Dave Peters

*** ******* **.

Wauconda, IL *****

*** – 788-9180

c. 847 – 804 – 3426

aczi3y@r.postjobfree.com

SKILLS SUMMARY

Operating Systems: Windows 7, 8, Vista, Windows 2000, Windows XP, Windows NT, Windows 95/98,10 Windows3. X, MS DOS, UNIX

Languages: VBA, VB, VB5.0, VB6.0, VB.NET, C#, SQL, VBScript, JavaScript, ASP, ASP.NET, HTML, FORTRAN, MQ SERIES

Technologies: .NET, MTS, COM, DCOM, COM +, XML, XML.NET, XLST, ADO, ADO.NET, Web Services (Design/Implementation & Consumption), SharePoint, PowerPoint.

Databases: SQL Server 2000/2005/2008/2010, Oracle, MS Access 97 /2000/2003-2010/XP, Sybase, DB2

Data Modeling Tools: ERWin

Report Generating Tools: ActiveReports, Crystal Reports, VB report Tools, SAS, Microsoft Reporting Services, WebFocus

Software Development Tools: Visual Studio 2005-2008, Visual Studio 6.0/.NET, Visual Interdev, FrontPage, Visual SourceSafe, MQ Series

Other Tools: Adobe Acrobat, Macromedia Flash, ePass, Photoshop, Power Point, Microsoft Office, PeopleSoft, Data Flex, Toxedo, Lotus Notes, Lotus 1 – 2 – 3, Excel, Microsoft Office Project Management, Siebel, Visio, Software Development Life Cycle (SDLC)

Data Warehousing - constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making including functions of Data Warehouse Tools and Utilities: Data Extraction, Data Cleaning, Data Transformation, Data loading and

Refreshing.

WORK EXPERIENCE

Abbvie (Former Abbott Lab)

Sept. 2016 – Current

Senior Business & Data Analyst

Advantech Solutions, Consultant

Security Vulnerability Remediation Program-Steering Committee.

Data analysis Project created for Abbvie Security Department.

Organize Data migration, warehousing & validation from different data sources, including SharePoint, SQL into Data analysis Templates. Provide input on incidents maintenance planning processes and systems. Work closely with the business areas and translate the requirements to IT solutions. Create Templates, custom Dashboards, reports (SQL, VBA, Excel, pivoting, Charts, graphs, MS Access). Create and implement into Excel Dashboard custom math formulas to estimate trends and forecasts of calculated issues resolves (Math & Statistics). Made dynamic charts and graphs Reports based on receiving data.

Coordinate all incoming data requests (collecting all information requests, assigned to correct groups, tracked to completion and distribution)

Execute listings and tabulations to support global drug safely and compliance.

Make automated templates to manipulate with data, make updates, auto generate reports and presentations. (PowerPoint, SharePoint, VBA, Excel).

Pinnacle Bank (PNC)

January 2016 – Aug 2016

Stefanini Inc., Consultant. Senior Operational Business Data Analyst.

Team Lead, Developer & Data analyst “Deck” project (Pinnacle Bank top management reporting tool).

Data Warehousing and automation current Dashboards and Excel Reporting using SQL Server, Excel and PowerPoint VBA. (macros pivoting, formulas, Sharepoint, Visio, Powerpoint.) Organize data migration from different sources into developed Excel template. (SQL SERVER, SQL VBA, Access, Excel)Provide data validation and analysis. Organize auto migration data to Powerpoint Presentation for Bank Engineering Department management. Automate Powerpoint Presentation(slides export & import, slides and shapes manipulation), auto upload & download presentation to&from sharepoint. (Visual Basic for Application, Excel formulas & pivoting)

CATAMARAN Data Analyst /Developer Consultant, SCHAUMBURG, IL May 2014 – Oct 2015

Catamaran RXClaim project for auditing department. Project automates pharmacy prescription and financial auditing process. Including PBMs - aggregate the buying clout of enrollees through their client health plans, enabling plan sponsors and individuals to obtain lower prices for their prescription drugs through price discounts from retail pharmacies, rebates from pharmaceutical manufacturers, and the efficiencies of mail-service pharmacies.

Create database and front end using SQL Server, MS Access, Excel, Visual Basic for application. Automate Excel Templates using VBA, macros, formulas.

Automate process to import data from Excel, text files and other sources to database. Organize Auto data validation, export text files for other group and create reporting tolls to compare Import and Export files and financial delta. Create Auto data analyzing process and pass reports to auditing or re-auditing process.

Create full documentation, end – user education and presentations using PowerPoint and Visio.

Automate data migration and Data Warehousing from different sources (SQL Server, text Files, Share Point and Excel files) into Access database. Automate clean up and validation raw data process. Manipulate with uploaded data, generate reports. Automate data manipulation in Excel. Create dynamic reporting tool in MS Access (MS Access 2007/2010, VBA forms, queries, Excel, macros SQL Server, tables, stored procedures, views).

Full circle project, SDLC, Data validation, documentation, end – user education, presentations (Visio, Power Point).

JPM Chase, Consultant, Elgin, IL August 2013 - January 2014

JPM Chase commercial credit card tracking tool. Fixed existing tool in Excel (VBA), add missing functionalities after MS Office change (xlsx, xlsm format).

Data Warehousing and Automate data migration from different sources (SQL Server, text Files, Share Point and Excel files) into Access database. Automate clean up and validation raw data process. Manipulate with uploaded data, generate reports. Automate data manipulation in Excel. Create dynamic reporting tool in MS Access (MS Access 2007/2010, VBA forms, queries, Excel, macros SQL Server, tables, stored procedures, views).

Discover Financial, Consultant, Riverwoods, IL March 2013 - August 2013

Audit scheduling system. Maintain and rebuilding existing MS Access application and Excel templates for multi user environment after MS Office and Windows migration, using VBA, Macros, MS Access, Excel, coding, form design and reports. Organize data loading from SAS and Excel to Access for future reports.

Northern Trust, Consultant, Chicago, IL January 2013 – March 2013

“Worldwide Traders Desktop Applications maintenance” after migration to Windows 7 and Office 2010.

Rewrite existing application in xlsm format, add and change functionalities.

Create database to keep all new standard requirements, add searchable functionality, create reports per user instructions.

Linked Access 2010 front end to SQL Server database utilizing VBA code and forms hyperlinks to documentation in SharePoint.

Automation in data transferring from Excel local desktop applications into Reflection IBM. Coding in VBA, Macros, modules, COM objects and Reports.

Reset and updated password protection features for custom Excel application.

AT&T, Consultant Hoffman Estates, IL October 2012 – January 2013

“In Fly” projects to support AT & T engineering department activities, including traffic control, installed equipment maintenance and field engineering support.

Loading data from different sources nationwide, such as Oracle, SQL Server, etc.,

Create front ends in Access 2010 and Excel 2010).

Maintain existing application to transfer VBA code and functionalities from .xls, xlsx files into xslm.

Automate existing workbooks and create new custom reporting tool in .xlsm format using VBA, SQL, macros, Access 2010, Excel 2007, Excel 2010, forms, queries, ActiveX controls and reports.

Organize system to distribute new reports and update existing trough SharePoint.

Miller Coors Brewing Company, Consultant June 2012 – September 2012

Project for Strategy Planning including Data analysis and existing Access, Excel application improvements and maintenance, based on new company policy, change requests and calculations.

Data Warehousing and Integrate Excel files into SharePoint and used SharePoint as a data source to track and deploy data.

Using Excel, 203-2010, VBA, SQL, macros and reporting tools.

Recreating existing documentation.

Services into MSDB, running packages on schedule basis.

Blue Cross Blue Shield, Consultant Chicago, IL August 2011- June 2012

Data analyst and developer for data migration project.

Organize database from different sources such as text files and Excel, make data validation, standardization and data maintenance.

Loading data into database, tracking ad hoc and standard reports development, using Excel, VBA, macros, coding and Access.

Merged Excel files into SharePoint.

Tracked and deployed data via SharePoint.

Used VB.NET and XML for deployment of packages

Develop MS SQL Server 2008 R2 based code to store packages from different sources in MSDB.

Create procedures and SQL Server jobs to run packages.

