PROFESSIONAL SUMMARY:

• 7+ years of experience in Software Development and Expertise in OBIEE 12.2.1.0/1.1.1.7/ 11.1.1.6.1 1 and Informatics 9.x/ 8.x.
• Worked Extensively on Oracle BI Administration Tool, Oracle BI Enterprise Manager, Console and Analytics.
• Very good experience in designing Star & Snowflake Schema, Slowly Changing Dimensions, Facts, Dimensions tables.
• Implemented Security by creating users in Active Directory and assigning them to roles in the repository level with LDAP. Worked extensively on data level and object level security
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Developed many Reports / Dashboards with different Analytics Views (Drill - down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters) using Presentation services.
• Experience in extracting data from Oracle EBS, PeopleSoft, flat files and integration and loading data to OLAP systems.
• Experience in Extraction, Transformation & Loading of data from multiple sources to Data Warehouse using Informatica OTB mappings and DAC.
• Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
• Extensive experience with various databases Oracle 11g, 10g, SQL Server 2005/2008.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

Reporting Tools: OBIEE (12.2.1.0, 11.1.1.6.5, 11, 11.1.1.7),Oracle BI apps 7.9.6.3,4, Essbase

ETL Tools: Informatica (Power Center 9.x, 8.x)

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Operating Systems: Windows NT/XP, Windows Server 2008, UNIX, Linux

Web technologies: HTML, JavaScript, XML.

Tools: Toad, SQL*plus, DAC 10g/11g, IDQ, IDR

RDBMS: Oracle 11g/10g, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

OBIEE/Informatica Administrator

Responsibilities:

• Install and maintain OBIEE and Informatica in DEV, Test, UAT and PROD environments on Linux servers and POC servers in Windows.
• Working on OBIEE 11g to 12c upgrade project
• Installation and configuration of Informatica Data Quality (IDQ) on the Linux servers on top of Informatica.
• Installed cluster on the Informatica server as Active and Passive nodes.
• Installed cluster on OBIEE, BIP Test, UAT and PROD server for the high availability and load balancing of the users across the two servers.
• Installed and configured Informatica Data Replication tool across all the environments.
• Working extensively on Informatica Data Replication to replicate the data between the Oracle servers and also between SQL and Oracle servers.
• Tidal integration with Informatica for scheduling jobs using enterprise Scheduler instead of native Informatica schedule.
• Work extensively on the performance tuning of OBIEE and BI Publisher reports.
• Maintain PROD bi-weekly and ongoing code migrations of OBIEE, BI Publisher and Informatica across all the environments.

Environment: OBIEE 12.2.1.0/11.1.1.7, Oracle 11g, SQL developer, Windows 7, RHEl 6.2/7.2, Linux Shell Scripting, Informatica 9.6, Toad, IDR, IDQ 9.6.

Confidential, Stamford, CT

BI Apps Admin

Responsibilities:

• Install and maintain OBIEE, BI Publisher, Informatica and DAC in DEV, Test, ITC, UAT, PROD and DR environments at the corporate level on REHL Linux servers.
• Implement and maintain data level and object level security according to the business requirements in OBIEE and BI Publisher.
• Cloned the PROD with DR environment and synchronizing required Application mount points and database with repli web and perform the DR testing on monthly basis.
• Installed and maintained Essbase on all the servers
• Configured BI Apps Financial and HR Analytics OOTB modules
• Configured Single Sign On with OID and OAM
• Configured SSL and load balancing using F5 for all the UAT, PROD and DR servers
• Automated Cache Purge and disabling Parallel index on all fact and aggregate tables as stored procedure from DAC as part of post ETL Process instead of the manual activity.
• Created page redirect for OBIEE home page while doing the full ETL load and integrated as part of DAC pre and post ETL tasks.
• Worked extensively on the performance tuning of Weblogic and OBIEE Application for increasing the performance of the Balance sheet and P&L reports.
• Migration of OBIEE, Informatica and DAC both incremental and full migrations.
• Applied multiple Oracle security Patches on the OBIEE and Weblogic servers
• As a part of production support I am involved in running and monitoring of the nightly ETLs and Micro ETLs for every 3 hours at the month end close.
• Managed Security privileges for each Subject area and Dashboards according to business requirements. Implemented data level security based on Project, and Chatfield security.
• Guide and coordinate with onshore and offshore resources to complete change requests and work on migration of all the code fixes from one environment to the other after getting the approval of the business.

Environment: OBIEE 11.1.1.6.1 1, Oracle 11g, SQL developer, Windows 7, Linux Shell Scripting, Informatica 9.1 HF2, DAC 11g

