Resume of Senior IT Developer

Title
Senior IT Developer

Primary Skills
Significant experience with COBOL/DB2 and SQL development

Location
US-GA-Atlanta

Posted
Oct-26-07

Technical Summary

Programming Languages Server Applications Legacy Applications
COBOL (14 Yrs) Microsoft Visual Studio 2005 ( 1 Yr) DB2 (14 Yrs) QMF(14 Yrs)
SQL (14 Yrs ) Microsoft SQL Server 2005 ( 1 Yr) CICS (10 Yrs) SPUFI (14 Yrs)
MDX ( 1 Yr) Microsoft Analysis Services 2005 ( 1 Yr) Endeavor (8 Yrs) CA-7 (16 Yrs)
JCL ( 16 Yrs) Brio ( 2 Yrs) Expediter (11 Yrs) SyncSort (14 Yrs)
EASYTRIEVE (14 Yrs) Maestro ( 2 Yrs) File-Aid (10 Yrs) Abend-Aid (14 Yrs)
HTML ( 8 Yrs)

Experience


Senior IT Developer Home Depot Corporation /
May 2004 - Present Atlanta , Georgia

Responsibilities include :

Developed OLAP cube application within Microsoft Analysis Services/SQL Server 2005/Proclarity architecture.
Process involved : Co-ordination of data structures and data movement between Data modeling, DBA and ETL
teams; Configured data source connectivity between multiple DB2/UDB dimension tables; Designed cube
Fact / Dimension tables and Measure groups based upon business requirements.

Support of retail applications within an Enterprise Data Warehouse architecture.
Design of AD-Hoc SQL Queries to perform data mining within DB2/UNIX UDB tables for extraction of
Specialty Sales data.

Change Control administration for software implementation into the production Enterprise environment.
Change Control functions include : Serve as Point-Of-Contact for EDW application developers, database
administrators ,etc.. upon submitting notification of production software implementation.

Developed automated B2B application for data extract/ transfer to external vendor for processing of Customer
interactive voice response System. Process involves: Development of batch COBOL programs which perform data
extraction using SQL cursor processing and perform data conversion to required data types. Process executes in
scheduled CA-7 batch cycles; Process includes B2B technique using MQ-Series/XML based file transfer to
external Vendor.

Modification of Enterprise(HTML/CICS) Portal application. Modifications include : analysis of (HTML/CICS)
integrated reporting application; modifications required updates to COBOL/SQL cursor allowing increased handling
of data volume.

Performed training to programmers in development and support methods applicable within an Enterprise Data Warehouse environment.



Consultant Home Depot Corporation /
December 2002 - May 2004 Proven Method Consulting
Atlanta , Georgia


Responsibilities include:


Design of Extended Service Plan (ESP) application . Process involves: Definition of business requirements; Development of COBOL\SQL programs within the Home Depot Application Architecture; Project administration of B2B data transfer methodology between internal (Home Depot) and external (General Electric) technical areas; defined specific data conditions for application testing throughout the AD and QA Life Cycle Phases (LCP); provided documentation of process development and support.

Support of Enterprise based Call Center Reporting Applications . Support includes : Problem determination and analysis ; Modification of COBOL/SQL/OPTIO source in PDF format ; Required modifications applied based upon user specifications.

Support of Enterprise based Call Center Reporting Applications . Support includes : Problem determination and analysis ; Analysis of integrated report and modification of OPTIO formatted reports available in PDF format ; Required modifications applied based upon user specifications.


Developed AHS BYO/CCC Flash reporting process. Process involved Coding of batch COBOL programs and batch JCL within the Home Depot Application Architecture. Process included automated FTP file transfer of converted mainframe text file data into MS-EXCEL comma-separated(csv) format, available in user server directory.

Developed AHS CCC Vendor Completed Changed Items reporting process. Process involved Coding of batch COBOL programs, batch JCL and Optio-DCS programs within the Home Depot Application Architecture. Process included automated FTP file transfer of converted mainframe text file data into ADOBE PDF pipe-separated(txt) format, available for user selection in IBRIDGE delivery method.

Performed AD/Sales DB2 table unloads providing periodic sales data to vendor. Process involved DB2 table unloads into multiple datasets due to space considerations. Files were uploaded to temporary desktop PC-hard drive using FTP. Co-coordinated installation , processing and delivery of vendor hard-drive between various groups including : PC-network services, storage administration and vendor.


Provide training to programmers in development and support methods within the MVS COBOL /DB2/JCL environment.