Create data flow presentation for user on weekly basis. Create SSSI packages, upload packages trough Integration Services into MSDB, running packages on schedule basis.

AON & Hewitt - Deerfield, IL March 2011 – August 2011

Application Developer Consultant

Rebuild and maintain existing large scale customer allocation and reporting tool and organize Data Warehousing. Project based on new end user’s and customer’s requirements after AON & Hewitt joining. Developer’s part includes forms, macros, modules, queries, VBA code.

Front end Access 2003. Back end SQL server 2007 and DB2. Create Excel – SQL Server data migration tool, stored procedures, triggers, views in SQL Server 2008.

Coding, collect outsourcing data and implement code and new project components including ActivEx and COM application.

Create project documentation, end user guides and presentations in Power Point.

McDonald’s - Oakbrook, IL October 2009 – February 2011

Application Developer & Data Analyst – Consultant

“Command Central” project. Create full circle project for McDonald’s Headquarter Command Central Division.

Application collect, store and analyze installation’s data and installers activity in Mc Donald’s restaurants worldwide. Create reports and charts for company’s top level management. Application includes back and front ends, reports.

Data Warehousing and automation Downloading data from Web into Excel, organize auto data migration from different Excel workbooks to the Central Excel master files, VBA coded procedures to organize and format received, data flow, then auto load data into Access and SQL Server database.

Created fully protected Access database and set up/created all custom security features for multi-user access.

Create reports parts to manipulate, update and analyze data, create reports in Excel & MS Access using VBA (code, tables, queries, forms and modules, ActiveX controls), macros and VBA in Excel (2003 – 2007), reports in MS Report services (SQL Server based tool).

Brand One Planet Corp. - Chicago, IL November 2008 – October 2009

Application Developer & Analyst – Consultant

“Energy Saving Control System” and activity reports” project.

Create SQL Server database in, including tables, stored procedures, DTP, to store and manipulate with energy saving products data.

Create front-end in Access to enter and tracking data. Create Access database and front-end tool to automatically upload data from different sources including plain text files, different Excel version files into Access and SQL Server database (ADO connectivity).

Create energy saving calculation reports and products comparison between previous “non-green” and new LED lamps technology, develop custom reports in Access and Excel based on user’s requests.

Create tool to for auto data migration from Quickbooks files to Access and SQL Server database. (VBA coding and QODBC 9.0).

Create project documentation and user guides. Create presentation package in Power Point and Excel including animation. Provide end-user trainings and education on the customer’s sites. (VBA, MS Access, Business Objects, queries, OLE objects, reports, Excel, macros, formulas, charts, SQL – Server, stored procedures, data transfer packages, schedules).

Deloitte - Chicago, IL June 2008 – October 2008

Data & Business analyst – Consultant

Prepare requirements for Tax Estimated package project for Deloitte clients, including Corporate Jurisdictional Tax Tool, Estimated Tax Practice Aid and Estimated Filling Instructions.

Estimate timeframe and manage project developing and implementation.

Create project presentation and data flow package in Power Point and provide presentation. Package calculates estimated tax liability for federal, all 50 states, New York City, Washington DC and 30 user-defined jurisdictions for C-corporations.

Application calculate annual tax liability on which estimated tax and extension payments mast be made. Calculate liability for income and non-income based taxes, provide matrix Summary of information relevant to the preparation of estimated payment vouchers and other federal/SALT filings, including a summary of non-income-based taxes, payment due dates, forms to use, etc.

Adjust calculations for the Treasury Department updates and regulations.

Assist professionals to annualized income installment method. Package Excel- based application, includes formulas, macros, charts, VBA, interactive connections between federal and state tax calculation parts, protection, user’s guide and technical documentation.

PepsiCo - Chicago, IL November 2007 – May 2008

Data & Business analyst – Consultant

Project developed for data management organization division for Human Resource Department in multi-user environment. Collect end user requirements, generate user guide and manual.

Create Automation raw data migration process from different sources, such as Excel files, Quick books, text files, etc. into SQL Server database using MS Access, VBA, macros, QODBC, PL SQL.

Provided data clean-up process based on internal selection criteria, presentation in Power Point, including animation.

