Project System

Mannu Kaur

Cell: 937-***-****

Email-id: *****.******@*****.***

SUMMARY OF EXPERIENCE

. Over 6 plus years of experience in IT in the Application study, system

Analysis, Design, Development, Testing, Implementation, Maintenance,

Business analysis and Processes of the Mainframe Applications.

. Rich working experience in COBOL, PL/I, EASYTRIEVE, JCL, CICS, VSAM,

DB2, CA-7, Xpeditor, Change man, CA-Ideal, CA-Datacom, SAR, SPUFI,

File-Aid, DB2-FileAid, TSO, ISPF.

. Expertise as a Systems Analyst in understanding the SAS codes and

converted the codes into COBOL.

. Proficient in working on the Server PCTMS DB2 tables which covered the

entire life cycle of the system.

. Very Good Understanding of Banking domain, Credit card system,

Mortgage Serves, CMS and educational reporting systems.

. Possesses excellent analytical skills and domain knowledge, enabling

to play a key role of a Software Developer in many projects.

. Extensive experience in Vision plus and CMS as a developer and as an

Analyst.

. Functional & Regression testing of various kinds of academic reports

as a QA Tester.

. Proven experience in writing queries, stored procedures and PL/SQL in

IBM DB2 and ORACLE.

. Monitoring online and batch processing jobs running on a mainframe

application system and solving abends.

. Expertise in working with Web Technologies using PHP, MySQL and Core

Java.

. Capable of handling multiple responsibilities simultaneously and work

closely with the client requirement gathering and involved in

implementation of all phases of SDLC.

. Quick learner, team player, strong analytical skills, excellent

trouble-shooting and superior communication skills are my assets.

CERTIFICATIONS

. OCA Certified (Oracle Certified Associate), Prometric Testing ID:

SR2451931

. Diploma in Software Management from Aptech Computer Education

. 'O' Level from DOEACC Society, New Delhi

. IBM-Mainframe Maintech Certified

TECHNICAL SKILLS

Languages: COBOL, CICS, PL/I, JCL, VarGen, VB, C, PHP, Java Script, Core

Java.

Database: VSAM, MySQL, Oracle9i, DB2

Operating Systems: Windows NT, Windows 9x, DOS, OS/390, Linux

Tools: TSO/ISPF, SPUFI, Change Man, Expeditor, IBM

Debugger, File-Aid, DB2-FileAid, CA-7, SAR,

Expeditor, CA-7, CA-Datacom, CA-Ideal

PROFESSIONAL EXPERIENCE

Client: CTB McGraw Hill, Monterey, CA Mar'

10 - Till Date

Project Title: EISS Reporting System

Project Description: California Testing Bureau is the business of "helping

the teacher helps the child". The test content of the reports reflects

national standards derived from the curriculum guides, teachers groups and

state framework. After the answers sheets come from the customer, they are

scanned and raw scores are updated into the EISS tables through the

WinBridge process. After bridge, DSP uploads a few more tables with the

derived scores of the students. Lastly Summary uploads a few more tables

with school, district or state level summaries as required in the contract.

When all these EISS tables have been populated, the report modules read

from the tables and produce the reports.

Responsibilities:

. Gathered project requirements and enhancements of the new contracts

through client interfacing.

. Actively coded in generation of reports using COBOL, PL/I and JCL.

. Involved in Functional testing, Regression testing, Compatibility

testing, and UAT Testing. Applied agile model for software testing

methodology.

. Writing stored procedures in DB2.

. Extensively involved in the functional and Regression testing of the

reports.

. Highly involved in scrum-meetings to discuss issues raised by QA team

along with client.

. Writing test objectives, test scenarios, test plan and test cases.

. Resolving business issues and QA defects raised while testing.

. Involved in the generation of electronic and paper reports.

. Involved in code modification according to different contracts based

on the various states of US.

. Determined the structures of database and maintenance of it.

. Documentation of requirement docs, report docs and distribution of

tasks.

. Designing and coding of CA-Ideal and CA-Datacom.

. Fully involved in QA & Production support during deployment of

enhancement from non-production to production environment.

. Coordinating design, building and implementation activities with

offshore team.

. Fully interaction with Client and delivery of the given tasks on time.

Environment: IBM Mainframe technologies: COBOL, DB2, CICS, PL/I, JCL,

TSO/ISPF, CA-Ideal and CA-Datacom, CICS and QTP.

Client: HSBC Bank, Chicago USA Mar' 07 -

Mar'10

Project Title: TRIAD adaptive control system

Project Description: TRIAD is a portfolio management and scoring system

