Raymond Newby

Data Analyst • Los Angeles, CA, US

SQL

Data Visualization

Tableau

Python

Data Analysis

Technical Writing

Available for hire fromNegotiable

Contracts

Full-Time Roles

Making sense of data so you don't have to.

Experienced data analyst with a passion for visualization and providing business leaders with the data-driven insights needed to grow their businesses. I've worked across industries including media/entertainment, banking, and the public sector, helping companies make sense of their data. Outside of work, I enjoy hiking the Southern California mountains and playing with my cats.

Projects

Dashboard

I did the first analysis of a government agency's procurement system data, including creating an R script to geocode the locations of the offices. I added the data to a custom database and built an interactive Tableau dashboard on top to allow senior leaders to examine the data themselves.See More

Work History

Senior Consultant (Data Analytics)

Qvest.USAug 2022 - Present • 2 yrs 1 mo- Senior Consultant with the Data & Analytics practice for the largest media and entertainment-focused consultancy in the US. - Compiled and analyzed internal data for social media sites and website data in order to guide leadership in making marketing decisions and analyzing existing campaigns. - Provided support and expert knowledge for data migration planning at a large international publishing company. - Recommended AWS Aurora database scalability improvements, SQL query optimizations, and load testing strategies for a major blood bank’s new donor and donation management platform. - Tools: SQL, AWS, Looker Studio, Snowflake, dbt, Google Analytics, Later, Git

Principal Data Analyst

Capital OneMay 2020 - Aug 2022 • 2 yrs 3 mos- Part of the strategic intelligence team, comparing bank and customer metrics to competitors and creating slide decks to be presented to the CEO. - Set up fraud alerts using SQL, Python, and Bash to flag accounts that exceeded set thresholds indicating potential high-risk threats, especially around government stimulus and Paycheck Protection Program (PPP) loans. - Built and maintained R Studio dashboards for high-level board meetings. - Led data management efforts and set up best practice documentation for improving metadata management. - Worked with the Data Transformation team to facilitate the movement of retail bank analytics data into the enterprise data lake. - Provided guidance and recommendations on leveraging emerging technologies from across the enterprise. - Built relationships with data producers and technology partners to reduce the burden on our contracting team and improve the speed at which we complete the onboarding of all retail bank analytics data. - Built and improved Tableau dashboards to ease monthly and quarterly reporting on all fraud cases within the Small Business market. - Tools: SQL, Snowflake, Databricks, R (Shiny, Flexdashboard), Python, Jupyter, Bash, Tableau, Spark, AWS, Git

Senior Data Analyst

BelcanAug 2019 - May 2020 • 10 mos- Analyzed State Department IT budget data for presentation to the CIO and inclusion in the President's yearly budget. - Gathered requirements from stakeholders to weave together stories to reflect IT investment funding priorities. - Worked with data team members to launch an analytic environment with SQL Server, R Studio, and Tableau Server to allow analysts to produce on-demand analysis for senior leadership. - Generated the first reports from the DoS’s existing IT purchase request system to provide insight into the requesting offices, items purchased, and spending trends. - Built interactive dashboards in Tableau and PowerBI to allow analysts to track budgets and spending requests. - Tools: SQL, Tableau, SQL Server, R / R Studio, Oracle, PowerBI

Data Scientist

Rotunda SolutionsJan 2018 - Aug 2019 • 1 yr 7 mos- Cleaned and analyzed data for use by the Undersecretary of Defense regarding major acquisition contracts and federal contractors. - Used R to script, cleanse, and output monthly and quarterly reports, as well as prepared the data used in yearly briefings to Congress. - Used visualization tools such as Tableau dashboards, R Markdown PDFs, and Shiny apps to create value-driven business recommendations and stories that are recognizable to data consumers. - Was part of the team that set up the first analytic environment within the DoD Acquisitions and Sustainment organization, including R, Python, Alteryx, and Tableau. - Conducted training sessions to teach acquisition subject matter experts the basics of data analytics and visualization, as well as modern analytical tools. - Worked closely with the company owner to expand the business into new areas, including overseeing efforts in smart city technology and environmental sustainability. - Tools: SQL, Tableau, R / R Studio, Alteryx, Python, Qlik Sense

Consultant (Software Development)

Booz Allen HamiltonJul 2016 - Jan 2018 • 1 yr 6 mos- Wrote Python scripts to automate data pulls and cleansing for the data collected within a new mobile app from the Dept. of Veterans Affairs. - Assisted with the expansion of a project aimed at setting up new patent office locations in innovation hotspots around the country by collecting, analyzing, and visualizing data using Excel and Tableau. - Worked as part of the development team on a grants management project by providing immediate assistance with operations and software releases, comparing business requirements to the current system design, and writing complex SQL queries to locate grants information and update the database with new data. - Completed surge-team support for the 2016 Presidential Transition Team (PTT), involving imaging and configuring laptops and cell phones as part of the PTT IT team. - Contributed to a proposal submission that helped the Finance and Economic Division account group to win a $10 million sole-source award. - Managed the Veterans Affairs Dependency Claims processing team, including through a surge effort during Hurricane Harvey. - Tools: Tableau, SQL, Python, Git

Technical Writer

Vencore (now Peraton)Sep 2015 - Jul 2016 • 11 mos- Worked with an Integrated Project Team to analyze the customer’s business needs in developing a system to record time and attendance of security officers and monitor the staffing of government facilities across the nation. - Wrote and edited acquisition documents, operational requirements, user stories, and technical documentation in order to move the project from the planning stage to the development stage through Department of Homeland Security gate reviews. - Planned the development process for implementing the first Agile software development project for the Information Technology Division of the Federal Protective Service. - Recorded unofficial meeting minutes for team stand-ups, as well as official minutes for high-level briefings with department chiefs.

Education

Georgia Institute of Technology

Graduate Degree, Computer ScienceAug 2016 - May 2021

University of Pittsburgh

Bachelor's Degree, Information Science2014 - Dec 2014

University of Pittsburgh

Bachelor's Degree, Writing / JournalismAug 2001 - Apr 2005

How Pangea Works

Effortlessly discover top talent

We’ve distilled the candidate search from endless hours down to just a few minutes. Using Pangea’s AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company’s niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea’s fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team’s capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We’ve combined every part of the hiring process into one platform to eliminate the miscommunication that’s unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.

Available Now

Book a Call