Mike Leech Email & Phone Number

Prior Lake, Mn, Us

Projects: Sales  Inventory Responsibilities: ETL design, development, testing, implementation and maintenance of medical device sales and inventory systems in a SQL Server and Oracle environment. Assisted in the conversion of an Informatica Medical Device System to DataStage. Environment: SQL Server  Oracle  DataStage PX  DataStage Server  Informatica  Unix

Projects: Pharmacy Claims  Lab Claims  Medical Claims  Member Enrollment  Health Care ProviderResponsibilities: Assisted in the development and testing of an SSIS/SQL Server Commission/Sales System (Agent ODS). ETL design, development, testing, implementation and maintenance of Health Care systems. Assisted in the redesign, coding, and implementation of mainframe DB2 DataMart processing to handle source changes for Provider Information from non-normalized data to normalized data. Assisted in the design, coding, implementation, and support of DataStage Detail Data Store processing of Health Care data to better analyze Provider Performance using SQL Server. Environment: SQL Server  SSIS  DataStage PX  Oracle  Mainframe  COBOL  Unix

Projects: Marketing Research Data MartResponsibilities: Assisted in the conversion of DTS to SSIS. Assisted in the SSIS conversion testing of ETL processing that was currently written in DataStage. Assisted in the completion of a multi-year Broker/Dealer System; Loaded 2-plus years of history data into a Marketing Research Data Mart; Converted 250-plus DataStage Programs to integrate the new Broker/Dealer System Keys; Enhanced programs for efficiency and streamlining processes to reduce runtimes; Changed programs to meet production coding standards as the code was moved from a staging environment to production. Environment: SQL Server  SSIS  DataStage Server  Unix

Projects: Custom Corporate Financial Extracts ETL Applications  UAT SupportResponsibilities: ETL development, testing, implementation and maintenance of Custom Financial Extracts for Corporate customers. Provided support to UAT environment for Financial Extracts and Corporate Fleet Card Services. Environment: Unix  DataStage Server  SQL  Mainframe DB2  DB2 UDB  Unicenter Autosys

Projects: Bankcards Data Mart  Wells Fargo Financial Data Mart  Basel Data Mart  Home Equity Data Mart  SOR ETL into EDW  Custom Extracts  Enhancement/Maintenance RequestsResponsibilities: ETL Development -- Extracting data from the source System Of Record; Transforming data and integrating account key information; Loading data into Enterprise Data Warehouse for use in customer custom extracts. Designing, developing, and implementing dozens of projects during the initial creation of the Enterprise Data Warehouse to the expansion of over 30 terabytes. Assisted in the conversion from Torrent Orchestrate to DataStage Parallel Extender. Environment: Teradata  Unix AIX  DB2 UDB  DataStage PX  Torrent Orchestrate  SQL  Unix Shell Script  C++  Mainframe  COBOL  Redbrick  Eztrieve  Unicenter Autosys

Projects: Financial System Enhancements  Y2K Conversions Responsibilities: Analyzed, Designed, and Developed Financial computer system enhancements. Worked with client users to analyze business functions. Documented enhancement requirements. Coded, tested, and implemented system enhancements. Assisted in the conversion of Financial Systems for the Year 2000 requirements. Environment: Mainframe  COBOL  DB2

Fingerhut Companies 7/1985 - 12/1997Minnetonka, MN Technical Lead Programmer/AnalystProjects: Merchandise Management System  Vendor/Product/Purchase Order  Vendor Compliance  Sample Tracking  Point Of Sale (Company Store)  Distribution Center Stocking Model  End User Computing  Electronic Data Interchange (EDI)  Product Bank System  List Requisition System  Address Integrity System  Marketing Analysis Systems  Y2K Conversions Responsibilities: Analyzed, Designed, Developed, and Maintained computer systems. Worked with client users to analyze business functions. Documented system requirements. Coded, tested, and implemented computer systems. Provided on-going system support to the user community. Assisted India-based team in the conversion of systems for the Year 2000 requirements. Environment: Mainframe  Oracle  COBOL  DB2  IMS  CICS  Telon  VSAM