Profile

• 8 years of IT experience
• 6years of Informatica and OBIEEExperience

Experience Summary

• OBIEE:Worked on OBIEE 11.1.1.7.0,OBIEE 11.1.1.6.2 and OBIEE 10.1.3.4.1 application implementation.
• Worked on OBIEE 10g to OBIEE11g migration.
• Excellent analysis, design and development of business applications using OBIEE, InformaticaandDAC.
• Competent technical knowledge on end to end process of Business intelligence, Data warehouse OLAP Analytics server architecture-Analytics application development.
• Involved in estimations for new and enhancement requests from client.
• Extensively worked with Administration Tool to customize the RPD in all the Physical, BMM and Presentation Layers.
• Expertise in ETL tool InformaticaPowerCenter9.5.1, 9.0.1, 8.6.1,8.1.1 and 6.2.2 and intense development knowledge using and Oracle 10g and 11g.
• Experience in improving reports performance by implementing Table-level partitioning.
• In depth knowledge of Dimensional modeling.
• Knowledge of Endecca Big Data tool.
• Prepared andexecuted Unit Test Planand Implemented/tested Incremental ETL thoroughly.
• Good experience in preparation of F.D.D Functional Design Documents , T.D.D. Technical Design Documents from F.D.D.
• Installed and configured OBIEE.
• Good understanding of RDBMS and Data warehousing concepts job scheduling, indexing, and ETL and OLAP processing and Software Development Life Cycle SDLC .
• Excellent verbal communication and interpersonal skills.

Technical Skills:

Professional Experience

Confidential

OBIEE Technical Consultant

Responsibilities:

• Involved in discussions with Client for understanding the BI requirements.
• Defining hi-level design for new business requirements and completing the development work for the same. OBIEE RPD, ETL design included as part of this.
• Tracking the SIT defects to closure.
• Implemented Job Code history and Org Code history using Informatica.
• Mapped Org Code history to existing OBIA Fact table.
• Created new execution plans in DAC for UT and SIT.
• Merged new EP with OBIA EP and created custom EP in DAC.
• Incremental migration of DAC/OBIEE and Informatica Code across dev., test and production environments.
• Merge new RPD contents onto EnterpriseBIAnalyticsappsRPD.
• Created IBots.
• Create new dashboards per requests.
• Set up permissions on Catalo objects.
• Start/Stop Hyperion Services.
• Resolve errors reported through Team forge application on Hyperion Suite apps.

Environment:OBIEE 11.1.1.5, BI Apps 7.9.X, DAC 10.1.3.4.1, Informatica PC 9, Oracle 11g, SQL Developer, SQL, Toad 10.1,UNIX., Hyperion EPM 11.1.2.1

Confidential

OBIEETechnical Consultant

Responsibilities:

• Involved in implementing different KPIs required by Sales and Service teams.
• Creation/customization of star schemas and Business Metrics in RPD as per customer requirements.
• Defining hi-level design for new business requirements and also drafting and building technical portion of the same.
• Design and monitor the ETL jobs which will load the data from OLTP to OLAP.
• Estimation of the work requirements provided by the Business.
• Development of Subject Area specific to client requirements.
• Repository configuration using OBI Administration Tool.Worked with Physical, Business model and Presentation Layer.
• Supported Sales and Service Analytics as part of AMS team.
• Involved in Unit testing of the metrics created in BMM Layer.
• Creation of new dashboards/reports per business requirement.
• Customization of Analytics dashboard Skin and Styles.
• Created Action Links on BI Content and Siebel CRM.
• Assign permissions at dashboard/report level.
• Enabled usage tracking of OBIEE
• Used usage tracking reports to track down the queries executing for long and worked on performance tuning of the same.
• Merge new RPD contents onto EnterpriseBIAnalyticsappsRPD and deploy RPD through Enterprise Manager.
• Create/Clone Application Roles and associate with the Groups of BISQLprovider.
• Configure SSO Logon and Logoff URL's.
• Applied patches 11.1.1.6.2 and 11.1.16.5 to deal with the bugs reported in 11g.
• Monitoring Informatica ETL jobs Scheduled through DAC.
• Hot fix of failed tasks and re-queue with the execution plan in progress.
• Add new users In Weblogic Default authenticator for debugging the issues.
• Start/Stop OPMN Components thru EM and UNIX Command prompt.
• Start/Stop Weblogic Server.
• Set up schedulers in DAC.

Environment:OBIEE 11.1.1.6.2, BI Apps 7.9.5, DAC 7.x, Informatica PC 8.1.1, Oracle 11g, SQL Developer, SQL, PL/SQL, Toad 10.1,UNIX.

Confidential

OBIEE Tech Lead

Responsibilities:

• Installed OBIEE 11g version on 64 bit windows, upgraded 10g RPD and Webcat.
• Upgrade of OBIEE 10.x RPD and Presentation Catalog to OBIEE 11.x.
• Worked on fixing issues with the upgraded OBIEE 11.x reports.
• Merged new RPD, Dashboard and Answers requests from other areas in the organization with enterprise OBIEE content and migrated RPD, Web catalog and other customization related content across environments
• Changed the configuration settings of BI Server and Presentation services based on requirements.
• Enabled Usage Tracking through Enterprise Manager.
• Created custom Reports in Usage tracking.
• Performed Data Validation of data in the reports, Fixed the errors and warnings in the repository and web catalog.
• Worked on Cache management of OBIEE 11.x, to improve the overall system performance.
• Upgraded the Informatica repository from Informatica 8 to 9.
• Customization of DAC execution plans in the new environment.
• Prepared test cases to test the OBIEE 11.x upgrade.
• Performed Unit, Integration and Regression testing to validate OBIEE 11.x reports and Informatica mappings.
• Participated in security design of OBIEE 11.x system.
• Prepared GO-LIVE checklists for Hyperion IR, OBIEE 11.x and Informatica 9.x.
• Co-ordination with various teams at onsite and offshore on development activities.

