We provide IT Staff Augmentation Services!

Siebel Analyst Resume

Titusville, NJ

SUMMARY:

  • 10+ years of total IT experience.
  • 7+ years of experience in Business Intelligence using Oracle Business Intelligence (OBIEE).
  • Experienced in Oracle Financial module of Business Intelligence Applications.
  • Expertise in Building Executive Dashboards using Oracle Presentation Services in OBIEE.
  • Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
  • Experience in translating user requirements into functional, technical and system specifications.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
  • Strong aptitude for learning and understanding business process and needs.
  • Experience in multiple SAP Modules including FI/ Confidential, FI-AP, FI-AR, FI-AM, and Procure to Pay modules.
  • Experience with setting up new audits, updating key data elements, facilitating validation testing review and sign-off in GRC.

TECHNICAL SKILL

SBI Tools: 10g 10.1.3.4.1 / 11.1.1.3.0 /11 g 11.1.1.5.0 / 11.1.1.6.0 / 11.1.1.7 (Oracle BI Administration, Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Delivers, Oracle BI Publisher, Catalog Manager), SAP ERP 6, SAP R/3, SAP GRC

Databases: Oracle 10g/11g

Languages: SQL, PL/SQL

Operating System: Windows XP/ NT/95/98/2000

SQLTools: SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Lead Developer

Responsibilities:

  • Lead coordination effort to understand the underlining data mart structure for successful OBIEE repository build requirements.
  • Collaborate with other strategic functions to and leadership groups across the org
  • Ensure on time delivery of monthly project sprints
  • Develop and manage project plans with key assignments, priorities, and responsibilities
  • Facilitates project meetings, sets agendas, and documents any notes or action items
  • Translate end user reporting requirements to an optimal performing OBIEE RPD model.
  • Coordinate in the daily operations, configuration and maintenance of the (OBIEE) repository
  • Work in the three layers of the Admin tool (Physical, Business Model and Mapping, and Presentation layers)
  • Responsible for federating disparate data sources in the logical layer.
  • Import metadata into physical layer per business requirements.
  • Create derived tables, level-based hierarchies, and dimensional modeling in the Business Model and Mapping layer.
  • Create reports with different views using OBI analytics.

Environment:: OBIEE 11g version 11.1.1.6.0, 11.1.1.7 BI Publisher 11g, SQL Developer, Windows-7.

Confidential,Seattle, WA

Senior Consultant

Responsibilities:
  • Successfully analyzed business requirements, in order to answer business questions.
  • Assess Technology Risk Management Audit, Business Continuity Planning / Disaster Recovery Audit,
  • Perform Systems Development Life Cycle Audits.
  • Worked in the three layers of the Admin tool (Physical, Business Model and Mapping, and Presentation layers)
  • Created Alias tables, star schemas within the physical layer.
  • Imported metadata into physical layer per business requirements.
  • Created derived tables, level-based hierarchies, and dimensional modeling in the Business Model and Mapping layer.
  • Used cache purging to get rid of stale cache once data in database was refreshed.
  • Created Reports with different views using OBI analytics.
  • Extensive use of filtering to limit data display in reporting.
  • Used enterprise manager, and Instance config file to configure Presentation services.
  • Used BI Scheduler to deliver reports to various destinations in multiple formats.
  • Used java scripts within agents to deliver reports to required destinations.
  • Performed Test of Design Effectiveness (TOD) and Test of Operating Effectiveness (TOE) for controls, formally documenting testing lead sheets, procedures, results, conclusions, and tick-marking supporting evidence for SAP clients

Environment:: OBIEE 11g version 11.1.1.6.0, 11.1.1.7 BI Publisher 11g, SQL Developer, Windows-7.

Confidential,Philadelphia, PA

Senior Consultant

Responsibilities:
  • Successfully analyzed business requirements, in order to answer business questions.
  • Migrated Oracle discoverer Data to Oracle Business 11g for the GAO
  • Migrated the EUL by exporting it to an EEX file
  • Ran the utility to convert to Oracle 11g
  • Enabled the repository using Enterprise Manager
  • Migrated Federal EBS Financial Reports from Discoverer workbooks to OBIEE 11g using report SQL
  • Created analysis using direct database request
  • Built OPAQUE views in .rpd using Discoverer SQL and thereafter building new tables and columns.
  • Assess Technology Risk Management Audit, Business Continuity Planning / Disaster Recovery Audit,
  • Perform Systems Development Life Cycle Audits.
  • Worked in the three layers of the Admin tool (Physical, Business Model and Mapping, and Presentation layers)
  • Created Alias tables, star schemas within the physical layer.
  • Imported metadata into physical layer per business requirements.
  • Created derived tables, level-based hierarchies, and dimensional modeling in the Business Model and Mapping layer.
  • Used cache purging to get rid of stale cache once data in database was refreshed.
  • Created Reports with different views using OBI analytics.
  • Extensive use of filtering to limit data display in reporting.
  • Used enterprise manager, and Instance config file to configure Presentation services.
  • Used BI Scheduler to deliver reports to various destinations in multiple formats.
  • Used java scripts within agents to deliver reports to required destinations.
  • Extensive use of conditional formatting to color columns according to business requirements.
  • Successfully used report cosmetics to produce great reports per business requirements.
  • Created users and groups, and assigned appropriate permissions to see data within reports and dashboards.
  • Experience working with BI system components, and query logs, when there are problems in the environment.
  • Tested and Validated the Repository by using consistency checker to check for errors, warnings, and best practice violations.
  • Worked well with QA team to test Rpd and Webcat before putting them into the production environment.
  • Involved in full installation and configuration of Oracle Business Intelligence Enterprise Edition (OBIEE 11g).
  • Actively engage meetings with management and raise salient points that add to meaningful discussions around the audit findings, recommendations and reports
  • Assist in Fraud investigations
  • Conduct Government Contractor compliance investigations
  • Perform Government Billing Audits
  • SAP Consulting (Security, FI/ Confidential, FI-AP, FI-AR,FI-AM, Procure to Pay

Environment:: OBIEE 11g version 11.1.1.6.0, BI Publisher 11g, SQL Developer, Windows-7.

Confidential,Wilmington, DE

OBIEE Reports Developer

Responsibilities:
  • Interacted with Users, and team members to successfully examine the business' functional and technical requirements.
  • Successfully analyzed business requirements, in order to answer business questions.
  • Developed various Reports using Analysis, Interactive Dashboards (Dashboards/ Dashboard Pages), with different Analytics Views (Pivot Tables, Charts, Narrative Views) using Analytics from the Presentation catalog.
  • Created Dashboard Prompts and Variables to make reports more dynamic.
  • Used KPIs and Scorecards to improve corporate profitability and increase customer satisfaction.
  • Used Conditional formatting in Tables and Charts, per business requirements.
  • Created/modified Metadata repositories per business requirements, using the Admin tool.
  • Created Aliases, Dim Tables, and Dimensional hierarchy modeling.
  • Created star and snowflake schemas per business requirements.
  • Successfully did dimensional modeling, Time series modeling, and created derived Tables, dimensional Hierarchies, per Business requirements.
  • Created Derived Logical Column calculations (Month ToDate gross profit/Month Ago Sales/Year to Date Sales) in the BMM layer.
  • Created Level based measures (Monthly/Yearly sales, Regional sales), per business requirements.
  • Expertise in troubleshooting when consistency checks show errors.
  • Trained in BI Publisher Standalone 11g as well as Integrated with OBIEE 11g, to answer business questions.
  • Configured Data sources and Data models in order to create sophisticated Graphs and Tables, and use filters, parameters, LOVs to make reports more dynamic.
  • Delivered user documents via PDF, Excel, Word, HTML output formats to various destinations like: Printer, Fax, and E-mail per business requirements.
  • Applied Cache management techniques and aggregated tables to maintain and enhance query performance.

Environment:: OBIEE 11g version 11.1.1.5.0, BI Publisher 11g, SQL Developer, Windows-XP.

Confidential,Titusville, NJ

OBIEE Developer

Responsibilities:
  • Interacted with Management, Users and Data analysts, and examined the business, functional and technical requirements.
  • Created Repositories using BI Administration tool by importing tables into the Physical layer and created the Business and Mapping model to in corporate the business logic.
  • Developed various Reports using Analysis, Interactive Dashboards with different Analytics Views (Pivot Tables, Charts, and Narrative Views)
  • Used both the BI Publisher Standalone 11g and Integrated with OBIEE 11g to answer business questions.
  • Configured Data sources and created Data models per business requirements.
  • Created sophisticated Graphs, Tables, and used filters, parameters, LOVs to make reports more dynamic.
  • Created Time series calculations (for example, Month to Date gross profit/Month Ago Sales/Year to Date Sales).
  • Created Alias and Dim Tables to enable Dimensional hierarchy modeling and repetitive use of tables.
  • Created Level-based measures per business requirements.
  • Configured Security by creating Users & Groups, and setting up their permissions to see certain data.
  • Expertise in troubleshooting when consistency checks show errors.
  • Created Prompts to filter interactive Dashboard Data
  • Successfully installed the OBIEE 11g versions 11.1.1.3.0 and 11.1.1.5.0 .
  • Applied Cache management techniques and aggregated tables, to maintain and enhance query performance.

Environment:: OBIEE 11g versions 11.1.1.3.0, and 11.1.1.5.0, BI Publisher 11g, SQL Developer in Windows-7.

Confidential,Philadelphia, PA

OBIEE Developer

Responsibilities:
  • Set up meetings with the Users to quickly establish relevant business requirements for the business.
  • Created/Modified Metadata repository (.rpd) by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers.
  • Designed, debugged and optimized the OBIEE/Siebel Analytics RPD / Dashboards / BI Publisher Reports.
  • Successfully configured Data Sources before creating BI Publisher Reports.
  • Used SQL to join Fact tables to Dimension tables in BI Publisher.
  • Used Filters, Parameters, and List of Values (LOVs), to make business Reports more dynamic.
  • Used iBots in alerting production managers resulting in quick and proactive decision making.
  • Worked closely with Business Analyst, discussed and gathered the Business requirements from different user groups.
  • Created Star and Snowflake schemas in the repository as well as using the new foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer.
  • Analyzed and validated the business model using the Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the BMM layer.
  • Set up Security to authenticate users and assign appropriate permissions per business requirements.
  • Used Filters and Prompts appropriately to avoid excessive data showing up on reports.
  • Created pivot tables allowing managers to analyze the business from different perspectives and in an orderly summarized manner.
  • Created reports and Dashboards and appropriately assigned permissions to users and groups to view these reports.
  • Actively trained users so that they could efficiently navigate the dashboards.

Environment:: OBIEE 10g 10.1.3.3.1, Oracle 10g, BI Publisher 10g, SQL Developer, Windows-XP

Confidential,Philadelphia, PA

Siebel Analyst

Responsibilities:

  • Set up meetings to quickly establish relevant business requirements for the different departments of the business.
  • Identified source systems and created appropriate connection pools, and implemented security within them.
  • Created/Modified Metadata repository (.rpd) using Siebel Analytics Admin tool in the Physical, Business Model and Mapping, and Presentation layers.
  • Analyzed and validated the business model in Siebel Administration Tool by performing consistency checks, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
  • Involved in building star and snowflake schemas in the Repository using new foreign key links in the physical layer, and new complex joints in the BMM layer.
  • Created derived columns from already established columns.(Such as Gross Profit)
  • Extensively used Hierarchy modeling from Granular levels to Global levels for sales to make periodic comparisons (Hour, Day, Week, Month, Quarter, and Year) among different Markets(States, Cities).
  • Created Level-based measures per business requirements.
  • Increased efficiency and profitability by extensively using Siebel Delivers and iBots to help decision making.
  • Validated the Presentation layer to make sure users liked the appearance of Business models and tables.
  • Tested RPD functionality by creating basic reports.

Environment:: OBIEE 10g, Windows XP

Hire Now