• Work with department managers to build data sets that answer their specific business questions including performance dashboards.• Designing and execute the successful Proof of Concept to move the company reporting from on-premises Oracle to AWS Redshift..• Select new replication software, Qlik Replicate, to simplify the existing ETL processes after multiple vendor trials.• Leading the project to migrate HomeServe’s on premises Oracle database into the AWS cloud changing the reporting database platform. This includes developing the project plan for the move, tracking what changes would need to be made to the current ETL processes, setting up data replication for both internal databases as well as Salesforce and working with multiple reporting teams to keep them aware of the upcoming changes. • Lead for CCPA compliance for all HomeServe databases. Identifying the necessary fields and creating plans to ensure compliance.• Data Custodian of feeds from more than 20 different systems being ingested into the reporting system, ensuring that the data is loaded and prepared on time. This also includes the replication of data from Salesforce and Heroku into Sql Server databases.• Prepare Low Level Documentation (LLD) for multiple projects. These contained details around the database structure changes, access permission, data models, change scripts and instructions to the ETL developers.• Analyze production systems to ensure data integrity and accuracy of setups as they relate to the data mart applications. Report findings and follow through to verify that the appropriate teams correct such errors.• Manage numerous requests concurrently and strategically, prioritizing when necessary.• Perform summary analysis to predict operations activity for given periods and conduct post-mortem research to explain variances from expected results.• Redesigned a data ingest process to reclaim 10 TB of space in the server, extending the machine viability for another year.

• Provided high-level view of existing systems and established design process for future database development. • Served as single point of contact for users’ data request and troubleshooting.• Developed initial plan to redesign and update infrastructure to make data available to users on a daily basis. • Worked with finance department to clear up processing errors in multiple systems, ensuring end-of-year underwriter reporting was completed accurately and on time.• Reverse-engineered production database, documenting current state, to provide starting point for system redesigns.• Assigned tasks to multiple external vendors, following up to keep each on track and within time constraints. • Led daily meetings with vice presidents and above to provide updates, set priorities and avoid surprises.

As the entire staff of the EDW and BI team, getting the users better data faster. • Design and implement data load strategies for daily financial reporting. Initiated a daily, automated inventory process to track system status.• Evaluated multiple BI tools, selecting Tableau, training users and serving as the server administrator.• Monitor daily data loads, troubleshoot any issues, design and implement data cleansing, create and maintain the customer access layer, provide user support.• Create data standards for the Financial Services team that will eventually propagate to the enterprise.• Take prototypes and develop performant solutions using Oracle stored procedures to replace layer upon layer of views. Build proof of concepts to illustrate alternate options.• Introduce tools such as PL/Sql developer (Oracle development IDE), Talend (ELT) and Subversion (source control) to the team. Data loads reduced from hours or days to minutes• Mentor junior developers to build up their skill sets

Lead multi-disciplinary project teams, Create and implement Teradata data warehouse models, logical and physical, to support tracking of loan and income within Capital finance, including design and hands on development. • Assumed responsibility for 13 additional projects from other divisions as departments are combined. Quickly learned their existing processes, the projects goals and objectives so that differing standards could be merged.• Developed the Version Control/continuous integration process proof of concept for the BI department using SVN, Jarvis and Udeploy • Team lead for custom Java application used to standardize ETL specifications, working with both on and off shore reports• Team Lead for project that linked the Oracle GL details to Hyperion aggregated data, using Teradata and Oracle to supply data to a Spotfire report, saving the finance department 1 person year of effort annually• Technical developer on implementation of Informatica Metadata Manager, interfacing with Teradata, Oracle, Informatica, and custom ETL scripts.• Lead Architect on General Ledger simplification project and the inclusion of Hyperion data extracts into the core reporting database• Member of the initial Big Data Proof of Concept team using Pivotal HD in charge of configuring and testing connectivity to the existing reporting tools OBIEE, Qlikview, Business Objects and the interface to Informatica Metadata Manager • Gate keeper for changes to all BI databases: reviewing architectural changes to the logical models, performing the conversion to the physical model and creation of the DDL sql scripts• ER/Studio Repository Administrator, creating user accounts, setting permissions and troubleshooting. Trained development data architects on ER/Studio: model validation, documentation standards, reverse engineering existing databases• Design semantic layer reporting views for use with Business Objects, QlikView, Spotfire and OBIEE reporting tools

Maintained responsibilities for architectural design and development of Oracle 11i database instance. Performed data-profiling activities, including documenting current state of databases and gathering performance metrics on code base. Redesigned existing 18-hour daily process to reduce duration down to six hours, allowing application to scale to more than double the number of records processed. Automated and instrumented existing processes, freeing up developers who previously had to manually interact with application at every step. Evaluated and recommended for purchase data modeling, development and ELT tools (Talend).

Assumed responsibilities for architectural design, redesign and administration of existing SQL Server 2000 and 2005 databases. Established database standards and worked to convert and migrate existing databases from all environments to SQL Server 2008. Performed data-profiling activities, including reverse engineering existing databases to capture current state. Identified unused database objects and redundant data for eventual elimination in role of capacity planner. Created and implemented indexing strategies for tables in VLDBs to improve overall system performance. Reviewed existing code base for redesign to increase performance and manageability.

First member of the Data Architect team at MultiPlan, a healthcare insurance claim discounter and PPO organization. Starting from a business specification, responsible for the design and implementation of the new Customer Management application database. This application is also the first in the company to utilize a Service Oriented Architecture (SOA). Established, implemented and enforced naming and design standards as well as change management procedures. Developed presentations for staff and senior management. Evaluated and acquired Embarcadero’s ER/Studio and its repository for MultiPlan and trained staff on its use. Multiple database redesign projects requiring conceptual, logical and physical models Complete redesign of reporting database for more efficient results. Design and creation of data warehouse to support new reports and allow users to execute ad-hoc queries. Created XML schema definitions (.xsd files) to be used with web services.

Named lead Oracle developer and data modeler on project to convert all applications to VB.net front end. Worked with data architects and database administrators to establish and enforce design and coding standards. Designed back-end Oracle architecture to support conversion using ER/Studio. Developed Oracle stored procedures and functions utilized by VB objects and front-end processes. Directed and mentored junior staff and contractors. Performance-tuned SQL and PL/SQL stored procedures using trace files and advanced performance tools. Focused on tools used to schedule resources and programs selected for digitally recording, using XML, Oracle Advanced Queues and Oracle forms developed in-house.

Senior Oracle developer at this family owned phone company on Hilton Head Island. I wrote provisioning software to add new clients to the system which involved interfacing with the existing telephone switches over IP and even via modem. I rapidly became the Go To person for Oracle performance troubleshooting, both in back end processes and Oracle forms.

Member of the migration and conversion team, duties included: • Prepared for the changeover to SCT Banner, an Oracle based system on a UNIX platform. • (Migrating data from the legacy system, documentation of the processes utilized, evaluation of client needs and wants, training on the new system). Successfully migrated the Alumni data into the new Oracle based system. • Developed and maintained database programs on the Informix system installed on a UNIX platform.• Created and performed troubleshooting for Crystal Reports for the current Oracle based accounting system. • Completed Crystal Reports training, Introduction and Advanced, and other on-site Oracle training.