Sr. Mainframe Analyst

INFORMATION TECHNOLOGY PROFESSIONAL

Career Summary:

Project Lead and Analyst for Mainframe with distributed Technologies with extensive experience in diverse software systems applicable to Financial, Brokerage, Health Insurance, International Shipping, Telecommunication, Credit Card processing, Retail and other broad range of opportunities, markets and industries. Supported by in-depth experience in legacy System integration and emerging technology Systems

TECHNICAL

SOFTWARE : ROSCOE, CICS TRANSACTION GATEWAY, XML, EASYTRIEVE, SAS,

CLIST, REXX, APS, MQ Series, FTP, NDM, C: D, TSO/ISPF,

XPEDITER, SMARTTEST, INTERTEST, INSYNC,

DUMPMASTER, SYNCSORT, DIALOG MANAGER, ERWIN,

INFORMATICA, BMC, RC-UPDATE, TOAD, MS-SQL SERVER 7.0,

DB2, ORACLE 9i, SQL*LOADER, UNIX, CICS, GT-ASSIST, IMS

DB/DC, IDMS, DATACOM, DG-RDBMS, VSAM, DBASE III plus,

DBAM, LIOCS STRUCTURES, MS-PROJECT, VISIO, CHANGEMAN,

ENDEVOR

LANGUAGES : COBOL OS/VS, COBOL II, C, JAVA SCRIPT, JAVA, VISUAL BASIC 6.0, SQL, PL/SQL, SQL*Plus, RPG II, INFORM

PROFESSIONAL EXPERIENCE

SEP 2006 – To Date UPS, Morristown, NJ, USA

* As member of Production support Team for Billing and Operations of International Shipments, make Production fixes, Write RFC's, Analyze code in QA environment and implement fixes in production environment, post implementation support of the fix

* Improve performance of Application processes, On call support

* As member of Release team for Billing of International Shipments involved with analysis, design, coding, testing, Production implementation, post implementation support of Initiatives of the Release

* Design based out of requirements for the release which entails creating functional and Technical document for Initiatives of release

* Analyze Code, Production data, looking at Screen wire frames, generated reports and review functional and Technical documents with business Users

* Create TEST PLAN, TEST Scenario’s and TEST cases for Test of changes to be implemented. Testing effort comprised of Unit Test followed by User Acceptance Test assisting Business users with the TEST and finally getting sign off for its implementation in Production

* Changes are migrated to librarian and promoted to production environment. Implementation is accompanied documentation for turnover, listing purpose of the change and associated technical details, providing retracting procedures in case of issues encountered with implementation of the change

ENVIRONMENT: DB2 7.0 using Stored Procedures, MQ Series, COBOL II, CICS, JCL,

ChangeMan, BMC, RC-Update, FTP, UNIX, TOAD, Oracle 9i,

SQL*LOADER, SQL*Plus

SEP 2005 – SEP 2006 UBS, Weehawken, NJ, USA

* Member of Product & Pricing application team (Wealth Management) thereby design, code, unit test and UAT for release with business partners

* Production implementation, post implementation support of Initiatives namely NASDAQ Symbolic Change, Eligibility, and Automated Prospectus for Securities. Application comprised of front end Java screens making back end calls to CICS & DB2 Stored Procedures

* Enhancements to Audit reports generated in batch environment

ENVIRONMENT: JAVA, DB2 7.0 using Stored Procedure, COBOL Z/OS, CICS, JCL,

Change Man, BMC

MAY 2004 – SEP 2005 Vanguard Group, Malvern, PA, USA

* Development of Case Management Application for Problem and Sales

* Create and review USE CASE’s created from requirements gathered by technical business analyst for Case Management Application also called Client Experience

* Review Logical & Physical Database Models

* Analyze, Design and code programs

* Create technical specifications in a Net Centric environment comprising of UI, Objects and Data adhering to the pre-defined organizational architecture, designed to enhance performance. Application goal was to improve customer relations for organization’s retail and commercial customers by providing a quick insight in to client accounts, thereby resolving issues before their occurrence for existing accounts and pursuing sales objectives of bringing assets in by identifying potential prospects and maintaining record of calls made.

ENVIRONMENT: XML, Java, DB2 7.0 Stored Procedures, MQ Series, COBOL Z/OS,

CICS, JCL, ENDEVOR, ERWIN

MAY 2003 – MAY 2004 (FEPOC), CareFirst BlueCross Blue Shield, WASHINGTON DC,

USA

* Data conversion of Claims History database residing on DBIII, a GHI Product, comprising of VSAM with RLS feature to DB2. The conversion effort was carried out in number of phases

* Co-ordinate with various business groups invoking data layer modules. Ascertaining proper functioning of application code

