Professional Summary

• Over 15 years experience in IT with 4 years of enhance experience on Oracle Business Intelligence, BI Apps, Oracle Real Time Decisioning (RTD), Oracle Data Integrator (ODI), Essbase, and ETL architecture
• 2+ years of experience in Business Requirements in gathering GAP Analysis, Data Modeling, Data Analysis, Testing, Development, Implementations and Documentations of Data Warehouse / Data Marts deployments on many Business Intelligence solutions
• Problem Solver, excellent presentation and communication skills for simplifying key units from a technical standpoint to interpret for customer understanding
• Proficient knowledge in working on BI Administration & Presentation Services, creating and using dashboards, develop Repositories, develop reports using Oracle Answers & Oracle delivers, scheduling requests
• Comfortable with OBIEE back-end design & development and the ETL (Extraction, Transformation, and Loading) process for deploying OBIEE reporting solutions
• Perform the best practices for creating Physical, Business Model and Presentation layers
• Extensive knowledge for implementing Aggregate Navigation, use of Aliases, event polling, performance tuning, iBOTS/Agents
• Experience with Multi-User Development Environment(MUDE), reports, and design tables

Business Intelligence: OBIEE 10.1.3.x, 11.1.1.6.x, Siebel Answers/Delivers, BI Apps/BI Publisher
Databases: SQL Server 2000, Oracle 9i/, MS Access
Data Modeling: SQL Assistant
Data Warehouse: Informatica 8x, ETL, DAC, SQL Loader
ERP: LMP, SAP MM/WM
Languages: PL/SQL, HTML XHTML, XML
Operating Systems: Windows 2000, XP, Vista, Windows 7, Novell, HP-UX, and Solaris
Software: MS Project, MS Office, Visio

Education
EMBA Energy Finance (Oil/Gas), Confidential,University, Houston, Texas (2013)
BS Management Technology, Confidential,University, Garland, Texas
AS Business Administration, Confidential,University, Honolulu, Hawaii

Additional Information
82 hours – Conflict Resolution in Mediation and Workplace Dispute Resolution from El Centro College
36 hours – OBIEE Edition Core training from Matherpoint
32 hours – OBIEE Edition Advance training from Matherpoint
40 hours – Completed courses in Government Contract and Project Management from KBR University
30 hours – Occupational Safety and Health (OSHA) in General Industry Safety & Health with KBR
Career History
7/11 – 8/12 OBIEE Developer / Project Supervisor
Confidential,NAS Corpus Christi, Texas

• Instrumental in warehouse startup project at Corpus Christi Army Depot (CCAD) and Defense Logistics Agency (DLA) contract/Task Order orchestrate under the Base Closure and Realignment Commission (BRAC).
• Design, create and tune physical database objects (tables, views) to support logical and dimensional models using Data Analysis techniques.
• Performed the Full and Incremented ETL/DAC process to populate the Data Warehouse, scheduled and ran the warehouse extracts.
• Designed repository based on business requirements followed design best practices for the RPD and Dashboard designs. Worked on Oracle BI Publisher 11g to create reports based on Oracle Database.
• Worked on developing Informatica Mapping, Mapplets, Sessions, Workflows and Work lets for Data loads from various sources such as Oracle, Flat Files, SQL servers etc.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, and joiner, Lookup, Expression and Aggregator.
• Implement Performance Tuning at various levels such as Source, Target, Mapping, Session, and System.
• Developed and Designed OBIEE Analytics Metadata repository (RPD) that consist of Physical Layer, Business Mapping and Model Layer and the Presentation Layer using Admin Tool 10g and 11g.
• Extensively developed mappings on various business areas in the project by employing available Transformations.
• Set up Meta data Objects (Subject Area, Table, Column) security and Data level security
• Experience in Performance tuning at the Database and Report level by creating aggregate tables, RPD level by creating Database hits in the physical layer, and enforcing repository best practices
• Worked in Multiuser Development Environment (MUDE) using Oracle BI Administration Tool. Migrated Analytic RPD and web catalog from one environment to another.
• Created Physical and Complex Joins. Exposed custom attributes in Presentation Layer.
• Experienced in Data Modeling using Dimensional Data Modeling, star Schema modeling, Fact and Dimensional tables including Physical, Logical data modeling in the OBIEE Administration tool.
• Performed Installation and upgrade of Oracle 10.1.3 to Oracle 11g Enterprise Edition.
• Worked with end users to identify, create, and deliver reports according to requirements.
• Configuring the Analytic repository (RPD) and implementing the security to authenticated and authorize Oracle EBS users.
• Extracted data from flat files, oracle and loaded them into target database using informatica, so the data is readily useful for testing purposes.
• Expertise in Performance Tuning Analytics Dashboards / Reports and Data Warehouse database.
• Upgrade Oracle BI Enterprise by deploying new improve utilities on location servers.

10/10-7/21/11 OBIEE Functional Analyst
Confidential,Dallas, Texas

