Lead Analytics Consultant - Wells Fargo - Bangalore, KA
(2024-06)
- Consolidated 15+ Tableau dashboards into a single Power BI scorecard, improving reporting efficiency.
- Automated refresh schedules using Power Automate; built PowerApps forms to enhance workflows.
- Enhanced user experience through drill-through personalized fields and one-click data export functionality.
- Implemented row-level security and optimized DAX queries for compliance and performance.
- Prepared semantic models using Copilot Studio for conversational insights via chat with dashboards.
- Conducted training sessions for over 30 new Power BI users, fostering self-service analytics.
- Delivered 10+ ad-hoc reports with 90% accuracy, decreasing turnaround time by 30%.
- Utilized Tabular Editor to fine-tune data models, enforce best practices, and streamline deployment.
Senior Business Intelligence Developer - Saama Technologies India Pvt Ltd. - Pune, MH
(2022-02 - 2024-05)
- Collaborated with US stakeholders to gather requirements and align solutions with business objectives.
- Delivered 10+ ad-hoc reports with 90% accuracy, reducing turnaround time by 30%.
- Migrated 15+ Tableau dashboards into consolidated Power BI reports, cutting maintenance overhead.
- Improved report refresh speed by 40% through incremental refresh and direct query optimization.
- Implemented Row-Level Security and optimized DAX queries for compliance and performance.
- Applied advanced DAX functions and variables to deliver customized insights.
- Developed complex DAX measures, calculated columns, and tables to support advanced analytics.
- Automated refresh schedules via Power Automate; built PowerApps forms to streamline workflows.
- Improved user experience with drill-through functionality, personalized fields, and one-click data export features.
- Designed advanced navigation and bookmarking features, increasing stakeholder adoption by 25%.
- Facilitated training sessions for 30+ new Power BI users, fostering self-service analytics capabilities.
- Managed multiple user stories in JIRA, consistently delivering within Agile sprints.
- Built composite models for large datasets, reducing query load times.
Module Lead - Sopra Steria - Noida, UP
(2020-12 - 2022-02)
- Developed centralized dataflows and dynamic parameters, facilitating report consistency and efficiency across multiple analyses.
- Applied advanced DAX functions and variables to deliver customized insights.
- Enhanced user experience through drill-through, bookmarks, and PowerApps integrations, improving accessibility and interaction with data.
- Built composite models for large datasets, streamlining query load times for improved reporting efficiency.
Senior Programmer - AbsolutData Research and Analytics (An Infogain Company) - Bangalore, IN
(2018-12 - 2020-12)
- Engineered optimized DAX calculations, cutting report load times by 40%.
- Created advanced data models and custom visuals, enhancing reporting insights for decision-making.
- Developed ETL frameworks with SQL Server, streamlining data extraction and transformation processes.
- Optimized stored procedures, boosting query performance and minimizing processing time.
- Transformed raw data using Power Query Editor, ensuring clean and reliable datasets.
- Designed interactive dashboards with overlapping visuals and bookmarks.
- Built Power BI dashboards with calculated measures and dimensions.
- Debugged and resolved reporting errors, ensuring accuracy and reliability.
Software Engineer - HCL technologies Ltd. - Noida, UP
(2016-09 - 2018-12)
- Optimized stored procedures to enhance query performance and minimize processing time.
- Developed ETL frameworks with SQL Server to streamline data extraction and transformation processes.
- Created Power BI dashboards with calculated measures and dimensions to provide actionable insights.
- Debugged and resolved reporting errors to enhance report accuracy and reliability.
