Manager Security

Eugene Foya

Oracle Business Intelligence Developer

Springfield, MA

**********@*****.*** - 413-***-****

WORK EXPERIENCE

Oracle Business Intelligence Developer

BIG Y FOOD INC - Springfield, MA - 2010 to 2013

Summary

Gathered Business requirements by interacting with the business users, defined subject areas for analytical

data requirement.

Performed functional analysis for the requirements gathered by business analysts, perform impact analysis

to provide detailed functional design document of the desired application changes

Added new Dimensions and Columns to the Subject Areas to full fill the additional Requirements of the

Business Analysts.

Configured Agents to deliver Analytics content based on schedule, automated Agents queries to obtain

weekly reports and updates.

Administered permissions and privileges for Dashboard visibility and modifications to users based on their

groups or responsibilities

Worked with time series wizard objects and Account dimensional hierarchies

Generated queries and placed filters and created numerous executive level reports. Dashboards' were

generated to provide insight into the sales/marketing/financial data

Developed custom reports/Ad-hoc queries using OBI Answers and Filters.

Added users and configured security in web logic console of OBIEE 11g.

Managed security privileges for each subject area and dashboards according to user requirements.

Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.

Configured the territorial hierarchy and worked with time series objects.

Played a crucial role in designing and developing custom reports using BI Answers and making them

available in Dashboards which pleased client. Implemented drill in place so that users could view data at the

granular level and make effective decisions concerning the business.

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.

Created connection pools, imported physical tables and defined joins in the physical and BMM layers of

the repository

Excellent understanding of Dimensional Modeling methodologies like Star Schema/Snow flake Schema.

Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

OBIEE Analyst

J.CREW - Natick, MA - 2009 to 2012

Retail chain)

Summary

Handled analysis and design of 300+ reports for Oracle Business Intelligence Enterprise Edition (OBIEE).

Merged new RPD, dashboard and BI Answers requests with existing OBIEE content.

Developed many reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View

Selector).

Working closely with users/developers and administrators to resolve the production problems by reviewing

design changes.

Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.

Created Objects into repository by merging and importing into OBIEE Repositories.

Provided Training to users and conducted practice additional Business Requirements sessions

Created OBIEE reports and Dashboards for the Marketing Department of the organization

Defined drill- down time series and other dimension hierarchies

Used Alias and Dim tables so that the hierarchy and time series modeling would meet business

requirements.

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.

Analyzed user needs, conferring with users to improve procedures and identifying and solving problems.

Developed reports / Dashboards with different Analytic Views (Pivot Table, Charts, drill-Down / dynamic,

cascading styles Sheets, Column Selector, Tabular with global and local filters).

Created connection pools, imported physical tables and defined joins in the physical layer of the repository.

Developed resource planning estimates to achieve project workload, productivity and utilization.

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.

Implemented user security configurations in the repository, Security setup (users/group, access/ query

privileges).

Tested and modified OBIEE security for the internal controls environment.

Created dimension hierarchies, aggregates, and keys in the BMM layer.

Created dashboards with global prompts, column selectors and navigation.

OBIEE Analyst/Developer

H&R Block - Kansas City, MO - 2008 to 2012

Tax preparation CO.)

Summary

Customized the OBIEE Repository (Physical, BMM, and Presentation layers).

Created dimension hierarchies, aggregates, and keys in the BMM layer.

Created dimensions, dimension hierarchies, log levels, level based measures and defined level, attributes

level keys. Used the expression builder utility to create new logical columns in the BMM layer and created

various calculation measures.

Built repositories from scratch, perform business modeling and mapping, create security profiles, create

variables, send for testing, deploy to OBIEE Presentation Services

Created and modified Business Intelligence requests using Oracle Business Intelligence Answers

Combined request criteria using set operations and execute direct database requests

Worked with views to display request information

Created and modified Interactive Dashboards

Worked in a Multi User Development ( MUD) Environment check out repository, made changes, and send

for merger

Created performance reports to be reviewed by executives for the worldwide firm, by management at local

regional and set security to localized regions, as well as functional reports for the detailed financial team and

contact team

Employed recommended design principles and best practices user, also conducted acceptance testing.

Test and modify OBIEE security for the internal controls environment

Took an active role in the preparation of Project plan before management,

Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared

business process models, defined milestone deliverables, and established critical success factors.

I also took part in the meetings with Sr. Business Analyst and managers and understood various process

plans, business process, and functionality in detail.

This helped me to prepare Integration Test Plan which was used by functional team as well as development

team for doing a detailed.

OBIEE developer

Hannaford's Super Market - Marlborough, MA - 2007 to 2009

Grocery Retail)

Summary

Created interactive user level security for dashboards.

Analyze, Design and develop OBIEE Analytics Metadata repository (RPD) that consist of Physical Layer,

Business Mapping and Model Layer and the Presentation Layer using Admin Tool 11g.

Created user level security for intelligence dashboards based on Business Requirement.

Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and

perform database optimization by analyzing query performance.

Created groups in the repository and added user to the groups and granted privileges explicitly through

group inheritance.

Created and modified Interactive Dashboards

Created guided navigation links within Interactive Dashboards

Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to

Interactive Dashboards using iBots

Performed administrative tasks related to the development and configuration of Interactive Dashboards

Customized the Oracle BI Presentation Services user interface

Created 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.

Analyzed user needs, conferring with users to improve procedures and identifying and solving problems.

Developed reports / Dashboards with different Analytic Views (Pivot Table, Charts, drill-Down / dynamic,

cascading styles Sheets, Column Selector, Tabular with global and local filters).

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.

Implemented user security configurations in the repository, Security setup (users/group, access/ query

privileges).

Efficiently worked in a multi user development environment (MUDE) to make changes and additions which

met business requirements. Developed Role-Based Dashboards for Managers and Business Heads to review

the Forecasts vs. Revenues to analyze the financial service center statistics for mortgages, Customized pre-

built dashboards.

EDUCATION

Quinsigamond Community College Worcester

April 2004

B.S in Computer Science

Framingham State College - Framingham, MA

ADDITIONAL INFORMATION

Qualifications

5+ years' experience in Oracle Business Intelligence Platforms including (OBIEE 10g-11g) Enterprise Edition

including standalone components such as BI Publisher.10+ of years' overall IT experience.

Highly motivated consultant with a rich diverse understanding in the multifaceted field of Business

Intelligence.

Vast experience and understanding in DW/BI as well as, proper installation, administration Report and

Dashboard design, Performance Tuning, Dimensional Modeling.

Results oriented consultant with experience driving and leading teams of individuals focused on achieving

deliverables, and promoting a positive working environment.

Great communication, leadership and interpersonal skills to meet various business objectives, project

milestones, commitments to quality, and nurture continuous improvement.

Hands on experience in delivery /consulting with Oracle including implementations, maintenance and

extension of existing applications, full life-cycle projects experience/roll-out and upgrade.

Identified facts, dimensions, KPIs for different business models

Highly organized professional who adheres to a solid work ethic second to none.

Technical Summary

Platform: Windows 2003/2007 Server, XP Professional. 2008

Business Intelligence: OBIEE 9i, 10i,11i,Administration Tool, BI Publisher

Answers, Analytics, Dashboards, Delivers, iBots, Agents

Dimensional modeling, star and snowflakes schema, Oracle Database

MS Office, TOAD, SQL Loader,PL/SQL

Contact this candidate