SUMMARY:

• Have 16+ years of IT experience in design, development & maintenance, conversion, production support, user acceptance testing, change migration support & DB2 DBA.
• Domains worked are Student Loan Processing, Health Care, Mutual Funds, Retail, Commercial & Investment Banking, Cards, Insurance, In - house product development, state and federal projects (GL).
• Expertise in Mainframe technologies COBOL, DB2, JCL, VSAM, CICS, IMS
• Worked exclusively on IBM technologies as well as supported distributed systems
• Worked on both Waterfall and Agile methodology (Scrum & Kanban)

TECHNICAL SKILLS SUMMARY:

Major skill set include: COBOL, DB2, JCL, VSAM, CICS,IMS

Operating Systems: MVS/OS-390, Z/OS, Windows 95/98/2000/NT/XP/VISTA/7, UNIX

Languages: COBOL, SQL,JCL,CICS,REXX

Database/ Database Tools: DB2(Versions 6 thru 11),IMS,VSAM,SPUFI,INSYNC,IBM DATA STUDIO,IBM COMMAND EDITOR,QMF,BMC,IBM DB2 ADMIN,PLATINUM,SQL Explorer,STROBE

Version Manager: CHANGEMAN,ENDEVOR,SCLM,LIBRARIAN

Tools: /Utilities: MQ messaging,XML,SORT,DTCN,ISPF Services,EditPlus

File Editors: FILE-AID,STAR TOOL,INSYNC

Program Analyzer: Mainframe Express,REVOLVE,CASEPAC,Projcl/Infox

Debugging tools: XPEDITOR(Batch and Online),DTCN,INTER TEST,ABEND AID,FAULT ANALYZER

Job Output Manager: EOS,$SAVRS,TOM,SAR

Report Manager: EOS,Infodevl View Direct, CONTROL-D

Job Schedulers: Control-M,TWS,CA-7, Control-M Enterprise Manager

Tape Manager: RMM,TLMS

CICS/Batch Monitor: TMONCICS,OMEGAMON

ISPF Services: Panels,Skeletons,Message Libraries

Reporting tools: TRMS,DYL280,Easytrieve

IBM Utilities: IEBGENER, IEFBR14, IKJEFT01, IDCAMS, SYNCSORT, IGYWCL, CSQUTIL, XMITIP

Testing tool: HP ALM Explorer(QC),HP Service centre

Business tools & Softwares: LIDP, TAS, INVESTONE, CRD, ANCHOR, VISTA, TOM (Trade Order Management),CARES,KOFAX,IMAGEPLUS,WORKFLOW

Others: PREPALL, JOBSCAN, PROJCL, JEM, XML, Rational Asset Analyzer, Embarcadero, JIIRA, Link, CATS, CELS, SmartTS, Serena Business Manager (Prod Change ticket process), Citrix Client for remote connection, Host on Demand 11, Outlook, Lotus notes

Intranet tools: Confluence, SharePoint

Timesheet tools: IPMS, Planview

PROFESSIONAL EXPERIENCE:

Senior Programmer Analyst & production support specialist

Confidential

Responsibilities:

• Provided mainframe batch production support and day time user initiated production incidents
• As part of IBM’s Imageplus conversion, assisted the project lead in the feasibility study of 2 approaches in conversion of one scanning software to the other. Alternate DB approach & reengineering possibility using MQ service. Estimated both approaches and created a proposal document to higher management for the decision. Got the alternate DB approach approved.
• Analyse, coordinate, design, assign, develop, test, review and implement the conversion.
• Created Business level documentation, process documentation, test plan documentation and obtain client approvals
• Generated reports using complex SQLs & Excel macros, generated extracts to Data warehouse team, provided nightly on call support and assisted Changeman Version upgrades
• Worked on lots of COBOL-DB2 batch application design, development and enhancements. These involved table design, table creation request using normalization techniques, SPUFI executions, SQL tuning using VISUAL & mainframe EXPLAINS, supported DB2 version upgrade from Version 9.1 to 10.
• Have interacted with mid-tier (TIBCO), front end (.NET & Java) and external agencies thru Stored procs (COBOL & Native SQL), MQ service, SWIFT messaging.
• Individually Setup DB2 Refresh Process (Unload from prod & load test tables) in Vanguard & Applied lean Six sigma quality principles on it and got it approved by the Client Manager and got Yellow belt certified.
• Have individually worked end to end from business requirement gathering thru post implementation for various individual requests and have performed huge retrofitting efforts for entire project and supported various periodical implementations.
• Have worked on researching & enhancing CICS programs. Have analysed IMS DB/DC modules. Knowledgeable on IMS data structures and embedded IMS programming both batch and online.

