SUMMARY

• Around More than 7 years of experience as a Sr.Data/Business Analyst in Federal Regulations, Accounting domain, Equity Derivatives, trading and operations within the financial services and asset management industry with special emphasis on Comprehensive Capital Analysis Review (CCAR).
• As a Senior Business Data Analyst working with a leading investment bank, work with a talented team of engineers and project managers to develop IT Data Governance Solutions to meet BCBS239, CCAR, and IHC regulations.
• Domain experience includes knowledge of CCAR, FRY9C, Equity, Bonds, Loans, Money markets, Benchmark Index, General Ledger, Credit Bills, Credit Reports, and Accounts Receivable/Payable.
• Strong knowledge of the Software Development Life Cycle (SDLC), Agile and Waterfall Methodology.
• Strong technical background and experience importing metadata from heterogeneous metadata sources, preferably using Abinitio Metadata Manager, Collibra, other data governance tools.
• Experience working in Oracle, SQL Server - SSIS, Teradata and DB2 environments.
• Supporting the implementation of data governance metrics and will Provide technical training and documentation in support of metadata policies and processes.
• Used project related tools including Cognos, MS Visio, MS Project.
• Demonstrated ability to bring success within highly critical and visible programs such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Testing (DFAST), which are regulatory requirements and a number one priority.
• Experience working as a business analyst in all phases of the IT Systems Development Lifecycle (SDLC) including, Project Initiation and Planning, Project Initiation Request (PIR), Capabilities Document, Business Case Development, Defining Scope Analysis.
• Knowledge of variousMetadatarepository and data quality measurement tools.
• In-depth experience in creating, driving and leading enterprise level data governance efforts.
• Expertise in gathering and documenting requirements from Subject Matter Experts and business users in the Finance industries for Credit risk, Market risk and regulatory reporting
• Sound knowledge of all Asset classes (Equities, Fixed Income, Derivatives, FX), Financial Statements, FP&A, Portfolio Analysis, CCAR (Comprehensive Capital Analysis Review), Basel I, II & III accords, Dodd-Frank regulations, and Compliance/Risk Management
• Experience in data mapping, data normalization, and reporting capabilities using Tableau Business Intelligence tools.
• Command over data warehousing and business intelligence concepts with emphasis on ETL and life cycle development using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Expertise in project assessment, functional analysis, and requirements gathering; Converting business requirements into BRD, Functional (FRS), Non-functional, User (URS) and the complete System requirement specifications (SRS) documents in a Requirements Traceability matrix (RTM)
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Valuation applications and strong analysis knowledge of the financial statements, financing structures, derivatives, capital management, portfolio analysis, stock valuation, amortization and budgeting.

TECHNICAL SKILLS

Databases: Oracle, MySQL 5.0, IBM DB2 9, MS SQL Server 2000 & 2005.

Database Tools: SQL*Plus, SQL*Loader, MySQL, Toad

ETL Tools: IBM InfoSphere DataStage, Informatica PowerCenter, and MicrosoftSSIS

Methodologies: Agile Modeling, Scrum, SDLC model, Waterfall model, Use Cases, JAD

Business Tools: Visual Paradigm, Doors, Erwin Data Modeler 4x, Business Object (Crystal Reports), MicroStrategy.

Microsoft Product Suites: MS Visio, MS Project, MS Access

Web Technologies: HTML, JavaScript, XML, AJAX, and SOAP

Languages: UML, C, C++, HTML, Java, SQL, PL/SQL, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, McLean, Virginia

Sr. Data/Business Analyst

Responsibilities:

• Managing and updating requirement documents.
• Created SQL Queries for testing the tableau Dashboards.
• Data governance definition and implementation.
• Logical design data models, implement data controls, data quality, change control,metadata, to Enterprise policy standards.
• Perform detailed cost & financial analysis and modeling for balance sheet & income statement accounts.
• Working knowledge and experience with IHC, BCBS239, and CCAR regulations.
• Manually consolidated prior data cleanup efforts into a single spreadsheet to manage themetadata update process
• Performed in depth analysis on credit risk, market risk and operational risk.
• Analyzed Bloomberg Market Data feeds for Equity and Fixed Income related feeds
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Understood trends in financial markets and impact on credit pricing.
• Created the road map for the development of capital, liquidity and enterprise wide stress tests consistent with CCAR and Dodd-Frank.
• Developed and managed project plans, schedules, issues log created and business-technical conflicts.
• Designing and creating key documentation, including data definitions, metrics, and supporting methodologies.
• Designed and implemented near-real-time monitoring Dashboards for Tableau Server and Visualization users
• Identified regulatory and enterprise archiving requirements, risk data quality measurement needs, and performed data classification and implementation strategy.
• Worked with the Business and the E&Y Team to analyze and document the PPNR Historical Data and FRY9C filing to the Federals.
• Conduct financial training and provide assistance, advice, and guidance on Financial Management system CCAR.
• Worked on Informatica Power Center - Source Analyzer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Configured and managed data sources for MS SQL,DB2and Teradata databases.
• Troubleshoot CCAR issues pertaining to releasing documents, managing budgets, new and existing CCAR accounts, CCAR records and allocation.
• Performed Gap Analysis of the "As-Is" and "To-Be" process within the organization (DOT) to analyze and fill the existing gaps in the business processes and participate in business processes.
• Create and updated Dodd-Frank, CCAR and Basel presentations to Firm Management and various regulatory bodies

