We provide IT Staff Augmentation Services!

Obiee Lead Resume

Helen Of Troy, TX

Executive Summary

  • More than Seven years of experience in IT implementing full life cycle of Business Intelli gence solution with System & Data Analysis, Application Design & Dimensional and Data Modeling with Design, and Documentation with applications on various flavors of UNIX and Windows.
  • Good knowledge about different tracks like Financials, Supply Chain & Order Management, Procurement and Spend Analytics.
  • Experience using Oracle Business Intelligence Enterprise Edition 10g and Oracle BI Apps.
  • Experience in end to end implementations of BI solutions for implementing Financials, Supply Chain and Order Management, Procurement and Spend Analytics.
  • Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher and iBots within OBIEE Suite.
  • Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).
  • Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
  • Performed Cache Management at repository level.
  • Developed Delivers iBots/Scheduler to automate report delivery and provide alerts on Interactive Dashboards.
  • Possess good knowledge on Hyperion Essbase.
  • Possess knowledge about SmartView.
  • Experience in working with Informatica Power Center in applying transformations, creating mappings & loading data into the data warehouse.
  • Excellent interpersonal and communication skills for efficient client interaction.

Technical Skills:
OLAP Tools: Siebel Analytics 7.8.3, OBIEE 11.1.1.5, 10.1.3.3/10.1.3.4, Oracle BI Apps, BI
Publisher
Databases: Oracle 10g/9i
DB Analysis Tools: SQL* Plus, ODBC, SQL Developer, TOAD.
ETL Tools: Informatica Power Center 8.6/8.1/7.x
Languages: PL/SQL, C, UNIX Shell Scripting, .NET
Web Technologies: HTML, JavaScript, XML, MS FrontPage
Operating Systems: Windows-All versions, Linux-Red Hat, Fedora and Ubuntu
Networking: Routers-LAN/WAN configuration, Firewall configuration, VPN configuration, Wireless configuration, services like FTP, TELNET, SSH.

Education:
Bachelor of Technology in Computer Science

Professional Experience:
Confidential, TX April 2011 - Till Date
[OBIEE Lead Developer]

Roles & Responsibilities:

  • Translated Business requirements into technical requirements.
  • Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
  • Worked with OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre- built rpd.
  • Created Dashboard prompts and advanced filter criteria.
  • Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation).
  • Customized reports from BI Apps (OOB-prebuilt) seeded reports.
  • Used BI Apps prebuilt Informatica mappings for development.
  • Fixed many OOB issues.Created major and important dashboards like Customer Profitability from the scratch including
  • The top priority reports like Monthly Net Sales, Customer Profitability, Funds Details, Credit Summary.
  • Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.
  • Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).
  • Implemented various Repository Variables and System Variables depending up on user requirements.
  • Extensively worked on Informatica PowerCenter 8.6 tools - Designer, Workflow Manager,

Workflow monitor.

  • Upgraded from OBIEE 10g to 11g.
  • Designed and developed complicated/complex reports.
  • Followed best practices to make sure there was good performance.
  • Administered MUD rpd, reviewed developers' rpd development before merging into MUD server.

Environment: OBIEE-11.1.1.5, OracleBI Apps, Oracle DB 10g, SQL Plus, Oracle SQL Developer, Informatica Power Center 8.6, DAC.

Confidential, MI July 2010 - April 2011
[Sr.OBIEE Consultant]

Roles & Responsibilities:

  • Interacting with management, business and users, gathering the business requirements, designed and developed complex dynamic business quality compliance group reports related to audit and early warning.
  • Created transformations like Expression builder, joiner, and router.
  • Implemented OBIEE solution for 'Sales' subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.
  • Tuned the performance of the reports by creating various types of indexes wherever appropriate.
  • Configured MUD for OBIEE Tool
  • Used existing data from Hyperion Essbase for analysis.
  • Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension
    hierarchies.
  • Created variety of interactive dashboards containing charts, graphs and pivot tables using BI Answers.
  • Utilized features like narrative views, dashboard prompts to create interactive dashboards.
  • Configured BI Scheduler and created simple, conditional and chained iBots to create alerts and deliver them using Oracle Delivers.

