Project Software

Gurveen Singh Sohal 224-***-****

PROFESSIONAL EXPERIENCE : Having more than 7 years of experience in Software industry in the area of AS/400 i-Series.

Summary of Experience:

An AS/400 Professional having experience of more than 7 years in software development, design, coding, and testing. Having hands on experience for full project life cycle.

Technical Activities – Involved in requirement analysis, design & development, implementation, code reviews, system and user acceptance test supports, maintenance, and technical support to the team members.

Main Work Areas IBM AS/400 –RPG, RPGLE and CLLE, SYNON.

Certifications IBM RPGLE certified Professional,

MSSQL 7.0 Certified,

ITIL certified,

VB 6.0 certified,

C++ certified.

ENVIRONMENT FAMILIAR WITH:

HARDWARE. : IBM PC COMPATIBLES, IBM AS/400.

OPERATING SYSTEMS. : OS/400, WINDOWS XP, NT, 2000 SERIES

UTILITIES / TOOLS. : SYNON, ALDON, REMEDY, EZVIEW, APLUS,

ESEND, YWRKF, SEU, DFU, SDA, RLU, OPNQRYF, QUERY/400, SQL/400, SCHED, ROBO and Crystal Reports 11.0, stored procedures.

LANGUAGES. : RPG/400, ILE RPG, SQLRPGLE, ILE CL, VB 6.0,

Core JAVA.

BACK END. : DB2/ 400, MSSQL, PL/SQL, ACCESS

FUNCTIONAL AREAS. : PBM, Retail, Inventory, Media & Entertainment and Textile.

Project’s Description:

Client/Company : CVS US / Galaxesolutions

Module : PBM – Business Process Loader

Description : CVS is one of largest Rx drug stores chain in USA with more than 7500

Stores across US. BPL is one of the module in which I am currently working to maintain the plans for the various client, carrier and members. We are currently involved in removing the RECAP PBM system and replacing it to Rx claim system which is the PBM system for adjudications.

PROJECTS

1.

Project : BPL

Time Period : Nov 2011 to Till Date.

Team Size : 20

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, TELXON Guns, Windows 2000

Software/Tools : RPG400, RPGLE, CLLE, Stored Procedures.

Role : Team Lead [Sr. Analyst/Programmer].

Project Description : Enhancement to RX claims process. Now we changed the process to remove the exiting PBM system to existing one. It involves converting all the hierarchy from RECAP system to the Rx Claim system. Also, same enhancements are applied to the PBM systems of RX Claim.

Client/Company : Walgreen’s US

Module : SIMS (Strategic Inventory Management System)

Description : Walgreen’s is one of largest RETAIL chain in USA With more than 7800

Stores. SIMS is one of the module in which I am currently working to maintain inventory at each Walgreen store across USA. There are many ways for finding items which require getting order like Forecasting, Seasonal sales etc. So, accordingly store acquires those items by different methods viz.:

1. Placing Direct Orders,

2. Inter-Store Balancing

3. Claims – [RX Claims, Vendor Claims, Warehouse Claims, CL Claims etc…]

4. Automated orders

5. Orders from 340B government vendors.

So, that minimum shelf quantity can be maintained at Plano-gram link level. Vendors then send the actual merchandise which store receives it and update the inventory. At the same time store also Post the order so that amount should get dispersed to the vendor by A/P department.

PROJECTS

1.

Project : RX Claims Enhancements.

Time Period : Feb 2011 Till Date.

Team Size : 15

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, TELXON Guns, Windows 2000

Software/Tools : RPG400, ILE, CLLE

Project Description : Enhancement to RX claims process. Now we changed the process to introduce three options for claiming RX items. 1. RECALL 2. SALVAGE and 3. OVERSTOCK. Item information will be controlled by business users from central server and they will send down the items to stores for claiming. Every Friday reports will be generated for items going to get expired next Friday.

Options are given on both RF Guns and the AS400. My role here is to lead the project, do the requirement gathering and coordinate with offshore team. Also, data communication now is being changed from old upload download process to NAI process which is far more advance and reliable.

2.

Project : Receiving Enhancements.

Time Period : Jul 2010 - Jan 2011.

