Experience Summary

Working as a Systems Analyst with 9+ years of IT experience in varying roles of Business Systems Analyst, Data and OBIEE Reports Analyst, ETL Developer and Support Analyst in Banking and Financial services.

My strengths and knowledge domains are Risk Analytics, Regulatory Reporting (OCC and CCAR) and Data warehousing/EDW involving Basel-II norms, knowledge of Basel-III accords and Real Estate banking. I have sound project management competence with excellent written and verbal communication skills. My experience includes but is not limited to:

Currently, working as a Sr. Business Systems Analyst and Project Coordinator for the ‘LINKS re-write’ project. Working for ‘PNC Real Estate’ and ‘Corporate and Institutional Banking’ Business Technology, PNC Financial Services in Pittsburgh, PA. May 2015 – Till Date.

Worked as a Business Systems Analyst, OBIEE reports analyst for ‘Model Administration Tracking Risk Information and Control System’ (MATRICS) for Risk Management Technology group, PNC Financial Services, Pittsburgh, PA.

Earlier worked as a Business Analyst and Informatica Developer for Regulatory Information Systems (RIS) project on OCC and CCAR reporting for Risk Management Technology group, PNC Financial Services.

Business Analyst / Senior Data Analyst for EIM technology project, PNC-RBC (USA) Mergers & Acquisitions.

Business Analyst / Data Analyst for Risk Analytics technology project Concentration Risk reporting. Involved in requirement gathering, design, Data Modeling, Data analysis for Concentration Risk reporting project. Various products from Commercial banking, trades, and capital markets were reported based on the Basel II asset classes.

Performed role of an ETL developer and QA analyst for ‘NCC to PNC re-platform’ project. Worked with various source systems and developed the code for re-platform of National City applications to PNC Bank platform.

Worked on decommissioning of the major applications in National City Corp. Worked with various downstream and upstream stakeholders for smooth decommissioning of the banks application. Was integral part of the team responsible for conversion of National City applications to PNC application platform, which involved testing and validations of data flow between the systems.

Worked as an onshore coordinator for a sizable offshore team. Responsible as Primary code owner of largest data warehouse applications and database at National City Corp, Cleveland, OH.

Education

Degree and Date

Institute

Major and Specialization

Bachelor of Engineering – June 2006

Rajiv Gandhi Technical University, Bhopal, India

Computer Science

Technical Skills

Technologies

Informatica Power Center 8.6.1 (ETL Tool), OBIEE 11g/10g (Oracle BI Administration, Oracle BI Dashboards, Oracle BI Publisher), Tableau, Informatica Power Center/Exchange 9.1.1/8.6.1 (Designer, Workflow Manager, Workflow Monitor), SQL (Oracle, SQL Server, DB2), PL/SQL, Autosys Scheduling, Unix scripting, COBOL, JCL, VSAM, Geneva

Databases

Oracle 11g/10g, IBM DB2

Computer System

Windows Embedded XP/2005, Windows XP/Vista/7, Unix platform, Mainframes

Software/Applications

oHP ALM-11/12 (Application Lifecycle Management), Mercury Quality Center ServiceNow, Infoman, Service Center, Serena ChangeMan DS, WSFTP*Pro

oOracle OFSMRM, LINKS

oMS Office tools, MS Visio, CA7

oTOAD for Oracle, SQL Developer, Toad Data Modeler, ERwin

Domain Expertise

Business Domain

oRetail Banking, Wholesale Banking, Real Estate, Corporate and Institutional Banking

oRegulatory reporting - OCC, Concentration reporting

oRisk Analytics, Risk Management - Model Risk Management

oBASEL II/III norms

oCredit Card processing

Certifications/Achievements

ASCENT advanced course for project leaders and managers

PathFinder course for project leaders

IIBA endorsed diploma certification in Business Analysis and Business Skills

Certified US banking and Retail banking specialized course

On-the-spot award with the National City Data warehouse team

Project Experience

Project Name

LINKS Re-write - Corporate and Institutional Banking Business Technology and PNC Real Estate