Develop data entry and data manipulation front -end, with forms, data analysis formulas, using custom math formulas and internal company policy. Create reporting tool, for current monitoring financial activity, forecast and employee benefits, including graphs and charts.

Create Access front-end and SQL server database, including security part front-end, based user’s levels, separate user’s access to different layers of information, security password parts, forms, queries and reports design, coding in Access, Excel, VBA and SQL, prepare tables, relationships, stored procedures, views, data transfer packages.

Provide implementation, end-user training and education, including prepared in Power Point animation and presentation

Protective life insurance company - Bannockburn, IL September 2007 – November 2007

Team Lead - Consultant

Data Warehousing and Improvement of several customer service existing Access applications and reports, using VBA, Excel, Macros, SQL SERVER, including automate data migration process from Access and Excel into SQL Server database.

Design local electronic signature and password’s system. Rebuild old Access application versions, including front-end, back-end, queries, reports, VBA coding.

Current system support and end user training based on new system changes.

Becker Professional Review, DeVry University - Oakbrook Terrace, IL June 2007 – September 2007

Developer - Data Analyst

Automation reporting system process for CPA and CFA professional screening, using Oracle, Access, SQL queries, Discoverer, Excel, VBA, formulas and charts.

Provide existing reports maintenance and adjusting for new report automation system.

Develop new reports based on new company policy and requirements, using Access, Excel, VBA, macros, custom developed formulas, charts. Create back-end and front-end to enter report’s selection criteria and data manipulation.

Career Educational Corporation - Hoffman Estates, IL December 2006 – June 2007

Business Analyst

Reporting project using Microsoft Report Services, Crystal Reports, Visual Studio 2005, SQL Server 2005, XML, “.RDL” files project has been created to organize data migration & data flow from SQL Server 2000 into SQL Server 2005 environment and generate groups of reports including Ad Hoc reports.

Provide clean up data and data migration from different sources .CSV, .XLS files into database.

Project architecture and reports structure oriented to describe general and detailed company activities and tracking data by customer’s request in appropriate formats.

Reports has been created for marketing groups, sales department, accounting and legal departments to make statistic and financial analysis. Including, store procedures, data transfer packages, charts and data math analysis by custom formulas, data validation procedure and testing, reports development and deployments into Web based application, collecting user requirements and end-user education & training.

Baxter - Deerfield, IL June 2006 – December 2006

Business Analyst

Project has been created for marketing department to support Baxter marketing activity for new pharmaceutical products worldwide.

Provide sale analysis by products, micro & macro components, regions, hospitals, hospitals departments, patient's ages et cetera using Visual Basic 6.0, VBA coding, Excel, macros, SDLC technologies, statistical analysis, and math formulas, SQL Server, Access 2003, reports, Ad Hoc reports, charts and Visio diagram.

Convert Accounting Department existing, applications from Access 95 and Access 97 into Access 2003, transfer existing data into SQL Server using data transfer packages.

Compare with another products sale using statistical analysis formulas and Baxter internal formulas as well. Convert and transfer data from different sources into database, develop and provide data validation.

Developed front-end to analyze business process and sale represents reports domestic and worldwide.

Application includes front- end in Visual Basic that read, analyze and store Visio files data in Access and SQL Server databases that has been created as well and included store procedures and data transfer packages.

Prepare and provide presentation in Power Point for Baxter's marketing team and customers, including animation. (VB 6.0, Access 2003, Visio, Excel, SQL Server 2000, Crystal Reports Power Point). A variety of tasks required generally involving analyzing business requirements, working with marketing to develop technical solutions, with Sourcing and Finance to work out costs forecasts/budget and pulling together overall timelines and solution into a management summary.

Provide Baxter’s domestic & foreign representative training and software user’s support as well.

Danlee & Philips – IL May 2006 – June 2006

Consultant

Short term project for Sales Department. Existing sale analysis application maintenance and report system creating. Added extra formulas and new reports to evaluate sales activity and provide business analysis based on corporate standards. Technology part includes VBA, ActiveX objects, Access 2003, SQL Server, Excel, macros, Visio.

Motorola – Schaumburg, IL February 2006 – April 2006

Business Analyst – Consultant

