SUMMARY

• Overall 14+ Years of extensive experience in IT industry, which includes Experience with OLAP reporting tool like OBIEE (Siebel Analytics), BI Applications including DAC, Informatica, ODI, BIACM, FSM
• 9 years of experience in BI Applications using Siebel Analytics, OBIEE. Completed 5 Full Implementations.
• Extensive experience in Analysis, Design, Development, Data conversion, Data Modeling in various domains i.e Financial, sales, Marketing and call center.
• Good understanding of source applications like E - business suite, Siebel CRM and Legacy Applications.
• Expertise in Data Analysis, Identification of slowly changing dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies
• Experienced in creating Data security & Object level security to the users using OBIEE.
• Worked in BI Apps mappings for different source applications i.e. EBS, Siebel and also implemented Incremental vs. Full load mechanisms at various clients.
• Worked on BI APPS Customizations for Oracle R12 GL, AP, AR and OM Modules
• Good Understanding on BIAPPS 7.9.6.4, BIAPPS 11.1.8.1 and ODI (Oracle Data Integrator)
• Strong in building Informatica mappings & ODI Interfaces sourcing from heterogeneous data sources.
• In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing.
• Experienced in designing Star Schema/ Snowflake Schema methodologies.
• Experienced in Configuring and publishing the iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions to all the departments in the organization by Emails.
• Proficient in using Informatica tools like Designer, Workflow Manager and Repository Manager to create, schedule and configure the repositories, mappings and workflows.
• Experienced in configuring DAC, BIACM for executing, scheduling and monitoring various ETL tasks (Execution plans).
• Extensively used DAC to implement Index management strategies and Database statistical updates for efficient query performance.
• Extensively worked on Performance tuning strategies by tuning the rpd for OBIEE to generate efficient queries.
• Extensively used Catalog Manager for webcatalog migrations and also Administered webcatalog upgrades.
• Strong experience with oracle Database in writing SQL queries, coding PL/SQL Procedures, Functions, Cursors, Triggers and Packages, Materialized view.
• Good analytical & functional skills, ability to effectively communicate with technical & business users.

TECHNICAL SKILLS

BI Reporting Tool: Siebel Analytics 7.x, OBIEE 10.1.3.x, OBIEE 11g, OBI Applications 7.9.x

ETL Tool: Informatica 9.0/8.6/7.1, ODI, DAC 10.1.3.4/11 G, BIACM, FSM

Business Domains: Financial, Sales, Marketing, Call center, Supply Chain, Manufacturing

Operating Systems: Windows 2000/2003, UNIX, Linux.

Programming languages: C, C++, PL/SQL, Unix Shell scripting.

Databases: Oracle 9i/10g, SQL Server 2000/2005, IBM DB2 8.1

DB Tools: TOAD, SQL Developer, SQL*Loader

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Pheonix AZ

Senior OBIEE & BIAPPS Consultant

Environment: OBIEE 11G, Oracle Business Intelligence Applications 11.1.81, Oracle R12, Siebel CRMODI, BIACM, FSM,Oracle 11g (SQL/PL-SQL), Windows 2007 Server

Responsibilities:

• Migrating Current OBIEE 10G, ESSBASE, APEX SFDC Reports into OBIEE 11G
• Working closely with Business Analyst, Team Lead and gathering the requirements from different user groups.
• Customizing Physical Layer, Business Model and Mapping Layer and Presentation layer of repository using Oracle Business Intelligence Administration tool.
• Building data modeling of facts and dimension tables in Star schema model.
• Implement Data Level security using repository and session variables.
• Building cache strategies using manual scripting, Event polling mechanism to improve report performance and Build Global prompts, Filters for customizing the reports using OBI Presentation services as per the requirement.
• Scheduling Reports using OBIEE Delivers and Implement Narrative views, Charts, Pivot tables and Compound layout to design the dashboards.
• Merging web catalogs using Catalog Manager at the time of Deployments.
• Creating Users and Groups and assigning permissions depending on the user for configuring security settings using Oracle Business Intelligence Administration Tool.
• Configuring OBI scheduler and generating ibots alerts for delivering the reports to different users.
• Configured OOTB ODI Interfaces and created BIACM execution Plans to schedule and run the mappings periodically for incremental Loads in the Datawarehouse.
• Involved in customizing the mappings using different transformations like Connected and Unconnected lookups, Aggregate transformation, Update Strategy for populating data into targets.
• Involved in configuring, scheduling and monitoring ETL tasks like Execution plans using BIACM as per the business requirement.
• Worked with end users and prepared documentation

