Lakshmi Kanth

Sr. Programmer Analyst

Contact: 703-***-****

*** ******** **, *** **

Lansing MI 48917

Experience Summary:

· Having 10 Years of experience in developing and maintaining large and small-scale business applications in IBM Mainframes (OS/390, VSE) environment and web based technologies.

· Extensively worked on development, maintenance and production support applications using VS COBOL II, CICS, DB2, IMS DB/DC, IDMS, NATURAL/ADABAS, VSAM, JCL, PL1, GTB and TELON.

· Have expertise in ENDEVOR, FILE MANAGER, FILE-AID, TSO/ISPF, MVS/TSO, SDSF, SPUFI, QMF, SQL, INFO/MAN, Expediter, IDCAMS, PVCS, Syncsort, ChangeMan, CA-7 scheduler, Web-Sphere, DOS/VSE, InterTest, ABENDAID, Easytrieve, and Quality Center tools.

· Gained lot of experience in developing online programs & screens in CICS.

· Lead the team of 6 people for more than 3 years.

· Have hands on experience of Onsite-Offshore model projects.

· Have extensive experience in all the phases of software development life cycle.

· More than 4+ years of experience in Systems Analysis.

· Have experience in Teradata RDBMS Database.

· Have experienced in using FTP and SSL.

· Worked on IBM MQ Series (Middleware) with Mainframe as backend.

· Have Very Good Experience in Telon tool in developing, maintenance, implementation and testing of projects.

· Involved in different phases of Testing, which includes Preparation of Test data, Setting up Testing environment, Creation of Test cases, Unit Testing and system Testing.

· Stretch to meet deadlines, can handle concurrent responsibilities, excellent presentation and documentation skills, good analytical and problem solving skills.

· Expert problem solving skills with the ability to think creatively and strategically about alternative solutions and opportunities.

· Have very good exposure to different domains in IT Industry.

TECHNICAL SKILLS:

Operating System MVS/ESA, MVS/TSO, VSE, MS-DOS, WIN-98, 2000 and 2003, z/OS, UNIX MP-RAS

Languages VS-COBOL II, CICS, JCL, SQL, Java, NATURAL/ADABAS PL1 CORBA, SWING, C++, J2EE, HTML, XML, XSLT and Java Script

Database DB2 V7.0, Teradata, BTEQ, IMS DB/DC, ORACLE 9i, IDMS, and SQL Database

Tools TELON, ENDEVOR, FILE-AID, FILE MANAGER, EZYEDIT, INFO/MAN,

CA-7 scheduler/OPCA, NDM, ChangeMan, Infopac, Expeditor, InterTest, SPUFI, QMF, Easytrieve, ABENDAID, and TestDirector

File Access VSAM, PS, PDS, and GDG

Domains Banking & Insurance, Finance Securities, Pharmaceutical and Retail

Middleware IBM MQ Series, Web-Sphere

ETL Tools Informatica 7.1.1, Datastage 7.5, Abinitio

BI Tools Business Objects 6.x/5.x

Software Engineering Methodologies/Tools/Technologies OOAD, UML

Project Experience:

Auto-Owners Insurance, Lansing, MI

Claims Processing, Dispersion Credit, Automation of Motor Cargo

Sr. Programmer/Analyst March 2009 – Till Date

Automate the rating of Dispersion Credits on the MENT System. This plan develops a special rating credit to reflect expense savings and dispersion of risk for commercial property meeting eligibility requirements for

Location and values and applied to Tailored Protection policies for accounts, which meet the eligibility requirements. This shall apply to all commercial building and business personal property premiums for all causes of loss, except for Equipment Breakdown Coverage. The word “values” as used in this plan means the limits of building and business personal property. The maximum percentage of “values” at any one location is the amount of coverage of the highest values location divided by the total “values” of all locations.

Responsibilities:

· Programs were written in COBOL, CICS, JCL, DB2, VSAM, and Flat files.

· Instrumental in developing online programs and screens using CICS, COBOL and GTB.

· Analyzed existing system and involved in designing a new application.

· Created and modified test and production JCLs/Procs/Parms and provided on-going support.

· Responsibilities include all the stages of the software development cycle, namely coding, debugging, testing (test plan and test execution), integration and System testing, documentation and maintenance of the programs.

· Extraction of data was done using VSAM & Flat files.

· Involved in Integration, E2E, Parallel, UAT and Regression testing before moving to production.

· Extensive coding and Unit testing for complex modules by interacting with business users.

· Involved in Troubleshooting, Debugging and Performance Tuning of code and supporting users by incorporating specific requests.

· Interacted closely with business users and agents regarding few doubts in the requirements.

· Created program specifications, test plans and performed Unit and system testing.

· Unit tested external Interface Input File process to ensure the data flow between Programs &

Database.

· Involved in writing many queries in DB2 to fetch data.

Environment: VS COBOL II, CICS, DB2 V7.0, JCL, VSAM, Expediter, Easytrieve, TSO/ISPF, MVS/TSO, FILEAID, ES-9000, IBM-MVS, OS390, and SPUFI.

Wal-Mart Inc, Bentonville, AR

Brazil Tax & Central America

Sr. Programmer/Analyst June 2008 – Jan 2009

The client is No.1 Retailer in the world; they are leading in retail business in 40% of the world. They have business across USA, North America, South America, UK, Canada, European, India and Japan.

As part of their establishment across the globe, they are starting their business in Central America. This project is a development project, which mainly deals with their new operation in Central America. This is a development and maintenance project. We have developed new & enhanced programs, which meet the requirements for Wal-Mart new business.

Responsibilities:

· Coding has been done using COBOL, JCL, DB2, CICS, Files and VSAM.

· Worked on critical reports using Infopac tool.

· Instrumental in coding and validation of the input data and processing.

· Database extraction was done by using Platinum DB2 Utilities.

· Created program specifications, test plans and performed Unit and system testing.

· Unit tested external Interface Input File process to ensure the data flow between Programs &

Database.

· Involved in writing queries in SQL Database.

· Submit jobs in system test environment as per CA11 job schedule.

Environment: VS COBOL II, CICS, DB2 V7.0, JCL, Expediter, Info Pac, SQL, VSAM, Easytrieve, HTML, Java Script, IDMS, TSO/ISPF, MVS/TSO, FILEAID, ES-9000, IBM-MVS, OS390, SPUFI, Platinum DB2 Utilities.

Wal-Mart Inc, Bentonville, AR

India Mars & COOPS

Programmer/Analyst January 2008 – May 2008

The client is No.1 Retailer in the world; they are leading in retail business in 40% of the world. They have business across USA, North America, South America, UK, Canada, European and India. As part of their establishment across the globe, they are starting their business in India. This project is a new development project, which mainly deals with their new operation in India. This is a development and maintenance project. We have developed new programs which meet the requirements for their new business in India, to implement this project in India, Wal-mart made a joint venture with leading Indian company called "Bharthi" and all their operations will be functioned on the name of "Bharthi Wal-Mart".

Responsibilities:

· Programs are developed in COBOL, CICS, JCL, DB2 and VSAM.

· Extensively worked on flat files to test the newly coded programs.

· Infopac tool is used to generate reports based on business requirements.

· Instrumental in coding and validation of the input data and processing.

· Responsibilities include all the stages of the software development cycle, namely design,

· Specification, coding, debugging, testing (test plan and test execution), integration and system testing, documentation and maintenance of the programs.

· Created program specifications, test plans and performed Unit and system testing.

· Unit tested external Interface Input File process to ensure the data flow between Programs &

Database.

· Involved in writing queries in SQL Database.

· Submit jobs in system test environment as per CA11 job schedule.

Environment: VS COBOL II, CICS, DB2 V7.0, JCL, Infopac, SQL, VSAM, Easytrieve, HTML, Java Script, IDMS, TSO/ISPF, MVS/TSO, FILEAID, ES-9000, IBM-MVS, OS390, SPUFI, Platinum DB2 Utilities, Xpediter.

UBS Investment Bank, Stamford, CT

GCU US Release 2

Sr. Programmer/Analyst July 2007 – Nov 2007

GCU Release 2 replaces the cash accounting system (CASH) - client pricing, billing and reporting including maintenance of customer and account data and related static data, Core accounting including interest calculation and pricing in US in order to provide a multi-entity, multi currency ledger to support business growth. It provides a scalable cash infrastructure to support business growth streamline processes and platforms by leveraging globally shared technology infrastructure (SSP), reduce an operational risk by reducing dependence on CASH legacy infrastructure.

