SUMMARY

• Over 20 years of Analysis, Design, Development, deployment and L3 production support for various business application systems using TSO, ISPF/PDF, z/OS, MVS/ESA, OS/390, UNIX and WIN’ Environment
• Software Design, Development, Maintenance and Testing of various Applications in COBOL II, DB2, CICS, JCL, VSAM, TELON, Teradata, Java, J2EE, JSP, Servlets, EJB, JavaScript, XML & HTML.
• Expertise in performance tuning the SQL queries and working with SQL Assistant.
• Expertise in analyzing existing metadata and adding structured metadata information for new database entities.
• Experienced in leading/managing large teams including onshore/offshore model.
• Expertise working with Change man tool to create new packages, approval process and deploying the package into production environment.
• Expertise in CAB change management process, Agile methodologies, working with MAXIMO tool to create RFC and code deployment.
• Expertise in writing COBOL, DB2 and CICS programs in z/OS, TSO/ISPF environment.
• Expertise in writing JCL, PROC's and automation process using PODS and CA7 tools.
• Expertise in Creating Views, alter Tables, Indexes, REORG, RUNSTAS Utilities, Image copy of Table space, IDCAMS utilities, creating triggers for table updates, running various queries using QMF/SPUFI DB2 utilities, Loading & unloading the tables.
• Expertise in tuning Complex queries, debugging SQL error codes and helping peers in problem solving.
• Expertise in creating test plans, test cases and test scripts for the new and modified programs.
• Expertise in loading Production data in to testing environment and downloading Mainframe QMF results into PC using FTP protocol and mainframe Express.
• Expertise in writing structured Copybooks, Date Validation and Data validation routines.
• Excellent knowledge with Unit Testing, Regression Testing, Integration testing, System acceptance testing, Client Acceptance testing, Production implementation and maintenance.
• Expertise with full Project Life Cycle and Project Management, Standards and Configuration Management, QA Management, Change Management, Team Management, Documentation, Implementation.

TECHNICAL SKILLS

Hardware: IBM z series, S/390, ES/9121,S/3090, Data Generator and Micro Focus - Workbench

Operating System: TSO/ISPF, z/OS,OS/390,MVS/XA/ESA,VSE, UNIX, USS on z/OS, Win’XP/Vista/NT

DatabasesDataDatabases: DB2, Teradata, VSAM, FOCUS, Oracle 10.1 & SQL Server

Languages lllllLanguages: COBOL II/LE, Pro COBOL, SAS, EAZYTRIEVE, CICS Command Level, JCL, CLIST, Mainframe FOCUS, C, Java, J2EE, JSP, EJB, XML, XSLT, JavaScript.

Software products: DB2 Connect, Mainframe Express, Debug Tool, File Manger, Informatica Powercneter9, TELON, SAR, Endevor, Changeman, Xpeditor, FileAid, BMC utilities, Syncsort, FTP, QMF, SPUFI, ISPF/PDF, ELIPS, SDF-II, INSYNC, NDM, PIPE’s,BMS, Autosys, Splunk, Introscope, Sitescope, IDCAMS, IBM Utilities, RIMDOC, CA-7, ABEND-AID & ROSCOE, MS Office, MS-DOS/WORD/XL, WebSphere Studio(WSAD), Eclipse, SVN & WebLogic

PROFESSIONAL EXPERIENCE

Confidential

Production Services Lead

Responsibilities:

• Managing the multiple Offshore/Onsite model teams.
• Production primary L3 oncall support for batch Legacy mainframe application DTB. Addressing the batch abends. Analyzing the JCL, COCBOL & VSAM files for recurring abends to find the root cause and design gaps and recommending the development team for the fix. Working on performance tuning the application and developing code and deploying the endeavor packages to automate the various alerts and adhoc reports.
• Responsible for Production primary L3 oncall support for Autosys Batch & real time BankAmeriDeals ETL application. Addressing production autosys job failures by analyzing the workflows and recovering the data if needed before restarting the failed session.
• Responsible for joining the bridge line for the production unplanned outages and leading the triage call to bring the production environment back to BAU and analyzing the root cause of the failure.Generating FCI’s using Splunk and Introscope monitoring tools.
• Responsible for performing L3 support tasks during integrated/independent releases, various upgrade and patching Activities to production environment/infrastructure.
• Responsible for creating the access requests to the team, Nexus and JIRA requests for creating dash boards and monitoring alerts using Splunk, Sitescope and Introscope monitoring tools.

Environment: z/OS, COBOL II, TSO/ISPF, MQ, CICS, JCL,VSAM, Endevor, JIRA, PODS, Java/J2EE, JBoss, WebSpehere, INFORMATICA POWER CENTER9.5.1, Autosys, Oracle, SQL Server, ISS, UNIX,File-aid, FTP and NDM.

Confidential

Technical Analyst

Responsibilities:

• Writing SQL scripts in Teradata and executing utilities such as Fast Export, Fast Load, MLOAD,BTEQ and Teradata parallel transporter.
• Creating mapping between source and target tables, creating, sessions, maplets, worklets andwork flow diagrams and executing work folw diagrams to load data into target tables..
• Unloading the Teradata from production environment and loading various test regions.
• Performance tuning the Teradata SQL queries, making non-compliant queries compliant andworking with SqlAssistant to test the various SQL’s...
• Helping the team in Teradata development and implementation procedure.
• Analysis, design and development of new COBOL,DB2,JCL programs and modifications to existing applications in Z/OS, TSO/ISPF environment.

Environment: z/OS, TSO/ISPF,COBOL-II, DB2, VSAM, JCL, SPUFI/QMF, CHANGEMAN, Teradata, SQL Assistant 13.1,FILEAID, XPEDITER, JIRA, SPM tool, SFTP, MAXIMO, Share point, Java, J2EE, JDBC and NDM.

Confidential

Lead programmer Analyst

Responsibilities:

• Responsible for working as Tech lead for maintenance team and conducting weekly status review meetings.
• Responsible of providing technical assistance to the team members in Maintenance team.
• Responsible for keep track of new changes to database/business process as per client requirement and keep the developed code in-sync with changes.
• Analyzing the requirements, identifying the data elements required to address business process and submitting database request to DBA.
• Loading COBOL flat files, XML data into the Teradata databases using Informatica power center.
• Having good experience Data extraction and Data loading of flat files and relational sources.
• Loading the data into the data warehouse by creating mapping, sessions, work flow diagrams andtransformation.
• Writing the Teradata SQL stored procedures and tuning the complex SQL queries.
• Design and development of Cobol/DB2 batch programs for premium cash receipt process, lock box process
• Developing and testing COBOL/DB2 programs for finance refunds process and sending OPUS to generate Premium invoice letters and Refunds letters.

Environment: z/OS, TSO/ISPF,COBOL-II, DB2, Teradata, Informatica power center8.x, SQL Assistant, XQMF, SPUFI, Unix System Services, Shell Script, ENDEVOR, Debug Tool, File Manger, Share Point, Java, J2EE, Java beans, XML, Ant, Subversion & Eclipse.