VISHNU THAMMI

Email: ablaai@r.postjobfree.com Current

Location: Dallas, TX

Ph: 408-***-****

Willing to Relocate: YES

Summary:

. Overall 10 years of IT experience in the Business Analysis, Design, Data

Modeling, Coding, Implementation and Testing of Applications using wide

range of Technologies including Data Warehousing and Database business

systems for Energy, Sales & Distribution and Telecom Industries.

. Data Warehousing experience using Informatica PowerCenter

8.6/8.1/7.x/6.2, Informatica PowerConnect, Informatica PowerExchange 6.5,

Data Integrator, IDQ, ETL, Teradata V2R5/V2R4, DB2 UDB 8.0/7.0, Oracle

9i/8i/8.0/7.x, Sybase 11.5, MS SQL Server 2000, MaxDB, MS Access 2000.

. Experience using Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000, MS Access

2000, PL/SQL, SQL*Plus, Stored Procedures, triggers, Materialized Views

and cursors, DB2 7.0.

. Business Intelligence experience using Business Objects XIR2/6.0/5.19

Designer, Webi, CMC, Infoview, Broadcast Agent, Supervisor, Designer,

Info View, Business Objects Universe Developer

. Experience in Relational Data Modeling and Dimensional Data Modeling,

Star Join Schema Modeling, Snowflake Modeling, FACT and Dimension Tables,

Physical and Logical Data Modeling, Erwin 4.0/3.x, Oracle Designer.

Education & Certifications:

. BE in Computer Science

. Brain Bench Certified in Data Warehousing Concepts

. 1Z0-007 Introduction to Oracle9i: SQL

. Undergone training and SAP Sales and Distribution Module

Technical Skills:

Data Warehousing& BI: Informatica PowerCenter 8.6/ 8.1/7.x/6.x,

PowerExchange 6.5, IDQ, Metadata,

Data Mining, OLAP, OLTP,

Data Integrator.

Reporting Tools : Business Objects 6.x/5.x, MS Access Reports,

Cognos7

Databases : Oracle 10g/9i/8i/7.1, MS SQL Server, Sybase

11.5, MS Access,

DB2, MaxDB, Teradata, BTEQ, Fast Load

Programming : C, C++, Visual Basic, PL/SQL, Java, Perl

Scripting UNIX Shell

Scripting

Data Modeling : Relational and Dimensional Modeling (Star &

Snowflake Schemas)

ERP and Others : SAP Sales & Distribution, FICO, Salesforce.com

Environment : Sun Solaris 2.6/2.7, Windows, Mainframes.

Professional Experience:

Dresser Corp, Dallas, TX

Informatica Lead/Admin

Nov'09 - Current

Dresser Inc is a leading equipment provider for energy companies. Dresser

initiated the data management projects AfterMarket, Global Sourcing and EDW

projects.

. Designed and developed data mart for aftermarket project.

. Analysis of the EBS source systems.

. Involved in the design of EDW.

. Designed the integration of GSI data with EDW.

. Integrated data from 11 different source systems including EBS .

. Extensively used oracle partitions to load 7 source systems.

. Used oracle bitmap indexing for improve query performance

. Created Informatica mappings involving complex logic to load fact and

dimension tables.

. Created Informatica workflows with decision and email tasks.

. Created sessions with pre and post session tasks.

. Used Informatica performance techniques to decrease the load times.

. Designed and developed the file handling from the ftp server.

. Developed mappings for purchase orders, accounts receivable,accounts

payable facts, vendor,item, item category and other dimensions

. Installed and configured informatica on windows servers for

development,test and production environments.

. Responsible for Informatica administration tasks like setting folder

access, users, and repositories.

. Responsible for contacting informatica tech support to resolve issues

of administration.

. Responsible for coordinating with offshore team for the development

and testing.

. Scheduled informatica repository backup in the development

environment.

Environment: Informatica 8.6, Oracle 11g, Oracle EBS11, Windows 2008 64

Bit, Toad, Erwin

CenturyTel, Monroe, LA

Informatica, PL/SQL Developer

Feb'09 - Aug'09

CenturyTel is a telecom service provider in rural regions recently acquired

Embarq also a telecom provider. As part of integrating systems and data

from both the companies it also integrated data warehouse data and

applications under the conversion project.

. Extensively used Designer to manipulate source definitions, create

Mappings, Mapplets.

