Mainframe Programmer

Location:

Posted:

March 19, 2012

Resume:

PROFESSIONAL SUMMARY:

• Presenting nearly** years of experience in software development, maintenance, production support, and testing of Mainframe Applications.

• Thorough understanding of the SDLC process entailing requirement analysis, design, development,

Testing, change request management and maintenance / enhancement.

• Proficient in COBOL,JCL,VSAM,IBM Utilities ,DB2, DB2 Stored Procedures, IMS,CICS,SDF,BMSGT, TERADATA, SQL,MARK IV, QUERYMAN, QMF,SPUFI,TSO/ISPF,FILEAID, XPEDITER, INTERTEST,CHANGEMAN,HOURGLASS,EASYTRIEVE,REXX, REMEDY, INTERTEST, INFOMAN, MANAGENOW, SCLM, LIBRARIAN, JOBTRAC and CA7.

• Expertise in XPEDITOR, PANVALET, SPUFI, QMF and FILEAID as testing tools and for data manipulation.

• Expertise in Functional, Integration, System testing and User Acceptance testing.

• Proficient in IBM Utilities and Tools like ABEND-AID, CHANGEMAN, ENDEVOR, INFOMAN, SYNC SORT.

• Strengths include strong customer interface and problem-solving skills, Estimations requirement analysis, designing, programming and testing.

• Proficient in SQL query writing and SQL performance tuning.

• Good team player with excellent organizational, analytical, project management and communication skills.

• Dedicated individual with strong sense of responsibility, work flexibly and quickly adapt to changing environments professionally and personally.

• Excellent domain knowledge on Credit card and Retail industry.

• Experience in working State Government Project - Worked with Florida School Board.

• Appreciations from American Express for best performance..

• Appreciations from the CIO of Wal-Mart for demand management savings and making the QSI morning reports available early.

SKILLS/TOOLS:

Mainframe Related:

Hardware IBM-3090, S/390

Operating Systems MVS

Languages COBOL, JCL, EZYTRIEVE, MARK IV, SQL

Databases DB2, IMS ,TERADATA, SQL Server 2005

GUI/TOOLS CICS, IMS-DCFILE-AID, XPEDITOR, SYNCSORT,REXX, SMARTEST, SPUFI, QMF, EASYTRIEVE , ABEND-AID, Platinum, DFSORT, INTERTEST, INFOMAN, CA-7, CA-11, BMC, ICETOOL, NDM, REMEDY,HOURGLASS,BMS-GT, Ezedit, CONNECT DIRECT, FASTLOAD, FASTEXPORT, BTEQ, MLOAD , XML, Quality Center

File Organization VSAM, PS, PDS, GDG

Version Control Tools ENDEVOR, CHANGE MAN, PANVALET, Librarian, SCLM

Non-Mainframe Related:

Hardware IBM PC Compatibles

Operating Systems Windows 95/98/2000/XP, MS-DOS

Languages SQL

Databases SQL Server 2005

Education:

Bachelors Degree in Electronics and Communication Engineering.

PROFESSIONAL EXPERIENCE:

Chrysler, Auburn Hills, MI July 2011 - Present

Scope: Chrysler is replacing the COMPASS legacy system with PENTASAP, because of which all its down stream

Legacy systems are impacted and need updates to support this.

• Analysis of the requirements and writing Business Requirement Documents.

• Involved in impact analysis.

• Involved in Design and Coding using COBOL, DB2, IMSDB, IMSDC, JCL..

• Involved in writing the test cases, creation of test data and execution of test cases.

• Created the validation plan to test the new code.

• Interacted with business as and when necessary.

• Attended the meetings with the clients on requirements and Design.

• Coordinating with a team of 10 from offshore on project activities.

Environment: DB2, COBOL, VSAM, IMS DB, IMS-DC, CICS, JCL, MVS, SYNCSORT, FTP, FILEAID, SPUFI, PANVALET, $AVRS, Quality Center

Wal-mart Stores Inc, Bentonville, AR Jan 2011 – June 2011

