SUMMARY

• Hands - on, Certified PM/ BA/ QA techno functional professional with 20 years of analysis & delivery of mission-critical, complex projects in Banking & Capital Markets covering front, middle, back office, Trading, Pricing and Reference data systems.
• Cross exposure to a broad range of OTC instruments including Forwards, Futures, Options, Swaps, Fx, MBS, CDO and Credit Default Swaps.
• Very strong in multiple domains through MBA, B.Eng., CFA2*, CMA* (Certified Management Accountant), CFP, CSC, IFIC etc. Technical competency in SQL, UML, PL SQL, advanced Excel, Access, Visio, Oracle Discoverer & Crystal Reports. Big Data Onboarding Analyst, Project & Release Manager, Solution architect

TECHNICAL SKILLS

High Volume, low latency systems transaction systems: Reuters Kondor 2.6.4, Charles River Development 7.x; 8.x; 9.x, HiPortfolio, Eagle Pace, Eagle Star, Bloomberg

Process modeling/ Workflow diagrams: UML 2.0 Rational Rose Professional J Edition; MagicDraw 9.5 Enterprise Edition, MS Visio, Casewise Corporate Modeler 9.3, 10.1

Cloud: AWS Certified Cloud Practitioner, AWS Certified Solutions Architect Associate, Oracle Cloud Infrastructure Architect Associate

DW/ BI/ ETL: Working knowledge of SQL Server, Oracle, Expert in MS Excel, MS Access, Crystal Reports, Oracle Discoverer 3.1.45 Administrator/ End User. PowerCenter, Tableau, Talend, Aqua Data Studio

ERP: Oracle Financials 11.7 modules Performance Analyzer, Balance & Control, Transfer Pricing

Project Management Software: JIRA, Green Hopper, MS Project, SharePointBig Data: Hadoop Admin including HDFS, MapReduce, Yarn, Hive, Mahout, Pig, HBase, Apache Drill, Oozie, Zookeeper, Flume and Sqoop

CRM: Salesforce CRM, ServiceMax, Working knowledge of UNIX, Agile Scrum, Waterfall, V-Model, RUP, CMM III/ V, Six Sigma, Defect

Tracking: JIRA, HP Quality Center/ ALM, TFS, Bugzilla, MS TFS, MTM

PROFESSIONAL EXPERIENCE

Senior TEMPPrincipal consultant

Confidential, Detroit, MI

Responsibilities:

• Enterprise Data Lake multi-tenant on boarding program - own and manage 7 enterprise data domains
• Data Ingestion, Conformance and Consumption workloads
• Devise and execute Big Data On boarding process document, flow diagrams, checklists
• Role of Enterprise Data Lake On boarding Business Analyst, Release Management, Solution & Test Architect
• Developed Enterprise Data Lake (EDL) Platform Sizing Questionnaire
• Evaluated business & data flows, business processes, implied requirements, process improvement, identify gaps
• Created EDL On boarding Process document, checklist, process flow diagrams
• Created & Managed EDL Go Live Implementation Plan - successful Go Live of 40+ projects
• Enterprise Data Environment Playbook, EDL Big Data Entitlements, Technical meta data, EDL Platform Issues Log
• Migrate workloads from legacy clusters to target cluster
• Ensured solutions align with and adheres to the standards established by platform architecture
• Align at a product and project level and take ownership of the end to end solution design
• Responsible for growing client relationship through service excellence
• Provided hands-on support and guidance to delivery leaders, business architects and Hadoop developers
• Participate in pilot project to migrate big data workloads to AWS

Lead BA/ QA

Confidential, New York, NY

Responsibilities:

• Use Case and POC Preparation Worksheet to assist in planning for POC
• Role of Business Analyst & Test Architect
• Created data mapping spreadsheet
• ETL testing to validate data transformation rules, source-to-target data validation, metadata testing including datatype, data length & constraints check, BI & GUI testing
• BRD in progress covering Users, Access Method, Functionalities, Key Data, Integration, GEO for multiple stakeholder groups
• Designed E2E Test Strategy from Discovery phase to implementation

Responsibilities:

• Build a cross functional SFDC solution to transform and operationalize the capabilities needed to run the Advanced Markets Network business
• Role of Business Analyst & Test Architect
• Created data mapping spreadsheet
• ETL testing to validate data transformation rules, source-to-target data validation, metadata testing including datatype, data length & constraints check, BI & GUI testing
• BRD in progress covering Users, Access Method, Functionalities, Key Data, Integration, GEO for multiple stakeholder groups
• Designed E2E Test Strategy from Discovery phase to implementation

Confidential

Responsibilities:

• Oracle CPQ was installed into SFDC using Managed Package v7
• Role of Business Analyst & Test Architect
• Price books and product information synced to OCPQ parts database on a nightly basis
• Commerce engine configured for MRSP/List price and calculation of EPP/Net/etc. as well as other financial calculations
• Configuration holds product configuration logic, supported by parts metadata and data tables
• Allows for multiple quotes within any opportunity in SFDC. The primary quote within SFDC drives opportunity products and opportunity dollar amount
• Designed E2E Test Strategy from Discovery phase to implementation
• Analyzed for native SFDC integrations wherever possible for quicker implementation, a more stable environment, and easier maintenance
• Early budgetary opportunities with standalone products and opportunities with quotes
• No data replication; pricing and product data housed in SFDC with OCPQ holding only configuration-specific data

Lead BA/ QA

Confidential, Cleveland, OH

Responsibilities:

• Worked as part of Scrum team in Agile environment
• Elicited current state/ gaps via meetings with Water Rights, Dam Safety, Adjudication business stakeholders
• Created Business Process flow documents of the as-is, to-be processes, including any ancillary and
• manual processes conducted within Water Allocation Bureau - Water Rights, Dam Safety &
• Adjudication Sections
• Created a Gap Analysis document dat addresses the pain points, backlog & desired future state
• Created UML flowcharts of the as-is and to-be processes
• Provided recommendations as a basis for Water Allocation Bureau to conduct more detailed analysis

Confidential

Responsibilities:

• Worked as part of Dev Ops teams in onsite/ offshore model in Agile Kanban environment
• Responded to Production tickets, recreate bugs in Production or Prod parallel environment
• As BA, created ‘As is” and “to be” process flow diagrams in consultation with Product Owners
• Designed & created mockups using Visio & corresponding Excel based data mapping
• Communicated with Project Managers, Systems Architects, Systems Analyst, DBA's and Software Engineers to gather requirements for testing and develop estimates for testing execution
• Led daily Standups and Story Review, BA Review and QA Review meetings
• Responsibilities: team management; design, develop and execute Test Strategy, Test Plans, Test cases Executed test Scenarios in manual and automated testing using TFS, Microsoft Test Manager, Selenium in C#

Confidential

Responsibilities:

• Supporting Treasury projects for largest single Treasury in the world
• Support the enhancements and testing of 360T FX Trading system, GE Debt & Derivatives Portal, IRIS (OTC Trading), Wallstreet Systems

Lead BA/ QA

Confidential, New York

Responsibilities:

• Supported Charles River 9.2 projects in Alternative Investment Services & Asset Management
• Charles River 9.2 Bug fixes, patches and upgrades
• Equities, exchange-traded funds, Depositary Receipts, listed equity options (puts and calls), OTC equity options
• Define requirements for Automated cash sweep functionality relating to the investment of deposits and recovery of overdrafts/fees
• Analyzed Business Requirements documents, Functional Specifications documents, Test plans, Test Cases, Defect Management
• UML Process Modeling, Analysis and Mapping, Use Case Development, Requirements Gathering/Analysis/Validation, Data Analysis, documentation, Test Cases, leading UAT and System testing
• Projects include Reuters Price Transmission, Eagle Pace Reports, Security composite rule overlay, REPO Negative coupon settlement

Program Lead BA/ QA

Confidential, New York

Responsibilities:

• Lead BA QA in Capital Markets me.e. Tullett Prebon, E*Trade, Franklin Templeton, Barclays Wealth Management
• Bank of Montreal: Migrating 18.000 Private Portfolio Accounts, Trades, Positions from Global Plus to Charles River.
• Current State and Future State recon process for portfolios, trades and positions including timing
• Requirements analysis for Create New Order, Pre - Trade Compliance, Send to Trading, Merger/Split, Place/Fill, Send to Accounting/ Cancel Send to Account, Replace/Cloning/Done Deal
• Requirements Analysis and Testing for the end-to-end trading of OTC Derivatives - Rates, Credit, Energy as well as Cash Bonds on in house trading systems tpCreditDeal, tpEnergyTrade, tpSwapDeal, tpFwdDeal, tpRepo, tpMatchBox
• The in house platform supports Interest Rate Swaps, Fx Forwards, NDF, Government Bonds, Repurchase Agreements, Reverse Repos, Basis Swaps, Futures, Future Options, FX Options
• Analyze Business Requirements documents, Functional Specifications documents, Test plans, Test Cases, Defect Management
• Create UML Activity flow diagrams, data models, data mapping sheets
• Lead sessions to elicit, elaborate, and curate user stories, define acceptance criteria, and develop test cases and scenarios
• Requirements Analysis and Testing of Serena, Online Advisor, Bond Fund Selector, Genie, EBOSS, Registered Independent Advisor, Wealth Management Advisor, Routex, Trading Operations and Clearing Operations applications covering multiple asset classes viz., Securities, Bonds, Mutual Funds, Exchange Traded Funds and OTC Options

Expert Business Analyst

Confidential, New York

Responsibilities:

• Expert Business Analyst supporting Fixed Income Front Office Trading - Middle Office - Back Office
• Asset types include MBS, TBA’s, government bonds, agency bonds, covered bonds and equity ETFs.
• Facilitated client workshops with Front Office Fixed Income portfolio managers and analysts to compile requirements for a new Fixed Income Front Office OMS for managing over $110 Billion in Fixed Income AUM.
• Developed enhancements to current in-house asset management tool, the Global Portfolio Guidance Model (GPGM) using UML use cases to model the requirements. Use SQL for trouble-shooting and communicated with IT resources in the head office in Zurich, and/or the data center in Armonk, NY.
• Developed business requirements for Derivative orders (futures, options, swaps, swaptions) from Murex and Calypso applications into the Hi Portfolio accounting system.
• Developed business requirements for Credit Default Swap (CDS) trading used for hedging purposes to remove credit risk from the Fixed Income portfolios.
• Developed business process workflows for Hedge Accounting, in which floating rate Asset Backed Securities are paired with Interest Rate Swaps to enable the asset matching with the cash flows of long term (30 year) underwriting liabilities.Lead Data Analyst in Data Hub migration project. Reconciled large volumes of data relating to Security Master, Positions, Transactions, Sectors, Ratings, Analytics, Company information, Fx etc. data

Technical Environment: Crystal Reports; Business Objects, Xcelsius, Dashboard; Tivoli (TWS); Hyperion; SmartStream TLM; Asset Control for Market/ Price/ Corp Actions Data; SQL Server 2005; Sybase; Oracle; PowerCenter, HiWay (DST Int’l); HiPortfolio (DST), MS Excel, MS Word, MS Project, MS Visio and MS Access; Casewise Corporate Modeler 9.3; Lotus Notes, Toad

Senior Business Systems Consultant

Confidential, Boston, MA

Responsibilities:

• Project to convert Fixed Income reports from Mainframe to Oracle Discoverer/ Oracle Reports - simple to highly complex reports (100+ pages) with charts, graphs, and diagrams
• Oracle Discoverer reports - Define, Build and Test
• Oracle Reports - Define, Enhance, Build, Test, Release and Prod support

Confidential, Boston, MA

Responsibilities:

• Reported to Vice President
• Trading Systems - Derivatives & Fixed Income
• As Lead BA/ PM on a project to create a Cash Engine to be a central, completed detailed process, flow and data analysis of various flavors of Book and Bank Cash me.e. Available, Investible, Synthetic Cash.
• As Lead BA/ PM, successfully completed the retirement of the central position keeping and messaging system; migrated all functionality to alternate systems
• Analyzed & documented Enterprise wide XML based messaging flows in response to Order & Trade Events, Corporate Actions etc. for all types of securities types - Equities, Fixed Income, Derivatives, Cash
• Complex, end to end testing of OTC derivatives, lead cross functional teams, track defects, bugs, issues using TeamTrack Ver 6.3
• Analyzed & documented Front Office workflows from loading SOD data in spreadsheets, to financial modeling & what-if scenarios, creating term sheets, pre-order compliance, allocations and trade tickets
• Analyzed and documented Middle Office workflows in UML including validation of counterparty term sheets, ISDA confirmation, approval and tracking; trade entry into order management system; pre trade and post trade compliance
• Understanding of OTC derivatives such as Equity, Index, Bond &Fx Options; Interest Rate swaps, Equity swaps, Variance swaps, Off Market swaps; Credit Default swaps/ index; Forwards & Futures; Swaptions; Repos, Reverse Repos, Collaterization, etc.
• Understanding & documenting of Back office derivatives accounting process including calculating period to date accruals, amortization, clearance, settlement transactions, backward and forward posting, days basis, roll forward, holiday & month end processing; intra-day, EOD and month end
• Created use cases and activity flow diagrams in Rational Rose for the end to end derivatives process flow from spreadsheet modeling in front office to middle office to back office derivatives accounting, valuation, pricing and analytics
• Understanding of & mapping the forex spot generation & linking process on transactions requiring a forex rate
• Mapped & defined the long/ short Cusip process for Exchange traded derivatives; understanding of Rollovers at maturity
• Prepare workflows/ User Manuals for Traders, Middle Office and for Production Support
• Conducted detailed Unit & System testing; Regression, IST, UAT & Parallel testing
• Designed detailed test plans for end to end testing of all Derivatives instruments including all order & trade events like opens, closes, resets, payments, cancels, cancel/ replaces, full & partial terminations; exercise options in-the-money, at-the-money or out-of-the-money;
• Co-ordinated and led detailed annual audit of OTC Derivatives including accruals and amortization with external auditors such as Price Waterhouse Coopers
• Evaluated vendor product: Charles River Development for Exchange Traded Futures
• Created use cases and activity flow diagrams in Rational Rose for Pace Eagle Star migration
• Participated in/ coordinated over 100 major/ minor projects which has been turned over into the production environment with minimal defects/ issues
• Created EUL in Discoverer Administration; Mapped, created folders, Created business areas.

Environment: XP, Unix, Oracle 9.3, Sybase 11; TIBCO messaging; Business Works; Vendor trading systems such as Reuters Kondor, Charles River Development, Latent Zero Minerva, Eagle Star, Pace SRM; in house blotter/ trading systems for Equity trading, Cash Management, MBS, TBAs, Pools etc.; Latent Zero Compliance; Rational Rose & MagicDraw UML, Excel, Word and Access; Exceed, Lotus Notes

Confidential

Assistant Manager, Private Banking & Wealth

Responsibilities:

• Promoted to Head Office as Manager of Finance
• Promoted to Regional HQ as Asst Manager of the Private Wealth Management & Trust, led a team of 21 Relationship Managers managing HNI clients and assets exceeding $2 billion
• Highest Money in totals in the branch; twice the volume of next best
• Highest #products sold per customer ratio in the branch. More than 3 times the next best
• Joined as Officer in largest retail banking branch of the bank. Offered full range of money in and money out products and services

Confidential

Wealth Management Advisor

Responsibilities:

• Client acquisition, retention, servicing and growth
• Financial & Retirement Planning, Mutual Funds, Insurance, Investment Management, Taxes
• Assess and analyze current financial position with reference to equity, fixed income generating assets and Life/Medical Insurance.
• Specific needs and setting you're financial goals.
• Developing a strategy to enable you to achieve you're financial objectives with acceptable levels of risk.
• Monitoring the strategy and complete execution of the investments in all three areas, which will be tax efficient as well as generate superior returns.
• Investment Strategy and recommendations
• Financial plan to meet client objectives and projected cash flows
• Updated Family Balance Sheet and asset allocation

Environment: Oracle 8.1.7, Sun Solaris Unix, Oracle Discoverer 3.0, SQL, Maestro Scheduler, MS Access, Excel, Oracle Financials Analyzer, Transfer Pricing & Balance & Control; Finance & Accounting