SUMMARY

• Around Eight years of experience in IT industry involving requirement analysis, design, development and implementation, reporting tools, RDBMS and Client Server applications under different environments
• In which seven years of experience in OBIEE 11.1.1.5/10.1.3.4, Oracle BI Analytics 11g, Oracle BI Applications 7.9.4, Siebel Analytics 7.7,7.8.5 which include building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots ETL-Informatica and OWB, Reporting-Siebel Analytics, Scheduling- DAC
• Experience in Oracle Business Intelligence e-business suite with Siebel as source system
• 4 years of Data warehouse and ETL design, build, and test experience
• Implemented BI solutions for Elsevier, Citco Fund services, CSC, US Foods, New Breed Logistics, Public Service of New Mexico, QUALCOMM, State farm and other sectors for their various business processes i.e. Financial, Medicare, Marketing, Sales, Services and Customer Care, Energy etc
• Responsibility includes gathering business requirements, analysis, design, data modeling, development, Client Interaction, and Compiling Specifications from client, Modification and Testing along with Agile Methodologies
• Experience with repository development, configured metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports, Alerts, Briefing Books . Added Metadata changes to the OBI/Siebel Analytics .rpd
• Worked on Siebel Analytics features i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUDE, Variables/Initialization Blocks configuration etc.
• Extracted data from various source systems like SIEBEL CRM, Oracle EBS ,PeopleSoft, Global, Seed and Aexeo Client Databases
• Expertise in data warehouse concepts and data models included physical, logical and conceptual to implement data marts and ODS
• Hands on experience in ETL process using Oracle Warehouse Builder and Informatica Power Center for various transactions and loading data from disparate data sources
• Hands on Experience on developing and modifying Siebel OLAP database to generate the required Siebel OLAP reports
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL's and reports that are generated from Informatica and OBI/Siebel Analytics
• Extensive experience in Oracle 8i/9i/10g SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL
• Experience in writing UNIX shell scripts, SQL Loader, Performance Tuning of Database
• Excellent problem solving skills with strong technical background and good inter-personal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure

TECHNICAL SKILLS:

• Reporting/Data warehouse Tools Oracle's Siebel Analytics 11g, 10.1.3.2/7.7.1/7.5,OWB10gR1 2
• Informatica Power Center/Power Mart 9.0.1, 6.2/7.x, 8.1, SQL Loader
• Business Intelligence OBIEE 11.1.1.5, OBIEE 10.1.3.4, Siebel Analytics 7.5, 7.8
• Oracle Applications Oracle Financials E-Business suite R12/11i
• Relational Databases Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS Access
• Database Languages SQL, SQL Plus, PL/SQL, UNIX shell scripts
• Web Technologies JSP, JDBC, Java Script.
• Programming Languages C, C , Java, VB 6.0, PL/SQL
• Operating Systems Windows XP/2000/NT, UNIX, Linux
• Scheduling Tools DAC Data warehouse Access Control
• Data Modeling Tools Erwin, Power Designer, ODI

PROFESSIONAL EXPERIENCE

Confidential

Senior OBIEE CONSULTANT

• Worked on OBIEE 10/11g version upgrades and modifying the reports for different teams: Clinical Key Reporting, Info button and CK Analytics.
• Updated Logo/ Styles as per the new Clinical Services Business Intelligence name change from Shared Services Business Intelligence in the all the Environments.
• Set up MUD and Usage Tracking along with implementing caching based on Subject Area using ODBC Functions.
• Supported their Security based on External Table Authentication, LDAP authentications for their Account based Users along with Data and object levels Security.
• Migration of RPD, Web catalog from different environments using Clear Case on Monthly Basis.

Confidential

Customer Analytics

• Worked on OBIEE 11g for entire Customer Analytics reporting which includes hospitals and network info for entire clinical key area end to end implementation.
• Many to Many relationships were taken care with help of Opaque views and table views to report different Provider information.
• Variables for the last closed dates as per the specifications has been created and used in reporting.
• Have documented all Business as well as Technical aspects including testing all the functionality until deployed.

Environment: OBIEE11.1.1.7.14/11.1.1.6.12/10g, Linux, PL/SQL Developer, Windows Vista, Informatica, HPQC, Putty, AWS, clear case, FileZilla, Oracle Applications R12- General Ledger, Account Payables, Accounts Receivable, Inventory, OBIEE 11.1.1.3.0/11.1.1.5.0, OBIA/BI APPS 7.9.6.3, DAC 10.1.3.4.1, Informatica Power center 9.0.1,WebLogic 10.3.5.0.

Confidential

Senior OBIEE CONSULTANT

