SUMMARY

• 7 Years of experience in Data Warehousing based application developments under Unix and Windows Operating Systems
• Expertise in Business Intelligence Data warehousing tools including Informatica (ETL Process)
• Have worked in developing ETLs for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in Using Repository Manager, Designer Workflow Manager, and Admin Console Tools in Informatica Power Center
• Experience in using Power Exchange for SAP, SFDC, and Web Services
• Involved in the data analysis for source and target systems. Experienced in designing and developing a Multi - dimensional STAR SCHEMA with fact and dimension tables.
• Good experience in Creating Repositories, Folders, Groups, and Users assigning privileges to users.
• Expertise in Developing Mappings and Mapplets /Transformation between Source and Target using Designer.
• Experience in preparing and running Sessions/tasks, Workflows, and Batch processes in Informatica Server.
• Involved in various stages of software development life cycle (SDLC).
• Working experiences using SQL, PL/SQL, SQL* Loader, SQL* Plus, Import/Export utilities.
• Experienced in Tuning SQL queries using oracle hints and indexing techniques.
• Expertise in creating oracle tables/views/synonyms in the development database.
• Hands of Experience in Creating Oracle PL/SQL stored procedures, functions, materialized views and packages.
• Good exposure to development, testing, debugging, implementation, documentation, and user training and production support.
• Involved in the analysis, design, and development of applications using ORACLE, SQL Server, and Access as backend and VB5.0/6.0, Developer 2000 as a front end. Proficient in programming using SQL and PL/SQL.
• Solid Understanding of OLAP Solutions, Developed OLAP applications using Business Objects tool suite, Cognos tool suite and extract data from the enterprise Data warehouse support the analytical and reporting for all corporate business units.
• Articulate with excellent communication skills with good interpersonal skills. Ability to work under tight schedules Sound technical background in computer science.

TECHNICAL SKILLS

ETL TOOLS: Informatica Power Center 8.6.1/8.5/8.1/7 x/6x

DATA MODELING TOOL: Erwin

OLAP Tools: Business Objects suite, Cognos suite, Brio.

REPORTING TOOLS: Business objects 3.0/4.x/5.x, Web Intelligence 2.0/2.6 Business Objects SDK, Brio Designer 6.0, Cognos Impromptu 6.0, Cognos Power play 6.0. Crystal Reports 7.0 / 8.0.

OPERATING SYSTEM: Windows NT /XP/ /95, UNIX, MS-DOS

LANGUAGES: Visual basic, VB.Net, C, C++.

RDBMS: Oracle 9i /8i /7i, MS SQL Server 6/7/2000, MS Access.

GUI: Visual Basic 5.0/60, Developer2000

DATABASE UTILITIES: SQL*Loader, SQL*Plus, SQL, PL/SQL, Store Procedures, Functions, Packages, Triggers, Database links, Exception handling, Import/Export.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Working with Business users to understand the requirements, understand pain points in the current system, and propose enhancements to improve the existing system.
• Worked with Data Modelers in Creating Logical & Physical Data models for integrating Revenue Data with LEADS & OPPORTUNITY data.
• Write up Functional Specs and coordinate with the offshore development team.
• Extensively worked on Power Center 8.6.1with Relational and Flat file sources/Targets
• Developed Informatica Mappings, applets, workflows, and worklets.
• Responsible for Integration Testing & Application Testing of ICM before releasing to End Users.
• Drafted Test Plans, backout plans, and Contingency measures during the Code Movements from DEV QA PRD System.
• Maintained the Defects, Reported Bugs, and Tracked Bug History, updating and clarifying where necessary in Watson bugs management system
• Maintained ETL standards, Naming Conventions, and Wrote ETL Workflow Documentation
• Responsible for Technical documentation & Production support Document of ETL Process. Fine-Tuned ETL Mappings for better performance.

Environment: ERWIN 7.3, Informatica 8.1/8.6, Oracle 10g, PL/SQL, Shell Scripts, Toad 8.5.3.2, Unix

Confidential

Informatica Developer

Responsibilities:

• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development, and testing to production.
• Worked on Informatica PowerCenter Tools-Designer (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets & Transformations), Repository Manager, Workflow Manager & Workflow Monitor.
• Extensively used ERwin to design Logical/Physical Data Models and Modeled the Data Warehousing Data marts.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables, and rapidly changing dimensions in Multidimensional model.
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
• Extracted data from Heterogeneous source systems like Oracle, Teradata, SQL Server, and flat files.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Optimized query & session performance, Improved mapping performance using SQL overrides.
• Used PL/SQL to write stored procedures to increase the performance.
• Developed post and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated to date, etc.
• Developed various sessions, and batches containing parameters files, indicator files, and multiple sources files.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, and automate the process of loading, pulling & pushing data from & to different servers.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata), and SQL*Plus, SQL*Loader (Oracle).
• Created Teradata External Loader connections such as MLoad Upsert, MLoad Update, Fast Load, and Tpump in the Informatica Workflow Manager while loading data into the target tables in Teradata Database.
• Worked on error handling in TD SQL s using ERROR CODE and ACTIVITY COUNT.
• Involved in Creating Unit test & Integration test plans to test mappings & created test data.
• Experienced in Building the repository and Involved in Administering the Physical Layer, Business Model Mapping Layer, and Presentation Layer.
• Effectively managed ODBC connections, and imported the Physical tables, keys, and foreign keys.
• It also involves developing IDE Reports and IDQ Dashboard Reports and Data validations.
• Developed Dashboards and Reports and also modified and formatted requests with different views, filters, prompts, and Drill-down capabilities as per the client requirements.

