Resume

Sign in

Manager Data

Location:
Hyderabad, Telangana, India
Posted:
March 29, 2018

Contact this candidate

Resume:

RAJ

Email: ac4y49@r.postjobfree.com

Ph: 503-***-****

Summary:

Over 9years Information Technology experience including 6 years of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE 12C) / Oracle Business Intelligence Apps (BI Apps 11.1.1.8.1)

Extensively worked on Oracle Engineered Systems Exalogic, Exalytics, and Exadata Servers.

Installed Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps Financial Analytics, Informatica Power Center.

Expertise in Financial Analytics, Supply chain and Order management Analytics, Procurement and Spend specific Analytics, HR Analytics, in BI Apps.

ETL processes for a data warehouse implementation of Oracle EBS R12 using, extraction, transformation, dimension and fact building, loading, as well as in-depth knowledge of and experience with SCD

Implementing Oracle BI Apps Financial Analytics in Designing ETL, metadata management using ODI, OBIEE RPD development, OBIEE 12C reports and Dashboards on Oracle EBS R12 Financial Analytics.

Expertise in Managing Oracle Weblogic10.3.6, 12c created Domain Services

Experienced in Business Intelligence and Transactional applications, Design and implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.

Extensively used ODI (Oracle Data Integrator) to perform ELT from heterogeneous sources using ODI tools - Security Manger, Topology Manager, Designer and Operator with versions ODI 12c,11g,10g(10.1.3.5,10.3.5.6).

Hands on experience in developing procedures, Packages, interfaces and workflows in ODI.

Excellent knowledge on the ODI Knowledge Modules such as LKM, IKM, CKM, JKM.

Good experience in Installing and Configuring ODI environment.

Upgrading ODI from 10.1.3.C to 11.1.1.X on multiple platforms.

Patching ODI 11.1.1.6.0 to 11.1.1.6.4.

Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.

Worked on ODI 12c for migrating 11g Interfaces to 12c Mappings for customized Data warehouse.

Expertise working with OBIA customization (Type1 and Type 2).

Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.

Working in design, development and configuration of RPD, Dashboards, Reports, Analysis & Interactive Reporting, OBIEE 11g new functionality and implemented Filters, Scheduled Reports, Prompting, Drill Thru, Multi-lingual reporting, Performed XML Manipulation. Design reports and dashboards using OBIEE12C/11g dimensional hierarchies. Design And Develop ad-hoc queries, reports and dashboards.

Implemented Multi-user Development Environment (MUDE) Using Oracle BI Administration Tool.

Upgraded ODI repository from 11.1.1.7 to 12.1.2

Hands on experience in implementing vertical scalability and horizontal scalability for BI Server to load balance the requests

Worked in setting up security and architecture with OBIEE 12C/11g /10g by using web logic admin console and enterprise manager.

Implemented Essbase cube for General ledger reports for faster access to users

Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).

Work with business to gather and document business requirements and KPIs.

Implemented Performance tuning for ODI increase in Heap size, Perfint, Parallel sql runs, and Data Stats after full load completed

Worked with OEM team for Database Alerts and Production Spikes to Minimal Disruption to Business

Hands on experience in Installing SSO certificated in WebLogic for LDAP handshake logins

