SUMMARY:

• Confidential has over 14 years of experience in business automation and architecture re - design projects in leading Investment Banks as Scrum Product Owner, Senior Business Analyst and Data Analyst roles.
• Using lean agile frameworks, he consistently delivered successful projects within time and budget.
• He works on user requirement gathering, project planning, scrum board backlog, workflow analysis, application design including wireframes, database modeling, systems integration, extract-transform-load (ETL) and data distribution specifications.
• He leads the development team by providing clear specification using data analysis, honed through working on applications.
• He performs complex data analysis, Unix scripting with equal ease as user requirement gathering, product backlog management, user story writing, providing detailed acceptance criteria and senior management reporting.
• His experience in finance domain includes working in domain of Regulatory Compliance, Financial Product and Price Reference Data, Trade and Positions golden data, Party Reference Data, Client Information Program/KYC, Account, Trades and Position Data.

TECHNICAL SKILLS AND TOOLS:

Cloud Computing: Amazon Web Services (EC2) for Linux & Windows

Database: Oracle, MS SQL Server, Sybase, MySQL, KDB in-memory

SQL Tools: SQL Developer, Toad, DBArtisan, Visio, Oracle - JSON functions

ETL/Data loaders: Informatica, Ab-Initio, Oracle Sql Loader, BCP

Collaboration: Scrum board, Kanban, Confluence-Jira, GitHub, Subversion, MS Project

UML Analysis Tools: Visio (Workflow, State, Sequence diagrams), PowerPoint, Data profiling

UNIX/Batch/Scripting: shell (ksh/bash), Autosys, perl, python, Selenium, Gherkin, Cucumber

Web Technologies: Java, REST API, Angular, JSP, SOAP, MQ, Axure RP

WORK EXPERIENCE:

Confidential, NJ

Consultant - Scrum Product Owner (BA/PM)

Responsibilities:

• Compliance application built for associate investment monitoring for outside business activity using Party Reference Data System.
• Managed story backlog stories using, gathering stakeholders’ feedback, application requirement gathering sessions, data analysis, data model re-designing, data lineage and traceability, provide acceptance criteria, perform user demo and story refinements.
• Perform data analysis using Oracle queries.
• Application based on Oracle Exadata, Informatica and angular-java REST API framework.
• Analyzing legacy data, data modeling, design framework and data distribution

Confidential, Securities, NY

Consultant - Lean Agile PM/Sr. Data Analyst

Responsibilities:

• Firm’s Supplemental Analytical Market Data rewrite project, is a Front Office (Trade) application for Equity, FI, ETF, Index, Custom Basket and Derivatives database in Oracle and UNIX platform.
• Data feeds included Bloomberg, Reuters, Markit/Sola, CME, etc.
• Resigned application for golden source; and implemented data quality, data governance, data marts, data-distribution, UAT communication and project planning.
• Designed automated data recon of large and complex data-sets, custom-built application in UNIX-Autosys-Oracle architecture

Confidential, NY

Data Steward/BA

Responsibilities:

• Data stewardship of Legal and Compliance data warehouse for Trade Surveillance and Positions monitoring
• Application design and enhancement for data ingestion (extract transform and load), data cleansing, data lineage and data consolidation.
• Deliverables management for Regulatory, Trade Surveillance and Compliance for Trade, Position, Books & Accounts
• Application data modeling, ETL functional spec creation for data warehouse
• Sourcing data, data profiling, data governance on firm trades on equity and derivatives;

Confidential, NJ

Sr. Business & Data Analyst

Responsibilities:

• Client Onboarding application Functional specs (FRD) and Business Requirement (BRD)
• Client Onboarding Workflow enhancements for client New Counterparty, Entitlement and Review flows
• Support Four-eye approval process, DocStore (Documentum) integration.
• Enhancement of Client Onboarding for Confidential rules, Risk classification, Client Identifying Program (CIP) tasks, vetting standard and country specific vetting tasks, firewalling among entities based on Client Data Confidentiality (CDC) flags
• Data mining (SQL) in Oracle; Oracle Virtual Private Database and business rule configuration
• Product and Price source hierarchy’s analysis for compliance and cost-reduction benefits.
• Data profiling, analysis and regression analysis using data source scenarios.
• Produced functional requirement specs (FRD) by facilitating requirement gathering discussions between Middle Office (Ops) and product development business stakeholders across regions
• Analyzed reference and price data for automated batch for Prime Accounts, Risk & Margin stakeholder. Worked on Price Master integration requirements for Prime Finance needs for attributes of interest (aka prices of interest) over various products using Securities of Interest list.

Confidential, NJ-NY

PM/Sr. Business Analyst

Responsibilities:

• Golden source product reference data for Electronic Trading system.
• Providing indicative data, NYSE Symbols, CME, OPRA code, Index and constituents, Corporate actions and pricing) to Trading Applications; OCC Options Symbology Change initiative
• Performed data analysis (complex SQL queries performing database joins), database modeling. time slicing (bi-temporal) and immutable identifiers (cross lookups).