Al has twenty years of Information Technology experience with fourteen years in Data Warehouse, Business Intelligence, Data Visualization, Data Modeling, Dashboard - ETL design, development, implementation and management. His ETL tool's are Informatica, Oracle Data Integrator with OBIEE, SAP Business Objects, and Qlikview for reporting with additional specialty in Teradata. Al's knowledge includes dimensional modeling and development in business processes such as orders, shipments, inventory, financial, claims, policies, procurement and invoicing. Al's expertise has afforded him opportunities to work in retail, manufacturing, healthcare, insurance, pharmaceutical, education and telecommunication industries. He is adept at facilitating sessions defining user requirements, developing and delivering end - user training, creating and maintaining project schedules, and preparing presenting project briefings to executives. Al has the vision to improve business with the efficient use of technology by evaluating gaps.

Databases:

• DB2 UDB 8.x, 7.x, 6.x, Oracle 11G, 10G, 11.x, 9,x, 8.x, 7.x, Oracle Times Ten IMDB, Cloudera,
• Hortonworks, MS-Access, MySQL, NoSQL Cassandra, MongoDB, Hadoop Flume, Hbase, Hive,
• Impala, MapReduce, Pig Sqoop , SQL Server 2012, 2008, 2005, 2000, 7.0, 6.5, 6.0, Redbrick, Sybase 12.5, 11, Teradata 13, 12

MPP Systesm: Cassandra, Hadoop, MongoDB and Teradata.

Enterprise Resource Planning:

Oracle Applications: Order Management, General Ledger, Accounts Payable, Accounts Receivable, Project Accounting, Inventory, Customer Relationship Management, Work in Process, Incentive Compensation and Shipping

Languages:

C , C, Java SE 1.X, SQL, PL/SQL, T-SQL, Perl 5, OraPerl, JavaScript, Html, ksh, bash, and XML XLST and XQuery .

Database Design and Tools:

Relational OLTP , Dimensional DSS, OLAP and Object Oriented. ErWin and ERStudio.

Data Discovery and Visualization Tools:

Oracle Endeca Information Discovery, Qlikview

ETL Tools:

• CloverETL, Informatica PowerCenter, Oracle Data Integrator, Oracle Warehouse Builder, SQL Server
• SSIS, DTS , Data Warehouse Administration Console DAC, Talend and Pentaho.

Business Intelligence Tools:

• Oracle Business Intelligence Enterprise Edition OBIEE Siebel Analytics , Oracle BI Publisher, Oracle
• Business Intelligence Applications OBIA, SAP Business Objects WebI, Information Design Tool,
• Universe Design Tool , SQL Server SSRS, Pentaho

Software:

• Apache Web Server, Quest Software Data and Schema Manager, Toad , Embarcadero DBArtisian,
• Rapid SQL , Crystal Reports, Eclipse, IBM HTTP Server, MS-Project, Netbeans, Oracle AWM, Fusion
• Middleware, RAC, PL/SQL Web Tool Kit, RMan, Web Application Server, Weblogic ,
• PVCS, Rational Clear Case, SQL Navigator, Statspack, Teradata Teradata Studio, BTEQ, SQL
• Assistance TKPROF and Veritas Cluster Software

Operating Systems:

UNIX Sun Solaris 8, 7, SCO UNIX, HP-UX 11i, IBM AIX 5L v5.2, Linux , Windows 2003, 2000 and

NT

Other Technologies:

Data Virtualization and Web Services

PROFESSIONAL EXPERIENCE

Confidential

Solution Architect Business Intelligence - Data Warehouse

Teradata OBIEE Architect for PeopleSoft Purchasing Spend Analytics and Oracle Endeca Information Discovery

BizRate

Lead Data Architect responsible for BI/DW technology OBIEE, Talend, Enterprise DW and 200 node Hadoop platform as an extension that comprise an Enterprise Analytic Data Hub.

Product Partners

Leader who is redefining requirements gathering, data modeling and dashboard design the system with new functionality for partner revenue of their existing BI Sales system. Technologies involved are Oracle 11i ERP, Data Guard, OBIEE, Informatica and OWB.

Activision Blizzard

Implemented Oracle's Point of Sale BI/DW Oracle DSR application at gaming software company in Santa Monica. Leader of the implementation which comprised of two OBIEE and three ETL developers. Main interfaces Oracle 11i ERP.

Openwave Corporation

Data Architect for a BI/DW upgrade of a Billings, Bookings and Backlog at a mobile analytics organization in Redwood City. Key technology components were Oracle 11i ERP, OBIEE and Informatica.

Confidential

Business Intelligence - Data Warehouse

As a senior member of the Business Intelligence Practice my specialty is Data Warehouse Lifecycle with primary products being Oracle Data Integrator 10gR2, Informatica 8.6, OBIEE, OBIA, Discoverer, Portal and Application Server. Lead development efforts 500k-1M projects in custom applications for data acquisition and access for federal agencies and electronic commerce. During these projects, have provided demonstrations and trained developers on the proper used of Oracle BI/DW products, data modeling and the leadership of a Business Intelligence project using Oracle software methodology.