Confidential, Milpitas, CA

Senior OBIEE Consultant

Environment: OBIEE 11.1.7.1, Oracle Business Intelligence Applications 7.9.6.3, DAC 10.1.3.4.1 , Oracle Financials R12, Sales force, Informatica 9.1.0, DAC 10.1.3.4.1 , Oracle 11g (SQL/PL-SQL)Windows 2008 Server, Linux

Responsibilities:

• Implemented current reporting outputs using SalesForce.com and EDW data delivered through the OBIEE 11.1.7.1 Dashboard and reporting capabilities.
• Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans
• Customized Physical Layer, Business Model and Mapping Layer and Presentation Layer of Repository (RPD) using Oracle Business Intelligence Administration Tool and performed Consistency check of the Business Model before exposing in the Presentation Layer considering errors, warnings and best practices
• Provide Ad-hoc reporting to selected business users for further data analysis by Object Level Permissions controlled Using External table.
• Developed a deep understanding of business needs and problems to analyse data and business requirements in order to design and deliver over a dozen dashboards containing a multitude of KPIs and metrics.
• Provided few real-time (frequently updated) reports in OBIEE using SFDC reporting and visualization functions and Loading in EDW using Informatica.
• Automate the current manual data collection process used to gather data into Data Warehouse which is updated to TL9000 system for use in reports.
• Complicated reports have been developed using multiple views like Pivot, View Selector, Chart View and Gauges and ensured pleasant User Experience and proper delivery of major requirements, minor details, and intuitive OBIEE User Interface.
• Implemented Security by creating roles & web groups, checks with External tables
• Working closely with Business Users, Team and gathering the requirements from different user groups for Migrating Current BRIO Reports into OBIEE 11G
• Implemented Cache management to handle performance issue in report generation.
• Executed OBIEE administrative tasks such as OBIEE RPD and Webcatalog migration and user maintenance.
• Good Understanding of BI Publisher reports and using various templates to publish the reports as per user requirements.

Confidential, Foster City, CA

Senior OBIEE Consultant

Environment: OBIEE 10.1.3.4.1 , Oracle Business Intelligence Applications 7.9.6.0, Oracle Financials R12, Informatica 9.0, DAC 11G, Windows 2008 Server, Linux

Responsibilities:

• Design and Develop OBIEE Metadata Repository (RPD) for Custom OPM and Work Order Reports using Oracle Business Intelligence Administration tool.
• Modified the ETL to get the Custom Conversion Rate for Bottles and Tablets
• Modified the Existing PLSQL Package which Populate MVIEWS in OLTP for OPM custom reports and scheduled it run every day through concurrent Manager
• Successfully validated all the Existing OBIEEE Reports and Dash Boards after Modifing the Data ware house
• Involved with systems team and Upgraded and Tested Intormatica from 8.6 to 9.5 and DAC 10g to DAC 11G
• Installed and configured OBIEE 11G applied several patches on Linux Machine and client tools on Windows for POC
• Migrated Informatica and DAC Repositories from One environment to other and perfornmend incremental load by modifing Sequence numbers in Informatica Repository
• Created DAC execution Plans to run and validate the mappings periodically for incremental and Full Loads in the Datawarehouse before Prd Migration.
• Tested all the Reports by capturing Logical SQL and schedule to run every day using cron Jobs and captured the Response time after Data base Upgrade

