Ajay Kumar Goyal

Project- Vanguard Asset Management for US, UK and AU operations

Developed BRD, FRD and Test Cases for UAT Testing based on discussion with business and IT teams.

Wrote SQL queries/procedures to analyze data sets to determine data gaps and work with cross functional teams to bridge the gap.

Provided Prod/UAT deployment support. Analyzed application logs to support Prod/UAT incidents.

Collaborated with code developers, test teams, process managers, and business Users globally to ensure solution being developed is as per business specifications.

Used Agile methodology and JIRA tool to track project items and ensure timely delivery of solution.

Created and managed the overall project plan at the project level; and escalated delays to the program lead, if needed.

Key member for entire project lifecycle which includes analysis, design, development, testing and implementation.

Worked on annual SWIFT and DTCC upgrade for messages (MT564 to MT568) every year since 2008.

Worked with DTCC, Markit and other data vendors to debug the issues in message content.

Worked on a project to redefine data source hierarchy for Golden copy.

Generated User stories, proof of concept models, and supporting documentation.

Managed many other sub-tasks, assist in making presentations etc.

Project- Fidelity Asset Management for US operations

Key IT contact for any new business initiatives by understanding and preparing BRD.

Prepare and execute UAT test cases.

Collaborated with IT and Business teams to understand, document and resolve functional and technical queries/issues/requirements during life cycle of project.

Back-up Lead for Scrum calls.

Created project artifacts using MS office products word, excel and power point.

Wrote SQL queries, analyze logs and code review to help support Prod/UAT incidents.

Monitored business trends via KPI and implement corrective action plans.

Identified areas for Manual Touch point reduction and automate wherever possible.

Project- Santander Bank (Spain) and Mizuho Trust (USA Operations)

Developed BRD, FSD based on discussion with business and IT team.

Supported UAT testing to make sure solution meets business needs.

Developed shell/unix scripts to monitor long running tasks etc.

Worked on creating BaNCS product/features enhancements based on Market research and customer needs.

Managed both projects and sub-tasks simultaneously.

Provided direction and solutions on various functions, working closely with operations in current day to day processes and operating model.

Worked as member of the FI (Final Inspection) team by reviewing test plans and other delivery artifacts to make sure delivery package is defect free and follows standards.

Support deployment tasks as well as post deployment incidents.

Project- Fidelity Investments (UK Operations)

Preapred BRD, FSD and Test plans to automate manual processes.

Supported functional and technical queries/issues/requirements during life cycle of Corporate Action project by debugging/collaborating with technical and business teams.

Analyzed existing processes, procedures and worked with various teams to improve them to improve automation and efficiency.

Reviewed and Executed Test plans using technical and functional knowledge on CA.

Support UAT and Prod incidents.

Project- Bank Of New York Mellon (US operations)

Code developement for BaNCS batches and UI web pages.

Prepared and executed test cases.

Reviewed Annual Swift 15022, DTCC 20022 and GCA/Markit changes/requirements and prepared solution document.