OBJECTIVE:

Full time or contract position as an ETL Data Warehouse / BI / Data Base Developer/ Analyst, or in combination with Business Analyst, contributing a strong balance of Kimball / OLAP / Star Schema based DW analysis, business analysis, and project methodology SDLC experience. Seven years Data Warehouse / ETL experience.

PROFESSIONAL SUMMARY:

• Data Warehouse ETL analysis, design, and development for Mortgage and Loan, Insurance Health Care, Insurance Marketing, Payroll, HR, Automobile Marketing systems. Experienced in Kimball SCD Methodology, DW Life Cycle including Business Rules to Data Model analysis, Business need to Model constraints, Information Engineering (IE) methodology, ER diagram analysis, Gap Analysis, data redundancy and optimization analysis, data profiling, Meta Data analysis and creation. Data model analysis, redesign.
• Business Intelligence OLAP Reporting analysis and development for HR, manufacturing systems. Six Sigma web Dashboard analysis and development for BI Reporting. Balanced Scorecard analysis, design, and implementation.
• Mature SDLC expertise: Experience as a systems analyst/business analyst in project design and implementation with direct customer interface through all phases of a structured project life cycle, including Requirements Gathering, Statements of Work, Detail Designs, Risk Analysis, Gap Analysis, RAD sessions, meta data analysis, data model communications. Thorough experience utilizing Demming TQM, SEI, EDS complete project life cycle methodologies through all phases of fully scaled projects.
• Extensive QA and product testing experience: Project documentation, project plan graphic design and presentations, project timeline documentation, unit test analysis, test data creation, test query creation and running, UAT (User Acceptance Testing) unit test documentation, system implementation documentation, and user documentation for the customer.
• Strong Senior Systems Analyst/ Business Analyst /Designer/Developer of integrated Client Server and Data Base systems for Mortgage and Loan, Finance, Accounting, Health Care, Insurance, Marketing, HR, Payroll applications.

TECHNICAL SKILLS:

Ascential Data Stage 7.5: Data extract, transformation and load to Oracle/ DB2 UDB Data Warehouse Architecture.

Kimball DW Design: full experience developing with slowly changing dimensional data warehouse concepts.

Ascential Quality Data Stage: Data examination and best choice selection.

Evoke Axio: Meta Data creation, data dependency, redundancy profiling and analysis, normalization, gap analysis. UDB DB2 for Windows, DB2/QMF/SPUFI. UNIX scripting to run ETL jobs, SQL procedures. Sync Sort - data stabilization. Oracle Developer 2000 for stored procedures interacting with Unix/Oracle data warehouse. PRISM Data Warehouse Executive 2.0 - COBOL/DB2 code & meta data creator. MS Excel - data model documentation, data set modeling, test plan documentation. MS Project: Project documentation, process proposals, designs, presentations.

SQL Development: ORACLE 9i, 10g: SQL, SQL Plus, Toad; Pl SQL, SQL Developer & Procedure Builder. UNIX: shell scripting . DB2 UDB: Command SQL. MS SQL SERVER 7: Stored Procedures, DTS Packages; Table updates; Query Analyzer - testing stored procedures, data manipulation.

Business Intelligence Reporting Development: HTML/VB/SQL Server - web dashboard platform base for COGNOS: Transformer analyze/model/update multi dimensional data cubes; Power Play cube analysis/creation. Impromptu reporting. Performance Plus Balanced Score Card Developer designed & built objects, measures, networks for Client Server and Web applications. Oberon Prospero OO management HR product. IQ Business Objects/ Reports like Crystal Reports.

Mainframe Development: COBOL II, MF COBOL, DB2, CICS, VSAM, MVS JCL, TSO, ROSCOE, IBM OS Utilities, FileAid, Easytreve, Syncsort & Sort Utilities. 12 years high level design/development/support experience.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Specialist EDS consultant

Responsibilities:

• Large scale Data Stage ETL creation of Lender Operational Data Store. Daily interaction with design/modeling team.
• Solo ETL development of Lendscape ODS Extract system. Extensive collaboration with Project Manager, Business Analysts and End User for data mapping and model design specifications and end user tool efficiency upgrades. Unit testing. UA testing.
• Solo production move up of entire ODS to production. Test runs, parallel run analysis, user acceptance communications, sign offs.
• Creation and utilization of Oracle SQL query based data testing system. Intensive testing, development re work analysis, re tests to meet strict year end project target dates.
• Solo responsibility for development and support on the Data Stage Batch Run/Job Hierarchy process (Ascential Ken Bland process) that runs all Daily, Weekly and Monthly cycles in support of the Corporate DW.
• Data Stage ETL development for the Wholesale Data Mart in a Kimball SCD design.
• Implemented upgrade of Data Stage 6.1 to version 7.5. Complete root uninstall/ re install, export /import of all projects, parallel run tests and analysis, user guidance and support.
• Responsible for establishment and delegation of ETL standards and conventions to the team.

Confidential

Data Warehouse ETL Developer Consultant

Responsibilities:

• Analyzed data structure, data integrity, business to meet data warehouse requirements.
• Designed and Created Data Stage ETL jobs.
• Built and ran UNIX scripts to run Data Stage jobs, facilitate auto load of insert/update data to staging tables, load staging tables to the warehouse. Created, ran UNIX Sync Sorts for data stabilization and compliance to data model.
• Created Unit Test Plans, performed full process testing, data validation for relational compliance to data model, move up of development programs and scripts to production. Extensive SQL testing, validation querying in UDB DB2 Command.

