PROFILE:

An expert in architecture, design, development, and support of Enterprise Data Warehouse and Datamart initiatives. Well - versed in Data Analysis, with excellent communication skills. Wide breadth of industry application experience (Manufacturing, Insurance, Retail, Telecommunications). Wide breadth of technical skills (SQL, Unix, Windows, MVS, Oracle, DB2, SQL Server). Has successfully developed and supported reporting applications for web and phone telemetry.

SKILLS:

DB2; SQL Server; Redbrick; Data Warehousing; OLAP; SQL; C#; COBOL; JCL; MVS; Windows; Unix

EXPERIENCE:Owner

Confidential, Rossie, NY

Responsibilities:

• Raising livestock for commodity auction market.
• Building trails, thinning woods thru 463 acre woodland for recreational tourist trails, as well as maple sugar harvest.
• Developed business plan to grow the farm utilizing management practices to improve the soil and water resources.
• Grass farming, low infrastructural imprint. Inoculated 500 logs with Shiitake mushroom spawn.
• Developed relationships with area restaurants to sell shiitake harvest.

Program Manager

Confidential, Seattle, WA

Responsibilities:

• Responsible for the Program Management of the Infrastructure team (DBA, Informatica Architect, Build and Release manager). Managed the upgrade to Informatica 8.1.5.
• Responsibilities were increased to include Program Management of the Tealeaf Data Acquisition project.
• This project involved the implementation of a Complex Event Processing engine (Coral8 software) to continuously subscribe/filter/scrub/aggregate web analytics data (Tealeaf).
• Met with leaders of federated datamarts.
• Created presentation describing disparate, overlapping decision support functions within the organization.
• Authored recommendation on consolidation of the data information resource, while maintaining federated local autonomy.

Senior Developer

Confidential, Mayfield village, OH

Responsibilities:

• Implemented upgrade to system reporting of call center performance data. Re-hosted data reporting back-end from Sybase to DB2. Improved performance of Avaya data acquisition application in middle-tier server. Application acquired call center performance data from over 100 disparate call center servers.
• Reduced batch run-time from 6 hours to 2 hours.
• Lead developer for (PBL) Profit-By-Line System, Confidential 's internally developed financial reporting application.
• This system extracts revenue and expense amounts from the General Ledger system (Peoplesoft), and apportions costs to products based on various utilization statistics.
• The final outputs of this application are Income Statements for each of the products, by company and state. Allocation results are loaded to Analysis Services for historical, detailed analysis.
• Lead developer for the creation and implementation of the Expense Data Mart.
• Created ETL process to extract from the General Ledger on a daily basis, and transform/append the results to the data mart.
• I worked closely with financial analysts to balance results to the GL and legacy reporting systems.
• Datamart implemented into Production 3 months from project initiation. This data mart became the standard application in Confidential for analysis of spending patterns and cost containment.

Data Warehouse Consultant

Confidential

Responsibilities:

• Designed star schema in support of gas deal accounting initiative. Logical model was designed in Erwin using Modelmart to describe data sources from Enterprise Data Layer.
• Led interviews with customers and subject-matter experts to gather requirements.
• Responsible for the support and continued development of a 350 GB Data Warehouse in Redbrick DBMS.
• This Data Mart contained Call Detail, Billing, and Order data. Responsible for maintaining production Extract, Transformation and Load (ETL) code (Perl, UNIX shell, RISQL) in a very dynamic, rapid growth environment.
• In addition, I was the primary on-call contact for resolving issues in the production environment.
• I performed the upgrade of the Redbrick database from version 5.1 to 6.0.
• Created process to synchronize Test and Production environments.
• Created scripts to administer database environment.
• Documented turnover requirements to standardize the communications necessary to implement new datamarts. Implement 6 new datamarts.

Senior Developer

Confidential, Los Gatos, CA

Responsibilities:

• Lead consultant of WorldCom for Redbrick. Technical Lead of IS teams (multiple-site engagement) in the scope, design, implementation, and production roll-out of 7 data marts.
• Provided project management and technical support for a team of 3 consultants
• Created data mart to contain the Enhanced CDR records from all WorldCom long distance switches. 750 GB application, which contained 1.5 billion rows.
• Created Rollover strategy and script to perform automated segment/partition management on a daily basis.
• Loaded 35-50 GB, 100-150 million rows per day in to this dynamic data mart.
• Designed and developed aggregated tables to support high-level queries and drill-down analysis.

DBA Manager

Confidential, Hudson, OH

Responsibilities:

• Working manager for a team of 2 DBAs and 2 UNIX System Administrators.
• Created logical and physical design (star schema) for Merchandising Information data warehouse (150 GB).
• Created file transfer and load scripts to pull the data from our operational database (DB2).
• Created aggregation routines to provide summary tables for drill-down purposes.
• Performed installs and maintenance upgrades for the Information Advantage Decision Suite toolkit.
• Responsibilities were increased to include the infrastructure development of UNIX (HP-UX) environment.
• Infrastructure development enabled growth of the environment to support a 150 GB data warehouse. Made purchasing recommendations and managed spending on $480,000 capital acquisition to build the environment from conception to production rollout.
• Initial assignment was improving the nightly batch processing performance.
• The single Distribution Center for the company was regularly at risk of not having the pick-lists for 400 warehouse employees by 7:30 A.M. deadline.
• Improved batch performance so that on average, pick-lists were available.