ALAN SIMPSON

Fort Worth, TX, *****

817-***-****

acyrr2@r.postjobfree.com www.linkedin.com/in/asimpson111

SUMMARY

Accomplished IT Professional with extensive experience working in collaboration with global, cross-functional teams to develop and implement streamlining strategies for a Fortune 500 Enterprise. Proven ability to provide leadership in planning, scheduling, management and definition of scope for large IT projects. Innovative and self-starting professional who is a proven problem solver able to take complex problems and break into smaller tasks and effectively delegate responsibility. Advanced AS400 and expert level SQL in many different environments. Additional expertise includes:

JDE One World

DB2, Oracle, SQL Server

COBOL/CICS

AS400

SQL, PL/SQL

Project Management

Applications Development

Creating Reports

Data Analysis

PROFESSIONAL EXPERIENCE

NOVARTIS/ALCON, Fort Worth, TX 2010-2016

Global Pharmaceutical Company

Systems and Production Support Analyst

Production Support of JDE One World, JDE World, EDI interfaces and AS400 database.

Managed projects supporting Customer Service, warehouse personnel and others in processing Sales Orders, accounting systems, EDI, Data Warehouse and ‘Order to Cash’ Billing using Remedy On Demand to document changes.

Used SQL extensively for research and updating data and created reports 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.

Analyzed and remediated complex problems including root cause analysis allowing the Business to serve the customers in a more efficient manner.

Managed and trained contractors in all aspects of Production Support allowing work to be spread among multiple employees.

Ensured QA Testing of Changes, adherence to all Internal, GxP and SOX standards.

CURASCRIPT (Owned by EXPRESS SCRIPTS INC), Orlando, FL 2009-2009

Mail Order Pharmacy

Contract Developer

Developed quality solutions for internal customers using Gupta Centura OOP, Oracle, SQL, and PL/SQL.

Met with customers, created specs and design solutions, and delegated projects to appropriate staff.

Collaborated with the Offshore teams.

Conducted Hands-on Coding on critical deliverables and Production support activities.

Practiced all processes inherent to Agile/SCRUM development methodology.

Conducted Iteration Retrospective meetings and Product Demo to the Product Owners at the end of the Iteration.

Coded Review and System testing of offshore deliverables.

Ensured QA and Release management support.

ALAN SIMPSON

Page 2

CGI, Fort Worth, TX 1996-2008

Property and Casualty Insurance Software

Programmer/Analyst

Designed, coded, tested and Implemented Solutions to business problems for Insurance Company clients using Gupta CENTURA (SQL windows) OOP, Oracle, SQL, PL/SQL, AS400, COBOL, CL, VSAM, JCL and CICS

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.

Collaborated 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.

Inspire Insurance Solutions (Later CGI), Fort Worth, TX 1991-1996

Property and Casualty Insurance Software

Lead Computer Operator

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.

EDUCATION/TRAINING

Scottish National Certificate and Scottish Higher National Diploma in Computer Data Processing

Falkirk College of Technology, Falkirk, Scotland

COBOL I, COBOL II, CICS, C, Advanced C, C++, C#, VB, Advanced VB, JAVA, Database Programming

Tarrant County College, Fort Worth, TX

PROFESSIONAL DEVELOPMENT

IBM AS400 Advanced Operations Certified

Contact this candidate