Software Contractors' Guild Software Contractors' Guild
View The Contractor's Resume
Current Address:
prem_db2dba@yahoo.com
New York NY USA 1006
E-Mail Address:
Additional Contract Information:
PREMANAND LAXMANAN
Phone: 408-470-4010
prem_db2dba@yahoo.com
Experience Summary
• Over 7+ years of experience on Software Development experience in diversified fields of development, maintenance and testing of Mainframes Related Applications.
• Good exposure to Application Software Development, System Support and Maintenance of Legacy Systems, Business and Functional knowledge of Applications.
• Worked extensively in TSO/ISPF, SPUFI, CICS, COBOL II, JCL, PL/I, DB2 and VSAM.
• Extensively worked with tools like TRACEMASTER, INSYNC, SYNCSORT, DFSORT, BMC, LIBRARIAN, ENDEAVOUR, OMEGAMON, SPUFI, QMF, CONNECT DIRECT, FILE-AID, REXX, EXPEDITOR, PLATINUM and CA-7.
• IBM Utilities - IEBGENER, IEBCOPY, IEFBR14.
• Worked extensively on DB2 Stored Procedures & REXX utilities.
• Good exposure on TABLE CREATION, TABLE ALTER, REORGS, RUNSTATS, and WLM ENVIRONMENT clean up, LOADS & UNLOADS.
• Strong experience on performance tuning of queries through EXPLAIN.
• Strong experience on creating Design documents, Test Case Docs.
• Been part of the Integration Test Team & Regression Test Team.
• Ability to work effectively while working as a team member as well as individually.
• Excellent communication and interpersonal skills.
• Trained new associates joining the project on application knowledge and project procedures.
• Have been nominated for the VERIZON Excellence Award.
• Expertise in usage of Microsoft office soft wares – Word, Excel, PowerPoint, Visio, and Project.
Technical Summary
Languages: COBOL II, REXX, CICS PL/1, JCL, SQL Server, Easytrieve and Rexx.
Hardware: IBM 370/3090, IBM PCs, Extra, Windows 95/ 98/2000/XP/NT
Operating Systems: MVS/XA, OS/VS1, VM/CMS, VSE/SP/ESA, OS 390
Utilities: File-Aid, Endeavor, ELIPS, PANVALET, XPEDITER, ABEND-AID,
SYNCSORT, Focus, CA7, JOBTRAC IDCAMS, RACF, IEBGENER, IEBCOPY,
BMC, OMEGAMON, TRACEMASTER, INSYNC, CHANGEMAN, INFOMAN,
LIBRARIAN, IEFBR14, SQL, SAS, EASYTRIEVE, SAR, DB2-Connect, QMF,
SPUFI, FTP, NDM and Lotus Notes, OUTLOOK,Javescript.
Databases: DB2, IMS, VSAM, SQL Server
Communications: TSO/ISPF.
Experience
Client: CITIBANK, NY Duration: Nov-2005 – Till Date
PROJECT: SCRAMBLER
Role: Mainframe Programmer
Project Description
Scrambling is a process, which used to scramble sensitive client & user information conforming to the security standards. It consists of several process Initial Layout, Delta processing, One-off processing and online access. Through Initial layout the seed database name, address & tax id file are created based on Full Extract files. These extract files are created based on the shrunken Normalized files. Once extract files are created, the data are scrambled and a cross-reference file is created and the address information is updated.
In One-off processing the scramble data are prepared for the applications that do not participate in the Initial Layout or Delta Processing in a XML format.
Responsibilities
 Participated in the full life cycle of a new development project. This included researching technical and user requirements, creating detail designs conversion, programming and coding of the COBOL II batch and online programs that were required to meet the project specifications.
 Application comprised large number of COBOL II, DB2, and COBOL-DB2 programs. These programs required analysis, design, code/construct, unit test and system test to implementation in a production environment.
 Worked on creation of new PROC’s & JCL’s and scheduled the jobs.
 Developed number of REXX utilities to minimize the number of manual works & repetitive works.
 Part of the testing team that does the creation of testing strategy, test cases and execution of test jobs. As part of testing, Unit Test Plans (UTP) was also created which reflected the details of the testing for each of the test cases.
 Involved in extensive system testing and migration into production.
 Conducted walk through on all proposed changes, interviews with users concerning all modifications and impact analysis.
 Involved in Production support.
 Testing Programs through Expeditor
 File Transfering using FTP and NDM process
 Running DB2 Utilites –REORG/RUNSTATS/IMAGECOPIES/WLM REFRESH.
