SUMMARY

• Over 7 years of extensive IT experience in complete life cycle projects from requirements gathering to implementation and post production support of enterprise reporting solutions
• Oracle certified OBIEE 11g Implementation specialist
• Extensively worked on DW/BI projects in various domains like Sales, Healthcare, Pharmaceuticals and Finance with OBIEE 10.1.3.x and 11.1.1.x .
• Expertise in data warehousing such as dimensional modeling, star and snowflake schemas, fact and dimension table identification, ETL process and mapping OLAP data to meta data
• Expertise in developing Custom Reports, Dashboards. Expertise in migrating from one environment to other.
• Extensive Experience in creating and configuring RPD(all three layers),Guided Navigation, creating level based measures and hierarchy objects using Administration tool
• Strong experience in Security Setup at both Object level and Data level, LDAP authentication setup
• Strong experience in Cache management techniques and cache seeding using agents
• Expertise in tuning performance by utilizing aggregate tables, caching, setting query limits..etc
• Experience in setting up Usage tracking and configuration of multi - user development environment.
• Experience in working with BI publisher to create custom reports
• Experience in developing mapping using Informatica (ETL) and DAC
• Extensive experience in writing SQL queries
• Extensive experience in MS-Office suite products i.e. MS-Access, MS-Excel, PowerPoint
• Excellent analytical skills and ability to identify problems and develop and implement solutions.
• Excellent communication skills and an outstanding team player
• Expertise in providing end to end business intelligent solutions

TECHNICAL SKILLS

BI Tools: OBIEE 10.1.3.x/11.1.1.x,OBIA 7.9.6.3, BIP 10g, Oracle 11g/10G/9i/8i

Languages: PL/SQL, SQL

ETL Tools: Informatica 9.0.1/8.6, DAC

Db Tools & Technologies: TOAD 8.0, SQL Developer

Operating Systems: Windows 2003/2000/NT, Windows 98/95, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Baskin Ridge, NJ

Senior OBIEE Developer

Responsibilities:

• Worked on rpd (Repository) with multiple data sources like Essbase cube, oracle database.
• Implemented security privileges on subject areas, dashboards and reports as per data security requirements
• Responsible for the support of OBIEE reports, implement change requests (CR) and work requests (WR) to modify existing reports or to create new
• Worked on multiple projects simultaneously. Created several POCs in dev. to get user response.
• Supported and enhanced the performance of dashboards and reports by the optimizing cache functionality
• Created agents for automated delivery of reports and to generate cache entries, Created several KPIs to provide users with more effective vision of data.
• Performed testing on existing reports using SQL Developer.
• Responsible for all day to day production issues and their resolution
• Worked in a SDLC environment for migration of web catalog and rpd from test environments to Production
• Worked with users to help them using the SA for adhoc reports and provided them with the required documentation

Environment: OBIEE 11.1.1.7,Unix/Linus, Essbase11, Oracle 11g, MS SQL Server Quality Center10, SQL Developer

Confidential - Hopewell, NJ

Senior OBIEE Developer

Responsibilities:

• Responsible for end to end project implementation and deliverables
• Gathered business requirements and created efficient high level and detailed level design documents
• Responsible for developing repository(.rpd), dashboards, reports and security settings
• Developed reports with different analytics views i.e. drill-down, pivot table, chart, column selector, global and local filter and various report prompts. Developed several agents.
• Implemented guided navigation and cache to improve the performance of dashboards.
• Resolved production issues timely and provided users with explanation
• Responsible for migrating rpd and catalog from one environment to other.
• Conducted user training in class room and desktop formats
• Used Catalog manager to manage dashboards and answers
• Coordinated with business users, senior management and offshore development team

Environment: OBIEE 11.1.1.7, Oracle 11g, HR Analytics, Quality Center 10, Toad

Confidential, Iselin, NJ

OBIEE Consultant

Responsibilities:

• Responsible for interacting with business users to identify KPI requirements and business requirements for BI reports
• Extensively used BI Administration Tool for customizing and modifying the(RPD), Physical, Business Model/Mapping and Presentation layers of metadata repository, Modified presentation layer dimensions and attributes to match user requirements
• Performed ETL procedure to load data from different sources into data warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor using Informatica 9
• Worked on DAC (Data Warehouse Administration Console) for customizing data warehouses, creating tasks, scheduling the execution plan for ETL incremental loads.
• Address many to many relationship problem using bridge table, Experience in creating time series measures
• Developed level based measures at different levels of dimensional hierarchies
• Tested and Validated the repository before making it available for the users
• Optimized query performance using Aggregate Navigation, Caching, setting query limits, turning off log levels and by pushing calculations to the database
• Set up user/role Access privileges using identity manager functionality in oracle BI Admin tool
• Developed Dynamic/Interactive dashboards with drill down capabilities and dynamic dashboard prompts to zoom into particular segment of business in a performance optimized manner
• Extensively worked on Answers and developed different Reports using presentation variables, global and local filters, charts and graphs
• Created dashboards using key performance indicator (KPIs) such as employee headcount, employee turnover, employee on boarded etc.
• Provided scheduled reports such as headcount report on a predefined basis for CEO, Head of business units (head count of their units), Created scheduled weekly reports for compensation and benefits team.
• Used Catalog manager and maintained the Analytic web catalog to manage Dashboards and Answers
• Tested various KPIs using KPI watch lists in dashboards
• Developed agents for delivering reports through email to the users.
• Provided trainings for the end users to help them using the applications and creating the delivery devices

Environment: OBIEE 11.1.1.5, Oracle 11g, Informatica9.1, DAC, HR Analytics, SQL Developer, Toad, Quality Center10

Confidential, Wilmington, Delaware

OBIEE Developer

Responsibilities:

• Create Functional (FRS), Technical design doc (SDS), Perform data mapping between reporting requirements and Oracle OLTP
• To handle dynamic scenarios and providing data level security, created repository, system and non-system session variables and initialization blocks for various reporting needs.
• Specified dimensional hierarchy, aggregate levels for the dimensions and created level based measures, experience in creating time series measures
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Developed (RPD) Physical Layer, Business Model & Mapping and Presentation Layer using OBIEE Administration Tool.
• Involved and developed various steps to improve the performance of the queries used in the Reports by having Aggregate tables
• Interact with Business Owners to know Dashboard/Reporting requirements, Design & Develop Dashboard/Subject Areas
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include sales executive, sales manager, sales representatives
• Developed 5 New Dashboards and 22 Dashboard pages. And configured column and Object level security for each dashboards, pages and reports.
• Developed reports with different analytics views i.e. drill-down, pivot table, chart, column selector, global and local filter and various report prompts for performing the sales trend analysis.

Environment: OBIEE 10.1.3.X/11.1.1.5,Oracle 11g, SQL Developer, Toad

Confidential, Piscataway, NJ

OBIE Developer/Reports Developer

Responsibilities:

• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the user specifications
• Developed custom reports/Ad-hoc queries and assigned them to application specific dashboards.
• Providing manager with reports using pivot table and column selector that allows him to analyze the business from different perspective
• Expertise in using several OBI reporting features(i.e filters, drill-down, drill-across, prompts)
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables for financial data modeling
• Created dynamic dashboards using dashboard prompts and filters to avoid excessive data showing up in the reports, provided ad hoc reporting as per the business requirement
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Created proactive agents/ iBots to alert the users about business changes.
• Build test cases and tested the reports by comparing the SQL output on the data warehouse to the values in the reports, documented the results.
• Worked closely with DBA and data modelers for all the database related issues
• Maintained the existing repository and used expression builder in BMM layer as required
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

Environment: OBIEE 10.1.3.X, Oracle9g/ 10g, SQL Developer

Confidential, Princeton, New Jersey

OBIEE Developer

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understanding the current requirements and Data Analysis.
• Developed Repository for OLAP data source into OBIEE Administrator tool.
• Closely monitored user reports performance and query counts using Usage tracking.
• Effectively managed ODBC connections and connection pools and imported the Physical tables, keys
• To solve many to many relationship problem, used bridge tables
• To provide data level security created session variables and initialization blocks
• Optimized query performance with the help Aggregate table, log level, using cache seeding
• Identified the granularity level of the data required to be available for the analysis
• Proficient in creating ad-hoc reports by using Pivot table, Chart, Narrative Views, Graph etc.
• Designed Prompts, multi-select dashboard as per specifications.
• Administered NQSCONFIG.INI file according to the Business requirements.
• Involving in Unit Testing, Validating Reports and Production support.
• Worked in Standalone and clustered environments of OBIEE environment.
• Provided end user with training and proper documentation to understand the application