Sandeep Pathak

adavgi@r.postjobfree.com

Visa H1

Current location Stamford, CT

Looking for C2C position only

Professional Profile

A Business Analyst/Project Manager with over 11 years of experience in Business Process, Business Analysis, System Analysis, Data Analysis and Regulatory Reporting (CCAR Stress Test), BEAT Tax Reporting and Project Management

Experience working on Large Bank Regulatory projects specializing in Dodd-Frank Act (DFA) CCAR Stress Testing, Volcker Rule, BCBS 239 compliance & most recently BEAT US Tax Implementation

Hands on experience of Data Sourcing, Data Reconciliation, Data Quality, Data Analysis, Requirement Analysis, Business Modeling, Master Data Management and Use Case Development using UML methodology

Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process such as Agile Software Development using Scrum and Tools used during various phases of SDLC

Excellent business writing skills in developing Business Requirement Documents (BRDs), Use Case Specifications, Functional Requirements Specifications (FRD), Workflows

Extensively worked on all phases of Data Warehousing project like Data modeling and conversion for data staging & Data Mart, ETL, Indexing, Quality Assurance, Data updating plan and Data presentation to business users

Professional Experience

Credit Suisse, New York NY Aug 2017 – Present

Sr. Business Analyst / PM

Current Project

Lead the Reporting & MI work stream within the BEAT (Base Erosion Anti- Abuse Tax) project and responsible for gathering business requirements for BEAT

Worked with the System Architectures to create / conceptualize the Architecture Design and Systems Data flow for BEAT

Created Dashboards as PoC (Proof of Concept) using PeopleSoft GL Data by utilizing SQL and fetching data from FDH (Finance Data Hub)

Performed extensive data analysis using HUE big data tool to analysis PNL (Profit and Losses) data needed IHC and Branch

Worked with the Data sourcing team to identify the critical data elements needed for the Numerator and Denominator Line items for BEAT

Responsible for Analysis, standardization, lineage, remediation of FDH (Finance Data Hub) critical data assets, in alignment with regulatory and compliance directives

Creation of Data Dictionary for all the CDE (Critical Data Element) needed for BEAT within the MDM systems

Previous Project

Responsible for defining requirements for MIS Reporting in Balance Sheet DataMart (BSDM)

Worked on enhancements related to the MIS Balance Sheet Netting and reallocation process for FRB, FINMA & PRA

Identified existing Production issues / defects with the system and proposed changes / solutions to fix the defects through release cycles

Worked on Gap Analysis of existing data models for both CCAR FR-Y 14A and BSDM

Worked in conjunction with BA from CCAR team to provide Jump off point for Quarterly Balance Sheet by Line of Business from BSDM

Created reconciliation framework for reconciling average daily balance sheet data between MIS Balance Sheet and PeopleSoft GL Balance Sheet

Responsible for defining the scope of quarterly BSDM release by working with IT PM on timeline and resource requirements

Created Test strategy along with the UAT test plans used for testing the system enhancements by the business users and supported them throughout the testing cycle

Mizuho Bank, New York NY Jan 2017 – Aug 2017

Business Analyst / Sr. Data Analyst

Identified mapping between FR-Y 16 DFAST stress test report to FR-Y 9C IHC report and created a mapping document

Responsible for identifying data sources for FR-Y 16 DFAST stress test report

Created a comprehensive framework to capture Actuals and Projections data for FR-Y 16 report.

Responsible for creating Critical Data Element (CDE) needed to support the projections process for FR-Y 16

Worked on L2 process flows for end to end DFAST stress testing process starting all the way from T0 data sourcing to Report submission

Credit Suisse, New York NY Jan 2015 – Dec 2016

Business Analyst / PM

Responsibilities

Created a comprehensive Actuals & Projections Metrics capturing all the attributes necessary to facilitate CCAR stress test for 14A Projections including Line of Business projection.

Designed framework for collection of Projections Data for FR-Y 14A schedules based on the Reporting Line, Line of Business projections.

Defined Business / Functional requirements for sourcing of Actuals data for FR-Y 14A from various FED reports like FR- Y 9C, FR-Y 14Q & FFIEC 102

Worked on identifying all the Critical Data elements on various CCAR (Stress Test) reports and created Data lineage for enhanced reporting standards as part of Master Data Management (MDM).

Implementation & execution plan for Reconciliation across Regulatory reporting example FR-Y 9C, 14Q, 14A within Axiom.

