Joseph Merkel Email & Phone Number

Concord, Ca, Us

Concord, Ca, Us

Typical Duties- Manages projects with multiple clients by communicating with business stakeholders to ensure task completeness, certifying project deadlines are met, providing internal logistical support, and supervising project funding to prevent cost overruns - Provides customized Supervisory Control and Data Acquisition (SCADA) integration services to businesses in the green-energy, food, and pharmaceutical sectors- Creates Extract-Transform-Load (ETL) applications to integrate web APIs with internal data historians- Writes technical system documentation for GxP and non-GxP systems- Creates supervisory dashboards and develops equipment monitoring notification strategies Major Projects with CKC AutomationGilead – OSIsoft/AVEVA PI Historian Facilities System and Operations Update- Supervise 4 engineers and coordinates tasks with customer to deploy a cloud-based PI Data Historian - Create a system health database with linked dashboards to monitor data historian status- Troubleshoot malfunctioning data pipelines and integrate new equipment into the asset model- Update system functionality by incorporating MQTT based IoT devices and integrating Ignition gatewaysAllergan – GE iFIX SCADA & OSIsoft/AVEVA PI Historian System Migration- Migrated a GE iFIX SCADA system and OSIsoft/AVEVA PI Data Archive using best security and operations practices by installing and configuring applications on new virtual infrastructure - Updated obsolete VBA code and removed bugs to meet revised system requirementsNaturEner – PI ACE to PI AF Analytics Conversion- Analyzed existing Visual Basic programs to convert procedural code to AF Analysis compatible scriptGrifols – OSIsoft PI Data Historian System Installation- Installed an OSIsoft PI Data Historian System to service a new pharmaceutical product test facility - Identified new system requirements by interviewing stakeholders, analyzing operations, and reviewing managerial expectations

- Processed incoming payables- Wrote checks for approved payables- Tracked Vendor Certificates of Insurance- Created and organized maintenance requests - Processed move-outs and wrote collection letters- Created Excel tables to divide bills among applicable properties- Provided support for Residential & Commercial Account Managers

- Managed U-Haul equipment and 800+ storage units - Acted as cashier for in-store purchases & storage payments- Performed daily reconciliation, collection calls, store opening/closing

- Maintained accuracy of over 250 advertisement accounts- Executed month-end closing procedures through ETL processes- Managed 4 employees to verify ad printings and correct billing- Organized office and filing systems to better utilize space and insure availability of back-up data- Collaborated with the Cal Poly Accounting Department to set internal controls by providing audit backup and accurate financial data- Created forms to track accounting adjustment information to improve department revenue records- Assisted the facilitation to an electronic database system (AdPro)- Contributed to receiving the CNBAM #1 Newspaper in America-circulation under 30,000 award

Certificate, Data Analytics

Associate Of Science - As, Computer Science

Bachelor Of Science, Business Administration; Accounting