SUMMARY:

• Senior Data Warehouse Architect (with strong development skills) - broad knowledge of the Data Warehouse and Business Intelligence space.
• 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 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.
• Completed TDWI’s ‘Data Science Bootcamp’ on 1-18-2017 and Udemy’s Spark Machine learning on Big Data.
• Udemy’s ‘AWS Certified Solutions Architect - Associate 2017’ in order to sit for the AWS Solutions Architect exam. The AWS solution covers Redshift and HPC tools and cloud formation templates.
• Completed an Azure cloud solution sourcing SAP HANA data (SAP ERP ECC and CRM data).
• Completed Udemy’s ‘OpenStack: Install, build and run IaaS cloud with Open Stack’.
• Evaluated SAP HANA Live for Confidential as replacement for a SAP ERP ECC installation.
• Understands and utilized Big Data tools and data structures. Working on my Confidential Hadoop Architect certification - tools includes Cassandra, Map Reduce, Hive and Pig. Created, loaded and read data from Hadoop Data File Structures (HDFS).
• Functioned as the liaison between technical and business resources within the organization to develop requirements and Use Cases.
• Several lead positions, the largest was in 2015 for Confidential in Mexico City, Mexico at the country’s largest Mexican owned bank - over 200 resources. On my last project in Sunnyvale, CA, I had 12 resources both onshore and offshore.
• Understands BI capabilities of SAS, Business Objects, SQL Server SSAS, Brio, Cognos , MicroStrategy, Hyperion, Qlikview, Siebel Analytic (now OBIEE) and Tableau.
• Understands competitive products such as Teradata, Netezza, Oracle, SQL Server, Confidential DB2 and SAS (30+ years).
• Developed and architected ETL solutions using Wherescape Red, SQL Server SSIS, Teradata Utilities, Ab Initio, DataStage, Informatica, Oracle Data Integrator, Cognos Data Manager, SAS Data Integrator and Pentaho Kettle.
• 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.
• Ability to present effectively in front of large groups, including non-technical and executive audiences and negotiate effectively among all groups.
• Maintains an up-to-date perspective of the information management industry including design and architectural patterns, best practices, industry and technology trend.

TECHNICAL SKILLS:

• Working on my Confidential Hadoop Architect certification - experience includes Cassandra, Map Reduce, Hive and Pig
• 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
• WhereScape Red
• Teradata Utilities ( Teradata Assistant, BTEQ, Multiload, Fastload, T-Pump and TPT)
• SQL Server SSIS
• Ab Initio (with EME)
• DataStage (former Ascential training)
• Informatica Powercenter
• Oracle Data Integrator (former Sunopsis)
• Cognos Data Manager
• SAS Data Integrator
• Pentaho Kettle
• UNIX and Linux (Red Hat)
• Mainframe MVS (with JCL, TSO/ISPF, CICS & VSAM)
• Windows 10
• Netezza OS
• Teradata v14
• Oracle 12c (with ODI)
• Netezza
• SAS 9 (base and macros)
• SQL Server
• DB2 (extracted and loaded data)
• Concurrent Versioning System (CVS)
• Visual Source Safe (VSS)
• ClearCase Subversion (SVN)
• SQL (Expert) and NOSQL (user)
• Java, Pascal (Delphi)
• C/C++
• COBOL (accessed using JCL and TSO)
• FORTRAN
• Python (Beginner)
• Visual Basic
• Shell Scripting (Korn)
• JavaScript (Udemy training certificate)
• Perl
• Teradata Viewpoint and DBQL (Teradata tuning)
• SQL Server SSRS
• Microsoft Office, Sharepoint and Project
• ERwin and SAP Powerdesigner
• SAS Dataflux
• VISIO (and the data modeling version)
• Vi editor; SED; AWK
• Crystal Reports (BOBJ and with ERwin)
• Confidential Infosphere Relational Data Architect
• Textual ETL (for Bill Inmon)
• Mainframe - MVS/JCL/TSO/ISPF

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, California

Solution Architect and Project Technical Lead

Responsibilities:

• Solution, 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.
• 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 Architect

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:

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

Responsibilities:

• Interviewed Confidential senior managers, directors and vice-presidents concerning data issues. Grouped issues and gave impact on business.
• 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 Consultant