Team Size : 8

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software/Tools : RPG400, ILE,CLLE, Stored Procedures.

Project Description : Enhancement to pay the vendors which are

Electronic invoice capable properly. Currently stores do not post their invoices and

Vendors are not getting their payments on time.

3.

Project : Suspension File.

Time Period : Aug 2009 to Jun 2010.

Team Size : 5

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software/Tools : SYNON, RPG400, ILE, CL400

Project Description : Enhancement to allow scanning those cases as well

For which we have not received the ASN (Advance Shipment Notice) yet. Project mainly

Emphasis on enhancing the current business. Till date we are not scanning those cases

Containing items for which we have not received ASN from respective vendor. That ship

List remains suspended till we don’t receive ASN. But now user wants us to change the

Scenario and allow them to accept the items and update the inventory even though ASN

Has not been received.

4.

Project : Enhancement for items having saleable on-lies GT 1.

Time Period : Feb 2009 to Jul 2009.

Team Size : 12

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software/Tools : RPG400, ILE, CL400

Project Description : Enhancement for items having saleable on-lies GT 1.

Project mainly emphasis on enhancing the current business where we have changed the

Calculation and flow of the screens totally for incorporating the change for saleable on

Lies greater than one which means items which can not be sold on individual basis.

5.

Project : 340B Vendors

Time Period : Aug 2008 to Jan 2009.

Team Size : 14

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software/Tools : RPG400, CL400, Stored Procedures.

Project Description : Enhancement for 340B vendors. It is a new

Introduction to vendor types. Project mainly emphasis on enhancing the current

Business. Before this change stores use to order the items in normal way but sometimes

It may happen that government vendors also send stores items specially drugs which are

Free of cost to customer. But here stock becomes Surplus so hence to reduce this we

Implemented this project.

Role & Responsibilities : Team Lead & Analyst.

Feasibility study: To come up with the fair idea of how to implement the changes for all the modules being affected due to any change. To estimate the work effort required for successfully completion of the project in man hours.

Analyzing and Designing: After all the requirements gathering analyzing was done a detailed design for the change was prepared. This document includes mainly changes to be done for various modules.

Coding and Testing: Coding and unit and system testing was done for same accordingly to the work break down structure.

Client/ Company : EMI Music US

Module : Royalty Systems.

Description : EMI Music is a Media and Entertainment industry base in UK.

Spreading across the globe. Royalty is one of the module in which we were working and basically. This module covers the calculation of royalty to be paid to the various Artists when their respective albums are released in the market. It also covers the internet sold copies calculations.

PROJECTS

1.

Project : License Recoupment.

Time Period : 10th Apr 2008 to Jul 2008.

Team Size : 3

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software/Tools : SYNON, RPG400, ILE, CL400

Project Description : To recoup the amount this was paid to wrong

License for some specific reason. Project mainly emphasis on changing the current business scenario. We need to recoup the money from the license which was paid to the artist due to some reason.

Role & Responsibilities : Team leader.

Feasibility study: To come up with the fair idea of how to implement the changes for all the modules being affected due to this particular change. Modules like UPLOAD, CALCULATION, GL, PL, AL and Statement were being affected. To estimate the work effort required for successfully completion of the project in man hours.

Analyzing and Designing: After all the requirements gathering analyzing was done a detailed design for the change was prepared. This document includes mainly changes to be done for Upload, Calc and statement module. Screen designing was done after a brief meeting with client and users as well.

Coding and Testing: Coding and unit and system testing was done for same accordingly to the work break down structure.

2.

Project : Admin Change in MRS.

Time Period : 15th Nov 2007 to Apr 2008.

Team Size : 5

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software/Tools : SYNON, RPG400, CL400, Stored Procedures.

Project Description : To do the Admin change from one contract to other. Project mainly emphasis on changing the current business scenario. We need to end up any contract and create a new contract for different or same royaltor account for this case as a change in MRS. ARS and MRS stands for Artist/Mechanical Royalty System which is complex system and handles mainly calculation and statement generation part for the beneficiaries.

Role & Responsibilities : Team leader, Onsite coordinator in NY, USA.