Scope: Wal-Mart Stores, Inc. is nation’s largest retailer runs a chain of large discount department stores. And is the world's largest public corporation by revenue. It operates in multiple countries like Mexico, UK, Japan, Argentina, Brazil, Canada, and Puerto Rico.

Pick Up Today (PuT) is a Wal-Mart application where customers can buy in store items online and pick up the same in a store where the customer likes. SOI/SLAP is mainframe batch process which sends the item information to DOTCOM based on the requirements. DOTCOM gets the item enrichment data for the items in the feed and displays online.

• Analysis of the requirements and Change requests..

• Involved in Design and Development of the code.

• Involved in writing the test cases , creation of test data and execution of test cases.

• Created the validation plan to test the new changes.

• Involved in User acceptance Testing and System testing.

• Interacted with business as and when necessary..

• Attended the meetings with the clients on requirements and implementation.

• Loaded the Teradata tables on test from the Production box for Testing.

• Involved in knowledge transfer to offshore and third party vendor on support.

• Involved in implementation and support of the application changes.

Environment: TERADATA, BTEQ,MLOAD,FASTLOAD,FASTXPORT,DB2,COBOL,JCL,MVS,SYNCSORT, FTP, FILEAID, SPUFI, LIBRARIAN, INTERTEST,$AVRS,XML,REMEDY

Orange County Public Schools Orlando, FL Dec 2009 – Dec 2010

Sr. Programmer Analyst

Scope: OCPS is one of the biggest school districts in the USA. Current project involves converting mainframe applications to Campusvue which is mainly web-based. All the processes like Student Enrollment Summary, Course details, Schedules, Financial details, Instructor Details, Transcripts are to be done thru Campusvue

web-based tool. Duties involve assisting Campusvue team in the areas of Analysis, Design, Testing and Implementation.

• Assist in the analysis, Design and Conversion of the application.

• Involved in identifying the screens to be converted, Files utilized for the conversion.

• Prepared the data dictionary for the conversion process.

• Have written many COBOL programs to generate the data conversion files.

• Written SQLs for Extracting, Loading and Testing the data loaded on Campusvue.

• Created the validation plan to test the new application.

• Supporting Integration and User Acceptance and System testing.

Environment: COBOL, DB2, Stored Procs,JCL, VSAM, SYNCSORT, FTP, CICS, FILE-AID, SPUFI, QMF, ENDEVOR, SCLM, JHS, JOBTRAC, XPEDITER, INTERTEST,ABEND-AID, SQL Server 2005,Quality Center

Orange County Public Schools Orlando, FL Feb 2009 – Nov 2009

Sr. Programmer Analyst

Scope: OCPS is one of the biggest school districts in the USA. Current project is to support school system to resolve problems faced by all the schools in the district while enrolling students or while accessing information like student Course details, Schedules, Financial details, Instructor Details, Transcripts. Also responsibilities include assist in maintenance and enhancements required to the system.

• Assist in the analysis, Design and Conversion of the application for enhancements.

• Involved in supporting the application and resolved many issues.

• Prepared the documentation of the application to help the conversion project.

• Have written AND updated many COBOL CICS programs.

• Have written new jobs which involves writing new COBOL/CICS and programs in EZYTRIEVE

• Interacted with schools to resolve the issues and gave the fixes as per the requirement.

• Preparation of Test and validation plan and preparation of test cases and test data according to changes.

• Involved in creation of New JCL’s, include members, programs, parms, Unload cards, Sort cards for production

• Involved in checking out all the elements in production and check in to stage once the changes are done.

• Provided development support for System Testing, Data Conversion Testing, Load Testing, and Production.

• Performing reviews of test scenarios, test cases, prepared defect reports and sent daily status reports.

• Analyzed System, functional and performance specifications and test plan, test scenario & test cases

Environment: COBOL, DB2, Stored Procs,JCL, IBM Utilities, VSAM, SYNCSORT, FTP, CICS, FILEAID, SPUFI, QMF, SCLM, JHS, JOBTRAC, INTERTEST,Endevor

Wal-mart Stores Inc, Bentonville, AR Oct 2008 – Jan 2009

Sr. Programmer Analyst

