Peter Michael Downes

Peter Michael Downes Email and Phone Number

SQL Programmer/Analyst (Data/Database/Business/Risk/Data Quality) @ DNV
Peter Michael Downes's Location
Roselle, Illinois, United States, United States
Peter Michael Downes's Contact Details

Peter Michael Downes personal email

n/a
About Peter Michael Downes

Consultant/Data Analyst/Data Scientist with proven track record of deploying solutions that increase accuracy, create capacity, and make room for growth. Some of these solutions become automated solutions that meet an ongoing need; while others meet a one-time need such as optimizing a spending plan, deploying a risk or forecasting model, or deploying a QA/QC or auditing process. * 20+ year diverse, professional background in IT, Leadership, Finance, Payroll, Project Management, Retail, Operations, Training, Science, and Quality.* Consistently takes on and accomplishes every challenge. Numerous accolades and awards. * Imaginative thinker with the courage to challenge existing processes and spearhead new and improved solutions.* Team player with the ability to lead and be led. Capable of working independently and collaboratively.

Peter Michael Downes's Current Company Details
DNV

Dnv

View
SQL Programmer/Analyst (Data/Database/Business/Risk/Data Quality)
Employees:
40
Peter Michael Downes Work Experience Details
  • Dnv
    Lead Business Analyst/Senior Consultant
    Dnv Sep 2019 - Present
    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.
  • Dnv
    Senior Program Analyst
    Dnv Sep 2019 - Present
  • International Health Management Associates, Inc.
    Database Analyst
    International Health Management Associates, Inc. Dec 2014 - Jul 2019
    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.
  • Database Insight
    Vice President
    Database Insight Sep 2014 - Dec 2014
    Greater Chicago Area
    * Business, Data, and Process Improvement analysis and consulting.
  • Ge Capital
    Field Analyst
    Ge Capital Aug 2010 - Jul 2014
    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)
  • Database Insight
    Vice President
    Database Insight Jan 2010 - Aug 2010
    Greater Chicago Area
    * Business, Data, and Process Improvement analysis and consulting
  • Ready Set Companies
    It Manager
    Ready Set Companies May 2007 - Oct 2009
    * 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.
  • Detail At Retail
    Data Analyst
    Detail At Retail 2003 - 2007
    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.
  • Bigger Than Huge Studios
    Sole Proprietor: Engineer & Producer
    Bigger Than Huge Studios Oct 1996 - Jan 2000
    * 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.
  • Cap Gemini Ernst & Young
    Report Analyst
    Cap Gemini Ernst & Young Jan 1996 - Jan 2000
    * 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
  • Morningstar, Inc
    Data Analyst/Editorial
    Morningstar, Inc Jan 1991 - Jan 1996
    * Wrote portfolio manager biographies, investment criteria, and industry blurbs for Variable Annuity publications.* Spearheaded conversion of data collection from fax to electronic formats.

Peter Michael Downes Skills

Management Access Project Management Leadership Microsoft Excel Training Analysis Human Resources Outlook Customer Service Team Leadership Data Analysis Retail Microsoft Word Forecasting Team Building Business Analysis Process Improvement Marketing Software Documentation Databases Sales Operations Inventory Management Microsoft Office Business Intelligence Vba Php Customer Satisfaction Payroll Crm Integration Peoplesoft Strategic Planning Microsoft Sql Server Mysql Business Process Improvement Microsoft Access Sql Server Management Studio

Peter Michael Downes Education Details

Frequently Asked Questions about Peter Michael Downes

What company does Peter Michael Downes work for?

Peter Michael Downes works for Dnv

What is Peter Michael Downes's role at the current company?

Peter Michael Downes's current role is SQL Programmer/Analyst (Data/Database/Business/Risk/Data Quality).

What is Peter Michael Downes's email address?

Peter Michael Downes's email address is pd****@****inc.com

What schools did Peter Michael Downes attend?

Peter Michael Downes attended Michigan State University.

What skills is Peter Michael Downes known for?

Peter Michael Downes has skills like Management, Access, Project Management, Leadership, Microsoft Excel, Training, Analysis, Human Resources, Outlook, Customer Service, Team Leadership, Data Analysis.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.