Developer Manager

Swathi [pic]

Ph: 727-***-****

Email: *********@***********.***

ETL INFORMATICA DEVELOPER

Summary:

. 7+ years of experience in IT Industry in Analysis, Design,

Development, Testing and Maintenance of Business Intelligence, OBIEE,

Data Warehousing and Telecom projects. Excellent Analytical and

Problem Solving Skills.

. Experience in Full Life Cycle Implementation of Data warehouses.

. Practical understanding of the Data modeling (Dimensional &

Relational) concepts like Star-Schema Modeling, Snowflakes Modeling,

Change data capture methodologies..

. Good understanding of Software Development Life Cycle (SDLC) and

Project Life Cycle.

. Used Informatica as an ETL to extract data from source systems to

target system. Experience in understanding & creating source and

target definitions, mappings, transformations and working with

sessions.

. Worked with Informatica transformations such as source qualifier,

joiner, connected/unconnected lookups, expressions, routers,

aggregators, update strategy, filters, normalizes, sequence

generators, etc.

. Experience in implementing Slowly Changing Dimensions.

. Hands on experience in performance tuning of mappings, identifying and

resolving performance bottlenecks in various levels like sources,

targets, mappings, and sessions.

. Expert in Designing and developing the OBIEE Dashboard report

including guages, graphs and charts.

. Experience with all components within Oracle's BI Applications (OBIEE)

including Presentation Services, Dashboards, iBots, DAC, Informatica,

BI Server, BI Publisher and Report Server. Expert in Oracle BI Server,

Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI

Publisher, Oracle BI Delivers and OBIEE performance tuning of BI

Applications 7.9.6.

. Experience in report development and data extracts using other Oracle

development tools including BI Publisher, Oracle Reports, SQL Loader,

etc.

. Experience developing with Interactive Dashboards, Answers (AdHoc), BI

Publisher.

. Advanced knowledge of standard data modeling tools, including Erwin

7.3 or Embarcadero ERStudio 9.0.

. Development experience with multiple applications in Oracle EBS

versions 11i and/or 12x.

. Strong Knowledge of Oracle Forms, Reports, XML Publisher, Work Flow,

AME, Interfaces

. Experience in RPD, Data Modeling, ETL, OBIEE/BI Publisher, Siebel

Analytics, Web Catalog. and OBIEE star schema

. Expert in DAC, Informatica, ETL architecture and OBIEE pre build data

models.

. Extensively worked on Oracle, SQL and PL/SQL programming.

. Developed Stored Procedures using PL/SQL.

. Good experience in UNIX shells scripting.

. Responsible for interacting with business partners to identify

information needs and business requirements for the project.

. Experience in OBIA Architecture and in depth experience in OBIA suite

( Oracle Database, Informatica, DAC, OBIEE)

. Proficient with OBIEE, OBIEE+, BI Publisher and Smartview.

. Flexible and Versatile who can adapt to any new environment and learn

fast with strong communication &interpersonal skills.

. Ability to perform well in a group or individually and can cope well

in a high intensity work environment

Education:

. Bachelors in Computer Science

Technical Profile:

ETL Tools : Informatica Power Center 9.x/8.x/7.x/6.x/5.x,

MSSIS, DAC

Databases : MSSQL server 2000/2005/2008, MS Access, Teradata,

Oracle 10g/9i/8i, DB2, MS Access97/2000

Languages : SQL, PL/SQL, SQL*Loader, SQL*Plus, C, C++

Scheduling Tool : Autosys, Tivoli

Operating Systems: Windows 98/2000/XP/Vista/7, UNIX

Office Tools : MS Office, Microsoft Visio, MS Visual Source Safe

Other Tools : Toad, Rapid SQL

Windows Utility Packages: Excel, Access, PowerPoint, Word

Professional Experience

Client: - USDA - NIFA, Washington, DC

April 2012 - Present

Role: Sr. OBIEE/Informatica Developer

Description: NIFA grants application, C-REEMS, has been deployed as a web

based application using Oracle 10g (Internal Application server) and

developed using Developer suit with OBIEE as a Front-End and Oracle 11g as

backend database. The web based application has unique features including

sending emails, generating fixed format files, loading data into tables

using SQL Loader programs, Forms and it will generating statistical year

end reports.. The purpose of the project is to obtain the data collection

from different customers in different systems and aggregate within the data

warehouse using OBIEE.

As an OBIEE & Informatica Developer my roles are to provide expertise

throughout the entire OBIEE Life Cycle from design and development

of OBIEE to support and reporting of implementations and to develop reports

using Oracle Answers/Delivers, provide Data modeling and mapping expertise

using Oracle BI Server.

Responsibilities:

. Effectively interacted with the end users for requirement gathering

and defined requirement specifications document by access and

retrieval of financial and personnel data from one single source.

. Identified & Created Facts, Dimensions, and Hierarchies of the

business model.

. Developed Segment Value Detail, Work Order Detail and OGA Repositories

(RPD) by importing metadata into Physical Layer, applied Business

rules in the Business Modeling and Mapping layer and created

customized user views in the Presentation layer.

