Saumya Vaish

Technical and Analytical Skills:

• Strong in SQL and Python for data extraction, cleansing, RCA, and automation.
• Experienced with Power BI dashboards, DAX, and efficient data modeling (star/snowflake).
• Skilled in ETL, data transformation, and ensuring data accuracy through governance and validation checks.

Data Quality & Root Cause Analysis:

• Conduct a deep-dive analysis to identify data issues, complaint drivers, and systemic root causes.
• Translate insights into clear recommendations that support operational improvements and control strengthening.
• Build repeatable workflows and pipelines to enhance data reliability and decision-making.
• Leadership and collaboration:
• Led analyst teams, set priorities, and coached members for high-quality delivery.
• Work closely with the Product, Operations, Journey, and Channel teams to influence insight-led change.
• Communicate complex findings clearly, and drive stakeholder alignment.

Delivery and Governance:

• Manage end-to-end analytics tasks.
• Optimize queries, processes, and data models to improve performance and efficiency.

• Understanding the client requirements and formulating a detailed execution plan for the business partners.
• Creating efficient SAS codes for permanent & ad hoc reporting purposes or for loading client data on the Aon Specific Database(TBA).
• Applied Proc Sql, Proc FreqandProc Means, and ProcTranspose for Data Analysis and generating a report using Proc Report.
• Good programming skills in SQL and understanding of data management principles, such as joining data sets, data aggregation.
• - Enhancing and automating process efficiency with SAS, and implementing the enhancements.
• Interacting with the US-based branch leads regularly for efficient resolution of project-related queries.
• Developing SAS code for Data Extraction, Validation, Manipulation, and Analysis.

• Conducted thorough code reviews to maintain high-quality software development standards.
  Boosted productivity by automating repetitive tasks using custom-built scripts and tools.
• Working directly with the client to understand the business insights by employing data analysis techniques and a delivery system, and also creating the analysis document.
• Solely responsible for taking care of the client’s electronic file transfer between clients and Aon.
• Facilitated knowledge transfer among team members by creating comprehensive technical documentation for developed solutions.

• Worked on various phases of the SDLC.
• Responsible for Production Support and internally initiated projects.

• Getting acquainted with the work environment and developing professional ethics.
• Undergone various training on SAS, SQL, and Proprietary Tools