SUMMARY

• Over 15 years’ experience in Business and Data Analysis, analyzing requirements, testing business functionalities in software, re - engineering processes, and enhancing capabilities and value. Expertise in Agile Scrum and Project Management.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential

Lead Technical Business Analyst/Project Manager

Responsibilities:

• Proxy Product Owner and created and managed Jira for the Global team.
• Broker/Dealers, Account Management, Compliance, Regulatory, Product Managers and external clients.
• Created and presented weekly project status reports to stakeholders including project sponsor and upper management.
• Contributed to Architect the solution comprising components - Feed Mapping, Data Quality, Corporate Action, Distribution and Client Engagement.
• 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 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

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.
• 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 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, MS Visio, Cucumber, MS Project.

Confidential

Senior Technical 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.
• 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.
• 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.
• 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.

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, Load Runner, 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 Apple 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 Apple Project team through conference calls, live meetings, and emails.
• Developed Test Strategy and Test plan to ensure the Test cases reflect business user requirements.
• 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.
• 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.
• 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