Founder/Enterprise Data Architect Resume Example

• Conducted a Data and DW architecture audit of Product Hierarchy to determine conformity to use cases and current implementation.
• Provided recommendations Customer MDM and System Integrator (Perficient) teams on attribute survivorship and entity resolution for Cusotmer MDM.
• Created conceptual, logical, and physical data models with Erwin for several hundred OLTP and DW entities and tables for Billing (SQL Server), Agronomy (Netezza) and EDW (3NF, Star/Snowflake).
• Architected, Managed, Delivered a DW MDM soucing 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 downstream systems.
• Create mappings for Datastage sourcing from PeopleSoft, Sql Server, XML files, and Netezza, From/to External data sources/targets.

Platform: Netezza, Erwin, SQL Server, Oracle, Aginity, Datatage, ETL mappings, SQL, XML & JSON analysis, BizTalk IBM Infosphere.​​

• 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.

• Analyzed and delivered a Data Masking enging to remove/mask sensive PII/HIPAA data for external vendor use.
• Tuned HCentive database & app and custom ADF app accessing HCentive db.
• Tuned several critical databases powering the State Health Exchange.
• Created performance dashboards using Splunk, AWR and ASH to monitor the health of the exchange during open enrollment.
• Identified data errors and and cleansed data in near real time during open enrollment.
• Deduped Customer data and created heuristic algorithms to determine a unique customer.
  

Platform: Oracle, HCentive, Data Masking, SQL, Excel, AWR, ASH, Splunk db_query, ADF Priv8Pay, Inc (Startup).

Using 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.

• Provide management consulting and advise on product development, product planning, and execution
• Cloud Architect.

• Managing a globally distributed team.
• Technical Advisor to the management.
• Define Product Strategy, and Direction Competitive Analysis.
• Analysis of credit card tokenization frameworks
• Analysis of block chains
• Analysis of cloud based IDM and other infrastructures of building highly scalable and responsive systems
  

• 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 and led development of Fusion Application clone releases which included RAC and delivered two releases of Fusion Application clone product.
• Represented client interests with Oracle Development and managed escalations.
• Created DR strategies for Fusion Applications.
• Utilized Exadata and Exalogic machines and presented product improvement feedback to Exalogic Development Teams.
• Led several successful On Premise to Cloud migration.
  
• Provided product feedback to SVPs and EVPs and created project proposals.
• Devised innovative ways to manage Fusion Applications lifecycle.

• 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 RAC.
• Provided hands-on technical architecture, design and coding.
• Conducted research and development for databases and storage with Fusion Applications.
• Tuned Fusion Applications databases including RAC using AWR and ASH.
• Installed and managed Oracle RAC instances for Fusion Applications installation and Clone product development. *Managed a team of A-Players on development projects.
• Managed several client relationships across the world.
• Led several high-profile customer engagements.
• Provided routine feedback to Dev organizations.
• Published in the A-Team Chronicles.
• Tools/Techniques: Fusion Applications, IDM, Exadata, Infiniband, BCDR, AWR, Performance Analysis, Replication, Product Development, Project Planning, Team Management, HR duties, ant.

• Developed the data models for case management using Oracle Data Modeler and provide Development guidance for the Legal Domain for ADF developers.
• Analyzed current and future architectures to map data from existing to new. *Created Conceptual, Logical, and Physical data models.
• Created reference data architecture.
• Tools/Techniques: Fusion Applications, IDM, Exadata, Infiniband, BCDR, AWR, Performance Analysis, Replication, Product Development, Project Planning, Team Management, HR duties, ant.

• 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.
• Worked with a team of DBAs, Domain modelers, and .NET Developers *Created innovative ways to meet project timeline to allow application rewrite using newer data structures using Oracle Views and Triggers that resulted in a successful and timely application release.
• Tools/Techniques: Fusion Applications, IDM, Exadata, Infiniband, BCDR, AWR, Performance Analysis, Replication,Product Development, Project Planning, Team Management, HR duties, ant.

• to the CTO acting as advisor to the CTO and CIO on Infrastructure, Data and Databases.
• Data security and Data Segregation using Oracle Virtual Private Databases.
• Evaluated NetApp and Hitachi for evaluation and made purchase recommendations.
• Created innovative Informatica tuning to convert ETL into ELT.
• Architected SAS Eminer implementation for a BI platform using Informatica, Cognos, SAS Enterprise Grid and Oracle.
• Gathered requirements from and drove business analytics for Biz Dev and CFO.
• Tuned SOA/ADF application architecture and performance tuning.
• Created Data models for transactions and BI using ER Studio.
• Created innovative PL/SQL techniques for XML, LDAP/Oracle, ELT interfaces for Informatica, SOA/BPE.

• Implemented an innovative CMDB for managing over 1000 databases, support ITIL functions, saving company 1M/year in opex and enhance SOX compliance.
• Spearheaded cross-functional initiative to implement Database as a Service using Heterogenous Solaris clusters using Oracle RAC.
• Advised senior IT leadership on IT Database strategies in BCDR, M&A Due Diligence, Data center layout, Staffing, Purchasing and network layouts.
• Partnered with KPMG and Internal Auditors to pass Sarbanes-Oxley (SOX) Audits, SAS70 Audits, and Internal Audits.
• Architected DR methodology for 1000 Databases backing up over 100TB/week.
• Setup Data/Information Lifecycle Management (ILM) using Hierarchical Storage (HSM), Net Backup and oracle RMAN.

• Enterprise database infrastructure and database administration Performance analysis of Oracle RAC on SP2 Oracle Cluster Performance analysis of Oracle RAC on Sequent Clusters using TPC-C and modified TPC-D Managed a team of Architects and the architecture steering committee.
• Created Database As A Service cloud computing infrastructure using Oracle RAC on Solaris.
• Created a DB infrastructure for over 1,000 databases, designed backup and disaster recovery for about 100TB of data over geographically dispersed data centers, designed HA using Oracle RAC, and architected and engineered for M&A.

• Database and application development.
• Performance analysis of Oracle RAC on SP2 Oracle Cluster.
• Performance analysis of Oracle RAC on Sequent Clusters using TPC-C and modified TPC-D.