Confidential, Gaithersburg, MD

OBIEE Admin

Responsibilities:

• Working on the installation and upgrade of OBIEE 10g to OBIEE 11.1.6.5 with both RPD and Web Catalog.
• Working on the installation and upgrade of Informatica from 7.1 to 9.1 hot fix2.
• Working on the installation and upgrade of DAC from 7.9.3 to 10.1.3.4.
• Upgrade BI Apps schema from 7.9.3 to 7.9.6.3
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created connection pools, and flattening of the dimension measures in the Physical Layer of the repository.
• Worked extensively on Time Dimensions combining Year and Period dimension and consolidated them into a single dimension.
• Created various Variables - Repository and Session for various Reporting requirements.
• Calculated Variance to Budget, LY and Prior Forecast values with respect to Actuals and Current Forecast.
• Designed and developed Web catalog objects - Reports/Dashboards
• Configured Web Catalog Objects (Dashboard Pages, Folder and Reports).
• Created Dashboard reports with Graphs, Pivot tables, Tickler and Narrative Views with Prompts, Selection Steps and Filters in BI Reports.
• Used attribute dimensions as the Hierarchical Prompts and used selection steps for filtering of the data.
• Configured Agents to deliver Reports content based on schedule to obtain weekly reports through email and sent notification Alerts.
• Implemented various Smart View Templates to unit test all the reports across the Essbase.

Environment: OBIEE 11.1.1.6.1, Essbase 11.1.2, Oracle 11g, SQL developer, Windows 7, Linux Shell Scripting, Siebel 8.0, OBIEE 10g, Informatica 7.1, 8.6, 9.1 Versions, DAC 10.1.3.4

Confidential, Dallas, TX

BI Apps Admin/Developer

Responsibilities:

• Install and build BI Apps completely on the Disaster Recovery environment from Production using V2V method.
• Customized the existing Analytics Metadata Repository (.rpd) using OBIEE Admin tool by adding new measures into BMM layer.
• Designed and developed Web catalog, Reports/Dashboards with different Analytics using Oracle Business Intelligence Presentation Services.
• Configured Web Catalog Objects (Dashboards, Pages, Folder and Reports).
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes .
• Implemented security by creating users and roles in LDAP.
• Extensively worked on the Informatica Power Center 9.1 tools - Designer, Workflow Manager, Workflow monitor .
• Used Informatica Power Center 9.1 to load the source PeopleSoft data into OBAW using Source dependent adaptors (SDE ORA11510), source independent adapters (SILOS), PLP and Custom Folders.
• Created custom complex Mappings which used to bring the data from MTA tables to staging tables and then to Facts and Dimensions.
• Used Deployment group for moving the mappings and sessions from one environment to another, such as from a development environment to test or production environments.
• Used DAC to configure domain values for Oracle financials like Budget, General Ledger, Journals, Payables, Receivables, MTA.
• Involved in Creating Tasks in the DAC for both new and modified Informatica Workflows.
• Created Custom Index’s in the DAC .
• Involved in Building and Running Execution Plan with the DAC .
• Performed Unit, Integration and Regression testing to validate and mapping functionality.
• Maintained extensive documentation for design, implementation and testing OBIEE Analytics requests, Dashboards.

Environment: OBIEE 11.1.1.5.0, Informatica 9.1, Oracle BI Financial Analytics 7.9.6, DAC 10.1.3.4, PeopleSoft, Oracle 11g, SQL, SQL developer, Windows 7, UNIX Shell Scripting.

Confidential, Skokie, IL

BI Apps Admin/Developer

Responsibilities:

• Complete OBIEE, Informatica installation and configuration of DAC.
• Install and build BI Apps completely on the QA, UAT and PROD environments.
• Migration of BI Apps and BIP components from Dev to QA, QA to UAT and UAT to Prod
• Running full load of data in the migrated environment initially and running incremental loads daily by scheduling the ETL process in DAC
• Responsible for security and configuration of the server machines
• Ensure that the network infrastructure is up and running.
• Prepare weekly and monthly project status reports for management
• Prepared complete design documentation for the installation process.
• Customized different OBIEE Intelligent Dashboards & Answers based on the user requirements.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• Involved in customizing ETLs for Data Extraction, and Data Conversion using Informatica 8.6

Environment: OBIEE 11.1.1.5.0, BI Publisher, Informatica 8.6.2, Oracle BI Financial Analytics 7.9.6, DAC 10.1.3.4, Oracle EBS, Oracle 10gR2, SQL, TOAD, Windows XP, UNIX Shell Scripting.