SUMMARY:

• 7+ years of Industry experience as a Business Analyst wif solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
• Hands - on working experience in Leading Market product such as Charles River and Eagle Pace.
• Strong understanding of banking requirements and regulatory compliances,CCARRegulatory Reporting, Basel II, Dodd Frank Act, Bank Secrecy Act, Customer Identification Program (KYC).
• Extensive noledge about theAML, Patriot Act, BSA, SAR, OFAC, Dodd Frank regulation, procedures and practices.
• Excellent noledge in Asset Management, Wealth Management, Investment Banking, Derivative products. such as Options and Futures, Credit Card, Insurance, Bonds, Sarbanes Oxley Act (SOX),GAAP, GAAS, IFRS, CCAR.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence.
• Strong noledge of the Software Development Life Cycle methodologies (phases and gates) like Agile and Waterfall models.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Experience on CCAR, Basel II, Basel III, Dodd-Frank Regulatory Reporting FR Y-14A/Q Monthly, Quarterly, Annual, FRY9-C, RWA, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
• Expertise in Business Process Management Suite (BPMS), evaluating alternatives, reviewing recommendations wif management, proactively managing change In-depth noledge of Business Modelling methodology and tools such as MS Visio.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in interaction wif the business users to gather requirements based on theCCARRegulation for Financial Statements, Basel II, Dodd Frank Act, Bank Secrecy Act, Customer.
• Online banking application dat enables customers to access their checking and savings accounts, and credit card account using the Internet.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Telelogic System Architect

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Change Management Tools: Rational ClearCase, Rational ClearQuest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, JAD, RUP, RAD, ETL, Informatica 7.1.1/6.5

Testing Tools: Loadrunner, Test Director,Mercury Quality Centre, JIRA

Operating Systems: MS Windows NT/98/95/2000, UNIX

Languages: SQL, UML, JAVA

Database: Oracle 8i/9i, SQL Server 2000, MDM, Teradata,MS Access

Utility: MS Office Suite Word, Project, Excel, Visio, PowerPoint, Adobe Acrobat Suite

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Sr. Business Analyst

Responsibilities:

• Created both data sourcing and functional controls according to BCBS 239 Principles.
• Wrote Data sourcing controls whose purpose was to match similar bucket names wif different feed names.
• Wrote functional controls dat consisted of functional and threshold controls dat were conditional based. dat either the control objective was either met or failed/red flagged given certain buckets.
• Functional controls consisted of Collateral Pool, Mortgage Rating, Mortgage PD, LGD, Guarantor, Lombard, Credit Limit, and Exposure, respectively.
• Threshold controls usually dealt wif periodic controls such as monthly and yearly and dealt wif wifin a 2% threshold of difference.
• Located bucket names for all of the above controls in Toad 12.6 RDBMS by running SQL queries.
• Also, utilized Enterprise Architect 12.1 to locate bucket names germane to controls wifin the WM data model.
• Conducted JAD sessions wif other BA’s dat were based in Mumbai, London, and Krakow, respectively.
• Co-ordinated Master List of all controls in the pipeline off of SharePoint as per quarterly release.
• All types of controls mentioned above were to be placed in different sections in Zeus Control Tool (“ZCT”) by BCBS Principle viz.
• Accuracy, Consistency, and Completeness. ZCT enabled authorized users to look at different internals of Confidential as it pertained to credit risk.
• Was responsible for performing a cash products gap analysis for the Confidential front-end trade order entry system called eTrader in relation to the Charles River IMS 8.1.4.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Developed & executed several Optimized queries in SQL on this data.
• Involved in Compliance of credit risk management and data integrity through regulatory reporting - policies and procedures pertaining to OFAC and BSA.
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Assisted in the business process re-engineering documentation of the cash trading desk to efficiently integrate into Charles River.
• Created and maintained the Business Requirements Document (BRD) while providing walkthroughs for the Line of Business.
• Evaluated Competitors offerings and products including fixed income and derivatives.
• Worked wif dev team to understand and review Java code of certain projects.
• Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
• Provide support toBusinessUnits for Large Currency Reporting (LCR), Anti Money Laundering,ActimizeKYC, SASAML, and Suspicious Activity Report (SAR) Filings.

Confidential, Pittsburgh, PA

CCAR Business Analyst

Responsibilities:

• Worked on documentation of project vision and scope, cost-benefit analysis, management of project budget and making project schedule wif the Project Manager.
• Managed risk-based audits, due diligence and governance of new initiatives and compliance (AML (Anti-Money Laundering),
• Developed good practices for risk modelling procedures related to CCAR/DFAST.
• Assisted in the calibration and validation of Mantas AML scenarios and behavior detection logic.
• Analysis and design of CCAR (FRY 14A schedules of Income statement and balance sheet), FRY 9C (few schedules), report requirements in AXIOM.
• Led Business Analysis and Functional Specification areas to plan and execute various consent order projects, ensuring adherence to regulatory requirements .
• Participated in data modeling, data analysis and requirement documentation.Extensive experience in Financial Service industry related to - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR.
• Generate Actimize process flow diagrams for Transportation and Vendor Finance using MS Visio.
• Extensive use of application TOAD to write SQL queries for data manipulations.
• Responsible for supporting and leading aspects of the firm's Anti-Money Laundering (AML) program.
• Develop and manage project plans, schedules, risk, and projections.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Oversee and manage the funds prime brokerage relationship and relationship wif the funds outside accounting firm.
• Conducted multiple gap analysis against Basel II, II.5 and III rules. Validated Basel II framework, including internal rating systems (PD, LGD, EAD models) and RWA calculation.
• Work experience in Risk Control, DFAST (Dodd Frank), CCAR and other regulatory reporting process.
• Lead on the data sourcing effort for Counterparty Credit, Market and Operational Risk, Income Statement and Balance Sheet Schedules pertaining to CCAR and the FRY9C reporting to FED.
• Created suite of Excel models used monthly for analysis and verification of Basel II results in Production environment.
• Created data model, mapped data elements to their source elements, created ETL transformations necessary to load the datawarehouse.
• Performed analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST)
• Have intimate noledge of the line of business data to ensure Instruction changes have minimal impact to CCAR Schedule.
• Cooperated wif CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
• Participated in preparation of schedules wifin several regulatory reports notably FRY9C, FFIEC, FRY 14Q/M, FRY 14A etc.
• Maintained audit controls for SOX compliance and GAAP accounting and business practices.
• Scope of Regulatory Reports: Comprehensive Capital Analysis and Review (CCAR), FR Y-14M / FR Y-14A / FR Y-14Q reports covering Enhanced Prudential Standards under Dodd-Frank/DFAST, BASEL III.
• Responsible for the successful development and deployment of CCAR model suite for PD, EAD and LGD models.
• Designated POC for Zero Based Budget Review efforts on SharePoint for Portfolio Management.
• Conducted various stress testing followed CCAR.
• Resolved issues and conflicts between different stakeholders, found out proper resolutions to make all stakeholders satisfied.

Confidential, Chicago, IL

Business /Data Analyst

Responsibilities:

• Develop BRD and data mapping logic to 14Q line items and Pre-provision Net Revenue (PPNR) configuration in Axiom,validating the data mapping using SQL developer.
• Reviewed and selected Charles River (CRD) OMS/trading software package via IT standardized RFP process.
• Identify and analyze business problems and defined the scope of activities required to address issues,
• including requirement definition, logics changes, process review, impact assessment and operational streamlining where necessary
• Involved depth understanding of Credit Risk management for the application.
• Responsible for investigating and explaining business drivers underpinning significant financial movements across B/S, fundingand RWA for LOB's, senior management, LEC's, Corporate Reporting.
• Main duties included project management of the Active Equities Trading Charles River IMS (v8.2) integration initiative migrated from Macgregor XIP.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirementsand Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions wif IT groups. Identified the Key Changes, andparticipated in Stakeholder Management to communicate TEMPeffectively wif them
• Involved in preparation of test cases for source to target count testing and other ETL business functional tests.
• Discussed wif SMEs across different businesses units to gain solid noledge of the existing Credit Risk Calculation Systemand assisted in preparing an advanced Risk Assessment and ROI Management.
• Elicited and mapped securities requirements via Bloomberg to Charles River.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users.dat provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted wif Architects, business and other stakeholders and created the Back-End Use Cases for Online Payments project.
• Map business functions underlying data and data models, perform data reconciliations, gap analysis at function and data level forCCAR reporting .
• Create data maps in the FR-Y 9C, 14Q and analyze in detail FR-Y 9C HC-K, 14Q PPNR Schedules to achieve automation process.
• Collaborate wif Axiom developers to link data to Federal Reserve Schedule templates .
• Liaise wif Axiom team to co-ordinate all aspects of testing, including planning, execution and close out of UAT phases wif reporting team.

Confidential -San Francisco, CA

Business Process Analyst

Responsibilities:

• Drove to deliver Statement of Work, High Level Design, Detail Design Document, Systems impact analysis,
• Testing plan reviews, project estimation, solution architecture and continuity of business (COB) setup.
• The system provides enhanced Business Process Management (BPM), new Portfolio Reporting System for High Net worth Clients and Credit Risk Management.
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating wif the PM and technical lead.
• Worked wif FAs and RAs to conduct Credit Risk Measurements like calculation of RWA (Risk Weighted Asset).
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing Agile methodology.
• Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc., and their mapping to the standard analysis mechanism to enable maximum reuse.
• Development of tools designed to improve the accuracy and efficiency of existing accounting processes.
• Interacted wif Architects, business and other stakeholders and created the Back-End Use Cases for Online Payments project.
• Interacted wif users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Wrote SQL statements to extract data from the Tables.
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing (UAT).
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Conducted User Acceptance Testing, gatheird and documented User Manuals and Business Rules