SUMMARY

• Bright, results - driven senior business analyst offers more than 8 years'bankingand financial services experience inregulatoryreporting, liquidity risk management, user acceptance testing and systems implementation
• Comprehensive understanding of liquidity ratios,regulatorycapital and balance sheet substantiation: US/EU LCR, NSFR, 5G, EPS, Basel III, DFAST/CCAR stress-testing, GAAP and IFRS. Experienced with FR Y-9C, FFIEC-101 and FR 2052a
• Successfully delivered projects in IBM MDM (Master Data Management), ERP (PeopleSoft, SAP, MS Dynamics, Great Plains) and Data Warehousing using strong Techno-Functional, analytical and problemsolving skills
• Expert in business process modelling and software development cycle (SDLC), including requirements analysis, system design, development, testing and implementation of software applications
• Experienced in all phases of application development and integration including requirements analysis, functional specification, data analysis, data mapping, test planning, implementation and release to production
• Self-motivated team builder with outstanding time/project management skills who applies superior interpersonal communication capabilities to achieve effective collaboration within all levels of an organization
• Deep understanding of enterprise data warehouses
• Advanced Excel and SQL skills in data analytics, quantitative/statistical modeling and risk metrics ("RWA") calculations.
• Well versed with the agile development framework
• Authored all inception artefacts including Business Requirement Documents (BRD), Use Case Diagrams, Business Rules, Mapping documents & Business Process Design
• Design, develop and implementBIsolutions for reports

TECHNICAL SKILLS

SDLC Methodologies: Water Fall, Spiral, Rational Unified Process (RUP), Agile.

Business Modeling Tools: Microsoft Visio, Rational Rose, (UML).

Testing Tools: Manual Testing Skills, Test Director, and Selenium.

Version Control Systems: MS VSS, CVS, Rational Clear Case.

Project Management: MS Project, MS Office, Clarity, JIRA, Rally.

Programming Languages: SQL, PL/SQL, C, C++, HTML, XML, Visual Basic, (UML), JAVA.

Databases: MS Access/SQL+ Server, Oracle.

Web Technologies: Microsoft FrontPage, Web Creator

Others: MS Windows, MS Office (Outlook/Express, Word, Excel, PowerPoint), Applicant Tracking Systems, Group Mail, UML, TOAD etc.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Business Analyst

Responsibilities:

• Working on a Parity Project to migrate data warehouse used for all the regulatory reporting
• Analyzing the Functional Requirement Documents and High Level Design Documents to provide the testing effort involved. Also involved in the designing activities to understand the data flow of a project and plan the test effort accordingly
• Creating Test Plan document and present to client to get the approvals for the testing effort estimated; further analyzing the Data Architecture Specification document and preparing the Test cases
• Prioritizing and planning Test cases and defects
• Participated in releases and performed Systems Integration Testing and User Acceptance Testing
• Prepared various artifacts for testing such as defect process flow and JIRA report
• Working on General Ledger (GL) reconciliation in Finance Regulatory Reporting Project (FRRP) vs different layers of Enterprise architecture
• Developed automated reports to check the GL balances for all source systems across different environments
• Worked on profiling the production data to identify the different anomalies with respect to CDE’s
• Lead for reporting and process automation initiative across all functions of Finance especially to GL team
• Responsible for preparing various reports and making it available to the Senior Management for weekly working group meetings.

Confidential, San Ramon, CA

Sr. Business Analyst

Responsibilities:

• Worked on a project to create a Regulatory Reporting data warehouse (FARM) to meet reporting and analytical business needs for the BNP Paribas IHC, BHC and Confidential CCAR, 2052A, Basel III, and other regulatory reports
• Delivered Source to target Mapping, BRD, Report Specification Document, System Requirement, Specification Data Analysis and weekly defect status reports
• Performed data gap analysis, data remediation plan for Risk Data Aggregation & Reporting
• Compile a list of all attributes and performed Data conformance all across source system for Loans and Deposits to bring the data into the central data warehouse“FARM” Finance and Risk Data Mart
• Documented BRD and liaison between Business and Technical BI developers to implementBIsolutions for internal Treasury Finance Reporting
• Worked on Change Requests/Design/Source to Target Mappings for fulfilling the requirements indicating Gap analysis

Confidential, San Francisco, CA

Sr. Business Analyst

Responsibilities:

• Provisioning data for OFSAA FSDF from various source systems and analysis of cash flows generated in OFSAA ALM processing area as well as OFSAA LRMS processing area.
• Provisioning data for OFSAA FSDF from various source systems and analysis of cash flows generated in OFSAA ALM processing area as well as OFSAA LRMS processing area.
• Perform Data Analysis and Data Validation by writing complex SQL Queries.
• Gained extensive knowledge on Confidential ’s Different source systems used for capturing and processing cash flow on Mortgage data.
• Perform Data Mapping and Data Profiling to map various source systems to the new Target source system.
• Document and maintain requirement traceability matrix to ensure all requirements are traceable from top to bottom.
• Utilize Quality centre to record, track, update or close any defects related to business requirements or data quality.
• Assist Test team in drafting test strategies and test plans to verify accurately any functionality issues and successful system integration.
• Create Technical specification documents based on the functional design document for the ETL coding to build the data mart.
• Assist in Data Extraction, Transformation & Loading (ETL) Process from source to target systems using Informatica Power Centre.
• Work on daily basis with Lead Data Warehouse Developers to evaluate impact on current implementation, redesign of all ETL logic
• Responsible for making the report available for scheduling or viewing on demand.
• Record project changes on a weekly basis to update plan and provide up to date information for project status reporting.

Confidential, Cranston, RI

Systems Analyst

Responsibilities:

• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, levelled technique for building Business Process Models.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Supported to Controller at cost control process improvement. Elaborated special cost benefit analyses as request to identify on cost cutting opportunities. Prepared integration data for cost reports and cost
• Continually collaborated with developers to deliver Basel required results using the OFSAA/Revenue solution.
• Experience with requirements management, test management and defect management tools like Rally, QC.
• Gathered and validated requirements, resulting in detailed business rules, functional requirements and process design

Confidential

Business Analyst

Responsibilities:

• Used the guidelines and artifacts for the implementation of Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle (SDLC)
• Decluttered Epics into user story and further breaking it down to task in Jira. Responsible in assigning estimation in Epics based on T-shirt size, user stories were estimated in story points and tasks were estimated in hours during the Sprint Planning meetings and Created product backlog by prioritizing the user stories.
• Created Business Case, Business Use-Case Model and Business Use-Case specifications after accessing the status and scope of the project and understanding the business processes.
• Presented user stories on power point to the different SMEs and project expectation during sprint planning meeting.
• Facilitated Kick off meeting, rationalization, project plan, portfolio management, budget and milestones.
• Performed Feasibility analysis, impact analysis, risk and cost benefit analysis.
• Coordinated with Data Analyst in performing analytics for: Healthcare Claims, Healthcare Provider Contract Healthcare payer analytics and Medicaid and Medicare eligibility criteria.
• Conducted JAD Sessions, one to one interviews, brainstorming sessions and focus group interviews to develop an architectural solution that the application meets the business requirements, resolve open issues and elicited information.
• Documentation of the Business Requirement Document (BRD) and functional specifications of the system in the Functional Requirement Document (FRD)
• Provided traceability across the project lifecycle, tracking requirements status, managing changes to requirements and versions of requirement specifications and tracing individual requirements to other project phases and work products
• Worked on SQL queries.
• Assisted in creating Test Plans, Test Strategies and Test cases
• Extensive use of Tableau to design workflow rules and specify related tasks, trigger reporting tasks, email alerts, filed reporting updates to enable business logic.
• Work with business resources to manage detailed business requirements to support Case Management process within the scope of prioritized initiatives.
• Participated in data dictionary management, extraction, transformation and loading (ETL) during data transition from source systems to target systems.
• Involved in data mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored
• Facilitated User Acceptance Testing (UAT) in co-ordination with the business users to identify business requirements recorded the requirements in a format that can be reviewed and understood by both business people and technical people
• Participated during all the phases of UAT testing i.e. Pre-UAT, During UAT and Post-UAT
• Conducts closure of project after the implementation of project as per customer expectations.