. Created Catalog Groups and set permissions for items in the

presentation catalog and privileges and rights to users and groups.

. Designed and Tested Reports in the Dashboards for C-REEMS and created

the Ad-hoc report according to the client needs.

. Configured Interactive Dashboard with drill-down capabilities using

global and local Filters, Metadata Objects and Web Catalog Objects.

. Applied Cascading Prompts and Multi Level Prompts on Dashboards.

. Identified issues, performance bottlenecks, and optimized the Business

Intelligence Dashboards and Reports.

. Developed different kinds of reports (pivots, charts, tabular) using

global and local Filters.

. Developed mapping documents and provide estimates for each mapping.

. Extensively used various transformations like Aggregator, Expression,

connected and unconnected Lookup's and update strategy transformations

to load data into target.

. Wrote Custom SQL Codes for the reports.

. Applied Optimization Techniques for the better performance of the

reports.

. Involved in Monitoring and Scheduling different process flows using

Oracle Work Flow Manager.

. Used external tables to Transform and Load data from Flat files into

target tables.

. Used Debugger to validate Mappings by creating break points to analyze

and monitor Data flow.

. Involve in troubleshooting the load failure cases, including database

problems

. Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g,

Oracle BI Publisher, Oracle Delivers, Windows XP, SQL server 2008 and

Microsoft SharePoint.

Capital Group, Irvine, CA

Oct 2011-Mar 2012

Role: Sr. ETL Informatica Developer

Responsibilities:

. Worked with business analyst for requirement gathering, business

analysis and testing and project- coordination using interviews,

document analysis, business process descriptions, scenarios and

workflow analysis.

. Developed business requirements document (BRD) based on business

objectives, facilitated joint sessions.

. Worked on IDQ file configuration at user's machines and resolved the

issues.

. Analyzed business and system requirements to identify system impacts.

. Created flow diagrams and charts.

. Created the Detail Design Documents which have the ETL technical

specifications for the given functionality, overall process flow for

each particular process, Flow diagrams, Mapping spreadsheets, issues,

assumptions, configurations, Informatica code details, shell scripts

etc. and conducted meetings with the clients for the Approval of the

process.

. Analyzed the existing mapping logic to determine the reusability of

the code.

. Handled versioning and dependencies in Informatica.

. Implemented Slowly Changing Dimensions - Type I & II in different

mappings as per the requirements.

. Created Mapping Parameters, Session parameters, Mapping Variables and

Session Variables.

. Created, Tested and debugged the Stored Procedures, Functions,

Packages, Cursors and triggers using PL/SQL developer.

. Developed restart token on UNIX server for Real-time Informatica

workflows and customized real-time Power Exchange workflows.

. Involved in extensive performance tuning by determining bottlenecks at

various points like targets, sources, mappings, sessions or system.

This led to better session performance.

. Used OBIEEDAC to Schedule the Informatica mappings in the correct

order, dependencies between them based on the sources and targets.

. Configured the workflow to remember the last time data was extracted

from the source and configured parameter for each mapping so that only

changed records can be extracted the next time it is run.

. Created Xcelsius dashboards for the ORM (Owner Relation Management)

application

. Extensively used Alerts while creating the Dashboards (Xcelsius).

. Created and maintained the Shell Scripts and Parameter files in UNIX

for the proper execution of Informatica workflows in different

environments.

. Created Unit test plans and did unit testing using different scenarios

separately for every process. Involved in System test, Regression test

& supported the UAT for the client.

. Performing ETL & database code migrations across environments.

Environment: Informatica Power Center 9.1/8.6, Power Exchange 9.1, IDQ,

Toad, UNIX Shell Scripting, Oracle, SQL Server, Flat Files, Mercury Quality

Center, MS Project, HL7, IBM Initiate, NCA Mainframes for CA7 Job

Scheduler.

Client:-GE, OH

Feb2011-Sep 2011

Role:-ETL Developer

Project Overview: UEC stands for Unison Engine Components. The project

deals with sales and purchase of engines and their components with respect

to airlines and aircrafts.

Initially the information regarding the parts and engines along with

various other entities are placed in a database. The Information from is

then transferred to another Database to enhance the flexibility and the

usage of the data.

Project Description: The initial source is a symix Database where the all

the bulk information is placed. The required information is pulled from the

symix database and placed on the Unixbox.The files from the Unix server

will act as our source (flat files) and they are to be loaded into the

desired Database. The daily transactions will be carried out from the

target Database once the design is complete for the daily transactions

also.

The tool taken for this job is Informatica.There are two phases in the

development filed.The first phase is completing all the mappings for the

History load which is one time Load. The next phase is a incremental load

which consists of daily transactions.

All the mappings and logics have been applied adhering to all requirements

and naming conventions.

Responsibilities:

. Worked on the mappings for both history and incremental loads. As an

ETL developer.

. Ensured that all the naming conventions, formats are strictly

followed. and also worked for preparing test cases.

. Used various debugging techniques to debug the mappings

. Unit tested the maps by running SQL queries on source and target

. Involved in preparation of user manual and knowledge transfer

