NAYAN JAYANTIBHAI PATEL
acced0@r.postjobfree.com
Professional Summary
. 12+ years of experience in program analysis, development, coding,
debugging, testing, implementation, maintenance and documentation on
AS/400 platform.
. Experienced as a Project Lead with strong skills in performing system
analysis, design, development, and maintenance of IT systems running
on AS/400 platform, using RPG 400, RPG IV, CL and SYNON.
. Good understanding of Agile Project Management & Scrum methodology.
. Well versed with Complete SDLC Process & Maintenance Projects.
. Customer centric attitude, Self-disciplined with attention to detail;
able to prioritize and handle multiple responsibilities.
. Delivers results on target, with efficient processing, increased
productivity, data integrity, and user satisfaction.
. Good experience of Micromanagement with Team of 15+ Resources.
. Dedicated and highly motivated professional.
. Well-structured and comfortable functioning in a virtual environment.
. Experience in onsite coordination, good communication, capable of
delivering optimized, effective and well-documented code adhering
optimum quality.
. Strong written and oral communication skills.
. Expert in using various tools and utilities in SDA/DSPF, DDS, PDM,
DBU, Implementer & ALDON (Turnover).
. Extensive knowledge in Manufacturing, Distribution Retail, Banking &
Non-Banking Financial domain.
. Techno-Functional experience on various J. D. Edwards modules.
Education
B. E. Computers, Pune University, Maharashtra, India.
Skill Set
Domain : Manufacturing, Distribution, Retail, Banking & Non-Banking
Financials
ERP : PRMS, PKMS & JD Edwards (Payroll, Order Management, Inventory
Management, Warehouse, Advance
pricing & Procurement)
Language : RPG/400, RPGILE, COBOL/400, CL/400 & Visual Basic 6.0
Tools : SEU, DFU, SDA, RLU, Query/400, PDM, MQ Series, SYNON
ProGen, World writer, FastR Hawkeye, Implementer & ALDON (Turnover)
Database : DB2/400, ORACLE 8i & SQL/400
Web Technology : HTML, Java Script, VB Script & ASP
Business Intelligence : COGNOS (Powerplay, Impromptu & Transformer),
Business Object &
Datastage
MS Office : Word, Excel, Access & Visio
CRM : SalesForce.com
Professional Experience
WUBIS - Agent Services, Denver - CO
Jan 2009 - Till Date
Role : Sr. System Analyst/Application Owner
Domain: Non-Banking Financial
Western Union is an industry leader, transferring funds in minutes among
over 190 countries, utilizing over 180,000 agent locations worldwide; and
more than 80,000 of these agent locations are equipped with a point-of-sale
(POS) device. Western Union also issues more than a quarter billion money
orders every year.
Agent Services provides Account Enrollment, Database Maintenance, Agent
Compensation, Check and Merchandise Ordering, Inventory Management and
Database Sharing with external systems.
The Agent Services project provides applications support across all of the
WU Business Units. There are three applications (Agent/Customer
Maintenance (ACM), Agent Compensation (ACP) and Inventory Management (IM1).
Successfully completed the brand merger Project for Orlandi Valuta & Vigo
into WU Applications. This was a fast pace project Sponsored & Monitored by
US Government (Compliance Office).
Responsibilities: As a Project Lead my role included the following tasks:
. Understanding/Evaluating Business requirement & creating
Functional/Technical Specifications.
. Analyze the programs and extract the logic.
. Extensive Coding, Testing and Debugging of programs for the Display files
and Sub Files using RPGILE, CL, SQLRPGLE, COBOL/400 & SYNON.
. Making changes in the existing Visual Basic Programs.
. Providing alternative solution where programmatic solutions are not
available.
. Design/implement the Solutions for Mass Data Add/Update from Backend
keeping Business Logic/Validation intact.
. Identify System Enhancement opportunities & convert them into System
Requirements.
. Estimating Development Efforts, Performing Unit/Integration & Supporting
SQA/UAT.
. Creating Project Schedules & Monitoring the same throughout its life
cycle.
. Providing the Support for analysis and documentation for User Training.
. Implement the Project & support post production issues.
. All the Enhancements related to new functionality of Agent Services.
. Solely responsible to solve all the technical issues & coordination with
Off Shore Team.
. Supporting Adhoc Requests from User & Oncall/Production Support.
. Accountable to ensure that projects are delivered as per requirement and
completed to time, cost and quality.
. Adhere to established project methodology/management guidelines, best
practices and communication guideline.
Environment: AS/400, OS/400, RPGIV, COBOL CL/400, SDA, DBU, PDM, DB2400,
Query400, SQL400, SYNON, VB 6.0, Job scheduler & Implementer
Imports Management (Purchase System), Middleboro - MA Aug
2008 - Jan 2009
Role : Senior Programmer Analyst Domain: Retail
Distribution (Consumer Products)
The majority of Christmas Tree Shops (CTS) sales product is imported from
outside the United States. The CTS Imports department is responsible for
maintaining visibility to product in route from foreign suppliers up until
this product is received at a CTS distribution center. CTS' Imports
department uses a custom import (control) log computer application to
maintain this visibility.
As a custom application written several years ago, the current CTS Imports
application has a number of shortcomings. Several of the programs have been
heavily modified over the years and are now difficult to maintain. There
are also new business support requirements that are not supported through
the current Imports application.
Some of the Import Related Functionalities are,
. Imports Core File Maintenance & Inquiry
. Import Log Maintenance/Inquiry
. Container Header & Detail Maintenance/Inquiry
. Imports User Master Maintenance
. Maintenance of Imports Notes
. Import Shipments to WMS
. Imports ASN (EDI 856) Download & Process
. Freight Fee Maintenance
Various Reports generated by Import systems are:
Cargo Value Report, Open Containers Reports, Containers in the Yard
Reports, Vendor History Report, On the Water Detail Report
Responsibilities: As a Programmer Analyst my role included the following
tasks:
. Understanding user requirement.
. Analyze programs and extract the logic.
. Estimating Efforts & Supporting UAT.
. Creating Technical Design documents.
. Identifying, isolating, troubleshooting and reporting on problems.
. Coding, testing and debugging of above Functions/programs using
ProGen(RPGLE).
. Addition of new programs to the menu, developing new functionality,
reports/inquires using ProGen.
. Providing the Support for analysis and documentation.
. Making changes in the programs using the Display files and Sub Files.
. Enhancements related to release of new Import system & Integrating it
with JDA
. Documenting the application for maintenance.
Environment: AS/400, OS/400, RPGIV, CL/400, SDA, DBU, PDM, DB2400,
Query400, SQL400, EDI, PROGEN, ROBOT scheduler & PKMS WMS.
SOE/SOP (Sales Order Entry/Processing), Pune - India
Sep 2007 - Jul 2008
Role : Senior Programmer Analyst/Team Lead
Domain : Supply Chain
AmerisourceBergen Corporation is one of the largest pharmaceutical services
companies in the U.S., serving both pharmaceutical manufacturers and
healthcare providers with drug distribution and other channel services.
AmeriSourceBergen has 30 distribution centers.
ABC buys pharmaceutical goods from supplier and sales them to the
customers. Buying of products is done with the help of Purchase Orders,
Sales of products is done with the help of Customer Orders.
The SOE/SOP module includes
. Receiving Customer Orders.
. Order Item Verification and Quantity Validation.
. Customer Authentication (In case of Narcotic Item).
. Item Substitution / Allocation.
. Alternate Servicing from Other Division.
. Sending Confirmation to Customer.
. Providing Route/Group/Stop Information for Picking.
. End of Day Process Support
Responsibilities: As a Programmer Analyst my role included the following
tasks:
. Understanding user requirement.
. Estimating Efforts & Supporting QA/UAT.
. Creating High & Low level Design documents.
. Extensive Coding, testing and debugging of programs in RPG IV and CL.
. Analyze the programs and extract the logic.
. Provided the Support for analysis and documentation.
. Mentored 5 people in a team and responsible for all modification
delivered by them.
. Maintained the code quality by reviewing the code written by others.
. Involved in documenting the application for maintenance.
Environment: PKMS, AS/400, OS/400, RPGIV, CL/400, SDA, DBU, PDM, DB2400,
Query400, SQL400, MQ Series & Aldon - Turnover
HSBC Middle East, Pune - India
Mar 2007 - Sep 2007
Role : Programmer Analyst/Team Lead
Domain: Banking (Retail)
HUB is an acronym for HSBC Universal Banking - proprietary banking software
of the HSBC Group. HUB is a common collection of computer programs that
supports a wide spectrum of banking and investment activity, meeting
diverse customer demands.
HUB helps us to streamline our back office activities. It keeps internal
accounts, performs straight through processing, and provides management
information through interfaces with other Group systems. It provides
interfaces to external systems, such as SWIFT and the Credit Card
associations. It is a multi-currency, multi-entity, multi-language system,
and can therefore support the Group's banking activities in virtually any
country.
The Project involves up-gradation, modifications and development of the HUB
System. Modifications such as new report generation programs, Adding new
programs for implementation of new business requirement, Implementation of
the application for different sites (Countries), implementing site-specific
local amendments.
Responsibilities: As a Team Lead/Programmer my role included the following
tasks:
. Understanding user requirement.
. Estimating Efforts & Supporting UAT.
. Creating High & Low level Design documents.
. Extensive Coding, testing and debugging of programs in RPG ILE and CL.
. Responsibilities included making changes in the programs using the
Display files and Sub Files.
. Analyze the programs and extract the logic.
. Provided the Support for analysis and documentation.
. Releasing Source/Objects to Production Server & Post Release support.
. Maintaining WSR & Task Tracking Sheet.
. Mentoring & Training.
Environment: AS/400, OS/400, RPGIV, CL/400, SDA, DBU, PDM, DB2400,
Query400, SQL400 & MQ Series.
MISS (Marketing Information & Statistical System) Pune - India Mar
2006 - Mar 2007
Role : Tech Lead Domain :
MFG & SCM
The SKF Group is the leading global supplier of products, customer
solutions, and services in the business of rolling bearings and seals.
SKF has 100 manufacturing sites distributed all over the world. With its
own sales companies in 70 countries, supported by some 15 000 distributors
and dealers worldwide, its e-business marketplace and global distribution
system.
SKF - LDW/MISS (Local Data Warehouse/ Marketing Information and Statistical
System)
The purpose of the Data Warehouse system is to supply sales information as
up to date as possible in an open data warehouse for access from several
tools.
LDW is a Data Warehousing system based on the IBM iSeries (AS/400)
Platform. It is used to store historical sales figures and is the master
system for sales information in SKF's internal reporting. MISS is a set of
OLAP Cubes created with the Cognos PowerPlay software on PC platform.
The task involved development and maintenance of RPG / CL programs on IBM
iSeries, creation of cubes using Cognos Powerplay, global deployment of new
installations of LDW / MISS on iSeries and PC, error handling and user
support.
Responsibilities: As a Team Lead my role included the following tasks:
. Creating High & Low level Design documents.
. Collating various User Requirements (Specifications) and converting them
to Design
. Responsibilities included creating new cubes on COGNOS Transformer &
installing COGNOS applications
. Analyze programs and extract the logic.
. Mentored 3 people in a team and responsible for all modification
delivered by them.
. Maintained the code quality by reviewing the code written by others.
. Responsible to solve all the technical issues related to Cognos
Reporting.
. Maintaining WSR & Task Tracking Sheet.
. Involved in documenting the application for maintenance.
Environment: AS/400, OS/400, RPGIV, CL/400, SDA, DBU, PDM, DB2400,
Query400, SQL400,VB 6.0, Implementer, SYNON, COGNOS - Powerplay,
Transformer & Impromptu.
Kroger West, Hyderabad - India
Jul 2005 - Mar 2006
Role : Team Lead/Programmer Analyst Domain:
Retail/Hospitality
The applications at Kroger West is based on a JD Edwards software package
that has been heavily modified to meet certain business demands. It also
contains many custom build modules to facilitate processing that isn't
readily available in the based package. The system produces approx 90,000
checks on weekly basis and another 5,000 checks on semi-monthly basis.
Autodater :
JDEdwards Payroll system at Kroger West is a menu driven system with heavy
usage of dynamic processing options and data selections in Dream Writers
and World Writers that are dependent on dates for processing or selecting
data. There are a great number of jobs involved on a weekly basis (when
bulk of payroll has completed running) which would mean a massive tedious
manual effort to update the dates on a weekly basis with the great
possibility of error. Therefore a programmatic solution was created to
handle this task called Autodater.
15+ other enhancement in payroll & Inventory Management application that
includes Design, coding & testing
Responsibilities: As a Programmer my role included the following tasks:
. Understanding user requirement & Preparing technical specifications
. Analyze Programs & Extract Business Logic.
. Estimating Efforts & Supporting UAT.
. Collating various User Requirements and converting them to Design.
. Identifying, isolating, troubleshooting and reporting on problems.
. Extensive Coding, testing & debugging of programs in RPG IV and CL.
. Adding new programs to the menu, developing functionality changes -
Reports/inquires.
. Making changes in the programs using the Display files and Sub Files.
. Provide Support for analysis and documentation.
. Maintained the code quality by reviewing the code written by others.
. Involved in documenting the application for maintenance.
. Involved in the defect log process.
. Production Support (24X7)
. Worked as onsite coordinator
Environment: JD Edwards Payroll & Inventory Application, AS/400, OS/400,
RPGIV, CL/400, SDA, DBU, PDM, DB2400, Query400, SQL400, Hawkeye &
Implementer.
Electrolux - UK Application Maintenance/Support, Pune - India Oct
2003 - Jun 2005
Role : Programmer Analyst Domain : MFG &
SCM
Electrolux UK uses PRMS as the ERP for their business support apart from
various other applications like JBA, CreatePrint etc. As part of the team
for application maintenance, knowledge transition, responsibility
transition and steady state phases were performed. The application support
scope included application maintenance, enhancements and third level
support for all applications for UK.
QES - Quality Evaluation System:
The Quality Evaluation System (QES) is the Electrolux Group's standard
system for quality reporting and service claims analysis. It is fed with
data from the Electrolux's markets and in turn offers the markets
possibilities for analyzing the data, and provides the means which form the
basis for the "best practice" quality improvement programs.
To extract the required data, run validation routines to ensure data meets
QES requirements. Produce reports of extracted information and/or exception
reports of those failing validation. Supply a maintenance routine for
assigned user to correct errors, and maintain fault tables etc. Create a
transmission routine for extract file to be sent via FTS2
Responsibilities: As a Programmer my role included the following tasks:
. Collating various User Requirements and converting them to Design.
. Coding, testing and debugging of programs in various languages including
RPG IV and CL.
. Creating Test Cases and Supporting Testing (Unit/Integration).
. Responsibilities included making changes in the programs using the
Display files and Sub Files.
. Mentored 2 people in a team and responsible for all modification
delivered by them.
. Maintained the code quality by reviewing the code written by others.
. Involved in documenting the application for maintenance & defect log
process.
. Maintaining WSR & Task Tracking Sheet.
Environment: PRMS, JBA, AS/400, OS/400, RPGIV, CL/400, SDA, DBU, PDM,
DB2400, Query400, SQL400.
SQM/400 India Pvt. Ltd., Pune, India
Jul 2002 - Sep 2003
Role : Software Engineer/Technical Trainer.
As a team member designing, coding, testing and maintenance of some of the
projects.
Geologistics Inc.: Warehousing Company in UK for cargo reservations for
various European airlines.
Team members - 4
Duration - 4 Months
My role was to modify existing screens and reports using SDA and RLU as
user the Specification and Modify program as per the modifications and test
it.
Onyx Inc - An Environmental Services company in US.
Team members - 4
Duration - 3 Months
My role was to convert all the numeric fields to alpha-numeric fields and
test the programs to check if it Works as it used to do earlier.
UStaad Inc. - Warehousing project for major distributor of electrical parts
and supplies in US.
Team members - 4
Duration - 4 Months
My role was to write a utility program to find out the garbage data of
pipelines which was existing in the Data, print out a report of the
location of the garbage data and if needed remove it.
Responsibilities: As a Programmer my role included the following tasks:
. Providing/delivering theoretical training to candidates & assisting
them in Lab during hands on.
. Understanding user requirement & Preparing technical specifications
. Creating Test Cases & Testing (Unit/Integration).
. Extensive Coding, testing and debugging of programs in RPG IV and CL.
. Adding new programs to menu, developing functionality changes -
Reports/inquires using RPG400.
. Involved in documenting the application for maintenance.
Environment: AS/400, OS/400, RPGIV, CL/400, SDA, DBU, PDM, DB2400,
Query400, SQL400.
Stork Electronic Pvt. Ltd., Pune, India
Aug 2000 - Jun 2002
Project : Stores Management System
Role : Programmer Analyst
Project Summary:
The objective of the system was to maintain records of the Stores Inventory
of the Sugar Factory. Maintain the record right from the demand of the item
from the various departments, if the material is available in stock then
generate an issue slip else generate an inquiry against the demand.
Generation of the comparative statement depending on the quotations
received from the vendors. Generate purchase order; goods receipt note,
credit note generation, and inspection report. Call validations to minimize
the over issue of stock and maintain the inventory. Maintain Security at
User as Well as Data Level.
Responsibilities: As a Programmer my role included the following tasks:
. Collating various User Requirements (Specifications) and converting
them to System Design.
. Designing of the system right from Analysis to File Design.
. Created Database Structure (Tables and Views) in Oracle.
. Developed User Interface in Visual Basic with all validations and
necessary Reports.
. Done extensive Coding, testing and debugging of programs using Visual
Basic 6.0.
. Testing of the System.
. Provided online help of Stores to the end-user
. Involved in documenting the User Guide & System Guide.
. Implementing the Package at Client Locations/Sites and supporting them
for First 3 Months of Implementation.
Environment: Windows NT, Visual Basic 6.0 & Oracle 8i