PROFESSIONAL SUMMARY:

• Extensive experienced in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and QA engineers.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Automation UAT.
• Well versed with regulatory reporting and stress testing (Dodd Frank/CCAR, and Basel III), Portfolio Risk (Credit Risk, Market risk across all assets, Facility Risk Rating, Statement Forecasting) and Compliance regulatory (KYC and Customer on Boarding).
• Depth knowledge in financial instruments within investment banking and brokerage environments (Fixed Income, Equity, Capital Markets, FX, Futures, Options, Trading Commodities, Debts)
• Adept at designing business models using UML diagrams - Use Case, Work Flow diagrams and data flow diagrams.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and JAD and JAR sessions. Excellent liaison skills in dealing with different stakeholders and managing business communications.
• Experience in ETL Processing, Data Analysis, Gap Analysis Data Profiling, Data Mining, Data Migration, Data Integration, Data Mapping and Configuration Management.
• Experience in Data Modeling in creating Star & Snow-Flake Schemas, FACT and Dimension table.
• Have exposure in educating internal customers on business systems, rules and procedures as well as working with other analysts and QA team to set priorities and schedules.

TECHNICAL SKILLS:

MS Office (Excel, Word, PowerPoint, Project, Visio, Access, Outlook, Communicator/Lync), MS SharePoint 2007, Lotus Notes, JIRA, SQL Server 2005/2000, Oracle 10g/11g, Adobe CS3/CS2 (Photoshop, Illustrator), HP Quality Center 9.2, Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Sr. Business Analyst/Data Analyst

Responsibilities:

• Supported documentation of project scope, budget and schedule with the Project Manager.
• Communicated with regulatory team to gather business requirements and worksheets. Created user stories based on business requirements with good understanding of stress testing and regulatory compliance standard.
• Worked as data analyst to query database, identified source of data and target data to generate FRY - 14M report for Schedules A to D.
• Identified data requirements with data sourcing team and provided data mapping documents to “Control M”.
• Validated data based on data requirements by running SQL queries and set validation rules.
• Uploaded and maintained the most updated version of Data Mapping into Share Point.
• Confirmed Manual data input templates with Business Users and got sign- off.
• Performed testing phase by providing test cases and identified variances between expecting value and output.
• Created ETL mapping document based on the requirements and performed data quality and data profiling checks for the mapped data.
• Defined and documented Requirements Traceability Matrix to provide requirements to test case linkage for audit purpose.
• Participated in testing of data captured into axiom automation tool during each sprint to verify work product meets stress testing and regulatory requirement standard.
• Liaised between stakeholders and risk reporting team to identify and confirm issues for submission purposes
• Ensured non-functional product requirements are well defined for the development team and other stakeholders

ENVIRONMENT: Microsoft Office Suit (Word, Excel, PowerPoint), HP ALM, SharePoint, SQL Server Management Studio, Axiom, Jira, MS Visio, Tableau, Oracle 10g/11g.

Confidential, San Francisco, California

Sr. Business Analyst/Data Analyst

Responsibilities:

• Conducted and guided JAD and Brainstorming Sessions to gather Business Requirements and worksheets from business users - Regulatory Reporting Team and other SMEs. Documented user stories in JIRA.
• Communicated with all stakeholders and SMEs in all phases, make sure the process were on right track.
• Collaborated with regulatory reporting team and Axiom configuration team to confirm manual data input templates, which could be consumed by Axiom Controller View.
• Worked closely with data sourcing team to identify data sources and target data, documented and analyzed SQL queries against databases and upgrading data mapping documents into SharePoint for automation purpose.
• Performed data validation based on data requirements in data sourcing stage (FTDR) and Regulatory Reporting Data Mart (ESP).
• Led on the data sourcing effort for Retail Schedules pertaining to CCAR and the FRY-14Q reporting to regulatory system; Federal Reserve Bank.
• Analyzed (MDRM) and design of CCAR (FRY 14Q Retail schedules), FRY 9C (HC-L Derivatives)
• Collaborated with Axiom developers to link data to Federal Reserve Schedule templates.
• Created and managed the project schedule, monitored the whole team to complete tasks in timely manner. Recorded issue and work status to represent to Project Managers.
• Involved in documenting detailed Functional Requirement Specification based on CCAR requirements.
• Assisted the data sourcing team to integrate data using ETL tools, and involved in implementing complex Business Objects reporting solutions
• Conducted Data Analysis check like Data Quality, Data Profiling and Data Validation for the available data.
• Created ETL Mapping Document to map the data from source to target destination.
• Participated in Axiom automation UAT. Identified and analyzed variances in the Reconciliation input and output form. Traced data work flow in Axiom.
• Acted as liaison between business users and Axiom configuration team.
• Resolved issues and conflicts between different stakeholders, found out proper resolutions to make all stakeholders satisfied.

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), Jira, SQL Server Management Studio, SharePoint, Tableau, Oracle Database.

