Manish Pandey

Crossing Republick, Ghaziabad UP- *01014

ad4wkm@r.postjobfree.com

linkedin.com/in/manish8802

Summary

+91-880*******

Results-driven Data Analyst with over 7 years of experience in data analysis, modeling, and database management. Proficient in SQL for querying and analyzing datasets, with a focus on extracting meaningful insights. Skilled in utilizing data technologies such as Excel, and proficient in statistical analysis techniques. Experienced in data visualization tools like Tableau and Power BI, adept at creating compelling visualizations to communicate findings effectively. Possesses a strong foundation in Python and R programming for data analysis tasks. Known for collaborative problem-solving and meticulous attention to detail, facilitating evidence-based decision-making.

Experience

Data Analyst

xFusion - Operations as a Service (Knoema Corporation) June 2021 - August 2023 (2 years 3 months)

Managed end-to-end data processing workflows for various datasets, prioritizing accuracy and consistency.

Leveraged Excel for data manipulation and analysis, ensuring data integrity and presenting insights effectively.

Collaborated cross-functionally to develop and execute data collection strategies, streamlining data acquisition processes.

Conducted thorough dataset analysis to identify trends, patterns, and anomalies, facilitating informed decision- making.

Implemented automated data validation techniques, ensuring high-quality, error-free data. Projects

McKinsey Shape - Healthcare Database for Germany o Developed a healthcare database for Germany Using VBA & MS excel. o Processed and cleaned over 100TB of data from a variety of sources, including hospitals, clinics, and insurance companies.

o Built a data warehouse that supports complex queries and analytics.

Automation of Economical Data Retrieval

o Developed a robust pipeline to automate the retrieval and transformation of economic data, including GDP and other critical indicators, from diverse government sources such as IMF, OECD, and others. o Implemented data automation techniques that significantly reduced the time required for data acquisition and transformation, improving efficiency from weeks to just days. Subject Matter Expert- Database Management

Chegg India-(Part Time)

September 2020 - March 2023 (2 years 7 months)

Mentored students in ETL best practices, emphasizing the importance of data accuracy and transformation efficiency.

Designed and implemented ETL pipelines, integrating various data sources for comprehensive analysis.

Leveraged Snowflake's features for building data marts, enabling faster and more accurate business intelligence. Assistant Manager- Business Data Analyst

Yuhai Technology Corporation

Mar 2020 - Aug 2020 (6 months)

Developed ETL solutions for complex datasets, ensuring data consistency and accuracy.

Implemented DBT models for transforming raw data into actionable insights, facilitating strategic decision-making.

Administered Snowflake databases, optimizing storage and query performance for large-scale data analytics. Senior Associate

Dataflow Group

Dec 2014 - Dec 2019 (5 years 1 month)

Data engineering skills: Database management.

Client communication: Ability to understand and document business objectives, communicate effectively with clients

Microsoft Office proficiency: Excel, PowerPoint, VBA Education

McGill University

Diploma of Education, Diploma (Dip.) Management: General 2020 – 2021 (Attended 1St Semester and drop due to Covid19 Crisis) Maharaja Surajmal Institute

Bachelor of Business Administration - BBA, Business Administration and Management, General

2011 - 2014

Licenses & Certifications

Microsoft Excel Master Class - Future in Hands

Microsoft VBA Master Class - Future in Hands

Foundations: Data, Data, Everywhere - Google

Skills

Data engineering skills: Data ingestion, data extraction, data transformation.

Data science skills: data science libraries (scikit-learn, pandas, matplotlib, Jupyter), machine learning algorithms

Communication skills: cross-functional collaboration, problem-solving, written and verbal communication Data Analyst Excel SQL Dataset Analysis Data Quality Statistical Analysis Power BI AI Enthusiast

Contact this candidate