Working with new OBIEE 11g functionality and features (Score cards, Action links, Animated Graphs, Selection steps, Hierarchical columns.

Determine the technical feasibility of the requirements against the OBIEE capabilities.

Collecting the artifacts and connection details for the object to be upgrade for OBIEE, OBIA, INFORMATICA and DAC.

Applying Security from previous version to latest version users and groups in RPD (Repository Product Detail) be moved to web Logic.

Hands on experience with ETL, Dimensional Modeling & Business Intelligence & capability with the performance tuning of the OBIEE application suite.

Strong experience in developing warehousing applications and customizing Reports using OBIEE 11.1.1.6, 11.1.1.5 10.1.3.4.x/10.1.3.2.x, XML/BI Publisher, BI Answers.

Management (Data level/Object level security), Variables, Initialization blocks and cache management.

Worked on Setting up Dynamic, System and Non-System Variables.

Implemented Data Level and Object Level Security using External Table Authentication, as well as Presentation Services.

Implemented Oracle BI Apps in all phases like implementing, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards.

Extensively worked on Power Center Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager.

Technical Experience in developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.

Experienced with designing ETL execution plan and scheduling task using DAC.

Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL.

Technical Skills

OBIEE Tools Oracle BIEE 12C/11.1.1.7/10.1.3.1,Oracle BI Applications 7.9.5/7.9.6/7.9.6.4.

ETL Tool ODI12.1.2, ODI 11.1.1.7ODI 10g (10.1.3.5, 10.3.5.6) Informatica 8.6.0/8.6.1/9.1 & DAC

OBI Apps Modules Oracle Financials [GL, AP, AR], Oracle SCM [OM, PO, INV],

Oracle Manufacturing [OM, PO, INV], Sales Analytics, Procure and Spend Analytics

Human Resource Analytics.

Databases Oracle 12C, 11.0.2.4, 10g, MS SQL Server2000/2005/2008, DB2, PeopleSoft.

Methodologies Dimensional Data Modeling Logical / Physical

Database Tools TOAD, SQL Navigator, SQL* Loader, SQL* Plus, SQL* Developer, MySQL.

Languages SQL, PL/SQL, XML, Java, Shell scripting

Web Technologies HTML, JSP, XML.

RDBMS Oracle 11g R1/10g/9i/8i/7.x, MS Access, SQL Server 7.x.

Operating System Oracle Linux 2.3.eu, UNIX, Windows 7/XP/2000/98, Linux, MS-DOS.

Other Oracle Virtual Directory(OVD) and Oracle Internet Directory(OID), Putty

Education Qualifications:

Bachelor of Technology in Computer Science and Engineering, India.

Professional Experience

Walgreens, Deerfield, IL Dec ’14 – Till Date

Sr. BI Apps / WebLogic Admin

Responsibilities:

Worked with Development in Release 1 GL, SLA, Fixed assets code moved to production

Created and Cloned Instances from SIT environment to Pre-production in Exalytics.

Worked with Engineered system Exalytics for Kernel up-gradation Patch support PS4 for hung states

Worked on Opatch and applied multiple BI and ODI patches in Development and test environments

Scheduling month end activities Loads in Production for Full cube refresh, Incremental Loads, OOTB (out of the box) from Ebusiness to Data warehouse and Essbase cube.

Worked with Engineered systems and Oracle Support for Connection activity on Exalogic to Exalytics.

Involved in Monthly enhancement activities with Development team

Initiated Critical Command Center for Production Downtime to resolve the issue in time

Installed Bundle patch for BI for Smart view User logins

Monitoring ODI_Server,Admin_server,bi_server,External deployments,essbase server, ODIAgent in Productions instances and Lower environments

Installed BI Publisher patch for BIPUB Data model Mapping issue

Implemented Vertical Scalability for Load balance user’s requests.

Implemented Performance tuning for ODI increase in Heap size, Perfint, Parallel sql runs, and Data Stats after full load completed

Worked with OEM team for Database Alerts and Production Spikes to Minimal Disruption to Business

Cloned WebLogic and oracle Repository’s from production to lower environments to validate the Business Requirements.

Involved with External LDAP authentication team to create Business users accounts

Applied SSL Certificate in WebLogic Admin server for Handshake with LDAP server.

Worked on Exalytics and Exalogic Infiband SDP protocol issue with engineered teams.

Migrated ODI Models, variables, procedure, packages, scenarios, interfaces and loadplans to Multiple Environments

Worked on Hyperion Essbase cube Migrations.

Created User and groups assigned Roles and responsibilities in Multiple Instances

Created topology's for Hyperion Essbase,File,Oracle and set upped physical, logical and Context connections

Prepared documents for production support, cloning and patch's applied in environment.

Worked on customization, adding new custom source tables and columns to the OOTB tables.

Worked with oracle in fixing bugs encountered in various aspects.

Customized and configured FSM and BIACM.

Administrating and monitoring Load plans testing individual load plans after customizations.

Worked on creating new Temp interfaces and debugging the failed loads and identifying duplicate inserts

Worked with Enterprise Manager for deployment and servers monitoring.

Created functional and technical documents for Wag Managers.

Environments: OBIEE 11.1.1.8.1, ODI 11.1.1.7, OBIEE 12C, BIApps Financial Analytics Oracle EBS 12.1.3, SQL*PLUS, SQL Developer, Toad, Windows 7, Oracle Linux, WinScp, Putty, Exalytics, Exadata and Exalogic.

Heathway’s, TN Jan ’13 – Nov’14

Sr. OBIEE/ODI/BI Apps Developer

Responsibilities:

Involved in the installation, configuration, customization and extension of OBIA, for Financial Module.

Responsible for General Ledger and Sub ledger accounting for Actual and Trail balance Sheet.

Worked with Customize mappings upon Business requirements from E- Business Suite to Data warehouse

Applied Change Data Capture for Incremental loads for Customized Mappings

Installed Development, SIT, UAT, PERFTEST, PREPROD environments

Provided content filtering at BMM layer of RPD and used complex joins on logical data source (LTS) to join tables in BMM layer.

Worked with Enterprise Manager for deployment and control of repository, web catalog and configuring parameters.

Designed and developed new dashboard as per the user requirement using Prompts using OBIEE 11g.

Automated cache purging process using when daily Incremental loads Runs

Created Primary keys using Sequence Generator and loaded dimension from flat file using source analyzer and Expression builder in Informatica.

Worked on Customized Knowledge modules LKM, IKM,RKM,CKM

Implemented Data level security and Object level security.

Automated dashboard page refresh using custom Java code with user selected filter preference unchanged, used java code to change and customize BI Publisher reports for pixel perfect reporting.

Created MUD environment to avoid overlapping of RPD in other environments.

Used OBIEE environmental and Multi-User development (MUD) migration process to check out projects, merge changes, publish changes to network, and create migration plan to move repository (.rpd) respective environments

Increased Heap size for Java objects utilization Performance for User Requests

Worked with Web Logic Administration console to configure LDAP security within the OBIEE 11g using Application Groups and Roles.

Implemented Performance tuning for ODI increase in Heap size, Perfint, Parallel sql runs, and Data Stats after full load completed

Worked with OEM team for Database Alerts and Production Spikes to Minimal Disruption to Business

Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Principal and Teacher Evaluation dashboard.

Worked on gathering the requirement and artifacts and connection details for the object to be upgrade of OBIEE10g to OBIEE11.1.1.7

Worked on implementing the custom security OBIEE 11g with advantage of web logic and used Oracle Identity Manger to grant access to users.

Extensively used Presentation variables in FILTER function in the report, to filter each report based on the user requirements.

Created various Static and Dynamic variables for different report.

Created OBIEE Repository (.rpd) which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security

Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution

Configured Oracle BI scheduler in an application server that manages and schedules defined jobs.

Responsible for migrating the web catalog and RPD from DEV, SIT, UAT and PROD environments.

Customized existing and developed new SDE & SIL Informatica mappings using transformations like Lookup, Stored Procedure, Filter, Expression, and Aggregator.

Installing and Configuring ODI 12c on all the environments with standalone agents for custom Data Warehouse project.

Worked with new components in ODI 12c using expression,aggregate,filter,lookup,join and split transformation

Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Active Directory-LDAP, SQL Server and Oracle).

Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.