Environment:OBIEE 11g, Informatica Power Center 9.x,DAC, Oracle 10g, Oracle 11g, Windows 2008 Server.

Confidential

OBIEE Tech Lead

• To design and implement a data warehousing solution to capture historical badge swipe data across all facilities of the organization.
• To design and implement an OBIEE dashboard for building utilization reporting metrics.
• To integrate the head count data from HR analytics into CRE space for better Real Estate planning and management

Responsibilities:

• Design and development of Badge Swipe Data warehouse using Informatica for Corporate Real Estate needs of the Organization.
• Involved in the reporting solution development for Building Utilization Analytics using OBIEE 10.x.
• Integrated HR Head Count Data with CRE analytics using Informatica ETL and OBIEE for real estate planning and management.
• Designed the ETL process using Informatica tool to load data from source SQL Server database to target Oracle Database.
• Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. And used Workflow Monitor to monitor the performance of the Jobs.
• Created DAC ETL execution plans.
• Developed OBIEE Dashboard for CRE Building Utilization Metrics.
• Customized OBIEE Dashboard look and feel as per business requirements.
• Worked on Cache management for the new development.
• Worked with Control M team for scheduling data warehouse Jobs

Environment:OBIEE 10.1.3.4,10.3.3.x, Informatica Power Center 8.6, Oracle 10g, Oracle BI Apps 7.9.X, DAC,MS SQL Server 2005, Toad, Windows NT

Confidential

Informatica Lead

Responsibilities:

• Impact analysis of People Soft HR transactional system version upgrade from 8 to 9 on OOTB Informatica ETL and OOTB OBIEE HR Reports and Hyperion IR reports.
• Prepared system requirement, design and test case documents for the remediation of Hyperion IR, OBIEE reports and Informatica ETL.
• Worked on remediation and regression testing of Informatica code, HR OBIEE and Hyperion IR reports.
• Designed the ETL process using Informatica tool to load data from source to target Oracle Database for new requirements in Recruiting and HR space.
• Developed mapping and sessions using Informatica power center for data loading.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. And used Workflow Monitor to monitor the performance of the Jobs.
• Customized DAC ETL execution plans according to the new ETL process developed.
• Customized the Physical, Business and Presentation layers using Oracle Business Intelligence Administration tool.
• Configured the security settings in Oracle Business Intelligence Administration tool to set up groups, access privileges and query privileges.
• Used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Merged new RPD, Dashboard and Answers requests with existing OBIEE content and migrated RPD, Web catalog and other customization related content across environments
• Changed the configuration settings of BI Server and Presentation services based on requirements.
• Created indexes on backend database tables to enhance report performance.

Environment:OBIEE 10.1.3.4, InformaticaPowerCenter 8.1.1, Oracle 10g, Hyperion IRS 9.x

Confidential

BI Developer

Responsibilities:

• Involved in writing SQL queries to acquire data from various source systems.
• Creation of DDL's for specific business requests and changes.
• Designed the ETL process using Informatica tool to load data from source to target Oracle Database.
• Developed mapping and sessions using Informaticapowercenter for data loading.
• Performance enhancement to Informatica code and ensuring the early completion of related Jobs.
• Monitoring and ensuring successful completion of Informatica Production jobs.

Environment:InformaticaPowerCenter, Oracle 9i, Sybase ASE 12.x, Hyperion IRS

Confidential

BI Developer

Responsibilities:

• Analysis of the existing reports and writing SQL queries to cater new report requests.
• Developed ad-hoc reports using SQL's.
• Created stored procedures on Sybase to implement complex report requirements.
• Involved in performance tuning of the report queries.
• Preparing SQL's for unit testing. Involved in the development of Data Models in BQY documents, pivot charts, creating and analysing reports. Developed reports and Dashboards as per business requirement.
• Migrated Non Unicode BQY files to Unicode.
• Monitoring the production Hyperion server and ensuring the successful completion of Jobs.
• Monitoring Jobs in Informatica production.
• Provided technical guidance and support to end-users by developing documentation required.

Environment:Informatica Power Center, Oracle 9i, Sybase ASE 12.x, Hyperion IRS

Confidential

Hyperion BI Developer

Responsibilities:

• Prepared SQL queries to acquire data into Hyperion Essbase Database.
• Outline Creation based on the business requirements.
• Created Dimension build rules for building the dimensions in the outline.
• Created Load rules for data to move from Warehouse to Essbase cubes.
• Loaded data from External data source into existing Hyperion Essbase OLAP server database.
• Migrated Essbase cubes from development to production.
• Monitor and support ETL processes and ensuring successful completion.
• Generated reports using BRIO.
• Monitoring the production Hyperion report server and ensuring the successful completion of Jobs.

Environment:Hyperion Essbase 7.x, HIRS 7