EXPERIENCE SUMMARY:

• Strong subject matter expertise and experience in the domains of Banking, Regulatory Reporting, Risk Management, Transaction analytics, Equities, Fixed Income, Financial Statement Analysis, Data mapping & analysis, Reference data, LBO & DCF Modeling, Trade Finance, Corporate Actions, Basel III
• Extensive experience in developing Business Requirement Documents (BRD), FRD), Software Requirements Specification (SRS), Requirements Traceability Matrix (RTM).
• Proficient in developing Business Process Flows, graphical depictions of Use Cases including Use Case diagrams, Activity diagrams, Sequence diagrams, Class diagrams and Collaboration diagrams.
• Strong communication skills in engaging Project Sponsors, Business stakeholders, subject matter experts and Business Users in gathering the intricate workings of business processes.
• Created and maintained project plans, meeting summaries, status reports, risk and issue logs, change management and performed Feasibility, Impact, Cost/Benefit, Gap and Data analyses.
• Developed screen mock ups, use cases, user stories, test scenarios and test cases.
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
• Proficient in using Agile Scrum methodologies, performed roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories and reviewed defects
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Fact and Dimension tables.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for Data warehousing.
• Strong data mapping and data analysis skills - Expertise in MS Excel, MS Access and SQL
• Familiarity with ETL and Business Intelligence tools like Ab Initio, Cognos, QlikView, Tableau
• Passed Level 1 of Financial Risk Manager (FRM).

TECHNICAL SKILLS:

TESTING TOOLS: HP Quality Center, Test Director

METHODOLOGIES: Waterfall, Agile

DATABASES: MS-Access, Oracle, SQL Server, My SQL

WORKFLOW TOOLS: MS-Visio, MS-Office

REPORTING TOOLS: IBM Cognos 10, QlikView 10

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

SENIOR BUSINESS ANALYST

Responsibilities:

• Data mapping for re-platforming from an individual database to an universal database.
• Created Visual analytics in Tableau which are to be productized and packaged to customers.
• Acting currently as the Product Owner / Product Manager for Suspicious Activity Monitoring module
• Liaising with clients and other teams to package the Suspicious Activity Monitoring tool solution to customers
• Created User Stories and features to capture business requirements.
• Managed the team through 4 sprints of 2 weeks each in driving demos, getting features and stories accepted.
• As an interim Product Owner, tracked the backlogs, provided detailed description of tasks and ensured stories are ready for review by team members.
• Prioritized User stories with the help of team for implementation
• Actively participated in Release gates, Daily scrum, Progressive Iteration sessions

Confidential, New York, NY

SENIOR BUSINESS ANALYST

Responsibilities:

Liquidity Coverage Ratio:

• To re-platform the existing LCR reporting from Axiom tool to home built platform.
• Reduced the processing time from 45 minutes to less than 2 min for the whole process.
• Analyzed Federal instructions and translated the rules to 5G reportable attributes.
• Designed rules engine to translate all Federal rules to systems specific rules. This rules engine provided greater flexibility to end users in adding new rules or new functionality
• Designed the User Interface and the logic to populate calculations and the various scenarios in submitting the reports to Federal Authorities.
• Designed and executed test cases in SQL to check the functionality.
• Enchanced the reporting for 5G from 6 Legal entities to 250+ legal entities
• Designed the tables for implementation the enhancements for Intermediary Holding Company (IHC).
• Designed the logic to seggregage entities as Stand Alone, IHC Consolidated, IHC Others etc
• Designed the elimination logic to filter which entities should go into Stand Alone, IHC Consolidated, IHC Other, US Operations reports.
• Designed user reports and thoroughly tested data for all the report types.
• Analyzed Federal instructions, gathered requirements from Business users to classify requirements into Fed defined buckets for all 10 report types.
• Created rules engine to translate FED requirements into ETL specifications.
• Designed all the stages of data from feeds to data warehouse, aggregation and submission layers.
• Thoroughly tested the 5G Reporting by creating an Exceptions Reporting Engine. This report identifies gap between Fed requirements and system output. The engine performs below checks.
• Developed SQL queries to perform below checks.
• Created FEDCON checks with .NET team which performs the final check before submitting the report to Fed.
• Managed and delivered change requests for requirement enhancements as defined by Business users.
• Defined and delivered multiple reports which identifies the gaps between Fed requirements and system output. This report is very critical as any shortcoming in the report is treated as non-compliant.
• Raised and addressed defects in HP-ALM and tracked defects for closure.
• Designed logic to detect variances among reports and auto-generate the opposite side of the variance.
• Designed .NET screens which enable Business users to enter, modify and approve the legal entities on which the 5G will be reported.
• Analysed the Stored Procedures and provided business and systems implementation logic to developers.
• Creation of Functional Specification Documents for multiple sources which are automated. This included creation of mapping documents, documenting business rules.
• Coordinated extensively with the Business users during the UAT Testing.

