Professional Summary:

• Used DAC Data Warehouse Administration Console , Control-M and AUTOSYS to configure, trigger and monitor the ETL loads.
• Worked onTuning mappings, identifying and resolving performance bottlenecks at various levels like Sources, Targets, Mappings and Sessions.
• Developed CDC's Change Data Capture using the Informatica Power Exchange.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure, Update Strategy, SCD's Type1, Type2 and Type3.
• Hands of experience in defining Technical Requirements for ETL process and Analytical reports involved End to End implementation of ETL methodology in Data Extraction, Transformation and Loading into Enterprise Data Warehouse and Data Mart.
• Experienced in data integration and migration experience in Analysis, Design, Developing ETL mappings and scripts using Informatica Power Center v 9.x/8.x/7.x using Designer Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer , Repository Manager, Workflow Manager and Workflow Monitor.
• Specializing in Date Warehouse and Business Intelligence fields, with extensive experience in full life cycle of the software design process including requirements definition, design, interface implementation, maintenance and support.
• Eight 8 plus years of total IT experience in Information Technology with a strong background in Analysis, Design, Development, Implementation and supporting Data Warehousing and BI applications by using Informatica Power Center and OBIEE tools.
• Widely exposed on OBIEE Administration Tool, Presentation Services/ OBIEE Analytics Web Answers, OBIEE Interactive Dashboards, OBIEE Delivers/AGENTS, Cache Management, OBIEE Scheduler Configuration, KPI's Key Performance Indicators .
• Proficiency in building three layers PhysicalLayer, Business Model Mapping BMM and Presentation Layer of OBIEE Repository.
• Good Knowledge on Data warehouse Concepts and Experience on Dimension Modeling Schemas Star, Snowflake and Galaxy Schemas.
• Experience in industry verticals like Insurance, Health care, Banking, Telecom, and Retail.
• Good analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent ability to Plan, Organize and prioritizes of my work to meet on time the deadlines of my clients and keep customer's satisfaction at the highest level possible.

TECHNICAL SKILLS:

• ETL Tools : Informatica7.x.x/8.x.x/9.x.x, Teradata 14.00
• BI Tools : BI Apps, OBIEE 11g/10g, BI Publisher,Cognos BI
• Distributed Computing : Apache Hadoop, HIVE, IMPALA, PIG
• Databases : Oracle, Teradata, SQL Server, DB2
• Programming Languages : C, SQL, PL/SQL, UNIX Shell Scripting,AVA
• Scheduling Tools : DAC, AUTOSYS, Control-M
• Operating System : LINUX, AIX and Windows

PROFESSIONAL EXPERIENCE:

ETL Consultant Confidential

Environment: Informatica9.5.1, Informatica Power Exchange, Informatica Data Quality IDQ , Informatica MDM, Teradata 14.00, Control-M, SQL Server, DB2,Qlikview, TOAD, Teradata SQL Assistant, Oracle 11g, Flat Files, COBOL Files, Mainframe JCLs, Shell Programming, AUTOSYS, Unix Scripting, Erwin, LINUX, PL/SQL, OBIEE, SQL Server Integration Service, SQL Server Reporting Service, HP Quality Center.

Responsibilities:

• Closely worked with Business Analyst and Architects to clarify the Requirements and then translate them into technical specifications.
• Implemented the mappings using Normalizer and other transformations to process the data from the COBOL flatten files by preparing the respective InformaticaCopybook for each and every file and then propagating the data into Teradata warehouse.
• Developed CDC Change Data Capture mechanism using InformaticaPower Exchange for capturing the near Real time data to enable Real time analytics for the business.
• Experienced in using various transformations like Aggregator, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Lookups, Union and XMLs to develop robust mappings in the Informatica Designer.
• Applied the Push down optimization technique and used to Teradata utility adapters BTEQ, MLOAD, FLOAD, FEXTRACT and TPT in the sessions and also fastening the loading process.
• Performance Tuning Informatica Maps, transformations and Sessions for the best performance.
• Designed and executed Informatica and Teradata test cases during Unit testing.
• Reconciled the issues comes out of testing cycles and updated the specifications accordingly.
• Troubleshooting memory related issues like DTM, Line Sequential buffer size and stack over flow
• Worked on Quality Center defects by performing the impact analysis and then apply the fix.
• Monitored the Informatica cycles on weekly basis and spot fixing the data/environment issues.
• Involved in Peer code reviews, code migration activities and scheduling of the loads.
• Worked with Informatica support team to resolve the Environment/Product bugs.

ETL OBIEE Consultant Confidential

Environment: InformaticaPower center 8.1.1, Informatica Power Exchange, Informatica Quality Center IDQ , Erwin, Informatica Developer tool, TOAD, PL/SQL, SAP BO, Data Stage, Flat Files, BI Publisher, OBIA 7.9.6.X, OBIEE 10.1.3.4.0,Oracle BI Publisher, Weblogic, Oracle EBS Forms, Reports ,PeopleSoft CRM, Unix Scripting, Shell Scripting, DAC, Oracle 10g, HP Quality Center, Windows, AIX server.

Responsibilities:

• Requirement gathering and preparing MD50 and MD70 design documents after doing proper impact analysis.
• Build efficient ETL Process for processing fact and dimension tables with complex transforms and SCD type 1 and SCD type 2 changes.
• Customized the OOB Out Of the Box mappings and also implemented new mappings based on the requirements.
• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Lookups, Union and Aggregator to develop robust mappings in the Informatica Designer.
• Built the new DAC execution plans for scheduling by customizing Out of Box Subject areas, building the new execution plans for triggering different ETL Loads.
• Customized and administered the Physical layer, Business Model Mapping layer and Presentation layer with OBI Apps repository.
• Created Security settings in Oracle Administration tool to set up groups, access privileges and also managing security for groups in BI Answers.
• Independently reconciled the defects logged during ST, SIT and UAT cycles for my owned requirements/Issues.
• Conducted peer code reviews and code migration activities to different environments.
• Experienced in monitoring the daily production loads, experienced in reconciling the issues on the spot and analyzing the bad and reject records.
• Given presentations to the end users on the new functionality before go live.

ETL OBIEE Developer Confidential

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange, OBIA 7.9.6.X, OBIEE 10.1.3.X, Siebel 7.8 CRM, Siebel Tools, TOAD, Flat Files, Oracle, Unix Shell Scripting, File Transfer Protocol FTP , Weblogic, SQL, PLSQL, DAC, Sun Solaris.

Responsibilities:

• Actively participated during the design discussions with the customer and prepared both the High level, Low level design HLD LLD documents.
• Implemented few complex mappings with all kinds of transformations and customized the Out of Box mappings to match the requirements.
• Built the new DAC execution plans using the Out of Box Subject areas and also fixed the issues occurred, while triggering different initial ETL Loads.
• Customized and administered the Physical layer, Business Model Mapping layer and Presentation layer with OBI Apps repository.
• Extensively worked on the Segments, Segment Trees, Lists and Load Formats used for the Campaign Management.
• Enhanced the performance of the Reports, Segments and Segment trees.
• Created Security settings in Oracle Administration tool to set up groups, access privileges and also managing security for groups in BI Answers.
• Responsible of Managing, scheduling/triggering different Loads in the DAC.
• Experienced in Automation of the loads using the Shell script programming.
• Performed the Peer to Peer code reviews for quality assurance.
• Independently reconciled the defects logged during ST, SIT and UAT cycles.

ETL OBIEE Developer Confidential

Environment: Informatica 7.1.5,OBIEE 10.1.3.3, Oracle 10g, Siebel Sales CRM, Siebel Tools, Quality Center, Windows, Unix Shell Scripting, TOAD, SQL, PLSQL, DAC, Flat Files.

Responsibilities:

• Prepared the Detailed Design High and Low level documents for all my requirements.
• Created new Maps, Maplets, Sessions, Workflows and Worklets using Power center tools.
• Scheduled and monitored the loads by using the DAC Data Administration Console tool.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables. Implemented Level based measures LBM .
• Definedmultiple Dimension Hierarchies for the Dimension Logical Table.
• Implemented both Object and Data level security as perbusiness requirement.
• Developed reports with different kinds of pivot, chart, compoundand column selector views.
• Worked on Analytics iBots to send messages conditionally to Groups / Selective Recipients.
• Analyzed and resolved thedefects logged during ST, SIT and UAT cycles.
• Conducted the KT sessions while handling the developed code to support team.

ETL Developer Confidential

Environment: Informatica7.5, Siebel Analytics 7.8.x, Administration Tool, Oracle 9i, Siebel CRM 7.5, Windows, Shell Scripting, File Transfer Protocol WINSCP , Quality Center.

Responsibilities:

• Developed various mappings and mapplets to load data from various sources using different transformations like Router, Aggregator, and Joiner, Lookup, Update Strategy, Source qualifier, Filter, Expression and Sequence generator etc., to store the data into the target table.
• Implemented Slowly Changing Dimensions Type 2 : Date Time to update the dimensional Schema Facts Dimensions .
• Using Transformations to clean the data from staging area as per the business rules.
• Involved in creating, editing, scheduling and deleting of Sessions and batch of session using Workflow Manager in Power Center.
• Performed error handling of sessions by using terse, normal, verbose initialization and verbose data tracing levels. Performed error handing using session logs.
• Involved in Delivery Review and Fix the defects which comes out of testing
• Used the existing connection pools to import new physical tables, defined joins and designed the Physical, BMM layers of the repository.
• Enhanced existing Business models and created customized Dashboards.
• Developed different kinds of Reports pivots, charts, compound layout using global, local Filters and assigned them to the application specific dashboards.

ETL Analytics Developer Confidential

business functionalities.

Environment: Informatica7.1, Siebel Analytics 7.8.x, Oracle 9i, Siebel CRM 7.8, AIX 5.1, Remedy tool.

Responsibilities:

• Developed the Mappings and session as per the technical Design specifications.
• Used various Transformations like Expression,filter,Joiner and Lookups for better Data propagation, migrate clean and consistent data.
• Involved in reviewing the Test Cases written by the peers and also prepare Test cases.
• Created and executed the Unit test case for the maps and trigger the loads.
• Used the existing connection pools to import new physical tables, defined joins and designed the Physical, BMM layers of the repository.
• Enhanced existing Business models and created customized Dashboards.
• Developed different kinds of Reports pivots, charts, compound layout using global, local Filters and assigned them to the application specific dashboards.
• Handled and fixed various support issues in both Siebel Analytics and Siebel CRM.
• Promptly acknowledged to all the Service requests which are owned by me with in the SLA.