Arjun Soni Email & Phone Number

Atlanta, Ga, Us

Atlanta, Georgia, United States

As a Data Engineer with a comprehensive background in designing, developing, and implementing data pipelines and solutions, I am skilled in managing the full lifecycle of data engineering projects. My expertise includes everything from analysis and design to testing, implementation, and documentation, with a strong focus on integrating solutions within cloud environments. My focus is on creating robust data pipelines and integrating data across diverse systems to support business objectives and data governance.Proficient in analyzing, designing, developing, testing, implementing, and documenting solutions and pipelines for new data objects as requested by business and data governance teams.Created detailed Source to Target Mapping Documents to guide the development of ETL pipelines. Applied ETL techniques to extract, transform, and load data across various sources and platforms, including Snowflake and Google Cloud Platform (GCP).Extracted, analyzed, and reported data with a keen eye for detail, identifying relationships, trends, and anomalies. Managed data migration from legacy systems to GCP BigQuery, ensuring a smooth transition and enhanced data accessibility. Replicated large SQL solution scripts in cloud environments, optimizing data processes and performance.Conducted comprehensive data quality testing using Informatica Analyst, Informatica Developer.Led pod-level activities including solution design, sprint planning, and daily scrum meetings. Mentored junior developers, delegating tasks effectively and contributing to their professional growth. Worked closely with cross-functional teams to ensure seamless integration of data solutions into existing systems.Performed performance tuning on legacy data pipelines, resulting in a 38% reduction in storage costs and improved slot utilization. This optimization enhanced overall system efficiency and reduced operational expenses.

Atlanta, Georgia, United States

Data Engineer with a robust background in designing and managing data pipelines, performing data quality assessments, and implementing cloud data solutions. My experience spans across complex data migrations, statistical modeling, and interactive data visualization, making me adept at transforming raw data into strategic insights.Skilled in building and optimizing ETL pipelines to migrate and transform data using Python, R, SQL, and Informatica PowerCenter.Extensive experience with data migration from legacy systems to Google Cloud Platform (GCP) and Snowflake, leveraging Big Data tools and Google Analytics for advanced data analysis.Proficient in conducting data quality testing with Informatica Analyst, Informatica Developer, and Python to ensure data integrity and accuracy.Expertise in developing regression, correlation, and other statistical models to derive actionable insights from transactional and shipping data.Experience in building interactive dashboards and automated reports using Tableau and Google Analytics to support business decision-making.Conducting in-depth analysis using BigQuery on Google Cloud Platform to uncover valuable insights and drive strategy.Led the successful migration of data from legacy systems to Google Cloud Platform, ensuring a smooth transition and improved data accessibility.Developed a custom Python tool to identify and resolve data discrepancies between legacy and new databases, enhancing data accuracy.Analyzed and presented e-commerce data insights to stakeholders, driving strategic decisions and optimizing business processes.Spearheaded data quality initiatives, profiling tables and addressing issues to ensure the reliability of new cloud databases.

Dekalb County, Illinois, United States

Extract Transform and Load the Data from unstructured files to structured format and load it into Oracle Database.Build Desktop based application using Python and Tkinter.Write Scripts in python to automate some of the processes.Modeled Data to derive actionable insights for the Department.Performed SQL queries to retrieve Data.Understanding Business Requirements of the project.Creating Dashboards on Power-BI to presents the insight from the data to the key stakeholders.Tools Used: Python, Peoplesoft Database, Power-BI, MS Excel, Microsoft SQL Server.

Forest Park, Illinois, United States

Prepared forecasts and identified business trends in the data by the help of Data Analytics. Modelled the data to answer Business questions. Used Tableau to visualize and explain the Data and Insights from the analytics to the Stakeholders.Came up with process improvement suggestions for on boarding to help in attracting new clients for the Business. Also gave suggestions on how to improve client retention.Provided insights on effectively running marketing campaigns including direct mail, email, mobile and other digital channels like Instagram, Facebook etc.Identified business requirements and devised implementation strategies to solve business problems.Researched and gathered data related to the similar business. Preformed data wrangle and analyze the potential customers for the business. Gave suggestions on what areas to focus more.Worked on Agile project development environment. Tools Used: Python, SQL, Tableau, MS Excel, Agile.

Hyderabad Area, India

Analyzed large and Multi-Dimensional datasets by leveraging analytical methods like (Statistics, Math’s, Machine-learning etc.) Collected and Interpreted the Data to Analyze it and Identify the patterns and trends in the Data.Acquired Data from primary and secondary data sources and maintaining Databases. Perform Advanced SQL queries to extract the Data.Collaborated with Data Engineers and Software engineers to build pipelines.Worked along with both Business and Technical teams to understand the requirements.Used SQL Server Reporting Services to build reports and present it to the Managers of different departments.Modeled the Data by using Microsoft SQL Server Analysis Services to answer Business questions.Performed ETL using SQL Server Integration Services to extract data from source data, clean, and transform the data to Load it in SQL Server Management studio.Helped Sales and Marketing team to determine the Target crowd for the product and analyzed appropriate time for doing B2B and B2C activities so that the Sales and Marketing team could yield Maximum revenue.Created Visualization Dashboards to present the insights from the Data.Collected and analyze the information about the competitor’s data about the similar products and recommended Changes needed in the company’s product. Analyzed Big Data using Spark, Machine Learning algorithms while also working on both Structured and Unstructured Data.Assisted Stakeholders in making Data driven decisions.

Hyderabad Area, India

Collected data about the competitors’ products details while cleaning Raw Data and Performing SQL Queries.Performed ETL activities and loaded the Data into SQL Server Management Studio.

Hyderabad Area, India

Summer Training Program on CYBER Shopping Development based on the concepts of Core Java.Build a sample CYBER Shopping website as a part of internship training.

Master Of Science - Ms, Operation Management And Information Systems, 3.94 Gpa

Activities and Societies: Logistics Chair for NIU APICS ChapterSpecialization into Data Analytics and Business Intelligence. Key Courses.

Btech - Bachelor Of Technology, Computer Science