Environments
COBOL, REXX, DB2, DB2 Utilities, EASYTRIEVE, PL/1,EXPEDITOR, JCL, TSO,
ENDEAVOR QMF, SPUFI, File-Aid, Endeavor, ELIPS, XPEDITER,
ABEND-AID, SYNCSORT, PANVALET.
Client: Verizon, MA Duration: Oct 2004 – Oct 2005
PROJECT: EXPRESS MEDIA (E-MEDIA)
Role: Mainframe Programmer
Project Description
E-MEDIA or Expresstrak is one of the major Billing applications that are responsible for Billing
MDVW (Maryland, Virgina & West Virgina) states. This is mostly a COBOL/table driven
application that is purchased from the Pacific Bell, for formatting the Bill that is sent to printer
center to get printed & get mailed to the Customer.
Inputs are received from Usages, Pricing, IRB (Invoice Ready Bill); Taxing on a Bill Round date
and the customer gets billed on the same day. It’s one of the most complex business systems since
lot of systems are interfaced with the system and any problems will affect the consecutive Bill
Round.
The application is split into different system namely Input Interface system that is responsible for
formatting the different inputs into one single format. Then the Aggregator Input Interface
system merges the different inputs for each single account and performs numerous business
functions. The Distribute Interface system is responsible for splitting the data into multiple
outputs depending on the number of MEDIA options a customer own. Ex: Paper Bill/Power
Bill/CD.The format Interface system formats the data so that it gets printed in the print center.
Responsibilities
 Participated in the full life cycle of a new development project. This included researching technical and user requirements, creating detail designs conversion, programming and coding of the COBOL batch and online programs that were required to meet the project specifications.
 Application comprised large number of COBOL, DB2, and COBOL-DB2 programs. These programs required analysis, design, code/construct, unit test and system test to implementation in a production environment.
 Developed COBOL DB2 Stored Procedures so that Enterprise solution Group creates the WEB PAGES which are used by the clients.
 Worked on creation of new PROC’s & JCL’s and scheduled the jobs.
 Developed number of REXX utilities to minimize the number of manual works & repetitive works.
 Part of the testing team that does the creation of testing strategy, test cases and execution of test jobs. As part of testing, Unit Test Plans (UTP) was also created which reflected the details of the testing for each of the test cases.
 Involved in extensive system testing and migration into production.
 Conducted walk through on all proposed changes, interviews with users concerning all modifications and impact analysis.
 Co-ordinating monthly release &1st Bp release
 Extensive usage of SQL Queries
 Testing Transactions through CICS.
 Running DB2 Utilites –REORG/RUNSTATS/IMAGECOPIES/WLM REFRESH
 Involved in Production support
