Patrick Shaw Email & Phone Number

Mechanicsburg, Pa, Us

Bonita Springs, Fl, Us

Bonita Springs, Fl, Us

Bonita Springs, Fl, Us

Migrating data form legacy system into Oracle database by using the K2View application which allows to manipulate data into a virtual database for staging before migrating into database.• Applying physical migration changes upon business decisions and request. Changes is a combination a sql base and php scripting.• Full cycle end to end testing.• Daily project backup for disaster recovery• Documentation of migration executions hand book, reconciliation development execution, and running data export reports.• Daily migration status meetings.• Leading my team to development reconciliation migration and reporting.• Allocating duties and responsibilities.• Reviewed all changes with team members to deliver 100% bug free project.• Making daily changes to Sapien’s Mediawiki internal pages.

Leading 2 teams to develop and deliver a phone application to allow users to scan products with the ability to check out without waiting in lines. • Weekly project and technical meetings• Creating project plan and project timeline chart• Architect and design flow of data and application• Gathering and creating documentation of project• Creating both low and high level flow charts with technical specifications • Backend development (creating API’s and stored procedures)• Complete development of back office and support applications for future support team• Application, Web, and Database Server administrator using AWS.

Development in the following languages Java, Java J2EE, SQL, ASP, Java Script, Windows Script, HTML, CSS, JavaScript, Vb script, Visio, XML for Point Of Sales.• Managing an old Clienteling system with 24hr on call support.• Design and development for reporting on 2 separate systems to track associate errors, improper SKU's used, open/pending items, and inventory.• Documentation with troubleshot page for fixes.• Production fixes• Writing technical documentation to support programmatical work; use Microsoft Visio to create high and low level flow charts.• Redesign purges process for Relationship Marketing and Clienteling. This will allow to go after a bigger audience and speed up the processing times.• Automate manual processes

Hanover, Md, Us

Convert and migrate data from I5 AS400 to SQL Server 2008 R2 in Java.• Created multi-threaded API calls to convert data from AS400 to SQL Server via JDBC. • Created error handler routines to manage data migration exceptions programmatically.• Established proprietary XML templates to handle data migration.• Used Microsoft Visual Studio Reporting Service to validate data from AS400 to SQL Server.• Write technical documentation to support programmatical work; use Microsoft Visio to create high and low level flow charts.• Used Sql Server Scripting for Stored Procedure; Bulk insert from CSV file; create and drop temp tables; delete, update, and insert records; Executed by a Java process.• Front end development for customized applications (internal use only) for data transfer from AS400 to SQL Server and also SQL to AS400 in Java.

Migrated peripheral controls from AMX’s NetLinx programming language to Java; wrote supporting documentation; conducted troubleshooting, including escalation, resolution and closure of trouble tickets as required.• Used Java to create user side virtual control functions for remotely operating in-room devices for Telepresence and video conferencing calls within a proprietary, closed environment.• Researched and developed similar functionality to the above bullet, but leveraged delivery of the application within a browser using JSP, Jetty, and HTML.• Performed unit-level testing as part of the software development process to deliver quality code in a timely manner.• Created supporting documentation and manuals for users and administrators, as needed.• Unit and client server side testing.

Certificate - 10774 Querying Microsoft Sql Server 2012, Querying Microsoft Sql Server 2012

Associates, Computer Science