AS/400
Resume:
Prakash Palanisamy Shanmugam [pic]
E-Mail id *********@*****.***
Visa Status Green Card
EXPERIENCE PROFILE
. Extensive experience in Requirement Gathering, Analysis, Design, Coding,
Testing, Deployment & Production Support
. 4+ years of work experience in USA to implement high quality software
through effective process improvement
. Strong requirement gathering, gap analysis skills resulting in higher
value to the overall business application software
. Proficient in analyzing and translating business requirements to
technical requirements and architecture.
. Provide effective solutions for complex business requirements through
software development methodologies
. Involved in various phases of the testing cycle such as Unit, Functional,
System Integration, User Acceptance and Regression
. Proficient in programming languages like RPG, RPGLE, CLP, CLLE, Free Form
RPG and having good experience in AS400 tools like SYNON (Advantage:2E),
Turnover, Aldon, Implementer and Hawkeye.
. Extensive experience in DB2/400, SQL/400 & Query/400
. IBM Certified Database Associate - DB2 Universal Database V8.1 Family.
. IBM Certified Application Developer - DB2 Universal Database V8.1 Family.
. Strong leadership and successful team building capabilities and excellent
technical, communication, presentation & customer service skills
. Project planning, execution, monitoring and resource balancing skills and
supporting multiple simultaneous projects in a matrix organizational
structure
. Ability to work independently as well as in a team with responsibility.
. Awareness of the Software Processes involved in a CMM Level 5 company.
Employment history
Working as a Senior Associate at Cognizant Technology Solutions
Dec 2010 - present.
Worked as a Senior System Engineer at IBM India Pvt. Ltd.
Aug 2004 - Dec 2010.
Worked as a Software Engineer at US Software Pvt. Ltd.
Jun 2002 - Jul 2004.
Technical skills
Technology AS400
Language RPG, RPGLE, Free Form RPG, CLP, CLLE, DDL, SQL/400,
Query/400, COBOL/400
Operating System OS400, Windows, Unix
Database DB2/400, Oracle
Tools/ Utilities SYNON, Turnover, Hawkeye, DBU, WRKDBF, Aldon, Implementer,
ROBOT
Processes IBM's QMS (Quality Management System), Cognizant's C2.0
Specialized in
Application/Functional Healthcare, Retail, Finance
areas/Packages worked
on
Types of projects Development, Maintenance, Support & Enhancement,
worked on Migration
Environments worked on AS400
Environments exposed Mainframe
to
Languages/Tools worked RPG, RPGLE, CLP, CLLE, Free Form RPG, COBOL/400, DB2/400,
on SQL/400, Query/400, SYNON, Turnover, Aldon, Implementer,
Hawkeye, DBU, WRKDBF
Languages/Tools C, C++, VB, VC++, Oracle, Java, IMS DB, IMS DC, CICS,
exposed to JCL, HTML, ASP
Education
Course Institution Course Grade/Percentag
Period e
1997 - Bharathiar Bachelor of Engineering in 85%
2001 University Electrical and Electronics
Training Details
Organization Cognizant Technology Solutions
E-mail Etiquette
Effective Business Communication Skills
Counseling
Presentation Skills
Workshop on Cognizant 2.0
Core Values and Standards of Business Conduct
Acceptable Use Policy (AUP)
Understanding Privacy
CMMI High Maturity Practices
Dynamic Presenters
Risk Management
Harassment Prevention and You
Secure Coding Practices
Problem Solving and Decision Making
Winning by Influencing
HIPAA/HITECH Privacy & Security
Occupational Health and Safety Assessment Series (OHSAS)
Merchandizing
Retail Foundation Course
Organization IBM India Pvt. Ltd.
Inspections and Reviews
Estimation Techniques
Defect Prevention & Causal Analysis
Configuration Management
Communication Skills
Leadership Skills
Customer Interaction Skills
Interpersonal Skills
Testing Methodologies
QMS (Quality Management Systems)
Implementer
Aldon
SYNON
Java on AS/400
RPM (Rational Portfolio Manager)
Organization US Software Pvt. Ltd.
Software development life cycle (SDLC) - Waterfall
IBM AS/400 Concepts (RPG/400, RPGLE, CL/400)
Defect Prevention & Causal Analysis
Configuration Control
Project Metrics
Conducted AS400 training
Turnover
Hawkeye
Project Details - Cognizant
Project 3 Way Match (One of the Leading Pharmacies, US)
Team Size 30
Role Onsite Technical Lead (US)
Responsibilit Involve in the following activities:
ies - Gather requirements from Business
- Review the Schedule & Estimation from offshore
- Convert the Business Requirements to Technical specifications
- Coding & Testing
- Review the offshore deliverables
- Guide the team technically
- Prepare & co-ordinate the weekly status reporting
Environment SYNON, RPG, CLP, COBOL/400, RPGLE, CLLE, Free form RPG, DB2/400,
Implementer
Job This initiative will enhance client's current vendor catalog
description maintenance application by having cost updated in central catalog
in timely manner and to address short term enhancement to have cost
flow down to the stores on timely manner. Also track all cost
discrepancy issues (related to vendor cost update delay, rejections
and user approval delay) to Business, so that corrective action can
be performed to resolve cost discrepancy issues.
Project Catalog File Transfer (One of the Leading Pharmacies, US)
Team Size 30
Role Onsite Technical Lead (US)
Responsibilit Involve in the following activities:
ies - Gather requirements from Business
- Review the Schedule & Estimation from offshore
- Convert the Business Requirements to Technical specifications
- Coding & Testing
- Review the offshore deliverables
- Guide the team technically
- Prepare & co-ordinate the weekly status reporting
Environment SYNON, RPG, CLP, COBOL/400, RPGLE, CLLE, Free form RPG, DB2/400,
Implementer
Job Servicing both pharmaceutical manufacturers and healthcare
description providers, the new vendor company provides drug distribution and
related services designed to reduce costs and improve patient
outcomes. This vendor will be replacing the existing vendor, as the
wholesale supplier of medicines to the pharmacies. The objective of
this enhancement is to replace the Catalog cost data of the
existing vendor with new vendor.
Project Customs Information for Domestic Items (One of the Leading
Pharmacies, US)
Team Size 30
Role Onsite Technical Lead (US)
Responsibilit Involve in the following activities:
ies - Gather requirements from Business
- Review the Schedule & Estimation from offshore
- Convert the Business Requirements to Technical specifications
- Coding & Testing
- Review the offshore deliverables
- Guide & mentor the team functionally & technically
- Prepare & co-ordinate the weekly status reporting
Environment SYNON, RPG, CLP, COBOL/400, RPGLE, CLLE, Free form RPG, DB2/400,
Implementer
Job The client was planning to open the new stores in St. Thomas
description Islands. Cognizant is working with the client to extend the Customs
related functionality applied for import items to domestic items
that are to be sourced outside US (St. Thomas Islands as of now)
Project WIC Deletion (One of the Leading Pharmacies, US)
Team Size 30
Role Onsite Technical Lead (US)
Responsibilit Involve in the following activities:
ies - Gather requirements from Business
- Review the Schedule & Estimation from offshore
- Convert the Business Requirements to Technical specifications
- Coding & Testing
- Review the offshore deliverables
- Guide the team technically
- Prepare & co-ordinate the weekly status reporting
Environment SYNON, RPG, CLP, COBOL/400, RPGLE, CLLE, Free form RPG, DB2/400,
Implementer
Job The client's Item code is six digit number that uniquely identifies
description an item within the system. Typically an item code will be created
if an item needs to be inventoried, planogramed or advertised. To
meet the demands of client's steady growth and acquisitions,
Business have been defining more items on the system than ever
before. Given the limitation on the size (6 digits) there is a
potential risk of exhausting the available item codes in the near
future. The project's objective is to delete and reuse the inactive
Item codes so that there will be a healthy pool for new item
definition.
Project Details - IBM
Project RxClaim Application (CVS Caremark, US)
Team Size 25
Role Offshore Team Lead / Onsite Co-ordinator (US)
Responsibilit As an offshore team lead, the following were the responsibilities:
ies - Converting the Business Requirements to Technical specifications,
Development, Testing, Schedule & Estimation
- Also involved in Guiding the team technically, Preparing,
co-ordinating the weekly status reporting, Allocating work
As an onsite co-ordinator, the following were the responsibilities:
- Involved in analyzing the Business requirements and converting it
to Technical specifications, Development, Testing, Implementation,
Schedule & Estimation, Reviewing the offshore deliverables
- Also involved in Guiding the offshore team technically, Tracking
and monitoring project status activities, co-ordinating the weekly
status reporting
- Involved in the Production support activities.
Environment SYNON, RPG, COBOL/400, RPGLE, CL, Free form RPG, DB2/400, Aldon,
Hawkeye, VB Recap
Job RxClaim application which is a Claim processing engine used for
description Adjudication of Medical and Pharmacy Claims and payments against
Eligibility, Plan Benefits, Formularies, Price, DUR and
Prior-Authorization. IBM supports Caremark to comply with HSA
Legislation, CMS regulations and HIPAA guidelines, by converting
the High level Business requirements into the detailed Technical
Specifications, Development and Testing. Also the Production
support is given when required.
Project Revenue Code Expansion (Healthnet, US)
Team Size 5
Role Senior Developer
Responsibilit Schedule & Estimation, analyzed the Business requirements and
ies converted it to Technical specifications, Coding, Testing &
Implementation. Tracked and monitored project status activities,
prepared & co-ordinated the weekly status reporting.
Environment RPGLE, CLLE, Free Form RPG, RPG/400, CL/400, DB2/400, Implementer
Job This project change is to upgrade MC400 inpatient, outpatient and
description encounter claims to four-character revenue code from
three-character revenue code. This requirement is in compliance
with the industry standard. Technical Design Documents have to be
prepared from the given Business Specifications Document and then
Coding, Unit Testing of code will be continued.
Project Handleman - Hito (Handleman, US)
Team Size 30
Role Senior Developer
Responsibilit Analysis, Coding, Testing & Production Support. Also involved in
ies Quality control activities, by preparing the metrics for the
project.
Environment RPGLE, CLLE, Free Form RPG, RPG/400, CL/400, DB2/400, Aldon, WRKDBF
Job To develop and implement an integrated, flexible business
description environment that will enable the organization to achieve strategic
growth through a focus on the client's internal and external
customers mainly for the music items distribution. Technical
Specifications have to be prepared from the given Functional
Specifications and then Builds, Enhancements, Conversions,
Interfaces, Unit Testing of code, Integration Testing, User
Acceptance Testing will be continued. The Production system has
also been supported by solving the tickets raised by the users.
Project IRFS (International Remarketer Financing System) (IGA, US)
Team Size 17
Role Developer
Responsibilit Business Study, Development, Testing, Support and Enhancement,
ies Meeting Co-ordinator, AMT-WST (Asset Management & Work Station
Security) in charge, Quality control activities by preparing the
metrics for the project
Environment SYNON, RPG, SQL/400
Job IRFS is International Remarketer financing system. IRFS is a dealer
description financing system designed specifically for Financiers and Suppliers
(Distributors) who sell their products through a network of Dealers
(Remarketers). It is the solution to control and manage financial
transactions related to dealer financing. The Financier funds the
Dealer's acquisition of product from the Supplier. The Financier
pays the Supplier for the product supplied, and then the Dealer
owes the value of the product to the Financier. This application is
developed in Synon. The Improvement Requests had been raised by the
client in case of any problem in the Application. And they had been
resolved either by enhancement or development according to the
need.
Automating FP Calculation
The tool automates manual procedure of calculating the Function
Points for each release. It gets the program names as input in a
text file and all the files used in each program will be listed in
an individual spool file according to its usage (whether it is in
Input/Output/Update mode).
Project Heinz Migration (Heinz, UK)
Team Size 20
Role Developer
Responsibilit System Study, Business Study, Support and Enhancement work
ies
Environment RPG, RPGLE, CL, CLLE, Query/400
Job Client would like to migrate the whole AS/400 Application to
description Offshore. Gone to the client place (UK) for a month to study and
transfer the knowledge on Business and Technology. Solved the Work
requests which come under support and enhancements.
Project Details - US Software
Project Canadian Payroll (COSTCO Wholesale, US)
Team Size 5
Role Project Lead
Responsibilit As a Lead, involved in the following activities:
ies Estimation and Project startup activities.
Doing the Impact Analysis on the Programs and modifying them
Testing and debugging modified programs.
Environment RPG, RPGLE, CL, Hawkeye
Job The client wanted to increase the number of warehouses in Canada,
description so the file fields and variables used to hold the warehouse number
has been expanded from 3 to 5. The Project is basically expanding
the Warehouse fields from Canadian Payroll files of the client
Financial system, from size 3 to 5. And the affected programs are
all modified to accommodate the expansion of the fields and Tested
for their functionality.
The Project is a Zero Defect Delivery and received the
Appreciations from Client and Onsite Lead.
Project GLTRANP Field Expansion (COSTCO Wholesale, US)
Team Size 5
Role Project Lead, Quality Controller
Responsibilit As a Lead, involved in the following activities
ies Preparing proposal for the project.
Estimation and Project startup activities.
Doing the Impact Analysis on the Programs and modification to them
Testing and debugging modified programs.
As a Quality Controller, capturing metrics, ensuring the quality in
the work product and conducting causal analysis for statistical
deviation.
Environment RPG, RPGLE, CL, Turnover, Hawkeye
Job The client was interested to enhance their Accounting systems and
description so they proceeded with expanding the transaction system of the
company. General Ledger Transaction File (GLTRANP) has been
modified to include the new fields and expanding some of the
existing fields like Invoice number, Check number, Location number,
and Vendor number for going into future enhancements. There are 121
programs affected due to this expansion, which are also taken care
in this project and the modified programs are undergone a
functionality testing.
The Project is a Zero Defect Delivery and received the
Appreciations from Client and Onsite Lead.
Project Audit tool (COSTCO Wholesale, US)
Team Size 9
Role Developer, Defect Prevention Controller
Responsibilit Analysis and creating tools. Defect Prevention, Causal Analysis for
ies defects.
Environment RPG, RPGLE, CL, Turnover, Hawkeye, SQL/400
Job After the installation of the modified files and programs in the
description Production, the production data of the old and new warehouse
variables are compared for the mismatches. If any discrepancy
found, then the corresponding file will be analyzed for the reason
of mismatch and accordingly the new warehouse variable is populated
correctly. The Audit tool fully automates the above manual
procedure. It gets the file name as input and compares the
production data of old and new warehouse fields, then prints if any
discrepancy found.
Project Field Expansion - Phase II (Program changes) (COSTCO Wholesale, US)
Team Size 9
Role Developer, Defect Prevention Controller
Responsibilit Analysis, Coding and Testing. Defect Prevention, Causal Analysis
ies for defects.
Environment RPG, RPGLE, CL, Turnover, Hawkeye
Job The programs which use the expanded files are being modified to
description populate the new warehouse fields('5' sized) by the old fields('3'
sized). This is done to preserve the value in the old fields. In
future, the old fields could be removed from the file.
Project Installation Schedule Review (COSTCO Wholesale, US)
Team Size 9
Role Developer, Defect Prevention Controller
Responsibilit Analysis, Defect Prevention, Causal Analysis for defects.
ies
Environment RPG, RPGLE, CL, Turnover, Hawkeye
Job The Logical files of the expanded Physical files are analyzed for
description installation. This phase verifies the newly created Logical files
for the Warehouse key fields.
Project Field Expansion - Phase I (File changes) (COSTCO Wholesale, US)
Team Size 9
Role Developer, Defect Prevention Controller
Responsibilit Analysis, Coding, Testing and creating tools. Defect Prevention,
ies Causal Analysis for defects.
Environment RPG, RPGLE, CL, Turnover, Hawkeye
Job The client wanted to increase the number of warehouses in US from
description the existing 3 digit number to 5 digit number in the future. So the
file fields and variables used to hold the warehouse numbers are
expanded from 3 size to 5. This has been divided into 3 phases.
This file changes is the first phase. The program changes come as
the second phase. And the third phase, testing phase is the ongoing
task. In this phase, the files that have the warehouse '3' sized
fields are modified to include the corresponding warehouse '5'
fields. Both the Character and Numeric fields are expanded. Also
created the tool (Tool to Analyze '3A' Fields) to automate the
manual work.
Tool to Analyze '3A' Fields
The tool got the file name as input, and then fetched all the
'3A'('3' sized character) Warehouse fields and checked whether the
field had been expanded to '5'. If expanded, then the corresponding
'5' sized field was also fetched and had been given as output.
Awards Received
> University Rank Holder in Engineering (85% Aggregate)
> Received 'Project Excellence Award' in Retail open house (Cognizant)
> Received client appreciations for delivering the projects on time with
high quality (Cognizant)
> Received the BRAVO Award for single handling the AS/400 Applications
in Handleman Project (IBM)
> Received the Customer Satisfaction Award (IBM)
> Received the "WOW" award given by the account team (IBM)
> Participated in COFFEE BREAK event held at competency level and got
selected as the Best paper (IBM)
> Appreciations from the Client and Organization, for leading to achieve
the Zero-defect delivery (GLTRANP Field Expansion and Canadian Field
Expansion) (US Software)
Certifications
> IBM Certified Database Associate - DB2 Universal Database V8.1 Family
> IBM Certified Application Developer - DB2 Universal Database V8.1
Family.
> Brain Bench certification in AS/400
Achievements
> Coordinated with C2.0 team for tracking of process activities
(Cognizant)
> Involved in TRIAGE Team for Production support (IBM)
> Key member to implement RPM (Rational Portfolio Manager) in Handleman
project (IBM)
> Involved in Defect Prevention, Configuration Control and Metrics
Calculation for the Project Quality (IBM)
> Active member in the AS/400 Technical Interview Panel for IBM
> Member of the LEAN team for Caremark account to improve the quality of
deliverables (IBM)
> Involved in Asset management (IBM)
> Created multiple Tools to Automate the manual work (US Software)
Contact this candidate