Michael Duchene Email & Phone Number

Dearborn, Mi

Responsible for co-developing and co-implementing 22 data warehouse reporting solutions for various business areas and their customers to solve business problems. Involved in concurrently developing and maintaining numerous data warehouse projects at various stages of their life cycles. Involved in project scope from initial architecture, data modeling, development, testing, implementation and maintenance. One database project contained records of approximately 400,000 Ford employees and this… Show more Responsible for co-developing and co-implementing 22 data warehouse reporting solutions for various business areas and their customers to solve business problems. Involved in concurrently developing and maintaining numerous data warehouse projects at various stages of their life cycles. Involved in project scope from initial architecture, data modeling, development, testing, implementation and maintenance. One database project contained records of approximately 400,000 Ford employees and this project cost $125M.• Worked collaboratively with all levels of stakeholders as a key participant and technical mentor in the logical and physical design of the Enterprise Data Warehouse.• Created/maintained Teradata data structures.• Assisted in the installation and maintenance of client Teradata database software.• Delivered design, development and maintenance of several client data warehouses.• Performed data modeling for design and enhancement of integrated data warehouses.• Performed query and database performance tuning and co-prepared user/system test plans.• Assisted clients in developing/modifying SQL.• Designed, implemented and ensured validity of database backup and recovery systems.• Involved in active governance of shared database environment with necessary security protocols.• Liaised between the company, customer, development team and any 3rd party regarding software functionality throughout the development cycle; interfaced with infrastructure support teams and database software vendor.• Tools: Teradata (SQL Assistant, SQL Administrator, TDWM, Teradata Manager, Viewpoint), SQL, exposure to PowerDesigner and Oracle Designer• Environment: IBM z/OS, Teradata V14R0, Windows 7, Business Objects, WebFOCUS Show less

Dearborn, Mi

Responsible for overseeing design, development and maintenance of client data warehouse. Involved in developing the implementation approach and managing the impact on all business areas. Responsible for all aspects of the project from identification and assessment to analysis, build and implementation phases.• Managed the analysis and implementation of global logistics data warehouse project.• Tasked with dimension design and maintenance for data warehouse encompassing multiple business… Show more Responsible for overseeing design, development and maintenance of client data warehouse. Involved in developing the implementation approach and managing the impact on all business areas. Responsible for all aspects of the project from identification and assessment to analysis, build and implementation phases.• Managed the analysis and implementation of global logistics data warehouse project.• Tasked with dimension design and maintenance for data warehouse encompassing multiple business areas.• Designed project plans, specifications and test cases.• Acted as a design and technical mentor to the development team.• Created and maintained Teradata data structures and related Oracle extract processes.• Tools: Oracle, Teradata (Queryman, WinDDI), DB2, UNIX, Perl, SQL• Environment: Oracle, Teradata, UNIX, IBM 3090/MVS/ESA, Windows Show less

• Assisted in design and development of client data warehouse• Created and maintained Oracle and DB2 data structures• Assist in installation and maintenance of Oracle database (RBDMS and OWB), reporting (Discoverer) and application (iProcure) software• Enhance and implement Perl scripts• Monitored disk space usage and requirements• Provided an initial contact point for suspected problems with the database and resolved these Windows NT and ’95 issues or worked with the… Show more • Assisted in design and development of client data warehouse• Created and maintained Oracle and DB2 data structures• Assist in installation and maintenance of Oracle database (RBDMS and OWB), reporting (Discoverer) and application (iProcure) software• Enhance and implement Perl scripts• Monitored disk space usage and requirements• Provided an initial contact point for suspected problems with the database and resolved these Windows NT and ’95 issues or worked with the corporate database administrators as required• Assisted in setup of file transfers within the intranet• Tools: ORACLE (RDBMS, Discoverer, Warehouse Builder, iProcure), Teradata (Queryman, WinDDI), DB2, UNIX, Perl, SQL, MS-WORD, MS-WINDOWS, AUTOSYS• Environment: Windows NT/Oracle, UNIX/Oracle on HP N-Series, IBM 3090/MVS/ESA, Windows’95• Environment: Oracle, Teradata, UNIX, Windows NT, Windows ’95 Show less

Greater Detroit Area

• Testing Lead for a team of 10 people to implement a modified electronic claims pre-certification process Developed overall testing strategy and provided direction to the test team• Developed project plans • Acted as a liaison with test team and management• Assisted team as a main technical resource and performed testing as required• Assisted with other technical tasks as necessary • Tools: DB2, COBOL, VSAM, IMS, TSO/SPF, QAHIPERSTATION, XPEDITER, FILE-AID, MS-PROJECT… Show more • Testing Lead for a team of 10 people to implement a modified electronic claims pre-certification process Developed overall testing strategy and provided direction to the test team• Developed project plans • Acted as a liaison with test team and management• Assisted team as a main technical resource and performed testing as required• Assisted with other technical tasks as necessary • Tools: DB2, COBOL, VSAM, IMS, TSO/SPF, QAHIPERSTATION, XPEDITER, FILE-AID, MS-PROJECT, MS-WINDOWS, MS-WORD, HOURGLASS. DATAAGER, ABEND-AID• Environment: OS/390, Windows NT• 9 month duration Show less

