Prashil Ramteke Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

· Analyzed problem statements and requirements for data analysis projects.· Conducted data discovery to identify relevant datasets and sources.· Gathered data from multiple sources including databases,and files.· Performed data modeling to structure and organize datasets for analysis.· Applied data profiling techniques and data mapping to ensure data integrity.· Performed analysis using Excel functions and complex SQL queries including window functions.· Cleaned and transformed data using Tableau,excel and python.· Developed interactive dashboards and visualizations using Tableau.· Published dashboards to higher environments using Tableau Server for stakeholder access.· Created insightful reports and presentations for business intelligence purposes.· Proficient in MS SQL for data extraction, manipulation, and EDA.· Experienced in Python libraries such as NumPy, Pandas, Matplotlib, and Seaborn for data analysis.· Skilled in pivot tables, VLOOKUP, HLOOKUP, and other Excel functions for data manipulation.· Demonstrated expertise in data visualization and storytelling to convey actionable insights from data.

Maharashtra, India

· Discussing requirements with source teams and end users for ELT processes.· Handling high-volume datasets from Salesforce, Oracle, flat files, and views.· Conducting thorough data analysis and utilizing SQL queries for data modeling and analysis.· Designing mappings for data sources to operational staging targets.· Loading data using various transformations (Source Qualifier, Joiner, etc.) and SQL development.· Performing rigorous testing and ensuring data quality for successful data loading.· Managing seamless migration from development to UAT and production environments.· Proficient in MySQL, Oracle, Teradata, AWS Redshift, PostgreSQL, and Linux/Unix shell scripting.· Skilled in data validation, mapping, ingestion, and warehouse management.· Experience with complex SQL queries, Unix scripting, OA/Tidal scheduling tool, data profiling and data management.