Resume

Sign in

Manager Data

Location:
Hockessin, DE
Posted:
October 17, 2019

Contact this candidate

Resume:

Craig Marshall

* ******* **., *********, **, ****7 302-***-**** adal6k@r.postjobfree.com

Summary

• Built specialized BI & Reporting function, provided work direction to others, worked across multiple business units to deliver reporting and BI solutions for complex issues, 20+ years in a scientific background, strong analytical and program solving skills, excellent written and verbal communications skills, strong data analytics experience, project management experience, strong use of SQL, VBA, Excel, Access, SQL Server.

Education

BACHELORS OF ARTS IN COMPUTER INFORMATION SYSTEMS GOLDEY-BEACOM COLLEGE

·Major: Computer Science

·Related coursework: System -based languages such as Assembly Language, VB, VBA, Java, JavaScript, C, C++. Also had classes in finance, accounting, business law, Database Architecture and Design.

·Graduated Summa Cum Laude.

Experience

SOFTWARE DESIGNER/DATA SCIENTIST QUALITY CONSULTANTS INCORPORATED SEPTEMBER 2017 - PRESENT

·Worked with the Acquisitions and Mergers team to move the assets, chemical research mainly, from DuPont into FMC and the new DuPont company currently known as Corteva. Once that split was complete, the effort was then underway to begin the merge with the remaining body of DuPont. The effort required the movement of hundreds of millions of data records in 36 different databases globally. The databases were Teradata, oracle, and SQL server platforms mostly. But actual paper records and electronic notebooks were reviewed as well to ensure its correct delivery to the appropriate client. Strong Use of Microstrategy and Aqua Studio.

DATA/REPORTING ANALYST ENVIRONMENTAL RESOURCE MANAGEMENT MARCH 2018 – PRESENT

·This project is in support of DuPont’s merger with Dow and subsequent split into 3 separate companies. The project consists of researching over 23,000 epidemiological files and categorizing them. This categorization became the search engine for the tool that is being delivered to the medical directors. The source data for these files consisted of work history data and medical records across hundreds of different Microsoft Access and SQL Server databases.

PROGRAMMER/REPORTING ANALYST CRITICAL PATH SERVICES (CPS) FEBRUARY 2002- JULY 2017

·Designed our time-tracking/invoice creation system for 100+ employees across 4 states. The solution used VBA/Excel/Access/Word.

·Created automation tools and reports for the client’s epidemiology group (which houses their employee “claims” data). The claims data were provided by health care providers to the client’s employees, which were used to recommend safety and process policies, as well as to provide litigious support. Used SQL Server/SSIS/TSQL/VBA/Excel/Access

·Created a system for CADDY XML creation, which transforms excel metadata with PDF files and combines it with XML programming to create an electronic dossier to European Regulatory Agencies. This automation allowed our customer to save time and money over the next best available off-the-shelf option. Used XML/VBA/Excel/Access/PDF

·Created tools for measuring KPI (Key Performance Indicators) in Excel and Outlook VBA, which manages the efforts of approximately 90 health care professionals. Used VBA/Outlook/Excel

·Flu Tracking. During the avian flu scare we were asked to provide a global data collection system for our client. We chose a web-based solution. This was a global scale project including hundreds of simultaneous users. Our solution used HTML/Cold Fusion/JavaScript (for masking personal information).

·For each of the projects listed, my roles varied from project manager to system tester to technical lead, doing the majority of programming.

First USA/Bank One programmer/reporting analyst 2000-2001

·Created Various automated reports for financial managers in the credit card field. Used Excel/Access/VBA

·Created Stored Procedures and Queries in Oracle Database.

·Had formal training in Oracle DB use.

DUPONT/WESTTOWN CONSULTING APPLICATION TESTER 1999-2000

·First assignment after leaving DuPont was as consultant for DuPont, designing an automated estrous cycle counter. Duration: 2 months Used: VBA/Excel.

·Worked as application tester in support of PECO Energy in their move from Mainframe to PeopleSoft Financials. Duration: 6 months Used: Cobol.

ASSOCIATE SCIENTIST DUPONT STINE-HASKELL RESEARCH CENTER 1989-1999

·Acted as Study Director on toxicology studies, Animal Care Technician, Performed Quality Assurance on Study Records, Wrote Toxicology Reports.

·Began writing macros/automation procedures to assist in the conversion of raw data to report ready tables, figures and appendices. Used: Macros (Pre-VBA) and Excel.

·Began working heavily with Microsoft Office Products, such as Excel, Access, PowerPoint, and Word, and the macros that make them more powerful.

·10 years’ experience working with SAS.

Highlights - Tool List Summary

#

Title

Summary

Solution

1

CePS

CePS is our version of PlantOS. CePS builds CADDY XML. CADDY's are the electronic version of dossiers which support pesticide registration in the EU. We made the tool in Excel VBA, and we taught the tool some basic XML functions. So the tool really builds the XML for us. We estimate that our tool saves our client 8-12 hours per submission, there is no licensing fees, and we completed for an approximate 80% savings for our client.

Excel VBA

XML

2

Timesheet/Invoicing

Created our timesheet and invoicing system for our employees (approximately 100+)across 4 states.

Excel VBA

Access VBA

Word VBA

3

Claims Data

Our client receives "claims" data from their vendor. A claim is submitted every time an employee visits a doctor. Acted as data manager for the client. One main function of the data manager is to support the Epidemiology group by creating summary reports while ensuring patient confidentiality.

SQL Server

TSQL, SQL

SSIS (SQL Server Import Specs)

Microsoft Access

4

KPI

Our client serves the Integrated Health Services Dept (doctors and nurses). This tool helps them to assess Key Performance Indicators (KPI). These indicators are a measure the efficiency of their work.

Outlook VBA

Excel VBA

5

LIMS

LIMS is a Laboratory Information Management System. One main function is to take the results of GC or Mass SPEC and produce reports. Also developed a bar code system which greatly increased the efficiency of hand entry data for frozen samples.

Microsoft Excel VBA

6

Flu Tracking

Our client was concerned about various Flu epidemics. We designed a flu tracking form using HTML and JavaScript. This tool allowed for immediate entry and reporting.

Javascript

HTML



Contact this candidate