SUMMARY:

• Enterprise Architect, Data Modeler and Developer - Over 25 years of experience with a broad knowledge of the Data Warehouse and Business Intelligence space gained from every past project. Hadoop experience and working on Big Data Architect certification.
• Hands-on developer on all technologies listed below.Senior level technical skills in developing and maintaining Data Warehouse solutions and design; including infrastructure, data modeling, data mining, system source analysis, ETL processes/architecture, data governance, database utilities and advanced SQL processes.
• Effective project Leader; capable of effectively communicating with a wide variety of users to gather, analyze, negotiate and document requirements. Both onshore and offshore experience with “very large” data volumes coordinated over several time zones.
• Past Oracle (Dev), SQL Server (Prod and Dev) and Teradata (Dev) DBA experience. Included maintenance, storage management, backups and restores.
• Infrastructure planning and design for technology solutions; includes risk management, vendors, costs and implementation best practices.
• I am enrolled in the Eindhoven University class 'Process Mining: Data Science in Action’, includes UML Activity diagrams.
• Udemy’s ‘AWS Certified Solutions Architect - Associate 2017’ to sit for the AWS Solutions Architect exam.
• Understands and utilized Big Data tools and data structures. Working on my Confidential Hadoop Architect certification.
• Understands BI capabilities of SAS, Business Objects, SQL Server SSAS, Brio, Cognos , MicroStrategy, Hyperion, Qlikview, Siebel Analytic (now OBIEE) and Tableau.
• Developed and understands competitive products such as Teradata, Netezza, Oracle (several versions), SQL Server, MySQL, Confidential DB2 and SAS (20+ years).
• Developed and architected ETL solutions using Confidential DataStage, Wherescape Red, SQL Server SSIS, Teradata Utilities, Ab Initio, Informatica, Oracle Data Integrator, Cognos Data Manager, SAS Data Integrator and Pentaho DI.
• Developed overall vision for client's Enterprise Information Lifecycle including road maps, data strategy, architecture, standards, quality and analytics to support strategic business initiatives.
• Have established modular data integration, master data and metadata management strategies and policies, data storage strategies and business intelligence solutions that have exceeded business expectations.
• Defined processes and evolved enterprise data architecture which included in the design best practices in areas that included standards, taxonomy, processes and methodologies, infrastructure, applications, quality, (either suggested or used a current) data frameworks and data models.
• Built strong cross-organizational relationships; effectively influence staff across the IT organization and broader enterprise to drive and realize enterprise data strategies and the tactical steps to achieve those strategies.
• Mentored, built teams & committees to set standards for data governance and master data management.
• Collaborated across business, management and information technology organizations to provide sound analysis and recommendations.
• Strong understanding of data modeling concepts (logical & physical), including OLTP and OLAP (3NF, star/snowflake schema, Data Vault) data structures for Enterprise Data Warehouses, Data Marts and Operational Data Stores.
• Maintains an up-to-date perspective of the information management industry including design and architectural patterns, best practices, industry and technology trends.

TECHNICAL SKILLS:

• Teradata v14
• Oracle (9i, 10g, 11g, 12c with ODI & OWB)
• Netezza
• Vertica
• SAS 9 (base, miner and macros)
• SQL Server & MySQL (open source)
• DB2 (extracted and loaded data)
• NoSQL and MariaDB
• Greenplum (web based training)
• OBIEE (former Siebel Analytics)
• Business Objects
• Cognos (Framework manager & Report Studio)
• SQL Server SSAS (built data cubes)
• SAS 9 (Base, SQL, Macros & Stored procedures)
• Tableau (data manipulation, reporting & visualization)
• MicroStrategy
• Qlikview (created Dashboards)
• Brio
• Pentaho (Data Integration)
• WhereScape Red
• Teradata Utilities ( Teradata Assistant, BTEQ, Multiload, Fastload, T-Pump and TPT)
• SQL Server SSIS
• Ab Initio (with EME)
• Confidential DataStage (former Ascential training)
• Informatica (including XML, XSD and SAP adaptors)
• Oracle Data Integrator (including Hyperion Essbase adapter)
• Cognos Data Manager
• SAS Data Integrator
• UNIX and Linux (Red Hat)
• Mainframe MVS
• Windows 10
• Netezza OS
• Concurrent Versioning System (CVS)
• Visual Source Safe (VSS)
• ClearCase Subversion (SVN)
• SQL (Expert) and NOSQL (User)
• C, C++, Java, Pascal (Delphi)
• COBOL (accessed using JCL and TSO)
• FORTRAN (IV, 95)
• Python (Proficient)
• Visual Basic
• Shell Scripting (Korn), Perl
• JavaScript (Udemy training certificate)
• Teradata Viewpoint and DBQL (Teradata tuning)
• ProM and Disco (Process Mining)
• Microsoft Office, Sharepoint and Project
• Erwin, ER/Studio, Powerdesigner & Visio
• SAS Dataflux
• Oracle Confidential
• Vi editor; SED; AWK
• Crystal Reports and SSRS
• Confidential Infosphere Relational Data Architect
• Textual ETL (for Bill Inmon)
• Mainframe - MVS/JCL/TSO/ISPF
• Communications ( Confidential & Teradata Telecom)
• Financial (Telecom, Credit Risk, Basel, Credit Cards, Commercial and Residential Mortgages)
• Manufacturing (Teradata models & SAP ECC)
• Insurance (Property & Casualty and Health)
• Public Petroleum Data Model (PPDM)
• Gaming (egames & player management)
• Retail (CPG)
• Confidential Banking (BDW) data model
• Health care (modelled in 3 rd Normal form, star schema and UML)

