SUMMARY
Senior information systems professional with over 10 years of full life cycle application development and support experience. Experience includes Decision Support Systems, Intranet applications, Reporting solutions, and OLTP systems beginning with business analysis and design through development, database administration, data migration, implementation, tuning, support, and documentation (procedures and standards). Business area experience in financial, sales, inventory, accounting (payables/receivables), order processing/tracking, retail, and telecommunications applications. Have filled project roles as a logical/physical data modeler, development lead, Oracle database administrator, data architect, systems analyst, and developer.

PROFESSIONAL EXPERIENCES

Confidential (Tampa FL May 2009 – Current)
Sr. Consultant
Client: State Street Bank (Boston)

• PL/SQL packages, procedures and function for iShare project for Statestreet Bank.
• SQL performance tuning.
• Logical and physical database design.
• Documentation: Technical Design, Data Models

Skills: Oracle 10g, Sun, Linux, ERWin , TOAD

Confidential (Tampa FL July 2006 – Mar 2009)
Oracle Database Administration

• Data Modeling (ERWIN) for various projects.
• Work closely with application developers and ETL developers on database requirements in an Agile
• environment. Using SCRUM methodology.
• Logical database design and physical implementation (OLTP and DW/DMs)
• Database support (3TB in size) for various projects
• Manage user and developer security to the database
• Database monitoring on (OEM)
• Manage development, integration and production code migration process
• Application SQL tuning and performance
• Develop materialized views and PL/SQL packages and functions for performance.
• ODI (Oracle Data Integrator) to extract from SQL Server database and load to
• Oracle target. Also from Oracle external tables to Oracle target database using ODI.
• Put together data warehouse best practice and standards.
• Other day-to-day databaseactivities– Monitor Veritas Cluster Service to manage and monitor cluster nodes ,
• Oracle 10g Grid Control to monitor database activities and manage resources, manage users, data for QA
• testing, data cleansing, developed pl/sql purge process and archiving and documentations

Skills: Oracle 9i & 10g, Sun, Linux, ERWin 7, Unix (Sunos, Unix, Linux), ODI v10.1., Symantec- VCS, RMAN, !0g Grid Control

Confidential (Tampa FL) (October 2005 – June 2006)
Lead Data Modeler

• Logical/Physical Data Modeling for various applications using ERWIN
• Source Database: DB2 on AS400. Staging and Target Database: Oracle 9.2.0
• Develop PL/SQL packages, procedures and functions, Triggers, Materialzied Views
• Unix kron shell scripting for wrapper scripts
• Data Mirror replication tool from OLTP to DW staging
• Manage database security and use access

Skills: Oracle 9.2.0, ERWin 4.1.4, Data Mirror5.0, Sun4u Sparc v5.8, Korn Shell vi

Employer: Confidential (June 1999 – October 2005)
Oracle Clients:
BristolWest (Insurance)
As a senior Data Warehouse lead, performed the following logical design.

• Design Document for the Data Warehouse (Financial Data)
• Logical Design Document.
• Prototype of the design
• PL/SQL packages and procedures for ETL
• Extract data from Oracle 11i apps (AR, AP and INV) to data marts using OWB
• Discoverer End User Layer and reports
• Configure Oracle Portal for publishing executive dashboard Discoverer reports

Skills: HP, Oracle 10g, OWB 10g, Discoverer 10.g, Oracle Portal

Confidential
Data Warehouse Lead
As a senior Data Warehouse lead, performed the following logical design.

• Worked with business users to gather requiremets
• Design Document for the Data Warehouse (Financial Data)
• Logical Data Warehouse Design.
• Implemented Data Warehouse ETL Strategy and Architecture Design
• Prototype of the design

Confidential
Lead ETL/ Report Developer

• 1 Designed and implemented Sales Data Mart
• Data modeling of the star schema for the Sales Data Mart.
• 2 Logical and physical design of the sales mart.
• ETL process to populate the sales data mart from various sources
• ETL from Oracle Apps (OM and AR module) to sales data mart.
• All ETL Process developed using OWB 10G
• Discoverer EUL and sales reports

Skills: Oracle Warehouse Builder 10G, Discoverer 4.1.47, Oracle 11i (AR and OM), LINUX

Confidential
Oracle Reports Lead
Reports lead for Oracle Report 6i to generate reports for Sales and Service groups for Service performance analysis and sales of their product to the customers. The sales and service group use these reports to make critical business decisions.

• Reports access data directly from Oracle Applications (AR, WSH, MTL) modules.
• Created PL/SQL package and functions to extract data from Oracle Applications to populate custom reporting tables to improve performance.
• Performance tuning SQL to reduce runtime and by creating views, functions and indexes to improve performance
•  Created Discoverer reports running against the custom tables and views data
• extracted from the Applications modules AR, WSH, MTL and ONT.

Skills: IBM RS6000 AIX V4, Oracle 6i and 9i, PL/SQL, Discoverer 4.1.46

Confidential
ETL Technical Lead
Designed and architected Point-Of-Sale data for client’s retail data warehouse. Data source from TOMAX (Retail POS system), transform and load the retail dimensions and fact tables. Extensively, used Informatica PowerMart for the ETL process.

