Jp Davey Email & Phone Number

Coral Springs, Fl, Us

South Jordan, Ut, Us

* Translate customizable multi-tenant dataset into standardized Analytics solution, enabling self-service capabilities and enhancing customer insights.* Analyze diverse software use cases to devise consolidated reporting solutions, bridging gaps between varied client requirements and unified analytics.* Architect dynamic Databricks PySpark workflow, optimizing refresh priorities and compute cluster allocation across medallion layers for efficient data processing.* Mentor team members, fostering a collaborative environment for innovative data solutions.* Tools used: Databricks, PySpark, Python, Azure, Power BI, SQL, ADF, SSMS.

Coral Springs, Fl, Us

Supervisory position* Mentoring junior and mid-level developers via group and one-on-one sessions* Involved with hiring of consultants and developers* Approve PTO and change management requestsDataOps Engineering, Data Solutions Modernization, and the Modern Data Warehouse:* Leading and facilitating internal and external Data Engineering teams to create and document procedures, standards, and best practices for Azure Synapse SQL Pool, Azure Data Factory, Azure DevOps CI/CD, code review, and repo branching and workflow* Migrating legacy SQL, SSIS, Cognos BI reporting, Azure SQL, Azure Data Factory, Azure Data Lake, Azure Storage, and Azure Databricks solutions into the Modern Data Warehouse (Synapse SQL Pool, Azure Data Factory and Azure Data Lake)Continued responsibilities of Data Engineer role

DataOps Engineering, Data Solutions Modernization, and the Modern Data Warehouse:* Leading the internal Data Engineering team towards adopting Agile and DataOps processes using the Azure DevOps platform to streamline development and deployment of data solutions* Leading bi-weekly training and knowledge sharing sessions with internal team members and external consultants covering DataOps topics and demonstrations* Creating build and release pipelines (CI/CD) using Azure DevOps for data solutions* Developing SQL database and Synapse SQL pool database projects to use with build pipelines and dacpac deployment* Creating ETL/ELT pipelines using Azure Data Factory* Developing PowerShell scripts for digital automation and Azure deployment* Creating complex SQL and PowerShell scripts to automate repetitive tasks and auto-generate data- and metadata-driven SQL, Visual Studio project, and SSAS codeERP Migration Data ETL - Lead Internal Developer/Engineer:* Extract and Transform GL, Payables, and Fixed Asset data from existing ERP system and Load into specific Excel macro-enabled templates provided by the ERP consultants* Worked directly with the Project Management, Accounting, and ERP consultant teams to solution and develop the ETL process* Analyzed ERP data for conformity to the new ERP system's data validations, including transformed data and invalid addresses* Routinely provided cleanup data to the appropriate Accounting team members to be cleansed in the existing ERP system before the final conversion* Used the following tools to perform the ETL and data validation/cleansing: Azure Databricks, Azure Data Lake Gen2, Azure Data Factory, Excel VBA, PowerShell, Power Query, Power BI, SQL DatabaseProof-of-concept Azure Modern Data Warehouse - Internal Solution Architect* Used the following tools to create a PoC solution: Azure Synapse, Azure Databricks, Azure Data Lake Gen2, Azure Data Factory, Azure FunctionsContinued support for existing systems

Modern Data Warehouse PoC* Technical lead, project lead, architect, and developer for the proof-of-concept Azure Modern Data Warehouse project pilot.* Developed policies and standards for naming conventions, data flows, documentation, technologies used, etc.Data Solution for Sensitive Data* Technical lead, architect, and developer for a dimensionally-modeled SQL database, SSAS tabular model, and SSIS ETL project to store and secure sensitive data.* Developed an algorithm for non-destructively de-duping various types of person records into a single record to support person-level reporting previously unavailable.* Worked directly with stakeholders to gather data and row/column-level security requirements.Dashboard and ETL for New Medical Billing Adjustments Application* Power BI and ETL developer for a new home-grown billing adjustment workflow application* Designed and built a fully-functional 6-tab dashboard despite the following challenges: application being designed and built at the same time as the dashboard and ETL, no database or report specifications, very little sample data, data not persisted between application releases, same ETL code had to connect to different environments with different application/database code versions and different sample relational and JSON data/schemas, and different Active Directory domains for prod and non-prod environmentsExisting System Support* Make modifications to Cognos reports and frameworks* Make modifications to SSAS OLAP cubes* Support and create SSIS and stored procedure ETLs* Create SQL scripts to generate operational reports for ETL packages* Create and optimize complex stored procedures* Create PowerShell scripts to pull Active Directory dataTechnologies:Azure SQL Data WarehouseAzure SQL DatabaseAzure Data FactoryAzure Analysis ServicesAzure DatabricksSQL Analysis Services (Tabular and OLAP)SQL DatabaseSQL Integration ServicesPower BIVisual Studio Database ProjectsAzure DevOpsgit

Application Support* Production application support for IBM Cognos, GE GPMS, Financial SQL and SSAS databases, and Financial and RCM ETL process support, among other various business applicationsProduction Control* Back-up for the Production Control Analyst* Conducted Production Control meetings for IT and business department representatives* Created semi-automation tools for updating the Production Control calendar on SharePoint* Created user-friendly Production Control documentation to interpret Change Management policies and procedures into "plain English"

* Production support for 2000+ corporate, divisional, regional, and medical office users of the IBM Cognos BI application* Centralized the monitoring of Cognos servers, ETL processes, scheduling maintenance, and database maintenance* Streamlined and documented both routine and one-off procedures for Cognos and ETL support* Automated routine tasks via SQL, Excel VBA, and PowerShell scripts

Boca Raton, Fl, Us

BI, ETL, and Customizations Development Manager• Meet with customer representatives from C-level executives to end users to gather customer needs and challenges• Translate customer needs and requests into deliverables• Project Management for upgrades, installations, reporting, and Business Intelligence• Advise customers on hardware and software requirements to meet business application and data growth needs• Create Business Intelligence and ETL solutions for clients using SSMS (T-SQL), SSIS, SSRS, Dynamics Integration Manager, Visual Studio (VB.NET and C#), Dynamics eConnect API, Excel, and Access• Perform SQL Server installs, query optimizations, code review, database tuning, and disaster recovery for clients• Perform data analysis, data repair and data cleanup for ETL processes and data corruption incidents• Design SQL and VB scripts and techniques used as standard company procedures for Dynamics GP maintenance, server migration, data repair, and complex reporting, reducing time for tasks from hours to minutes• Create T-SQL coding solutions for clients using views, stored procedures, triggers, and functions• Create company standards for end user and internal technical documentation for visual and step-by-step audiences• Assist hiring new consultants• Supervise and train junior consultants on SQL, VB, Excel, SSRS, ETL, BI, data analysis, UI design, and security• Certifications earned: MCTS: SQL 2008 BI Development & Maintenance, MCTS: SQL 2005 Implementation and Maintenance, MCITP: Dynamics GP Installation and Configuration 10.0

• Responsible for POS software Q/A testing, POS terminal build-out and restaurant database implementation, POS software technical support, internal IT maintenance and support, database setup, and software development• Streamlined existing site terminal preparation process through scripting, reducing setup time from hours to minutes• Developed intranet applications using Classic ASP to reduce menu and database setup time from days to hours• Created POS terminal branding, including a custom screensaver, background, start screen, and program icons• Removed a resource bottleneck by creating a multi-threaded print service for the development department• Relieved the development department from having to maintain separate software builds per customer by creating a dynamic restaurant layout program used for showing tables in use and editing orders• Optimized SQL indexes, reducing report and query times from minutes to seconds• Moved into the development department as a result of all aforementioned development, efficiency, and branding efforts created independently in spare work time

• Primarily responsible for 30 Windows servers across 6 sites• Primarily responsible for Active Directory, Exchange, SQL, IIS, VPN, Anti-Virus, and remote connectivity • Secondary support for 250 Windows desktops • Designed and created intranet applications for network, server, backup, and desktop management• Early adopter of virtual server technology for domain operations, server testing and disaster recovery• Hand-coded all VBScript, HTML, CSS, and JavaScript

• Primarily responsible for 10 Windows servers and 100 Windows desktops• Primarily responsible for Active Directory, Exchange, SQL, IIS, and remote connectivity• Designed and created the organization’s internet and intranet websites, website content management intranet portal, a student and class registration portal including a shopping cart and credit card processing, an ID card and door access intranet portal, and automated network management software using Photoshop, Flash, Classic ASP (VBScript), MS Access, MS SQL, HTML, CSS, JavaScript, and Notepad• Hand-coded all VBScript, HTML, CSS, and JavaScript• Certifications earned: MCSE NT 4.0, MCP+i

• Primarily responsible for 10 Windows servers and 100 Windows desktops• Primarily responsible for Active Directory, Exchange, SQL, IIS, and remote connectivity• Designed and created the organizations internet and intranet websites, web content management intranet portal, a church membership internet portal, server and network alerting, and automated network management software using Photoshop, Flash, Classic ASP (VBScript), MS Access, MS SQL, HTML, CSS, JavaScript, and Notepad• Hand-coded all VBScript, HTML, CSS, and JavaScript

Produced 4-page websites for Web Result Institute's web hosting clients

Boca Raton, Florida, Us

Moved from cashier to stocker to computer sales associateDealt with various customer software and hardware problems

Layed telephone, computer, and camera cable for $4.5 million office and set expansion

Used Macromedia Director, Photoshop and SoundForge to produce and combine graphics, animation, sound and video into a product used for literacy training in the Broward County school system

Created 3D models and animations using Autodesk 3D Studio (DOS) and Autodesk Animator Pro (DOS) for national accounts such as Motorola and National EnquirerSupported the internal network