PROFESSIONAL SUMMARY:

• Over 15 years of progressive software development, design and management experience in several technology market spaces including Hospitality, Retail, Finance,, Insurance and Retail Energy Commodities. A strong functional knowledge of both current and legacy technologies and design methodologies. A demonstrated ability to achieve results by driving innovation, creating and articulating a vision, setting priorities, allocating resources and embracing change. Consistently meets and exceeds service level agreements and possesses strong technical problem solving skills.
• Data/Solutions Architecture - Production Support Management - Process/IT Development - Reengineering/Performance Tuning - Coaching/Teambuilding - Vendor Management - Client Relationship Management - Data Analysis/Engineering - ETL Design/Implementation - Business Intelligence - BIG Data

TECHNICAL SKILLS:

Databases/Languages: ORACLE 8I, 9I, 10G, 11G, PLSQL, T-SQL, MySQL, SQL Server, DB2 LUW 8.1 - 10.5, MariaDB, POSTGRES SQL, NETEEZA, MONGODB, HADOOP, PERL, IMS, MSACCESS, SAS, VB, C/C++, COBOL/COBOL2, CICS, Micro Focus, PHP, HTML, Java Script, TSO/ISPF, JES, JCL, VSAM, FTP, UNIX Shell Scripting.

Operating Systems: MSDOS, UNIX(Solaris), MVS, LINUX(Red Hat 7.2, Ubuntu 12 - 14 ), Windows 98/NT/2000/XP/ME/7/8/10.

Tools: UML, PVCS, ENDEVOR, MSOFFICE, T.O.A.D., SQL Loader, Rational Rose, Crystal Reports, SPUFI, SQL Navigator, OEM (Oracle Enterprise Manager), QMF, MIDAS, EOWIN, TKPROF, CRONTAB, AUTOSYS/ERWIN/TFS SQL Server Management Studio

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Enterprise Data Architect, Director

Responsibilities:

• Redesigned an 8 TB SQL Server 2008 North American Claims database for integration into an International DaaS solution existing on DB2 LUW 10.5. integrating with a Hadoop stack for advanced analytics
• Assessed, documented and proposed a comprehensive data consolidation solution for a 14 TB Medical Billing Reporting and BI platform from a legacy DB2 architecture to a SQL SERVER 2008 EDW.
• Proposed the framework for a 20 million dollar complete redesign of a 10 TB Global Risk Rating and Loss Exposure Platform existing on SQL SERVER 2008 including OLAP cubes for reporting and analytics that was implemented 3rd and 4th quarter 2015.
• Acted as the primary contact point for all data architecture concerns and strategies for North American technology coordinating the resolution and mitigation of production issues with key business stakeholders and clients
• Mentored and coached 6 junior architects
• Coordinated the integration of data across the enterprise into a common taxonomy available Con both Legacy Confidential and Legacy Ace development
• Continuously reviewed and enforced data architecture and development standards through ongoing architectural oversight of database development activities including the implementation of a basic MDM solution

Confidential, Allentown, PA

Solutions/Data Architect, AVP

Responsibilities:

• Redesigned a proprietary Energy Commodity trading platform for SOX1 compliance, scalability and performance issues existing on ORACLE 11G.
• Acted as data steward for all enterprise data identifying and resolving defects in both data quality and design
• Provided comprehensive oversight of enterprise data standards and database development practices for strict adherence to Energy Commission guidelines for SOX and audit compliance
• Had 5 development leads matrix report to me as part of a long term strategy for adherence to data architecture standards and guidelines

Confidential, Hollywood, FL

Data Architect

Responsibilities:

• Assessed, proposed and documented the redesign and integration of multi-terabyte SaaS compensation system from operational ownership to systems ownership existing on Oracle 11G
• Coordinated the redesign of the enterprise data taxonomy for integration firm wide with all existing and new application development efforts

Confidential, Pennington, NJ

Database Architect/Deployment and Integration Manager

Responsibilities:

• Designed and implemented a custom 250 GB data warehouse and data capture system for a firm wide compliance and risk reporting repository including OLAP cube design and integration with Hadoop for analytical reporting
• Contributed as an SME for the enterprises DBMS disciplines including development standards, data architecture, performance tuning and database architecture implementation
• Managed and coordinated the synchronous implementation and deployment of 20+ releases for 13 systems including both scheduled and off-cycle releases
• Assisted in the hiring, structuring and development of application and support teams including, coaching and mentoring
• Contributed as a Subject Matter Expert for ORACLE 9I, 10G, POSTGRES SQL and SQL Server database and performance tuning concerns
• Coordinated, estimated and assigned break fixes and small enhancements for post implementation issues

Confidential, Princeton, NJ

Solutions Architect/Technical Lead

Responsibilities:

• Designed and implemented a comprehensive data capture utility and data mart utilizing Oracle 9i, My SQL and PHP to deliver real time analysis of production data in the support of online world wide testing for TOEFL and GRA
• Automated and documented over 100 manual tasks using PERL and Linux scripting to stream line support processes and allowed for more efficient use of the teams resources during active support periods
• Contributed as an SME and mentor for the departments, standards development and operational support model including compliance and audit

Confidential, Hopewell, NJ

VP of Production Support/Strategy/Development

Responsibilities:

• Implemented and maintained comprehensive systemic monitoring process using UNIX shell scripting and ORACLE 9I stored procedures for the proactive communication and support of critical production processes
• Contributed as a Subject Matter Expert on platform development, FASB reconciliation and custom UNIX/Mainframe/ORACLE ETL development for integration and support of new and existing clients.
• Provided 24 by 7 support of critical path batch systems, online availability and scheduling/execution of 500+ proprietary ETL jobs
• Managed a staff of 15 consultants and 6 FTE’s
• Managed and forecasted a budget in excess of 5 million dollars

Confidential, Hopewell, NJ

AVP Conversions/Migrations/New Business

Responsibilities:

• Outlined strategic direction and project plans for the overall migration effort of over 200 companies ranging from 50,000 to over 20,000,000 rows of data
• Ensured compliance with SOX, FED and SEC data standards
• Developed and implemented standardized and custom stored procedures and ETL scripts to process incoming data adding consistency, client focus and minimizing load times
• Created a standalone production look alike ORACLE environment emulating loads and processing for over 300 clients and 500,000,000 rows of data
• Managed a staff of 6 consultants and 3 FTE’s
• Managed and forecasted a budget in excess of 2 million dollars