Test region DBA

Confidential

Responsibilities:

• Created, modified, synched table structures, Load/Unload or Data refresh from Prod to QA regions.
• Perform Quarterly Data Refresh of 1400 tables and 4400 files of entire QA applications ensuring data integrity
• Perform Data Objects Authorizations, spufi executions, image copies, Database maintenance activities like Reorg, Runstats, Rebind, Check data, Backup etc.
• Monitor and fix QA DB2 job abends, assist in admin aspects of NON DB2 issues (Dump and restore of files migration of change packages to QA, Batch Allocate &, deallocate files in CICS region) and ensure job completion within timelines.

Project Lead

Confidential

Responsibilities:

• Tasks acquisition from onsite and assign to offshore team.
• Analyse and create Estimation, Technical specifications for the allocated tasks
• Monitor, Assist & lead smooth execution of Enhancements meeting deadlines
• Perform reviews on the code, unit test plans and results.
• Review Packaging for certification, Create Certification test plan and Implementation plan for the releases and provide implementation support
• Maintain timesheets, perform quality mandates, IQA, EQA, Final Inspection, Metrics, Audit & PMR
• Manage and Maintain Project details on the Server and Prepare SOW for the agreement extensions
• Write unsolicited proposals and share to higher management.

Developer, UAT tester & Migration specialist

Confidential

Responsibilities:

• Extensively developed adhoc programs using COBOL, reading and writing of VSAM (ESDS, KSDS,RRDS & Reusables), & FLAT Files involving File, Table, character handling and report creating techniques.
• Handled FB, VB files on both DASD as well as on TAPES. Recover files from TAPE to DASDs, Manipulate GDGs.
• Extensively used File Aid and IDCAMS for VSAM file creations & deletion. IDCAMS to DEL/DEF, ALTER, DEFINE ALT INDX, PATH & BLDINDEX etc
• Used SMS to manipulate VSAMs thru JCL without IDCAMS.
• Extensively xpedited CICS & batch programs for production sev3 level tickets
• Extensively worked on background transaction processing in CICS and provided online oncall support
• Provided batch oncall support for PROD/QA/Model office jobs.
• Have worked on retiring legacy applications.
• As a UAT tester have created test plans and test scripts and executed manual testing
• As a Change Migration Specialist performed Endevor Migration Activities by reviewing and approving compliant client packages and Quality Assurance review of JCL / Procs
• As an In-house tool developer Used Rexx, ISPF utilities (Panels, Skeletons)
• Individually strategized, processed and accomplished $0.6m Cost Savings for ING thru various Mainframe cost saving techniques.
• Obtain knowledge for the applications of Confidential plans that needs to be supported.
• Provide production support by analysing and resolving health care claim incidents raised by users
• Resolve by researching CLAIMS GUI, Member GUI and Mainframe CICS screens and identify mismatches and provide resolution or assign it to appropriate area.
• Provide production support of mainframe batch applications in shifts
• Resolve batch abends (identify bad record, handle contentions etc)
• Create Change orders in SNOW application
• And move the temporary fix to production and ensure smooth batch application
• Handle service requests of Blue transfer application code program changes for the issues test the code changes and validate test result btain necessary approvals and implement the changes in production and provide post production support
• Identify and provide Continuous Improvement Activities for clients
• Identified a long running job in North America Blue star Illinois applications
• Researched and found the root cause of the issue to be huge volume of input historical claims VSAM file.
• Created process (DB2 unloads, SORT Joins, IDCAMS etc) and identified potential historical claims dated back to 1996 to be purged from input VSAM file
• Backed up the input file and purged the history data and showed improvement in CPU of the job
• Attend biweekly issue meeting going over the batch issues and resolutions
• Undergo client mandated training & certifications

Solution Environment and Tools: COBOL, JCL, VSAM, DB2, CICS, CA DB2 Product Platinum, SPUFI, ENDEVOR, INTERTEST,VDR Assist, ZEKE, File master tape read, DCD Xrefs, File-AID for files and DB2,SYNCSORT,SNOWSenior Analyst & Assistant Technical Lead

Confidential, Madison, WI

Responsibilities:

• Underwent training on Imageplus and Abstraction layer DB structures and processing.
• Assisted the lead in the feasibility study of the 150+ components (COBOL, JCL/ Controlibs, SAS). Analyzed the modules for abstraction layer approach or reengineering possibility using MQ service. Estimated both approaches and created a proposal document to higher management for the decision. Got the alternate DB (Abstraction layer) approach approved.
• Analysed Operational tables imaging impact and finalised 50+ impacted components.
• Coordinate with SME’s and technical leads in finalizing impacted components.
• Research Image Print process both batch and online to replace it with Java process and created new DB2 structures for the print process replacement and worked with DBAs to create the same.
• Create technical specification documents along with the team lead and assign it to self & team.
• Prod parallel tested the above changes and documented the test results
• Create process document and test plan document
• Executed Visual EXPLAIN for SQL changes and fine-tuned SQLs for better Service units
• Review team’s test plan document & help them on technical challenges.
• Obtain client approvals for the process document & test plan documents and implemented the changes

Solution Environment and Tools: COBOL, JCL, DB2, CICS, DB2 Data Studio, Insync, SPUFI, CHANGEMAN, MQ messaging services, File-AID for files and DB2, SAS,REXX, PREPALL, SYNCSORT, $avers, TRMS,CA-7,Test Management tools, DMR(Mask PII data during test copy), Automatic restart feature, QUICK START & BYPASS routines, File I/O handler that checkpoints for rollbacks and commits, CSQUTIL, XMITIP Rational Asset Analyzer, Embarcadero, Confluence, JIIRA, Link, Agile

Senior Mainframe Analyst

Confidential, Madison, WI

Responsibilities:

• For the report requirements created in CATS/JIRA by clients, analysed system, table data and prepared high level criteria document. (MS Word for SQL query, BLDs for Program change using VISIO)
• Generation of non adhoc reports -
• As required, coordinated with DBAs to create temp tables, get data loaded & generate reports comparing TEMP tables & CARES/ ACCESS tables
• For program changes, coordinated with production support team to request UT program, JCLs & generated report thru Request cycle(RQJ) cycle
• Ran query for selected partitions, unit tested the query result against approved criteria.
• Document the unit test results and other docs in CATS/JIRA and closely work with System & UAT (clients) team to get the report tested
• Once UAT approved, generated report for all partitions, formatted the output using various EXCEL macros and distributed it to clients
• Generation of Adhoc reports
• Generate routine Adhoc reports (using SQL queries & Excel Macros) on a weekly/monthly basis and distribute it to county and consortia clients.
• Enhanced Prisoner Data Match response process for Data Exchange subsystem
• Created prisoner verification details and data match discrepancies for different health program areas
• This involved COBOL, DB2, MQ, JCL changes
• Coded one time SQL queries to convert history records in Discrepancy table and work item table
• As part of ECF’s Electronic document management team, supported documents transformation from ECF to CARES
• Fixed routine and adhoc issues thru SPUFI’s.
• Provided system & acceptance testing & production implementation support
• Provided Pager support by fixing Mainframe production nightly Job abends on a rotation basis.
• Used Control-M for monitoring the jobs.
• Provided application support for Changeman Version upgrade from 7.1.3 to 8.1.
• Tested all major changeman functionalities with new changeman version in DEV & INT for various types of modules DB2, IMS, Stored procs etc and resolved issues with Confidential prod support team. And successfully provided implementation support and rolled out Version 8.1
• Helped application teams in scheduling test cycle jobs in Control-M, manually order, hold, force complete, rerun, etc

Solution Environment and Tools: COBOL, JCL,DB2,IBM Command Editor, IBM Data Studio, Platinum, SPUFI,CHANGEMAN,IMS DC, WebSphere MQ messaging, File-AID, JJ SCAN,HOD11,EOS,Control-M,JIIRA, CATS,CWW(CARES WORKER WEB),ACCESS

Team Lead

Confidential

Responsibilities:

• Undergo domain certifications in Cards and Payments & Self Study DNB Application documents.
• Brainstorm, raise queries and enhance understanding & Engage in Knowledge Sharing sessions with DNB SME”s
• Understand various Applications’ objective, functionalities, interfaces and conventions and understand online / batch processes and flow diagrams.
• Analyse IMS DB/DC programs using xpediting applications and extensively document Functional & Technical understanding of application.
• Perform playback to the SME’s using the document and get approvals
• Finalise the approved Understanding document into Application Maintenance Manual
• Worked on SEV 3 level tickets, involving xpediting programs using VSAM/flat file/DB2/IMS DBDC.
• Made necessary changes out of the understanding of the application and migrated using SCLM

Solution Environment and Tools: COBOL, JCL,DB2, IMS, VSAM,BMC, DB2 Admin, SPUFI, SQL,IMS DC, CICS, XPEDITOR,SCLM,TWS, HOD, Tivoli Output ManagerSenior Developer