A.L.S Chandrakala E-mail:ad3ypt@r.postjobfree.com

Mob: +1-208-***-****

Experience Profile

Having around 7 years of experience in Mainframe development

Having 1 year experience in Unix and Cobol

Certified in DB2 V8.1 Family Fundamentals

Extensively worked in Finance & Banking domains

Worked in various phases of software development life cycle

Extensively worked on mainframe development projects with various skill set like COBOL,JCL,DB2,CICS,VSAM UNIX and TELON

Worked on DB2 Stored Procedures

Good experience on version control tools like Endeavor and Changeman

Good experience in preparation of TS and LLD’s

Preparation of Software Requirement Analysis for the Change Requests

Preparation of Test Plans for Quality checks and also User Testing

Have done the FTC Certification: Certificate Program in Retail Management Competency (CPRMC)

Organization

Duration

Designation

TATA Consultancy Service, Kolkata

TATA Consultancy Service, Bangalore

2006-2010

2010-2016

Asst systems Engineer

Software Engineer

Achievements

Completed Six Sigma awareness Training.

Certified in DB2 V8.1 Family Fundamentals

Certified in FTC Certification

Educational Qualification

University

Percentage

M.C.A.(Master in Computer Applications)

Jawaharlal Nehru Technological University (Campus) - A.P.

78

Expertise

Platform

IBM Mainframe

Operating System

OS /390, MVS, DOS, Windows 2000/NT & Unix

RDBMS

DB2, SQL Server2000,

Programming Languages

OS/VS COBOL, VS COBOL II, RM-COBOL JCL, Easytrieve

Online Subsystem

TSO/ISPF

Tools and Utilities

Telon, File-Aid, SIMS, Changeman, Endevor, Insync, File manager, Platinum.

Special Software

Vision Plus, Card Pac

OLTP

CICS

Mainframe Skills

Having Good Skills in VisionPlus, CARD PAC and TELON

Having experience on CICS regions like CICSA6, CICSA8, and CICSOY.

Developed and Modifying Programs/JCL’s

Worked on file handling programs in COBOL

Worked on DB2 Stored procedures using Platinum Tool

Trainings

Attended VISION PLUS, Easytrieve Trainings

Attended GE Security awareness Training

Attended Oracle PL/SQL Training

Attended Unix Training

Experience Summary:-

Title

IDMS- Enhancement of China Dormant Account validations

Period

Jan, 2015 –Jan2016

Client

DEUTSCHE BANK

Role

Team Member

Project

Description

Roles&

Responsibility

Deutsche Bank Group, one of the world's leading financial service providers to corporate, institutional and individual clients.

Enhancement of China Dormant Account: Current Account: Currently, a current account is considered as dormant after six months of inactivity. Account interest postings are not considered as account activity. As per the new China regulation, a current account should become dormant after one year of inactivity

Savings Account: Currently, a savings account is considered as dormant after two years of inactivity. As per regulation, savings account should become dormant after a year of inactivity

Enhancement of Block Funds phase: As part of this enhancement Mumbai custody services want to achieve client reporting and regulatory reporting for blocked funds. A feed to dbCRIS should be sent with the details of blocking/unblocking. This will be used by dbCRIS and dbDI to present the details of blocking to the clients.

Developed many scratch programs in the online feed dbcris successful for blocking and unblocking.

Generates XML format blocking and unblocking messages and end of feed generated messages successful for blocking and unblocking

Enhanced many programs as per requirement of Dormant account validations, Block funds, Library changes and ASM changes

Developed new scratch program for Dormant account report, Block funds.

Created new scripts as per requirement through Unix.

Involved in the following activities in this project.

Analysis, design and development work by using COBOL, UNIX scripts

Unit testing and prepared unit test case plan

Prepared Low level design and Unit test Result documentation.

#3

Title

MPD-MG

Period

Jan, 2013–Oct 2014

Client

TARGET

Role

Team Member

Project

Description

Target Corporation has undertaken a key initiative – MPD Adjacency Automation Merchandising Grid – which will develop a new system to maintain Target’s Adjacency Hierarchy and automate the manual Adjacency process with the purpose of Store Specific Adjacencies to improve the merchandising process. This initiative will create a business process which will ensure that the right merchandise, plan grams, signing and fixtures arrive in the store in the right quantity, to the right location and at the right time to support store change events.

Merchandising Grid (MG) is a web based application used by MPD Adjacency Analysts/users for creating, viewing and managing Merchandising Grid for a Transition.

Few of My development includes:

Developed many COBOL Stored Procedures in MPD-MG.

Developed many DB2 stored procedures as per requirement on different

tables Manipulations on Merchandise Grid, Action sequence, Action

sequence header and action sequence value and audit table etc.

Roles

&Responsibility

Involved in the following activities in this project.

Analysis, design and development work by using COBOL, DB2 stored procedures and Endevor

Created routines.

Unit testing and System testing

Prepared Technical Specification documentation and UTP documentation

#4

Title

MM-Stock Management

Period

June, 2011 –May, 2012

Client

TESCO(CLIENT PLACE)

Role

Team Member

Project

Description

The Tesco Hindustan Service Centre (HSC) is the Global Services Arm for Tesco. The centre sits at the heart of the Tesco group, and provides IT and Business services to Tesco operations across Europe, Asia and America. Tesco is the first major international retailer to have a fully-owned support centre in India.

The CR-FINAL ORDER–Data warehouse project released on September-2008. Few of my development includes:

Developed an extraction report to extract min/max of thresholds’ of

Departments on date wise and generated the department’s thresholds’

limits file which will be used by data warehousing section.

Developed a program to extract Details of Store safety parameters for

Product areas hardlines, SOFTLINES and generated Store safety

Parameters output file which will be used by data warehousing section.

Developed a program to eliminate duplication of allocation volumes from

the inclusion and exclusion file of base product numbers

Roles

&

Responsibility

Involved in the following activities in this project.

Analysis, design and development work by using TELON, DB2 and Files

Coded JCL’s

Unit testing and System testing

Prepared Technical Specification documentation and UTP documentation

#5

Title

CBA-BLR-MLRB-Payments

Period

May, 2010– May, 2011

Client

CBA, Sydney

Role

Team Member

Project Description

Roles &

Responsibility

CBA-BLR-MLRB-Payments are an Onsite/Offshore Model Support Project for CBA (Commonwealth Bank of Australia), Sydney. This project is now under transition phase from another vendor to TCS

I have played an active role in Knowledge Transition and aware of below processes/Applications in CBA

Common Transaction Switch (CTS )

Electronic Fund Transfer At Point of Banking (EFTPOB)

Group Account Payment Authorization (GAPA)

Direct Entry system (DE)

Responsible for preparation of TOD (Technical Oriented Document) for :

Electronic Fund Transfer At Point of Banking (EFTPOB)

Group Account Payment Authorisation (GAPA)

#6

Title

SuperXpress System

Period

Jan, 2007 –Aug, 2009

Client

GE-Money, UK

Role

Team Member

Project Description

Offshore Originations team is currently providing the service of developing the projects that are required for the Enhancement of the SuperXpress system.

The E-apps/Originations April release will consist of a number of projects all tied into the same implementation with a delivery date driven by the Competition Commission (CoCo) change requirements,

It has been identified that two of these projects will have an impact on

Toys R Us in-store account opening (SuperXpress system):

E-apps SuperXpress System

Comet

The following projects are being delivered as part of this release:

CoCo Direct Debit Full Balance Option – This part of the CoCo project

will ensure all credit applications/agreements with a Direct Debit mandate include the option for the applicant to request that their Direct Debit is set-up to take the full balance on the account each month instead of the current default of the minimum payment amount

CoCo Direct Debit Tick Box – ensure all credit applications/agreements

Without a Direct Debit mandate include a tick box to register the applicant’s interest in setting up a Direct Debit for their account.

