SUMMARY:

• Results - oriented Engagement Lead, Business Analyst and Solutions Architect with a solid record in delivering Data Governance, Analytics, Business Intelligence, Data Warehousing, Enterprise Data Management, Master Data Management, and Data Quality Management capabilities to Fortune 100 corporations. Managed teams ranging from 2 to 50 technical and business resources. Responsibilities included Data Architecture and Design, Engagement Management, al Seminars for Executives and Technologists and Speaking Engagements. Led all phases of the System Development Life Cycle (SDLC).
• Data Architecture and Business Analysis. Major driver in architecting and developing solutions targeting vertical specific Actionable Analytics, Business Intelligence, Data Warehousing, Data Governance and Master Data Management - accelerators that were successfully deployed for customers in Confidential, Banking, Brokerage Pharmaceuticals, HealthCare, CRM, Call Centers, Government, Sarbanes - Oxley, Transportation and Insurance verticals. Led all phases of the System Development Life Cycle (SDLC) including systems/architecture roadmaps, strategy, design, implementation and quality assurance. Developed conceptual models, software and hardware architecture for the development and production environments.
• Project / Engagement Management. Conceptualized and managed deliveries of Analytics, Business Intelligence (BI), Data Warehousing (DW) and Data Governance products / consulting engagements in verticals such as Confidential, Investment Management, Insurance, Pharmaceuticals, Managed Care, Dodd-Frank, Sarbanes - Oxley, CRM, Call Centers - Contact Centers, and Department of Defense. As a subject matter expert on technology and business issues provided key contribution to winning major engagements using consultative selling to “C-Level” executives and their supporting IT managers. Managed successful sales and deliveries of highly complex projects for clients such as Confidential, Confidential, Barclays, Morgan Stanley, Credit Suisse, BOA - Confidential, Confidential, HSBC, Deutsche Bank, TD Waterhouse, MBNA, Vanguard, Confidential, Pfizer, Aventis, Bristol-Myers Squibb, Confidential and Confidential, Confidential, IBM, Avaya, Teradata, and the United States Marine Corps.

TECHNICAL SKILLS:

Technology and Tools: Investment Management, Capital Markets, Banking Multi - Asset Trading, Wealth Management, Trade Order Management (TOM), Compliance, Buy Side / Sell Side Alpha, Risk, Trading Surveillance, Basel II, Securitization, Loan Origination and Servicing, Securitization, Commercial Loan Processing Pre-Trade, Post-Trade Analytics (for Equities, Derivatives, Fixed Income, FX and cross desk), Transaction Cost Analysis (TOC), Trader and Client Alpha, AML, Trade Compliance, ECN execution, TOM /OMS Compliance Dodd-Frank, BCBS239, EPS for International Holding Company (IHC) EPS Regs, CCAR, Operational Risk, Process Risk Control Taxonomies, Supervisory Surveillance, Trade Surveillance, Fraud Prevention, Basel II, AML, Client Onboarding, SOX Section 404 CRM Analytics Call Centers Contact Centers Closed Feedback / Closed Loop, Client Retention, Customer Profitability, Customer Churn, Campaign Effectiveness, Agent Effectiveness, Customer Value, Customer Satisfaction Insurance Personal Lines, Property Casualty, Agent / Brokerage, Claims Processing, Loss Ratio Analysis, Cross LOB Performance, Risk Management Analysis, Claims and Risk Predictive Modeling Pharmaceuticals and HealthCare Brand / Product / Buying Group NDC Performance, Price and Market Elasticity Analysis, CRM Analytics, Territory Management, Best Price Calculation, Drug Utilization and Analysis Expert Level Skills in the Areas of

PROFESSIONAL EXPERIENCE:

Engagement Lead

Confidential

Responsibilities:

• Led the Data Governance and DQ Management Roadmap, Conducted gap analysis of the existing data flows across Investment Banking, Wealth Management, Market Risk, Operational, Credit Risk and Finance platforms.
• Developed a set of Metrics, Analytics, KPIs and KRIs to track progress of the Data Quality centric initiatives in alignment with Key Procedural Controls (KPCs).
• Implementation of Analytics, DQ Business Rules, Data Dictionary and Data Lineage using Informatica Metadata Manager (MM) and categorized into DQ Dimensions such as Completeness, Timeliness, Accuracy, Uniqueness, Coverage, Relevance.
• Defined MDM architecture for the centralized and distributed options globally
• Conducted reviews and prioritized requests for changes to loads to and from distributed MDM hubs and evaluated use cases
• Participated in developing an end-to-end DQ Rule Acquisition, ETL Data Transportation, Data Mart and DQ Analytics layers.
• Managed Identification of Data Golden Sources including Reuters, Confidential an Internal Security and Product Master environments.
• Reviewed and provided recommendations for DW, ETL, Data Lineage, Golden Sources, Authoritative Sources and Logical / Physical objects within Metadata Manager.
• Led an initiative of developing an Executive Dashboard / Actionable Analytics for reconciliation controls.
• For BCBS239 and CCAR, conducted data lineage / business analysis of the data elements and data sources including Income Balance Sheets, Retail, Trading, Counterparty Credit Risk, Operational Risk, Securities, Loans, Portfolio Level Data, Risk Weighted Assets and Securitized Products. Conducted analysis of the reg reports and Key Data Elements (KDE) using AXIOM software.
• Managed project risks, budget and status reporting to the steering committee.

Technical Environment: AXIOM, Informatica IDQ, Informatica Metadata Manager, Oracle, Cognos, Business Objects.

Industry Consultant

Confidential

Responsibilities:

• Delivered and Managed the following:
• Lead the effort of defining a centralized and distributed approach to MDM architecture. The architecture included functions to consolidate dimensional attributes, rejection processing and notifications.
• Defined Data Governance and Data Quality Metrics Rules (i.e. Accuracy, Timeliness, Completeness)
• MDM / s Data Functional Architecture and Operating Model including Security Master, Business Entity Master and Market Data, Party / Counterparty
• Analysis of Logical Data Models and Physical Data Models for Loan, Deal, Agreements and Party / Counterparty subject areas
• Developed an approach to documenting Data Lineage, Golden Sources, Authoritative Sources for Data Owners and Custodians
• Dashboards / MIS and Analytics for Managing Data Governance, Data Quality and Error Processing.
• Led the selection of the BI / Analytics Platform that included Tableau, Spotfire, SAP Lumira / HANA and Microstrategy. Developed use cases.
• Led Analytics and Data Governance workshops with Business and IT Stakeholders defining Operational, Prescriptive and Predictive Analytics.
• Managed project risks, budget and status reporting to the steering committee.

Industry Consultant

Confidential

Responsibilities:

• As a project manager and senior data architect conducted an assessment of business and technical requirements, developed recommendations for technical architecture supporting in-memory and persistence layers, federated data warehouses, rules engine, data governance, workflow engine and metadata management.
• Analysis and solutions architecture supported firm wide Process - Risk - Control (PRC) taxonomies, management reporting and actionable analytics.
• Developed Business Requirements and Functional Requirements Documents.
• Lead Data Governance initiative that included People (Organization) models, Processes and Technical Architecture to support Basel 239 data quality technical and business checks and analytics.
• Developed data models describing structured and unstructured data. Data requirements supported social media, sentiment analytics, direct mails, print ads, paid search, mobile presence, predictive models targeting investment strategies, demographics firmagraphics, multi-asset allocations and trade surveillance.
• Developed enterprise wide metadata strategy and platform based on a hybrid distributed / centralized architecture. Documented Business and Technical metadata components using Zachman ISA framework. The Metadata deliverables were implemented as part of an active data dictionary and enterprise wide metadata repository.
• Conducted Business and Gap Analysis, Develop business requirements documents (BRD) and functional requirements documents (FRD).
• Validated Use Acceptance Test (UAT) and Integrated System Test Plans and scenarios.

Technical Environment: Tableau, GreenPlum, HP Vertica, InetSoft, ICE DQ, Composite, SPSS, QlikView, Oracle GoldenGate, Cognos, DB2, Oracle OBIEE, Essbase, Business Objects, Xcelsius, Charles River, Fidessa, Thompson Reuters.

Project Manager / Data Architect / Business Analyst