• Worked on OBIEE 10.1.3.4.1 version for creating the repository and generating reports for different Aexeo Development Warehouse and Risk Development Warehouse.
• Also developed and fine tuned OBIEE metadata repository using Admin Tool.
• Worked on the Baskets Functionality for Equities, options related Instruments at Client Vendor Broker and Fund Levels as per time series related report dates.
• Installations included Oracle Client, Oracle BI Enterprise Suite 10.3.4.1 on Windows Vista.
• Worked on Limits Functionality which would help users to see the trends for different Entities and their Gross Exposures, Soft Limit Values and Hard Limit Values along with references amounts and Result sets.
• Worked on end to end Development in RPD with Dimensional Hierarchies for Publishers, Instruments and other attributes, Variables both session and repository and also Logical Table Sources from different facts.
• Worked on Portfolio and Accounting Subject Area, Created users and Groups Risk and managed security at both RPD and Presentation Server Level.
• Used Partitioning and Fragmentation to model Fact based Partition and also used Expression Builder and Calculation Wizard to create calculation Measures like Positions related, Trading Related and Fund level Measures.
• Renamed and remapped tables/Views depending on the user for better performances in RPD.
• Designed and developed single Prompt set dashboard Pages including all the formatting and report changes as per the standards.
• Debugged issues for different business users from front to back end to identify both data and design related.
• Created Metadata dictionaries to support Users for Business needs related to Front, Middle Back Offices.
• Performed Design feasibilities to use variables and Oracle Functions in Write back Functionality to enable users to populate filter criteria by insert, update and delete Global Temp tables.
• Worked on session variables to populate the connections scripts to execute the queries depending on changes
• Participated in all Business User Meetings to discuss the requirements and design the data warehouse objects to further accomplish BI Solutions focused on Oracle BI Suite.
• Assisted in Migrating Reports and RPD From Local to Development Box and then to QA.

Environment: OBIEE10g, Oracle11g with RAC, Linux, PL/SQL Developer, Windows Vista, ODI11g, Aexeo Client Db, Jira

Confidential

Senior OBIEE CONSULTANT

• Worked on OBIEE 11.1.1.5 version for creating BI Publisher Reports for Fiscal Year 2014 under the Program End-Stage Renal Disease ESRD .
• Worked on the Performance Score Summary and Performance Score Certification Reports for CMS in English and Spanish Languages.
• Installing Oracle BI Publisher Template Builder for Word and configuring the data model with multiple data sets along with the parameters settings for each report.
• Created Data models for the reports including the RTF Templates, defining table styles, Paragraph styles and defining Header and Footers.
• Also Adding Translations to the style templates to support Spanish translated RTF, which involved XLIFF .xlf files for Style Templates.
• Worked with Inserting Data fields, charts and performed calculations on fields within the template along with conditional formatting.
• Worked in both connected and disconnected modes.
• Loading Data from the sample XML files and also uploading the Layout template file to the BI Publisher Catalog.
• Used Field Browser to edit, review and update to refresh the form fields added or modified.
• Configured Report General Properties including Caching, formatting, Font mapping and Currency Formats.

Environment: OBIEE 11g., Oracle 10g, PL/SQL Developer, Windows Vista, MS Word 2007, JDK 1.5,Oracle Application Server 10.1.3.1, Explorer 7.0

Confidential

Senior OBIEE CONSULTANT

• Worked on OBIEE 10.1.3.4.1 version for Merlin Reporting to Executives, Regional and Divisional Presidents for the Company and BI Analytics 11g for Cash GP
• Worked on three different projects involving different teams and different areas of company's rebranding and data from different sources
• Created Dashboards, reports, offline Briefing Books and Scheduled ibots in Delivers for Executive Summary Reporting
• Worked with the feasibilities and different approaches related to GO URL's, Guided Navigations, Aggregate Tables, Bins and Evaluate Functions based on different Time Frames
• Involved in Repository Configuration, Troubleshooting and Migrations to from all the environments LOCAL to DEV to QA to PROD and all three layers of RPD.
• Have done Business requirement gathering, understanding business objectives and analysis between Functionalities and feasibilities with the tool
• Involved in One on One meeting with SME to understand the business scenario and process flow.
• Used Filters Global and provided customized prompts to avoid excessive data showing up in the reports
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE answers to build the query
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Server Administration Tool by considering the Standards of the company
• Designed the Star Schema for all the different subject areas and build hierarchies, level-based measures, Aggregate level, Alias tables, Implicit Facts
• Used constrained filters, column filter prompts and various views such as Table View, Pivot tables, View Selector, Column selector, Chart, Narrative view
• Worked on Aggregate Tables created for different subject Areas of Pyramid Segmentation and Corp Regional Reporting Executive Summary
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository and TIMESTAMP Functions in the Answers
• Worked on data from different sources and data at different levels of granularity to build the required functionality
• Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
• Shared Knowledge in ETL processes using Informatica Power Center, PL/SQL for various transactions and loading data from various legacy data sources
• Configuring the Informatica Mappings and DAC accordingly for controlling the data set for the out-of -the box reports
• Worked with Other Teams of Reporting, Data warehouse Developers and DBA's along with the Business Analysts and BRM's for requirement Gatherings and Feasibilities, Standards and Trouble shooting with the Issues along with QA Teams in Agile Methodology.