Environments
COBOL,REXX,DB2,DB2Utilities,EASYTRIEVE,PL/1,EXPEDITOR,JCL,TSO,ENDEAVOR,
PANVALET,SQL,FTP,NDM, ELIPS, XPEDITER, ABEND-AID.
Client: Verizon, MA Duration: Dec 2003 – Sep 2004
PROJECT: BILL MANAGER
Role: Mainframe Programmer
Project Description
Bill Manager 3.0 is a powerful PC-based electronic billing application developed by Verizon to
help customers efficiently analyze and manage their telecommunication costs. Customers may
receive Bill Manager monthly billing data in CD format or download the data directly from
Enterprise Direct. Enterprise Customers involve major players like CITIGROUP, IBM CORP,
FLEET BOSTON etc.
VAM Server distributes the VZ450 data used by Bill Manager to create the CD product. The
distribution is done for each Customer based on a complex set of rules. The time stamps for the
distribution of the source data, the receipt of the data by Bill Manager, and the eventual CD
creations are all tracked using an acknowledgment process and recorded on VAM tables. This
processing audit trail is made available to the client via the VAM web page.
Responsibilities
 Participated in the full life cycle of a new development project. This included researching technical and user requirements, creating detail designs conversion, programming and coding of the COBOL batch and online programs that were required to meet the project specifications.
 Application comprised large number of COBOL, DB2, and COBOL-DB2 programs. These programs required analysis, design, code/construct, unit test and system test to implementation in a production environment.
 Developed COBOL DB2 Stored Procedures so that Enterprise solution Group creates the WEB PAGES which are used by the clients.
 Part of the testing team that does the creation of testing strategy, test cases and execution of test jobs. As part of testing, Unit Test Plans (UTP) was also created which reflected the details of the testing for each of the test cases.
 Involved in extensive system testing and migration into production.
 Conducted walk through on all proposed changes, interviews with users concerning all modifications and impact analysis
 Coded DDL scripts for Creating and Altering database objects. Setup and run utility jobs to complete the alteration processes.
 Extensive usage of SQL Queries
 Responsible for configuation management of the team.
 File Transfering using FTP and NDM process
 Coding & Testing CICS Programs.
 Running DB2 Utilites –REORG/RUNSTATS/IMAGECOPIES/WLM REFRESH
 Involved in Production support
Environments
COBOL,REXX,DB2,DB2Utilities,EASYTRIEVE,PL/1,EXPEDITOR,JCL,TSO,ENDEAVOR,
PANVALET,SQL,FTP,NDM,OMEGAMON, ELIPS, XPEDITER, ABEND-AID.
Client: Verizon, MA Duration: July 2003 – Nov 2003
PROJECT: VERIZON ACCOUNT MANAGER
Role: Mainframe Programmer
Project Description
Verizon Account Manager (VAM) is the backbone of many strategic billing related functions
such as the ESG Portal bill display and account management, Bill Manager for bill analysis, NBBE
national billing and discounting, and metrics reporting.
VAM Server is a historical repository for all ESG billing data and currently has 4.7 terabytes of
data stored in over one hundred DB2 relational tables. The billing data is received from thirteen
different billing systems in VZ450 format and is processed through a comprehensive load process
that converts the VZ450 records to a relational table format and updates the database while still
maintaining 24 X 7 availability.
VAM supports the ESG Portal billing functions through a series of DB2 stored procedures. This
real time interface extracts data from the base tables and presents it to the ESG Portal for display.
VAM fully supports the ESG Portal pagination and sorting functionality for ESG accounts
including National Bill and host billed DSL customers. VAM Server handles approximately 1.8
million on-line bill inquiry transactions per month. The VAM Profile application performs the vital
role of daily account maintenance by receiving account updates from the backend billing systems
and synchronizing them with the Portal account management function. VAM Server bill view also
leverages the daily account maintenance function to provide fast response for the Portal billing
home page.
Responsibilities
 Participated in the full life cycle of a new development project. This included researching technical and user requirements, creating detail designs conversion, programming and coding of the COBOL batch and online programs that were required to meet the project specifications.
 Application comprised large number of COBOL, DB2, and COBOL-DB2 programs. These programs required analysis, design, code/construct, unit test and system test to implementation in a production environment.
 Developed COBOL DB2 Stored Procedures so that Enterprise solution Group creates the WEB PAGES which are used by the clients.
 Worked on creation of new PROC’s & JCL’s and scheduled the jobs.
 Developed number of REXX utilities to minimize the number of manual works & repetitive works.
 Part of the testing team that does the creation of testing strategy, test cases and execution of test jobs. As part of testing, Unit Test Plans (UTP) was also created which reflected the details of the testing for each of the test cases.
 Involved in extensive system testing and migration into production.
 Conducted walk through on all proposed changes, interviews with users concerning all modifications and impact analysis
 Coded DDL scripts for Creating and Altering database objects. Setup and run utility jobs to complete the alteration processes.
 Responsible for configuation management of the team.
 File Transferring using FTP and NDM process
 Running DB2 Utilites –REORG/RUNSTATS/IMAGECOPIES/WLM REFRESH
 Co-ordinating monthly release &1st Bp release
