PROFESSIONAL SUMMARY:

• Around 7 years of extensive IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Financial, Banking and Insurance industries
• Over 5+ years of strong experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing ETL Solutions using Informatica Power Center (9.1/8.x/7.x)
• Extensively worked on Informatica Designer Components - Source Analyzer, target Designer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.
• Involved in the Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Staging Tables, Dimensions, Facts and Star, Snowflake Schemas.
• Expertise in Query Analyzing, performance tuning of Informatica Mappings
• Extensive knowledge in PL/SQL, strong in writing complex database queries
• Extensively utilizedBusiness Intelligence Reporting Tools such as Business Objects 5.X/6.X, Business Objects Enterprise XI R1/R2
• Expertise in building/enhancing/migrating Universes, Retrieving data using Universes, Personal data files, stored procedures and Freehand SQL methods.
• Expertise in creating Reports using Business Objects Web Intelligence and Desktop Intelligence tools.
• Expertise in creating Dashboards using XCelcius
• Expertise in using Crystal Reports, QAAWS
• Experience in building Universes, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

Education :

• Bachelor of Science in Computer Science
• Post Graduate Diploma in Computer Applications

Certifications:

• Sun Certified Java Programmer (JDK1.5)

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6.1/8.1.1/7.x/6.x BI Tools: Business Objects , Cognos BI 8 Series (Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Transformer) Cognos Report Net 1.1MR1/MR2, Framework Manager, Report Studio, Query Studio, Cognos Connection, Cognos Databases: Oracle 10g/9i/8i, SQL Server 2000/2005/2008, DB2, Teradata Languages: SQL, PL/SQL, Java Operating Systems: Windows 2000/2003/NT, Unix, Solaris DB Tools: TOAD, SQL *Plus, PL/SQL Developer, SQL * Loader

PROFESSIONAL EXPERIENCE:

Client - Confidential, Bristol, CT Oct 11 - Till date
Role: Business Intelligence Consultant
Responsibilities:

• Participated in design sessions where decisions are made involving the transformation from source to target.
• Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (PL and SQL), packages and triggers.
• Managed and compiled documentation for all ETL processes.
• Created detailed process flow designs and drafts high-level Standard Operation Procedures.
• Performed Informatica Administration tasks.
• Performed tuning for PL and SQL procedures, Views, and Informatica objects.
• Designed and implements the error handling strategy for ETL team.
• Monitored data warehouse month-end loads to ensure successful completion.
• Proactively work with other Data Warehouse team members and with the members of other teams (business customers, analysts, developers, DBA’s and technical support staff) to create innovative analytical solution

Environment:Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL, XML, Flat Files, TOAD, SQL * Loader, Windows NT, Unix

Confidential, Milwaukee, WI Feb 09 - Aug 11
Role: Datawarehouse Consultant
Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements.
• Interacted with DBA and Source systems and resolved the Issues.
• Extracted the data from Flatfiles and loaded the data into Oracle using Informatica Power center.
• Created shortcuts for source and target and also created Reusable Transformations in Shared folder.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked on the Informatica Admin Console when the issues were not solved at the session/workflow level.
• Involved in creating the repositories and setting up the repository service and integration service.
• Worked extensively on different types of transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer.
• Creating sessions, worklets and workflows for carrying out test loads.
• Created the Deployment groups to move the workflows from one environment to the other.
• Designed/created the plan for the Master workflows that are to be scheduled to run on daily and monthly basis.
• Performed the performance evaluation of the ETLs for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem troubleshooting.
• Identified and fixed bottlenecksand tuned the complex Informatica mappings for better performance.
• Created Contexts and aliases for resolving Loops in the Universes using Business Object
• Implemented different level of hierarchies for drill down reports using Web-Intelligence and Desktop Intelligence
• Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc
• Migrating Universes and Reports from Business Objects 6.5 to Business Objects XI using Import Wizard.
• Converting the Desktop Intelligence Reports to Web Intelligence reports using Report Conversion Tool.
• Created test cases for carrying out unit testing and part of functional testing.

