Terry P. Email & Phone Number

Milford, Oh, Us

Milford, Ohio

Software development with Microsoft stack: C# utilizing Azure DevOps for CI/CD deployment.Agile Development with 2 week sprints and daily scrums. Activity tracking using Atlassian Jira.Migrating source code repository from TFS to GitLab.

• SSIS – Develop ETL (Extract, Transform, Load) packages to pull data from source systems and load target databases using SSIS. Developed, implemented, and maintained business driven modifications for six unique data loaders to populate Company grown data warehouse table using SQL Server 2010, 2012, and 2016. Data arrived in a variety of formats: Excel, flat file, Access DB, XML• Monitored data warehouse load processes and resolve issues as they would arise• SSMS - Develop views, stored procedures, and functionso Rewrite existing queries to improve query performance and optimize codeo Define table indexing and partitioning strategies to improve database and query performance• SSRS – Developed reports relevant to the business needs• PowerShell – Developed file archiving script for auto-archiving during SSIS data loading. Wrote many additional scripts to automate repeated daily tasks• C# – Developed automatic email notification application to send email alerts to employees in all offices for expiring AD password• Participated in the IT Leadership forum responsible for driving the direction and innovation in the IT organization• Lead support for the Trade Promotion Management system for the Sales Department• Procured and setup new laptops and desktops, including imaging PCs and installing all software• Maintained all Company issued cell phones, trouble shooting issues to quick resolutions. Maintained relationships with Verizon and AT&T• Setup and maintained all Company desk phones (VOIP) with Cin Bell Emerge system• SharePoint admin for Company site. Including security permissions and user access• Domain Admin responsible for adding and maintaining user accounts, OUs, contacts, security groups• Office 365 admin for Company. Setup and maintain user email accounts• Traveled to help maintain 10 manufacturing and office sites for Company

Developed applications in C# for both Windows and web based environments using VS 2003, 2005, and 2008. Proficient in SQL Server 2000, 2005, and 2008 development of stored procedures, Integrated Services (SSIS), and Reporting Services (SSRS).Helped develop a web-based internal portal for over 1200 retail storesDeveloped an asset management application utilizing a SQL database backendDeveloped an application to gather and FTP transfer nightly ACH submissions files to 5/3Experience with single sign-on application developmentDeveloped numerous SSRS reports. Delivering reports via subscriptions in many forms including email and shared drive locationsSSIS experience in creating and deploying packages, maintaining nightly jobs to execute packagesRegularly delivered applications on time during multiple reduction in work force periodsSharePoint Administer

Scheduled and managed all office furniture/cubicle installations from Columbus to middle Kentucky. Solely responsible for estimating costs of all installations for design and sales departments Sixteen direct reportsResponsible for helping setup all PCs and maintain company network

Set-up and maintain PCs. Created zip code data bases and set-up of company web site. I conducted daily sales and customer service activities. I ran all day-to-day business operations including checking of all of the receivables, and process all of the payables.Trouble shoot and repair products as needed, facilitate and assist with all customer complaints.Maintained all PCs for the company Designed and implemented the database for tracking all customers and salesIncreased customer base through excellent sales and maintaining a great relationship with all customersHelped to determine mark-up for all products sold

Edited retail sales data. Cleaned data for errors and processed reports for blue-chip companies such as Phillip Morris, Miller Beer, Gatorade, and Quaker Oats. As Asst. Network Admin I helped set-up and maintain file servers and individual workstations as needed.Maintained databases and developed reportsFour direct reportsHelped maintain computer systems, both hardware and software - including Novell Netware network servers

Cincinnati

Assisted in cleaning and compiling data from numerous supermarket chains across the country.Edited data to produced customer reportsAssisted in mass mailings and shipping of reportsDaily compiled reports from store sales activity and advertising campaigns

Associate Of Applied Business Degree With A Focus, Computer Support Technology And Computer Science

Associates, Business Administration