Senior Data Engineer & BI Architect

TIMOTHY T MAIDEN

**** ******* ******, ************, ** 19136-1024

**************@*****.*** M: 267-***-****

PROFICIENCIES

Databases & Warehouses

Azure SQL; MS SQL Server; Oracle; Teradata; MySQL; Greenplum; IBM: Netezza, DB2

Database Tools

BIDS: SSIS, SSAS, SSRS; Pentaho: Kettle

Business Intelligence

SSRS; Crystal Reports; Tableau; SharePoint; Google Charts AP

JavaScript Libraries & Frameworks

React; Angular; jQuery; Node.js; Prototype; Ext JS

Programming & Scripting Languages

VB; VBA; C++; Python; PHP; JavaScript; Perl; Bash; PowerShell

EMPLOYMENT HISTORY

Managing Partner

04/2023 – CURRENT

ML General Contracting

Philadelphia, PA

Established and Maintained Client Relationships, overseeing Project Timelines, Budgets, and Deliverables, utilizing Strong Organizational and Communication skills honed through Leadership Roles in diverse Technical Environments.

Managed Project Procurement, Subcontractor Negotiations, and Resource Allocation, demonstrating proficiency in Resource Management and Cost Control Strategies acquired from previous roles in Database Development and Business Intelligence.

Implemented quality assurance processes and safety protocols to ensure compliance with industry standards and regulations, drawing on experience in data-driven decision-making and operational efficiency gained from managing complex technical projects.

Sr. Data Engineer (Remote Contract)

04/2022 – 04/2023

GolfNow

Orlando, FL

SME in Optimization, Data Modeling, and Data Platform Architecture. Ensured PCI, Compliance, and Security Standards compliance, providing on-call Production Support.

Designed and Managed High-Performance Data Pipelines. Integrated Data Systems across platforms via SQL, Message Queues, and APIs (SOAP, REST), executing ETL/ELT Functions for Data Cleansing, Quality Inspection, and Transformation.

Developed and optimized PL/SQL Scripts for Azure Data Lake and SQL Databases, enhancing Application Functionality and Performance. Ensured robust, scalable data solutions meeting business needs.

Sr. PL/SQL Developer (Remote Contract)

09/2021 – 12/2022

PayQuicker

Rochester, NY

Modeled an Enterprise-Class Schema, including Tables, Views, Stored Procedures, and Functions for new market products and features, ensuring efficient and scalable database design.

Identified and resolved Performance Issues in an Enterprise Data Persistence environment, enhancing data retrieval speeds and overall system efficiency.

Led Cloud Migration projects to Azure SQL Database as a Service, ensuring seamless data transition, minimal downtime, and optimized cloud-based database performance.

Sr. PL/SQL Developer (Remote Contract)

01/2021 – 07/2021

HarperCollins Publishers

Monmouth Junction, NJ

Analyzed Clickstream Data from Omniture and Google Analytics to create APIs using Google BigQuery. Developed, analyzed, and optimized PL/SQL Programs to support Data Warehousing and Analysis in collaboration with Business Analysts, Software Developers, and PMO Partners. Executed and resolved Data Migration Plans, administered Data Management procedures, and supported daily operational production issues.

Created, debugged, and optimized PL/SQL Queries, Views, Functions, Triggers, and Stored Procedures, coordinating closely with Software Development teams to ensure optimal database performance and functionality.

Developed automated C# Scripts for ETL processes, integrating RESTful APIs created in Node.js with and without SSIS. Managed production issues remotely outside of normal business hours, including evenings and weekends, to ensure seamless operations.

Sr. PL/SQL Business Intelligence Lead Developer (Onsite Permanent)

01/2020 – 03/2020

Arc Home LLC

Mt. Laurel, NJ

Developed a Business Intelligence Data Warehouse for Power BI, creating data visualizations, and maintaining dashboards. Utilized PL/SQL Queries, Reports, Stored Procedures, and ETL Processes to centralize Client, Customer, Salesforce.com, and Vendor data.

Created, maintained, and migrated Enterprise Data Dictionary, BI Dashboards, and SSRS Reports to Power BI. Modeled, developed, and created ETL packages to populate PL/SQL Data Warehouse using SSIS, incorporating event handlers and error handling for robust data processing.

Supported the development team in creating and integrating PL/SQL Scripts within reporting projects. Established change management, source control, and standard methodologies for programming and documentation to ensure consistency and quality.

