SUMMARY

• A certified, accomplished, results - driven professional with over 12 years of experience in Data Management, Data Governance and Regulatory Reporting.
• Proven track record in increasing quality, productivity and customer satisfaction in various Banking, Health & Insurance projects including the Basel II Program, CCAR Program. Liquidity
• Expert in execution of Data Governance Functions like Data Trace, Data Quality, Controls Assessment
• Team leader with established ability to employ, guide and encourage others to surpass established objectives.
• Techno Functional Consultant who can understand both technology and business.
• Wide technical and the strategic background, experienced at functioning with business leaders to transform business needs into technology results.
• Basel II, Basel 2.5, Basel III, CCAR, Liquidity
• Excellent Banking Product Knowledge which includes both Banking and Trading Products
• Experience in handling Credit Risk and Market Risk Projects
• Excellent understanding of regulatory reporting forms like FFIEC, 14Q, 14M, 14A, FRY 9C, Call Report (FFIEC 031 - 041), LCR (5G/4G), NSFR
• Working Experience in OFSAA/Reveleus Credit Risk Module
• Worked with ETL Tools like Abinitio & Informatica
• Worked Extensively on Advanced Abinitio Concepts like Conduct>it, BRE etc.
• Working Experience in Analytical Tool SAS 9.1.3
• Excellent Excel VBA Skills
• Extensively worked on Source Systems like AFS Vision, ALS, TSYS etc
• Worked in the Big Data Warehousing Projects in various roles like Developer, Designer and Architect
• Performed Knowledge Sharing and Mentoring of resources besides coordinating with multiple domains on different projects.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica PowerCenter 8.6.1/8.5/7.1.4/6.2/5.1.1 , Abinitio GDE 1.15.9, Abinitio Co> Operating System 2.15.6/3.0, Abinitio BRE 1.15.2.5, Ab Initio Conduct > IT, OFSAA, SAS 9.1.3

Reporting Tools: Hyperion 9, OBIEE

Database: Oracle 8i/9i/10g, Sybase

Languages: SQL, PL/SQL, Shell scripting, PERL 5.8.3, Java Scripting

Data Modeling Tools: ERwin 3.5.2,4.0,7.2

Operating Systems: AIX 5.3, NT4.0/5.0, Windows XP/2000/98, Unix and MS DOSMainframe

Miscellaneous: AutoSys, TOAD, SQL Navigator, Microsoft Visio, Microsoft PowerPoint, MS Excel with VBA, MS Access, Putty, Microsoft Project Plan

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Business Analyst

Responsibilities:

• Lead the effort to derive the historical data based on Risk Asset Class, Obligor Rating, Maturity etc and worked with FP&A to get the Balance Sheet Forecasting
• Creating the RWA Methodology Documents for Wholesale Workstream
• Conducting UAT for the Standardized and Advanced RWA Calculations for Wholesale Results
• Reviewing and challenging the Results in the reporting layer called Lattice which is RWA Dashboard
• Attribution Analysis to make sure that the RWA Projections are as per the FP&A Allocations
• Leading the data analysis efforts like Sensitivity Analysis where the sensitivity of the Risk Attributes are identified based on the Stress Scenario’s
• Designed and Developed Manual Intervention Process to correct any misallocations observed during the post calculation analysis
• Designed Trend Analysis Reports based on the PD Transition Matrix for each of the Critical Business based on the Country and Industry Segments

Confidential, San Ramon

Sr. Business Analyst

Responsibilities:

• Lead the team of business analysts and guided them in successful implementation of the Data Trace Program
• Review the Mapping Documents provided by the Businesses to validate against the CCAR & Basel III Guidelines provided by Regulators
• Validating the data entering into the PPNR Models and the results of the models
• Conducted the Sensitivity Analysis on the Balance Sheet Forecasts and RWA due to the macro economic scenario’s in various Stress Scenario’s
• Conduct Review Meetings with the Business Data Submitter to understand missing details of the mapping documents
• Identification of Critical Data Elements and creating the rules around the Critical Data Elements to create automated reports as Critical Quality Indicators
• Select the sample portfolios for each schedule based on the materiality
• Conducting data analysis from Schedule à DataWarehouse à Source System Data
• Conduct the Data Quality Checks on the data to see that the consistency is maintained between different layers of the data flow, Analyse the default values used, validate the data to see that NULLS/Unavailable Data is handled in a conservative approach
• Anchored meetings with various stake holders like Senior Management, PMO, Business Teams, Auditors to report the findings and to get consensus about the issues/gaps identified
• Raise the issues to the Global Issue Tracking Tool to make it more visible to the senior management
• Generate reports and present them to the Regulators along with the above stake holders and provide all the supporting documents required by the regulators and the auditors.

Environment: Informatica 9.5.1, Oracle 10g, MS-Access, MS-Excel, TOAD

Confidential, Newyork City, NY

Sr. Business Analyst

Responsibilities:

• Review the Mapping Documents provided by the Retail Businesses to validate against the Business Requirement Document
• Review of the Mapping Document and BRD to the US Final Rule
• Conduct Review Meetings with the Business Data Submitter to understand missing details of the mapping documents
• Select the sample portfolios for each business based on the products so that most of the products are covered in the process
• Conducted analysis on the Backtesting Data for the development of PD Models
• Conducted Trend Analysis on the PD and LGD for multiple years of data for identifying the data quality issues
• Request Data from the Business Data Submitter from different layers of the data flow i.e., Product Processor à Any Intermediate Layer (Data Marts/Files) à RWA Calculator
• Reproduce the results based on the Business Requirement Documents, Mapping Documents and the US Final Rule
• Compare the results between the Calculated Results with the actual files submitted to the RWA Calculator and conduct gap analysis
• Conduct the Data Quality Checks on the data to see that the consistency is maintained between different layers of the data flow, Analyse the default values used, validate the data to see that NULLS/Unavailable Data is handled in a conservative approach
• Conduct Business Checks to see that data is consistent between multiple months
• Conduct Meetings with various stake holders like Senior Management, PMO, Business Teams, Auditors to report the findings and to get consensus about the issues/gaps identified
• Raise the issues to the Global Issue Tracking Tool to make it more visible to the senior management
• Generate reports and present them to the Regulators along with the above stake holders and provide all the supporting documents required by the regulators and the auditors.

Environment: SAS 9.1.3, Abinitio 3.1.5, Oracle 10g, MS-Access, MS-Excel, TOAD, UNIX

Confidential, Pittsburgh, PA

RWA Business Analyst

Responsibilities:

• Processing OFSAA/Reveleus Processes for various asset classes
• Conducting Data Gap Analysis between EIP (Warehouse) and Calculator
• Worked with DT, T2T, Measures of the OFSAA Data Model
• Review and Suggest fixes in the PL/SQL Procedures
• Providing Support to E2E Team and Development Team
• Analysis of Metadata for Data Quality and some important attributes like Asset Classification
• Participating in the Requirements Analysis with the Test Design Team to help with various configuration related clarifications
• Analysis of the FFIEC Reports against the data from the Source to confirm the data submissions
• Participating in the review meetings with the Audit Team and providing clarifications on the calculations
• Coordinating with the development team to get the code fixes to implement, in case of any gaps identified
• Participating in the sign off meetings with the business teams by supporting the E2E Team for any clarifications
• Involved in analysis on the Retail Pooling to understand the derivation of PD, LGD and Capitals for Retail Exposures
• Extensively worked on different types of Retail Exposures like Residential Mortgages, Qualifying Revolving Credit Exposures and Other Retail Exposures and have a very good understanding of Capital Calculations for each exposure.
• Involved in the analysis of various OTC and Repo Products like FX Derivatives, Options, Swaps, Credit Derivatives, Margin Loans, Repo’s and Reverse Repo’s
• Participated in analyzing the various wholesale exposures with calculations involving SOP03 Accounting Principles, Sovereign Exposures
• Involved in extensive analysis of securitization approaches like RBA, SFA Approached
• Involved in extensive analysis of Equity exposures involving Hedge Pairs and various tier 1 and tier 2 capitals
• Have a good understanding of various attributes like PD, LGD, Effective Maturity, Residual Maturity, Capital Calculations for various asset classes, EAD and RWA
• Extensively worked on various Mitigants like Collaterals, Guarantees & Credit Default Swaps and how the pledging happens.
• Good understanding of the various haircuts and the pd override concepts which have impact on the RWA