Confidential

Responsibilities:

• Lead implementation of business and technical metadata describing analytics, data transport / ETL processes and data quality rules.
• The metadata was made available to the application level dictionaries via ODBC - JDBC Rochade interfaces.
• Developed and validated data models for data staging, data validation, data conformity and analytical tiers of the DW.
• Developed Data Warehouse (DW) Architecture specific Testing Methodology.
• Interfaces included feeds from Order Management Systems (OMS) such as Royal Blue Fidessa, ADP / Broadridge Back Office, BRASS, NASDAQ, Ticker Data, Tradebook, Confidential Market Data, OASYS, OATS, ACT, Rule 605, Rule 606.
• Facilitated Joint Application Design (JAD) sessions with client’s IT staff to deliver Data Analysis, Data Models and Process Models.
• Develop business requirements documents (BRD) and functional requirements documents (FRD).
• Conducted UAT sessions and Business User workshops.
• Conducted gaps analysis and developed technology roadmap for the Global Bank Operations Infrastructure across technology towers

Program Manager / Sr. Architect

Confidential

Responsibilities:

• Conducted Workshops with Chief Data Officers, Data Owners, Data Stewards and Architects to define metrics, dimensional model and workflow processes for the Dodd-Fran and Basel Regulatory Requirements.
• Defined data sourcing strategies across US, EMEA and ASIA data stores such as Security Master, Product Master, Global Book Master and Client Master.
• Conducted engagement to deliver rationalization and readiness assessments and software as a service (SaaS) platforms for the enterprise wide Actionable Analytics, Business Intelligence, Management Reporting and Data Governance.
• Developed SaaS migration strategy and roadmap
• Developed SaaS migration Cost Estimates and ROI
• Recommendations were aligned with Technology, Processes and, Organizational structures / skills and included
• BI / Analytics platform rationalization across Qlikview, SPSS, Business Objects, Cognos, SSIS, Oracle’s OBIEE, Pentaho and other platforms
• Master Data Management (MDM) - data sourcing, distributed vs. centralized approach, Integration MDM Hub
• Data Governance and Data Quality (DQ) - DQ metrics and definitions, team roles and skills requirements
• Data Warehouse Architecture - real time / in-memory processing, data sourcing, distributed vs. centralized approach, operational data stores (ODS), conformity and aggregation layers
• SaaS migration forklift cost estimation.
• Managed Development Teams in Asia and US.
• Managed project risks, budget and status reporting to the steering committee.
• Managed vendors.
• Developed RFPs and RFQs.

Engagement Lead / Sr. Architect / Business Analyst

Confidential

Responsibilities:

• Conducted Interviews / Workshops with business and technology sponsors
• Mapped corporate process - risk - control (PRC) taxonomies to the logical and physical data models
• Developed three (3) architectural alternatives for the target solution
• Documented AML Surveillance scenarios based on global data transaction feeds
• Acted as a liaison between Business Analysis, PMO and CTO teams
• Responsible for Project Planning and Status Reporting.

Engagement Manager / Sr. Architect

Confidential

Responsibilities:

• Managed a team of designers and developers to deploy Trader / Broker Alpha - rule based digital dashboard engine that tracks Trader and Client Position-taking Profitability, Proprietary vs. Client P&L, Importance of Block Trading, Buy Side / Sell Side facilitation return on capital, a true “Trader Alpha” and “Broker Alpha” assessment across agency and principal trades, execution venues, market capitalization value, securities, traders, loss ratios, research and banking effectiveness.
• Participated in developing a Transaction Cost Analysis (TCA) model and deployment roadmap for revenue and cost categories such as hard / soft $$, explicit cost, opportunity cost, broker commissions, connectivity fees, slippage costs / liquidity search costs.
• Interfaces included feeds from Order Management Systems (OMS) such as Royal Blue Fidessa, ADP Back Office, BRASS, NASDAQ, Reuters Market Data RMDS, Tradebook, Confidential Market Data, OASYS, OATS, ACT, Rule 605, Rule 606.
• Managed project risks, budget and status reporting to the steering committee.

