SUMMARY

• Around 11 years of total experience in Business Intelligence and Data warehousing.
• Worked extensively on Oracle Business Intelligence, Oracle BI Apps and Oracle BI Publisher.
• Expertise in designing logical data models, designing reporting solutions and defining administration practices in Oracle BI.
• Strong knowledge in upgrading BI Applications.
• Experience in using Tableau, Spotfire, Business Objects and Cognos.
• Knowledge in ETL tools like Informatica and Datastage.
• Worked on different databases like Oracle, DB2, Hyperion, Sparkline and Green Plum.
• Experience in working with AWS architecture.
• Good knowledge in Finance, Banking, HR Analytics and Transportation domains.

TECHNICAL SKILLS

Applications: Oracle Business Intelligence Enterprise Edition 10.1.3.4, 11.1.1.5, 11.1.1.7, 12.2.1.0, 12.2.1.3, Oracle BI Publisher 12C, Oracle BI Applications 11g, Business Objects, Spotfire, Tableau

Databases: Oracle 10g, 11g, 12c, DB2, Hyperion, Sparkline, Green Plum

Operating Systems: Windows, Linux

Languages: C, Java, HTML

Tools: & Utilities: SQL Developer, Toad, ERWin, Putty, WinScp, PG Admin

PROFESSIONAL EXPERIENCE

OBIEE Analyst

Responsibilities:

• Work closely with financial business leaders and business users to understand their requirements and analyze the business needs which should be implemented as a solution within Confidential .
• After analyzing the business requirements, design a solution for those requirements in Confidential application. Designing a solution involves different stages like, preparing a high - level design and low-level design which includes modelling of data from existing source systems and define data flow from source systems into the analytics solution.
• For some requirements, preparing a proof of concept is also part of the design.
• For the new requirements in the existing application, design a solution that will fit into the existing system without disturbing the working application.
• Work with business leaders with the proposed design and make necessary changes as needed for their requirement.
• Implement the proposed design as a solution using Oracle BI along with other required Databases, tools and utilities as needed.
• Test the implemented solution in different stages before releasing it to live application. During the stages of testing, revisit the solution/design in case of any inconsistencies/issues.
• With respect to using the existing analytics application, prepare instruction manuals for end users which will help them in using the application with all the features. Sometimes when the users are very new, it is also required to train/guide them on using the application.
• If application needs to be upgraded, analyze the benefits and new features of the application in terms of efficiency and cost which helps to make decision if the upgrade is worth going ahead. Also do an impact analysis to see if upgrading the application will break any existing functionality.
• Design, plan and implement application upgrades when the software needs to be upgraded. Estimate and propose the hardware and software changes required for the upgrade.
• Research on new relevant technologies or plug-ins for the existing application that would increase the productivity and efficiency in terms of serving the business requirements.

OBIEE architect

Responsibilities:

• Gathering the requirements about enhancement requests. These enhancement requests sometimes involve creation of additional reports in an existing dashboard or creating new views.
• For enhancement requests where change of data model is involved, doing an impact analysis to see if new requirement would break any existing functionality.
• Plan and design and implement the solution based on new enhancement request. The solution should be planned in a way that existing report model is not affected in terms of performance or usability.
• Played a very crucial role in planning and executing a tech refresh activity where the existing application is upgraded from 11g to 12c, which is a major upgrade. The activity also involved moving the application from old infrastructure to new infrastructure.
• Tech refresh activity included planning and executing of the upgrade activity on a test environment first to identify the issues with new version of the application and analyze on workaround solutions for those issues.
• While analyzing and discovering new workarounds, work with product vendor in reporting the bugs and have them create patches for issues identified as bugs.
• Work with business leaders with respect to change in security requirements of the data. Since the reports contains sensitive and confidential data, only authorized users should be able to view the data.
• Design a security model according to the requirements and apply that model on the current application.
• Train end users in usage of the application and creating adhoc analysis which will help them to create their own views of data.
• With respect to application issues, interact with users to understand the exact issue, identify the problem and work on a solution to fix the issue.
• For application bugs, do a detailed analysis of the issue and create possible workaround solution for smooth running of the application.
• Working with Oracle, the application vendor with respect to application bugs for a permanent solution or patch.
• Plan and install the patches or upgrades required for the application to improve the performance and availability of the application.
• Suggested new plug-ins available with the application which will help to create reports within Microsoft Office tools. Installed those plug-ins and trained users in using them which helped them to use the data more efficiently.

OBIEE Analytics

Confidential

Responsibilities:

• Understand and analyze the requirements in creating new reports. This sometimes involves creating of requirement understanding documents and meeting with business leaders for more clarity on the requirements.
• Do a deep analysis of data model used in the data warehouse to understand the flow of data from source systems. This helps in designing the solutions based on existing data model.
• Based on the requirement and existing data model, design a solution within OBIEE and create a design and a proof of concept of proposed solution.
• Present the proof of concept to business leaders and discuss any changes to the design and in corporate them in proof of concept before getting the design approval from business leaders.
• Based on the design approval, prepare high-level and low-level design documents which will help in executing the solution within OBIEE.
• Plan and contribute in development of the solution using design documents. Initial testing of solution is also involved during development to make sure the solution is in line with the requirements.
• Plan migration of developed solution to testing instance where the application is tested for data integrity, quality and performance by dedicated testers. Any test defects reported during this phase are to be fixed and migrate them back for testing. This sometimes involves change in the design.
• Plan for production release of the solution upon signoff from testing team and business leaders. Production release involves migrating the existing solution to live instance where users will be now directly using the solution.
• Post production issues are supported for 30 days after going live, post which the issues will be handled by a separate application support team. During this transition, knowledge transfer to support team with respect to the new solution is involved.

Confidential

Responsibilities:

• Help users to fix the issues with respect to the application. This involves interacting with users and understanding the exact issue and fix it accordingly.
• Some of the issues involves revisiting the solution and in such cases, designing of new solution followed by implementing and testing of the solution before it is moved to production.
• Help users with necessary steps in using the application when they are new to the system and need guidance in viewing or analyzing the reports.
• Fixing performance issues with respect to existing reports. This involves fine tuning of the reports by applying performance improvement techniques and best practices. This sometimes involves fine tuning of the queries generated by the application.
• Ensure object level and date level security is working as per expectation so that highly sensitive financial data is protected from unauthorized access.
• Working with Oracle in terms of application bugs for a solution. Upon receipt of the solution from vendor, apply that solution in development instance first, test it and then move it to production.
• Support for month-end and quarter-end activities by closely monitoring the health of the application and helping users with any performance issues due to heavy load on the application during peak times.
• Gather timely statistics of usage of the application to plan for any technology upgrades to match with load on the system.

Confidential

Responsibilities:

• Gather requirements of the application by interacting with business users and study the existing reports they are creating manually.
• Study how data is captured in source systems and how it is being transformed and loaded into reporting data warehouse.
• Prepare a design to generate the reports using OBIEE. The reports include the standard reports that users manually generated previously.
• Prepare a security design to authorize users based on their role. This involved studying of different roles of application users and their requirements.
• Execute the design in OBIEE and create reports according to the requirement. The reports are matched with manual reports of users to ensure that solution is matching with the expectation.
• Created reports are tested by dedicated testing team and then by users for providing sign off. During this phase, all the defects raised by testers and users are fixed and the fixes are re-tested.
• Approved solution is moved to Production for users to use this automated solution to generate financial reports.
• Post production support of 30 days is given to the users for any issues that came up during this period.

Confidential

Responsibilities:

• Define coding and quality standards to be followed in a newly setup OBIEE application which should be followed by the team of developers.
• Defined and streamlined the process of deployments and migrations from lower environments till production.
• Prepared a checklist of items that need to be reviewed by the Confidential Architects teams while Development team is trying to migrate the objects from lower environments to Production.
• Since it is a new environment that is setup with OBIEE 11g, documented the new features that came along with this version of OBIEE that will suit the requirements in the project. New dashboards and reports are developed with these new features which helped as a reference for new enhancements.
• Developed reusable components within OBIEE 11g, that can be used by development teams in various scenarios. These components are developed with following all the best practices and coding standards.
• Documented best practices according to the requirement of the project which will be used by development teams as a reference.

Confidential

Responsibilities:

• Studied the requirement and analyzed the functionality of existing java based reports and their usage.
• Participated in designing a logical data model to be built in a Data warehouse using DataStage as ETL tool.
• Converted the business requirements into technical terms and prepared high-level and low-level design documents for developing a reporting solution in OBIEE.
• Built a PoC to demonstrate sample reports in OBIEE which will replace the reports built on Java. The PoC is verified and approved by the business users.
• Once the PoC is approved, designed and developed the repository which is the metadata layer for building reports and dashboards.
• Designed and developed reports on top of the repository.
• Participated in testing and resolution of defects raised by the testing team.
• Trained business users in using the newly built application for reports and analysis.
• Involved in post-production support activities.

Confidential

Responsibilities:

• Analyzed the out of the box solution provided by Oracle and studied the requirements of the project to understand the gaps.
• Based on the gaps identified, designed data model to fit in the requirements of the project and accordingly new database objects are created.
• Based on the new data model, designed and developed repository which will help to develop reports according to the reporting requirements.
• Used the existing out of the box reports and made necessary changes to replicate the reports according to the requirements.
• Participated in unit testing and defect resolution during user acceptance testing.
• Documentation of customizations done in repository and report development.

OBIEE Migration

Confidential

Responsibilities:

• Analyzed the existing reporting solution built on Actuate and specifications of the reporting requirements.
• Analyzing the feasibility of building similar reports in OBIEE and Oracle BI Publisher.
• Designed and developed SQL queries to create BI Publisher reports without using OBIEE metadata.
• Designed and developed report templates in BI Publisher to create visually similar reports to Actuate.
• To develop similar reports in OBIEE, created a repository with simple data model with all the tables used to build sample reports.
• Designed and developed OBIEE reports on top of the developed repository.
• Documented the pros and cons for both the approaches.
• Presented the reports built on both OBIEE and BI Publisher to business managers along with detailed analysis of pros and cons in using both the tools.
• Designed and developed proof of concepts for client presentations which will showcase the reporting capabilities according to project requirements.
• Worked in short-term and long-term end-to-end development project implementations within OBIEE for various customers.
• Participated in quoting effort estimations for project planning for new projects on OBIEE.
• Organized and facilitated trainings on OBIEE for project needs and re-skilling of associates for new technologies.
• Developed re-usable OBIEE solutions which can be used by internal project teams.
• Prepared training materials and published technical papers on various features and techniques in OBIEE.
• Handled administration Citirix servers hosting various BI applications which will be used for trainings and hands-on for internal project teams.