Preeti Roul

P ***/*, DIAT(D.U), Girinagar, Near Khadakwasla Dam, Pune: 411025

Mobile: 888-***-****

Landline:020-********

Email : acf279@r.postjobfree.com

Career Objective:

To pursue a growth oriented career with a progressive company that provides

a scope to apply my knowledge and skills that would help me contribute my

best to the organization.

Personal Attributes:

Good interpersonal, communication and problem solving skills, ability to

grasp & willingness to learn new concepts and ability to organize and work

in a team.

Educational Qualification:

Masters in Computer Application(MCA), with Distinction from Pune

University, India - 2004.

Bachelors in Computer Science(BCS), with 1st Class from Pune University,

India - 2001.

Experience (around 6.0 years)

Previous Employer: Nomura (formerly Lehman Brothers Services Ltd,

Mumbai,India.)

Designation: Developer

Period: May 2008 -to- 27 July 2010

Previous Employer: Tata Consultancy Services Ltd, Mumbai, India.

Designation: Asst System Engineer.

Period: September 2007 -to- April 2008

Previous Employer: IBM Global Service India Pvt. Ltd, Pune,

India.

Designation: Software Engineer.

Period: August 2004 -to- August 2007

Areas of Proficiency: Skill Set:

Operating Systems: Win 2000, Win 95/98, UNIX

Programming Languages: (AIX) Unix Shell Scripting, (Core Java, JSP,

Servlets, Visual

Basic, .NET exposure)

Database : Teradata, Sybase(Exposure)

Tools: Teradata Load Utilities Bteq, Fastload,

Multiload, Fast

Export, Acuate, (Informatica,

Jasper iReport and BO exposure.)

Certifications:

1. Certified Teradata Professional V2R5

2. Teradata Certified SQL Specialist V2R5

3. Six Sigma White Belt

Paper Presented:

Participated in the Telecom Sharenet held in Pune in IBM in Nov 06 and

presented paper on "Telecom Industry Standards- SID"

Projects: Prime Services Reporting

Duration: Oct 2008 - July 2010

Environment: Sybase,Unix,Java

Client: Nomura

I have worked on Sybase development along with basic Unix commands and

shell scripting. I have a basic knowledge of Java concepts too.

I was working as a Developer in Prime Services reporting team including

gathering of requirements, analysis of impact on existing reports and new

development in reports and Sybase.

My responsibilities Includes:

1. Development of projects that involve: Databases (Sybase 12.5, Data

Warehouses etc ) and Reports (Actuate ERD Pro 9, Unix)

3. Detail analysis of business requirements and implementation of the same

along with impact analysis on existing functionalities.

Projects: Asia DB Merge

Duration: May 2008 - Sept 2008

Environment: Sybase,Unix,Java

Client: Lehman Brothers - Prime Brokerage

The team is responsible for maintaining the data warehouse for the

reporting suite of the Prime Brokerage division of the bank.

Overview of overall requirement

Provide a globally consistent Prime Brokerage Report by offering same

set of tools, reports, accuracy and availability of reports,

regardless of Client / Account's region.

To requirement of this Program are split across 4 different Phases.

Phase I

Sync-up the Asia environment with production software of US/EU

environment. Modify software (loader, reports, scripts etc) to

maintain current reporting functionality (this might need some Asia

specific changes be done in Main Cycle too).

Phase II

Consolidate US/EU and Asia reports to a single set of Global Reports.

Develop data feeds and modify reports to close regional data and

reporting gaps.

Improve SOD mark to market prices, FX Rates for reporting.

Phase III

Support local time zone specific SLAs to deliver reports. Build

relevant reconciliations in place to check accuracy of reports.

Phase IV

Develop or enhance Prime Services applications outside of reporting to

support global clients and client services.

Responsibilities:

. Analysis

. Coding

. Unit testing, System Testing & UAT

. Migration & Implementation

Projects: EDW ONE PMS - HFS BI

Duration: November 2007 - April 2008

Environment: UNIX, Teradata Loading Utilities, Teradata Sql,

Informatica, BO

Client: Group Client - GE-CF.

Migration of HFS portfolio (with exception of Life Sciences

portfolio) from CEF to VFS on legacy side is mandating souring a

number of EDW Core attributes from VFS staging area and adding /

reorganizing existing EDW tables / fields for VFS to make sure HFS

Reporting continue to work post migration.

This includes :

. Sourcing existing attributes in EDW Core tables from TBID tables

(these are currently populated as nulls)

. Adding new attributes to existing EDW Core tables and sourcing

them from TBID

. Adding new tables to EDW Core and sourcing its attributes from

TBID

. Planning and executing X-ref update strategy to make sure

currently available history data for HFS gets reported correctly

post conversion

Responsibilities:

. Analysis and Design

. All mapping validation including tables and column mapping.

. Coding

. Unit testing, System Testing & UAT

. Migration & Implementation

Projects: Embarq Finance Information System

Duration: April 2006 - April 2007

Environment: UNIX, Teradata Loading Utilities, Teradata Sql.

Client: Embarq, USA.

Embarq data warehouse deals with the customer and revenue information.

The information is regarding LTD exists for customer and revenue

information.

The wireless data is taken from Visage.

The environments comprises of Mainframe and Unix boxes.

The data from the mainframe and Unix boxes are now stored into the Teradata

Database .

The customer information from the existing systems is stored in the form of

delta files which need to be maintained as part of the warehouse. The

revenue information is to be rolled up to the corresponding subsystems for

which the customer is a subscriber, the taxes or discount which are

allocated on his billing amount which is calculated for each bill cycle

year and month.

The Customer data is processed by CM Load Process.

There is a separate flow to process Revenue data.

This Embarq database is around 8Tera Byte.

Populate the Source Bill Customer ID on TFR9 D6255.026/PR000658

Duration: Feb 2007 - April 2007

Environment: UNIX, Teradata Loading Utilities, Teradata Sql.

Client: Embarq. USA.

Description:

Currently the SRC_BILL_CUST_ID in the TFR9_LOCAL_SRC_INVC_CHG table is not

being populated for non-wireless customers. The column should be populated

with the 13 digit CRB Account Number. This change accurately reflects the

source customer identifier making it easier for business users to report on

revenue by customer.This approach is based on populating the

SRC_BILL_CUST_IDs in TFR9_LOCAL_SRC_INVC_CHG where OS_BILL_SYS_CD is 'LT'

and the 1st 4 positions of SRC_FILE_CD is not WRLS .

We would be taking the value of SRC_BILL_CUST_ID from the corresponding

staging

tables as per my analysis and discussions with business clients.

We would also be sweeping the TFRJ and TFR9 tables to update all 'LT'

records where the 1st 4 positions of SRC_FILE_CD is not WRLS.

Responsibilities:

. Analysis and Design

. All mapping validation including tables and column mapping.

. Coding

. Unit testing, System Testing & UAT

. Migration & Implementation

Populate Source Invoice Date on TFR9 D6255.025/PR000665

Environment: UNIX, Teradata Loading Utilities, Teradata Sql.

Client: Embarq. USA.

Description:

SRC_INV_DT in TFR9_LOCAL-SRC_INVC_CHG is not being populated for any CRB

accounts except for wireless accounts. The SRC_INV_DT needs to be populated

for CRB records on the revenue fact table.

When loading TFR9 and all related revenue fact and aggregate tables,

SRC_INV_DT should be populated with TFHQ _BILL_DT field from the

TFHQ_CRB_CUSTOMER table for ALL CRB accounts from the corresponding

customer record (based on OS_CUST_ID join).

This population activity should be done at the stage where we are

populating the TFRJ

table itself so that we would not miss any records at a later stage. This

would ensure

that the fact table is correctly populated and not be overlooked.

Responsibilities:

. Analysis and Design

. All mapping validation including tables and column mapping.

. Coding

. Unit testing, System Testing & UAT.

. Migration & Implementation

Populate the SRC_LTD_BUS_UNIT_CD on TFR9 for CASS Records D6255.013

Environment: UNIX, Teradata Loading Utilities, Teradata Sql.

Client: Embarq. USA.

Description:

SRC_LTD_BUS_UNIT_CD on TFR9 is not populated for CASS records but is

populated for all other Embarq source systems. The business unit code

(company number) needs to be populated for CASS records on the revenue fact

and aggregate tables. Impacted applications include B5L and L7L

This approach is based on populating the SRC_LTD_BUS_UNIT_CD s with the

last

two characters of the TF75_CUST.SRC_LTD_BUS_UNIT_CD from the corresponding

customer record (based on OS_CUST_ID join).

Responsibilities:

. Analysis and Design

. All mapping validation including tables and column mapping.

. Coding

. Unit testing, System Testing & UAT

. Migration & Implementation

Create Archive Jobs for EQ Customer and Revenue Data Warehouse Tables

D6255.020

Environment: UNIX, Teradata Loading Utilities, Teradata Sql.

Client: Embarq. USA.

Description: It has been discovered that several tables in the EQ Customer

and Revenue Data Warehouse are not being archived resulting in a lack of

backup of critical files. The purpose of this project is to create the jobs

that will archive the tables not currently being archived.

For Archiving tables, approach is based upon identification of type of

archive(Table or individual archive, mass archive, database archive and

partition archive

) for a particular table. Tables excluded from the database archive must be

individual or mass archived. Mass archive for the table is based on the

table size and its loading schedule. PPI tables if loaded for the partition

only, we can do Partition archive for them.

Existing midrange code has to be changed which will now populate

TF59_TBL_ARC table. This table will be used by partition archive job.

We also have to run a PSR to populate all the history bill yr months in

TF59 table so that the mainframe job can read this value and archive the

table.

We have done this for each table in the revenue flow. Also we have done it

for tables present in job mb5lm526.

Responsibilities:

. Analysis

. Midrange Part Coding

. Unit testing, System Testing & UAT

. Migration & Implementation

Embarq Wireless Initiative Revenue D6093.55

Environment: UnixTeradata Loading Utilities, Teradata Sql.

Client: Embarq. USA.

Description:

This supports NLC wireless initiative.

We need to bring in Wireless revenue feed from CRB(LT) to provide reporting

functionality to the business clients.

B5L shall load CRB wireless revenue and usage feed into staging and

consolidated model tables tp provide business community with the data they

need for their reporting.

There are 5 new source/staging tables introduced. The 5 five files from

different sources/mainframe is put into these source tables.

We are supposed to remove the duplicates from these tables and populate the

cust_id from TFS9_OS_ID_XREF table. We also need to put all the data from

these tables into a single table using multi-statement insert. We need to

apply data conversions as necessary. The mb5ld201 job will use staging

tables to populate TFRJ_UNAPRVD_INVC_CHG and from there revenue will be

copied into TFR9_LOCAL_SRC_INVC_CHG after getting approved. Client also

changed some of the existing business rules with this SR.

Responsibilities:

. Analysis

. Done all mapping validation including tables and column mapping.

. Midrange Part Coding

. Unit testing, System Testing & UAT

. Migration & Implementation

Sprint Financial Information System:

Duration: December 2004 - April 2006

Environment: UNIX, Teradata Loading Utilities, Teradata Sql.

Client: Sprint Telecommunications. USA.

Description:

FIS is the financial information System which deals with the customer and

revenue information. The total environment is to integrate the multiple

data marts into unique data warehouse .The information is regarding three

subsystems LTD, PCS and GMG for which there exists customer and revenue

information. The environments comprises of Mainframe and Unix boxes.The

data from the mainframe and Unix boxes are to be stored into the Teradata

Database on the Unix box.

The customer information from the existing systems is stored in the form of

delta files which need to be maintained as part of the warehouse. The

revenue information is to be rolled up to the corresponding subsytems for

which the customer is a subscriber, the taxes or discount which are

allocated on his billing amount which is calculated for each bill cycle

year and month.

This Sprint database is around 40Tera Byte.

Customer Load Jobs Scheduling D3172.086

Environment: Unix, Teradata

Client: Sprint. USA.

Description:

This project is to provide the capability to meet the business needs of

getting the day's customer changes loaded into the warehouse by the next

morning and to increase the load windows as well as alter some of the

scheduling. Created 2 new traffic cop jobs(one for TF75 and TF10) that will

run every 30 minutes between 1:05 and 7:05 and will only kick off the CM

load if the wireless data is ready to load. If the Wireless data is ready

to load, it will load any customer data that is ready regardless of

division.

Responsibilities:

. Coding

. Unit testing

ECID/Name Reference Table D3172.102

Environment: Unix, Teradata

Client: Sprint. USA.

Description:

This project is required in order to keep the records of ECID match type

indicator(UM and CM) and the corresponding surviving customer name as

stored in TF75_CUST in reference tables. We have to populate one reference

table with Customer Match and the corresponding Customer name and another

reference table with Ultimate Match and corresponding Customer name. The

project gives the business the ability to track the ECID match type

indicator for particular records present in TF75_CUST table. Every time the

TF75_CUST table gets updated with ECID details, the reference tables will

be updated along with.

Responsibilities:

. Coding

. Unit testing

Daily update of new Segmentation on TF75 D3172.136

Environment: Unix, Teradata

Client: Sprint-Nextel. USA.

Description:

This project aims to support a daily update of new segmentation on TF75 on

ST_PROD_TBLS database. Basically the OS_MKT_MNR_SEG_CD and

os_lvl_0_vert_seg_cd columns of TF75_CUST will be populated from

report_minor_seg and lvl_0_vert_seg_cd columns respectively of the SEG_PERM

table of IM_TMP2_TBLS database. The corresponding current row(s) of TFH3 on

ST_PROD_TBLS will be updated accordingly.

Responsibilities:

. Coding

. Unit testing

Resourcing ECID for FIS and Daily Duns D4291

Environment: Unix, Teradata, Trillium, SyncSort, Abinitio

Client: Sprint. USA.

Description:

The purpose of this project is to convert the sourcing for Corporate ECID

to the One Sprint finance data warehouse(FIS). In addition, the Duns

matching portion of ECID needs to be converted from a weekly to a daily

process. Corporate ECID provides 5 levels of house holding for various

customers, including finance and marketing. The goal of the project is not

to rewite the logic of the matches, rather source the data from the FIS

warehouse instead of PAR/PINNACLE and add efficiencies that will both speed

up the delta process as well as allow the Duns matching to occur on a daily

basis, rather than the current weekly runs.

Responsibilities:

. Coding

. Unit testing

Production Tickets Resolved:

Issue 220

Description: 3 given a/c no are not showing up in ECID tables. These same 3

a/c are visible in SEG_PERM table, and also in T251 table(HU_PROD).

Identify why they are not visible in ECID.

I cloned the sample data of these tables right from the mainframe part and

ran the whole ECID process till its populated in SEG_PERM and ECID. No

problem with code. Client was mistaken about the a/c nos.

Skills required: Teradata, UNIX, Strong Business Knowledge of FIS

Issue 242

Description: The entry for DUNS 71771562 needs to be deleted from new DnB

data. This DUNS is not a customer of Sprint, but has the same address as a

customer. Our customer is incorrectly rolling up to this DUNS.

For resolving this issue I found that we just need a PSR to delete this

particular record from T619_DNB_BUS_WORK.

Skills required: Teradata, UNIX Strong Business Knowledge of FIS

Issue 245

Description: Need to change the T619_DOM_ULT_DUNS_NBR in production table

T619_DNB_BUS_WORK to a given value.

For resolving this issue I found that we just need a PSR to update this

particular record in T619_DNB_BUS_WORK.

Skills required: Teradata, UNIX, Strong Business Knowledge of FIS

Issue 254

Description: There appears to be an issue with the TF75_GEO_ID not matching

TFNX_CSA_ID in level 2. There are 37 instances and all are from base load.

I have gone through the data and found that the TF75_GEO_ID does not match

TFN2_CSA_ID in level 2. Code is ok. Sweep to update records in TF75 and

TFH3 with those in TFN2 is required.

Skills required: Teradata, UNIX, Strong Business Knowledge of FIS

Personal Information:

Date of birth: June 13th, 1980.

Marital Status: Married.

Nationality: Indian.

Languages Known: English, Hindi, Marathi, French.

Preeti Roul

Contact this candidate