SUMMARY

• Having 8+ years of IT experience in Enterprise Business Intelligence and Data Warehousing.
• Experience in complete Software Development Life Cycle Starting from Requirements gathering, Proof of Concept, Design, Modeling, Development, Unit Testing, Support during QA and UAT, and Prod Deployment.
• Experience in end to end implementation of Oracle BI projects and involved in phases of project
• Experience in upgrading and configuring OBIEE 11g and working on latest version of 11.1.1.7.1 server
• Good understanding in using different views (Table, Pivot View, Chart, Column Selector and View Selector) based on Business requirements
• Experience in using Dashboard Prompts and Presentation Variables to apply dynamic filters
• Experience in managing Presentation Catalog, Dashboards and catalog groups during deployments
• Experience in configuring ODBC connections to connect to Data sources
• Experience in building three layers of metadata repository using Admin Tool
• Good understanding of using all kinds of variables (Session, Repository and Presentation) in OBIEE
• Good understanding of Dimensional Modeling techniques (Star Schema and Snow Flake Schema) in OBIEE
• Experience in creating Dimensional Hierarchies to generate Drilldown interaction in reports
• Extensive knowledge OBIEE 11g security architecture and configuring application roles and policies.
• Experience in configuring object level Security, Data Level (Row Level) Security in OBIEE
• Experience in using Go URLs to embed OBIEE content in other front end applications
• Good understanding on Cache management methodologies in OBIEE
• Experience in setting up Usage Tracking to track long running queries and performance of BI reports
• Exposure on configuring iBots in OBIEE to send alerts to user groups
• Experience in using Bi Publisher reports for generating reports in executive presentable form.
• Good knowledge on Oracle SQL (DML, DDL and Select) and Database Objects (Tables, Views, Synonyms and Materialized Views)
• Experience in writing PLSQL packages for ETL purpose
• Extensive knowledge on Oracle Database architecture and exposure on DB Admin activities
• Experience in writing Unix shell scripting that are useful for OBI deployments
• Highly motivated Team member with good communication and maintaining healthy interpersonal relationship within team

TECHNICAL SKILLS

OLAP Tools: Siebel Analytics 7.8.4, OBIEE 10.1.3.4.1 , 11.1.1.7, Discoverer

ETL tools: Informatica 8.6.1, OWB

Operating Systems: Windows XP, 2000 and Windows 2003, Unix, AIX 5.2

Languages: C, SQL, PL/SQL

Database: Oracle 10gR2, 11g, SQL Server 2008, Netezza, Essbase

QA Tools: Quality Center, Mercury load Runner

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Sr Developer

