Candidates About

 

 

David F. Zima

 

 

PROFILE

Over twenty years of experience in supply chain, healthcare and data warehouse information systems.  Full cycle development experience.  Rose through the ranks as a programmer, programmer/analyst, systems analyst, software engineer, lead software engineer, consultant and project manager. Proactive and result oriented individual with strong communication skills.

SUMMARY OF QUALIFICATIONS

●     Over 15 years of data warehouse experience including dimensional modeling and hierarchies.  I also have extensive ETL experience including development, tool installation, administration, standards, guidelines and best practices.

●     10 years of supply chain business knowledge including order management, inventory management, warehouse management, forecasting, and replenishment.

●     8 years of healthcare business experience including utilization review, case management, claims processing,  disease management and pharmacy benefit management. 

●     Managed two development teams and six applications.

●     Developed a commercial computer language used to integrate health care information systems.

 

TECHNICAL SKILLS

 

Languages:  DataStage (15 yrs), Prism ETL(2 yrs), Talend(1 month), Oracle Warehouse Builder(4 months),PL/SQL(6 yrs), SQL(12 yrs), C(10 yrs), Pro C(1 yr), Visual C++(1 yr), COBOL(2 yrs), Visual Basic(4 yrs), Unix Shell(10 yrs), Pascal(6 yrs), Fortran(1 yr) DCL(8 yrs), Assembler(1 yr), RPG(6 months), SQLWindows(6 months)

OS: Digital Unix(2 yrs), HP Unix(2 yrs), Sun Unix(6 yrs), Linux(7 yrs), VMS(10 yrs), MS Windows(8 yrs), MSDOS(5 yrs), MPE(2 yrs), Netware(5 yrs)

Databases: Oracle (14 years), DB2 (4 yrs), Teradata (2 yrs), Informix(5 yrs), Ingres(6 yrs), RDB(4 yrs), SQL Server (1 yr), Access(2 yrs)

Other: SAP BW R/3, ECC 6(4 yrs), JDA Demand/Fulfillment 7.5,7.7(4 yrs), JDA Enterprise Planning 7.5(2 yrs), Business Objects XI R2,R3(4 yrs), ParAccel 3.5(2 yrs), OSB, Websphere MQ, Hortonworks Hadoop 2.4.0, Oozie 4.0.0, Agile, Rally

 

EMPLOYMENT HISTORY

 

11/16 - Current                                                 DataStage Developer                                                     OptumRx, Schaumburg IL.          

 

OptumRx is owned by UnitedHealth Group and provides pharmacy services for more than 65 million people and processes more than 1 billion adjusted retail, mail and speciality drug prescriptions annually.

 

Project: DataStage 11.5 Migration

 

Migrated over 2,200 DataStage jobs from IBM AIX DataStage 8.7 to RedHat Linux DataStage 11.5.  I helped to lead the project and I coordinated the efforts of both our onshore and offshore teams. Worked with the Unix, Storage and DataStage Administration teams to configure the new DataStage 11.5 servers.  We converted user administration  from local to LDAP.  I designed LDAP groups and modified our folder permissions so that all developers could develop and run DataStage jobs using their own LDAP account.  This provided better auditing capabilities and it centralized user administration and authentication.  The DataStage 8.7 environment lacked source code control so I implemented git and github. 

 

Project: Claims Archiving

 

Our team supports the Client Billing System (CBS) which is a home grown application that generates pharmacy benefit management (PBM) billing.  The application utilizes a 10 year old Oracle database that is over 18 TB in size.  This database has never been archived which has resulted in the database growing larger and slower each year.  Main tables contain several billion rows and a non-partitioned database table design results in frequent slow full table scans in many SQL queries.

 

The Claims Archiving project was previously attempted using a job design that consisted of using a DataStage ETL that identified data that could be archived and then loaded the data into an archive database.  My job was to complete the ETL and create a job that perform archiving during a weekend time window.  My years of experience with DataStage and several past archiving efforts made me realize that the current design would not work because an ETL could not purge, migrate and load the data fast enough.  I performed data and performance analysis to prove how inefficient the existing archive design was.  I enlisted the help of the Technical Architecture team to present different archive solutions to our team.  My manager and the team agreed on a different design in where we created partitions for the tables and used database utilities/scripts to roll-off partitions from the production database into the archive database. 

 