* Test data layer comprising of Parallel, String, performance, system & Plan tests. Business accessed data layer via WEB, MQ & Mainframe

* Extract data from DBIII, generating flat files of data for load to DB2, Loading flat files to DB2

* Post implementation support. Make code fixes to data layer, design & analysis of data layer. Also involved in second phase of data layer conversion and thereby created functional and technical specifications.

ENVIRONMENT: TMON 3.3, Strobe 3.0, COBOL Z/OS, CICS 6.2.0, DB2 7.0 Stored

Procedures and triggers, MQ Series, ERWIN, CHANGEMAN 3.0,

XPEDITER 7.2, File AID 8.8.2, MS PROJECT, SQL-Server,

INFORMATICA

MAY 2001 – APR 2003 BLUE CROSS BLUE SHIELD, SC, USA

* Member of TMCS HIPAA Re-Write team. TMCS serves as point of contact by

doctors, registered nurses, and medical service technicians. Access to

internal systems such as PIMS, INFORM, Claims History, Membership and

ALGS letter writing is also available through TMCS Main Menu. TMCS is

Online real-time data repository of patient and provider information serves

three primary purposes

Documentation of clinical history and notes

Authorization of services used in claims adjudication

Cost savings information through reporting

* Code and implement On Line CICS application system to process HIPAA 278 inbound and out bound transaction request/response segments arriving from WEB in EDI ASCII X12 format. The EDI Gateway interface programs perform HIPAA X12 syntax, IG syntax and semantic edits (using SYBASE paper free translator) and use MQ Series to send these request transaction records to Enterprise server. TMCS application interacts with MQ Series, determines the syntactical correctness, insurance coverage and medical necessity of the 278 transaction request and loads to various DB2 and IMS databases

* Maintenance of Online CICS application screens to display and provide edit capabilities for new HIPAA Codes

* Maintenance of Batch End reporting systems to adapt new HIPAA Code sets and procedures

ENVIRONMENT: APS, COBOL, IMS, DB2, CICS, MQ Series, GTASSIST, OLR,

SMARTEST, VISTA, ENDEVOR, UNIX

MAY 1998 – MAY 2001 VERIZON, NY, USA

* Member of Tech Team to provide support for various tools coded with blend of CLIST, REXX & DIALOG MANAGER, being used by groups namely Development, Testing, Customer service group, who were involved with the Maintenance & enhancement of Carrier Access billing system

* Provide support for CAFÉ, a front end to CABS via Oracle Gateway

* Handled trouble tickets generated by users for any production problems, investigated the cause utilizing TOAD, SQL*Plus, UNIX shell scripts and employed solutions

* Analysis of code pertaining to IMS DB/DC, CICS & MQ-Series

* Write DB2 stored procedures, triggers

* Ship code for Application releases using ENDEVOR

* Execute DB2 utilities namely Run-stats, Re-orgs, Image Copies, Load, Unload

* Archive DB2 Data to improve performance. Performance tuning of the code as well as SQL Queries using monitoring tools namely STROBE and OMEGAMON

* Maintain jobs using SAS to automate process of binds & Grants of DB2 Packages and plans

* Generate PSB's, RTT's in IMS Environment

* Code IMS exit routines

ENVIRONMENT: DB2 (PLATINUM, BMC TOOLS), IMS, SAS, EZTRIEVE, REXX, CLIST,

COBOL II, TELON, MQ-Series, Dialog Manager, STROBE,

OMEGAMON, XPEDITER, INTERTEST, INSYNC & DUMPMASTER,

VISUAL BASIC 6.0, ENDEVOR, UNIX, SQL*Plus, TOAD

MAR 1997 – APR 1998 FIRST DATA MERCHANT SERVICES, MELVILLE, NY, USA

* Analysis of Credit Card processing to converge systems from North to systems from south in order to facilitate a merger.

* System study and generation of Adhoc reports as per user requirements pertaining to Credit Card Processing business.

* Led a team, Database Design study of systems from North and South to create common data model

* Identify User Interface and batch processes for convergence thereby co-ordinate between users and the team

* Monitor project tasks using MS Project

* Create Specifications as per User requirements

* QA of final deliverables to be supplied to Users

ENVIRONMENT: IBM PC, COBOL II, EZTRIEVE, OLQ, IDMS, SORT, MS-PROJECT, WORD, EXCEL, VISIO

EDUCATION

Post Graduate Diploma in computer programming, system analysis & application

from Board of Technical Education, Govt. Of Maharashtra, India

Diploma in Operational Research for Management, University of Bombay, India

Bachelor of Science in Statistics from University Of Bombay, India

REFRENCES

Furnished upon request

Contact this candidate