Created the users, profiles using the ODI security manager.

Extensively worked and utilized ODI Knowledge Modules (Reverse Engineering, Loading, Integration, Check, Journalizing and service)

Created various procedures and variables.

Created ODI Packages, Jobs of various complexities and automated process data flow.

Creating standalone agent on windows server.

Implemented CDC through ODI Journalization Knowledge Modules (KMs).

Configuring windows standalone agents with OPMN and running windows agents as services.

Patching ODI 11.1.1.6.0 to 11.1.1.6.4.

Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.

Worked with the team and a DBA to communicate and negotiate data needs

Developed various report for data extracts in different format for users in .PDF, .RTF and Excel.

Environments: OBIEE 11.1.1.7.1, ODI 11.1.1.7 BIApps Financial Analytics Oracle EBS 12.1.3, SQL*PLUS, SQL Developer, Toad, Windows 7, Oracle Linux, WinScp, Putty,

LexisNexis Martindale-Hubbell, New Jersey Mar ’12 – Dec ‘12

Sr. OBIEE/ODI Administrator

Responsibilities:

Requirement analysis gathering, analyzing the functional and technical specifications.

Creating separate environments for Development, QA and Production.

Installing ODI 11.1.1.6 on all the environments and configuring ODI.

Patching ODI 11.1.1.6.0 to 11.1.1.6.4.

Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.

