About
Results-driven Data Analyst with over 4 years of experience in SQL Server, Power BI, IBM Cognos Analytics, and ETL. Skilled in data extraction, transformation, and reporting, with expertise in designing interactive dashboards and data models to support business decision-making. Adept at writing complex SQL queries. Experienced in both recurring and ad hoc analysis, as well as business intelligence.
Skills & Expertise (8)
Work Experience
Data Analyst
Accenture
08-2023 - Present
Built an interactive Power BI dashboard with KPI Cards, Line Charts, Clustered Column Charts, Tooltips, and Drill-throughs. Developed a Driver Performance Dashboard to analyze fuel efficiency, maintenance costs, trip count, and cost per KM using DAX measures and calculated columns. Implemented a Revenue Insights Dashboard featuring geospatial analytics (Map Visuals), customer segmentation, and sales trends across different regions and time periods. Optimized Data Modelling by establishing Star Schema relationships in Power BI, reducing redundancy and improving report performance. Leveraged advanced DAX functions to derive meaningful insights. Integrated real-time filtering with slicers and dynamic measure selection to enhance interactivity and improve user experience. Conducted customer behaviour analysis, leading to the implementation of loyalty programs and targeted marketing campaigns. Used Power Query for data transformation cleaned, merged, and reshaped large datasets from multiple sources, ensuring accurate and efficient reporting. Optimized report performance by using aggregations, measure tables, and Direct Query for large datasets, ensuring seamless user experience. Collaborated with stakeholders to align business goals with data insights, leading to improved fleet utilization, reduced fuel costs, and increased revenue through strategic customer engagement.
Data Analyst
Accenture
08-2023 - Present
Built an interactive Power BI dashboard with KPI Cards, Line Charts, Clustered Column Charts, Tooltips, and Drill-throughs. Developed a Driver Performance Dashboard to analyze fuel efficiency, maintenance costs, trip count, and cost per KM using DAX measures and calculated columns. Implemented a Revenue Insights Dashboard featuring geospatial analytics (Map Visuals), customer segmentation, and sales trends across different regions and time periods. Optimized Data Modelling by establishing Star Schema relationships in Power BI, reducing redundancy and improving report performance. Leveraged advanced DAX functions to derive meaningful insights. Integrated real-time filtering with slicers and dynamic measure selection to enhance interactivity and improve user experience. Conducted customer behaviour analysis, leading to the implementation of loyalty programs and targeted marketing campaigns. Used Power Query for data transformation cleaned, merged, and reshaped large datasets from multiple sources, ensuring accurate and efficient reporting. Optimized report performance by using aggregations, measure tables, and Direct Query for large datasets, ensuring seamless user experience. Collaborated with stakeholders to align business goals with data insights, leading to improved fleet utilization, reduced fuel costs, and increased revenue through strategic customer engagement.
Data Analyst
Accenture
01-2022 - Present
Designed, developed, and maintained reports using IBM Cognos Analytics and SQL Server to support business decision-making. Performed data extraction, transformation, and loading (ETL) tasks using IBM Cognos Data Manager and to ensure data integrity and consistency. Collaborated with cross-functional teams to gather reporting requirements and deliver insights that drive strategic business initiatives. Debugged complex Stored Procedures to analyze data. Utilized Joins, CTEs, Window Functions, Aggregate functions, Sub Queries to extract data insights. Designed ad hoc queries to provide on-demand insights for business users. Ensured data accuracy by performing data validation, cleansing, and reconciliation using SQL queries.
Data Analyst
Accenture
01-2022 - Present
Designed, developed, and maintained reports using IBM Cognos Analytics and SQL Server to support business decision-making. Performed data extraction, transformation, and loading (ETL) tasks using IBM Cognos Data Manager and to ensure data integrity and consistency. Collaborated with cross-functional teams to gather reporting requirements and deliver insights that drive strategic business initiatives. Debugged complex Stored Procedures to analyze data. Utilized Joins, CTEs, Window Functions, Aggregate functions, Sub Queries to extract data insights. Designed ad hoc queries to provide on-demand insights for business users. Ensured data accuracy by performing data validation, cleansing, and reconciliation using SQL queries.
Education
Bachelor of Engineering
2017 - 2021 · India
Bachelor of Engineering
2017 - 2021 · India
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Current Company
Other
Visa Status
No Visa
Relocation
Open to Relocation
