About Me
Certified Data analyst with 5+ years of Experience and strong background in data manipulation and reporting, Dashboarding Skills. Proficient in SQL, Adv Excel, Power Query, and Python, Pandas, Numpy, Matplotlib, ETL, Pow…
Certified Data analyst with 5+ years of Experience and strong background in data manipulation and reporting, Dashboarding Skills. Proficient in SQL, Adv Excel, Power Query, and Python, Pandas, Numpy, Matplotlib, ETL, Power BI ,adept at creating dashboards and visualizations to present key findings. Motivated to leverage data-driven insights to optimize processes and enhance decision-making.
Experience
Data Analyst
Collected and organized large data sets from various sources like Super Punch, SAP, NICE, Excel.
• Performed data preprocessing and transformation to ensure data accuracy and consistency using Power Query.
• Identified patterns and trends in data to inform business decisions.
• Performed Data Audit , Report Discrepencies and Timely Resolve Issues.
• Automated Reports using SAP Business Intelligence, Power Query.
• Building,Maintaining reports and dashboards that provide key performance indicators (KPIs) for different operational areas.
• Present findings to stakeholders through clear and concise reports, visualizations, and presentations.
• Interacting with Clients and Working closely on Analytics Requirements and Improvements.
• Worked closely with cross-functional teams to understand business objectives and data requirements
Data Analyst
Collected and organized large data sets from various sources like Super Punch, SAP, NICE, Excel.
Performed data preprocessing and transformation to ensure data accuracy and consistency using Power Query.
Identified patterns and trends in data to inform business decisions.
Performed Data Audit, Report Discrepencies and Timely Resolve Issues.
Automated Reports using SAP Business Intelligence, Power Query.
Building,Maintaining reports and dashboards that provide key performance indicators (KPIs) for different operational areas.
Present findings to stakeholders through clear and concise reports, visualizations, and presentations.
Interacting with Clients and Working closely on Analytics Requirements and Improvements.
Worked closely with cross-functional teams to understand business objectives and data requirements.
Investigate and Deep Dive to Resolve Data Quality issues.
Data Analytics - Technical Engineer
Accomplished database development tasks like developing tables, CTE, Views, Scripted SQL queries for retrieving data from multiple tables.
Developed tables with required fields for Key Performance Indicators (KPI) reporting, which saved time spent on data extraction and cleaning of huge datasets around 1.5M rows.
Conducted data mining and accomplished ETL, to transform data in power BI query editor using various DAX measures, calculated columns and developed efficient star schema data models, by collecting data from different data sources like SQL server, Excel, Datawarehouse.
Evaluation and analysis of data by detecting, removing anomalies which prevented assumption of false insights.
Junior Data Analyst
Worked on Sales projects, creating dashboards which highlights trends in sales, profit-loss metrics, across regions and find out touch points.
Building Monthly, Quarterly, yearly reports and Monitoring KPI, ETL data from various sources, Data Mining, Data validation.
Evaluation and analysis of data by detecting, removing anomalies which prevented assumption of false insights.
Developed monthly Power BI reports and dashboards with KPI trends and which resulted in 40% increase towards sales target and customers count.