Responsibilities:

• 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.
• Stores ETL project, used Teradata loading utilities, gathered requirements, source to Confidential mappings, user accept testing and training.

Confidential, White Plains, New York

Senior Data Warehouse Architect

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

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 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.
• 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.
• 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 global business. Mentored and trained employees to do data warehouse data modeling and architecture roles.

Confidential, Round Rock, Texas

Senior Data Warehousing Architect

Responsibilities:

• Several sub-projects for each separate source system.
• Communicate with Offshore development in Russia and India.
• Used Erwin to model 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.
• Data sources included Teradata, 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 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 global 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.
• 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/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 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 - Cognos and Business Objects.

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.

Confidential, San Jose, California

Ab Initio/ Source System Consultant

Responsibilities:

• Provide Ab Initio support for Teradata.
• Ab Initio ETL; Business Objects on a Teradata database.
• Interviewed Source System Developers to build/document Business Rules.
• Mappings from Source System to e-Retail LDM.

Confidential, Boston, Massachusetts

Senior Data Warehousing Architect

Responsibilities:

• Explained strategy, design and implantation plans to Executives (C-Level) and senior managers concerning integrating data, data warehousing and business Intelligence for various business engagements.
• Create data models including conceptual, logical and physical designs for health and property and casualty and others. UML, 3 rd normal and dimensional. rescued an Oracle data warehouse project that was under-planed, under resourced and had a non-workable data model. Cognos was the Business Intelligence tool used. lead technical effort to strategize a conceptual data warehouse. Did analysis of sources systems and processes to identify gaps and opportunities. Delivered a UML data model, data architecture (with data flow) and system architecture.
• ETL tool was Informatica and BI tools - Cognos , Hyperion and Business Objects. Report Analysis done on all three to consolidate.

Confidential, Chicago, Illinois

Data Warehousing Architect

Responsibilities:

• Designed and built data warehouse using MS SQL Server 2005.
• Designed physical data model for home and commercial lending/mortgages.
• Created a dimensional data warehouse data model using type 2 SCD.
• Used SQL Server SSAS to build aggregations for a Foreclosure information data cube.

Confidential

Data Warehousing Architect

Responsibilities:

• Project planning and managed resources.
• Red used to build data warehouse.
• Review/Comment on departmental data warehousing initiatives.
• Developed Logical and Physical data models for new data warehouse using Erwin.
• ‘Hands-on’ developer using SAS Data Integrator and Oracle Data Integrator ETL.
• Built data warehouse team with Oracle 10g, DB2 and SAS tool skills.
• Put together documentation templates for functional, technical, detailed data flow design.
• Setup testing, creating testing templates for all phases of testing.
• Designed migration process for development, testing, QA and Production.

Confidential, Winston-Salem, North Carolina

Teradata Data Warehousing Architect

Responsibilities:

• Created Solution Architect documents.
• Cognos was the Business Intelligence tool for the project.
• Identified data sources and interdependencies.
• Interviewed resources, built team.
• “Hands on” ETL development using Oracle Data Integrator.
• Reviewed the Logical Data Model (LDM) using Teradata’s Confidential Data Warehouse LDM. Test plans and test cases.
• Conversion of the LDM to a Physical Data Model (PDM).

Confidential

Senior Data Warehousing Consultant

Responsibilities:

• Health Check - review/comment on Confidential data warehousing efforts.
• Review/Comment on Confidential data warehousing efforts.
• Review/Comment Oracle Data Warehousing Builder.
• Review/Comment Oracle Data Integrator.
• FORTRAN loading routines.
• Suggested new solutions to match their business needs.

Confidential

Senior Informatica & ETL Consultant/Trainer

Responsibilities:

• Project Managed India resources for Optimisation and Performance INFA workflows. Informatica Administration
• Credit Risk and Basel II training
• SAS Credit Risk and Basel II experience used Data Flux cleansing tool
• Oracle and DB2 source systems
• Introduced ODI (at that time called Sunopsis) as a second tier ETL solution to eliminate cost because Informatica was processor cost based.
• Redesigned a Business Object Universe queried for analytics.
• Fix defects found in development, testing, and quality assurance and production stages of the data warehousing life cycle.
• Consult concerning defect configuration processes.