Merchandise reporting system creates the reports for the Category Financials, BAAG, GAP, SWAS applications. Teradata batch jobs send the files to the SQL server using File Transfer Protocols. Reports are displayed in the Front End using the SQL server tables. Hierarchy tool is designed to maintain product, merchandise and people hierarchy. Hierarchy tool changes incorporated in the application to reflect the changes in product, merchandise and people hierarchy.

• Analysis, Design and Development of the application.

• Involved in impact Analysis.

• Analyzed the applications to list all the Mainframe Jobs impacted.

• Updated the main frame Teradata jobs to reflect the hierarchy changes.

• Created the new tables and loaded in the Teradata to reflect the new hierarchy changes.

• Created the validation plan to test the new hierarchy changes.

• Involved in writing the test cases , creation of test data from prod data and execution of test cases.

• Loaded the Teradata tables on test from the Production box for Testing.

• Involved in performance tuning of the queries to optimize the run time.

• Supporting Integration and User Acceptance and System testing.

Environment: TERADATA, BTEQ, MLOAD, FASTLOAD, FASTXPORT, COBOL, DB2, JCL, VSAM, MVS, SYNCSORT, FTP, FILEAID, LIBRARIAN,INTERTEST, XML, $AVRS, REMEDY.

Wal-mart Stores Inc, Bentonville, AR May 2008 – Oct 2008

Sr. Programmer Analyst

Scope: Wal-mart nation’s largest retailer wants to display the items that are available in stores on their website. Wal-mart initiated this project to make the website more informative and searchable by customers. Customers can find information such as availability of an item in the stores and details about that item. Merchandize Reporting team is one of the teams involved in this project, and its main responsibility includes supplying a file with the information for all the items that are available in stores.

• Involved in System analysis, Design, coding, testing and Implementation.

• Interacted with users and Business Analyst as and when necessary

• Involved in Code review and walk through.

• Planned, created and executed test scenarios and test cases that ensure the system modification

Will meet the specified business requirements

• Defined data requirements to support all phases of testing. This included constructing input files to support testing as well as coordinating data across multiple applications to perform integrated testing.

• Attended teleconferences with managers and users.

Environment: COBOL, JCL, FILE AID, TERADATA, BTEQ, MLOAD, FASTLOAD, FASTXPORT, REMEDY, EASYTRIEVE, CA7, EXPEDITER, INTERTEST, XML, SYNCSORT, QUERYMAN.

Wal-mart Stores Inc, Bentonville, AR Nov 2007 – Apr 2008

Sr. Programmer Analyst

Scope: QSI morning Reports are one of the most important reports that Merchandize Reporting team generates. The customers of these reports include the CEOs of Wal-mart. Now the customers wanted these reports look more meaningful and available earlier. To achieve this we need to tune the queries and make the jobs run faster.

• Involved in System analysis, Design, coding, testing and Implementation.

• Interacted with users and Business Analysts.

• Involved in tuning SQL queries with DBAs.

• Used Query man and Explain extensively in analysis of long running queries.

• Planned, created and executed test scenarios and test cases that ensure the system modification

Will meet the specified business requirements

• Involved in analysis of recurring problems and providing solutions for the same.

• Prepared check lists to be followed while creating Change Controls which helped in reducing number of rejections by Change Council.

• Achieved 40% of CPU savings and also made the reports available early.

• Split several long running jobs in to smaller jobs and also made some of them to run in parallel so that the process will be completed sooner.

Environment: COBOL, JCL, VSAM, FILE AID, DB2, TERADATA, BTEQ,MLOAD,FASTLOAD,FASTXPORT, Remedy, EASYTRIEVE, CA7, EXPEDITER, SYNCSORT, QUERYMAN

American Express, Phoenix, AZ Nov 2005 – Jul 2007

Project Lead/ Technical Lead

Scope: WW CAS (World Wide Credit Authorization System) or simply CAS is a Global Transaction Processing System servicing the American Express card business and providing risk management. It is AMEX’s most mission critical system. CAS is a single global system that provides authorization operations and is also the direct indicator of business. Current Project is to update WWCAS batch programs to authorize transactions with higher amount.

