Pete Fuller

Pete Fuller Email and Phone Number

Senior Data Engineer, Architect, Developer @
Pete Fuller's Location
United States, United States
Pete Fuller's Contact Details
About Pete Fuller

My experience is wide and varied over many years and has tempered me into a reliable architect/developer. I have been a part of successful projects and part of teams that have turned around failing projects. My spirit for team-work has fit nicely with both large and small projects and with colleagues of all skill levels. With a seasoned track record my patient and thorough approach to software architecture and development produces an optimal application while using minimal resources.Specialties: Synapse Analytics, Azure Databricks, Power BI Premium, Azure Fabric, Sql Server BI and Database development, Data Integration and Data AnalyticsETL and ELTSnowflakePythonAzure Data Factory.

Pete Fuller's Current Company Details
Senior Data Engineer/Architect

Senior Data Engineer/Architect

Senior Data Engineer, Architect, Developer
Pete Fuller Work Experience Details
  • Senior Data Engineer/Architect
    Senior Data Developer/Engineer/Architect
    Senior Data Engineer/Architect Jan 1992 - Present
  • Unilever
    Senior Business Intelligence Developer
    Unilever Nov 2022 - Apr 2023
    Blackfriars, London, Gb
    Unilever wished to create a new Collaborative Manufacturing Portal, Vital Signs, with cross functional visualizations that included Weekly Inventory, Aged Inventory, Weekly Production, Production Demand, Quality Control, Vendor Compliance, SLOB, and MSTN. Data was sourced from SAP, Aravo, and SharePoint.Data engineering was performed with Databricks. All sources were ETL to Azure Data Lake Gen2. The multi-dimensional warehouse was stored in CSV files in ADLS. Automation was performed using ADF and Logic Apps.
  • Fortress Information Security
    Senior Data Developer/Engineer/Architect
    Fortress Information Security May 2020 - Feb 2023
    Orlando, Florida, Us
    Fortress is a leader in the emerging Security Information Space. Fortress offers the Asset to Vendor Marketplace where businesses can share private security information on companies throughout the world.• Architected Warehouse for Asset 2 Vendor Marketplace using Kimball Methodology.• Developed all Postgresql Warehouse procs and functions for data pipeline.• Developed Python service layer for loading proprietary security information into a data warehouse.
  • Lids Sports Group
    Senior Data Developer/Engineer/Architect
    Lids Sports Group Jun 2019 - Jan 2023
    Indianapolis, Indiana, Us
    LIDS is a retailer of sports hats and apparel that has line of business apps developedwith on premise technologies. LIDS requires the on-premises business apps be ported over to Azure services.
  • Microsoft
    Senior Data Developer/Engineer
    Microsoft May 2021 - Oct 2022
    Redmond, Washington, Us
    Microsoft required a new analytics tool for sales and compensation for internal use. The solution comprised of the following:1. ADLS Gen 2 data lake2. Azure Databricks data pipelines3. Synapse views for parquet files4. Tabular ModelDaily tasks include:1. Develop pipelines in Azure Databricks using SQL and SCALA.2. Develop tabular model using the tool, Tabular Editor.3. Perform very detailed and complicated data analysis and data validation.4. Assist business with using data feed produced by Azure Databricks.
  • Timepayment
    Senior Sql Developer
    Timepayment Jan 2022 - Jun 2022
    Burlington, Massachusetts, Us
    Senior level sq developer on small team involved in all aspects of software development. Time payment was in the final sprints of multi year conversion and required seasoned expert level sql developer to complete complicated data deliverables.
  • Medcost
    Senior Data Developer/Engineer
    Medcost Jun 2019 - Apr 2022
    Winston-Salem, Nc, Us
    Medcost is an integrated health benefits solution company that requires extensive data integration and pipelines to be developed to many 3rd party healthcare platforms.
  • Kar Auction Services, Inc
    Senior Sql Server Developer
    Kar Auction Services, Inc May 2019 - Dec 2019
    Carmel, In, Us
    KAR is a Global Remarketer of Vehicles using both Physical Auctions and Virtual Auctions. A foundational internal business app is AuctionTrac. AucionTrac services the Physical Auction. AuctionTrac, like its name suggests, tracks a vehicle from Vehicle Checkin to Vehicle Sold. KAR required skills in the following areas for product enhancement: • Tsql development • Amazon RDS Administration • Amazon Lambda development • NodeJS development • Python development • Sql Server SSAS – Tabular development • Sql Server Relational db Performance Tuning
  • Indiana Farm Bureau Insurance
    Senior Data Warehouse Developer/Architect
    Indiana Farm Bureau Insurance Jul 2018 - Apr 2019
    Indianapolis, In, Us
    Indiana Farm Bureau desired to implement SSAS Tabular Model to measure Corporate Sales Goals and provide insights for Strategic Growth Plans. The solution had the following requirements:• Data solution will allow flexible and evolving business requirements.• New business analytics will be introduced and exhaustive validation required.• The data pipeline will maintain data consistency to ensure accurate analytics.• The Tabular Model will be analyzed for accuracy by comparing the current period against historical trends.The source data had the following qualities • Missing data in critical data columns • Incorrect active and inactive dates • Data gaps for certain time periodsThe solution architecture comprised the following• Solution automation implemented with SQL Agent Jobs will be self-healing.• Data Mart consists of Factless Fact, Type 1 and Type 2 dimensions.• Tabular Model is processed in Staging Environment, Validated for accuracy, and Synchronized to Production.• PowerBI reports will be published to Powerbi.com and On-Prem Gateway will be implemented.Roles Performed• Solution Architect• Solution Designer• Data Analyst• Senior DeveloperTechnical Skills Provided• Senior T-Sql Developer• Senior SSIS Developer• Senior DAX Developer• PowerBI developer
  • Fusion Alliance
    Data Consultant
    Fusion Alliance Aug 2015 - Aug 2018
    Carmel, Indiana, Us
    Providing all things for BI, Integration, and Data.
  • Lids Sports Group
    Senior Data Developer/Engineer
    Lids Sports Group Aug 2015 - Aug 2018
    Indianapolis, Indiana, Us
    LIDS desired to implement JDA Allocation and Planning for Retailers for product allocation and planning. The project had a very aggressive schedule and required a seasoned expert in Sql Server Database solutions.Roles Performed• Business Analyst• Data Analyst• Senior Developer• User Acceptance Test Case Developer Technical Skills• Senior Tsql Developer• Senior SSIS Developer• Advanced Integration Patterns• Data Quality PatternsLIDS has experienced rapid growth and now desires to migrate their extensive data and analytics solutions to the latest Microsoft technologies. The LIDS solutions include SSIS, SSRS, SSAS, and MSSQL.* Migrate SQL Server 2000 solutions to SQL Server 2012 and 2014.* Design new Sql Server solutions for business problems while working with the business sponsors and subject matter experts.* Tune, enhance, and optimize existing SQL Server solutions as part of an improved scalability initiative.* Improve development processes to better comply with the Agile Manifesto.
  • Deg Digital
    Sfmc Engineer
    Deg Digital Mar 2016 - Jun 2017
    Overland Park, Ks, Us
  • Digital Fusion, Llc
    Lead Technical Architect
    Digital Fusion, Llc Jun 2016 - Mar 2017
    Digital Fusion LLC is a platinum level partner for Salesforce Marketing Cloud. They required staff augmentation for some large projects.I performed the following Functional Roles:1. Salesforce Engineer2. Business Analyst3. Salesforce Solution Architect4. Technical Sales Support, Estimation and SOW support.I provided solutions in with the following technologies:1. Email Studio2. Mobile Connect3. Automation Studio4. Journey Builder5. Mobile Push
  • Williams Comfort Air, Inc.
    Data Consultant
    Williams Comfort Air, Inc. Apr 2015 - Sep 2015
    Provided integration services.
  • Cummins Inc.
    Senior Data Warehouse Developer/Engineer/Architect
    Cummins Inc. May 2014 - Jul 2015
    Columbus, Indiana, Us
    Cummins New and Recon Parts has been using OBIEE for business analysis. In order to be more responsive to the engine parts market NRP is replacing Oracle OBIEE with Microsoft BI. Sql Server 2012 SSIS packages are extracting parts and sales data from global manufacturing and distribution centers, transforming the staged data with proprietary business rules and processing SSSA 2012 tabular databases. SSAS tabular databases are refreshed daily allowing business users to take advantage of the global cost and order management systems data.* Architect Kimball Datamart for MSBI solution for global Oracle ERP implementation.* Migrate business logic from OBIEE to Sql Server.* Migrate Essbase cubes to SSAS 2012 tabular db.* Develop SSIS 2012 packages to build data marts.* Develop SSAS 2012 tabular models.* Develop versioned controlled databases using Visual Studio database projects.* Deployed *.dacpac, *.ispac, and *.asdatabase using deployment wizards.* Used versioned controlled development practices for databases, SSIS packages and SSAS tabular models with TFS.* Worked in Agile environment with scheduled releases.
  • Allegient, Llc
    Data Consultant
    Allegient, Llc May 2014 - Jul 2015
    Indianapolis, In, Us
    All things Data.
  • Defender Direct
    Senior Data Developer
    Defender Direct Aug 2013 - May 2015
    Indianapolis, In, Us
    Defender Direct is a sales agency for ADT Security.Defender Direct decided to expand into the HVAC industry in surrounding markets and required a consultant to help with Business Intelligence using SSIS. SSAS. SSRS, SQL database development, and integration with Salesforce Marketing Cloud (ExactTarget). * Scripted TSql scripts to transform data from different HVAC business management software to Defender Direct business management software. * Developed SSAS 2012 olap model for HVAC surveys. * Developed WCF services to connect 3rd party lead and prospect generation to ExactTarget API. * Developed SSIS 2012 packages for automated ETL between the different business units within Defender Direct.
  • Contact Solutions
    Senior Data Developer/Engineer
    Contact Solutions May 2013 - Mar 2014
    Contact Solutions, an IVR software company, is developing a business intelligence solution. Contact Solutions’ SAAS-based software routes millions of calls for its customers each day. Tasks included building a Kimball data warehouse, OLAP and tabular models (data cubes), and reports using Microsoft SQL Server 2012 to provide real-time access to the information needed to enhance their offerings and grow their business. As a result, Contact Solutions now has real-time access to hundreds of gigabytes of data enabling them to enhance their system, improve caller experience, and implement efficiencies that result in bottom-line savings.* Scripted DML and DDL for data warehouse * Architected, designed, and developed solution for automatically for maintaining eBI product. * Developed SSIS 2012 packages for data warehouse. * Developed SSAS 2012 MD models and Tabular models * Developed SSIS 2012 packages for processing ssas models * Developed SSRS 2012 reports accessing data warehouse, olap model, and transaction tables.
  • Simon Property Group
    Senior Application Developer
    Simon Property Group May 2011 - May 2013
    Indianapolis, In, Us
    Simon brought all digital marketing in house in 2011 and created a new department that would perform all duties for application development. The primary focus being mobile and a new social website and integration of the Salesforce Marketing Cloud (ExactTarget).• Co-developer of all new Simon.com consumber website. Primary responsibilities were interactive forms, Salesforce Marketing Cloud (ExactTarget) integration, website globalization, website cms for mall managers and other product owners, search functionality and display, Google Map integration, website localization. Please browse www.simon.com. • On simon.com Javascript and jQuery were validated across all ie browsers, chrome, firefox and safari. jQuery 1.7.2 with many plugins provide an interactive user experience. Custom Google maps were generated using Google API and javascript. Telerik WebUI controls were implemented along with ScriptManager. Page load and user experience were optimized by loading javascript last. Javascript ajax calls were made with JSON.• Developed and maintained internal mall mapping system solely based on (css, html, and javascript). Advanced Javascript patterns were used like passing functions as objects.• Co-developer of Simon Malls Android app. Primary responsibilities were social integration with included Facebook, Twitter, and foursquare, gift card balance checking and xTify message pushing. Please download Simon Malls app from Google Play Store.• Technologies used were Javascript, MVC3, jQuery, Sql Server 2008, Web Forms, CSS, Android, Java, C#, Facebook API, Google Maps API, Twitter API, foursquare API.
  • Exacttarget
    Senior Software Engineer
    Exacttarget Jul 2009 - May 2011
    Indianapolis, In, Us
    The ExactTarget (ET) email marketing SAAS is like no other application when it comes to data. With over 130TB of on demand data and growing at a rate of 7TB per month, all application development skills are challenged and put to new level of competency and proficiency.Developed extensive and robust SSIS ETL for all users of the SAAS platform and for internal and external cubes used by customers and support services. All code behind and customization was done in VB.net.• Developed sophisticated event handling in C# for the custom .Net application that runs the SSIS packages.• Developed user friendly web UI using ComponentArt (javascript) components and ASP.Net.• Developed SSAS KPI and cubes based on SSIS package execution data tables. In other words, the custom application managed the running of SSIS packages amount 12 middle-tier servers and the cubes provided valuable information regarding these servers performance.• Developed sophisticated helper components and console applications in C# to enhance the SSIS toolkit.• Developed robust SSIS ETL package to interface SQL Server and Netezza. All code behind and customization was done in VB.net• Proficient with all versions of .Net and all versions of C#. In the process of learning .Net 4 and C# 4.
  • 360Rugs.Com
    Senior Web Developer/Architect
    360Rugs.Com Nov 2008 - Apr 2010
    360Rugs is an ecommerce site for area rugs. Please browse the site.• Gathered all requirements and planned development, deliverables and site deployment.• Developed web site using C#, webforms, web controls and master pages and entity framework.• Developed database using SQL Server 2008.• Used Object Oriented Design Architecture for web site design and architecture.• Extensive use of asp.net 2.0 web controls for shopping cart, search engine and CRM.• Used of Membership Provider classes for site authentication and authorization.• Exercised CSS technology so site would properly render in IE6 and 7, Firefox, Safari, and Chrome.• Created interface to Chase Payment Tech for credit card processing.• Created Excel 2007 spreadsheet with code behind to manage product descriptions and pricing.
  • Entermarket
    Senior Data Developer/Engineer/Architect
    Entermarket Jun 2008 - Jul 2009
    Us
    Entermarket is a regional fulfillment company that specializes in providing business intelligence to their customers. Along with ASAP providing inventory and performance reports, the solution also provides scrubbed data for ad-hoc analysis in Excel and Access. The current fulfillment solution is based on SQL Server 2005 database engine, SSIS 2005, and Crystal Reports XI. • Developed configurable SSIS packages that scrub and transform SQL data into Access files and transport to client FTP site.• Developed complex views from normalized data tables for export to text files for analysis in Excel.• Developed stored procedures and SSIS packages that scrubbed transaction data for data warehouse.• Developed inventory and performance reports using Crystal Reports XI.• Developed efficient queries based on existing indexes and tuned database with additional indexes.• Developed ETL protocol for transferring returned orders to customer site while archiving previous extractions on Entermarket servers.• Worked extensively with production personal to scrub transaction data for data warehouse and provide meaningful reports.
  • Author Solutions, Inc.
    Biztalk Developer
    Author Solutions, Inc. Nov 2008 - Jun 2009
    Bloomington, In, Us
    Gemini is an enterprise service bus based on BizTalk 2006 R2 that facilitates an enterprise-level business application for the self-publishing industry. Gemini connects SalesForce.com CRM framework, Commerce Server 2007, asp.net web sites, SQL Server 2008 data stores, and many vendors who use different types of EDI. * Developed orchestrations handling complex business processes using best practice messaging patterns. * Developed Business Rules for submitting book manuscript and cover to printer. * Worked with software architect in designing applications according to best practice software design patterns. * Developed patterns to work with SalesForce.com * Taught team members BizTalk architecture, BizTalk best practices, BizTalk development skills for maps and orchestrations, BizTalk deployment and application upgrade paths. * Developed web services and windows services for the ESB. * Worked in SCRUM environment with Kanban work management system.
  • Pelco By Schneider Electric
    Senior Data Developer
    Pelco By Schneider Electric Mar 2008 - Oct 2008
    Fresno, California, Us
    Black Jack is the code name for a new access control web application with a reporting portal solution. The reporting portal that is built on Microsoft Sql Server Reporting Services 2005, Sql Server 2005, and Asp.Net 3.0 with porting to Sql Server 2008 in development.• Developed reporting portal web application using Microsoft Reporting Services 2005 and 2008, Sql Server 2005 and 2008, and Asp.Net 3.0.• Developed web application, WCF services, and reporting portal for internal design reference.Authored reports using SQL Server 2005 and Sql Server 2008.• Designed Sql Server views for the report data sources.• Developed WCF services to send datasets to Report Viewer control.• Architect for Black Jack reporting portal using Microsoft Reporting Services 2005 and 2008, Sql Server 2005 and 2008, and Asp.Net 3.0.• Authored functional specifications, end user documentation, and report mock ups for entire reporting portal.• Worked exclusively in Windows Server 2008 environment.• Business Analyst for all reporting requirements for access control market.
  • Kirby Risk
    Application Analyst
    Kirby Risk Mar 2005 - Mar 2008
    Indianapolis, Indiana, Us
    KRBI is a corporate initiative to move from an ERP based reactive operation to a business intelligence driven proactive operation. The ERP is built on IBM Universe and Pick basic. The middleware and deliverables are built with Microsoft BizTalk 2006, SQL Server 2005, Portal Server 2003, .Net 1.1, and Reporting Services 2005. * Designed, developed and maintained data warehouse in Sql Server 2000 and Sql Server 2005. * Designed staging database in SQL Server 2005 to ETL the IBM Universe multivalued database using Integration Services 2005. * Developed BizTalk 2006 web services, schemas and maps to receive and send messages to SQL Server 2005. * Developed kron jobs through a Pick basic interface to send soap messages to the BizTalk 2006 exposed web services. * Developed SQL Server procedures and triggers to insert and update data. * Lead architect for solution to move data from Universe into SQL Server 2005 and provide data to business users using Microsoft server products. Worked with Microsoft representatives and seasoned consultants in the proof of concept stages. * Established all design templates for the Pick basic subroutines, BizTalk applications, and SQL Server 2005 procedures. * Lead many sessions with IT staff and business users to flush out the business requirements. Diagrammed structured programming code. * Developed Excel Applications with VSTO 2003 and VBA to validate the data in SQL Server 2005. * Developed Share Point web parts with C#.
  • Ritchie Automation, Inc.
    Product Manager
    Ritchie Automation, Inc. Jul 2002 - Feb 2005
    Us
    Paint Keeper is a commercial ERP package that reads Allen Bradley control hardware to manage and report on a paint application assembly line. Paint Keeper is built on SQL Server 2000, Visual Basic 6, Crystal Reports 8, and RSTools by Rockwell Software. * Designed and developed reporting portal using Crystal Reports 8, Sql Server 2008 and VB6. * Developed extensively with VB6, SQL Server 2000, and Crystal Reports 8. * Established product functions and features. Interviewed line personnel, paint engineers, production managers, and IT administrators for usability, maintainability, performance, and extensibility. * Created version life cycles and upgrade paths while maintaining source code for clients customizations. Additional features were derived from new customizations and research and development and were included with each new project. Software upgrades were considered an additional project because of scope and complexity. * Worked along side hardware controls engineers to synchronize data acquisition with the assembly line limit switches and painting robots. * Managed programming, testing, and deployment. Initially the position was a product manager with one of the responsibilities being the managing of an outside programming firm. Project schedules and change orders forced the development to be brought inside under my direct supervision. The department grew to 10 developers.
  • Conforma Clad
    Senior Data Developer/Engineer/Architect
    Conforma Clad 1997 - 2002
    Us
    Responsible for all aspects of IT that was common in the 90s: App Dev, ERP Customization, Admin, Roll Outs, Security, Licensing, Business Intelligence, Enterprise Service Bus, Integration.
  • Corporate Computer Center, Inc.
    Data Consultant
    Corporate Computer Center, Inc. 1992 - 2002
    I started building 386 clone computers in my garage. With the advent of Windows 95 and Windows NT, I started selling and performing warranty repairs on Compaq desktops, notebooks and servers. ERP packages quickly became the rage in the middle 90s and I implemented a major manufacturing package with customizations. With the rush of the internet, I configured web servers, dns servers, mail gateways and connected many businesses to the internet. Finally I authored and maintained a home grown business intelligence application that propelled a small company into major growth. * Authored extensive customizations to major accounting and manufacturing ERP packages using VBA, Excel, MS Access, and ASP. * Consultant to businesses with a few million to over $500 million in sales. Lead many meetings with management and all skill levels to bring technology to organizations and business processes without any information technology. * Managed major technology projects with new desktops, notebooks, servers, and Microsoft and Novell operating systems. Projects included hardware sales, software installation, network connectivity, and business software configuration. * Implemented computer aided manufacturing projects that included CNC program management software. * Administered many Microsoft and Novell networks. Managed data backup regimens. Coordinated hardware and software obsolescence. * Configured and installed many servers with all Raid types and server landscapes.
  • American Air Filter
    Application Engineer
    American Air Filter Sep 1991 - Sep 1993
    Cramlington, Northumberland, Gb
  • Flsmidth
    Application Engineer
    Flsmidth Jul 1989 - Sep 1991
    Copenhagen, Valby, Dk

