|
|
|
|
Oracle Business Intelligence Subject Matter Expert Resume
|
| Desired Industry: Information Technology |
SpiderID: 20624 |
| Desired Job Location: Washington, District of Columbia |
Date Posted: 4/11/2008 |
| Type of Position: Contractor |
Availability Date: Immediate |
| Desired Wage: |
|
|
U.S. Work Authorization: Yes |
| Job Level: Management (Manager, Director) |
Willing to Travel: Yes, More Than 75% |
| Highest Degree Attained: Bachelors |
Willing to Relocate: No Preference |
Objective:
Summary: Fifteen years experience in the implementation of Sales and Financial Software Enterprise Systems for large, global private (Fortune 500) and public (Government Agencies) Entities. His main role as technical lead has provided strong business value by following tried and true best business practices. By applying various project methodologies and giving strong attention to critical factors of success, Stanley Hao has proven to give strong business benefit to clients based on specific performance metrics to deliver a best in class software solution. He has worked on various client engagements in all phases of the software development life cycle.
Experience:
WORK EXPERIENCE:
10/1/07– Present Business Intelligence Architect at Defense Intelligence Agency Washington, DC.
• Evaluated, upgraded, and implemented Oracle BI version 10.1.3.2.1 Software Package from the previous software version at DIA, Siebel Analytics 7.8. Project Areas include: DAC Administration - Configured Custom Execution Plans, Subject Areas, Table Groups, Task Definitions/Informatica SDE/SIL Workflow Tasks, Slowly Changing Dimensions, new business features provided to the end users, version changes in required software components, new Oracle Components and Services, increased formatting capability with the new Oracle BI Publisher component, and new configured parameters for improved performance and scalability. One area specifically addressed at DIA is the software security aspect of the Oracle BI Package, and its ability to function within network, hardware, and software security DIA mandated guidelines.
2/07– 10/1/07 Analytics Architect at America Red Cross Washington, DC.
• Large-scale Data Warehouse Project on OBI EE 10.1/Siebel Analytics 7.8.5. Designed the Data Warehouse and created Proof of Concept (POC) modeling and implemented delivery using an iterative approach.
• Server Admin: Configured the DAC Server, Analytics Web Server, and Informatica Repository Server.
• Requirements: gap analysis, User and Software Reqs. Review, Critical Design Reviews (CDR).
• Produced Analytics Design Document and Configured Star Schemas for Orders and Service Requests using the Analytics Admin Tool. Verified/Tested Data Sources, Configured Physical/Business Model/Presentation Catalogs/Subject Areas, keys, joins, Logical Table Sources. Identified measures, dimensions, hierarchical relationships, granularity of data, data sources (flat file, excel, Oracle, SQL Server, DB2, Sybase, Informix).
• Configured Analytic Requests and Dashboard Prompts. Managed the Web Catalog.
• Identified Performance Metrics such as Time Series Comparison (Monthly and Year Ago Comparisons), Aggregate Tables. Configured Initialization Blocks, Session, and Repository Variables. Modeled Time Series Data, Slow Changing Dimensions (SCD123), Ext Tables, Partitions/Fragments, Cache Management
• Managed the DAC repository for the ETL Process and Performance tuning.
12/05 – 2/07 Analytics Architect at Department of Homeland Security Washington, DC.
• Presented high-level Analytics Executive Summary Reports to Upper Management. Reports include
analysis of Cases Outstanding, Case Status (Open, Pending, etc).
• Analytics Task Details – Fact Calculations, Testing and validating Analytics Repository, reviewing logs
(NQuery.log). Validated DW Tables/Columns using Siebel ODBC Client.
• Worked with Business Analysts to identify key Performance Metrics, from initial engagement with
the Customer, high priority escalation queuing, to final resolution and Customer follow-up.
1/05 – 12/05 Analytics Technical Lead at Marriott International Orlando, FL.
• Designed over 50 reports using Siebel Answers for Monthly and Quarterly meetings with Vice Presidents and Executives which display Project Performance of Hotel Properties and Divisions.
• Using the Analytics Admin Tool, configured the Physical/Logical/Presentation Layers of Analytics Repository. Designed Executive Level Dashboards for Vice Presidents in Change Control Board Meetings.
7/04 – 12/04 Analytics Technical Lead at Home Depot Atlanta, GA.
• Tracked and provided Statistical Analytics Reports based on Service Requests.
• Build Physical, Business Models and Mapping from multiple data sources.
1/04 – 6/04 Lead Reports Developer at Federal Home Loan Mortgage Company McLean, VA.
• Siebel 7.5.3 eSales Project. Siebel Configuration Developer/Actuate Report Writer.
• Managed over 300 reports on the Actuate Server. Designed and created Bulk Data Load Reports, Data Integrity Reports, Arm Product Assignment Reports based on Mortgage and Clean-up tables.
• Actuate reports include Pipeline Reports, Pie Charts, Average Deal Cycle Time, Group Security
4/02 – 10/03 Lead Integration Specialist at Philips Medical Systems Milpitas, CA.
• Lead EAI Developer. Performed Siebel to Legacy Inbound/Outbound Integration EAI Adapters XML.
• Phases include the following: requirements gathering, analysis, technical and detail design, development, testing, pilot, production, and deployment/roll-out.
4/01 – 11/01 Lead Siebel Configurator at Deloitte & Touche Nashville, TN.
• Lead Siebel Configurator – Picklist, Pickmaps, Extension Columns, etc. Created multiple reports which integrated with Siebel 2000 Call Center. Managed SMTP/POP3 Server Email Workflow System.
5/00 – 9/00 Lead Siebel Configurator at Government Technology Services Chantilly, VA.
• Lead Configurator for a Sales and Service Siebel Project. Designed and configured an application for the Sales Team for their Business to Government (B2G) Sales System.
4/99 – 4/00 Configurator at Siebel Systems Reston, VA.
• Configurator for an eMedical Call Center Sales and Service Siebel Project, specifically with Customer and Product Orders by Category and Brand Sales. Configured and modified the Vanilla application to meet customer requirements. Worked with Expert Services to add new tables to the repository for reporting requirements. Participated in the full life-cycle software development using Siebel eFinance.
8/96 – 3/99 VB Developer at Abacus Technology Corporation Washington, DC.
• Developed an enterprise-wide tracking application with VB 5.0 and SQL Server. Programmed functionality using Visual Basic API calls which piped (SQL) statements to the Microsoft SQL Server. Designed and built a Security Module for users and access rights to legal documents.
5/94 – 7/96 Price Waterhouse, LLP Bethesda, MD.
• Created a peer evaluation reporting system which allowed manager and peer level summary reports to be generated based on a complex hierarchy within the Global Markets Division of Deutsche Bank.
REPRESENTATIVE CLIENTS
American Red Cross
Bayer AG
Chase Manhattan Bank
Clubmom.com
Defense Intelligence Agency
Deloitte Consulting
Department of Defense
Department of Homeland Security
Department of State
Deutsche Bank
Freddie Mac
General Services Administration
Home Depot
Marriott International
Philips Electronics
TIAA-CREF
United Healthcare USCIS
Education:
EDUCATION: Carnegie Mellon University, BS, Math/Operations Research.
Skills:
HOTSKILLS Oracle BI 10.X, Siebel Analytics 8.0, Informatica, Oracle 11i, SQL Server 2005.
Candidate Contact Information:
This candidate has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|