Testing the newly upgraded ODI 11G, fixing issues related to upgrading and running ODI jobs as per schedule

Creating standalone agent on windows server.

Configuring windows standalone agents with OPMN and running windows agents as services.

Creating packages for Historical load and incremental load and running the jobs through agents.

Installed and Setup ODI Master Repository, Work Repository, Execution Repository

As an administrator I was responsible for security across multiple users and groups.

Responsible for moving scenarios across multiple environments.

Created Different user groups based on user role and responsibility.

Scheduling, monitoring jobs daily and data load from scheduled jobs.

Imported tables using connection pool and designed Star schema.

Developed RPD from scratch for custom warehouse to create OBIEE interactive reports.

Created presentation and server variables for reports.

Created global prompts to use across the Dashboard pages.

Performance tuned the existing parameters to improve and enhance the performance to load data for OBIEE reports development.

.

Environment: OBIEE 11.1.1.6.8, ODI 11.1.1.6.4, SQL Developer, Oracle 11g, SQL server.

Travel Click, CA Jun ’11 – Feb ‘12

Sr. OBIEE/Informatica Developer

Responsibilities:

Installation, Configuration and Administration of Informatica Power Center Client, Server(8.6.0),Oracle 10g and OBIEE 10.1.3.4

Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.

Extracted data from various source systems like relational data bases, Flat files and data into the data warehouse using Informatica on Demand.

Extensively used Informatica On Demand for replicating the data from Sales Force to local Database.

Developed new Adapters using Informatica 8.6.1, complete end to end development against Salesforce.com source.

Extensively worked in developing SalesForce Adapters for Sales and Opportunities.

Worked on extracting the legacy data from the application.

Created Facts like OpportunityLineitem, Opportunity History, Sales, Budget, Goals and dimensions like Opportunity, PriceBookEntry, User, Region, Account,

Created reusable transformations and Mapplets and used them in mappings.

Performed Execution plans in the DAC Console.

Custom built the OBIEE repository (RPD) from the scratch with 4 Facts and 9 Dimensions and 4 conformed Dimensions.

Created metrics like MTD Sales, QTD Sales, YTD Sales, MAGO Amount, QAGO Amount and MTD Expected Revenue, Opportunity Amount.

Performed high level and detailed design of the star schema as well as the reporting metadata.

Analyzed reporting requirements for dashboard reports and created dashboard prompts.

Created some Reports for analyzing the Trend in Opportunities, sales and Sales Reps Efficiency.

Developed complex and rich Reports using pivots tables, charts, and view selector. Used global and local Filters for data abstraction.

Developed various test scripts for business users for UAT and assisted them to use and understand the functionality of the tool.

Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.

Developed process for object level migration of web catalog, for post-production release of - enhanced and bug fixed reports

Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements..