• Researched and analyzed the TOMAX database for POS dimensions and fact data.
• Created star schema data model for the POS SALES FACT
• Developed ETL process to extract data from source (TOMAX) to DW Staging tables. Transformation and load from the staging to the retail data warehouse schema.
• Also designed and developed inventory by location fact on daily basis.
• Tested and implemented the process.
• Developed Sales, Inventory and Financial reports in Business Object reporting tool for end users. Sales and Inventory universe and user access/security on the universes.

Skills: SUN4u Sparc 5.8, Oracle 9i, PL/SQL, Unix shell scripts, Informatica PowerMart V-5.1.2, Business Object 5.1.6.

Confidential
Oracle Reporting Technical Lead
Designed, developed, and implemented a reporting environment using Oracle Reports accessing OFSA (Oracle Financial Services Application). Lead the Source System Analysis initiative, mapped source data into the reporting data mart, and designed & developed the data migration/load routines to support the Data Mart Reporting System. Created PL/SQL packages and procedures to load OFSA data into the reporting tables for Sr. Management, Customer, and Organizational Profitability Reports.

• Designed overall reporting environment including database-reporting tables.
• Developed PL/SQL packages and procedures to load reporting tables from OFSA
• Created prototype in Oracle Forms to run reports based on user selected
• parameters.
• Setup Reports and Forms to run in an Oracle 9ias environment on NT Server platform

Skills: IBM RS6000 AIX V4, Oracle 8i, PL/SQL, Unix, Forms and Reports 6i, 9iAS Rel1 on NT.

Confidential
Lead Developer for a high profile internal Oracle project

• Designed and developed multiple financial reports using Oracle Reports for an executive management scorecard.
• Interviewed business users and documented the functional and technical requirements.
• Designed and implemented the security within Oracle Portal to ensure report data is displayed based on the user’s level within the organization.
• Responsible for data migration/loading in support of the Business Intelligence System. Designed and developed the ETL procedures in PL/SQL to extract data from the source systems and load the data into the reporting environment. Report data resides in OFA, PAA, and Oracle Express.

Skills: LINUX V 0.9.6, Oracle 9i, PL/SQL, Reports 9i.

Confidential 
Technical Lead/Developer
Database, ETL, and Report design architect supporting a system that matches consultant skills to consultant available job roles. The on-line process creates individual training paths to ensure consultants gain the necessary skills to support new consulting opportunities.

• Database design.
• Data Architect (Source data analysis, mapping, and ETL development)
• DBA Tasks for production support.
• PL/SQL procedures and functions to support XML front end.
• Setup 9ias for Forms and Discoverer 4i.
• Created Oracle Forms 6i and deployed in portal.
• Performed various Discoverer Admin and User report activities.

Skills: Compaq Tru64 UNIX V.1, Oracle 9i, PL/SQL, Oracle Discoverer, SQL LOADER, SQL Navigator, Unix, korn shell, Forms 6i, 9iAS R2

Confidential

Discoverer Reporting and ETL Technical Lead
Design Consultant responsible for creating the decision support report environment

• Technical Lead for Discoverer Reporting
• Supported upgrade from Discoverer 3i to Discoverer 4i
• Tuned the Oracle End User Layer (EUL)
• Lead ETT developer for Operational & Planning, Sales, Profitability and Product Data Marts.
• Created load Modules for populating the Oracle Data Warehouse database in Oracle 8i.

Skills: HP-UX 9000, Oracle 8.0.5, PL/SQL, Oracle Discoverer, SQL LOADER, SQL Navigator, Unix, korn shell.

Confidential 
ETL Team Lead/ Developer
Automated ETL processes

• Automated the click stream data insert process
• Automated the load of data into an Oracle matrix table for analysis and reporting.
• Enhanced performance of loading processes
• Improved controls by creating error or success messages for each load and sending results via e-mail to the group administrator.
• Automated several extract processes for down stream feeds.

Skills: Unix, Korn shell scripts on sun4u sparc SUNW Ultra-4, PL/SQL, Oracle 8.1.6, Awk/Sed 

Engagement Expertise

• Data Warehouse Technical Architecture and Design
• Relational Data Modeling and Normalization
• § Data Warehouse ETL Strategy and Architecture Design
• PL/SQL Developer
• Informatica PowerMart 5.1.2
• OWB 10G

Relational Databases

• Oracle 7.x, 8, 8i, 9i, 10g
• DB2
• Oracle 11i (AP, OM,AR,GL)

Operating Systems

• AIX,
• SunOS
• Linux RedHat
• HP

Languages/Tools

• C
• SQL Plus
• PL/SQL
• Pro*C
• Perl
• UNIX shell scripts, awk, sed
• Oracle SQLDBA
• Discoverer
• Business Object 5.1.6
• SQL Loader
• ERWIN
• ODI (Oracle Data Integrator v10.1.3

Industry

• Broadcasting
• Marketing and Research
• Consumer
• Retail
• Media and Advertising
• Oil
• Telecommunications
• Shipping

EDUCATION & CERTIFICATIONS

Education

MBA in Information Science 
Bachelors in Business & Commerce

Training

• Oracle BIS/EDW Installation
• Oracle Portal
• Advanced PL/SQL.
• Database Administration 8i
• Advanced PL/SQL.
• Oracle Warehouse Builder 10g