Jeff Crooks Email & Phone Number

Atlanta, Georgia, Us

• Drive the performance and value of enterprise-wide data resources as the Technical Lead tasked with executing daily ETL and integration processes, ensuring optimal support for finance, supply chain, marketing, data science, accounting, and executive leadership teams.• Leverage a robust technology stack consisting of dbt, Airbyte, AWS Redshift, RDS, Lambda, DMS, and Google Cloud Platform for support delivery, maintaining a strategic focus on quality and efficiency. • Foster and develop a culture of data excellence by leveraging expertise to mentor and support data consumers in executing best practices and maximizing the value of enterprise data, including facilitating formal trainings on various reporting tools and focused training sessions on specific products and datasets.• Ensure data integrity and quality while architecting and developing the AWS Parquet/Iceberg-based data lake consisting of both relational and non-relational sources.• Enable deeper insights into marketing performance and results by leveraging Segment to create and implement a marketing customer data platform with the ability to develop and manage application and website data tracking plans, build and manage digital advertising campaign audiences, reverse ETL for activation in marketing platforms (Meta, Google Ads, Iterable, etc.), and produce unique customer traits from data warehouse.KEY PROJECTS AND ACHIEVEMENTS• Charted the successful creation, deployment, and ongoing management of the AWS Redshift data warehouse, dbt transformation layer, and Metabase reporting environment, including crafting well-structured and highly efficient architecture, to support enterprise-wide operations.• Played a key role in advancing the goals and objectives of the data organization by crafting and launching a comprehensive 12/24/26-month data strategy and accompanying roadmaps for master data and governance; identified and address data needs and gaps by performing initial maturity assessments.

Atlanta, Georgia, Us

Jersey City, Nj, Us

• Provided dynamic, high-quality leadership to a high-performing, eight-person team consisting of ETL developers, database developers, a QA analyst, and a business analyst, directly contributing to operational and performance excellence.• Strengthened the company’s data practice by performing initial maturity assessments to identify both successes and areas for improvement.• Improved the performance and functionality of accounting applications while delivering application management to support the efficiency of commission/premium payments and reconciliations.• Handled an array of daily data administration tasks, such as supporting internal and external partners by leading ETL and integration process execution.KEY PROJECTS AND ACHIEVEMENTS• Headed data management practice and technologies, including managing architecture development and DOMO software suite deployment to deliver seamless self-service reporting capabilities for 300+ users and producing the 12/24/26-month data strategies with master data/governance roadmaps.

• Pioneered the strategic planning and development of cross-channel marketing performance enhancements for a Fortune 50 telecom client, including advising the 14-person cross-sell analytics team and executives in driving results across inbound call center, digital, direct mail, email, and retail channels.• Facilitated the successful creation of value-added Tableau dashboards and reports by defining robust development guidelines and best practices to strengthen consistency, including delivering a strategic dashboard and establishing monthly KPIs to allow senior leadership to track performance.• Executed the AWS data lake and associated services (S3, Athena, Glue, etc.) on a daily basis, demonstrating strong data aptitude to support data-driven planning.• Prioritized data integrity, quality, and accuracy by performing data extraction, data cleaning, and data transformation within legacy applications and diverse data environments, including, but not limited to, Adobe Analytics, Teradata, Vertica, and Oracle.

Atlanta, Georgia, Us

• Conducted in-depth analysis of current-state technical, data, analytical, and team operations to craft impactful 6/12/36-month roadmaps with the objective of strengthening data and analytics maturity.• Employed knowledge of industry-standard and cutting-edge technologies to improve data capabilities, such as enabling classification and anomaly detection via machine learning models in AzureML.• Accelerated the creation of a high-quality enterprise data warehouse (EDW) by delivering effective and comprehensive leadership to a 12-person team; demonstrated expertise with end-to-end data project management inclusive of data modeling, ETL design and development, report design and development, source control management, and ongoing reporting warehouse and mart support.KEY PROJECTS AND ACHIEVEMENTS• Revamped reporting and analytics operations to strengthen self-service capabilities, leveraging tools such as Microsoft Azure, Power BI, and Azure Analysis to provide a seamless data experience.• Bolstered team performance and data acumen of 200+ staff by spearheading the development and launch of the on-site ‘Data School’ learning program focused on databases, SQL, analysis methodologies and techniques, and statistical analysis best practices.• Served as the Chair of the Data Governance Council responsible for monitoring and communicating progress to key stakeholders, integrating data management processes into enterprise operations, and representing the interests of the executive team by proactively gathering and implementing feedback. • Succeeded in deepening insights, efforts, and solutions related to data quality assurance by defining and implementing key metrics, establishing assessment and reporting best practices, and leveraging ServiceNow and Jira for efficient troubleshooting and Agile tracking.

Atlanta, Georgia, Us

