Management Data

SUMMARY:

Extensive experience in Project Management, Business Intelligence, Business Analysis and System design and development.

Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7

OBIEE/ Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layers

Designing and developing custom reports using BI Answers and presenting them in Dashboards. Building Interactive Dashboards with drill-down & drill-across capabilities using both global & local Filters, Business Rule

OBIEE/ Presentation Services including Answers, Interactive Dashboards, Delivers/Agents, Cache Management, Scheduler. Converting business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / Agents, creating reports / Dashboards, cache management

Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules

OBI Implementation methodology, Cache Management and Performance Tuning., Time Series functions etc. Caching & Mapping, data-level and object-level security, MUDE, Integration Variables/Initialization Blocks configuration

OBI Security Setup (groups, data access/query privileges), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)

Development, Testing and migrating to Production environments

Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data. Writing, analytical, communication and interpersonal skills

Understanding of business processes and interacting with business users conducting interviews to gather, analyze and document user needs, business processes, identifying reports/KPIs and other requirements then rolling out deliverables.

EDUCATION:

Bachelor of Science: Business Administration with MIS concentration, Marian University

Oracle Certified Specialist

Pursuing PMP Certification

PROFESSIONAL EXPERIENCE:

Independent Consultant Via Alliance Management Resources LLC Offshore Projects (Isoquant Investments (Pvt) Ltd, S&N Investments (Pvt) Ltd, Hobo Gases (Pvt) Ltd)

Jan 2013 - Present

Lead Business Intelligence Developer

Worked closely with Business Analysts, translating the Business requirements into technical specifications.

Built the Physical Layer / Business Model and Mapping layer / Presentation layer of a repository by using Star and snowflake Schemas.

Involved in building star schemas in the repository using the primary and foreign keys.

Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements. Used Analytics, WebLogic and Enterprise Manager.

Responsible for OBIEE ad-hoc reports. Developed Variables and did Cache Management.

Trained end-users to easily design report layouts directly in a Web browser, thereby dramatically reducing the time and cost to develop and maintain the reports.

Created and scheduled agents Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.

Used WebLogic/Console for Administrative functions such as creating users and groups, and restarting servers

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating

logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts and filters.

Customized and Developed OBIEE Analytics Reports and integrated them into Dashboards. Unit Testing

Designed, debugged and optimized the Dashboards / Reports

Created mockup reports and dashboards for review by the business users. Incorporated their feedback and updated the report designs.

Developed many reports / Dashboards with different Analytic Views (drill-Down / dynamic, Pivot Table, Charts, Column Selector, global and local filters) using OBIEE Analytics Web.

Integrated with the EBS AR module to create reports to analyze account aging and collection efforts, calculate and identify AR turn over ratios, analyze account by invoice and by customer as well as evaluate collection staff by invoice using OBIEE Analytics Web.

Created groups and assigned the users to the groups and attached the groups to the respective roles

Created proactive agents and interactive dashboards to alert the management team about business changes. Managed day-to-day rpd, scheduler and agents.

Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements

Used EM for general Admin that includes RPD upload to the server, create roles and policies.

Performed performance tuning duties including cache management and report error trouble shooting

Worked the entire OBIEE life cycle at different stages including, working with DBA and ETL teams.

Geispa Technology Group Indianapolis, IN

Mar 2010 - Jan 2013

Business Intelligence Analyst

Worked closely with the business team using Oracle Financial Analytics and Oracle HR Analytics to develop reports from a range of data sources and applications including Oracle E-Business Suite and PeopleSoft.

Participated in the project status meetings working with team leads and project managers.

Worked on various Reports /Dashboards in BI Analytics with different analytics views

Drill-down, Dynamic, Narrative, Charts, Pivot tables, Column selector, View selector and Local filters

Created and modified Interactive Dashboards

Created reports, using filters, protected the filters and also created dashboard prompts.

Hard coded the prompts according to the users business needs

Customized and developed OBIEE Analytics Reports and integrated them in dashboards.

Created Action links and Web links on various reports per user specifications

