Mayur Shah Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

• Led a cross-functional team of 20 FTEs in the development and maintenance of a global intranet site serving over 100k users across 31 markets.• Ensured end-to-end project execution by ensuring timely delivery of project deliverables and proactively removing impediments, facilitating clear communication and fostering a collaborative team environment.• Promoted a culture of quality, delivering bug-free increments and maintaining high standards of excellence.• Managed stakeholder communications, ensuring alignment with project goals and addressing concerns transparently.

Pune, Maharashtra, India

• Led business-critical Transformation program of Data Migration to migrate 5.9 million post-paid and 700k SMB subscribers from legacy stack to Oracle’s BSS stack using ETL tool.• Managed 5 work streams including Data Migrations, Pre-Bill Crediting, Data Reconciliations, Feed Monitoring, Change Management with cross-functional team of 35 FTEs.• Delivered over 32 small IT change projects in 2 years, addressing business demands and unblocking migration processes.• Successfully prepared and won RFPs for insourcing projects, transitioning new services smoothly and efficiently.• Achieved 9 FTE worth savings through automation, cross-skilling, and strategic hiring practices.

Pune, Maharashtra, India

• Successfully transitioned the Data Migration service from an external supplier to VOIS, ensuring comprehensive knowledge transfer through shadowing and reverse-shadowing activities performed by our team.• Strategized and executed the migration process within stringent time constraints, effectively mitigating risks to meet all SLAs.• Spearheaded continuous improvement initiatives in Data Migration processes by identifying and implementing automation opportunities, thereby enhancing efficiency, quality, and operational excellence.• Developed and enforced Standard Operating Procedures (SOPs) to ensure seamless functionality and 100% operational continuity.

London, United Kingdom

Developed APIs in PL/SQL for generating reports in Text, CSV, PDF, Excel and XML formats.Developed JIL files for scheduled jobs in AutoSys Workload Control Centre.Prepared Technical Design documents, Test Plans, Implementation Plans for UAT and Production release.

Bournemouth, Dorset, United Kingdom

First Assist was using Global Insurance Open Solution (GIOS), a software product developed for Insurance industry by CGI Group.Provided 3rd line support for tickets raised by service desk by analysing the defects, bug fixes, data fixes and enhancements based on Change Requests (CRs) for existing Database Program Units and Oracle Forms of GIOS.

Dublin, Ireland

Allianz Worldwide Care (AWC) is part of Allianz Group, Germany. GIOS was an OLTP application customised for International Health Insurance business of AWC for policy and claims handling.Successfully led a team of 3 Offshore Developers, communicated effectively to coordinate and resolve issues. Created APIs in PL/SQL using Stored Procedures and Packages for Claims calculations involving complex business rules. Used XML & XSL with PL/SQL to generate reports. Prepared Efforts Estimation plans, Technical Design Specifications documents after analysing Functional Design Specifications documents. Participated in Peer Code Review meetings. Liaised effectively with cross-functional team of Business Analysts, Technical Architect, Java Developers, Project Manager and QA team.

Havant, Hampshire, United Kingdom

Tech Refresh program was about upgrading Royal Mail’s various bespoke applications to the latest technologies. Designed Logical Data Model for WebVCS application, defined Entity Relationships (ER) and created Physical Data Model using Enterprise Architect tool. Generated DDL scripts for database objects based on this ER diagram. Migrated bespoke AICC application from Oracle Forms 6i to web based Oracle Forms 11g in three-tier architecture by installing and configuring Oracle Weblogic Server 11g & Oracle Forms 11g on IBM AIX 6.1.Migrated bespoke RADB application running on Oracle 9i database on Microsoft Windows Server 2003 to Oracle 11g database on IBM AIX 6.1. Created new Unix Shell scripts and Windows Batch procedures in the migration process.

Folkestone, Kent, United Kingdom

European Breakdown Cover product was vehicle breakdown recovery insurance cover for AA's customers when travelling from UK to Europe. Created new Forms in Oracle Forms and APIs in PL/SQL for Customers, Quotes, Policies, Premium Calculations and Payment modules involving Credit Card, Debit Card and Direct Debit methods, Mid-Term Adjustments (MTA), Renewals and Cancellations of policies in TIA and AA.com website.Developed a solution using PL/SQL and XML for reconciliation of Direct Debit transactions received in XML format from Banks with the Direct Debit details of customers held on the database.Created Korn Shell Scripts in Unix to schedule batch jobs in Oracle to run at night.

Worthing, West Sussex, United Kingdom

Rating Support Application (RSA) was developed for Valuation Office Agency (VOA). RSA was designed to calculate the rateable value of Non-Domestic properties across England and Wales.Developed new code and enhanced existing code in Stored Procedures, Functions and Database Packages based on design documents using PL/SQL in Oracle 10g database.Produced Design documents from Use Cases and Unit Test script documents.Conducted code reviews, Design document reviews, Unit Test script reviews, by and for peers.

London, United Kingdom

This project was developed for UK Border Agency (UKBA), Home Office.Successfully migrated Oracle Forms 6i and Oracle Reports 6i from client-server architecture to web- based Oracle Forms 10g in three-tier architecture.Installed and configured Oracle Application Server (OAS) 10g, Oracle Forms Services 10g, Oracle Reports Services 10g, Oracle Developer Suite (ODS) 10g, Forms Servlet and Reports Server.Configured and integrated WebUtil utility into Forms 10g to replace client side features of Forms 6i.Setup Oracle Single Sign-On Server (SSO) to authenticate User names & Passwords and Oracle Internet Directory (OID) for querying and modifying directory services.Extensively created documentation for analysing the scope of migration, issues found during migration, prescribing alternative solution, User Guides for installation & configuration, Release Notes for Test and Production environment.

London, United Kingdom

This project was developed for Ministry of Justice (MoJ).Developed Forms and APIs using PL/SQL Library, Object Library in Oracle Forms 10g and database Stored Procedures, Functions and Packages using PL/SQL in Oracle 10g.Analysed and fixed bugs in existing Forms, Reports and database program units.Participated in UAT testing and code review processes.

Reading & Rugby, United Kingdom

This project was developed for Airwave Solutions who are providing world-class mission-critical communication services used by the emergency services in the UK.Created PL/SQL APIs for extracting data from staging database, cleansing the data by applying business rules and loading the data into the data warehouse for MI reports.Fine tuned SQL queries to retrieve records from very large tables by using techniques such as partitioning tables, parallel queries, Explain Plan and TKPROF.

Bracknell, Berkshire, United Kingdom

Motivity Plus was a bespoke application developed for Vehicle Leasing and Fleet Management companies. Developed forms for Contracts, Billing and Payment modules. Developed Stored Procedures, Functions and Packages using PL/SQL and enhanced existing modules based on Change Requests (CR) raised by customers.Used SQL*Loader to extract data from CSV files and load it into Oracle database.

Pune, India

Worked on a project for Cummins Filtration Inc, USA. and Motivity Solutions in UK.Fleetguard Access was a web based B2B portal to track customers’ orders and shipments. Oracle 9i AS InterConnect (OAI) was used to integrate different Sales Order Management System (SOMS) database instances with the central database of Fleetguard Access.

Mumbai, India

Worked on projects for Orix Auto and Orix Leasing, Japan. Developed Forms in Oracle Forms 5, Reports in Oracle Reports 3 and Database Program Units using PL/SQL in Oracle 8 database.

Mumbai, Maharashtra, India

Worked on client site of IL&FS in Mumbai. Designed and developed Financial Accounting software using Oracle Forms 4.5, Oracle Reports 2.5 and Oracle database 8.