SUMMARY

• 37 years US experience as highly accomplished data architect, data warehouse architect, hands - on cloud Architect, big data architect, for fortune 500 companies (optimal solutions with High ROI). Specializing in powerful designs that extract the maximum business benefit from Intelligence & Insight investments.
• Over 25 Years’ experience as data architect delivering business value.
• Data architecture, requirements collection, administration, ETL, HA/DR, Confidential architecture & artifacts.
• The lead Architect for Sun Oracle "Business Intelligence Center of Excellence". Implementing over 70 BI/DW & analytics on premise or cloud projects.
• Data Architect for Confidential & Architecture Review Board (ARB).
• Data modeling (logical, physical, dimensional & Star schema), Kimball & Inmon.
• Teach classes in University for MSBA in Databases, Analytics, AWS, Big Data, Redshift & NoSQL.
• Expert in Modern Enterprise Architecture using Big Data, cloud technology & data visualization
• Metadata, mapping, partitioning, indexing & aggregation strategies.
• Certified AWS Solution Architect, Technology Partner & AWS Trainer. Completed Amazon for authorized AWS instructors to teach certified AWS classes for architects & DevOps.
• Experience with AWS, Azure, SoftLayer, Private & Hybrid Cloud. Expert in SQL & NoSQL databases.
• Data Security/Encryption. Help companies migrate to modern enterprise architecture to stay competitive
• Roadmaps, technology stack selections, pilots and vendor co-ordinations.
• Redshift implementation & administration for DW.
• EMR, Cloudera, HortonWorks, Kafka, Kinesis & knowledge of Sparks 2.
• Senior DBA (Oracle, MySQL, SQL*Server, DB2). NoSQL (MongoDB, DynamoDB).
• Large migrations from RDBMS to MongoDB & DynamoDB NoSQL.
• Performance engineer for Confidential Corp.
• Invaluable experience with Confidential team to develop world class data warehouse for Confidential . My BI tools evaluation published. Big 4 consulting experiences. AWS Machine Learning & Predictive Analytics.
• Hadoop architecture and administration to improve effectiveness, cut costs, respond faster to the business..
• Work closely with executives & business users providing guidance to deliver value to the business. Proven leader on high profile successful projects.
• Business Objects, Cognos, Informatica, Syncsort, Pentaho, Talend.
• Mainframe & MS SQL Server BI. AWS: Redshift, EC2, EBS, S3, RDS, VPC, DynamoDB, Route53, ELB, IAM, CloudFront, CDN, Cloud Formation Lambda, Python. Metadata, mapping, ERWIN, Linux (RHEL, CentOS, Ubuntu).

TECHNICAL SKILLS

Languages: Linux shell, regular exp, Awk/Sed, grep, Python, JSON, COBOL, SQL, PL/SQL & TSQL.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Warehouse Architect

Responsibilities:

• Teach classes (Part Time) in AWS (Redshift, RDS), advanced analytics, Big Data (EMR, Kinesis), MongoDB, Spark best practices, dataframes, RDD, PySpark, Python, R, Databricks, Anaconda Jupyter, Zeppelin notebooks & Databases. Technology coordinator for Data Science & Machine Learning graduate programs in leading University. Support students on real life projects using machine learning models in areas such as Customer Churn & Sales Forecast.
• Data Warehouse Lead/Architect, ARC (Architecture Review Counsel), building next gen AWS data warehouse for community colleges. Technology stack selection, AWS Data Lake, architecture, Redshift, S3, Data pipeline, Kinesis & QuickSight. Student Information System & Learning Management System Canvas, Agile, Story board, Zoom, JIRA, Slack. Managing DW & Data Lake teams.
• Vehicle fleet management software (Integrated Telematics for Trucks & Analytics).
• Consulted Omnitracs on large EDW Modernization & Analytics migration from Oracle, OBIEE & Informatica to Hadoop HortonWorks, HIVE, Sqoop, Spark, Kafka & Data Lake on AWS for cost savings, meeting batch window & new data types. Led pilots. Tungseng, Flydata, Informatica Cloud, Attunity.
• Consulted Retailer to migrate its Confidential stack, SQL Server to build Confidential Multi-Tenant Point of Sale cloud web & analytics application. Cloud vendors’ selection (AWS, Azure & Rackspace), technology stack selection, database (SQL/NoSQL), data warehouse/analytics platform, BI/reporting tools & Confidential architecture options. Documented cost benefit analysis, capacity plan & vendor negotiations. Initial architecture with focus on Microservices & robust HA/DR. Evaluation of MongoDB Confidential, MySQL RDS, SQL Server Confidential, AWS RedShift, Azure SQL, Data Warehouse & Data Lake.
• Rescue project for Oracle11g performance audit to identify bottlenecks and document best practices.

Confidential, NY

Senior Data Warehouse Architect - Contracts

Responsibilities:

• =Re-architecture of major social gaming company, Confidential, AWS infrastructure with focus on performance, scalability, high availability & cost optimization. Presented effective HA/DR solution.
• Build POC to convert the social gaming relationships from MySQL & MongoDB to Neo4J graph database.
• =Security First Corp: Data Architect/DBA for Cloud & On-Premise: Installation, configuration & benchmarks of advanced security encryption for SQL/NoSQL databases (Oracle, MySQL, SQL*Server, Postgres, MongoDB, Cassandra) & Hadoop in AWS. Protecting PCI & PHI data.
• Performance testing tools including Jmeter. Redhat, CentOS & Ubuntu.
• Recruiting, building, and leading database testing team. Advisor to VP Ops, Sales, CTO & CEO.
• Creating & managing Virtual Machines on VMware ESXi & VSphere center.
• Built SAP HANA & Oracle EBS performance testing environment in AWS & IBM to test data encryption.

Confidential

Data Architect

Responsibilities:

• Fast & cost efficient initial assessment. Hadoop vendors’ evaluation & selection Installation, configuration, administration & optimization of Hadoop for Cloudera & HortonWorks. EDW Modernization, Hadoop, Data Lake pilot, Customer 360 pilot, syncsort Telematics IOT Trucking analytics for automotive co. - Storm, Kafka, Spark, HDP, AWS ML, ELK
• Presented consulting firms (Presidio & BlueShiftTek) to begin cloud & Big Data practices. Hands-on leader of cloud, Hadoop, NoSQL, BI/DW evaluations, pilots & production implementations that delivered high ROI. I used my experience with NoSQL, Hadoop (Cloudera, HortonWorks & EMR) or AWS.
• Presidio offers hybrid cloud solutions for public, private, multi-vendors & brokering.
• Principal Cloud Architect for AWS projects (includes Pre-Sales/Post-Sales Consulting):
• Projects qualification & sizing. Initial assessment. Requirements collection. Enterprise migration framework, roadmap & strategy. Enterprise level migration to new AWS architecture & rebuild of DevOps. AWS IAM management. Hybrid data warehouse, reporting & analytics using DynamoDB, Redshift & Tableau. On-premise Oracle & EBS migration. Oracle Disaster Recovery/HA on AWS AWS Machine Learning & Predictive Analytics pilot, Python, shell scripting, regular expressions MySQL migration to MySQL RDS & Aurora. MongoDB migration to AWS DynamoDB Postgres migration to AWS MongoDB. Media Streaming for gaming & social networking company
• DevOps: key player in a team managing multi-tier infrastructure: MongoDB replication, load balancers, web servers, app servers (apache, tomcat), Splunk for 24x7 online gaming.
• AWS automation & Configuration management: Ansible, Python boto, AWS CLI, Cloud Formation & bash shell scripting. Linux administration, provisioning. Windows experience. Docker, Kubernetes.

Confidential, Newport, CA

Data Warehouse Architect

Responsibilities:

• Large EDW Modernization & Analytics migration from Oracle, Microstrategy & Informatica to Hadoop. Presented cost effective cloud architectures & best practices for AWS Disaster Recovery/High Availability. Proposed an Enterprise Data Architecture model to revolutionize enterprise workload, make business more agile, cut costs, gain 360 view of customer for high ROI & ROA. Evaluation of AWS EMR, Cloudera, Hortonworks & Redshift. Informatica Data Virtualization, Tableau, Syncsort & Talend. Sandbox for predictive analytics and Data Discovery. Applications: insurance, capital investments, securities, mutual funds, annuities. Pivotal CRM, claims, commissions, architecture, IBM zOS, Web Services, XML, REST, Erwin, HDFS, Attunity, Hive, regular expressions & PIG.

Confidential, Newport, CA

Data Warehouse Architect

Responsibilities:

• Global company specialized in Recruitment analytics. I was tasked to build Confidential, Multi-Tenant, Multi-Zone cost efficient scalable cloud solution for unknown number of tenants.
• Defined cloud strategy, roadmap, optimal scalable architecture and implementation guide lines.
• Architected Global Talent Supply Chain Analytics solution for fortune 500 clients. The complex system integrates ATS software and web analytics data to deliver actionable intelligence.
• Cloud vendors evaluation, stack selection, cost benefit analysis, cost conscious cloud infrastructure. Evaluated OLAP, integration tools & databases. Informatica Cloud, Pentaho, Talend, Jasper. Vendor negotiations, demos and POC. HA/DR & replication solutions. Tableau BI analytics (dashboards).
• Designed ODS, Data mart flexible dimensional model. Redshift, RDS MySQL.
• Migration to AWS. Daily tasks, replications, data movement, cost optimization and backup/recovery.
• ETL to Redshift, S3, EC2, RDS, VPC, CloudWatch. Ubuntu, Attunity JSON, Git.

Confidential

Data Warehouse Architect

Responsibilities:

• Advised on migrating SQL Server databases, data warehouse & reporting to AWS using Redshift, DynamoDB, Attunity & Tableau. Replications, data movement, cost optimization and backup/recovery.
• AWS Cost optimization: Presented recommendations to save the company thousands annually.
• Advised on data integrating of disparate manufacturing systems, data quality and bridging issues.
• Evaluated datamart & reporting design. Sources: ERP & MS Dynamics CRM.
• Evaluated tools to replicate SQL Server to AWS. Developed a Pilot using Pentaho PDI ETL tool.
• Knowledge transfer sessions to management on best cloud practices & HA/DR techniques.

Confidential

Data Warehouse Architect/Lead

Responsibilities:

• Managing data across the full lifecycle from acquisition, through cleanse, transform, classify and storage to presentation, distribution, security, privacy and archiving. Agile, Scrum, TOGAF. Designed Conceptual, Logical & Physical models. Dimensional Modeling across divisions & enterprise
• Working with business units to identify business processes, process flow & data definitions.
• Data mapping, data profiling, data definitions and data modeling. IBM Doors tool.
• Project leader working with Lead Architect, Business, ETL Leads & PMs delivering quality integrated data designs on time and within budget within a fast - paced, multi-project environment.
• Data analysis, Data Migration Specification, Data Quality Plan & Meta Data Strategy. IBM Doors tool.
• Communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels. Influence multiple levels on highly technical issues and challenges
• Identify Data Sources, Data Attributes to Measure KPIs & Gaps in Data Stores.

Confidential

Senior Enterprise Architect

Responsibilities:

• JPMC Commercial credit cards: architect, evaluate and select BI tools to service its Federal Government Clients. Architected Proof of Concept (focus on data governance & data security).
• As a member of JPMC Architecture Review Board, participated in architecture reviews.
• Roadmap & Strategic Planning Support. IT Technology Roadmap.
• Worked with business units and leads to identify business processes, process flow & data definitions. Coordinate demos & development resources with vendors.
• Architected optimal & scalable BI architecture to support JPMC strategic initiatives. Reviewed IBM ERD Banking Model and designed dimensional model. Evaluated BI tools. ETL Specs for SSIS. SmartPay, TSYS, HP DDF, DEF, PaymentNet, SAP (Business Objects 4.0 Information Design, Webi, Dashboards), Mobile, MicroStrategy, Teradata, Oracle, SQL Server 2008/2012, Erwin, Data Stage, MDM, TOGAF.

Confidential, Idaho

Senior Data Warehouse Architect

Responsibilities:

• Contract to lead the development of strategic data marts. Guided business users to define requirements to deliver value to the business. Prepared architectural artifacts. Designed logical & physical data model in Power Designer. Agile, Scrum, MS Dynamics, PL/SQL.
• Worked with state officials & leads to identify business processes, process flow & data sources.
• Data Marts: Claims & Public Sector Case Management, Longitudinal analytics to provide decision - makers with tools to make informed, fact-based decisions. Created HLD, ETL Specs and developed pilot.
• Created flexible scalable architecture while emphasizing performance and business needs. Logical model, Star Schemas, DDL, capacity plan, Data Stage ETL, Business Objects Universes 4.0, Webi & Dashboard.
• Aggregation, analytic functions and materialized views. Partitioning & indexing strategies for Oracle11g. Tuning using Grid Control & AWR. Impact assessment for migration to Golden Gate, Exadata, RAC.