• Daily perform duties in operations to ensure this new startup logistic company meets it weekly and monthly objective.
• Performed Unit and system testing for all components.
• Worked side-by-side clients in maintaining their sales accounts and mediate any concerns.
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Created OBIEE reports and Dashboards for the Marketing Operations of the Organization.
• Identified missing data elements and worked with the ETL team to update Informatica mapping to get the data into the warehouse.
• Developed reports / Dashboards with different Analytic Views (drill-Down / dynamic, Cascading styles Sheets, Pivot Table, Charts, Column Selector, Tabular with global and local filters) using Siebel Analytics Web.
• Created connection pools, imported physical tables and defined joins in the physical and BMM layers of the repository.
• Created dimension hierarchies, aggregates, and logical keys in the BMM layer.
• Involved in setting up iBots to run reports at scheduled time for cache seeding improvement of Query Performance using Caching.
• Created proactive agents iBots and interactive dashboards to alerts the marketing team about business changes, managed day-to-day RPD, scheduler and iBots.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level

10/3/03 – 6/10 IT/Communication Supervisor
Confidential,Government Services in Iraq - LOGCAPIII

• Startup experience in building site IT/Communication Infrastructure (Camp Al Asad, Al Anbar Province, Iraq); determines IT operations service requirements by analyzing needs of IT/Communication team and the internal Customers, which includes updating and processing requisitions; prioritizing modifications to core systems; daily resolves organizational conflicts which are mission critical; develop and implement documentation requirements for problem resolution.
• Ensure all financial objectives are met by forecasting future requirements; preparing an annual budget; scheduling expenditures; analyzing variances; initiating corrective actions;
• Accountable for camp telecommunication operations of a CAPROCK satellite (VSAT) terminal which include the install service, testing telecommunications equipment that include voice, data network, radio, and a satellite links; develop, update and ensure compliance with the disaster recovery plan; direct the operation of IT Service Center and Network Operation Center (NOC) in timely maintenance, opening/closing tickets, and troubleshooting to isolate faults; manage the installation 100 to 250 users Voice-Over-IP using Motorola Canopy, Nortel NORTHSTAR PBX system with 2 analog and 600 to 800 data/voice connections using CISCO 1700 Router, 2950/3560 POE Catalyst switch to support site internal/external communications from a VSAT system; collaborates in assisting high level discussions with senior management to support insight and guidance for future department direction and growth; and produces outstanding periodic reports on the usage of Satellite terminal performance, department personnel status. Supervise a team of 10 IT Technicians. While abroad configure SAP for Finance and Accounting team.

1/02 – 9/03 Owner/Senior Manager
Confidential,Dallas, Texas
Direct the operation of computer system for maintenance, timely and accurate processing; formulated contracts with new vendors and companies in gaining their business and services that includes Siebel Analytics 7 and SQL Server 2000; accomplishes IT operations human resource objectives by recruiting, selecting, orienting, training, assigning, scheduling, coaching, counseling, and disciplining employees; communicating job expectations; planning, monitoring, appraising, and reviewing job contributions; planning and reviewing compensation actions; enforcing policies and procedures; supervised training new hires after acquiring new accounts; experienced in contractor negotiations, liaison with service agencies, personnel relation, financial management and other basic function for effective management of client properties; control and manage full profit and loss accountability which involves scheduling, cost accounting, cash flow analysis, purchasing, and professional relations.

7/98 – 11/01 Network Operation Center, IT Supervisor
Confidential,Dallas, Texas
Oversee a wireless network and system technology, which include ability to establish procedures, standards, and support structure to improve operations; team building – provided leadership, training, and supervisory to team members by praising individual performances; attentive to details – documented network outages in tracking similar case in drafting analytical and comprehensive reports; managed Frame Relay Virtual Private Networks compose of Nortel (BCN, ARN, AN) / Cisco (7500, 3620, 1004) routers that interfaces small to medium routers nationwide; supervise the a team of 10 personnel in monitoring alarms and defined abnormalities on circuits and database utilizing EMCOM, Siebel Analytics 7, Cisco Works, HP OPENVIEW monitoring applications.

12/97 – 6/98 Switch Engineer
Confidential,Cary, North Carolina
Tested and maintained business customer local service lines/trunks through Nortel DMS switches, ALCATEL 1630/1631/1633 Digital Cross-connects, voice and data, through T-1, DS3, CSU/DSU, POTS, Sonnet, XYPLEX terminal servers, and ISDN equipment with vendors and Local Exchange Carriers; developed statistical reports of system performance and capabilities after troubleshooting on large circuits outages; tracked, update open tickets, and escalate unresolved issues 4 level support group; responsible for dispatching field technicians to Customer Premise Equipment and assisting in troubleshooting to resolve complex telecommunication issues; monitored connectivity and track total outage for reporting to management after replacement and/or repair of defective products.
Confidential,10/96 – 10/97 Plans Departmental Coordinator
Naval Command Telecommunication Area Master Station EPAC,
Wahiawa, Confidential,

10/94 – 10/96 Radio Department Communication Watch Manager
USS Lake Erie (CG-70), Pearl Harbor, Hawaii

08/91 – 07/94 Satellite Communications Site Supervisor and Departmental Trainer
Naval Command Telecommunication Area Master Station EPAC,
Wahiawa, Confidential,

11/86 – 05/90 Radio Central and Teletype Operation Supervisor
Confidential,California to Norfolk, Virginia
(World Cruise)