SUMMARY:

An IT modernization and transformation expert at large enterprises, deploying EDW, Master Data Management, Data Quality and Data Governance best practices for 'end - to-end' delivery of large ‘multi-million dollar’ cloud transformation projects.

EXPERIENCE:

Confidential

Solution Architect / Big Data Scientist

Responsibilities:

• leading a new venture startup with a team of Confidential students, and data scientists. This new ventures is currently entered in the Confidential $300k Entrepreneurs Challenge through W. R. Berkley Innovation Labs.
• This new venture startup is on ‘Better Sleep’, deploying the latest in sleep innovations like phototherapy, melatonin, soothing sound/music, all with a blue-tooth connected sleep mask. The masks are being prototyped and developed in Shenzhen, China.
• We are also exploring the Confidential markers through big data artificial intelligence (AI), and machine learning (ML) to identify the 25% portion of the population who are susceptible to sleep issues, i.e., can’t sleep due to work, long distance air travels, insomia, migraints.
• The technology stack consist of Cloud Computing, Big Data, additional wearable device IoT sensors like Fitbit, and Apple iWatch, AI, ML, plus others. Technology stack included: Python, MariaDB, SQL database and Toad workbench. These are mobile native applications all in real time, and updates data for offline users as soon as they are connected. We are using AWS technology eco-system in cloud computing using Amazon S3, EC2, DynamoDB, Lambda functions, Amazon RDS, Redshift DB, Spectrum and EMR as enterprise data warehouse for BI reporting.

Confidential

Master Data Architect

Responsibilities:

• Created the cloud transformation/modernization roadmap and strategy, the selection of appropriate cloud technology by documenting as-is architecture, to-be architecture, and gap analysis. Creating artifacts that included not only CDM, LDM, and PDMs; but also Data Flows, CRUD Matrix, Change Management with impact analysis. plus, how the data all related to internal ERP data with respect to system of record to core data from the enterprise, as well as externally sourced Social Media/Salesforce data consistent with enterprise business objectives.
• Design solutions, build consensus, sells and execute solutions across business areas with complex mission-critical projects portfolio.
• Design modern enterprise arechitecture with serverless API/microservices, DevOp, AWS, Azure or Google.
• Data Warehousing, EDW, OLTP, OLAP, ODS and BI Data Marts; DDS and Big Data. Agile and SDLC methodology, enabling data sciences, Machine Learning, and Artificial Intelligence. Besides a Master Data Hub for HR, ERP and GL/COA, build out multi-channel client architecture that provided differentiated end-user experience - Spoke local use architecture.
• Transform applications into cloud-based technical solutions by porting to open-sourced cloud technical platform solutions with agile and scrum processes for POC and prototyping. Served as scrum master for the development team on data.

Confidential

Responsibilities:

• Led the design and deployment of a BI Reporting Data Mart for Regulatory Risk reporting as part of the overall IT modernization project effort at this global rating organization.
• Built out a comprehensive data model in order to sunset a dozen legacy applications in a data-led transformation/modernization with 7 conforming dimensions connected to EDW.
• On the legacy on-promises BI, built out an OLAP time-based BI reporting dimensional data mart in Oracle DB with Confidential as well as Snowflake schemas using Embarcadero’s ER/Studio modeling tool following agile/Kanban methodology.
• AlsoDeployed a cloud-based multi-tenant modern BI and analytics Saas with Confidential to improved business agility with fast to market, rapid source data discovery, onboarding of data, all with self-service, and visualization reporting capabilities.

Confidential

Responsibilities:

• Applying enterprise Master Data Management and Governance best practices, using Informatica MDM tools for ETL.
• SAP ERP, CRUD Data Quality Governance for a ‘single version of the truth
• Deploying a master reference data hub from enterprise Human Resources data services with APIs to future-proof IT architecture using TOGAF’s data-led framework.

Confidential

Big Data Scientist / Solution Architect

Responsibilities:

