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.
• 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, data quality, system source analysis
• ETL development, processes and architecture, data governance (includes MDM), 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.
• Lead Banking data architect for Confidential in Mexico City on the Banorte project in 2015 (other banking projects too).
• Big data experience with Hadoop Distributed File System, used Pig and Hive - in Scala and Storm.
• Used several sources in formats that also included HL7, XML, XLS, JSON, HTML, COBOL copy books and others.
• Designed, sourced and targeted 3rd normal, dimensional/fact and data vault data structures.
• Past Oracle, SQL Server and Teradata DBA experience. Included storage management and backups/ restores.
• Infrastructure planning and design for technology solutions; includes risk management, vendors, costs and implementation best practices.
• Understands BI capabilities of SAS (base and macros), 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:

Database Technologies/Business Intelligence Tools: Industry Data Models: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)

ETL Tools: Languages/Scripting:

Other Tools and Applications: I Public Petroleum Data Model (PPDM) Gaming (egames & player management) Retail (CPG) Confidential Banking (BDW) and Teradata Financial Services data model (FSDM) Health care (modelled in 3rd Normal form, star schema and UML)

PROFESSIONAL EXPERIENCE:

Confidential - Tulsa, Oklahoma

Data Architect and Data Modeler

Responsibilities:

• Design and build a Health Exchange Information analytics data model, sourcing HL7 and CCDA clinical data from providers and payer information. Used ERwin as the data modeling. I also did a base assessment on the quality of data and documented the data flow with MPI and MRN data source information.

Confidential

Data architect and ETL Developer

Responsibilities:

• Designing and building a Confidential solution using a MariaDB (NoSQL) database and model. Using retail data to ‘Process’ mine for defined and non-defined processes and potential bottlenecks using ProM, Disco Process mining tools, SAS (base and macros), and SQL Server.

Confidential

Data Warehouse Consultant

Responsibilities:

• Documenting, modifying and tuning Claims and Provider ETL stored procedures and Informatica mappings for 3NF DB2 data warehouse source to fact/dimensional SQL Server Confidential . Taught data modeling, how complex ETL procedures works, lineage, how to resolve issue and make changes.

Confidential - Sunnyvale, California

Solution Architect and ETL Technical Lead

Responsibilities:

• Responsible for Solution, Infrastructure, 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. Designed a cloud architecture that included AWS and Azure.
• Sourced and remapped HANA, SAP ECC, SAP CRM and Saleforce.com data source to an Azure cloud solution. The migrations tools used included SAP SLT, BODS with SDI and SSIS.

Confidential - San Antonio, Texas

Senior Data Extraction Consultant

Responsibilities:

• Extracted petroleum trading data from Oracle, OBIEE reports, 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. They told that 25% of the refined petroleum products were traded on the floor I worked on.

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. There were also some Hadoop data structures that I analyzed.

Confidential - Buffalo, New York

