SUMMARY:

• 6 years of strong experience with ETL design and development using Informatica,Pentaho ETL tools. Have been involved in analysis and design of complex datamart schemas, migration strategies and interfaces for Data Warehouses using Informatica ETL tool
• Experience in Data Warehouse using Informatica Power Center v 9.1/8.6/8.5 (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Transformation Designer, Warehouse Designer, Star & Snowflake Schemas, using ETL tool Informatica on Oracle Databases etc)
• Heavily involved in complete life cycle of enterprise data warehouse
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques, pushdown optimization and also identifying performance bottlenecks
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema)
• Experience in multiple domains like Banking, Insurance and Telecom
• Worked with connected, unconnected lookups and reusable transformations and mapplets
• Involved in unit testing of the mapping and SQL code
• Experience in integration of various data sources like Oracle, SQL server and non-relational sources like flat files, CSV and XML into staging area
• Expertise in handling multiple projects simultaneously and design / development of client-server and multi-tier applications and Decision Support systems and solutions
• Experienced in UNIX work environment, file transfers and error handling
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD
• Experience in Job scheduling tools like Control-M, Autosys
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation, Resource Planning, Project Tracking, UAT

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter 9.5.1/8.6,Pentaho

Data Modeling: Star Schema Modelling and Snow Flake Modelling

Databases: Oracle 11g,10g/9i,SQL Server 2008

Languages: SQL, PL/SQL, Unix Shell Script, XML,HTML

Scheduling Tools: Auto sys, Control M

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, New Jersey

Responsibilities:

• Extensively usedInformaticaClient tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files
• Responsible for developing for the ETL (Extract, Transform and Load) processes usingInformatica Power Center
• Developed Informatica mappings using transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations the business logic after replacing the new ERP
• Redesigned some of the existing mappings in the system to meet new functionality
• Worked on Performance Tuning at Database andInformaticaside like Source, Target, Mapping, Transformation and Session to make them more efficient in terms of session performance
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers
• Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process
• Daily Data load Monitoring: These Workflows were then scheduled to run at specific time intervals on the Client Production Repository and monitored regularly in Workflow Monitor
• Supporting the issues raised by the Front end Development teams and Testing teams
• Involved in regular project status meetings related to Development
• Coordination of onsite and offshore activities
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager
• Used Control- M Scheduling tool to schedule the jobs as per the requirement
• Involved in writing Unit test cases for complex scenarios
• Experience in creating UNIX shell scripts and Perl scripts
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects and knowledge in microstrategy
• Client interaction with respect to delivery and deployment

Environment: Informatica Power Center 9.0.1, Oracle 10g, Oracle, SQL, UNIX.

ETL Developer

Confidential, Dallas, TX

Responsibilities:

• Worked with business analysts in gathering the requirement and kept huge efforts to get the precise information as we are working with provider data.
• Extensively involved in analyzing the huge data in the data ware house to understand the amount of duplicates, distinct values in order to determine the key column.
• Developed mappings/sessions usingInformaticaPower Center 9.1/8.6.1 / Power exchange 8.5.1 for data loadings
• Responsible for managing informatica services like PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extensively worked onInformaticaPower Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier
• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes
• Worked in all the phases of the Data Warehouse project life cycle involving design, development and Implementation of Data warehouses using ETL, Online Analytical Processing & reporting tools(BO)
• Good Understanding of Logical and Physical Data Modeling, Dimensional Data Modeling, Star Schema/Snow Flake Schema
• Involved in data quality profiling, standardization and testing
• Created reusable transformations and Mapplet and used with various mappings.
• Checking whether data Imported from source tables transformed and loaded into Data Warehouse Targets using SAS
• Assisted the other ETLDevelopersin resolving complex scenarios
• Implemented various functionality such as Drill down, Drill up, Alerts etc.
• Designed and created an Autosys job plan to schedule our processes
• Shown commitment and enthusiasm to achieve the dead lines by effective time management

Environment: Informatica Power Center 9.1/8.6, Oracle 10g, Oracle, SQL, UNIX.

SQL/PentahoDeveloper

Confidential

Responsibilities:

• Coded database Stored Procedures, Functions, Packages and Triggers in PL/SQL, and maintained Integrity Constraints
• Provide enhancements and maintenance support to current application
• Designed pilot system usingPentahoKettle for ETL enhancements andPentahoBI Server for publishing thePentahoReports on user funds transfer measures
• Used various types of inputs and outputs inPentahoKettle including Database Tables, MS Access, Text Files, Excel files and CSV files
• Implemented miscellaneous transformations in Kettle Spoon Designer including Database Lookup, Database Join, Calculator, Generate Rows, Mapping Transformation, Filter Rows, Dimension Lookup/Update, Add Sequence, Add Constants, Row Normalizer and Demoralizer
• Developed SSIS Packages to generate the reports in Excel sheets required by the managers for analysis
• Created SSIS package to get data from different sources, consolidate and cleanse the data and merge it into one single source
• Designed Data warehouse including star schema design, DW capacity planning, MySQL performance and tuning. Implemented Orders and Points DW using star schema, Orders and Points Business domain usingPentahoMeta Data. Created Stage based DW supported by that's completely implemented inPentahoKettle
• Participated in design of Staging Databases and Data Warehouse database using Star Schema
• Successfully converted all database code including stored procedures, functions and triggers written in PL/SQL into T-SQL to be created in new system running on SQL Server Database
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created several SSIS packages in Business Intelligence Development studio (BIDS) to extract data from OLTP systems and load into staging databases
• Created triggers on master data tables in OLTP to keep track of insertion and updates
• Created Profiling, Cleansing and auditing plans with SSIS Packages
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time
• Load data in Data ware House by using Slowly Changing Dimension (SCD - Type 1, 2, 3)
• Use event handling to send E-mail on event like on error
• Use Data Viewers in SSIS Packages to check the flow of data during Execution of Packages
• Generated reports using SSRS that could be used to send information to different managers of Different Branch
• Actively participated in all phases of system development life cycle (SDLC) starting from requirement gathering all the way up to deployment in production and system testing
• Prepared user manual and technical support manual
• Created different type of reports including Cross-tab, Tabular, Charts, graphs, Sub reports, Drill-down reports with Cascading Parameter prompts
• Performed SQL Server installation in Share-Point Integrated mode
• Deployed SSRS reports on Report Server using Report Manager, as well on SharePoint Server
• Generated the various kinds of reports using Graphs and Images
• Deployed SSRS reports using Report Manager and scheduled the reports to generate all daily, weekly, monthly and quarterly Reports including current status
• Utilized Dynamic SQL in stored procedures to generate the query dynamically within the procedure using parameter values to make up the query

Environment: PentahoBI Server,PentahoData Integration (PDI/Kettle),PentahoMondrian OLAP Server,PentahoDesign Studio,PentahoReport Designer, MS SQL Server, SQL Server Integration Services (SSIS), Oracle 10g, Enterprise Management Studio

PL/SQLDeveloper

Confidential

Responsibilities:

• Developed PL/SQL triggers and procedures, functions, packages to provide backend security and data consistency
• Involved in documenting user requirements, technical specifications and Reporting manuals
• Involved in PL/SQL code review and modification for the development of new requirements
• Developing functional, technical documents, advanced coding and bug fixation
• Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Partitioned the fact tables and materialized views to enhance the performance
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Implemented using Forms, Reports, PL/SQL, Flex fields and Workflow
• Customized, created and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc
• Designed and developed custom database security in PL/SQL for Oracle versions 9i, and 10g.
• Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD