Developer Data

Subhalakshmi Gopisetty Phone: 309-***-****

Informatica & OBIEE Developer Email: **********@*****.***

PROFESSIONAL SUMMARY:

• Over seven years of total IT experience in the Business Requirements Analysis, Application Design,

Development, Implementation, Testing and production support of Data warehousing, Data Migration

and Business Intelligence Application using Informatica, Oracle warehouse Builder (OWB), OBIEE

& SQL.

• Expertise in installation, implementation and troubleshooting involving ETL Tools Informatica 8.6

and Oracle Warehouse Builder 10G and 11G

• Experience in Data Warehousing development using ETL tools such as Informatica Power Center /

Power Mart Experience with Workflow Manager, Workflow Monitor, Source Analyzer,

Transformation developer

• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence

Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations to extract

data from client’s operational databases, Transform and cleanse data and load it into data warehouse

• Good Understanding of dimensional modeling/Data Warehousing concepts and techniques

• Experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model &

Presentation Layer).

• Created OLAP reports using Presentation Services (Answers, Dashboard, Prompts, Filter, and Views).

• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and

Answers) using Repository Variables, Session Variables and Initialization Blocks.

• Experience in creating Time series measures using AGO & TODATE functions and Level based

measures.

• Executed projects in Waterfall and V-model Software development methods

• Worked in on site and remote development models and in various environments requiring team

coordination.

• Highly motivated team player with good communication skills and excellent problem solving abilities

to work independently or as part of a team.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.1,8.6.1 and 7.2

Oracle Warehouse Builder 10g, 11g

Oracle Data Integrator 10g

Databases: Oracle 11g/10g/9i/8i

Reporting Tools: OBIEE 10.1.3.x,11.1.1.x(Administration Tool, Oracle BI Web / Presentation

Services, Answers, scheduling iBots using BI delivers)

Languages: SQL, PL/SQL, Unix Shell Scripting, SQL*Loader

Tools: Toad, SQL Developer, Erwin, PVCS, SVN

Operating Systems: Windows, UNIX

Scheduling Tools: Control-M, IBM’s Tivoli Workflow Manager

1

WORK EXPERIENCE:

Maryland Department of State Education October 2012 – Present

BI (Informatica & OWB) Developer

This project at MSDE is aimed to track information of high school graduates taking up higher education. This

information is tracked by US Federal department to utilize State Funds. This accomplished by sharing data

between Maryland Higher Education Commission and Maryland State Department of Education.

The data from various student information systems is collated to support their internal analysis and reporting

purposes.

Responsibilities:

• Designed and developed many simple as well as Complex Mappings, from varied transformation

logic using Unconnected and Connected lookups, Filter, Expression, Aggregator, Joiner and more.

• Designed the ETL processes using OWB and Informatica tool to load data from File system and

Oracle into the target Oracle Database.

• Developed mappings to load data from various sources using standard ETL transformations to store

the data in the staging area and target tables.

• Extensively used both Connected and Un connected Lookup transformations

• Developed multiple Workflows using work flow manager for initial loading

Environment: Informatica 9.1, Oracle Warehouse Builder 11g, Oracle 11g/10g, SQL Developer

Blue Cross Blue Shield of Michigan Dec 2011 – Sep 2012

BI Developer

Blue Health Intelligence is the largest centralized national data warehouse that aggregates standardized

medical and pharmacy claims, membership and account information from the BHI participating Plans. BHI

brings together the healthcare experience of more than 54 million Blue Cross and Blue Shield members

nationwide in a safe and secure database.

The data is accessible by each participating Plan to support their internal analysis and reports.

As part of BHI Stage III project, Provider, SCCF (ITS Standard Claims Collection Facility claim) and

Account reporting information will be added to the existing process of sending claims file to BCBSA.

Responsibilities:

• Analyzed the designed dimension model and laid out the steps for the data extraction, business logic

implementation & loading into targets.

• Designed and developed many simple as well as Complex Mappings, from varied transformation

logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner,

Update Strategy and more.

• Designed the ETL processes using Informatica tool to load data from File system and Oracle into the

target Oracle Database.

• Developed mappings & mapplets to load data from various sources using standard ETL

transformations to store the data in the staging area and target tables.

Subhalakshmi Gopisetty

Informatica & OBIEE Developer

• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session

Level.

• Extensively used both Connected and Un connected Lookup transformations

• Developed slowly changing dimension, according to the data mart schemas.

• Developed multiple Workflows using work flow manager for initial loading, historical data loading,

using sessions, commands, decisions, events and timers.

• Responsible for implementing Incremental Loading mappings using Mapping Variables and

Parameter Files

• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-

mail using workflow manager.

Environment: Informatica 9.1, Oracle 11g/10g, SQL Developer, SQL*LOADER, UNIX

Merrill Lynch Account, Atlanta April 2011 – Dec 2011

BI Developer

This project deals with Anti money laundering system of Merrill Lynch. AML project replaces existing 4

different systems into one consolidated system. The first logical component in the new AML architecture is

the data acquisition subsystem. The primary function of this subsystem is to acquire the data needed for AML

surveillance. This data will originate from source systems in the different divisions of the firm: ISG, Zurich,

IM and GWMG and will be loaded into consolidated Legal & Compliance (LC) Data Warehouse. Main

subject areas that Application uses are: TRANSACTION and supporting reference data ACCOUNT, PARTY,

PARTY ROLE, PRODUCT, BALANCE and ACCOUNT GROUP.

Environment: Informatica 9.1, Oracle 11g/10g, SQL Developer, SQL*LOADER, UNIX

Responsibilities:

• Gathering the Business Requirements.

• Analyzed the data in the source system, analyzed the Target schemas, transformed the data and

mapped the data and load the data into targets using Informatica according to TDD specifications.

• Extensively worked with Informatica power center components for reusing the Business

Functionality.

• Developed mappings to load the data in slowly changing dimensions such as Type1 and Type 2

according to the requirements.

• Created mappings using Informatica tool for DQ checks and for bring the data from source to staging

tables and from staging tables to target tables. Actively participated in team meetings to gather

business requirements and in developing the specifications.

• Involved in unit testing and integration testing

.

Environment: Informatica 9.1, Oracle 11g/10g, SQL Developer, UNIX, SQL*LOADER

Oracle Account, California Jul 2010 – March 2011

BI Developer

Oracle Tax Analytics is a prebuilt business intelligence solution. Oracle Tax Analytics supports the source

system Oracle Enterprise Taxation Management V2.2.1.Oracle Enterprise Taxation Management is an

integrated Tax System solution that provides an end-to-end solution for Tax authorities at all levels of

government and improves tax office efficiency. The Oracle Tax Analytics Warehouse is a data repository for

3

forms(Number of processed, suspended & corrected Forms by Form Type, Tax Type, Tax Year, Time,

Employee, Time to Correct), payments(Number and $Amount of processed, suspended & corrected payments

by Payment Type, Source, Tax Type, Time, Employee, Time to Correct), and accounting(Number and

$Amount of financial transactions (Penalty, Interest, Write Off, Tax, credit), Penalty & Interest waivers) data

which supports the analytical requirements of the source system Oracle Enterprise Taxation Management.

The Oracle Tax Analytics Warehouse includes

a) A complete relational data warehouse data model with prebuilt star schemas encompassing conformed

dimensions and fact tables

b) Prebuilt data extractors to incorporate data from Oracle Enterprise Taxation Management into the

Oracle Tax Analytics Warehouse

c) Prebuilt RPD, reports and dashboards.

Responsibilities:

• Gathering the Business Requirements.

• Developed several reports and dashboards involving various views like table, pivot, graphs, narrative

and maps.

• Developed the RPD file.

• Attribute level Data Analysis and building Data Mapping from source to target applications.

• Worked extensively on OBIEE Answers to test the reports as per the requirements.

• Identified and worked with various application areas in identifying, analyzing, and documenting various

information sources solutions to meet the business requirements

• Extensively worked on OBIEE repository modeling at Physical, BMM and presentation layer

• Designed, developed and customized Reports and Dashboards using different analytical views.

• Designed and tested Reports in the Dashboards for the Oracle Tax Analytics and created the adhoc reports

according to the client needs.

• Created session variables for users to provide row- level security to build the query

• Implemented Row level, Column level and object level security..

• Used OBIEE Answers to create the Tax Statement reports and Dashboards as per the detailed design

requirements

• Coordinated the OBIEE RPD and Presentation Catalog objects migration across instances.

• Involved in setting up and working in multi-user developer (MUD) environment

•

•

• Environment: OBIEE 10.1.3.4, OBIEE 11.1.1.3, Oracle Data Integrator, UNIX, Oracle 11g, SQL

Developer,

• Oracle’s Enterprise Tax Management Suit

Morrisons Account, UK Nov 2008 –Mar 2010

Data Analyst and BI Report Developer

Morrisons has implemented an Oracle based ERP solution, enabling it to react to business initiatives quickly

and to be future ready. As a result of this many legacy applications will be replaced with this packaged Oracle

ERP suite of applications. This will call for migration of legacy data to the identified packaged applications

that includes Finance, Trading & Supply Chain, Logistics, Stores, Merchandising and Manufacturing.

Responsibilities:

Subhalakshmi Gopisetty

Informatica & OBIEE Developer

• Gathering the Business Requirements.

• Attribute level Data Analysis and building Data Mapping from source to target applications.

• Involved in designing the Requirement and Technical design documents.

• Coordinating with Offshore Team members for accurate code development.

• Involved in code deployment activities across various environments.

