We provide IT Staff Augmentation Services!

Obiee Lead Resume

Charlotte, NC

SUMMARY:

  • 10 years of experience in IT industry involving requirement analysis, design, development, implementation, quality analysis and production support for business intelligence and reporting projects.
  • Extensive experience as a technical developer and lead managing multiple projects actively involving in all phases of the design, development and production support.
  • Experience in interacting with business users, business analysts and developers in analyzing business requirements and converting them into technical specifications for reporting solutions.
  • Strong interpersonal, Communication skills with excellent verbal, written skills.
  • Ability to handle multiple tasks with very strong analytical and problem solving skills.
  • Good knowledge of regulatory reporting requirements for Employee Retirement Income Security Act (ERISA), Fee Disclosure.
  • Worked extensively on Repository (RPD) development.
  • Extensively worked with OBIEE 10g, 11g, 12c and Siebel Analytics 7.9.x in developing Analysis, Prompts, Interactive Dashboards and Agents, Action links
  • Experience in OBIEE features Time Series Objects, Hierarchies, Level Based Measures, Session Variables, and Initialization Blocks.
  • Experience in OBIEE authentication setup with external table and AD.
  • Experience in OBIEE 11g, 12c installation.
  • Good knowledge of OBIEE administration including WebLogic and OBIEE components.
  • Experience in automating OBIEE migration activities like RPD, web catalog, WebLogic deployment migration between various SDLC environments.
  • Extensive experience in developing shell scripts for automating various migration activities and report generation processes.
  • Experience in setting up and using Multiuser Development Environment (MUDE).
  • Extensively worked on creating various PDF, CSV, EXCEL reports using BI publisher.
  • Experience in setting up Impersonate functionality in OBIEE 12c.
  • Experience in Oracle, SQL Server, and Teradata databases for designing and developing stored procedures/packages, database triggers and cursors using SQL, PL/SQL.
  • Experience is developing RPD, reports with Hadoop as data source.
  • Extensive SQL experience in multiple domains with a strong understanding of data & analytics with ability to code and implement complex business rules in SQL.
  • Experience in performance tuning of queries and indexing, partitioning the tables to improve performance.
  • Extensively used various data stage transformations like Lookup, Join, Sort, Aggregator, different source file format, transformer.
  • Good knowledge of ITIL Standards and process.

TECHNICAL SKILLS:

DBMS: Oracle 10g/11g/12c, SQL Server, Teradata, Hadoop.

Languages: PL/SQL, SQL.

Data Warehousing tools: Informatica (Power Center 7.x), Data Stage 8.1.

Reporting tools: OBIEE 12c, OBIEE 11g, OBIEE 10g, BI Publisher, OBI Marketing, Siebel Analytics, Tableau.

Tools: TOAD, SQL developer, Quality Center, Teradata SQL Assistant, Omni Station.

Operating Systems: UNIX, LINUX, Windows.

Scheduling Tool: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

OBIEE Lead

Responsibilities:

  • Involved with users for gathering requirements, providing inputs for functional requirement document (FRD), preparation of technical design documents (TDD).
  • Involved in the full SDLC for application upgrade from 10g to 11g and 11g to 12c
  • SME for multiple applications like ERISA Plan Reporting, Institutional Reporting on the Web and Fee Disclosure 408(b) (2) applications.
  • Developed multiple complex BI Publisher reports with PDF, CSV and excel output formats.
  • Developed and customized the P hysical layer, Business Model and Mapping layer and Presentation layer of the repository.
  • Created internal dashboards containing various reports for generating team metrics .
  • Customized dashboard navigation using Iframes .
  • Developed agents for report delivery and also invoke agents using web service .
  • Developed store procedures for loading aggregate tables upon completion of the ETL loads.
  • Performed admin activities in Linux, Windows environments.
  • Worked on migration activities for OBI components.
  • Worked on WebLogic administration for all OBIEE applications as part of maintenance.
  • Worked on creating and updating deployments in WebLogic.
  • Worked on creating data sources in WebLogic, BI Publisher.
  • Developed wlst scripts to automate WebLogic application deployments, data source reset, role and group creation.
  • Developed shell scripts for RPD and web catalog migrations as part of production and non - prod server migrations.
  • Developed scripts to automate the OBI server restarts, monitoring upon completion of Unix server patching/reboots.
  • Implemented encryption process in the shell scripts to eliminate the risk of password visibility.
  • Successfully lead the team to complete the disaster recovery exercise for all the reporting applications.
  • Have extensively worked on analyzing and tuning SQL queries to improve the performance of long running reports.
  • Created aggregate tables to improve performance and reduce report run time.
  • Developed Teradata store procedures, BTEQ scripts to load aggregate tables.
  • Accountable for all BI projects development, maintenance and support . Lead and motivate the BI onsite and offshore teams towards the success without losing the momentum.
  • First point of contact for triaging production issues and application support.
  • Handled complex incidents for various projects with reporting issues.
  • Imported Hadoop tables to OBIEE RPD for modeling and reporting.
  • Configured connection to Hadoop from OBIEE with Kerberos.
  • Impala, Hive odbc connection setup from OBIEE Linux servers.
  • Working on migrating aggregate tables from Teradata to Hadoop for cost efficiency .
  • Working on Hadoop Beeline scripts to load aggregate tables.
  • Responsible for providing updates and weekly/monthly/quarterly/yearly metrics to the management on the activities handled by the team.
  • Lead the team to successfully deliver ERISA financial reports to 17000 clients for two major reporting cycles (Dec, June) for four consecutive years.
  • Responsible for review and approval of all production fix migrations performed by the production support team as part of the change management process.
  • Responsible for preparing KT plans, project Staffing and Work assignment to the team and be a helping hand for them as and when required.
  • Responsible for triaging, assigning and monitoring the progress of production incidents/requests.
  • Responsible for identifying the knowledge gap within the members of the team and conduct KT sessions to address the gaps.
  • Performed multiple tasks, co-ordination among the team during crisis management situations .
  • Worked on creating dashboards for analyzing the data and forecast the business metrics .
  • Worked with various business users to develop application enhancements to reduce additional team effort and increase efficiency .
  • Identified manual/repetitive tasks and built automated processes to increase efficiency of the team.
  • Responsible for co-ordination of all server maintenance activities with application business and infrastructure teams.