Sr. Technical Analyst (Onsite Consultant)

05/2017 - 01/2019

Comcast Cable: Corporate Office, Xfinity Home Division

Philadelphia, PA

Supported the Reporting and Business Intelligence Team and collaborated with Subject Matter Experts to create and maintain Teradata Databases, SSRS and Tableau Reports, and code for business end users. Ensured technical solutions were scalable and easily adaptable to change.

Analyzed current databases and reporting logic to optimize data delivery processes and reduce code toxicity. Created and executed high-level test plans for technical changes to reports and databases, ensuring robust and reliable solutions.

Provided comprehensive estimates that considered requirements, development, testing, and implementation efforts. Ensured adequate controls were in place for all processes created, maintaining high standards of data integrity and compliance.

Business Intelligence Executive (Onsite Consultant)

07/2015 - 05/2017

Ashfield Healthcare: Commercial & Medical Services

Ivyland, PA

Spearheaded development of Business Intelligence Dashboards, SharePoint, and Data Warehouses for commercial and medical healthcare sectors. Consolidated client, customer, and vendor data into a DW, accessible via HUB, SSRS, and Veeva’s CRM on iPads.

Implemented Visual Studio 2012 Team Foundation Server for SSRS Reports and SSIS Packages. Revamped version control and set development standards. Deployed DDL triggers and audit tables for SQL Server 2012 development and staging.

Migrated Pentaho ETL packages to SSIS 2012. Automated dashboard content, reporting, and analytics with SSIS packages. Crafted a jQuery/MetroJS/Google Charts API frontend for intuitive dashboard experience. Developed stored procedures for SSRS Reports, auditing, error handling, and logging.

Sr. Technical Consultant (Onsite Permanent)

03/2012 - 07/2015

HighPoint Solutions

East Norriton, PA

Created a multithreaded SSIS ETL package automating consolidation of 5 million nightly transactions from 27 diverse sources into an Operational Data Store. Implemented robust error handling, logging, data validation, and failover mechanisms.

Managed SSAS Cubes and Greenplum MPP Data Warehouse hosting terabytes of data. Developed efficient SSIS ETL packages for Slowly Changing Dimension Types 2 and 6, incorporating advanced transforms and VB.NET script components.

Implemented change history log triggers for DDL changes, automated index management, and advanced string handling stored procedures. Optimized queries, SSIS packages, and indexing using Index Tuning Advisor and architectural modifications.

Business Intelligence Architect (Onsite Consultant)

09/2010 - 03/2012

Comcast Cable: Northeastern Regional Office, Engineering Department

Oaks, PA

Collaborated directly with the Engineering Department to design and develop data warehouses for efficient bandwidth management from multiple systems and sources. Ensured compatibility with various reporting tools and formats.

Developed SSIS ETL packages to seamlessly handle incoming and outgoing PGP encrypted CSV, Excel, and XML files, ensuring data security and integrity throughout the transfer process.

Designed stored procedures, tables, views, and functions to optimize database performance and accuracy. Migrated pre-existing Access and SQL 2000 databases, along with Data Transformation Services (DTS) packages, to SQL 2005 for improved functionality and compatibility.

Sr. PL/SQL Developer (Onsite Consultant)

02/2010 - 08/2010

Accolade LLC

Plymouth Meeting, PA

Developed and modified existing ETL processes and PL/SQL queries utilized by internal analytic software and SSRS, ensuring seamless data integration and accuracy in production and reporting environments.

Created an Operational Data Store to warehouse reporting tables and Microsoft Dynamics CRM data for reporting, exporting, and archiving purposes. This initiative relieved stress on production servers and databases, optimizing performance.

Developed import SSIS packages into the Data Warehouse for statistical modeling, reporting, and analytics, automating XML, Excel, and CSV file exports for outbound data delivery. Tailored solutions to client formatting preferences and standards, enhancing client satisfaction. Additionally, provided technical specifications to MS CRM 4.0 developers for backend and frontend SQL development, fostering work efficiency and data accuracy.

Business Intelligence Development Analyst (Onsite Consultant)

09/2009 – 02/2010

Endo Pharmaceuticals

Chadds Ford, PA

Designed a Business Objects reporting solution for clinical trials data consolidation into a data warehouse. Simplified data access and analysis through multiple Business Objects universes.

