Data Engineer Analysis

Sanjeev V Gaikwad

Missouri, US ad5yg6@r.postjobfree.com 913-***-****

https://www.linkedin.com/in/sanjeev-v-gaikwad-88618b228/ Education

University Of Central Missouri Warrensburg

MS Computer Science Aug 2022 - May 2024

Profile Summary

Detail-oriented Data Engineer with expertise in database administration, ETL, and big data technologies. Proficient in relational database management, data pipeline implementation, and BI development. Skilled in Python and Apache Spark for efficient data processing. Experienced in data analysis proficient in SQL, Python, and Excel, with a track record of improving data retrieval efficiency by 25%. Proven ability in developing data models, automating reports, and creating interactive Tableau dashboards for enhanced visualization and decision-making.

Work Experience

Sodexo Warrensburg, MO, USA

Student Worker Sept 2022 - April 2024

• Managed a team of 10 individuals to organize and maintain food services for approximately 500 students and staff of UCM daily.

• Ensured accurate recording of food item temperatures at 5 stations at regular intervals, maintaining optimal temperatures for food quality while facilitating data analysis.

• Created temperature sheets, analyzed food temperature behavior using Excel, Power BI, and statistical tools to draw insights on food behavior in varied temperature and weather conditions.

• Utilized Weka and RapidMiner for customer segmentation, employing various clustering algorithms, user-friendly interfaces, and automation capabilities to derive actionable insights for targeted marketing strategies.

• Leveraged Tableau and Power BI for supply chain optimization, providing insightful data visualizations that facilitate decision-making, identify inefficiencies, and enhance overall operational performance.

• Used Minitab, JMP for food safety, monitoring control points, identifying trends, and ensuring compliance with regulations while maintaining product quality standards.

• Utilized SurveyMonkey, Google Forms for customer feedback analysis, and Hootsuite, Sprout Social for social media listening, gathering insights and managing customer feedback across diverse channels effectively.

Sysark Datasol Pvt. Ltd Hyderabad

Software Engineer April 2018 - May 2022

• Developed and maintained relational databases, ensuring optimal performance and security.

• Implemented ETL pipelines using Bash, Airflow, and Kafka to extract, transform, and load data from various sources.

• Utilized NoSQL and Big Data technologies like MongoDB, Hadoop, and Spark for large-scale data processing and analytics.

• Drove a 25% reduction in ETL processing time and overhead through the design and implementation of cloud-based data pipelines in Talend and BigQuery.

• Developed, tested and debugged several ETL pipelines that resulted in increased loading yields by 10%. Optimized data warehouse solutions for efficient data consolidation, reducing processing time by 80%.

• Led a design review and code process that improved the operational efficiency of internal data sets by 35%. Designed data models for a 3rd-party analytics engine, increasing accuracy and scalability.

• Collaborate with stakeholders to understand business objectives and requirements, while analyzing data to identify trends, patterns, and insights relevant to business goals (50% stakeholder collaboration, 50% data analysis).

• Worked with a client to understand business needs and translate those needs into actionable reports in Tableau, saving manual hours.

• Developed and implemented data pipelines to improve data quality, resulting in a 30% increase in data accuracy.

• User Enhanced quality of data insights through implementation of automated data validation processes and improved access to data sources.

• Reduced migration costs of large data sets across multiple cloud providers by 50%.

• Analyzed source data to identify data quality issues and developed strategies to address them, resulting in a 30% reduction in data errors and inconsistencies.

• Developed and maintained data models to support data warehouse and reporting requirements, resulting in a 20% improvement in data accessibility and usability.

• Conduct thorough analysis of business processes and workflows, recommending improvements and optimizations, while monitoring industry trends to inform strategic decision-making (70% analysis, 30% trend monitoring).

Swashtech Software Paradigm Pune

Associate Software Engineer (Data Analyst) July 2015 - March 2018

• Proficient in data analysis, cleansing, visualization, and presentation.

• Utilized SQL, Python, Excel, Power BI, and other tools to extract, manipulate, and analyze datasets, ensuring data accuracy and relevance.

• Knowledgeable in data collection, aggregation, and integrity practices, and implemented SQL databases, resulting in a 25% reduction in data retrieval time.

• Built data models and maps to generate meaningful insights from customer data, thereby boosting successful sales efforts by 20%

• Used Python and R to automate 20+ weekly data reports, saving roughly 10 hours per week.

• Developed interactive Tableau dashboards for 20+ clients, enhancing data visualization and analysis capabilities by 50%.

• Ability to determine sample sizes for data analysis and make informed decisions based on analytical insights.

• Effective problem-solving skills with a proactive approach to questioning and decision-making.

• Developed, interpreted, and monitored moderate-to-complex health care analyses, data projections, and reports to support system management decision-making.

• Identified procedural areas of improvement through customer data using SQL, resulting in a 25% increase in profitability.

• Proficient in Microsoft Excel, Created custom reports and dashboards to present data, enabling senior management to make data-driven decisions, resulting in an increase in revenue.

• Effective communication, positive stakeholder interaction, detail-oriented for accuracy, adaptable team player, managing changing priorities and deadlines autonomously. Skills

1): Python, ETL & Data Pipelines, NoSQL and Big Data, Apache Spark. 2): Metadata, SQL, R Programming, Tableau Software, Data Integrity, Excel 3): Data Analysis, Creating case studies, Data Visualization, Data Cleansing, Data Collection 4): Statistical Analysis, Regression Models, Exploratory Data Analysis (EDA) 5): Extraction, Transformation And Loading (ETL), Bigquery, Dashboarding and Reporting, Sheets

Contact this candidate