Hummelstown, PA *****
******.******@*****.***
PROFESSIONAL SUMMARY
Career minded operationally aware technical professional possessing strong leadership abilities and solid fundamentals honed over a variety of career experiences. Goal oriented, focused on improving and understanding the implementation of technology as it relates to operations and objectives within business units. An already proven jack of all trades / go to person with the ability to take on tasks outside the normal scope of responsibilities and has the ability to come up to speed quickly to ensure operational and business success. This professional brings almost twenty years of computer and networking experience and a team-based management style with excellent communication and interpersonal skills. 15+ years SQL Development / Architecture
14+ years C# / VB .NET Development ASP / CORE
15+ years Visual Studio / SSMS Enterprise
10+ years Full Stack / SDLC Development
Agile / Waterfall
Problem Solving / Troubleshooting
Leadership / Management
US Citizen
WORK EXPERIENCE
Cleveland Cliffs Senior Software Engineer 01/2015 – Present Primarily tasked to support production. Analyzing and solving operational problems related to projects, including identifying root causes of issues and providing solutions. Another responsibility is to maintain various technologies, both old and new, pertaining to plant operation. Developing and maintaining custom Level 2 applications directly impacting quality and efficiency. Documentation and enforcement of Standard Operating Procedure (SOP)
Visual Basic / C# / ASP .NET Framework
SQL – Queries, Views, Stored Procedures,
Security, Login, Performance, Triggers,
Dependencies
SQL Server Reporting Services (SSRS)
Microsoft Azure / JSON
PLC ControlLogix Programming
RS Linx, Advanced HMI
Microsoft Message Queuing (MSMQ)
Remote Services
IT systems administration
SDLC Process
Administrative Office of PA Courts Programming Analyst 02/2013 – 12/2014 Supplied various reports for Common Pleas Courts staff. Clients use the .NET application to access the reports. Responsibilities included anything from Statistical Data to Accounting to Court Letters. Tasks included writing stored procedures and custom applications. Provide internal customer service to various departments, must be able to translate technical information to non-technical audiences
Optimize and improve reports when
necessary
Embarcadero Rapid SQL
T-SQL
SAP Crystal Reports XI
Team Foundation Server (TFS); SharePoint
Visual Studio 2013 for Visual Basic .NET
PA Legislative Data Processing Center Computer Programmer 07/2012 – 01/2013 2
Responsible for the creation and maintenance of SAP Crystal Reports, scheduling and distribution. Maintains and ensures data transition from OpenVMS host to Microsoft SQL Server and creation/modification of user defined functions, views and tables as needed. Design and implement cost-effective, high-quality web applications to meet/exceed client needs in Cold Fusion. Works with the rest of the Information Systems department to ensure efficient operations of the organization.
Compile data, create reports and present information utilizing expertise with SAP Crystal Reports, SQL Query, MS Excel and MS Access
Generate and collect simple reports and complex data extractions including multiple tables and ODBC connections
Interface with customers to obtain a full understanding of the project requirements to recommend the appropriate technology to accomplish requirements (Cold Fusion)
Monitor application efficiencies to identify means of enhancing performance
Ability to be self-directed, able to focus on personal assignments while remaining part of a larger team with proven ability to multi-task
Rite Aid Corporation .NET Developer 01/2012 – 07/2012 Design, modify, develop, write and implement software programming applications and components. Support and/or install software applications and components. Work from written specifications and pre-established guidelines to perform the functions of the job and maintain documentation of process flow. Main objective was to update Phone System with new SQL Database structure and build a release.
Utilize established development tools, guidelines and conventions including but not limited to: Visual Studio, ASP.NET, SQL Server, and C#/VB.NET
Design, code and test new Windows applications
Enhance existing systems by analyzing business objectives, preparing an action plan and identifying areas for modification and improvement
Maintain existing software systems by identifying and correcting software defects
Create new and extend existing operational documentation
Consult closely with management and occasionally agency staff related to projects and tasks
Consult colleagues concerning maintenance and performance of software systems Holy Spirit Health System Network Specialist 07/2011 – 01/2012 Automated critical tasks that required hours of manpower. Created WMI application that scans all servers on network and generates detailed specifications document. Redesigned Server Inventory application to be faster, simpler and user-friendly. SQL and VB Scripting. Automated spreadsheets to update active/inactive users with the click of a button. Also Print Server migration from MS Server 2003 x86 to MS Server 2008 x64.
SDLC, Microsoft Visual Studio .NET 2008, SQL Server Enterprise 2008, Crystal Reports, C++, ASP.NET, XML, Web Services, SQL, Stored Procedures, Functions, Microsoft EXCEL, Troubleshooting
Gather data to identify customers’ needs then use the information to identify, interpret and evaluate system and network requirement
Software design and development in Microsoft SQL Server 2008 database environments with Microsoft Visual Studio .NET including C++, ASP.NET, and XML web services
Strong understanding of .NET Framework
Write queries within Microsoft SQL Server
Experienced in providing production system support and solving daily production issues
Strong analytical, troubleshooting
Evaluate efficiency of system and work to improve production and workflow
Provide technical advice as required for system planning 3
TransCore Systems Administrator/Engineer 01/2011 – 06/2011 Strengthened much needed relationship between clients and Department of Information Technology. Responsible for documenting all IT processes and upkeep of Server/Workstation Security. Developed program to strengthen integrity and record keeping. I worked on designing Help Desk Software.
Software design and development with the use of Microsoft Visual Studio .NET 2008, Microsoft SQL Server Enterprise 2008
Expertise with full software development life cycle including software system analysis, functional design, technical design, development, testing, code review and production system support
Integration of Crystal Reports with Visual Studio .NET
Expertise with grouping, sub-grouping, formatting, conditional formatting, and creating complex formulas
Test report output; export report output to Microsoft Excel format
Knowledgeable of software design and development in Microsoft SQL Server 2008 database environment
Knowledgeable of data analysis and data design
Knowledgeable of performance tuning database stored procedures and functions
Perform regular maintenance and upkeep documents
Develop and maintain installation and configuration procedures
Debug using MS Visual Studio 2010, MS Visual SourceSafe, Business Objects Crystal Reports
Languages: .NET, XML and Visual Basic
Maintain proper communication between IT and other departments
Worked on improving department image and social evaluation
Troubleshoot/Test Windows 7, Website, Multiple in-house software Essintial Enterprise Solutions Training Coordinator/Escalations Agent 05/2010 – 01/2011 The primary responsibility is to raise the technical expertise of our agent staff and contribute to overall customer satisfaction by providing timely technical and professional mentoring in a leveraged manner. Assist in resolving cases that exceed agents’ capabilities either in technical skill set, urgency, complexity or time to service. Partnered with the Team Manager to improve technical and soft skill performance of the team, to meet customer satisfaction initiatives and to meet Case Wellness goals.
Evaluate cases and partner with agents to validate proper technical action plans
Manage escalation processes and adherence by assigned team
Manage escalated tickets and proper consult line usage
Ensure all scheduled callbacks are met
Promote greater customer satisfaction for the team/unit
Assist with special projects and other duties as assigned PA Department of Transportation Lead Systems Analyst 05/2006 – 04/2009 Responsible for management and upkeep of systems statewide while providing complete client satisfaction. The client base included everyone from a regular end user to the Secretary of Department of Transportation. Support includes planning, scheduling, operation, optimization, security administration, maintenance, network management, network monitoring and administration. Manage four Systems Analysts and ensure that their duties are performed in accordance with the applicable Performance Work Statement guidelines. Primary responsibility – oversight of team members.
Network services support
Third party and internal application support
Use of Customer Relationship Management (CRM) to ensure quality of client service 4
Operations, planning, and management support
Systems Management Server (SMS); Active Directory; Internet Information Services (IIS)
IT systems administration
Administrative support
Training support
Scripting with C++, Visual Basic and Batch Files
I was involved in numerous projects. For instance, Hardware Refresh, Central Office Developer move, PEMA move, Material Testing Lab move, custom images, CWOPA migration, etc
Working with Central Office and District IT Staff in various issues that arise with upgrades/changes; Service Calls; Host-On-Demand; IBM Rational; Off Hour Support; Network Setup; others as needed
Experience in multiple OS platforms; Windows XP/Vista, Server 2003/2008, Linux RedHat, Unix
Build/image workstations/servers with the help of VMWare
Create Symantec Ghost Image standards
Test software compatibility with VMWare to improve productivity and efficiency
Retrieve back-ups from IBM Tivoli Server
Support PEMA workstations during urgent situations
Manage Dell ImageDirect
Pennsylvania Credit Union Association Technical Consultant 08/2008 – 02/2009 Responsible for implementing, enhancing and integrating a finance database. Consultants are usually performing their duties at the customer’s site. In-depth knowledge of Business Processes and technologies such as Microsoft SQL Server, the SQL language and Visual Basic development. Operated under general supervision on mid-size projects usually involving single products or single platforms
Full understanding of SDLC (Software Development Life Cycle) standard processes and industry best practices
Help configure client’s applications and databases
Perform business analyst services in developing functional and technical requirements and reporting requirements
Strong documentation skills
Define, develop and test application
Resolve bugs/issues at customer’s site
Develop and use quality assurance procedures to assure high quality software
Determine database configuration needs and requirements
Guide and train new clients in setting up NT Server and SQL Server
Assist new clients in developing and implementing maintenance and administrative procedures, including robust backup routines
EDUCATIONAL BACKGROUND
Pennsylvania State University Bachelors in Computer Science 05/2008 REFERENCES - Cleveland Cliffs Steelton
Bill Carlisle General Manager 717-***-****
John Suda Process Automation Engineer 570-***-**** Bill Wallenmeyer Senior IT Analyst 717-***-****
Mike Brooks Senior Network Engineer 717-***-**** Roy Moyer Senior Area Manager Operations 717-***-****