OBJECTIVE:

Create sustained and significant business value, growth, and market opportunities through innovation, partnerships, and by leveraging the organization’s information assets.

SUMMARY:

• Consummate professional with over 25 years of experience in Enterprise Data Architecture and Application Development, leading with a strong passion for Data, Data Science, and Analytics, creating and leading dynamic teams to consistently deliver cost effective and manageable solutions to complex business problems.
• Database Architecture, Administration, Performance Analysis, and Tuning
• Finding data patterns, data mining, data forensics and creating Enterprise Master Data plan.
• Managing terrbyte and petabyte systems and architecting the data and information lifcycle for data storage, analysis, and reporting.
• Communicating with executives, developers, vendors and auditors and managing global teams, projects and escalations
• Resolving interpersonal conflicts, and finding pragmatic solutions via consensus.
• Conducting user interviews/JAD and creating use cases, user stories, business requirements.
• Performing due diligence - Mergers and Acquisitions (M&A).
• Creating product and technology roadmaps.
• Enterprise strategies and solution architecture.
• Data Governance, Data Quality, Conforming Dimensions, Master Data analysis, entity rule definition.
• Creating Information Architecture, data flows, and data analysis.
• Defining Enterprise Data Strategy for BI and defining Data/Information Lifecycle Management policies.
• Defining and implementing Data Security, Access controls, and Data masking for compliance with various regulations such as SOX, HIPAA, PPI, PCI DSS.
• Managing/mitigating business and technology risks.
• Data gathering, quality, and preparation and defining mappings from a variety of data sources and types such as structured and unstructured data.
• Heuristics development for customer matching - using soundex, and other algorithms such as Levenshtein and Jaro Winkler.
• Managed/Participated in Database and Data Migration from data centers across the country during 7 M&As.
• (Co)Founded for profit and Non-profit organizations. Served as board member and officer.
• Pioneered Database as a Service using Oracle.
• Conceived and Developed the DBA Console to save 1M/yr. on opex and keep FTE low.
• Applying data science to music/signal analysis.

TECHNICAL PROFICIENCY:

• Data Modeling (Erwin, ER Studio, Oracle Data Modeler) for OLTP, 3NF, Dimensional modeling, and Source to Target Mappings.
• Data Analysis, Architecture, Lineage, Data Cleansing, Data Mining, Data Quality, Data Masking.
• High Availability and BCDR ( Confidential, Active/Passive replication, Data Guard)
• Programming (SQL, PL/SQL, Swift, Perl, Python, SciPy, scikit-learn)
• Software as a Service SaaS (REST, Identity Management, Google App Engine)
• Data security, encryption, fine grained and row level security
• Databases (Oracle 10g/11g/12c, Netezza, SQL Server, PostgreSQL, MySQL, Hadoop)
• SQL (Oracle, PL/SQL, SQL, impala, presto, spark, beeline, hive)

WORK EXPERIENCE:

Confidential, Colorado

Founder/Enterprise Data Architect

Responsibilities:

• Independent Consulting. Various Clients since 2007
• Evaluated startup companies and ideas for Venture Capitalists.
• Created and marketed Database Management platform product for managing storage, high availability, disaster recovery, data life cycle, regulatory compliance, and data flow.
• Consulted with multiple clients on high availability, disaster recovery, regulatory compliance, performance tuning, data warehousing, data modeling, and business intelligence concepts.
• Built Oracle connector to Postgress/Netezza as part of a startup.
• Innovated Database As A Service.
• Provide management consulting and advise on product development, product planning, and execution
• Managing a globally distributed team.
• Technical Advisor to the management.
• Defining product strategy, minimum viable product, product direction, competitive analysis, and market niche.
• Analyzing of credit card tokenization frameworks, block chains, and mobile payment frameworks.
• System integration with various partners’ cloud and SaaS implementations.
• Developing REST API on Google Cloud Engine (GCE).
• Platform: Google Cloud, Swift, Python, REST, iOS mobile UI/UX, PCI DSS, AHP (Analytic Hierarchy Process), SaaS, Bluetooth LE (BLE 4.0), MQTT, Beacon programming, Proximity based application behavior.

Confidential, California

Consultant/Chief Architect

Responsibilities:

• Defining product strategy, market and competitive analysis, financial viability, and release scope.
• Evaluated vendors to determine technical, business, and financial compatibilities.
• Review contracts.
• Create specifications for REST API for SaaS model.
• Evaluated cloud providers for SaaS and cloud hosting of product.
• Applied for patent on innovative uses of technologies in Identity and Access management.
• Define and develop mobile strategy.

Confidential, Loveland, Colorado

Consultant/Data Architect, Data Modeler

Responsibilities:

• Conducted a Data and DW architecture audit of Product Hierarchy and delivered a gap analysis.
• Provided recommendations on Customer MDM and System Integrator (Perficient) teams on member definition, entity resolution, and attribute survivorship
• Delivered conceptual, logical, and physical data models using Erwin for several hundred OLTP and DW entities and tables for Billing (SQL Server), Agronomy (Netezza) and EDW (3NF, Star/Snowflake).
• Architected and delivered a DW MDM sourcing from IBM Infosphere Customer MDM via BizTalk through Datastage.
• Analyzed and profiled Customer data to determine data quality and implemented EDW wide data cleansing including impact analysis to downstream systems.
• Review Datastage mappings sourcing from PeopleSoft, Sql Server, XML files, and Netezza, From/to External data sources/targets.