Confidential, Liver More, CA

Senior OBIEE Consultant

Environment: OBIEE 11.1.1.7.1 , Oracle Business Intelligence Applications 7.9.6.3, Oracle Financials R12, Informatica 9.0, DAC, Oracle 11g (SQL/PL-SQL), Windows 2008 Server, APEX

Responsibilities:

• Installed OBIEE, BIAPPS, Informatica, DAC for Sand Box Environment on Windows 2008 Server
• Worked closely with Oracle Support and Upgraded OBIEE 11.1.5.0 to 11.1.7.1 and applied several patches in Linux Environment
• Configured, Implemented and Modified Source LKP files for Oracle BIAPPS 7.9.6.3 for Supply chain & Order management Analytics
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Created DAC execution Plans to as per the business requirement to run the mappings periodically for incremental and Full Loads in the Datawarehouse.
• Successfully validated all the OBIEEE Functionalities, Reports and Dash Boards for existing Financial Analytics after OBIEE Upgrade from 11.1.5.0 to 11.1.7.1
• Configured Authentication using LDAP and Authorization from External Data base Using BISQL Group Provider
• Implement Data & Object Level security and Created Users, Groups and Roles assigned permissions depending on the Roles for configuring Secutiry as per the requirement
• Working closely with Business Users in gathering the requirements for Migrating Current APEX Reports into OBIEE 11G
• Design and Develop OBIEE Metadata Repository (RPD) for Custom Sales Reports using Oracle Business Intelligence Administration tool.
• Installed and configured Oracle BI Mobile App Designer for Reporting requirements for Mobile Users

Confidential, Sunnyvale, CA

Senior OBIEE Consultant

Environment: OBIEE 11.1.1.6.0 , Oracle Business Intelligence Applications 7.9.6.3, Siebel CRM, Oracle Financials R12, Informatica 9.0, DAC, Oracle 11g (SQL/PL-SQL), Windows 2008 Server, Actuate

Responsibilities:

• Installed OBIEE (Configured Static Ports), Informatica, DAC and WebLogic Server on Red Hat Enterprise Linux Server
• Configured & Implemented OOTB Oracle BIAPPS 7.9.6.3 Financial Analytics, Supply chain & Order management Analytics, Service Analytics.
• Successfully implemented the Data Warehouse Administration Console Email Notification setup to receive daily email notifications on data load success/failure.
• Configured OOTB Informatica mappings and created DAC execution Plans to schedule and Monitor ETL tasks like Execution plans using Data warehouse Admin Console (DAC) as per the business requirement to run the mappings periodically for incremental and Full Loads in the Datawarehouse.
• Worked with Oracle Support and applied several patches for OBIEE Dashboards Gauge error, BIAPPS Bugs etc.
• Successfully validated data for OOTB Financial Analytics (GL, AP, AR) and Order Management dashboards and Delivered different documents for Data Migration, OOTB Dashboards Description and Financial, Order Management Analytics Configuration.
• Debugged Dashboards using different Analytics Views like Table, Pivot Table, Pie/Bar Chart, Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters and Trouble shooting the issues related to repository models and report development.
• Implement Data Level, Object Level security, cache strategies and Created Users and Groups and assigned permissions depending on the user groups for configuring security settings using Oracle Business Intelligence Administration Tool.
• Configured Custom Logo for OBIEE Dashboards and implemented SSO Security between EBS and OBIEE.
• Working closely with Business Users, Team and gathering the requirements from different user groups for Migrating Current Revenue and Sales Actuate Reports into OBIEE 11G as Users used Actuate as prior reporting tool. So, needed to match every pixel from Actuate to be the same as for OBIEE.
• Analyze Design and Develop OBIEE Metadata Repository (RPD) in all the three layers, Physical Layer, Business Mapping and Model Layer, and Presentation Layer for GCD-CHIP (Custom Data Warehouse project) using Oracle Business Intelligence Administration tool.
• Building data modeling of facts and dimension tables in Star schema model and Designed Dimensional Hierarchies for Drill down and Rool up reports, Trending Reports, aggregations and levels based reports
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Built Customer Care Dashboards, Revenue reporting and Sales Dashboard. Created Presentation catalogs for Sales and Month End Account measures.
• Configured OBI scheduler and generating Agents, alerts for delivering the reports to different users.
• Merged web catalogs using Catalog Manager at the time of Deployments from one Environment to other