Confidential

Manager Business Intelligence - Data Warehouse

• Results oriented leader who constantly evaluates current business processes identifying strength and weaknesses. Recommends and implements new Business Intelligence BI strategies to empower improve business analysis. Constantly, leverages evolving BI technologies in the best interest of business.
• The technical lead for four BI Developers managing development efforts, providing leadership and supervision. Managed implementation projects.
• Architect for custom ERP BI Implementation
• Lead migration effort to Oracle 11i for BI
• Current system is an Oracle 11i ERP system on 8i and Solaris 9. The 11i Apps database is 1TB and the DW 600GB. Functional pieces include Order Management, General Ledger, Accounts Receivable, Inventory, Customer Relationship Management, Work in Process, Incentive Compensation and Oracle Shipping Warehouse .
• Data Marts shipment, transaction, point of sale and VMI based on the use of flex fields from ont.oe order lines all were designed and developed using Oracle Warehouse Builder 300 mappings used to load extract, stage and dw , KSH/PL/SQL stored procedures, Dimensional Modeling and UML notation. The key data mart is shipment based on OM, WSH, tracking booked, shipped, canceled, deleted lines, wholesale dollars, gross dollars, net sale dollars, freight cost and freight charge. The aggregates that support the shipment data mart calculate sales adjustments, credits, debts, rebates all previous items from AR , commissions OIC and all pertinent facts from the shipment fact table are based on customer product. Oracle Discoverer is used for reporting.

Confidential

CONSULTANT

• Lead Architect two other associates for first project, a full life cycle design with an emphasis on Rational Unified Process which uses Oracle 9i, RAC Sun 5.8, IBM WebSphere, MQSeries and Vitria's Businessware for an EAI system. Environment included development, quality assurance, customer connectivity testing and production. Established data model, data loading, cleansing, tuning BMC Patrol , capacity planning, backup and recovery RMAN for a department Standard Operating Procedures manual.
• Instrumental in the deployment of Oracle and WebSphere for the first phase of the project that went into production on the 16th of October 2002 3rd phase 16th of October 2003 . Developed the processing logic using PL/SQL and Java stored procedures for a real time reporting system tracking Healthcare transactions down to the milliseconds.
• Primary use of the application involves real and batch transactions between entities governed by HIPAA regulations. The formats of these transactions are either EDI or XML based which were stored in Oracle as CLOBs. Transaction volumes approached 900,000 on a daily basis.
• Designed Business Associate Data Model used for routing and establishing processing rules for transactions. Developed cleansing, transformation and loading tools for model based on data validation Use Cases.
• Second project involved with maintaining a current Web application using Oracle 8i, Sun 2,8, Java and XML. The later two technologies are used for backend processes to cleanse, normalize and load data.
• Third project used technologies such as SQL Server 2000, T-SQL and DTS for nightly loads into a target reporting database.
• Installed, configured, troubleshot and tuned IBM WebSphere V5 on Sun 5.8 through all environments Development, QA, External Customer Test and Production.
• Supported Sybase ASE 12.5 on Solaris.

Confidential

PROJECT MANAGER CONSULTANT

Managed, planned, designed and upgraded the infrastructure for ten existing database systems with web based applications to Oracle 9i, Oracle Replication, Sun V880 running 5.8 and IBM AIX. Database versions migrated were Oracle 7.3.4, 8.0.5 and 8.1.6, MS-SQL Server 7.0 and DB2 UDB 8.1 ranging in size from 500mb to 80 GB.

Apache Web Server, C using CGI , Cold Fusion, Java, Perl, HTML, Oracle Web Application Server, PL/SQL Pages and Web Tool Kit were existing applications rewritten to use the latest version of Oracle 9i.

Confidential

DATA WAREHOUSE DEVELOPER CONSULTANT

• A developer on an eight member data warehouse 500GB team analyzing company and competitive pharmaceuticals sales using Oracle 8i PL/SQL, Perl, JDBC, Korn and Bourne shell scripting on HP-UX. Enhancing current ETL process by redesigning, quality checking and changing current relational model to a dimensional model via logical to physical design of data warehouse using Oracle Warehouse Builder. Wrote SQL and PL/SQL statements and introduced partitioning to large tables so the database may perform more efficiently.
• Designed and developed 2002 Data Marts for initial and monthly loads. Case tools used were ErWin and ErWin's Model Mart.

Confidential

DATA WAREHOUSE CONSULTANT

• Part of a six member team which designed and modeled a 200GB data warehouse prototype from an existing legacy system VSAM to an Oracle 8i on Solaris 8 with MS-Access 97 as a front end report tool.
• Mentored VP of Health Systems, Manager of Programmers Claim , Manager of Programmers Policy , Manager of Tech Services and various other team leaders in Oracle, MS-Access 97, star schema, relational data modeling and SQL.
• Supported Oracle Financials which included Forms, Reports and Oracle 9i Portal.

Confidential

DATA WAREHOUSE CONSULTANT

• Managed trained two Developers in database administration and designed a data warehouse conversion from Redbrick to Oracle 8ion IBM AIX. The new data warehouse includes improvements to an old Star Schema and the new data warehouse features Oracle 8i provides such as summary management, query rewrite and enhanced partitioning methods.
• Updated a data model for Java Web developers from an old sales and marketing database. Migrated two MS-Access databases to Oracle. One database used for logistics tracking and the other for a help desk application. Developed an automatic load process for a MS-Access application into Oracle leveraging SQL-Loader, Oracle PL/SQL, Perl and ksh scripts. Additional tools used were Oracle Enterprise/Recovery Manager and ErWin.
• Managed SQL Server 6.0 databases as an intermediate operational data store for Oracle and Redbrick data warehouses.

Confidential

DATABASE ADMINISTRATOR CONSULTANT

• Database Analyst on a three month project with a progressive and exciting Internet Startup. Designed
• An Oracle 8iDatabase on IBM AIX with Interworld an ecommerce package specializing in CRM. Assist the Data Architect by providing input to the customer data model and deploying the logical entities to physical objects in Oracle.
• DBA member of an Oracle Financials Implementation team.
• Instituted rules and guidelines for deploying Oracle instances from Development to QA and Production. Worked in conjunction with DIGEX an online hosting facility to establish an Oracle HA
• High Availability database for this Internet Startup.

Confidential

LEAD DATABASE ADMINISTRATOR

• Lead Oracle Database Analyst for Anixter's remote WMS Warehouse Management System . Mentored two DB2 DBAs and Senior Developers in Oracle and UNIX environments. Pioneered the introduction of Oracle Databases to a company with many centric legacy systems and applications. The new WMS program improved warehouse efficiency from 76 capacity to greater than 90 capacity. The past year Anixter has implemented six production databases, two development databases and two training databases mobile databases for training of warehouse personnel . Responsible for database reorganization, performance tuning and backup/recovery of OLTP and DSS databases on various platforms to include Sun Solaris, HP-UX and Windows NT.
• Designed a centralized database/server on a Sun Solaris 5500 eight processors with an EMC Symmetrix 5430-18 Enterprise Storage System Mainframe, Open Systems . This server will accommodate six production Oracle databases with the potential of encompassing all forty-three of Anixter's DC Distribution Centers in North America. This database has one instance with six separate Schemas for six DCs. The DCs will be sharing SGA/PGA, rollback segments, temporary tablespace, system tablespace and redo logs. Engineered this centralized architecture will save Anixter from investing in single Sun 3000 and Legato backup solutions at each individual DC.
• Established 'Purge and Archive' program to alleviate space problems for dynamic tables by transferring history greater than 90 days to a DSS database through the implementation of database triggers and stored procedures. This process eventually provided ease of database administration by preventing objects tables and indexes from over extending and eliminating of storage in tablespaces.
• Converted SQL Server databases from version 6.5 to version 7.0 to support PeopleSoft version 7.5. Managed and tuned SQL Server for PeopleSoft HRMS.

Confidential

I.S. MANAGER

• Manage Systems Support staff and Developers as direct reports. Responsible for department operational and capital budgets.
• Oracle Database Administrator for three production and three development databases running on SCO UNIX servers. Ensured the performance and stability of the production databases by optimizing memory usage in the SGA, monitoring space usage, validating database statistics, rebuilding indexes where necessary and performing regular database backups. Implemented a third development database on a SCO UNIX server using ERWIN to reverse engineer the production schema.
• Support Computer Telephony Integration between Fujitsu telecommunications equipment, the Melita predictive dialer RS/6000 for outbound campaigns and the call center infrastructure. A Fujitsu 9600 PBX and EMML programmer with four ISDN PRI T-1's ANI and DNIS processing. Centigram Voicememo and Automatic Call Distribution ACD SCO UNIX server are used to satisfy the inbound requirements of the call center. Loaded data into Sybase Database for calling queues used by Melita predictive dialer.

Confidential

SYSTEMS CONSULTANT

System Administrator for four LANs running Netware 4.1 and Windows NT 3.51.

Confidential

NETWORK SUPPORT

Designed 4.1 Novell NDS Tree for manufacturing company by migrating from Novell 3.11.

Confidential

CRYPTOLOGIC TECHNICIAN SECOND CLASS/E5

• Supervised, trained, and evaluated a staff of eight technicians. Scheduled and controlled the installation and maintenance of electronic systems ensuring that all work and documentation was maintained to US military standards. Responsible for the purchase of parts and materials for multiple sytems.
• Troubleshot complex malfunctions in many electronic systems including, Novell, UNIX, IBM compatible PC's, notebooks, HP laser printers, high speed line printers, Computer Satellite Communications, Counter measure Receiving Set Signal Processors, High Frequency Direction Finding Equipment, LF/MF/HF/VHF/UHF multi-couplers, receivers, antennas, spectrophotometer, centrifuges, power supplies, Cryptographic and many other medical equipment.