Mandeep Singh Rawat

With 10 + years of experience, Mandeep has Strong analytical, problem-solving & organizational abilities with a flexible & detail-oriented attitude. He is proficient in developing & streamlining audit analytics implementations with a proven ability to enhance operational effectiveness and meet operational goals within the cost, time & quality parameters. He has strong experience in working with different clients & Teams and liaising between technical and managerial levels. Proficient in tools such as Tableau, Power BI , DAX Query, Paginated Reports, SQL Server, Alteryx, R, JIRA, EXCEL, EDA, Data Dictionary, Portfolio Optimizer. Having extensive experience in Project planning, Client Management, People Management, Business Analytics.

• Oracle 10g Pl/SQL (PL/SQL Developer)
• RedHat Certified Engineer Linux 5.1 channel
• RedHat Certified Technician Linux 5.1 channel
• Tableau Desktop Qualified Associate
• Tableau Desktop Specialist
• Alteryx Sales Partner Certification, 2023
• IBM - Databases & SQL for Data Science with Python
• Certified Data Management Professional
• Data Governance with AXON and Enterprise Data Catalog (EDC)

• Father's Name: Mr. Yashpal Singh Rawat
• Date of Birth: 10/14/90
• Nationality: Indian
• Marital Status: Married

• Employee Expense Monitoring

Led a team to implement continuous monitoring of employee expenses to identify duplicate claims, claims with compliance conduct and other expense outliers and anomalies on a real-time basis using interactive user-friendly dashboards. Continuous Audit Strategy establishment and Analytics Integration, Worked closely with the client stakeholders of a well-known ITES organization to set up a continuous audit framework at the organization level to ensure real-time audit exception reporting and reduce manual interventions by around 45%. Development of Analytics solution for the Sponsor. Involve relevant stakeholders and consult with experts in the field to ensure a successful analytics integration implementation. Created a proposal and various standard requirement documents for the team. 

• Customer & Product 360 for one of the big Telecom Company of Saudi Arabia & Bahrain

Creating Project Plan and decide deadlines and deliverables, annual deadlines. connect with client stakeholders on finalization of scope and delivery schedule while working as a technical lead of various projects accomplished in the continuous audit space. 

• Business Glossary, Data Lineage & Data Dictionary for one of the largest banks of Saudi Arabia

Work closely with client stakeholders and create Business Glossary, Data Lineage & Data Dictionary. Engagement with business stakeholders to get input for Business Glossary. Working with the technical team on Data Lineage and Data Dictionary.

• Data Strategy & Data Governance for one of the Telecom Giant in India Leading the project as PMO

Define the scope of work and deliverables Gather business requirements. Conduct stakeholder interviews. Set project communication. Set team role expectations. Build team awareness of change considerations. Establish shared document repository. Finalize and deliver the Project.

• MDM Implementation program and strategy

Oversees the entire MDM program and strategy. Develops and communicates MDM policies and guidelines. Ensures alignment of MDM efforts with organizational goals. Ensures the quality and integrity of master data. Defines and enforces data governance policies. Manages MDM projects from initiation to completion. Develops project plans, timelines, and budgets. Coordinates with various stakeholders and team members.

• Target Data Architecture, RACI, Process Control, DG Operating Model and Tools & Technology Recommendation

Define the list of all conceptual data domains against these processes. Develop the conceptual model for data storage, mastership between applications, integration of data, and develop an understanding of CRUD lifecycle for critical data points. Develop the data architecture for data domains, capturing the storage requirements, reporting requirements, analytics requirements, data sharing requirements, and governance requirements. Capture all relevant roles at a conceptual level, across channels. Understand existing data landscape, perform detailed analysis on Org structure and enable RACI matrix, Building operating model.

• Power BI Dashboards and Reporting

Develop and Optimize Power BI Dashboards - Design, develop, and maintain advanced Power BI dashboards and reports that provide actionable insights. Paginated Reports Creation - Create, customize, and manage paginated reports using Power BI Report Builder. Data Modeling - Construct complex data models that aggregate data from multiple sources and optimize them for performance in Power BI. Develop and optimize SQL queries to ensure maximum performance and efficiency. Implemented advanced Data Analysis Expression queries in Power BI desktop, providing detailed insights and enabling 20% better performance. Develop and implement data calculations, KPIs, and aggregations that provide deeper insights into the data. Optimize Data Analysis Expression queries to ensure maximum performance in data retrieval for reports and dashboards. 

• Tableau Dashboards and Reporting

Collaborated with stakeholders to understand business requirements and translate them into actionable insights. Designed and implemented data visualizations to effectively communicate data insights. Analyzed data from multiple sources to identify trends and insights, leading to the identification of a new customer segment. Identified and resolved Tableau performance issues, reducing query times by 40% and improving overall server performance. Collaborated with cross-functional teams to develop and maintain Tableau visualizations for increase in data accuracy. Developed and implemented a Tableau dashboard that provided real-time insights into customer behaviour.

• Expert Solutions Projects

Led team for Expert Solution Centre (ESC) in GWS Segment. Maintain effective delivery mechanisms for the team across and products.

Review and provide feedback to team members on the team around products. Ensure high quality products and constantly work towards enhancing newer projects.

Proactive in managing ESC which includes regular touch-base with account teams.

Closing all ESC requests in the given timeline. Tracking and ensuring active accounts are up to date and operational.

Keeping track of all ESC Jira tickets. Account team communication and updates of ESC requests.

• Underwriting Models

Understand and implement the working and purpose of the model.

Understand the data and clean it according to set guidelines. If required help colleagues to understand and implement it better. Reviewing the Model and managing it according to the requirement.

• Tableau Dashboard (Vantage Analytics)

Taking initiatives in creating new designs and styles for Vantage Analytics Tableau Dashboards. Prepare, publish, and provide Analysis for reports and dashboards on time against daily, weekly, monthly.

• Portfolio Optimizer

Understanding the client’s requirements and preparing visualized reports in CBRE tool such as Portfolio Optimizer. Reviewing the Model and managing it according to the requirement.