. Unit tested the maps by running SQL queries on source and target

. Tested data necessary to validate ETL code using positive and negative

scenarios

. Created Test cases, Test data and involved in Unit Testing to find the

business rules applied correctly.

Environment: Symix, Oracle Database, Informatica8.6, UNIX Shell Scripting,

Oracle, SQL Server

Client:-Motorola, Texas

Mar 2010-Feb2011

Role: ETL Developer

Description: Motorola is one of the leading US mobile producers. It is a

global leader in wireless, broadband and automotive communications

technologies and embedded electronic products. The purpose of this project

is to extract the products & global hierarchy data from various source

systems and exchange data from an Independent source system into SWA

Staging Application. The main objective of the project is to reduce the

time taken to detect warranty issues.

Responsibilities:

. Worked on Power Center client tools like Source Analyzer, Warehouse

Designer, Mapping Designer, Mapplet Designer and Transformation

Developer.

. Used most of the transformations such as the Source qualifier,

Aggregators, lookups, Filters, Sequence Generator and Update strategy.

. Developed transformations, mappings, sessions and workflows in

Informatica to load target database and tuned mappings for improving

performance.

. Involved in Data Extraction from heterogeneous source systems like

Oracle, DB2 and flat files.

. Used mapping parameters and variables to meet the business requirement

. Wrote UNIX shell scripts to execute Informatica Workflows.

. Developed universe and reports using Business objects.

. Worked on Business Objects reports like drill down reports, master

detail reports, etc.

. Worked on enhancing the reports according to business rules.

. Created the Test cases for Unit Test and involved in Unit testing.

Environment: Informatics Power Center 8.6 Business Objects 6.1, Oracle 8i,

DB2, UNIX, SQL, PL/SQL, Toad

Client:- Wachovia, India

Oct 2008-Feb2010

Role:- ETL Informatica Developer

Description: Wachovia is a diversified financial services company that

provides a broad range of retail banking and brokerage, asset and wealth

management, and corporate and investment banking products and services. It

is one of the largest providers of financial services in the United States.

This project deals with Managing the Data Sourcing ETL for Corporate,

regulatory and management reporting initiatives, Managing ETL Enhancement,

Maintenance & Data refresh support for ODS, BDW & KDM Environments. It also

deals with providing Maintenance & Support to Informatica Center of

Excellence.

Responsibilities:

. Prepared Functional/Technical Specificationdocuments from BRD

(Business Requirement Document) / Customer Requirements

. Involved in giving the estimate for the project

. Worked on Informatica PowerCenter components Designer, Workflow

Manager, Workflow Monitor and Repository Manager

. Involved in creation of data warehouse star schema using Data modeling

tool Erwin

. Involved in Data Extraction from heterogeneous source systems like

Oracle, DB2 and flat files.

. Created Informatica mappings, sessions and workflows to populate data

into Fact and Dimension tables

. According to the business logic created various transformations

likeSource Qualifier, Lookup, Sequence Generator, Router, Filter,

Aggregator, Joiner, Expression, Normalizer and Update Strategy

. Created reusable transformations and used in various mappings

. Performance tuning of targets, sources, mappings and SQL queries in

the transformations

. Developed mappings to implement type 1 and type 2 slowly changing

dimensions

. Used mapping parameters and variables to meet the business requirement

. Used various debugging techniques to debug the mappings

. Developed Informatica parameter files

. Involved in doing reviews

. Involved in creation of Stored Procedures using PL/SQL

. Wrote UNIX shell scripts to execute Informatica Workflows

. Mentored and guided the junior developers

. Created JIL scripts using the job scheduling tool Autosys

. Performed extensive SQL querying on Oracle database for data

validation

. Unit tested the maps by running SQL queries on source and target

. Tested data necessary to validate ETL code using positive and negative

scenarios

. Created Test cases, Test data and involved in Unit Testing to find the

business rules applied correctly.

Environment: Informatica Power Center 8.x, Oracle 10g, SQL, PL/SQL, DB2,

Stored Procedures, UNIX, Autosys, Rapid SQL, ERWIN 4.0

Data Matrix Solutions, Bangalore, Karnataka March

2006 - Aug 2008

Role: ETL Developer

Bangalore: Treasury Process Automation, Sales Information System, Inventory

Management System

Responsibilities:

. Developed various Mappings and Transformations using Informatica

Designer.

. Developed complex Mappings using Expressions, Routers, Lookups, Rank,

Filter, and Aggregator transformations.

. Developed complex mappings using multiple sources and targets in

different databases, flat and XML files.

. Created and configured Sessions to load the data from source to target

database using Workflow Manager.

. Configured session properties and target options for better

performance.

. Developed PL/SQL Functions, Procedures, Packages, and Triggers

. Developed the reports using Business Objects.

Environment: ETL, Informatica, Windows NT Client/Server, Oracle, Visual

Basic, Linux, Unix,

SQL, SQL*Plus.

Skills: ETL Informatica, Informatica, Informatica Power Center

9.x/8.x/7.x/6.x/5.x, Teradata, MSSIS, ETL

Contact this candidate