• Involved in System analysis, Design, coding, testing and Implementation.

• Interacted with users and Business Analyst as and when necessary

• Involved in Code review and walk through.

• Planned, created and executed test scenarios and test cases that ensure the system modification

Will meet the specified business requirements

• Involved in analysis of recurring problems and providing solutions for the same.

• Performed SQA (Software Quality Assurance) role.

• Prepared check lists to be followed while creating CMRs, SSRs and PRCs and this helped in reducing number of rejections by ACM.

• Coordinating with a team of 5 members independently.

• Conducted team meetings, attended leader ship meetings, teleconferences with managers

• Task allocation

• Metrics and status reporting

• Capacity planning

• Mentoring team members

Environment: COBOL, JCL, VSAM, FILE AID, DB2 ,IMS-DB, CHANGEMAN, EASYTRIEVE, INFOMAN, MANAGENOW, JOBTRAC, EXPEDITER, SYNCSORT.

American Express, Phoenix, AZ Feb 2004 – Oct 2005

Project Lead/ Technical Lead

Scope: WWCAS is AMEX’s most mission critical system.CAS is a single global system that provides authorization operations. The current project is very critical as it feeds CAS online data base with the information from GRMS and Calculator groups for all the markets in the world. CAS receives the information for nearly 54 markets and does edit checks and reasonability checks before feeding the downstream systems.. The scope of the project is to Analyze, Design, Build, and Test and provide Implementation Support to the AMEX requirements.

• Involved in System analysis, Design, coding, testing and Implementation of system.

• Interacted with users and Business Analyst as and when necessary

• Analyzed the CR requirements to fix the code.

• Analyzed client requirements in order to design, write and execute COBOL programs as well as create JCL jobs to run them.

• Ensured the correct implementation of code and system testing of the Change Requests (CRs)

• Created test data and tailored JCLs, control cards and parameters.

• Developed Unit test plans and Executed test cases

• Involved in Code review and walk through.

• Carried pager for production support

• Involved in analysis of recurring problems and providing solutions for the same.

• Coordinating a team of 8 people at offshore.

Environment: COBOL, JCL, VSAM, FILE AID, DB2, IMS-DB CHANGEMAN, EASYTRIEVE, INFOMAN, MANAGENOW, JOBTRAC, EXPEDITER, SYNCSORT.

American Express, Phoenix, AZ Mar 2003 – Jan 2004

Project Lead/ Technical Lead

Scope: WW CAS (World Wide Credit Authorization System) is a Global Transaction Processing System servicing the American Express card business and provides authorization to the credit card transactions. All the activities against the credit card are captured by TPF, which is an on line system, by a process called STAT4 file capturing.TPF sends a tape for every 2 hours containing the transactions which captured during that time.CAS offline (Batch) segregates these transactions by type of the transaction and sends the files to appropriate interfacing systems which further use these files for their processing and updating the databases. Also part of this project contains ROC ACCUM matching. All the ROCs received are matched against the ACCUMs at the end of the day and will be written to matched and unmatched tables. Unmatched ROCS are maintained for a period of 21 days and if not matched they will be moved to History database.

Involved in Design, Coding and Integration testing

• Prepared Business Analysis documents and Technical Designs.

• Developed, maintained and supported COBOL/DB2 programs that accessed very large tables.

• Analyzed the most time & cost consuming jobs and provided the solutions to reduce the running Costs.

• Owned a DB2 subsystem in the test region and has maintained the DB2 objects

• Testing was done using SPUFI, QMF, FILE-AID, FTP, XPEDITER and thus minimizing post

Implementation problems.

• Designed and implemented the exception handling throughout the application.

• Bug fixing in the existing system involving root cause analysis of regular problems.

• Defined data requirements to support all phases of testing. This included constructing input files

To support testing as well as coordinating data across multiple applications to perform

Integrated testing.

Environment: COBOL, JCL, VSAM, FILEAID, DB2, IMS, CHANGEMAN, REXX, EASYTRIEVE, INFOMAN,

MANAGENOW, JOBTRAC

Pershing Technologies, Florham Park, NJ Nov 99 – Feb 2003

