System Training
Resume:
Michael Pepich
Olathe, KS. 66062
********@*******.***
Michael Pepich has over 30 years of Mainframe Focus experience and over 12 years of WebFocus development experience
Federal Reserve Bank 12/2011 thru current
• Wrote new Web Focus release 7.7.03 reports for Payment system.
• Created HTML / PDF / Excel reports /CSV Files using WebFocus and DB2.
• Created 2 level drill down reports using WebFocus.
• Conducted formal training classes for WebFocus, held 3 classes, basic, advanced, expert
Allegis Group 1/2011 thru 10/2011
• Wrote new Web Focus release 7.7.01 reports for Commission system.
• Created new Bar/ Pie graphs and HTML / PDF / Excel reports
• Created 2 HTML Dropdown screens for Report Variable input
• Created 6 level drill down reports using WebFocus.
• Conducted formal training classes for WebFocus, held 4 classes, basic, advanced, expert, HTML
State Of Minnesota Department of Education 9/2010 thru 1/2011
• Wrote new WebFocus reports release 7.6.11 for Minnesota Department of Education/ No Child Left Behind Federal Reporting using WebFocus and Oracle
• Created new Bar/ Pie graphs and HTML / PDF / Excel reports
• Created 4 HTML Dropdown screens for Report Variable input
• Created 3 level drill down reports using WebFocus.
• Conducted formal training classes for WebFocus, held 4 classes, basic, advanced, expert, HTML
State Of Oklahoma 7/2009 thru 9/2010
• Wrote 120 new WebFocus reports for Oklahoma Department of Human Services/ Child Support services / Federal Performance Measures using WebFocus and Oracle
• Created 120 Bar/ Pie graphs and HTML / PDF / Excel reports
• Created 3 HTML Dropdown screens for Report Variable input
• Created 4 level drill down reports using WebFocus.
• Conducted formal training classes for WebFocus, held 4 classes, basic, advanced, expert, HTML
• Was also responsible for 508 Compliance.
Navistar Financial Corporation 3/2008 thru 12/2008
• Wrote 25 new reports using PC Focus for the Repossession system.
• Wrote 12 new reports using Mainframe Focus for the Tax system
• Worked with end users to design and implement new Repossession and Tax Reports
• Documented Repossession and Tax systems using MS WORD and MS VISIO
• Helped convert existing Leasing system to Oracle
Daimler Trucks North America 8/2007 thru 5/2008
• Wrote 18 new reports using WebFocus for the Online Warranty Link system.
• Wrote 42 new reports using Mainframe Focus and DB2
• Helped covert existing Warranty reports to new Warranty reports using Focus and WebFocus.
• Created 12 new PDF and EXCEL reports using Web Focus
• Created 3 level drill down reports using WebFocus and Report Caster.
• Setup email report system using Report Caster.
• Used WebFocus, FML, Report Caster, HTML. Java Script. Excel, PDF Layout Painter and HTML Layout Painter.
State of Louisiana 3/2007 thru 7/2007
• Wrote 32 new reports using WebFocus for the CSFR Child Welfare system / OCS system.
• Conducted formal training classes for WebFocus, held 3 classes, basic, advanced and expert,class size 30 people.
• Designed and Created Dashboard and Variable input screens to access CSFR Child Welfare system / OCS system programs.
• Created 4 level drill down reports in WebFocus.
• Helped set up data mapping and ETL of existing Data Warehouse.
• Using WebFocus 7.6, Dashboard, MRE and Developer Studio, FML, Report Caster, Excel, HTML. Java Script. PDF Layout Painter and HTML Layout Painter.
City of Philadelphia 11/2006 thru 2/2007
• Created 2 data entry programs using WebFocus Maintains for the Behavioral Health and Mental Retardation Research and Information Management system,
• Installed WebFocus release 5.36
• Using WebFocus, Maintains, Unix, FML, Report Caster, HTML, Excel, Java Script. PDF Layout Painter and HTML Layout Painter.
Various Local Companies 3/2006 thru 11/2006
• Created several inventory and reporting systems for small business.
• Setup several WebFocus dashboards MFD's and Modifies for data entry
• Setup numerous spreadsheets and automated word documents
• Setup several Access databases and data mapping.
Navistar Financial Corporation 2/2005 thru 4/2006
• Helped maintain Leasing system using PC/Focus and SQL
• Created 25+ Leasing reports and spreadsheets using PC/Focus, SQL and Excel
• Helped install Mainframe Focus release 7.6.
• Created New Tax reporting system using Focus and DB2.
• Helped maintain Retail system using Focus DB2 and MVS
• Created 50+ Retail reports using Focus, DB2, MVS and Excel
Compusys 11/2004 thru 2/2005
• Created Dashboard and variable input page for Trade show participants
• Created 20+ reports for Trade show participants using WebFocus SQL and DB2
• Created 5 level drill down reports in WebFocus.
• Installed WebFocus release 5.33 Unix, FML, Report Caster, Excel, HTML. Java Script. PDF Layout Painter and HTML Layout Painter.
Navistar Financial Corporation 7/2004 thru 11/2004
• Helped maintain Leasing system using PC/Focus and SQL
• Created 40+ Leasing reports and spreadsheets using PC/Focus, SQL and Excel
• Helped maintain Retail system using Focus DB2 and MVS
• Created 20+ Retail reports using Focus, DB2, MVS and Excel
Washington University in St Louis 2/2004 thru 3/2004
• Installed WebFocus release 5.23
• Conversion of Mainframe Focus system to WebFocus - 25+ programs
• Informal training of employees in WebFocus
• Created 3 level drill down reports using WebFocus, FML, Report Caster, Excel, HTML. Java Script. PDF Layout Painter and HTML Layout Painter.
American Family Insurance 10/2002 thru 5/2003.
• Project Leader on installation of Mainframe Focus upgrade from release 7.08 to 7.2
• Responsible for Installation, Testing and Validation of new release
• Setup Formal Focus training classes.
Contact this candidate