Greater Detroit Area

• Responsible for a team of 6 persons required to age data to be used in client’s Y2K test of their mission critical Customer Information system which generates customer’s utility bills• Developed project plans and provided direction for the Compuware data aging team• Liaison with client test team and management• Developed data aging strategy and assisted client with overall testing strategy• Consulted with both Compuware and client teams as a main technical resource and… Show more • Responsible for a team of 6 persons required to age data to be used in client’s Y2K test of their mission critical Customer Information system which generates customer’s utility bills• Developed project plans and provided direction for the Compuware data aging team• Liaison with client test team and management• Developed data aging strategy and assisted client with overall testing strategy• Consulted with both Compuware and client teams as a main technical resource and provided software tool training as required• Acted as a liaison with Compuware technical support when client found anomalies with Compuware software products• Aged data and assisted in other technical tasks as necessary • Tools: DATAAGER, DB2, COBOL, VSAM, ASSEMBLER, TSO/SPF, QAHIPERSTATION, XPEDITER, FILE-AID, MS-PROJECT, MS-WINDOWS, MS-WORD, XPEDITER/XCHANGE. ABEND-AID• Environment: OS/390, Windows ’95• 6 month duration Show less

Troy, Michigan

• Developed recommendations for the client to test or not to test various systems (mainframe and PC based) for Y2K readiness based on risk and pay back and on input from client technical and end-user staff, as well as from software vendors• Assisted client technical staff in the development of test strategies when necessary• Consulted with both Compuware and client teams as a main technical resource• Tools: DATAAGER, COBOL, VSAM, TSO/SPF, QAHIPERSTATION, XPEDITER, FILE-AID… Show more • Developed recommendations for the client to test or not to test various systems (mainframe and PC based) for Y2K readiness based on risk and pay back and on input from client technical and end-user staff, as well as from software vendors• Assisted client technical staff in the development of test strategies when necessary• Consulted with both Compuware and client teams as a main technical resource• Tools: DATAAGER, COBOL, VSAM, TSO/SPF, QAHIPERSTATION, XPEDITER, FILE-AID, MS-WINDOWS, MS-WORD, XPEDITER/XCHANGE. ABEND-AID• Environment: OS/390, Windows ’95• 7 month duration Show less

Pontiac, Michigan

• Assisted in designing processes and procedures to evaluate the Y2K readiness of factory floor equipment• Assisted in designing processes to track the Y2K readiness status of individual pieces of equipment from the inventory phase to the assessment phase and through the remediation phase• Assisted in the inventory and assessment of factory floor and office environment equipment• Tools: MS-WINDOWS, MS-WORD• Environment: Manufacturing Production and Laboratories• 4 month… Show more • Assisted in designing processes and procedures to evaluate the Y2K readiness of factory floor equipment• Assisted in designing processes to track the Y2K readiness status of individual pieces of equipment from the inventory phase to the assessment phase and through the remediation phase• Assisted in the inventory and assessment of factory floor and office environment equipment• Tools: MS-WINDOWS, MS-WORD• Environment: Manufacturing Production and Laboratories• 4 month duration Show less

Farmington Hills, Mi

• Training in the entire life cycle and methodologies of software testing using Compuware’s methodologies of QAPlan, QABuild and QATest• Training in software tools necessary to complete the testing process in an IBM mainframe environment such as DataAger, Xpediter, FileAid, Xpediter/Xchange, AbendAid• Slight exposure to software tools necessary to complete the testing process in a client/server environment• 2 month duration

Dearborn, Mi

• Created and maintained Oracle, DB2 and IMS data structures• Provided direction in data modeling for new data structures• Provide guidance in query development for the department• Monitored disk space usage and requirements• Provided an initial contact point for suspected problems with the database and resolved these issues or worked with the corporate database administrators as required• Installed and was responsible for the UNIX scheduling product AutoSys• Developed… Show more • Created and maintained Oracle, DB2 and IMS data structures• Provided direction in data modeling for new data structures• Provide guidance in query development for the department• Monitored disk space usage and requirements• Provided an initial contact point for suspected problems with the database and resolved these issues or worked with the corporate database administrators as required• Installed and was responsible for the UNIX scheduling product AutoSys• Developed automated procedures for use by data controls staff in order to migrate objects between test and production Oracle environments• Assisted in issues of data movement between Europe and North America• Tools: ORACLE, DB2, IMS/DB, SQL, COBOL, MS-ACCESS, VSAM, TSO/SPF, MS-WORD, MS-WINDOWS, UNIX, AUTOSYS• Environment: IBM 3090/MVS/ESA, Windows ’95, UNIX and Oracle on IBM RS/6000 and HP9000• 2 year, 6 month duration Show less

