SUMMARY

• He is a seasoned Application Developer and Database Administrator with over 10 years of experience consulting in various areas of business.
• This experience includes an in - depth knowledge of web application development tools and many database technologies, as well as an assortment of front-end web development and Systems Development Life Cycle (SDLC) implementations.
• During his tenure, Confidential has supported a wide variety of both technical and functional roles.
• These roles have included a multitude of programmatic components, information quality assurance reviews, reports, and the life cycle implementation of electronic management support tools (with specific focus on web development/database tools such as .NET and Microsoft SQL Server), and large data integrations / migrations between multiple system platforms.
• Having spent the past ~10 years within service-based and State sectors, it’s given him a broad perspective of an organization’s needs and capabilities in pursuance of high-quality, secure systems and deliverables.
• As an IT Contractor and Consultant, Confidential has a proven competence in identifying, planning, analyzing, designing and implementing approved recommendations tailored to specific, many times complex workflow processes. This in turn has helped create more efficient automated systems and helped boost his clients’ application performance and rapport with those customers.
• Confidential has a talent for researching and configuring new information technologies to improve efficiencies within the client’s current environment, as well as identifying improvement processes through the use of automation.
• As a trained Database Professional and responsive Web Developer, Confidential possesses strong development skills covering a wide range of programming languages and database technologies (Oracle, PL/SQL, MySQL, MS SQL Server, SSRS, SSIS). He is highly experienced with developing and administering databases of many types, sizes and architectures, while conducting validity, feasibility and performance checks to ensure quality and stability.
• Among the variety of other roles played, he has also had the opportunity to gather user requirements, perform strategic requirements analysis and project management functions, and conduct front-end/back-end development from all stages of the SDLC.

PROFESSIONAL EXPERIENCE

Confidential - Harrisburg, PA

IT Specialist & Consultant

Responsibilities:

• Updated aging ASP web applications to ASP.net and performed new development tasks
• Troubleshooted and fixed broken database links between front - end ASP.net application and SQL Server back-ends
• Developed new simplified database structures and worked on MS SQL Server DB maintenance tasks
• Migrated massive amounts of SQL Server data into more recent version
• Installed routers and performed network cable management for nursing home facilities and ensured applications were in working order
• Provided experience in database administration along with backup/recovery and expanded knowledge about database connectivity (ODBC etc.) and table creation/modification
• Performed database management and setup with respect to imports/exports, storage, efficiency optimizations, constraints, table-space, ER diagrams, variables, referential integrity, key setup, etc.
• Performed disaster recovery and server configuration tasks working with Dell PowerEdge & HP servers (set up both web and file servers as well)
• Provided Active Directory maintenance and set up user security, accounts, MS Exchange profiles, etc. and performed password resets & user setup/removal
• Windows Server 2000, 2003, and 2008 administration tasks and Remote Desktop
• Maintained printers as well as VOIP phone system and connected switches to Confidential Business Class high-speed connection, controlled wiring of racks for new/old servers
• Assembled/tore down workstations for business use and tested individual hardware components to assess future capabilities and functionality
• Performed data reporting functions from MySQL and SQL Server databases
• Migrated entire Microsoft Exchange email server into Gmail and set up access for all company users as well as cloud storage
• Created VBScripts for company-specific task automation related to pulling SQL Server data and reporting
• Deployed large-scale software enhancements including mass upgrades of OS's, Internet browsers, Symantec Endpoint Protection, and other software as determined needed by PM and organization
• Troubleshot user issues after deployments and entered/logged issues into a ticketing system for eventual resolution based on escalation levels and provided customer support

Confidential - Mechanicsburg, PA

Database Administrator

Responsibilities:

• Responsible for installing, monitoring performance and auditing databases
• Developed database strategies and back up procedures
• Worked directly with users of data and system developers
• Enhanced data accessibility techniques and employed technologies such as DB replication, mirroring, etc.
• Worked directly with client projects to migrate a wealth of legacy data (e.g. SQL 2000) to SQL 2012
• Migrated SSRS 2005 systems into SSRS 2012 and maintained SSRS 2012 systems
• Coded custom tool to monitor backup status of 1000s of servers and monitor performance
• Created Maintenance Plans & Indexes as well as scheduled jobs to handle server tasking
• Installations and upgrades of SQL server coupled with patches, etc.
• Largely focused on Remote Server Management
• Responded to troubleshooting calls dealing with network as well as DB access security
• Created associated documentation with all newly installed patches, processes, scripts applied, etc.
• Deployed scripts and stored procedures when required by developers as well as schema changes, job changes, etc.
• Was versatile in researching SQL server issues as they arose and finding workarounds when necessary in order to save money for clients in areas of SQL licensing, etc.

Confidential - Harrisburg, PA

.NET/C# Applications Developer

Responsibilities:

• Responsible for administration, entry, and analysis of data utilized by the client
• Modified existing interfaces and/or created new interfaces as necessary to improve data quality and to facilitate data entry to address a significant back-log from both electronic and hard-copy sources
• Worked hand-in-hand with database administrators at the client as well as subject matter experts and geologists
• Analyzed existing interfaces for data and suggest/remedy improvements as necessary
• Identified sources of data that are not yet in systems being developed and devised methods for importation or data entry
• Modified and/or created interfaces or processes as needed to improve data entry for new/existing systems from identified sources
• Documented new interfaces and processes created as part of new requisitions
• Trained Commonwealth of PA staff from the Bureaus of Information Technology and the Bureau of Topographic and Geological Services in the use of any interfaces produced as part of current projects
• Utilization, design, and management of Microsoft SQL Server 2000, 2005, and 2008 R2, Microsoft .NET development (C# syntax) and SSRS/Crystal Reports development
• Employed MVC Application Architecture Model and jQuery in Web Application development

Confidential - Carlisle, PA

.NET/C# Applications Developer

Responsibilities:

• Performed all tasks necessary to completing customized C# solutions based upon an extensive knowledge of the financial/college loan business and computing environment
• Involved in Full Life Cycle Development - Analysis, Design, Architecture, Development, Testing, Implementation, Support, and other duties necessary to deploy business critical systems
• Worked in an Agile/Evolutionary environment
• Interacted and integrated with customized Web Services for consumption of data
• Worked both individually and as part of a team including business representatives, technical staff and senior management
• Assisted business stake holders and the Project Management Office to develop requirements, design and testing
• Worked within production control guidelines production application changes
• Offered suggestions and ideas regarding development practices, application design and solution development and performed tasks such as data modeling, creation of ERDs, etc.
• Obtained and maintained a working knowledge of operating systems and hardware used by the development groups, and systemic relationships with outside service providers and designers
• Documented components in accordance with development standards and procedures
• Development utilized C#, .NET, ASP, ASP.NET, Web Services, and/or XML on a daily basis
• Work typically involved strong emphasis on relational database concepts including SQL Server using stored procedures
• Utilized n-tier development practices
• Worked in a solution-oriented atmosphere and possessed a strong ability in providing solutions to new projects and ongoing operations

Confidential - Harrisburg, PA

.NET/C# Applications Developer and Systems Analyst

Responsibilities:

• Performed Project Management tasks while developing new healthcare web applications and saw projects through the Software Development Life Cycle
• Became familiarized with Agile/Scrum methodology for Project Management and implemented in all IT projects
• Developed workflows and web applications utilizing VB.net/ASP.net and C# in Visual Studio 2010
• Worked with developing and maintaining SQL Server 2008 and 2010 database back-ends for creating applications and interacted with Toad for SQL Server heavily
• Utilized AJAX toolkit to enhance web application functionality and appearance
• Worked with SSRS and Telerik package to enhance reporting capabilities within the organization
• Became familiarized with 508 compliance and U.S. Government security standards such as OWASP in developing web applications
• Learned and adhered to Federal regulations for handling Protected Health Information and created secure, effective, and efficient information systems to house that data
• Became familiarized with and implemented security measures in ASP.net code to protect against SQL injection and cross-site scripting attacks