PROFESSIONAL PROFILE

Over 15 years of experience in system analysis, database design, SDLC- full life cycle development, testing, user training and Implementation of various applications on IBM AS400 iSeries systems using RPGLE, RPG Free, Embedded SQL, RPGIV, DDL, RPGIII, DB2, CLLE, CLP, COBOL, SQL, GENTRAN, EDI, JD Edwards, LANSA, IBM Web Sphere, PKMS, Mozart/CW direct and MQ SERIES. 4+ years of experience in financial/banking application CORE (Citibank), 3 Years of experience in logistics/shipping application LYNX (CP Ships), Retail and health care industries. Experienced in analyze company needs by interacting with end users to determine software solutions. Delivers result on target, with efficient processing, increased productivity, data integrity, and user satisfaction. Strictly adheres to client coding, style and documentation standards on all projects to ensure maintainability and continuity of all code produced. Resolved programming problems in various environments and provided solutions to various application level issues. Dedicated and highly motive, takes ownership of projects and provided timely solutions for complex customer requirements. Self-disciplined with attention to detail, able to prioritize and handle multiple responsibilities and ability to work on multiple projects. Self-starter with a positive attitude, willingness to learn new concepts and to accept challenges and works well with both team environment and Individual assignment. Proven Leadership capabilities in leading off shore team and manage projects to time and budget. Expertise and experience in data analysis, application programming and database management utilizing Embedded SQL, RPGIII, RPGIV, Free Format RPG and ILE. 12+ years of experience in daily production support for nightly batch process and online applications. Good understanding of EDI X12, EDIFACT standards and IDOCS. Hands on experience in using GENTRAN tool in AS/400 Environment and Data stage- TX (IBM/ Ascential).

Professional Experience Confidential,Jacksonville, FL May 2010 – Present

