ETL Informatica Developer resume in San Francisco, CA, CA, 94110

ETL Informatica Developer

Posted by:	Name is not set.
Posted date:	4/30/2008
Contact Info:	**@******.* Show Contact Info (premium) Send messge (free) - disabled by job seeker
Country:	United States
State:	California
City:	San Francisco, CA
ZIP:	94110

Resume Text:

PostJobFree
Premium Subscription
secure payment
through
Google Checkout.

We do not ask for
your credit card number.

Srinivas Yeluguri ETL Informatica Consultant
510-962-****
------------------------------------------------------------------------------------------

SUMMARY
• 6 + years of work experience in IT Industry in Analysis, Design, Development and Maintenance of various software applications mainly in Data Warehousing (Informatica Power Exchange, Informatica Power Center, DataStage, Business Objects), Oracle (SQL, PL/SQL) and Windows environments in industry verticals like Banking, Marketing, Retail, Hospitality and Healthcare.
• 2 + Year of Data Modeling & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• 5 years of database experience using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader, Stored Procedures, Functions, TOAD, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, , Inline Views, IBM DB2 UDB 8.0/7.0 & MS Access.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and XML.

EDUCATION
• Masters of Computer Applications

TECHNICAL SKILLS
ETL Tools: Informatica Power Exchange 8.1, Informatica Power
Center 8.1/8.0/7.1.2/7.1.1/7.0/6.2/5.1.2, Power Mart
6.2/5.1.1/5.0, Informatica Power Connect,
Informatica Designer, Workflow Manager, Work flow
Monitor, DataStage, Oracle Warehouse Builder
(OWB), SQL*Plus & SQL*Loader
Business Intelligence: Business Objects XI R2/XI/6.5/6.0 (Web-Intelligence
6.X/2.X, Designer, Info view, Designer, Supervisor,
Application Foundation Dashboard Manager, Business
Objects Reporting, Cognos (Impromptu reports,
Transformer, Power play, ReportNet)
Data Modeling: Dimensional Data Modeling, Star Join Schema
Modeling, Snow Flake Modeling, FACT and Dimensions
Tables, Physical and Logical Data Modeling, Erwin 3.5.2/
3.X & Toad 8.0/9.1
RDBMS: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, SQL
Server 2000/ 2005 & MS Access
Programming: UNIX Shell Scripting, SQL, PL/SQL, VB, C, C++ &
Java
Operating Systems: Windows 2000, UNIX AIX
Other Tools: Aqua Data Studio and Dashboard CDMA

PROJECT EXPERIENCE SUMMARY
BlueShield of California, CA Jan’ 08 – Till Date
Programmer Analyst

Project: IA Migration
The provider system of record used by Blue Shield of California for storing Provider Identification Numbers (PIN) is the California Automated Provider System, or CAPS. The PIN certification or assignment process and system is maintained by the Provider Services department within the Network Management division. The purpose of CAPS is to establish and maintain a central source of provider information.
Responsibilities:
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange
• Implemented a New Project by changing the current DW, written details design document & turn it over to the developers
• Helped the team in analyzing the data to be able to identify the data quality issues
• Work with Business Analyst and business users to clarify requirements and translate the requirement into technical specifications.
• As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Work closely with various levels of individuals to coordinate and prioritize multiple projects. Estimate, schedule and track ETL projects throughout SDLC
• Coordinating with user to gather the new requirements and working with existing issues.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router
• Data quality checking and interacting with the business analysts
• Good experience in communicating with offshore team
• Communication with the client for weekly status report
• Performed testing as per UTCs
• Testing and debugging of code
Environment: Informatica Power Center 8.1, Power Exchange 8.1.1, VSAM files, Flat Files, Oracle 10g, Erwin 4.x, Quest Toad Central 9.1, CDMA, Unix Shell Scripting and Windows 2000

Wyndham Hotel Groups, NJ Mar’ 07 – Dec’ 07
Associate

Project: Wyndham Brand Integration
Wyndham Hotel Group (WHG, formerly Cendant) is in the process of integrating applications of Wyndham Hotels into the EDW and /or data mart. Each property level Stay, Reservation and Smith Travels information flows to EDW and then to Marketing and Operations Data Mart for reporting purposes

Responsibilities:
• Analyzed the current system for the core properties
• Analyzed the impact of changes on the existing systems
• Involved in ETL design for the new requirements
• Suggested feasible solution, to integrate the core and the new property systems
• Created 200 mapping for moving the data from different sources into Oracle database
• Used INFORMATICA (Power Center) tool as ETL tool for constantly moving the data from sources into staging area
• Troubleshoot and tune SQL using EXPLAIN PLAN
• Prepared Test cases for the Project
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication
• Fixed the Issues that come out of Integration Testing
• Involved in reviewing the Test Cases written by the peers
Environment: Informatica 7.1.2, XML, DB2, Oracle 9i, Flat Files, Quest Toad and Central, Windows 2000 and UNIX AIX

Wyndham Hotel Groups, NJ Sep’ 06 – Feb’ 07
Programmer Analyst

Project: ETL System Maintenance and Enhancement
Cendant needs to analyze consumer behavior on a constant basis for its direct marketing initiatives. For the success of these initiatives it is essential to provide a Consolidated Consumer view. This view should be reliable, clean and should integrate data from Cendant’s various disparate source systems. The data is extracted, transformed and loaded in Enterprise Data Warehouse (EDW) from different source systems. Also, the data is being extracted, transformed and loaded to different data marts from EDW for the reporting purpose.

Responsibilities:
• Monitoring the identified ETL processes, restarting the ETL processes that aborted
• Rescheduling specific ETL processes when there is one such requirement, Work with System Administration on backups/image copies.
• The above listed maintenance tasks for the other environments where the similar ETL process runs.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes – success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Modified Existing ETL scripts to fix defects at the root cause as enhancement part of project.
• Requirement gathering, Requirement Analysis, Coding, Code Review, testing, Implementation, Production support, Project Management, Weekly/Monthly Status reports
Environment: Informatica 7.1.2, DB2, Oracle 9i, SQL Server 2005, UNIX Shell Scripting, Quest Toad and Central, Aqua Data Studio and Erwin

Carlson Marketing, CA Nov’ 05 – Aug’ 06
Programmer Analyst

Project: Carlson Sales Driver
Carlson Marketing creates and maintains various programs for different clients as per their requirements. The data was migrated from Minneapolis to Canada. The different programs and their reward points are maintained and assigned to the participants in the system. The project involved designing the target data mart, ETL design and development along with testing.

Responsibilities:
• Requirement gathering, Requirement Analysis, Coding, Code Review, testing, and Implementation
• Involved in creating, editing, scheduling and deleting of sessions and batch of session using workflow manager in Informatica
• Designed Metadata tables at staging in order to do impact analysis
• Implemented Query tuning and setting optimization on Oracle 9i (Rule and Cost Based).
• Involved in the designing and Building of Universes, Classes and objects for Sales, Marketing.
• Used Business Objects Designer to implement Universe, Linkages between Tables, create prompts and queries, and parse the Universes, applied Contexts and Alias Tables to remove cyclic dependencies.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Handled time critical Development requirements
• Delivery review
• Provided fixes for critical bugs and assisting code moves to QA.
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication
Environment: DataStage 7.5, Oracle 9i, Business Objects 6.5, Flat Files and Windows 2000

Orbitz, CA Mar’ 05 – Oct’ 05
Programmer Analyst

Project: Orbitz DW Enhancements and Maintenance
Orbitz, a wholly-owned subsidiary of Travelport Corporation and part of Travelport Travel Distribution Services division, is a world leader in providing Travel and distribution services.

The project involves resolving issues related to the Orbitz data warehouse, analysis and construction of business critical ETL enhancements as per the end users’ requirements

Responsibilities:
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations
• Designed and developed various Mappings using Active & Passive Transformations.
• Implemented various Data Transformations using Slowly Changing Dimensions
• Used various Transformations like Expression, Filter, Joiner and Lookups for better Data messaging, migrate clean and consistent Data.
• Used TOAD for SQL
• Used Debugger for debugging Mappings
• Designed and configured sessions with effective caching and logging
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Implemented Slowly Changing Dimensions (Type 2: versions) to update the dimensional schema.
• Resolved session locking issues using Informatica repository manager
• Monitored workflows and collected performance data to maximize the session performance.
Environment: Informatica 7.1.1, Oracle 9i, Quest Toad

STMicroelectronics, Switzerland Dec’ 03 – Jan’ 05
Software Engineer

Project: Partners of Network Systems
STMicroelectronics is a Network Component Company located in US, Europe and France. Products include LAN Routers, SAN Modular and Voice Gateways. The data warehouse maintains the client’s Partner Database information like Partner type, Partner Qualification, Partner country and the details about which partner of the client has been enrolled. The present system generates reports by using Java application. This repoted are very basic is not intended for sophisticated for analysis.

The client requirement was to be build a Data Warehouse to maintain historical data at central location for analysis of the businesses in different locations. The system servers as DSS for the management to analyze the operations of profit centers

Responsibilities:
• Interacted with onsite team,
• Prepared Test cases for the module
• Fixed bugs during SIT.
• Handled time critical Development requirements
• ETL Design Review
• Implemented Materialized Views using P/SQL for loading extended tables
• Designed and configured sessions with effective caching and logging
• Created reusable Mapplets and transformations
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication
Environment: Informatica 7.1.1, DB2, Teradata, Toad, Erwin 3.0, Oracle 8i and Toad

Saudi Electricity Company, Saudi Feb’ 03 – Nov’ 03
Software Developer

Project: Distribution Analysis System
This project helps in decision makers to Analyze the Electricity Distribution and sales in different Categories (Industrial, General, Etc,.)Of customers .It also analyses various Business angles and sales patterns. Data warehouse strictly based on Star Schema to accommodate future additions without affecting the existing structure and application development

Responsibilities:
• Extensively involved in extraction of data from Oracle, Flat files
• Design of ETL process using Informatica
• Developed various Mappings using Aggregator, Joiners, Lookups, Filters, Router and Update strategy
• Optimized various Mappings, Sessions, Sources and Target Databases
• Unit testing performed on Mappings.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema techniques
• Involved in Development and Deployment of Complex Reports using methods like Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc
• Involved in Installation and Configuration of all Components of Informatica
Environment: Informatica 6.1, Oracle (PL/SQL Scripts) 8i, Business Objects 6.0 & ER–Oracle 8i and Flat files

Meier – Tech, Malaysia Feb’ 02 – Jan’ 03
Software Trainee

Project: Automobile Business Intelligent System
This project studies the Analysis, Business trends and Sales of this industry. It generates reports regarding the existing business situations .It also identifies the product trends and develop channel Strategy. By analyzing Sales channel, one can lead to Maximum profits.

Responsibilities:
• Extracted data from Legacy systems like Flat files
• Involved in preparation of Data Staging area and Staging Tables
• Designed and developed various mappings using Transformations like Aggregator, Filters, Sequence generator, Lookups, etc to build business rules.
• Implemented various Data Transformations using Slowly Changing Dimensions
• Debugged and Tested mappings.
• Optimized various Mappings, Sessions, Sources and Target Databases
• Involved in the designing and Building of Universes, Classes and objects for Sales, Marketing.
• Used Business Objects Designer to implement Universe, Linkages between Tables, create prompts and queries, and parse the Universes, applied Contexts and Alias Tables to remove cyclic dependencies.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Involved in Installation and Configuration of all Components of Business Objects
Environment: Informatica 6.1, Business Objects 5.1, BO Designer, Web Intelligence 2.x, Business Objects Supervisor, Windows NT Oracle 8i

Job seeker turned off message sending

New resumes:
java - 4090
java developer - 1680
qa - 3819
datastage - 91
informatica - 386

New jobs:
warehouse - 1367
construction - 2511
engineer - 7279

Jobs vs Resumes

ETL Informatica Developer

Similar Resumes