Net Developer Sql

Harry Wilfong Telephone: 717-***-****

*** ******** ***** *-****: *********@*****.***

Etters, PA 17319 https://www.linkedin.com/in/harrywilfong1999/

PROFESSIONAL SUMMARY

Highly motivated IT developer with 10+ years of experience with an eye for detail and a proven ability to meet deadlines. Strong creative and analytical skills with a goal-oriented mindset toward development of business requirements. A team player experienced in project management and leadership.

TECHNICAL SKILLS

Programming: C#, VB.NET, MVC, ASP.NET, UI/UX, LINQ, VB6, VBA, HTML, CSS, Bootstrap, JavaScript, JQuery, Angular JS, JSON, Classic ASP

Database: SQL, SQL Server, Oracle, SSIS, SSRS, SASS, Oracle PL/SQL, ADO.Net, Microsoft Access

Other: .Net Framework, BizTalk, TFS (Team Foundation Server), WCF, SourceSafe, Crystal Reports, Web Services, Windows Services, AGILE, SCRUM, PowerShell, ErWin, SQLIdeara, Solar Winds, RedGate

PROFESSIONAL EXPERIENCE:

Dataquest

Enterprise Application Architect

Harrisburg Pennsylvania February 2022 - Current

Analyze all requirements and maintain all architecture business systems and documents. Administer installation and provide support to all documents. Design various integration programs and prepare required documents for same and execute various integration platforms. Maintain oversight for all third party processes.

SQL Developer

Glatfelter Insurance Group

York, Pennsylvania Dec 2020 – February 2021

Managing and monitoring a multiple SQL Server environment, including but not limited to backups/recovery, performance tuning, patching and upgrades, planning/install/configuring new SQL Servers, system documentation, security, server auditing, programming SSIS packages, Report development using SSRS, and troubleshooting.

Bath Fitter

Lewisberry, PA: September 2019 – Present

Full Stack Developer

Evaluates and analyzes business requests to determine specifications and requirements for custom application development using VB.net for legacy applications and C# MVC for new development.

Evaluates and analyzes service support tickets to determine specifications and corrective action.

Develops, enhances, and maintains ad-hoc and recurring company reports from backend SQL Server databases.

Pennsylvania State System of Higher Education

Harrisburg, PA: January 2015 – September 2019

SQL Server BI/.Net Developer

Developed code to capture and correct address information though geocoding APIs. Implemented google maps UI to provide “in the app geo services” like locating addresses, providing directions, appointment locations, and searches on the map.

Created stored procedures for automated end-of-day operations using SQL Server agent.

Performed data migration to SQL Server.

Setup email notifications for ETL process using Data Integrator in SSIS and SSAS.

Developed jobs and alerts to run SSAS and SSRS packages periodically.

XML Development and XML File Parsing.

Created automated processes for the activities such as database backup processes, SSAS and SSRS Packages to run sequentially using SQL Server Agent job.

Siemens

Mechanicsburg PA: June 2014 – October 2014

Systems Analyst 3

Built, maintained, and scheduled reports to client specifications in Crystal Reports XI.

Created stored procedures in SQL Server for the purposes of reporting.

Troubleshot and resolved issues with reporting in operational reporting, context sensitive printing, and Job Scheduler reports.

Automated daily system tasks through the use of PowerShell.

NORCAL Group

Mechanicsburg PA: October 2012 – June 2014

Crystal Enterprise PL/SQL Developer

Developed reports using CSS and HTML5 for an online application.

Used ETL processes and dimensional model design for the purpose of data mining for creation of reporting views.

Administrative Office of Pennsylvania Courts (AOPC)

Mechanicsburg PA: April 2004 – October 2012

Crystal Enterprise .Net Developer (Ajilon Consultant)

Acted as Staff Manager (Ajilon) screening candidates for technical positions, performed technical interviews, assessed communication abilities and fit at various sites. Performed annual reviews and salary recommendations. Produced weekly reports for Ajilon’s corporate office regarding various projects and timelines.

Developed and maintained reports for Common Pleas Criminal Court Management System using Crystal reports and SQL stored procedures.

Recipient of Ajilon Silver award for Outstanding Service and Contribution to Company and Client.

Teachers Protective Mutual Life Insurance

Lancaster PA: August 2000 – April 2004

IT Manager/Developer/Analyst/Systems Administrator

Developed VB.Net client side and ASP.Net web based (intranet and internet) rate quoting program for company underwriters and agents.

Assisted in creation of a data repository of a document imaging system.

Was responsible for all hardware and software certification for HIPPA compliancy.

Created and maintained project schedules and database documentation, and acted as liaison between all project contractors.

Created and configured OLAP Cubes using SQL Server Analysis Services.

Designed logical/physical data models using Erwin.

EDUCATION

Massachusetts Institute of Technology

Certification in Artificial Intelligence with Data science

COMPUTER LEARNING NETWORK, Camp Hill, PA

Diploma, Computer Systems Technology

NORTH AMERICAN INSTITUTE OF AVIATION, Conway, SC

Flight Certification and Teaching Certification

REFERENCES

Available upon request

Contact this candidate