SUMMARY

• Over 8+ Years of progressive experience in design, configuration, development, testing and Implementation of Data warehousing and Business intelligence Applications.
• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodologies and project management principles.
• Worked extensively in the analysis and development of Data warehousing applications using Siebel Analytics 7.x/ OBIEE 10.1.3.x.
• Experienced in creating KPI, KPI Watch lists, and Scorecards.
• Extensive experience in OBIEE, Oracle BI applications, and Siebel Analytics which includes creating, configuring, customizing and managing repository and Presentation services.
• Strong experience in developing OBIEE /Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Facts and Dimensions tables and Physical and Logical data modeling in OBIEE Administration tool.
• Hands on experience in customizing reports, filters, charts agents and conditions in Oracle Answers.
• Experienced in usage of Disconnected Analytics and Siebel/Oracle Delivers for sending alerts via intelligence agents (iBots) to the dashboards for the end users.
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL.
• Strong working knowledge in design and development of ETL Process, Data modeling for Data warehouse and scheduling DAC.
• Proficiency in security management of all aspects of OBIEE (Siebel Analytics).
• Good experience in Oracle Data Integrator 10g/11g.
• Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment using Oracle Data Integrator (ODI).
• Experienced in Configuring Oracle BI Applications (OBIA) such as Sales, Marketing, HR, and Financials Analytical Applications.
• Knowledge in extracting data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Knowledge in Data Warehousing development using ETL tools such as Informatica Power Center 8.x/7.x/6.x and developed Informatica Mappings and Workflows with Worklets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
• Excellent interpersonal and communication skills for efficient client interactions.

PROFESSIONAL EXPERIENCE

Sr OBIEE Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Worked on Agile environment to Develop rpd and Dashboard reporting.
• Participated in sprint planning and status meeting to provide feedback and progress of development.
• Participated in sprint showcase to present current development progress and provide feedback for upcoming releases.
• Worked on Oracle EBS data into OBAW using Source SDE, SIL, PLP and Custom Folders.
• Based on user requirements, DAC tasks and Informatica mappings were debugged and DAC parameters were changed to load multiple Subject Areas into Warehouse.
• Prepared Migration Documents and Performed WebCat and RPD migration to different environment.
• Participated as production support during system file migrations and patch updates ETL/DAC.
• Participated in Production migration to ensure proper migration and validated related Dashboard and Reports.
• Worked with BA and end - users to create user friendly and highly interactive dashboard.
• Managed and Configured Oracle BI Applications (OBIA) such as Sales, Marketing, HR, and Financials Analytical Applications.
• Worked on Siebel CRM Application to Develop Service Requests and Activity dashboard.
• Created CRM Service Requests and CRM Sales Analytics Dashboard.
• Worked on Multiuser Development Model to develop Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Configured Subject Area, Catalog, and Functional Area Security.
• Managed and Configured Application Roles and Application Polices.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Created and Configured Actionable Intelligence and Action Framework.
• Developed Dashboard Prompts, Presentation Variables, and Filtering an analyses using repository variable.
• Worked on Usage tracking feature to keep track of analyses and dashboards, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Involved in troubleshooting the load failure cases, including database problems.
• Implemented Security by authenticating against the LDAP and external table.
• Trained end-users how to use OBIEE functionalities and develop Adhoc reports.

Environment: OBIA, OBIEE /ODI 10g/11g, Informatica Power Center 9.1/8.6, Power Exchange 8.1, Oracle 11g, SQL, PL/SQL, TOAD, SQL Developer .

Sr OBIEE Developer

Confidential - Irving, TX

Responsibilities:

• Interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial data from one single source.
• Participated in upgrade activities and provide valuable information to CM team for successful upgrade.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Configured Interactive Dashboard with drill - down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIA, OBIEE 10g/11g, ODI 10g/11g, Informatica Power Center 9.1/8.6, Power Exchange 8.1, Oracle 11g, SQL, PL/SQL, TOAD, Erwin, MS SQL Server 2008, T-SQL, Hyperion.

Sr OBIEE Developer

Confidential, Denver, CO

Responsibilities:

• Used the OBIEE 10.1.3.3.x Administration tool to develop and enhance meta - data.
• Participated on upgrade of OBIEE form 10g to 11g.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Configured and Created repository using OBIEE Admin tool.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the sales/marketing/financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Created business reports using Siebel Answers as per requirements.
• Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
• Involved in modifications of physical, business and presentation layers of metadata repository using Siebel Analytics Administration Tool.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Defined views (chart, ticker, narrative, column selector, view selector, legend, funnel, Gauge) of the data.
• Used advanced property measures for dial and bar graphs in a Gauge view, including the details such as specifying the dial arc length and thickness manually.
• Created complex requirements like time comparisons and share measures along with ranks returned by the request to visualize data in different ways.

Environment: OBIEE 10.1.3.3/11 g, SQL Server 2003, SQL, SQL*Plus, TOAD, Informatica 8/7.1

Sr OBIEE Developer

Confidential, Malvern, PA

Responsibilities:

• Requirement gathering from Business user's /end - users and develop a layout plan.
• Work extensively for supporting and enhancements of OBIEE .
• Involved in project planning, work estimations, Architecture design and development methodology.
• Test Dashboard's functionalities and validated data before publishing reports to users.
• Customize and created permission to dashboard per employee to their responsibilities.
• Analyzed, diagnose and provide helpful insight to improve security.
• Worked extensively on OBIEE Answers to create the reports as per the Business Requirements.
• Created new reports and troubleshoot OBIEE issues at the Report, rpd and modified existing Reports, to meet new requirements.
• Responsible for unit testing, integration testing of the generated reports.
• Involved in improving the performance of the Dashboards and Reports by modifying rpd.
• Preparation of Reports standards, report templates, and prepared custom made BI solution according to the plan using BI applications.
• Work with DBAs and System Support personnel in elevating and automating successful code to production.
• Designing custom web portal architecture to display the report in web report viewer using visual studio 2010.
• Train and manage developers, advising other groups in organization on ETL development and Data Warehouse development.
• Conduct code walkthrough and reviewing and approving code and documentation for project manager review.
• Conducting weekly project meeting to analyses the technical issues.
• Provide on-call support to production system to resolve any issues.
• Version control through Visual Source Safe / Team Foundation Server.
• Object Export and Import from development to testing environment.
• Proof-of-Concept development, documentation and presentation to the client.

Environment: OBIEE, Informatica Power Center 9.1/8.6, DB2, Power Exchange 8.1, Oracle 10g/11g, SQL, PL/SQL, TOAD, Erwin.

Sr OBIEE Developer

Confidential, San Bruno, CA

Responsibilities:

• Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad - hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Managed Oracle Delivers, Scheduler & iBots.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Developed several mappings to load data from multiple sources to data warehouse.
• Developed and tested Store procedures, Functions and packages in PL/SQL.
• On-call support for any application related issues

Environment: OBIEE, Informatica Power Center 9.1/8.6, DB2, Power Exchange 8.1, Oracle10g, SQL, PL/SQL, TOAD, Erwin.