Developer Data

SEEMA RAI

SUMMARY

Over ** years of IT experience in SDLC and Agile Methodologies in Finance, Insurance, Public sector and Utilities.

Knowledge of Object Oriented Analysis and Design applying various Design and Structural Patterns with UML.

Highly motivated, results oriented, excellent communication skills and a strong team player.

SKILLS

Hardware: IBM Mainframe- ES9000, 3090, IBM-PC, x86/Pentium based machines,

Operating Systems: Z/VM, MVS, SCO UNIX, LINUX, MS-DOS, MS-WINDOWS

Languages: VS COBOL II, JCL, PL/SQL, BASIC, Perl, M/F COBOL, JAVA, UML, C#, K-Shell

Standards: JSP, ASP, Servlets, J2EE, JDBC, ODBC

GUIs: Html, Java Applets, MS Windows using Sybase PowerBuilder 11.5

DBMS: DB2, IMS, ORACLE

BI Tools: Cognos 8.2, Easytrieve, PL/SQL

Others: CICS, VSAM, Intertest, Xpediter, IAM, File-Aid, PNC, Progeni, VSS, ADS, ARS, ISPF, TSO, MultiEditor, TestDirector, Lotus Notes, ChangeMan, CA-Scheduler, OPC scheduler, Smartest, SPUFI, C-List, REXX, Control-M, Autosys, Toad, JES commands, BMC

EXPERIENCE

Deloitte Consulting, US 4/2008-11/2015

Delaware Eligibility Modernization, Delaware - State of Delaware

Programmer cum Analyst

Created Business Logic Diagrams for existing Legacy system of Eligibility Determination.

Made changes to the existing legacy code for improving efficiency of the new system.

Coding of complex programs using COBOL, DB2, VSAM, JCL and other tools like CHANGEMAN, File Aid etc.

Perform DB2 LOADS, UNLOADS, Image copies, RUNSTATS, BINDS and other DB2 core utilities.

Code changes made to existing Legacy system for the new ACA act. Used DB2 Stored procedures / cursors.

Migration of applications from Dev to Prod DB2 subsystem using Endevor.

Stand-up Scrum meetings with the team members on the progress.

Test data created for QA and development testing (later used for UAT).

Colorado Benefits Management Systems, Denver – State of Colorado

Developer

Prepared PIA, DIA to list the changes needed in Jobs /COBOL Source codes /Stored Procedures/

Batch scripts /Cognos reports for the respective CR.

Made changes to the existing Stored Procedures/ batch scripts/ Cognos reports for the data requirement.

Monitoring of Batch jobs /Cognos reports on a daily basis.

Providing support for Production nightly run jobs in UNIX environment.

Creating and updating shell scripts for running the jobs.

Test data created for QA and development testing (that was later used for UAT).

Migration to Powerbuilder 11, Delaware Health and Social Services – State of Delaware

Developer

Preparation of documents to list the fixes on all the windows/screens that will be in the scope and would need migration.

Testing each individual window on both PB9 and PB11, to verify that the functionality was not impacted due to the migration.

Bug-fixing of the identified screens and testing the same. This was verified again using the PB Delta5 comparision tool.

Source Version Control was done using Visual Source Safe.

Test data created for QA and development testing, participated in Unit Testing and System Integration Testing.

TANF, Delaware Health and Social Services – State of Delaware

Developer

Developed and maintained systems documentation such as Technical Specifications, Technical Manuals.

Coding of complex programs using COBOL, DB2, VSAM, JCL and other tools like CHANGEMAN, File Aid etc.

Used DB2 Stored procedures and cursors for database processing in application.

Created and modified COBOL batch programs, JCL’s, Procs and Control cards.

Created load and unload jobs for loading development and QA tables with prod data.

Performed Unit Testing and System/Integration Testing for the new and modified codes.

Perot Systems, India - Bank of Ireland

Bookkeeping Infocentre, Bank of Ireland 10/2006-2/2008

Team Leader

Responsible for business requirement capturing and creation of technical specifications for client requests.

Developed and maintained systems documentation such as design specifications, technical manuals, description of application.

Coding of medium to complex programs using Cobol, DB2,IMS, VSAM, JCL and other tools like CHANGEMAN, File Aid.

Created and modified COBOL batch programs, JCL’s, Procs and Control cards.

Test data creation for QA and development testing (Creation of load and unload jobs for loading development and QA tables

with the production data)

Delivery of the work products (FS/UTC/UTR) to the client.