Environment: DataStage 8.7 and 11.5,  Oracle 11g

 

08/15 - 11/16                                                      DataStage Developer                                                         McDonald’s, Oakbrook  IL.

 

McDonald's is the world's largest chain of hamburger fast food restaurants, serving around 68 million customers daily in 119 countries across 36,538 outlets.

 

Project: NextGen TDA

 

McDonald’s restaurant POS data was being captured in the Global Data Warehouse (GDW) at a daily sales level.  The NextGen TDA project loaded the data at a POS level into the GDW which allowed POS transaction detail analysis (TDA).  Capturing POS transactions allowed the business to perform full market transactional analysis and provided detailed new product evaluation.  The project also allowed McDonald’s to retire a legacy mainframe system.

 

Hadoop java programs are used to parse the restaurant’s POS XML files and disaggregate extra value meals  into the meal components.  A DataStage ETL job was used to extract the data from Hadoop using a File Connector stage.  The ETL also validated the data and loaded it into new GDW tables.  The ETL job was written so that it could process multiple territories at the same time.  The US territory was implemented first followed by the Canadian territory. 

 

Environment: DataStage 11.3,  Teradata 14.10 Database, ViewPoint, Bteq and SQL Assistant,  Hortonworks Hadoop 2.4.0, Oozie 4.0.0

 

Project: Food and Paper Cost Logic Enhancement

 

McDonald’s meals ( e.g. Extra Value, McPick ) were represented by a single item number in the Global Data Warehouse (GDW).  Because a meal can contain many different component configurations, the cost of the meal item was an average cost of the meal item within a geographical territory.  With the arrival of NextGen TDA data, we were able to capture the meal and it’s components and calculate a more accurate cost.  I enhanced the NextGen TDA and PMIX ETLs so that this new logic was utilized.  After the ETLs were implemented, I wrote Teradata BTEQ scripts to update the cost history. Finally, I built a new food and paper cost Global Data Warehouse (GDW) to Hadoop interface ETL job so that Java Hadoop extractor programs could utilize the cost data.

 

Environment:   DataStage 11.3, Teradata 14.10 Database, ViewPoint, BTEQ and SQL Assistant,  Hortonworks Hadoop 2.4.0, Oozie 4.0.0

 

11/13 – 5/15                                                       Senior Software Engineer                                            Office Depot, Boca Raton  FL.

Office Depot is an office supply retailing company with annual sales of approximately $11.2 billion, employs about 66,000 associates, and serves consumers and businesses in 59 countries with more than 2,200 retail stores, e-commerce sites and a business-to-business sales organization.

 

Project: The JDA Forecast, Fulfillment and Inventory Optimization project consisted of replacing the Office Depot legacy forecast, fulfillment and safety stock systems with JDA to maximize supply chain performance and maintain a profitable balance among speed and service levels.

●     Led a DataStage team of 4 DataStage developers. Responsible for defining, planning, tracking, resource allocation and managing the DataStage development for the project.

●     Defined the DataStage 8.7 project environment including storage requirements, job folder structures, environment variables, and parameter sets.

●     Developed ETL development design patterns, coding and documentation standards.

●     Successfully developed and implemented over 60 interfaces which integrated the JDA with the Office Depot legacy systems.

●     Designed and modeled staging tables

●     Designed and implemented a production data refresh of the UAT environment which facilitated business testing.

●     Developed a near real time interface which sent purchase orders and transfers from JDA to the mainframe legacy systems via a SOA OSB web service. The DataStage interface utilized the XML and Web Services Transformer stages to send the documents to an OSB web service which validated the data and relayed it to a mainframe Websphere MQ queue where it was consumed by the mainframe purchase order and transfer legacy systems.

 