Confidential, FL

Senior Enterprise Architect/Lead (remote)

Responsibilities:

• For Confidential external clients, I designed optimal scalable architecture solutions using industry best architectural practices. Working closely with stake holders, I translated business strategy into strategic plans and maps to ensure the overall goals and vision of business owners are met. TOGAF.
• Managed and coordinated the implementation & communications between business owners IT staff.
• Led the design, development and support of complex EDW - ODS data architecture, database design, integration, mappings, ETL processes end to end.
• Interviewed enterprise-wide business to document requirements and produced architecture artifacts (mappings, data flows, process flows, HLSD, capacity planning, SLAs, servers & storage infrastructure).
• Profiled and analyzed data to identify gap analysis & data quality issues.
• Developed logical & physical dimensional data models using Erwin for data warehouse & data marts.
• Developed ETL specifications for developers to implement transformations and load processes for tight batch window. Developed strategies to collect and update metadata.
• Performance tuning of queries, database design and reporting tools. Implemented Partitioning, indexing & aggregation strategies. Developed standards, procedures for BI tools and systems.
• Worked with QA team to develop testing methodologies and best practices to follow on defects, JIRA.
• Technical resource and SME for senior management on how to turn data into actionable intelligence.
• Researching new technologies and making recommendation to include data visualization tools, virtualization and cloud architecture.
• . Around the clock support for Oracle ERP, SAP and PeopleSoft HR.
• . Oracle 11g, AWR, Statspack, Grid Control, partitioning, Materialized views, cubes & PL/SQL.
• Creation of cubes, reports. SQL Server 2008. BIDS, SSAS. SSIS, T-SQL, SSRS.
• Tableau, Business Objects, Cognos, Informatica, Erwin, Agile, Linux, SAS, DB2, Agile.

Confidential

BI Architect

Responsibilities:

• Interviewed users to define requirements. Conducted data warehouse audit to improve infrastructure, design, performance and functionality. Consulted with multiple teams to create an effective information environment. The new architecture eliminated redundant data, enhanced ETL and reporting. Developed data maps, DFD & HSLD. Evaluation of BI tools. Oracle ERP, NetApp, Cognos, DataStage, OWB.
• PACIFIC GAS & ELECTRIC (contract) ODS Architect
• Key player in ODS project data cleansing, profiling and integration, metadata, logical & physical model, design, infrastructure, tuning & ETL. Sourced from billing system SPL CorDaptix. Oracle, Informatica.
• BlueCrossBlueShields, LABI Architect

Confidential, Santa Clara, CA

Lead Enterprise Architect/Manager

Responsibilities:

• Business Intelligence Center of Excellence: Lead BI Architect for several large implementations for fortune 100 clients. Advisor to IT and management on enterprise - wide information delivery technologies.
• Managed multiple large teams of DBAs, sys admins, developers, analysts & domain experts.
• Sizing, planning for Infrastructure solutions deployable in Enterprise Data Centers, MPP, SMP, Unix, Web Servers, load balancers, switches, routers, firewalls, N-tier architectures, J2EE, Java, Performance tuning, modeling, Oracle, Business Objects, Cognos, ETL, Erwin.
• Sun/Oracle Apps Technology Center: Sizing, tuning, install, admin for oracle ERP, application and web servers. Investigated and selected Disaster Recovery Solutions. RMAN, SQL, Tibco middle ware, Java.

Confidential, Palo Alto, CA

Senior Oracle DBA

Responsibilities:

• Responsible for mission - critical, 7x24 NOC environment. American Airlines B2B.
• Supported airline reservation systems including high traffic OLTP e-commerce. Installed SNMP agents for HP OpenView. Installation, configuration, tuning and troubleshooting of Oracle, replication. Developing High Availability & Disaster Recovery solution. Shareplex, EMC, Oracle OPS.

Confidential, CA

Performance DW Architect

Responsibilities:

• Audit Enterprise Data Warehouse. Evaluated the hardware, Op Sys, Oracle configuration and the data warehouse logical and physical design. Implemented application tuning using partitioning, indexing & aggregation strategies that reduced the ETL processes run time by %450.

Confidential, CA

Senior DBA

Responsibilities:

• Design & support of the EDW database design. Developed ETL processes to the Orders datamart. Maintained logical/physical models. EDW interfaced to PeopleSoft, Oracle ERP & SIEBEL CRM.
• BUSINESS OBJECTS, Informatica. Supported Oracle ERP, PeopleSoft & Siebel.

Confidential, CA

SQL Server DBA

Responsibilities:

• Talus provides advanced statistical models to help clients such as Princess Cruises, Holland America & Northwest Airlines to predict their vacancies/bookings over time using seasonality, customer segmentation & various techniques. These models are used to drive marketing strategies to optimize their bookings and reduce vacancies. Data Modeler, Oracle, Unix & SAS.

Confidential, Santa Clara, CA

EDW Architect

Responsibilities:

• I was selected by Confidential eBusiness Director to Provide strategic plan to develop Sales and Marketing BI solution to use their internet data to develop marketing strategies and increase profitability. Identified Key Metrics to use them to identify business opportunities. Developed a delivery strategy to implement datamarts that seamlessly integrate to provide managers and key users, OLAP and Data Mining capabilities to uncover trends and patterns to develop closer relationships with their Channel Operations.
• Interviewed key users, designed star schema, and prepared project charter with implementation plan, and project size & cost. Erwin logical model, physical model, meta data and business rules. Built pilot on SQL Server. Prepared an al seminar to introduce EDW & OLAP concepts.
• Evaluated Business Objects, Cognos. Investigated Web Statistics tools, Clickstream Analysis. Designed Business Objects universes and Webi for reports.

Confidential, Palo Alto, CA

Lead Oracle DBA/Solution Architect

Responsibilities:

• Key player creating an Electronic Catalog for Confidential, an INTRANET application to create customized catalogs for their worldwide clientele. Object oriented design, Java.
• Evaluated tools and presented a Decision Matrix to Confidential Global Sales VP. Designed relational model using Erwin. Database Designer. Created Schema and supported team of developers.

Confidential, Santa Clara

Data Warehouse Administrator

Responsibilities:

• I was recruited by InfoDynamics (co - founded by Confidential ) to join the 3 co-founders to build world class customer focused data warehouse at WebTV.
• Two of the team members wrote best-selling series The Data Warehouse Lifecycle Toolkit . Improved query performance drastically by designing and implementing aggregation solutions.
• Responsible for creating and tuning the physical design and ETL load processing. Deployed tools to effectively automate monitoring usage, data loads and physical database growth. Red Brick warehouse server (developed by Ralph Kimball), Unix, tcsh scripts, RISQL, TMU, Brio OLAP.

Confidential, San Francisco

Data Warehouse Architect

Responsibilities:

• Data Warehouse & Data Marts for Inventory and Shipments Management to reduce inventory and forecast inventory demand. Project was a success & on target resulting in inventory reduction and significant cost savings. Developed Analytics solutions Oracle, Cognos, Business Objects SAS/SQL. PFIZER, San Francisco, CA Senior Oracle DBA

Confidential, Santa Clara

DW Specialist

Responsibilities:

• My highly regarded tools analysis published in HP global knowledgebase. Was recruited by Cognos & Business Objects as a Consulting Partner to represent them for their High Profile clients.

Confidential

Oracle SIEBEL DBA

Responsibilities:

• Sr. Data Warehouse Consultant: key player in Confidential team for database design, ETL development, testing, implementation and production support EDW. SAS, COBOL, Syncsort, SQL, DB2 to Oracle.
• Capacity Planner, developed a SAS - based Performance/Capacity Monitoring system (for over 200 servers). The performance data collected using HP/PCS. Developed complex batch SAS macros.

Confidential

San Francisco Oracle DBA

Responsibilities:

• The analytics application used for: Credit scoring, Collection analytics, Cross-sell, Customer retention, Fraud detection, Risk management & Marketing. JCL, COBOL, SAS, Syncsort DB2 SQL, CICS, IBM mainframe

Confidential, Hartford, CT

Data Integration Specialist

Responsibilities:

• Key player in developing customer information system. The application integrated data from 5 line of business applications. Used advanced analytics application to score customers based on advanced statistical models. The analytics application used for: Collection analytics, Cross-sell, Customer Retention, Fraud Detection, Risk Management. JCL, COBOL, SAS, Syncsort, DB2, IBM mainframe.