Environment: OBIEE 10.1.3.4., Oracle BI Analytics 11g,Oracle 10g/11g, TOAD, SQL Developer, Windows XP, Linux.

Confidential

Senior OBIEE CONSULTANT

Responsibilities

• Installed and configured complete suite of OBIEE 10.1.3.4 on both Windows DEV and Linux QA and PROD environments.
• Designed the star schema in the data model Physical, Business and Presentation in the repository for Lost and Stolen Project in OLTP System by setting the Staging Tables for Reporting.
• Worked on RPD for the VZW as per the requirement changes and also with BI Answers for Reporting and Dashboards.
• Created, Copied and Moved Dashboards along with the Pages, Reports, Filters, Prompts using Catalog Manager.
• Created reports using the Pivot Tables, View Selectors, Column selectors, Guided Navigations, In-place drills in the reports, Embedding HTML links in the report columns for Dashboards.
• Worked in Creating Variables, global filters, charts, tables, global prompts. Created glossaries as a book-mark link in the reports along with combined similar requests.
• Also worked on color gauge reports on a different dashboard that helped the users to easily analyze the reports.
• Created, Edited and Scheduled BI Publisher reports as required for the Lost/Stolen Project as well as for VZW.
• Created the hierarchies, drills and level-based measures on different dimensions in the repository.
• Worked efficiently in creating the session variables and also the assigning the security groups and users. Also, worked on the data-level security to restrict the data to certain groups of users.
• Worked closely in migrating the Security Groups, Id's, Users at the time of migration along with catalog.
• Also applied the different OBI Patches both on the Windows and Linux boxes.
• Involved in migrations of the development from DEV to QA and finally to PROD environments on both Windows and Linux boxes using the version control tool called SVN.
• Worked on performance tuning on dashboard and BI Publisher reports working closely with the database developers on indexes and tuning the data in the tables with the appropriate facts and dimension measure in the tables along with the Java Bean Based Data Extraction and validations.
• Performed Unit and Regression testing on all the reports developed to maintain consistency and efficiency to meet the user's requirement.
• Involved in all the meetings and worked closely with the business analysts from both the client and end client Verizon .
• Documented all the Technical Specification Documents for VZW and Lost /Stolen Projects as well as worked with analysts for the Functional Design Documentations as well.
• Used TOAD and SQL Navigator for the database queries to resolve any data issues along with the data model changes.
• Efficiently co-ordinate with the offshore team in taking the requirements between the client and team efficiently and meeting the deadlines and the deliverables on time.

Environment: OBIEE 10.1.3.4. Oracle BI Publisher, Oracle 10g, TOAD, SQL Navigator, Windows XP, Linux.

Confidential

OBIEE Developer

Responsibilities

• Installed and configured OBIEE on Linux and Windows
• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Added Aggregate measures using Aggregate Persistence Wizard
• Enabled Usage Tracking Table and Dashboards
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and ToDate functions
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Siebel Application level
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
• Creating new measures as well as modifying the existing measures at RPD levels
• Involved in creating dimensional hierarchies to support drill downs
• Designed and Implemented the Pre Staging and Staging approach, for cleansing using Informatica ETL and Oracle Warehouse Builder 11g
• Design and developed process for Initial loads and Ongoing loads Incremental Aggregation with Extract Date concept
• Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Oracle warehouse Builder

Environment: Oracle Business Intelligence 10.1.3.4, Oracle 10g, Oracle Warehouse Builder 10g R2, Informatica Power center 8.1, Microsoft Windows Server 2003, SQL, PL/SQL, Linux, UNIX

Confidential

OBIEE Developer

Responsibilities

• Involved in the full life cycle implementation of Invoices Tracking Analytics Application used by Accounting Team to monitor the invoices made to Point-of-Sale POS customers, Commercial / Business customers and third-parties
• Involved in preparation of technical documents and end user training
• Interacted with Billing and Account Receivables Subject Matter Experts SME , Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements
• Experience in configuring the metadata in all the three layers physical, semantic and presentation layers
• Participated in the installation and configuration of Oracle BI EE 10.x in the windows as well as the Linux environment
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables in the repository
• Developed Dashboards / Reports using different Views Pivot Table, Chart and Column Selector , with drill-down and drill across capabilities, guided navigation and dashboard and page prompts
• Created dimension hierarchies aggregates and logical sources in the BMM layer
• Configured the security settings in Siebel Analytics Admin tool to setup users Groups and Access privileges
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Involved in Reconciliation Process Oracle BI Reports output with Excel Reports
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters for performing the customer insights / trends using Siebel Analytics Web
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process using Informatica and integrate to Oracle Warehouse Builder 10g R2 for reporting

Environment: Oracle Business Intelligence OBI EE 10.2, Oracle 9i, Oracle Warehouse Builder 10g R2, Toad, Teradata, Putty, Linux.