Client Name

PNC Financial Services

Duration and Location

May 2015 – Till Date; Pittsburgh, PA

Description

LINKS Re-write

The LINKS application is used to manage the work flow for real estate valuations, construction inspections, and real estate market research for commercial LOB’s. It serves as the tool to engage third party appraisers and inspectors. The application houses documents as part of the various processes by third party appraisers / inspectors / PNC staff. Additionally, the regulations require due diligence for real estate valuations is performed and maintained in the application.

The LINKS application rewrite is essential in order to support the future business growth and alignment to the PNC’s strategic direction.

Role

Business Systems Analyst, Project Coordinator

Responsibilities

Interacted with business users, SME’s and other stakeholders to understand the requirements.

Analysis and understanding of the functional and non-functional requirements.

Delivering essential documentation in project’s discovery phase - Functional and Non-Functional requirements, Business Use Case/Data Validation Rules, Functional workflow and process flow documents, Gap Analysis and Reports using MS word, MS Excel and MS Visio.

Conducting workshops and deep dive sessions to understand the business needs and criticality.

Conducting demos of the application based on the requirements and maintaining issues/feedback tracker.

Harvesting of the business rules required to implement the application.

Worked with UI/UX design team to build wireframes, prototypes, and HTML pages. Helped them to create end-to-end design flow.

Responsible for providing requirements and inputs to OBIEE reporting team. Worked on fixing of some of the answers report.

Worked with other business accelerators and interfacing teams for the project.

Worked on estimating tasks and effort with technical team for various modules of application.

Provide Use Case documents to development team.

Provide inputs to data architect and technical lead on data mapping, HLD and LLD documentation.

Performed smoke test, unit test on the application based on the requirements. For testing purposes HP ALM-12 (Application Lifecycle Management) was used.

Helped in writing test cases for UAT purposes.

Working with offshore design and development teams to help them understand the business requirements.

Adopting AGILE methodology for the project, be part of SCRUM meetings, and work with Stakeholders.

Tools

LINKS Real Estate application, OBIEE-11g, OBIEE Answers, TOAD, ALM, Erwin, MS Excel, MS Visio and MS Word.

Project Name

Model Risk Management - Risk Analytics Technology

Client Name

PNC Financial Services

Duration and Location

April 2013 – May 2015; Pittsburgh, PA

Description

Model Administration Tracking Risk Information and Control System (MATRICS)

Model metadata needs to be housed at a single location based on the business requirements. It is currently maintained through manual processes and is being automated as part of this project Around 250+ Models and their business usages information will be maintained in the automated solution. The various model and the related issues which fall under various regulatory portfolios exists in the current system. The Model can be for SOX, BASEL, or other compliance and have statistical or quantitative calculation capabilities.

The project involves automation of the current system to the Model Risk Management (OFSMRM or MRM) based on OFSAAI (Oracle Financial Services Analytical Applications Infrastructure) platform.

Role

Business Systems Analyst, OBIEE Reports Analyst and Project Lead

Responsibilities

Interacted with business users and other stakeholders to understand the requirements.

Analysis and understanding of the functional and non-functional requirements.

Delivering essential documentation in project’s discovery phase - Functional and Non-Functional requirements, Business Use Case/Data Validation Rules, Functional workflow and process flow documents, Gap Analysis and Reports using MS word, MS Excel and MS Visio.

Conducting workshops and deep dive sessions to understand the business needs and criticality.

Understanding of SOX and BASEL compliant models’ quantitative calculations.

Conducting demos of the tool based on the requirements and maintaining issues/feedback tracker.

Harvesting of the business rules required to implement the tool.

Performed smoke test, unit test on the tool based on the requirements. For testing purposes HP ALM-11 (Application Lifecycle Management) was used.

Working with offshore development team to help them understand the business needs.

Tools

Oracle MRM 2.0, OBIEE-11g, OBIEE Answers, Putty, TOAD, ALM, Erwin, MS Excel, MS Visio and MS Word.

Project Name

Enterprise Information Platform – Regulatory Reporting Application

Client Name

PNC Financial Services

Duration and Location

Jan 2012 – March 2013; Pune, India

Description

Regulatory Information System

PNC is submitting eight electronic OCC submissions (Monthly or Quarterly) and an annual Shared National Credit (SNC) examination. Financial report of the bank needs to be submitted to the OCC/FED based on the regulatory requirements. The report generation/submission requires analysis and an ETL process within RIS Data mart. Data from various data sources needs to be fetched and analyzed to produce reports based on the business requirements. Hence, the scope of the project was to create an automated, scalable, and auditable IT solution to cater to the following eight OCC data submissions.

Monthly

oMortgage Metrics Reporting (MMR)

oHome Equity Loan Level Reporting

oCredit Card Account Level Reporting

oMortgage and Home Equity Address Matching

Quarterly

oHome Equity Portfolio Level Reporting

oCredit Card Portfolio Level Reporting

oCommercial Real Estate (CRE)

oLarge Corporate Syndicated Credits (LCSC)

Role

Business Analyst and Informatica Developer

Responsibilities

Analysis and comparison of the data flowing from various data sources.

Interaction with business stakeholders and clients for the requirements.

Analyzing and maintaining Source-to-Target data mappings, the document which defines the relationship between source and target fields, provides description and type of the fields.

Be part of DFAST (stress testing) and help in providing results for the bank.

Assist downstream with data elements and inputs to CCAR (Comprehensive Capital Analysis & Review) reporting requirements.

Worked on ETL tool, Informatica to update existing mappings and workflow, to which Source-to-Target mappings are fed with data load from the database to generate the business/regulatory reports.

Performed analysis on each source system and mapped financial data, customer data, general ledger data and reference data to data mart.

Worked on Mercury Quality center which was used to validate the report generation for the project and for test cases, defect tracking.

Carried out testing for data validation and preparing test cases.

Provided technical and business documentation using MS office tools.

Tools

SQL Developer, Informatica Power Center, TOAD, Mercury Quality Centre, MS office tools, MS Excel, MS Visio and MS Word.

Project Name

PNC-RBC (USA) Mergers & Acquisitions - Enterprise Information Management

Client Name

PNC Bank

Duration and Location

July 2011 – Jan 2012; Pune, India

Description

PNC-RBC (USA) Mergers & Acquisitions

The M&A project started after the acquisition of RBC banks’ US arm by PNC Bank. Mapping the attributes and products of acquired banks to the existing PNC Data mart attributes. The various line of businesses products, like Demand Deposit, Credit Card, Savings, Installment Loan, Auto Loan and others were mapped as part of the project scope.

Project involved understanding of current PNC system and analysis for mapping the data attributes with the current Enterprise Information Platform (EIP) Database.

Role

Business Analyst / Sr. Data Analyst

Responsibilities

Interacted with business clients, worked with upstream source systems, doing analysis and comparison of data attributes.

Analyzing and gathering requirements for system build.

As per the given requirements, coordinating to get the data into required format and provide the rules on which the fields should be processed.

Analysis and comparison of the data flowing from various data sources.

Analyzing and maintaining Source-to-Target data mappings, the document which defines the relationship between source and target fields, provides description and type of the fields.

Worked on Mercury Quality center which was used to validate data for the project and for test cases, defect tracking.

Worked with the source systems to meet the requirements.

Tools

SQL Developer, TOAD, Mercury Quality Centre, MS Office

Project Name

Concentration Reporting - Risk Analytics BI projects

Client Name

PNC Bank

Duration and Location

Sept 2010 - June 2011; Cleveland, OH

Description

Concentration Risk Reporting

Business user group required Concentration reports which provide the amount balances of different portfolios of the bank and also carries a Risk Profile to determine the risk and asset in each of its segment/area. Various products from Commercial banking, trades, and capital markets were reported based on the Basel II asset classes.

These reports were very crucial for the business processes to have visibility on the risks and exposure involved in each area of bank.

Role

Business Analyst / Data Analyst