Platform: Netezza, Oracle, SQL Server, Datastage, IBM Infosphere.

Confidential

Consultant/Performance Analyst

Responsibilities:

• Conducted performance benchmark using modified TPC-DS to assess the maturity of SQL clients on Hadoop (Hive, Beeline, Spark, Impala, Presto).
• Ran benchmarks and performed quantitative comparative analysis on both structural (SQL syntax supported) and performance.
• Determined relative maturity of Bigdata SQL interfaces and traditional ANSI SQL.
• Created a labeling scheme to transform degree of SQL for quantitative analysis.

Platform: Hadoop (Cloudera, Hortonworks), Excel, Shell Scripting, Hadoop SQL (hive, beeline, spark, impala, presto), Hadoop file formats (Orc, Parquet), TPC-DS.

Confidential

Consultant/Performance Analyst, Data Analyst

Responsibilities:

• Analyzed and delivered a Data Masking engine to remove/mask sensitive PII/HIPAA data.
• Tuned several critical databases powering the State Confidential proactively, and during open enrollment surges.
• Created performance dashboards using Splunk, AWR and ASH to monitor databases during open enrollment.
• Identified data errors and cleansed data during open enrollment.
• Deduped Customer data and created heuristic algorithms for unique customer.
• Determine customer using soundex, and word distance algorithms such as Levenshtein and Jaro Winkler routines in Oracle.

Platform: Oracle, HCentive, Data Masking, SQL, Excel, AWR, ASH, Splunk db query, ADF, SOA.

Confidential

Consultant/Data Architect, Data Modeler

Responsibilities:

• Performed data architecture and data modeling for Medical Insurance Fraud Detection in the Healthcare
• Insurance domain using Oracle Data Modeler.
• Revised the medical fraud detection using PL/SQL packages and procedures for rules and heuristic based fraud detection.
• Created innovative ways rewriter applications to use existing data Oracle Views and Instead-Of Triggers that resulted in a successful and timely application release.

Platform: Oracle Data Modeler, .NET, Oracle 11g, Confidential, Exadata.

Confidential, Colorado

Chief Data Architect

Responsibilities:

• Reported to and acted as technology and data architecture advisor to Confidential .
• Created dashboards and visualizations wireframes for CFO and analyzed company performance.

Confidential, Colorado

Database Architect/Manager Database Architecture & Infrastructure

Responsibilities:

• Implemented an innovative CMDB for managing over 1000 databases, support ITIL functions, saving company 1M/year in opex and enhance SOX compliance.

Confidential, Colorado

Founder/Analyst

Responsibilities:

• Defining product strategy, financial viability, and release scope.
• Analyzing classical music using machine learning algorithms to extract features and characterize temporal variations.
• Developing python based services on AWS Elastic Beanstalk for python based machine learning.

Platform: Google App Engine, AWS, scientific python, SyPy, sckit-learn, svm.

Confidential, Redwood Shores, California

Director, Fusion Applications

Responsibilities:

• Managed a global team of A-Players both direct reports and dotted-line.
• Supported high profile customers across the world and executed several projects in the United States, France, Dubai, South Korea, India, South Africa, and Australia in the areas of Fusion applications architecture.
• Directed Fusion Application clone development and delivered two releases of Fusion Application clone product.
• Provided product feedback to SVPs and EVPs and created project proposals.
• Represented client interests with Oracle Development and managed escalations serving as a liaison.
• Created DR strategies for Fusion Applications.
• Led several successful On Premise to Cloud migration.

Confidential, Redwood Shores, California

Consulting Solution Architect

Responsibilities:

• Supported high profile customers’, onsite or remote, projects in the United States, France, Dubai, South Korea India, South Africa, and Australia.
• Directed and led development of Fusion Application clone releases which included Confidential .
• Provided hands-on technical architecture, design and coding.
• Conducted research and development for databases and storage with Fusion Applications.
• Tuned Fusion Applications databases including Confidential using AWR and ASH.

Platform: Fusion Applications, IDM, Exadata, Infiniband, BCDR, AWR, Performance Analysis Replication, Product Development, Project Planning, Team Management, HR duties, ant.

Confidential, Colorado

Chief Data Architect

Responsibilities:

• Reported to and acted as technology and data architecture advisor to Confidential .
• Created dashboards and visualizations wireframes for CFO and analyzed company performance.
• Evaluated NetApp and Hitachi and made purchase recommendations for storage rearchitecture for the CIO/ Confidential .
• Implemented data segregation using row level fine grained security and Oracle Virtual Private Databases.
• Rearchitected Informatica ETL for ELT using Oracle procedures for higher throughput & performance.
• Architected SAS Eminer implementation for a BI platform.
• Created Data models for transactions and BI using ER Studio and tuned SOA/ADF applications.
• Innovated using PL/SQL pipelined functions to make search meet SLA.
• Solving complex problems in SOA, Informatica through critical and out of the box thinking and creative problem solving - example: Creating piplelined functions in Oracle to solve ADF pagination and optimizing search results.