Senior Data Warehouse ETL Architect and Developer

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 and ETL consultant

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 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 . Worked with Confidential data Administration group to do backups and restore data when they accidently removed files that stored the development BTEQs.Q

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.
• 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, 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.
• Greenplum and POC to replace petroleum revenue tax database.
• User Acceptance Testing with Confidential Auditors and IT group.
• Documentation included INFA 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 (3rd 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 POC 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.
• POC for CA-ERwin data modelling tool and GoldenGate.
• 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 Logical Data Modeler

Responsibilities:

• Part of Confidential ’s Confidential data warehouse team that is assigned the most complex and largest projects. Completed for their Telecom data warehouse Logical data model that included the M1 and Rational (now Infosphere) Data Architect.
• Started cross- 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.

Confidential - San Jose, California

ETL/ 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

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, 3rd normal and dimensional.
• Health Markets (Dallas, Texas) - 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.
• Sentara (Virginia Beach, Virginia - integrated hospital group - 7 hospitals and several other organisations) - 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, Siebel Analytics (now OBIEE), Hyperion and Business Objects. Report Analysis done on all three to consolidate. Data Quality - DataFlux. Modeling tool - Erwin.

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 and ETL consultant

Responsibilities:

• Project planning, built and designed infrastructure and managed resources.
• Wherescape Red and Java subroutines 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 Manufacturing 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 (OWB to ODI).
• Review/Comment Oracle Data Integrator ETL and Embarcadero Data modeler.
• FORTRAN and Java 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
• 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.

Confidential

ETL Consultant/Trainer/Architect

Responsibilities:

• ETL architect for Philippine side of the project, set up ETL environment for developers.
• Trainer for Ab Initio used Informatica, Ab Initio and native database loading tools for ETL development.
• Oracle and Teradata sourcing and development.
• Sourced and extracted several systems including SAP BW/Oracle tables.
• Performed analysis on different Interfaces between several external and internal (Seibel Analytics - now OBIEE), Confidential and source systems.
• Created IFB batch load scripts
• Test plans and test cases.
• Created batch architecture to use with ETL loads.
• Oracle, DB2, SAS, Cognos, Business Objects and Teradata (Teradata to Oracle) and Siebel Analytics (now OBIEE).
• Passed in parameters to use at load time so that we can reuse graphs.
• Created and modified Interface Agreements for functional design and detail designs.
• Provided coding assistance for junior Software engineers and did development myself (hands-on).
• Created tested data, testing documents and test cases for development and testing.
• Worked with Application testing to clear up discrepancies, preformed needed modifications.
• Localisation for databases targets and source using Japanese double byte characters.
• Contract extended three times.

Confidential

Senior ETL /Change Request

Responsibilities:

• Change Request - Changing a data mart feeds to a data warehouse feeds for a sales and marketing dependant data mart. Documented Analysis, detailed design, IDP and test cases.
• Trainer for Ab Initio to ETL development and DBA team.
• Ascential (now DataStage) .
• Mainframe accessing Teradata; JCL, Fast Exports, Multiloads and BTEQ.
• On the UNIX side, Korn shell scripting and UDFs written using Java and C++.
• Unit testing and integration testing.
• Oracle to Teradata and Teradata to Oracle database conversions.

Confidential

Senior ETL / Informatica Consultant

Responsibilities:

• Confidential MasterCard and Private Label Credit Cards information. Full development life cycle using mainframe flat files loaded using Informatica into a Redbrick Data Warehouse.
• Merged all the disparate and often conflicting records on customer’s information and transactions into one authenticated master file - Master Data Management.
• Technical specifications, Unit and Integration testing plans and Implementations plans.
• Coordinated with companies in India (offshore development company) for extracts and change request. Wrote requirements for the India team.
• Teradata evaluation to replace Redbrick data warehouse.

Confidential

Senior Consultant

Responsibilities:

• Evaluate web site development for the content web management tool Vignette.
• Evaluate web site development and architecture and the content web management tool Vignette.
• Test plans and test cases.
• Automate Access database loading procedures using Excel VBA.

Confidential

Senior Teradata ETL Data Warehousing Consultant

Responsibilities:

• Migrated Oracle CRM to Teradata data warehouse.
• Infrastructure design and build for Teradata solution.
• DBA - Managed Teradata development machine.
• ETL using UDFs, MLOAD and BTEQ.
• Managed Confidential work for LDM AND PDM.
• Migrated Oracle CRM to Teradata data warehouse.
• Test plans and test cases.
• Create a (Universe) dimensional model for Business Objects reporting.
• Cleansed data using Excel VBA.

Confidential

Senior Informatica ETL Specialist

Responsibilities:

• Informatica 5.1 developer.
• DB2, PeopleSoft application and Business Objects.
• Started project with no documentation.
• Wrote a DB2 triggers for PeopleSoft.
• Test plans and test cases.
• Automated testing processes using Excel VBA.

Confidential

Senior Teradata ETL Warehousing Consultant

Responsibilities:

• Data Modelling for PDM (and did optimisation from LDM) - financial, call detail and VoIP.
• Oracle to Teradata using ORA2TD tool.
• Data Quality Analysis - reviewed and commented on over 500 ETL processes.
• Query performance and tuning
• Taught SAS/Teradata Interface class
• ETI development doing Multiloads (source to staging) and BTEQs (staging to Confidential ).
• Test plans and test cases.
• Clear Quest Issues - set privileges, created views, generating DDL and work on the PDM.
• Automated procedures using Excel functions and VBA.
• DBA group - loaded data using UDFs, Multiload and BTEQ.
• Data Quality issues. Because of the 2 GB UNIX limit, partition the data then wrote shell script that consolidated ET and UV tables, in order that the same load could be restarted if there was an error.
• Developed a Korn Shell Script and C program that counted pipe delimiters that was causing problems when the data itself contained pipes in the data.
• Completed a primary and secondary index analysis for major tables and reports.
• Query performance tuning.
• Used Net Vault backup utility.

Confidential - Indianapolis, Indiana

Senior ETL Consultant

Responsibilities:

• Re-engineered clinical drug trial information to comply with the Health Information Privacy and Accountability Act.
• Enhanced data flow by effectively building coalitions with all groups within Confidential Pharmaceuticals.
• Combined Clinical Trial and drug data - this was eventually morphed into GXP regulatory compliance for accountability and traceability.
• Automated cleansing using Excel functions and VBA.
• Assumed Technical Lead for ETL effort (Informatica 5.1).
• Performed analysis on existing ETL processes, primarily from SAS, Oracle and DB2 on MVS, UNIX and AS/400.
• Improved security by working with Data Security to analyse Oracle databases and UNIX to identify security exposures and mitigation.
• Completed a risk analysis and developed a plan to turn MVS/JCL into Korn shell scripting, port the validated SAS code to UNIX, change VSAM data sets into sorted SAS data sets, and use the same DDL from DB2 for an Oracle Confidential .
• Test plans and test cases. Performed Confidential /Teradata evaluation.

Confidential, San Francisco, California

Senior Teradata Warehousing Consultant

Responsibilities:

• Appointed the SAS/Teradata Expert for the “in-house” statisticians.
• Orchestrated the design, development, and implemented a customer campaign management and market segmentation project using the Ab Initio ETL tool.
• Did Oracle to Teradata migration using ORA2TD tool.
• Automated Testing using Excel functions and VBA.
• Used UDFs, Mload, BTEQ and Tpump (for near real time loads)

Confidential - Dallas, Texas

Senior Teradata Warehousing Consultant / ETL Lead

Responsibilities:

• Completed analysis of business facets to determine transformations, gaps and data source to Confidential .
• Reduced bill processing time from twenty hours to five minutes using Teradata.
• Completed data mapping to Confidential logical CRM model for communications.
• Ab Initio ETL tool used.
• Worked on the logical model to facilitate the physical model using the Erwin modelling tool.
• Oracle to Teradata using ORA2TD tool.
• Reduced billing processing time to five minutes from twenty hours by orchestrating the migration of an Oracle 8I, 9 Terabyte datamart to Teradata.

Confidential

Teradata ETL Data Warehousing Consultant

Responsibilities:

• Initiated Churn analysis and data warehouse design.
• Brio report development.
• Played a pivotal role in the integration of new market data into existing national WISDEM Data Warehouse using Ab Initio for a consolidation of marketing information and a main production database comprising data for all markets for AT&T Wireless including kiosks, retail centres and call centres.
• Served as Technical Lead for a six-member team responsible for Teradata migrations form SAS, SQL and COBOL/VMS to BTEQ with source data coming from multiple systems residing in the eastern half of the United States and from legacy systems (SQL 7.0 Server/ODBC) in California.
• Initiated and consulted on the WISDEM Intermediate Data program that is recognised by AT&T Wireless nationwide.
• Managed a two-node development database development box for project planning, modelling, coding, testing, SDF format for client feedback and production.
• Spearheaded the creation of a new database “HROW” to automatically update static tables residing in WISDEM, including writing code to act as date/time triggers and working with Executive Management and Production to carry out extensive test planning and walk-throughs.
• Coordinated new market Teradata database loading, testing, shell scripting, BTEQ, Multiload and Fast Export.
• Automated Unit, System and Integration testing scripts (including test plans, test cases, test results for Teradata/UNIX environment) with shell scripts.

Confidential, Irving, Texas

Senior ETL Consultant / Lead

Responsibilities:

• Created SAS data marts for Confidential ’s Fraud Department to show any outliers with property and casualty agents.
• Created SAS data marts for development reporting environment. Used Korn shell scripting to handle data flow which also had exception handling for errors.
• Used Cron jobs to automate process for nightly execution.
• Implemented SAS data warehouse and DB2 loader for Confidential Insurance.
• Test plans and test cases.
• Created MVS/SAS reports for Confidential ’s Fraud Department creating statistical models to show any problems with agents and reported information.
• Executed Y2K remediation and identified a date problem after all remediation had been completed.
• Dramatically reduced amount of development time required for writing SAS programs by introducing SAS pseudo-coding to the programming staff.

Confidential - Norman, Oklahoma

Consultant

Responsibilities:

• Provided software support and for entire university community.
• Hired to work with all Departments in the University system to provide software support and . Provided programming support for several languages including SAS, Delphi, Visual Basic, Microsoft Visual C++, FORTRAN, Pascal, SPSS and COBOL.
• Worked on several platforms including the MVS/TSO, DEC VAX 6000/VMS, Confidential RISC 6000/UNIX/AIX. Installed Confidential PC network Token-ring networks and SCO UNIX networks.
• Taught several classes including SAS for MVS/TSO and MVS/JCL.
• One of 5 nominees chosen from over 2,000 professional staff employees to receive an “Outstanding Professional Employee of the Confidential ” in recognition of outstanding job performance.
• Served as Head SAS Consultant for campus and taught SAS base, SAS Statistics and SAS Graph, on the mainframe, UNIX and PC platforms.

Confidential - Norman, Oklahoma

Data Analyst / Developer / Project Manager

Responsibilities:

• Design and develop database and applications using several different applications.
• Recruited to design and develop database and telephony applications using Delphi, MICROSOFT C++, Visual Basic and SAS on PC client/server based environments.
• Provided design and programming support on PC-based projects.

Confidential - Minneapolis, Minnesota

Summer Computer Engineer

Responsibilities:

• Operated and networked VAX 11/750, 11/780 and 11/785 using VMS/DCL.
• Taught FORTRAN and Pascal courses.
• Taught pioneering classes on computer security with enrollment in excess of 100 Engineers for each session.
• Received Confidential Department of Defense clearance.

Confidential - Norman, Oklahoma

Consultant

Responsibilities:

• Wrote an application to create invoices for a lumber company.
• Worked with Confidential to develop an airline scheduling program.
• Developed a program to bring up text files per what was touched on a kiosk screen.
• Several other smaller projects.