. Extensively worked with Designer, Workflow Manager, Workflow Monitor

and Repository Manager

. Created extract mappings and load mappings

. Converted procedures into mappings using various transformations like

Source Qualifier, Expression, Sorter, Update Strategy, Filter, Lookup,

HTTP,Aggregator etc.

. Loaded data from VSAM files.

. Altered mappings to accommodate new business requirements due to

single instance impact at the source.

. Validation of Informatica mappings for source compatibility due to

version changes at the source

. Worked on Informatica metadata for checking the hard coded values

. Implemented Type1 SCD Methodology

. Used Informatica IDE for data profiling and analysis of data.

. Used Informatica IDQ for Address standardization for the Customer

Address

Information.

. Trouble shooting of long running sessions and fixing the issues.

. Created workflows using Session, Command, Email tasks.

. Monitoring of workflows and running of workflows by changing the

incremental windows for test purposes.

. Scheduled jobs using DAC.

. Created adhoc reports using MicroStrategy.

. Created sql packages, procedures, cursors

. Fine tuned the existing procedures.

. Used Bulk collect for faster loading of the tables.

. Created Unix Shell scripts to load files from ftp.

Environment: Informatica 8.5/8.6, IDE 8.6, IDQ 8.6, MicroStrategy 9, Oracle

9i, Pl/SQL Developer, UNIX, DAC, Mainframe VSAM, COBOL, Winscp.

Symantec, Mountain View, CA

Senior Applications Specialist

Dec'07 - Dec'08

Symantec is a top provider of security software. It has developed special

B2B application through Partner Program Foundation (PPF) project to make it

easier do business with its partners.

. Responsible for the requirement gathering, analysis and design and

development of the data mart.

. Involved in the complete cycle of the System Development Life Cycle

(SDLC),Design, Development, Testing and Production

. Prepared Design document and mapping document for the complete ETL

process.

. Analyzed the Data coming from source to check for data irregularities

and identify dirty data to apply suitable transformation in the

mappings in the jobs.

. Implemented the ETL process using Informatica Tools, Designer, and

Workflow Manager.

. Used various transformations like Router, Aggregator, Stored

Procedure, Lookup, XML Source Qualifier, Source Qualifier, HTTP etc.

. Cleansed data using Informatica IDQ.

. Loaded data from relational and flat file sources.

. Created flat files through ETL process for each business region of

Symantec and exported to third party vendors to be appended with new

fields

. Loaded the appended flat files into the data mart.

. Extensively used Informatica designer, workflow manager to develop the

mappings, mapplets, Reusable transformations, sessions, email tasks.

. Worked with metadata to check long running sessions.

. Created shell scripts to check long running sessions .

. Fine tuned mappings using Informatica guidelines for better

performance .

. Extensively used IDQ plans in informatica mappings for data cleaning.

. Tuned sql queries using explain plan and general sql tuning practices

. Worked with Data Quality group to identify and research data quality

issues.

. Coding & Debugging, Sorting out the time-to-time technical problems.

. Enforced consistency in data using Trillium data quality tool.

. Writing SQL, PL/SQL procedures to implement complex business logic.

. Prepared test cases for testing the complete application

. Tested the Business Object's Universe

. Worked with the Business Object's team to create reports

. Coded test scripts for verifying source and target data.

. Solution oriented and strong problem solving skills.

. Ability to meet deadlines within timeframes.

Environment: Informatica PowerCenter 8.1, Informatica IDQ, Business Objects

XI R2, Webi, Trillium 7,Oracle 10g,Teradata, BTEQ, Fast Load, Toad 9.1,

WinScp, FTP, MS Visio, AppWorkx 6, Unix

Merrill Lynch, San Jose, CA

DW Developer

Sep'07-Dec'07

First Franklin is a residential lender and a subsidiary of Merrill Lynch.

Developed proprietary underwriting solution called EasyWriter, which became

benchmark for the automated underwriting in the industry

. Production support for the EasyWriter data mart

. Responsible for monthly releases of production fixes and enhancements

. Tested Guidelines application for migration issues of database from 8i

to MaxDB.

. Involved in the modeling of the data mart using dimensional modeling

techniques.

. Modification of existing mappings to fit new business requirements

. Extensively worked on Informatica Designer, Informatica Workflow

Manager

. Write, debug and enhance various calculation scripts.

. Developed Report scripts to export data and feed to downstream Essbase

cubes.

. Written PL/SQL procedures to substitute Informatica mappings due to

problems in Informatica.

. Created SQL scripts to run on netezza.

. Created ad hoc reports on Oracle Forms 6i

. Modified Unix scripts and scripted new scripts to test the data loaded

into data mart.

. Migrated data from oracle to netezza.

. Created Scripts to test the data migrated from 8i to 10g.

. Preparation of jump-start guide for the new contractors.

Environment: Informatica 8.1,Oracle 8i/9i/10g, Informatica Data explorer

5,Oracle Forms6, Netezza Performance Server, SAP FICO, DB2 UDB, VBScript,

Teradata, Oracle Forms 6i,Toad 8.

Brocade Communications, San Jose, CA

Informatica Developer/BO

Nov'06- Aug'07

Brocade communications develops Storage Area Network (SAN) infrastructure

solutions that simplify the deployment and management of SAN's. Brocade

also provides Forward compatibility based solutions and provides and

publishes certifies interoperability solutions for enterprise SAN's.

Brocade acquired McData and as part of integrating systems it upgraded its

existing applications and integrated the applications with McData

applications.

. Interacted with user community to get the requirements and to know

business process and how it can be implemented with the current

system.

. Extensively worked with Designer, Workflow Manager, Workflow Monitor

and Repository Manager

. Extensively used Designer to manipulate source definitions, create

Mappings, Mapplets.

. Converted procedures into mappings using various transformations like

Source Qualifier, Expression, Sorter, Update Strategy, Filter, Lookup,

Aggregator etc.

. Created extract mappings and load mappings.

. Extracted data from salesforce.com by creating Salesforce mappings.

. Altered mappings to accommodate new business requirements due to

single instance impact at the source.

. Validation of Informatica mappings for source compatibility due to

version changes at the source

. Worked on Informatica metadata for checking the hard coded values

. Implemented Type1 SCD Methodology

. Created and refreshed repositories for test phase's crp1, crp2, uat

with prod repository.

. Trouble shooting of long running sessions and fixing the issues.

. Refreshed CRP1, CRP2 repositories with Production Repositories

. Created workflows using Session, Command, Email tasks.

. Monitoring of workflows and running of workflows by changing the

incremental windows for test purposes.

. Coded Oracle Stored Procedures using PL/SQL for tasks which required

some complex logic

. Cleaned data using data quality tool .

. Report Migration from Business Objects 6.5 to Web Intelligence XIR2

. Design new Universe Objects to accommodate new business requirements

. Created new joins, Pre Defined Filters in the Designer and added them

in the right contexts

. Resolved loops in universes using Aliases and Contexts.

. Created new Deski reports and Webi reports as per user requirements

. Created ad hoc and canned reports involving sections, blocks, filters,

breaks, alerts.

. Created new connections in the Designer for Development purpose.

Developed jects in the universe using some calculations on existing

columns in database tables.

. Developed objects in the universe using with calculations on existing

columns in database tables.

. Resolved various production tickets in BO and Informatica

. Scheduled reports to be delivered to the users mail boxes.

. Created groups in Central Management Console and added users to the

groups

. Prepared SDLC documents

. Written shell scripts to monitor long running sessions

Environment: Informatica PowerCenter7.1/8.1,PowerExchange 8.1, Business

Objects XI R2, Business Objects Xcelsius, Webi, BPM, Salesforce.com,Oracle

10g,PL/SQL, Oracle Apps 11i, Sybase 11.5, Trillium, MS Access, Windows XP,

Sun Solaris 2.8

Avery Dennison, Brea, CA

Jul'06-Sep'06

Data Warehouse Production Support

Avery Dennison is office products manufacturer and listed as a Fortune 500

company. Avery has number of data marts to cater to different business

needs and has numerous reports based on these data marts.

. Altered and updated existing data marts with new columns from main

feed

. Modified Universes to reflect new business changes

. Modified the existing BO dashboard reports to reflect the new data

mart changes.

. Worked on various other production issues and requests like populating

missing data

. Rescheduled various Unix jobs according new business requirements due

to changes from customers data feed

. Modified the existing sql scripts to accommodate new production

requests

. Worked on POS, OBS, Service Metrics Data marts

. Redesigned and created new Informatica mappings to fit new business

demands.

. Helped project manager on identifying Master Data and streamlining

the while integrating data marts

Environment: Informatica 7.1, SQL Server DTS, SQL Tools, Business Objects

