Maitree Upadhyay

• Spearheaded the management of the in-house data quality tool GEMS, driving collaboration with business stakeholders to identify and address data quality issues, resulting in the creation of efficient stored procedures to trigger exceptions.
• Took charge of backend SQL database modifications for GEMS, encompassing the creation and maintenance of rules, team structure management, and user access administration, ensuring seamless operations.
• Independently engineered a reconciliation process between two source systems, seamlessly integrating it within GEMS, thereby enhancing data accuracy and reliability.
• Demonstrated proactive ownership by maintaining GEMS exception Power BI reports and providing comprehensive support across sectors, assuming extensive responsibility for resolving business queries
• Played a pivotal role in the management and enhancement of the Master Data Service (MDS) application, automating processes through SSIS packages and stored procedures, while actively engaging with stakeholders to address challenges and ensure system integrity.

• Took ownership of troubleshooting and resolving data-related queries across various divisions, collaborating closely with stakeholders to ensure data quality enhancement, while also assisting the BI&A team with Power BI requests.
• Partnered with business stakeholders to understand objectives and develop value-added reports using Power BI, contributing to ad-hoc data extracts and modifying existing reports to align with evolving business needs.
• Played a pivotal role in high-profile projects, collaborating with the Tax team and developers to translate client requirements into technical specifications, resulting in the successful creation of functioning products that met business objectives.
• Demonstrated strong analytical skills and technical proficiency by designing ETL workflows, migrating 25+ Qlikview reports to Power BI, and implementing innovative solutions, leading to a 70% reduction in team workload.
• Contributed to the development of a streamlined process leveraging Power BI's write-back functionality, empowering the Tax team to take direct action within Power BI and achieve real-time data updates that seamlessly reflect changes in both the SQL database and the report interface. This enhancement significantly boosted efficiency and facilitated the integration of real-time data updates.

• Led data migration projects, ensuring seamless delivery of comprehensive data conversion services while managing source-to-target mapping and performing rigorous data analysis.
• Demonstrated proficiency in utilising various source systems such as SSP, Acturis, and Transactor (TGSL), executing data cleaning, enrichment, and mapping tasks to maintain data integrity.
• Spearheaded the development of migration strategies and project plans, collaborating closely with team members and clients to achieve project objectives and meet client needs effectively.
• Leveraged technical expertise to write scripts, develop SSIS packages, and implement reconciliation checks, facilitating efficient data import into SQL Server and ensuring accurate frontend and backend testing experiences.

Project: MS Amlin - Data Analyst (Consultant Contract)

07/2018 - 11/2019

• Developed and implemented robust ETL processes using SQL Server (2014, 2008r2) and T-SQL, facilitating seamless migration of physical and liability data into the target system.
• Utilised Visual Studio 2015 (SSDT) and TFS (2013) for efficient database code management and deployment across multiple environments, ensuring code integrity and reliability.
• Executed comprehensive data cleansing, enrichment, and mapping processes, alongside writing ad-hoc queries to merge diverse data sources into desired output, enhancing data quality and accuracy.
• Established effective communication channels with Modellers and Underwriters, fostering collaboration to gain insights into data for decision-making, while remaining responsive to changing requirements and defects uncovered, and actively contributing to Agile stand-up and sprint sessions.