SUMMARY:

• 7 years of experience working as a Business Analyst with a track record of managing complex IT projects in the Financial Services domain.
• Business requirement gathering from various sponsors and stakeholders by understanding business goals and priorities through research, formal - informal sessions, JAD sessions with teams, stakeholders and end users.
• Performing GAP analysis on existing system and suggest solutions for a new system based on business needs.
• Drafting business requirements and functional requirements in the form of BRDs, FRDs, and SRSs etc. with great technical detail to support actual implementation of project. Hands-on experience with MS Visio and use case diagrams for creating data flow/process flow diagrams such as flowcharts, activity charts, sequence diagrams as per UML.
• Ample knowledge of industry regulations in different financial service sectors, i.e. investment services regulations; such as, MiFID, EMIR and GIPS, and international banking regulations; such as Basel Principles.
• Hands-on experience with Investment Management System like Charles River and Credit Risk Management platforms such as Oracle and OFSAA.
• Advanced knowledge of Capital Markets including Equity, Fixed Income, FX and Derivatives domain, Financial Reporting and Variance Analysis
• Specialized in Financial Analysis, Portfolio and Risk Management, Financial Modeling and Forecasting Trends
• Applied experience in Optimization, Cross sectional and Time Series Econometrics and Data Analysis
• Extensive experience in developing and enhancing applications for financial purposes in the advisory sector.
• Team player with excellent interpersonal and communication skills. Technically competent and goal oriented with problem solving skills. Excellent team management and leadership skills. Additionally, great presentation skills regarding communication with both business and technical teams.

TECHNICAL SKILLS:

Project Methodologies: Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Enterprise Architect

Requirement Management Tools: Caliber RM

Defect Tracking Tools: JIRA, HP QC-ALM

Operating Systems: Microsoft Windows XP, Vista7, Windows 10, Mac OS X Lion, OS X Sierra

Databases: Oracle, MS SQL Server

Tools: MS PROJECT, MS Access, MS Excel, SQL, SharePoint, Crystal Reports

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst

Confidential

Responsibilities:

• Followed agile methodology for the project
• Led projects across different streams of the regulations like Trade and Transaction Reporting, Commission Management, Best Execution
• Worked together with Legal and Compliance to elicit requirements from the business in the Fixed Income and Equity space to build a Business Requirements Document (BRD)
• Managed user stories and tracked progress in Jira
• Perform balance sheet account reconciliations, including identification of proposed adjustments, processing errors, and work with other departments to resolve any reconciling item
• Model data using MS Excel, Access, SQL, and/or other data ware house analytical tools
• Identified gaps in the Charles River IMS v 9.7 with respect to MiFID II and EMIR, and provided solutions for solving them by introducing new processes to capture the missing data
• Created a new process using MS Visio to separate Commission charges from Research charges and introducing a trigger to notify when the separate charges for the account reaches the limit
• Introduced a systematic process via SQL to capture data required for Top 5 venue reporting under Best Execution
• Developed and extract definition for the Transaction Reporting space to be submitted to the Approved Reporting Mechanism (ARM)
• Involved in drafting the Request for Proposal (RFP) for selecting the ARM vendor for Trade and Transaction Reporting
• Used HP-ALM for user acceptance tests based on the test plans defined in the design phase

Environment: Agile-Scrum, Jira, Charles River, MS Visio, MS Project, SQL Server, Crystal Reports, HP-ALM

Sr. Business Analyst

Confidential

Responsibilities:

• Delivered enhancements to the FP&A Team responsible for submitting the bank's OCC DFAST/CCAR FR Y-14A Summary Schedules in XML format to the Federal Reserves and OCC
• Facilitated meetings with Head of Stress-Testing and Governance team including the End-to End CCAR Team, Steering Committee, FP&A Team, SME's, Third-Party Vendor (Moody's Analytics), documenting regulatory reporting controls across divisions, curing defects, defining business requirements, vendor deliverables and OCC data dictionary.
• Work with other line of business attachments on initiative of identifying, researching, and rectifying gaps and discrepancies in regulatory reporting application AXIOM SL/ Oracle/ OFSAA Credit Management.
• Was assigned the task of working in the project management team in implementing ETL process for pulling data from various databases relevant to model input data
• Prepared project plan for building ORACLE database and implementing ETL and constantly updated SharePoint site
• Participated in various CCAR workgroups and steering committee meetings; emphasis and execution on process efficiencies and automation efforts
• Create different types of reports in AXIOM/ Oracle/ OFSAA Credit Management Control Report, Adjustment Report, Manual Upload template
• Merging, cleansing, manipulating and loading the data using SAS functions and procedures
• Work with SME's of different groups to gain detailed knowledge of Investments and Capital Market and also to understand the cross impacts of the system
• Ensure the regulatory submission and internal audit requirements were properly gathered and identified from the Subject Matter Entities (SMEs) via meetings, phone interviews, workshops, surveys, site visits, and JAD sessions
• Involve in the design of the User Interface (UI) Prototypes for the internal consolidated platform
• Figure out the potential changes to existing data status, and mapped data from sources to target database using MS Excel creating Risk Weighted Assets (RWA), VaR models and updating automated calculation engine required by regulations
• Perform data validation using SQL queries and implement validation constraints, drew the Data Flow Diagram and Entity Relationship diagram in MS Visio
• Maintain detailed documentation of the BRD, FRD and the User Story using the UML diagrams
• Use roadmap to create the Product backlog, Release Backlog and the Sprint backlog, and keep the burn down chart up to date in a dynamic environment
• Perform business analysis and impact studies, manage the conflict and negotiated the scope and solution by identifying business risk, dependences and constraints
• Develop a detailed test plan and test cases, and track defects in HP QC/HP ALM

Environment: Microsoft Office Suite, MS Project, Smart Draw, MS Visio, Enterprise Architect, Team Foundation Server, Bloomberg, Erwin, HP-ALM, SQL Server Management Studio.

Sr. Business Analyst

Confidential

Responsibilities:

• Worked with lines of businesses to build interface specifications for position feeds. Created design specifications for eligibility filter used by analytical engines to build the data for collateral supply
• Worked on the business requirement document (BRD) and functional requirement document (FRD) while interacting with developers, project stakeholders and QA team
• Coordinated various agile ceremonies such as sprint planning, sprint retrospective and daily scrum meetings and reviewed various reports in JIRA for defect resolving
• Demonstrated knowledge of the Collateral workflow including, exposure calculations, margin management and collateral selection
• Designed process flow diagrams and functional field mapping between Contact and Position System to facilitate analysis
• Extensively executed SQL queries to validate the trade data and reporting
• Created screen wireframes for supply and demand dashboard, work flow diagrams, use case diagrams and sequence diagrams using MS Visio
• Managed deliverables within project timeframe by creating status reports and assisted users in user acceptance testing (UAT), user manual, presentation and training manuals

Environment: MS Access, Star UML, MS Office, HPQC, Jira, MySQL SnagIt

Business Analyst

Confidential

Responsibilities:

• To make sure all the trades get captured and interest rate is not more than four digits, Partial Redemption is included where ever necessary and the interest rate is calculated correctly
• I was involved in group meetings every week with Risk team of the Bank and updating the requirements according to CCAR
• Met with stakeholders and users to review expectations and identify opportunities to improve ROI
• Extensively involved with the trading activities of Coupon bonds, Fixed Income bonds, Derivatives
• Used Agile Software Development process viz. Scrum, as this was a time bound project
• Facilitated JAD sessions with end users, development and QA teams
• Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME's
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting for CCAR
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project
• Responsible for improved service, reduce coding errors, improve consistency, improve profitability, improve cash flow and reduce facultative placement errors through a front-end reinsurance system
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• I also authored functional requirements documents FRD by interacting with development team for improving client's legacy system
• Performed the client reporting and updating of the project on a regular basis
• Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping
• Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations
• Submitted change requests and worked with change request records in SharePoint
• Participated in entering and tracking system defects in Quality Center
• Designed plans for User Acceptance Testing (UAT) and facilitated Post Production Validation (PPV) to ensure all functionalities are meeting the standard

Environment: Jira, SQL, Power Designer, Bloomberg, Windows XP, Silk Central, Oracle, Quality Center, SharePoint