XI R2, Cognos 7, Oracle 9.2, Hyperion Planning 4.0.5, Hyperion Essbase

7.1.2,Hyperion Brio, DB2, Solaris 5.8,Windows XP

Cingular Wireless, Alpharetta, GA

Aug'05- May 06

ETL Developer/ Business Analyst.

Cingular is one of the largest wireless providers in North America with

customer base of nearly 50 million. Cingular implemented the data

warehousing project to make the reporting process easier and to have data

that is accurate and clean.

Responsibilities:

. Designed the logical model using star schema with all related

entities, attributes and relationship with each entities based on the

rules provided by the business manager using Erwin 4.0, along with

the project manger.

. Involved in requirement gathering, analysis and study of existing

systems.

. Extensively worked with Repository Manager, Designer, Workflow

Manager and Workflow Monitor

. Extensively used Informatica Designer to create and manipulate source and

target

definitions, mappings, Mapplets, transformations, re-usable

transformations,

etc.

. Extracted data from Oracle, SQL Server and Flat Files and loaded them

into Oracle

and also data was extracted from Peoplesoft system using Power

Connect for

Peoplesoft.

. Used PL/SQL procedures to perform various tasks.

. Developed transformation logic and designed various Complex Mappings

and Mapplets using Designer.

. Used various transformations like source qualifier, joiner, update

strategy, lookup, aggregator etc.

. Used workflow monitor to monitor the jobs, reviewed error logs that were

generated

for each session.

. Implemented SCD methodology including Type 1, Type 2 changes to keep

track of

historical data.

. Tuned the mappings for optimal performance using the Informatica

guidelines.

. Documented the number of source / target rows and analyzed the

rejected rows and worked on re-loading the rejected rows

. Documented all the mapping details using Company's document templates.

. Extensive Knowledge of Business Objects Reporter

. Coordinated between the developments and testing teams for robust and

timely

development of fully integrated application.

Environment: Informatica PowerCenter 7.1, Informatica Power Connect,

Business Objects 6.5, Oracle 8i, SQL Plus, PL/SQL, SQL, MS Visio 2002, Toad

7.0, Java Script, Teradata, BTEQ, FastLoad, Unix, Windows XP

OGE Energy Corp., OKC, Oklahoma

Oct'04 - Aug'05

Informatica Developer

OGE Energy is the parent company of Oklahoma Gas and Electric Company,

which has customer base of over one million. Due to increased competition

and deregulation the company wanted to better understand the consumption

trends. It integrated customer, billing, consumption, sales, service, and

product data for better reporting.

Responsibilities:

. Worked extensively with Source Analyzer, Warehouse and Mapping Designers.

. Involved in Database design, Data Modeling and application design.

. Analyzed the source data, deciding on appropriate extraction,

transformation and

loading strategy.

. Integrated data from multiple sources systems

. Extensively worked on all the transformations like Filter, Aggregator,

Expression,

Router, Lookup, Update Strategy, Sequence generator, Rank.

. Implemented SCD methodology including Type 1, Type 2 and Type 3 changes

to

keep track of historical data.

. Partitioned the sessions to improve the performance.

. Improved the performance of the Sources, Targets, Sessions by identifying

and

eliminating the Bottlenecks

. Created UNIX shell scripting and automation of ETL processes using

Crontab.

. Used Sorter which is introduced in PowerCenter 6.2 extensively with

Aggregator

which helped the performance pickup.

. Used the command line program Pmcmd and Pmrep to communicate with the

Informatica server and the Repository server.

. Implemented Explain Plan and TKPROF utilities.

. Documented Informatica mappings, design and validation rules.

. Initially Created Mappings using Data Integrator.

. Designed and developed universes for reporting generation from warehouse

databases using Business Objects Designer

. Created Contexts and Aliases for resolving Loops in the Universes.

. Developed reports with business objects functionalities like slice and

dice, drill down.

. Created user prompts, conditions and filters for various reports to

specify the

reporting parameters as per the business rules and the requirements

of the end

users.

. Involved in creating complex reports and publishing on WebI.

. Created Master Detail and Cross Tab reports to view the data in an

analyzed way.

. Used Supervisor module in maintaining, creating users and to restrict

resources and

report bursting

Environment: Informatica PowerCenter 6.1, Informatica Power

Connect, Informatica

PowerExchange 6.5, Business Objects 5.1, Data Integrator 6,

