EXECUTIVE SUMMARY:

For 25 years, a recognized specialist in strategic IT planning, big data, data warehousing, information architecture, and business architecture solutions, have successfully designed and managed the implementation of countless projects for the insurance, banking, finance, publishing, government, technology, healthcare industries and beyond. The author of several books and hundreds of magazine articles, webcasts, and white papers, with previous global work experience focused around Japan and the United States.

EXPERTISE SUMMARY:

Functions: MDM, Project Management (PMP), Business Intelligence (BI), Data Warehouse, Big Data Analytics, Financial Analysis, Solutions Architecture, BPR, Data Modeling, Trade Capture, Affirmation, Collateral, Confirmation, Valuation, Settlement, Concordance/Matching, Data Governance, Regulatory Compliance, Risk Management, Product Control, Claims Processing, Underwriting, Enterprise Business Capability Mapping and Taxonomies

Technology & Methodology: MDDL, FPML, ITIL, BPR, MDM, UML, ETL, SOA, BI, JSON, Oracle, DB2, Sybase, Data Modeling (Reference Data, Market Data, Transactional Data) Data Architecture, Data Warehouse, XML/XSD, BMC, Erwin, Sparx, Enterprise Architect, J2EE, Informatica, Iaas, SaaS, PaaS, .NET, Entity and Dimensional Modeling - Kimbal/Inmon,etc., Cognos, MQ Series, BMC Remedy, CMDB, Talend, Cloudera Navigator, SAS, OBIEE, UML, Tibco, QA, Configuration Management, Sybase, DB2, XML, SOAP, SQL, ETL, MDM, IBM Infosphere MDM, Data Stage, Hadoop, Hive, NOSQL, MapReduce, EARP, Alphabet AG, Tivoli TADM, Mongo DB, Taxonomy Management, Archer

Various Utilities: Confidential Deriv-Serv, Confidential CDS Warehouse, Swapswire, T-Zero, REDI, Oracle OFSAA and OBEII, TerraData Models, Oracle Reveleus

Market Data and Models: ACORD Information Model, ACORD Capability, Bloomberg, Markit, DataCode, DDF, Fides, Provision, Loan IQ, OFSAA, IBM Insurance Information Warehouse, IBM/Informatica/Oracle/Teradata Customer Master Models

Pricing & Accounting: Calypso, Super Derivatives, Mysis-Summit, Murex, Advent

Product Expertise: OTC Derivatives (CDS, Interest Rate Swaps, Futures/Forwards, Options),FX, Equities, Commodities, Macro Finance, Customer Master, Security Master

Others: Insurance, Pharma, Education, Government, Reinsurance, Capital Markets

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Architected big data Analytic Sandbox and data lake structures, provided firmament for analytic libraries to support all metadata ontology graphs, taxonomies, and glossaries for Prudential data scientists and other internal consumption requirements.
• Established big data governance and audit/discovery through Cloudera Navigator, saving money and reducing latency of analytic data: Analytics capabilities could be organized across the organization—yet still be elastic and federated
• Implementation of global MDM data and solutions architecture using both IBM and Informatica product suites in order to form a Common Constituent Profile that gave Prudential a multidimensional view of every business party—across product lines, business unites, and geographical regions. Full customer view was achieved through MDM Operational Model.
• Architected and stood up Enterprise-wise Data Governance Organization.
• Deep assistance in setting policy and standards and designing procedures, communication matrixes, best practices, data modeling rules of engagement, stewardship metrics and tools, and other strategic topics related to data quality.
• Helped lead MDM platform proof of concept and vendor selection workstreams by working closely with infrastructure, and analytic/big data teams, data architects, and numerous business unit leads.
• Led technical (data and architecture) overhaul and releases of companies EARP and IT portfolio solution in Alphabet AG.
• IT portfolio management could now better drive data governance and big data analytics and discovery. In parallel, created supplemental models, process flow, and architecture so that actionable end-of-life and licensing information for all software and hardware components could be shared throughout the enterprise.
• Various Business Intelligence and Data Governance initiatives using OBIEE, Cognos, Informatica MDM, etc.
• Co-Driver and facilitator of Enterprise Business Capability formulization, ultimately persisted in Alfabet for C-level strategic analysis and greatly improved SOA design and governance.

Confidential

Responsibilities:

• Worked with senior Confidential management and solutions architects to produce Client and Product Master Data (MDM) and big data architectures and solutions based on representation of Global ODS data models.
• Advised on delivery and consumption strategies and mapped ACORD capability model and information models to corporate reference and transactional data across all lines of business.
• Created messaging templates and canonical interfaces to for the Global Data Warehouse (GOAL-D data model) and the Japanese Operational Data Stores. Resolved numerous data challenges with respect to implementation of various hierarchies such as product, policy, organization, customers, cost and profit centers
• Co-authored solution architecture to promote the sharing of hardware, data, and software resources, reducing overall IT processing costs and standardizing the Japan Policy Administration technology stack.
• Defined MDM architecture for data harmonization and data greening/concordance to create a single "matched" view of customers, products, and business units. Logically assured that the MDM architecture was fault tolerant and load balanced, with data governance and reconciliation processes implicit in the platform firmament.
• Engineered unified big data and MDM solutions via OBIEE, Cloudera, and Teradata technologies. Metrics, calculations, definitions, and hierarchies were managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information was consumed.
• Created Client and Product Master Data (MDM) architectures and data models and advised on delivery, architecture approach for the Investment bank.
• Reporting to various IT and business (IB/PB/Technology) directors, was instrumental in helping drive the strategic data architecture for the CFO organization—with a special emphasis on logical/physical data modeling and interface design of inter-department shared components.
• Worked with business analysts and IT resources in JAD sessions in order to formulate requirements and logical design—all the way to the physical realization of each data structure/model.
• Shared responsibilities for creating and syndicating the firm’s data modeling standards and best practices, which included governance structures, rules of engagement, guiding architectural principles, and change management procedures.
• Served as a leading source of domain expertise for reference data subject areas such as counterparty, legal entity hierarchy, Books, PnL, chart of accounts, GL accounts, MI hierarchy, product and security data and many more. market data, and transactional data elements.
• Modeled business and accounting events—Erwin/Teradata/others--and translated/transposed the concepts into semantically rich shared architecture components that were consumed on an enterprise-wide basis.
• Primary participant in Loans (including Total Return Swaps) and Listed Derivative SOSAL SOA/Messaging architecture and data model agenda. Full lifecycle data transformation from LOAN IQ to OPERA DAL.
• Created deep system requirements and strategic technology blueprint and architecture to support the future-state research data platform for the world’s largest hedge fund.
• Established a PMO office for the entire Bridgewater Research Data Group. Defined the structure and governance framework for the PMO, from the Chief of Staff and Steering committee levels downwards.
• Successfully modeled business processes and data distribution, security and transformation processes for the BW Research Data Group under incredibly aggressive timelines and resource constraints.
• Created PMO communication model and various templates and artifacts to support the overall governance framework.
• Created data models for PMO SharePoint portals.
• Provided strategic vision to Enterprise Platform Services which included Iaas and grid computing.
• Senior market data and master data (MDM) analyst for infrastructure support of trade and sales workflows and processes for Prime Markets and Liquid Markets Groups-- Equities and Derivative (OTC, synthetic products) systems, also FX systems (Repos, Futures, Options).
• Improved Portfolio Management, Configuration Management, Best Practices, and infrastructure usage through BMC Remedy projects. Managed projects to successful completion, including CMDB reengineer and audit.
• Working closely with Infrastructure Director and PMO office to enumerate and mitigate various classes of business risks, including critical issues around legacy, continuity, regulatory/compliance.
• Created UML models, meta repository models to achieve a better transparency of business and IT infrastructure, and SLA-driven alignment. Intensive and strategic project management and system discovery/codification work.
• Semantic and Heritage models for global information exchange and financial data sharing and business continuity via OFSAA and Teradata standards.
• Reporting directly to company CEO, created and hosted webcasts on cutting-edge Business Intelligence and Data Warehouse subjects for a global audience.
• Featured writer and columnist (Contributing Editor) for Dashboard Insight, the world’s leading BI web portal.
• Served in advisory capacity for Dundas on BI/DW projects and co-headed presales efforts with clients in the USA and Canada—culminating in the sale of large pieces of Dundas to Microsoft.
• Reporting directly to former CEO of Advanced Microdevices Asia Pacific, to develop strategic content delivery platforms—XML/SOA-- for Fujitsu and EZ-PC Japan, which is a content rich experience that is intuitively linked to e-commerce and serves as content delivery platform.
• Created business intelligence platform, data models. Performed detailed business and architectural analysis to support e-commerce and revenue sharing models.
• Standardized and automated trade capture and post-trade processing of, payments and events over a contract's life.
• Massive financial data integration including Confidential Deriv/Serv platform to provide seamless financial information flows and business intelligence to counterparties, pricing systems, accounting packages, and risk management applications.
• Business Intelligence engine helped employ GRC (Governance, Risk, Compliance) controls with user customizable KPIs to optimize performance management and workflow.
• Modeled a large range of OTC derivative products, specifically credit default swaps (single name), REPOS, and vanilla interest rate swaps and structured data for better scalability (low and high volumes), performance, and semantic consistency, also to support robust centralized collateral management optimization from unified dashboard.
• Credit risk and exposure were minimized and new opportunities were identified in real-time.
• Developed a Master Data Management Platform. Included standards for MDM extraction and transformation process, as well as matching and concordance processes.

