Ian Reid's Location
Chicago, Illinois, United States, United States
Ian Reid's Contact Details
Ian Reid work email
- Valid
- Valid
- Valid
Ian Reid personal email
n/a
Ian Reid phone numbers
About Ian Reid
Dedicated and solutions-oriented senior Data Analyst with passion, drive,and vision, possessing progressive experience in leveraging vast data tocreate meaningful reports and establish KPIs to measure the effectiveness ofbusiness decisions while capturing, consolidating, and visualizinginformation to foster understanding of the past, present, and likely futureoutcomes. Demonstrated track record of designing and building interactivedashboards with strong background in ETL processes. Excellent communicationand presentation skills, with the ability to effectively convey complexconcepts to both technical and non-technical stakeholders.Technical Proficiency: Data Visualization & Storytelling | Data Warehousing& ETL | Data Modeling & Analysis | Data Governance & Security | PredictiveModeling | Insight & Trend Identification | Business Intelligence: Tableau,Power BI | Cloud-based Systems: iMIS | Programming Languages: Python, R |Servers: MySQL, Microsoft SQL Server | Machine-learning Algorithms |Analytical Tools: Excel, Google Sheets, Google Analytics | CRM Software:Salesforce
Ian Reid's Current Company Details
Ian Reid Work Experience Details
-
Hx Solutions DeveloperPress GaneyChicago, Il, Us
-
Data ConsultantZenza Consulting Jan 2024 - Apr 2024Chicago, Il, UsAddressed and oversaw diverse IT requirements for clients by employing a spectrum of technologies. Tracked project advancements systematically through Azure DevOps and JiraSelected Accomplishment: • Developed comprehensive report tests using dbt to assess the functionality and efficacy of SQL queries, encompassing a dataset of 5,000 rows stored in Google BigQuery. -
Data AnalystCfa Society Chicago Jan 2023 - Jul 2023Chicago, Il, UsMy role as a Data Analyst encompassed oversight of design, development, andmaintenance of large datasets and accuracy of visualized data, utilizingdata visualization platforms specifically Excel and Power BI.I fashioned Power BI dashboards to visualize KPIs on active members, CFAexam candidates, and ESG program participants through large datasets rangingfrom 150 to 5,000 rows pulled from Salesforce CRM.KEY CONTRIBUTIONS: Educated CFA Society Chicago staff and via visualizations in Excel andPower BI on status of 4,500 active members, 1,500 candidates, and 250 ESGparticipants to ensure that events were meeting the Society's needs. Wrote a Python script to automate sending emails to 4,500 addresses inless than 2 hours as part of a targeted marketing campaign for a majorevent; libraries used included pandas, win32com.client, and email amongothers. -
Data AnalystPower Stop Llc Apr 2022 - Aug 2022Bedford Park, Illinois, UsAs a Data Analyst, I modeled data, set up automation of processes, providedanalysis and insight, and worked with tools such as SQL, Power BI, andPython to drive efficiency and effectiveness. Essentially, I bridged the gapbetween business and data, using analytical thinking to solve businessproblems to generate value, presented through clear presentations andinsight.KEY CONTRIBUTIONS: Ensured that over 30 truckloads were filled and delivered in a timelymanner each day by creating a Power BI dashboard linked to a SQL Serverview of 30,000,000 rows of data which tracked order date and shippingdate for each order. -
Senior Data AnalystCoinflip Nov 2021 - Mar 2022Chicago, Il, UsMy experience encompassed the management of design, maintenance, andenhancement of data collection and reporting through data systems andplatforms to support evaluation, research, and quality improvementinitiatives.I designed and developed interactive dashboards for inter-departmental(Sales, Marketing, Business Development, Compliance, and Finance) operationsusing Tableau through profound datasets (1,500-1,500,000 rows) retrievedfrom MySQL database, Google Analytics, and/or spreadsheet programs.KEY CONTRIBUTIONS: Illuminated C-Level executives about 6 competitors’ weekly sales throughtracking of 1,000,000+ blockchain transactions and comparing them tothose of CoinFlip via a Tableau dashboard utilizing Python, SQL, andGoogle Sheets. Extracted, transformed, and loaded data, while leveraging expertise inSQL to analyze large datasets (1,500-5,000 rows) and create ad-hoc Excelreports for various departments, to improve company’s strategic decision-making process. Wrote procedures, functions, and triggers in Python scripts to controlflow of data, automate data retrieval, formatting, and perform otheradministrative tasks for multiple departments, to increase operationalefficiency; libraries used – pandas, numpy, and mysql.connector. -
Senior Compliance AnalystCoinflip Jul 2020 - Nov 2021Chicago, Il, UsAs a Senior Data Compliance Analyst, I collaborated with other members ofthe Compliance team to analyze and review regulatory requirements, toproactively identify and implement new or improved oversight/supervisoryprocesses, procedures, and reporting.Additionally, I leveraged BI maintenance skills in sustaining existingdashboards and preparing standard Python scripts used to withdraw data forwriting suspicious activity reports (SARs), completing cash collectionreports, and finding accounts with various user policy violations and/orconcerns (shared wallets, structuring, and high-volume accounts), andidentifying new and improved ways to showcase compliance information in ascalable manner.KEY CONTRIBUTIONS: Expedited writing of SARs for Compliance team at CoinFlip by writing aPython script with built-in SQL queries that cut research time down from3 hours to 30 seconds.
-
Professional DevelopmentCareer Break Feb 2020 - Jul 2020During the initial phase of the Covid-19 pandemic, I took the time to refresh my understanding of Python, SQL, and R, along with their associated libraries, and to learn the basics of Power BI and Tableau. This was done using exercises from DataCamp. These skills proved useful in my data-focused experiences later on.
-
Litigation Support SpecialistWinston & Strawn Llp Aug 2019 - Jan 2020Chicago, Illinois, Us• Archived files in Relativity before using WinRAR to store case data for possible future; changed file data, if necessary, with EmEditor; mapped folders and files to new drives to use WinRAR on separate sections if needed; task tracked in Excel • Copied data to external drives for legal cases using the robocopy command line prompt, Beyond Compare, or other means, and verified file transfers for size and accuracy; secured drives using BitLocker as instructed by project managers via Outlook -
Circulation AssistantUniversity Of Illinois Urbana-Champaign Aug 2017 - May 2019Champaign, Il, Us· Assisted Patrons with finding and checking out relevant study materials in the Law Library· Facilitated study of course material by providing a comfortable, clean, and silent study environment for students to achieve their best results in their classes; any phone calls where taken in a quiet, yet polite, manner · Organized materials to ensure that materials could be searched more easily -
Data Modeling And Visualization PracticumUniversity Of Illinois Urbana-Champaign Aug 2018 - Dec 2018Champaign, Il, Us· Modelled relationships between data tables in Excel Power Pivot to investigate relationships between them for the UIUC Facilities and Services department· Created new columns using DAX with the above tables’ data values to create new values that illustrate the changes in data over time.· Visualized the discovered changes using Excel and organized the findings by date and bin location in a categorical hierarchy
-
Library AssistantUniversity Of Illinois Urbana-Champaign May 2018 - Aug 2018Champaign, Il, Us· Remodeled library shelves by shifting materials to provide space for more materials that would benefit patrons’ needs at the UIUC Music and Performing Arts Library· Furnished materials by shelving them in accessible locations and an understandable order on library shelves· Inventoried items to ensure that they are available or accounted for scholar’s academic and/or intellectual needs
-
Office AssociateAccess Technology Solutions Inc. Jan 2017 - Jun 2017Southlake, Texas, Us· Fashioned an orderly space for sales meetings by providing clerical and administrative office support in including completing reports and assignments as assigned and coordinating paperwork and information flow· Moved sales along by faxing, scanning and copying documents, monitoring/ maintain office supply and coordinating courier service by receiving, sorting, and distributing incoming mail.· Sustained history of company reports, records and various other documents by sorting and binding them for documentation in order to make negotiations and practices accessible for review. -
General Testing AssistantThe American Board Of Radiology Oct 2016 - Nov 2016Tucson, Arizona, Us· Provided radiologists an orderly testing environment by directing them where necessary places were in the facility in order to give them the maximum amount of test-taking time· Assisted focus on test-taking by ensuring that noise was kept to a minimum so that testers may achieve their maximum potential scores· Furnish a clean environment by disposing of waste and cleaning testing materials in order that testers would not lose focus by messy surroundings -
Customer Service Sales RepresentativeSports Awards Feb 2016 - Aug 2016Us· Equipped race organizers with custom medals to fit their art style and budget thereby providing an incentive for an average of 1000 runners to participate in races; supervised design and scheduling of product manufacturing/shipment for the Runner's High Medallions division· Bestowed information about relevant products to 15 customers per day by pertinent yet friendly email and/or phone conversation to ensure that time-sensitive orders were completed at a quick pace yet with acute attention to detail.· Safe-Guarded personal financial information to make sure that all payments were carried out in a safe manner. -
G-Corps FellowGalapagos Charter Schools Aug 2014 - Jun 2015Rockford, Illinois, Us· Cultivated scholars’ understanding of mathematics by providing organized lessons in a clear, concise manner that lead to an average growth of over 1.5 years in conceptual understanding· Produced an orderly timetable of events by shaping a personal Mastery Connect calendar to include which of the said lessons would belong to certain scholars and when they would be executed (held to a standard set by supervisor)· Championed a high standard of content mastery and lucid presentation by critiquing lessons of other fellows -
Library ClerkUniversity Of Illinois Urbana-Champaign Aug 2013 - May 2014Champaign, Il, Us· Facilitated study of course material by providing a comfortable, clean, and silent study environment at the ISR Residence Hall Library for students to achieve their best results in their classes; any phone calls where taken in a quiet, yet polite, manner · Transformed the library into place for patrons’ all-around growth by running programs about the library’s resources· Actualized the patrons’ needs or desires by providing detailed reports of said items and activities to supervisor
Ian Reid Skills
Teaching
Curriculum Development
Microsoft Office
Research
Public Speaking
Educational Leadership
Customer Service
Microsoft Excel
Classroom
Powerpoint
Editing
Writing
Data Entry
Office Management
Ian Reid Education Details
-
University Of Illinois Urbana-ChampaignLibrary And Information Science -
University Of Illinois Urbana-ChampaignEnglish Language And Literature/Letters & Philosophy
Frequently Asked Questions about Ian Reid
What company does Ian Reid work for?
Ian Reid works for Press Ganey
What is Ian Reid's role at the current company?
Ian Reid's current role is HX Solutions Developer.
What is Ian Reid's email address?
Ian Reid's email address is ir****@****ton.com
What is Ian Reid's direct phone number?
Ian Reid's direct phone number is +121739*****
What schools did Ian Reid attend?
Ian Reid attended University Of Illinois Urbana-Champaign, University Of Illinois Urbana-Champaign.
What are some of Ian Reid's interests?
Ian Reid has interest in Human Rights, Education, Arts And Culture.
What skills is Ian Reid known for?
Ian Reid has skills like Teaching, Curriculum Development, Microsoft Office, Research, Public Speaking, Educational Leadership, Customer Service, Microsoft Excel, Classroom, Powerpoint, Editing, Writing.
Who are Ian Reid's colleagues?
Ian Reid's colleagues are Kelsey Johnson, Mohammed Imtiaz Ali, Janet Campbell, Todd Harshman, Cassie Lamanti, Greg Weber, Leeann Inman Hancock.
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
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
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.
Start your free trial