• Leading a non-profit startup, using the publicly available official big data from NYC government to do good for the public.
• The new technology venture’s name is ‘ Confidential ’.
• The ‘ Confidential ’ project was entered in both the 2017 nyc.gov’s BigApp competition for the public good, and the Entrepreneur Challenge at Confidential ’s Innovation Lab.

Technology stack consist of: AWS, Express.JS, Node.JS, Python, MariaDB SQL database and Toad workbench.

Confidential, New York, NY

Enterprise Data Architect /SaaS Solution Architect / Project Manager

Responsibilities:

• Successfully implemented a global digital training portal in the Cloud which enables McKinsey project teams to learn and collaborate seamlessly in the cloud 24X7, regardless where an individual team member is physically located in the world. Managed a team consist McKinsey and Vendor architects and developers from both on-site and offshore.
• Led Scrum of scrum Agile project approach, coordinated user stories for business, as well as software development by Sprints using business story designs and points all documented in JIRA. Alteryx is used for data cleansing and data integration ‘Proof of Concept’. Tableau to visualize reports, and ConformIT for surveying.
• Reviewed various usage of Human Resource data, defined a common ontology, and created an Enterprise Data Hub - provisioning the employee data to all downstream application systems. Enabling firm-wide to collaborate effectively and efficiently with pristine data coming directly from the source HR "system of record' with base reference blocks by organizational unit data domain like job roles, offices, and others. Sync up with Oracle ESBus.
• Deployed a MyDevelopment/MyLearning Portal - for coordinating the staff development, training and performance at the enterprise level. Evaluated existing training process workflow, identified data gaps, and proposed future state architecture with a 'step-by-step' strategy and road map; standardized central governance, policies and streamlining the training process workflows. Aligning business strategy of staff development to Information Management (IM) strategy and roadmap, and technology infrastructure to support continued innovation of technology platforms, such as: service-oriented architecture (SOA) with API web services, messaging with enterprise services BUS, mobile technology, combined Cornerstone Learn Services OnDemand (Saas) in the cloud, and big data (with Salesforce client data on demand in the cloud). This mission-critical project was successfully deployed into production globally on schedule and on budget, August 31st, 2016.
• As enterprise master data architect, tasked to design and define a common taxonomy/data dictionary for the firm.
• Set the overall architectural direction for Enterprise Data Warehouse, OBIEE and Data Marts for employee data hub for enterprise analytics reporting.
• Tools used are: Oracle eBS, OBIEE, Informatica’ MDM, IDQ and PowerCenter, Toad for Oracle, ESBus, MS Access DB, Confidential for Data Modeling, Alteryx for DQ/DG profiling.

Confidential, New York, NY

Enterprise Master Data Architect/ Solution Architect

Responsibilities:

• Led major client engagements as the enterprise master data architect in data integration and modernization, by assess the current state, develop future state data strategy and road map by setting the overall architectural direction at the enterprise level. Design of common enterprise-wide Integration DevOps processes with agile, test-driven implementation for availability, reusability, recoverability, scalability and performance on multiple platforms.
• Partner with CIO/CDO perferforming business process modernization and data transformation using the latest in technology innovations for key TCS clients, such as: Confidential, JP Confidential Chase, Confidential Capital ( Confidential ) bank in financial services industry, AXA Equitable, Hartford, AvivaCanada, AIG, and AFLAC in the insurance industry, plus others like Comcast, Fluor, ConAgra Foods, Wyndham Hotels, and Disney.
• Evaluated existing workflow processes utilizing enterprise architecture framework like TOGAF, identified any gaps, and proposed future state architecture with a 'step-by-step' road map, streamlining and simplify workflows, and standardize policies and methods to drive business process efficiency, and lowering risk and cost both.
• Aligning the enterprise business strategy to Information Management (IM) road map, also mapped to enterprise (COBIT) technology framework and infrastructure to support continued innovation of new platforms, such as: mobile technology, cloud services, social media and big data that include both structured, and un­structured data contents.
• Development of IM components and data access interfaces across the enterprise by key data domains such as Customer (CRM), Product/Services (PIM), PNL (GL/COA) and HR (Employees' data) via APIs and SOA (Service-oriented Architecture) to provide self-serve capability for the whole communities of business users.
• Define and promote the Master Data Management (MDM) of key data, it’s usage and the data quality throughout the whole enterprise for Customer, Product & Services, Employee (HR) and financial data's control and management through General Ledger's Chart of Accounts (COA), all part of EDM (Enterprise Data Management).
• Established a common reference data architecture enterprise-wide, educate both the business and the development teams on the data lineage with regard to all stages of data enrichment/development framework, data lifecycle, data quality and data governance for both the applications, as well as the technology platform stacks.
• Instituting on-going Data Quality and Data Governance programs at the enterprise level with standards and procedures, with SME and data owners identified, and data stewardship all properly identified and assigned. Finally, empowering the data stewards with the proper User Interface, plus Data Dictionary tools to do their jobs well.
• Expert at business analysis, following the TOGAF enterprise architecture framework by weaving together the four major pillars: Business, Data, Application, and Technology platforms. EDW database standards were documented.
• Agile project management, experienced at turning business requirement into achieveable milestones and delivery.

Confidential

Responsibilities:

• Designed and delivered a roadmap for a Data Warehouse/BI solution for consolidated FRTB regulatory reporting and the tracking of cash and cash-equivalent, allocation of capital, and traded collaterals for various subsidiary banking entities of this large IHC/FBO; Worked closely with multiple lines of business, technology partners, and senior management to articulate future vision/strategy, execute efficiently to the plan with overall governance. For the delivery phase, focus is on BI reporting on risk-based capital and leverage requirements, and in prepsaration for stress testings. Created dimensional data model on Oracle DB, used PL/SQL to create test case data. Documented the step-by-step controls, data verification gates, logging and calculation routines. Provided full data traceability back to each source Treasury data systems by each LOBs for cash and cash equivalent product.

Confidential

Responsibilities:

• Identified all 'Sources and Uses' for key master data, and the core data's life cycle (for example, individual consumers and small businesses for credit cards, mortgages, financing loans, …. etc.
• Created a global business glossary and data's taxonomy with data quality standards, rules, standard policies and procedures, and data governance defined. Proposed the KPI measures to monitor "the state of Master Data Quality (DQ)" - An On-going Data Management, Surveillance and Controls, and Disaster Recovery plan.
• Conducted a feasibility of creating an alternative Operational Data Store (ODS) in Teradata. Then to replace the often non-responsive DB2/UDB database to Cassandra DB in waves.
• Two options were explored, one being conducting a Proof Of Concept (POC) ODS on Teradata database, and the other being replacing it directly with a Cassandra NoSQL DB. It was decided to go with Teradata database first.

Confidential

Responsibilities:

• Led a 13+ months of 4-year effort for ingesting 17 source data streams by each financial product source; submitted roadmap and standard interfaces for 40 more data streams to be done with offshore resources for the year of 2013)
• Led the TCS's on-site BIPM team for Confidential 's Post Trade Technology unit, owned and responsible for bringing together various data source streams, i.e.: Equity, Bonds, OTC Derivatives, Cash Equity, Stock Borrow, distressed Loan trades to arrive at a unified central analytics platform at the enterprise level as the "golden source" for Risk Management, Trading Surveillance and Compliance, Capital Planning and Investment Controls (CPIC).
• Leveraged Investopedia for standard industry terminology for the various financial products and services.
• Owned and responsible for overall enterprise-wide strategic conceptual data architecture for institutional trade processing, post trade processing and settlement, also owned both logical and physical data models and architecture for the project. Confidential tool were used for data modeling, DDL generation and data dictionary.
• Technology platform include: IBM DB2, Cognos BI reporting, Informatica ETL maplets, and Qlik view dashboard.

Confidential, New York, NY

Solution Architect/Enterprise Data Architect/Senior Business Analyst