Environment: OBIEE 10.1.3.3, OBIEE 11.1.1.6.9, OBIEE 11.1.1.7.1, OBIEE 12.2.1.0.0, BI publisher, Teradata, Autosys, SQL server, PL/SQL, XML, Linux, Omni Plus.

Confidential - Charlotte, NC

OBIEE Lead

Responsibilities:

  • Involved with users for gathering requirements, providing inputs for functional requirement document (FRD), preparation of technical design documents (TDD).
  • Designed and developed the OBIEE Repository using Admin tool
  • Developed multiple Dimensions (Drill-Down Hierarchies), Logical Facts, Measures in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
  • Created dashboard reports with pictorial representation of the status of the loads.
  • Created dashboard reports for management to easily pull metrics and stats for the duration of the loads.
  • Created dashboard reports for technical support team to identify long running jobs for performance improvement considerations.
  • Created conditional based reports to dynamically display different dashboard sections.
  • Created iBots/Agents to deliver status of the loads and further eliminate manual communication process.
  • Created writeback pages to provide capability of adding comments/updates to the dashboard.
  • Implemented object level security to restrict the access based on user profile.
  • Created aggregate tables for reporting for high performance.

Environment: OBIEE 11.1.1.7.1, Oracle, Autosys, Linux, Data stage.

Confidential - Charlotte, NC

Sr OBIEE Developer

Responsibilities:

  • Involved in the full SDLC for Fee Disclosure 408(b) (2), 404(a) reports as part of the DOL released regulations for ERISA plans during 2011, 2012.
  • Worked closely with the Business Analyst to gather the Analytics requirements .
  • Involved with business users while gathering requirements, providing inputs for Functional Requirement Document (FRD), Preparation of Technical Design Documents (TDD).
  • Translated business requirements to technical considerations for reporting.
  • Identified & Created Facts, Dimensions, and Hierarchies of the business model.
  • Created various Session and Repository variables in OBIEE for reporting purpose.
  • Developed BI publisher data templates to generate xml files for 8 reports.
  • Developed 8 PDF, CSV reports using RTF and ETEXT templates in BI publisher.
  • Involved in report bursting process to generate PDF, CSV reports.
  • Worked on developing shell scripts for moving PDF, CSV reports to various file systems to access from front end applications.
  • Performed Query tuning to improve report performance by building aggregate tables.
  • Designed dashboard for workflow management for various client reports based on the reporting dates and stages.
  • Designed and developed role-based Intelligence Dashboards for Management Executives, Managers.
  • Used Filters and customized Prompts to avoid excessive data in reports to improve performance.
  • Implemented Writeback to database using OBIEE to automate the business process.
  • Worked on migration of OBIEE components between Dev/Test environments.
  • Involved in performing Unit Testing, Integration Testing and User Acceptance Testing .
  • Worked on various issues reported during testing and performed report fixes as required.
  • Automated the report generation and delivery process using Autosys job scheduler .

Environment: OBIEE 10.1.3.3, BI publisher, Teradata, Autosys, SQL server, PL/SQL, XML, UNIX, Omni Plus.

Confidential - Charlotte, NC

OBIEE Developer

Responsibilities:

  • Worked on record keeping system OMNI for analysis of the data.
  • Worked on manually building reports from recording keeping system OMNI .
  • Worked on testing and analyzing the reports.
  • Worked closely with the Business Analyst to gather the Analytics requirements .
  • Translated business requirements to technical considerations for Data warehousing and reporting.
  • Build prototype reports from excel spreadsheet during the requirement gathering stage to visualize the reports and clarify requirements.
  • Identified & created Facts, Dimensions, and Hierarchies of the business model.
  • Customized the P hysical layer, Business Model and Mapping layer and Presentation layer of the repository.
  • Administered OBIEE Security by creating users, security profiles, and assigning users to groups to implement Object and Data level security .
  • Created various Session and Repository variables in OBIEE for reporting purpose.
  • Performed Query tuning to improve report performance by creating JIs, building aggregate tables.
  • Worked on Cache management techniques to enhance query performance.
  • Extensively worked in designing several Analytics reports using Answers .
  • Used Filters and customized Prompts to avoid excessive data in reports to improve performance.
  • Involved in developing BI publisher data templates to generate xml files.
  • Involved in developing RTF and ETEXT templates for BI publisher reports.
  • Involved in report bursting process to generate PDF, CSV reports.
  • Involved in performing Unit Testing, Integration Testing and User Acceptance Testing.
  • Worked on various issues reported during testing

Environment: OBIEE 10.1.3.3, OBIEE 11g, BI publisher, Teradata, Data Stage, SQL server, PL/SQL, XML, UNIX, SQL-Navigator 4.5, Omni Plus.

Confidential, Milwaukee, WI

OBIEE Developer/Administrator

Responsibilities:

  • Gathered the business requirements, worked on analysis and prepared the working schema.
  • Involved in installing Siebel analytics in various servers as part of software build process.
  • Identified & Created Facts, Dimensions, and Hierarchies of the business model.
  • Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, Session Variables, and Initialization Blocks.
  • Created and configured repository using analytics admin tool.
  • Developed different custom reports for gathering data for end users using Siebel analytics answers.
  • Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled Slowly Changing dimension data.
  • Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
  • Involved in customizing the look of OBIEE according to the clients requirements.
  • Worked extensively on Siebel Answers to create the reports as per the client requirements.
  • Built reports using Answers including drill down objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
  • Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
  • Prepared Role-Based Dashboards for higher authorities to review the reports according to their role.
  • Hands on experience in troubleshooting issues related to Siebel CRM 7.8 remote users.
  • Created users and assigned responsibilities and positions using Siebel CRM 7.8
  • Worked on Siebel analytics production issues raised by end users.
  • Hands on experience in Siebel data administration and Siebel remote administration.
  • Maintained extensive documentation for design, implementation and testing Siebel Analytics reports, Dashboards

Environment: OBIEE 10.1.3.4, Siebel Analytics 7.8,Siebel CRM 7.8, Oracle 11g, Unix, Clarify tool.

Confidential, Minneapolis, MN

Siebel Analytics Consultant

Responsibilities:

  • Installed and configured Siebel Analytics Server and Siebel Analytics Web.
  • Worked closely with the Business Analyst to gather the Analytics requirements .
  • Translated business requirements to technical considerations for Data warehousing and reporting.
  • Build prototype reports from excel spreadsheet during the requirement gathering stage to visualize the reports and clarify requirements.
  • Designed and developed ETL processes ( SDE and SIL Mappings) for populating data into RMW.
  • Identified & Created Facts, Dimensions, and Hierarchies of the business model.
  • Customized the P hysical layer, Business Model and Mapping layer and Presentation layer of the repository.
  • Administered Siebel Analytics Security by creating users, security profiles, and assigning users to groups to implement Object and Data level security .
  • Strong understanding of Session and Repository variables, and Initialization block .
  • Worked on Cache management techniques to enhance query performance.
  • Extensively worked in designing several Analytics reports using Siebel Answers .
  • Reports Created: Product Analysis, Customer Analysis, Channel Analysis, E-commerce Analysis, and Promotion Management.
  • Designed and developed role-based Intelligence Dashboards for Management Executives, Managers and Sales personnel.
  • Used Filters and customized Prompts to avoid excessive data in reports to improve performance.
  • Created iBots in Siebel Delivers to send alert messages and group mails to the end-users.
  • Involved in performing Unit Testing, Integration Testing and User Acceptance Testing.

Environment: OBIEE 10.1.3.3, Informatica7.1, Oracle10g, PL/SQL, XML, UNIX, SQL-Navigator 4.5.

Hire Now