James Hatton Email & Phone Number

Cincinnati, Oh

▪ Developed and maintained an interface with the DST Fan Mail system to share annuity financial advisor account and transaction information with DST FAN Mail subscribers. This solution has an ASP.NET MVC Web application that uses EF integrations to communicate with back-end SQL Server databases and EXL LifePRO policy management systems. (ASP.NET MVC, JavaScript, EF, SQL Server)▪ Developed and maintained an interface with the DTCC I&RS system to share annuity and agent financial information with DTCC subscribers. This solution has an ASP.NET MVC Web application that uses EF integrations to communicate with back-end SQL Server databases and EXL LifePRO policy management systems. (ASP.NET MVC, JavaScript, EF, SSIS, SQL Server)▪ Developed and maintained several ASP.NET- or JavaScript-based solutions that manage agent and policy information for annuities. These solutions have Web-based user interfaces that use WCF or EF integrations to communicate with several back-end SQL Server databases, which in turn are integrated with several EXL LifePRO policy management systems. (ASP.NET MVC, JavaScript, EF, WCF, SQL Server)▪ Developed and maintained an enterprise solution to assess an annuity applicant’s suitability to purchase an annuity. This solution delivers a FireLight e-Application to a TIBCO ActiveMatrix BusinessWorks service that extracts, transforms, and distributes the e-Application’s information to a SQL Server database and other enterprise systems. A knowledge worker then determines the applicant’s suitability by interacting with the database via an ASP.NET MVC Web application. (ASP.NET MVC, JavaScript, EF, SSIS, SQL Server)▪ Developed miscellaneous maintenance enhancements to various enterprise solutions. (ASP.NET MVC, JavaScript, EF, WCF, TIBCO, SSIS, Service Broker, SQL Server)▪ Participated in a working, effective, Scrum-based solution development environment, utilizing Jira for backlog item management and TFS for source code control. (Scrum, Jira, TFS)

Cincinnati, Oh

▪ Developed SQL Server application enhancements to submit borrower accounts to a major credit reporting company to acquire the borrower’s credit status. (SQL Server, SSIS, SSRS, ASP.NET)▪ Developed C# application enhancements to convert PDF, DOC, and TIFF images in preparation for DIP upload to OnBase. (C#, XML, Snowbatch)▪ Developed C# and SQL Server application enhancements to submit and report telephone number scrubs to a major phone number lookup company. (C#, SQL Server, WPF, Windows Services)▪ Developed an ad hoc C# and SQL Server application to process purchased accounts data for import to Resurgent systems. (C#, SQL Server, Regex)▪ Developed miscellaneous enhancements to various WPF-based applications. (WPF, C#)▪ Participated in a working, effective, Scrum-based development environment, utilizing TFS for backlog item management and source code control. (Scrum, TFS)

Cincinnati, Ohio Area

▪ Participated in the design, development, and deployment of a .NET web application used to manage a claims processing workflow. (ASP.NET, IIS 6, IIS 7)▪ Developed a WCF Web service that linked a .NET application to a legacy DATABUS claims processing system. This included developing a TCP/IP client-server link in .NET and DATABUS.▪ Developed a SharePoint 2007 pilot to demonstrate its enterprise system capabilities to upper management. This involved developing a virtual enterprise system using virtual machines, with multiple servers, desktops, and users (SharePoint 2007, SQL Server 2005, Active Directory, Windows 2003 SBS, VMWare Workstation)▪ Maintained and extended an ETL system to import pharmacy claims from PBMs. This is a Python- SQL Server-based hybrid system, which used both technologies extensively. (Python, SQL Server, NCPDP D.0)▪ Managed source code repository using TortoiseSVN.▪ Developed ITIL-based change management process for upper management.

Cincinnati, Oh

