System Analyst/ programmer Resume

SUMMARY:

Experience: Over 12 years of solid experience of development using ILERPG Free RPG (II - IV, ILE), embedded SQL/400 and CLP, including analysis, Designing, Coding, maintenance, testing, implementation of various software applications in Warehouse Distribution and management, Transportation and Retail, Insurance, Textile manufacturing & finance companies.

TECHNICAL SKILLS:

Hardware Platform: AS/400 (I & MQ series), System/36, PCs

Operating Systems: OS/400, SSP, Dos, Windows (3.1 2000), Window NT

Software & Tools: RPG free, RPGLE II III/IV, Embed SQL, CLP, Web Sphere, Query36 & 400, SEU, SDA, Client Access (ODBC) FoxPro Other tools & utilities MS Access, Java, Excel, HTML, DBU, WMS, PkMS, Hawkeye and Lotus Notes. C# .Net, Q shell environment

Database: Relational data DB2/400, dbase, Access

Protocols: TCP/IP, FTP and SFTP

PROFESSIONAL EXPERIENCE:

Confidential, MA

System Analyst/ programmer

Responsibilities:

Also includes modification of the existing programs and users Interaction to discuss and to review their requirements.
I developed interfaces programs for Web application using SQL store procedure and RPG.
Data files conversion from and to between DB2, CSV, Text, XL and XML formats
Data Transfer From and to local and outside servers using IFS folders, FTP and SFTP (for secure bank data) Q shell.
Programs for data conversion From/to zip format using AS/400 Q shell.
Conduct user meetings for projects update and reviews.
Developed CRM system and created interface with Salesforce.com
User data upload to AS/400 (Prices, Products etc.) and vice versa.
I also developed various reports and printout programs that includes;
Created accounts statements in PDF format using AFPU and trigger emails to the customer.
Design and upload company logos for AS/400 page segments.
Created reports using Crystal Reports, COGNOS

Tools: used RPG free, Web Sphere, SQL/400, CLP.

Confidential, New Jersey, NJ/New York

System Analyst/ programmer

Responsibilities:

I am responsible to implement and customizing Pick ticket Management system (PkMS) and retail management system (RMS).
I developed various programs, which includes the bridging and transfer information from host to PkMS and PkMS to Host for PO, distribution and Pix and Invoices.
Communicate with PkMS severs.
Maintain and define new customize menu. Maintain distribution for multiple case pack inventories.
I developed various reports for all departments.
I am working with all the departments (Receiving, shipping, Pick and load).
Recreate distribution for wave shortage issues.
I also coordinate with PkMS office to resolve software operational issues.
Implement trailer management system for warehouse and stores.

Development tools used: ILE RPG 400 and CL, SQL/400, FTP, and DDM files.

Confidential, Columbus, OH

System Analyst/ programmer

Responsibilities:

Analyzing the project requirements and designing
Design and create physical and logical files
Developed programs/procedures using RPGLE IV/embed SQL
Created displays and also used sub file
Crated program with Binding of modules
Created store procedure to communicate Java Server application
Created FTP procedure to send and receive data among admin centers
Created test environment and conduct extensive testing
Completed system documentation and users training
Provided technical support to the users of more than 200 locations

Environment: AS/400 (MQ series), DB2/400 database, RPGLE, Embed SQL, Java, CLP, Query/400, DBU, DDM

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship