SATYAVATHI K

Phone: 741-***-****

E-mail: acekzr@r.postjobfree.com

SUMMARY

Having 3.6 Years of working experience in the IT Industry as ETL (Business Objects Data Services/

Data Services) and Oracle SQL Developer.

Configured and installed SAP Business Objects Data Services and Job Server on client systems.

Creating Scripts, Batch Jobs, Workflows, Data Flows and Executing jobs with Data Services

Designer. Loading Data into Target using flat files, XML files, Excel Workbook and Database

tables used as source files.

Configuration of Central Repository for Multi User Environment.

Having experience in upgrading BODS version from 3.2 to 4.1

Experience in debugging and performance tuning of sources, targets and mappings

Capable of distributing data in the form of XML and Flat files.

Created ETL logics to load the data warehouse using BODS readymade transforms like

Table_comparison, History_preserving, Case, Date_generation, Effective Date, Merge, Look

up, Key_generation, Map_operation, Validation, Pivot, Reverse Pivot, and Query transform etc.

Proficient in all phases of software development life cycle (SDLC) including requirements gathering,

Analysis, Design, Performance tuning, testing and support.

Knowledge in Data Quality Transforms.

Good experience in coordinating the work (Offshore and Onsite) and End Users in Team based

environment.

PROFESSIONAL EXPERIENCE

Company: Luensen Technologies

Tenure : Nov 2010– Present

PRIMARY TECHNICAL SKILLS

ETL Tools : Business Objects Data Services11.7 &12.2&4.1

Database : Oracle 10g, 9i and SQL Server 2005/2008

OS : Window and Unix

EDUCATIONAL QUALIFICATION

Bsc with Distinction from A.S.N degree college for women,Amalapuram(2006-

2009)

SUMMARY

PROJECTS

Project: 3 Mar 13 - Till Date

Global dwh for Abbey National Bank

Client : Abbey National Bank,UK

Role : ETL Developer

Description:

The customer is a pre-eminent investment management organization with

offices in United

Kingdom. The customer wanted to start a Data Warehouse (DW) to meet its

analytical reporting

and decision support requirements. Main objective of the DW is to Increase

business efficiency

through a centralized global view of holdings, transactions and trade and facilitate

global

exposure analysis, global compliance etc. Increase Data Quality by centralized data

quality

monitoring, Understand the different source System/s that reside on diverse

platforms,

Identify/Extract data from various source ystems, Meta data management

Design and create a

data mart for downstream applications .

Responsibilities:

Worked on implementing new jobs with Business Logics.

Prepared ETL Mapping documents

Worked on Business objects Data Services for developing jobs.

Worked Extensively on various Transforms like Case, Merge, Date Generation, Map Operation,

Key Generation, Validation, Query, Row Generation, History Preserving and Table Comparison

etc.

Used Central Repository to checkin /checkout operation of jobs

Perform Transformation and validation process

Coding, testing, modifying, debugging, documenting and implementation of bods jobs.

Environment:

Business Objects Data Services 12.2(3.2), Oracle,Microsoft SQL Server,Flat Files,XML.

Project: - 2 Feb 12–Mar 13

American Insurance Corporation

Client : Humana Health Insurance, USA

Role : Data Services Developer

Description:

Insurance is one of the leading insurance companies in the Country. The application

helps the field agents of the company to enter prospective customer data. The application

also calculates the amount of premium required, cash value and benefit amount for the years

in consideration. The project dealt with registering the members in online applications having

different modules to get details of coverage of the members, change the term of their

coverage and use the premium calculator to determine the new premium.

Responsibilities:

Involved in gathering business requirements, functional requirements and data specification.

Creation of ETL Processes for the added new Subject areas, Develop Data Extraction,

Transformation and Loading Program using Data Services.

Created Workflow, Data flows, Batch Jobs to extract the data from various sources and load into

target.

Involved in Creation of jobs that specify data mappings and transformations by using Data Services

Designer.

Worked on writing scripts and used lookup_ext functions to reference the reference table data.

Used Data Services to load data from different sources (MS SQL server 2008, Text files) to the target

database.

Involved in creation of recoverable workflows during source and target server crashes.

Involved in creation of local repository and associating job server to it.

Involved in Performance tuning at source, transformation, and target levels.

Environment:

Business Objects Data Services 12.2(3.2),Oracle,Microsoft SQL Server 2008,Flat Files.

Project– 1: Nov 10–Feb 12

Med Decision

Client : NHS,UK

Role : Data Services Developer

Description:

MED Decision is a leading provider of software services and clinical data content to health care payer

organizations. Its innovative solutions collectively known as Collaborative Care Management (CCM) allow

companies to increase administrative efficiencies and improve the overall quality and affordability of health

care. The project CRIS 3.0 (Care Planner Reporting and Information Systems) is aimed at providing

optimized reporting solutions for Med Decision using Business Objects. This release has been suited for

generation of real time reports that connect directly to the backend database of Care Planner to provide

reports that are time sensitive and updated to second.

Responsibilities:

Responsible for gathering and analyzing business requirements.

Worked with different types of transformations like Query, SQL, Date-Generation and Validation.

Created Workflow, Data flows, Batch Jobs to extract the data from various sources and load into

target..

Involved in working with different components of Data Services.

Involved in validating and improving the quality of source data before loading it to the target.

Involved in pulling data from different data sources like flat files, template tables and relational tables.

Environment:

Business Objects Data Services 12.2(3.2),Oracle 10g,Microsoft SQL Server,Flat Files.

Contact this candidate