Environment:Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL, XML, Flat Files, TOAD 9.6, SQL * Loader, Windows NT, Unix, Business Objects XI R1 Suit, Web Intelligence, Crystal Reports 2008, XCelcius 2008, TeraData,

Client: Confidential, Scottsdale Arizona JUL 2007 to Dec 2008
Role: Datawarehouse Consultant
Responsibilities:

• Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects.
• Created (or edited existing) Informatica mappings and sessions to accomplish data migrations. Sources were Oracle, DB2 and flat files and load into target.
• Created Complex mappings using transformation like Connected/Unconnected Lookup, Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Re-designed ETL mappings to improve data quality.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Provided production support by monitoring the processes running daily.
• Involved in the debugging of the mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Created partitions through the session wizard in the workflow manager to increase the performance.
• Created workflows with sessions, worklets, event waits, assignments, conditional flows, email and command tasks in Workflow Manager.
• Recommended tuning options to source/target database DBA team to gain optimum performance.
• Created various Classes, Objects and Measure Objects in the Universe. Measure Objects and Dimension Objects were created keeping in view of the end user.
• Created Contexts and aliases for resolving Loops in the Universes
• Implemented different level of hierarchies for drill down reports.
• Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc
• Migrating Universes and Reports from Business Objects 6.5 to Business Objects XI using Import Wizard.
• Converting the Desktop Intelligence Reports to Web Intelligence reports using Report Conversion Tool.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.

Environment:Informatica Power Center 7.1, Oracle 8i, SQL, PL/SQL, SQL * Loader, TOAD, Windows 2000, Unix, Business Objects XI R1 Suite, Desktop Intelligence, Web Intelligence, Crystal Reports 2008, DB2.

Client: Confidential, Phoenix, Arizona Mar 06 to June 07
Role: Datawarehouse Consultant
Responsibilities:

• Involved in end to end datawarehousing project from ETL (Informatica) to Reporting(BO Suite)
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Solid Expertise in using both Connected and Unconnected Lookup transformations.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Extensively worked with joiner functions like normal join, full outer join, master outer join, and detail outer join in the joiner transformation.
• Extensively made use of sorted input option for the performance tuning of aggregator transformation.
• Worked on the system that has around 3000 stored procedures and 400 tables.
• Responsible for month-end data consistency checks and fixes using shell scripts and stored procedures. Also responsible for tuning stored procedures.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Used Update Strategy DD_INSERT, DD_DELETE, DD_UPDATE, and DD_REJECT to insert, delete, update and reject the items based on the requirement.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Developed Re usable Transformations, and Re Usable Mapplets.

Environment: Informatica Power Center , Oracle 8i, SQL Server , SQL, PL/SQL, XML, Flat Files, TOAD, SQL * Loader, Windows NT, Business Objects 6.5, BO XI R2 Suit, Web-Intelligence, , SQL, Windows XP Professional, Solaris

Client: Confidential, Scottsdale, Arizona Apr 05 to Jan 06
Role: Informatica Consultant
Responsibilities:

• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, and Sequence Generator.
• Extensively worked with Slowly Changing Dimensions Type1, Type2 for Data Loads
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
• Extensively worked with Source Qualifier Transformation to join the homogeneous sources.
• Extensively worked with Joiner Transformation to join the heterogeneous sources.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re usable objects like Re-Usable Transformation and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level

Environment: Informatica Power Center, Oracle 8i, SQL Server, SQL, PL/SQL, XML, Flat Files, TOAD, SQL * Loader, Windows NT.
Confidential Oct 03 to Dec 04
Role: Oracle Developer
Responsibilities:

• Design of the overall database using Entity Relationship diagrams.
• Wrote triggers and stored procedures in PL/SQL.
• Data loading and Extracting functions using SQL.
• Designed and developed all the tables, views for the system in Oracle.
• Designing and developing forms validation procedures for query and update of Data.
• Created forms, and queries.
• Created reports for different criteria.

Environment: Oracle 8i, SQL, PL/SQL, Windows NT