Siebel Analytics Developer Resume Samples

Description :

1. Provided customers with the advice and information that they seek through the distribution options of their choice, offering proprietary and non-proprietary investment and insurance products supported by excellent service.
2. Identified the Facts and Dimensions based on the design specification.
3. Extensively worked on Answers, Dashboards and Security for users.
4. Worked on creating complex reports.
5. Worked closely with Business Analyst, during the JAD sessions and gathered the Analytics requirements.
6. Installed Analytics Application in Dev, Test and UAT Environments.
7. Created Star schemas like: Call Account, Call contact, Objective Star and Territory time Stars.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. Installed and set up Informatica environment and responsible for administration and migration or repositories between various environments Used DAC.
2. Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings.
3. Created business reports using Siebel Answers as per requirements.
4. Created iBots and delivers to send alert messages to subscribed user groups.
5. Configured and administered existing subject areas and created new subject areas as per the modified Star schema information.
6. Created Dimensions, Aggregations and Keys using admin tool.
7. Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. Used to increase the sales and to strengthen their marketing strategy.
2. Worked closely with Business Analyst, Discussed and Gathered the KPI's from different user groups and created the Business Model using Star and Snowflake schemas.
3. Worked on Target Levels, Qualified list items, List Catalogs, Confirming Dimension Links.
4. Created Repositories, Physical Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool.
5. Created dimensions, aggregations and levels using admin tool in the Business Model and Mapping Layer.
6. Worked with the Security settings in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges.
7. Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.

Experience

7-10 Years

Level

Management

Education

Master's

Description :

1. Created reports like Inventory reports, Supply Disruption reports, Major Pricing Challenges, Major Pricing Opportunities, Operational metrics reports, Inter-Company Sales reports, feed through Productivity reports, and Performance reports.
2. Involved in translating high-level business requirements into logical business dimensional models.
3. Designed and developed the OBIEE/Siebel Analytics Metadata Repository (.rpd) using OBIEE 10.1.3.x Admin Tool by importing the required database objects both Facts and Dimensions with integrity constraints into the physical layer using a connection pool.
4. Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model, and Mapping Layer and Presentation Layer.
5. Created Hierarchies, Levels, and implemented Business Logic by creating level-based measures in the OBIEE business model & mapping layer.
6. Identified and created aggregate tables to improve query performance.
7. Collaborated with territory TSMs to Provide VARs with monthly reports detailing outstanding Oracle opportunities.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Worked in Sales Data Mart Project.
2. Implemented a data warehouse as a single repository of sales data and develop reports to cater to the needs of all levels of the Sales organization, from Sales Representatives to Executives.
3. Worked closely with the Business Community to assess Business Needs, define Requirements and Implement Solutions.
4. Interacted with Program Managers & QA teams located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
5. Designed Siebel Web Components including OBIEE Answers and Intelligence Dashboards.
6. Built repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.
7. Created Dimension Hierarchies, Aggregation Criteria and multiple logical sources in the BMM layer.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. Maintained company global external website, optimizing look, and feel, functionality, navigation logic, etc.
2. Designed and wrote web pages with a combination of codes (e.g., HTML, JavaScript, PHP).
3. Programmed web pages working with databases and programming languages to perform back-end work (i.e., MySQL, PHP).
4. Maintained and developed the companys intranet.
5. Experienced integrating website lead flow to CRM (i.e., Siebel, SF.com).
6. Managed and developed site functionality, site architecture, data-flow parameters particularly sales lead flows, user interfaces, and intuitive navigation schemes.
7. Executed the indirect sales strategy of assigned Partner(s) in assigned territory.

Experience

7-10 Years

Level

Management

Education

Masters Of Business Administration

Description :

1. Reported tool used by wholesaler/Retailers.
2. Tracked all these objectives they are some reports developed by store, duration, description of objectives, Sales Summary for particular store.
3. Used Answers to customize reports for additional views and interactive/ drillable charts.
4. Developed different kinds of reports using pivots, charts and global and local filters using Siebel Answers.
5. Employed Siebel recommended design principles and best practices for Dashboards and Reports development.
6. Mapped in data sources using Oracle BIEE Admin tool to create repository.
7. Created dashboards using analytics requests and assign Permissions to dashboards depending on their user group.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Worked with the Physical layer to create joins between tables to build star schema.
2. Created aliases for tables in the physical layer for analytics requirements.
3. Worked extensively with BMM layer to develop various business models.
4. Created dimensional hierarchies and assigned levels and custom aggregation rules for each level.
5. Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
6. Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation Layer.
7. Created various aggregate tables to improve the query performance.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. Experienced in Migration of objects across Local (DEV), Test (QA) and Central Locations (PROD).
2. Experienced in Cache management and Performance tuning in OBIEE and Informatica Experience in Analysis and collecting business requirements from Business Analysts and users.
3. Experienced in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
4. Experienced in troubleshooting SQL queries and improve data delivery performance.
5. Experienced in building, configuring and managing repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers.
6. Capabled of designing/creating, Subject Area in Analytics Repository (RPD) based on the Business requirements.
7. Hands-on experience in developing Oracle Business Intelligence and Siebel Analytics Repository consisting of three layers.

Experience

10+ Years

Level

Senior

Education

Diploma In Computer Programming

Description :

1. Identified Facts, Dimensions, and Hierarchies of the business model.
2. Involved in Analysis, Requirement gathering, function/technical specification, development and testing.
3. Identified the granularity level of the business model based on the end user requirements.
4. Extensively used OBIEE Administration Tool for customizing and modifying the physical, business, and Presentation layer of the repository.
5. Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
6. Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
7. Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

Experience

10+ Years

Level

Senior

Education

Masters Of Business Administration