John Xiong, MBA

Experience

• 

  ICS Marketing Services

  Jan 2012 - Jun 2014

  Programmer

  Reputable Projects:List Encoding/NCOA - Develop automated processes to take client customer list and run them through data cleansing/transformation processes across the wire to BCC company. (SSIS, SQL, C#, Visual Basic)Business/Customer Profile - Develop system to process customer list through marketing data and return profile of information on demographics in Excel spreadsheet. (C#, SQL, SSIS, EPPLUS)AutoNet - Develop custom projects to process customer data and compare to actively shopping customers. Results return as an Excel customer profile report and enhanced data using Acxiom services. (C#, SQL, SSIS, EPPLUS)Tasks:- Develop Microsoft SQL Server databases for new/reoccurring projects- Develop SQL Server Integration Services (SSIS) / C# applications for ETL projects- Data Normalization and mapping files to database objects- Maintain previous developer programs including a PDF report generator, Customer profiling utilizing data analytics, and AutoNet prospecting list management- Develop automated systems to reduce human interaction; utilizing various languages including VB.NET, C#, Perl, and Python- Assist developers in creating supplemental applications- Generate customized data sets to help customers with marketing efforts. Show less

• 

  Pii

  Jun 2014 - Feb 2016

  Data Programmer Analyst

  Reputable Projects:AutoNet Direct - Develop and maintain automated processes to compare actively car shoppers to customer lists for prospecting and enhance data from Acxiom demographics and automotive elements. Backend supports sources such as Autobytel, Cars Direct, and Reply.com. NCOA Service - Enterprise level API service to allow uploading and processing of data for a NCOA through a GUI.Efficient Packaging - Automated process to parse BCC packaging information files, load USPS post offices, and create bar-coded shipping papers for production workers; Reducing hours work into minutes, and lowering cost of postage amounts.Tasks:- Develop application wrappers to automate data processing systems (C#, SQL)- Data list cleansing, transformation, and maintenance (SSIS, SQL, C#)- Develop and rewrite complete systems to work with VisualCron (SSIS, SQL, C#, Python, Perl)- Develop back end SSIS packages for Azure Cloud and on premise data loading- Improve current ETL and manual data processing projects- Evaluate new projects for feasibility, time, and resources- Create PDF / Excel reporting applications using Active Reports, EPPlus, and Adobe Acrobat (C#, VB.NET, SQL, Adobe)- Code libraries to help with data validation between standard output files and other (C#, Python, Perl)- Develop RESTful clients to communicate with Web API services (C#, JSON, XML)- Participate in design and development of enterprise level WCF NCOA service (C#, JSON, XML, WCF) Show less

• 

  Farm Bureau Insurance of Michigan

  Feb 2016 - Nov 2021

  Promoted from Associate ETL Developer position.Tasks:- Enterprise Data Warehouse (EDW) development & maintenance - Operational Data Store (ODS) development & maintenance- Architect & develop system integrations such as Pivotal, Guidewire, Web via Extract, Transform and Load (ETL) methodologies.- Utilize Team Foundation Server (TFS) for branching, merging, hot fixes, patches, builds, and deployment- Engineer databases and SQL Server Integration Services (SSIS) projects- Assist in querying data sets for Business Intelligence (BI) departments- Liaison between development team and third-party vendors for knowledge transfersReputable Projects:- Guidewire Billing Center (GWBC) to ODS Integration: Rewrote process that extracts billing account balances from GWBC and loads to ODS for web consumption where customers make payments. New process fixed data issues, reduced likelihood of not meeting SLAs, and reduced batch execution time from 2.5 hours to 15 minutes.- Cornerstone LMS: Developed process that extracts users and organizational unit information from an in-house MDM system to Cornerstone. Show less Tasks:- Ongoing development and maintenance of operational data store (ODS) for consumers/business use- Develop, maintain, and support Extract Transform Load (ETL) processes - Adapt ETL processes to accommodate changes in source systems or business requirements- Design, develop, and maintain business and physical data mappings- Develop and alter SQL programs and stored procedures- Solving defects with SQL Server Reporting Services (SSRS) reports, databases, and processes- Utilize Team Foundation Server (TFS) and SharePoint to manage development processes, assist with life cycle management, and facilitate team collaboration- Database work for Guidewire PC/BC implementation Show less

  • Senior Data Engineer

    Jul 2020 - Nov 2021

  • ETL Developer

    Jul 2017 - Jul 2020

  • Associate ETL Developer

    Feb 2016 - Jul 2017
• 

  Ford Motor Company

  Nov 2021 - now

  Reputable Data Projects:1) Pro Power Onboard (PPO)- Develop 2023 August Michigan storm map PPO usage insights that were displayed at 2024 F-150 Reveal event. Live-streamed and in-person exposure to over 4,000 attendees. (See media below)- Generate PPO usage visualizations that led to uncovering customer usages that spans farmers, campers, and a non-profit called Mainely Teeth that powers a mobile dental clinic to bring oral care to rural and underserved communities in Maine. (See media below)General Tasks:- Aid in requesting and extracting connected vehicle data for internal customers- Standardizing Amplitude and Looker Studio visualization processes- Lead in data quality and validation for visualizations- Train individuals on data and evaluation processes- Engineer automated data pipelines- Assist cross-functional teams with backend architecture optimizations and best practices Show less

  • Prognostic Technical Program Manager

    Jan 2024 - now

  • Connected Vehicle Data Engineer

    Nov 2021 - Jan 2024