PROFESSIONAL EXPERIENCE:

Confidential

Data architect

Responsibilities:

• Designing and building a Confidential solution using a MariaDB database and model.
• Using retail data to process mine for processes and potential bottlenecks using ProM and Disco mining tools.

Confidential, Sunnyvale, California

Solution Architect and ETL Technical Lead

Responsibilities:

• Responsible for Solution, Infrastructure, Reference architecture, led (LDM and PDM) data modeling (in PowerDesigner) and the gathering of requirements, conducted Workshops (JAD) and lead client technical interface. Primarily manufacture subject area with drill down on Quality Notification, Complaints, RMA, Testing and Failure analysis data.
• Sourced and remapped SAP ECC, SAP CRM and Saleforce.com data source to an Azure cloud solution.
• Determined the risk management of solutions between MPP, COTS, clouds and others
• Developed different graphs using Tableau for Bill Inmon. The data was mined using Inmon’s Textual ETL tool (Texting mining tool) from a Healthcare Insurance provider.

Confidential, San Antonio, Texas

Senior SQL ETL Developer

Responsibilities:

• Extracted data from Oracle and Access databases and SAP SD tables for KPIs using Business Objects Universes, queries with ODBC and BEx connections.
• Also, used Excel for visualizations and dashboards.
• Worked with the business to strengthen their testing processes and data quality.

Confidential

Senior Data Warehouse Architect

Responsibilities:

• Part of 4-person group accessing current IT environment. Doing a current and future state.
• For my part of the project, I evaluated Oracle and Teradata semantic layers, data models in Erwin (reversed Engineered DDL), BTEQs, Informatica ETL and PL/SQL.
• Determined risk management of data quality associated with reports and the silos that they had created.

Confidential

Data Warehouse Architect and ETL Development

Responsibilities:

• Coordinated and resolved ETL development and issues.
• Architected a BI stream of work on Netezza.
• Documented and coded Ab Initio’s Graphical Data Environment ( Confidential ), Python and Metadata Data Warehouse (MDW) and data flow information.
• Completed a gap analysis between client’s change management and Confidential issue logs and procedures.
• Used Infosphere IDA tool with Eclipse Java to implement Confidential ’s BDW model for both the LDM and PDM. Put on an Enterprise Data Governance stream of work.
• Used Oracle Data Integrator to show/demonstrate data lineage in solution documents.
• Determined the risk management for data lineage, MDM and data quality.

Confidential, Oklahoma City, Oklahoma

Senior Database Developer/Amalga Database Administrator

Responsibilities:

• Administer and audit security access for a Production SQL Server Amalga (Healthcare) database.
• Optimize other Production Hospital databases.
• Roadmap (strategic and tactical) for a data strategy that includes MDM, data governance, data models and other standards.
• Worked with Administration group to do backups and restore data as needed.
• Determined the risk management for SQL Server execution paths.

Confidential, Lafayette, Louisiana

Senior Data Integration Consultant

Responsibilities:

• Integrated data into Essbase data cubes using Oracle Data Integrator (with the Essbase adaptor) for a Hyperion Planning oil and gas financial planning application including income statements, cash flow and forecasting.
• Confidential Integration with ODI. Analysis of OBIEE and Micro Strategy reports and intelligent cubes to get data requirements. Mitigated issues with both data quality and data design.
• Providing functional, technical specifications and testing documentation.
• Included SSAS, SSIS and SSRS.
• Determined the risk management of ETL tools that could be used in the final solution.

Confidential, Chicago, Illinois

Enterprise Data Management Consultant and ETL Architecture

Responsibilities:

• DB2 and Oracle data using DataStage as ETL and Cognos as the BI tool.
• Architect, design and documentation for an Oracle data warehouse using Oracle Data Integrator (ODI). Validated Legacy metadata.
• Determined the risk management issues associated with ODI.
• First international project for the corporation (currency, volume and weight conversions). Rich’s is in 8 countries.
• Error routines and incremental batch numbers used.

