Peter Mcfarland Email & Phone Number

Centennial, Colorado, United States

Member of Comcast Western Division's Data Solution team building, and maintaining data ingest solutions using Informatica, and Microsoft Visual Studio SSIS packages accessing Oracle, MS SQLServer, and Teradata.

Denver, Colorado, United States

Lead for Rx Spend rehosting, and enhancement project tasked with documenting, and migrating HCA's three Pharmacy Spend SSIS/SQL Server ETL processes to DMExpress/Teradata.

Centennial, Colorado, United States

Member of Comcast's Western Division Solution team migrating Microsoft SQLServer data to Teradata using SSIS packages using ETL Framework hosted on SQLServer 2017. Updated hundreds of SSIS packages from Teradata Fastload to TPT Stream, built new SSIS to TD ETL packages deployed using Comcast ETL framework, fixed a number of failing ETL packages reducing target table record size, and improving run time by 5x, and SQLServer job scheduler, provided operational support for 5k+ SSIS jobs run daily on rotational basis.

A hands-on DW developer with Macy Technology's Customer Call and Credit Center (CCCS) DW team(CCBI) performing: • Data Engineering: Four years of ETL work on Hadoop/Hive cluster using a variety of ETL tools, DMExpress SyncSort, Microsoft SSIS, and Python. Python Job packages utilize RDBMS based metadata, and cleanse PCI data in memory using Spark. Linux and Hadoop scripts set HDFS directories, and access rights. Development process followed a Kanban deployment process under Git source control. • Big Data Mgt: Defined underlying Hive table and associated directory structures, access rights, and table management, e.g., changing storage formats, and/or partitioning strategies.• DB Administration: Tuned user queries for use with Hive/Hadoop, managed access rights, maintained table structures, and underlying Hadoop files.• RDBMS Systems - IBM BigSQL/Hadoop, and MS SQLServer. • SQL Support – Tuned problematic user queries, architected Macy's Call Center Associate Hierarchy, and built Collections SSRS report and its associated SQLServer Stored Procedures.

Omaha, Nebraska, United States

Teradata implementation consultant acting as client’s Teradata Architect interface to Teradata professional services deployment of TAS, Teradata Analytics for SAS EDW Jumpstart project on 67xx EDW system. Analyzed client’s EDW requirements and Teradata sourced HW and SW solution, and reviewed associated project schedule and SOW to help guide customer in oversight, and general EDW implementation support. Validated client requirements, and tool choices per their use cases. Contract ended as TD Professional Services were doing a great job.

Rancho Bernardo, California

Roles varied over my seven years with Teradata initial starting with TD R&D Benchmark center performing benchmarks for sales opportunities, progressing to TD R&D Testing, TD BI/DW Consulting – Performance Tuning, BI Implementation, and finally technical sales role. Teradata knowledge and skills include certifications across multiple versions.Solution Architect Solution Architect/DW Lead providing Teradata pre and post-sales support to its Western and Midwest accounts. Performed as Lead Consultant for Teradata NAD accounts, analyzing customer business and technical requirements, translating them into data warehouse solutions, and professional services SOW. Own resolution of client Teradata production issues, and upgrades. BI/DW Architect A senior resource providing BI implementation services, BI server setup, BOBJ 3.0/XI Universe and report development as well as tuning through review of problematic BOBJ reports and universe design. Conducted Teradata performance tuning and resource recapture engagements. Senior Test/Benchmark Analyst Lead T-CAT Analyst responsible for designing, building, and conducting in-house client-based product testing in support of their planned production environment migration and/or upgrade. Benchmark Analyst performing as a Teradata DBA loading data, archiving and restoring databases, converting and tuning queries, and building scripts to automate benchmark activities such as data explosion, and sequential and stress testing.

Aliso Viejo, California, United States