Responsibilities:

· Preparation of Internal design document based on business requirements.

· Coordinating offshore/onsite model for development/maintenance of the project.

· Programs were written in COBOL, JCL, CICS, DB2, VSAM, and IMS DB.

· Involved in Integration, E2E, Parallel, UAT and Regression testing.

· Worked on web-based application using JSP, Servlets, XML, XSLT, HTML and Java Script.

· Extensively worked on flat files to induce scenarios for different testing teams as a developer.

· Key person in sending the upstream files to B-PLEX test region by using FTP protocol & NDM.

· Instrumental in coding the validation of the input data and processing.

· I have involved in few modules of PeopleSoft and have done mapping to Mainframe modules as

Per the client requirement.

· Responsibilities include all the stages of the software development cycle, namely design, Specification, coding, debugging, testing (test plan and test execution), integration and

· System testing, documentation and maintenance of the programs.

· Database extraction was done using Informatica.

· Exclusively involved in Stored Procedures in DB2.

· Created program specifications, test plans and performed Unit and system testing.

· Unit tested external Interface Input File process to ensure the data flow between Programs & database.

· Involved in writing queries in SQL Database.

Environment: VS COBOL II, CICS, SQL Database, DOS/VSE, DB2 V7.0, JCL, SQL, Informatica, NDM VSAM, Oracle 9i, PeopleSoft, Java, JSP, XML, XSLT, HTML, Java Script, MQ Series, Teradata V2R5, OPCA, SWING, C++, TSO/ISPF, MVS/TSO, FILE MANAGER, ES-9000, IBM-MVS, OS390, SPUFI, Web-Sphere, CORBA, and QMF

IMS (Institute of Mathematics & Statistics), San Francisco, CA

Parma Trend Application

Programmer/Analyst January 2007 - June 2007

Pharmacy Trend is a flagship product for IMS catering to the pharmaceutical segment of the Healthcare industry. This System gets input on sales and stock of the pharmaceutical products from selected pharmacies. The data obtained is projected and transform to generate the trend analysis reports.

Responsibilities:

· Study of system level design document.

· Programs were written in VS COBOL II, PL1, DB2, CICS, and JCL.

· Some programs are written in Java, JSP, XML, XSLT, SWING, Oracle 9i, MQ Series, and C++

· Coordination with offshore/onsite for the business requirements, development of project.

· Handled many queries in SQL Database.

· Modified/Created stored procedures in DB2.

· Extensive coding and Unit testing for complex modules.

· Involved in writing program specifications & SQL Performance Tuning.

· Executed test plans and performed Unit testing in development.

· Responsible in identifying data quality issues and working with the project manager and

· Team lead on data cleansing opportunities and future data re-engineering opportunities.

· Analyzed existing system and involved in designing a new application.

· Instrumental in coding the validation of the input data and processing.

· Database (DB2) extraction was done using COBOL code.

· Created and modified test and production JCLs/Procs/Parms and provided on-going support.

· Unit tested external Interface Input File process to ensure the data flow between Programs & database.

· Preparation of UTP.

Environment: VS COBOL II, PL1, CICS, DB2 V7.0, JCL, SQL Database, Informatica, VSAM, Oracle 9i, Java, JSP, XML, XSLT, MQ Series, SWING, DOS/VSE, C++, TSO/ISPF, MVS/TSO, FILE MANAGER, ES-9000, IBM-MVS, OS390, SPUFI, Web-Sphere, CORBA, and QMF

Nationwide Insurance, Columbus, Ohio

Teradata Extracts

Programmer/Analyst April 2006 – Nov 2006

Nationwide is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. Over the last 80 years Nationwide has gone from a small auto insurer for Ohio farmers, to one of the largest insurance and financial services companies in the world. With more than $157 billion in statutory assets.

Responsibilities:

· Involved in executing Teradata Scripts to fetch Business Information for high level Managements by using Mainframe batch Jobs.

· Coordinating offshore/onsite model for development of the project.

· Implementing new business requirements, understanding new business process flow, design, coding, and Implementation to production.

· Interacting closely with functional teams and end users regarding technical specifications and reports.

· Production support activities and generated Ad hoc reports whenever required by client.

· Analyzed existing system and involved in designing a new application.

· Involved in designing front-end part by using Java, XML, XSLT, C++, SWING, JSP, and MQ Series.