Confidential, Menlo Park, CA

Senior OBIEE Consultant

Environment: OBIEE 11.1.1.6.0 , Oracle Business Intelligence Applications 7.9.6.3, Siebel CRMInformatica 9.0, DAC, Oracle 11g (SQL/PL-SQL), Windows 2008 Server

Responsibilities:

• Installed and configured OBIEE 11.1.1.5 which was inturn upgraded to 11.1.1.6, Informatica 9.0, BIAPPS 7.9.6.3 on Linux and Windows Environment.
• Created Sample Reports and Dashboards for Tool Demonstration purpose.
• Migrated OBIEE from 10.1.3.4 to 11.1.1.6, Informatica Repository from 8.6 to 9.0 and configured BIAPPS for Sales, Marketing, Service and Contact center Analytics
• Handled OBIEE Admin activities (Uploads, Migration(RPD and Web catalog), Created New users and Groups, Restarting Services, Configuring Performance Options in EM).
• Analyzed the existing reports in 10g and fixed the code issues in 11g reports
• Setup LDAP Authentication followed by database authorization for authenticating the users
• Implemented security on dashboards and reports based on the roles created in the weblogic.
• Configured Full load / Incremental Load and Scheduled, Maintained and Monitored ETL using Data Warehouse Application Console (DAC)
• Configured Usage Tracking which allowed the Business to analyze the frequently run reports and long running reports and implement performance tuning on these reports accordingly.

Confidential, Mountain View, CA

Senior OBIEE Consultant

Environment: OBIEE 10.1.3.4.1 , Oracle Business Intelligence Applications 7.9.6, Siebel CRM, Informatica 8.6DAC, Oracle 10g (SQL/PL-SQL), Windows 2003 Server

Responsibilities:

• Implemented Data Level security using repository and session variables.
• Creating Users and Groups and assigning permissions depending on the user for configuring security settings using Oracle Business Intelligence Administration Tool.
• Configured Object Level Security as per the User Requirements
• Scheduled Cron Jobs to Clean RPD Cache after Load Completed
• Implemented cache strategies to improve report performance.
• Developed Global prompts, Filters for customizing the reports using OBI Presentation services as per the requirement.
• Worked Extensively on OBI Answers, Delivers and Dashboards.
• Worked on changing styles and Skins of the Dashboard and customized it to user requirements.
• Implemented Default Dash Board using Portal Path Variable and Designed Welcome Screen Using HTML and CSS Files
• Implemented Usage Tracking to Identify the Usage of OBIEE Reports, Dash Boards and Identify Performance of Logical Quires
• Implemented ETL Tracking to Identify Load Status of the DAC Loads like start, End time, status and Embedded the Report in the OBIEE Welcome Screen to Let the users know the Current Load Status and Last Data Refresh Time
• Created Narrative views, Charts, Pivot tables and Compound layout to design the dashboards.
• Merged web catalogs using Catalog Manager.
• Involved in Setting up Production Environment like Installation of OBIEE, Informatica, DAC, Oracle 10G Data Base
• Configured OBI scheduler and generating ibots alerts for delivering the reports to different users.
• Involved in customizing BI APPS mappings sourcing from Siebel Applications.
• Configured OOTB Informatica mappings and created DAC execution Plans to schedule and run the mappings periodically for incremental Loads in the Datawarehouse.
• Involved in configuring, scheduling and monitoring ETL tasks like Execution plans using Data warehouse Admin Console (DAC) as per the business requirement.
• Involved in Performance testing, Stress testing on OBIEE Servers to Identify the Stability of OBIEE Servers when the Load Increases Using Silk Performer
• Generated Silk Performer Scripts for Creating Virtual OBIEE Users to check the Response time of the Reports when the load on OBIEE Servers are Increasing
• Worked with end users and prepared documentation