Implemented and executed prospect defined competitive VLDB multi-terabyte sized database benchmarks on DATAllegro’s MPP appliance. Defined MPP data distribution and partitioning strategies, converted legacy system DDL, bulk loaded client data, converted and tuned user queries and reports. Co-authored and delivered DATAllegro Data Warehouse (DW) Appliance Administrator, and SQL (Postgres SQL) class. DATAllegro was purchased by Microsoft, and it's MPP DW Appliance/DB Engine converted to be MS SQLServer Enterprise Edition.

Denver, Colorado, United States

A member of Brio/Hyperion’s Client Services team for almost seven years, I implemented and tuned Hyperion Performance Suite (HPSu) solutions, e.g., reports, master data models, queries, and pivots visualized through user-oriented dashboards. Services Manager responsible for SOW, and staffing, and successfully delivered 70+ engagements. Hyperion was purchased by Oracle March 2007.

Denver, Colorado, United States

Business Intelligence consultant who helped establish Denver practice through recruiting key associates, and developing Business Objects service relationship that help drive Braun Denver team service revenues while performing hands-on BusinessObjects 6.5 Decision Support consulting.

Denver, Colorado, United States

Preformed BusinessObjects pre/post sales support, and implementation services for Denver office, presenting product overviews, demonstrating product, and providing POCs for clients as well as corporate sponsored road show events. Provided sales technical product support, analyzing client BI needs, developing and presenting requirements based BusinessObjects solutions and driving sales through on-site proof-of-concepts. Provide hands-on SW installs(Desktop/Servers), as well as building BOBJ reports for clients across continental US. Subsequently, western region consulting services manager for three years, developed services revenue, scoped work, negotiated consulting rates and agreements, hired staff, and managed engagement delivery.

Denver, Colorado, United States

Provided technical sales support for Software Artistry’s Help Desk product, Expert Advisor, as well as post-sales software installation, training and product interface customization. Provided implementation consulting, and eventually promoted to Western US Project Manager. Developed a three-person professional services team to deploy Software Artistry’s Client/Server help desk solutions.

Denver, Colorado, United States

A technical presales member of Digital’s district sales team providing presales support to Colorado based government accounts and aerospace companies; Technical account lead for Martin Marietta. Co-author numerous RFPs with notable wins at USDA for one million dollars in equipment and services, and the purchase of several large DEC 780 systems by Air Force Finance and Accounting Center for replacement of IBM based processing. Western Region CASE lead helping significantly boosting SW Case tool sales as Road Show persenter.

Denver, Colorado, United States

Product Consultant - Denver office pre and post sales specialist supporting client use of and training on UCCEL’s time-share services on IBM, CDC, and Unisys equipment, and Prime front-end job creation and management system. Supported client use of systems, wrote scripts to analyst job log output, and managed local branch hardware.DB4 Product Consultant - Instrumental in initial startup efforts to sell UCCEL’s proprietary Relational Database Management Product, DB4 including translating client hierarchical file structures into RDBM database table structures, and product demonstrations.

Aurora, Colorado, United States

DOD - Aerospace Data Facility - Hands-on maintenance of two Real Time Systems programming in assembly language Lead. Also part maintenance team for a large FORTRAN mathematical modeling program hosted on a CDC 176 Cyber system. Completed several major application improvements with responsibility for requirements gathering, change design, coding and associated unit and system level integration testing. Also, provided daily support for real-time systems, debugging system core dumps, application interface errors, documenting issues, resolutions, and proposing and implementing changes.

Waterton, Colorado

US Agency (RainMaker) - A test engineer on system integration test team with responsibility for analyzing system integration test contractual requirements, writing test specification, and setup, execution, and capture of results and any system crash dumps.

Masters Of Computer Information Systems, Computer Software Engineering, 3.95

Activities and Societies: Master's Soccer League, Mountain Biking, and People Farming.Studies focused on Software Engineering related.

Bachelors, Computer Science, 3.27

Activities and Societies: Tennis, biking, and Soccer.My focus was on computer languages, though I also incorporated three and half years.