Project Developer

SHRUTHI KESARA

Los Angeles (c) 310-***-**** *********@*****.***

Professional Summary

Over 7+ years of experience in IT Industry and over 5+ years of experience in designing, development and implementation of OBIEE 11g/10g.

Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE 11.1.1.7, OBIEE 10.1.1.3.

Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping and Presentation layer.

Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake Schemas.

Experienced in working with Variable Manager to define session and repository variables and

initialization blocks to streamline administrative tasks and modify metadata content dynamically.

Proficient in Installation, Configuration and Administration of the OBIEE platform.

Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.

Skilled at creating and scheduling Agents/iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.

Experienced in configuring and setup of OBIEE Security using LDAP, Weblogic and External Database Tables and configuring object level and database level security.

Experienced in configuring Usage Tracking to improve the performance of overall OBIEE Platform.

Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.

Extensive experience in creating executive reports with BI Publisher integrated with OBIEE.

Highly skilled in Data Analysis, Data Modeling, Dimensional Modeling using Erwin tool.

Well versed in working with ETL Tools such as Informatica Power Center in creating Source/Target definitions, building Mappings/Mapplets and creating and monitoring Sessions/Workflows.

Experienced in creating Sessions, Workflows, Mappings, Mapplets using various available transformations in Informatica, including Router, Aggregator, and Lookup.

Functional knowledge of Oracle EBS 11i- R12 in Finance (AR, AP, GL, FA) and HRMS modules.

Competencies include Business Analysis, writing functional and technical specifications, business requirements and system requirements documentation, Issue Resolution, and Defect Management.

Skills

OBIEE Oracle Applications R12

Informatica XML Publisher

BI Publisher Oracle Reports

Oracle 10g/11g SQL Developer

SQL/PLSQL SQL*Loader

UNIX Oracle FNDLOAD

LINUX TOAD

Win7, Win Server, Win XP WinSCP

Work History

OBIEE Developer Jan 2013 - Mar 2016

Eappsys Info Solutions

BI Developer Jan 2012 - Dec 2012

Eappsys Limited

OBIEE Developer Aug 2010 - Nov 2011

IBM

Software Engineer Jan 2008 - Jun 2010

Wipro Technologies

Oracle Business Intelligence Consultant Apr 2015 - Mar 2016

Eappsys Info Solutions

Project: Fidelity UK.

Client: Fidelity International.

Environment: OBIEE 11.1.1.7.1, Informatica 9.0.1, Oracle 11g.

Project Summary: Fidelity International provides financial services to their customers. It uses OBIEE 11g as their reporting application. This project involved implementation of OBIEE to analyze financial data. Involved in entire lifecycle of Business Intelligence. I worked on both repository and User Interface (UI) development.

Key Responsibilities:

Worked during the whole life cycle of the project from requirements gathering to deployment.

Acted as a liaison between business users and BI team to facilitate understanding of business requirements.

Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.

Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Developed Time Series Objects using Ago and ToDate functions for time series comparisons.

Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.

Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.

Configured BI Scheduler and Oracle BI Delivers- Agents to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.

Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.

Implemented security based on LDAP Authentication.

Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.

Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.

Integrated BI Publisher with OBIEE to build reports in word, excel and doc format. Created various templates, reports, and prompts in BI Publisher.

Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Provided guidance and support to end users during the implementation and in production.

Oracle Data Migration Consultant Jul 2014 - Jul 2015

Eappsys Info Solutions

Project: SACMIG

Client: South Ayrshire Council

Environment : Oracle Applications r12(modules include HRMS, Payroll), Oracle FNDLOAD, Oracle

SQL*Loader, Oracle PL/SQL, Xml/BI Publisher, LINUX, UNIX, windows 7.

Project Summary: South Ayrshire Council upgraded from Oracle E-Business Suite 11i to 12.1.3 in July of 2014.

This project involved migration of data from legacy system to oracle applications r12. Developed and managed complete data migration process.

Key Responsibilities:

Developing routines to migrate various data extracts across various organizations in the SAC group into one R12 system.

Part of Enterprise wide Data Migration activities including HR, Payroll - Oracle R12 (12.1.3).

Worked on designing and coding the reconciliation procedures & scripts for reconciliation of data both on R12 (load) and legacy (extract) sides.

Data Migration remediation – identification of corrupt source data and timely remediation of transformational and load errors to ensure project milestones completed on time.

Oracle Business Intelligence Consultant Jan 2013 – May 2014

Eappsys Info Solutions

Project: Project Global Reach (PJR) – OBIEE

Client: IDIS Pharma