Team Lead

Scope: Pershing, a division of CSFB (Once, a div of DLJ direct), works behind the scene to provide the people, services, and technologies that help make successful investment possible. Pershing is a source for a diverse array of security trading, clearing, information management and financial products and services.

Real-time Positions and Balances is one of the systems of Pershing that keeps customers' accounts updated for intraday transactions. It interfaces with other systems to keep the required tables updated. This system processes about 200,000 messages daily. This project mainly involves in maintaining the batch jobs and making them updated as per the user requirements. Current requirement is to update the system to process the global data being sent to the PNBR system.

• Interacted with users and Business Analyst as and when necessary

• Involved in analysis, Design, coding, testing and Implementation of system.

• Followed up the existing standards for analysis and coding

• Written new JCLs for batch jobs

• Performed Unit testing, Integration Testing, and Regression Testing.

• Involved in Software Quality Assurance for the team.

• As most of the work involved making changes to the existing code, testing was carried out according to the changes made to the code.

• Fixed faults during system and/or acceptance testing phase or during external review of deliverables in development phase

• Involved in Code review and walk through.

• Conducted team meetings, attended leader ship meetings, teleconferences with managers.

Environment: COBOL, JCL, VSAM, FILE AID, DB2,CICS,BMS-GT, CHANGEMAN, EASYTRIEVE, INFOMAN, MANAGENOW, JOBTRAC, EXPEDITER, SYNCSORT.

American Express , Phoenix , AZ Jul 99 – Oct 99 Programmer Analyst

Scope: American Express provides banking, credit cards and related services worldwide. The objective of the project is to make the existing code YEAR 2000 compliant. This module started with collecting the date fields from Analysis reports in the existing format, creating parameter files for each Implementation Group. Using the parameter files, the data's obtained from Clients are Rolling Current date to past dates and future dates. This changed data is made use of in system testing.

• Analysis, Conversion and Testing of the code

• Convert the input source code by using Fixed window technique

• Testing the converted code

• Conducting code walkthroughs and reviews

• Changing the DB2 tables' content as per analysis

• Created and ran queries using QMF utility

• Rolling the dates for testing

• Preparation and review of quality document.

• Development of new modules, Preparation of test plans and test cases

• Unit and regression testing to satisfy business requirements

• Status Reporting

Environment: COBOL, JCL, VSAM, CICS, DB2, IMS-DB, EXPEDITER, FILEAID, ENDEVOR

Pearl Assurarnce , Peterborough ,UK Mar 97 – Jun 99

Programmer Analyst

Scope: Pearl Assurance is one of the major insurance companies in the U.K. Basically the client wants to asses the impact of the millennium bug on its mainframe based application systems. The system consists of over 20 applications of which majority of the programs are in COBOL. The work involves three phases Analysis, Conversion and Testing. Analysis phase is where all the programs would be analyzed for finding the list of programs that are to be converted to make them Y2K compliant. Conversion phase is where the programs are made Y2K compliant.

Once the conversion of the programs is over, the programs were tested. Testing involved 2 phases Regression and Simulation. Regression testing involved whether the programs would give exactly the same results with Y2K compliance as before conversion. Simulation was where the dates were simulated in the 21st century and tested on the programs. This was done using the date aging tool developed by TCS.

• Analysis, Conversion and Testing of the code

• Making the analyzed code Y2K compliant

• Unit and simulation testing to satisfy business requirements

• Conducting code walkthroughs and reviews

• Assigning jobs to team members

• Review of analysis reports and Status Reporting

Environment: COBOL, DB2, VSAM, JCL, CAT, CASEPAC, DATA AGER, ENDEVOR, REXX

Serveen Software Systems , Hyderabad Oct 95 – Feb 97

Programmer/Developer

Scope: Serveen Software systems was a budding company with projects from small local client.

Joined as a programmer and was trained as COBOL programmer and worked in couple of small project during this time.

• Coding programs in Cobol

• Testing of the code

• Conducting code walkthroughs and reviews to check if the requirements are met.

• Support and fix bugs if reported

Environment: COBOL, MS-DOS

Contact this candidate