SUMMARY:

• Senior Business Intelligence and Database Project Leader known for producing rapid results and delivering effective answers to challenging technology problems in a wide range of projects.
• Manage and teach data base adminstration, data warehouse, business intelligence, and product development acquired over 30 years of experience. Experienced in delivering project management and operations solutions in financial, insurance, pharmaceutical, manufacturing and service industries, as well as software products for resale.
• BI Development
• Database Administration
• Data Architecture
• DevOps support
• Product development

TECHNICAL SKILLS:

Operating Systems: Databases:Languages: AWSHiveHQL, T - SQL, PL\SQL AzureMS 2017 MS SqlserverPerl 5 ( Tcl /Tk ) Red Hat Enterprise Linux ORACLE RAC 10g / 11g Python 3.7 SYBASE 12 DB2 Java IBM AIX MySQL 5XML, XLST, C/C++/C# SUN Solaris 10 DBMongo Bash, Korn, C shell

Sys. Admin Tools: Data Warehouse: MS Management Studio Azure Synapse Oracle Enterprise Manager Hadoop HIVE Veritas Volume, NetBackup and Database Erwin, Embarcadero Tivoli. Legato, BMC SSIS, SSRS, SSAS, BIDS UniCenter Task Factory vmstat, iostat, perfmon, iPerf Talend / Open Studio Oracle Data Warehouse Builder

Tools: Azure ADF, Synapse, Data Bricks CosmosDB Python pipelines DBeaverAmbariSqoop Oozie\ PigSSIS/SSRS/SSASGoogle Instream Translator TableauMS Power - BIQlik MS Visual Studio 2017\ BIDS HadoopGitHub SourceSafeConfluence / Jira Solarwinds DPA\Ignite Oracle Rac 10/11Data Guard AX Trace Parser ORACLE Enterprise Manager Oracle RAC 10g/11g ORACLE Grid Control Statspack/AWR DynamicsPerfSpotLight Citrix WinFrame, MetaFrameProphix PeopleSoft Accounting / HR

ERP \ Financial: MS Dynamics AX 2009AptosInfor M3 EpicorSAPBPCS SynventiveJDASelectiva ORACLE ManufacturingMS NAV ORACLE Financials 11.5.10 Web application delivery: Oracle AS10gR2 IBM Websphere JBOSS/JRunHadoop Microsoft IIS BEA WeblogicApacheTomcat Years DBA in: Oracle 15, Sqlserver 12, Sybase 6, UDB 2, DB2 4, IMS 4, Snowflake 1

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Data Base Manager

Responsibilities:

• Managing as a coach\player another DBA while streamlining labor intensive administration and SSIS processes. Decoupling a legacy EDW. Building out of new EDW, Data Lake, and business intelligence objects in Snowflake on AWS, redesign and redesign a new eCommerce application to have less manual interventions.
• Using Fivetran, Sql Server HA, SentryOne, Python, Jira, Confluence, MS Teams, Github, Dbeaver, Salesforce

Confidential, Mechanicsburg, PA

Data Engineer

Responsibilities:

• Completed a Objectives and Key Reponsibilities (OKR) project with ETL processes for Microsoft's Ally performance metrics product measuring hospital administrators by private ownership.
• This sourced disparate databases and products for 95 long term, acute care and rehabilitation hospitals and healthcare facilities. The data model has no common primary key except non - unique hospital names, ownership and disparate period end timelines.
• This was accomplished in parallel as part of a 3 member team merging Medhost, Cantata, and Epic EMR systems into a common WellSky medical record system accessing the Health Information Exchange (HIE) via HL7 and FIRE using Sql Server, Pentaho, Azure ADF, Data Bricks, Synapse, CosmosDB, and PowerBI.

Confidential, East Hartford, CT

Hadoop BI Consultant

Responsibilities:

• Big data conversion of Teredata Commercial Data Warehouse SQL using HIVE HQL within the Hadoop ecosystem. Reduced annual reload of 29 years of data from 6 weeks to 26 hours. Built ETL processes using Python, R, Sqoop, Oozie and SSIS.
• Conversion of Aircraft hours and materials report system from Perl, Python and Excel process into Hive HQL and then Sql Server.
• Performed remotely with hybrid office model, use of GitHub and JIRA in Agile development.

Confidential, Bristol, CT

BI Consultant

Responsibilities:

• Built SSIS solutions to load SEC required sales, invoice, marketing and costs data from SAP, Epicor, BPCS, Infor M3, Synventive, JDA, and Selectiva manufacturing ERP systems of 9 foreign subsidiaries into a preexisting in-house data warehouse. These ERP systems lived on AS400, Linux, and MS servers and were directly or had exported files, reports or excel file accessed.
• SSIS solutions were composed of SQL queries, data flow tasks, merge transform, Task
• Factory Upsert and derived column tasks and stored in Subversion source control.
• Data load quality processes were built to find issues with GL detail lines and invoice linkage, base and line currency values, sales back order totals in comparison to manual reports submitted by subsidiaries.
• The warehouse was composed of operational, master, summary, and staging db instances updated by daily Sql Server Agent jobs. Data base administration duties were provided as required.
• Built or modified Tableau workbooks distributed on Sharepoint portal of consolidated sales for domestic and foreign entities.

Confidential, Farmington,CT

Data Engineer Consultant

Responsibilities:

• Implemeted new Cares Act AMS codes and rules to customer enrollment process using MS SSIS, PLSQL, and Javascript. Designed, developed and deployed SSRS reports.

Confidential, Meriden, CT

BI Developer \ Database Administrator

Responsibilities:

• Developed dashboards and scorecards for senior management and companywide consumption in MS Power-BI and use of SSIS data profiling
• Designed, Developed and Deployed reports in SSRS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Maintained, monitored, and developed production data warehouse and SSAS Cube
• Developed data quality processes with Epicor ERP and Store data feeds using business information needs from stake holders and translated into requirements and functional specifications. Evaluated and recommended best form of delivery - SSRS report manager report, Excel spreadsheets, or SSAS Cube
• Implemented Aptos ERP SaaS data integration for Bobs, EMS, and Sport Chalet brands
• SSIS migration of data from Sybase, Oracle, and DB2 legacy databases
• Implemented MS NAV 2015 and Prophix for multi user self service OLAP cubes on MS SSAS
• Performed database administrator duties such as server security, query optimization, storage management, performance tuning, indexing, replication, backups, restores, monitoring production jobs, and being on on-call for Sql Server 2014 thru 2000, MySQL, Sybase, and Oracle
• Troubleshot IT infrastructure projects when system engineers could not solve issues.

Confidential, Middletown,CT

Sr. Database Administrator

Responsibilities:

• Sole Production Administrator for cloud based health insurance clearinghouse.
• Successfully implemented elapsed time based diagnosis and resolution of severe performance issues.
• Successfully implemented Replication from clustered OLTP to OLAP to Sharepoint.
• Successfully implmented SSIS,SSAS in replacement of MS 2000 DTS and .dll ETL methods.
• Realtime edi transaction using IBM Websphere in a SOA architecture implemented using Centurylink private cloud.
• Provided all database support to all developers, operations, edi, and portal teams.

Confidential, Burlington, VT

Sql Server Administrator / ETL Developer

Responsibilities:

• Provided all Sqlserver 2008R2/ Oracle 10i/11g DBA support during implementation and heavy modification to MS Dynamics AX 2009 ERP, Direct Inventory Control/Forecasting, and Data Mart
• Integrator of Inventory, Merchandising and Marketing systems to MS Dynamics AX
• Lead implementation of successful elapsed time methodology to resolve MS Dynamics AX and SQL Server performance problems
• Implemented SSRS, SSIS, TFS, Sql Server Replication and Mirroring
• Implemented Sharepoint 3.0 Administration (WSS 3.0) and ERP and SSRS integration

Confidential, Norwalk, CT

Senior Oracle Database Warehouse Administrator, Operations

Responsibilities:

• Built Data Mart on 2, 3, and 4 node RACs of 2T on RHAT Enterprise Linux, Oracle AS, Oracle Warehouse Builder, BI, ETL, OLAP and Data Integration
• Built 2 node cluster in SQLServer 2008 to support the SalesLogix Customer Management Relations (CMR) database and Dynamics AX content workflow environments.
• Built 4 production Oracle Real Application Cluster ( RAC ) implementations in Oracle 10.2.0.3 and 11g, on Sun V490's using ASM, OEM, OID, SLDC and SAN
• Upgraded Oracle Financials to 11.5.10 from 10.5.2
• Remote migrated production servers from New York City to Norwalk and onto Ft. Worth
• Managed senior DBA during upgrade of 41 databases from 8.1.7 to 10.2 & 11gR2, converting to SAN, implementing OEM and RMAN. Used Enterprise Manager for alerts, monitoring, patching, provisioning and proactive tuning with baselines.
• Resolved performance issues using wait state diagnosis for databases and Java apps
• Implemented replicated MySql databases using phpMyAdmin for Customer Management project using CMS and PHP.

Confidential, Rocky Hill, CT

Consulting Partner, Senior Database Administrator and Project Manager

Responsibilities:

• Reengineered the proprietary product catalog appserver to an inhouse Oracle / Java architecture saving 15% of the company's two year budget.
• Application Development Manager, directed Customer Support projects using Java and Delphi.
• Manager of offshore Oracle database administrator

Confidential, Boston, MA

Sybase and Oracle DBA

Responsibilities:

• Troubleshot issues with the initial configuration and use of PeopleSoft GL and HR. Unraveled extensive and slow SQL processing and cleaned up poor data migrated into PeopleSoft as Oracle DBA.
• Built first Risky Bank Trading system after $20 million loss from bank failed to cover underwater penny stock trade.

Confidential, Farmington, CT

Project Leader, Operations

Responsibilities:

• Managed migration of policy and claims system from Sybase / NT to Sybase / UNIX and implemention of iManage document management system and Oracle databases.
• Troubleshot issues between California insurance firm and the entire technical services staff to ensure successful migration.

Confidential, New York, NY

Operations Project Leader

Responsibilities:

• As sole Unix System Administrator and DBA, solved system hangs, slowdowns, and network problems, reorganized file systems, added new disk drives, memory cards, io cards, tape drives, backup and recoveries, job automation, software upgrades and patches.
• Solved extensive ORACLE system failures, slowdowns, and recovery failures.
• Implemented firm’s first accounting software system for CFO and Treasurer.