Candidates About

 

 

Operating System	Windows, Unix
Project Management Tools/Methodology	Object Oriented Analysis and Design (OOAD) using Unified Modeling Language(UML)
Microsoft Tools	MS Office, MS Front Page, MS Outlook, MS Project, MS Visio
Software/Database	Oracle8/9i
Programming Languages	C, Java, J2EE, SQL, PL/SQL, HTML, XML, UML, Visual Basic 6.0
Testing Tools	Quality Center
Technologies	J2EE Framework with EJB, MVC Framework, JSP, Hibernate
Modeling Tools	MS Visio, Rational Rose, TOAD Designer
Web technologies	JSP, Servlets, XML, JavaScript, Web Logic, Style Sheet, HTML
Change Management Tools	PVCS Dimension, Visual Source Safe, Infoman

Client: GE Capital (Norwalk)                                                                                       

Role: Business Systems Analyst

 

Model Risk Management project enables GE to record all activities related to Model Development, Customization and Implementation Process, and identify and regularize validations in order to evaluate and assess performance and risk associated with the Models.

 

Responsibilities

·         Conducted Backlog Grooming sessions with various stakeholders and created user stories for all the requirements

·         Created field level analysis documents with all the business rules , transformation rules

·         Created mockup screens and workflow diagrams

·         Configured all the data transformation rules into OFSAA MRM application

·         Customized OFSAA MRM application per GE requirements

·         Developed Data migration SQL scripts and migrated models into MRM application

·         Implemented Functional Role matrix and masking into MRM Application as per the given roles

·         Conducted Sprint Planning meetings, Retrospective meetings and showcase meetings for individual sprints

·         Reviewed test plan, test cases created by QA team

·         Performed Functional testing for the new requirements and regression testing for all the existing scenarios in SIT

 

Environment:                                                                                                                                                               

Client: PNC (Capital Markets, Pittsburgh)                                                                    Jan 2011 – Jun 2014

Role: Business Analyst/ QA Analyst/Data Analyst

 

RWA- Basel 2 and 3 project calculates the RWA (Risk Weighted Assets) for counterparty, Equity, Wholesale, Retail and Securitization exposures as per the Basel II US Final Rule. The Basel II US Final Rule covers counterparty credit risk under Pillar I requirements and includes specific rules on how the risk weighting (RWA) for specific transactions must be calculated

Pillar3 -Initiative 20 project is focused on development of only the quantitative portions of the Pillar III disclosures report.

Responsibilities

·         Worked as a Business Analyst, QA Analyst and Data Analyst. Analyzed business and data requirements and documented detailed Functional and Technical Requirements

·         Analyzed business and data requirements and documented detailed Functional and Technical Requirements

·         Documented  Business Requirements for Basel 3 rules for Counterparty credit and for Equity work streams

·         Created Business Metadata, Rules Metadata and Technical Metadata documents with all Business and Transformation rules and configured metadata into OFSAA

·         Created batch metadata documents and configured OFSAA batches to run for counterparty and Equity work streams

·         Created data lineage documents with data mappings from various source systems to target system. Documented the test cases for validating the data movement between source system files to Stage1, Stage1 to Stage2, and Stage2 to Fact tables.

·         Prepared High Level Logical Data Models, DL Specs, ER Diagrams and Business Requirement Documents containing the essential business elements, detailed definitions and descriptions of the relationships between the actors to analyze and document business data requirements

·         Configured data quality checks, transformation rules on the stage2 data and validated data loading

·         Responsible for Data Extraction, Data Compilation, Data Analysis, and Data Loading from source system to stage1 using ETL scripts

·         Implemented GL reconciliation process to reconcile data between OFSAA and PNC GL System

·         Gathered requirements for FFIEC reports, pillar3 reports and developed reports using BI Publisher

·         Extensively used MS Excel and Oracle for data comparisons and data exports and imports and for testing batch files

·         Responsible for trouble shooting, debugging and resolving production data/reporting issues encountered in OFSAA

·         Developed complex SQLs to generate in depth drilldown reports for business users

 

 

 

 

 

 

 

Client: PNC (Wealth Management, Pittsburgh)                                     Jun 2010 – Dec 2010

Role: Business Analyst

 

Wystar Conversion project is a continuation of the integration of NationalCity into PNC.  NationalCity is using Wachovia’s WySTAR system for their record keeping.   The retirement plan and participant data from the WySTAR system is de-converted and imported into PNC’s Schwab RT system.

 

Morningstar Managed accounts project enhances the PNC application RetirementDirections.com (Vested Interest) by enabling the “Managed by Morningstar” component from the Morningstar vendor.   Morningstar managed accounts service enables participants to have their accounts managed by Morningstar.

 

Responsibilities

·         Worked as a Business Analyst/QA Analyst. Was responsible for doing the business analyst functions, quality assurance and administrative tasks as well as defining the project schedules.

·         Conducted JAD sessions with business units and documented the requirements for migrating the Nationalcity plans and participants to PNC. Gathered requirements for generating the reverse feeds for various Nationalcity clients during conversion.

·         Worked with Morningstar , Envisage vendor teams and integrated PNC’s Schwab RKDB application with Morningstar and Envisage systems

·         Analyzed business and data requirements and documented detailed Functional and Technical Requirements

·         Developed Process Flow Diagram’s and use cases for reverse feeds.

·         Onshore,  Offshore communication and documentation management

