SUMMARY:

• Solid experience of 25+ years in Full SDLC (managing, design, analysis, writing tech specifications, coding, unit testing, QA testing, Implementation, Prod support, documentation) using various technologies such as Mainframe, MQ Series, UNIX, and Web technologies and variety of Business applications.
• Managing Teams, Lead, Senior Analyst, Senior Programmer/Analyst,, Senior Developer
• Strong skills in all phases of the Full Software development life cycle
• Major player to work in a Team environment
• Managing, Leading Teams as well as a good Team player
• Worked extensively on Cross Platforms and Automation.
• Worked with Off - shore extensively
• Experience using variety of Software
• Experience in variety of Industries
• Experience both in Consulting and Full Time environments

TECHNICAL SKILLS:

SOFTWARE: COBOL, COBOL II, DB2, SQL/DS, CICS, VSAM, UDB, DATACOM DB, RDB, IMS DB/DC, SAS, SQL, CSP, TSO/ISPF, JCL, ENDEVOR, CHANGEMAN, MQ SERIES, INFORMATICA (ETL), TEST DIRECTOR, DIMENSIONS, XPEDITOR, INTERTEST, IBM DEBUG TOOL, SMART TEST, RACF, STORED PROCEDURES, ADR, VISUAL BASIC(6.0), SYNCSORT, REMOTE PROCEDURE CALL, MICROFOCUS COBOL (NETEX), REXX, INFOPAC, ROSCOE, PANVALET, LIBRARIAN, FILEAID, IDCAMS, CLIST, QMF, SPUFI, PROEDIT, EASYTREV, QUICKJOB, GMT, REPORT WRITER, QSAM, VISIO, FOCUS, POWER BUILDER(4.0). HTML, DHTML, CFML, XML, JAVASCRIPT, VBSCRIPT, COLD FUSION, SQL, ASP.NET, FTP, VISUAL SOURCE SAFE, HOMESITE, MS ACCESS, MS WORD, MS EXCEL, MS Project, LOTUS NOTES, MS OUTLOOK, DOCUMENTUM, etc. MVS/XA, MVS/ESA, UNIX, WINDOWS 2000, VMWARE etc.

INDUSTRIES: Retirement package - Defined Benefits (DB), Health & Welfare (HW), Health Care, HR/Payroll, Pension/Payroll, Educational Testing System, Re-Insurance (Claims Processing), Brokerage, Insurance, Sales, Finance, Inventory Control, Merchandise Software, Performance Analysis, Human Resource, Purchase Order, Billing, Banking, and Payroll etc.

PROFESSIONAL EXPERIENCE:

Confidential, Secaucus, NJ

Data Lead / Senior Functional Analyst

Responsibilities:

• Involved in the development and maintenance of HR/Payroll, Health & Welfare and Pension & Payroll inbound process to load the processed data into different areas such as Master File (PMAS) and SYBASE tables and in turn to DB2.
• Also involved in the support role for other clients
• Work involved studying Business requirements (BRD), System Analysis, writing Technical Specifications, Programming, Getting environment ready before loading the data for Business, Creating Sybase tables and then Loading raw data in to them either via UNIX scripts or Informatica (ETL), validations were done using ffvalidate, support Testing, preparing Processing Notes (for Business), Service and Operation change document for Prod support - following up creation of Production Jobs (JCL / PROC), Automation in both MF and UNIX environments, Production support, documentation etc.
• Data updates were processed using SQL as well as Partial loads, Creating and posting Zip files on SFTP with password verification.
• Used PASS and PENSION screens very efficiently to research, Analyze and to update the details per the requirements.
• Studied and researched Calc Specs per the requirements and provided results to the team.
• Involved in an automation of 361 Vendor reports to eliminate a Manual step via Mainframes by working on BRDs with developers and analyzing data and results.
• During Production support role managed Regression testing very efficiently at times had to work almost thru the night.
• Each week performed Pre Prod regression testing and generated Compare reports to make sure it is smooth sailing during the Prod move.
• Wrote new SQL queries on a regular basis while doing Business Analysis.
• Error Analysis from the generated reports and proving resolutions from Business, System and Technical point of view.
• Maintained existing programs and Developed new ones per the Business requirements both in Online and Batch environments..
• As Data lead oversaw entire Data updates requests for the Client
• Regularly added new features to the existing process.
• Supported Unit Testing, UAT and involved in Production support.
• This work was done using SYBASE, DB2, SQL, JCL/PROC, KLG Tools, Partial Loads, PENSION and PASS screens, MS ACCESS, MS EXCEL, FILEAID, QUICKJOB, GMT, REPORT WRITER, INFORMATICA (ETL).

Confidential

Responsibilities:

• Involved in a full life cycle of development and maintenance of a Healthcare System.
• Did System analysis, wrote Tech Specs, Coding, supported testing.
• Also involved in Production support.
• Involved in creating documentation.
• Worked on the New Case Installation and Plan change (maintenance) of the case while working on several screens and batch programs.
• While maintaining the system added new fields to different screens, and then related changes to different programs and databases as well.
• Wrote new programs, updated existing ones.
• Created HIPPA Letters updated different databases DB2/IMS via different programs.
• Worked on different subsystems like Adjudication. Claim verification, Pricing etc
• Involved in Unit test and QA test plan and testing. Support role for UAT.
• Used MQ to pass data back and forth to the front end.
• Developed and Maintained MQ programs. Involved in development and maintenance of Stored procedures.
• Used them regularly to access DB2 database using Cobol.
• Worked in both Online and Batch environment.
• This work was done using COBOL II, CICS, DB2, APS (4GL), IMS/MFS/DLI, MQ Series, MS EXCEL, VSAM, JCL/PROC, FILEAID, XPEDITOR, SMART TEST, ENDEVOR, EASYTREV, TEST DIRECTOR, under MVS IBM 3090.