Project Management

Axiom CCAR Specialist/Business Analyst/ Functional Analyst/

Quality Analyst/ Test Lead/Test Coordinator/Defect Manager

Reconciliations Service Utility operations CONTROL / change management

BUSINESS ANALYSIS Quality ASSURANCE Analysis Test coordination defect coordination

MIS Reporting Governance Meetings/ Relationship Development

S

easoned, highly-motivated Change Management professional with over 8+ years of experience in Top Tier Investment Bank. Extensive experience in Change Management processes, Business Analysis, Quality Analysis, Business Process Design/Re-engineering/Modeling, and Web based Application Designs of different Brokerage firms. Hands-on in Business Performance Management, Business Process Re-engineering and Enterprise Application Integration, Process Coordination, Quality Assurance Analysis and Testing in the domain of Banking, and Federal Reserve’s Comprehensive Capital Analysis and Review (CCAR) Regulatory Reporting.

Core Competencies

Highly skilled in providing Business Analysis/Quality Analysis Solutions and Business Specification design working in large global financial companies participating in all phases of SDLC

Expertize in implementation of regulatory reports using Controller View (Axiom SL). Specialization in FR Y-9C & FFIEC-041, FRY-14Q & FRY-14A

Experience in defining scope of projects based on Business Requirements including documentation of constraints, assumptions, business impacts, Project risks & scope exclusions

Reviewing configuration rules and documenting, testing Strategy, evaluation of Tool for test automation, workflow, creating match passes based on matching criteria and validating final recon reports

Adept in reviewing test procedures, creating test plans, defining System & Integration test cases, executing test cases, test data reviewing, maintaining and executing detailed test scripts for User Acceptance Testing (UAT) analyzing bugs, interacting with team members in fixing errors and performing Integration testing and User Acceptance Testing

Equipped with strong communication, analytical and problem solving skills, keen to details, flexible, accountable and an advocate for creating a team atmosphere

Expert-level knowledge in all components of Controller View (Axiom SL).

Technical skills

Reporting Tools: Controller View (Axiom SL), Business Objects XI (Rich and Web Client), Crystal reports, Web based Dashboards.

Operating Systems: Windows XP, 2000, NT, 98, 95, UNIX.

Microsoft Suite: MS Visio, MS Word, MS Excel, MS Project, MS Outlook, MS Database, MS Publisher.

Defect Tracking: HP Application life cycle Management (ALM), JIRA, HP/Mercury Quality Center, Bugzilla, JIRA, GenJIRA.

Programming Languages: C, C#.NET, JAVA, Oracle, ASP.NET, VB6.0

ERP: SAP, Oracle Financials.

Professional Experience

DEUTSCHE BANK AG.

Exchange Place, New Jersey

Aug 2013 – Dec 2016

Project: Deutsche Bank Services-Strategic Reporting Information Delivery (StRIDe) CCAR programme

Team: Global Technology Operations – Change Management

Role: Functional Analyst/Quality Analyst/Test Lead/Test Coordinator/Defect Manager

As part of Deutsche Bank’s global program StRIDe - CCAR programme (Strategic Reporting & Information Delivery - Comprehensive Capital Analysis and Review Program), Deutsche Bank initiated to automate US Regulatory Reports using Axiom Controller View.

The scope of the StRIDe CCAR Programme is defined as a strategic/enterprise solution to regulatory reporting for Finance within the AMERICAS Region. Factors that were considered in the development of this programme are:

Reduction of risk associated with the current financial regulatory reporting process, ensuring timelines, accuracy and granularity to the users and to the regulators

Reduction of complexity and compliance with mandatory requirements of regulating bodies(AMERICAS)

Efficient and scalable solution for Finance to meet regulatory reporting requirements

The CCAR Programme sees the deployment of AXIOMSL as part of the end to end strategic architecture as prescribed within the FED commitments. AxiomSL will be used for the local regulatory reporting covering the current Call reports and new CCAR reporting requirements.

Roles and Responsibilities:

Involved in requirements analysis, preparing Functional Specification Documents for FR-Y 9C, FFIEC 041, CCAR FRY-14Q, FRY-14A

Involved in analysis, design and validation of reports generated through Axiom Controller View.

Performed data analysis, data validation and data quality checks on the key data attributes

Performed System Integration Testing/User Acceptance Testing, configuration checks by validating the Shorthand conditions, Aggregations and Data Quality Analysis

Played a key role in end to end UAT for IHC FR Y-9C. this included giving walkthroughs to stakeholders, understanding their queries and probing for the best solution for any defects raised during the cycle

Involved in identifying MDRM dependencies across all the FR-Y 9C schedules and validating the edit check rules

Reconciled strategic and tactical solution output as basis for approving schedules for FRB submission

Involved in Requirements review sessions, Gap Analysis and performing Root Cause analysis for data discrepancies and data gaps.

Coordinated testing across global teams to ensure adherence to Deutsche Bank Quality Standards and Procedures and On-time deliverables

Created test artifacts to be used for the System and Integration testing. Created Decision documents, Test Strategy, Test Plans, Test Guidelines and Test Milestone Evidence Reports.

Used Software tools/applications such as Controller View(Axiom SL), Hewlett-Packard Application Lifecycle Management v11.0 and v11.52, v12.21 Microsoft office and Visio and work with databases like MS Access, Oracle, SQL Server database and Flat files

Tracked the application tests performed across the global team members, created and review Test cases, Test Scripts and Test Results for the executed scenarios