Confidential, Sunnyvale, CA

Senior OBIEE Consultant

Environment: OBIEE 11G, Oracle Discoverer, Oracle Business Intelligence Applications 7.9.6, Siebel CRMInformatica 8.6, DAC, Oracle 10g (SQL/PL-SQL), Windows 2003 Server

Responsibilities:

• Installed and Configured OBIEE 11G Environment in Windows and Linux Servers
• Migrated OBIEE 10.1.3.4.1 RPD and WebCat to OBIEE 11G
• Preparation of prototype per the requirements & requirement understanding documents for the sign-off
• Analyzed existing Oracle Discoverer Reports and developed the same reports in OBIEE 11G as Per user Requirements
• Developed Global prompts, Filters for customizing the reports using OBI Presentation services as per the requirement
• Worked on support role to do the enhancements in answers pages to make the reports look similar to OBIEE 10g reports

Confidential

Senior OBIEE Consultant

Environment: OBIEE 10.1.3.3, Oracle Business Intelligence Applications 7.9.6, Siebel CRM, Informatica 8.6DAC, Oracle 10g (SQL/PL-SQL), Windows 2003 Server

Responsibilities:

• Worked closely with Business Analyst, Team Lead and gathered the requirements from different user groups.
• Involved in customizing Physical Layer, Business Model and Mapping Layer and Presentation layer of repository using Oracle Business Intelligence Administration tool.
• Involved in data modeling of facts and dimension tables in Star schema model.
• Designing Dimensional Hierarchies for Drill down reports, aggregations and levels using admin tool in the Business Model and Mapping Layer.
• Using Time series functions in building Trending reports for analysis.
• Implemented Data Level security using repository and session variables.
• Implemented cache strategies using manual scripting, Event polling mechanism to improve report performance.
• Developed Global prompts, Filters for customizing the reports using OBI Presentation services as per the requirement.
• Worked Extensively on OBI Answers, Delivers and Dashboards.
• Worked on changing styles and Skins of the Dashboard and customized it to user requirements.
• Created Narrative views, Charts, Pivot tables and Compound layout to design the dashboards.
• Merged web catalogs using Catalog Manager.
• Creating Users and Groups and assigning permissions depending on the user for configuring security settings using Oracle Business Intelligence Administration Tool.
• Configuring OBI scheduler and generating ibots alerts for delivering the reports to different users.
• Involved in customizing BI APPS mappings sourcing from Siebel Applications.
• Configured OOTB Informatica mappings and created DAC execution Plans to schedule and run the mappings periodically for incremental Loads in the Datawarehouse.
• Involved in customizing the mappings using different transformations like Connected and Unconnected lookups, Aggregate transformation, Update Strategy for populating data into targets.
• Involved in configuring, scheduling and monitoring ETL tasks like Execution plans using Data warehouse Admin Console (DAC) as per the business requirement.

Confidential - Concord, MA

OBIEE Consultant

Environment: OBIEE 10.1.3.3, Oracle Business Intelligence Applications 7.9.6, Siebel CRM,Informatica 8.1DAC, Oracle 10g(SQL/PL-SQL), Windows 2003 Server.

Responsibilities:

• Worked closely with Business Analyst, Team Lead and gathered the requirements from different user groups.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Involved in customizing Physical Layer, Business Model and Mapping Layer and Presentation Layer of Repository (rpd) using Oracle Business Intelligence Administration Tool.
• Developed and generated standard and ad hoc reporting capabilities from new and existing data sources in a Data Warehouse environment
• Analyze source data of different types and design programs for data integration, cleansing and transformation using Informatica.
• Designing Dimensional Hierarchies for Drill down reports, aggregations and levels using admin tool in the Business Model and Mapping Layer.
• Configuring repository & session variables to get dynamic reports and dashboards.
• Implementing Cache management to handle performance issue in report generation.
• Implemented Data Level Security using RPD security group Filters.
• Worked on creating Initialization Blocks to handle lot of reporting requirements.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Developed Global prompts, Filters for customizing the reports as per the requirement using OBIEE Answers.
• Worked Extensively on OBI Answers, Delivers and Dashboards
• Created Narrative views, Charts, Pivot tables and Compound layout to design the dashboards.
• Merging of OBI repository and webcat files using Catalog Manager.
• Creating Users and Groups and assigning permissions depending on the user for configuring security settings using Oracle Business Intelligence Administration Tool.
• Configuring OBI scheduler and generating ibots alerts for delivering the reports to different users.
• Created Btree, Bitmap Indexes for improving the report performance and also managed the indexes using DAC to improve the Data Loads for Full Vs Incremental.
• Customized lot of OOTB Informatica mappings to add additional logics such as extension columns, delete mappings etc to meet the business requirements.
• Worked on creating lot of aggregate tables to improve the performance of reports and also configured rpd to handle Aggregate navigations.
• Perform Unit testing in the development instance as the project reaches the Build/Test stages.
• Assist with additional testing as the projects progress through to production release.
• Communicate within MIS, development and business owners to support and deliver quality services.

Confidential, IL

OBIEE Developer

Environment: Oracle Business Intelligence OBIEE 10.x,BI Publisher, oracle 10g,Datawarehouse Administration Console, Oracle E Business Suite, Informatica Power Center 7.1.4,Linux,ERWIN Data Modeling Tool.

Responsibilities:

• Meetings with business representatives for gathering the financial reports/ dash board Requirements.
• Performed the analysis of PBAR datamart to identify facts, dimensions and hierarchies of Dimensions.
• Created Reports in Oracle BI answers from exiting reports in Oracle Discoverer in Interactive Dashboards
• Developing multiple dimensions (drill down hierarchies), logical objects in business model layer and creating presentation catalogs in presentation layer.
• Worked on Implementing Data Level security using Rpd security group filters, session variables etc
• Implemented row wise initialization blocks to implement complex filters on the reports.
• Implemented lot of cross dimensional hierarchies to meet the business requirements
• Developed reports with Analytics View (drill down), Pivot Table, Charts, Column selector with global and local filters using Oracle BI Presentation services.
• Developed various financial Time Series Objects and reports for comparing respective Patient Billings and collections and calculating the Year ago and Month ago percentages.
• Implemented security functionality by creating users and web groups, setting External Tables
• Performance tuning of Dashboards/ Reports, creating subset tables, required changes to Repository (Aggregate navigation) and Database (aggregate facts).
• Worked on ETL OOTB customization for the EBS financial mappings.
• Worked on DAC repository and created lot of new tasks and new execution plans to handle the Loads.
• Involved in performance tuning of Informatica ETLs by tuning various informatica session parameters.

Confidential, Minneapolis

OBIEE Consultant

Environment: Informatica PowerCenter 7.x, OBIEE 10.x, Discoverer 4i/10g (9.0.4),10.1.2, PeopleSoft EPM 8.9, PeopleTools 8.48, Oracle 8i/9i/10g, Enterprise Data warehouse, Oracle Financials, SQL, PL/SQL, Forms 6i

Responsibilities:

• Worked on Metadata Modeling, created a new modified repository (.rpd) using OBIEE Admin tool.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Worked on BI Answers to build Interactive Dashboards with drill-down capabilities.
• Customized the repository and created new requests, developed custom reports/Ad-hoc queries, charts Using BI Answers Created and configured the Siebel Dashboards
• Experienced in migrating Reports from Oracle discoverer to Oracle BI answers. Setting up Delivers to configure iBots based on user requirements
• Splitting of repository projects and make it available to developers configured the database connection tool for the oracle database sources( ODBC, JDBC)
• Effectively migrating webcast, Skins and Style sheets from one server to another server by using Catalog Manager.
• Merging of repositories and migrating to multiple servers.
• Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression and Aggregator).