Confidential

Senior Systems Consultant

Responsibilities:

• Worked with Business Analysts and Erwin data modelers to clarify meta data and data model.
• Analyzed meta data results with Subject Matter Experts to guarantee data model compliance, referential integrity.
• Used Axio to create meta data repositories; for column, data dependency, and data redundancy profiling; data normalization; gap analysis; meta data tag reports. UAT.
• Created Data Stage sorts, ETL data transformations, customized functions, load programs to access the data, manipulate it to match all business and data integrity requirements, and insert to the data warehouse.
• Coded numerous COBOL programs to convert comma delimited source files to data extract specifications.

Systems Consultant

Confidential

Responsibilities:

• Updated database structure, Year End Processes using SQL Server 7.0, COGNOS, Web Server to meet emergency direct requests from Dupont CEO Chad Haliday for critical
• Resolved system errors and provided request solutions to the CEO and his immediate strategic team regarding year end financial targets.
• Created Balanced Scorecard system that dynamically advanced Dupont’s strategic capabilities.
• Worked with Dupont Senior Confidential consultants in designing business bjects and measures.
• Created user system with Performance Plus software to build business objects for Client Server and Web applications.
• Rolled out product to directors, coached them in usage and capabilities.
• Operations Metrics Data Warehouse Project: Built and tested SQL Stored Procedures utilizing MS SQL Server 7.0. Created test scripts, tested warehouse product. UAT.

Confidential

System Consultant

Responsibilities:

• Project Lead for Event to Customer data conversion interface: Led a four person team. Redesigned specs. Assigned requirements and specs to team. Coordinated extensive database/GUI product tests. Clarified all test results with management and data architects. Built front end process that converted and fed all data for the other 3 modules.
• Recognized by management for excellence in product design, reporting documentation, and life cycle process.
• Worked with warehouse architects on data mapping and design issues related to the ERWin Data Models.
• Used PRISM data warehouse GUI tool to create DB2/COBOL programs, meta data, data mapping.
• Provided reliable design updates and tests in face of constant data and spec redesign from the GM customer.
• Created SQL packages, procedures using Oracle SQL Developer and procedure Builder.
• Built and implemented Visual Basic report process and VB front end processor for ftp Internet data transfer.
• Responsible for analysis and problem resolution of Wright Express and Payroll systems in preparation for conversion.
• Tracked down error sources and eliminated code and data errors that existing staff were unable to detect.
• Interfaced with a variety of business directors for requirements gathering, design analysis, requirements agreements, data and test compliance, UAT user acceptance testing, product acceptance and sign off.
• Converted an existing reporting system to a new platform, Responsible for conversion analysis of existing system, data analysis, data mapping, report creation.
• Used Peregrin Span Fin (open ended Power Builder based integrated facility management product), Span Dos, Span Flex QL, and Win QL Data Flex systems for report and data analysis, and data mapping on a SQL Server 6.5 database.
• Built reporting system with IQ for Objects (an object based client server data access and report tool. It utilizes a SQL query base and is similar to Crystal Reports). UAT user acceptance testing. Phoenix Project
• Support and maintenance of Radiant Coretech pricing inventory system and SASI, ROI Point Of Sale scanning system, using Xellenet, RAS Dial In, and Alta Vista Tunnel with MS Windows NT 4.0 on a SQL Server 6.5 database.
• Performed DBA assist functions: on call support of package/ SQL Server system. SQL queries for sys start and close.
• Assisted in conversion of SQL Server database from NT 3.5.1 to NT 4.0. Update and test of Visual Basic programs. Human Resources Interface System Development Project
• Helped design, build an HR management compensation / incentive system.
• Used Oberon Prospero interfacing with Oracle database. Oberon Prospero is an Object Oriented middleware integration
• Prospero programs are built on a VB base, coding in SQL to build interactive objects.
• Created detail design docs, test plans and Oracle test data using SQL Plus. Built 15 interface program object modules.
• Completed all programs in half the time estimated by project management, resulting in significant savings to project.
• Solo creation of CGM Management Bonus Interface System: analysis, design, project flow, development test plan, testing, documentation. UAT user acceptance testing, Built and tested 5 Prospero programs.
• Designed and coded COBOL II/DB2 programs.
• Built all system DB2 SQL code.
• Created DB2 test data, populating and testing DB2 tables using SPUFI.
• Responsible for unit/system testing: created test plans, tested programs, documented test plan and results in MS Excel.

Confidential

Senior Analyst, Programmer/Analyst

Responsibilities:

• Received Performance as co-designer/creator of IRAS (Insurance Related Accounting System): two year full life cycle project created corporate wide system. Wrote 35 CICS and 20 COBOL II programs. Project Lead for business interface process for the entire IRAS system.
• Spec creation, task tracking, time lining, testing, QA and documentation.
• Project Lead for creation of ESIS/Casualty Split on line CICS system. Responsible for all aspects of a life cycle phased project: proposal development, presentation, and negotiation. Deliverable generated large monthly savings.
• Received Performance for solo development of Statutory Supplemental Schedule System.
• Key team figure working with EDS consultants implementing SEI project life cycle and EDS Software
• Configuration Management initiatives.
• Run Time Improvement Project Lead for Financial Reporting System. Optimized all systems for significant run time cost savings.