Peter Michael Downes Email & Phone Number

Roselle, Il, Us

Greater Chicago Area

• Manage documentation of all scheduled and ad hoc deliverables. • Confirm success of daily data load and troubleshoot ETL fails seeing each failure through to resolution• Identify new QA/QC opportunities, write the Stored Procedures that isolate them, test them, stage them, and have them promoted to production once staged successfully.• Successfully Manage and Mentor BA Team• Compile list of meaningful Operations metrics for production of high level metrics dashboard.• Maintain Trady Ally RBS (Risk-Based Scoring), QA/QC, Forecasting, Automated Reporting, and integration of new BI opportunities into existing automated process.

Schaumburg, Il

Database Analyst Combined the Astra Zeneca and Pfizer global surveillance studies from 2002 through 2018. This included resolving all inherent scientific discrepancies between phenotyping to create 36 million record database.  Wrote Custom Views to analyze, process, and deliver all of the test results from each specific project.  Wrote and deployed Triggers (Update, Delete, and Insert) for Audit trail tracking. Served as part time DBA hunting down the cause for Stored Procedure fails and resolving transaction issues. Used Audit tables to identify anomalies in the data, and how they were either inserted or modified, when, and by whom. Wrote dozens of Stored Procedures each designed to identify unusual test results; each called by a master Stored Procedure as part of a comprehensive Quality Assurance process.

Greater Chicago Area

* Business, Data, and Process Improvement analysis and consulting.

Hoffman Estates, Il

* Leadership Team Field Services Group* Completed SimpLean project to re-write and automate Risk-Based Scoring process responsible for evaluation of $13 billion portfolio (4 days to 1-hour touch time).* Replaced existing manual process for Risk-Based Scheduling (month-long process) with an automated solution requiring 8 minutes runtime; facilitating 100% accurate scheduling to 35,000 account portfolio for inspection teams.* Replaced existing manual process for Risk-Based Scheduling (also month-long process) with an automated solution to identify high risk accounts requiring financial audits.* Developed automated Time and Attendance Application used by ~250 non-exempt employees to replace manual spreadsheet process for tracking employee’s weekly hours. * Wrote automated monthly process to schedule new accounts and apply appropriate floor check schedules.* Wrote automated monthly process to identify out of sync combined accounts and re-apply appropriate schedule based on ‘last touch’ by Portfolio Managers and new combined relationships.* Built Data Models for Risk-Based Scoring and Risk-Based Scheduling to facilitate promotion to enterprise solution (SQL Server)

Greater Chicago Area

* Business, Data, and Process Improvement analysis and consulting

* Saved company approximately $200,000/year through optimization of mobile phone, conference calling, and eFax plans.* Coordinated implementation of FTP Dropbox, Time and Attendance Modules, and HRB Integration between multiple vendors.* Effectively managed, directed, and coordinated the workload of the people in my department. IS/DATA ANALYST* Saved company $181,000/year in manager salary hours through implementation of automated reporting procedures.* Reverse engineered Enterprise eTime Reports to create data import process facilitating comprehensive Employee Hours Reporting.* Developed Outside Labor Management Application for Administrative Team.Developed complete Data Import Process and Reporting procedures for Home Depot's post-ISS TMO and WebClock systems.

Lisle, Il

* MIS: MySQL, Access, Excel. BE and FE solutions across departments.* Developed Conversion Application for Data Import Process with Home Depot ISS Reporting.* Developed Payroll Application for HR Dept managing 250+ Reps.* Developed Automated Business Intelligence Applications for upper mgmt.

* Built state-of-the-art music recording studio.* Developed business plan to compete successfully in the Chicago market.* Recorded albums for more than 50 area artists.* Provided Sound Production Services for Music Clients.* Produced soundtrack material for Discovery Channel series Urban Explorers.

* Compiled Access Queries into unified output process.* Automated 40-hour Reporting Schedule into 4-hour VBA procedure.* Integrated CGEY Reporting Rules into automation process.* Integrated additional reporting needs into automated procedure.* Advised management to how to further expand automation possibilities

* Wrote portfolio manager biographies, investment criteria, and industry blurbs for Variable Annuity publications.* Spearheaded conversion of data collection from fax to electronic formats.