SAILAJA NIMMAGADDA,

Email: ablnhj@r.postjobfree.com

Contact : 248-***-**** (Mobile)

Career Summary:

. 4.2 years of experience in Software Development and Implementation of

Packaged Data Warehousing solutions using Informatica, SAS and Teradata

. Good exposure of Data Warehouse concepts and SDLC Life cycle.

. Excellent working experience on Informatica V8.1

. Worked on Informatica transformations like Normalizer, Lookup, Source

Qualifier, Expression, Aggregator, Sorter, Rank and Joiner.

. Hands on experience on SAS Enterprise Guide 4.1, SAS Data Integration

Studio 3.4 and Teradata V2R6, Teradata SQL Assistant.

. Excellent team spirit and ability to quickly adapt different project

environments and technologies with impressive communication skills.

. Extensive experience in handling the Team.

. Good exposure on Insurance Domain and acquired Accenture certification on

this domain.

. Experience in using the SQLPLUS and TOAD

Education

Bachelor of Technology in Information Science & Technology Engineering.

Strengths:

. Sense of Responsibility

. Enthusiastic

. Dynamic Team Player

Technical Skills:

Technology Class Technology

DBMS SQL Server 8.0, Teradata V2R6,

Oracle 10i

DW Tools & Technologies

ETL Tools Informatica 8.1, SAS Enterprise

Guide 4.1 (BI) and SAS Data

Integration Studio 3.4

Database Comparison CDB (Cross Data Base) Comparator

4.0

Languages / Scripts PL/SQL, UNIX Scripting

Certifications:

. Achieved certification in Informatica - PowerCenter 7 Mapping Designer

. Achieved certification in Teradata - Teradata V2R5 certified professional

Experience:

Organization

Title From To

Accenture Services Pvt Ltd. Senior Mar 2006 Jan 2010

Hyderabad, India Software

Engineer

Liberty Mutual Agency Markets, Senior Jul 2009 Dec 2009

Indianapolis, US (As part of Software

Accenture) Engineer

Ness Technologies Pvt Ltd. Senior Jan 2010 May 2010

Hyderabad, India Software

Engineer

Project Experience Highlights:

Organization: Ness technologies

Pvt Ltd

Standard & Poor's Jan

2010 to May 2010

Standard and Poor's formally known as "S&P" is one of the Mc Graw-hill

Group of companies, Headquartered in New York. It is basically a Credit

Ratings company which deals with Stock based companies. Company will

provide ratings to any Organization, Funds and Government Institutions.

Standard & Poor's serving for more than 50 years is a leader of financial-

market intelligence. Standard & Poor's strives to provide investors who

want to make better informed investment decisions with market intelligence

in the form of credit ratings, indices, investment research and risk

evaluations and solutions. Standard & Poor's is an independent provider of

credit ratings. They published more than 870,000 new and revised credits

ratings. Standard & Poor's independent equity research business is among

the world's leading providers of independent investment information,

offering fundamental coverage on approximately 2,000 stocks.

The objective of BI effort is to populate the personal information and

their hierarchy information of Standard & Poor's employees.

Roles & Responsibilities:

. Analyze the employee information in the existing database

. Interact with client team to get clarifications for issues if any.

. Identify the duplicate information and work with client team to get it

resolved

. Populate ETL to provide the hierarchy information of all the

employees.

. Provide understanding document on the project

. Unit test the ETL workflow & mappings - fixing the defects if any

. Migrate code from test to prod environment

. Load the data from production tables to Golden source link.

Software : Informatica Power Center 8.1.1 as ETL Tool and

Oracle as Databases

Domain : Insurance

Team Size : 2

Project Duration : Jan 2010 - May 2010

Organization: Accenture Services

Pvt Ltd

Liberty Mutual - Agency Markets

SAS Business Integration Service:

SAS BIS team involves in job creation work for the production by data

integration, mapping, validation issues, data issues and ad-hoc requests

for the OCG policy model. It also involves in supporting maintenance and

validation for other policy models like AQS, PLS, Summit.

Highlights:

. Lead a team of 3.

. Interacted directly with the client to understand the existing model

and communicate the same to the offshore team members to leverage new

model in similar way using different sources and logic which improves

the performance.

. Develop strong knowledge on various policy models.

. Provide additional technical and business insight into ETL job

creation.

. Provide ETA on requests and ensure delivery within that.

. Guide the team to follow coding standard guidelines and procedures

. Gather daily status from Offshore team and Communicate the same to

clients

. Getting the requirement issues resolved.

. Preparing Weekly status on the tasks completed and pending for the

next week.

Software : SAS EG 4.1 and SAS DI 3.4 as ETL Tool and Teradata

as Database.

Domain : Insurance

Team Size : 4

Project Duration : Jan 2009 - Jan 2010 (Worked in Indianapolis, US from Jun

2009 to Dec 2009)

Liberty Mutual - Agency Markets Sept

2007 to Jan 2010

Boston-based Liberty Mutual Group is a diversified global insurer and sixth

largest property and casualty insurer in the U.S. based on 2007 direct

written premium. The Company also ranks 94th on the Fortune 500 list of

largest corporations in the U.S. based on 2007 revenue. Agency Markets, a

major business unit of the Liberty Mutual Group focuses on independent

agency distribution and has approximately 7,000 employees.

Liberty Mutual Group offers a wide range of insurance products and

services, including personal automobile, homeowners, commercial multiple

peril, commercial automobile, general liability, surety, workers

compensation, global specialty, group disability, assumed reinsurance and

fire.

The objective of BI effort is to define and implement information and data

analysis capabilities that are effectively used across the enterprise to

enable innovation and transformation and to drive fact-based decision

making at all levels of the company. Delivered this solution as onsite-

offshore methodology.

Roles & Responsibilities:

. Understanding of the Requirements Documents and interact with client

team to get clarifications for issues if any.

. OnSite-OffShore coordination, participating in weekly all-hands

meeting with onsite teams, participating in client interactions to

resolve any business logic issues/concerns, participated in knowledge

transition activities, escalate any techno-functional issues to the

leads, and ensuring about the task timelines and quality.

. Creating schematic diagrams for depicting the pseudo mapping logic,

and workflow logic. Creation of Unit test cases for each component in

workflow and for other tasks as part of ETL process.

. Conduct/participate in the peer reviews of Mapping Documents - Get the

sign-off from client to start construction phase.

. Unit test the ETL workflow & mappings - fixing the defects which came

out of unit testing and if needed, make modifications to the documents

to ensure that those are up to date as per the functionality in the

system.

. Migrate the code from one environment to other environments

Client : Liberty Mutual, Indianapolis, U.S

Designation : Software Engineer

Project Duration : Dec 2008 - Jan 2009

As part of BI program, I have delivered the following projects:

Automated Underwriting Process - Integrated Decisions Result (AUP/IDR):

AUP/IDR project will focus on integrating data from IDR database with data

already in the EDW. This will enable the EDW to support for analytics into

the data per industry best practices. AUP calculates the Quality Index (QI)

and makes underwriting decisions, pricing and touch decisions.

Highlights:

. Worked in a team of 34.

. Responsible for work effort estimation, the detailed task plan and

assigning tasks to members and conduct peer reviews and code reviews.

. Review of Design documents and Mappings.

. Provide development support for team members

. Driving the team to reach the deadlines within/before the estimated

time

. Help new comers in the team to catch up to the speed.

. Guide the team to follow standard guidelines and procedures

. Guiding the team in doing root cause analysis in case if data seems to

be invalid etc.

. Communicating the daily DEV status to Onshore team and getting the

issues resolved

. Participate in fixing the defects from various testing phases

. Participate in providing the post production support.

Software : Informatica Power Center 8.1.1 as ETL Tool and SQL

Server and Teradata as Databases and CDB Comparator.

Domain : Insurance

Team Size : 34

Project Duration : Sept 2007 - Dec 2008

PACE - Thrivent Financial for Lutherans April 2006 to Aug

2007

"Thrivent Financial for Lutherans" and its affiliates offer a broad range

of financial products and services including life insurance, annuities,

mutual funds, disability income insurance, bank products and more.

Accenture is providing an Enterprise Incentive Management System - titled

as PACE to Thrivent. As par of PACE, delivered Agent's Administration,

Conversion of Legacy System's Data, Data provider for Downstream Systems,

Incentives / Compensation Calculations, Data Provider for Payment

Processing Systems and General Ledger, and Reporting Application (True

Information), where all the Sales Force Group can see their attainments,

performance, rating, compensation and Incentives related information

including transactions.

Used Callidus True Comp Suite for automating the compensation calculations

- everything is rule based and easy to customize Compensation Rules based

on twists in Compensation Process and/or cycle. We have used Informatica as

an ETL tool to integrate the source systems and staging areas with the

target True Comp Schema. Used Informatica to populate True Comp Data Mart

which is source for True Portal where Sales Force Group will login and

monitor their compensation details. We have used Actuate e.Reporting Suite

as a reporting tool in this PACE - EIM solution.

PACE EIM solution has been split into following Releases.

. Release1 which we have delivered recently, dealt with Agent

Administration, Conversion & Migration activities, and Compensation

Calculation for some group of Thrivent's prop and non-prop products

hierarchy nodes and four Reports for end users.

. Release2 also will add new nodes in existing product hierarchy to

calculate compensation with some new set of reports to end users.

Roles & Responsibilities:

. Understanding of the Business Requirements Documents (BRDs), High

Level Design Documents and High Level Test Cases - which are inputs

for us to come up with Low Level Design phase deliverables.

. Participated in weekly all-hands meeting with onsite teams,

participated in client interactions to resolve any business logic

issues/concerns, escalate any techno-functional issues to the leads

and get the answers.

. Worked as part of Design team and participated in some of the "Low

Level Design Documents" by coordinating with Accenture IDC Team,

Thrivent Client team and Accenture US counter part.

. Reviewed the Compensation Plans with distinct Compensation Rules

(Credit, Measurements, Incentives, and Deposits)of Participants (Agent

Groups in Sales Force Group) as per the guidelines and low-level comp

rule specification documents which been sent by Thrivent.

. Creating the Informatica mappings with distinct transformations to

o Extract the data from source systems, transform the data & load

in to OASIS.

o To transform the data from OASIS, enrich the transaction and

load the enriched transactions into "Transaction Enrichment

DataBase" (TED).

o Load the transactions from TED to TrueComp Staging area.

o Extract the data from TrueComp Repository, which is normalized

schema, and load into TrueComp DataMart schema, which is star-

flake schema. Actuate reports will pull the data from this Data

Mart schema.

Client : Thrivent Financial for Lutherans, Minneapolis, MI, USA.

Software : Teradata V2R6, Teradata SQL Assistant, Informatica Power

Center V8.1

Domain : Insurance

Team Size : 28

Designation : Software Engineer

Project Duration : April 2006 - Aug 2007

Contact this candidate