SUMMARY:

• Complete System Development Life Cycle experience including analysis, design, development, testing and support in Mainframe environment.
• Strong experience in COBOL II, DB2, CICS, JCL, VSAM in Z/OS environment. Good programming experience in reporting languages like SAS, CA - Easytrieve plus and VISION:Results (DYL-280).
• SAS Certified Base Programmer for SAS9. (Oct 2009)
• Good experience and expertise in Base SAS, SAS/AF, SAS/SCL, SAS/PROCs, SAS/MACROs and SAS database in SAS 8.0, 9.0 and 9.1
• Expertise in Natural, Adabas, PL/1 and COBOL in mainframe environment.
• Expertise in MF-COBOL Workbench, ISAM and PC-CICS in PC environment.
• Good Experience with Data Modeling, Database Design and Administration
• Expertise in DB2 UDB EEE, DB2 AIX/UNIX and MVS environment.
• Good experience with Oracle, Teradata databases on UNIX.
• Work experience in financial departments of state and federal government agencies and healthcare.
• Ability to interact with end user, managers and technical personnel, self motivated and quick learner..
• Excellent oral/written communication skills and a good team player.

KEY WORDS:

SAS 9.1.3, 8.0 ( Base SAS, SAS/AF, SAS/SCL, SAS/PROCs, SAS/MACROs, SAS/SQL, SAS Enterprise Guide 4.0, SAS database), JCL, Natural, Adabas, PL/1, TSO/ISPF, VS COBOL II, CICS, DB2, ORACLE, Teradata, CA-7, UNIX, ChangeMan, Vantive, FileAid

TECHNICAL SKILLS:

Operating Systems: MVS, OS/390, z/OS, WINDOWS, UNIX, Solaris

RDBMS: SAS, DB2, Adabas, Teradata

Languages: SAS, COBOL, Natural, PL/1

Reporting Tools: SAS, EZTrieve and VISI ON Results (DYL-280)

Financial packages: Federal Financial System, Government Financial System

Tools: MVS Utilities, Endevor, FileAid, CA-7, ChangeMan

AREAS OF EXPERTISE:

System Development Life Cycle.

SAS Certified Base Programmer for SAS9.

SAS, SAS EG, COBOL, CICS, VSAM, CA-7, DB2, Oracle, Teradata experience

Systems integration across platforms.

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

Apps Systems Engineer

Responsibilities:

• Worked on ACT (Access Certification Tool) system.
• ACT is the enterprise wide certification tool. All applications, users, resources, entitlements and configuration detail from every system is sent to ACT. ACT certifies all records sent.
• Worked on ACT onboarding including adding new applications and also worked on modification to the existing feed to ACT.
• Worked on SAS macros, SAS-SQL. Wrote new programs and modified existing SAS programs.
• Processing was done in batch mode in mainframe environment using JCL, Enterprise COBOL, CA-7.

Environment: Confidential z/OS, SORT, JCL, SAS 9.1, Endevor, CA-7, VSAM, SQL, Pac-2000, Enterprise COBOL

Confidential, Sacramento, CA

Application Developer COBOL

Responsibilities:

• Analyzed daily and weekly scheduled run mainframe COBOL programs.
• Analyzed COBOL programs and did impact analysis on upcoming changes to the production system.
• The changes are due to new federal laws and updates in HIPPA regulations.
• Identified the impacted components including COBOL source code, INCLUDE members, copy books and report programs.
• Analyzed the upstream and downstream jobs and subsystems. Document the impact analysis as word document.
• Created Functional Specification Document and Technical Specification Document.
• The document listed the components by subsystem.
• The detailed changes were included in the document.
• Created Technical Specification Document. The document highlighted the pseudo code changes of each component.
• The test plan and test cases were included in the document.

Environment: Confidential Mainframe, Enterprise COBOL, JCL, VSAM, ISPF, Confidential File Manager, MS-office Word

Confidential, Vacaville, CA

Consultant - Programmer Analyst

Responsibilities:

• Documentation, analysis, coding, unit testing and system testing for the modifcation of Policy and Billing system.
• Studied the existing system and documented.
• Modified the code on issue basis.
• Preparing the project plan, scheduling, estimation for small as well as large work requests.
• Worked on extracting and loading DB2 tables
• Modified and added new reports to the existing report programs.
• Compared and validated new reports by performing regression testing with existing reports in test environment.
• Extensively involved in various stages of testing Unit Testing, System testing and Integration testing.
• Installed new Jobs in the production environment.
• Involved in Production support of installed jobs.

Environment: z/OS Rel 1.13, Confidential Enterprise COBOL for z/OS 3.4.1, Compuware COBOL Compiler Rel 8.8, DB2 SQL PreCompiler Ver 8 rel 1.0, DB2 Version 8, CA-Panvalet Version 14.5, CICS, SAR, ISPF, BMC Tools Version 10.1, FileAid/DB2 Version 6.3, FileAid/MVS Version 9.4, CA SysView 13.0 (job output), serena comparex/ISPF 8.6.1, Xpediter/TSO 9.2, Abend-Aid, CA- JCLCheck 7.1

Confidential, Tempe, AZ

Programmer

Responsibilities:

• Modified IMS DB/DC COBOL programs in SCEPTRE application.
• The project is to modify the transactions in SCEPTRE application to use the new aircraft number assigned as a result of the merger of US Airways and Confidential .
• A translation table is maintained to convert old aircraft number to new one.
• Involved in modification of COBOL programs and testing.
• Browsed contents of data files using FileAid, for test results validation.
• Created test plans and test cases.
• Involved in all stages of testing including unit testing, system testing and integration testing.
• Created production installation timeline schedule.
• Debugging of COBOL code was done using Xpeditor.

Environment: Confidential mainframe, TSO/ISPF, IMS, Enterprise COBOL for Z/OS 3.4.1, FileAid for IMS Rel 7.6, Xpeditor for TSO 9.1, SCLM

Confidential, Chandler, AZ

Programmer

Responsibilities:

• Maintenance of CICS web services (CWS) between applications - PMP, LAWS, CWS and SHAW.
• Updated COBOL code and tested the modified code using SOAPUI.
• Created test plans and test cases.
• Participated in meeting with all stakeholders to discuss about the unresolved issues and the progress of the effort by each affected team.
• Used SOAPUI as testing tool for CWS.
• Created projects, service requests and reviewed the service responses.

Environment: Confidential Mainframe, COBOL, CICS Web Services, Link3270, XML, SOAPUI

Confidential, Sacramento, CA

System Analyst/Programmer

Responsibilities:

• Created analysis and design documents including System Architecture Specification and Application Design Specification. The documents were created as per DOJ document template.
• Identified all the stakeholders for each application system including SME, data owners and production support personnel.
• Scheduled, organized and lead the meetings to collect the artifacts and knowledge needed to create the specification documents.
• The documents were created as documentation for the existing in - house built web-based applications.

Environment: J2EE, Jira, MS-Office products, Clearquest

Confidential, Sacramento, CA

Lead SAS Application Programmer

Responsibilities:

• Created adhoc reports for SOMS (Strategic Offender Management Systems) from SOMS data, SOMS Level2 warehouse, calparole, HoldWarrantsDetainer and DDPS systems.
• Created reports using Base SAS, SAS macros and procedures.
• Outputs were in PDF files and excel outputs.
• PDF outputs ere in Portrait and Landscape formats. Excel reports were ODS formatted using excelxp tagsets.
• Used PROC PRINT, PROC REPORT, PROC TABULATE and PROC EXPORT.
• Created reports for parole population, temporary release, COMPAS assessment, PRCS (Post Release Community Supervision) and US ICE.

Environment: PC-SAS, SAS 9.3, Enterprise Guide 4.3, SAS/ODS, SAS/SQL, SAS/MACRO, Base SAS 9.3, SAS/MS-Office products

Confidential, Sacramento, CA

Lead Programmer Analyst

Responsibilities:

• Responsibility is to do get the data from eServices and save the data in existing system so that further data flow is handled by existing system.
• Participation in all stages of SDLC including business requirements, system requirements, design, coding, test plan preparation and all stages of testing.
• Wrote stored procedures in ASE to validate data and update Sybase tables, batch COBOL programs and shell scripts for data refresh and batch process.
• Wrote COBOL programs using DB2, CICS, VSAM for backend processing for the functional specification.
• Worked on extracting and loading data to DB2 tables.
• Collected data from SLA (Service Level Agreement) document.

Environment: Sybase ASE 15.0.3, ASE bcp utility, Solaris ver 5.10, Micro Focus Server Express V5.0, UNIX shell script, Sybase Embedded SQL Preprocessor, Sybase ESQL, COBOL, DB2, VSAM, CICS, JCL, SQL

Confidential, San Francisco, CA

Lead Programmer Analyst

Responsibilities:

• Code, test and implement mergers & acquisitions subsystem to include new companies.
• Maintained components using Endevor.
• Created new CA - 7 networks which are triggered by the files sent from the newly acquired bank.
• Conversion or translation of balances and transactions data / activities received as input and post them to the General Ledger application.
• Wrote utility in SAS to track the usage of copybooks in currently used production jobs using Endevor Search.
• Wrote COBOL programs using DB2, VSAM.

Environment: CA-7, Confidential Enterprise COBOL for z/OS 3.4.1, DYL-280, SORT, JCL, SAS 9.1, Endevor, CA-7, DB2, VSAM, SQL

Confidential, Sacramento, CA

Sr Programmer Analyst

Responsibilities:

• Support and maintenance of OBIS (Offender Based Information System).
• Batch interface programs for internal clients of Confidential including SOMS, DDPS, VSRIS, CODB, OISB and external clients of Confidential including DOJ, SSA, DHS.
• Modification, testing, documentation of batch (Natural) and online (PL1 and Natural) programs.
• Processing and support of daily/weekly/monthly/on - request jobs for creating interface files.
• Attended problem issues through (on-call support) by remedy tickets. Fixed JCL problems using SYNCSORT.
• Worked in user discussion to identify change in specification and scope of the job/project.
• Performed systems analysis, high level design and detail design.
• Performed entire software life cycle (SDLC) starting with Requirement, Analysis, Design and Development and testing. Created functional and technical specification.
• Created data Flow diagrams, Process flow diagrams, table design specification.
• Performed Business analysis, Use Case Preparation and technical support for application related issues
• Performed System / QA testing. Created test plan and test cases.
• Performed DB2 Load /Unload, Performance tuning of applications
• Provided 24 X 7 production support for applications.
• Wrote COBOL DB2 CICS VSAM programs including singleton select, select SUM and cursor select statements.

Environment: Mainframe, Natural 4.1.4, Adabas 7.4.4, PL/1 LE 3.7, CICS TS 3.1, JCL, Syncsort, Fileaid, TMS, TSO/ISPF, MS-Office products, Panvalet 14.5, Remedy, zOS1.9, CICS, DB2, VSAM, CA-7, SQL

Confidential

Data Consultant - Market Strategy and Analysis

Responsibilities:

• Worked in the analysis, coding and running of monthly jobs.
• Created datamarts and reports that contain membership counts and add - term counts.
• The reports were created as membership counts at product level (ASO-Admin Services only and KPIC-KP Insurance Company), segment level and line of business level.
• Worked in the analysis and creation of COBOL programs and jobs for Length of enrollment for each Confidential Record Number.
• Worked in the updating and running of monthly reports for federal segment, national market research analysis, PID level for labor and trust and national segments, creation of public databases, monthly growth report for national accounts, add-term PU group and add-term report for major and minor Line of Business.
• Reports were created in mainframe as delimited files and loaded to excel spreadsheets in PC and formatted.
• Documentation of programs and jobs using Microsoft Visio.
• Performed systems analysis, high level design and detail design.
• Performed entire software life cycle (SDLC) starting with Requirement, Analysis, Design and Development and testing.
• Prepared project plan, scheduling and estimation for small as well as large work requests.
• Created COBOL adhoc reports for the functional specification.
• Wrote online and batch COBOL programs using DB2, CICS.
• Collected data for SLA (Service Level Agreement) document.

Environment: Mainframe, JCL, mainframe utilities including Syncsort, Fileaid, NDM, Extra Personal client, WS-FTP Pro Ver 8.03, WinZip 9.0, MS-office products, mainframe SAS Ver 9.1.3, SAS Enterprise Guide 4, Teradata SQL assistant 7.2, Advanced Query Tool Ver 8, DB2, CICS, COBOL II, JCL, SQL

Confidential, San Francisco, CA

Sr Lead Application Engineer

Responsibilities:

• Supported QA team. Involved in the creation of test data. Involved in system testing and regression testing of the modified elements using CA-7 and endevor in test environment.
• Performed regression testing, compared the outputs from the production and testing environments using INSYNC.
• Performed coding, testing and packaging of small and medium sized enhancements in the form of change requests and work requests to the General Ledger system.
• Responsible for systems analysis, design, development of Batch and Online COBOL programs using DB2, CICS.
• Maintained existing programs, made changes as per change request and supported the financial application in production environment.
• Performed documentation of programs and jobs using Microsoft Visio.

Environment: Enterprise COBOL for zOS ver 3.3.1, CICS transaction server version 3 Rel 1.0, DB2 V8R1M0, Endevor 4.0, Connect:Direct OS/390 Ver 4.5.0.0 (to NDM), JCLPREP Ver 6.3.0, INSYNC 5.300, CA-7 Rel 3.3, CA-11 3.0, zOS, TSO/ISPF, SPUFI, BMC software products for DB2, Savers, VISI ON:Results (DYL-280) 5.0, CA-EasyTrieve Plus 6.4.0311, JCL, SQL

Confidential

Sr Lead Application Engineer

Responsibilities:

• Performed modification and unit testing of personnel and payroll system programs of DOP as per CBAR changes specification.
• Performed development, modification and unit testing of DOP-HRISD programs and jobs for the implementation of the PAY1 replacement system.
• Performed verification of jobs at the system testing stage for the changes done at the unit testing stage.
• Wrote new COBOL programs using DB2, CICS to implement new functionality.
• Performed entire SDLC starting with requirement, analysis, design and development and testing.
• Extensively used CICS Screen Definition Facility (SDF) and BMS maps to develop user interface in CICS programs.
• Designed reports using COBOL, DB2, SPUFI, QMF and SAS programs.
• Performed Documentation of programs and jobs using Microsoft Visio.
• Used DB2 Unload, File-Aid to do data transformation.
• Performed system tests for various monthly releases. Including creation of test cases, test conditions and test plan.
• Performed 24X7 Production supports of COBOL modules.

Environment: Confidential Mainframe, CICS/ESA Ver 4.1, Confidential COBOL for OS/390 & VM Ver 2.2.2, SDF II, Xpeditor/CICS, Xpeditor/TSO, FileAid, Adabas Ver 6.1.3, Adaprep Ver 2.6, Predict 3.4, Natural, ISPF 5.2, SPIFFY, IOF Ver 7, JCLPREP Ver 6.3.0, CA-7, Endevor 3.9, DB2, CICS, QMF, SQL

Confidential, Lawrenceville, NJ

Sr Lead Programmer Analyst

Responsibilities:

• Developed scorecards to manage performance measurement for Pharmaceutical Research Institute.
• Balanced scorecard is a performance measurement tool that provides clear performance targets by translating strategy into measurable outcomes.
• The project is to extract data from source systems into a staging area called Operational Data Store to support analysis. Also, a storage area is maintained for historical volume data. From Operational Data Store, the data is brought to SAS environment as OLAP cubes and user generated reports.
• Later, the cubes and reports are linked to scorecards using SAS SPM tool and published for executives to view as dashboards.
• Worked in the creation of SAS OLAP cubes using PROC MDDB.
• Worked in the creation of JSP pages with custom SAS/ADS tags and HTML page to view cubes.
• Worked in the set up of scorecards in different environments and linking of cubes and reports to the scorecards.
• Coded new COBOL programs using DB2, CICS.
• Performed entire software life cycle (SDLC) starting with Requirement, Analysis, Design and Development and testing.
• Was on-call whenever the procedures and programs provided by me were executed in test, quality assurance, mock conversion, and production conversion

Environment: SAS 8.1.2, SAS AppDevStudio, SAS Strategic Performance Management Ver 1.4.0, JSP with SAS/ADS custom tags, WRQ Reflection FTP client, Mozilla Thunderbird Email client, Windows 2000, Novell Netware, COBOL, DB2, CICS, JCL,, SQL

Confidential, Walnut Creek, CA

Sr Lead Mainframe developer

Responsibilities:

• Worked on complete SDLC including High level Design, Detail Design, Data Modeling/database Design, Process and Module Design, Development and Testing.
• Created many Batch and On-line COBOL II programs using CICS and DB2.
• Designed databases and Tables and Wrote Programs to transfer and Validate data transfer from Oracle to DB2.
• Performed Documentation of programs and jobs using Microsoft Word and Visio.
• Designed case report forms.

Environment: SAS 8.2, JCL, TSO/ISPF, VS COBOL II, DB2 (SPUFI & QMF), Confidential utilities, Extra Personal client, VPN dialer, Vantive ver 8.5.5.1, FileAid/MVS, ChangeMan Ver 4.1, CICS, Oracle, EDI, JCL, SQL