Prince Arora

Data Analyst Lead

Coforge•  June 2021 - Present

Successfully managed comprehensive data migration, conversion, and cleaning initiatives, leading US Bank's GCT Event 2A and 2B to live production with expert project management and technical skills, meeting critical milestones within tight timelines. Analysed BRDs and Functional Design documents to validate ER models, ensuring alignment with project goals. Collaborated with Database Architects to design comprehensive ER models for diverse bank implementations, accurately reflecting business processes and data flows. Took ownership of critical financial modules at US Bank, including Open Lots, Inflights, Close Lots, Transaction History, Income Loader, and all static modules. Developed code from scratch for these modules in two new hybrid implementations. Developed advanced PL/SQL packages, procedures, triggers, functions, indexes, and collections to implement business logic using SQL Developer. Created server-side PL/SQL scripts for data manipulation, validation, and materialized views across remote instances.

Associate Team Lead

Telus International (Xavient)•  July 2019 - June 2021

Managing deliverables and monitoring project progress effectively. Developing SQL scripts for data migration to SWP Platform, conducting data integrity checks and source validations. Creating reconciliation and load reports using SQL queries to verify migrated data for end clients. Generating implementation-specific reports with SQL queries to furnish detailed information to banks.

Sr. Software Analyst

Accenture•  July 2015 - January 2019

Analysing Business Requirement Document (BRD) and the Functional Design document. Performed extraction, transformation and loading from large Oracle tables. Used SQL queries extensively to validate and manipulate the research data. Facilitated in the overall management of the project including mitigation, status reports, client presentations, defining milestones, deliverables and establishing critical success factors.

Software Engineer

Bureau Veritas•  January 2015 - July 2015

Proficient in Web Services, GUI, Functional Testing, Black Box Testing and user acceptance Testing. Coordinated testing efforts, overseeing test deliverables, reporting status to management, and managing issue escalations.

Engineer

Rate Gain It Solutions•  July 2014 - January 2015

Specialized in Database Testing, focusing on Stored Procedures & complex SQL queries. Improved performance for clients like Carnival Cruises & British Airlines. Responsible for Functional Testing, Test Plan, Test Strategy, Requirement Traceability Matrix, and Defects Closure. Developed automated scripts to streamline tasks and reduce manual effort.

Software Engineer

NIIT Limited•  May 2012 - April 2014

Developed automated scripts to simplify common tasks and reduce manual efforts. Involved in release support: facilitating release to QA and testing the release process.