Alan Rogers

Alan Rogers Email and Phone Number

Data Engineer @ OneMagnify
Detroit, MI, US
Alan Rogers's Location
Detroit Metropolitan Area, United States, United States
Alan Rogers's Contact Details

Alan Rogers personal email

n/a
About Alan Rogers

Data Engineer and Big Data SQL developer experienced in the Hadoop ecosystem as well as Google Cloud Platform, working with automotive customer experience survey data as well as vehicle and loyalty data. Responsible for the ETL of internal and external data sources to create data marts to the specifications of downstream data analytics and business dashboard requirements. Manager of a team of six Data Engineers in the CX Data tech/CX measurement space.Previously - Market Research Information Technology professional with a strong background in data analytics, analysis and reporting. I enjoy working with collaborative teams to brainstorm creative solutions that reach the client’s project goals using the right tools. Leveraging diverse skills, I have worked on and managed projects that range from analyzing market research data to creating elaborate client-ready Excel dashboards and reports using VBA macros.My focus has been designing multi-language web-based surveys using HTML in conjunction with SQL databases, as well as creating SPSS and SAS databases for deep dive analysis. As an experienced HTML multi-language web survey design and implementation manager, I work to ensure a quality product that is delivered on-time and in accordance with ISO quality and security standards.Connecting with the project team to create, manage and improve market research data and analytics for large multi-national companies is my best talent. Delivering results, juggling priorities, managing staff, making deadlines and integrating new tools has been a constant throughout my career.

Alan Rogers's Current Company Details
OneMagnify

Onemagnify

View
Data Engineer
Detroit, MI, US
Employees:
3
Alan Rogers Work Experience Details
  • Onemagnify
    Data Engineer
    Onemagnify
    Detroit, Mi, Us
  • Onemagnify
    Data Engineer
    Onemagnify Sep 2019 - Present
    Detroit, Mi, Us
    Product manager responsible for the design, build and maintenance of Ford customer experience survey Data Marts. Experienced working with Ford internal and external data sources to transform them, via SQL, in the Hadoop ecosystem, to meet customer needs for analytics and dashboards. Currently working on the redesign and migration of data and the SQL transformation code to function in Google Cloud Platform via Terraform, Tekton pipelines and BigQuery. I am also a OneMagnify team leader within the Ford CX Data Tech group, collaborating with a team of six amazing and talented Data Engineers.
  • Ipsos / Rda Group
    Director Of Programming
    Ipsos / Rda Group Feb 2010 - Aug 2019
    Working in conjunction with the project team, I prepare client-ready data deliverables including Excel dashboards and reports using VBA, SQL database Real Time Reporting, SPSS and SAS datasets for many large international clients in the automotive, heavy equipment, utilities, financial and technology industries, including Ford, General Motors, Pacific Gas & Electric, Caterpillar Financial, Bose and Guardian Glass. I work with both client-specific and syndicated research. Highlights of progress and projects include:Expanded Ipsos RDA’s relationship with Caterpillar Financial and their CSI tracking program by adding many international markets and implementing various methodologies including mail, multi-language web surveys, web CATI and phone surveys to capture customer metrics for weekly alerts/concerns processing, as well as client ready SPSS reporting.Reporting manager for customer satisfaction and tracking studies across a wide variety of clients including General Motors, Ford, Pacific Gas & Electric, Bose, Guardian Glass, Panasonic, Kelly Services, Houston School District, Isuzu and Nissan.Instrumental in growing a 10+year relationship with PG&E and their customer satisfaction and feedback research. Provided guidance to other staff in developing and maintaining additional PG&E studies as the relationship developed.Lead programmer on a large international syndicated research study focusing on emerging and future automotive technologies including autonomous and electric vehicles and consumer lifestyle preferences and attitudes towards them.Responsible for the professional development and training of several programmer/analysts.
  • Rda Group
    Senior Programmer / Analyst
    Rda Group Jan 1998 - Feb 2010
    Conducted statistical validation of advertising themes and campaigns as a partner with Campbell Ewald/CECO Communications.Designed longitudinal research studies to determine the effectiveness of direct marketing programs.Experienced with advanced statistical techniques, such as perceptual mapping, conjoint analysis, factor, discriminant and regression analysis.Experienced in research study design and methodology, as well as the analysis and reporting of quantitative market data in SAS.Manager of automotive VIN decoding database for all in-house and competitive automotive research studies.Instrumental in the establishment of a 20+ year relationship with Caterpillar Financial for customer satisfaction/CSI tracking and customer relationship data reporting.
  • Rda Group
    Programmer / Analyst
    Rda Group Feb 1989 - Dec 1997
    Responsible for data processing administration and reporting of on-site automotive advanced product research clinics, automotive features research and drive tests throughout North America, Europe and Brazil for Ford and Mercedes.Director of numerous high-volume, high-visibility automotive quality tracking studies for Chrysler North America and General Motors Mexico, South America and Asia. This involved extensive client contact in the capacity of data processing manager and research consultant.

Alan Rogers Skills

Automotive Data Reporting Customer Satisfaction Marketing Research Web Based Surveys Sql Market Research Analytics Customer Insight Marketing Strategy Data Analysis Sas Programming Statistical Data Analysis Quantitative Research Microsoft Sql Server Microsoft Access Spss Html Microsoft Excel Visual Basic For Applications Management Html Emails Html Scripting Excel Dashboards Customer Relationship Management Customer Csi

Alan Rogers Education Details

  • Oakland University
    Oakland University
    Corporate Finance
  • Gmi Engineering & Management Institute (Now Kettering University)
    Gmi Engineering & Management Institute (Now Kettering University)
    Marketing And Finance - Dual Major

Frequently Asked Questions about Alan Rogers

What company does Alan Rogers work for?

Alan Rogers works for Onemagnify

What is Alan Rogers's role at the current company?

Alan Rogers's current role is Data Engineer.

What is Alan Rogers's email address?

Alan Rogers's email address is ar****@****tes.com

What schools did Alan Rogers attend?

Alan Rogers attended Oakland University, Gmi Engineering & Management Institute (Now Kettering University).

What are some of Alan Rogers's interests?

Alan Rogers has interest in Photography, Audiophile.

What skills is Alan Rogers known for?

Alan Rogers has skills like Automotive, Data Reporting, Customer Satisfaction, Marketing Research, Web Based Surveys, Sql, Market Research, Analytics, Customer Insight, Marketing Strategy, Data Analysis, Sas Programming.

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.