SUMMARY:

• Over 35 years of experience in various Information Technology roles. Extensive background in development environments, particularly in large - scale data warehousing projects. Have managed and contributed in all phases of the development lifecycle: project requirements definition, system architecture, database design, ETL design and development, semantic layer design and development.

TECHNICAL SKILLS:

DBMS Platforms: TERADATA, ORACLE, SYBASE SQL SERVER, SYBASE IQ SERVER, Microsoft SQL SERVER, INFORMIX, IMAGE, IMS, DB/2, ADABASE, PARADOX, CLIPPER, FOXBASE.

Data Warehouse Architect responsible for all aspects of design and implementation of Data Warehouses.

Teradata RDBMS Logical and Physical Database Design, Administration, Performance Analysis and Tuning.

Mainframe and UNIX Based Data Warehouse Extract, Transformation, and Loading (ETL/ELT) of data from various sources into Enterprise wide Integrated data models including Teradata load and extract utilities such as MLOAD, FASTLOAD, FASTEXPORT and BTEQ.

Other: Teradata SQL Assistant, Teradata Administrator, ERWIN, Embarcadero Data Architect, Power Designer, S-Designor, ER/Studio, Business Objects, COGNOS, DATASTAGE, DEVELOPER 2000, COBOL, PL/1, FORTRAN, POWERHOUSE.

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, Detroit MI

Responsibilities:

• Design of the ‘Analytics as a Service’ solution which has included: analysis of the existing Power Pivot based Dashboards, documenting business rules for KPI, validation of the existing SQL logic for the Power Pivot tables.
• Participation in ETL Migration Project which has included conversion of existing Microsoft SQL Server ETL jobs.

Teradata - Teradata Senior Consultant.

Confidential, Washington DC

Responsibilities:

• Design of the Enterprise Data Warehouse which has included: comprehensive analysis of various customer OLTP systems including MOMENTUM Financials product and FMIS modules resulting in building of the Logical and Physical Data Models. Conducted al presentations about built Logical and Physical Data Models.
• ETL development using Teradata BTEQ scripts and Stored Procedures.
• Performing daily ETL batch support using Teradata Stored Procedures and Teradata Unity Service Link.

Confidential, Chesterfield MO

Responsibilities:

• Performance tuning of the processes running on the 2700 Teradata Data Warehouse Appliance Server (Analysis of Key Performance Metrics and Development of a set of recommendations in the areas of Workload Management, definition of PI’s and SI’s, data de-normalization).
• Modification of EDW ETL process (Teradata SQL Stored Procedures) for the needs of Data Security project (Teradata and PROTEGRITY partnership).
• Migration from Teradata 1 .00 which included re-builds of Databases, Users, Tables, Macros, Stored Procedures.
• Migration of data using SQL scripts.

Confidential, Livonia MI

Responsibilities:

• Physical Data Model Design for two ORACLE based Source Systems of the EDW - PisCES and PieV2 containing clinical information (PI assignment based on Data profiling results and Data Usage patterns).
• ‘Forward Engineering’ of the DDL’s for the EDW Tables, building Tables and corresponding Views.

Confidential, Franklin TN

Responsibilities:

• EDW Logical Data Model Design using Healthcare Industry LDM based on the analysis of various Hospital Confidential t Record Management Systems (MEDHOST, DAR, Meditech, Mckesson, ATHENA).
• Physical Data Model Design using EDW Logical Data Model.
• ‘Forward Engineering’ of the DDL’s for the EDW Tables. That also included building of the DDL’s for EDW Staging Area.
• Assisted Project Team DBA in the implementation of EDW Tables,
• Performed ongoing Data Model correction based on the requests from business users, ETL team and Reporting team.

Confidential, Lewisville TX, Columbus OH, Jersey City NJ

Responsibilities:

• Conversion of SQL queries sourced from various tools (SAS, BRIO, TOAD, Business Objects)
• Conducted user on Teradata technology online and as an instructor for a broad audience in cooperation with Confidential employees and Teradata Professional Services Consultants.
• Performed conversion of SQL scripts which are currently being used in SAS applications against DB2 for their usage against Teradata.
• During the daily activities provided user consultation on Teradata best practices
• Participated in brainstorming sessions on Workload Management activities with Confidential Corporate DBA employees and Teradata PS personnel
• Has developed a Teradata ‘Tips and Tricks’ document and has disseminated it within Confidential user community through Teradata sessions
• Performed analysis of the existing Physical Data Model and has provided recommendations on
• Performance tuning of poorly performing SQL queries utilizing Teradata Performance COE recommendations (Query assessment, Stats collection recommendations, Query join path analysis).
• Provided recommendations to the users on Application Design, conducted Application Design sessions for various business groups.
• As a part of daily activities has been involved in numerous Production Support Incident resolution which required Teradata expertise.

