SUMMARY:

• 9+ years of experience as a Senior Financial Business and Data Analyst. Area of expertise includes
• In - depth understanding of business processes in Capital Markets with SDLC and SOX Compliance
• In depth expertise in areas - Wholesale Banking, Enterprise Risk - Ops & Market Risk (FRTB), Wealth Confidential Management, Regulatory Risk Analytics and Corporate Banking
• Experienced working in AGILE methodology - Scrum Master and Test-Driven Development
• Expertise in analyzing and reviewing business req. for Requirement Traceability Matrix and Use-case validation
• Performed Backend SQL Data Testing on Oracle, Teradata, Sybase and DB2 database using SQL/PLSQL queries
• Hands-on expertise in creating use cases and utilizing MS Visio to create UML diagrams and MACROS in excel
• Designed use case, activity and class diagrams to extract business process flows assisting DEV and QA teams with req’s
• Knowledgeable in GAAP, GAAS, SEC regulations, Sarbanes-Oxley Act
• Professional hands-on experiences in general and cost accounting, tax and auditing in corporation
• Well organized, logical thinking decision-maker with an analytical, detailed approach to researching and problem solving
• Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the application
• Adept in conducting Joint Application Design (JAD) sessions for requirement, feasibility and risk analysis with various stakeholders, including designers, developers, QA and management to identify critical and high risk areas of the application
• Skilled in conducting Rapid Application Development (RAD) sessions, requirement reviews and system walkthroughs
• Developed data flow diagrams, illustrating the flow of data from systems to Application with checkpoints for verification
• Expertise in writing complex SQL queries using Toad, Teradata SQL Assistant, SQL Server Studio, SQL*Plus
• Expertise with the recon of financials and SOR records against GL, EPM and FP&A
• Taken initiatives in multiple business solution design and reviewed with the business groups and stakeholders
• Expertise in managing requirements through tools ALM, Sharepoint and ClearCase for repository management, ClearQuest for change management and handling change requests through Change Control Boards (CCBs).
• Strong SQL and PL/SQL skills with backend (in both OLTP & OLAP) database for data reconciliation and validation
• Hands-on expertise on data analysis through SAS and frontend BI reports (Tableau, Microstrategy, OBIEE, Qlikview)
• In-depth hands-on experience with OBIEE SQL Queries and usage of Presentation Variables across Subject Areas
• Validation of data by comparing Tableau SQL queries with proc created to recon the data from source systems
• Validation of Metric Calculation in OBIEE against the back-end databases (Teradata, Oracle, Sybase)
• Expertise with Ops and credit risk as per Basel II/III norms and hands-on with OFSAA Run-Rule Framework
• Expertise with various SAS report generating procedures - PROC FREQ, MEAN, TRANSPOSE, PRINT, etc
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Proficient in working with different DBs’ - Oracle, Teradata, MS SQL Server and OS - Windows and UNIX
• Expertise in reconciliation of financial records in Data Warehouse against GL, EPM and FP&A
• Expertise in creating user acceptance test plan for validating the user interface and functionality of the application
• Managed individual test cycles, reported bugs and worked with analysts and developers to resolve problems
• Prepared weekly, monthly OBIEE test validation reports for management reviews and performed weekly scrum meetings
• Expertise in executing test cases and finding defects by utilizing log files on the servers for capturing exceptions/errors
• Strong experience in all levels of Testing such Integration Testing, Functional Testing, System Testing, Regression Testing and User Acceptance Testing(UAT) and Black box testing

TECHNICAL SKILLS:

Database: Oracle, Teradata, MS-Access, Sybase, DB2

Database language: PL/SQL Advanced, SQL Advanced

Reporting Applications: Tableau, Qlikview, Oracle Business Intelligence (OBIEE), Microstrategy, OFSAA and SAS

Scheduler: Autosys, DAC

Operating System: Unix, Windows

Management tools: Sharepoint, ClearQuest, Rational Rose, MS Visio, Rational Clearcase, ALM, RUP, RQM, SVN, Win SCP, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Business System Consultant

Responsibilities:

• Senior Business Analyst in requirements gathering and development in Financial Operations and Technology
• Particular strengths include extensive trading systems implementation experience with multi-products and LOBs’.
• Manages, compiles and maintains documentation and submission to authorizes for the regulatory reporting
• Interaction with LOB users and assisting them with problem solving for various critical issues incl data recon and reporting
• Involved in on-boarding of LOB users in RDR along with planning and strategizing through a 24 hr clock project plan
• Prepared strategic trend reports with the latest processing of the various SORs’ by working on the processing trends
• Hands-on expertise with user role based application GLOSS - General Ledger Online Security system
• Users request specific roles to an application and if their request is approved are granted access
• Translating regulatory requirements into practical workable plans and communicates to the teams
• Prepared systematic reports to be presented to the users for "what to be expected" in terms of reconciliation and data processing through the critical period of month end closing by considering the various business rules for the various SOR's
• Analyze views capturing availability and accuracy of data on a monthly and weekly data used by the downstream
• Engaged in the special year-end tasks to avoid untoward scenarios during the critical time of year-end testing
• Providing analysis for the manual workarounds to be done before the releases by logging Problem tickets
• Expert is using tools like OBIEE, JIRA, ALM, Sharepoint, MSProject, one-note, etc

Environment: ALM, OBIEE, JIRA, Teradata, SQL/PLSQL, Oracle, MS Visio, TOAD, Unix, SVN, Sharepoint, MSProject, Macros, one-note

Confidential, Stamford, CT

Senior Financial Business Analyst

Responsibilities:

• Handle all accounting and tax matters, including AP, AR, fixed assets, credit, GL, payroll, loans, payroll tax, business tax, property tax, franchise / income tax
• Responsible for cash flow; close books and prepare financial reports for monthly and yearly.
• Participate in financial strategic planning, prepare budget and forecasts
• Handle owners capital equities accounts, review of budgets vs. actual to ensure accuracy.
• Develop internal control system, recommend areas for improvement both financial and operational, and establish new accounting policies and procedures.
• Use financial know-how to improve profits and operations, reduce costs, and develop strategies for the company.
• Created product roadmap for the various SCRUM and releases throughout the SCRUM lifecycle in Agile methodology
• Conducted JAD sessions with the stakeholders, end users and SMEs’ to determine the critical business processes and identify key functional requirements for Oracle Financial Analytics Application adhering to the Banking Industry practices and FDIC guidelines
• Documented business requirement for better understanding of business processes and projects using Agile methodologies
• Developed Test Plans which include testing overview, approach, strategy and complete scope of testing and assisted in developing the test strategy based on project quality and testing goals
• Involved in GAP Analysis and Technical Feasibility study with the technical leads and other SME's
• Worked in various roles and teams during the project in activities System Testing and User Training for Business Process Mapping and prototyping, gap analysis, solution design
• Identified the Use Cases and documented the product requirements and the workflows of the As-Is process and the To-Be process in the textual Use Cases for Reporting in OBIEE
• Reporting on the data provided by OFSAA BASEL II/III for Operational and Market Risk
• Created various UML models like Use Case diagrams, Activity Diagrams and State Diagrams in MS Visio
• Conducted requirement review sessions with the Stakeholders and business and end users to ensure product verification
• Created Software Test Plan, develop test cases/scripts for Integration, Regression and User Acceptance testing
• Analyze requirements during the requirements analysis phase of projects and escalate concerns
• Created Requirement Tractability Matrix to ensure complete coverage of requirements and to identify all test conditions
• Keep track of the new requirements & Change Requests for the Project
• Extensively worked upon the data for Equities and Options Trade Clearing systems reconciliation
• Performed the Back end testing by using SQL queries and verified the data integrity in source systems - EBS and EPM
• Act as a point of contact between Dev team and Requirement team
• Track and report upon testing activities, including testing results & defects
• Wrote SQL/PLSQL Queries using TOAD, SQL Developer to validate the data in Oracle database
• Log project related issues in the defect tracking tool identified for the project (ALM)
• Check for timely delivery of different milestones, Identify Training requirements and forward it to the Project Manager
• Performed Functional and UAT testing before the system went live
• Participating and leading daily Scrum meetings and bug triage meetings
• Tracking progress based on requirement traceability and process metrics trending
• Review Functional design and process design documents as well as communicate with implementation team as necessary
• Verify and ensure that the system has been configured and built to support the business process requirements
• Identify and correct defects and system deficiencies prior to 'Go Live'
• Execute test scripts within the Oracle EBS application and document actual results for data recon
• Work with the Business Process Owners / Developers to resolve any issues that arise out of the testing process

Environment: Data Recon, Oracle E-Business Suite, SAS, ALM, OBIEE, OFSAA, Rational Rose, Oracle, Sybase, Teradata, MS Visio, TOAD, Unix, SVN

Confidential, Salt Lake City, UT

Wealth Management

Responsibilities:

• Worked with Project Managers in Project Planning, Project charter and scheduling and kick off through waterfall model
• Interacted with SMEs and stakeholders for business requirements to get a better understanding of the business processes
• Played an active and leading role in collecting, analyzing and documenting business requirements, business rules and technical requirements of the different Financial dept., business and technology groups within the bank
• Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, CurrencyForwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes
• Analyze FIX trading flow, instantly reporting problems and important trading events and activities by monitoring the content in online/real time or offline mode.
• Prepare Process Flow Diagram for Business Requirement Document using Rational Rose
• Modeled the detailed design of the system and created Use Case Diagrams
• Provided status reports with the project team to track progress against plan
• Facilitating the JRP and JAD sessions, brain storming sessions with the Business Group and Technology Group
• Documented Requirement Traceability Matrix (RTM) and implement UML modeling, activity/data flow diagrams
• Analyzed test data to detect significant findings and recommended corrective measures
• Designed the Requirements Traceability Matrix (RTM) using Rational Rose to trace the relationship between business and functional requirements to test cases and achievement metrics on an ongoing basis for keeping the project team informed on the progress report of the project
• Provided SharePoint updates with project documents and keeping track of project status on SharePoint
• Develop and maintain comprehensive test cases and procedures for all aspects of verification
• Validation of over 100 reports built in Qlikview and Microstrategy for business users spread out across US and UK
• Review Functional design and process design documents as well as communicate with implementation team as necessary
• Manual testing of reports built in Microstrategy and in-memory analytics reports built out of memory in Qlikview
• Work with the Business Process Owners / Developers to resolve any issues that arise out of the testing process
• Coordinate with end-users to schedule and support User Acceptance Testing (UAT)
• Utilize Rational Quality Manager (RQM), Rational ClearQuest, Rational Rose and SharePoint as Project Management Tools
• Log project related issues in the defect tracking tool identified for the project (Rational ClearQuest)
• Utilizing Rational Quality Manager (RQM) and SharePoint for documenting test results
• Developed test strategy to meet the requirements and deadlines for each quarterly releases

Environment: SAS, Qlikview, Microstrategy, UML with Rational rose, Sharepoint, SQL Developer, TOAD, Rational Clearquest, Oracle, Teradata, Putty, WinSCP, UNIX