Confidential, NJ

Siebel Analytics Consultant

Environment: Siebel Analytics 7.5 & 7.7, nQuire, Siebel Answers, Siebel Dashboard, Siebel iBots, Windows NT, Oracle 9.2.05

Responsibilities:

• Meeting with business and technical users to understand their data warehousing data needs on a regular basis.
• Performed detailed source data analysis to determine grain and data quality characteristics
• Associated with interfacing teams from Siebel perspective to provide information on Data Mapping relating to Siebel.
• Created the new analytics reports and modified the already existing ones.
• Used conditional formatting in the reports.
• Created reports with table, pivot, ticker, filter, chart and narrative views.
• Creating filters and prompts, dashboard prompts.
• Created intelligence dashboards and mapped the Reports.
• Worked on metadata repository .rpd enhancements.
• Performed project and application level data migration and delivery that support business information requirements ensuring effective data organization and maximizing re-usability of data.
• Worked extensively with complex mappings using Expression, Aggregator, Filter, Router, Joiner, Sorter and Rank Transformations.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches of sessions and workflows.
• Provided end user support by addressing their issues.

Confidential

Data warehouse/ETL Developer

Environment: Data Warehousing, Informatica Power Center6.1, Oracle 9i, PL/SQL, Business ObjectsERWIN, TOAD

Responsibilities:

• Understanding mapping specification Documents and Business Rules
• Created Mappings, Sessions, Workflows
• Created Sequential and parallel batches, Schedule the workflows
• Performed unit Testing, Performance Tuning Test, Involved in code Review
• W rote the data cleansing scripts and also involved in Performance management issues.
• Involved in debugging the software modules developed by the team members, Involved in integration of the software modules developed by individual team members
• Creation of Bitmap indexes & Partitioned indexes for partitioned tables to maximize Performance.
• Performed Application Performance Tuning including SQL Statement Tuning using Explain Plan & Optimizer Hints etc.
• Created Mappings in Informatica Designer to extract data from Heterogeneous data sources like Oracle,

Confidential

ETL Developer

Environment: Informatica Power Mart 5.1, Siebel Analytics 7.0.4, Oracle 8i, Windows 2000, UNIX.

Responsibilities:

• Worked closely with the Business Analyst to formulate Business Requirements and assimilating the required documentation
• User interaction, requirements analysis and specifications
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations
• Analyzed the source data and decided on appropriate extraction, transformation and loading strategy
• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, and Update Strategy
• Multi source Extraction Transformation and loading into the Repository using Informatica
• Partitioned the Sessions to Improve the Performance
• Created batches to run several sessions sequentially and concurrently.

Confidential

ETL Developer

Environment: Informatica Power Center 7.1.1, Siebel Analytics 7.0, SQL Server 2000, Oracle 8i, Share Point portal, Microsoft Analysis Services.

Responsibilities:

• Siebel Analytics was used to develop standard reports on Product Line data. Client used it upfront to Manipulate data over the web for data analysis.
• Migrated flat file extracts from legacy databases into staging tables of a data warehouse (Oracle 9i database).
• Staging tables were used as source data to populate data marts.
• Four data marts were developed with up to 8 million records per mart. Warehouse Was developed to allow Incremental loading of fact tables
• Migrated flat file extracts from legacy databases into staging tables of a data warehouse (Oracle 9i database) Staging tables were used as source data to populate data marts
• Four data marts were developed with up to 8 million records per mart. Warehouse was developed to allow Incremental loading of fact tables
• Involved in design of data modeling for Fact and Dimension tables.
• Performed dimensional analysis. Created Facts and Dimensions for analytic reporting
• Performed ETL transformations in Informatica and SQL Server from relational databases to Data warehouse star schema