Cristian W Potter
North Providence,RI
Summary
I am looking to help organizations become more data driven by creating technical solutions based on organizational contexts. Perceptive and logical Data Analyst communicates well with both technical professionals and end-users to identify and translate business requirements. Experienced driving data accuracy and integrity to exceed quality standards. Builds and leads teams of talented professionals to develop valuable process solutions and meet business objectives.
Overview
12
12
years of professional experience
Work History
Mathematics teacher
Providence
03.2021 - Current
- I teach AB and BC Calculus, Precalculus, AP Statistics and Cryptography.
Founder
Red Rooster Solutions
, RI
10.2018 - Current
- I founded Red Rooster Solutions to focus my work on helping local organizations and small businesses develop their analytics capacity
- Conducted an in depth analysis of HR data for Teach for America as part of the Diversity, Equity and Inclusion audit using SQL, Python and PowerBI.
- Provided statistical analysis for 'School Centered Housing Response Model' report conducted by UPD Consulting using R and Tableau.
- Designed small business grant program for RI Commerce, including researching and documenting Treasury guidance and best practices based on CARES Act and ARPA funding sources. Created technical and analytics requirements in confluence and technical architecture documents in Visio.
- Created a dashboard for the pvdrescueplan.com site.
- Created an entire reporting suite of automated weekly, monthly, quarterly sales reports for Fish Head Farms.
- Conducted trainings on PowerBI and Tableau for several local small businesses and non-profit organizations.
Senior analytics
UPD Consulting
04.2019 - 10.2020
- Worked with school systems and colleges on implementing the EdFi standard and the Teacher Prep Data Model extension
- Architected and built analytics pipelines from ETL, to data modeling, to data visualization and statistical analysis mostly using Microsoft tools like Azure Data Factory, SQL Server and PowerBI
- Designed a FERPA compliant, cloud hosting line of business using MS Azure, and Azure Active Directory.
- Provide training for clients on data modeling (SQL and Analysis Services) and data visualization (PowerBI and Tableau), Azure administration.
- Reviewed current analytics implementations and provided recommendations for realignment to customer KPIs or technical best practices.
- Captured and documented customers' business and technical requirements.
- Created business and technical requirements documentation and developed solution designs for analytics implementation.
- Mapped current business and operational processes and recommended areas for improvement.
Data engineer
Oliver Wyman
12.2018 - 04.2019
- Worked on an Oracle to Postgres Data Migration for a technology modernization project with a major retail client.
Founder
Sol Tiempo
Providence, RI
04.2018 - 12.2018
- Soltiempo was a startup that attempted to create both hardware and web-based software, grid edge, demand response solutions that would change the way our everyday devices behaved.
Principal Data Engineer
Hasbro
Pawtucket, RI
11.2016 - 04.2018
- Built new analytics pipelines including writing ETL scripts using Python and Azure Data Factory.
- Built and managed SQL Server databases.
- Built dashboards in PowerBI and helping business teams with advanced analysis projects.
- Administered both development and production Azure subscriptions.
- Led major projects with eComm and Digital Marketing teams.
- Developed, implemented, supported and maintained data analytics protocols, standards and documentation.
- Contributed to internal activities for overall process improvements, efficiencies and innovation.
- Addressed ad hoc analytics requests and facilitated data acquisitions to support internal projects, special projects and investigations.
Senior Consultant - Data Science
CVS Health Pharmacy Operations COE
Woonsocket, RI
06.2016 - 11.2016
- Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.
- Identified business issues through careful collaboration with key stakeholders.
- Prioritized projects and project tasks depending upon key milestones and deadline dates.
- Performed various statistical, time series and segmentation analysis using data that was mostly in Teradata SQL data warehouses.
- Built Tableau dashboards and made presentations to business partners and senior management.
Senior Consultant-Analytics
CVS Health Digital
Woonsocket, RI
05.2015 - 06.2016
- Started the drive to adopt Tableau as the delivery method of choice for digital analytics
- Tableau Server site admin
- Created Tableau a dozen dashboards using web data
- Performed various statistical, time series and segmentation analysis
Data Program Director
InsureMyTrip
Warwick, RI
05.2014 - 05.2015
- Redesigned data and reporting architectures
- Lead implementation of new BI tool, moving all reporting towards a single source of truth
- Lead a team of analysts, provided training on programming, report and dashboard design, and advanced statistical methodology
- Additionally, I performed the "big picture" analysis projects.
- Collaborated with various teams to uncover issues, identify applicable solutions and offer guidance.
- Improved success of program by making proactive adjustments to operations.
Data solutions engineer
12.2012 - 04.2014
- Built statistical models to predict the value of an impression to use with the real time bidding system for enterprise level publishers
- Performed market research and create Chitika Insights reports including taking over our monthly marketingland.com post.
Education
BS - Statistics, Economics
East Carolina University
Greenville, NC05.2012
AS - General Studies
Community College of Rhode Island
Warwick, RI05.2007
Skills
- SQL Programming
- SQL DBA
- SQL Server, MariaDB, Oracle, Postgres, Snowflake
- Python Scripting (Pandas, SciPY, NumPy, etc)
- Azure Administration
- NoSQL data (JSON, XML, unstructured)
- Data Visualization (Tableau, PowerBI, Sisense)
- Web Analytics (Google Analytics, Webtrends, raw weblogs)
- Digital Analytics (Social Media, YouTube, Mobile Apps)
- CRM Analytics (Salesforce, Microsoft Dynamics)
Timeline
Mathematics teacher
Providence
03.2021 - Current
Senior analytics
UPD Consulting
04.2019 - 10.2020
Data engineer
Oliver Wyman
12.2018 - 04.2019
Founder
Red Rooster Solutions
10.2018 - Current
Founder
Sol Tiempo
04.2018 - 12.2018
Principal Data Engineer
Hasbro
11.2016 - 04.2018
Senior Consultant - Data Science
CVS Health Pharmacy Operations COE
06.2016 - 11.2016
Senior Consultant-Analytics
CVS Health Digital
05.2015 - 06.2016
Data Program Director
InsureMyTrip
05.2014 - 05.2015
Data solutions engineer
12.2012 - 04.2014
BS - Statistics, Economics
East Carolina University
AS - General Studies
Community College of Rhode Island