IT Systems Analyst and Developer
Resume:
ALAN SIMPSON
Fort Worth, TX, *****
***********@*****.*** 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