Confidential, Pittsburgh, PA

SENIOR BUSINESS ANALYST

Responsibilities:

• Worked closely with business owners, end users, cross functional groups, stakeholders of various Banking work streams and source systems to define, gather, analyse specifications for Unfunded Commitments
• Performed Gap Analysis to determine deltas between existing pilot and proposed systems by querying the database for multiple work streams for multiple source systems
• Created complex SQL queries to analyse the data in source systems and assess the quality of solution.
• Prepared FRD from the requirements gathered and matched them to the Logical Data Model
• Prepared data mapping document from Source Systems to destination source system and define the Business rules to populate the data
• Conducting Knowledge Sharing sessions with the Development team and testing team to provide functional aspect of the project and provide the Business rules.
• Created traceability matrix to map Business, Functional, System requirements and test plans

Confidential, Wilmington, DE

SENIOR BUSINESS ANALYST

Responsibilities:

• Tracked 600 Performance Guarantee metrics having a pay-out of $6 Mn and advised Business Process leaders to minimise pay out to the clients.
• Identified and presented analysis on Pre-Cert claims processing which would result in a significant cost saving of $6Mn/year. Designed roadmap to recover $ 10 Mn from prior Pre-Cert claims.
• Created and executed complex SQL queries to obtain the data from the database
• Partnered with global operations leadership to define valid and reliable Key Performance metrics that accurately reflect outcomes and impact on matrix partners.
• Supported data consolidation activities to support global management reporting and analytics through monthly Operational Reporting, Department Dashboards, and Financial Reporting.
• Prepared and presented strategic and day to day operational analytics using IBM Cognos 10 and QlikView to Senior Management to drive changes in behaviours, metrics and performance across business units.
• Consulted with Business owners to translate business needs into Analytics / reporting requirements.
• Performed root cause analysis and corrective action planning with business areas as indicated by trends.
• Designed, built and enhanced data analytic dashboards and reports to support multiple business units.
• Executed the BI Strategy and Roadmap by contributing individually and collaborating with team members.
• Performed key reporting functions by providing actionable data to support decision making analysis.
• Built strong subject matter expertise on the team through BI, data warehousing and functional knowledge.

Confidential, Jersey City, NJ

SENIOR BUSINESS ANALYST / BUSINESS SYSTEMS ANALYST

Responsibilities:

• Worked closely with business owners, end users, cross functional groups, stakeholders of various geographies to define, gather, analyse specifications.
• Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings
• Prepared BRD, FRD, Traceability Matrix and assisted in preparing Technical Design Document.
• Provided functional inputs and provided sign off in creating and reviewing Logical and Physical Data Models.
• Performed and documented Gap Analysis to determine deltas between existing and proposed systems.
• Performed data mapping from Source to Warehouse and then to Mart to on board the data.
• Conducted Knowledge Sharing sessions with the Development team and Testing team to provide functional aspect of the project and provide the Business rules.
• Reviewed the design of end-to-end ETL process from source systems using Ab Initio.
• Facilitated sessions for volume requirements, design reviews and periodic sessions for on-going progress.
• Created scripts in SQL to populate data into Referential tables.
• Investigated and resolved data quality issues across platforms and applications
• Developed Test Strategy, Test Scenarios, Test Cases for SIT and UAT Testing
• Created and executed test cases using complex SQL queries based on functional requirements.
• Prioritized all the business requirements based on criticality, recommended and designated implementation of requirements in phases.
• Worked closely with business owners, various end users to gather and analyse specifications.
• Created BRD, FRD and assisted the Development and Testing teams in preparing Technical Design Document and Integrated Test Plans.
• Developed and Documented User Stories, use cases and facilitated Story Point discussions to analyse effort levels.
• Developed flow diagrams for Business process of the company, UI Wireframes and Mock ups using Microsoft Visio
• Worked extensively through Agile development methodology by dividing the application into iterations
• Prepared end-to-end data mapping document for Development and Testing teams
• Acted as a Single Point of Contact to all the clients, developers, testers on functionality of the application.
• Provided timely status, updates, risk and issues log to the higher management.
• Performed data validation, data integration and backend testing using SQL Queries.
• Identified, gathered and documented business requirements from the business stakeholders and translated them to system specifications.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
• Created BRD, FRD, MDD, Business dictionary and other related business documents
• Created Use Case Diagrams, User Stories, Data Flow Diagrams, Business Rules to understand and finalise the Functional and Quantitative requirements
• Organized Knowledge Transfer sessions with the Development and Technical teams and prepared Traceability matrix to ensure all the requirements have been developed and tested thoroughly.
• Conducted workshops with end users, developers, testers to analyse and rectify open issues and bugs identified during Testing process.
• Created UAT Scenarios, UAT Test cases and UAT scripts and assisted Business users in UAT execution
• Gathered requirements from Tax consultants and Business owners of 11 source systems on calculation logic of Adjusted Cost Basis for variety of instruments involved in the ESA Act.
• Created Use Cases, User Stories, Mock ups, Test scenarios for sign off from Business owners.
• Documented BRD, FRD, Understanding documents of functional logic for each source system
• Prepared blue print for scoping and implementation of the project based on criticality and the readiness of source systems to provide input for calculation of Adjusted Cost Basis.
• Identified tax lots and wash sales to ensure correct calculation of logic.
• Conducted workshops for Development and Testing teams on the functionality of various instruments, their properties and calculation of Adjusted Cost Basis.
• Closely involved in development and testing of the application by preparing test scenarios and test cases to implement the logic as desired