Complete responsible for preparing the END to END Document.

Environment: OBIEE 10.1.3.4, Informatica 8.6.0, DAC 10.1.3.4, OBIA, Informatica On Demand, Sales Force, Flat Files, Oracle10g, Windows XP, PL/SQL, TOAD.

SunTrust Atlanta, Georgia Apr ‘10 – May ‘11

Sr. OBIEE/BI Apps Developer

Responsibilities:

Involved in gathering requirements and prepare Functional and Technical document for development of OBIA 7.9.6.3 Financial Analytics and HR Analytics.

Worked in customizing the out of the box mapping for HR Analytics in OBIA 7.9.6.3.

Developed Dashboards displaying the client requirements for new reports using HR Analytics.

Integrated OBIEE with EBS Financial and HR Analytics for developing custom Reports and Dashboards.

Worked extensively with Physical Layer, Business Layer and Presentation Layer to customize the existing business models and also developed new models for maintenance of HR Analytics.

Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.

Involved Answer reports, Dashboards and Filters migration from one instance to another instance. All OBIEE objects will be check in to SVN version control system.

Developed new reports for end user requirement using HR Analytics Data warehouse tables.

Integrated Fusion Charts with OBIEE per client requirement.

Involved in developing star and snow flake schema.

Involved in creating Fact and Dimensional tables base on requirement and source tables.

Provided full analytical functionality for the mobile professionals and enabled fully interactive dashboards and ad hoc analysis while disconnected from the corporate network (Disconnected Analytics).

Involved in BI Publisher Integration with OBIEE for using HR Analytics data.

Interacted with the business leads and Client to gather reporting requirements to provide focus on Analytics and mainly focusing on AR and AP.

Generated Functional Specifications for the additional data processing requirements.

Involved in designing the PL/SQL procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.

Involved in developing the Incremental ETL process by Informatica Mappings & Mapplets using various Transformations.

Experience with Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager.

Developed a Dimensional model that identifies the fact table Grain, Associated dimensions, Attributes, and Hierarchical drill paths.

Developed Informatica mappings using transformations like Lookup, Stored Procedure, Filter, Expression, and Aggregator.

Worked on PLP, SDE and SIL mappings & workflows in Informatica.

Used the tools and views of Data warehouse Admin Console, objects, tasks, Subject Areas.

Created Custom Execution Plans and Scheduling.

Used the Data Warehouse Administration Console (DAC) to build, load and configure the Oracle Business Analytics Warehouse.

Installed and used the Informatica Components to integrate with DAC.

Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment

Used OBIEE Add-Ins to insert, deploy, and analyze Reports in Excel and PowerPoint and also OBIEE Objects such as table views and chart views (BI Publisher).

Environment: OBIEE 11g/10g, BI Apps7.9.6.3 (HR, Financial), Informatica 8.x, DAC, Oracle EBS(Source System), Windows XP, UNIX and LINUX.

Terex Corporation Westport, CT Jun ‘09 – Mar ‘10

OBIEE /BI Apps Developer

Responsibilities:

Responsible for ETL and OBIEE Repository development for Financials and Procurement and Spend Analytics on 7.9.5.

Responsible for the upgrade of OBI Applications from 7.9.5 to 7.9.6 HR Analytics.

Responsible for developing OBIEE11g repository (RPD) from the scratch. Worked with ETL team to implement primary key, foreign key and composition key relationship among physical facts and dimension tables and also with EBS Financial and HR analytics.

Integrated OBIEE with EBS Financial and HR Analytics for developing custom Reports and Dashboards.

Worked with Oracle HR Analytics prebuilt content like OBIEE metadata, RPD, Datawarehouse objects and reports

Involved in integrating Oracle HR Analytics with Oracle EBS 11i.

Extracted, transformed, cleansed, and loaded (ETL) on a VLDB for AP, GL, AR data from Finance and other enterprise systems into Oracle business analytics warehouse (OBAW) via Informatica 8.1.1 and 8.6.0.