Confidential, Philadelphia PA

Responsibilities:

• Performed assessment of ‘MyPPL’ Data Mart sourcing data from SAP BW.

Confidential, Providence RI

Responsibilities:

• Maintenance of the Logical and Physical Data Models for Commercial Loan Application (AFS), total number of physical entities around 200.
• Development of Business Views for the Presentation Layer of the Application.
• Confidential for Staging and Core Databases (choosing optimal PI’s and PPI’s, tuning of the free-hand SQL queries developed by ETL and Reporting teams).
• Conducted knowledge transfer sessions on AFS Data Model and Teradata Database to new members of Project team and Application business users.

Confidential, Eden Prairie MN

Responsibilities:

• Building of the EDW Staging and Core Physical Data Models and corresponding Database objects based off Oracle and Mainframe applications with total number of instantiated physical entities around 1,200.
• Assisted off-shore ETL team in data load tuning efforts and data quality analysis.

Confidential, Dayton OH

Responsibilities:

• Phase 1 EDW Physical Data Model Design containing 192 tables.
• ‘Forward Engineering’ of the DDL’s for the Core EDW Tables.
• Assisted Project Team DBA in the implementation of Phase 1 Core EDW Tables,
• Performed ongoing Physical Data Model correction based on the results of abovementioned step.

Confidential, Los Angeles CA

Responsibilities:

• ETL process performance tuning.

Confidential

Teradata Solutions Architect

Responsibilities:

• Conceptual, Logical and Physical Database Design, ETL Design, Semantic Layer Design.
• DBA responsibilities for various projects.
• Review and Sign-Off of SDLC related project documentation.
• Technical project management of on-shore/off-shore teams for various consulting companies (INFOSYS, COGNIZANT, EAGLE CREEK).

Teradata - Teradata Consultant

Confidential, Atlanta GA

Responsibilities:

• Technical project management of the off-shore resource team (requirements definition, test plan definition, unit test result review, integration testing) for Business Objects and DBA tasks.

Confidential, Hanover MD

Responsibilities:

• Interface development from Financial Data Warehouse to Profitability Analysis application which included Project definition, Project requirements gathering and documentation.
• Database design specifications for existing and new tables.
• ETL software development and implementation using TERADATA BTEQ utility.

Confidential, Rancho Bernardo CA

Responsibilities:

• Conversion of reporting environment from Oracle to Teradata- migration of existing Universes and Reports.
• Conducted performance benchmarking of Business Objects queries.
• Worked on Business Objects SQL optimization.
• Management of off-shore resource team engaged for Unit Testing.

Confidential, Rancho Bernardo CA

Responsibilities:

• Development of reports for Early Warning System - Confidential POC using TERADATA and Business Objects.

Confidential, Columbus OH

Responsibilities:

• Data mining initiative - software design, development and implementation of analytical data sets and customer scoring models from Customer Knowledge System (CKS) data warehouse using BTEQ, FASTLOAD and MULTILOAD utilities and Teradata Warehouse Miner.

Confidential, Mason OH

Responsibilities:

• Performed assessment of an existing Account Reporting system for the areas of Claims and

Confidential, Confidential PA

Responsibilities:

• Point of Sale Enterprise Data Warehouse ETL process development including unit and integration testing using TERADATA BTEQ, FASTLOAD utilities, KORNE SHELL and MERCURY Test Director, sourcing data from SAP/R3 and SAP BW.

Data Warehouse Developer/Analyst

Confidential, Dearborn MI

Responsibilities:

• ETL batch processes development and implementation for various FORD Authorized Dealer Parts Sales Reporting Programs and Marketing and Sales Retail Incentive Programs (Medallion Elite Club, RMI/RPM, Be the Best, Keep it Genuine, Big Summer Brake, A/C Compressor Cool Cash) using TERADATA BTEQ, MULTILOAD, FASTLOAD, FASTEXPORT utilities and COBOL.
• Design of star schema data model and development of ETL process for Unit in Operations
• Design and development of new universes and reports for Unified Database Data Warehouse and eReact program using BUSINESS OBJECTS.
• Documentation development for existing ETL processes using SDM methodology.
• Information gathering for 2004 Sarbanes-Oxly Compliance program - Control Process and Corporate Standard categories.
• Participation in regression testing for V2R5 TERADATA implementation.
• Daily and monthly ETL batch process restructuring for the performance improvement purposes.

Confidential, Auburn Hills MI

Responsibilities:

• Support of existing ETL batch processes on UNIX SUN SOLARIS platform from SYBASE database servers and IBM DB/2 using COBOL, KORNE SHELL, SYBASE SQL SERVER and SYBASE IQ SERVER stored procedures.
• Support of user reporting requirements - administration of COGNOS IMPROMPTU catalogues.

Data Warehouse Developer/Analyst

Confidential, Troy MI

Responsibilities:

• Development of ETL jobs for Purchasing History Data Warehouse using DATASTAGE.
• Report specifications definition using existing COBOL and FOCUS reports and reportsand extracts for client/server application using DEVELOPER 2000, SQL and PERL.
• Reports development for Claims Warranty Data Warehouse using Business Objects.

Technical Leader

Confidential, Troy MI

Responsibilities:

• Requirements definition for various interfaces - data warehouse, funds transfer pricing, match funded, transfer rate, teller strip, central files for HOGAN, lockbox, SAP ISB.
• Development of TRANSACT SQL scripts using abovementioned design specifications.
• Development of conversion programs for abovementioned interfaces on IBM mainframe side using COBOL.
• Testing of results of Year 2000 conversion project for Leasing application using PL/1. COBOL/VSAM, JCL, FILEAID, XPEDITOR, PLAYBACK, VIADUCT and DATEFIND.

Business Analyst/Systems Engineer

Confidential, Dearborn MI

Responsibilities:

• Development of EDI system for outside processors using GENTRAN:EXCEL, GENTRAN:SERVER, PERL and COBOL/IMS.
• Development and maintenance of application software for outside processing and customer service departments using COBOL/IMS.

Confidential, Romulus MI

Responsibilities:

• Development of shipping/receiving front-end system using PARADOX, ORACLE and

Confidential, Troy MI

Responsibilities:

• Development of EDI Purchasing system using GENTRAN:MENTOR,
• Maintenance of accounts receivable and order entry systems using COBOL/IMS and
• Participation in implementation of ORACLE INVENTORY module for Australia-New Zealand and USA divisions using ORACLE, SQL, QL*LOADER,COBOL/IMS/VSAM/CICS.
• Consultation of Confidential customers on bar coding hardware/software acquisition and implementation.

Programmer Analyst

Confidential, Ann Arbor MI

Responsibilities:

• Maintenance of order processing, accounts receivable, accounts payable and sales history application systems using IMAGE and POWERHOUSE.
• EDI maintenance duties for order processing application systems using EDI WINDOWS.

Programmer Analyst

Confidential, Southfield MI

Responsibilities:

• Development of Physical Data Model for Month End lookup system using MS ACCESS and

S-DESIGNOR

Confidential, Auburn Hills MI

• Maintenance of laboratory claims processing system using IMAGE, COBOL and POWERHOUSE.

Confidential, Walled Lake MI

Responsibilities:

• Development of direct ship application using IMAGE, POWERHOUSE and FORTRAN

Confidential, Flint MI

Programmer Analyst

Responsibilities:

• Reports development for claims processing,, provider, prescription drugs and referral application systems using IMAGE, POWERHOUSE and COBOL.

Confidential

Senior Programmer Analyst/Project Leader

Responsibilities:

• Design, development and maintenance of general ledger, payroll and accounts payable applications using FOXBASE, TURBO PASCAL and CLIPPER.

Confidential

Senior Programmer Analyst/Project Leader

Responsibilities:

• Design, development and maintenance of accounts payable and accounts receivable application systems for various grain processors using ADABASE and NATURAL.

Confidential

Senior Programmer Analyst/Project Leader

Responsibilities:

• Design for a major warehouse inventory management project, which included shipping/receiving, accounts payable, accounts receivable and inventory material management.

Confidential

Programmer Analyst

Responsibilities:

• Development and maintenance of inventory material management application using PL/1/VSAM.