Oracle Sql Server
Resume:
Kuziva Mutsvaru
Senior Analytics Developer
Sweetwater, TX 79556
*********@*****.***
CAREER PROFILE
Over 5 years of experience in Software Development and Expertise in OBIEE
10.1.3.3.2/ 7.7.1and 7.8.4, Oracle 10g/9i Administration, SQL Server
Administration, SQL, PL/SQL Development,. Web Based Technologies and
Client Server Technologies.
In which 3 + year of experience in OBIEE 10.1.3.3.2, Oracle BI Applications
7.9.4, Siebel Analytics 7.7 which include building and configuring repository,
creating and managing oracle/siebel Intelligent Dashboards, oracle/siebel
Answers, oracle/siebel Delivers and oracle/siebel iBots.
Responsibility includes gathering business requirements, analysis, design, data
modeling, development, Client Interaction, and Compiling Specifications from
client, Modification and Testing.
Team player and an individual contributor with steep learning curve and good
interpersonal skills.
Experience in Installation, Configuration, and Administration of Oracle BI
Apps 7.9.4, OBIEE 10g standalone.
Hands on experience in administrating oracle 10g/9i and SQL Server 2005/2000
databases in DEV and TEST Environments.
Experience with repository development, configured metadata objects (Subject
Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders,
Reports). Added Metadata changes to the OBI/Siebel Analytics .rpd
Business Intelligence–
Responsible for interacting with business partners to identify information needs and
business requirements for reports.
Strong in Analysis and collecting business requirements from BSA’s, users.
Expertise in creating Business / Functional Documentation for Business Analytics
OBI EE Stand Alone (Siebel Analytics)
Experience in building and deploying an OBIEE repository (Physical,
Business and presentation model) to create Dashboards, answers, ibots.
Experience in creating dimension hierarchies and level based measures.
Experience in adding disparate sources to business model objects
Experience in modeling aggregate tables to speed processing.
Experience in building calculated measures for the fact tables
Experience in setting up a Multi User Development Environment (MUDE).
Proficient in using the time series functions to support historical time
comparison analysis.
Experience in using OBIEE answers to run queries to test and validate the
repository.
Experience in creating requests, adding filters, creating prompts, and
creating pivot tables using OBIEE.
Data Modeling
Good Understanding of Dimensional data models, Star schema/Snow Flake,
identification of fact and dimension tables, Normalization.
Communication Skills
Excellent written/documentation, verbal communication skills.
Education
Bachelor of Science Computer Information Systems, Lincoln University, MO
TECHNICAL SKILLS
Operating Systems Unix, Windows 2003/2000 Server, XP Professional.
Business Intelligence Oracle Business Applications 7.9.4, OBI EE Dashboards,
Answers,
CRM (Siebel Ibots, BI Publisher.
Analytics) Siebel Analytics 7.7 Siebel tools.
Oracle 10G/9.2/8i/, MS SQL Server 2005/2000, MS Access.
Databases
MS Office Enterprise, MS Visio
Database & Office
Tools
Languages SQL, and HTML
EXPERIENCE
Role: Oracle Business Intelligence Developer
February 2010 – Till Date
Client: Corioliysis, Dallas, TX
Roles and Responsibilities:
OBI EE (Repository(.rpd Development), Dashboards, Answers, Ibots and BI
Publisher)
Worked closely with Business Analyst in understanding the Analytics requirements
•
and created the business model for generating reports as per the user requirements.
Configured OBIEE Repository like implementation of physical data model as per
•
requirements, importing the tables and having the physical joins/keys required and
changed the physical joins/key on the existing tables.
Modeling activities which included building star schema as per the business
•
requirements and configuration of Logical Layer, Logical tables, dimensions and
columns in Business and Mapping model layer. Established the logical joins/keys
required to support drill down aggregation.
Created dimension hierarchies and assigned levels for each level.
•
Designed and Configured Dashboards in Analytics for different groups of users to
•
view figures across regions, products with the facility to drill down to individual
customer relationship manager.
Developed Role Based Dashboards for Managers and Business Heads to review the
•
Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze
the financial service center statistics for different campaigns, Customized pre built
dashboards.
Developed custom reports/Ad hoc queries using OBI Answers and Filters.
•
Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
•
Responsible for Unit and System Testing and Performed Data Validation for all the
•
reports that are generated from OBIEE.
Performed Testing of the IT Defects and CR raised by the Testing team.
•
Environment: Oracle Business Intelligence suite (OBI EE), Oracle 11i upgrade,
Oracle 10g, Toad 9.0, Windows Adv Server 2003, SQL.
Role: Oracle Business Intelligence and Oracle BI Apps Developer
February 2009 January 2010
Client: Citigroup, Dallas, TX
Roles and Responsibilities:
OBI EE (Repository(.rpd Development), Dashboards, Answers, Ibots and BI
Publisher)
Involved in preliminary source system analysis to the collected Business
•
requirements from the BSA.
Involved in meetings/interviews with users, BSA’s, and data analysts, and examined
•
the business, functional and technical requirement documentation.
Used simple to complex analytical SQL queries against the source databases to
•
identify and analyze the authenticity of the data before importing to build the OBI
repository.
Involved in laying out a strategy with senior management and technical team for
•
building the metadata that presents the business model to support the business
requirements.
Involved in creating POC’s (proof of concepts) for the repositories and business
•
functionalities with the architect team and business users.
Identified the appropriate facts, metrics, hierarchies, and territories to structure the
•
initial conceptual model of the business from the requirement documentation.
Identified the source and target schemas and the ER relationships to support the
•
business reporting model.
Identified the lowest level of detail (Grain) and rollups drill mechanism.
•
Created a repository using OBI Administration tool by importing tables into the
•
physical layer and created the business and mapping model to incorporate the
business logic.
Add calculated measures that involve operations on existing columns.
•
Add time series calculations (for example, percent change in a measure compared to
•
same period in previous year).
Created presentation catalog which allows exposing the business model to users in
•
Oracle BI Answers so that users can build requests to analyze the data.
Created presentation folders and test with Answers.
•
Use the query log to verify query results and debugging issues if any.
•
Created Dashboard Pages, Creating a New Interactive Dashboard Page by using
•
answers from presentation catalog.
Created Prompts to Filter Interactive Dashboard Data and Configuring Guided
•
Navigation Links
• Created Pivot tables, views, charts.
• Created and Delivering an iBot
Environment: Oracle Business Intelligence suite (OBI EE), Oracle BI Applications
Oracle 10g, SQL Server 2005/2000, Toad 9.0, SQL, PL/SQL, Solaris 9/10
Role: Siebel Analytics Developer Feb 08 to Jan 09
Client: Coriolisys(Dallas,TX)
Roles and Responsibilities:
Siebel Analytics
• Performed Installation & Configuration of Siebel Analytics Software to set up the
enterprise.
• Reviewed Functional Design Document and Technical Design Document.
• Worked closely with Business Analyst, Discussed and Gathered the Analytics
requirements from different user groups.
• Designed Prototype of the project repository and developed reports/dashboards to
make it easier for business users to visualize how reports will look like in Siebel
Analytics.
• Modeling activities which included building star schema as per the business
requirements and configuration of Logical Layer, Logical tables, dimensions and
columns. Established the logical joins/keys.
• Used Aggregate Tables and specified Aggregate Levels for each source.
• Designed Intelligence Dashboards and created Global Filters.
• Customized the logical tables and columns, defined the Analytics dimensions,
aggregations and levels.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in
BMM layer.
• Configured charts, views, filters in user interface. Configured Global Filters and
Prompts in Siebel Analytics Web.
• Added new Dimensions and Columns to the Subject Areas to full fill the additional
Requirements of the Business Analysts.
• Used customized, Dashboard prompts, & local prompts.
• Formatting results, Filtering requests, and Showing results with Pivot, Chart.
• Involved with the Testing team to resolve, fixing and testing problems found during
the Systems integration test.
Alliance Data Systems, Dallas, TX Sep 05 –Jan 08
Senior Siebel Analytics Developer
Responsibilities:
Identified the granularity level of the data required to be available for analysis.
Implemented comprehensive security functionality by creating users & web groups,
external table security using session variables, test and validate the model using
Siebel Analytics Server Admin tool and associating catalog objects and Web
modules with the created users and groups
Developed Metadata repository (.rpd), configured metadata the Business Model
Layer & Physical Data Model and Web Catalog Objects as per the data
requirements using Siebel Analytics Admin and Web tool.
Worked on Siebel Answers to build Interactive Dashboards with drill down
capabilities.
Designed the business model conforming to functional mapping, defined logical
and complex joins for the dimension tables.
Configured the territorial hierarchy and worked with time series objects.
Configured Sales and Distribution Facts using analytics and generated reports
according to the business requirement.
Used Filters and provided Customized prompts appropriately to avoid excessive
data showing up Reports
Identified the aggregate levels for each source and created dimension sources for
each level of aggregates
Assisted in creation of pivot table request allowing manager to analyze the business
from different perspectives, provided optimized analytics request using column
selector
Configured the NQSCONFIG.INI file for Usage Tracking using direct insertion.
Created comprehensive and easy to understand Documentation of the complete
implementation of Analytics that includes (.rpd, Dashboards, Security etc.).
Generated queries and placed filters in Siebel Answers and created numerous
executive level reports. ‘Dashboards’ were generated to provide insight into the
sales/marketing/financial data
Exposed to Oracle Business Intelligence and performed proof of concepts on
Oracle BI publisher.
Environment: Siebel Analytics 7.8.5, Siebel Answers, Siebel Dashboards, Siebel Delivers
& iBots, Oracle 9i/8i, SQL, XML, Windows 2000, Oracle BI enterprise edition.
Responsibilities:
Interacted with business representatives for requirement analysis and to define
business and functional specifications.
Created/Modified Metadata repository (.rpd) by using Siebel Analytics Admin tool:
Physical, Business Model and Mapping, and Presentation Layers.
Designed the Siebel Repository Physical layer by defining joins and configuring the
Connection Pool settings and created the Star Schema in Business Model.
Extensively worked on Data marts(different subject areas) for decision support
based on the needs of a given department and setting up LDAP (ADSI) authentication
Creating reports and Dashboards and assigning the dashboards to the users and
groups.
Designed and customized Siebel Answers, Reports and Siebel Delivers according to
the requirement.
Managed the Analytics Cache environment.
Configured Dimension table in Business layer for Drill down functionality.
Specified the aggregation levels and configured measures in the Business Model
Layer and mapped to Multiple Logical Source tables.
Created data level security for based on Business Requirement by creating opaque
views.
Design and development of custom reports. Developed Reports/Dashboards with
different Analytics views(compound layout, Pivot table, chart, table) with local and
global filters using Siebel analytics Web
Configured metadata objects (Subject Area, Table, and Column) and Web Catalog
Objects (Dashboard, Pages, Folders, and Reports).
Implemented dynamic dashboard prompts to zoom into particular segments of the
business in a performance optimized manner
Configured iBot to deliver Analytics content based on schedule, automated iBot
queries to obtain weekly reports and updates.
Analyzed and validated the business model in Siebel Administration Tool by
performing consistency check, validating logical source tables, logical columns, and
also validating repository level calculations done in the business model layer.
Environment: Siebel Analytics 7.7, SQL Server 2003.
Trainings
1. OBIEE I0g – Coriolisys Business Systems
2. OBI (Oracle Business Intelligence – Formerly known as Siebel Analytics) –
i. Oracle BI Server Administrator 10g: Build Repositories Release 1
ii. Oracle BI Presentation Services 10g: Create Reports/Dashboards
iii. Oracle BI Applications 7.9: Develop a Data Warehouse Ed 1
3. Oracle Database 10g: Administration Workshop I Release 2
Oracle Database 10g: Administration Workshop II Release 2
Contact this candidate