Abhinav Kumar

Abhinav Kumar

Software Engineer

Followers of Abhinav Kumar720 followers
location of Abhinav KumarBengaluru, Karnataka, India

Connect with Abhinav Kumar to Send Message

Connect

Connect with Abhinav Kumar to Send Message

Connect
  • Timeline

  • About me

    PowerBI | MicroStrategy | PL/SQL |

  • Education

    • Tagore Public School

      1991 - 2006
      Bachelor of Engineering (B.E.) PCM & Computer

      Completed my 10th from CBSE boardCompleted my 12th from CBSE board

    • UNITED INSTITUTE OF TECHNOLOGY, ALLAHABAD

      2007 - 2011
      Bachelor's degree Computer Engineering

      Activities and Societies: BASKETBALL TEAM Completed my Bachelor of technology degree in Computer Science branch

  • 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

  • Licenses & Certifications

    • 10.142: Dashboarding & Visualizations

      MicroStrategy
      Oct 2018
    • 10.142_Dashboarding & Visualizations (2018)

      MicroStrategy
      Oct 2018
  • Honors & Awards

    • Awarded to Abhinav Kumar
      Inspiring Performance Muthulakshmi Ravishankar Aug 2021 - Got an Award - "Inspiring Performer'. - Handled multiple technologies like MicroStrategy, PowerBI, QlikView etc. successfully. Self-learned various required technologies and started to contribute to the team. - Took the responsibility from the reporting team front during DR activities. - Took the responsibility of my team. Feedbacks and discussion to keep the learning and productivity goes hand in hand.