designed to help reduce losses, increase revenues and take advantage of

promotional opportunities, for single or multiple portfolios such as credit

cards and installment loans. TRIAD helps in decision making process and

responds quickly to changes in customer population and the economic

environment. It is used in WHIRL as a sophisticated tool that allows us to

identify the risk posed by an account and it takes corrective measure to

avoid risk.

Responsibilities:

. Gathered project requirements through client interfacing and coded in

TRIAD.

. Determined the structures of DB2 tables by using PCTMS Tools for DB2,

and by looking at the Citrix.

. Analysis and providing resolution to major production problems to

resolve online and batch abends.

. Documentation of system design, application enhancements and preparing

relevant documentation for business users.

. System Analysis, design, development, testing and implementation of

new enhancements.

. Expert in Compliance check and execution of test scripts.

. Involved in designing Requirement and Functional specification

document including design and documentation of System related

requirements including scope, use cases, business rules, transactions

and processes, identifying data sources, data decomposition diagrams,

UI specs, work flow and actor diagrams, using UML.

. Actively coded in PL/I, CICS and COBOL codes based on program level

specifications.

. NDM of production jobs as per the requirement.

. Preparing the Business requirements document.

. Designing and coding of Easytrieves, CA-Ideal and CA-Datacom.

. Coordinating design, building and implementation activities with

offshore.

. Regular interaction with Client and delivery of the given tasks on

time.

. Received appreciations and commendations from client, for efficient

solution, response and great work.

Environment: IBM Mainframe technologies: COBOL, CICS, DB2, VSAM, PL/I,

JCL, Easytrieve, TSO/ISPF, File-Aid, SAR, Abend aid, CA-7, Changeman,

Vision Plus, Estimator

Employer: Ensim Pvt. Ltd. Dec'05 to Mar' 07

Project Title: Customer Oriented System for Management of Special Services

Project Description: This project focuses on Mortgage loans. It helps in

building a database management system for the Mortgage Lenders and Brokers.

It also keeps an eye on the local regulation and legal requirements of the

government. This enables hosted service provider and enterprise to develop,

deploy, and manage packaged as well as associated software infrastructure

components. IBM had outsourced this project for Germany branch.

Responsibilities:

. Coordinating design, building and implementation activities with

onsite.

. Creating relevant adhoc reports that give accurate information to the

higher management.

. Writing programs in Mainframe Assembler.

. Collecting data for CMM level-5 reports.

. Using causal analysis and brain storming techniques to identify the

root causes and solutions.

. Production support during onsite night hours.

. Development of core processes from offshore.

. Project status reporting to the clients.

. Written PL/SQL queries for oracle and DB2 databases, the extracted

images were placed in Oracle and the ones to be uploaded were to be

stored in IBM DB2 (UDB).

. Supporting and enhancement of the applications.

. Preparation of technical manual and user help guide.

Environment: COBOL, JCL, VSAM, DB2, AS/400, File-Aid, CICS, Changeman, IBM

DEBUGGER, FAULT ANALYZER, Oracle 9i.

Client: RedAlkemi

Aug' 04 to Apr' 05

Project Name: Wigmann

Project Description: RedAlkemi mainly worked in Web Development. It has

been helping clients enhance their online presence to draw and efficiently

tap into potential business opportunities for over a decade. Our endeavor

has been to combine the best of creativity, technology and in-depth

understanding of different dynamic factors, to offer customized solutions

for a range of specific requirements. The essential purpose is to

strategically streamline our clients' online presence and help translate it

into actual, numerable returns. This project is used for a project

management system. It has two interfaces: Admin console and Front-end. The

data is entered from the backend and displayed on front-end at the time of

activation. There is a facility for client feedback and administrator

responds it.

Responsibilities:

. Review of the requirements document and design documents sent from

onsite.

. Preparing the impact analysis and Low level design for the new

enhancements.

. Performing Unit Testing & System testing.

. Developing the code to implement the new functionality.

. Preparing test plans for testing the new functionality.

. Worked in the implementation of LDAP system.

. Part of build team and prepared release notes.

. Involved in designing for the sorting and searching mechanism.

Environment: Linux, Shell Scripting, PHP, HTML, Ajax, Java and MySQL.

Education

. MBA from Sunnyvale, CA.

. MCA (Master of Computer Application)

. BIT (Bachelor in Information Technology)

Workshop Training Program attended

* 'O' Level from DOEACC Society, New Delhi

* Delivered seminar on E-bomb, Microsoft, IVR Systems, Spam

Contact this candidate