Also responsible for working with Line of business functions to capture the Business requirements for Regulatory & MIS reporting.

Responsible for creating mappings and bridging the gap between MIS & Regulatory reporting views to facilitate review & signoff process.

Worked with a number of change functions within the organization to capture business /data requirements to support Line of business projections.

Coordinate the Data collection of all Actuals & Jump off point data from various Manual data provider for the data not available through the strategic systems.

Worked in conjunction with other Business Analysts to create end to end CCAR process flows and to identify and manage all Key controls to help facilitate Review & Challenge.

Royal Bank of Scotland, Stamford CT June 2013 – Dec 2014

Business Analyst Lead

Responsibilities

Delivered high quality functional, technical requirements (FRD) based on the proposed Volcker Rule for qualified Fixed Income products.

Developed detailed analysis, utilized analytics by reviewing the proposed & final Volcker Rule metrics to define the regulatory reporting requirements for Market Risk, Finance metrics

Facilitated focus group discussion with front office, middle office and internal regulators to collect feedbacks on the final Volcker metrics report design

Created data mapping and business rules logic for Comprehensive PnL Attribution data sourcing data from various Data Warehouses.

Worked with the internal regulators to elicit requirements for Volcker Reporting of Quantitative Measurements

Identified the gap between the proposed rule and the final rule to estimate the impact of implementing required changes through Change Request in JIRA.

Set up definitions and process for test phases including Reports test, integration test, system test and user acceptance test (UAT)

Performed Data Analysis from both front end and back end using SQL queries. Also worked with Data Architect to define the Data Dictionary for the Data Warehouse.

Beazley, Farmington CT April 2011 – May 2013

Sr. Business Analyst

Responsibilities

Facilitated collection of Functional Requirements from system users, and prepared Business and Technical Requirement Specification documents.

Worked with Quality Assurance Team to log all relevant defects in Mercury Quality Center(QC)

Functioned as the primary liaison between the business line, operations, and technical areas throughout the project cycle

Maintained requirement traceability from Initiation phases to Construction phases and managed version control on documentation

Designed and implemented basic SQL queries for QA testing and report / data validation

Conducted System Integration Testing and facilitated User Acceptance Testing (UAT) to provide a smooth transition to the new system/application

Hands on experience writing SQL queries for data analysis and data quality and have prepared data mapping specifications and data dictionaries used in ETL processes

XL Insurance, CT May 2008 – Mar 2011

Sr. Business Analyst/Release Manager

Responsibilities

Worked on Insurance Data Warehouse (IDW) responsible for gathering requirement for the new development along with supporting and enhancing the existing Production Environment

Launched the business requirement collection approach for streamlining the Claims Processing System

Worked with the ETL development team & Cognos reporting team for data migration & User Reports

Performed Gap analysis for As-IS and TO-BE system

Assisted testing team with developing System Test Plan based on the Business Requirements

Was a Release Manager on the Underwriting WorkStation responsible for successfully deploying the monthly rate release by following the conventional SDLC process for each individual release

Responsible for identifying, developing and completing the Release Definition, Release Implementation Plan for the Rate Releases

Wells Fargo Home Mortgage, IA January 2007 – April 2008

Requirements Analyst

Responsibilities

Created a new project in ReqPro and maintained all BNF (Business needs and Features) items, Requirement Artifacts (Use Case, SRS and BRD), Design Documents (HLD, DDD), Build Notes and Test Scripts

Created and maintained Traceability Coverage

Hosted weekly Change Control Board (CCB) meetings to discuss change requests and their impacts on Scope

Generated Reports using both MS Access and Crystal Reports for Project Managers to help them with Change Management

Assisted Design Analysts with creating Use Case Models and Object Models in Rational Rose

Professional Skills

Methodologies: RUP, Agile, Waterfall

Requirement Automation Tools: RequisitePro, Enterprise Architect

Change Management Tools: Rational Clear Quest, JIRA, Mercury ALM

Business Modeling Tools: RequisitePro, Rational Rose, Microsoft Visio.

Databases: Oracle 10, MS SQL Server 8.0, Sybase DBMS, MS-Access

Version Control Tool: Rational Clear Case, SharePoint

Project Management: Microsoft Project, Microsoft Office

Education

MS in Computer Information Tech, Central Connecticut State University, CT

BS in Computer Science, Vishveshwaraiah Technical University, India

Contact this candidate