ABN AMRO Services Company, North America

Goldmine 8/2005-9/2006

Technical Analyst cum Developer

Retrieval of historical data from mainframe viewdirect reports, for specific accounts.

Creation of Extract files using easytrieve from the data obtained from reports.

Query Resolution with Client for the requirements.

Followed complete SDLC i.e. RA, DLD, Coding, unit testing and review of the work products.

Performance tuning for the existing COBOL DB2 batch programs and stored procedure

Documentation of the entire approach for the Client’s use.

ABN AMRO Bank, Netherlands

BASICS 2 Aanvraagscoring

Technical Analyst

Conversion of data processing from existing V213 layout to new G3 layouts for the affected loans.

Requirement analysis of the approach, creation of Detailed Level Design.

Assisting the team in coding and testing of the modified codes.

Query Resolution with OSC/Client for the requirements.

Report creation using COBOL DB2, Unit Testing & review of work products

ABN AMRO Services Company, North America

C3-PreClose Loan Application

Analyst cum Developer

Impact analysis of the new Loan submission system on the existing codes, as well as new compliance requirements.

Creation of design documents for the modifications/enhancements.

Creation of the new AUS engine that would now be responsible for submitting loans to LP/DU.

Use of Oracle’s TOAD for generation of multiple table reports for different queries.

Requirement Analysis, Coding, unit testing and review of the developed code.

Creation of Test cases, SIT/UAT support during Testing phase.

Initially worked at client site (onsite) for Requirement gathering, and then successfully transitioned it to offshore for an onsite-offshore model.

Fidelity Investments

Employee Stock Option Plan (ESOP) 2004-7/2005

Analyst cum Developer

Report generation, programs documentation, Amending/creating Jobs, Reverse engineering for performance enhancement.

Requirement Analysis, coding, unit testing and review of new/modified work products.

Resolving Adhoc queries, report generation.

Configuration Management activities (in the role of CM), of the work products in compliance with ISO 9001 requirements.

Performance testing and UAT of the modified and newly developed codes in terms of CPU / Elapsed time.

QC activities such as Self and P2P reviews.

Improved performance of existing processes (in terms of Elapsed/CPU time), by implementing better algorithms. In many cases, this has led to improvement by more than 60% overall (after system testing). Award recognition for the role.

Fidelity Investments

Employee Stock Option Plan (ESOP)-FAS Phase II

Analyst cum Developer

The project involved enhancements that were designed to comply with the Financial Accounting Standards Board’s regulatory changes, mainly the transition from VSAM files to DB2 tables.

Analysis of the programs and jobs for change impact due to conversion of the files.

Preparation of High Level Documents for the changes for review by the client/OSC.

Coding the changes so that the files now referred to DB2 tables for data access/manipulation instead of VSAM files.

Testing (System Testing and UAT) of both the modified and unmodified code to ensure that the existing functionality is the same.

At each stage of the above activities, QC by means of self and P2P reviews.

Configuration Management activities in compliance with ISO 9001 requirements.

Southern California Edison (SCE) 1997-2000

Usage Calc

Analyst cum Developer

The pre-existing Prebill modules were modified to integrate CR-2 SSGDR Cogen Simulator Accounts in CSS.

Prepared SQL queries for the proposed system after analyzing the existing code.

Developed a module for updating the DB2 tables for the mopped-reads and tested to ensure it does mop the bad reads.

Coding and Unit Testing (using Xpediter-Interactive debugging facility for Batch programs) of the programs.

System integration and implementation while ensured that these accounts were Y2K compliant.

QA of the deliverables sent to the client in compliance with ISO 9001 standards.

Colonial Penn Insurance

2000 Conversion, GE FA

Analyst cum Developer

Impact analysis of the programs for Y2K conversion using SEEC tool.

Manual Verification and analysis of the impacted changes in the code.

Analysis, Coding, Testing, and QC of the year 2000 compliant sources for the project.

Carrying out QA of other team members' work, correspondence with OSC on issues resolution.

GE Capital Retail Financial Services

Credit Card Application Processing System

Analyst cum Developer

Impact analysis of the programs and jobs for change requirements.

Analysis, Coding, Unit Testing and Integration Testing of the CRs/enhancements received from the client.

Providing Production Support for the nightly batch jobs.

Carrying out QA of other team members' work, correspondence with OSC on issues resolution.

EDUCATION & DEVELOPMENT

California State University East Bay, CA

M.S. in Computer Science, GPA 3.9/4

Contact this candidate