Extensively worked on SRs as per the client’s requirement to get the reports for the Business Analyzation.

Integrated OBIEE with EBS 11i for HR Analytics for Single Sign On (SSO).

Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.

Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.

Manage and execute tasks via Onsite and Offshore model.

Designed and Developed Dashboard Pages for HR Analytics and other Modules Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.

Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.

Customized Dashboard pages like Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.

Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.

Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.

Design and architect data model for OBIEE to meet business requirements

OBIA upgrade from 7.9.6.1 to 7.9.6.

Developed custom Informatica mappings for SDE and SIL to load OBAW from various data sources like flat files.

Validate data loads and fix any inconsistencies in data or errors in ETL mappings using Informatica 8.1.1 and 8.6.0

Administer heavy data load volumes and optimize performance issues across ETL with SQL and PL/SQL aggregations.

Build and administer OBIEE reports, Dashboards, IBots, Integration and user acceptance testing both canned, custom, adhoc reports.

Configured briefing books for offline dashboard content to specific group of users

Conducted training Sessions on Informatica power center.

Worked with migration and implemented migration strategies.

Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Provide SME knowledge and recommendations

Managed ETL changes via Informatica and fix any breaks in data loads.

Environments: OBIEE 10.1.3.4.1, OBIA 7.9.6.1,7.9.6.(HRAnalytics,Financial, Analytics,Supply Chain & Spend Analytics) Informatica 8.x, Data Warehouse Administration Console 10.1.3.4.1, Financial Analytics, Procurement, Spend Analytics,Oracle 10g/9i,Toad,MS SQL Server 2005/2008,Linux,Unix and Windows.

Igloo Corporation, TX Aug’08–May’09

OBIEE/BIApps Developer

Responsibilities:

Worked with Business Groups to identify, analyze, and document Business Requirements.

Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.

Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.

Created Primary keys using Sequence Generator and loaded dimension from flat file using source analyzer and Expression builder in Informatica.

Worked on customizing the OBIA Prebuilt mapping and loading metadata into DAC for initial full load.

Worked on adding new tasks to the DAC.

Built the Physical Layer /Business Model and Mapping Layer of the Repository by using Star and snowflake Schemas.

Defined dimensional hierarchies and associated the proper level of granularity to the fact table.

Created new logical measures required as per the business requirements.

Created catalog folder in the presentation layer and setup visibility of the presentation catalog to users with respect to their responsibilities.

Added data level security at the repository level. The data was restricted with respect to the group user belongs too.

Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.

Migrated Analytics RPD and Webcat from one environment to another.

Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.

Designed and implemented the single sign on (SSO).

Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.

Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.

Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Customized Dashboard pages like Marketing, Field Sales, Marketing Service, and etc.

Customized Dashboard pages like Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Details Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.

Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.

Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

Environments: Oracle Business Intelligence (OBIEE) 10.1.3.2.1, Oracle 10g/9i, SQL Server 2000, Linux, Windows.

Cubefore, India May ‘06 – Mar ‘08

Oracle Technical Consultant

The project tracking system was used to track the status of internal projects so that the application is accessible through web and different users could access and update the status at different geographical locations working at different times.

Responsibilities:

Participated in Requirements review

Involved in developing E-R model (Entity-Relationship)

Developed the SQL queries to create tables and Views.

Developed PL/SQL procedures, functions, Triggers using TOAD.

Loaded Data using SQL loader and developed the control files for the same.

Developed custom reports using SQL*Plus.

Wrote and executed test plans, maintained versions of change components to ensure accuracy and update.

Tested the software using many methodologies like Functional Testing, Load testing, and Regression Testing. Tuned few queries to resolve Performance issues.

Used SQL Loader to dump the data provided in the form of flat files from the legacy system into normalized staging tables.

Developed workbooks and worksheets using Oracle Discoverer for custom queries for analyzing data.

Environment: Oracle 8i



Contact this candidate