SKILL:

UML, SQL, Java, Data Mapping, Unix, Visual Basic, Confidential Office Suite, Confidential Visio, Confidential Project, Web Services (“API”), XML, JSON, Confidential SharePoint 2010, Oracle, ETL tools (“Informatica”), Data Warehouse, Tableau, Hadoop, ALM (HP Quality Center and HP Quick Test Professional(QTP), Cloud, Rally, Jira and Confluence.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Technical Business Analyst/Project Manager

Responsibilities:

• Developed the Business Requirements and Specification Document to migrate over 90 Confidential ( Confidential ) from ETD Hub to PME/Fusion database system covering all assets classes - Equities, Derivatives, Fixed Incomes, Spreads, Warrants, Tick Scales, and Vendor feeds ( Confidential and Confidential )
• Proxy Product Owner and created and managed Jira for the Confidential team. Broker/Dealers, Account Management, Compliance, Regulatory, Product Managers and external clients.
• Run Agile ceremonies including Daily Standup meeting for 2 scrum teams comprising Offshore (APAC - Singapore & India) and Onshore
• Created and presented weekly project status reports to stakeholders including project sponsor and upper management.
• Performed Mapping of Raw Data File through RVR process and TNT (Transformation, Enrichment and Data) to produce Golden Copy for client consumption PME DataMart or PME API.
• Analyzed attributes and database objects for reconciliation in respect of Population, Attributes and Client’s Data as part of MIFID II Regulation for Data organization by making all assets complaint prior to January 3, 2018 effective date.
• Produced complete set of attributes by regions and documented Test Cases covering various criteria and scenario.
• 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.
• Designed and documented the client On-boarder workflow to migrating client systems from ETD Hub to PME/Fusion platforms.
• Performed UAT testing and Level 3 PROD support by implement Jira tickets for PROD and UAT.
• Analyze the feasibility of Business Case, produced User Stories, budgeting and time estimation schedules in Confidential Project, and associated Risks and Mitigation action plans.

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

Confidential

Lead 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.
• Performed GAP analysis for defining the current state of Trade Surveillance reporting practices and proposals to improve reporting tools and metrics to capture quarterly aggregates.
• 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.
• Performed the detailed data analysis and created Facts and Dimensions Matrix on Trade Counts, Commissions, Managed Accounts, Brokerage Accounts, and Alerts data elements to capture Data, Query and Interface requirements.
• Reviewed and documented data process implementation in Data Warehouse - source, staging and production and captured business requirements for Schema. Documented ETL processes and rules; and identified quality rules to Trap and Capture exceptions and produces BI reports.
• Used SQL to 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, SQL Developer, ALM, Blueprint, Agile, Tableau, UML, Confidential Visio, Cucumber, Confidential Project.

Confidential

Senior Technical Business Analyst

Responsibilities:

• 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, (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 Confidential 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, Confidential SharePoint 2010, Confidential Word, Confidential Excel, PowerPoint, Confidential Access, Confidential Visio, Load Runner, Confidential 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 Confidential cryptographic solution on Private Key and Public Key pairing to enhance security environment for Confidential Pay solution.
• Worked closely with Confidential 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 rmation.
• Developed Test Strategy and Test plan to ensure the Test cases reflect business user requirements.

Environment: Java, JavaScript, J2EE, HTML 5, CSS 3, Unix, Oracle 11g, SQL, Test Director, HP Quality Center, Agile, UML, Confidential SharePoint 2010, Confidential Word, Confidential Excel, PowerPoint, Confidential Access, Confidential Visio, Confidential DOS, Load Runner, Confidential 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 Confidential 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 Confidential 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 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: Confidential Excel, Confidential Word, Confidential PowerPoint, SQL, Confidential 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 sessions for the end users and documented various 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, Confidential Office, SDLC, Mercury Quality Center, IBM Rational UML