Abhijeet Kumar PowerBI, SQL Server, SSIS, SSRS, SSAS and Excel,
No reviews yet

- Senior BI Analyst at Shubham Housing Finance Company, adept at monthly report generation for stakeholders, with a proven track record of delivering high-quality reports within tight deadlines.
- Successfully migrated existing Excel reports to Power BI and Excel Power Pivot using the "Analyze in Excel" capability. Designed user experience dashboards using VBA for enhanced interactivity and intuitive data exploration.
- Additionally, responsible for preparing and analyzing a diverse range of reports, including Portfolio Quality Report (PQR), PQR Base file preparation, Collection Efficiency, Closer and Retention, Principal Waiver, Branch Performance Metrics, KRI-data Collection, KRI-Report Preparation, HR Employee Master, RO Productivity, Underwriter Performance, and Data Sanity Check.
- Utilized advanced BI tools and techniques to ensure accurate data analysis and insightful reporting.
- Collaborate with cross-functional teams to gather requirements, extracts data from various sources, and maintains data integrity and quality assurance throughout the reporting process.
- Provide actionable insights and recommendations based on report findings, while continually staying updated with industry trends and best practices in BI reporting to enhance reporting capabilities.
- Proactively streamline report generation processes to improve efficiency and timeliness.

Capgemini Invent: PowerBI Developer
Project: Kimberley-Clark – HMP Support (March 23 - June 23)
====================================================================
- Power BI Developer for the Holistic Measurement Support project under Capgemini Invent
- Imported data from Google Big Query and Azure DevOps using Import connection modes.
- Created a Power BI dashboard from Azure DevOps for work story analysis.
- Actively managed stories in Azure DevOps, collaborating with stakeholders for timely closure.
- Enhanced measurement and reporting capabilities for deeper insights and strategic decision-making

Project: Olam – Data Migration (June 22 - March 23)
====================================================================
- Responsible for data migration from Azure MySQL to Azure PostgreSQL in the Olam project
- Used DBConvert for MSSQL & PostgreSQL tool for seamless data migration.
- Utilized DBSync for MSSQL & PostgreSQL tool for data synchronization between databases.
- Conducted data and schema comparisons using the DiffDog tool for data accuracy and consistency.
- Ensured successful data migration and maintained data integrity throughout the process.

Capgemini Invent: PowerBI Developer (May 22 - March 23)
Projects: Olam - Survey Analysis
====================================================================
- Played a key role in requirement gathering and creating technical documentation for the Olam project.
- Imported data 100 million records (60 GB Data in Size) from Azure SQL and Azure Synapse using Import connection modes for smooth data integration.
- Created partition based on question id’s in SSMS.
- Utilized Azure Analysis Services and deployed the solution using Azure Data Factory for efficient data refresh.
- Created 4500 DAX measures in Azure Analysis Services and organised under display folders.
- Employed Power Query, Power Pivot, and Power View for data analysis and creating visually compelling reports and interactive dashboards.
- Created Power BI dashboard having Personalize Visuals feature allowing users to make changes to dashboard visuals as per their need.

Capgemini Invent: PowerBI Developer (Jan 22 - April 22)
Projects: Olam - Incident Management
====================================================================
- Leveraged the capabilities of SSIS packages to facilitate the weekly loading of Excel data into SQL Server for Incident Management project, ensuring a timely and efficient data integration process.
- Utilized the Direct Query connection mode to import and harness data directly from SQL Server, enhancing the project's responsiveness and data retrieval speed.
- Creation of 9 comprehensive dashboards, implementing Row-level security features to safeguard sensitive information and ensure data integrity across the Incident Management project.
- Demonstrated mastery in data analysis by harnessing the dynamic trio of Power Query, Power Pivot, and Power View. These powerful tools were instrumental in transforming raw data into insightful narratives, enabling the creation of visually striking reports and interactive dashboards.

This approach not only elevated the project's analytical capabilities but also provided stakeholders with a user-friendly and visually engaging experience, fostering better decision-making processes.

Capgemini Invent: Resource Management (Apr 19 - Jan 22)
====================================================================
- Successfully partnered with stakeholders and competency leaders to effectively manage Capgemini Invent resources.
- Demonstrated strong understanding of resource skills and ensured their deployment on suitable projects.
- Responsible for tracking resources, managing assignments, and planning for future assignments.
- Actively contributed to demand creation and timely fulfilment of resource demands
- Collaborated with the recruitment team to bridge the gap between business needs and the recruitment/vendor process.
- Proactively managed the bench to reduce bench strength and optimize resource utilization.
- Published essential data and reports such as Bench Report, Bench forecast, headcount forecast, and N-1 fulfilment report.
- Automated Weekly/Monthly reports using Power BI, Excel, SharePoint.
- Managed resources and project data, maintained trackers, and provided required data upon stakeholder requests.
- Oversaw R2D2 cleanup and loading management processes.
- Prioritized adherence to RMG process and organizational policies and procedures
- Actively engaged in self-development to expand knowledge of RMG concepts.
- Effectively managed a team of five, providing guidance, support, and fostering their professional growth.
- Worked towards achieving the goals of the Resource Management Group and delivering high-quality results.

Annik Technology: Project: Employee Engagement, Client: PricewaterhouseCoopers
Market Research (March-16 to Apr-19)
====================================================================
- Data management & preparation, useful for creation of PPT’s and Excel report using tools such as SPSS & quantum.
- Collect/Organize/Prepare/Manage data for the analysis and conduct quality checks.
- Data stacking and restructuring.
- Generating reports such as Engagement index, DDHM (Demographic heat map), Correlation scatter plot, Employee Landscape.
- Report generation based on tab-spec (Given Excel & PPT template).
- Data validation on provided dataset as per questionnaire logic.
- Share the findings of the data with client such as outlier and anomalies within data.

Annik Technology: Project: HR Benchmarking, Client: PricewaterhouseCoopers
Market Research (Sep-14 to Feb-16)
====================================================================
- Creating Metrics that can answer the questions about workforce of the future.
- Metrics covers industry sectors with over 300 metrics relating to workforce productivity, span of control, succession, recruiting costs, hire quality, labour costs, turnover, diversity, HR cost, and org structures.
- Share the findings of the data such as outlier and anomalies within data.
- Managing PwC clients and helping them in data submission, subscription renewals, reports access etc.

IndiGo: InterGlobe Aviation – Grievance Consultant/ MIS (May-11 to Sep-14)
====================================================================
- Possess knowledge of airline travel reservations software Navitaire, making reservations, payments tracking, additional services etc.
- Dealing directly with customer’s grievance for payment issues.
- Organize workflow to meet customer timeframes.
- Direct requests and unresolved issues to the designated resource.
- Update records of customer interactions and transactions in CRM and Navitaire new skies.
- Categorize interactions records to inquiries, feedback, and complaints.
- Maintain customer database related to compensation and benefits.
- Communicate and coordinate with internal departments.
- Making MIS reports for various departments through CRM and Navitaire.