Created a Visual Studio 2008 VB.Net Windows application for efficient handling of backend Netezza data using ADO 2.0. Implemented complex queries for data manipulation, ensuring accuracy and integrity.

Developed ETL stored procedures using KIMBALL Star Schema for VB.Net data warehouse population. Optimized data loading procedures in collaboration with Netezza DBA, including SSIS package modifications, bulk data imports, and SharePoint integration. Delivered parameter-driven SSRS reports for the Marketing & Research Department, meeting pharmaceutical business needs.

Sr. PL/SQL Developer & Business Objects Lead (Onsite Consultant)

04/2009 – 08/2009

PMA

Newark, DE

Developed a comprehensive data warehouse, Business Objects universes, and reports for the Production, Retail, Distribution, and Marketing Departments within the Fruit, Vegetable, Floral, and Food Service Industry. Facilitated data-driven decision-making and improved operational efficiency across multiple business sectors.

Coordinated, managed, and maintained the integrity of the existing data warehouse, including multiple SQL 2005 databases. Ensured data accuracy, consistency, and availability for various departmental needs, contributing to smoother operations and informed decision-making processes.

Created stored procedures and SSIS ETL packages to collect and manipulate data from spreadsheets and SQL Server data sources. Implemented efficient data extraction, transformation, and loading processes, optimizing data flow and enhancing overall system performance.

SharePoint & Business Intelligence Developer (Onsite Consultant)

10/2008 - 01/2009

SEI Investments

Oaks, PA

Developed a custom Business Intelligence dashboard and reports using Xcelsius 2008, Tableau 5.0, and SharePoint, tailored specifically for the Hedge Fund sector. Leveraged JavaScript frameworks to enhance dashboard functionality and user experience.

Implemented a Business Intelligence dashboard using MOSS 2007 (Microsoft Office SharePoint Server) to generate summary results based on user views and role membership. This initiative provided stakeholders with actionable insights into key performance indicators.

Created drill-down, auditable, mixed data, and formula reports for Hedge Fund operation teams using Xcelsius, Tableau, and SSRS (SQL Server Reporting Services). These reports facilitated efficient management of billions of dollars in revenue, enabling informed decision-making and strategic planning.

PL/SQL Server Business Intelligence Developer (Onsite Consultant)

07/2007 - 09/2008

GlobalFit

Philadelphia, PA

Spearheaded analysis, design, and deployment of internal SharePoint websites and dashboard reporting. Translated leadership, project management, finance, marketing, and HR requirements into detailed design specs. Ensured seamless integration and functionality aligned with user expectations.

Designed and developed SharePoint portals, team sites, custom web parts, workflows, InfoPath forms, and KPIs, enhancing collaboration and streamlining processes. Provided actionable insights for decision-making through custom lists and dashboards.

Managed development, staging, and production SQL 2005 databases. Ensured optimal performance, reliability, and security. Implemented best practices for data integrity and accessibility, supporting organizational objectives.

Data Warehouse Team Lead (Onsite Permanent)

05/2006 - 07/2007

Comcast Cable

Philadelphia, PA

Directed a data development team for Comcast's Delaware Valley Region, overseeing BI report analysis, design, and implementation. Ensured timely, accurate reports servicing 5 million customers met performance standards.

Created stored procedures and SSIS packages for bulk data loading and SSRS processes in MS SQL 2005. Utilized advanced SSRS techniques for complex report creation and data manipulation.

Architected SSIS ETL processes for data transport between warehouses and enterprise apps. Identified and resolved architectural issues, ensuring data integrity, performance, and system stability.

PL/SQL Server Business Intelligence Developer (Onsite Permanent)

04/2005 - 05/2006

GlaxoSmithKline: SB1 Federal Credit Union

Philadelphia, PA

Managed Business Department needs in MS SQL 2000 Server and Crystal Reporting Environment. Oversaw installation, configuration, security, and query development for optimal performance.

Established ODS and staging environment for data integration from MS Access, DB2, and ERP apps. Improved data quality and flow for downstream reporting and analytics.

Designed and implemented a data warehouse for Crystal Enterprise analysis and financial reporting. Developed DTS packages for ETL, ensuring data accuracy across multiple sources. Produced planned and ad-hoc financial reports with Crystal Reports, aiding ongoing analytical support.

EDUCATION

Associate Degree in Computer Science

11/2003 – 04/2005

CHI Institute

Southampton, PA

Contact this candidate