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. • Create, implement and maintain master source to target documentation and use it to align data across multiple business units through direct coordination with those units. • Provide coordination for complex change requests, where necessary, to ensure that business processes are not disrupted by changes. • Includes the administration and support of the tools, forms and workflow systems that are employed in the coordination process. • Collaborate with and support internal business units which utilize ETL data mapping in relation to master documentation • Project management • Client data processing

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 Sales Orders, Accounting systems, EDI, Data Warehouse, and Order to Cash Billing. Used SQL extensively for research and updating data. Reports created using Showcase.• 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 customers being billed quicker.• 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.• QA and Release management support

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 e-filed to the IRS in an efficient manner. • 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 thus resulting in greater customer satisfaction and growth.• 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 including macros and VBA. The investigations led to software fixes, user education and increased client satisfaction. • 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 useful reports for the client.

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.