Responsibilities:

• Designed & planned an enterprise-wide platform for delivering common Building reference data by using SOA, XML schemas, with Web 2.0 services using SOAP on .NET Platform, to replace legacy PowerBuilder IT platform. Designed and implemented an agency-wide operational (OLTP) and decision-support (OLAP) Data Warehouse (DW) on Oracle RDBMS called HPD INFO. MS SQL Server DB were also used for staging (landing zone) database. Messaging queuing in a publish and subscribe paradym to distribute master data asynchronologically.

Confidential, Jersey City, NJ

Solution Architect/Enterprise Data Architect

Responsibilities:

• Led and facilitated a Confidential enterprise-wide master data management (MDM) architectural initiative with data architects from the entire company, both from the Fortune-500 parent, as well as dozens of other Confidential subsidiaries.
• Owned and led the enterprise data architecture, being part of the Merger & Acquisition team for the Confidential the parent to acquire Confidential, stitching together dozen or so critical application capabilities for Confidential Investment Services (CIS) division across different software and hardware of Fiserv’s Technology platforms.
• Focused on enterprise data domains such as: Sales & Marketing, Portfolio Performance Measures and Matrix, Financial Instrument's Product Research & Analysis by leveraging Enterprise Ontology/Data Dictionary (EDD) from existing Confidential 's corporate Data Dictionary (CDD), align it to the Ontology of the parent Fiserv’s.
• Market Data vendor management on Reuters, Boomberg and EBS, direct market price access for pricing.
• Prior to the Merger & Acquisition activity by Fiserv, successfully designed and implemented CIS ( Confidential Investment System) which has over 1,000 database tables. Some 300+ are core tables covering 17 major data domains such as: Account, Transactions, Business Partner, Performance & Benchmark, Program, Strategy-Style-Model, Pricing & Corporate Actions, Security, User, and Common Reference.
• Also built an anti-money laundering detection and surveillance program into CIS system per regulatory requirement. CIS has a total of $120 billion asset under management covering all asset classes, both financial and real estate.

Confidential, New York. NY

Solution Architect/Enterprise Data Architect

Responsibilities:

• Using my extensive experience in VLDB, successfully brought flexibility and scalability to Confidential 's various lines of businesses, such as Confidential corporate travels, and Site59's sales channels with the rest of Confidential sales data, to be reported off the central Business Intelligence Passport Teradata databases, with non-mission critical data staged locally on MySQL databases. Used agile project development methodology on a Fraud detection project. Led the business stakeholders, and dozens of architects/developers’ enterprise-wide on this Fraud detection project, spanning all world time zones (Europe, Africa, India, and South Pacific), and cultural spectrum.
• Administered, monitor-ed and maintained large-scale Oracle production databases across Confidential, globally. Cluster partitioned the production Oracle databases by date ranges and four regions of the world on historical data for business intelligence reporting for users. (Pre-prototype were first deployed on MS SQL Server databases.)
• Successfully tuned the production Oracle and MySQL databases by rationalize the number of indexes on top IS critical tables, got rid of redundant, unused, and badly conceived indexes using explain plan tool.
• For example, just for the main Customer Account table, I have reduced the number of indices on it from 34 down to 15. As result, the production database performance improved by almost 50%.

Confidential, Jersey City. NJ

Enterprise Data Architect/ Senior Solution Architect/Data Warehouse Designer

Responsibilities:

• Designed and proposed the strategy and roadmap for enterprise data warehouse (EDW) with multiple BI data marts by subject areas, such as: Party, Legal Entity hierarchies, Security Master with Confidential , adding market data by security/asset type, Sales & Marketing, Product offerings and hierarchy, and Product Research.
• Gathered FIX/SWIFT financial industry and ISO standards for best practices for equity trades, also designed fixed income (bond) trade and foreign currency swaps, published in a global canonical data model for enhanced trade processing, enterprise-wide.
• Provided market data via direct market access through vendors like Reuters, EBS, and Bloomberg for pricing.