SUMMARY:

• An Enterprise Data Warehouse Architect /ETL Programmer /D BA with a broad - base of skills and experience.
• Excellent verbal and written communication skills. Wide breadth of industry experience (Telecommunications, Insurance, Manufacturing, Retail, Higher-Education).
• Wide range of technical skills (SQL, Unix, Windows, Oracle, DB2, SQL Server). I’m seeking a position of responsibility leveraging these skills and experiences.

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

DATA WAREHOUSE ARCHITECT/DBA

Confidential

Responsibilities:

• Solely responsible for the logical/physical design of the Data Warehouse/ODS as well as the ETL development for both.
• Created Budget and Expense Datamart for 700 Budget Managers.
• Implemented row-level security in Tableau from Ellucian and custom permissions.
• Created and implemented Admissions Datamart, first from Ellucian, then from Salesforce.
• Creat ed ETL processes in Informatica to localize Salesforce data.

ERP PROGRAMMER ANALYST

Confidential

Responsibilities:

• Implemented 6 new PeopleSoft Financial Systems modules. Converted Clarkson’s existing Grants from proprietary system to Grants Module in PeopleSoft.
• Created SQR’s to generate the XML that controlled Selenium browser automation software.
• Implemented People Soft Travel and Expense module. Lead Programmer/Analyst authoring Clarkson’s implementation of a One Card program with Visa.
• Programmed the process to utilize files direct from Visa (VCF 4.0 format). Implemented Messages and Queues in Integration Broker to support this process.

PROGRAM MANAGER

Confidential

Responsibilities:

• Responsible for the Program Management of the Infrastructure team (DBA, Informatica Architect, Build and Release manager).
• Responsibilities were increased to include Program Management of the Tealeaf Data Acquisition project.
• This project involved the implementation of a Complex Event Processing engine to continuously subscribe/filter/scrub/aggregate web analytics data (Tealeaf).

SENIOR DEVELOPER

Confidential

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, Progressive'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. This data mart became the standard application in Progressive for analysis of spending patterns.

DATA WAREHOUSE CONSULTANT

• 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 Confidential 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 Confidential 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.
• Responsible for the administration of database structures to support PeopleSoft HR and Financials in DB2.

PRINCIPAL CONSULTANT

Confidential

Responsibilities:

• Lead consultant of Confidential for Confidential . 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 Confidential 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 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

Responsibilities:

• Managed a team of 2 Oracle/DB2 DBA’s and 2 Unix System Admins. 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 roll-out.
• 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 by 1:30 A.M.

DBA

Confidential

Responsibilities:

• Performed database support for applications development. Physical designer for Chemical Inventory, Chemical Material Definition, Chemical Process Definition, Test Results Definition, and Test Scheduling applications. One of 3 DBA ’s supporting 400 databases, 3,000 tablespaces, and 9,000 plans in 3 DB2 regions.
• Architect of the recommendation, design, implementation and support of rule-based systems to generate intelligent utility job streams. Performed a comparative evaluation of database object management tools. Produced recommendation and cost justification for purchase. Responsible for the installation and maintenance of database tools.