We provide IT Staff Augmentation Services!

Developer Resume

Ft Worth, TX

SUMMARY:

  • Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical
  • Layer, BMM Layer and Presentation Layer.
  • Extensive experience in OBIEE11g/10g Presentation Services including Answers, Interactive Dashboards,
  • Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher.
  • Excellent aptitude in translating high - level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, creating reports / Dashboards, cache monitor
  • Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures,
  • Aggregation Rules, Time Series and other functions.
  • Highly skilled in building Interactive Dashboards with drill-down capabilities using global & local Filters, Business
  • Rules with User Identity & Roles, Profiles & Personalization.
  • Dashboards/Reports to improve performance at Database.
  • Proficient in working on production and development environment in different RDBMS (in Oracle 10g/11g).
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling,
  • Snowflakes modeling, fact and dimension tables modeling of data.
  • A team player with excellent mentoring skills and technical instructor experience.
  • Used Oracle SQL for various data operation including but not limited to Data Definition Data Manipulations, Data Query, and Administration

PROFESSIONAL EXPERIENCE:

Confidential, Ft Worth, TX

Developer

Responsibilities:
  • Gather business requirements from the user community.
  • Convert functional requirements into technical requirements.
  • Identify the granularity level of data required to be available for analysis.
  • Develop/configure Metadata repository (.rpd) and Web Catalog Objects as per business requirements using OBIEE
  • Admin tool and BI Analytics.
  • Work on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
  • Use prompts in reports and dashboards to help users quickly answer business questions.
  • Use conditional formatting in reports with a lot of coloring, per business requirements.
  • Create action links in reports to expose detail information and answer more business questions.
  • Design the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
  • Create/configure hierarchies in the BMM layer.
  • Work with time series models such as Month Ago gross profit, Year To Date (YTD) revenue.
  • Import tables from DB, created star schemas, and used them to create reports using BI Analytics according to the business requirement.
  • Use Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
  • Experience in creating reports with different views (pivot tables, charts, column selectors, view selectors) allowing clients to analyze the business from different perspectives.
  • Experience in configuring the NQSConfig.INI and instance config files.
  • Experience in creating comprehensive and easy-to-understand Documentation of the complete implementation of
  • Analytics that includes (RPD, Reports and Dashboards, Security).
  • Manage security functionality by creating users and assigning them to their respective groups.
  • Manage performance by use of cache management, and aggregate tables.

Environment: Oracle 11g, OBIEE 11g, SQL, SQL Developer, Windows 7.

Confidential,Dallas, TX

Business Intelligence Consultant

Responsibilities:
  • Gathered requirements from senior finance managers/users through meetings,.
  • Configured security permissions for various application roles to restrict access to specific subject areas and web catalog objects (Dashboards and reports).
  • Used the OBIEE Admin Tool to develop the three layers in the Repository.
  • The Physical, Business Model and Mapping layer and Presentation layer (RPD) analytics.
  • Migrating reports /dashboards between different environments.
  • Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
  • Added required dashboard pages per senior management requirements.
  • Added relevant projects in the Company RPD for new subject areas, and developed the star schemas using the OBIEE Administration Tool.
  • Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
  • Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
  • Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
  • Worked on OBIEE Analytics to create the reports as per the client requirements (including compound views, table, charts, drill downs) for the Global Organization.
  • Used the OBIEE Admin Tool to develop the three layers in the Repository. (RPD).
  • Redesigned an existing model by examining and reconfiguring the joints on the star schema to improve report performance.
  • Worked with Oracle Business Intelligence Enterprise Edition 11.1.1.9. Created Complex Joins, Alias Tables.
  • Created Logical dimensions with Level Based Hierarchies in BMM layer using.
  • Worked on OBIEE Answers to create the reports as per the client requirements (including compound views, table, Charts).
  • Data Sources: Oracle 11g Enterprise Data Warehouse, Operational Data Store (ODS).
  • Customized presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.

Hire Now