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