Confidential, Minneapolis

Data/Business Analyst

Responsibilities:

• Involved in the FRY9C and CCAR Q/M/A data analysis and reporting.
• Awarded for bringing transparency to the end-to-end CCAR and DFAST 14A Stress Testing process through design and build of process maps that were then submitted to the FRB and FDIC.
• Work with risk to select stress tests for CCAR, US Basel and DFAST.
• Involved in the entire project management cycle - project initiation, project planning, project execution, project controls and project close activities.
• Led and managed the development of various analytical tools to capture the data requirements for various regulations (Basel II, CCAR, Dodd Frank etc) and analyze the business impact of acquiring and processing the data for external and internal reporting.
• Identified and documented business needs for new market risk and credit risk module or re-usability of an existing module by performing a GAP analysis.
• Managed projects for Basel II compliance and creating roadmaps for the required projects for calculation methodology, required data and reporting.
• Involved in extraction by DBA into SQL Server or Flat File and plugging that data into Tableau from either flat file or SQL Server.
• Worked with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow to create market risk and credit risk module.
• Responsible for Managing backup and recovery of the domain / Repositorymetadata.
• Create table structures in IBM Cognos Framework Manager from different sources (Oracle, SQL)
• Created Business Rule requirements using JRules for Income Statement and Balance Sheet and also created mockup reports in Cognos for the IT team.
• Created and Designed logical database schema for data warehouse (Teradata) environment to prepare for ETL.
• Analyzed and created requirement for the Sign Convention for different systems to understand how the signs for different Account Class change when flowing from one system to other; and how the data should be reported to the Regulators via Axiom.
• Created a PowerPoint presentation from an Infrastructure prospective to understand all the requirements needed to deliver an accurate Average Daily Balance Sheet for the FRY9C/ CCAR requirements.
• Analyzed and documented the current and the future state of reports related to Credit Risk and different types of securities.
• Involved in analyzing and documenting the Nine Quarter Projections for the CCAR filing.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Conducted Brainstorming Session to gather Business Requirements from Market Risk Group, Risk Reporting Team and other stakeholders (PMEs, Compliance, etc.).
• Analyzed the new regulatory requirements of Basel Accord of all Pillar 1, 2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
• Analysis of corporate balance sheet and income statement accounts with emphasis on 401k wages and expenses.
• Instrumental in performing International Equity Valuation processes to determine Absolute & Relative performance measurement of Equity securities.
• Worked with Quantitative Analysts to design and administrate new Stressed VAR model and Advanced Monte Carlo Simulation method.
• Worked with Risk Reporting Team to generate new Standard Pillar 3 Reporting Framework, distinguish firm-wide global standards within QRM and the unique requirements for the site.
• Create data mapping documents to define required elements on inbound SWIFT, XML or FpML messages, as well as to define the expected data format; specific to OTC derivatives, ETD's, Commodities and FX transactions.
• Create instruction standards onmetadataand data quality process for new employees
• Worked on Equity Models to determine Equity Risk premium using Historical estimates & forward looking estimates like Gordon Growth Model, Dividend Discount Model (2- stage & 3- stage) & Macroeconomic Models.
• Developed the test scripts using SQL for the unit testing.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Worked actively on fixed income securities such as bonds, treasury bills, repos, commercial papers and derivatives such as options contracts, future contracts and forward contracts, also Commodities.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Interacted extensively with SME's including heads in areas of equities, fixed income, derivatives, options, futures and risk managers, asset managers to understand corporate actions, extracting requirements from discussions, and refining and documenting them into Business requirements.
• Worked on a Risk Management System, which supplies users with intra-day and end-of-day speeds, status of modeled bonds, as well as market and credit risk (delta) information.
• Involved in the entire project of migrating reports and cubes from Cognos 7 to Cognos 8.3 and creating project documentation for future use
• Collaborated with capital planning team and other business units in optimizing the stress testing cycle by implementing a robust stress test process.
• Converted existing PL-SQL procedures to ETL code to remove some of the heavy ETL processing from RDBMS to a separate Informatica server.
• Extensively involved with Annuities, Investments risk tolerance and investment objectives
• Performed Valuation models to determine firm specific "Free Cash flow to equity & Free Cash flow to Firm".