Sr. Obiee Developer Resume
Sunnyvale, CA
SUMMARY
- 10 years of strong technical expertise and experience in OBIEE 12c (OBIEE 12c version 12.2.5.3.0 ), OBIEE 11g and OBIEE 10g including various versions of OBIEE 11g - 11.1.1.7.140715 / other 11g variants of OBIEE and OBIEE 12c variants of OBIEE like OBIEE 12.2.1.0.0 , OBIEE 12.2.1.3.0 , Oracle BIAPPS 7.6.9.3, Oracle SQL Developer, Oracle BI Publisher 12.2.1.0.0 .
- Strong expertise in many different versions of OBIEE 11g like 11.1.1.5.0 , 11.1.1.6.0 (applied patches to get it to 11.x.6.6), 11.1.1.7.0 , 11.1.1.7.x, OBIEE 12c and different versions of OBIEE 12c - Oracle BI EE 12c ( 12.2.1.0.0 ), Oracle BI EE 12c ( 12.2.1.3.0 ), Upgrade from 11g to 12c, expertise in OBIEE 10g, and OBI apps 796 pre-built analytics (Financials and Procurement & Spend analytics).
- Applied patches to OBIEE 11g to get it to 11.x.6.6 and have strong development expertise in many different versions of OBIEE 11g like 11.1.1.5.0 , 11.1.1.6.0 , 11.1.1.7.0 , 11.1.1.7.x, and in various verisons of OBIEE 12c, also applied patches in OBIEE 12c to troubleshoot a few bugs as recommended by Oracle.
- Upgraded from OBIEE 10g to OBIEE 11g, Upgraded from 11g to 12c, expertise in OBIEE 10g, and OBI apps 796 pre-built analytics (Financials and Procurement & Spend analytics), BI Publisher 12.2.1.3.0 ., and Immense and extremely solid development experience in OBIEE.
- Have worked as various roles/designations in the past as Advisory Consultant, Technical Specialist, Project Lead, Tech Lead, Mentor, Developer, BI Admin, Solution Architect, and Business Analyst and Subject Matter Expert (SME) in OBIEE.
- Strong expertise in OBIEE Answers and designing Interactive Dashboards with drill-down capabilities, pages, folders, reports/ analyses, OBIEE Delivers(Agents), charts, compound views.
- Completed many full end-to- end implementations for clients. Lead the entire team and motivated the team members to perform against all odd conditions as changing client requirements and increased complexities.
- Strong technical expertise and work experience in RPD development and Front-end development including dashboards, reports, permissions, security development in many complete end-to-end implementations/projects.
- Experience in requirement gathering, schema designing, repository development and customising, dashboard designing, Security implementation, documentation, system testing using Oracle SQL developer & MS SQL Server 2008, and functional testing, performance tuning, and creating development, SIT, UAT, and PRODUCTION environment, finally led multiple projects with multiple roles and technologies.
- Have worked under C-level officers & have demonstrated excellent communication & interpersonal skills & leadership skills with top-brass & have received a lot of appreciation from them.
- Very strong knowledge in RPD development as well as dimensional modelling, RPD variables, presentation variables, Fragmentation, performance tuning, writing SQL and debugging them etc. Also have used system / non-system variables during security implementation in many projects and have developed various variables as a part of it.
- Have used XML scripting in catalog manager exhaustively to fix many complex requirements & issues.
- Strong expertise in OBIEE Administration tool and reports and dashboards and real time reports and etc, including strong development expertise in developing RPD and security implementation (application roles, row level security, object level security) and policy store.
- Have created all environments like Dev, Test, SIT, UAT with installation of OBIEE12c in various boxes.
- Expertise in business model and mapping layer development with creating / developing Dimensions, Skipped and Ragged-level Hierarchies etc, Measures, Level-based Measures, Aggregation Rules, and Time Series functions.
- Have worked with databases like DB2, SQL server, Oracle, flat files, CSV and XML files.
- Expertise in developing Usage Tracking, merging RPD, WriteBack & Cache Management Techniques.
- Experienced in creating templates in various formats like RTF, XLS, etc.
- Strong understanding of OBIEE design and development, good understanding of ETL process using various transformations, data migration and gathering reporting requirements.
- Sound knowledge of Data Warehousing concepts like Star Schema, Snowflake Schema etc.
- Have excellent expertise in security implementation and have implemented in various projects for example the data level security as well as the object level security.
- Experience in Agile, Waterfall SDLC, Software Design, Software Documentation, Software Testing
- Integrated the ODI jobs to be run from the directly from OBIEE interactive dashboards making it super-handy for users to run ODI scenarios/ jobs right from OBIEE dashboards.
- Implemented the skin changes as per business requirements such as banner colour, logo, width of the top banner etc.
- Experienced in implementing, supporting, and maintaining Oracle BI applications
- Proficient in BI Desktop Tools, BI 11g / 12c Publisher, BI 11g/12c Analytics, BI 11g/ 12c database SQL language, detailed knowledge of XML
- Have strong communication, influencing & leadership skills. Have excellent verbal and writing skills.
- Experienced in debugging and optimizing SQL queries. Have a good understanding of ETL concepts. Have good proficiency in transformation and mapping using ODI/Informatica
- Have familiarity with Oracle database architecture.
- Developed reports and queries utilizing BI Publisher, OTBI, Tableau and OBIEE.
- Deployed the RPD using wlst and did the node manager configuration to troubleshoot the services restart in OBIEE 12c
- Experienced in core OBIEE applications dashboards, and repository maintenance and metadata repository configuration.
- Able to liaison between technical Business Intelligence support team and business process owners
- Provided training and technical assistance to end users and other team members that use BI reports
- Oracle Certified Specialist: ORACLE BUSINESS INTELLIGENCE FOUNDATION SUITE 11G CERTIFIED IMPLEMENTATION SPECIALIST.
- Oracle Certified Specialist: ORACLE BUSINESS INTELLIGENCE CLOUD SERVICE SPECIALIST
TECHNICAL SKILLS
- OBIEE 12c - OBIEE 12c version 12.2.5.3.0 , Oracle BI EE 12c ( 12.2.1.0.0 ), Oracle BI EE 12c ( 12.2.1.3.0 ) etc
- OBIEE 11g -OBIEE 11.1.1.7.140715 / other 11g variants
- OBIEE 10g
- Oracle BI Publisher 12c ( 12.2.1.0.0 ), Oracle BI Publisher 12c ( 12.2.1.3.0 )
- Oracle Data Visualization Cloud Service,
- Visual analyser
- Oracle Analytics Cloud version 105.3.0
- Business Intelligence Cloud Service (BICS)
- Procurement and Spend Analytics
- (Oracle Database 11.2.0.4, RDBMS), Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
- Oracle SQL developer, Toad
- Informatica Power Center 9.1.0 with HotFix 2, Informatica PowerCenter 10.2.0 HotFix1
- DAC 10.1.3.4.1 (Oracle Data Warehouse Administration Console), DAC 11g version 11.1.1.6.4.20170330.0204 (Oracle Data Warehouse Administration Console)
- Oracle Data Integrator 11g, 12c, PL/SQL
- Oracle Linux7, Unix, Windows, Mac OS
- SQL, Data Warehouse, Data analysis, Data Modelling, ETL concepts, XML
PROFESSIONAL EXPERIENCE
Confidential, Sunnyvale, CA
Sr. OBIEE Developer / Team Lead/ Solution Architect
Responsibilities:
- Have merged the two Prod environments by merging respective two MUD RPD’s and catalog objects to simplify the systems and save the costs and maintenance of two Prod environments. It went live successfully without a single error or ticket from users in Prod.
- Have handled the issues of merging both the environments single handedly and have done the migration of all the objects into higher environments single handedly. Data validation and testing was a big success.
- Have authored the asset documents for Merging SFI and NEAP projects apart from the migration documents, Roll-back plan, test plan, IT Cert documents etc.
- Have created the direct database request by creating various tables and loaded data from excelsheets to serve instant requests from Director and VP and C level officers of the company. Have developed revenue related confidential reports using direct database request right from requirement from CFO.
- Have developed the OBIEE reports from scratch to fulfil users unique requirements that requires RPD work from scratch as well including the XML know how(knowledge) to be used in catalog manger as advance level. Have edited and developed the HTML index page.
- Have worked on the MUD rpd using the OBIEE Admin tool version 12.2.5.3.0 and developed new subject areas and developed all the three layers to fulfil the requirements.
- Have worked on Oracle Analytics Cloud (OAC) 105.3.0 and have used its catalog manger and admin tool for RPD development under MUD environment. Have used XML Script to fulfil various tasks in catalog manager (OAC).
- Have migrated all the development work to higher environments in all the projects/modules/reports/ RPD development etc. Have created dashboards, reports, prompts, action links, etc and other objects in Oracle Cloud Infrastructure.Have worked on Oracle BI Cloud Service.
- Have used XML script in extensively in catalog manger of Oracle Analytics Cloud
Have deployed the Data model (RPD) many times as required for development against all the environments.
- Have done the RPD and dashboards and reports and prompts development in many modules/ projects such as: ACV Project, the ACV PHASE II project, the SFI AND NEAP MERGE Project and the Restructuring of the catalog objects and so on etc. Have implemented in security in IDCS.
- Did the data cleansing per the business logic provided before developing the OBIEE reports out of it by Direct Database Request Reports.
Environment: Informatica PowerCenter 10.2.0 HotFix1, Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 , OBIEE 12c version 12.2.5.3.0 , Oracle Analytics Cloud version 105.3.0, DAC 11g version 11.1.1.6.4.20170330.0204 (Oracle Data Warehouse Administration Console)
Confidential, Estero, Florida
Sr. OBIEE Developer / BI Admin/ Solution Architect/ SME
Responsibilities:
- Worked on requirement gathering from BI perspective and Have attended workshops in US local timings to understand the requirement.
- Have completed the entire RPD development and BI Reports development including testing and documentation for the entire project.
- Worked on currency conversions into prompts for reports, so that corporate currency and local currency can be shown in the report.
- Developed customized and attractive Analysis/ Dashboards/ Reports with different Analytics Views (Pivot Table, Chart, Tabular, Ticker, Column Selector and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
- Used Analytics Web Catalog to set up groups, access privileges and query privileges.
- Implemented object level security for different web groups based on responsibilities.
- Implemented the security for Herc spin - off project in a very short period and tested and went - live instead of long pending hurdles and issues.
- Have completed the entire RPD development for Fixed asset reports and worked on RPD variables and used them as arguments in a function in package in a view in OBIEE Physical layer as a part of real-time reporting direct hitting to EBS database.
- Have developed the dashboard prompts which will communicate with the function in package in a view to server the user friendly selection of values from the dashboard and let the report interact per prompt selection.
- Have delivered the entire project in a very short span of time.
- Have created/developed a lot of assets for Hertz by documenting the complex parts of the project successfully delivered by me.
- Worked in Fixed assets analytics OOTB and resolved long pending issues.
- Have built some real time complex reports and dashboards in Fixed Asset analytics by designing complex RPD structure having tables, packages (and function in package), views, alias, and supporting variables and init blocks and corresponding joins.
- Have built blackbox and blackline reports fully customised for new Global Charts of Accounts.
Environment: Informatica PowerCenter 9.1.0 with HotFix 2, Oracle Database 11.2.0.4, OBIEE 11g, DAC 10.1.3.4.1 (Oracle Data Warehouse Administration Console), OBI APPS 7963
Confidential, Atlanta, GA
Sr. OBIEE Developer / SME/ Solution Architect
Responsibilities:
- Single point of contact for the entire engagement and successfully met the deadlines and the project successfully went - live.
- Have worked on performance tuning of reports containing huge data.
- Have worked on OBIEE administration including setting up the environment and maintaining the entire environment
- Have tested and validated the reports against ebs or oracle forms but validating each entry in the report.
- Debugged various errors pertaining to reports on the dashboard.
- Have worked on system-jazn-data.xml extensively and on the policy store to create new roles and users and map them as per security requirements of the client.
- Have completed the Report testing and QA before delivering the reports to business.
- Migrated OBIEE code including RPD and web catalog items between Dev, Qual, prod servers/ environments.
Environment: Informatica PowerCenter 9.1.0 with HotFix 2, Oracle Database 11.2.0.4, OBIEE 11g, DAC 10.1.3.4.1 (Oracle Data Warehouse Administration Console)
Confidential, Charlotte, North Carolina
Sr. OBIEE Developer / SME/ Solution Architect
Responsibilities:
- Single point of contact for the entire engagement.
- Created an Entire New Subject Area for Adhoc Reporting after understanding the entire ETL framework in a very short span of time.
- Working in MUDE environment and created and assigned a new project for MUDE RPD.
- Working very closely with client and understand the requirement soon and deliver it asap.
- Migrated all the reports to UAT and SIT and Prod environments.
- Created many Direct Database Request reports.
- Reduced RPD size by deleting some 3500 odd objects from RPD and webcat by using Usage tracking of un-used reports and reports from catalog manager.
- Have completed the entire RPD development for reports after gathering the information and understanding the requirement from the business.
- Ensured 100% compliance with security requirements for data.
Environment: Informatica PowerCenter 9.1.0 with HotFix 2, Oracle Database 11.2.0.4, OBIEE 11g, OBI APPS 7963, DAC 10.1.3.4.1 (Oracle Data Warehouse Administration Console)
Confidential
Advisory Consultant/ OBIEE Developer / BI Admin/ Solution Architect
Responsibilities:
- Single point of contact for the entire engagement for upgrade and development tasks pertaining to OBIEE.
- Handled multiple projects single handedly and have played the role of subject matter expert by imparting valuable advice to different clients and projects.
- Have set up and configured OBIEE 12 action frame work to invoke ODI jobs from OBIEE dashboards and have got immense appreciation from top brass in Confidential as this first of its kind with the latest versions
- Have developed data model, BI reports, a few BI publisher reports from the scratch and have done the RPD development for the same.
- Installed and created and configured the DEV, TEST, SIT environment for different projects for the same client in windows OS.
- Upgraded OBIEE 12.2.1.0.0 to OBIEE 12.2.1.3.0 to resolve a few issues and bugs.
- Have changed the oracle logo with downer logo in the top banner on each page and have changed its height and colour.
- Have removed “Business Intelligence” from the login page and other webpages and done other customizations per business requirement.
- Upgraded OBIEE 10g to OBIEE 11.1.1.9.0 (11g) and troubleshoot the issues in doing the same.
- Upgraded OBIEE 11.1.1.9.0 (11g) to OBIEE 12.2.1.0.0 (12c) and troubleshoot the issues involved in this.
- Validated all the reports and troubleshoot all issues during upgrade of OBIEE from 10g to 11g.
- Configured external LDAP in existing WebLogic server & implemented security for the projects.
- Have installed OBIEE 12c & have created all environments like Dev, Test, SIT in different boxes.
Environment: Oracle data integrator 12c, Oracle Database 11.2.0.4, OBIEE 11g, OBIEE10g, OBIEE 12c
Confidential
OBIEE Developer / SME/ Solution Architect
Responsibilities:
- Single point of contact for the entire engagement.
- Incepted entire data model and then developed entire OBIEE model from the scratch there by building/ creating source tables and cleaning of the tables in staging.
- Developed OBIEE Repository from the scratch and developed reports and dashboards as per client requirements.
- Demonstrated entire offering amongst client in very short span of time despite of many hurdles.
- Trained the users by giving many demonstrations.
- Migrated the entire model from dev to TEST to PROD single-handed.
- Demonstrated strong client facing skills and worked under c-level in the client organisation at client location.
Environment: Informatica PowerCenter 9.1.0 with HotFix 2, Oracle Database 11.2.0.4, OBIEE 11g, DAC 10.1.3.4.1 (Oracle Data Warehouse Administration Console)