SUMMARY

• Experienced in planning, managing, and controlling resources to achieve specific application workflow in finance domains such as Investment Banking, Retail Banking, Commercial Banking, and Infrastructure projects.
• Thorough knowledge in the SDLC processes and methodologies such as Agile and Waterfall while using Agile Scrum methodology extensively to manage projects.
• Competent in extracting, documenting, organizing, and tracking the Business requirements by creating Business Requirement Documents (BRDs) and Functional Specifications Documents (FSDs).
• Adept in Requirements Engineering and describing them in Hierarchical Task Analysis, Task Descriptions, Data Flow models & Data Diagrams.
• Proficient in conducting Joint Application Development (JAD) and Joint Application Review (JAR) sessions to develop systems focusing on business requirements.
• Worked on Gap Analysis extensively.
• Strong skills of working autonomously and in a team environment while building & preserving strong relationships with senior and junior business sponsors and technical specialists, adhering to a delivery focused approach while managing business expectations.
• Facilitated User Acceptance Testing (UAT) with business users.
• Skilled in Solution Architecture, Enterprise Data Architecture, Data Quality, Master Data Management, Business Systems Analysis, Data Governance Framework, Business Intelligence, and Data Warehousing.
• Strong Analytical and Problem Solving skills.
• Excellent planning and multi - tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises to make critical decisions.
• Excellent communication and presentation skills.
• Good judgment skills to access high risk areas on which to focus testing efforts and analyze business processes to suggest improvements.

TECHNICAL SKILLS

Methodologies & Tools: SDLC, UML, Use Cases, Class Diagrams, MS Visio, HP Quality Center, MS Word, MS Excel (V-lookup & Pivot Tables), MS PowerPoint, MS Project, Business Objects, TFS, SAP, JD Edwards, Informatica, IBM Rational Doors, SSIS, SSAS

Industry Knowledge: Detailed understanding of various securities; Equity, Fixed Income, Derivatives; Securities Trade Processing; Payments and Transaction Processing (ACH, SWIFT, etc); Insurance

Regulatory Knowledge: BASEL(- I, II, & III) & Risk Management (Credit Risk &Market Risk), CCAR, GAAP, SEC, FINRA, CFTC

Bug Tracking/ BI Reporting Tools: Rational ClearQuest, SSRS, OBIEE, BI Publisher.

Database: Oracle, MS SQL Server, MS Access, Teradata SQL

Operating System: WINDOWS, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Business Systems Analyst

Responsibilities:

• Supported data quality initiatives for MDM project by performing data quality using Informatica as the primary tool as well as Excel and Teradata SQL. Applied DQ rules by creating expressions and queries in order to source data in to the warehouse.
• Effectively trained new data quality analysts in DQ initiatives and Informatica analyst.
• Effectively communicated with business SME on reference data in order to create reference data repository with primary intention to support MDM and EDW. Regularly organized meetings with SMEs and created documents for Surveys.
• Supported Informatica Proof of Concept (POC) for Enterprise Reference Data domain by creating a BRD and analyzing and providing data for POC. Effectively engaged in regular meeting with working group and outside clients.
• Supported a project with focus on creating an enterprise wide products catalogue by gathering requirements through communicating with business SMEs and Working Group (WG). Supported the project by products mapping across different domains and identifying necessary products to support business.
• Supported CCAR reporting project by creating data flow models and lineage for FRB(federal Reserve Board) codes.
• Served as a Subject-Matter-Expert for a Master Data Management project.
• Used waterfall methods extensively on data warehousing projects.

Confidential, Charlotte, NC & NJ

Business Analyst

Responsibilities:

• Met with Credit Risk and Market Risk Analysts and Loan Officers to gather Credit Approval Process and Reporting Requirements for Credit Cards, and Asset Based Lending Products, according to the Basel II compliance guidelines.
• Engaged and collaborated closely with the appropriate Business Subject Matter Experts for understanding the Business Processes behind the Small Business Loans and Credit Cards from Loan Origination and Collateral Management to Account Maintenance and Settlement.
• Actively engaged and collaborated with Developers, QA team, and other stakeholders to discuss deliverables, timelines, risks, and issues.
• Actively collaborated with Business users in the UAT phase to reconcile the reports from the old system with a new system by building appropriate test cases and test scenarios.
• Worked with Front Office and Middle Office Users to gather and analyze Reporting requirements; Formulated Business Rules for Securities Transaction, Position, and Sales Reporting of various Trades including Fund Trades, Equity Trades, Fixed Income Trades and Derivative Trades for the Institutional Client Group.
• Worked on various Market Data/Reference Data sources such as Bloomberg and Reuters for sourcing trade related data in the Security Master Database about various financial instruments in the portfolio.
• Gathered requirements for automating the process of creating Fact Sheets, Shareholder Reports, P&L and Balance sheet reports, liquidity ratio, solvency, profitability and efficiency ratios by understanding the Current Process, brainstorming the proposed new design with the Marketing Team of the Reports, and then analyzing data points for Performance, Risk, Portfolio Holdings, and other information required from various data sources consolidated into Eagle PACE..
• Developed Source-To-Target Mapping for the Data Mart incorporating various Business Rules.
• Performed Data Analysis for profiling of current state of data in the Data Warehouse by performing Data Analysis using SQL Queries and Excel.
• Involved in a Project for Data Quality Initiative in compliance with Sarbannes-Oxley Act.
• Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue.

Confidential, Newark, NJ

Business System Analyst

Responsibilities:

• Interviewed client employees and application owners, users to gather information, understand the user’s needs, define requirements, and develop functional specifications for web portal.
• Participated in Join Application Development (JAD) meetings with the domain and technology specialist to collect and define user requirements.
• Participated and led sprint planning meeting to prioritize and determine level of work for PBIs in line with Agile Scrum methodology
• Worked directly with Portfolio Managers and Product Managers to understand the current process for reporting and marketing.
• Gathered requirements for automating Fact Sheets, Shareholder Reports, and Web Site by analyzing data points for Performance, Risk, Portfolio Holdings, and other information required from various data sources including Trading Systems like Charles River and Market Data/Reference Data sources.
• Worked with Front Office Traders and Portfolio Managers to Validate Market Valuation/Pricing and performing Data Analysis using SQL Queries and Microsoft Excel on various Equities, Derivatives, and Fixed Income Securities. This included validating various Bond measures like Yields, Coupons, Total Return for various Funds, and the Internal Rate of Return of the Bond Portfolio.
• Performed Mutual Fund Structure analysis by analyzing data in Eagle PACE for establishing relationship between various entities like Fund, Share Classes, and Portfolios.
• Validate Mutual Fund Performance information by testing and creating Reports using Oracle Business Intelligence Suite (OBIEE) to be sourced into Eagle Pace and then performed Gap Analysis of data required on various reports.
• Analyzed performance, designed, developed, implemented, and maintained Enterprise Data Warehouse (EDW) production processes. created current and Future Process Flow Diagrams, performed Gap Analysis, and presented the same to Management using Microsoft PowerPoint
• Directed and guided Development and Quality Assurance teams.
• Lead the development and QA team in terms of prioritizing of tasks, creating milestones, providing business context to development efforts, and preparing test cases and test scenarios.

Confidential, Reston, VA

Business Analyst

Responsibilities:

• Interviewed client employees and application owners from different business lines to gather information, understand the user’s needs, define requirements, and develop specifications.
• Participated in Join Application Development (JAD) and Rapid Application Development (RAD) meetings with the domain and technology specialist to collect and define user requirements.
• Assisted in the development of quality assurance activities including Quality Assurance Plan, Product Acceptance Plan, Test Plan, and Test Cases.
• Conducted detailed study of existing database and worked out a detailed migration plan for transforming disintegrated database from multiple platforms in to single integrated data source.
• Extracted data from different sources such as flat files, access, MS SQL & Oracle relational databases and processed data to upload in to the target database.
• Used Excel to create Macros and record Macros using VBA.
• Created data model that visually represents the nature of data, business rules governing the data, and how it will be organized in the database.
• Interfaced with the developers to provide support and resources needed to resolve domain and technical issues.