Environment: OBIEE 11.1.1.7, Oracle 10g, PLSQL

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Business Analysts and Users
• Created and customized Physical, Business Model and Presentation Layers in a Repository Using Administration Tool
• Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors
• Created different types of Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Upgraded and deployed OBIEE 10g applications in OBIEE 11g
• Extensive knowledge on OBIEE 11g security architecture and set up security by creating application roles and policies
• Used Hierarchical columns to display Manager Hierarchy in prompts and used selection steps to filter hierarchical columns
• Experience in conducting load test and performance test using Mercury load Runner.
• Configured BI scheduler to create iBots and scheduled reports to deliver to user profiles
• Granted users with appropriate access to the Subject Areas and Reports
• Implemented various Dashboard Objects like Link or Image, Embedded Content, HTML and Guided Navigation Link.
• Extensive knowledge on OBI file structures and worked on default font settings in OBI
• Implemented custom skins and styles with Confidential Logo and Banner
• Implemented the data and object level security for this application.
• Created Cache seeding and purging scripts to improve the performance with cache management
• Designed BI Ad Hoc learning documents and make available for users from Help links
• I have enabled Usage Tracking and developed usage reports to monitor certain metrics about BI report usage across LOB.
• Implemented governor settings to limit no of records and query run time in DB
• Involved in unit testing and written test scripts for this application to log defects in Quality Center.
• Experience in merging and deploying rpd and catalog deployment using catalog Manager.

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.4.1 , Oracle 10g, PLSQL

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Business Analysts and Users
• Created and customized Physical, Business Model and Presentation Layers in a Repository Using Administration Tool
• Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors
• Created different types of Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Configured BI scheduler to create iBots and scheduled reports to deliver to user profiles
• Granted users with appropriate access to the Subject Areas and Reports
• Implemented various Dashboard Objects like Link or Image, Embedded Content, HTML and Guided Navigation Link.
• Implemented custom skins and styles with Confidential Logo and Banner
• Implemented the data and object level security for this application.
• Implemented single GO Button by using Java scripts available in Blog
• Created Cache seeding and purging scripts to improve the performance with cache management
• Designed BI Ad Hoc learning documents and make available for users from Help links
• I have enabled Usage Tracking and developed usage reports to monitor certain metrics about BI report usage across LOB.
• Implemented governor settings to limit no of records and query run time in DB
• Involved in unit testing and written test scripts for this application to log defects in Quality Center.
• Actively participated in resolving defects during UAT phase by interacting with testing teams and users
• Provided production support to implement enhancements and production tickets as per SLA.
• Involved in merging and deploying rpd and catalog deployment using catalog Manager

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.4.1 , Oracle 10g, PLSQL, Unix, .Net

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Business Analysts and Users
• Worked on understanding existing .net application and underlining queries to design new data model.
• Involved in installation, configuration and administration of OBIEE10.1.3.4 and Client components
• Created and customized Physical, Business Model and Presentation Layers in a Repository Using Administration Tool
• Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors
• Created different types of Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Implemented custom skins and styles with BT Logo
• Implemented LDAP authentication and external table Authorization to grant access to catalog objects.
• Granted users with appropriate access to the Subject Areas and Reports
• Implemented Guided Navigation in Dashboard page to display sections based on conditions.
• Added OBI Report links with use of Go URL with parameters.
• Have written Unix shell scripts to use for deployments
• Improved process of deployments by streamlining the steps with use of Unix commands
• Created Cache seeding and purging scripts to improve the performance with cache management
• Involved in deploying rpd and catalog from one environment to other environment
• Provided production support after successful release of this application

Confidential

Siebel Developer

Environment: Siebel Analytics 7.8.4, Oracle 10g, PLSQL, Unix

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Business Analysts and Users
• Created and customized Physical, Business Model and Presentation Layers in a Repository Using Administration Tool
• Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors
• Created different types of Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Created iBots to identify list of customers who need renewal of different telecom services and scheduled those iBots to deliver mails to customer support teams on monthly, Quarterly and yearly basis.
• Granted users with appropriate access to the Subject Areas and Reports
• Implemented various Dashboard Objects like Link or Image, Embedded Content, HTML and Guided Navigation Link.
• Implemented the data and object level security for this application.
• Created staging tables and Materialized views in the process of ETL using PLSQL procedures
• Have written Unix shell scripts to start and stop BI services
• Involved in unit testing and written test scripts for this application to log defects in Quality Center.
• Actively participated in resolving defects during UAT phase by interacting with testing teams and users

Confidential

Junior DBA

Environment: Oracle 10gR2, Unix, PLSQL

Responsibilities:

• I have worked on creating DB objects (Schemas, Tables, Views, Materialized Views, Synonyms, Sequences, DB links)
• Worked on creating users and grant/revoking roles/privileges to those users
• Worked on increasing Table space size by adding more data files
• Worked on creating Databases and backup of Databases during support
• I have worked on cloning databases from one environment to another
• I have worked on SQL extensively (DML, DDL, Select, Grant/Revoke….)
• I have created PLSQL packages, procedures, functions, triggers to support various DBA activities
• I have involved in writing shell scripts to perform back up/cloning activities
• I have completed Oracle Certification in PLSQL and Administration during this project assignment.