Feasibility study: To come up with the fair idea of how to implement the changes for all the modules being affected due to this particular change. Modules like UPLOAD, CALCULATION, GL, PL, AL and Statement were being affected. To estimate the work effort required for successfully completion of the project in man hours.

Analyzing and Designing: After all the requirements gathering analyzing was done a detailed design for the change was prepared. This document includes mainly changes to be done for Upload, Calc and Mass Admin changes Screen. Screen designing was done after a brief meeting with client and users as well. Designing includes preparing of 5 display screens and coding change of 7 upload programs and 6 calculation programs including the change of statement.

Coding and Testing: Coding and unit and system testing was done for same accordingly to the work break down structure.

3.

Project : Digital Downloads Calculation in MRS.

Time Period : 4th June 2007 to Nov/2007.

Team Size : 5

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software/Tools : SYNON, RPG400, CL400, Stored Procedures.

Project Description : To do the Digital Download. To allow the calculation for the Digital Downloads. Currently there is no such way exists for calculating the royalties for the Digital Downloads products such as Ring Tune and Ring Back processing.

Role & Responsibilities : Analyst/Programmer, Onsite coordinator in NY, USA.

Feasibility study: To come up with the feasibility study of the project and impact on the various modules being affected. Total of 7 different programs of calc were affected, 2 of upload, 3 for statement and 4 for auditing.

Analyzing and Designing: After all the requirements gathering analyzing was done a detailed design for the change was prepared. This document includes mainly changes to be done for Upload, Calc and Mass Admin changes Screen. Screen designing was done after a brief meeting with client and users as well.

Coding and Testing: Coding and unit and system testing was done for same accordingly to the work break down structure.

4.

Project : Retrieving CLLE source from CLLE object.

Time Period : 19th March 2007 to 2nd April 2007.

Team Size : 3

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software : CLLE, RPGLE.

Project Description : To retrieve the CLLE source from CLLE object. There is always needed of such tool to retrieve the source from the deleted object. So from this prospective we developed this code. Dump of the given object is taken and then from the given dump we again regenerate the code.

Feasibility study: To come up with the study of various dump code generated for different CLLE code. Marking the start and end of each statement in the code. Handling the declaration of file in CLLE.

Analyzing requirements: Here we define our predefined tasks like how to write the new member, designing the input screen for the user, validating the inputs from the users like checking for the object existence, type of file, library and the source PF in which it was created. We have also used some API’s like QUSLOBJ from here we have extracted the originating source file name and the library name.

Coding and Testing: Coding phase includes the free formatting style of RPGLE. And the RPGLE standards are also followed. Unit test cases and unit test reviews are created side by side after the completion of each module of the project. Final project testing will be done at last.

5.

Project : Spool to PDF Generation

Time Period : 20th December 2006 to 16th March 2007.

Team Size : 5

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 2000

Software : CLLE, RPGLE, User Space.

Project Description : To Create a PDF file from a SCS spool file. Generating a PDF document from the spool file by using a user space. Spool File API’s have been used to get the attribute of the spool file to a data structure from where we can get the number of pages, buffers to store data etc. Inbuilt Modules of IFS like OPEN CLOSE WRITE UNLINK are used to write a PDF File.

Role & Responsibilities : Team Lead.

Analyzing requirements: Basic requirements for the spool file like spool file attributes, creation of user space, defining the end Control characters for the spool file in the user space.

Making use of the binding directory QC2LE for the use of the procedures like write, unlink, atoi, itoa. Making use of different procedures for handling the XML coding for the PDF file.

Making procedure for how to convert the EBCDIC code for the AS400 system to the ASCII format of the PDF file.

Coding and Implementing: Coding includes the modulating every parts of the programs. Every function has been divided into sub procedures like for writing the header information for the PDF file we use WriteHeader, for detail format we use WriteDetail and so on. Various API’s like QSPCRTSP Creating the spool file, QSPOPNSP Opening up the spool file, QSPGETSP Getting the data from the spool to user space, QSPCLOSP Closing the spool file, QUSCRTUS Creating the user space, QUSDLTUS Deleting the user space, QUSPTRUS Making the basing pointer to the user space, QUSRSPLA for getting the spool file attribute, QMHSNDPM for message handling. Command has also been created for the SPL2PDF converter.

Client/ Company : Birla VXL Limited (Birla)