Responsibilities

Interaction with business clients, working with source systems, performing analysis and comparison of data.

Coordination with users, source systems to get the data into required format and provide the rules on which the fields should be processed.

Analyzing and gathering requirements for system build.

Analyzing source system data using Oracle PL/SQL and relational database concepts.

Analyzing business requirements and design Standard Interface Files for Basel II Asset Classes – Retail, Wholesale, Equity & Securitization and other financial report filings including OCC and Credit Risk Reporting.

Preparing Source to Target Mappings and configuring ETL.

Worked on Mercury Quality center which was used to validate data for the project and for test cases, defect tracking.

Preparing test cases and validating data as part of the testing process.

Tools

SQL Developer, TOAD, Mercury Quality Centre, MS Office

Project Name

EIM - Re-platform - Enterprise Information Management

Client Name

PNC Bank

Duration and Location

July 2010 - Sept 2010; Cleveland, OH, USA

Description

EIM - Re-platform

Post merger of NCC Bank and PNC Financial, the project scope involved to re-platform National City’s 24 major Data Warehouse applications to PNC platform. The technical aspect involved writing ETL code, testing the code and validation of resulting data. Coordinating with source and downstream applications for checking presence of monthly files and providing the same. Filling out requests for new datasets and scheduling jobs in CA7.

At its core EIP Architecture uses industry standard IBM Banking Data Warehouse (BDW) model which provides an integrated data environment that supports decision making and reporting, and compliance requirements supports the data requirements of Basel II. It provides data coverage for retail, commercial, trading and investment banking.

Role

Developer and QA Analyst

Responsibilities

Worked as ETL developer and QA analyst for the Enterprise Information Management, re-platform project from National City to PNC domain.

Maintaining source to target mapping document.

Assist business team with data elements flowing to EDW (Enterprise data warehouse).

Responsible for code development, unit testing and scheduling of the jobs in CA7 system.

Tools

JCL, COBOL, SQL, CA7 Scheduler, TSO/ISPF, DB2, Rocket Shuttle, Endevor, Infoman.

Project Name

EIM - National City Data Warehouse

Client Name

National City Corp Bank

Duration and Location

June 2007 - July 2010;

June 2007 to Apr 2009 - Pune, India; April 2009 to July 2010 - Cleveland, OH

Description

Enterprise Information Management - National City Data Warehouse

National City Data Warehouse was an integrated repository of data that provided single point access to Customer, Household, Account, Product and Branch/Organization information. The data warehouse combined customer information from Customer Information File (CIF) and account information from legacy systems vis. Demand Deposit, Cash Reserve, Savings, Installment Loans, Credit Card, Line of Credit, Debit Card, ATM, Mortgage Loans, Safe Deposit Box, Auto Lease, and Commercial Loans. Data Warehouse captured information about 21 million customers, 14 million Households, 33 million accounts, and 80 million transactions per month. Clients also used Geneva Adhoc Reporting tool to access all of 5 years legacy data.

Role

Lead Support Analyst, Data warehouse Application Owner (Onshore), Support Analyst (Offshore)

Responsibilities

Maintaining and supporting the data warehouse applications, reviewing data/ETL codes, adding new features/enchantments.

Coordinating with Source systems, downstream users of Data Warehouse, onshore and offshore teams.

Analyze and resolve all production issues and ABENDS/on-call tickets generated.

Representing the team in various project and business discussions.

Resolving high priority issues and meeting of the SLA’s defined for the support processes.

Involved in analysis for decommissioning of National City data warehouse legacy applications.

Analysis to prepare for the re-platform for the National City applications based on the PNC environment.

Enforcing successful completion of batch jobs scheduled to run daily/monthly/yearly and ensuring the expected data flow.

Rolling out enhancements or new code codes to production environment.

Tools

JCL, COBOL, Rocket Shuttle, DB2, DB2 Connect, CA7 Scheduler, Serena Changeman DS, GENEVA, Peregrine Service Center, Operating System: MVS/XA, IBM 3090, Z-OS

Contact this candidate