Shawn Hendricks Email & Phone Number

Pickerington, OH, US

Columbus, Ohio Area

• Responsible for creating residential marketing lists based on criteria give by marketing group and management. Process consists of loading text files into Oracle database, standardizing data, executing filtering based.
• Assisted IT group with ETL of customer data from external billing company to and internal billing system as part of a company merger.
• Created multiple Python scripts to scrape website data and save it to a MySql database.
• Created C# program to upload data to Emma email marketing platform.

Columbus, Ohio Area

• Created C# application to download variable quantities of files from multiple vendors FTP sites and preform automated ETL process into an Oracle database.
• Improved Oracle database performance and data integrity by implementing indexing and foreign keys.
• Created tables and views to help track business operation data in Oracle that was not previously being tracked.
• Created C# application that logs into a web site and submits customer account numbers required by the utility. This automated process submits approximately 100 records in five minutes.
• Responsible for UAT of web application. Must coordinate testing and problem resolution between end users and development team.

Columbus, Ohio Area

• Automated existing manual reporting process using C# to do the following: Allow reports to be viewed in a database, export data to Excel, and email reports to customer service representatives or directly to the customer.
• Created C# application to import CSV files from ERP system into MySql database. The application is a multi-threaded application that simultaneously downloads 11 files from an FTP server and 20 files from Outlook and.
• Created a C# application that exports data into a fixed width text file for customer to import into SAP.
• Responsible for ad hoc reporting for customer service representatives, managers and customers.
• Created an Access database to ensure compliance with customer pricing contracts. Database compares cost and price, and then requires customer service to give an explanation of why an order was not compliant.

Columbus, Ohio Area

• Web administrator for facility and database administrator of several Access and MySql databases.
• Designed a web based repair backlog application.Created a Visual Basic program that imports data from an Oracle based ERP system and exports the data into a MySql database. Site has query and filter capabilities and a.
• Designed a web based quoting application.Requests for quotes are submitted by an offsite employee.The application allows for data entry and extracts product structure, inventory and cost information from ERP.
• Designed several web based reports that eliminated manual reporting processes for purchasing, customer service and manufacturing departments.
• Designed an Access database to extract data from an Oracle database and populate Excel spreadsheets.The spreadsheets were used by the IT department to transfer data from one ERP system to another.Spreadsheets were.
• Designed a web front end for customer service and engineering departments to query data from legacy systems. Data is stored in Microsoft SQL server, Access and MySql databases.Data could not be migrated into new.

Columbus, Ohio Area

• Created an Access database to track order information that was not in ERP system and allowed for additional reporting capabilities.
• Created an Access database to track time spent working on orders so it could be billed back to customer.

Assembled printed circuit boards.