SUMMARY

• IT professional with over 15+ years of experience mainly in financial domain. Expert in Business Analysis, Project Management and Agile Scrum execution in enterprise environment with focus on client value addition
• Technologist, highly proficient in requirement gathering and documentation, software testing, defect triage and SDLC (Waterfall and Agile Scrum) implementation.

TECHNICAL SKILLS

Software: Microsoft Office Suite, MS Visio, MS Project, SharePoint, ALM, Confluence, Jira and Rally.

Databases and Big Data: Oracle, Data Warehouse, Business Intelligence (Tableau), ETL (Informatica), and Hadoop.

Programming Languages: Java and SQL.

PROFESSIONAL EXPERIENCE

Confidential

Technical Business Analyst/Project Manager

Responsibilities:

• Developed the Business Requirements and Specification Document to migrate over 90 Global Exchange Feeds (EMEA, AMER, APAC) from ETD Hub to PME/Fusion database system covering all assets classes - Equities, Derivatives, Fixed Incomes, Spreads, Warrants, Tick Scales, and Vendor feeds (Bloomberg and Reuters)
• Produced project artifacts, including Communication Plan. Tracked and managed Risk, Assumptions, Issues, and Dependencies items successfully through proactively logging and follow-through in collaboration with stakeholders.
• Used Microsoft Project to create project plan and associated milestones. And successfully updated and maintained project schedules.
• Analyzed attributes and database objects for reconciliation in respect of Population, Attributes and Client’s Data as part of MIFID II Regulation for Reference Data organization by making all assets complaint prior to January 3, 2018 effective date.
• Created and presented weekly project status reports to stakeholders including project sponsor and upper management highlighting Risks and Mitigation actions thereof.
• Used SQL to query ETD Hub databases and Produced complete set of attributes by regions.
• Performed Mapping of Raw Data File through RVR process and TNT (Transformation, Enrichment and Reference Data) to produce Golden Copy for client consumption PME DataMart or PME API.
• Successfully used Agile techniques of TDD and Continuous Integration to improve team performance and quality of sprint increments.
• Analyzed and produced list of Objects in ETD Hub and corresponding PME/Fusion that were loaded into Helix (Hadoop) for reconciliation of the two systems.
• Analyzed feasibility of Business Case, produced User Stories, budgeting and time estimation schedules in MS Project, and associated Risks and Mitigation action plans.

Environment: Java, Unix, ETD Hub, PME/Fusion, Reference Data Quartz, Oracle 12c, Data Warehouse, Hadoop, SQL Developer, ALM, Agile, Tableau, UML, MS Visio, MS Project and Jira.

Confidential

Technical Business Analyst/Project Manager

Responsibilities:

• Created Functional Specification to capture Business Ask based on interaction with Broker/Dealers, Account Management, Compliance, Regulatory, Product Managers and external clients.
• Created Web Services (API) payloads for accessing Data in PME Database and tested using SOAP API tool.
• Effectively communicated and maintained relationship with project team participants and project’s business stakeholders.
• Create Change Request (CRQs) based on client requests and worked with development team to implement the CRQs.
• Performed data analysis of wealth management transactions with centralized analytic, data conversion and performance reporting of various assets classes.
• Used SQL to interrogate databases and produce Dashboards and predictive analysis using Tableau based on metrics - Trade Counts, Commissions, Managed Accounts, Brokerage Accounts, and Alerts data elements to capture Data, Query and Interface requirements.
• Facilitated the development of RFP’s or SOW based on business requirements; and manage vendor/clients through implementation and delivery.
• Analyzed and verified the integrity of data in Database and Data Quality scripts to make sure cleaning, resolving, redundancy and checking against Business Rules for data integrity. Also, maintains atomic level checks for transactional and pricing data.
• Used BDD to create Automated testing scripts in a Continuous Integration Environment with Eclipse in Java Language.
• Provided PROD support using ALM as defect management repository for PROD and UAT. Performed SQA, IST and Performance testing.

Environment: Java, Unix, Hive, Oracle 12c, Data Warehouse, Hadoop, SOAP API, SQL Developer, ALM, Blueprint, Agile, Tableau, UML, MS Visio, Cucumber, MS Project.

Confidential

Senior Business Analyst

Responsibilities:

• Produced Clients’ Internal, MYSS portal performance reports, and Interactive Views for various Clients/Funds and Entities.
• Wrote requirements for issue of report Regeneration fixes, Decimal precision fixes, spaces issues in reports, extra line spacing, and calculation changes.
• Created Test Harness using Excel and SQL in lieu of documentation to Map the fields between Source file (Blob format) to Intermediate tables from Tri-party feeds to stimulate the ETL operations that created the Daily reports to investigate under-collateralization of clients (funds).
• Used Toad and SQL Developer platforms to perform queries on data sets and understand the various Joints and Union operations on tables in the Collateral, Reference (static data) and SLD schemas to identify new accounts and securities.
• Performed the detailed data analysis and created Facts and Dimensions Matrix on Star and Snow-Flakes Schema to capture Data, Query and Interface requirements.
• Wrote requirements for creating various services and query changes and constructed data mapping.
• Led the Migration project of Actuate to Jasper involving 54 e-reports and 62 e-Spreadsheets using ODS as Interface between the DB and reports generation - BI tool Tableau.
• Coordinated, initialized and facilitated Joint Requirement Planning seminars for Business and Functional Requirement gathering, analyzing, and documenting them in Product Backlog and subsequently breaking up Feature Lists into User Stories, and drawing up Acceptance Criteria.
• Led the Migration of Client (Fund)\Entity reporting from Securities Lending Data Warehouse to Securities Finance Business Intelligence platform to support reporting for Average Lendable for various frequencies - monthly, quarterly and yearly.
• Solicited requirements directly from Counterparties, Brokers, Agency Traders and Account Management and translate same into user stories for various stages of Agile implementation.
• Performed Impact Analysis of current systems and processes and draw up Current State, Future State and Benefits thereof for presentation to Executive Committee for approval and funding.
• Implemented Basis Points (BPS) calculation from the Security Lending Data repository to Securities Finance Business Intelligence platform by changing Activity Period to Calendar Days to reflect entire asset yield duration using Tableau.
• Developed the Securities Finance Entity Profile project to facilitate Indemnification to 3rd parties and Insurance companies so as to reduce the RWA being carried on SS books.
• Forged the Regulatory planning and management work on CCAR - capital stress test, DFAST incorporating forecasting exercise FR Y-14 and FR Y-9, and generating organization scenarios.
• Coordinated the Securities Finance transaction consolidation for all trades into a consolidated repository of loan and portfolio level data capture and granularity to be used by Risk, Regulatory and Internal applications.