·         Scheduled and facilitated meetings with developers and testers to collaborate resource allocation and project completion.

·         Managed requirements traceability to track requirements status throughout the project development lifecycle.

·         Tracked results in the HP ALM and reported system defects.

·         Log, track and report defects in ALM and update ‘best practices' documentation and responsible for risk assessment and test coverage analysis.

·         Developed test plans and test cases to check the functionality and performance of application.

·         Set up the test environment and created test data for all test cycles

·         Performed the Functional testing for the new requirements and regression testing for the existing scenarios in various environments like SIT, and UAT. 

 

 

Client: Bank Of America, Charlotte                                                                                Jun 2009 – Jun 2010

Role: Business Analyst

 

1) Mortgage Investments Management System (MIMS) is a Portfolio Management System utilized by Corporate Investments Group to manage its Portfolio of Mortgages. The application is a web application suite providing Portfolio analytics, query, pooling and deal execution capabilities along with other custom reports. Front Office uses the tool to serve the trading needs of the Whole loan Trading Desk.

 

2) Mortgage Data Mart is a data ware house application used to house primarily all whole loan reference data in CIG's portfolio. It pulls mortgage reference data from a variety of sources like SBO2000, LYNX and consolidates the data into a consistent format. MIMS application imports data from MDM and use that data for Loan Pooling.

 

Responsibilities

·         Worked as a Business Analyst for, MDM and Mortgage Investments Management System (MIMS). Was responsible for doing the business analyst functions, quality assurance and administrative tasks as well as defining the project schedules.

·         Analyzed business and data requirements and documented detailed Functional and Technical Requirements

·         Developed Process Flow Diagram’s and use cases for the New Loan Boarding Process, Master Servicer file upload process, Loan Pooling and allocation process for loan and collateral.

·         Act as liaison between systems and business users and responsible for conducting meetings with all the stake holders to assure critical and minute details of the project are discussed and issues were resolved beforehand.

·         Responsible for monitoring the project progress and communicate regularly with cross functional team members.

·         Conducted JAD sessions with business units for gathering requirements in order to elicit valid business requirements and in getting consensus on the functional and data requirements.

·         Developed Questionnaires and Conducted user interviews for gathering requirements, analyzed and documented business requirements based on the analysis of New Loan Boarding Process, MDM and Mortgage Investment Management system.

·         Managed requirements traceability to track requirements status throughout the project development lifecycle.

·         Performed the Functional testing for the new requirements and regression testing for the existing scenarios in various environments like SIT, and UAT. 

·         Performed End to End testing

·         Tracked results in the HP ALM and reported system defects and defects.

·         Log, track and report defects in HP ALM and JIRA; update "best practices" documentation and was responsible for risk assessment and test coverage analysis.

·         Identified critical failure points in technical architecture and included test scenarios in the test plan for testing potential failures

 

Environment:

Client: PNC Bank (Capital Markets), Pittsburgh                                                                                      Sep2008 – May 2009                                                                                              

Role: Systems Analyst 

                                                   

Murex is a front office investment, Asset management and Buy/Sell side trade order management systems (TOMS) with market data from Bloomberg. It provides an easy to use trade management and asset allocations over different asset classes including Derivatives, equities and fixed income products and provides decision support platform with Performance measurement and Bench marking for the effective and efficient management of client assets with trade capture, settlement and position Reporting.

Responsibilities

 

·         Responsible for creating Test Plans/Test Scripts and Test Cases from the Business Requirement document and design document to cover overall quality assurance.

·         Responsible for the documentation test cases related to requirements relating to PNCCM fixed income trading for Compliance, Credit Risk Management, and the Front Office

·         Performed Data Compilation, Data Scrubbing and Data Validation using SQL queries in a Oracle environment

·         Reviewed the test plans related to configuration testing, interface testing and reconciliation testing

·         Provided Subject matter expertise during Testing, Implementation and Post Production and assist developers in creating online validations.

·         Created Quality center folder structure and maintained requirement traceability by linking the requirements to test plans.

·         Developed Quality center training documentation and provided QC trainings to various user groups by taking real time scenarios.

·         Conducted Back End Testing, Functionality Testing , Regression testing

Environment:

Client:  General Electric – Stamford                                                                             Jun 2007 – Aug 2008

Role: Business Analyst

Debt and Derivatives Simplification: DDS project validates and finalize the functional design of Wall Street Suite for simplifying GE Corporate Treasury's handling and processing of debt and derivative instruments. It replaces the existing legacy systems with Wall Street Suite.

Responsibilities

 

·         Created AS-IS and TO-BE business process flow diagrams for each system.

·         Performed GAP Analysis to identify problems and inconsistencies with business requirements specification and the existing system

·         Created process flow diagrams to document the end to end flow of data from source to target systems

·         Developed and documented business scenarios and test strategies

·         Participated in Data Analysis and Design with the Data analyst in defining data sources

·         Used MS Project to manage schedules, deadlines and resources and collaborate on the project.

·         Prepared status report, charting out schedules, allocation and management of technical and human resources using MS Excel and MS Project

·         Involved in WSS Instrument Configuration. Configured various Instruments like Fixed Rate Bonds, Floating Rate Bonds, Interest Rate Swaps , Basis Swaps in WSS

·         Reviewed the test plans related to configuration testing, interface testing and reconciliation testing

·         Performed Data Migration testing between In