SUMMARY

• Over 8+ year of experience in areas of OCC DFAST/CCAR, Basel II/III (Pillar I/II/III), CCAR, bank examiner, regulatory compliance and reporting, with the ability to implement regulatory requirements and work with regulatory source documents quickly assimilating new knowledge even as regulators are asking for more information, increased transparency, and clear accountability putting growing pressure on departments throughout banks.
• Experience in all stages of ERP implementation including Requirement Gathering, Solution Design, GAP Analysis, Customization, Configuration, Testing and Project Coordination.
• Experience in Summarize, analyze and prepare Treasury Report monthly - Credit lines, Debt Maturity and Debt by Region according to USGAAP and IFRS.
• Extensive understanding of Software Development Life Cycle (SDLC) including Waterfall, Agile, Scrum and Rational Unified Process (RUP).
• Experience ofCollibra Data Governance Centreor other data governance orMetadata management tools. Including; metadata management, content on boarding, data stewardship.
• Subject matter expertise inFixed Income, Risk Analysis especially the Custody and Corporate action. Good understanding of Equity, Cash management, Capital market, SWIFT, STP and Credit risk, Derivative Securitiesfundamentals with hands on experience.
• Proficient in reviewing and identifying bank processes procedures that may be impacted by implementation of new data architecture necessary to exceed CCAR data testing benchmarks.
• Significant experience responding to and reviewing Government IssuedRequestforProposals (RFP),RequestforQuotations (RFQ), and Request for Information (RFI).
• Experience on CCAR, Basel II, Basel III, Dodd-Frank Regulatory Reporting FR Y-14A/Q Monthly, Quarterly, Annual, FRY9-C, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
• Experience in various modules of AML such as KYC, Entity Resolution, Compliance Reporting, and Transaction Monitoring.
• Outstanding proficiency in MS Office applications, including Outlook, Word and Excel
• Good knowledge in SQL, practical experience in MS SQL & Oracle databases and share point.
• Excellent Knowledge of accounting principles (US GAAP/IFRS) & methods and ability to apply & adapt established methods to various accounting problems
• Experience in Data Visualization development using Tableau to create complex, and innovative dashboards
• Strong experience in Data Analysis, Data Lineage, Feed Analysis, Data Mapping, Data Modeling, Data Reconciliation, Data Quality, Data Governance, Data Warehousing, Business Intelligence, Data Analytics, ad-hoc data reporting,
• Experience in leading a team to measure transformations, calculations and business processes used in calculation of Basel II risk parameters as well as generation and review of FFIEC 101 Schedules while focusing on testing of derivatives portfolio.
• Experience in Extraction of knowledge and patterns from data, combining Access SQL and Excel VBA programing to assist SBUs in corporate enrollment and financial data analysis
• Experience with VBA, Visual Basic and SQL, with custom Excel automation improving business processes, regulatory compliance and operations
• Experienced in the Financial Industry with exposure to Retail Banking, Capital Markets, Retail Market and Digital Media Market.
• Experience on CCAR, Basel II, Basel III, Dodd-Frank Regulatory Reporting FR Y-14A/Q Monthly, Quarterly, Annual, FRY9-C, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
• Expertise in providing communication briefings to finance leadership and financial analysts regarding the implementation progress of the transition to an enterprise common system
• Expertise in drafting technical documentation such as BRD, FRD, System Design Specification, Requirement Traceability Matrix, Test Cases.
• Experience in facilitating Joint Application Development (JAD) sessions, Rapid application development (RAD) sessions, conducting user interviews and acting as a liaison between the customers, development team and testing team
• 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 with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Knowledge of trends in technology relating to software applications, Good understanding of the organization’s goals and objective

PROFESSIONAL EXPERIENCE

Sr. Business Analyst/ PM

Confidential, CA

Responsibilities:

• Supporting the US Regulatory Reporting Initiative to implement strategic CCAR 14 series and DFAST Stress testing, for Quarterly, Bi-annual and Annual filing cycles, to comply with Federal and other Regulatory boards.
• Analyzed QA data using SQL, SSMS and created data visualization ofKPIusing MS Excel and Tableau
• Working as a Full-Stack Systems Analyst inAgileenvironment on all project aspects ranging from requirement gathering to supporting Business Acceptance Testing (BAT), engaging with Product Owners and stakeholders to drive IT system design.
• Drive decision-making and action ondatagovernancepriorities; ensure timely escalation of roadblocks, risks, & approvals.
• Ensure processes, controls and accounting records are in accordance withUSGAAPandIFRS.
• Led the Analytics & Reporting'sDataGovernanceinitiative, including implementing Collibra.
• Conceptualization, Design and development of Tableau dashboard for sales and marketing team by working in conjunction with the business users.
• Worked on Exchange clearing project ofOTCderivatives for the Frank-Dodd Act
• Identifying and Analyzing Regulatory Reporting Requirements, participate in Strategy definition, Data Sourcing, Data Consumption, Data Analysis, Design discussions, Test support and BAU process definition after implementation.
• Worked on identifying all the Critical Data elements on variousCCARreports and created Data lineage for enhanced reporting standards.
• Coordinate the Data collection of all Actuals & Jump off point data from various Manual data provider for the data not available through the strategic systems.
• Worked in conjunction with other Business Analysts to create end-to-endCCARprocess flows and to identify and manage all Key controls to help facilitate Review & Challenge.
• Designed framework for collection of Projections Data for FR-Y 14A schedules based on the Reporting Line, Line of Business projections.
• Authored and Implemented Edit Check Rules based on Regulator provided Edit check logics, for different filing Form’s Edit check types like Interseries, Syntax, Quality, Validity and Derived.
• Implemented cross form reconciliation among FRY14Q, FRY14A, FRY9C, FFIEC101 and other Capital adequacy reports by developing variance and trend analysis, form balance drill-downs and Management Analysis Dashboards.

Sr. Business Analyst

Confidential, NY

Responsibilities:

• Ensure data integrity and accuracy with other regulatory submissions (FRY 9C, FRY 14A, FRY 14M, GL system, etc.).\Analysis, design, validation and test of Inter / Intra series checks, edit checks, etc.
• In-depth analysis between reporting requirements and available data attributes; coordinate for requisite data gaps
• ManageNetSuiteERPsystem for all administrative work Such as adding/deleting user, Customization, Workflow, Reports & Saves searches etc.
• Involved in creating a data lifecycle governance plan, processes, procedures, KPI's, measurements for data quality, validation, standardization, and roadmaps.
• In-depth analysis between reporting requirements and available data attributes; coordinate for requisite data gap Working as a Full-Stack Systems Analyst inAgileenvironment on all project aspects ranging from requirement gathering to supporting Business Acceptance Testing (BAT), engaging with Product Owners and stakeholders to drive IT system design.
• Identify critical data elements and attributes to populate into the new business metadata tool (Collibra).
• Worked under financial reporting frameworks such asIFRSand USGAAP.
• Provided an Enterprise Level Data Management Strategy and Framework encompassing Data Governance, Data Lifecycle, Data Quality Improvement, Decision Support, Master Data Management, and Metadata Management.
• Responsible for leading process of Data Governance, define, monitor, create, and implement standard.
• Manage team of Business Analysts, developers and testers for successful and timely delivery.
• Experience of working on multiple critical projects in parallel with different project managers with managed and communicated impact on the timelines and deliverables.
• Helping Confidential prepare for CCAR reporting requirements (ex. FRY 14A/Q/M & 9C).
• Writing FRD’s that help drive the design of the infrastructure necessary for the organization to meet new CCAR reporting requirements.
• Participate in the design and development of CCAR reporting for the newly created US Intermediate Holding Company (IHC) and support dry run prep and execution prior to filing.
• Worked on various projects (CCAR, FFIEC102, IHC, LEP, ANC (Alternate Net Capital), Capital Reserve Calculations, Planning and forecasting, transaction level GL reporting, etc.) encompassing Finance, MI and reporting systems (e.g. AXIOM, Datamart, DWH, OBIEE, Essbase, Hyperion, PeopleSoft GL, etc.).

Business Analyst

Confidential, CA

Responsibilities:

• Strong knowledge of Retail Banking - Deposits, Consumer Loans, Commercial Loans, Mortgage Loans, Retail & Commercial Credit Cards, and Securities.
• Contribution to few key projects inside the bank and gained tremendous experience being a part of different teams - IHC, ALM, CCAR, and Risk.
• Established thedatagovernancemodel and managed all delivery teams involved in platform setup, development, quality assurance and visualization development.
• Reported the status and outcomes to client leadership team.
• Created the Enterprise Information Group encompassing Business Intelligence Center of Excellence, Data Governance Working Group, Enterprise Data Warehousing and Master Data Management. Provided strategic vision and direction with operational and business leaders for enterprise information initiatives enabling Executives to make information-based decision.
• Data Analysis for different federal reports (FR Y14A, FR Y-9C, EU LCR, US LCR, US 5G - FR 2052b, FR 2052a), be it Bank level reporting or IHC level reporting structure/content including report principles, layout, schedules, business attributes, data source, lines from Finance, Risk, Treasury, and Liquidity.
• Involved in architecting thedataintegration, created thedatamodel for thedatawarehouse, advised the client on the importance ofdatagovernanceto consistently maintain thedataquality.
• Good Experience with Data analysis, Data profiling, & Data mapping from one application to another.
• Experience with Data warehousing & Data Marts concepts and ETL tool (Informatica) for source to target mappings.
• Worked on gathering and converting data over to Tableau using SQL/SAS/Excel data over to tableau reports and Dashboards
• Account for intricate and complex revenue and analyze developed procedures quarterly according toUSGAAP.
• Experience with preparing Mapping documents for data flow, Business/Operational Flow diagrams, Decision Tree’s & Use Case diagrams using MS Visio.
• Hands-on experience in developing reports, charts and presentations in MS Office & MS PowerPoint. Expertise in identifying, and documenting SDLC artifacts like scope, HLBR, BRD, RTM etc.
• Used Quality Center for Defect Management/Change Requests.
• Write the SQL Queries for Database testing and health checks to validate the Data Quality (DQ rules) from one application to another.
• Analyzed and createdBusinessRequirements and Functional Requirements for 14Q/A Actuals for various schedules.
• Planned, Defined and Designed data based onbusinessrequirement and provided documentation forCCAR.
• Played a title role for retail banking project for Key corp to have a custom tier plan of graded interest, consultingproject from one end to the other using oracle 10g database and generating results as a part of the project.
• Participate in the discussions and technology initiatives in the Equity derivatives platform as a result of Dodd Frank Act and Stress Test (DFAST) such as Central repository, Volcker rule and Comprehensive Capital Analysis Review (CCAR)
• Conducted performance audits to determine the efficiency, effectiveness, and impact of government programs and regulations and prepared visio articles forCCAR, risk management associated with that.
• Establish and maintain strong working relationships across various CitiBusinessunits (i.e., Legal, Compliance, Finance, Operations, Internal Audit, etc.).
• Maintained knowledge of applicable rules, regulations, policies, laws, and guidelines that impact the finance and contract management process.
• Experience in writing and analyzing Business Requirements Document (BRD), Functional Requirements Document (FRD), Request for Proposals (RFP), Return of Investment (ROI), and Statement of Work (SOW)

Business Analyst

Confidential, NY

Responsibilities:

• Expertise in evaluating and managing Basel III Data Attestation agreements and packages to ensure AXP is Basel III compliant as per timelines aligned with regulators.
• Write and execute positive and negative test cases to ensure data originating from data warehouse (Oracle dB) is accurate through to SQL dB in applications.
• UsedAgile, Scrum, Waterfall, or RAD methodologies where appropriate, while managing all phases of the software development life cycle (SDLC).
• Performed data analysis, feed analysis on the staging and data warehouse using complex queries and reporting tools.
• Mapped business functions t underlying data and data models, performed data reconciliations, gap analysis at function and data level for Basel III reporting
• Manage and analyze multiple data reports, raw files perform Data Quality checks and reconcile multiple tracing reports and DQ Score Cards for all legal entities and attributes Tier 1 for Basel III FFIEC 101 schedules.
• Perform UAT testing for automation of the Attestation Package Tool developed by the Cognizant team to improve Data Governance attestation process.
• Identify, develop, document and build changes to Analytical Reporting, Manual Adjustments and other related processes currently associated with Basel II.
• Developed and maintained a reusable implementation plan checklist and work plan, based on lessons learned from previous project launches.
• Facilitated problem-solving sessions within various departments as collaborative effort to resolve business issues that had cross-functional impacts.
• Led a team to measure transformations, calculations and business processes used in calculation of Basel II risk parameters as well as generation and review of FFIEC 101 Schedules while focusing on testing of derivatives portfolio.
• Analyze Risk Authority TM, a Moody’s product, towards readiness for Basel III for different functional requirements like compliance and capital calculations and analyzed the potential areas of improvement in data management processes.

Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Conduct Brainstorming and JAD Session to gatherBusinessRequirements with Regularity and Compliance subject matter experts to have a good knowledge ofCCARreporting.
• Worked with thebusinessusers and with different levels of management to identify requirements, use cases and to develop functional specifications using the Agile-scrum methodology for software development.
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Created source table definitions in Data Stage Repository by studying data sources by importing data from Mainframe.
• Integrated financial data and transaction data from source to target database for creating a central Risk Data Repository as required byCCARreporting regulations
• Conduct Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added in.
• As a part ofCCARmarket shock exercise prepared application mapping for FRY 14Q report.
• Design detailed FRD, and Solution Options Document according to BRD and Basel regulatory requirements using Power Designer.
• Model the detailed design of the system using UML diagrams including Sequence Diagrams, Activity Diagrams and Use Case, and Data Flow diagrams using Smart Draw.
• Identify and assess potential data source of Interest Rate, help the market data team to integrate data using ETL tools.
• Identified and communicated dependencies and potential risks to the completion of the sprints including resources, costs & systems,CCARand treasury management.