Pete Fuller Skills

Microsoft Sql Server Integration Software Development Sql Ssrs Ssis Business Intelligence Visual Studio T Sql Agile Methodologies C# Scrum Etl Business Analysis Database Administration Sql Server Integration Services Exacttarget Sql Server Reporting Services Ssas 2008 Transact Sql Team Management Team Leadership Dax Mdx Agile Application Development Master Data Management Data Quality Data Quality Control Data Quality Assurance Data Governance

Pete Fuller Education Details

  • University Of Massachusetts Amherst
    University Of Massachusetts Amherst
    Manufacturing Engineering

Frequently Asked Questions about Pete Fuller

What company does Pete Fuller work for?

Pete Fuller works for Senior Data Engineer/architect

What is Pete Fuller's role at the current company?

Pete Fuller's current role is Senior Data Engineer, Architect, Developer.

What is Pete Fuller's email address?

Pete Fuller's email address is pf****@****cil.com

What is Pete Fuller's direct phone number?

Pete Fuller's direct phone number is +150249*****

What schools did Pete Fuller attend?

Pete Fuller attended University Of Massachusetts Amherst.

What are some of Pete Fuller's interests?

Pete Fuller has interest in Motorcycling, Boating, Travelling, Rving, Scuba Diving, Swing Dancing, Camping, Bowling.

What skills is Pete Fuller known for?

Pete Fuller has skills like Microsoft Sql Server, Integration, Software Development, Sql, Ssrs, Ssis, Business Intelligence, Visual Studio, T Sql, Agile Methodologies, C#, Scrum.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.