Environment: OBIEE 11.1.1.7, BI Publisher, Oracle 10g, EBS (Financial, Manufacturing, Projects, Supply Chain) SQL, Toad 9.6, Linux, Windows XP, XML.

Project Summary: IDIS is a pharmaceutical company which provides Healthcare services to the patients in need. They have used OBIEE 11g as the reporting tool to analyze their Sales and Products Data.

Key Responsibilities:

Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector and View Selector with Global and Local Filters using Oracle BI Presentation Services.

Used OBIEE Web Catalog to set up groups, access privileges and query privileges.

Created schedules to seed and purge cache for cache management.

Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.

Created Wireframes and Web-Mockups to give look and feel of UI to end users. Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA, BA and selected business users.

Oracle BI Developer Jan 2012 – Dec 2012

Eappsys Limited

Project : NHS-SBS Financial Analysis.

Client : NHS SBS, UK.

Environment: OBIEE 10.1.3, Informatica 8.6.1, DAC, Oracle10g, SQL Developer, Windows XP.

Project Summary: NHS Shared Business Services (NHS SBS), the market leader in business support services for NHS Trusts and organizations. NHS SBS provides innovative and reliable services to NHS by sharing best practice, improving financial control, maximizing purchasing power, Excellent Service.

Key Responsibilities:

Developed and customized the coding of Informatica Mapping for the different stages of ETL (SDE/SIL/PLP).

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Extensively used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator, Joiner and Sequence generator.

Used Informatica Workflow manger to create Sessions, Workflows and worklets to run the mappings.

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Customized OBIEE Repository as per user requirements and available information in Date Warehouse.

Oracle Business Intelligence Developer Aug 2010 – Nov 2011

IBM

Project: GT HR Analysis

Client: Galliford Try, UK.

Environment: OBIEE 10.1.3.4.1, Informatica 8.6.1, DAC, Oracle BI Applications 7.9.6, Oracle10g, SQL Developer, Windows XP.

Project Summary: Galliford Try is a construction company delivering industry leading performance in the construction of a sustainable future. Galliford try implementing an enterprise level data warehouse in the Development and that will include data needed to fill HR analytic and cross-platform operational needs.

Key Responsibilities:

Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.

Incorporated all the customizations in RPD from all the customizations done in Informatica.

Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.

Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.

Configured Measures in the Business Model Layer and mapped to multiple logical table sources.

Performed unit and integration testing of reports and dashboards.

Software Developer Aug 2009 – Jun 2010

Wipro Technologies

Project: KTLO (Keep The Lights On).

Client : Credit Suisse, United Kingdom.

Environment: OBIEE 10.1.3, Informatica 8.1, DAC 7.9.4, Oracle 10g.

Project Summary: Credit Suisse is a leading global private bank with distinctive investment banking capabilities. It uses OBIEE 10g as their reporting application to analyze the data.

Key Responsibilities:

Worked closely with Business Analyst in understanding the BI and reporting requirements and created the business model for generating reports as per the user requirements.

Worked closely with the data modeler in designing the logical data model in star schema in BMM Layer.

Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Repository using Administration Tool.

Managed security privileges for each subject area and dashboards according to the requirements.

Developed various kinds of request queries using BI Answers and assigned them to specific Dashboards.

Created Security settings in OBIEE Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Answers.

Developed intuitive and user friendly Dashboards by appropriately including guided navigational links, prompts, and drilldowns.

Involved in unit testing, integration testing of the reports generated by OBIEE.

Software Developer Jun 2008 - Jul 2009

Wipro Technologies

Project: Vistakon BI

Client: Vistakon (Business Unit of Johnson and Johnson), USA.

Environment: OBIEE 10.1.3.x, Informatica 8.1, DAC, Oracle BI Applications 7.9.3, Oracle10g, Putty, Sql Developer, Windows XP.

Project Summary: Vistakon is a multinational medical devices manufacturer which offers products and services to their customers. Worked on generating various adhoc reports and dashboards to track the sales activity.

Key Responsibilities:

Interacted with BA, Sales Managers, Sales Representatives, and DBA to gather Analytics Reports/Dashboards requirements and to define business and functional specifications.

Customized and developed RPD (Physical, BMM and Presentation Layer).

Developed many Reports/Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE.

Used various Time series functions to create trending reports of sales.

Worked with DBA and SME towards performance tuning.

Performed unit and integration testing of reports and dashboards.

Education

Bachelors of Technology: Computer Science and Engineering

2008

Jawaharlal Nehru Technological University

India

Contact this candidate