• Facilitated the efficient daily execution of vendor data exchanges, analysis cubes, table/dimension/fact loads, and other SSIS ETL packages, demonstrating success managing 200+ packages total.• Adapted to quickly changing priorities while overseeing and supporting ETL performance tuning and database administration to foster cohesion between development, UAT, and production operations.• Utilized Salesforce to define standardized metrics and processes for data quality assessment, reporting, troubleshooting, and resolution.• Mitigated the risk of variances and strengthened consistency by creating the enterprise-wide business glossary, data dictionary, and end-user/development documentation, ensuring a unified understanding across cross-functional business units.KEY PROJECTS AND ACHIEVEMENTS• Championed the development and integration of a comprehensive enterprise data warehouse (EDW) while directing, mentoring, and supporting a nine-person team; ensured the delivery of capabilities in line with enterprise needs, such as data modeling, ETL, reporting, and more.• Assumed additional responsibilities to accelerate project completion and goal attainment, including chairing the Business Intelligence and Data Governance steering committees; owned accountability for ensuring transparent communication with stakeholders and executive feedback integration.

Savannah, Georgia, Us

- Managed twelve staff performing six quarterly SAP Business ByDesign deployments worth between $320K and $500K for seven North American clients as the Project Manager and Functional Consultant. - Created Enterprise Resource Planning (ERP) implementation scopes to track and record project KPIs, schedules, budgets, and costs versus revenue using SAP Cloud Launch Navigator, GDrive, Dropbox, MS Excel scope planning templates, migration templates, custom reports, and customer legacy data exports. - Ensured project quality, schedule and budget adherence, and safety using the Project Management Body of Knowledge (PMBOK) and Agile management methodologies.- Assigned daily tasks to twelve team members and five external Software Developers and client IT Consultants, including system configuration and testing, data integrity review, data source merging, and ERP system data source loading tasks. - Integrated additional software and implemented custom software development add-ons for SAP ByDesign to enhance existing software functionality and connect to additional 3rd party services including Magento, Marketo, Salesforce, and niche industry applications in coordination with five external Consultants. - Conducted thirty one-on-one initial preparation interviews with key users from each of the seven clients to gather detailed business requirements, review project scope, and define business processes for the new ERP system. - Created and updated the scoping of the ERP system within the SAP ByDesign software using gathered requirements and agreed upon SOWs. - Identified project gaps by reviewing the SAP ByDesign requirements and customer needs analysis documentation.- Created monthly internal profitability reports on productivity, costs, applications for payment, and quality control used by the Director of Services, the VP, the President, and the Director of Finance.

- Managed 75 staff performing a $5MM network and voice asset inventory porting project for Merrill Lynch International. - Maintained 99.6% accuracy for a customer inventory with 50K voice and data asset devices, including switches, routers, servers, PCs, laptops, telephones, alarms, WAPs, PBX, printers, fax, postage meters, and trader turrets across 100 data center sites, regional offices, backup/disaster recovery sites, and trading floors in 46 countries for Merrill Lynch/BoA.- Created and administered monthly project budgets worth between $1MM and $3MM.- Re-forecasted weekly revenue and costs for a $5MM budget in response to schedule adjustments. - Performed qualitative and quantitative project risk analysis on a global and site-by-site basis based on geographic location, type of site, quality of legacy data, and available Technicians.- Developed and maintained T-minus project schedules with up to 100 revisions.- Trained forty new Project Managers, Coordinators, and Analysts and wrote and maintained a 100-page field process guide used by 75 level I, II, and III Field Engineers. - Managed internally subcontracted Field Engineers and coordinated with up to twenty onsite customer vendors including Electricians, Help Desk and Cable Infrastructure Service Technicians, and video conference and trader turret Engineers.

- Led a team of forty Field Technicians performing software quality assurance, black box testing, and laptop system configuration management for a Merrill Lynch Domestic inventory project. - Reviewed between five and ten database deliverables a week for accuracy and consistency from 75 Field Engineers.- Ensured maximum uptime by checking 75 individual machines for compatibility and developing the onboarding process for new Technicians engaged in onsite work to ensure compatibility across a wide range of laptop makes and models. - Oversaw the gathering of device and port level information for all voice and data network assets at customer retail and enterprise locations with up to 5K users and 10K devices.- Resolved between ten and twenty daily remote troubleshooting cases in support of the Service Delivery team. - Validated customer-provided logical data exports before onsite engagement, including CDR data, PBX reports, switch dumps, floor plans, employee lists, and billing data loaded into the proprietary MS Access inventory application.

Us

- Managed voice and data infrastructure and assets at 300 client locations for the largest private Cisco VoIP installation in the world for an IT services company with SMB and Fortune 500 clients.- Trained fifty field Technicians on site surveys, network readiness, and system cutovers.

Us

- Designed 100 VoIP networks for retail banking locations and developed legacy systems transition plans.- Created a test plan used by 500 Voice, Field and Data Engineers nationwide for telecom system testing.

Us

Delivered nationwide training of field engineers in all project phases for the largest Cisco VoIP installation in the world (180,000+ phones)Developed testing plans to ensure system performanceDesigned new Cisco voice networks as well as transition plans for several hundred site locations

Bachelor Of Science - Bs, Computer/Information Technology Administration And Management

Master Of Business Administration - Mba