PROFESSIONAL SUMMARY:

• Over 7 years of involvement in planning, creating and execution of OBIEE 10g & 11g and 3 years in ODI 11g
• Strong experience in configuring and developing the Analytics/OBIEE Repository (RPD), which involves Schema Import, Implementing the Business Logic by customization, Dimensional Hierarchies, Utilities, Subject Areas etc.
• Experience of OBIEE 11g and also having hands on experience in OBIEE 10g in integration with BI publisher Extraction, Load and Transformation (ELT) using Oracle Data Integrator (ODI) 11g, Informatica 9.x/8.x/7.x and SQL, PL/SQL.
• Making and tweaking dashboards and reports to meet client prerequisites.
• Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers.
• Expert knowledge of report development execution in a complex environment.
• Administration of OBIEE and the OBIEE Web Catalog.
• Experience in incorporating BI Publisher with OBIEE.
• Installation, configuration of ODI in Unix/Linux environments.
• Proficient in Oracle, SQL, MS/SQL.
• Excellent relational abilities, administration aptitudes, group abilities with result arranged mentality.
• Excellent communication skills, strong architectural skills, hardworking and a good team player.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Experienced in supporting performance tuning and process tuning at all levels.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Good Exposure in dimensional demonstrating.
• Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Expertise in installing, configuring, and administering WebLogic Server in various environments.
• Implemented the extraction, loading, and transformation (EL - T) of data using Oracle Data Integrator.
• Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator and configuring the ODI master and work repositories, ODI models defining and organizing the ODI project including interfaces, packages, procedures, variables and user defined-functions.
• Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM and CKM.
• Customized versions for the existing ODI Knowledge modules which can be re-used in data integration projects.
• Expert ability to trouble shoots and prioritizes issues.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

OBIEE Infrastructure: OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g OBIEE Applications OBIA7.9.6.3, 7.9.6.1(Financialanalytics, HR Analytics, Sales, Service, Marketing)

ETL Tools: Knowledge in Informatica Power Center9.0, Informatica Power center8.6.1, DAC 10.1.3.4.1, ODI 11g

Languages and Web Technologies: SQL, PL/SQL, Java, C, C++ XML, HTML/XHTML, TOAD, SLA

ERP and Applications Servers: Oracle Applications 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.5

RDBMS: DB2 UDB (8.x and 7.x), Oracle11g/10g, MS-Access, SQL-Server 2008, Hyperion System 9 Essbase

Operating Systems: Microsoft Windows 8.x, Windows 7, Solaris 5.8, UNIX, Oracle Enterprise Linux 5.7, Mac OS X

Methodologies: Software Development Life Cycle (SDLC) -Waterfall Model, Agile Methodology, Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE:

Confidential - Westfield Center, OH

Sr. ODI/OBIEE Developer

Responsibilities:

• Gathered requirements from the customer, designed the technical specs and technical documentation, developed Interfaces and Workflows as per the business requirement, tested the application and deployed it to production.
• Built the Interfaces with ODI 11g Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored procedures
• Responsible for creating interfaces, procedures, packages and load plans using ODI and monitored the workflow run and statistic properties on ODI Operator.
• Involved in creating rules and transformation on staging tables in ODI designer and using variables in ODI like counter variables and filename variables.
• Created ODI design documents and used the documents in development of ODI interfaces and packages.
• Hands on experience for reverse engineering of databases using ODI designer tool.
• Involved in installation and configuration of ODI 11g.
• Used Topology manager to create connections to various technologies (Such as Oracle, SQL server, Flat files, XML etc.)
• Wrote conversion scripts using SQL, PL/SQL, Stored procedures, functions and packages to migrate data from SQL server data base to Oracle database.
• Wrote SQL, PL/SQL, SQL* Plus programs required to retrieve data using cursors and exception handling.
• Involved in Performance tuning for sources, targets, interfaces and sessions.
• Conducted data investigations and assisted the business partners with complex data analysis and ad-hoc queries
• Developed stored procedures, triggers, functions and complex extensively using Oracle 11g PL/SQL.
• Experienced in creating database connections, physical and logical schema using Topology Manager.
• Designed, documented and tested logical and physical data models optimized for operational and analytical reporting.
• Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.
• Used BI Publisher and created complex pivot table reports and cross-tabular reports using connected queries of data models with parameters passed from data model as well as parameters.
• Reconciled the data in the reports to tie numbers back to PeopleSoft, which was the system of record.
• Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.
• Used PLSQL Developer for running SQL queries.

Environment: ODI 11.1.1.9x/11.1.1.7 x, OBIEE 11.1.1.9/11.1.1.7, OBIA (Inventory, Sales, Bill of Material, Order fulfilment, Shipping), Oracle 11g, PL/SQL, SQL, ODBC.

Confidential - Wyomissing, PA

OBIEE/ODI Developer

Responsibilities:

• Created and developed the ODI Interface metadata mappings to extract the data from Exhibition Event Master and EBS Apps to consolidate the data into Enterprise data warehouse.
• Involved in system performance tuning to improve the performance from OBIEE report/dashboard wise and RPD.
• Designed ETL mappings for bringing in data from various data sources using ODI.
• Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix
• Developed multiple Dimensions with multiple Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer
• Designed Aggregate Tables modeled the repository for improving performance of reports.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Developed OBIEE dashboards using JavaScript and Cascading style sheets.
• Created Roles/Groups in OBIEE to provide the access to multiple departments without relying on the responsibilities.
• Integrated LDAP server in order to authenticate the users along with Native authentication. Maintained the groups in LDAP and applied the security on user level.
• Identified Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases.
• Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables
• Involved in data model designs and assisted in ETL design mappings using Oracle Data Integrator (ODI) to extract the data.
• Modify existing ETL jobs in Oracle Data Integrator(ODI).
• Develop data extracts from the data warehouse environment using ODI.
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Extensively worked on complex Interfaces which involved slowly changing dimensions.
• Created Complex procedures and used them in the interfaces to load the data to simplify the interface design. Automated the schema name using ODI interface function in procedures.
• Customized requests and modified the OBIEE Dashboard using cascading style sheets
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements
• Performed Unit, Integration, and Regression testing to validate report and mapping
• Respectively participated in weekly Project status meetings and communicated effectively with Project Managers

Environment: OBIEE 11.1.1.5.x, BI Publisher, Oracle 11g, ODI 11.1.1.9, SQL, PL/SQL.

Confidential - Mountain View, CA

Sr. OBIEE Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Created/Modified Metadata repository (.rpd), Customized BI Repository, defined/developed Physical Data Layer, Business Model & Mapping Layer and Presentation Layer using BI Administration Tool.
• Created and used Repository Variables, Session Variables, Presentation Variables and Initialization Blocks into BI Admin tool & Answers.
• Configured & managed Application role & Application Policies for Users & Users group using Enterprise manager.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed many Reports with different Analytics Views (Drill-Down, Pivot, View Selector and Tabular with Filters) using OBIEE Answers.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Using OBI EE Delivers to configure, schedule, and deliver Personalized Alerts to Intelligence Dashboards via Intelligence Agents (iBots)
• Used Different BI Publisher Templates like RTF, Excel to replicate the layouts based on sample reports provided by the users.
• Involved in the upgrade done for OBIEE and ODI.
• Worked closely with Users and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.
• Assembled subject areas and created execution plan and accommodated the new ODI mappings.
• Developed data extracts from the data warehouse environment using ODI. Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Worked extensively on OBIEE Skin & Branding as per client requirement.
• Created schedules to seed and purge cache for cache management.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Migrated Development RPD to the QA and Production environment and used Catalog Manager to migrated catalog files like Dashboard, Reports and other object from one environment to the other environment.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.

Environment: OBIEE 11.1.1.7.x, BI Publisher, ODI 11.1.1.9.x, OBIA 7.9.6.4, Oracle EBS R12, Oracle Database 11.2.0.4, SQL Developer, Linux 6.0

Confidential - Austin, TX

Sr. OBIEE Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Worked as production support for the various reports/Dashboards. Provided performance-tuning queries.
• Helped refine and determine feasibility, correctness, and completeness of end-user’s requirements.
• Developed high level design documents for reporting and analysis projects.
• Designed Data Mart using Dimensional Data Modeling using ETL tool.
• Configured and installed Data Warehouse Administration Console (DAC).
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Dimensional hierarchies, Aggregation to meet client requirements.
• Built Business model and established relationships, created joins& Foreign Keys Physical & Logical between tables. Created Time-series function.
• Created business reports using BI Answers as per requirements.
• Utilized OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, and Security…. etc.).
• Used existing data from Hyperion Essbase for analysis.
• Generated various Analytics Reports using global and local filters.
• Integrated BI Publisher with OBIEE. Created Excel Templates such as Shareholder’s Equity report, Reports such as Deposits over quarter/year in BI Publisher.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards at object level and data level security according to user requirements.
• Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Compared data from Hyperion Essbase with the OBIEE for data validation.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Monitoring Incremental & Full load through DAC. Performance tuning done to all jobs.
• Worked in Multi User Development Environment (MUDE).
• Migrated to production environment after successful testing is done.
• Trained End Users and Pilot Users about OBIEE Tools.
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS.

Environment: OBIEE 11.1.1.7, OBIEE Financial Analytics 7.9.6.1, Essbase 9, Oracle EBS R12.1.1, Informatica 8.6, DB2 UDB (8.x and 7.x), Oracle Enterprise Linux 5.7, Windows Server 2003, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Analyze, Design and Developed OBIEE Metadata repository (.rpd) that consists of physical layer, multiple business model / layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders, external table security using session variables, test and validate the model using Siebel Analytics Server Admin tool.
• Designed Star Schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Organize presentation layer in a format that is easy for end user to use as basis for reporting using Oracle BI Administration tool (.RPD).
• Used Optimization Techniques and Database hints to improve the query performance and better reporting.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Configured iBots using Delivers to seed server cache and send requests to dashboards as Alerts.
• Customized Activity and Revenue star schemas.
• Deployment of the OBIEE RPD to the BI Presentation Services.

Environment: OBIEE 11.1.1.5/6, OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Informatica 8.6, SQL Server 2005, Oracle 10g/11g, SQL, TOAD, Windows XP