TECHNICAL SKILLS:

Hardware: Unix Redhat/Linux Servers, IBM - 3090, WINDOWS-PC

Software: DataStage ETL Tool versions 8.1/11.5, Java, Python, JiraSVN Tortoise, Maven, IBM ClearCase, Unix Shell Scripting, CRON scheduler, CICS, DB2, COBOL-II, JCLVSAM, Visual Basic, Oracle PL/SQL, Oracle Times Ten SQLMQT and WebFOCUS BI Tool version 8.1.

WORK EXPERIENCE:

Confidential, San Francisco, CA

Lead ETL developer

Responsibilities:

• Worked with Treasury business partners to create Data Warehouse user requirements.
• Provided 24x7 production support for DIR dataware house system.
• Created change control management for the migration of ETL code and database code/changes for Treasury software releases using Tortoise SVN.
• Provided coding solution for Encryption of sensitive (PII) data on the DB2 target tables.
• Performed many tasks typical of DBA tasks, such as Runstats, table reorgs, enforce foreign key constraints, performance tuning by the addition of indexes and partitioning of tables.
• Provided ETL job documentation for Treasury users and DMS Operations training
• Worked extensively with File Transfer ( Confidential ) and Connect Direct to send/receive files into Mainframe and Unix Servers
• Handled creation and walk through of packaged release implementation plan into UAT and Production environments.
• Assisted user community in UAT Testing and Production Deployment
• Performed Unit Testing, Integration Testing/QA Testing prior to UAT/Production Release.
• Assisted in simultaneous migration of DataStage ETL software from version 7.1 to 11.5 and Unix Servers from Linux to Redhat Servers.
• Assisted with Big Data on Proof of Concept to ingest debt management

Environment: Unix Red Hat, IBM DataStage ETL Version 7.1 and 11.5, DB2/Oracle SQL Query, PL SQL and Java

Confidential, San Francisco, CA

Lead Business Intelligence (BI) developer

Responsibilities:

• Created Materialized Query Table (MQT) for the analytics team to run their SQL queries efficiently.
• Creation of MQT involved joining multiple DB2 tables that created a single flat table containing over 10 million records.

Environment: Unix Red Hat, MQT, Confidential WebFOCUS, FEX Code and DB2 SQL Query

Confidential, San Francisco, CA

Lead programmer analyst

Responsibilities:

• I was responsible for gathering requirements from other Policy sub-system and making code changes to programs, testing and implementation. Document files created in mainframe are transmitted to Image Line Unix Server by Confidential .
• Also, prepared detailed design document for Balancing Policy output reports and involved in development of the system.
• Worked on converting VS-COBOL/VSAM/Assembler programs to COBOL-II/DB2 programs as a lead Systems Analyst.
• Responsibilities included analyzing existing VS-COBOL programs and rewriting them in COBOL-II/DB2 platform, testing, implementation and post implementation support.
• Assembler/VSAM subroutines have been rewritten to COBOL-II/DB2 subroutines.
• I’ve written several DB2 stored procedure for the Java Based Applications and also, responsible for production support during nightly batch cycle and fix production anomalies.

Environment: IBM 3090, MVS/ESA, DB2,CICS, JCL, Easytrieve and COBOL-II.

Confidential, Walnut Creek, CA

Systems Analyst

Responsibilities:

• I was responsible for the successful implementation of the Medicare Risk Project.
• Involved in writing several new CICS on-line programs.
• In Phase-I of the project, data was collected in VSAM and in Phase-II it was migrated to DB2.
• Wrote batch programs for the data conversion from VSAM to DB2.
• Also, participated in database design walk-through.

Environment: IBM 3090, MVS/ESA, DB2, IMS, IMS-DB/DC, CICS, JCL, Change Man and COBOL-II.

Confidential, San Francisco, CA

Lead System Analyst

Responsibilities:

• I was responsible for analysis, design and coding of programs for Account Open Systems.
• Worked both on online and batch Account Open.
• Created online account open subroutines and that were called by the Java GUI front end via an API call.
• This system was developed as a new application, replacing the existing PC standalone application written in Paradox.

Environment: IBM 3090, MVS/ESA, DB2, CICS, JCL, Change Man and COBOL-II.

Confidential, San Francisco, CA

Lead System Analyst

Responsibilities:

• Responsible for the design changes, coding and testing of the system.
• Trained end-users to use the system, to write ad-hoc MIS reports, provided production support and Production Control Management using Change Man Package.
• My work involved both On-line and Batch Programs.

Environment: IBM 3090, MVS/ESA, KEY 4.1, DB2, CICS, JCL, Change Man and COBOL-II.

Confidential, Los Angeles, CA

Lead Systems Analyst

Responsibilities:

• I was responsible for design, coding and testing of the system.
• I was also responsible for Systems Testing, Design and Code reviews.
• Worked primarily on On-line Programs

Environment: IBM 3090, MVS/ESA, ADW 2.7, DB2, CICS, JCL and COBOL-II.

Confidential, Los Angeles, CA

Analyst/ Programmer

Responsibilities:

• Responsibilities included production of program specifications and unit test plans as per business requirements, development of modules using knowledge-ware’s ADW case tool, testing of modules using MF Work Bench and X-DB, consolidating the developed modules to the Confidential mainframe and coordinating the development activity between the business analysts and the project managers.
• Worked on both on-line and batch programs and was part of the production support team.

Environment: IBM 3090, MVS/ESA, ADW 2.7, ADW 1.6, DB2, CICS, JCL and COBOL-II.

Confidential

Systems Analyst

Responsibilities:

• Responsible for the design changes, coding and testing of the telecommunications application software using IDMS-R, IDMS/ADSO, DMLO, OLQ, IDD, ADS/A, ADS/C and the system was developed on IBM-ES/9000.
• Also involved in system testing and coordination with the
• Malaysian Telecom Staff for the design walk-throughs.
• System testing involved in setting up the static data which includes the tables, catalogues in the database and modifying the batch programs.

Environment: IBM 3090, MVS/ESA, IDMS-R, ADSO, ADSA, JCL and COBOL-II.

Confidential

Analyst/Programmer

Responsibilities:

• My responsibilities included writing program specifications, translating the specifications into programs using COBOL-II, CICS, DB2.
• Involved in Unit testing and system using INTER/TEST, QMF and SPUFI and JCL.
• Worked on both on-line and batch programs in an IBM-3090 environment.

Environment: IBM 3090, MVS/ESA, DB2,CICS, JCL and COBOL-II.