Alan Simpson Email & Phone Number

300 Burnett St, Fort Worth Texas 76102

Dallas/Fort Worth Area

• SQL Server 2016 Environment using SSMS, SSRS, Visual Studio and Vault Change Management.
• Creation and Maintenance of Stored Procedures.
• Created a Master Data Management document describing the main in house Web based system for gathering and storing Market Research Data for Medical Insurers and Providers.
• Diagnosis and Analysis of Production Programs,.NET, ASPX, CSS, HTML, VB, Stored Procedures, Functions, Tables, Views.
• Coordinate multiple business units to define and maintain standard data, field and variable conventions.
• Information to be managed will be metadata, hierarchical and master data.

Dallas/Fort Worth Area

Contract to Hire with DSS Research, Fort Worth, Texas, see DSS.

Dallas/Fort Worth Area

• Production Support of JDE One World, JDE World, EDI interfaces and AS400 database. Using Remedy On Demand to document changes, manage Projects and Support Customer Service, Warehouse personnel and others in processing.
• Automated many previously manual processes that allowed the proactive cleansing of data and timesaving solutions where Orders were stuck. Resulted in Orders getting out on time, revenue being booked faster and.
• Analysis and fixing of complex problems including root cause analysis allowing the Business to serve the customers in a more efficient manner.
• Manage and train contractors in all aspects of Production Support allowing work to be spread among multiple employees.
• QA Testing of Changes, adherence to all Internal, GxP and SOX standards.
• Supported AS400 processes including SQL, CL and RPG.

Dallas/Fort Worth Area

Contract to hire with Alcon, Fort Worth, Texas, see Alcon

Orlando, Florida Area

• Develop Quality Solutions to internal customers using Gupta Centura OOP, Oracle, SQL, and PL/SQL. Meet with customers, create specs and design solutions, and assign to others as well as myself.
• Coordinate with the Offshore team
• Hands-on Coding on critical deliverables and Production support activities
• Practice all processes inherent to Agile/SCRUM development methodology
• Conduct Iteration Retrospective meetings and Product Demo to the Product Owners at the end of the Iteration.
• Code Review and System testing of offshore deliverables.

Dallas/Fort Worth Area

• Designed, coded, tested and Implemented Solutions to business problems for Insurance Company clients using Gupta Centura OOP, Oracle, SQL, and PL/SQL.
• Developed an IRS 1099 reporting system from many different platforms for many different clients. This created an efficient system which gathered data, printed 1099 forms, corrections were streamlined and 1099 data was.
• Worked with Clients to develop project specifications, estimates and progress reports for making software fixes and upgrading current products resulting in an efficient system for processing changes and enhancements.
• Provided support to clients by investigating in Policy and Claims Out of Balance issues. These issues were reported by the clients and system reports. Data was extracted and analyzed using SQL, Excel and Access.
• Responded to requests for reports using SQL, Excel and Access databases resulting in a quick turnaround and in some cases these requests resulted in new Production reports that created revenue for the company and.

Dallas/Fort Worth Area

• Responsible for running IBM Mainframe and AS400 Operations on a daily, weekly, and monthly schedule. Monitoring processes and servers. Reporting and participating in fixing abends.
• Setting up software to direct reports to the correct recipient.
• Interacting with on call developers and collaborating on fixes and reruns.
• Participation on testing and Processing jobs to convert from a Mainframe to an AS400 system.