Module : Chalaan and Retail Shopping

Description : Birla VXL is a manufacturing unit in India formerly known as OCM. It

Mainly deals with manufacturing of fiber/yarn and distributing to the various other companies across the globe. Mainly have high standard in Suiting and Shirting’s.

Module in which I was working was of Chalaan printing and retail shopping.

PROJECTS

1.

Project : Challaan Printing

Time Period : 9th September 2006 to 21st October 2006

Team Size : 14

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows XP.

Software : CLLE, RPGLE, DB2/400, SQL/400.

Project Description : Project mainly deals with printing of challaan for different firms, which buy the twisted threads from our organization. Challaan for the different firms like Digjam, Raymond, and Arvind mills are produced sequentially after the request to dispatch twisted threads is received. RRN reference order number is taken as key with the date and each firm is assigned a different code. Every time when request is made, next RRN is generated. SQLRPGLE get the next number. At Bottom of every challaan totals are given and at the end of the order, Grand totals are shown to the clients for simplicity of payments.

2.

Project : Wages System/Leave Benefit System

Time Period : 24th Apr 2006 to 22nd August 2006.

Team Size : 3

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows XP

Software : CL/400, CLLE, RPGLE, DB2/400,

SQL/400, SQLRPGLE.

Project Description : To calculate the wages for workers depending on picks produced by them on different machines and rate per hour of that machine. Our main concern was on the generation of salary depending on the hours worked, picks produced per machine, machine type like DORNIER, SULZER, PICANOL with their varying speed, night shifts and section in which they were working. Continuation of shifts gives an extra benefit to the worker. Also, calculation of the total yearly attendance, remaining leaves, their CLW, ALW, SLW, LTA, absent and their total amount for the leaves not availed.

3.

Project : Generation of labels

Time Period : 3rd April 2006 to 22nd April 2006.

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows XP

Software : CL/400, RPG, DB2/400

SQL/400, SQLRPG.

Project Description : This project covers up the printing of the labels to be used for the cones to dispatch. These labels are of varying size. These includes the complete definition like weight of cone, shade, color, tare weight, net weight, date of dispatch, date of manufacturing, order number etc.

4.

Project : Stock, Opening, Closing maintenance & RMPD

Time Period : 3rd Jan 2006 to 20th March 2006.

Team Size : 3

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 98

Software : CL/400, RPG, DB2/400,

SQL/400, SQLRPG.

Project Description : Mainly maintenance work was there for the project. Some of the new reports that were needed by the management were generated.

RMPD was an in-house project, directed towards designing an internal product to calculate the raw material purchased (that is wool) from various dealers.

Reports : Generating Ledgers, Weekly, Monthly, Yearly reports for the cost incurred to the company. Quantity of wool purchased, GRN cost, VAT calculation etc. are also calculated. Crystal Reports have also been used with AS400 through DSN Connection for the quick exporting of reports to different formats.

5.

Project : Retail Shop Billing.

Time Period : 9th November 2005 to 2nd January 2006.

Environment (Software, Hardware & Tools & Design Methodologies used)

Hardware : IBM AS/400, Windows 98

Software : CL/400, RPG, DB2/400,

SQL/400, SQLRPG.

Project Description :

The project is an in-house project, directed towards designing an internal product to generate the bill for the customers who have purchased any item from the shop. Bills include FULL, CUT and DEBIT bills. Each type is having a unique bill number generated every time for a new bill.

Reports : Generating Ledgers, Weekly, Monthly, Yearly reports for the sale done. Reports on sale for every type of bill. In Case of debit Bills the amount standing towards the customer etc. Crystal Reports have also been used interacted with AS400 through DSN Connection for the quick exporting of reports to different formats.

MIS/User Reports - Concerned with generation of reports providing information about daily, weekly, and monthly dispatched cones grouped by color, Blend etc.

Role & Responsibilities : Team Member. Analyzing requirements, developing code and implementing it.

PERSONNEL PROFILE

EDUCATION : B.Tech. In Computer Science and

Engineering from Government College,

Gurdaspur, Punjab (With Honors)

CONTACT : 224-***-****

************@*****.***

***********@*****.***

Contact this candidate