Met with business representatives, business analysts and end users to understand the business models and functionality.

Gathered Business requirements, interacted with the business users, defined subject areas for analytical data requirements

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

Created agents for job-critical levels and auditable differences delivered to dashboards, email and cell phones to assist process owners with timely decision making.

Used BI analytics to run queries, test, and reports and validated the repository.

Helped create connection pools, imported physical tables and defined joins in the physical layer of the repository

Assisted with Building the Physical, Business Model and Mapping and Presentation Layer of the repository.

Created dimensional hierarchies and level based measures, built time series and calculated measures for different measures.

Used the rename wizard to rename fields and tables

Modified Presentation Layer to add presentation tables and columns to meet the business user needs

Created repository and session variables

Created groups and added users to the groups and granted privileges

Customized the Oracle BI Presentation Services user interface

Performance tuning experience included modeling aggregate tables to speed query processing and partitions and fragments to improve application performance, usability and caching

Enhanced performance tuning using the SQL developer

Tested and modified OBIEE security for the internal controls environment.

Environment: OBIEE 11g, Reports, Dashboards, BI analytics, SQL, MUDE, Oracle 11g, SQL

PropertyThree Technology Group, Inc. Indianapolis, IN

Apr 2004 - Jan 2010

Director of Information Technology

Responsible for technology project management.

Responsible for operations and direction of the company.

Planning, Projecting, Staffing, Budgeting and Business Development.

Monitored technology project lifecycles.

Defined requirements, architecture, and implementation for custom e-commerce solutions.

Identified and documented complex functional workflows with use cases and UI mockups.

Hands on development of most of the business layer that constituted project framework.

Worked with Visual Studio, SQL Server, and Crystal Reports

NNC Group Inc. Indianapolis, IN

Dec 1999 - Apr 2004

Senior Database Analyst

Conducted data analysis to address specific business requirements and to establish facts and draw valid conclusions.

Synthesized data findings and communicated them to management in order to drive further understanding of the consumer lifecycle. Manipulated and cleaned data to make it usable for analysis by summarizing data points, creating new metrics, and addressing data quality issues.

Performed analysis in support of demand forecasting to identify trends, seasonality, and other demand impacting variations. Produced ad hoc reports requests by gathering, manipulating, and analyzing data.

Gathered data from multiple database platforms and consolidated it to produce reports.

Performed coding functions to produce custom reporting tools for other departments

XEROX Connect Indianapolis, IN

Jan 1994 - Oct 1999

Senior Technology Consultant

Consulted at the following companies (Indiana Eli Lilly, E&Y, Indiana University School of Dentistry, Temporary Technologies, Indiana Mobile Communications)

Involved in various software validation projects. Drafted test plans as well as test scripts.

Developed & managed client agreements, project plans, and various other deliverables (class diagrams, sequence diagrams, technical documentation).

Implemented and managed technologies that include IP, ACD, PBX, IVR, and CRM

Oversaw Voice/Data requirements for new office set up, and office closings.

Negotiated phone service contract recognizing cost substantial cost savings from Tariff rates.

SKILLS AND RELEVANT TRAINING AND TECHNICAL TRACKS:

Oracle Business Intelligence Suite 10/11g

Oracle EBS HRMS: Payroll

Oracle EBS Financials: AP, AR, GL, FA and Purchasing

Oracle Hyperion Financial Management, Hyperion Reporting

Oracle 11g,MS SQL Server 2000 - 2008, DB2

TOAD / SQL Developer / Query Analyzer

ETL Tools - ODI / Informatica

Tableau

Transact SQL / PLSQL / Stored Procedures

Support Tools (Crystal Reports, WinZip, FTP)

Relational Database Structures SQL and Oracle PL*SQL

Design Methodology and Technology

Effective Requirements Gathering

Process Documentation and Process Documentation Tools (such as Visio)

Data Modeling

Project Management

SAP FI/CO R3

Six Sigma Methodology

Security Auditing

MS SQL Server

Microsoft Office Suite

Windows OS / Linux OS

Windows Server Applications

References Upon Request

Contact this candidate