• Analytic Business Analysis: Translating high-level business requirements into logical Business

dimensional model; Defining various logical subject areas and organization Of presentation layer

meta data, Understanding and defining key metrics, Dimensions, hierarchies and attributes.

• Developed new subject areas in the repository per business requirements.

• Created, modified and formatted requests, along with charts and filters, in OBIEE Answers.

• Created, modified, and administered analytics intelligence dashboards with links to web sites; HTML

text; links to documents; and embedded content, such as images, text, charts, and tables.

Environment: Oracle Warehouse Builder (OWB 10g/11g), OBIEE 10.1.3.4, Informatica Power Center 8.6.1,

UNIX, Oracle 10g/11g, SQL Developer, TOAD

Reliant Energy Account, India May 2008- Jul 2008

PL/SQL Developer

Project Engineer

The Power Smart project is designed to provide consumers about the real-time information on their electric

power usage and provides pre estimated bill to the consumers. In this way the consumers can monitor to

regulate the total monthly bill amount.

Responsibilities:

• Co-ordinate with the Onsite team about the daily activities in offshore.

• To work on the requirement as specified by the user in consultation with the functional team and

developing the SQL and Shell scripts.

• Preparing the test data to suit the various business scenarios and to perform rigorous testing to

validate the requirement.

• Complete documentation of the requirement

Environment: Oracle 10g, SQL Developer, UNIX

Medtronic Account, India Dec 2006- Apr 2008

Project Engineer

The project involved post implementation support for i2 Demand Planner and Supply Chain Planner

implemented at Medtronic Inc, USA. This is based on CIS-ODS architecture and uses TmAPI schema. The

project involves support of i2 DP & i2 SCP for 5 business units of Medtronic, upgrade initiatives for i2 DP

and i2 SCP from 5.x to 6.x and fresh rollout of i2 DM for one business unit.

Responsibilities:

• Development of scripts (SQL,.KSH, .PL) to suit the business requirement.

• Development and testing the Forms as per the CRs. - Providing in time resolution to the EPM's (CR's)

to meet the SLA.

• Developing the extract scripts to populate data into i2 ODS schema.

5

Environment: Oracle 9i, D2K (Oracle Forms and Reports 6i), Unix, Informatics, Oracle Database 10g,

PL/SQL, PL/SQL Developer, SQL * LOADER, TOAD

Ingress Consulting Ltd Account, India Mar 2006- Nov 2006

Project Engineer

Ingress Consulting Ltd., is UK based company associated with various business partners like bank and

insurance companies. This project is for one of its Finance Companies, which is involved in distribution of

loan amounts. This project aims to provide detail level of analysis that would help the company to enhance

their business while making appropriate decisions.

Responsibilities:

• Design and development of ETL process using Informatica 7.1 to load data from file systems to the

Warehouse.

• Implemented complex SQL scripts in the Informatica mapping as per the business requirement.

• Developed sessions, scheduling, monitoring and debugging the sessions.

• Developed test plans and writing test cases for unit testing.

Environment: Informatica Power Center 7.1.2., UNIX, Oracle 9i, SQL Developer, TOAD

Falco Electronics Account, India Jan 2005- Mar 2006

Project Engineer

FALCO Cost and Sales Analysis System (FACSAS) help the customer to evaluate the sales and functional

performance of its business operations. FALCO has 3 manufacturing plants in Merida (Mexico), Xiamen

(China) & Bangalore (India) and having five liaison offices across the globe and above 20 warehouses across

the globe.

FALCO requires the best-cost analysis & sales Evaluation system to compare the cost trends in different

manufacturing locations & sales trends in different warehouses and liaison offices. The FACSAS provides the

information on customer’s buying patterns and trend over a period of time. The Production Cost & Sales

standard reports are generated automatically. The software is designed to provide ADHOC reports as per

customer requirements. The business development team analyze for further improvement of their business by

providing adequate information about sale leads & business conversion ratio.

The data is stored on the oracle database in all manufacturing & liaison office locations and stored on flat files

in warehouses. Each location at the end of the day shall upload data into central server(s). We have provided

Data Warehouse so that they could maintain historical data at central location for integration; analyze business

in different locations, according profit areas, which could serve a purpose of a DSS for decision makers.

Responsibilities:

• Informatica Power Center 7.1, 2. UNIX

• Responsibilities: Responsible for Extracting, Transforming and loading data from operational

database to warehouse database.

• Create and maintain Informatica Mappings. Defined source and

Target Definitions in Informatica

• Developed reusable mappings using Mapplet designer

Subhalakshmi Gopisetty

Informatica & OBIEE Developer

Environment: Informatica Power Center 7.1.2., UNIX, Oracle 9i, SQL Developer, TOAD

EDUCATION:

• Bachelor of Electronics and Communication, JNTU, INDIA 2004

7

Contact this candidate