Confidential, Boston, MA

SENIOR BUSINESS ANALYST / BUSINESS SYSTEMS ANALYST

Responsibilities:

• Gathered and analysed requirements from Business users and SMEs and documented BRD, FRD etc.
• Implemented SWIFT enabled Positions and Trades processing system.
• Analysed and processed DVP, RVP, DF, RF trades, Short sales, borrow, lend trades and other security movements / trades, trade cancellation, reversal, settlement, short selling, claim processing & settlement.
• Conducted Knowledge Transfer sessions to Development and Testing teams.
• Prepared Use Cases, User stories to finalise the understanding of functional requirements
• Worked with Testing team in defining Test Scenarios, Test Cases for SIT and UAT Testing.
• Identified, gathered and documented business requirements from the business stakeholders and translated them to system specifications and created BRD, FRD, MDD, Business dictionary etc.
• Created Use Case Diagrams, User Stories, Data Flow Diagrams, Business Rules to understand and finalise the Functional and Quantitative requirements
• Organized Knowledge Transfer sessions with the Development and Technical teams.
• Conducted workshops with end users, developers, testers to analyse and rectify open issues and bugs identified during Testing process.
• Created UAT Scenarios, UAT Test cases and UAT scripts and assisted Business users in UAT execution

Confidential

FINANCIAL/BUSINESS CONSULTANT

Responsibilities:

• Analysed and prepared research reports and presentation materials and performed strategic screening for potential acquisition and partnering candidates.
• Participated actively in M&A auction processes including analysis and review of offering materials, valuation modeling, coordination of due diligence, contract negotiation and integration preparation.
• Worked on various financial models including DCF, LBO, Comparable Company Analysis, Capital Structure, Merger Consequence Analysis (Accretion/Dilution Analysis)

Confidential

CREDIT & BUSINESS ANALYST

Responsibilities:

• Analysed business requirements and created BRD, FRD, test scenarios, test plans, test cases.
• Documented Use cases, Business Rules to finalize functional understanding·
• Acted as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Evaluated credit proposals for corporate and personal credit by MPBF method and estimated the net worth.
• Analysed credit worthiness applications by reviewing financial capacity, repayment capability
• Prepared Credit Appraisal recommendations for approving/rejecting/amending the credit facility limits

Confidential

CREDIT & BUSINESS ANALYST

Responsibilities:

• Performed credit risk analysis, credit limit & drawing power calculations for corporate clients based on stock statements and assessing the hypothecated stock with frequent visits to the warehouses.
• Processed the complete lifecycle of Trade Finance -inland Letter of Credit, Bank Guarantee, Bank lien, clearing systems, bill collections and bill payments.
• Created BRD, FRD, Use Case Diagrams, User Stories, Data Flow Diagrams, Business Rules, Traceability matrix.
• Organized Knowledge Transfer sessions, workshops with end users, developers, testers to analyse and rectify open issues and bugs identified during Testing process