Environment: Informatica PowerCenter 8.6, Oracle 10g/11g, UNIX, PL/SQL, OBIEE 10.1.3.2, Erwin, Teradata 12, CDC, MS SQL Server 2008/2005

Confidential

Informatica Developer

Responsibilities:

• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development, and testing to production.
• Worked on Informatica PowerCenter Tools-Designer (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets & Transformations), Repository Manager, Workflow Manager & Workflow Monitor.
• Extensively used ERwin to design Logical/Physical Data Models and Modeled the Data Warehousing Data marts.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables, and rapidly changing dimensions in Multidimensional model.
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
• Extracted data from Heterogeneous source systems like Oracle, Teradata, SQL Server, and flat files.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Optimized query & session performance, Improved mapping performance using SQL overrides.
• Used PL/SQL to write stored procedures to increase the performance.
• Developed post and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated to date, etc.
• Developed various sessions, and batches containing parameters files, indicator files, and multiple sources files.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, and automate the process of loading, pulling & pushing data from & to different servers.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata), and SQL*Plus, SQL*Loader (Oracle).
• Created Teradata External Loader connections such as MLoad Upsert, MLoad Update, FastLoad, and Tpump in the Informatica Workflow Manager while loading data into the target tables in Teradata Database.
• Worked on error handling in TD SQL s using ERROR CODE and ACTIVITY COUNT.
• Involved in Creating Unit test & Integration test plans to test mappings & created test data.
• Experienced in Building the repository and Involved in Administering the Physical Layer, Business Model Mapping Layer, and Presentation Layer.
• Effectively managed ODBC connections, and imported the Physical tables, keys, and foreign keys.
• It also involves developing IDE Reports and IDQ Dashboard Reports and Data validations.
• Developed Dashboards and Reports and also modified and formatted requests with different views, filters, prompts, and Drill-down capabilities as per the client requirements.

Environment: Informatica 6.1, Business objects 6.0, Unix, Oracle 9i, Toad, Loss States, Showcase, AS400, and Windows 2000.

Confidential

System Analyst (Data Warehouse)

Responsibilities:

• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Lookup, Sequence Generator, Stored Procedure, Expression, and Filter transformations.
• Scheduled sessions using workflow manager’s scheduler, Crontab, and Control-M Scripts in Unix.
• Extensively used SQL overrides at Source Qualifier and Lookup Transformations while extracting data from multiple tables.
• Tuned mappings to perform better using different logics to provide maximum efficiency and performance.
• Tested the target data against source system tables.
• Created Parameter files for Mappings and written header files for target flat files.
• Migrated mappings from Development to UAT and to Production Environments.
• Used Source files from DB2, Oracle, CSV & Flat files.

Environment: Informatica 6.1, Business objects 6.0, Unix, Oracle 9i, Toad, Loss States, Showcase, AS400, and Windows 2000.

Confidential

Informatica/ETL Developer

Responsibilities:

• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Lookup, Sequence Generator, Stored Procedure, Expression, Filter, and Rank transformations.
• Worked on Normalizer transformation to normalize the denormalized sources.
• Used Unix Shell script for Oracle & Informatica to automate the Server start and shutdown process
• Informatica ETL tool (Power Center6.1) was used to load strategic source data to build the data marts. An operational data store was created. The metadata Build up was designed for performing data mapping. Also, being involved in Mass data Loads, refreshing the data in various applications, Performance evaluations, and modifying the existing code to accommodate new features.
• Informatica is used to create and organize various metadata types, including legacy source and data warehouse target data definitions and ETL jobs.
• The Mapping Designer module is used for ETL tasks to upload the data from various centers with data in different source systems to build Data Marts.
• Created Informatica parameter files with workflows and sessions
• Informatica Server Manager is used to execute the sessions
• Used SQL overrides at Source Qualifier and Lookup Transformations while extracting data from multiple tables.
• Optimizing Performance tuning for mappings.
• Testing and comparing source and target data.
• Documentation of ETL extracts developed using the Informatica extract tool.
• Used exp & repository manager for taking backup of the repository
• Migration from test to dev, stag, prod repositories.
• Developed PL/SQL Stored procedure, Package, Trigger, Materialized View.
• Created various Adhoc and canned reports using Business Objects.
• Generated reports with Universes created in Business objects Designer as the data providers with various functionalities that displayed data even in a graphical format.
• Used Business Objects designer to create Universes, classes, objects.

Environment: Informatica 7.1/6.1, Business objects 6.0, TOAD, Erwin 4.1, BRIO 6.0, Oracle 9i/oracle 11i, windows 2000, UNIX