SUMMARY:

• Dedicated IT professional with extensive versatile hands - on experience in different industries
• Experience working with all levels of management
• Experience as Technical Leader, Analyst Programmer, Programmer and Database Analyst
• Performed the duties of liaison between the IT, business end-user/vendor community and technical group (including the .NET group) in order to develop a customized font end
• Performed analysis on different systems in order to in corporate additional sub-systems to fulfill the requirements on AS/400
• Developed simple and complex programs using written specifications and oral described requirements using RPG IV, ILE and Free Format; also worked on embedded SQL and CL programs
• Coordinated with development teams and business owners and performed testing in order to validate the system was built per requirements
• Successfully delivered project deliverables under extremely tight timeframes and met customer expectations in delivering a quality product within budget and schedule

TECHNICAL SKILLS:

Systems: - IBM-AS/400 (I-Series), IBM- S/36, IBM-360/370, IBM-390, IBM-3741/42

Operating Systems: - DB2, OS/400, TOS, DOS, OS, Oracle, Windows

Programming Languages and Tools: - RPG (II, III, IV, ILE, Free), COBOL, SQL, Embedded SQL, PL/SQL, C++, Assembler, ACL (Application Control Language), JCL, CL, CLLE, CMD, APLUS (Abstract/Probe+), ASC, Query (36, 400), DBU, DDS, SDA, FTP, SEU, DFU, RLU, EDI, PDM, Hawkeye, TURNOVER, ALDON, RDI,VALENCE, JSON.

Software: - Word, Excel, Visio

PROFESSIONAL EXPERIENCE:

Date Analyst Programmer

Confidential

Responsibilities:

• Analysis of Baillie Lumber Volume calculations.
• Created new programs to accommodate the change calculations.
• Created new program documentation.
• Created new reports for managements.

Analyst Programmer

Confidential

Responsibilities:

• Analysis of the programs to me modified
• New programs to rewritten using modern technique (JSON).
• Changed existing programs to work as required

Technical Lead/Analyst Programmer

Confidential

Responsibilities:

• Analyzed the system to find the programs need to be changed to in corporate the new laws for government support Med-D retail and Catalog Sale
• Changes to Rx Claim, Claim Pricing, Claim Benefits and Coordination of Benefits Systems.
• Made changes to the RPG Existing Programs
• Written New programs using RPG Free Format
• Tested the Changed and new Programs
• Documented the changes and test results.
• Designed the new Screens/Windows for the representative to complete the customer Sales order.
• Written new programs using RPG Free Format to in corporate the new order screens.
• Created new Customized Order Sales inquiry screen/window.
• Written program to calculate the agent sale commission.
• Test all the screens and RPG programs
• Documented the change/creation in the display screen
• Documented the RPG programs
• Documented the test results
• Sign off by the user.

Confidential

Responsibilities:

• Created new programs using RPG Free Format in the reservation system to create the availability of the resorts.
• New programs to create the service requirement in the resort including any special request from the guest.
• Created New Credit Card Screen for inquiry.
• Written programs to manage the rental property for the upper management.
• Created the test document.
• Documented the Test Results.

Confidential

Responsibilities:

• Studied the Billing system to the point the customer bills are printed after that the bills are enveloped and send to the customer manually.
• Analyzed how to quire the spool file and automatically send to the customer.
• Created a E-Mail address table to hold the address of the customers.
• Written programs using RPG Free to attach the customer bill to the email and send to the respected customer.
• Documented the change to the system.
• Documented the test results.
• Sign off by the user.

Confidential

Responsibilities:

• Studied the existing data file and created the new data file to hold the data separately for to different companies.
• Designed new screens/windows to display different data for inquiry and information.
• Written the program to update the date separately in two different file where it belongs
• Written programs using RPG Free to create the two different sales reports for management.
• Written Billing programs to create the bill as per customer’s wish (combined bill for both companies or separate bills for each company).
• Written program to bifurcate the sale order in case it has the combined items for the two companies.
• Written dispatch order depending on the customer’s wish.
• Documented the test results.

Analyst Programmer

Confidential, Addison, Texas

Responsibilities:

• Analyzing the date form County Wide for Mapping and Migration.
• Migrated Data to Confidential System.
• Written new programs using RPG Free to create the summary reports of the transferred data.
• Updated the existing programs using RPG-IV as required.
• Created Store Procedures to communicate and process Data on two different systems (Country Wide and Confidential ).
• Written programs to create the Foreclosure reports for the management.
• Written programs to create Mortgage summary reports.
• Documented the test results.

Analyst Programmer

Confidential, Atlanta, Georgia

Responsibilities:

• Analyze the existing system/programs to in corporate the require changes.
• Program specification to accommodate the new requirements.
• Created the logical flow for the sub-system.
• Code some of the complex new programs using RPG Free Format.
• Updated the existing programs using RPG IV.
• Created the system Documentation.
• Performed unit testing.

Analyst Programmer

Confidential

Responsibilities:

• Developed sale promotion system.
• Perform Database Analyses
• Performed day to day change management jobs.
• Introduced programming standards.
• Introduced ‘Commit and Rollback’ methodology.
• Redesigned Re-order and Roll down system.
• Analyzed COBOL programs of Warehouse system.
• Converted COBOL programs to RPG IV programs.
• Included Embedded SQL to enhance performance.
• Created program specifications for Developers to code programs.
• Developed auto report distribution system.
• Automated night jobs and error handling messages system.
• Developed Audit, Inventory and Account reports for management.
• Developed the methodology for unit testing, integrated testing.
• Worked with Dot-net team to design customer friendly front-end system.
• Eliminated the paper reports by putting the reports on web.

Analyst Programmer/Architect

Confidential, Atlanta Georgia

Responsibilities:

• Architecture change to Functionality (COMMIT) to avoid data corruption.
• Data mapping for merging/conversion.
• Transferred AT&T Accounts into Cingular System
• Changed and updated Business Markets
• Created the “Staging Area” (Libraries/files)
• Established the “Check Points” to stop and restart the data transfer process
• Validated the date while conversion was in progress
• Planned the data transfer (method of transferring data FTP)
• Identified and documented redundant data and interfaces and their reason/effects
• Created legacy system data feed inventory lists mapped to the target application
• Wrote program specifications
• Coded programs using RPG-IV/free format, COBOL 400 and SQL
• Created test cases and performed testing
• Performed integrated testing (CARE billing system with other applications)
• Enhanced and modified CARE Billing System in order to handle the transactions of AT&T and Cingular
• Changed the architecture of Cingular Billing System

Programmer

Confidential

Responsibilities:

• Written RPG-IV programs with embedded SQL in order to validate and update database files
• Updated CL programs to run the job automatically every morning from the existing morning procedure
• Worked on data mapping
• Created flat files to transfer data electronically to remote locations
• Created AS/400 screens to enter new records, update/change existing records and to run customer queries
• Performed unit testing.

Analyst Programmer

Confidential

Responsibilities:

• Analyzed the existing manual data entry system
• Designed automated sub-system to capture data from AS/400 into Oracle
• Written programs to update database files and create reports using RPG-IV, embedded SQL and CL
• Analyzed the existing database file layouts
• Created new database files to be used as intermediates between Web and As/400
• Created CL programs to handle automated file transfer using FTP
• Documented the changes made to the system and programs
• Updated/changed securities on AS/400

Programmer

Confidential

Responsibilities:

• Investigated the problem of missing data during the transfer from IBM-390 into AS/400
• Written RPG-IV program to fix the problem
• Written RPG-IV and CL programs to control invalid transactions
• Created screen to edit the invalid transactions
• Added options to menu for editing and updating the transaction
• Written summary report programs for higher management
• Redesigned the initial data collection screen/forms to accommodate additional fields/data for Life Insurance System
• Redesigned the database to accommodate additional fields
• Extended the existing fields to avoid data truncation.
• Written RPG-IV program for insurance premium collection
• Written RPG-IV program for commission payable and commission distribution
• Used turnover in order to perform different tasks

Programmer

Confidential

Responsibilities:

• Analyzed existing unbalanced reports for sales and purchase
• Designed a sub-system in order to resolve the problem
• Standardized the detail and summary reports
• Wrote programs in order to accomplish the requirement using RPG-IV and CL
• Wrote programs in order to create sales analyses reports and summaries
• Documented the sub-system, new programs and the changes made to the existing programs

Analyst Programmer

Confidential

Responsibilities:

• Designed the credit card system
• Created database to accomplish the requirement
• Designed the screens for Credit Card swipe, initial data collection, data validation and data entry
• Written programs to accept the data from swipe machines when the credit card was swiped.
• Written programs to validate and transfer information between bank tandem and a company’s system.
• Written Trigger Programs for administration purposes.
• Performed unit testing and integrated testing
• Implemented the credit card system
• Documented credit card system
• Analyzed Rental Man system existed on IBM/390
• Created a system flow chart

System Analyst

Confidential

Responsibilities:

• Studied and documented the Manual Loan System
• Designed and documented the systems for computerization
• Written program specifications
• Coded Complex programs.
• Performed program testing
• Performed rigorous system testing
• Implemented the systems
• Designed/created the Operation Manual
• Trained the users on computerized system
• Created the Operation Manual