Oracle 8i, MS SQL Server

2000,COBOL, MainFrame DB2, SQL Plus, PL/SQL, SQL, MS Visio

2002, VB Script, Perl, Toad

7.0,WebSphere, Solaris 2.6, Windows 2000 Professional.

Schering-Plough, Kenilworth, NJ

Nov'03- Aug'04

ETL/Informatica Developer

Schering-Plough is a global pharmaceutical company providing a steady flow

of innovative medicines that improve health and well being of people around

the world. The project is focused on gathering Customers, Products and

Orders Data and Loading it into Warehouse for analysis.

Responsibilities:

. Extensively worked with Informatica to load data from flat files,

Oracle, MS SQL

server to target database

. Modeled the Data Warehousing Data Marts using Star Join Schema

Worked on Informatica tool Source Analyzer, Data warehousing

designer,

Mapping Designer & Mapplets, and Transformations.

. Extensively Used IMS Data component Xponent to get and send the

encrypted data

over the network.

. Extensively worked on FDA approved Clinical Trials data

. Extensively used Trusted Third Party (TTP) system to preserve

doctor's

confidentiality.

. Developed various mapping by using reusable transformations.

. Most of the transformations were used like Source Qualifier,

Aggregator, Filter,

Expression, and Unconnected and connected Lookups, Update Strategy.

. Improved the mapping performance using sql overrides

. Used PL/SQL to write stored procedures to increase the performance.

. Created Mapplets and used them in different mappings.

. Used various transformations for data Manipulation.

. Developed various sessions, batches containing parameters files,

indicator files and

multiple sources files

. Optimized query performance, session performance

. Used Unix Shell scripts using K-shell to automate the process of

running

jobs/batches.

. Generated simple list reports, Grouped list, cross tab reports

using BO.

. Documented the purpose of Data marts (including transformations,

mapplets)

mappings, sessions, batches) so as to facilitate the personnel to

understand the

process and incorporate the changes as when necessary

. Extensively used Oracle Loader and PL/SQL for ETL.

. Optimized Query Performance, Session Performance and Reliability.

. Extensively involved in creating procedures, functions and triggers

using PL/SQL.

. Designed and developed Target Warehouse Entity for Oracle using

Informatica Power

Center.

. Loaded data from VSAM files

. Reviewed and documented existing SQL*Loader ETL scripts.

Environment: Informatica PowerCenter 5.1, PL/SQL, Oracle 8i, Teradata,

BTEQ, Fastload, Main Erwin 3.x,Mainframe VSAM,COBOL Windows NT 4.0,

Windows 2000, Sun Solaris 2.6.

Nextel Communications, VA

Dec' 02 - Oct' 03

Oracle ETL Developer

Nextel Communications is fortune 200 company based in Reston, Va., is a

leading provider of fully integrated wireless communications services and

has built the largest guaranteed all-digital wireless network in the

country covering thousands of communities across the United States.

Responsibilities:

. Developed ETL Mappings with Business Critical validations.

. Worked with the senior DBA in creating test and development environments

for ETL

development.

. Involved in the ER Modeling of the application, which involved more than

120

tables.

. Developed PL/SQL Procedures and fine tuned SQL queries, for faster data

retrieval.

. Loaded the data into test and development environments.

. Created test cases to test the data in target the data warehouse with the

source

systems postproduction maintenance and support

Environment: Informatica Power Mart 5.1, PL/SQL, IIS 5.0, 3MS Access 2000,

MS SQL Server 2000, Oracle 8i,DB2 7, Erwin 3.x, Windows NT 4.0, Windows

2000, HP-UX.

Quatalys, Chennai, India Aug'00- Sep'02

Software Engineer

Quatalys is a medium sized company providing solutions in client-server

architecture. Apex Data Systems (USA) was one of its major clients.

Responsibilities:

. Developed the Screens for the applications using Visual Basic

. Responsible for the coding of the screens in visual basic

. Involved in the ER Modeling of the application, which involved more than

120

tables.

. Developed PL/SQL Procedures and fine tuned SQL queries, for faster data

retrieval.

. Performed the unit level testing and also created test plans.

. Undergone Training in BI and Data Warehousing Tools and Technologies

like

Business Objects 5.0, Informatica PowerCenter 1.7and Power Mart 4.7.

Environment: Windows 98, NT, Unix, Oracle 7.1, Visual Basic

Contact this candidate