SUMMARY:

• Over 11 Years of IT experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes OBIEE 10g/11g, ODI and WebLogic server 10.3.
• Experience in leading small and medium teams and also extensive experience in onshore coordination.
• Well versed with Agile Software Process: Participated in daily scrum, Sprint planning meeting, Sprint review meeting and Sprint retrospective.
• Experience in Analysis, Design, Development, Deploying and Testing including Implementation of Business Intelligence (BI) solutions using OBIEE/Siebel Analytics.
• Worked along with business analysts, developers, management professionals and with business users from various locations of customer to gather requirements.
• Experience in OBIEE Reports and Dashboard Builder.
• Experience in Oracle BI Publisher builder.
• Experience in Converting Oracle reports in to Oracle BI Publisher Reports.
• Experience in Production Support Environment.
• Good Knowledge on Data warehousing Concepts.
• Experience in Writing and Executing the Test Cases.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Exclusively worked on OBIEE Administration (RPD) (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
• Experience in OBIE Administration, configuring MUDE, OBIEE Schedule, usage tracking. Repository Sever and Presentation Server configuration changes, Cache management, space management.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation). Exposure to version tracking control systems.
• Dedicated, conscientious individual with strong sense of responsibility, work flexibly and quickly adapt to the changing environments professionally and personally.
• Experience in installation and configuration.
• Experience in Informatica installation,configuration and Building Mappings&Maplets.
• Experience in setup usage tracking.
• Experience in data level and object level security implementation.
• Experience in Dimensional and Relational Data Modeling.
• Experience in LDAP configuration.
• Experience in OBIEE 12C Installation and Configuration.
• Experience in ODI11g/12c Installation and Configuration.
• Experience in ODI11g/12c Mapping Design.

TECHNICAL SKILLS:

Fusion Tools: OBIEE 12c/11g/10g, Confidential 7.9.6, BI Publisher,OBIA11g,Hyperion ESSBASE, Hyperion Interactive Reporting

ELT Tool: Informatica,ODI11g/12c,BO Data Services

Database: Oracle10g/9i/8i, SQL Server 2005/2008/2012.

Languages: SQL

Operating System: Windows 7/8, Windows NT, UNIX.

Database Tool: TOAD, SQL plus 11.x/10.x/ 9.x/ 8.x, SQL Developer 4.0.2.15

PROFESSIONAL EXPERIENCE:

Confidential, MOUNT LAUREL,NJ

OBIEEE Developer

Responsibilities:

• Responsible for Developing ODI objects like interfaces, packages, variables, procedures And scenarios to ensure the successful execution of the data loading Process.
• Configuration of topologies and Data servers in ODI.
• Customizing knowledge modules to ensure data load process faster.
• Loading data into Warehouse from various sources involving CSV files and Oracle, SQL SERVER
• Exporting and importing the scenarios from DEV to TEST and TEST to PROD environments.
• Responsible for Business meetings, conversion of business rules into technical design document.
• Scheduling the jobs in ODI to load data from cloud to DWH.
• Work closely with the end users and designing the documents to the track changes.
• Configure mail server and send mail notification on completion of Jobs.
• SAP BODS(ETL) to load data from oracle to SQL Server

Confidential, PHILADELPHIA, PA

OBIEE Developer

Responsibilities:

• Production support and maintenance.
• Creating Adhoc Reports based on user requirement.
• Involved in Performance Tuning.
• Security implementation.
• RPD & Catalog deployments.
• Configured Usage Tracking for Auditing.
• RPD Enhancements.
• Monitoring DAC jobs.
• Customization of Informatica mappings to load Flexi fields data into DWH.
• Involved in Patch installation.
• Involved in Report Testing.
• Software Installation.

Environment: Oracle 11g R2, Windows NT, OBIEE, DAC, INFORMATICA

Confidential, NEW YORK, NY

OBIEE Developer

Responsibilities:

• Involved in requirements gathering.
• Involved in installation and configuration.
• Designed RPD using OBIEE Administration(Physical,BMM and Presentation layer)
• Deployed rpd and catalogs using Enterprise manager.
• Creating and enhancing pivot, chart reports using BI Answers
• Utilized variables and initialization blocks in the repository
• Created new reports and dashboards as per the business need
• Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
• Worked on performance tuning of various OBIEE Reports / Dashboard
• Caching options configured and defined overall cache strategy
• Implemented OBIEE security at the data and object levels
• Created Oracle BI Publisher Reports.
• Converting Oracle Reports in to Oracle BI Publisher Reports.
• Bursting Oracle BI Publisher Reports.

Environment: Oracle Data Integrator (ODI) 11g/12c, OBIEE 11g/11.1.1.7, Oracle 11g/10g, SQL*Plus, TOAD, WinNT/7 and UNIX.