Environment: OFSAA/Reveleus, Informatica 8.x, Oracle 10g, Microsoft Project plan, Microsoft Visio, MS-Office, TOAD, UNIX

Confidential, Detroit, MI

Business Analyst

Responsibilities:

• Interacting with the Business Managers and understanding the requirements
• Participating in the High Level Designs
• Creating Process Flow Diagrams and conducting review sessions.
• Participated in the Design Sessions for GL Reconciliation
• Creating the Requirement Documents and Source to Target Mappings for Commercial and Retail Asset Classes
• Coordinated with cross-functional teams in different locations for quality data analysis and articulated these facts into Requirements Capturing.
• Actively Participated in Design Reviews
• Closely worked with the development team providing the required support in understanding requirements.
• Active participant in technology related User Group meetings

Environment: Oracle 10g, Datastage, Microsoft Visio, MS-Office, TOAD, SQL Developer

Confidential, warren, nj

Project Lead/Data Architect

Responsibilities:

• Acting as a Subject Matter Expert for various subjects like Credit Risk Mitigants, RWA Calculations for Standardized Approach & Advanced Internal Ratings Approach.
• Successfully managed the Project Plan for the above projects and prepared the status reports in a timely manner for the review of the top management.
• Interacted with business managers related to the projects to understand the requirements.
• Participated in creating the Business Requirements and High Level Designs.
• Worked with data modeling team in designing the database models, Designed & Reviewed Error Handling Strategies.
• Working in feeding the data to RWA Calculator (Reveleus/OFSAA)
• Actively involved in the High Level Design of the Processes and involved in Technical Design Reviews.
• Worked on Abinitio BRE Tool in creating reformat, filter and join components
• Version Controlling using EME
• Worked closely with the business while creating rules in BRE
• Review the FFIEC Reports and perform the data validations against the Datawarehouse
• Coordinated with cross-functional teams in different locations for quality data analysis and articulated these facts into ETL design approach.
• Designed logical and physical ETL specs for the ETL mappings.
• Worked on designing and building applications to create, maintain, and transform data in support of business processes.
• Responsible for interacting with business users/business analysts for requirement analysis and to define business and functional specifications.
• Created and managed of the Rough cost estimations, solution proposals, work plan, requirement documents, work cases, and technical specifications, source data analysis, data dictionary, source to target document, project plan, and deployment plans confirming to the business rule.
• Performed Code Reviews and provided the feedback.
• Lead and closely monitored the development team providing the required guidance and worked on enhancements and project integration.
• Active participant in technology related User Group meetings and Technical forum programs to keep abreast of latest technological developments.
• Supported the SIT/UAT teams in providing the necessary guidance regarding the business requirements and the development.

Environment: Informatica 7.x/8.x, Abinitio GDE 1.15.9, Abinitio Co> Operating System 2.15.6, Ab Initio Conduct>IT, Flat file, Oracle 10g, Microsoft Project plan, Microsoft Visio, MS-Office, TOAD, UNIX, Autosys

Confidential, Pittsburgh, PA

Technology Lead

Responsibilities:

• Gathered/Analyzed business requirements; participated in data modeling; planning, designing, implementation of the data warehouse and conducted testing. Produced data mapping and data definition, Data profiling documentation. Interacted with ETL programmers, database administrators, project managers and business managers (credit risk).
• Involved in the design of the overall database using Entity Relationship diagrams.
• Worked as an Onsite Co-ordinator and get the work done by the offshore team by resolving daily clarifications
• Used ETL procedures for cleansing the source data coming heterogeneous sources such as fixed width flat files), CSV files, and COBOL files and also loaded using concurrent and sequential jobs
• Extensively used Designer to develop various jobs to extract, cleanse, transform, integrate and load data into Datamart.
• Worked with Manager to import/export metadata, jobs, and routines from repository, and also created data elements.
• Wrote stored procedures and functions in PL/SQL
• Helped in writing proposals, documentation and training, both internally and cross domain teams
• Involved in building, debugging and running forms
• Designing and developing forms validation procedures for query and update of data.

Environment: Informatica Power Center 6.2, Oracle 10g, Microsoft Visio, MS-Office, Flat files, TOAD, UNIX