"Global Analysis Reports System". Project has been created for “Global Analysis Department” for automatically evaluation and estimate current and make prognosis for future sales activities by company products groups, by regions and worldwide as well. Generate reports using WebFOCUS, which turns the collected corporate data into the meaningful information, complemented with the web components for presenting the information, and interacting with the end-users.

Analysis based on company standard requirements and contains math formulas and calculations.

Project created from scratch, using SDLC model and included databases, front-end, testing, user guide documentation, implementation support and Data Warehousing.

Tools and technology: Excel, macros, Access & SQL Server, Crystal Reports, Ad Hoc reports, VBA. WebFocus (FOCUS 4GL dialects).

Abbott Laboratories – Waukegan, IL Janaury2006 – February 2006

Programmer – Consultant

"Fisher Exact" – existing project modification provided for new sales requirements. Changed front- end forms and code to void source as text files.

Created procedure to transfer data from text file into SQL Server database. Data Warehousing. Created new SQL Server database and store procedures. Created code to track and manipulate data based on sales results formulas and standards. For new database mapped source data tables and fields from other corporate databases, created procedure for data validation as well.

Created new Excel report system. Application included SQL Server databases, Excel, VBA, Intranet report part in ASP, standard and custom financial math functions formulas and parameters.

Pactiv Corp. – Lake Forest, IL November 2005 – December 2005

Business Analyst – Consultant

"Building the profitability Model" has been created for financial department Pactiv Corp. Full circle of project included front and back ends, automation of data transfer and recalculation procedures, based on corporate standards and department management requirements to generate data and dynamic's reports, that shows sales department and customer's activity and profitability.

Application included Oracle and Access databases, Excel, VBA, Crystal Reports, standard and custom financial math functions formulas and parameters. Also, provided final product testing in financial environment, implementation, end – user training and support. Application based on System Development Life Cycle parts such as Software Requirements Analysis, Systems Analysis and Design, Code Generation & Testing.

Abbott Laboratories – Waukegan, IL September 2005 – November 2005

Data Analyst – Consultant

PowerCenter & Medics” Project to make automation in process to generate Excel files from collected Visio charts files from insulin division customer service worldwide.

Auto reading existing logic information on Visio files such as shapes, connectors, arrows and another objects, using chart’s logic to store this data in database. Using stored data auto creating Excel files in different formats, automatically replace Visio and Excel files into different directories based on management requirements.

Using Siebel have created and executed Internet-based marketing campaigns, to identify and acquire new customers, and to develop customized product and service offerings that meet customer requirements and expectations and facilitate unassisted selling. Create and tested Siebel reports by managers requests to get on-demand access to critical real-time information through one single system containing financial, customer relationship management, manufacturing, and management control capabilities.

Unit testing and auto data verification between original and created files. End - users training, guide documentation & implementation.

Project created using VB6.0, VBA, Excel, Visio. Siebel, Access 2003, Oracle, Powerpoint and SDLC methodology.

Ferro Pfanstiehl Laboratories, Inc. – Waukegan IL February 2004 – July 2005

Programmer – Consultant

”CAPAR – Corrective and Preventive Actions”, based on Federal Drug Administration Requirements and SDLC requirements.

Project created for the Quality Assurance Department and company different level management to generate all manufacture process quality control tracking & analyzing data and documentation including Customer Complaints investigation, Deviation Investigation, Recall Material Reports(including auto recalculation for different measure system parameters and shipping – receiving data), Multilevel Security System and Electronic Signature etc. for multi-user environment.

Project created using VB 6.0, SQL Server, Access, OLE Objects, Excel and Charts (front- end & back- end, reports, user requirements documentation, education implementation and support).

Created and set up custom security features including password, user id and electronic signature for a multi-user Access database. Database was fully protected and access depended on user’s level of permission.

Data analyzing part of project included selection criteria determination list and reports based on queries and selection parameters.

Product recall part of project included imbedded, custom designed math function to recalculate product quantity, volume, weight, terms of delivery and receiving.

Used data migration tools to transfer existing data in Excel into Access tables and then into SQL Server tables. Prepare transfer data packages to synchronize data with different databases.

Determine different user level and establish user connection using data mapping tools.