Environment: Java, Unix, Oracle, Data Warehouse, SQL Developer, Toad, Test Director, HP Quality Center, Agile, UML, MS SharePoint 2010, MS Word, MS Excel, PowerPoint, MS Access, MS Visio, and MS Project.

Confidential

Senior Technical Business Analyst/Scrum Master

Responsibilities:

• Developed Product Backlog and Sprint Backlog from requirements and run daily sprints. Tracked and monitored tasks and team collaboration using Agile tool Jira and Confluence for code collaboration.
• Produced sequence diagrams, business mappings, UML diagrams for functional requirements documentations.
• Documented the APIs Payloads for the various Requests and Responses transactions and other resource usage.
• Worked with technical team to deploy HSM cryptographic solution on Private Key and Public Key pairing to enhance security environment for Confidential Pay solution.
• Worked closely with PMO to produce daily executive reports and organize periodic checkpoint meeting involving key members of the organization and project team.
• Gathered requirements from Confidential Project team through conference calls, live meetings, and emails.
• Led the Sprint Review meeting Confidential office and live demo of transaction from Confidential device through Confidential network and finally to the Associations (Amex, Visa, and MasterCard) for settlement.
• Captured business rules and scenarios for implementing requirements in the enterprise environment in compliance with PCI-DSS and PA-DSS regulatory standards in credit card and personal information.
• Developed Test Strategy and Test plan to ensure the Test cases reflect business user requirements.
• Gathered and documented requirements for the Fraud Detection and Prevention System as an additional security for existing merchants to authenticate for Credit Card transactions and Refunds.
• Utilized Public Key and Private Key Data Management in the encryption space to HSM cryptographic algorithm key generation.
• Designed the workflow and sequence diagram depicting API payload request/response profiles between the Gateways and the back-end systems using internal Reference Data system.
• Coordinated and conducted testing in multiple environments including INT, QA, CAT, and UAT before working with release management to push code to Production.
• Worked with team to design and implement JSON to SOAP (XML) format mapping and vice versa for communication between front-end and back-end systems.
• Led and managed off-shore teams that implemented Fraud API on US and EMEA regions Gateways and produced the global roll-out plan.
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing, and User Acceptance Testing (UAT).
• Facilitated Defect Triage process for effective Defect management through severity and priority categorization to ensure completeness.

Environment: Java, JavaScript, J2EE, HTML 5, CSS 3, Unix, Oracle 11g, SQL, Test Director, HP Quality Center, Agile, UML, MS SharePoint 2010, MS Word, MS Excel, PowerPoint, MS Access, MS Visio, MS DOS, Load Runner, MS Project, Restful APIs, WebSphere, Client Languages SDKs - Java JS, PHP, Ruby and Python.

Confidential

Programmer/Analyst

Responsibilities:

• Developed the Vision and Scope document, Requirement Work Plan and Work Breakdown Structure for tasks involved in the project.
• Used MS project to document and tracked project schedules, tasks and resources.
• Conducted workshop for stakeholders in each market to gather, analyze, document and validate requirements and produced BRD and FRD.
• Created Use Case specifications, business flow diagrams using MS Visio for developer and other stakeholders to understand the business process according to their perspective with all possible alternate scenarios.
• Performed Root Cause Analysis and Re-engineered business processes, and implemented performance measures, presented project presentations to executive management.
• Achieved final approval and validations of business rules and processes with users and management.
• Co-ordinate with off-shore technical teams in various markets to explain and clarify requirements and resolve issues arising from the project.
• Worked with Testing team to review and finalize Test Cases and Test Plan to address Test Objectives, Test Scope, Test Environment, Test Approach, Roles & Responsibilities, Test Scenarios, Defect Resolution, Capacity/Load testing, Performance goals and success factors.
• Created documentation for project tutorial session and provided end-user training and support to various markets.
• Worked closely with Release Manager on planned Releases.
• Prepared Project Dashboards and facilitate review meeting and produced status reports.

Environment: MS Excel, MS Word, MS PowerPoint, SQL, MS Visio, Oracle 10g

Confidential

Programmer

Responsibilities:

• Developed code in COBOL/CICS on IBM Mainframes from specifications and tested code successfully for deployment in Production.
• Participated in Code Review and contributed in enhancing code effectiveness.
• Fixed Bugs in code and re-tested code for releases into Production.
• Performed code enhancements and implemented new features in existing programs.
• Conducted training sessions for the end users and documented various training manuals.
• Maintained traceability matrix and ensured that the project charter, BRD, design (HLD) docs, and test scripts are synchronized and are aligned with enterprise provisions.
• Developed user test plans and performed User Acceptance Testing to ensure developed code meets business requirements.

Environment: Cobol/CICS, Mainframe, MS Office, SDLC, Mercury Quality Center, IBM Rational UML