Confidential, San Francisco, California.

Business Analyst/Data Analyst

Responsibilities:

• Defining strategy level architectures and system/technology level architectures for Pillar I and Pillar II(including Balance sheet planning, Corporate Stress Testing, Liquidity risk, VAR implementation, EC Credit risk, EC Aggregation and Allocation). 
• Worked with platform owner and model owner to develop solutions for stress testing activities, including enterprise-wide capital adequacy stress tests such as CCAR. 
• Worked with Reporting team to prepare FFIEC reports 
• Analyzed the Basel II Risk Weighted Assets (RWA) classification process to determine key data for RWA and capital ratio calculation.
• Worked with product management to help develop roadmap items related to IRR & FX Risk 
• Designing Balance sheet planning and Liquidity risk framework methodology 
• Involved in implementation of Business user implementation of EC Credit Risk 
• Providing data, application and technology consulting in pre-feasibility and feasibility discussions with IT team members and business partners, 
• Worked with simple complex SQL queries to access the data from database
• Performed Data Quality, Data Profiling and Data Validation for the data to be brought into repository to make sure the data integrity is maintained.
• Created source to target mapping document to bring the data from source to target.
• Preparing project deliverables and documentation as needed to support Architecture-related processes
• Assisted in gathering the business requirements, and creating ETL documents
• Created Data specification document and data specification document, conducted data validation, and profiling.

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), SharePoint, HP ALM, Jira, SQL Server Management Studio,

Confidential, Georgia Avenue Olney, Maryland

Business Analyst/Data Analyst

Responsibilities:

• Gathered the business requirements and detailed design specifications for Pillar 1 & Pillar 2 and Created process manuals for Credit Risk & Market risk. 
• Understood the functionality of the existing systems and designed stress testing activities 
• Designed process manuals for Counterparty Credit risk & Market risk and the overall architecture of the system 
• Creation of data attributes and tables for Traded products and Implementation and customization of RWA calculator
• Managed the end to end build of the Capital / RWA requirements to facilitate regulatory filings under the new Basel II rules
• Designed system components for Pillar 1 & Pillar 2 and generated test Scripts 
• Analysis of Source, existing OLTP system and Identification of required dimensions and facts from the Database.
• Performed testing phase by providing test cases and identified variances between expecting value and output.
• Created ETL mapping document based on the requirements and performed data quality and data profiling checks for the mapped data.
• Defined and documented Requirements Traceability Matrix to provide requirements to test case linkage for audit purpose.
• Defined detailed design specifications for interfaces for BASEL II Credit Risk Implementation. 
• Created ETL mapping document based on the requirements and performed data quality and data profiling checks for the mapped data.

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), Jira, MS Visio, SQL Server Management Studio, SharePoint, HP ALM.

Confidential

Investment Associate

Responsibilities:

• Manage projects in the Credit Risk, Technology and Enterprise work streams within the Basel program by monitoring project status, risks/issues and leading biweekly meetings with all necessary stakeholders. 
• Responsible for valuing equities, bonds and other fixed income securities, and developing investment strategies for managing mutual fund and other investment portfolios.
• Conducted market research on equities of target companies significantly improving investment profitability by 60%
• Created NPV, IRR, discount cash flow, and ROI models for evaluating new products and investments, and provided recommendations to senior management
• Prepared pitch books while working with the sales team to gain new investors and constantly increased the asset under management by 50% yearly
• Served as the technical support for deploying a new asset management software for the company while interacting with the development team
• Re-designed flowchart of operations between market facing units and back office which saved the company costs of duplication of functions.
• Redesigned a comprehensive financial planning process which integrated both front and back office units.
• Managed mutual funds subscriptions processing and payment of redemptions.
• Supported the Controller in month end close processes, schedules and other reports, recorded monthly journal entries and reviewed postings
• Provided timely postings of daily investment transactions which constantly ensured smooth audit queries

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), Oracle ERP, HP Quality Center, Finacle.