Siva Pennabadi
abnue6@r.postjobfree.com
Professional Summary
* ***** ** ********** ** Informatica Power Mart & Power Center ETL tools.
2+ years of experience working in Telecommunications
Expertise in using Power Exchange to create data maps and metadata reports using Power
Analyzer.
Valuable experience in Data Warehouse applications, directly responsible for the Extraction,
Transformation & Loading of data from multiple sources into Data Warehouse using
various versions of Informatica.
Extensively worked on Production support for Data ware house and Data Mart jobs.
Experience in identifying & analyzing the source/feeder systems, identifying GAPS and
providing appropriate solutions.
Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and
Dimensions Tables, Physical and Logical Data Modeling using Erwin.
Requirement analysis of the system specifications and converting them into data warehouse
architectural design.
Used CA7 for automation of workflows and Sub Version for versioning.
Used SQL tools like TOAD, WIN SQL, Rapid SQL, Clear Quest to run SQL queries and
validate the data.
Extensively used korn shell Scripts to FTP flat files that have dynamically changing file
names,to manipulate data and data cleansing.
Experience in creating Indexes and partitioning tables for better performance.
Identified and tracked the slowly changing dimensions, heterogeneous Sources and
determined the hierarchies in dimensions.
Used Data Profile to analyze source systems and create reference data.
Experience in performance tuning of sources, mappings, targets and sessions
Skill Sets
Informatica PowerCenter 8.1/ 7.1.4/6.2, Power Mart 5.0,Power Connect, Power
Data Warehousing
Exchange
Oracle 10G/9i,sybase, DB2, SQL Server 2005
Databases
Star Schema, Snowflake Schema, ERWin 4.x, RUP
Data Modeling
Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), Scheduler (iBots), BO
BI Tools
6.0/Xi, Cognos 6.x (Impromptu, Power Play Transformer)
SQL, PL/SQL, C, C++, Visual Basic, UNIX (korn shell), PERL
Programming
Windows 98/NT/2000/2003/XP, Sun Solaris, HP-UX11/10/9, IBM-AIX4.3/4.0/3.1
Environment
Clear Quest, Win Runner 7.0, Load Runner 7.0,Crystal reports XI, Quest Central
Tools
4.5,Rapid SQL, Win SQL, XML, Ultra Edit, Embarcadero Rapid SQL, First logic,
Trillium,VSS 6.0,Robo FTP
Dean Health Plan, Madison, WI Aug 08 to Till Date
Sr Data Warehouse Developer/lead
Dean Health Plan (operates as DeanCare) was founded in 1983, and serves Wisconsin residents
in 22 counties across the state. DeanCare offers PPO, HMO, and POS health insurance plans as
well as public health insurance programs for the companies’ clients throughout south central
Wisconsin.
The Dean Health Plan provider network includes about more than 2,100 providers (including
physicians, hospitals, clinics etc.). The Dean Health Plan also provides a 24-hour nurse line and
offer a variety of other value added programs and resources to help its members stay healthy.
Responsibilities:
Extensively invoIved in Data Modeling for the Metavance Data ware house Design
using Erwin.
Facilitating information requirements clarification session with clients.
Documenting data definitions, valid values, data availability ruels, calculations, summer
izations and derivations
Extensively worked in Converting data from Mainframes to MetaVance application.
Created STT and Design Documents for Offshore Development.
Designed the mappings, Workflows and automated those using Autosys.
Used Quality Center for Defect Tracking and uploading test cases.
Executed workflows using Autosys console and Pmcmd for Shake out testing.
Developed Korn shell scripts to zip,rename and to FTP flat files to the client
location.
Created UNIX (korn shell) scripts to rename Flat Files, archiving and to delete files
older than 30 days.
Used Quality Center for Defect Tracking and uploading test cases.
Involved in Unit testing of Mappings and Workflows.
Involved in extensive Performance Tuning by determining bottlenecks at various points
like targets, sources, mappings and sessions.
Used Micro Soft Share Point to create action items for the Business Users.
Used Visual Source Safe for documenting the Mappping specifications,IAD's and
design documents.
Environment:
Informatica Power Center 8.1.1, Sybase, Oracle 9i, Cognos, Rapid SQL, Flat Files, AIX
UNIX(korn shell),
ERwin 4.5, Quality Center, VSS 6.0, Share Point, Robo FTP.
FedEx SmartPost Milwaukee, WI Aug 07 – July 08
Sr Informatica Developer/ Lead
FedEx Ground specializes in cost-effective, small-package shipping, offering dependable
business-to-business delivery or convenient residential service through FedEx Home Delivery
and FedEx SmartPost.
FedEx SmartPost offers you an efficient, value-oriented, and timely way to ship high volumes of
low-weight packages to residential customers. Pick up, sort, line haul, track and deliver your
packages to the post offices closest to the customers. The USPS makes the final delivery to the
residence. As a result, the customer reduces transit time, minimize handling, and maximize postal
discounts. With over 29 ground hubs and over 500/pickup and delivery terminals and 20
distribution centers it services throughout the United States, Canada and Puerto Rico.
Responsibilities:
Involved in gathering the requirements and created the solution proposal document for
EPDI (Electronic Package Data Interchange)
Used ERWin to Design the Ware House tables.
Designed the mappings, Workflows and Automated them using Informatica Scheduler.
Created UNIX (korn shell) scripts to FTP the Extracted Flat Files for Auditing.
Created UNIX (korn shell) scripts to rename Flat Files, archiving and to delete files
older than 30 days.
Imported Audited Files and Loaded into Warehouse.
Implemented Checkout mappings to check the count of Rows sent and the Rows Loaded
into the Warehouse.
Created reports using Business Objects functionality like Combined Queries, Slice and
Dice, Drill Down, Functions, Cross Tab, Master Detail and Formulae etc. and exported to
the repository.
Extensively worked on Production support for Data ware house and Data Mart jobs.
Extensively worked on tuning informatica mappings to increase performance.
Created, launched & scheduled tasks/sessions. Configured email notification. Setting up
tasks to schedule the loads at required frequency using Power Center.
Extensively Worked on Performance Tuning of SQL and Mappings.
Used Stored Procedures to create and remove indexes before and after loading tables.
Environment:
Informatica Power Center 8.1, Sybase, SQL Server 2000, Oracle 10g, Rapid SQL, Flat Files,
AIX UNIX (korn shell).
American Family Insurance June 05 to July 07
Senior ETL Developer
Sales Initiation Suite (SIS)
SIS is an integrated system of software programs that allows you to create, save and revise
customer quotes and applications. This program will detail objectives and direction for the
migration of ADS to a web environment including the migration of quoting and applications to a
web environment. Creating consistent work processes for the field is the backbone of this
program and Field Compass will serve as the foundation for deliverables.
Responsibilities:
Involved in the gathering the requirements and created the solution proposal document.
Involved in extracting XML data from CLOB that is in oracle and parsing the XML data
into ware house tables.
Involved in Dimensional Modeling of the data warehouse to design the business process.
Worked with FTP to transfer the ADS Extract files to Client Server.
Developed korn shell scripts to change File name extension with the date of run.
Designed the mapping’s to load ADS extract file
Involved in creating CA7 to automate the jobs to run on monthly basis.
Health EDW
For historical needs, the MDR data is brought into the EDW occasionally and indexed for a
certain time period. This will enable end users to query based on time periods for costs and
comparisons as needed. The MDR database is updated with new data
At least twice a year and for the purposes of the warehouse, data should be updated when the
MDR database is scheduled to be updated for consistency and parallelism with other data.
Involved in creating staging mappings to read MDR data into Health Staging tables and
automating them to run everyday.
Involved in creating the Health EDW Mapping’s for Diagnosis Codes and NexSys Paid
Denied all bills.
Extensively worked with Power Exchange to read Main Frame data into the Staging
tables.
Education Project:
Project is basically to keep track of training classes taken by the AMFAM employees and agents.
Used to get the education information from Oracle, Employee information from people soft and
agent information from x500 mainframe files. In the data warehouse level ETL process used to
integrate all of the 3 systems and data mart level data is populated into star schema tables for
reporting purpose. In this project I worked from the solution proposal to till post production
testing.
Responsibilities:-
Involved in the gathering the requirements and created the solution proposal document.
Involved in the discussions with Datamodelrs about the data warehouse and data mart
models.
Developed ETL process mappings for data warehouse.
Wrote SQL/PL/SQL to read data from the Oracle source and created mappings to load
into the Target DB2 tables.
Developed the star schema dimension and fact tables for data mart.
Environment:
Informatica Power Center 7.1.4, DB2, Oracle 9i, Business Objects 6.0, Quest Central, WinSQL
X500 Mainframe, Business Objects 6.5, Flat Files, AIX UNIX (Korn shell)
WEATRUST, Madison, WI July 02 – May 05
ETL Developer
WEA Trust is charged with designing and maintaining benefit plans that are responsive to the
needs of school employees, that are compatible with the collective bargaining philosophy and
dynamics, and that are faithful to the fiduciary relationship between the union and its members.
The Trust is a not-for-profit corporation that is dedicated to helping public school employee’s
finds ways to address the health care cost crisis while providing them comprehensive health care
at a reasonable price.
The Wisconsin Education Association Council (WEAC) created the WEA Trust in 1970 to
provide insurance and benefit plans for public school employees and their families. The first
offerings were health, life, and disability plans.
Responsibilities:
Involved in Dimensional Modeling of the data warehouse to design the business process.
Worked on Dimensional modeling to Design and develop STAR Schemas, used ER-
win 4.5, identifying Fact and Dimension Tables.
Identified and tracked the slowly changing dimensions, heterogeneous Sources and
determined the hierarchies in dimensions
Worked closely with business analysts to understand and document business needs for
decision support data.
Involved in developing & testing of ETL, Informatica mappings, workflows, sessions
using Informatica.
Extensively utilized Informatica Power Center to load data from oracle and Fixed-
Width, Delimited Flat files into DB2.
Imported various heterogeneous and homogenous sources using Informatica 7.x
source analyzer.
Involved in working with ODS (Operational Data Store) to extract data from the Data
warehouse.
Involved in designing and building of Universe, Classes and Objects.
Created Joins, Cardinalities, Aliases and Contexts for resolving Loops and checked the
Integrity of the Universe.
Involved in writing procedures, functions in PL/SQL.
Created, launched & scheduled tasks/sessions. Configured email notification. Setting up
tasks to schedule the loads at required frequency using Power Center.
Monitored Sessions using the workflow monitor, which were scheduled, running,
completed or failed.
Involved in Unit testing of Mappings and Workflows.
Involved in extensive Performance Tuning by determining bottlenecks at various points
like targets, sources, mappings and sessions.
Environment:
Informatica Power Center 6.2/7.1.2, DB2, Mocha Soft, Crystal Reports 9.0, Aqua Data 4.5,
IBM iSeries Client Access, Business Objects 6.5,Flat Files.
Pri-Tel Naperville, IL Feb 00 - June 02
Electrical Engineer
PriTel, Inc. designs, manufactures, and markets fiber lasers, amplifiers, and related equipment for
1550-nm and 1060-nm band applications. Specializing in RF and optical technologies, scientists
at PriTel design and build state-of-the-art actively and passively mode-locked fiberoptic lasers
that meet the most demanding technical specifications.
The company works closely with telecommunications clients worldwide to custom-design short-
pulse fiberoptic lasers that operate at repetition rates up to 40 Gbps. PriTel's multiplexing
systems enable ultra-high data rates exceeding 320 Gbps
Responsibilities:
Expertise in Designing Optical Fiber Amplifier’s and Optical Clock Multipliers as per
the customer requirements.
Extensively worked with Er Doped and Tr Doped optical fibers.
Designed necessary circuits for the amplifiers and assembling them.
Extensively tested Optical Amplifiers for high performance like Saturated output power,
Signal gain, Optical Noise Figure, Spectral Gain Flatness etc.
EDUCATION
B.E (Electronics & Communications) India.
CERTIFICATIONS:
Informatica Certified Developer V8
Microsoft Certified Developer VB6