Confidential, Phoenix, Arizona

Senior Data Strategy Architect and ETL consultant

Responsibilities:

• Interviewed Confidential senior managers, directors and vice-presidents concerning data issues. Grouped issues and gave impact on business. Determine project and data model risks.
• Worked with Data Architects to bring up their credibility backup Enterprise wide. The group had several setbacks and false starts on previous projects that I had to overcome.
• Created a plan for an Enterprise Data Strategy and initial tactical steps to achieve alignment with business objectives. The plan addressed the needs for a road map which contained data governance, master data management, standards, metadata strategy and more. Also, determined gaps in processes and documentation.

Confidential, Minneapolis, Minnesota

Senior Teradata ETL Consultant

Responsibilities:

• Project 1 - Teradata consultant for Confidential ’s Strategic Financial Planning Funnel group - forecast planning by comparing sales data for last year, current year to current week and next year (planning forecast). Debugged and tuned queries (using DBQL, Viewpoint and Explain plans) for semantic layer (consumed by Java screens and MicroStrategy). For performance issues re-wrote extra complex views/queries that were developed by Confidential ’s offshore development group. Tableau used for data manipulation and visualization.
• Project 2 - Pharmacy ETL project, used Teradata loading utilities, gathered requirements, source to Confidential mappings, user accept testing and training. Wrote stored procedure in Java. Worked with Confidential data Administration group to do backups and restore data when they accidently removed files that stored the development BTEQs. Included SSIS in them.

Confidential, White Plains, New York

Senior Data Warehouse Architect and ETL development

Responsibilities:

• Analyzed data sources, negotiated formats and landing of both internal (SAP APO, M-Factor/Demand Tec and forecast data) and external (IRI, Nielsen, Nitro, Vision Chain, Retail Link and other syndicated data) for the data warehouse.
• Tableau used for data manipulations.
• Data modeler for the group - Developed and designed Data model for data warehouse (3rd normal) and data marts (star schema) using Erwin.
• Architected and built Semantic reporting layer.
• Developed and architected ETL solutions using Confidential Data Stage, Wherescape Red, SQL Server SSIS, Teradata Utilities, Ab Initio, Informatica, Oracle Data Integrator, Cognos Data Manager, SAS Data Integrator and Pentaho DI.
• Infrastructure planning for the following technologies: Database - Oracle and SQL Server 2012; ETL tool - Informatica; Business Intelligence - Business Objects and Qlikview.
• Used Oracle Data Integrator ELT and Informatica as the ETL tool.
• Developed sFTP and shell scripts for data movements and manipulations.
• Data quality profiling using Erwin profiling tool and making updates to data as needed.
• Setup all process around the data warehouse including error logging.
• Master data management - define and describe customer, product and UPC hierarchies. Consolidated different hierarchies for same subject areas.
• Completed training, documentation and mentored IS staff in data warehousing.
• Contract extended past primary term.

Confidential, OKC, Oklahoma

Senior Teradata ETL Data Warehouse Developer

Responsibilities:

• Loading data into a Teradata Enterprise Data Warehouse and then extracting from it too.
• Doing extracts from a mainframe (with COBOL copybooks), Oracle and SQL Server.
• Analyzed COBOL code that created Confidential in-house reporting.
• Mainframe - TSO/ISPF and submitting batch jobs (uses JCL with Teradata TPT, BTEQ, Multiloads and Fastloads).
• Doing data quality checks and updates to data as needed.
• Created Universe for Business Objects users.
• User Acceptance Testing with Confidential Auditors and IT group.
• Documentation included source-to- Confidential mapping, functional, technical and testing documents.
• Mentored Confidential developers, architects and DBAs.

Confidential

Senior Data Warehousing Architect and ETL development

Responsibilities:

• Designed new reporting database for the Business Intelligence group using Qlikview BI tool.
• Optimised ETL Cognos Data Manager Code and processes.
• Mapped ETL data flow in Cognos Data Manager.
• Created a new way for Cognos Data Manager to do Change Data Capture with little or no impact on the SAP (Oracle) source system. Brought the batch loading window down from 22 hours to 4 hours using grouping data and dynamic SQL.
• Data Warehouse Appliance, migration planning, administration management (included backup and restore software) and ETL tool evaluation.
• Presentations to management and senior architects on LDM (3 rd normal) data modelling, case tools, latency, concurrency and error handling.
• Analysis of Data Warehouse appliances.
• Created Tableau dashboards from SAP SD (sales and distribution) meta-data to monitor progress of ETL data during the night’s batch window.
• Did Confidential for Confidential 's Infosphere DataStage, Infosphere Data Quality, Infosphere Discovery (data profiling) and Infosphere Change Data Capture tool and required infrastructure.
• Reviewed and wrote requirements for Netezza Data Warehouse appliance solution. Also, convinced the CEO of Netezza (from the USA) to make a sales presentation in the Helsinki office.
• Confidential for CA-ERwin data modelling tool and Confidential .
• Mapped Business process and brought them in-line with new LDMs for the business views.
• Taxonomy from the business processes and incorporated them into the new LDMs. Proposed a new architecture incorporating CDC and SCD into the fact and dimensional table loads and PDM.
• Mentored Wärtsilä resources on conceptual, logical and physical data modeling.
• Proposed a new Metadata strategy that would use the new proposed (ETL/ELT, CDC and data modeling) tool capabilities.
• Built up expertise in SAP R/3 ERP solution in the billing, shipping, sales/order, materials management and invoicing (mostly in the MM and SD and some in the FI areas) of Wärtsilä's Confidential business. Mentored and trained employees to do data warehouse data modeling and architecture roles.

