Manager Data
Resume:
JANAKI R SAMANTHULA
*******@*****.***
Summary
* Over 4+ Years Experience in IT Industry with 4 Years of expertise
in BI, DataWarehousing, Informatica(ETL).
* Worked on all phases of data warehouse development lifecycle, from
gathering
Requirements, testing, implementation, and support.
* Extensively worked on Informatica PowerCenter Components - Source
Analyzer, Warehousing Designer, Transformation Developer, Mapplet
Designer, Mapping Designer, Workflow Manager and Workflow Monitor
* Experience in working with a variety of data sources/targets like
Oracle, SQL Server, DB2 and Flat files, MS Access, VSAM
* Created mappings using various transformations like Lookup,
Aggregator, Joiner, Expression and Normalizer Transformation and
configured them to handle data according to a business purpose
* Extensive experience in setting up Procedures to Extract, Transform
and Load (ETL) data from Operational and Legacy Systems to the Data
Warehouse by Using Informatica
* Scheduled daily loads from various data sources.
* Experience in testing and fixing the bugs in mappings
* Experience in Debugging and Performance Tuning of targets, sources,
mappings and sessions
* Developed Slowly Changing Dimension mappings of type I, II and III
* Worked on database utilities like Toad
* Proficient in SQL, PL/SQL, T-SQL, Procedures, Functions, Triggers
and Packages Views/ Materialized Views in Oracle 10g and SQL Server
* Good team player with leadership abilities and excellent
communication skills
* Production support activities including emergency fixes
* Produced appropriate project documentation
SKILLS
Data Warehousing Informatica Power Center 8.6.0/7.1
Power
Exchange, Informatica IDQ/DQA,
SSIS, OLAP, OLTP, Business Objects XI
Modeling Erwin 4.x, Dimensional Data Modeling, Star
Schema
Modeling, Snow-Flake
Modeling,
Physical and Logical Modeling
Databases Oracle 10g/9i, MS SQL Server
2005, DB2, MS Access
ERP SAP-ABAP, BW
Languages SQL, PL/SQL, T-SLQ,
Java, C++, XML, UNIX Shell Scripting, Batch
scripting
Operating Systems Win NT/XP/2000, UNIX (Sun Solaris
2.7, HP-UX 11.x)
Experience
ALSTOM POWER, Richmond VA June 2008 -
Present
Sr ETL Developer
ALSTOM Power is the world leader in integrated power plants for the
production of electricity and air quality control systems. Alstom has
solutions for all energy sources (coal, gas, nuclear, fuel-oil, hydropower,
wind) and is a leader in innovative technologies for the protection of the
environment
Customer User Data Base (CUDB)
This project was developed to bring the Alstom global employee
information from different countries and from different source
applications like lotus notes, active directory, HR database, ERP, and
flat files then relate all the data and load in to DW tables. This data is
using by many business users and also different Alstom applications
Parts Data Warehouse (PDW)
Worked on enhancements for the existing ETL process. These ETLs brings
data from Mainframe using Informatica Power Exchange, then transforms the
data based on the business rules and loads the data to Parts Data
Warehouse. This data is used for reporting.
Enterprise Data Warehouse (EDW)
Financial data from ERP is processed in to EDW using different ETL
logics
* Communicated with users, managers and business analysts along with
team leader for understanding the business and database flow
* Reviewed the business logic and documented the ETL development process
* Designed data loading sequence and populated data into Staging, PDW
(Parts Data Warehouse) with business rules as per Data Warehousing
Methodologies
* Used Informatica Power Center 8.6 as ETL for extracting data from Flat
Files, Oracle and loads the data into the target Oracle 10g database,
and Flat Files
* Used Informatica Power Exchange 8.6 for extracting Mainframe
* Developed Mappings and Mapplets
* Implemented critical business logic related to customer data from
different source systems
* Used various transformations like: Source Qualifier, Sequence
Generator, Expression, Filters, Routers, Connected & Unconnected
Lookups Aggregate, Joiner, Sorter, Stored Procedure and etc
* Developed Informatica mappings and tuned the existing mappings for
better performance
* Used workflow manager to create tasks and workflows
* Worked on mapping variables, mapping parameters, workflow variables
and session parameters
* Used debugger to test mapping and fixed mapping bugs
* Used stored procedures in mappings to do complex database level
operations.
* Used TOAD to work with oracle database
* Used Batch scripts to execute the tasks
* Created FTP scripts to transfer data from server to server
* Provided the support for all the issues, which comes up in
Production
Environment: Informatica Power Center 8.6.0 (ETL), Power Exchange 8.6,
Oracle 10g, SSIS, SQL Server, TOAD, DB2, Windows NT/2000, Flat files,
SAP R/3
Circuit City Stores, Richmond VA October 2006 - January 2008
ETL Consultant
Promotion System Transformation (PST)
Circuit city is one of the leading retail merchandise enterpriser. Circuit
city promotions are categorized as Coupons, Rebates, Finance Promotion, All
on sale and Packages.
The old way of entering the promotions on AS/400 screens was replaced with
new application called Promotion Manager. Promotion manager is integrated
tool from Connect3, using this tool user can key in different promotional
offers at one place. Informatica was used to process the data entered in
Promotion Manager and load data to feeder files on AS/400.
* Analyzed business requirements and worked closely with various
application teams and business teams to develop ETL procedures that
are consistent across all applications and systems.
* Designed source to target mapping documents and loading strategies as
a part of requirements gathering
* Designed source definition, target definition and transformation for
building mappings using the Informatica designer tools.
* Created unit test plans, test cases and reports on various bugs while
testing the Informatica processes.
* Performed performance tuning of sources, targets, transformations,
mappings, and sessions.
* Successfully supported production System as post production activity
* Reviewed the business logic and documented the ETL development
process.
* Developed shell scripts to automatically email the reports to users
* Created jill files and autosys jobs to automate informatica workflows.
* Implemented best practices suggested by informatica to simplify
deployment process.
* Extensively used parameters,variables and parameter files
* Used PVCs as version controlling tool
* Implemented error handling mechanisms in informatica mapping.
* Extensively used Test Director to document test cases and test
results.
* Used shortcuts to reuse objects without creating multiple objects in
the repository and inherit changes made to the source automatically.
* Created test scripts and executed in the Test Director.
* Worked with pmcmd to interact with Informatica Server from command
mode and execute the shells scripts.
* Wrote documentation to describe program development, logic, coding,
testing, changes and corrections
Environment: Informatica Power Center 7.1.2 (ETL), SQL Server, DB2
Windows NT/2000, UNIX, AS400
Data metrics Software Solutions, Edison NJ July 2006 -
September 2006
ETL Developer
Trained in Informatica
Designed and developed different ETL Mapping
Developed "Slowly Changing Dimension Type 2" and Change Data Capture
Created different shell scripts to move the flat files
Contact this candidate