Sql, Power Bi Developer
Resume:
Pradnya Khobragade
Business Analyst/Data Analyst
Bopodi, Pune
**********@*****.***
Summary
● Analytical and results-driven Data Analyst with over 3 years of experience in solving business problems through data-driven insights and automation.
● Skilled in SQL, Python, Excel, and Power BI with hands-on experience in ETL processes, dashboard development, and statistical analysis.
● Adept at handling large, complex datasets, identifying key metrics, conducting root cause analyses, and enabling business decision-making through compelling data stories.
● Known for structured thinking, a detail-oriented approach, and cross-functional collaboration.
Technical Skills
● Programming Languages:
Advanced Excel (Power Query, Pivot tables), Python (Pandas, Numpy), MySQL (Structured Query Language), VBA, DAX.
● Data Visualization:
Power BI, Matplotlib.
● Data Manipulation and Analysis:
Data cleaning and preprocessing, Data transformation, Data Mining, Data Manipulation, Data/Business Analytics, Data Science, ETL.
● Soft Skill:
Excellent Verbal and Written Communication skills, Presentation, and Storytelling. Professional Experience:
Anviktech Enterprises LLP– Associate Data Analyst
May 2022 – Present
● Built and maintained automated Power BI dashboards to monitor key performance metrics across sales and operations.
● Conducted root cause analysis and trend monitoring using SQL and Python to support business reviews and performance evaluations.
● Collaborated with business, product, and data engineering teams to scope data instrumentation and improve data accuracy.
● Designed self-serve reporting solutions using Power BI and Power Query, reducing manual data processing efforts by 70%.
● Implemented data validation frameworks and built custom DAX measures to enable real- time business insights.
● Worked on KPI development, variance analysis, and data storytelling aligned with organizational goals.
Ai Variant Technologies – Data Science & Analyst
April 2021 – April 2022
Data Analyst
● Contributed to a software and hardware installation, maintenance, and renewal project by developing analytical reports and managing quotes, opportunities, and cases.
● Designed and implemented a comprehensive sales and delivery dashboard using advanced Excel functionalities, including formulas, Pivot tables/charts, and data validation, ensuring accurate and insightful data representation.
● Generated detailed analytical reports on warranty costs, utilizing VBA and SQL to analyse various parameters such as product types, part numbers, warranty timelines, and customer locations.
● Automated complex reporting processes and recurring tasks through the use of VBA and Macros, significantly enhancing efficiency and accuracy in data handling.
● Analyzed and developed programs to decode warranty serial numbers, providing critical insights into product failure timelines and upcoming renewal dates for clients.
● Collaborated closely with management across operations, finance, and HR to gather requirements and ensure comprehensive data compilation aligned with organizational goals. Data Science
● Building predictive and decision models using machine learning algorithms for various business study cases with optimizations and evaluation techniques.
● Analyzed large and imbalanced datasets by performing machine learning techniques to provide data insights, optimistic solutions, and strategic directions for making data-driven decisions.
● Developed customized scripts for scraping the data from multiple websites.
● Worked with text data with text mining techniques including EDA text extraction, data cleaning, pattern identification, Feature Engineering, and named-entity recognition.
● End-to-end deployment of Machine Learning, Deep Learning, and Natural Language Processing solutions on web-based frameworks like Heroku and Streamlit. Education
Department of Science, Rashtrapita Mahatma Gandhi Arts & Science College, Nagbhir - B.Sc. in Maths In 2016.
Awards & Certification:
● “Data Visualization” certificate by IBM.
● “Machine Learning with Python” Certificate by IBM.
● “Data Science Course Completion” Certificate by ExcelR.
● “Data Analyst Course Completion” Certificate by ExcelR.
Contact this candidate