Prepared project’s validation based on FDA and internal requirements.

Created Power Point presentation materials for users and customers.

Technical compliance documentation and auditing. Part of application has been created for Laboratories supporting stability, microbiology, and raw material testing.

“Online Customer Complaint Handling System”. The project applies to all product complaints received (trough Ferro Pfanstiehl sales agents, directly from clients, or trough any other means).

Project include featured SQL Server 2000 backend, MQ series, Core components written in C #, COM + enabled transactional components, ASP. NET, ADO. NET, XML/XSLT technology, and SOAP - based services.

Designed XSLT Style Sheets were used to transform XML data into HTML output for end users.

Created automatically generate quotation database and front-end for Sale Department.

“Sign in & Actions” Project created for Quality Control & Chem. Lab Department rebuild existing plain Excel spreadsheets in Access front- end and SQL Server database.

Project included Excel macros, charts and math functions, reports and password system.

Abbott Laboratories - Waukegan, IL June 2003 – January 2004

Data Analyst – Consultant

“Verifier” project created for Abbot Diagnostic Division, automatically analyze and validate corporate documents, based on corporate and international pharmaceutical and medical standards, using Visual Basic, ActiveX VB applications, Excel, macros and Excel objects, charts, Pivot tables and third party controls. This project is designed to provide all the objective evidence required by the governing documents. Provide implementation, user’s education and support.

Validate Documentation Report” system. Troubleshooting incoming calls and create reports with Crystal Reports, created Access database as back end contains information about all validated documents, details and changes based on the company requirements and limitations. Create “Validate Report” system using Crystal Reports, macros and queries to track data by different parameters, users and Department management requirements.

“Formula Analyzer” project was developed to assist in validation activities and test the

Ability to find all formulas and determine which are “unique” formulas within a user Excel workbook. The user interface provided for the testing and documentation of each unique formula will also tested.

Dresden Nuclear Station - Morris, IL March 2003 – May 2003

Programmer – Consultant

"Lessons Learned" project using VB 6.0, ActiveX,, VB applications, created database in Access XP, using queries, macros, reports and Excel, Novell to perform an evaluation and remediation, testing and implementation, (Included front – end, back – end), user’s education and support.

International Health Management Company - Schaumburg, IL July 2002 – February 2003

Programmer – Consultant

Created several projects using VB 6.0, ActiveX, dll files, VB applications, Access 2000, Crystal Reports, SQL Server, Windows NT and additional Third Party programs including: Internal/external On-line client’s and company’s microbiology specimens test / result processing and work order systems for Data Entry, Laboratory & Project departments. (Included front-end, back-end, installation and support).

Designed and implemented Package - Login and shipping systems for Laboratory and Shipping Department (Included front- end, back- end, installation and support).

Created special based on Digit and Bar Code Labeling System program for Laboratory and Shipping Departments for each of tested and shipped specimen. (Included different Labels and Bar Code design, Bar coding & Bar Code reading system, front- end, back- end, installation and support).

Developed Test – Processing subculture’s / drug’s system based on Aerobic/Anaerobic test’s environments (Included front- end, back-end, installation and support). Technical compliance, (Laboratories performing bio-analytical testing in support of non-clinical and clinical studies.)

Created report’s front and back-end for Company’s management, based on company’s general and laboratory’s activities.

Developed for Laboratory Manager and Laboratory Staff front and back- end, to create current test methods forms, documentation and test methods data entry system.

Developed Trade Shows and trading applications to support Sales and Lab Departments efforts to market and ship organisms that are contained within their freezers. The application is a multi-parameter search feature, with several reports.

Created automatically generate quotation database and front- end for Sale Department.

Participated in redesign, maintenance and support existing company’s programs included Client Package Indexer and Exporter Systems, based n VB 6.0, ActiveX, SQL Server.

NuBreed Technologies, Inc., Chicago, IL April 2002 – June 2002

Programmer – Consultant

Created a scalable E–Commerce solution framework for generic On–line Store–Front deployment. The NET – based application framework featured SQL Server 2000 backend, Core components written in C #, COM + enabled transactional components, ASP. NET, ADO. NET

Contact this candidate