• 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.
BACHELORS OF ARTS IN COMPUTER INFORMATION SYSTEMS GOLDEY-BEACOM COLLEGE
·Major: Computer Science
·Graduated Summa Cum Laude.
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
·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
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.
Created our timesheet and invoicing system for our employees (approximately 100+)across 4 states.
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.
SSIS (SQL Server Import Specs)
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.
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