SUMMARY:

• Data Architect with 20+ years of experience as an ETL specialist, developer, network engineer, DBA, and business analyst seeks opportunities commensurate with experience.

TECHNICAL SKILLS:

SKILLS: SQL Server 2005/2008 Sybase ASE 11x/12x DB2 MySQL Content OnBase Management SharePoint Siperian MDM Cognos Data Manager 8 Warehouse Informatica COBOL (OS/360) Data Migrator PL/SQL & T - SQL SSRS / SSAS Team Foundation Server WebFocus 8 Peoplesoft Retalix HQ (pricing/orders) OS Active Directory Business Objects XIR2 Confio Ignite ER/Win Crystal Reports 9x/10x Microsoft Project 2010 T.O.A.D Visio Professional 2010

PROFESSIONAL EXPERIENCE:

Confidential, Sunbury, PA

Data Architect

Responsibilities:

• Architectural team member for the development of a conformed dimensional data model
• Team lead of Russian, Indian, and American developers/DBAs in an agile environment
• Developed code (PL/SQL, T-SQL, & WebFOCUS Data Migrator scripts) to support ETL processing
• Data profiling / cleansing / modeling as part of ETL processing
• Administered SharePoint & TFS sub-sites
• Metadata repository development to include business rules/processes, data dictionary, user interfaces, reports, documentation, communications, and workflow across systems.
• Converted Reporting Services reports to WebFocus dashboards Identity management system architect to include Active Directory, SharePoint, MS Exchange, and PeopleSoft HCM for more than 18,000 users.
• Managed DBAs, C#, and SSIS developers.
• Lead Tech Writer Contract Completed

Confidential, Milwaukee, WI

ETL & Application Architect

Responsibilities:

• Analyzed client schema to map loan, deposit, and fund transfer data to the QRM schema
• Developed an Excel-based metadata repository
• Converted FOCUS and Desktop Intelligence reports to SSIS packages and Web Intelligence reports
• Created and maintained Business Objects XIR2 universes
• Facilitated data loads/processing for the Loans cube (prototype)Contract Completed
• Developed Reporting Services reports for maintenance and capacity planning purposes

Confidential, Wausau, WI

Database Administrator

Responsibilities:

• DBA support of multiple MySQL and SQL Server 2005 OLAP and OLTP environments was provided. DTS/SSIS package development and maintenance was performed in conjunction with Team Foundation Server and SharePoint applications. As part of the server consolidation effort responsibilities included providing support for the implementation of VMware.Contract Completed

Confidential, Madison, WI

ETL Specialist

Responsibilities:

• Developed Data Manager 8.3 ETL processes including Type I slowly changing dimensions. Performed analysis to address partitioning, buffer pool sizing, parallel processing, thread management, physical/logical modeling, and index optimization. The insurance-based data warehouse supports customer service, claims, enrollments, and medical management functionalityContract Completed

Confidential, Chicago, IL

Data Architect

Responsibilities:

• Developed SQL Server based DTS/SSIS packages for the PaymentNet3 application in accordance with ETL processing (300 GB daily) to map credit card data to chart of accounts entries in addition to producing Reporting Services deliverables. Analyzed the warehouse architecture and enhanced data models.

Confidential, Rochester, NY

ETL Specialist

Responsibilities:

• ETL development and maintenance activities performed in support of the Order to Cash (OTC) and data warehouse and MDM projects. Engineered 2005 Analysis Services (2005) cubes supporting a dimensional model. Source systems include JD Edwards, Siperian MDM, Oracle applications, Manugistics, SAS, and SAP functional modules.

Confidential, Dallas TX

Project Manager

Responsibilities:

• Oracle database administrators, report writers, vendors, test coordinators, and testers. Developed overall project plan in addition to the following; test plans, acceptance criteria, a communications plan, status reporting, change/issues management, process documents, configuration management, error tracking, problem resolution, and coding standards.

Confidential, Trumbull CT

Data Architect

Responsibilities:

• ER/Win development to maintain and enhance dimensional models and ETL processes (including slowly changing dimensions) to sup data marts including facultative, treaty, and pro rata, business areas.
• Maintained physical and logical data models
• DTS package development to populate Oracle data warehouses.
• Provide DBA support to include stored procedure development, object creation, rights administration, query optimization, operating system configuration, and system architecture.
• Upgraded existing Oracle 9i databases to 10g in addition to porting from HP-UX 11 to SuSE Linux.
• Enhanced Business Objects universes and reports as required
• Migrated SQL Server 7.0/2000 databases to Oracle 10g
• Facilitated database content integration with various WebLogic services

Confidential, Baltimore, MD

Database Administrator

Responsibilities:

• Responsible for integrating an existing clustered SQL Server data warehouse for an acquired company within the acquiring organization’s infrastructure utilizing EMC hardware
• Developed Crystal reports in support of Peoplesoft financial applications.
• Project management, business analysis, design responsibilities for the data warehouse migration/reengineering effort. Participants include vendors, communication entities, resellers, distributors, marketers, call centers, and co-locaters.
• Developed a dimensional model to support marketing, order management, and accounting functions. Supplied dynamically generated content for PHP based web pages.
• Processed data via DTS package development.

Confidential, Harrisburg, PA

Database Administrator

Responsibilities:

• Maintained Oracle 9i, SQL Server 2000 / 7.0, and MS Access databases
• Supported Cognos Decision Stream and JD Edward's One World applications
• Implemented SQL Server transactional replication
• Developed DTS jobs for ETL purposes
• Utilized Snap Manager to perform backup and recovery operations for a Network Appliance SAN.

Confidential, Harrisburg, Pa

Founder

Responsibilities:

• Architect of an SQL Server / VBA based data entry / transmission application. The goal of the application is to: reduce data entry requirements, compress text-based data, and reduce bandwidth requirements.

Confidential, Dallas, TX

Warehouse Architect

Responsibilities:

• Developed PL/SQL scripts to facilitate demand and consensus forecasting.
• Configured online (forward/reverse) auctions and online catalogs.
• Developed metadata repository relating SAP schema and process elements to Confidential proprietary data structures.

Confidential, St. Petersburg, FL

Database administrator

Responsibilities:

• Migrated 100+ GB distributed Oracle 7x/8x databases on NT & Unix to Oracle 8i using Network Appliance storage.
• Administered and tuned an Oracle Parallel Server installation running on a VAX cluster.
• Implemented Oracle Enterprise Manager 2.0.4 with the Oracle Performance Pack
• PL/SQL development of stored procedures and packages.
• UML based object-oriented redesign of a distributed billing DBMS. Primary tasks included partitioning, normalization, and the conversion of relational to object tables.

Confidential, Annandale, VA

Data warehouse architect

Responsibilities:

• Architect of an inventory management data mart utilizing Oracle Express.
• Developed and performed ETL processes for Informatica PowerMart 6x and custom applications.
• Developer 2000, Visual Basic 5x/6x, and Access 97 form and report maintenance as part of SQL Server 7 to Oracle 7.3 conversion.
• Developed shell scripts (perl/korn) for backup & recovery processing for use with Veritas software.
• Administered Oracle Applications 10.7 inventory management module and associated workflows.