Dré Randaci

Nashville, TN drerandaci@gmail.com

I have held positions specializing in IT services as a programmer and business intelligence analyst. My practical experience includes systems integration, ETL, business intelligence, data warehousing, mobile app development, fullstack web development, and team collaboration. Find me online via the links below.


Technical Experience

Software Developer

InfoWorks
Data warehousing and ETL

While working for a Fortune 200 manufacturing client, I built a dimensional Data Warehouse for reporting and analytics. The warehouse integrated five SQL Server databases holding gigabites worth of data each that required extraction from different server locations and heavy cleansing via SQL stored procedures. The model was based on Ralph Kimball's Dimensional Modeling. I executed an architecture that follows a simple ETL pattern using four schema definitions (staging, ods, dim, fact):

  • Extract data based on a date delta (daily) and strip of all referential integrity (no foreign keys, indexes, primary keys)
  • Utilize an ODS (Operational Data Store) to transform the data. The ODS layer primarily acted as a gate keeper; all records were transformed into target data shapes for use upstream in the dim and fact layer. If an entity was named one thing in one database and something else in another, transform both into a common name. This included removing all NULL values and replacing them with the mapped defaults below based on column data types:
  • Load the model with facts and dimensions defined in the reporting and business requirements. Tables were created under their respective schema layer names (fact.TableName, dim.TableName, etc.). Facts are the measurements that result from a business process event, while dimensions provide the “who, what, where, when, why, and how” context surrounding a business process event
The system decreased the amount of time to deliver reports for product genealogies dramatically; previously, these reports were generated in anywhere from 1-4 days and involved multiple management teams. Once implemented, the Data Warehouse could generate these reports with only the latency of the query.

SQL Server, Visual Studio Schema Compare, TFS
Application Development

As part of a team of five developers, I helped build an application for a Fortune 200 manufacturing company to operate their packing processes. This system implemented new functionality to track product packing, quality control, quality acceptance, and to replace antiquated paper checklists. Business logic was strictly segragated to the database layer and communicated with various systems, all supported by a JavaScript web app. My main duties were to build out the database and business logic and communicate with various consuming PLC's and HMI's. I also built JavaScript views to support the web app. One of the most interesting features I worked on was an operator checklist system based on a matrix table that associated criteria to corresponding entities and were instantiated by event-driven triggers.


Kendo-UI jQuery, SQL Server, Visual Studio, TFS
October 2018 - Present

Software Developer

PxlPotion
Application Development

I worked on a number of web and mobile projects across industries mostly using JavaScript and MongoDB. Projects included:

  • A mobile application built for a moving company that allowed movers to walk through a move step-by-step with checklist milestones. The application was used by field workers to track inventory during a move, route to a destination, and aggregate move statistics. The application was cross-platform via the React Native library. Alongside the mobile app was a paired administrative web app for management to view workers in real time on a map utilizing web sockets. My main duties included building the mapping functionality in the mobile app and creating custom pagination for viewing historical data in the administrative app
  • A facility management app (view MapPlug here) that allowed users to mark building information on an interactive map. I implemented Google Maps and helped create customizable layering functionality to overlay images, icons, and info boxes onto a map. The web app was built mobile-first and utilized Material Design for React. In addition to implementing the map, I worked on navigation functionality, icon toggling, and created a movie player modal for new-user orienteering.

React, React Native, Node, iOS, Android, VS Code, Git
April 2018 - October 2018

Skills

Programming Languages & Tools
Workflow
  • Mobile-First, Responsive Design
  • Cross Browser Testing & Debugging
  • Cross Functional Teams
  • Agile & Kanban Development, Scrum
  • Test-Driven Development

Interests

Responsive image

Apart from being a developer, I spend most of my time outdoors. During the warmer months here in Nashville, I enjoy mountain biking, rock climbing, cooking out, and fly fishing.

When forced indoors, I follow a number of television shows, I am an aspiring cook, and I spend a large amount of my free time exploring the latest technology advancements in the machine learning, data science, and AI world.


Community Activities & Certifications