Environment: OBIEE-10.1.3.4, Oracle DB 10g, SQL* Plus, PL/SQL, Informatica Power Center 8.6.

Confidential, FL August 2009 - July 2010
[Sr.OBIEE Consultant]

Roles & Responsibilities:

  • Gathered User requirements, reporting requirements and the document for requirement specifications.
  • Used Administration Tool for customizing and modifying the Physical, Business Model & Mapping and Presentation Layers.
  • Created dimension hierarchies, aggregates and keys in BMM layer.
  • Worked on session variables and dynamic variables along with initialization blocks.
  • Created users and groups in the repository and granted privileges and group inheritance.
  • Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.
  • Involved in troubleshooting of Informatica Mappings and Workflows
  • Compared data from Hyperion Essbase with the OBI for data validation.
  • Created source and target instances and various transformations (Joiner, Aggregator, Filters, and Router).
  • Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
  • Created highly formatted reports using BI Publisher based on Oracle Database.

Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle BI Publisher, Informatica Power Center 8.1.

Client: Confidential, NY July 2008 - August 2009
[OBIEE Developer]

Roles & Responsibilities:

  • Involved in translating high-level business requirements into logical business dimensional model.
  • Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
  • Imported physical tables and defined relations between Physical tables at the Physical Layer.
  • Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.
  • Utilized Aggregation to improve query performance
  • Created Reports using different views
  • Implemented BI Security using External Table for Authentication and Authorization
  • Worked on iBots using BI Delivers for issuing Alerts and setup a Delivery Profile to email reports to various power users at scheduled intervals.

Environment: OBIEE 10.1.3.3, 10.1.3.4, Oracle 10g, MS Excel, Linux, Windows XP, SQL Plus

Client: Confidential, PA August 2007 - May 2008
[Siebel Analytics Developer]

Roles & Responsibilities:

  • Involved in gathering the reporting requirements from Operation and Marketing departments.
  • Identified the GAPs by analyzing the Data mart instance and provided alternative solutions as well recommended changes to database.
  • Analyze Design and Developed Metadata repository (.rpd) that consists of physical layer, multiple business models with dimensions & time series objects, presentation layers with catalogs, external table security using session variables, LDAP authentication, assigning catalog objects & Web modules to users & groups etc.
  • Designed and developed the various Dashboards/Reports that are Dynamic & Interactive with drill-down capabilities and local & global filters and cache monitor using Siebel Analytical Web. Extensively used Siebel Delivers and iBots.
  • Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
  • Performed Unit testing and Integration testing to validate Dashboards/Reports.
  • Developed/Updated Informatica Mappings and Workflows for ETL processes per reporting requirements.

Environment: Siebel Analytics 7.8.3, Informatica Power Center 7.1.2, Oracle10g,

Confidential, MI Jan 2006 - July 2007 [Informatica Developer]

Roles & Responsibilities:

  • Created new ETL transformations, mappings, mapplets, workflows and loading data into DW transforms.
  • Tracking long running Transformations and Loads and was involved in performance tuning the SQL queries.
  • Executing Day to Day Operations which include rerunning the jobs on failure, fixing the transformation issues and verify data quality of the tables.
  • Developed and tested stored procedures, functions in SQL for data ETL Process.
  • Handled dynamic data load via staging tables in the ETL Layer.

Environment: Informatica Power Center 7.1.2, Oracle 10g, Windows, TOAD

Confidential, Hyderabad, India
HQ: TeamF1, CA Jan 2005 - Jan 2006
[Software Engineer]
Roles & Responsibilities:

  • Developed core modules which are the major components of the product.
  • Coordinated with other teams for quality performance and resolving at critical stages.
  • Debugged issues reported by QA team and customer.
  • Maintained projects after stable release.
  • White box testing of the components.

Environment: gcc, Windows and Linux, shell scripting, C,

Hire Now