Sql Server Information Technology
Resume:
Patrick I. James
*********@*****.***
https://www.linkedin.com/in/patrick-james-7741581b/
SUMMARY
Exceptionally skilled at visualizing and creating solutions. Highly developed support capabilities. Excellent communications skills. Always take the opportunity to expand and apply new knowledge. Over 30 years of experience across all aspects of Information Technology with specialization in Microsoft technologies. My specialty is legacy application development, support and maintenance.
SKILLS
● Business Analysis ● Requirements Gathering ● Documentation ● Release Management
● Production Support ● MS SQL Server ● SSRS ● T-SQL
● IIS ● ASP.NET / MVC ● HTML5 / CSS ● VB 6
● C# ● VB.NET ● JQuery / Ajax ● Bootstrap
● JavaScript ● WinForms ● WebForms ● Telerik
● REST API ● XML / JSON ● PostMan ● Azure DevOps
● TFS ● GIT
EMPLOYMENT HISTORY
PRO*ACT, LLC, Lead Software Developer/Analyst April 2012 - January 2025
• Led end-to-end development and support of several enterprise applications including a Food Safety Management System, Procurement Contract Management System, and a Trouble Ticket System using C#, VB.NET, WebForms, MVC, jQuery, Ajax, Bootstrap, Telerik and Microsoft SQL Server.
• Integrated legacy systems with Acumatica ERP via REST APIs
• Maintained a VB6-based ERP handling EDI/XML/flat file orders through to invoicing.
• Built internal tools for encryption, account management, and reporting.
• Developed a data warehouse to support Tableau and Power BI dashboards
• Mentored junior developers and support staff on best practices.
MERCURY INSURANCE (CONTRACTUAL), Senior QA Analyst / Senior Developer January 2010 - April 2012
• Utilized SOA and Agile methodologies to design and execute custom test scripts for VIN services, address standardization, and insurance rating scenarios.
• Developed simulators for service endpoints and optimized existing testing procedures through automation and performance enhancements.
• Served as a Sr. Developer to deliver two key releases aligned with regulatory and competitive market changes in Illinois and Georgia.
• Performed manual testing for internal applications in support of the Oklahoma office.
ATB SERVICES, Application Development Manager November 2007 - June 2009
• Led the development of new Microsoft Access systems for client onboarding.
• Consolidated 19 Access databases into a unified web-based front end with a SQL Server backend integrated with QuickBooks data.
• Automated late fee invoicing and new customer processes, generating approximately $1.3 million in revenue in the first year.
• Handled data reconciliation and delivered weekly reports to business stakeholders.
MERCURY INSURANCE, Senior Programmer/Analyst (Contractual) October 2006 - October 2007
• Developed long-term solutions for internal legacy applications using VB6, XML, Java, SQL Server 2000/2005, ClearCase, and InstallShield.
• Produced design specs, unit test documentation, and ensured SOX compliance in collaboration with Business Analysts.
• Provided technical support to internal staff and RCM team members.
• Led the upgrade of Mercury's agent-facing software delivery system from InstallShield 6.3 to 10.5, supporting both CD and web-based installs.
KBHOME, Programmer/Analyst / Quality Control / Release Engineer September 2003 - July 2006
• Managed Change Control, Build, and Release processes for in-house applications using Visual SourceSafe, VB6, VB.NET,ASP.NET, and SQL Server.
• Created deployment packages with Wise Installation tools
• Maintained a multi-platform test lab for application QA and regression testing.
• Provided production support and backup for the Data Warehouse environment using SQL Server and Cognos.
• Played a key role in data migration efforts and led the coordination of a major Cognos upgrade.
• Handled daily team status reporting and maintained project timelines in Microsoft Project.
INDYMAC BANK, Software Developer February 2002 - March 2003
• Designed and developed internal enterprise applications using Visual Basic 6, SQL 7, ADO, XML, Interdev 6, HTML, JavaScript, and VBScript.
• Created a robust email daemon for automated, data-driven messaging with WMI API support.
• Built a wire reservation system that generated and distributed spreadsheets via email and secure FTP, running on a scheduled server.
• Contributed to the Loan Explorer application by developing user interfaces for wire request management and configuration control.
• Built a file-based interface for transferring loan data to a mortgage servicing company via FTP.
CITIBANK DEVELOPMENT CENTER, Lead Programmer (Contractual) September 1999 - December 2001
• Contributed to the redevelopment of a Citibank web-based Credit Card Information Management system using VB6, SQL Server, COM/DCOM, XML, and Visual InterDev.
• Developed site maintenance tools and an email daemon leveraging Entrust cryptography for single sign-on via encrypted cookies using Triple DES.
• Handled QA coordination and managed NT Enterprise servers including IIS, Exchange, SQL Server, and SourceSafe.
• Supported production rollouts with on-site assistance at the Denver data center.
TWENTIETH CENTURY FOX FILM CORPORATION, Lead Programmer (Contractual) October 1998 to July 1999
• Designed and implemented a SQL Server 6.5 back-end to support customized Crystal Reports using stored procedures.
• Developed a 2-tier Visual Basic 6.0 front-end application with user-specific report access, hierarchical drilldown menus, and maintenance tools for managing reports and categories.
• Created custom reports and built a separate reporting database with nightly batch SQL processing to generate daily historical activity reports without impacting live system performance.
NESTLÉ FOOD COMPANY, Lead Programmer/Analyst (Contractual) January 1995 to October 1998
• Led the design and development of a unified SQL Server 6.5 database to consolidate product, pricing, and promotion data across three Nestlé operating companies.
• Built a secure 2-tier Visual Basic 3.0 application enabling Account Managers to manage and transmit deal data via EDI
(formats 879, 888, 889).
• Developed QA test scripts and served as liaison between users and QA/network teams.
• Created data integration tools using VB, Excel, and OLE/SQL, and led data reconciliation efforts for a major platform migration (MVS to HP-UX Sybase).
• Developed a C-based budgeting system to replace a legacy mainframe application.
• Supported team members with debugging, design, and reporting.
COUNTRYWIDE FUNDING, Programmer/Analyst September 1992 - December 1994
• Led the design and implementation of automated systems and reporting tools using Visual Basic, SQL Server, Microsoft Access, and Crystal Reports.
• Provided advanced (Level 4) technical support, network application administration, and remote OS version control.
• Developed tools and scripts for data retrieval and system upgrades.
• Conducted beta testing of new technologies and maintained Lotus Notes databases for network planning.
• Previously served as a User Support Analyst, delivering Level 2 software/hardware support across multiple platforms and locations.
Contact this candidate