CoCo Insurance/Other Insurance Requirements – clients offering Account

Cover insurance during account opening will be able to offer the Balance Cancellation Cover as a separate product i.e. applicant’s can chose between Account Cover (which includes Balance Cancellation Cover), Balance Cancellation Cover only or no insurance.

Roles &Responsibility

Involved in the following activities in this projects

Analysis, design and development works for Different clients for the

Different Projects,

Enhancement work is done in Cardpac (Batch programs, Online Programs,

New Fields are added in the Maps, Copybooks changes, some added

functionality).

Modifying Files and Coding JCL’s

Prepare applications and testing results

Unit testing, SIT Results,

Prepared Technical Specification documentation, Combined UTP &

UTR’s and Implementation Plan.

& In this project my responsibilities has given some Support to that Projects. Analysis for different projects, as well as maintenance and enhancement for SuperXpress Application, end-to-end activities for SuperXpress Project works, client liaison, Solution Design / Construction and implementation

#7

Title

Tactical Development (GECF) – BHS & EVANS project

Period

July, 2006 – Dec, 2006

Client

GE Consumer Finance UK

Role

Team Member

Responsibilities

Project Description

Involved in the following activities till date

Analysis, design and development work for BHS and EVANS module

Development work is done in Vision plus (Batch programs, Copybooks,

Some added functionality

Prepare Application and Report Generation.

Prepared Technical Analysis documentation, Combined UTP & UTR’s

and Implementation Plan.

Unit testing, system testing and UAT of all converted objects and

getting approved by the client.

A credit card solution seeks to achieve the following:

Enhance revenue and generate higher spend in store

Generate and capture external spend to drive higher balances

Give customers more reason to visit the retailer’s stores

Provide added benefits to customers, including loyalty programming.

Provide additional information of customer spending behavior to enable

direct marketing

Modifications will be done to the existing loyalty system. New loyalty will be setup for BHS PLCC and EVANS PLCC ORG/LOGO.

BHS – 121 /200

EVANS – 103/200 and 103/202

Current loyalty setup for BHS and Evans Master cards will be amended as per the new requirement in V+ Coding to generate the reports.

Two reports to be produced on the first of each month. One for points redeemed and the other for points earned.

The redemption report would show totals by Org/logo:

Total points redeemed in the preceding month - split by internal/external spend number of customers receiving redeemed points

The points earned report would show totals by logo:

Total points earned for all customers during their last complete cycle (e.g. the period up to the last cycle date for each customer) - split by internal/external spend

Total points brought forward from the previous cycle (summation of all BFD totals)

Total point carried forward at end of cycle (summation of all CFD totals).

Bonus points would be included with internal spends.

Statements and letters setup will be done for EVANS GOLD PLCC org/logo i.e. 103/202.

#8

Title

SII High Effort Project

Period

Jan’ 2006 - Jun’2006

Client

GE-Global Consumer Finance, Australia

Role

Team Member

Description

Roles &Responsibility

The GECF Australia Vision PLUS support group has a dedicated effort aimed at continuous improvements and optimization of the existing processes used within the GECF V+ system. These improvements maybe in the batch or the online, as and when an issue or irregularity is noticed. As part of this effort, several items are identified and tracked through tools such as Traffic Light Reports etc.

Some of the items identified are items requiring high effort, and some of these high-effort changes were clubbed together to be implement in the SII High Effort Project. The changes included items to reduce CPU utilization, increases parallelism in the batch, optimization of I-Os etc.

The final result of these changes is to reduce IT spending on capacity infrastructure and also to have a smoother and leaner background processing.

Involved in the following activities in this projects

Analysis, design and development works for SII High effort project

Development work is done in Vision plus and Easytrieve (Batch programs, Copybooks, Some added functionality).

Modifications are done in existing code to improve the Performance and Reducing CPU Utilization.

Report Generations and testing results through SUPERC

Unit testing, System testing

Prepared Technical Analysis documentation, Combined UTP & UTR’s and Implementation Plan.

Contact this candidate