SUMMARY:

• Qualifications over 11.5 years of Development, Production Support and QA software testing experience with capital markets and Banking domain
• Strong Knowledge on implementing Enterprise Security Master Data Management(MDM) using GoldenSource Enterprise Data management platform
• Using Goldensource Enterprise Data Management(EDM), involved in development of connectors(MDX/OMDX) for Data Mapping from vendor files, UI development, business rule implementation using custom JAVA rules, analyzing Goldensource package release notes and deploying the GoldenSource and custom packages in PROD and non - PROD environment
• Designed data models for each asset classes defining the set of fields needed for model completeness using Goldensource data models.
• Analyze and design short and long term business solutions for the Enterprise Security master data management platform
• Experience in managing complex and critical projects using Agile (Scrum and Kanban), SDLC and RUP methodologies.
• Proficient using Microsoft Office products that include Excel, PowerPoint, Team Foundation Server (TFS), and SharePoint
• Experience in data manipulation and writing complex SQL and PL/SQL queries
• Good Knowledge in PL/SQL, SQL and UNIX
• Strong knowledge in writing ESP job scheduler (CA Workstation tool) and Control-M scripts to trigger and monitor jobs.
• Analyze the CPU Utilization, Memory usage, Garbage Collection and DB connections to verify the performance of the applications using AppDynamics
• Supporting Application Disaster Recovery activity, Monthly release and emergency fixes. Analyzing the production application logs using SPLUNK, OEM, TOAD and PUTTY
• Co-coordinating with cross platform teams, vendors for any technical issues and following up on root cause and resolution.
• Extensive experience in data analysis, data corrections and data clean ups using complex SQL and PL/SQL queries
• Extensive knowledge of the Fixed Income trading, operations, settlement and reporting processes
• Strong Knowledge of a wide range of investment products including fixed income, equities and Options
• Work with cross-functional business team to understanding key business initiatives and tie them to solutions available or that can be put into the development pipeline that meet the business goal.
• Experience in solving complex, multi-faceted problems facing day-to-day operations; deliver simplified solutions that allow the business to seamlessly provide customer service excellence.
• Experience in on call support for any production issues during US day time and weekends, troubleshooting the issues, finding root cause and resolving the issues.
• Provided required support for implementation of functional changes, as a result of production support issues, through all phases of the lifecycle, including design, defect triage and resolution.
• Experience in data governance, quality and controls in the financial services (Capital Markets) industry
• Experience in maintaining Onsite and Offshore coordination and sharing knowledge to the new team members on both domain and application knowledge
• Experience in Functional Testing, Regression Testing and Integration Testing and expertise in developing Test Estimations, Test Plans, Test Cases/Scenarios, Test Procedures, Defect tracking, analyzing Test Results and Test documentation and Test Metrics
• Creating the automation plan, approach and design to the automation testers to start with the automation scripts • Good knowledge of project activities including requirements gathering/review, planning, designing test conditions/ acceptance criteria, executing test scripts, troubleshooting and error tracking
• Specialization in the Atlassian Product Stack (JIRA, Confluence)
• Expertise in Automation testing with HP- UFT tool, VB script (QTP) and Selenium Web driver
• High impact communication - good experience of working in client location and interaction with various stakeholders like senior leadership, test coordinators, vendors, development/infrastructure team, business analysts, upstream/ downstream contacts and offshore teams
• Involved in Story Refinement, Sprint Estimation, Development Approach, Coding and Unit Testing, Daily Stand Up, Demo, Retrospective meetings and strictly followed Agile Methodology

SKILL:

GoldenSource, ESP Job Scheduler, Control-M, AppDynamics, Splunk, UFT, HP Quality Center, HP Quick Test Professional(UFT), Selenium Web Driver, Java, TFS, JIRA, Putty, OEM(Oracle Enterprise Monitoring), Clear Quest, SQL, PL/SQL, XML, UNIX, Oracle, TOAD, MS Office, UNIX shell scripting, FTP, WebSphere, eclipse, RAD, WinSCP, Confluence

TECHNICAL SKILLS:

Web/Application Servers: WebSphere

EDM Tools: GoldenSource Enterprise Data Management (EDM) suite 8.4/8.6/8.7

Databases: ORACLE 12c,11g/10g

Operating Systems: Sun Solaris 10, Linux 7/5, Windows XP/7/10

Scripting: Shell Scripting, SQL, PL/SQL

Database Management Tools: Toad 11/10

Schedulers: CA Workstation, Control-M

Languages: C, C++, Java, XML

Version Control Tools: TFS

Monitoring Tools: Splunk, App Dynamics, Oracle Enterprise Manager

Distributed Technologies: Web Services, JMS

Tools: Eclipse, Altova XML Spy, Putty, SQL Loader, WinSCP

Defect Tracking Tools: JIRA, TFS, Clear quest

WORK EXPERIENCE:

Technology Lead

Confidential, Denver, CO

Responsibilities:

• Using Goldensource Security Master Data Management(MDM), involved in development of connectors(MDX/OMDX) for Data Mapping from vendor files, UI development, business rule implementation using custom JAVA rules, analyzing Goldensource package release notes and deploying the GoldenSource and custom packages in PROD and non-PROD environment
• Involved in writing complex SQL, PL/SQL queries for data clean up, data extract and data analysis requests
• Lead the S&P and Confidential ’s Ratings Migration effort that includes the Detail Design, Development and coordinating with the vendors Golden Source, S&P and Confidential ’s till PRODUCTION install implementation and sign off
• Involved in fixing the defects prioritized in TFS queue part of monthly maintenance release
• Involved in production installs and Proactively analyze and resolve the production issues.
• Lead the 12-member development and production support team to implement the user stories assigned in the sprint window
• Worked on the design, development and unit testing of the regulatory projects SIX Financial 871M and Sanctions monitoring projects by building custom mapping connector using Goldensource software
• Reviews/perform master data request from all business functions to create, change, or delete existing data
• As a production support Lead involved in the daily batch monitoring, troubleshooting the issues, finding root cause, resolving the issues and suggesting short term and long term fixes
• Used monitoring tools like splunk, OEM, AppDynamics during batch monitoring and takes required actions.
• Strong knowledge in writing ESP job scheduler and Control-M scripts to trigger and monitor jobs.
• Involved in writing UNIX shell Scripts
• Worked on writing ESP job scheduler and Control-M scripts to trigger and monitor jobs.
• Worked on WebSphere for deploying the ear files as part of PRODUCTION installations
• Worked with cross-functional business team to understanding key business initiatives and tie them to solutions available or that can be put into the development pipeline that meet the business goal.
• Solved complex, multi-faceted problems facing day-to-day operations; deliver simplified solutions that allow the business to seamlessly provide customer service excellence.
• Involved in Story Refinement, Sprint Estimation, Development Approach, Coding and Unit Testing, Daily Stand Up, Demo, Retrospective meetings and strictly followed Agile Methodology

Senior QA Analyst/QA Lead

Confidential, Denver, CO

Responsibilities:

• Analysis of business requirements and creation of requirement analysis and supporting documents
• Creating Test approach document, Design and analyze Test Plans with focus on critical areas such as Scope, Methodology, Approach
• Involved in validating the mapping logic for the market data received from different data vendors to ensure the security data gets loaded as per the Golden source model and Business rules
• Performed functional, regression and performance testing using Goldensource Security Master Data Management software involving data mapping rule validation, business rules, UI validation, XML validation, Data warehouse validation, database validation by comparing the columns, etc
• Performed the critical pricing validation of files having 4 million rows using UNIX commands by comparing similar files generated from Production
• Creating the automation plan, approach and design to the automation testers to start with the automation scripts using QTP(UFT) and Selenium Web driver
• Involved in writing complex SQL, PL/SQL queries for database testing for comparison
• Attended Technical and Weekly Client Status Meeting and involved in interacting with the client to get the Requirement Clarifications, BRD Review, and approvals for deliverables.
• Responsible for daily status reporting for Client as well as offshore team members
• Responsible for System Integration Testing and UAT Testing Defect Review and tracking to closure
• Responsible for test data creation in Enterprise security master to support end to end testing

QA Analyst

Confidential, Denver, CO

Responsibilities:

• Analysis of business requirements and creation of requirement analysis and supporting documents
• Creating Design and analyze Test Plans with focus on critical areas such as Scope, Methodology, Approach
• Performed functional, regression and end to end testing to validate the trade confirms reports and customer letters
• Using Mainframe screens performed order placement for different types of accounts and security types and validated the same in the confirms report/letters
• Creating the automation plan, approach and design to the automation testers to start with the automation scripts
• Attended Technical and Weekly Client Status Meeting and involved in interacting with the client to elicit Requirement Clarifications, BRD Review, and approvals for deliverables.
• Responsible for daily status reporting for Client as well as offshore team members (size 15 members).

QA Analyst/Tester

Confidential

Responsibilities:

• Creating the automation plan, approach and design to the automation testers to start with the automation scripts • Validating the trade order placement workflows, portfolio analysis tools, interacting with external dealers for dealer testing, performance testing
• Created QTP(UFT) scripts for all core modules - Quick Search, Advance Search, Order placement, Portfolio Analysis tool, etc in SBS application. Also created QTP scripts to perform database testing, excel comparison
• Analysis of business requirements and creation of requirement analysis and supporting documents
• Creating Test approach document, Design and analyze Test Plans with focus on critical areas such as Scope, Methodology, Approach
• Performed Functional, Regression testing for different modules in this project as per the business requirement.
• Performed database testing using SQL queries
• Attended Technical and Weekly Client Status Meeting and involved in interacting with the client to elicit Requirement Clarifications, BRD Review, and approvals for deliverables.
• Project planning, prioritization & tracking, task/defect prioritization & scheduling, team (onsite & offshore) and client meetings, daily task/status monitoring, weekly client reports & updates, defect analysis reports, issue tracking/ resolution, project plan updates, change management (raised change request).
• Conducting Daily triage meeting with Business, QA and Tech partners to discuss the issues and defects raised by different team and update the status accordingly in TFS.
• Responsible for daily status reporting for Client as well as offshore team members.
• Responsible for System Integration Testing and UAT Testing Defect Review and tracking to closure. • Represent test team for release go / no go decisions
• Performed Functional testing, Regression testing, Performance testing, Automation testing, Backend verification with Oracle and Unix, UAT and test data creation, new issue creation from IPREO/JPM, etc