Consultant

• Sep 2020 - Present

IT Consultant (1099) / Data Engineering:

• Jan 2020 - Mar 2020

SSIS DATA ENGINEERING DEVELOPMENT AND SUPPORT: TEMPORARY BACKFILL FOR OUT OF COUNTRY STAFF: • Programmed SSIS Pipelines, coordinated and tested deliverables with client operations • Identified and reprogrammed tasks ensuring stage datasets were processed correctly and delivered. • Programmed new projects and aligned with standard development methods SSIS DATA ENGINEERING DEVELOPMENT AND SUPPORT: TEMPORARY BACKFILL FOR OUT OF COUNTRY STAFF: • Programmed SSIS Pipelines, coordinated and tested deliverables with client operations • Identified and reprogrammed tasks ensuring stage datasets were processed correctly and delivered. • Programmed new projects and aligned with standard development methods

Business Intelligence Developer / Data Engineering

• Jun 2015 - Aug 2019

DATA ENGINEERING AND DATA SCIENCE SOLUTIONS:SAS BIG DATA SCIENCE CERTIFICATION: • Programmed SAS PROC SQL and stats functions, Cloudera hadoop• Contingency, market basket, confusion matrix, hypothesis test, naive bayes, pearsonALTERYX DATA ENGINEERING AND SCIENCE:• Programmed Statistics, R and Python toolsets, MongoDb ETL and administration• RegEx, fuzzy match, clustering (Kmeans), association analysis, random forest, decision trees, regressionDATA ENGINEERING AND SCIENCE:• Drove daily progress on projects in multiple environments• Programming toolsets: SQL(MS and Oracle), SSIS, SSAS, SAP Business Objects, Alteryx, SAS, RPA(UiPath)• Programmed MS & ORACLE SQL scripts, views, stored procs, user defined functions, source to destination ETL.• Views to source data, UDF's filtering and converting field data types, stored procedures to select,insert, update data • Visualization & SQL programming in Tableau, Power BI, Business Objects, Crystal Reports, SSRS, Lumira, Minitab• Analysis/Modeling, Software QA, Forecasting, PDCA, ANOVA, Time Series Analysis• Azure Cloud programming API's, data science VM's, Cortana templates• Big Data Hadoop, Hive, Apache NIFI Real-time broker install, configure, programming external views as sources• Industry Sources: SAP, Cygnet, ARIES, Flowcal, Peloton, Drilling InfoProblem, Action, Result o P: Time and costs to complete the drilling of wells to be improved. Third-party drilling operator Big Data to be ingested, processed and analyzed. o A: Programmed Apache NIFI process groups from SFTP site to on-prem Hadoop Hortonworks HDFS and HIVE External tables. Programmed Tableau and MS PowerBI visualization dashboards to HIVE.o R: Developed end-to-end Big Data analysis environment of real-time drilling data from external partners, Decreasing the rate-of-penetration of drilling improves relevant and significant productivity and drilling costs by decreasing the time and costs to complete wells drilled.

Senior Systems Analyst

• May 2014 - May 2015

DATA ENGINEERING, ETL, AND MODELING • SQL, Mainframe IMS, DB2, Flat file, multi-layout• Interactive data-maps, and dashboards of global research, marketing, and sales metrics.• Biologic pharmaceutical and medical device development case studies• Value chain analysis, and business modeling including FDA cGMP/GCP (current Good Manuf./Clinical Practice), ICH (Intl. Conf. Harmon.), USP (U.S Pharmacopeia)Problem, Action, Resulto P: ETL procedures relying on manual conversion and search increase cost and demand on project resources.o A: Programmed and linked multiple extracts and filters using Textpipe, Perl, Powershell, VB, and VBA (Excel and Access).o R: Standardized, consolidated, and automated tasks. Decreased processing time 62%, increased productivity and ROI.

Senior Business Analyst

• Jan 2013 - Dec 2013