Confidential, Little Rock, AR

OBIEE Developer

Responsibilities:

• Involved in requirements gathering.
• Involved in installation and configuration.
• Deployed rpd and catalogs using Enterprise manager.
• Created new reports and dashboards as per the business need.
• Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Caching options configured and defined overall cache strategy
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Leading the team and coordinating in sharing the daily status report of the ticket status
• Monitoring the scheduled jobs.
• Weekly status reviews with the team.
• Created Oracle BI Publisher Reports.

Environment: Oracle Data Integrator (ODI) 11g/12c, OBIEE 11g/11.1.1.7, Confidential 11.1.1.7.1, Oracle 11g/10g, SQL*Plus, TOAD, WinNT/7 and UNIX.

Confidential, Newark, NJ

OBIEE Developer

Responsibilities:

• Coordinated with the on - site and off-shore team and working on service requests as team.
• Involved in designing the Star Schema.
• Involved in software Installations.
• Creating and enhancing pivot, chart reports using BI Answers.
• Used different types of prompts and filters in Dashboards.
• Imported reports into office Excel and PowerPoint
• Implemented OBI security at the data and object levels.
• Utilized variables and initialization blocks in the repository.
• Upgraded catalog and rpd from existing 10g to 11g using upgrade agent (ua).
• Creating and migrating iBots/Agents to 11g.
• Set up Act As /Impersonation in OBIEE 11g, which helps to debug end user’s production issue.
• Deployed rpd and catalogs using Enterprise manager.
• Created new reports and dashboards as per the business need.
• Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Caching options configured and defined overall cache strategy
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data in OBIEE reports and dashboards.

Environment:, Oracle Data Integrator 11g, OBIEE 10g/11g, SOA 11g, Oracle EBS, Siebel CRM, WebLogic server 10.3 and Jdeveloper 11.1.1.6.0, Oracle 10g,UNIX, Windows 2003 Server.

Confidential, Chester brook PA

OBIEE Developer

Responsibilities:

• Creating and submitting status reports to up line managements.
• Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Caching options configured and defined overall cache strategy.
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Involved in designing the Star Schema.
• Involved in software Installations.
• Creating and enhancing pivot, chart reports using BI Answers.
• Used different types of prompts and filters in Dashboards.
• Imported reports into office Excel and PowerPoint.
• Implemented OBI security at the data and object levels.
• Utilized variables and initialization blocks in the repository.

Environment: OBIEE 10g/11g, Oracle Data Integrator 11g, Oracle 10g, Siebel 8.0, UNIX, Windows 2003 Server.

Confidential

OBIEE Developer

Responsibilities:

• Involved in designing the Star Schema.
• Involved in software Installations.
• Creating and enhancing pivot, chart reports using BI Answers.
• Used different types of prompts and filters in Dashboards.
• Imported reports into office Excel and PowerPoint
• Implemented OBI security at the data and object levels.
• Utilized variables and initialization blocks in the repository.
• Created, modified and formatted requests, along with charts and filters, in OBI Answers.

Environment: Oracle 11g R2, Windows NT, OBIEE, DAC, INFORMATICA

Confidential

OBIEE Developer

Responsibilities:

• Involved in designing the Star Schema.
• Involved in software Installations.
• Creating and enhancing pivot, chart reports using BI Answers.
• Used different types of prompts and filters in Dashboards.
• Imported reports into office Excel and PowerPoint
• Implemented OBI security at the data and object levels.
• Utilized variables and initialization blocks in the repository.
• Created, modified and formatted requests, along with charts and filters, in OBI Answers.
• Utilized OBI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

Environment: OBIEE 10.1.3.4.0, Oracle 10g, OWB and Windows NT

Confidential

OBIEE Developer

Responsibilities:

• Involved in designing the Star Schema.
• Created Views and materialized views.
• Creating and enhancing pivot, chart reports using BI Answers.
• Used different types of prompts and filters in Dashboards.
• Imported reports into office Excel and PowerPoint
• Implemented OBI security at the data and object levels.
• Utilized variables and initialization blocks in the repository.
• Created, modified and formatted requests, along with charts and filters, in OBI Answers.
• Utilized OBI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users

Environment: OBIEE 10.1.3.4.0, Oracle 10g, and Windows NT

Confidential

OBIEE Developer

Responsibilities:

• Involved in software Installations.
• Involved in designing the Star Schema.
• Creating and enhancing pivot, chart reports using BI Answers.
• Created Narrative view, sectional view reports.
• Created IBOTS in order to schedule reports.
• Created Dashboards with conditional formatting.
• Used different types of prompts and filters in Dashboards.
• Imported reports into office Excel and PowerPoint.

Environment: OBIEE 10.1.3.3.2, Oracle 10g, Informatica and Windows 2000