Manager Management
Resume:
Dayton, OH *****
Phone: 937-***-****
Email:
*******.*******@*****.***
Richard T. Chiromo
Professional Over 4 years of experience in gathering Business
Summary Requirements, Analysis, Design, Data Modeling,
Development, Implementations and Testing of Data
Warehouse/Data Mart.
Experience in creating, modifying, and
administering Analytics Intelligence Dashboards
with drill down capabilities using global and
local filters Siebel Analytics applications, using
Siebel Answers.
Expertise in providing end to end business
intelligence solutions by dimensional modeling
design, building business models. Configuring
metadata, creating reports, Dashboards, Cache
monitor, building OBIEE Repository consisting of
Physical Layer, Business Model and Presentation
Layer, time series objects, configuring OBIEE
security(groups, access/query privileges) using
Analytics.
Over 8 years of management experience. Skilled at
assessing client needs, recommending strategies
that enhance efficiency and maximizing return on
investment, implementing cutting cost solutions
and organizational leadership training.
Work Experience Apr - Dec 2012 ABSA Bank Pretoria,
South Africa
Oracle Business Intelligence Developer
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.
Jan 2010 - Mar 2012 Alpha &
Omega Dayton, OH
Oracle BI Consultant
Interacted with Management to identify key
Dimensions and Measures for business performance.
Developed custom reports/Ad-hoc queries using OBI
Answers and Filters
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.
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.
Nov 2008 - Dec 2009 Dayton Progress Dayton, OH
Oracle Business Intelligence Developer
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.
Involved in Unit/Integration Testing & user
training of the generated reports in Siebel
analytics web
Involved in merging applications from Dev - Test -
Prod for deployment.
Formatting results, Filtering requests, and
Showing results with Pivot, Chart, & Views on SAW
Involved with the Testing team to resolve, fixing
and testing problems found during the Systems
integration test, UAT Phases
Performed Testing of the IT Defects and CR raised
by the Testing team
Feb 2006- Oct 2008 Dayton Progress Dayton, OH
Junior Financial Analyst
Assisted in developing the annual budget and
quarterly forecasts as needed.
Conducted a wide range of analysis including:
Credit risk analytics.
Investment portfolio analytics.
Interest rate risk management.
Balance sheet analysis.
Cash management.
Under the direction of the Chief Financial
Officer, assisted with meeting the evolving
financial management information needs of the
company
Analysed monthly financial trends and budget
results
Jan 2005 - Jan 2006 Lexis Nexis (Contractor )
Dayton, OH
Account Manager
Responsible for managing onsite operations for 12
buildings.
Increased efficiencies and reduced the need for
additional headcount with an annual payroll
reduction of $100, 000/yr.
Implemented cost cutting techniques on cleaning
chemicals
Processed bi-weekly payroll for 55 - 60 staff.
Mar 2000 - Jan 2005 ABM Dayton, OH
Area Manager
Operated within the monthly budget set by the
Property Managers
Responsible for researching emerging trends,
technologies and competitive environmental
friendly cleaning methods.
Responsible for 12 accounts which included some of
the largest companies in the Dayton area.
Developed new processes and solutions
Identified customer specific business
requirements.
Supported current processes and services utilizing
efficient technologies while focusing on client
requirements.
Trained account managers periodically to maintain
efficiency within the company.
Liaison between property managers and branch
managers
Education Wright State University Dayton OH
BA in Economics
Sinclair Community College Dayton OH
ABA Associate of Business Administration
Certification and Trainings
OBI (Oracle Business Intelligence - Formerly known
as Siebel Analytics)
Oracle BI Server Administrator 11g: Build
Repositories Release 1
Oracle BI Presentation Services 11g: Create
Reports/Dashboard
7x/8.0/8i/9i/11g, MS Access, MySQL
Computer
Knowledge Proficient with MS Office products. Outlook, Word,
PowerPoint, Excel, Access and Publisher
Reference: Available upon request
Contact this candidate