Mayur Shah Email & Phone Number

Mumbai, Mh, In

Mumbai, Maharashtra, India

Mumbai, Maharashtra, India

• Extensively worked on in-house ETL platform used within Finance Technology department, to develop reusable modules that are utilized across thousands of ETL jobs. • Engaged with cross-regional functional leads across the department to gather requirements, fostering collaboration and ensuring a comprehensive understanding of project needs for seamless execution.• Involved in all phases of SDLC, from initial concept and requirements gathering through design, development, testing… Show more • Extensively worked on in-house ETL platform used within Finance Technology department, to develop reusable modules that are utilized across thousands of ETL jobs. • Engaged with cross-regional functional leads across the department to gather requirements, fostering collaboration and ensuring a comprehensive understanding of project needs for seamless execution.• Involved in all phases of SDLC, from initial concept and requirements gathering through design, development, testing, deployment, and ongoing support and maintenance.• Local lead and Scrum Master for team of 6 backend developers• Enhanced the ETL platform to incorporate various source data quality checks as mandated by the regulatory requirements, and seamlessly incorporated these checks in 1000’s of ETL jobs.• Designed and developed a reusable module for Teradata Parallel Transporter (TPT) in ETL, drawing inspiration from the native C driver, to enhance data extraction performance and extend the functionality of data loading into Teradata.• Collaborated in gathering requirements, designing, developing and deploying an ‘ETL Job Configuration as Code’ process, ensuring SDLC compliance for efficient ETL job deployment. Show less

Mumbai, Maharashtra, India

• Implemented a Primary/Secondary Architecture within the ETL framework for data loading into Teradata, ensuring synchronized data loading across both Production and Business Continuity Plan (BCP) Teradata environments.• Led a team of six consultants in remediating approximately 500 ETL jobs to align with the Primary/Secondary architecture.

Pune, Maharashtra, India

• FIS Wall Street Concepts (WSC) suite provides tax information reporting solutions to the financial industry, which facilitate the production of IRS forms 1099, 1042S and K-1, as well as the preparation of individual tax returns.• Compliance Plus is a service that helps firms to comply with Federal and State Tax Information reporting, including rules related to investor level supplemental reporting for Widely Held Fixed Investment Trusts (WHFITs). It provides a web-based interface to… Show more • FIS Wall Street Concepts (WSC) suite provides tax information reporting solutions to the financial industry, which facilitate the production of IRS forms 1099, 1042S and K-1, as well as the preparation of individual tax returns.• Compliance Plus is a service that helps firms to comply with Federal and State Tax Information reporting, including rules related to investor level supplemental reporting for Widely Held Fixed Investment Trusts (WHFITs). It provides a web-based interface to manage all facets of the tax reporting process - across multiple sources - as well as a correction management system through Bulk Adjustments.• Extensively worked on Compliance Plus - ETL Framework, to persist tax year agnostic data for certain entities like Accountholders, Securities etc. in a centralized location so that business can view and manage data in a better way. This avoids the need to save duplicate and redundant data across the tax years and hence reduces the memory utilization at database level.• Implemented a Generic Bulk Adjustment framework, facilitating efficient corrections to Accountholder, Transaction, and Security data in bulk. Overcame limitations of the previous Excel template method, scaling the processing capacity from a few hundred to several thousand records. Show less

Pune, Maharashtra, India