Confidential

Responsibilities:

• Architected data migration and integration strategy for international education projects—using XML oriented feeds, based on enterprise data model—in order to communicate between business segments and applications.
• Created initial SOA and messaging model for educational data.
• Extracted business logic from legacy code - PERL, DHTML, ETC.--in order to create object and relational data models for data and services as well as canonical models.
• BPM (Business Process Modeling) to understand how to align business and IT through better OLTP and DSS.
• Defined and designed directories and service calls in 100 + page System Requirements and QA Specification.
• Evaluated governance policy and enterprise business processes in order to chart new policy, methods, and roadmaps for achieving Six Sigma states in business and technology processes and system architecture.

Confidential

Responsibilities:

• Spearheaded international team to develop technical and business architectures and methodologies that greatly reduced risk in the enterprise data supply chain.
• Responsible for enterprise trade data model—XML and ERD—including messaging architecture and reporting via star schema and dimensional models around reference, market, and transactional data.
• Created and managed corporate compliance and governance (business and technical) architectures for all major financial regulatory bodies and other international regional exchanges.
• Worked closely with Managing Directors to formulate and execute strategic data models, meta data strategies, data subscription architectures, and risk management best practices in order to support Confidential Compliance and Operations for firm-wide equity transactions.
• Created data marts and reporting structures from LOAN IQ base entities.

Confidential

Responsibilities:

• Reporting to Confidential Managing Directors and head of Corporate Treasury Controllers, led data architecture and data modeling efforts for the Compass Debt Management Data Warehouse and ODS.
• Drove development and user requirements through iterative modeling of data, business processes, and architectural messaging components.
• Oversaw and carried out complex integration strategies and practices so that Debt Management OLTP data was distributed to various user segments in a multitude of customizations and dimensional classifications.
• Created meta data and transactional data models and routines in Informatica and Business Objects for DSS/BI

Confidential

Responsibilities:

• Reporting to Structured Finance (SFG) and Technology Directors, captured and modeled requirements and business rules for Confidential ’s Electronic Document Management System (EDMS), implemented in Stellent and MDY repositories with Service Oriented Architecture (SOA) via web services/portlets, XML, and SOAP.
• Help re-engineered business process by creating detailed Use Cases, Message Templates, and technical specifications throughout all aspects of the development cycle for DSS and compliance systems.
• Co-leading JAD meetings and sessions, ensured that EDMS continued to meet Confidential ’s core business needs and values by liasoning closely between business and technology in data architect, business analyst, and senior systems analyst capacities.

Confidential

Responsibilities:

• Reporting to Senior Vice Presidents and Vice President of Development/CIO, responsible for normalized and dimensional modeling, as well as managing data consolidation and transformation for DSS Executive Reporting Repository across multiple insurance business lines and profit centers. Enabled best of class business intelligence.
• Successfully managed and led two development teams (over one dozen people) on multiple and parallel enterprise data conversion projects. Interfaced and liaised with executive/senior management, vendors, Third Party Agents, and outsourced technical talent, satisfying most aggressive project deadlines in company history.
• Supervised Architecture, Design, Development, UAT, and versioning efforts while managing project risk and scope creep. Final approver of technical specifications, business analysis, and resource allocations.
• Unified WINS system with TPA and Producer claims and policy processing across all business lines: Property, Casualty, Workers Comp, Inland Marine, and more. Reconciled over one dozen external disparate claims systems.
• Reassessed and greatly improved current pricing model measures, dimensions, and associated member hierarchies for both Demographic (policies since inception) and renewal data stores and dimensional OLAP/ROLAP cubes.

