Qualifications

• Programmer Analyst with more than 27 years' experience in Property and Claim Insurance, Invoicing, Retail, Manufacturing Inventory, Shipments, Receiving, Order Entry, Purchasing, Order Billing, Order Processing, etc. , Socket Server, Accounts Payable and Receivable, EDI Invoice System.
• Experience in programming embedded SQL in RPG Free-Format, RPG ILE, RPG III and Cobol/400
• Ability to manage and prioritize multiple projects
• More than 2 years experience in PC Support
• Ability to manage operations and technical support in AS/400
• Good written and oral communication skills
• Team oriented

Professional Experience:

Confidential

Consultant Programmer Analysts

• Resolved user's issues in responding to help tickets.
• Language: RPG Free-Format, RPG ILE, RPG IV, and RPG III, CL, SUBFILES, DB2/400 and SQL/400
• Tools: DBU, Query/400 and Open Query File
• Software: Infor Distribution APlus, Release 8.3.2

Confidential

Consultant Programmer Analysts

• Provide user production support for Apex, Claims and General Ledger Applications.
• Provide problem determination and resolution analysis as needed for Apex and Claims production issues.
• Language: RPG Free-Format, RPG ILE, RPG IV and RPG III, Cobol ILE, CL, SQL, Embedded SQL, DB2/400, SUBFILES
• General Ledger
• Enhanced and developed their existing application for Apex Property Insurance , Claims and
• Provide estimates to Apex project management for IT Responses.
• Tools: DBU, Query/400 and Open Query File, Aldon Lifecycle Manager, MS SQL
• Software: Wins
• Confidential

Consultant Programmer Analyst

• Data Warehouse: Developed conversion and population programs to support Stratum Inventory and Sales.
• Transitioned existing IBM Expense Reporting to Concur Online Travel and an Expense Reporting
• System. Developed Concur application where Concur data will be processed into Accounts Payable and General Ledger System.
• Did research and resolved issues in responding to Help Tickets

• Language: RPG Free-Format, RPG ILE, RPG IV and RPG III, CL, SQL, Embedded SQL, DB2/400, SUBFILES
• Tools: DBU, Hawkeye, Query/400 and Open Query File, Surveyor 400, Turnover, Surveyor 400
• Software: BPCS, Silvon Stratum Software

Confidential

Consultant Programmer Analyst

• Worked on Build Process to automate a simpler approach with Assembly/Disassembly of building of materials and kits.
• Wrote programs for Inventory turns, Sales analysis and Comparative Sales Analyst for APLUS
• Language: RPG ILE, RPG IV, and RPG Free-Format, RPG III, CL, SUBFILES, DB2/400 and SQL/400

Confidential

Consultant Programmer Analyst

• Wrote programs for data conversion to supports for Blue Cherry and existing Apparel Business System.
• Enhanced and developed their existing application for Warehouse Management System, ABS
• Forecasting production planning and Inventory Location.
• Language: RPG ILE, RPG IV, and RPG Free-Format, RPG III, CL, SUBFILES, DB2/400 and SQL/400

Confidential

Consultant Programmer Analyst

• Worked on Availability Web Service From E-com to BPCS
• Wrote programs to combine service supports several variations of Available to Ship requests through the socket server connection as well as direct call from BPCS system.
• Enhanced and developed their existing application Customer Maintenance system, Initial Load for Orders and Quote, Calculate Tax for Web Orders, Material Status Inquiry, Process EDI to Web Order files, Available to Ship for Resupply, Available to ship Resupply dating module and Virtual Resupply, Back Office Interrogation of ATS Service Programs and Order Entry system for E-com.
• Language: RPG Free-Format, RPG ILE, RPG IV and RPG III, CL, SQL, Embedded SQL, DB2/400, SUBFILES
• Tools: DBU, Hawkeye, Query/400 and Open Query File, Surveyor 400, Turnover
• Software:, BPCS, Bugzilla Software

Confidential

Consultant Programmer Analyst

• Enhance their existing application for the new release RLM Apparel Software system.
• Write programs to maintain the cost sheet variance and HCAP aging files
• Write utility program to compare source member and print report via e-mail
• Software: RPG ILE, RPG IV, and RPG Free-Format, RPG III, CL, SUBFILES, DB2/400 and SQL/400

Confidential

Consultant Programmer Analyst

