SUMMARY

• She is having 8+ years of IT experience. Her main area of work has been Mainframe development and support.
• She is experienced in coding in PLI, working in DB2, writing SQL scripts, scripting in JCL, coding in REXX, working in Web and Corba Services, working in IMS DB, working in production support, batch jobs monitoring via Control - M in both test and production environment, UT, SIT, UAT, regression validation and quality reviews, performing SCM role for various applications.
• She has worked in requirement analysis, functional and business point research and analysis, technical and business risk analysis, application maintenance, defect analysis and fixing, batch abend solving and impact analysis. She had worked in COBOL programming also in the initial days of her career.
• She worked closely with other teams to achieve the common goals. She worked in automation, Code Migration / Release, Microsoft Excel tool handling and with the application team for data creation and analysis for various application. She has an in depth knowledge & understanding of software development phases.
• She worked primarily in the domain of Banking and Financial Services industry till now. She has experience in Private Banking and International Wealth Management domain.
• Her main forte is developing PLI-DB2 programs, writing SQL and JCL scripts, end to end development of online services(WS/CORBA), monitoring batch jobs and REXX codes for automation tools.

PROFESSIONAL EXPERIENCE

Confidential

Mainframe Developer

Responsibilities:

• Have supported around thirty thousand jobs in every EoD Cycle in DvSZ. Has knowledge on distributed systems in DvSZ and the interdependency of host and Distributed Systems (DS) batches.
• Worked in client location (Zurich, Switzerland) for 4 months for a support and batch job monitoring team. Having experience on request handling(mailbox handling) process from both onsite and offshore. Supported in setting up two new regions and solely responsible for setting up some frequent synch processes in the new regions.
• Worked as a Team member within the Mainframe Stability team providing support, testing, implementation and maintenance of change to live IBM Mainframe systems.
• Developed various tools in JCL, REXX, Excel etc. which improved our process, productivity and reduced manual effort. Those were highly appreciated by client.
• Have been responsible for support and resolution of problems around technology such as JCL, Control-M, TSO, ISPF, REXX, DB2, IMS DB and Beta 92.
• Have been providing necessary service to the development teams for system testing.
• Worked in permanent defect fixing by source code analysis, browse/promote components using Changeman, RDz workbench helping to bring down the defect count in EoD cycle in DvSZ significantly.
• Providing solution to application development teams for fixing defects/issues in DvSZ SIT. E.g. For some jobs which were taking long time to execute, the suggestion was to optimize Sqlcode by analyzing the code or optimize data by analyzing if old data is required or not.
• Have experience in monitoring the batch jobs running in the mainframe console and resolve any abended jobs.
• Worked on various tools like Changeman, SDSF, TSO tools, BETA92, and Control-M Graph.
• Have good understanding of Control-M scheduler (building up new schedules in Control-M), MVS / JES commands.
• Have experience in providing Mainframe Technical Support in MVS Z/OS platform in a Test environment.
• Have experience in analyzing PLI codes and defect solving.
• Have experience on writing automated tools in REXX.
• Have good knowledge on DB2 platform and solving the different type of SQL errors.
• Have experience on IMS DB and IMS DC.
• Have good knowledge on various IBM utilities.
• Have good knowledge on File Aid tools (DB2 and IMS).
• Have knowledge on message queue systems (IBM Web Sphere MQ).
• Have experience on Microsoft Excel tool with its different formulas.
• Have experience on creating good documentation.
• Have understanding of the current application environment.
• Have understanding on Data Analysis
• Have experience on coordinating with application teams for data requirement and testing
• Have experience in maintaining the quality documents of a project (faced internal audits, keep the documents updated of the project according to the current project scenario).

Confidential

Mainframe Developer

Responsibilities:

• Responsible for analysis of the work request and preparing detail design(Jackson diagrams) and developing PL1 codes, prepare and run JCL.
• Have a very good knowledge in various PL1 modules, their use and development of the modules.
• Have worked on PL1-DB2 program. Developed scratch programs using DB2 and IMS.
• Have worked on implementing IMS checkpoint restart in PL1 programs. Developed quite a few programs with such scenario where checkpoint restart is needed.
• Have worked on dynamic dispatcher jobs through PL1 code and Control-M scheduler.
• Have created detail specifications both business & technical and test case, log documents.
• Have worked on 6 major and 4 minor releases for this application in various areas. Have good knowledge of this application and its business rules.
• Have worked on DB2 SQL Optimization using concept of index scan. Used common table expression to optimize SQL codes in few areas.
• Have worked on creating DB2 tables by writing DDLs for many tables. Used check constraint and foreign key constraint while preparing DDLs.
• Have worked on various DMLs to fetch data from table with nested queries and joining 10-12 tables.
• Have played the role of offshore PoC for some CRs and delivered them smoothly till production.
• Have built up a tool in REXX for preparing Create, Alter and Drop DDLs for DB2 tables which is being used by the developers for creating new tables.
• Worked on the development of a REXX tool (DB2 Query Optimizer) to optimize DB2 Queries for a developer by accessing the plan table of that user.
• Worked on the development of a REXX tool which shows application data in mainframe batch. The same data can be seen in online through a GUI. For developers this tool is very useful during UT phase. Also when the online GUI is down for several reasons, users can use this batch tool to continue their work.
• Worked on the development of a review comment checklist for coding standard tool in Slick C. This tool will give warning for some best practice rules of coding standards which can’t be found in compile listing.

Confidential

Sr. Mainframe Developer

Responsibilities:

• Working as a single member team for mainframe development and support with no offshore support. She is solely responsible for everything on mainframe side for 3 different applications.
• As it is a migration project from mainframe to JAP, most of task are to migrate data from Mainframe DB2 databases to Oracle DB.
• Prepare SQL and JCL scripts for the data migration
• Works on various DMLs to fetch data from table with nested queries and joining 10-12 tables.
• Works on common table expression to retrieve specific data from DB2 database
• Works on JCL scripts with extensive use of SORT utility
• Analyze the business logic of different batches which updates databases and help the java developers to implement the same in front end.
• Production support of responsible applications.
• Works on Incident Management team and uses Service Now tool
• Support on adhoc data extraction request from different business guys.
• Fixing major and minor defects to keep the application up and running. Log and maintains defects in defect management tool ALM.
• Interacting with business guys directly to understand requirements
• Generates different reports for the application analysis and documenting mainframe code logic for migration planning.
• Resolves performance issue of many web services in collaboration with DB2 guys
• Analyze and compare data in DB2 and Oracle DBs
• Perform SCMV tasks for 3 different applications i.e. creating deployment requests, change requests, emergency deployment etc. in ChangeMan.
• Track and log the tasks in JIRA tool.
• Works on modifying DB2 tables by writing DDLs, load and unload batch jobs and deploy the tables in different environments.
• Helping the java developers in integrating web service modules to their code and change the host web service code if it was not compatible with the front end.
• Works on various PL1 modules(PLB, PLO, PLU, PLG, PL#, PLI etc.). Have a good knowledge on their use and development of the modules.
• Working in co-ordination with different application e.g. ALIS, PCR, NPMS, VDPS etc. which is sending or receiving feed from the WM application. She has to analyze dependencies and impact to other applications while changing the WM application code. So she has a good knowledge on impact analysis.
• Works on creating entirely new web services on mainframe platform end to end and creating new version of web services.
• Worked in Agile project with SCRUM method, delivered and given demo on Sprints. She has good knowledge in Agile Methodologies.
• Basic knowledge on PLSQL Developer tool i.e. Checking tables and DB, writing SQL queries on Oracle tables.