Confidential

Responsibilities:

• Reporting to CIO, VPs, and global management: Devised complete architecture of Data Warehouse that implemented a consolidated and futuristic approach (dynamic ODS, XML, Process Control, Backup, Meta Data, Snowflakes, etc.) to conclusively integrate systems from over 30 countries.
• Integrated dynamic metadata into corporate knowledge factory/data warehouse.
• Liaised between global offices, outsourced labor, developers and business users, responsively attending to needs and concerns of all.
• Synergized management interviews, information gathering, and design meetings.
• Created and implemented business and data models for all warehouse functional areas—Security Master, Name and Address, Positions and Balances, Holdings, Transaction History, etc.—including new T+1 initiatives.
• Performed detailed and extensive analysis of conceptual and existing Confidential architectures, greatly helping consolidate brokerage and technologies on logistical, transitional and compatibility issues.
• Intensive data warehouse architecture and modeling (ERD/DSS) to improve continuity and business intelligence.
• Co-headed partnership with Computer Associates to steer development of CA’s Decision Based Transformer product so that it satisfied Confidential requirements, and advantageously positioned itself in the market place for ETL tools by offering best of class functionality in CRM initiatives.
• Led QA, Configuration Management, Data Warehouse, Tagging and Remittance, and ETL initiatives. Liaised between outsourced/offshore developers and Corporate Finance staff to solve sensitive issues and transitions in an expedient and friendly fashion. Administered and created databases, IT architecture, data movement and migration strategies, incorporating star/ snowflake schemas and matrix hierarchies into existing database designs to better facilitate true DSS and EIS ad hoc analysis.
• Created standards for error handling, version control, migration, performance, transaction management, and naming conventions, and ETL processing. Established a code base and documented components and process dependencies to modularize/compartmentalize enterprise warehouse, enabling compliance with SLA standards and speeding processing of financial and “tagging” data.
• Responsible for C++ DLLs and other messaging APIs—interface with Tibco, MQ Series, etc.
• Supervised JAD sessions and guided users in establishing coherent business rules that were fed into UBS MODELER metadata layers to create DACFA II. Upon this foundational data warehouse, established federated standards using hybrid architectures, table structures, linear programming logic, and snowflake structures, instituting true distributed and enterprise business intelligence.
• Led construction of dynamic Decision Support (DSS) data warehouse semantic layers for multi-dimensional data repositories, virtual star-schema data marts, and operational data stores (ODS) using UBS’ MODELER tool. Inventory of key financial and business elements metadata were modeled with these Universal and Uniform Semantic Layers, reducing time- constrained analysis and intelligence gaps, while speeding extra-departmental knowledge transfer.
• Consulted with, and advised top AIC management—Accounting, Finance, Portfolio Management—on data warehousing, batch logistics, business process reengineering, OLTP best processes, performance tuning, and interoperability/scalability issues. Streamlined business process by putting more information in the hands of customers and clients.
• Reporting to CIO: Primary managing resource and lead for Premium Finance Leasing System data modeling, archiving, data warehouse design and implementation. Liaised between technologists and business users, fostering enhanced communication and sharpened functionality.
• Responsible for interviewing, screening, and technically scoring prospective AIC employees and consultants for development team. Improved migration, code
• Managed, developed, and implemented numerous version control and migration standards for AIC Systems.
• Identified and eliminated duplication of business user labor and redundant coding/analysis efforts, drastically improving ROI on mission critical technology efforts. Destructive and flawed business processes were eradicated.
• Oversaw reengineering of DOE systems, putting a quick stop to duplicate benefit and training distributions and disbursements, protecting NYC taxpayers by reducing numerous instances of waste and fraud.
• Responsible for managing a wide range of duties—user interviews, business analysis/reengineering, project management, for Budget and Fiscal interests of agency. Designed, architected, and reengineered huge components and sections of applications, allowing for future enterprise-wide distributed objects.
• Using a three-tiered architecture methodology, transitioned legacy data from the city’s mainframe systems to the user-desktop to support both OLTP and state of art DSS systems. Return on investment of measurable and the New York media gave positive coverage to this project.

Senior IT Analyst

Confidential

Responsibilities:

• Managed, supervised, and developed entire project life-cycle for mission critical projects including Confidential and key initiative data-conversions and application efforts.
• The Core Topics System along with the Confidential rollout centralized all Confidential Research in Lotus Notes/Oracle databases.