United States
Supported Industries: Global Pharmaceutical (Supply Chain and Manufacturing, Clinical Packaging, Commercial, R&D, Compliance & Validation) Global Shipping and Logistics Global Consumer Goods Telecom Regulation (Compliance) Defense Contracting Environmental Testing Banking (Compliance and Risk Assessment) Healthcare Using database and development tools such as: Tibco Spotfire, Meditech, Informatica Powercenter, R, RStudio, VisualCron, JAMS Python, Anaconda Amazon Web Services (EC2, S3) SAP HANA Oracle SQL Developer and Data Modeler Pentaho Business Integration Suite AllFusion Erwin Data Modeler DB2, Oracle thru 12 SQL Server 2005 thru 2019 SQL Server Data Integration Services (SSIS) and Reporting Services (SSRS) Methodologies: Agile Development, Systems Development Methodology (SDM), Systems Development Lifecycle (SDLC) COTS: Labware LIMS ChemWare Horizon LIMS Honeywell POMS
Created Dashboards, visualizations, and other capabilities using Tibco Spotfire, R and Python to support the Global Supply Chain and Manufacturing. Specifically I was involved with Quaility, LIMS (Pharma, Environmental, Stability and Cell & Microbiology (CMB)), Back-Order prevention, Inventory Optimization, Logistics, among others. Automated many manual tasks using R and Python running on AWS EC2 instances. Created other capabilities such as daily Newspapers which contained current and forecast sales and consumption quantities, HeatMaps with similar data by type (Pharma, Small Molecule) and then also by Portfolio and Market. Those Newspapers were emailed automatically to those that had subscribed via mail groups. Consolidated data, reports and visualizations across multiple databases and applications, to provide a reliable, single truth for leadership. Some of the consolidations were for Quality (Audits, Observations and Corrective Actions (CAPA)), Backorders / Anticipated Backorders (resulted in a 70% reduction in hours and resources). Responsible for the setup and maintenance of those EC2 instances, S3 buckets and migration towards DevOps using Python and Lambda. And more....
Supporting Risk and Compliance, performed data analysis including but not limited to: • Analyze and resolving data gaps • Developed SQL queries to perform analysis • Data modeling using PowerDesigner • Gathered and wrote requirements from the business level through design • Data Mappings and Migration using Informatica PowerCenter • End to end testing • Consolidation of existing and development of new data warehouses to store operational data and reporting data separately. This improved performance, reducing processing time and provided a better customer experience.
Technologies: ChemWare Horizon LIMS v11 application and database, Oracle 11g R2, Microsoft Office, PL/SQL Reporting: Created new Electronic Data Deliverables (EDD) for reporting purposes using Horizon LIMS Data Layer, replacing MS Access based EDDs. EDDs provide data related to batches, samples, testing and results in standardized formats for the given requestor. Additionally: • Rules Engine o Setup data mappings for each EDD o Performed import / export activities • Created automated testing scripts, etc. • Other activities as needed. EDDs: EDSA7 for NJ DEP, EQuis 4, EZ EDD, NY Department of Environmental Conservation, EPA Region 2 and 4, Port Authority EDD Checkers: Horizon EQuis EDD Checker, EDSA7 EDD Checker