• Setup transfer files to enable clean up data, transfer files on another iSeries server via FTP.
• Wrote programs to setup library list, system library and job description on different applications.
• Analyze Data Mirror to improved system performance.
• Loading dimensions and facts for data warehouse using embedded SQL in Cobol/400.
• Responsible for ISBN translation. Design and develop ISBN conversion across different application.
• Software: RPG III, RPG IV and RPG IV Free-Format, COBOL/400, CL, SUBFILES, DB2/400 and SQL/400,

Confidential

Consultant Programmer Analyst and Technical Support

• Verify daily operations on AS/400, installs and configure AS/400 devices, run system backup, setup PC's, provides PC support and Install PC application software and hardware's.
• Mostly worked on AS/400 using COBOL/400, CL/400, SUBFILES, DB2/400 and SQL/400 and provided strong team guidance and support.
• Was the lead contact at the base supervising 10 consultants for supporting the implementation teams in different countries.
• Trained and guided the core implementation team members.
• Designed and developed the implementation modules that were deployed at 13 countries.
• Developed in-house procedures to run in parallel with a customized tool to cross check the identification of date fields.
• Was a key member of the Y2k team and actively participated in designing and developing the Y2k factory procedures. Did the Y2k changes without interrupting the ongoing development.
• Converted the traditional Invoice Data Entry Process to EDI Invoice System. Including Invoice Validation, Invoice Review, Error Notification and Tax Control Message.
• Converted Toys 'R' Us business systems to Euro with enhancements and changes in Merchandising and Finance.
• Worked in Euro Vendor Conversion and participated in designing and developing the conversion of vendor currently trading in another currency.
• Developed Interface Modules for the existing Commercial Invoice Duty/Tariff and Credit Card Request with the new Retailing Software SVI . This package provided merchandising, inventory control, stock ledger and accounting functionalities, payables, receivables, and ledger.

Confidential

Consultant Programmer Analyst and Technical Support Specialist

• Responsible for analysis, design and development of programs for Inventory, Shipments, Receiving, Order Inquiry, Material Status Inquiry, Invoice Statement, Slow Moving Item and Purchasing. Maintenance of ProfitKey System, BPCS and On-Line System.
• Efficiently managed Corporate Data Center and Remote Sites.
• Analyzed, recommended and implemented new technologies for improving productivity.
• Set up new PC's, provides initial response to PC problems, Install PC application software and configures PC hardware and software to support the applications, IO-Emulation Cards, Printers, Modems, Remote Controllers, Work Stations and UPS System.
• AS/400: Managed MIS department operations, programming and technical support . Installs and configures AS/400 Devices and PC's and setup user profile.

Confidential

Senior Programmer Analyst

Worked on Accounts Payable, Accounts Receivable and General Ledger Applications of American Software Inc. Also worked on Manufacturing. Duties included implementing and maintaining the above systems, analyzing user requests, investigating and providing solutions.

Confidential

Programmer Analyst

Worked in the development/maintenance of the Order Verification Modules, Catalog Maintenance System, Order Entry System, Order Billing, Purchasing, Merchandising and Implementation of Order Processing Correction. Duties included analyzing user request and investigating its impact on the existing system, coding, testing and debugging and preparing more detailed program/system specifications or documentation.

Confidential

Programmer Analyst

Worked in the development/maintenance of Premium, Statistical, Management Information, Installment and Marketing. Duties included documentation for assigned programs and systems, preparing run charts and requirements, operations, documentation, general and detailed flow charts and specifying processing time.

Computer Operator

Confidential

Responsible for day-to-day operations on IBM S/38 and S/3. Was in charge of job scheduling for daily, monthly and quarterly run, yearly closing and backups, flow-charting, inventory and balancing report.

Computer Skills

• Hardware: IBM AS/400 iSeries, IBM AS/400 ADVANCED SERIES MODEL 310, AS/400 B20, E45 and E90, IBM S/38 and IBM S/3 MODEL 12, PC
• Software: IBM AS/400 OS/400, SQL, QUERY, DFU, and DBU, RLM Apparel Software Systems, Turnover, ProfitKey, On-Line System, BPCS, American Software Inc., Source Object Management, AS/400 Disaster Recovery, Microsoft Office Word, Excel and Access and PC SUPPORT
• Programming: RPG ILE, RPG IV, RPG IV Free-format, RPG III, COBOL400, COBOL ILE, CL, SDA, DB2, SQL400, VISUAL BASIC, C Language