Data Analyst Analysis
Resume:
Manish Pandey
Crossing Republick, Ghaziabad UP- *01014
******************@*****.***
linkedin.com/in/manish8802
Summary
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