DATA ENGINEERING AND INFORMATICA ETL:• Programmed Informatica, Oracle SQL data warehouse of claims, commissions, and risk mgmt.• Developed dashboards: SAP Business Objects, Cognos, Crystal Reports, KPI's, UAT, QA• Rational Unified Process use case and activity modeling requirements, actors, processes.Problem, Action, Resulto P: Development projects regularly and repeatedly met deadlines and testing but found to be defective in production.o A: Developed context and systems diagrams to identify inconsistencies between requirements and technical designs and collaborated with business and technical staff to correct development and implement correct functionalityo R: Increased quality, productivity, and client satisfaction by delivering zero defects.o P: The details of inefficient data transfer processes with business partners and their status were not modeled.o A: Developed and analyzed systems analysis diagrams depicting process scope, procedures, and data stores and had technical and non-technical teams consider the business cases and efficacy of various procedures.o R: Processing modifications made to sequence of summarizations that decreased processing time by 66%

Business Process Engineer

• Mar 2012 - Dec 2012

LEAN MANUFACTURING BUSINESS PROCESS ETL DEVELOPMENT: • Designed and programmed custom product configuration sales-to-engineering order tracking.• Designed and programmed custom staffing demand and capacity analysis tool• Integrated Active Directory securing engineers schedules, assignments, productivity, KPI's• Programmed Business Objects, VBA, SQL, Sharepoint, and Access.Problem, Action, Resulto P: Limited demand and capacity metrics for engineering hours decreased productivity and increased costs.o A: Collaboratively translated business needs to technical requirements for KPI business intelligence system projecto R: Developed network integrated demand and capacity KPI metric system providing departmental productivity and scheduling charting to managers and personal assignment and productivity reporting to engineers and drafters.o P: High degree of variation in specifications for industrial drives increased engineering hours and manufacturing costs.o A: Developed customized LEAN product configuration sales-to-engineering order entry and reuse system.o R: Improved collaboration and innovation between sales and engineering that decreased delivery time and costs.

Systems Analyst

• Jun 2008 - Aug 2011

• SAP Business Objects XI conversion project lead• Translated complex technical configuration options, configured system architecture and implemented on time.• Installed SAP & IIS software, Windows Servers, MS SQL in HP Polyserve & VMware.• Configured SAP data migration tool and Central Management Servers to reduce CPU and memory utilization providing zero downtime for clients.• Programmed SAP universes using Designer, Web Intelligence documents, Xcelsius dashboards, SQL, and Crystal Reports.Problem, Action, Resulto P: Reporting system migration did not distribute via email and required downtime for maintenanceo A: Analyzed and resolved software versions and architecture. Purchased, installed and configured new softwareo R: Provided production-ready system increasing user productivity, system security and eliminated downtimeo P: Named user licensing and folder navigation of application required user administration and poor ease of useo A: Analyzed security and application options and integrated application and network security authenticationo R: Eliminated security administration demand on users and increased ease of use and client satisfaction

Systems Analyst

• Jun 2006 - Jun 2008

• Implemented GE Imagecast Radiology Information System and developed custom SQL scripts for clinical and financial Crystal Reports and administered dictation system • HL7 ConnectR billing and clinical system interface SQL transaction support• Systems Admin: Configured HL7 ConnectR EMR system interface servers to operate using clustered servers: restored communications & re-transmitted interrupted messagesProblem, Action, Resulto P: Patient order messaging transactions between systems stopped during peak communication periodso A: Set interface transaction servers to operate using non-failed clustered serverso R: Restored transaction communications between systems and verified or retransmitted all interrupted messages

Database Manager

• Jan 2000 - Jun 2006

• Clinical trials research data manager using SAS, SPSS, MATLAB, SQL Server, Access, and Active Server Pages o Managed requirements and programming projects tracking subjects, samples, and imaging at sites in U.S. and Europeo Developed and customized SQL and Access databases to reliably audit collection of clinical assessment datao Developed processes to reliably audit collection of assessments and ETL of Genomic and imaging data (PET/CT)o Developed and audited scanning OCR forms using ScanTools and Teleform that reduced costs by 25%o Supervised staff and coordinated career path transitions among business units by implementing training plans for staffProblem, Action, Resulto P: Patient tracking system did not integrate data from multiple international siteso A: Managed project and staff translating business requirements and developed patient tracking websiteso R: Sites able to conduct comparative analysis of local data accurately in a more timely mannero P: Collection processes of sensitive patient data created data security risks and was prone to erroro A:Developed de-identified data capture and tracking system using optical character scanning databases and web siteso R: Increased security and accuracy of patient information and ease-of-use in data capture and reduced costs 50%

Systems Developer

• Jun 1995 - Jan 2000

• System Developer upgrading departmental systems, Help Desk Coordinator managing support, Mainframe Systems Operator