▪ Participated in the design, development, and deployment of an enterprise PLM system based on Teamcenter Enterprise and related technologies. It was used for managing FDA documents, SOPs, and engineering drawings. (C/C++, J2EE, JavaScript, XML, Oracle, Korn shell, C shell)▪ Participated in the design, development, and deployment of the webMethods integration aspects of an enterprise ERP system based on JD Edwards EnterpriseOne that integrated more than 15 systems worldwide. (Java, XML, webMethods, Oracle, BPM)▪ Designed, developed, and deployed a requirements management system based on Teamcenter Requirements (SLATE) to manage requirements for an enterprise ERP system. (Tcl, Visual Basic (VBA, Excel, Word), Versant)▪ Designed, developed, and deployed a Microsoft Access database to manage systems information for enterprise architecture activities. (Access, VBA, Windows Forms)▪ Developed and deployed an enterprise architecture strategy and framework comprising business systems and business processes for principal global business units. (Access, Excel, ProVision, BPM)▪ Authored all levels of design documents for several enterprise IT systems.▪ Designed, developed, and executed unit and system test cases for several enterprise IT systems.

Cincinnati, Ohio Area

▪ Participated in the design, development, and deployment of two enterprise PLM systems for a leading medical device manufacturer: product configuration, drawing control. Major contributions were: advanced Metaphase software configuration and customization, software engineering expertise, PLM expertise, subject matter expert for Metaphase. (C/C++, J2EE, JavaScript, XML, Oracle, Korn shell, C shell)▪ Designed, developed, and deployed a Metaphase PLM system for a major U.S. aircraft engine manufacturer. Provided global access to instance based provisioning information for customer-model-specific aircraft engine configurations. Major contributions were: business process analysis and reengineering, requirements analysis, principal solution analysis and design, advanced Metaphase software configuration and customization, software engineering expertise, subject matter expert for Metaphase. (C/C++, Oracle, Korn shell, C shell, MQSeries, XML)

Cincinnati, Ohio Area

▪ Designed and developed a Metaphase PLM system to manage engineering analysis data for a major U.S. automobile tire manufacturer. Provided global vault management of engineering analysis data and generic interfaces to existing databases. (C/C++, Oracle, UNIX scripts)▪ Designed and developed a Metaphase PLM system to manage design configurations for a major Japanese automobile manufacturer. Linked globally separated MCAD work groups with a single vault management system. (C/C++, Oracle, Korn shell, C shell)

Cincinnati, Ohio Area

▪ Designed and developed a Metaphase PLM system for a major U. S. shipbuilding enterprise. Provided shipyard access to ship designs via shop floor workstations. Interfaced a print shop scanning operation to incorporate legacy drawings into enterprise wide Metaphase PLM vaults. (C/C++, Visual Basic, Oracle, Korn shell, C shell, Windows BAT)

▪ Designed and developed a commercial UI to interface SDRC’s Metaphase and I-DEAS software products. Satisfied a fundamental requirement for signing of a $200M contract with a major U.S. automobile manufacturer.▪ Designed and developed a commercial UI to manage the sharing of I-DEAS solid models between I-DEAS installations. This enabled engineers to reuse solid models developed at I-DEAS installations.▪ Designed and developed I-DEAS Update in Library software feature. Enabled update of solid models in a part library. This reduced update time by 90%.▪ C/C++, FORTRAN, Korn shell, C shell, VAX/VMS scripts, Apollo, AIX, MVS, CMS, DEC/VAX, Motif.

Cincinnati, Ohio Area

▪ Designed and developed I-DEAS Distributed Application facility for solid model part libraries. Enabled storage of assemblies and drawings in libraries.▪ Implemented I-DEAS part library. Enabled the storage of solid model parts in a library.▪ Implemented I-DEAS Design Programmer’s Interface. Provided a mechanism for customization of I-DEAS solid modeling processes by customers.▪ Principal support for source code control and configuration.▪ Designed and implemented software development automation tools.▪ C/C++, FORTRAN, Korn shell, C shell, VAX/VMS scripts, Apollo, AIX, MVS, CMS, DEC/VAX, Motif.