SUMMARY

• Over 7+ years of IT experience with expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools with Oracle, MS SQL server and Teradata databases on windows and UNIX platforms.
• Expert level experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter/PowerMart 6.x/7.x/8/9.0.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets/Workflow Manager). Knowledge of Informatica tools Power Analyser, Power Connect, Data Mart, OLAP and OLTP.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions). Complete knowledge of data ware house
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Experience in Performance Tuning for targets, mappings and sessions.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data definition, population and manipulation. Expertise in logical and physical database design and Data Modeling using data modeling tools like Erwin.
• Experienced in using Business Objects 5.x/6.x to build user defined queries and reports to enable drill-down and slice and dice analysis on multiple databases. Thorough knowledge of Software Development Life Cycle including Planning, Analysis, Design, Implementation, and Maintenance.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, TeraData and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL-LOADER. Highly proficient in writing, testing triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Experience in Task Automation using UNIX Shell Scripts, Job scheduling and Communicating with Server using pmcmd.
• Domain Data warehousing experience including Investment banking, Credit card, and Pharmaceutical. Proven ability to implement technology based solutions for business problems.
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0.1/8.x/7.x/6.x/5.1(Source Analyzer, Data Warehouse designer, Mapping Designer, Mapplet Transformations, Workflow Manager, Workflow Monitor, Worklets), Data Stage, SAP Informatica Power Connector.

Analysis/Reporting Tools: Business Objects 5.2.1/6.1b/XIR2, Micro strategy 7.2.4. Web Intelligence 2.6/6.x and Informatica Power Analyzer.

Databases: Oracle 9i/8i, APEX,MS SQL Server 7.0/2000, DB2, Teradata11, MS Access, Excel.

DB Tools: SQL*Plus, SQL* Loader, TOAD.

Environment: s: Sun Solaris, UNIX, HP-UX, IBM-AIX, WINDOWS XP/NT/ 2000/98/95.

Languages: C, C++, SQL, PL/SQL, T-SQL, UNIX, Shell Scripting, Visual basic,, XML

Data Modeling: Visio.

Scheduling Tool: Tidal

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

ETL/ Informatica developer

Responsibilities:

• Requirement gathering, analysis and designing technical specifications for the data migration according to the business requirement.
• Developed logical and physical dimensional data models using ERWIN.
• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation
• Developed test cases and test plans to complete the unit testing. Support System testing.
• Planned and coordinated testing across multiple teams, tracked and reported status, created testing cycle plan, scenarios etc.
• Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Responsible for performance tuning in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Extensively worked with SQL queries and T-SQL statements. Created Cursors, functions, stored procedures, packages, Triggers, views, materialized views using PL/SQL.
• Extensively worked with PL/SQL, performance tuning of Oracle.
• Used ANALYZE, dbms stats, explain plan, sql trace, sql hints and Tkprof to tune sql queries.
• Extensively used Oracle partitioning (range/hash/list), indexes (bitmap, B-tree, reverse key, etc) and various join types (hash joins, sort merge, nested iteration join) to improve the performance.
• Used Oracle Data Integrator (ODI) for web-services integration
• Used Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Hands on experience with Informatica Metadata Manager.
• Design/developed and managed PowerCenter upgrades from v8.x to v9.1 and migration of ETL code from Informatica v8.x to v9.1.
• Extensively worked with incremental loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger.
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows.
• Developed user defined functions (UDF) to extract data from flat files.
• Developed and modified UNIX shell scripts to meet the requirements after the system modifications andwas also involved in monitoring and maintenance of the batch jobs.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse
• Involved in Tidal scheduling sessions coming up with various test cases

Environment: Informatica Power Center 8.5/9.1, Teradata11, Oracle 11g, Erwin, PL/SQL, Auto-Sys Scheduler.

Confidential, Plano, TX

ETL/Informatica Developer

Responsibilities:

• Involved in Systems Study/ Analysis and understand the business needs and implement the same into a functional database design.
• Created Source definitions from Flat Files, Oracle 9i, Imported Target definitions and created Reusable Transformations in Informatica Powecenter Designer 8.6.1
• Used Informatica Power Connect to extract information from the Oracle ERP systems.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Used Shell Scripting to get data from source for the transformation to cleanse data as per business rule
• Developed Transformation Logic in Power center Designer 8.6.1 to cleanse the source data of inconsistencies before loading the data into the staging area, which is the source for stage loading.
• Worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Used PMCMD commands for automating Batches and Sessions.
• Identified and fixed bottlenecks and tuned the Informatica mappings for better performance.
• Created Test cases for Unit test, Used TOAD 9.7 to validate the data with SQL Quarry.
• Scheduling of Informatica workflows using Tidal Scheduler

Environment: Informatica Power Center 8.6.1 (Power center, Designer, Mapplets, Workflow manager, Workflow monitor), DB2 Mainframes, Oracle 9i, TOAD 9.7, ERWIN, SQL Navigator, SQL, PL/SQL

Confidential, Seattle, WA

ETL Developer

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL Informatica process
• Interacted with the technical staff to develop Entity Relationship/data models, requirements document and Informatica 8.1.1 specifications.
• Create Mappings in Informatica Power center Designer 8.1.1 to cleanse the data as per business logic.
• Extensively used Transformations such as Lookup, Expression, Joiner, Router, Union, Filter, Aggregator, Filter, Sequence Genarator, Normalize, Source Qualifier.
• Worked in Oracle SQL, PL/SQL, Query Tuning, created DDL scripts, created database objects like Tables, Indexes, Synonyms, and Sequences etc.,
• Used Pipeline partitioning to enhance session performance.
• Performed versioning i.e. Checking in and checking out of objects to commit changes to the repository.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Actively took part in creating Performance summary and Reporting Hierarchy tables for customer reports.
• Created Test cases for Unit test, Used TOAD 11.0 to validate the data with SQL PL/SQL Quarry.

Environment: Informatica Power Center 8.1.1, DB2, Oracle 9i, PL/SQL, SQL Developer 2.1.1, TOAD 11.0, Windows 2003, UNIX.

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Responsible for documentation, version control of schema and version release.
• Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Interpreted logical and physical data model for business users to determine common data definitions and establish referential integrity of the system.
• Participated in the analysis of development environment of Extraction process and development architecture of ETL process.
• Coordinated with customer in finding the sources and targets for data conversion.
• Involved in the preparation of documentation for ETL standards, Procedures and Naming conventions as per ETL standards.
• Created new Informatica Mappings with Source qualifier, Union, Aggregator, Connected & unconnected lookups, Filter, Update Strategy, Rank, Stored Procedure, Expression and Sequence Generator transformations while transforming the Sales/Marketing data.
• Created Reusable transformations and Mapplets for use in Multiple Mappings.
• Created multiple universes and resolved loops by creating table aliases and contexts.
• Used session partitions, Dynamic cache memory and Index caches for improving performance of Informatica server.
• Extracted data from SQL server Source Systems and loaded into Oracle Target tables.
• Involved in writing shell scripts for automating pre-session, post-session processes and batch execution at required frequency using power center server manager.
• Involved in the loading and Scheduling of jobs to be run in the Batch process.
• Optimized and performed Tuning in mappings to achieve higher response times.
• Involved in the migration of existing ETL process to Informatica Power center.
• Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data loading processes.
• Organized data in reports using Filters, sorting, ranking data with alerts.
• Created reports using business object functionality like queries, slice and dice, drill down, functions and formulas.

Environment: Informatica PowerCenter 6.1, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.

Confidential

ETL Developer

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL). .
• Created new mappings and updating old mappings according to changes in Business logic.
• Used ETL (Informatica) to load data from sources like Oracle database and Flat Files.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Used Debugger to troubleshoot the mappings
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier
• Created various Mapplets in designer using Informatica Power Center Mapplet Designer.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in Unit and System testing of developed mapping.
• Optimizing Query Performance, Session Performance.
• Defined Target Load Order Plan for loading data into Target Tables.
• Involved in creating desktop intelligence and web intelligence reports.

Environment: Informatica Power Center 6.2, Windows 2003, PL/SQL, Excel, SQL Server 2000, Erwin, Business Objects 6.5.