Janani Nandagopal
Senior Mainframe Developer
**********.******@*****.***
SUMMARY
Senior IT Analyst/Maniframe Developer with 8+ years of progressive, in-depth
experience in analyzing, designing, developing and deploying Mainframe
applications.
Have worked specifically on Insurance and Banking (Credit cards and Deposits)
domain.
Good Exposure in ETL ((Extraction, Transformation and Loading) part of Data
warehouse Concepts.
Experience in designing and development of software applications with COBOL,
JCL, VSAM, DB2, CICS, SQL, FOCUS
Exposure to analysis, development, testing, batch support, building testing
region, providing root cause analysis to the issues in the batch and identifying
valid defects
Experienced in End-to-End Application Development, handling Enhancements
and testing region Support in IBM Mainframe technologies (COBOL/JCL/ DB2/
VSAM/ FOCUS).
Extensive experience in Batch processing using the tools like Jobtrac, CA7,
TWS.
Sound knowledge of mainframe related tools like File Aid, TSO/ISPF, SPUFI,
ChangeMan, Endevor, INTERTEST & Table Editor.
Sound knowledge in TERDATA Load Utilities like MLOAD, BTEQ, TPUMP,
FASTLOAD & FASTEXP.
Strong written and verbal communication skills and experience in customer
interaction in requirements gathering and presentation of solution description.
Experience as a software engineer and ability to co-ordinate multiple tasks. Good
learner and versatile team player with excellent communication and analytical
skills.
TECHNICAL EXPERIENCE
Operating Systems: Mainframes OS/390, Windows, Z/OS, SAP
Languages: COBOL, JCL, SQL, CICS, FOCUS, EASYTRIEVE
Database: DB2, TERADATA
Teradata Utilities: MLOAD, BTEQ, TPUMP, FASTLOAD, FASTEXP
File Handling Tools: File – AID R8.8.0, INSYNC V2.7, NDM
Source Migration Tools: Endevor R4.0, Change Man
Query Based Tools: SPUFI, Platinum, Table Editor
Debugging Tools: Intertest, CEDF
Job Monitoring Tools: Jobtrac, CA-7, BETA-92 V3R4, TWS, SAR
Testing Tools: Test Director 8.0 Utilities/Tools, PEREGRINE, Mercury
Quality Control tool, CITRIX, Maximo Service
Centre
Domains: Insurance, Banking
EDUCATION
M.S (Master of Science - SE) during 2006-2010 in BITS Pilani – Wipro BITS
integrated Program.
Bsc. Computer Technology at Sri Krishna Engineering College, Coimbatore
during 2003-2006
PROJECT EXPERIENCE:
Project Title: CA & NW Conversion
Client: Bank Of America, Florida, US
Role: Senior Mainframe Developer
Duration: April 2013 – Till Date
Impact analysis coordination with a team of 20+ as the conversion impacted
almost all the other deposit applications.
Leading the projects from Onsite/Offshore which includes a daily interaction
with clients and Business Analysts for requirements gathering,
clarifications and suggestions in data integration.
Worked on Initiatives which involved COBOL-VSAM-DB2 coding to improve
Performance.
Design and development of Mainframe JCLs and SQL queries as per the
business requirement.
Preparing Unit Test Cases and Unit Test Results.
Coordinating with testing team for fixing QA and UAT Defects.
Scheduling the jobs in CA7 and monitoring its daily run on Production.
Preparing all the necessary documents like Run book, Low Level Design,
Deployment Sheets, Delivery packages.
Creating/Updating data flow using MS Visio.
Technology/Environment: Mainframes, COBOL, JCL, VSAM, DB2, File-AID,
CA7, Change man
Project Title: Deposits in Data Warehousing Resource Pool
Client: Bank Of America, Chennai
Role: Senior Mainframe Developer
Duration: Aug 2011 – March 2013
Project Description:
Data warehouse Resource Pooling is a data supply team that sends the
inputs from System of Records (SOR) and the data loaded into the tables are
used for making business decisions and also perform Data profiling and Analysis.
The RDBMS used is DB2.
Responsibilities:
Analysis, Coding, Unit Testing, Regression Testing, Implementation of the
new requirements.
Understanding the Business Requirements and System specifications and
modifying the Deposits COBOL DB2 driver programs to implement the
functionality.
To do an impact Analysis for the New/Changed Requirements and prepare
LLD (Low Level Design).
Compare Client Supplied products like BRD, HLD with the LLD to find out any
incompleteness.
Prepare Unit Test Plan and Unit Test Scenarios.
Preparation of adhoc SQL queries according to the requirements of the
project.
Perform Peer Review and Code Walk through
Perform SIT (System Integration Testing) and provide data to Onshore
Counterpart for submitting it to the User community.
Assist in Deployment and provide Technical & Operational support during
Install.
Involve in Post implementation support.
Ensure overall quality of all the deliverables.
Used IPMS for all project management related quality activities.
Involve enthusiastically in KT and KSS of Technical details relevant to the
project for all the New Entrants.
Involved in the Hands on training for all the New Entrants.
Technology/Environment: Mainframes, COBOL, JCL, File-AID, CA7, Change
man
Project Title: DWH KTLON
Client: GMAC Insurance (Chennai, India)
Role: Senior Mainframe Developer
Duration: Jan 2010 – Jun 2011
Responsibilities:
Involved in Analysis, Coding, Unit Testing, Regression Testing,
Implementation of the new requirements.
Prepared the HLD and LLDs for all the functional requirements.
Created test cases, test data and recorded test results for new/enhanced
requests.
Interacted with the clients during the weekly status meeting, client meeting.
Documented the changes made and Unit test plans for the custom
components.
Developed and Coded Focus programs for creation of reports.
Technology/Environment: Mainframes, COBOL, JCL, DB2, File-AID, CA7,
Focus, TWS, SPUFI
Project Title: SUSTAIN-FTP
Client: GMAC Insurance (Chennai, India)
Role: Senior Mainframe Developer
Duration: Sep 2009 – Jan 2010
Responsibilites:
Analysis on the high level design and the system requirements
Analysis and Preparation of Functional Design and Technical Design
documents.
Design and Development of COBOL for the Online and Batch processes.
Preparation and Review of Unit Test Cases and Execution of the same in
Development region
Retrofitting the code to stabilize the project in different environments
Promoting the code to Higher Environments by using the Change Man
Defect support and Implementation support for the code till the code is moved
into Production.
Supported the users in User Acceptance Testing phase.
Regularly did Post Production Validation and provided Warranty support for
the code.
Technology/Environment: COBOL, JCL, VSAM, CICS, File-AID, SPUFI,
Change Man
Project Title: Billing simplification
Client: Farmers Insurance (Chennai, India)
Role: Environment Support Engineer
Duration: Feb 2008 – Aug 2009
Responsibilities:
Involved in setting up the testing environment which includes building the
testing region by, doing Massbind for both Online and Batch, Global
changes to JCLs, PROCs, CONTROL cards, Eazytrive programs, SORT
cards, CONCAT Libraries, done Basic Online and Batch shake outs.
Analyzed the regional issues, online issues and raised valid defects and have
advised the testing team to raise defects.
Analyzed the Jobs and the COBOL program in order to fix the regional issues
if any or else to raise a valid defect.
Involved in the Configuration Management and Endevor Migration activities.
Wrote several SCL (Schedule Libraries) for moving the code from the
DEV/Test regions to the production using Endeavor.
I was the only person in the entire account to do the Configuration
Management.
Involved in scheduling jobs independently in jobtrac for each and every
rollout.
Have hands on experience in the external applications like Mobius, SAP and
RDR.
Involved in identifying data in the production region by writing SQL Queries.
Involved in data migration for unloading the production data and loading them
into the testing region with the help of the EASYTRIEVE programs and
DB2 queries.
Technology/Environment: Mainframe, MVS/TSO-ISPF, CA-7, Jobtrac, Beta,
DB2, JCL, COBOL, CICS, SAP, File-Aid, Endeavor
Project Title: CARFAX
Client: Farmers Insurance (Chennai, India)
Role: Mainframe Developer
Duration: Oct 2007 – Feb 2008
Project Description:
This project is in response to changes in the CA Code of Regulations
pertaining to the validation requirements for Annual Mileage. Annual
mileage of our existing customers will be verify through a questionnaire,
for which if there is no response will allow us to default to a DOI filed and
approved default annual mileage value.
1. Accurate odometer reading will be collected from a CARFAX
2. New annual mileage will be derived based on the readings form Carfax.
3. Survey will be sent to insured stating the estimated annual mileage through
Mail and email by E-business and Foremost respectively.
4. Scantron will collect the survey feedback which contains the customer’s
readings, annual mileage and his reason supporting his readings.
Based on the survey feedback, annual mileage will be applied to APPS
system during renewal or after renewal through temporal in case of late
reply.
Responsibilities:
Involved in analysis, development, testing and documentation during the bug
fixing tasks.
Preparing High level and Low level design documents
Coding, developing, modifying COBOL DB2 programs
Involved in the preparation and execution of the test cases for Unit testing
and regression testing
Involved in Code Walkthroughs, Debugging and Error fixing.
Defect support and Implementation support for the code till the code is move
into production
Technology/Environment: Mainframe, MVS/TSO-ISPF, DB2, JCL, COBOL,
CICS, INTERTEST, CEDF
Project Title: IA Dev APPS
Client: Farmers Insurance (Chennai, India)
Role: Mainframe Developer
Duration: Jan 2007 – Oct 2007
Responsibilities:
Involved in coding and enhancement of COBOL programs and tested the
changes and implemented in Production.
Understand the requirement and developed the Edge Reports using Eazytrive
programs.
Preparation and Review of Unit Test Cases and Execution of the same in
Development region
Retrofitting the code to stabilize the project in different environments
Did end to end testing of all the components.
Technology/Environment: Mainframe, MVS/TSO-ISPF, DB2, JCL, COBOL,
CICS, INTERTEST, CEDF
AWARDS & RECOGNITIONS
Feather in my Cap award by Wipro for the best performance during 2008.
THANKS A ZILLION award in the year 2010.