Remarkable experience in SQL queries, Extensive Huge knowledge of Informatica ETL process design, Deep knowledge of Oracle database, data warehouising design and architecture.
Wealth of experience using analytical,Engineering, and computational techniques BI reporting tools: Business Objects, COGNOS, IBM TM1, Oracle 10g, 9i, 8.xx, Strong PL/SQL skills, DBA tasks and extensive experience with ETL tools Informatica PowerCenter 9.xx, Workflow manager, Designer., Monitor, Administrative console
Experienced in all phases of data warehouse development lifecycle, Planning, Gathering requirements analysis , Design and implementation. Responsible for definition and integrity of data warehouse data elements and thier tie- back to the originating systtems.
Design conceptual models outlining programmatic instruction to ETL and database developers for implementation of new data marts or enhancements to existing martsbased on user requirements, for the Keystone data warehouse used by the Air Force for tracking logistics and accounting information relevant to its spare parts working capital fund. it consist of 22 source systems and 16 data marts.
Transforming legacy source systems data into a format for the new Oracle start schema environment and the loading of this data into the database structures.
Utilizing Oracle 11, Informatica ETL, BI reporting tools Business Objects, COGNOS, IBM TM1 budget system.
SQL , Shell scripting, Materilized Views, Partitions, and parallel processing.
Experienced IBM Cognos TM1 technology, Building a TM1 Cube budget system for the airforce from more than 1400 EXCEL work sheet, , converting formulas, and rules to the TM1 Cube technology system. Using TM1 contributor, WEB SHEETS, and Cognos Architect.
One of the three major products WorldCom offers is VPN (Virtual Private Network).
A data warehouse system to extract data from Lucent and Cisco routers and loaded into a star schema data warehouse system to report on the efficiency of the communication between the different nodes for a VPN to determine if the numbers meets the SLA numbers.
Data are collected and extracted from the different routers and loaded into the ORACLE database system on an hourly basis.
Utilizing ETL Tool Informatica Power center, Connected five Oracle instances, three Sybase instances, XML and flat files.
Claim Data warehouse: data is extracted, transformed, and loaded into an ORACLE system to be analyzed and reported to High executives and department managers for decision making, checking total amounts for claims on daily, weekly, monthly and quarterly basis.
Extract data from the IBM legacy System and VSAM files, Transfer and load data into client server Oracle RDBMS systems.
performance tuning issues, checking the alert file, UTLBSTAT and UTLESTAT reports, tuning the SGA, tuning rollback segments, the usage of Oracle blocks efficiently, optimizing sorts operation, monitoring and detecting lock and latch contention.
Managed Oracle Objects (Tables, Indexes, Views, Procedures, Triggers, Functions) analyzing tables for optimization purposes, reorganizing indexes, managing roles, privileges, users, and security. Grant , revoke privileges to users and groups.
Created Oracle instances, setting up initial parameter files, configuration of control and online redo log files, memory utilization and SGA configuration.
Installed and administered COGNOS – IMPROMPTU, and Power Play Cubes software to generate ad hoc queries, and multiple dimension data cubes to enable users to drill down to details, Both products run over the World Wide Web.
Specializd in Relational Databases
Empahsis on analysis, design and programming languges
Companies Worked For:
Job Titles Held: