SUMMARY OF SKILLS

• Over 14 years of experience as Systems Analyst and programmer in multiple platforms including MVS on IBM mainframe, UNIX on minicomputer and Windows NT, Novell Netware and DOS on PCs.
• Eight years of experience and expertise in Base SAS, SAS/AF, SAS/SCL, SAS/PROCs, SAS/MACROs, PROC/MDDB, OLAP Cubes, JSP with SAS/ADS Custom tags and SAS database in SAS 8.0 in mainframe environment.
• Expertise in VS COBOL II, VSAM, CICS, JCL, CLIST and TSO/ISPF, Vantive, ChangeMan and FileAid/MVS in IBM mainframe environment.
• Work experience in financial departments of state and federal government agencies and healthcare.
• Expertise in developing stand-alone applications using DAO/ADO, VBScript, MS-Visualbasic 5.0/6.0, CrystalReports and MS-Access in PC environment.
• Expertise in Natural, Adabas, PL/1 and COBOL in mainframe environment.
• Expertise in MF-COBOL Workbench, ISAM and PC-CICS in PC environment.
• SAS Certified Base Programmer.
• Proficient and involvement in all phases of the System Development Life Cycle.
• 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, PROC/MDDB, OLAP Cubes, SAS Enterprise Guide 4.0, JSP with SAS/ADS Custom tags and SAS database , JCL, Natural, Adabas, PL/1, TSO/ISPF, VS COBOL II, CICS, DB2, CrystalReports, VisualBasic 6.0, ORACLE 5.0, CA-7, UNIX, IDMS DB/DC, ADS/O, ChangeMan, Vantive, FileAid

TECHNICAL SKILLS

Operating Systems: MVS, WINDOWS NT/XP/2000/98/95 and UNIX

RDBMS: SAS, DB2, Adabas, MS-Access

Languages: SAS, SAS EG, COBOL, Natural, PL/1

Reporting Tools Crystal Reports, MS-Access report writer

Application Architecture CORE Foundation Software

Financial packages Federal Financial System, Government Financial System

Tools MVS Utilities, ChangeMan, Vantive, FileAid

AREAS OF EXPERTISE

• System Development Life Cycle.
• SAS Certified Base Programmer.
• SAS, SAS EG, COBOL, CICS, VSAM, CA-7, Natural, Adabas, PL/1 and DB2 in mainframe environment.
• Systems integration across platforms.

PROFESSIONAL EXPERIENCE

SAS Developer

Confidential

• Board of Equalization has Installment Payment Agreement IPA to establish payment
• arrangements with the tax payer who has payment due. The existing system is collector
• initiated.
• The project is to add eServices based front end so that the tax payer can input and initiate
• the online IPA.
• 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.
• 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 levels 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.

Environment: PC SAS,SAS 9.3, Enterprise Guide 4.3, SAS/ODS,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

Confidential

Programmer Analyst

• Worked in CCAR Comprehensive Capital Analysis and Review 2012 team. Quarterly and
• annual schedule data are submitted by WF LOB Line of business to the federal reserve.
• Validated quarterly schedules total 17 15 in SAS data files, one tab delimited and one CSV
• as per the edit checks provided by the schedule specification.
• The edit check routines were written in SAS and the error reports were created as TXT. Then
• error reports were stripped of formatting and loaded into excel spreadsheets. The error reports
• were analysed by creating pivot tables in excel.
• Code, test and implement acquisitions subsystem.
• Creation of 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.

Environment: CA-7, IBM Enterprise COBOL for z/OS 3.4.1, DYL-280, SORT, JCL, SAS 9.1

Confidential

Programmer Analyst

• Worked as programmer analyst.
• Support and maintenance of OBIS offender Based Information System .
• Batch interface programs for internal clients of CDCR including SOMS, DDPS, VSRIS, CODB, OISB and external clients of CDCR 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.
• Involved in user discussion to identify change in specification and scope of the job/project.

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

Confidential

Programmer Analyst

• Worked as programmer analyst.
• Involved 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.
• Involved in the analysis and creation of programs and jobs for Length of enrollment for each Medical Record Number.
• Involved 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.

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.

Confidential

Programmer Analyst

• Worked in Line expansion and other changes to General Ledger System.
• Line expansion change is to convert the Lineids in the General Ledger System from 5 characters to 9 characters. The CICS maps, copybooks, online programs and batch programs were converted.
• 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.
• During regression testing, compared the outputs from the production and testing environments using INSYNC.
• Involved in the coding, testing and packaging of small and medium sized enhancements in the form of change requests and work requests to the General Ledger system.

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

Confidential

Programmer Analyst

• Involved in the development, modification and unit testing of ARMS Automated Register Maintenance System sub-system programs according to CBAR Collective Bargaining Agreement Reform changes.
• Involved in the modification and unit testing of personnel and payroll system programs of DOP as per CBAR changes specification.
• Involved in the development, modification and unit testing of DOP-HRISD programs and jobs for the implementation of the PAY1 replacement system.
• Involved in the verification of jobs at the system testing stage for the changes done at the unit testing stage.

Environment: IBM Mainframe, CICS/ESA Ver 4.1, IBM 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

Confidential

Programmer Analyst

• Development of 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.
• Involved in the creation of SAS OLAP cubes using PROC MDDB.
• Involved in the creation of JSP pages with custom SAS/ADS tags and HTML page to view cubes.
• Involved in the set up of scorecards in different environments and linking of cubes and reports to the scorecards.

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.

Confidential

• Involved in the production support and small enhancements for one of the healthcare subsystems of the client.
• Involved in the system study, production support and small enhancements.
• Management Data Repository MDR is a mainframe workplace in which copies of production system data reside in DB2 tables. These copies are brought together to the same place and are organized to be more amenable for reporting. It is the primary data source for almost all reporting and analysis done at Kaiser, Northern California.
• The information from individual applications arrives to MDR on a scheduled basis in batch mode using COBOL and SAS programs.
• The data is read from the individual application, processed to the required format to be stored in MDR tables and the records are written to a flat file. The flat file is then loaded onto MDR DB2 tables using LOAD utility.

Environment: SAS 8.2, JCL, TSO/ISPF, VS COBOL II, DB2 SPUFI QMF , IBM utilities, Extra Personal client, VPN dialer, Vantive ver 8.5.5.1, FileAid/MVS, ChangeMan Ver 4.1

Confidential

Software engineer

Worked for a client who does state and federal government contracts. As part of the client's contract jobs, worked at different state and federal government client sites.

Confidential

• Interacted with Systems Officer and Systems Analyst in financial department on-site.
• Provided systems support for Report Management System RMS . RMS is a menu-driven package in SAS with facility to add, delete and submit reports. Added new reports, modified existing reports as per requirement. Added and modified menus and frames using SAS/SCL as per requirement.
• Created adhoc reports using SAS/PROCs and SAS/MACROs for the functional specification.
• Provided systems support and modifications to Federal Financial System FFS for the change in functional specifications using VS COBOL II.
• Involved in the creation and maintenance of RMS data mart, which is, a SAS database using JCL and SAS. The data comes from FFS to RMS in the form of flat files.
• Involved in the up gradation of Report Management System to Y2K compliant.
• Involved in the development of PC-based stand-alone packages, which are subsystems to the main Federal Financial System. These systems interact with the main systems through flat files. Used FTP process using Hummingbird for data interaction across systems. Used DAO/ADO, VBScript in VisualBasic 5.0/6.0. Created reports using MS-Access and Crystalreports. Educated the end-users to use the subsystems developed.
• Involved in the conversion of RMS from SAS to CrystalReports. Involved in the data migration from SAS database by creating flat files for further processing by the new system.

Environment: SAS, JCL, TSO/ISPF, VS COBOL II, CICS, VisualBasic 5.0/6.0, MS-Access, CrystalReports, Hummingbird, MVS, Windows 95/98/2000/NT, CORE, Federal Financial System, Report Management System

Confidential

• Interacted with the Project Manager for functional specification.
• Provided systems support for Report Management System RMS . RMS is a menu-driven package in SAS with facility to add, delete and submit reports. Added new reports, modified existing reports as per requirement.
• Created new reports using SAS/PROCs and SAS/MACROs for the specification. Interacted with the end users for acceptance testing with live data.
• Provided systems support and modifications to Court Accounting System, customized version of Federal Financial System FFS at the client site for the change in functional specifications using VS COBOL II. Wrote new batch programs and table processors using VS COBOL II and CORE.

Environment: SAS, JCL, TSO/ISPF, VS COBOL II, CICS, CORE, Court Accounting System, Report Management System