(Confidential,is engaged in the business of providing insurance and administering group insurance products to financial institutions, associations, affinity groups and credit unions and their customers. Lots is also engaged in the business of marketing and issuing and administering individual insurance coverage and customers of the participating organizations.

Senior Programmer Analyst

Support and maintain in-house insurance solution system specializing in payment protection products. Duties include resolution of daily support issue and new development and enhancement to the Billing, Payments, and Claim system. Created a interface process written in RPGLE Free using embedded SQL to make sure every enroll that was attached to an image would have a identifier so it would be picked up in the enroll process. Added code to the billing, payment, ACH rejects, Claims processing applications to fix production issues and enhancements. This enhancement written using RPGLE, Service Programs and Modules. Use x-Analysis and other tools to help document the Billing system. Enhance Check and Letter creation process to use the name entered by the claims adjuster at time of payment.Environment set up and developing new programs to process in bound telemarketer sales file processing, enrollment process for CHUBBS/Ducks unlimited.
Environment: AS400/i Series, RPGIV, ILE, RPGLE, SQL/400, RPGIII, CLLE, RPG Free, Embedded SQL, PROGEN, Turnover, PGP, PCI, IFS, DB2, QUERY, and IBM Web sphere

Confidential,Tampa, FL Apr 2007 – March 2010

(Confidential,is a leading specialty retailer and cataloger of women\'s classic apparel. JJILL Warehouse Management system (PKMS - Manhattan Associates product) runs on AS400. Jill’s PKMS/WM was tightly interfaced to application called Mozart, which provides PO, Customer Support Services for catalog, Price Management, Item/SKU creation among other functions. Talbots/Jill operates in two business segments: Retail Stores and Direct Marketing.)

Senior Programmer Analyst

Developed new interfaces to establish ASN, Item, Vendor and pricing data from Talbot’s systems (Mainframe and UNIX) to PKMS WM. Developed new programs to send data sales data, order history and SKU inventory to data ware house applications using PKZIP and FTP process. Architected, developed and implemented 3-2 Color conversion in various PKMS and Mozart applications. Worked with other application groups (Mainframe, JDA allocations, Data Ware house) in providing/supporting data feeds and resolving data issues if necessary. Prepared technical specification documents and functional specification documents based on business requirements. Prepared technical specification documents, program specification documents and test cases for all the program changes. Interacted with Business users and end users in identifying the daily production issues and provided support. Provided environmental support and running batch jobs when required and assisted testing team when changes made to existing, new applications. Involved in analysis, coding, development, testing, maintenance of existing applications, database creation, maintenance and support and post implementation support. Created test cases and scripts for unit testing and integration testing. Handled on call production support activities and 24/7 on call support.

Environment: AS400/i Series, RPGIV, ILE, RPGLE, SQL/400, RPGIII, CLLE, RPG Free, COBOL, Embedded SQL, Unix, Triggers, PKMS, Mozart (CW Direct), IBM Mainframe, Turnover, DB2, VB.Net, QUERY, and IBM Web sphere

Confidential,Tampa, FL March 2003 – April 2007

(Confidential,is one of the world\'s leading container shipping companies providing international container transportation services all over the world. Logistics application called LYNX includes Bookings, Bill of Lading, Inland transportation, Account Payables, Sea cargo modules, Customs and Regulatory modules.)

Senior Programmer Analyst

Prepared functional Specification and Technical specification documents based on business requirements. Interacted with business users and business Analysts to collect business requirements. Developed new programs, stored procedures and Trigger programs using Embedded SQL/RPG ILE modular concepts, RPG Free format, DDL to manipulate DB2/400 data. Created databases using DDL and DDS, maintained the data bases and supported. Logical and physical database design, SQL tables and SQL views using DDL. Led a team of off-shore development team in Mumbai, India in the design, development and implementation of various AS/400 project. Provided Analysis, coding, development, maintenance and supporting various projects, daily production support activities and on call support. Coordination with external EDI trading partners including portal, Customs, Regulatory, Port and terminal authorities for regular EDI support activities and new enhancements. Establishing new EDI Connections with various Trading Partners & support activities. Created New Trading partner profiles and Communication profiles in Gentran and Data stage – TX using FTP server and VAN, Tested EDI transactions with partners.

Environment: AS400/iSeries, RPGIV, RPG Free, RPGLE, DDL, SQL Views, Embedded SQL, Triggers, EDI, GENTRAN, IBM Web Sphere, Lansa, Synon, MQ Series, RPGIII,CL,DB2/400, COBOL, QUERY/400, SQL/400 and Data Stage -TX.

Confidential,Tampa, FL Aug 2002 – Feb 2003

(Confidential, is full-service mail-order pharmacy distribution application, specialized in home delivery of medications, medical equipment, supplies and services like Transportation, Home Health care and other patient pharmacy needs. PMSI provides specialty services for workers compensation patients.)

Programmer Analyst

Developed new programs in Order Entry Module for Med’s and Specialty services. Modified billing interface programs as per the changes to PTBE billing application. Developed new online programs in Order Entry, RPH review, Patient Services, DUR and Specialty Services. Prepared functional specification and technical specification documents, test cases based on business requirements. Supported QA team, user group and change management until production implementation.

Environment: AS/400, DB2/400, RPGIV, RPGIII, CL/400, MS office, Visio, GENTRAN, SYNON, QUERY/400, ILE, OS/400, JD Edwards.

Confidential,Tampa, FL 1999 – 2002

(LACB – RegionalTechnologyCenter (RTC) provides total technology solution to Citibank in Latin American countries (Venezuela, Chile, Columbia and Mexico) and International Personal Banking (IPB – San Francisco, New York, Miami and Los Angeles). IPB – CBNA Conversion/ Migration - The Initial phase of IPB (International Personal Banking) Conversion project is to migrate existing IPB Customers from CORE banking System to CBNA CAS & TIPS systems in New York. The second phase Involves developing new programs to data conversion, Purging, archiving financial information, creation of archive reports, file transmission to the migrated system (MVS) and shutting down the external interfaces. Host Authorization Using MQ series – The main purpose of this Project is to change the authorization process for Citibank ATM customer when used in any of the ATM networks and Point of sale.)

Programmer/ Analyst

Worked in various Citibank’s LACB projects and supported applications like Credit Card, Transaction Subsystem, Time Subsystem, Bill payment, Back office, Loans, CIF Subsystems, Account/Payables, Receivable (AP/AR), Data Ware Housing, CITIFUNDS, GRB in CORE application. Interacted with Business users on daily production issues and Project Management standpoints. Worked with off shore development team in providing technical specifications and supported QA team in creating/building test environments. Involved in Maintenance of CORE Banking application, participated in analysis, Design, Coding, Testing, Implementation and Post implementation (support) activities. Provided daily Production support services for nightly batch process and online support. Prepared Functional Specification, Program specification documents. Supported QA group in testing various projects and productions support fixes and bug fixes in IST and UAT environments. Did Field level mapping and developed new programs to populate Conversion files. New conversion programs have been developed and FTP scripts have been created to transmit conversion data. Created reconciliation reports to support reconciliation team.

Environment: AS/400, OS/400, RPGIV, RPGILE, RPGIII, CL/400, DB2/400, COBOL/400, SQL, Query/400, BLDCOS, CSSA, VB, MQSERIES

Confidential,Arkansas 1998 – 1999

(Confidential,Maintenance tracking system that allows tracking all maintenance requests on any given store or piece of real estate that company own! Property Development/Management - System that allows tracking the land that is currently under construction, land being bought or sold and managing property details in regards to leases, square foot, lease status, type of property owned or being bought or sold. ACRE System - System used to track store information on new or existing projects i.e. Store size, Location, Grand Opening Dates, Store type, Project type Etc. Property management system is one of the applications in JD Edwards’s package that incorporates a group of user interfaces.)

Programmer/ Analyst

Participated in daily production support and modified various programs in existing application as per the business requirement. Modified existing programs to support Y2K issue by fixing date routines and date calculations in ACRE, INACRE (international) systems. Created a module to convert date format after identifying the date format in any given program. Design, Coding, Testing and Post implementation activities.
Environment: AS/400, RPGIV, RPGIII, CL/400, DB2/400, COBOL/400, JD Edwards

Confidential,India 1996 – 1998 Programmer/ Analyst

Analysis, Design, Coding, Testing, Implementation and post implementation support.
SD2000 Tool for Confidential, (1997-1998)
The main purpose of the tool is to detect the date fields and probable date fields of variable length. The application generates a repository to detect the date fields taking into considering the various different formats of date and change appropriately.
Order and Invoice Confidential, (1996-1997)
This system was developed for generating an invoice; printing the invoice, dispatching the item to different parties, list of items to be invoiced during a particular period, printing of statements, reports and customer wise invoicing statements etc.
Environment: AS/400, RPGIII, CL/400, DB2/400, COBOL/400, QUERY, DB2, JCL, SYNON/2E

Education

Bachelor’s Degree in Engineering (Electronics)

Post Graduate Diploma in Computer Applications.

TECHNICAL SKILLS

Hardware : AS/400 iSeries, S/38, Windows PC
Software : PKMS, MOZART/CW Direct, JD Edwards
Operating system : OS/400, MVS, UNIX, Windows 95/2000, Windows NT, Solaris
RDBMS : Oracle 8i/9i, Oracle 7X, SQL Server 2000, DB2.
Internet Technologies : ASP, VB Script, Java Script, XML, HTML.
Application Servers : BEA Web logic Server, IBM Web sphere Application Server, IIS
Protocols : TCP/IP, FTP, HTTP, XML, SOAP
Languages : RPG, RPGLE, RPGIV, RPGIII, CL, JCL, COBOL, SQL, C,
PL/SQL, Visual Basic and VB.Net, Java
Utilities : SEU, SDA, PDM, RLU, DFU, HAWKEYE, EZVIEW, Cute Ftp,
Mark Magic, X-Analysis, Rational Clear Case, Remedy, TOAD,
i Séries Navigator.