Profile

• Over 12 years of progressive experience with Oracle Technologies with 7 plus years of experience working with Analysis, Design, Development, Implementation of Oracle Business Intelligence - OBIEE, Fusion Middleware, Data Federation, Data Visualization and Data Virtualization solutions.
• Experience in leading and managing multiple OBIEE projects
• Expert knowledge of OBIEE Architecture and Administration
• Expert installing Oracle Fusion Middleware products on Linux, Windows and UNIX platforms.
• Installed multiple standalone/cluster OBIEE 11g/10g environments on Linux and Windows
• Successfully implemented multiple OBIEE 10g/11g projects and upgrade projects
• Developed and maintained data warehouse/BI solutions through the entire project life cycle
• Developed and created OBIEE- RPDs, BI Analysis, Dashboards, Alerts, iBots and BI Publisher reports
• Worked extensively on OBIEE Administration, OBIEE Report development and tuning.
• Successfully implemented Windows Authentication, SSO for OBIEE.
• Worked extensively on managing Enterprise Repository RPD and MUD process.
• Installed and configured Oracle BI Mobile App Designer for OBIEE
• Worked extensively on BI Publisher 10g/11.1.1.7.x Administration, setup, scheduling, reporting and XML Publisher EBS
• Worked on BI Publisher Enterprise standalone as well as BI Publisher within OBIEE Suite
• Worked on converting Oracle Reports, Discoverer Reports to BI Publisher 10.1.3.4.2/11.1.1.7.x
• Working knowledge of Informatica Power Center.
• Expert at designing OBIEE RPD/Metadata
• Worked extensively with Star and Snowflake data models in Data Warehousing.
• Worked on SDLC and developed project/software standards
• Worked with business groups and stakeholders in gathering user requirements and designed Functional and Technical specification documents.
• Worked extensively on CISCO Composite 6.2.6 Data Virtualization software
• Worked on BI Analytical Tools Tableau, Spotfire and Microstrategy.
• Worked extensively on Database designing, Data Modeling, Data Migrations and Data Analysis.
• Experience in full project life cycle - requirements, design, development, testing, deployment and training
• Expert in evaluating and recommending new software and BI tools.
• Expert in troubleshooting and resolving issues. Worked extensively with Oracle Support and other software support teams.
• Very good team player. Can effectively work with small and large groups. Can take ownership. Good Project Management skills.
• Well experienced working with off-shore teams and managing off-shore resources.
• Established software/product development standards, best practices, guidelines, technical and training documents.
• Mentored developers, trained users and conducted workshops.

Primary Skills

• Operating Systems: UNIX, Linux, Windows 8.1/7/XP/2000/2003/NT
• Programming Languages: Java, J2EE, PL/SQL, XM
• RDBMS: Oracle Database Sever 11g/10g, MS Access
• Oracle Products: Oracle Fusion Middleware, OBIEE 11.1.1.7.x/10g, APEX, BI Publisher 11.1.1.7.x/10g, Oracle BI Mobile App Designer, ADF, BI Publisher Desktop, Smartview, Oracle Discoverer, OWB, Oracle Forms Reports, Oracle Portal, Oracle Developer Suite
• Software Tools: JDeveloper 11g, SQL Developer, TOAD 12.1, Oracle Raptor
• App. Servers: WebLogic Application Server, Oracle Application Server
• Web Technologies: J2EE, XML, JAVA, JDBC, Java, JavaScript, HTML, CSS
• BI Tools: SpotFire 4.5, Tableau 8.2, Microstrategy 9.3, BI Admin Tool, BI Publisher, BI Analysis and Dashboards
• Reporting Tools: Discoverer, BI Publisher and Oracle Reports
• Version Control Tools: Subversion, PVCS, CVS
• Data Modeling: Erwin 9.5
• Data Archiving Tools: Informatica ILM
• Data Virtualization: CISCO Composite Information Server 6.2.6

Professional Experience

Confidential

Lead and managed multiple OBIEE projects

• Worked extensively OBIEE Architecture and Administration
• Successfully implemented cluster/standalone OBIEE 10g/11g solutions on Windows and Linux platforms
• Worked on multiple OBIEE upgrade projects
• Worked on implementing LDAP - AD Authentication and Single-Sign-On for OBIEE
• Worked on implementing projects for Enterprise Data Warehouse and Operational Reporting using OBIEE
• Worked on Enterprise Data Warehouse, Data Marts
• Developed and maintained data warehouse/BI solutions through the entire project life cycle
• Developed and created OBIEE- RPDs, BI Analysis, Dashboards, Alerts, Agents and BI Publisher reports
• Worked on migrating RPD files and Web Catalogs across different environments.
• Developed Multi User Development MUD standards for OBIEE
• Worked on developing BI Publisher 11g reports from Oracle Golden Gate replicated tables in ODS for Enterprise Operational Reporting needs.
• Worked on providing SSO access to BI Publisher reports on OBIEE dashboards
• Installed and configured SmartView for OBIEE and other MS Office add-ins and web-based tools
• Worked extensively on OBIEE and BI Publisher security.
• Developed POC for migrating Discoverer 11g reports, crystal reports to OBIEE and BI Publisher.
• Worked extensively on BI Publisher setup, administration, configuration, security, scheduling, report bursting and XML Publisher EBS
• Worked on deploying BI Publisher OIM 11g Oracle Identity Management reports in Web Catalog.
• Worked on creating Interactive Reports, RTF layouts, XML Templates and BI Publisher security.
• Worked on upgrading BI Publisher reports from 10g to 11g and upgrading RPDs from OBIEE 10g to 11g
• Worked on installing and configuring CISCO Composite Information Server 6.2.6 CIS Data Virtualization Tool
• Worked on BI Analytical Tools Tableau, Spotfire and Microstrategy.
• Worked on HP PPM, PVCS and Subversion
• Worked on SDLC and developed project/software standards
• Mentored developers and conducted workshops/training sessions for OBIEE, BI Publisher, XML Publisher and BI Tools

Confidential

Role Responsibilities:

Worked on OBIEE Administration.

• Worked on building OBIEE repositories, Answers, Dashboards and iBots
• Worked on BI Publisher report bursting and scheduling
• Converted Oracle Reports to BI Publisher reports
• Worked on migrating repositories and web catalog across environments
• Worked on building OBIEE repositories using OLTP databases for Operational Reporting.
• Configured and implemented the AD External Authentication using SSO.
• Designed and developed Corporate Portals using PL/SQL and J2EE.
• Migrated Portal Content across various Portal instances.
• Worked on Data Loading and Data Modeling
• Worked on GAP Analysis
• Worked with the business groups in gathering the business/user requirements.
• Operating System: Windows 2003 Server and HP-UX 11.23
• Languages: PL / SQL, J2EE, HTML, XML, JavaScript.
• Special Software: OBIEE, BI Publisher, Oracle Portal 10.1.4, Apache, PDK

Confidential

Role Responsibilities:

• Installed and configured OBIEE 10.1.3 on Windows 2003.
• Worked on designing and developing OBIEE Repositories, BI Answers and Dashboards.
• Worked on migrating RPDs and Catalogues from Test to Production environments.
• Developed BI Publisher reports.
• Converted Oracle Reports to BI Publisher.

Environment:

Operating System: Windows 2003 Server and AIX

Languages: PL / SQL, HTML, XML, JavaScript.