Day to Day Application Defect Management Process, coordinated defect identification, review, prioritization, assignment and fix re-test and Track system defects/requirements using the HP Application Life cycle Management

Responsible for updating all the impacted documents for the Service Delivery and provide training for all the impacted Users within Service Delivery

Participated in the creation of project plans and communicate status of the projects, RAID’s(Risks, Assumptions, Issues and Dependencies) to all levels of management using SharePoint and MS office

Worked collaboratively with Project Managers, Development/Application Managers, Technical Architects, Quality Assurance Managers and others to ensure effective cross-project communication and issue resolution management

Built credibility, established rapport and maintained communication with stakeholders and Technology at multiple levels throughout project life cycle

Applications: Controller View (Axiom SL) v8.9/9.5.2 (Java based), Oracle 10g, SQL Server database, JIRA, Hewlett-Packard Application Life Cycle Management (ALM v11.0, 11.52), SharePoint, Microsoft office Suite (Excel, Access, PowerPoint, Word, Visio, Outlook) and Lotus Notes.

Credit Suisse (Capital Markets) Manhattan, New York Jan 2012 – Jul 2013

Project: Global Operations Exposure Reporting Project.

Team: Global OPS Risk and Control – Change Management

Role: Business Analyst/Quality Analyst

Global Operations Exposure Reporting Project: The main purpose of this Data warehousing project is to provide Daily transparent Automated Global and Regional(AMER,EMEA & APAC) Operations Exposures Trend report to senior Management with information required to manage risk and understand relevant Business metrics like KRI’s and KPI’s Key Risk Indicators like Nostros, Fails, P&R and Suspense etc.

Roles and Responsibilities:

Worked closely with Business users (Middle office and Back office users) to Design the Functional Specifications and system requirements and other issues throughout Project Life cycle.

Analyzed business requirements, incorporated development and business objectives, and used the information to develop detailed comprehensive test strategies to verify system changes that met the needs of the client.

Prepared and Executed Test Plan, Test Scripts and Test Case Document for User Acceptance Testing (UAT) based on functional and Technical Specifications.

Performed UAT’s for different Source Systems to get automated feed followed by Control-M jobs and manual upload where Source systems do not exist.

Performed Business functionality testing, which involved testing of all core functions of the application. Organized and executed the User Acceptance testing

Managed and Analyzed requirements (business as well as system) in development of GUI, Performed GUI Automation Testing using QTP in various development Phases for different OS (Linux, UNIX).

Conduct Weekly meetings with the Project team and to have a weekly status report and prepare an overall QA status report and share it with the Project Manager using HP Quality Centre 9.2.

Executed Transaction Level Queries in SAP to Reconcile Sub-Ledger with General Ledger Accounts and address the Breaks of Risk Indicators followed by Sign-Off.

Followed the Key Software Development Life Cycle SDLC/SOX Project Stages to ensure quality of work effort and ability to report on Key milestones.

Achievements:

Proficiently defined and create new reports and financial analysis based upon management requirements.

Managed all QA resources globally from inception to off shoring of the project.

Nomura Securities International, Inc. New York, New York Aug 2010 - Dec 2011

Role: Business Analyst/Quality Analyst

Project: Global Management Information Systems

The G-MIS (Global Management Information Systems) Application maintains and reports all the aspects of Accounting which has sub modules like Exposure Information, Finance Control, Accounts Receivable, and Accounts Payable. This G-MIS “Information” System helps the senior management to get accurate information about firm’s financial Exposure, across all the Financial Instruments like Fixed Income, OTC, Loans, etc. Exposure tracking (Ageing) is another aspect of this application, which generates reports and runs queries on request.

Roles & Responsibilities:

• Participated in all the phases of SDLC, starting from requirement, design, development, testing and implementation phase.

• Involved in writing Test Plans, creating Test Scripts, Team Co-ordination and Documentation.

• Analyzed system requirements and formulate scenarios in Test Director for the Functionality, Navigation, Performance and Security testing of the application.

• Verified the functional aspect as per the business process and validated the interfaces with the other systems.

• Submitting weekly status updates and reports showing the progress of Software Testing.

• Involved in developing and executing Regression Test using QTP.

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using Visio.

• Developed and executed the test plans for Functional Testing, regression testing, Integration Testing.

• Performed Business functionality testing which involved testing of all core functions of the application.

• Organized and executed the User Acceptance testing

ING VYSYA INVESTMENTS Mumbai, India Dec 2009 – July 2010

Project: Investment Maintenance Management Systems (IMMS)

Role: Business Analyst

Assisted in the review of Risk Analysis & Assessment, Root Cause Analysis & SWOT Analysis. Served as a liaison between Clients & cross functional-teams to capture & create the Business Requirement Document (BRD), Business Solution Document (BSD) & Impact Analysis document with respect to business & functional change request. Interacted closely with the project manager on numerous project management tasks such as outlining project plan & strategies, regulating release schedules, tracking project status & coordinating resources using MS Project. Gained unanimity on the documented requirements from business owners in an opportune manner. Created documents like system design, functional specifications & project scope. Involved with developers, QA’s & clients to review design, development & test cases so as to ensure project deliverables conform to capture requirements. Coordinated with developers in identifying issues with unit test results & involved in UAT.

Achievements:

Actively involved in Risk Analysis & Assessment and SWOT Analysis

Analyzed spending and income trends and usage and negotiated fringe benefit rates.

Academic Qualifications:

Bachelors of Technology, Jawaharlal Nehru Technological University, India

Contact this candidate