Environment: DataStage 8.5 and 8.7, Oracle 11g, DB2 10.1, Teradata 14, Oracle Solaris 11.1, OSB 11gR1, Websphere MQ 7.1, Red Hat Enterprise Linux 6, Toad for Oracle 11.5, Korn Shell ksh93.

 

Project: Office Depot and OfficeMax Merger Integration.  A number of sub-projects which moved and transformed data between the two companies in order to facilitate the migration of OfficeMax customers, distribution centers and order management into the Office Depot legacy systems.

●     Worked with the Office Depot enterprise architecture and security teams to define a secure method of transferring the data between the two company’s information systems.

●     Wrote Korn shell scripts that were utilized by the DataStage jobs to encrypt and decrypt PGP data.

●     Developed and implemented the inventory stocked items and future projected purchases interfaces.

 

Environment: DataStage 8.5, 8.7, Oracle 10, 11g, DB2 10.1, Red Hat Enterprise Linux 6, Toad for Oracle 11.5, Korn Shell ksh93.

 

3/6 – 10/13                                                         Lead Software Engineer                                                OfficeMax, Naperville  IL.

 

OfficeMax was an office supply retailer with approximately 6.9 billion in sales.  The company provided office supplies and paper, in-store print and document services through OfficeMax ImPress™, technology products and solutions, and furniture to consumers and to large, medium and small businesses.  OfficeMax customers were served by approximately 35,000 associates through direct sales, catalogs, e-commerce and more than 900 stores.

 

Project: Every day the JDA replenishment system generates hundreds of purchase orders which were manually approved by Inventory Management (IM) planners. The Purchase Order Auto Approve project included working with IM to define approval criteria and implementing a new job that automatically approved purchase orders which saved Inventory Management planner man/hours. 

●     Developed a PL/SQL package to perform the automatic approvals and allow the IM planners to configure the approval criteria from within JDA.

●     The package parsed and validated the user entered rules each time it was executed to determine the logic to be used on the day’s newly generated purchase orders.

 

Environment: Oracle 11g, PL/SQL, Red Hat Enterprise Linux 6, Toad for Oracle 11.5, Korn Shell ksh93.

 

Project: The SAP Consolidation project migrated and consolidated OfficeMax contract legacy system processes on to the SAP Platform. I worked on the consolidation of master data, order management and the enhancement of the enterprise data warehouse.

●     Developed new and enhanced existing JDA to SAP purchase order and stock transfer order interfaces.

●     Performed a gap analysis of the existing data warehouse to future SAP consolidated state to define the enterprise data warehouse project’s scope.

●     Led a team of 4 DataStage developers to develop and implement the necessary data warehouse changes.

 

Environment: DataStage 8.5, Oracle 10,11g, DB2 9, SAP ECC6, DataStage SAP R/3 Pack 6.5, Red Hat Enterprise Linux 6, Toad for Oracle 10, Korn Shell ksh93.

 

Project: DataStage Capacity.  The OfficeMax DataStage 8.01 environment had reached its full capacity with almost 1000 ETL jobs that supported 15 data marts. As a result of this, critical businesses SLAs were being missed and there was little room for expansion.  On the DataStage Capacity project, I helped to design and implement a new DataStage 8.5 environment. 

●     The new environment was a big technical change as we went from a single server Solaris Unix SMP environment to a 4 server clustered Linux environment.  I configured and installed DataStage 8.5 on 4 production, 4 test and 2 development servers.

●     Worked with the Storage, Network, and Unix Admin teams to resolve DataStage NFS compatibility issues.

●     Led 5 DataStage developers in migrating 15 DataStage projects and almost 1000 jobs from DataStage 8.01 to 8.5.

●     Defined an end to end testing strategy that allowed us to complete the project in under a year.

 

Environment: DataStage 8.5, Oracle 10,11g, DB2 9, SAP ECC6, DataStage SAP R/3 Pack 6.5, Red Hat Enterprise Linux 6, Toad for Oracle 10, Korn Shell ksh93.

 

Project: DataStage Center of Excellence.  The Business Intelligence team did not have any formal DataStage development standards and as a result, the DataStage jobs varied greatly in quality and design.  Jobs frequently failed in production so I proposed this project to management.

●     I set up weekly meetings and worked with the team to define DataStage standards, guidelines and best practices.

●     Implemented code walkthroughs.

●     Corrected jobs that failed frequently

●     After some time we measured a reduction of production job issues.

 

Environment: DataStage 8.5, Oracle 10,11g, DB2 9, SAP ECC6, DataStage SAP R/3 Pack 6.5, Red Hat Enterprise Linux 6, Toad for Oracle 10, Korn Shell ksh93.

 

Project: The Supply Chain Improvements project addressed capturing contract fulfillment and execute to promise data that was missing in the Supply Chain data mart.  Adding the contract fulfillment and E2P the data mart allowed a more comprehensive view of network performance and using Business Objects provided a superior reporting environment.

●     Led a team of 4 DataStage developers, 1 Business Objects developer and a Data Modeler.

●     Worked with the business to capture and refine their requirements.

●     The project was difficult but successful and led to significant savings through a reduction of wholesaler dependence and fewer shipments per order.

 

Environment: DataStage 8.01, Oracle 10, DB2 9 Toad for Oracle 10, Korn Shell ksh93.

 

Project: Supply Chain Data Mart.  The Inventory Management team was capturing legacy system data in to Access databases and spreadsheets in order to measure inventory turnover, inventory cost, service levels, lost sales and forecast accuracy.  Replacing these processes by capturing this data in to the enterprise data warehouse and Supply Chain data mart provided the business with a central location with conformed and validated data.

●     I was hired at OfficeMax as a contractor to help migrate the new supply chain data mart from SQLServer to Oracle.  The new data mart contained millions of rows of inventory, daily instock and matplant data which tested the limits of SQLServer and led to missed SLAs. 

●     I reversed engineered the existing ETLs and migrated the data mart to Oracle.

 

Environment: DataStage 7.5, Oracle 10, DB2 9, SQL Server 2008, Toad for Oracle 10, Korn Shell ksh93

 

1/5 – 2/6                                                              Data Warehouse Analyst                              Focused Health Solutions, Deerfield  IL.

 

Focused Health Solutions (FHS) is a leading national provider of customized health management services for individuals diagnosed with costly, chronic medical conditions that can be managed effectively by a comprehensive health management program. FHS combines innovative data analysis tools, condition-specific clinical pathways, proprietary tele health technology, Health Risk Assessments, and medical expertise to reduce healthcare costs and improve health.

 

●     I helped to develop the FHS enterprise data warehouse.  My primary responsibility was the conversion of PL/SQL packages into Oracle Warehouse Builder ETL processes.  I was also involved in the migration of our current production data from a Windows Oracle 9i database to the data warehouse which resides in an Linux Oracle 10g database.

●     Other responsibilities included the design, development, implementation, and maintenance of eligibility, medical claim, and pharmacy claim data feeds.  I was assigned a set of clients and I worked with TPAs including BCBSIL, United Healthcare, United Benefits, and Cigna. I was also responsible for the generation of ROI savings analysis data, major disease group (MDG) cubes, and utilization metrics for the Decision Support Data Analysts.

Environment: Oracle 9i, Oracle Warehouse Builder, PL/SQL, Toad 9, Windows Server 2003

 

4/4 – 9/4                                              Contractor                                          First Health Group Corp., Downers Grove IL.

 

First Health Group Corp., an indirect wholly-owned subsidiary of Aetna, Inc., provides national PPO network access and other cost containment programs to help their clients manage employee benefit plans.  Aetna has 48,600 employees and an annual revenue of 47 billion dollars in 2013.

 

●     Developed the Generic Dimension ETL program as part of the Bill Review Workers Compensation project. TD_ETL is a C program that maintained type 2 dimension (TD) tables in a generic way.  All TD reference tables are maintained by this single program and support for the new tables consists of a few code changes and adding the correct parameters.  TD_ETL was a necessity since the design of Bill Review required many type 2 dimensions.

 

