Created daily workflow processes to bring in millions of rows of customer data from an AWS S3 server to our Snowflake database, using SQL and python programs. Used data mining techniques to pre-process data, ensure matching of data types, keep data integrity, prevent truncated data, and remove duplicate data.Analysis of data from previous defunct processes, to prevent further corruption. Migrated data from our Hadoop environment to our existing Snowflake database. SPOC for the installation and administration of QuerySurge, an application which helps validate data once it reaches the Snowflake database. Reviewed SSIS packages for efficiency, and debugging failed workflows.

Assured software, server, and data processes are completed as needed and on time. Responsible for ensuring all servers were up to the newest version of Java. Provided weekly executive status reports.Organized the process to assure IPv6 compliance.

Responsible for creating SQL stored procedures, ETL, and creating tables and views for web and BI based data needs.Created reports via Excel, BI, and BO.Extracted and large amounts of data, via SSIS from external sources to determine technician habits that were not cost effective for the company. Also, provided more cost effective options for the technicians based on the data.Utilized SSIS for error handling, package preview, event handling, and re-running of failed SSIS packages.Experience using SSIS to transform data such as derived columns, data conversion, pivoting and unpivoting data.Utilized GPS coordinating systems to keep track of employees and vehicles. Worked directly with Area Manager discussing time frames and scope of work, to ensure product completion. SPOC for the home dispatch of technicians for the Central Atlantic and Southeastern United States.Primary duties included determination of availability based on past performance, reporting statistics of home dispatched technicians, removal of technicians from the program, and coordination of operations with the other 5 areas of the country.

Responsible for remote and onsite analysis, design, custom development, testing and support of software for local governments across UNIX, LINUX and Windows based platforms.Provided baseline bug retrofitting, database management, remote & onsite training and go-live assistance.Coordination with clients on time frames and availability of their system to ensure upgrades and customizations were coordinated as to not interfere with daily operations. Primary support specialist for the Utility Billing, GIS, and web access software. Designed and implemented a data import program for ESRI, a 3rd party mapping software. The program is SOAP based and pulls data from our database for use in the Arc ESRI mapping solution.Created training curriculum for our UNIX client’s system IT administrators as well as many of our other software options; this included, database management for both standard and online engines, file and directory manipulation, user account maintenance, and security permissions.Mentored several new employees in the processes of the company and taught them our core software programs.Led major rewrite of several proprietary applications, converting modules from Informix to C#, as well as delivering code upgrades, bug fixes, training, and documentation.Use of SharePoint to store, organize, and share files used across team areas.

Leverage 36 years of cycling experience; road, track and mountain biking, to implement training plans for competitive and elite cyclists and inline speed skaters, generated specifically to individual goals and needs of the athleteRecruited, organized, and scheduled members for cyclocross events from 2012-2014. I have promoted numerous races for 12 years that regularly brought in hundreds of local, regional, and world class racers. I promoted three state championship events. Just to name a few of the many duties would include pre and post registration, volunteer management, sponsorship deals, local advertisement and promotion, as well as traffic control. Wrote a program using C# and SQL server for my day of registration, records keeping, Timing and scoring, and accounting.

I am honored to have managed one of the Historic Fine Dining Restaurants of the Lehigh Valley, with a staff of 15. Position duties included, but not limited to were, inventory, planning social events such as weddings, business luncheons and other special events. Scheduling appropriate staff on daily basis and for stated social events.