Consultant State of Georgia Department of Revenue
August 2002 - December 2002 Matrix Resources Inc.
Atlanta , Georgia

Responsibilities include:

Design and development of Treasury Offset Process (TOP) application.New COBOL/DB2 programs were developed to process inbound/outbound taxpayer liabilities. Application was successfully integrated with existing Centralized Taxpayer Accounting (CTA) processes while adhering to application development methodology.

Developed batch programs to process taxpayer liability/reversal records. Process included creation of batch report for user evaluation.

Developed batch process to reconcile bi-annual file containing taxpayers with missing address information. Process performs DB2 table selects of existing address information and applies it to errant records. Corrected file is re-transmitted to external collection agency.








Performed DB2 data migration of production data to unit and system test environment. Developed Easytrieve processes to manipulate test data values for system testing. Evaluated test results and performed code modifications as required based upon results of testing.

Maintained application documentation as prescribed by project management group.


Consultant State of Georgia Department of Human
February 2001 - June 2002 Resources / Matrix Resources Inc.
Atlanta , Georgia

Responsibilities include:

Development and support of a government based economic support system within an MVS/CICS/DB2 environment.

Development of statistical batch reporting process involving comparisons of assistance types including: Food stamp, TANF and Medicaid. Process involved DB2 table unloads and complex Easytrieve routines for record extraction and report formatting.


Development of batch reporting process for statewide workers eligible for Medicaid maintainance. Process involved DB2 table unloads and Easytrieve routines to combine county/load data with matching key fields of selected supervisor.
Process included modifcations to existing CICS program performing similar caseload selection functions.

Implementation of federally mandated system revisions concerning new claim type indicator. Project involved : team based intercommunication with business analyst, users and management groups ; analysis/modification/testing of affected CICS/batch COBOL programs/copybooks ; specifications of DB2 table modifications ; modifications of embedded SQL within affected CICS/batch processes. Modifcations were successfully installed before expected due date.

Periodic after hours oncall support, involving: ability to access host system from home using provided software and procedures ; analysis of production processing ; communication with operation support staff ; problem resolution or escalation notification.


Programmer Analyst Allied Automotive Group Inc.
September 1999 - February 2001 Decatur, Georgia

Responsibilities include:

Development and support of COBOL/SQL applications within an MVS/DB2/Peoplesoft environment.
Primary functions involve: system revisions based upon approved user specifications. Integration of revised
benefit codes for enhanced cost accounting. Modifications were based upon business requirements within
user specifications. Enhancement provided increased accounting accuracy which decreased monthly cost
for the company.

Developed COBOL/DB2/FTP batch process performing selection of table data which was reformatted in proper
client-server based ASCII format for upload to LAN based user reporting system.

Analysis and modification of COBOL program responsible for regional employee incentive/bonus payment. Process involved detailed analysis of complex company payroll program using Expediter. Error was attributed to process conditions never being met due to invalid nested-if conditions.

Developed COBOL/SQL solution for updating of payroll exception tables. Processing involved: large DB2 cursor for selection of qualified employees in pay period with matching earning , deduction and tax criteria ; COBOL condition logic to apply proper pay codes for each employee ; SQL table inserts of selected records ; and generated user audit report of processed employees and pay amounts.

Developed various custom reporting queries using QMF.

Participated in periodic on-call support duties.




Consultant State of Georgia - Department of Medical
May 1999 - August 1999 Assistance / EDS / MTS-PeopleSource
Clarkston, Georgia

Responsibilities include:

Analysis and modification of Syncsort parms for the application of vendor prescribed century windowing parameters. Batch jobs using Syncsort parms were successfully tested for Y2K compliancy.

Modifications of CICS and batch COBOL programs performing calls to internal date sort routine. Process involved
Remediation of COBOL source through addition of COBOL index/tabling techniques. Non-century formatted dates containing year-fields were expanded in the sort table to include a century-field. This allowed century windowing in the sort. Resulting table data was returned from called program in original non-century format.




Senior Consultant SunTrust Bank Incorporated /
February 1998 - May 1999 Technical Software Development
Incorporated
Fayetteville, Georgia

Responsibilities include:

Administration of Y2K certification for ASI-15 and ASI-17 research /adjustment systems. Project includes : organization of technical documentation within the scope of Y2K compliancy; technical representation between client/user area and corporate Y2K management relating to application ; development /coordination/participation in
Integrated application acceptance testing for Y2K.

Analysis and modification of mainframe programs designed for client-data formatting within ASI-17/15 client-server application. Programs containing date routines were modified with date "windowing" techniques based upon formatting requirements of interfacing applications.