Environment: Oracle 9i, Pro*C, PL/SQL, Toad 9

 

3/99 – 10/03                                                       Contractor,                         International Truck and Engine Corp., Warrenville, IL.     

 

International Truck and Engine Corp owns the manufacturer of International brand commercial trucks, MaxxForce brand diesel engines, IC Bus school and commercial buses. The company is also a provider of truck and diesel engine parts and service.  There are 16,500 employees and an annual revenue of $10.775 billion (in 2013). The company's products, parts, and services are sold through a network of nearly 1,000 dealer outlets in the United States, Canada, Brazil, and Mexico and more than 60 dealers in 90 countries throughout the world..

               

●     Performed data warehouse ETL work, extracting data from a number of different legacy systems and databases on DEC VMS and IBM MVS computers.

●     I worked with both internal and external IT teams to define, design, and implement the data warehouse interfaces.

●     Our team worked with the Parts division and our data warehouse helped them to manage their supply chain.  My primary responsibility was to extract orders and invoices from the TOLAS order management system and to build DataStage ETL processes to load the data in our data warehouse which resided in a HP Unix Informix database.

●     I was also responsible for the analysis and design of the Dealer Inventory Alliance (DIA) ODS. I gathered requirements from the DIA business unit and worked with the operational DIA IT team to implement the PIN Primitive database.

 

Environment: Informix V9, DB2 9, RDB 6, Oracle 9, RMS, C, Prism, Ascential DataStage Server Edition, DataStage 6, 7

 

8/92 - 2/99                                          Project Manager                              First Health Group Corp., Downers Grove, IL.

First Health Group Corp., an indirect wholly-owned subsidiary of Aetna, Inc., provides national PPO network access and other cost containment programs to help their clients manage employee benefit plans.  Aetna has 48,600 employees and an annual revenue of 47 billion dollars in 2013.

 

●     Responsible for the development, enhancement, maintenance, and support of the Referral Management System (RMS), Electronic Directory (ED) system, Risk Assessment Tool (RAT), OnCall system, Issues Management  (IM) system, and   Central Healthcare Eligibility (CHE) system. 

●     Lead  two development teams consisting of 6 developers each. 

●     Technical Project Manager who understands both business and technical issues. Served as a resource and mentor to team members.

●     As a Programmer/Analyst, I was the lead programmer on the Referral Management System (RMS).  I worked with another programmer to build the system which was written in Visual Basic and contained over 30 screens.  The system implemented our company's Point of Service (POS) product

●     Developed the Managed Pharmacy System (MPS) RX Paid Claims and Clinical Drug Trigger sub-systems.  Was responsible for all aspects of these systems. I gathered requirements, performed systems analysis, designed the software, programmed, tested and implemented the software. 

●     Helped to form the software engineering group (SEG).  This group was responsible for evaluating new application development tools and application development standards.  I gave a companywide SEG presentation and worked with the different development group to implement the new standards

 

Environment: Ingres 6, Oracle 7, VB, VC++, C,  Windows 31 API

 

EDUCATION

 

●     AAS in Business Data Processing College of DuPage,  Glen Ellyn, IL.

●     Completed OptumRx Agile training course.

●     Completed Talend 6.3 DI Basics course

●     Completed Talend 6.3 DI Advanced course

●     Completed Talend 6.3 TDM Essentials course

●     IBM Certified Solution Developer InfoSphere DataStage v8.5

●     VB Proficiency Certificate College of DuPage, Glen Ellyn, IL.

●     Unix Proficiency Certificate  College of DuPage, Glen Ellyn, IL.

●     COBOL Proficiency Certificate College of DuPage, Glen Ellyn, IL.

●     Completed Introduction to Java course College of DuPage, Glen Ellyn, IL.

●     Completed a 2 day course in Metacube

●     Completed 5 day course in Project Management

●     Completed 5 day course  in Structured Analysis/ Design

●     Completed 5 day course in Extended Relational Analysis Data Modeling