· Created Test plans and performed Unit and system testing.

· Created/modified DB2 Stored procedures as per the client requirement.

· Involved in Troubleshooting, Debugging and Performance Tuning of code and supporting users by incorporating specific requests.

· UNIX & Kornshell scripts have been used to extract data from Teradata box.

· Instrumental in coding the validation of the input data and processing.

· Unit tested external Interface Input File process to ensure the data flow between programs & database.

· Interacting closely with functional teams and database administrators to resolve production issues.

Environment: Teradata V2R5, BTEQ, Fast Export, OS/390, CA-7 scheduler/OPCA, Informatica, FTP, NDM, Java, C++, SWING, VSAM, JSP, XML, XSLT, MQ Series, JCL, Easytrieve, Expediter, IDCAMS, z/OS, Syncsort, SQL, Web-Sphere, CORBA, UNIX with Kornshell scripts, ChangeMan 5.5.2, SPUFI, QMF, OMEGAVIEW 300, UNIX MP-RAS

State of California, Sacramento, CA

Programmer/Analyst Jan 2005 - March 2006

I developed the Legal Subsystem for the Integrated Revenue Information System (IRIS) and California State Board of Equalization (BOE) (IRIS and BOE's tax system), tracking Bankruptcies, other legal issues. Data conversion for Tax System, extracting ADABAS records, manipulation on micros, moved to new mainframe database for special reporting requirements. Maintenance, enhancement of User Security subsystem and data for IRIS. Maintenance for Consumer Affairs Dept. I created programs to run Batch JCL from Natural Online. Online and batch unit and system testing, user acceptance testing, flowchart documentation of functionality. MVS, TSO/ISPF, JCL development, CICS, COBOL / 390, RACF, Microsoft Office (Word, Excel), all SDLC Documentation.

Responsibilities:

· Requirements gathering from the client.

· Programs were written in COBOL, CICS, and DB2.

· Handled many queries in SQL Database.

· Involved in writing program specifications & SQL Performance Tuning.

· Created test plans and performed Unit testing and Involved in DB2 stored procedures.

· Analyzed existing system and involved in designing a new application.

· Created and modified test and production JCLs/Procs/Parms and provided on-going support.

· Involved in the defect fixing, testing and generating Incident Reports.

· Solved abends in Acceptance and Prod during batch cycle run.

· Preparation of document for project movement from model office to UAT and its support activities.

Environment: VS-COBOL II, CICS, Expediter, IDCAMS, Syncsort, ENDEVOR, FTP, ABENDAID, FILE-AID, EZYEDIT, INFO/MAN, VSAM, CA-7 scheduler, DB2 V7.0, ES-9000, IBM-MVS, VSE, OS390.

State of Kansas Social & Rehabilitation Services, Topeka, KS

Programmer August 2003 - Dec 2004

Part of Medicaid conversion team converting Missouri Medicaid system (MVS CICS / COBOL / COBOL II / VSAM) to State of Kansas specifications. Analyzed existing programs and wrote general and detailed specifications to modify each program and / or screen to allow it to work with other enhanced modules. Coding and tested changes to Claims, Financial, Accounting, Provider Third Party Liability and Worker Compensation sub-systems. Coded and tested programs; Assisted client in development and completion of user acceptance testing; Implemented solutions. Completed documentation necessary to have objects moved to production environment. Online environment MVS CICS COBOL II /ADABAS (ADAPREP) and NATURAL/ADABAS. Batch MVS environment Natural/ADABAS. Directed, tutored and trained clients and junior P/As in the use of Natural, ADABAS, CICS & COBOL.

Responsibilities:

· Programs were written in COBOL, CICS, Natural/Adabas, DB2 and JCL

· Coding and Unit testing for given requirement

· Handled many queries in SQL Database.

· Involved in writing program specifications & SQL Performance Tuning

· Created test plans and performed Unit testing and Involved in DB2 stored procedures.

· Analyzed existing system and involved in designing a new application

· Set up different scenarios of data in test environment to avoid abends in production.

· Involved in the defect fixing, testing and generating Incident Reports.

· Solved abends in Acceptance and Prod during batch cycle run.

· Preparation of document for project movement from model office to UAT and its support activities.

Environment: NATURAL/ADABAS, COBOL, DB2, JCL, CICS, ENDEVOR, FILE-AID, EZYEDIT, INFO/MAN, VSAM,

ES-9000, IBM-MVS, OS390, JSP, Servlets, HTML.

Putnam Investments, Boston, MA

PANAGORA

Programmer Feb 2002 – July 2003

Putnam Investments introduced the policy of charging short-term redemption fees; to participants who sell fund shares prior to the expiration of a specified holding period. The fee is calculated on a percentage basis, triggered by pre-defined time sensitive holding periods, and based on the number of shares being redeemed. The fee charged is then typically paid to the fund.

Responsibilities:

· Programs were written in COBOL, CICS, DB2, VSAM, JCL, and TELON.

· Written program specifications for complex modules for different business systems.

· Correcting Data in tables in the form of Data fix request from client.

· Retrieved much data from database tables by many transactions with the help of Mainframe batch process.

· Worked exclusively in defined contribution system for Putnam.

· Executed test plans and performed Unit testing in development.

· Involved in Troubleshooting, Debugging and Performance Tuning of code and supporting

· Users by incorporating specific requests in production support.

· Involved in the defect fixing, testing and generating Incident Reports.

· Created and modified test and production JCLs/Procs/Parms and provided on-going support.

· Involved in writing/modifying queries in SQL Database.

· Co-ordinate with the developers/business to determine the test cases and bug fixes.

· Used InterTest debugging tool to test online programs.

· Solved abends in Acceptance and Production during batch cycle run.

Environment: TELON, VS-COBOL II, CICS, InterTest, DB2 V7.0, JCL, TSO/ISPF, FILE MANAGER,

ES-9000, IBM-MVS, OS/390, SQL Database.

Putnam Investments, Boston, MA

RetirementReady Re-allocation

Programmer Jan 2001 - Jan 2002

RetirementReady is Putnam’s branded product that refers to a portfolio of funds that invests in other funds - mutual funds, commingled trusts, and separate accounts. The underlying investments have designated allocation percentages. The fund’s value and performance are determined based on the underlying assets. At the time of this writing, not all clients have agreed to move assets from commingled trusts into mutual funds. As a result there may very well still be client plans with Putnam RetirementReady portfolios upon implementation.

Responsibilities:

· Programs were written in COBOL, DB2, and CICS for online programs.

· Extensive coding and Unit testing for complex modules.

· Involved in writing program specifications, coding, and review and test batch programs.

· Executed test plans and performed Unit testing in development.

· Analyzed existing system and involved in designing a new application for Retirementready.

· Instrumental in coding the validation of the input data and processing.

· Created and modified test and production JCLs/Procs/Parms and provided on-going support.

· Unit tested external input file process to ensure the data flow between Programs & database.

· Preparation of turnover documents.

Environment: TELON, VS-COBOL II, CICS, DB2 V7.0, JCL, TSO/ISPF, FILE MANAGER, ES-9000,

IBM-MVS, OS390, and SQL.

Putnam Investments, Boston, MA

OFAC

Programmer June 1999 - Dec 2000

The OFAC requires that U.S. businesses examine their files/databases for potential organizations, countries, individuals, etc. deemed to be potentially harmful to American interests. A master database of these groups/individuals has been developed by Thomson Financial and distributed to U.S. companies. Shareholder has already developed a batch scanning process to compare the names and addresses contained in their system against the Thomson Financial master list.

Responsibilities:

· Preparation of program specifications.

· Programs were written in COBOL, using IMS DB/DC and VSAM file handling.

· Involved in design, analysis, coding, reviewing and testing batch IMS, DB2 and Online IMS DC, CICS, COBOL, programs, enabled IMS transactions

· Instrumental in coding the complex programs in COBOL & DB2 combination.

· Modified and developed online screens in IMS DC and CICS.

· Database extraction was done using COBOL code, Unit testing and review of programs.

· Unit tested external Interface input file process to ensure the data flow between Programs & RDBMS database.

· Preparation of document for project movement from model office to UAT and its support activities.

Environment: TELON, VS-COBOL II, IMS DB/DC, JCL, PL/SQL, FILE-AID, TSO/ISPF, SPUFI, QMF,

FILE MANAGER, Oracle, DB2 V7.0, ES-9000, IBM-MVS, OS390.

EDUCATION: MS in Computer Applications, India.

Contact this candidate