Technical Environment: Order Management Systems (OMS) Royal Blue Fidessa, ADP Back Office, BRASS, NASDAQ, Ticker Data, Market DataBloomberg Market Data, Cognos, Business Objects, Xcelsius, Sybase, Oracle, DB2.

Engagement Lead / Sr. Architect / Business Analyst

Confidential, Confidential

• Responsible for the assessments of functional architecture and technical architecture for the Portfolio Management Asset Allocation Multi-Strategy Program. The Program enabled portfolio managers, supervisors, team managers with capabilities of tracking Accounts that have dispersion issues relative to the model portfolio(s) and Accounts that have conditions requiring renewal across asset types such as Equities, Fixed Income, Cash. Information was acquired and processed from multiple information hubs and Trade Order Management (TOM) platforms such as Charles River and Royal Blue on a T+1 basis.

Technical Environment: Eagle PACE, Charles River, CheckFree, Oracle, DB2, Sybase, Legacy Data Warehouses and external data feeds from Confidential, Reuters, NASDAQ.

Engagement Manager / Technical Lead

Confidential

Responsibilities:

• Developed Master Test Plans and User Acceptance Test (UAT) documentation.

Technical Environment: Brass, Royal Blue, XTIVA, NASDAQ, Mantas, Reuters RTCE and Confidential Market Data, Oracle, UNIX.

Engagement Manager / Sr. Architect

Confidential

Responsibilities:

• Lead a team of consultants and client personnel to deliver multi-channel CRM Analytics portal to enable sales and marketing professionals with an information advantage gained from the analysis of Campaign Effectiveness, Client Value / Satisfaction and Product Value with actionable insights derived from analyzing from internal systems such as Siebel SFA, CRM Contact Centers, POS and ERPs.
• Lead an effort of developing CRM executive scorecard capabilities with client centric analytics across Banking, Research and Trading functions. Conducted definition workshops with executives and participated in creation of a framework / analytical model that included client / client relationships, security / sector level market share variances, loss ratios, revenue / cost analysis across local and global market centers. The analytics were sourced out of data warehouses and trade order management and execution platforms and made available in real time.
• Architected and managed deployments of Oracle and Sybase based Federated Data Warehouses supporting Cost / Investment analyses linked to Revenue / Market Elasticity Performance. Designed multi-tier ETL processes for Data Staging, Data Cleansing and Data Population functions from Internal and External data sources.

Technical Environment: Avaya Call Center, IVR, Siebel, Unica, Cognos, Essbase, Sybase, Oracle, DB2, C/C++, UNIX, IBM MVS, JSP, Royal Blue, Reuters RTCE engines.

Engagement Manager / Sr. Architect / Business Analyst

Confidential

Responsibilities:

• Responsible for the assessments of functional architecture and technical architecture for the Portfolio Management Asset Allocation Multi-Strategy Program. The Program enabled portfolio managers, supervisors, team managers with capabilities of tracking Accounts that have dispersion issues relative to the model portfolio(s) and Accounts that have conditions requiring renewal across asset types such as Equities, Fixed Income, Cash. Information was acquired and processed from multiple information hubs and Trade Order Management (TOM) platforms such as Charles River and Royal Blue on a T+1 basis.

Technical Environment: Eagle PACE, Charles River, CheckFree, Oracle, DB2, Sybase, Legacy Data Warehouses and external data feeds from Confidential, Reuters, NASDAQ.

Engagement Manager / Technical Lead

Confidential

Responsibilities:

• Managed a deployment of the Trade Compliance Surveillance system. Participated in all phases of the SDLC including requirements definition workshops, design and deployment of surveillance scenarios such as Front-running, Spoofing and Marking to Close Buy / Sell. Negotiated contracts with external and internal market data providers. Evaluated Reg NMS requirements for compliance and market data management groups.

Technical Environment: Brass, Royal Blue, XTIVA, NASDAQ, Mantas, Reuters RTCE and Confidential Market Data, Oracle, UNIX.

Research Technical Lead

Confidential

Responsibilities:

• Key contributor to a study to define AML Detection scenarios and remedy rules for institutional trading organizations. The study analyzed NASD and SEC rules, guidelines and “red flags” and detailed recommendations around application solutions to detect potential AML activities in real time as well as analyzing historical transactions and events. The study summary was published by The Journal of Investment Compliance in Summer 2004 issue.
• Developed data models to support the data ingestion, alert and reporting requirements.

Sr. Architect / Data Analyst

Confidential

Responsibilities:

• Responsible for the assessment of the Basel II technical architecture. Conducted interviews with business executives and technology staff, reviewed end-to-end technical architecture and information flows, client onboarding processes, program governance, data governance, business and technical design requirements documents, provided assessment for Basel II readiness, gap analysis and opportunities for improvement. Participated in the development of recommendations in the areas such as Program Governance and Decision Making, Stakeholder Accountability, Sector Responsibilities, Interdependency Management, Management Reporting, Visibility across the program, Risk and Issue management.
• Technical Architecture recommendations targeted critical elements such as definition of end-to-end architectural data integrity, traceability and accountability, unified data architecture and data governance program, scalability and flexibility in the system.

Technical Environment: PeopleSoft EPM, Reveleus, Oracle, DB2, Sybase, Legacy Data Warehouses and Risk Calculation Applications.

Project Manager / Sr. Architect

Confidential

Responsibilities:

• Lead a team of analysts and developers to design and implement Metadata Repository and Metadata GUI Navigator to store Business Metadata and Technical Metadata for Best Execution and Trading Compliance analysis. The Metadata Repository was based on Zachman’s Information System Architecture Framework (ISA) with a friendly end-user access to Business Definitions, Usage Statistics, Data Sourcing, Frequency of Updates, ETL Rules and Triggers, Security Authorizations, Data Mappings between Sources and Target data objects, Logical and Physical Data Models, Rejection Processing Statistics, Data Population Statistics.

Technical Environment: Oracle, Sybase, Rochade, ERwin.

Confidential

Responsibilities:

• Enabled sales and marketing professionals with an information advantage over their competition by combining market intelligence gained from the analysis of industry-leading data sources, such as Wolters Kluwer
• , ACNielsen, IRI and IMS with actionable insights derived from analyzing Product, Customer and Sales data from internal systems, such as Siebel SFA, CRM Contact Centers, POS and ERP.
• Managed deployments of Oracle and Sybase based Federated Data Warehouses supporting Cost / Investment analyses linked to Revenue / Market Elasticity Performance.
• Designed multi-tier ETL processes for Data Staging, Data Cleansing and Data Conformity processes from Internal and External data sources to manage and analyze Buying Group Purchasing Data, Samples, Promotional Campaigns, al Seminars, Medical Professional Affiliations, Demographics, POS NDC data.
• The Federated Data Warehouse Architecture utilized a Dynamic Metadata Approach to adopt to changing levels of detail provided by 3rd party data sources such as IRI and IMS.

Confidential

Responsibilities:

• Drug Utilization, Out Of Network Analysis, HealthCare Products (MM, HMO, PPO families), Utilization of Services by Provider, Contract Renewal Ratio, Churn PCP Analysis, Claim Turnaround Performance, MDC Performance, Claim Pharmacy Analysis, Utilization by In- Confidential t/Out Confidential t.
• Build Corporate Data for Customer, Product, Territory and Market domains to support multiple initiatives, - Introduce Data Quality Processes and Controls, Enforce Data Integrity via Data / Metadata Management principals across multiple information silos based on IBM Mainframes, UNIX, DB2, Oracle, Sybase, Business Objects, Hyperion, Teradata, SQL Server and other platforms.
• Recent Product/ Service Introductions. A key contributor to the development and successful deployment of
• Data Warehousing (DW) Deployment Time Box Methodology which is based on 4 tier DW architecture (Operations Tier, Staging Tier, Analytical Tier and Information Distribution Tier), Multi-Dimensional Business Modeling, Key Performance Indicator (KPI) Clustering Analysis and Segmentation. The methodology was instrumental in winning major engagements with Fortune 500 companies. Metadata Repository and Metadata GUI Navigator that is a user friendly product designed to store Business Metadata and Technical Metadata such as data element definitions, data mappings, alerts, user groups, usage by user, data transformation rules, report and alert distribution lists.