Project Developer
Resume:
Shekar
Email: ********@*****.***
Phone: 508-***-****
Experience Summary
. Having around 10 Years of extensive experience in Mainframes
Technologies.
. Involved in complete software development life cycle (SDLC) of the
Requirements gathering, Analysis, Design, Coding and Testing Using
Waterfall and Agile Methodologies.
. Experience includes preparation of Functional Specification, Technical
Specification which includes High level design and Low level design.
. Experience in project like Enhancements, Migration, Maintenance, and
Support.
. Extensive experience in Batch and Online Application development.
. Extensive working experience on COBOL, JCL, CICS, MANTIS, ADSO and
Easytrieve plus technologies.
. Extensive working experience on databases DB2, VSAM, SUPRA, SQL, IMS
DB/DC and IDMS.
. Experience in IBM MQ series, passing the data between open systems to
Legacy system.
. Extensive working experience on mainframe tools like TSO, ISPF,
FILEAID, SPUFI, QMF, BMC.
. Extensive working experience on Mainframe Debugging tools XPEDITOR,
and INTERTEST.
. Extensive working experience on version control tool CHANGEMAN,
ENDEVOR, PANAVLET, CA-Library.
. Experience in using CA7 Job scheduler.
. Having working experience on Mainframe Testing, Which includes
Functional, Regression testing, End to End testing and data
validations.
. Having working experience in preparing documents using Visio, Ms-word,
MS-Excel.
. Having working experience in preparing Test Strategy, Test cases.
. Experience in using the Quality centre.
. Having knowledge on Data warehousing tools Informatica 9.1.
. Having Knowledge on .net, Java, Java Script, and HTML.
. Having the knowledge of XML, OLTP and OLAP databases.
. Good understanding of Business practices in the verticals like
Insurance, Banking & Financial Services, Manufacturing and Retail
Industry.
. Good Team player, having interest towards exploring, learning and
using new Tools & Software quickly as required.
. Excellent communication, team spirit, hardworking and leadership
skill.
. Excellent exposure in interacting with clients and providing Co-
ordination between onsite and offshore.
. Coordinating the technical team with Business team, Test team, and
Support team.
Technical skillset
Operating system :Z/OS,OS/390,MVS/ESA,Windows7/XP/NT,UNIX
Programming languages :COBOL, JCL, CICS, MANTIS, Easytrieve Plus,
PL/1, IMSDC, Java
Databases : DB2, VSAM, SQL, IMS DB, SUPRA and IDMS.
Tools and Utilities : FILEAID, BMC, SPUFI, QMF, XPEDITOR,
INTERTEST, TSO, ISPF, SDSF, Sync sort, IDCAMS,
IBM Utilities, IBM File manager
Version control tools : CHANGEMAN, ENDEVOR, PANAVLET, CA-Library,
Visual Source safe
Professional Certifications
. IBM DB2 database fundamentals-Exam 730 in June 2010.
. Certificate in Financial markets (Beginners module) in March 2011.
. IBM DB2 database fundamentals-Exam 733 in July 2011.
Project : Perishables May2013 - Till date
Client : AC Nielsen, Schaumburg, IL
Role : Lead / Sr. Mainframes Developer
Description: AC Nielsen is the One of the top rating agencies in consumer
products in United States, Nielsen provides clients the most complete
understanding of what consumers watch and buy. Consumers in more than 100
countries to give you the most complete view of trends and habits
worldwide.
Perishable products are the locally available products, which have local
assigned codes for billing purpose. The perishable products like Milk,
Meat, Vegetables, Fruits and etc. Some of these items are weighted and some
of these items are sold at unit wise.
Responsibilities:
. Handling work requests to change or enhance the existing
functionality.
. Preparing Analysis document to describe the problem and providing
solutions.
. Preparing the project related documents using Visio and Ms-word.
. Preparing the Functional specification and Technical specifications
which includes High level and Low level design.
. Interacting with various business teams to gather the requirements.
. Providing the estimates for the required component changes.
. Writing new COBOL, VSAM, DB2, CICS, IMS DB and Easytrieve Plus
programs and modifying existing programs based on the business needs.
. Preparing new jobs JCLS or modifying the existing jobs based on the
business needs.
. Preparing the Adhoc, Monthly, Quarterly, yearly reports using
Easytrieve plus.
. Prepare the Test data, creating the test scenarios, to test the new
and existing programs.
. Preparing Unit Test Plans and Perform Unit Testing, and UAT Support
. Involved in peer reviews.
. Providing the support to implement the components in the production.
. Tracking the various phases of the project to deliver the deliverables
on time.
. Providing the functional and technical support to the onshore and
offshore team.
. Project status will be updated to Clients and stake holders.
. Coordinating the Offshore team to Onsite team.
Environment & Tools: COBOL II, JCL, DB2, VSAM, IMS DB, Easytrieve Plus,
SQL, File Aid, SPUFI, XPEDITOR, CHANGEMAN, Quality Centre
Project : Common Disbursement Services Aug 2012 - Apr 2013
Client : State Farm Insurance, Bloomington, IL
Role : Lead / Sr. Mainframes Developer
Description: State Farm Insurance is one of the leading Insurance company
in the United States provides Insurance products and services to customers
in over United states and Canada. The State farm has Banking, and Insurance
services like Auto, Life, Fire polices to its customers.
The current cash disbursement system has different regions to provide the
services to its customers for claims, Policy amount refunds, now we are
design a new system clubbing all regions into a new Common Disbursement to
provide services from a single place and track all its financial
transactions processing from state farm to its customers.
Responsibilities:
. Understanding the functionality of the system and sharing with the
team.
. Analysis of existing system, programs (COBOL, PL/I) and writing the
component specifications, Technical specification and Job flow
diagrams using Ms-word, Visio.
. Design a new report layouts and structure after discussing with
business people.
. Rewrite of existing programs from PL/1 to Cobol DB2 programs.
. Writing the new Cobol DB2 program and modifying the existing programs
and doing unit testing.
. Writing new jobs (JCL) and modifying the existing jobs to execute the
programs.
. Generating the reports Daily, weekly, monthly, Quarterly, Half yearly
and Annually using Easytrieve Plus.
. Preparing Unit Test Plans and Unit Test Cases
. Executing the Unit test cases and document the unit test results.
. Involved in peer reviews.
. Update project status to clients and business stake holders.
. Coordinating the Technical team with business Users and test teams.
Environment & Tools: COBOL II, PL1, JCL, DB2, VSAM, Easytrieve Plus,
FileAid, SPUFI, CHANGEMAN, XPEDITOR
Project : PACE Aug 2008 - July 2012
Client : Bank of America, Pennington, NJ
Role : Lead / Sr. Mainframes Developer
Description: Profitability and Customer Enhancement Bank of America, one of
the leading banks in the United States provides financial products,
services, ideas and solutions to customers and clients in over 48 states.
The bank has four main business segments, viz. Consumer Banking, Commercial
Banking, Global Corporate and Investment Banking and Asset Management.
PACE is a Legacy Mainframe based Trust Accounting system. Originally vendor
developed - Amtrust. The PACE system handles trust operation services to
its customers in Bank of America. PACE is an integrated personal trust
system which provides both batch and on-line functions.
Key functional areas as follows
SMAC (Security Moment and Control), Fee & Account Processing, Tax & Lot
processing
And Corporate Actions.
Responsibilities:
. Handling work requests to change or enhance the existing
functionality.
. Handling the project like cost basis, Pending trades
. Preparing Analysis document to describe the problem and providing
solutions.
. Preparing the Functional specification and Technical specifications.
. Writing new programs and modifying existing programs based on the
business needs.
. Preparing new jobs or modifying the existing jobs based on the
business needs.
. Prepare the Test data to test the new and existing programs.
. Preparing Unit Test Plans and Perform Unit Testing, SIT/UAT Support
. Involved in peer reviews.
. Project status will be updated to Clients and stake holders.
. Grooming and providing the technical and functional trainings to the
juniors.
. Coordinating offshore resources with onsite coordinator, Test team,
support team and End users.
Environment & Tools: COBOL II, JCL, VSAM, DB2, FileAid, XPEDITOR, CHANGEMAN
Project : Client Central Maintenance Nov 2006 - July
2008
Client : Charles Schwab, San Francisco, CA
Role : Senior Mainframes Developer
Description: Customer and Account Technology (CAT) Client Central
Maintenance
The Charles Schwab Corporation is a leading financial services provider. It
provides a full range of securities brokerage, banking, money management
and financial advisory services to individual investors and offer a
complete range of investment services and products, It includes an
extensive selection of mutual funds, financial planning, investment advice,
retirement plan, equity compensation plan services, referrals to
independent fee-based investment advisors, custodial, operational and
trading support for independent and fee-based investment advisors through
its Schwab Institutional division.
Client Central is a API which Schwab representatives use to open the
brokerage accounts.
The Schwab need maintenance activates. The offshore team will receive the
work requests, Trouble tickets, production Issues, and SPR's assignments
through the onsite team.
Responsibilities:
. Provide solutions for Production Problems, SPR's(Special Requests),
trouble tickets
. Handling work requests to change or enhance the existing
functionality.
. Handling the project like legal address project
. Preparing Analysis document to describe the problem and solution
provided
. Developing and modifying existing programs.
. Generating the Reports using Easytrieve.
. Preparing the Unit test data.
. Preparing Unit Test Plans and Perform Unit Testing
. Involved in peer reviews
. Coordinating the team members to the Onsite coordinator
. Project status will be updated to the clients and Business stake
holders
Environment & Tools: COBOL II, JCL, Easytrieve, Java, Java Script, HTML,
DB2, CICS, File Aid, BMC, XPEDITOR, IBM Debugging tool, CHANGEMAN
Project : Timken LPWS Migration Dec 2004 - Oct 2006
Client : Engineering and Research Timken, Canton, OH
Role : Junior Mainframes Developer
Description: Timken LPWS Migration, The Timken Company is a leading global
manufacturer of highly engineered bearings and alloy steels and a provider
of related products and services with operations in 27 countries.
Timken had a mainframe based LPWS (Label Packaging and Work copy)
application. This was a legacy application developed several years back
using Mantis language and Supra database. Manufacturing units all over the
world used this application for generating labels and packaging
instructions. Timken wanted to re-engineer LPWS application to web
environment with mainframe DB2 as the database. The project is divided into
two phases. The first phase involved changing every mainframe routine to
access DB2 instead of Supra database. The second phase was the development
on web pages, which communicate with mainframe database
The project involved extensive use of IBM MQ architecture. This was done in
order to use the routines existing on the mainframe environment. The
alternative would have been to re-engineer the mainframe routines on the
web environment (not a very cost-effective solution). User security was
retained in CICS system. Existing mainframe print routines were called from
the web environment. This involved developing mainframe interface in order
to communicate with the existing mainframe routines.
Responsibilities:
. Requirement Analysis of the Mantis, Cobol Programs
. Changed the Cobol, Mantis programs to access the DB2 calls instead of
Supra
. Preparing the program specification to re-engineering Mantis programs to
.net
. Reading the data and passing the data TO/From legacy system to .net thru
IBM MQ Series
. Mapping the fields from SUPRA to DB2
. Writing the new programs to download the data to flat files.
. Involved in Data clean up
. Preparation of unit test cases
. Unit testing and System testing
. Peer review of the code changes and unit test cases
. Coordinating the offshore team to onsite team
Environment & Tools: COBOL II, JCL, DB2, Supra, VSAM, IBM MQ, SPUFI,
Panvalet, Interest, Mantis, CICS, .NET
Project : Sandvik IMS DB to DB2 Conversion Feb 2004 - Nov
2004
Client : Sandvik-Coromant, Sweden
Role : Junior Mainframes Developer
Description: Sandvik IMS DB to DB2 Conversion, Sandvik is a high
technology, engineering group with advanced products and a world-leading
position within select areas. Worldwide business activities are conducted
through representation in 130 countries. The Group has 37,000 employees and
annual sales of approximately SEK 50 billion.
Sandvik has a unique competence in materials technology, like high-end
tools for metalworking & rock-excavation, Stainless & high-alloy steels,
resistance materials & process systems.
Sandvik currently uses GSS (Global Sourcing System) for Production
administration, which runs 24x7. This is a DB2 based system and has evolved
from the old MIS system (IMS database) and does not have all the
functionality of the old IMS system. Data is currently copied back and
forth between new GSS database in DB2 and old MIS database in IMS.
Sandvik wanted to convert the programs from old MIS system to DB2 based GSS
system and also to incorporate MIS features into GSS. This involved
changing the programs to access DB2 database (GSS system) instead of IMS
database. It also involved creation of new fields on DB2 database for non-
existent fields & migration of data from old MIS system to DB2.
Responsibilities:
. Analyses of the existing Cobol IMSDB programs and convert the IMSDB calls
to DB2 calls.
. Writing the new COBOL programs to download the data to flat files.
. Mapping the fields IMS to DB2 tables
. Data clean up before loading the data into the DB2 tables
. Preparing the unit test cases and perform the unit testing and system
testing
. Peer to peer code reviews
. Reviewing the unit test cases and unit test results
. Involved in Defect prevention meetings
. Providing the implementation support
Environment & Tools: COBOL II, JCL, VSAM, DB2, IMS DB, XPERDITOR, SPUFI, CA-
Library
Education.
. Post graduate in Master of Computer Application (M.C.A).
Contact this candidate