Confidential, Round Rock, Texas

Senior Data Warehousing Architect and ETL Consultant

Responsibilities:

• Several sub-projects for each separate source system.
• Communicate with Offshore development in Russia and India.
• Used ER/Studio and Erwin data models and generate DDL.
• Created a security Access Control List (ACL) for access to all database objects.
• Also created templates for ETL mapping, test plans/cases and metadata.
• Designed and implemented an Infrastructure plan for the SQL Server Confidential solution.
• Data sources included Teradata, Vertica, Oracle Business Intelligence that queried Oracle OLAP data cubes, Non-structured Excel data (generated from Siebel Analytics, now OBIEE), Business Object universes and data the populated dashboards (Xcelsius), SQL Server 2008 and Data Allegro data warehouse appliance and Confidential is SQL Server 2008.

Confidential

Senior Data Warehousing Architect/Informatica ETL Developer

Responsibilities:

• Informatica developer using Teradata, Oracle and DB2 for Planning Sales data, did weekly aggregations by store and SKU; summing quantities, sales, returns, cancels and open sales. This work used Informatica Pushdown optimisation and ELT with SQL overrides. Created Test plans and test cases documentation.
• Reverse Engineered JDA sales planning data. Architected, modeled data (using Erwin) and extracted from JDA planning data in an Oracle database. Extracted using Informatica and then loaded into Teradata tables. Sourced Oracle, SQL Server 2008, Teradata, AS400/RPG and COBOL data.

Confidential

Senior Data Warehousing Logical Data Modeler

Responsibilities:

• Part of Confidential ’s Confidential data warehouse team that is assigned the most complex and largest projects. Completed training for their Telecom data warehouse Logical data model that included the M1 and Rational (now Infosphere) Data Architect.
• Started cross-training on Confidential ’s BDW logical data model and Eclipse Java.
• Taught to up-sell additional work for Confidential by presenting data marts to answer specific business questions that could be sourced from the communications data warehouse.

Confidential

Senior Data Warehousing Architect/ETL Consultant

Responsibilities:

• Documented, Optimised and increased data quality.
• Mentored their current data warehouse team to get the data warehouse functional again.
• Documented a Data Governance strategy with included Master Data Management.

Confidential, Catoosa, Oklahoma

Senior Data Warehousing Consultant

Responsibilities:

• Gathered Requirements and documented processes for data flows.
• Reverse engineered the IGT data models for Machine accounting, Cage Table accounting and Player management.
• Analysed IGT Advantage stored procedures, views and reports for source system data.
• Completed Mappings and populated tables using SQL Server 2008, SSIS.
• In Architecture document suggested plans to implement a Data Governance strategy with included Master Data Management.
• Test plans and test cases.
• Used SSRS for duplicating current reports used by the Cherokee Hard Rock Casino.

Confidential, Dayton, Ohio

Senior ETL Data Warehousing and Migration Consultant

Responsibilities:

• Created same granularity attribute tables that improved data quality and performance.
• Improved Primary Indexes so that it was distributed across all AMPs. Also, used secondary index on joins and collected statistics.
• Improved Cognos development, reporting and queries.
• Created User Defined Functions, Java based, for filtering data
• ETL tools - Teradata Utilities and BI tools

Confidential, Catoosa, Oklahoma

Senior Data Warehousing Consultant

Responsibilities:

• Gathered Requirements and documented processes for data flows.
• Interviewed Source System Developers to build/document Business Rules.
• Created ODS and Data Warehouse data model.
• Completed Mappings and populated tables using SSIS.
• Created naming and environment standards.
• Regenerated report to match current Slot Accounting and Patron Management reporting.
• Used SQL Server 2008 Analysis Services (SSAS) for creating data cubes for drill down reporting using SSRS.
• Test plans and test cases to show discrepancies in current reports.
• Completed Conceptual (Technical and System) architecture documents.