Dearborn, Mi

• Major player in the development and subsequent enhancements of an “ad-hoc” system to download critical purchasing information from a mainframe application in Europe and provide it on UNIX/Oracle servers to end-users. These end-users could then write their own Microsoft Access queries to retrieve various types of needed information in a timely fashion• Wrote COBOL programs and data transfer utilities to unload and reload the databases• Worked with end-users and technical staff to… Show more • Major player in the development and subsequent enhancements of an “ad-hoc” system to download critical purchasing information from a mainframe application in Europe and provide it on UNIX/Oracle servers to end-users. These end-users could then write their own Microsoft Access queries to retrieve various types of needed information in a timely fashion• Wrote COBOL programs and data transfer utilities to unload and reload the databases• Worked with end-users and technical staff to develop an appropriate database design• Assisted end-users in the development of Microsoft access queries• Tools: ORACLE, DB2, IMS/DB, SQL, COBOL, MS-ACCESS, VSAM, TSO/SPF, MS-WORD, MS-WINDOWS• Environment: IBM 3090/MVS/ESA, Windows ’95, Oracle on IBM RS/6000 and HP9000• 1 year, 9 month duration Show less

Windsor, On

• Maintained and enhanced system to calculate eligibility and determine payment amounts for sales incentives• Designed and implemented electronic report data distribution• Consulted with end users regarding impact of new incentive programs• Analyzed and redesigned test system, leading to a more stable production environment• Assisted in implementation of a data down-loading process from mainframe into LOTUS 1-2-3 spreadsheets• Tools: IMS DB/DC, DB2, SQL, COBOL, VSAM… Show more • Maintained and enhanced system to calculate eligibility and determine payment amounts for sales incentives• Designed and implemented electronic report data distribution• Consulted with end users regarding impact of new incentive programs• Analyzed and redesigned test system, leading to a more stable production environment• Assisted in implementation of a data down-loading process from mainframe into LOTUS 1-2-3 spreadsheets• Tools: IMS DB/DC, DB2, SQL, COBOL, VSAM, TSO/SPF, XPEDITER, FILE-AID, MS DOS, LOTUS 1-2-3, WORDPERFECT, MS-WINDOWS, DATAVANTAGE, ARBITER• Environment: IBM 3090/MVS/ESA, PC-DOS• 3 year, 4 month duration Show less

Windsor, On

• Part-time position concurrent with Full-time position• Instructed courses in PL/1 programming, computer concepts, MS-DOS, LOTUS 1-2-3, DBASE III, and graphics packages• Tools: PL/1, MS-DOS, LOTUS 1-2-3, DBASE III, GRAPHICS PACKAGES• 5 year duration

Windsor, On

• Maintained systems• Designed and implemented replacement of key punched cards for data entry• Participated in evaluation and selection of IDMS/R as the DBMS for the Computer Center• Tools: PL/1, COBOL, IDMS/R, ADS/O, CULPRIT, VSAM, TSO• Environment: IBM S/370, MVS, MVT• 3 year, 10 month duration

Windsor, On

• Managed day-to-day operation of a small data center• Implemented and maintained a pre-packaged DOS/VSE operation system• Analyzed and recommended personal computer purchases• Assisted in analysis of system to be purchased for shop floor data collection• Implemented PC/mainframe system to send Advance Ship Notices (ASNs) to customers in standard AIAG EDI format• Installed and maintained 15 node personal computer network• Prepared and implemented budgets and project… Show more • Managed day-to-day operation of a small data center• Implemented and maintained a pre-packaged DOS/VSE operation system• Analyzed and recommended personal computer purchases• Assisted in analysis of system to be purchased for shop floor data collection• Implemented PC/mainframe system to send Advance Ship Notices (ASNs) to customers in standard AIAG EDI format• Installed and maintained 15 node personal computer network• Prepared and implemented budgets and project plans• Tools: CICS, PL/1, COBOL, VSAM, JES2, POWER, VTAM, DOS/VSE, MVS/XA, ICCF, RPG, MS-DOS, LOTUS 1-2-3, DBASE III, EDI, WORDPERFECT• Environment: IBM 4361, SSX/VSE, DOS/VSE, PC-DOS/LAN• 5 year, 5 month duration Show less

Bachelor Of Computer Science (Honours), Computer Science

Education record