Abhinav Kumar

Experience

• 

  Theorem

  Jul 2012 - Sept 2014

  Software Engineer

  Comprehensive database management and migration from SQL to Oracle.

• 

  Capgemini

  Oct 2014 - Feb 2017

  Analytics Consultant

  RefreshmentExecuted tasks using MicroStrategy Developer, Web, and Object Manager.Designed and implemented Application & Schema Objects in MicroStrategy.Fixed report metrics and facts through backend SQL.Validated price comparisons and provided historical data for forecasting and budgeting.Managed monthly, weekly, and ad-hoc maintenance.Handled invoice approvals and report filter checks.

• 

  Microland Limited

  Feb 2017 - Jul 2018

  Data Analyst

  Insurance Led client migration to MicroStrategy and served as the SPOC for the development team.Modified unit and integration tests to improve error detection.Managed yearly, monthly, and ad-hoc maintenance tasks.Designed and executed Application & Schema Objects in MicroStrategy Developer.Debugged backend SQL to correct report metrics and facts.Utilized MicroStrategy Developer, Web, and Object Manager for key tasks.

• 

  Wipro Limited

  Aug 2018 - Dec 2021

  Senior Project Engineer

  Retail & Manufacturing Managed SNOW tasks (Incidents, Requests, Changes, Problems) and gathered requirements from BU SPOCs for dashboard development.Improved Power BI performance by optimizing DAX, refining data models, and enhancing refresh times for real-time analytics.Led scrum meetings to track development progress and collaborated with backend teams for optimal table structure.Delivered dashboard enhancements and data updates.Recognized as Star Performer of the Year (2020-21). Show less

• 

  CGI

  Dec 2021 - now

  Senior Architect

  Power & EnergyPartner with business stakeholders to identify their needs and translate them into technical solutions.Developed 37 advanced Power BI dashboards from scratch, tailored for executive-level decision-making.Completed the ETL framework for nearly 70 tables using SSIS, integrating it into interactive Power BI dashboards.Delivered custom reports, enabling stakeholders to make informed business decisions.Mentored junior team members to boost productivity and ensure timely project delivery.Led the migration of key systems and reports.Implemented row-level security (RLS) and data governance in Power BI to safeguard data and maintain compliance.Deployed Incremental Refresh for Power BI reports across all environments.Core contributor to automating report refresh schedules and delivery, streamlining processes for end-users.Achieved a 10/10 Customer Satisfaction Rating and won the "Best Team of the Year" award.Retail StoresLed the migration of reports from legacy tools to Power BI, driving modernization efforts.Engaged in Agile practices, maintaining daily communication with stakeholders to ensure alignment with requirements and ongoing feedback.Acted as the offshore SPOC, identifying challenges and delivering optimized solutions for Power BI dashboards.Managed and mentored a team of 5, providing guidance on business operations and technical solutions to enhance delivery outcomes.Developed optimized data models with complex calculations to support advanced reporting.Improved Power BI report performance by optimizing DAX queries, data models, and refresh times for real-time analytics.Enforced row-level security (RLS) and data governance in Power BI to ensure data security and compliance.Automated report refresh schedules and delivery, streamlining processes for business users.Trained junior developers and conducted Power BI sessions for end-users to enhance BI capabilities across the organization. Show less