Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
MIA MAGALELA
Phone: 1 469-464-9876|E-mail:maya.magalela@gmail.com
PROFILE
SUMMARY
·
7+ years information technology experience in
business intelligence applications
(specific experience in OBIEE) installation, configuration, design,
development and implementation and database
design and administration
·
Strong in Metadata design and development repositories (.rpd) (Physical Layer, Business
Model and Mapping and Presentation layers) using the OBI Administration tool in
OBIEE/Siebel Analytics
·
Strong in developing data models using
Dimensional Data Modeling, Star Schema Modeling using Fact and Dimension tables
in the physical, business model and mapping, presentation layers
·
Experience configuring BI Scheduler for
delivers via creating schema, tables and Job Manager and enabling communication
with presentation services
·
Strong experience working in Presentation
Services customizing reports and charts in answers, creating ad hoc query
reports, creating dashboards
·
Experience customizing setting up and
scheduling iBots to the end user dashboards
·
Experience performing Administration tasks in
the backend and frontend creating users, user groups, catalog groups, user
permissions, privileges etc
·
Comprehensive knowledge of performance tuning
and optimization of OBIEE using Usage Tracking and Direct Insert method, Event
Polling and Aggregate persistence, cache management
·
Experience setting up and management of
security in all aspects of OBIEE including extending LDAP security
·
Knowledge of Data Warehousing development
using data extraction and transformation tools specifically Informatica Power
Center 8.x/7.x/6.x
·
Experience configuring and working with BIP in OBIEE, creating
reports, charts and presenting in different formats and bursting reports
·
Excellent
Business Writing skills compiling business requirements, writing business
requirement documents (BRD), functional and non functional requirements
specifications
·
Complete understanding of the SDLC
methodology and project management processes
Additional strengths
include:
Thrive in a team environment
Training others in technical processes
Ability to interact easily and share ideas
Quick to learn new methods and adapt to new ideas
PROFESSIONAL
AND WORK EXPERIENCE
Robert Half
technology Inc, Fort Worth, TX,
Sr OBIEE
Developer/Consultant @ NCTCOG - Sept’09 – February’12
North Central Texas Council
of Governments (NCTCOG) provides 16 North Central Texas Counties with a centralized
planning organization to manage emergencies, environment, transportation and
other resources. The organization required a business solution to capture and
analyze trends and expenditures relating to all the activities in the different
regions covered by the 16 counties.
Responsibilities:
·
Oracle (OBIEE 10g and 11g) BI Development of business metadata objects
·
Worked with Business Analyst to design and develop
BRD with functional and non functional requirements for the new OBIEE system
·
Helped translate functional requirements document
into technical requirements
·
Analyzed source data systems to identify and
document complex data mapping, business rule analysis identifying Facts,
Dimensions, Levels/Hierarchies
·
Performed system requirements check on all
enterprise computers and performed OBIEE installations on standalone systems
·
Customized and developed Repository for
Physical, BMM and Presentation layers, configured metadata objects and web
catalog objects to align with business requirements
·
Developed reports in Answers and created
Dashboards with different analytic views and features such as drill down, pivot
tables, charts, prompts, filters, column sector to provide insight into the
sales/marketing/financial data
·
Configured scheduler for iIBOTs delivers, BI
Publisher and created reports
·
Created users and assigned privileges and
permissions and configured security settings to secure repository metadata and
catalog objects
·
Performed continuous performance testing and
tuning working closely with stakeholders
to resolve ongoing production issues
·
Conducted training for users
Environment:
OBIEE 10.1.3.4.2,
Oracle 10g database, Windows XP, SQL Server 2008, Informatica Power Center
8.1.1, SharePoint, Visio, SQL Developer, SQL*Plus, Microsoft Project
PSFWEB for Discovery
Channel Stores
Sr OBIEE Developer - Oct’08 – Aug’09
PSFWEB is a provider of total End to End e-Commerce
solutions supporting online brands. In order to forge relationships with its
clients and deliver measurable value, the company decided to implement a
business solution that will be both client and customer focused to track sales
data and use for ongoing and future business development plans.
Responsibilities:
·
Responsible for mapping and developing OBIEE
metadata objects during BI Development lifecycle.
·
Performed simple to complex analytical SQL
queries on the main data sources to identify and analyze the authenticity
of the data before importing to build the OBI repository.
·
Created/Modified Metadata repository (.rpd)
by using OBI Administration Tool:
Physical, Business Model and Mapping with time and geographical hierarchies and
time series functions for detailed analytics, building star schema
as per the business requirements
·
Added new Dimensions and Columns to the
Subject Areas to full fill the additional Requirements of the Business
Analysts.
·
Created analytic reports in Answers in the Presentation
services and built interactive Dashboards
for Business Users, and Set up Usage Tracking database.
·
Created Dynamic Dashboard Prompts for different time and geographical
variables to enhance query performance and easy navigation of reports by users.
Developed
custom reports/Ad-hoc queries using filters in presentation services and
assigned them to application specific dashboards
·
Configured Scheduler for Delivers using Job Manager and set up
iBots for delivery of reports to business users
·
Implemented Comprehensive Security Model, by creating User Roles, web groups and
setting up Authentication.
·
Performed Unit and System Testing validating
security, access to the right data screens and dashboards, response time, user
prompts, drilldown, navigation and validating metrics.
Environment: OBIEE, Oracle 10g, OBI Applications (Sales
Analytics, Order to Cash Management), Informatica Power Center 8.1.1, SQL
Server, SQL Developer, SQL*Plus, Windows XP
Safari Com, Nairobi, Kenya
OBIEE developer - Jan’07
– Sept’08
Safari Com is one of the biggest telephone providers in
Kenya. Stiff competition required that the company streamline its consumer and
product balance in order to develop, marketing strategies of branded products
and services. Information was stored in a Data warehouse built in order to
provide standardized reporting process for the sales and marketing data. Oracle
BI Platform Solution was implemented for providing analytic reports and Dashboard
access to strategic business information from the company-wide data warehouse
with data-marts already created according to subject areas.
Responsibilities:
·
Primary responsibilities include gathering
business requirements, designing the functional and technical specifications.
·
Involved in Creating and Administering the
Physical Layer, Business Model & Mapping Layer and Presentation Layer using
Oracle Business Intelligence
Admin tool.
·
Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the
repository.
·
Created Dimensional Hierarchy, Level based
Measures and Aggregate navigation in BMM layer.
·
Managed security privileges for each subject
area and dashboards according to user requirements.
·
Created groups in the repository and added
users to the groups and granted privileges explicitly and through group
inheritance.
·
Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
·
Developed different kinds of Reports (pivots, charts, tabular)
using global and local Filters.
·
Created proactive agents iBots and interactive Dashboards to
alert the financial team about business changes. Managed Oracle Delivers, Scheduler & iBots.
Environment: OBIEE 10.1.3.2, Oracle
BI Applications 7.9.4(Sales Analytics, Order Management Analytics),
Informatica 7.1.3, Oracle 10g, SQL Developer, SQL*Plus, Windows-XP,
UNIX
Texas Instruments,
Dallas, TX
OBIEE Developer - Sept’03 – Dec‘06
Texas
Instruments is one of the world’s largest producers of microchips for the
electronic industries for cell phones, computers, cars and high security chips.
With competitors in Taiwan, Malaysia, Japan and China, the company has been
trying to implement a business solution that will help it keep a focus on
production and sales metrics in order to be competitive
Responsibilities:
·
Configured OBIEE/Siebel Anlystics Repository creating
connections to different data sources, importing data from various data
sources, developing the physical data model as per requirements, importing the
tables and building physical models required.
·
Modeling within the BMM layer including
building star schema, level base metrics (hierarchies), and time series
modeling as per the business requirements.
·
Designed and Configured Dashboards for
different groups of users to view figures across regions, products with the
facility to drill down for different analytics
·
Developed Role-Based Dashboards for Managers
and Business Heads to review Production Forecasts, Sales and Revenues
·
Developed custom reports/Ad-hoc queries from
Answers and Filters.
·
Created dashboard prompts as per user
requirements
·
Implemented the delivery of iBots using OBI
Delivers to alert the relevant teams and managers.
·
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.
·
Trained users on the front end on OBIEE features
and capabilities
·
Developed and tested stored procedures, Functions and packages in PL/SQL for
Data ETL and developed several mappings to load data from multiple
sources to data warehouse.
Environment: OBIEE/Siebel Analytics 7.7, Oracle 9i/10g, Informatica Power Center
7.1, PL/SQL, Windows Server 2003/ XP.
COMPUTER
SKILLS AND SOFTWARE
Operating Systems
|
Windows, Linux, Unix
|
Bi Tools
|
OBIEE 10.1.3.x, Siebel Analytics 7.x,
|
Server and DB Tools
|
SQL Server, Unix, SQL Developer, SQL*Plus, Management
Studio, Visio
|
ETL Tools
|
Informatica Power Center 8.x/9.x
|
RDBMS
|
Oracle 10g/9i/8i, Oracle E-Business Suite 11i/R12,
Siebel CRM,SQL Server, MS Access
|
Programming Languages
|
SQL, PL/SQL, VBA, Python
|
Web Programming
|
HTML 4.0, XML, MXML, UML
|
Project Management Applications
|
Visio, Microsoft Project, SharePoint,
|
Office Applications
|
Microsoft Office Suite
|
EDUCATION
MBA Project Management, University of Texas at Dallas, TX
(in progress)
MSc Geographic Information Technology, University of
Texas at Dallas, TX
BSc Imperial College of Science and Technology-London, UK
PROFESSIONAL
MEMBERSHIP
PMI Dallas Chapter,
Download Resume Format
0 comments:
Post a Comment