Oracle Business Intelligence Administrator
Resume:
Gomathi Arunachalam
*******@*****.***
SUMMARY PROFESSIONAL EXPERIENCE
10 years of IT experience with 5 years in Data Warehousing and BI
Expert Level experience in Siebel Analytics and OBI EE 10g version.
Extensive work experience in Administration tools, Catalog Manager, Answers, Dashboards, and Delivers and excel plug-in.
Successful full life cycle Siebel implementation experience, customization and configuration for Pitney Bowes
Experience in Informatica power center, Repository Manager, Server Manager and Mapping Designer
Work experience in other reporting tools like Brio, Crystal Reports and Hyperion Essbase
Work experience in ETL tools like Informatica and Data Stage
Excellent Communicator both verbally and written
TECHNOLOGY EXPERTISE
Siebel
Oracle BI 10.1.3.3
Siebel Analytics ,7.8.4
Siebel Server Administration Siebel Tools (configuration)
Siebel Data Modeling
Siebel Marketing
Siebel Field Service
Siebel Sales
Siebel Call Center
Oracle
PL/SQL
SQL*Plus
Erwin
TOAD
Other Reporting Tools
Brio
Crystal Reports
Business Objects
Hyperion Essbase
Data Warehouse Tools
Informatica 5.x, 6.x, 7.x
EDUCATION & TRAINING
Masters in Computer Applications (MCA)
.
Project#1: AXA Reporting and Analytical Projects
Client: AXA Equitable, NJ MAR 2007-MAY 2009
ENVIRONMENT: OBI EE 10.1.3.3, SIEBEL ANALYTICS 7.8.4, ORACLE 9i, OAS, LINUX
Brief: AXA Reporting and Analytics Portals are used by all internal business groups to access the individual dashboard reports from the axaonline site. Two different systems of application are accessed from Windows and Linux environments.
• Worked as the OBI Administrator for all the BI Applications in the AXA Portal in both windows and Linux Environments.
• Worked in Erwin in data modeling the architecture of the BI Application requirements to meet the snow flake schema.
• Involved in all Administrative activities of creating groups, users, subject area security, dashboard reports security and data level security
• Expert in Merge and Migrating BI applications that include Repository and Catalog files from Development to Integration and Production Environments.
• Involved in many BI application deployment, developing repository in all three layers, developing complex reports in Answers, creating Dashboard reports, Filters, prompts and ibots. Projects involved are IVR system, Ariba, Burgundy Project, Flex sales project, Corporate Markets and Reg60
• Involved in all the phase of the SDLC in the project of requirement gathering, leading the team, design and develop the rpd and reports and target the deliverables.
• Have Experience in installing the OBI 10g software on the Linux servers and windows.
• Migrated applications from Siebel analytics version to OBI10g version.
• Involved in working with Excel Plug-in and Publisher features.
• Involved in the OBI server maintenance, backup of rpd and catalog files and start and stop the sa ,saw and sch services
• Query analysis and data analysis are done for performance on the OBI Reports using toad for faster response
• Implemented Event Polling to purge the cache after the production load and seed the cache by Scheduled the Dashboard Reports using ibots
• Also involved in all production support activities, incident ticket resolving, issues fixing and trouble shooting the problems.
Project#2: Gartner Data Warehouse Projects
Client: Gartner Inc, CT AUG 2006- FEB 2007
ENVIRONMENT: DATA STAGE 7.3, ORACLE 9i, SIEBEL ANALYTICS 7.8.4
Brief: Gartner Data warehouse is used for all the internal systems in Gartner Inc. to do analysis and bring high level reports to the management. The GDW involves data flow from different source systems, regular enhancements, administrative process control, Siebel reports are built to show the data to the higher management.
• Involved in developing the Siebel Analytics Reports for the GDW applications.
• Design the repository model and developed the summary reports.
• Also created feeds to the warehouse using Data stage for the requested enhancements.
• Build the data mart tables for reporting purpose, developed feeds to the mart and developed reports in Siebel Analytics.
• Involved in the regular support of the weekly loads to the Data warehouse
• Interacted with the end users in collecting the information on the reports build on the marts.
• Data analysis and verification done using Toad on the Oracle database
Project #3: Sales Tracking System
Client: The Bank of New York, NY MAY 2006 –JUL 2006
ENVIORNMENT: SIEBEL ANALYTICS 7.8.3, INFORMATICA 7.1 , ANSWERS, DASHBOARDS, UDB DB2 8, SUN SOLARIS 5.8
Brief: Sales Tracking System was initiated as a part of Corporate Banking of BNY to restructure the business process for Sales tracking. The Siebel Analytics application was developed for the top Executives to view, analyze the Win Loss Revenue.
• Involved in designing the Repository model using the Administrative Tool for the Sales Tracking System
• Built a new business model bringing in all the extension tables, required fields and building the business rules.
• Two presentation layers Sales Analysis and the Win Loss Analysis was created.
• Created five Dashboards with the Executive Summary reports top down navigating to the detail level of reports for the Sales Tracking System.
• Created Action Links to navigate from the Dashboard reports to a record in Siebel operational application.
• Created user groups for the Analytic Users reflecting the responsibility of the SFA users.
Project #3: Phase I – Field Service Integration
Client : Pitney Bowes Inc. CT APR 2004 – MAR 2006
ENVIORNMENT: SIEBEL ANALYTICS 7.5.2/7.7, INFORMATICA 5.1/7.1 , ANSWERS, DASHBOARDS, DELIVERS, ORACLE 9i, HP UNIX 11i, PL/SQL, APACHE/TOMCAT4.0
Brief: Develop/design and support Siebel Analytics Application for Field Service, Marketing and call center subject areas.
• The Field Service Enhancement project was implemented for the acquisition of the third party customers to Pitney Bowes Field Service Application. Involved extensively in the design and the implementations phase.
• Created dimensional tables and fact tables. Modified and redesigned the Physical, Business model layers and Presentation layer of the existing repository model with the new star schema.
• Designed and involved in configuring the intelligence dashboards for Siebel Analytics to target user groups of various levels in the organization. Designed the attributes in the Physical, Business and Presentation layers of repository and Siebel Answers.
• Installed and configured Siebel Analytics Web, Siebel Analytics Server, Scheduler, and Pop chart server in the test and production environment.
• Used Administrative tool to create dynamic variables, dimensions and levels with the required business logic functions in the Business model layer
• Designed the repository to incorporate data from different data sources.
• Created and designed Reseller reports and Entitlement Reports.
• Created separate dashboards for Field Service and scheduled reports through I-bots to be delivered to the respective Reseller e-mails.
• Used UNIX scripts to clear the Cache and to kick off the dashboard report scripts.
• Involved in the Installation, Configuration & administration of Siebel Analytics.
• Took backups of repository and web cat files
• Implemented Enhancements and Change Requests in accordance with SEI-CMMi level 2 process for process and documents
• Involved in the up gradation process of Siebel analytics from 5.1 to 7.7, User Acceptance and training for the new look and feel of the Application.
• Responsible for Authorization and Administration of User Groups, Securities and roles for different subject areas.
• Responsible for Data model Changes, Developing reports in Answers/Dashboards and scheduling reports in I-bots for various integration projects.
• Involved in creating the mappings and workflows, extensively worked on Informatica Power Center Client, Designer, Workflow Manager, workflow monitor and Repository Manager
• Responsible for the ETL processes like Scheduling Informatica Jobs, Used Informatica Workflow Monitor to monitor the Workflows and see log information for trouble shooting in case if the task fails.
• Involved in all activities of the Support for the production environment for the Siebel Analytics Application, provided 24x7 on-call support to the organization as the primary support.
Phase II – Integration (Call Center Module)
• The Call Center Project was implemented for the MIS reporting purposes. Involved in creating the new subject area, Call Center New in the repository
• Created new mappings in Informatica to bring in required fields to OLAP.
• Created new tables and appended new fields in the extension tables for the reporting purpose. Involved in working in all three layers physical, business and presentation of the repositories
• Two new user groups Call Center Power Users (PU) and Dashboard users (DB) were created in the repository to assign appropriate privileges
• All user groups are delivered with appropriate reports using the Siebel Analytics scheduler and generating proactive Delivers-iBot alerts
• Optimized complex OLAP reports requests by dividing into multiple reports. This feature has a top to down approach when viewing the data and was implemented using drilldowns.
• Performed various validations and scheduled the jobs in informatica.
• Involved in preparation of the test plan, test cases and test results along with the test data.
• Verified the reports results using TOAD in and OLTP (Siebel OLTP) databases.
Phase III – Integration (Sales Module)
• Worked with Business Analyst in gathering business requirements for the Analytics requirements from sales users.
• Involved in the customization of the Pipeline module for the Sales reporting project.
• Created new extended fields in the dx tables and applied through the physical, business and presentation layers bringing the data for reporting.
• Involved in creating highly interactive business intelligent report in Answers using Global filters, Charts, Pivot tables etc.
• Created separate Dashboard for the Sales users and all reports are deployed here.
• Sales reports qualify and tunes for high query performance and cache management is handled.
• Responsible to deliver Adhoc reports required by Business Analysts and Sales Account Managers
Project #4: Pipeline leadership project
Client: Dun & Bradstreet SEP 2003 – MAR 2004
ENVIORNMENT: SIEBEL ANALYTICS 7.7, INFORMATICA 7.1, MS SQL Server, WINDOWS 2000
Brief:
Pipeline Leadership project was initiated as a part of an overall strategy to restructure the business process for Sales tracking and lead conversion. Using a web-based platform, it enabled Sales Leaders and GLT members to view, analyze and scrutinize the composition of the revenue pipeline.
• Involved in understanding the new requirements of the system and working out the design solution to satisfy the enhancements of the Pipeline Leadership Application.
• Involved in developing the customized data model for pipeline subject area using the Siebel Administration tools.
• Involved in designing new Reports, creating the dashboard reports and publishing the required though delivers, bringing high-end reports for the Management.
• Also involved in some internal projects developing OLAP reports and AdHoc reports and preparing test cases for the reports.
Project #5: RRS (Regulatory reporting system)
Client: SBC Communications JUL 2003 – SEP2003
ENVIORNMENT: UNIX, PRISM WAREHOUSE EXECUTIVE, BUSINESS OBJECTS, ORACLE 8 AND WINDOWS 2000
Brief:
The Regulatory Reporting System is a data warehousing system that provides TA96 compliancy reports. The project involves the testing of the RRS, which is designed to provide evidence that SBC Ameritech has indeed opened local markets to competition for the nearby states formerly serviced competitors. The RRS system provides TA96 compliancy reports that demonstrate the level of service against the competitors. It receives data from multiple legacy systems, processes the data on a monthly basis, generating summary and details reports using business objects and posts the data on the Internet. Prism warehouse executive is used for transferring and loading data into the system.
• Involved in the analysis of the RRS, Analyzing the change requests raised by the LDC.
• Generated the product test plan with relevant test cases, execute the test cases, designing and executing the regression tests.
• Update the BO reports and execute the test cases on the reports.
• Also involved in the shell scripts writing to load data into the system.
Project #6: BAS (BUSINESS ANALYSIS SYSTEM)
Client: China mobile communication corp (CMCC) JAN 2003- JUN 2003
ENVIORNMENT: BRIO 6.6, IBM DB2 OLAP INTEGRATION SERVER 7.1, HYPERION ESSBASE SERVER, HYPERION APPLICATION MANAGER, DATA WAREHOUSE MANAGER 7
Brief:
The project involves building an integrated data warehouse from the source system from BOSS system. The data are extracted, transformed and loaded into the BAS System from the source systems. The data marts are built on various business areas, which include Income Analysis, Marketing, Customer Service, Network, Settlement, Competitor, Data Service and VIP analysis. The cubes are built using Hyperion Essbase integration server on these data marts with the hierarchy and levels specified for the drill down and rollup. The OLAP reports are developed from the cubes and are deployed on the web portal (Brio Portal) for the user to view and analyze the organization's performance. Involved in the following analysis
• Created Models, Meta outlines, Calculation, Filters, hierarchy for Dimensions on the Business areas using Hyperion Essbase Server
• Groups/ User Security applied on the OLAP cube application using Application Manager
• Developed OLAP reports with EIS, PIVOT, CHARTS, REPORTS along with drill up, drill down features using BRIO
• Scheduled the reports using the Broadcast Server and invoked brio thru On Demand server.
• Loaded history and current data in to data warehouse.
• Validated and performance tested the data loaded against the source System.
• Creation of Models with the business views and created ad-hoc reports.
• Developed ad-hoc reports in OLAP Integration Server
Project #7: CORPORATE MANAGEMENT SYSTEM (cms)
Client: EQUISERVE, NJ AUG 1999- MAY 2002
ENVIORNMENT: Crystal reports 6.0/8.0, sql server 6.5, sybase 11and segate crystal info 7.0.
Brief:
Involved in the analysis, database design, and conversion and integrating reports of Corporate Management system. This system provides solutions in shareholder services, investment plan administration, employee plan record keeping, and stock option plan administration, stock surveillance consulting, merger and acquisition processing.
• Involved in developing complex reports using Crystal Report Designer 6.0/8.0. Also involved in the conversion of corporate reports into user interactive reports.
• Handled almost 30 clients of Equiserve in creating adhoc reports and on demand reports.
• Involved in the migration of database from Sybase to SQL Server
• Created required tables and validated all the data involved in the conversion.
• Involved in the data warehouse analysis, used Seagate Holes tool to query the user requirement reports also involved in collecting/uploading the data to the database module for data warehousing.
• Involved in the implementation of Seagate Info 7.0 and Seagate Analysis for scheduling the reports on the Intranet, distributing reports on the desktop and giving user level permissions
• Also involved in developing web reports for the CMS application
Project #8: Consultant information system
Client: Computech Resources intl. NJ OCT1998- JUL1999
ENVIORNMENT: VISUAL BASIC 6.0, SQL SERVER 6.5 AND CRYSTAL REPORTS, SEAGATE CRYSTAL INFO 7.0
Brief:
Involved in the analysis, design, development, testing and documentation of Consultant Information system using Visual Basic 6.0 and SQL server 6.5. This system handles the information about the Consultants, Clients and Business alliances. Generated context-sensitive help files for the system. Designed several Cross-Tab reports and complex Sub-Reports and Standard Reports using Crystal Info Designer linking multiple tables using ODBC connectivity. Management reports were scheduled using crystal info. Worked with info Administrator, assigned security to user level and report level, implemented and scheduled reports on info desktop.
Project #9: ADVANCED INTEGRATED MANUFACTURING SYSTEM
Client : MASCON, INDIA JUN1997- SEP1998
ENVIRONMENT: VISUAL BASIC 5.0, MS SQL SERVER 6.5, CRYSTAL REPORT
Brief:
Involved in the deployment of an ERP Product, Advanced Integrated Manufacturing System using Visual Basic 5.0 and MS SQL Server 6.5 database. This system handles information about Production, Sales, Materials, Quality and Financial operation. Crystal report designer was extensively used to generate various complex reports linking multiple tables. Knowledge of the ActiveX and Custom Controls includes implementation methods, properties and effective use of the controls for the user interface implementation. Was responsible for report development, documentation and Implementation of the System for two clients MEIL and Indokem.
Contact this candidate