Post Job Free
Sign in

Analyst Data

Location:
Allen, TX
Posted:
September 10, 2020

Contact this candidate

Resume:

Danny B. Evans

*** ***** ***** **.

Allen, Texas 75002-2314

Cell: 214-***-****

E-Mail: ***********@***.***

LANGUAGES:

RPG(FREE) SQL RPGILE COBOL

RPGIV RPGIII DBU SDA

DDS DFU Assembler Z80

C TAL SQLWindows PDM

OS400 DB2 Query SYNON

Certified:

Windows Windows NT Microsoft Office Suite

Gupta SQL Windows HIPAA

EXPERIENCE:

Yochana 10/2019 – 08/2020

Consultant

Worked on coding display programs for different record formats of a flat file. Programs were written using COBOL/400. Worked to program interface between a manual and automatic picking of inventory to be loaded on trucks to distribute to store locations. Also maintained existing programs to handle new automated picking software.

Infosys Limited 06/2017 – 06/2019

Consultant

Did analysis on ISeries to convert RPG programs, SQL, and Files into SQL Server. Provided information to aid team members in performing their tasks to complete projects assigned. Analyzed programs and provided input to enhance processing of orders coming from retail stores. Work with Order Processing Data Base to aid in processing of Work Orders.

J C 2 Technologies 12/2016 – 01/2017

Consultant

Programs were created to calculate added cost to products used in manufacturing other products on AS/400 using RPG(Free), RPG-ILE, SQL and DDS. The files were joined by a Select Statement or using multiple Select Statements to acquire the data needed for processing. Debugged legacy programs to correct existing code problems.

IQuasar 08/2015 – 04/2016

Consultant

Programs were modified to convert processing of one master file into 9 detail files on AS/400 using RPG(Free), RPG-ILE, SQL and DDS. The files were joined by a Select Statement or using multiple Select Statements to acquire the data needed for processing. Debugged legacy programs to correct existing code problems.

Internal Data Resources 10/2014 – 07/2015

Consultant

Programs were written to create reports for balancing accounts and for local stores. Programs were written to add fields and maintain files to hold part numbers, cross references and pricing. Programs were written to correct any error found in invoices and/or Purchase Orders. Programs were written to keep track of orders for stores to maintain inventory on AS/400 using RPG(Free), RPG-ILE, SQL and DDS. Code was written to support and maintain all existing systems that run the business.

NTA Life 03/2012 – 08/2014

Senior Programmer/Analyst

Programs were written to create reports for balancing accounts and for governmental reporting, actuarial validation. Programs were written to maintain files to hold account numbers used in reporting programs. Programs were written to change Policy Status and Bill Mode on AS/400 using RPG(Free), RPG-ILE, COBOL, SQL, DDS and Query. Programs were written to import data to Tracker Software to handle Escheated property to create letters and report to the states. Also Maintenance programs were written to populate and maintain files containing business rules. Code was written to support and maintain all existing systems that run the business.

Gainsco 08/2006 – 03/2012

Senior Programmer/Analyst

Programs were written to interface with the WEB to allow agents to Endorse and Reinstate policies on-line. Stored Procedures were also created to interface with the WEB. Be lead programmer in the coding of software to complete 9 digit Zip Codes and determine distance between two addresses on the AS/400 using RPG-ILE, COBOL, SQL, DDS and Query. Also Maintenance programs were written to populate and maintain files containing business rules. Code was written to support and maintain all existing systems that run the business.

Allied Solutions 01/2006 – 08/2006

Consultant

Work with DBA to finalize Technical Specifications. Play a vital role in designing new system for automated credit approval for corporate customers. Be lead programmer in the coding of the selection of Financial Programs for new system on the AS/400 using RPG-ILE, COBOL, SQL, DDS and Query. Also Maintenance programs were written to maintain files required to populate the appropriate financial programs, pricing and other information available to the customer.

Addison Staffing 05/2005 – 12/2005

Consultant

Programs were written and maintained for manufacturing and warehousing systems. Programs were written for Accounting, Sales, Shipping and International applications. Programs were written on an iSeries AS/400, DB2 using RPG-IV, RPG-ILE, CL, Query, DBU, DDS, DFU and SDA. I also worked as DBA creating files, validating and correcting existing data. This included the use of subfiles, windows and help screens. I worked on EDI applications, form 810.

Ajilon Consulting 07/2003 – 08/2003

Consultant

Wrote a Bonus System for a mortgage service company to track performance by loan service personnel to assure tasks were completed before awarding bonuses. Programs were written on an iSeries AS/400, DB2 using RPG-IV, RPG-ILE, CL, Query, DBU, DDS, DFU and SDA. This included the use of subfiles, windows and help screens.

Tek Systems 10/2002 – 04/2003

Consultant

To write and maintain programs that report prescription information to pharmacies and insurance providers. Programs were written on an iSeries AS/400, DB2 using RPG-IV, RPG-ILE, COBOL, CL, Query, DBU, DDS, DFU, SDA, SYNON and SQL. Aldon Change Management System was used. Data was used by pharmacies to obtain information such as number of refills, date limitations on refills, maximum number of doses, copay, etc. Providers used the information in data warehousing and for other reporting.

Transamerica Real Estate Tax Services 08/1999 – 03/2002

Sr. Programmer/Analyst

To write and maintain programs to report tax information from County, City and/or school district tax rolls. Programs were written on an AS/400, DB2 using RPG-IV, RPG-ILE, COBOL, CL, Query, DBU, DDS, DFU, SDA and limited SQL. Data was used for paying property taxes by TRETS, and for reporting property tax status to major mortgage firms. Wrote automated edit program to reduce number of verification runs.

Integration Services, Inc. 05/1998 – 07/1999

Consultant

To write and maintain programs and systems to produce reports, update files and On-line Screens for Warehouse Software system on an AS/400 using RPG-IV, RPG-ILE, Query, DBU, DDS, DFU, SDA and limited SQL. Responsibilities included administrative controls such as adding or changing peripherals, operating software and PTF’s. Work was done with other systems in Accounting, Purchase Orders, Warehouse Management and Inventory Control.

CompUSA 04/1997 - 04/1998

Programmer/Analyst

To write and maintain programs and systems to produce reports, update files and On-line screens for Electronic Data Interchange system on an AS/400 using RPG-IV, RPG-ILE, Query, DBU, DDS, DFU and SDA. Work was done with other groups as needed on Accounting, Purchase Orders, and Inventory systems.

Charter Group 01/1996 - 04/1997

Programmer/Analyst

To write and maintain programs and systems to produce reports, update files and On-line screens for Claims, Policy Services, Customer Service, Underwriting and Accounting on an AS/400 using COBOL, Query, DDS, DFU and SDA. Aldon Change Management System was used.

Nobel Insurance Group 12/1993 - 12/1995

Programmer/Analyst

To write and maintain programs and systems to produce reports and update files and On-line screens for Claims, Policy Services, Customer Service, Cash Operations, Underwriting, Actuarial and Accounting on an AS/400 using COBOL, Query, DDS, DFU, and SDA. Performed all aspects of operations, including monthly runs, adding/deleting profiles, system administration, PTF’s, etc. Also worked on conversion to Client Server Arena programming with GUPTA SQLWindows.

EDUCATION:

Baylor University Bachelor of Arts: Telecommunications

TCJC Associate of applied Science: Computer Science



Contact this candidate