Environments
COBOL,REXX,DB2,PL/1,EXPEDITOR,JCL,TSO,ENDEAVOR,SQL,FTP,NDM,ELIPS, XPEDITER, ABEND-AID.
Client: AT&T Duration: April 2001 - June 2003
PROJECT: MESSAGE PROCESS DEVELOPMENT (MPD)
Role: Systems Analyst
Project Description
MPS is recognized as one of the few complex system since it processes the daily usages of the
customer and rates them. The daily usages are processed in the system according the plan the
customer inherits and he his rated for the most efficient plan he holds. The rating is done after
checking the number of optional calling plan he exhibit, order them and check in whether the
account number exists in the master file. The rates are stored in special designed ITMS tables,
which are CSECT tables.
 Involved in the analysis, design, conversion, programming and coding of the COBOL/DB2 programs that were required to meet the project specifications.
 Single point of contact for any queries about the work requests
 Responsible for modifying the existing reports using COBOL-JCL-DB2 in order to meet the client’s requirement.
 Responsible for the reviews and defect free delivery of the product.
 Integration Testing rolls ups through trouble tickets.
 Handled the additional responsibility of maintaining the quality and project related documents.
 File Transferring using FTP and NDM process
Environments
COBOL, REXX, DB2, EXPEDITOR, JCL, TSO, ENDEAVOR, SQL, FTP, NDM.
Client: AT&T Duration: Sept 98-March 2001
PROJECT: CHARGING & DISTRIBUTION
Role: Mainframe Analyst
Project Description
Charging and Distribution groups all the usages from different special systems such as AIRFONE,
IMPS (International and Offshore Message), CBIS (Pre Billed Returns and Universal Card Swipe
Messages), RICS (Messages made on AT&T Network that were card, third Number or Collect)
and does the following checks, Duplicate Checking, Routing, Alternate Biller Qualification.
These Checks are done through the Sync sort exit routine programs where is the input is read
through one program and formatting done through another EXIT routine. After the checks are done
the usages are grouped into one single file and fed as the input to the MPS system, which process
and rates the data.
 Involved in the analysis, design, conversion, programming and coding of the COBOL/DB2 programs that were required to meet the project specifications.
 Single point of contact for any queries about the work requests
 Responsible for modifying the existing reports using COBOL-JCL-DB2 in order to meet the client’s requirement.
 Responsible for the reviews and defect free delivery of the product.
 Handled the additional responsibility of maintaining the quality and project related documents.
Environments
COBOL, REXX, DB2, EXPEDITOR, JCL, TSO, ENDEAVOR, SQL, FTP, NDM.
Education
Bachelor of Technology in Engineering from MADRAS University, India.
Willing to work over the internet
Willing to Relocate Work Offsite ONLY I do use contract agents/recruiters. I am an Independent Corporation. I am a Limited Liability Company (LLC). I use an Umbrella company as employer of record. I am an Independent Sole Proprietor (1099). I can be an Employee of an Agent (W2). I can be convertible to Employee of Client. I am also looking for part-time work. I will also bid fixed price work.
Member number:9317 Last Updated: Feb 16 2006 Member since: Oct 13 2005 Membership expires:Oct 13 2005 (Pending Deletion) Hit Statistics on This Page and the Resume Page. The Legal Disclaimer. |
|