Development and coordination of enterprise system tests with applications interfacing to ASI-17 and ASI-15 for Y2K certification.

Implemented batch process for transfer of files between regional operation centers for updates to VSAM master files of
Large Cash Reporting (LCR) tax system.


Performed maintenance through oncall production support of LCR application with periodic execution of acknowledgment processing for LCR online master file updates via input of IRS external data .


Consultant Metropolitan Life Insurance/
August 1997 - February 1998 Ciber Incorporated
Atlanta, Georgia

Responsibilities include:

Development of scheduled batch process for updating of Asset Backed Security tables. Process involved development of FTP/PERL script to transfer Windows/NT client file into mainframe dataset for input to COBOL program that formatted records into acceptable DB2 load format for related tables.

Designed and coded batch process for updating of Mortgage Backed Security tables. Process involved development of COBOL programs with embedded SQL to input external data from Pricing system and perform table selects/inserts and updates against Securities tables prior to their updates.

Performed analysis and inventory of process elements within Security Asset application for Year 2000 renovations, including software migration through ADS/LUS migration manager. Provided internal details of application to technical support area responsible for application certification using Peritus Millennium conversion software.





Software Engineer TransQuest Corporation
February 1997 - August 1997 Atlanta, Georgia

Responsibilities include:

Analysis and modification of COBOL/DB2 program to validate user input accounting categories against DB2 finance tables, prior to returning data-block to client application. Inserted logic to place correct expense category in host based copybooks for routing to desktop client through client/server architecture.

Modification and development of Syncsort modules to process batch extract files, through summarization of related expense records. Process generated multiple sorted and summarized output datasets to be used in subsequent batch processing.


Direction of support staff in use of analysis software such as; Expediter and File-Aid to identify source errors
and validation techniques for unit testing during code modification and production migration.



Systems Engineer Home Depot Corporation
May 1993 - February 1997 Atlanta, Georgia

Responsibilities include:

Development of on demand batch process for transfer of prescribed existing regional structures and retail entities to create new regional merchandising center, preserving established referential integrity utilizing custom COBOL DB2 coding techniques.

Designed and coded batch process for advertising results tracking system, utilizing custom COBOL II coding techniques with embedded SQL to perform merchandising table updates.

Analysis and COBOL/DB2 modification of market build process to preserve proper item/pricing relationships during establishment of new markets. Developed integrated COBOL/JCL/FTP batch processes to transfer and format inventory/sales data from Data General platform to IBM/DB2 platform for sales/inventory update and reporting purposes.

Coded host PIN maintenance process surrounding Interactive Voice Response for corporate benefits enrollment. Process included development of random number generator to assign/expire employee PIN numbers through CICS on-demand submission of scheduled batch processing.

Organized user requirements and developed programs to implement in-house printing of employee W-2s.
Developed process to access and maintain large VSAM files for loading into easily managed DB2 tables,


for on-demand job submission. Designed custom W-2 form using Xerox FSL language to merge host data
with custom form resident on Xerox printer.

Evaluated and applied maintenance to CICS programs to ensure existing relationships of user entered tax data. Modifications generated online errors to the user which prevented entry of data when required tax data had not been previously established in required DB2 tables. SQL abends were prevented in scheduled batch processing by this change.


Supervisor Computer Operations Home Depot Corporation
February 1991 - May 1993 Atlanta, Georgia

Responsibilities include:

Computer operations shift management involving national monitoring of networks and integrated production
processing of MVS, Data General, UNIX and PC/LAN platforms.

Analysis and escalation of system outages affecting online availability and network transmissions through the
use of performance analyzers such as Boole/Babbage and Omegamon.


Implementation of standards and procedures for computer operations entailing:CA-7 batch process monitoring, scheduled IML/IPL, facilities maintenance and disaster recovery.

Provided training and periodic performance reviews of operators.



Network Operator Bank South Corporation/ November 1987 - February 1991 Computer Task Group
Riverdale, Georgia

Responsibilities include:

Coordinated and maintained MVS and network operations automation with Netview Clist.

Performed problem determination analysis of communication outages with Racal-Milgo protocol analyzers
and terminal test equipment.

Served as point-of-contact for vendors such as AT&T and IBM during network installations.




Education:
Morehouse College Candidate for Bachelor of Arts majoring
Atlanta, Georgia in Computer Science.
August 1983 - May 1987

References available upon request

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-GA-Atlanta »
View all resumes in US-GA »

View other Senior IT Developer resumes, Programmer / Developer resumes