Oct 2018 – Present · 7 yrs 7 mos

• Consultant at Capgemini Invent

Oct 2018 – Dec 2022 · 4 yrs 2 mos

• PROJECT : Revenue Allocation Service Desk (RASD) Solutions UAT
• I am working as a Associate Consultant at Capgemini for Client MICROSOFT at Gurugram in Solutions UAT Team.
• Roles and Responsibilities :
• Writing SQL scripts to analyze data and perform specific data queries.
• Well versed in SQL to write Queries, Joins, Filtering Data, Importing & Exporting.
• Performing analytics right from Data Cleaning, Data Validation, Data Analysis and Data Processing.
• Creating Power BI dashboards on premise after Data Validation for the Microsoft Team for visualization of the data.
• Providing a detailed insight to client by providing visualization and detailed statistical analysis using Power BI.
• Experienced in Row Level Security (RLS) at Database and Power BI end.
• Experienced in DAX Calculations, Power Query, Power Pivot, Excel.
• Experienced in creating Calculated Columns, Measures, Relationships, Modelling, Report Publishing.
• Possess knowledge of Star Schema and Snow Flake Schema of Power BI.
• Experienced in Drill Down, Drill Through, Bookmarks, Merge Queries, Append Queries functions of Power BI.
• Good understanding of Power BI Services and Power BI Desktop.
• Experienced in importing data from various sources to Power BI like MS SQL Server (Direct Query), MS Excel, Azure.
• Designing and Finalizing BI solutions in close coordination with clients.
• Analyzing large volumes of data to allow users to investigate trends, predict outcomes and discover insights.
• Integrating data from multiple sets into one database system to streamline information.
• Performing Root Cause Analysis on an issue in a large production Environment.
• Experience accessing, compiling and analyzing large volumes of transactional data into actionable information.
• Interacting extensively with Stakeholders on requirement gathering, analysis and documentation.
• Examine the unique needs and concerns of business to develop relevant reports and procedures.

Apr 2018 – Sep 2018 · 5 mos

• Roles and Responsibilities :
• Responsible for People Management and Service Delivery with clients and accountable for overall smooth functioning of operations.
• Establishing work procedures and processes that support clients and standards, procedures, and strategic directives.
• Ensuring team SLAs are delivered, Review Team Performance on process metrics.
• Managing talent through coordinating and facilitating training and identifying development needs.
• Providing statistical and performance feedback and coaching, and administered performance reviews for skill improvement.
• Partnering with Human Resources with screening, interviewing, scheduling, hiring candidates and terminations.
• Working closely with the senior management team, reviewing potential issues affecting aging tickets, new hires, and terminations.
• Building partnership and working collaboratively with internal resources and clients.
• Developing processes, with cross-functional teams, to deliver with improved efficiency and effectiveness.
• Serving as point-of-contact for escalation of all issues related to data variation as well as for special requests.
• Actively practice and support company operating policies and procedures.
• Providing daily, weekly and monthly reports to the team and leadership about the team's performance on various metrics.
• Strong Knowledge on Power BI to import data from sources such as SQL Server,MS Excel etc. to generate reports.
• Exploring data in a variety of ways and across multiple visualizations using Power BI.
• WIND, O365, EMS, Filter Power BI Reports (Graphical Representations used by MSFT to track Usage)
• Cubes (SSMS)
• DUIT
• OEM Heatmap
• WIND Security
• Piracy Dashboard
• OEM Access
• Investigation:
• Writing SQL Queries to investigate Business Group, SubRegions and Destination Cube in WIND Database containing Microsoft data , Browsing Cubes to get overall data.