Nicholas Roy Email & Phone Number

Charlotte, Nc, Us

Charlotte, Nc, Us

New York, Ny, Us

• Manage and mentor two direct data engineering reports, delegating tasks and responsibilities, fostering professional growth and ensuring the successful execution of various projects in alignment with organizational objectives

New York, Ny, Us

• Identify, build, and implement optimal data lake platform on AWS using native services such as AWS CDK, CloudFormation, Step Functions, Lambda, Glue, Athena, DynamoDB, S3, EC2, SES, SNS, STS, and more• Developed a new data pipeline utilizing customers' AWS Cost and Usage Report data, applying complex row-level business logic and collaborating with a cross-functional team to integrate the processed data into a front-end platform. This initiative will ultimately result in multi-million dollar cost savings per year and has facilitated the implementation of new features such as Anomaly Detection, Budget Tracking, and Cost Forecasting

Norwalk, Connecticut, Us

• Migrated data warehouse from an on-prem MySQL instance to a robust and scalable cloud implementation using AWS, dbt, Spark, and Snowflake• Collaborated with Data & Analytics team on dbt workflow which enabled analysts without software engineering backgrounds to version their SQL, test their code, and submit their work for production deployment all within VS Code• Cooperated with business and technology stakeholders to ensure successful data warehouse development and utilization• Maintained both on-prem and cloud pipelines during transition period

Greenville, South Carolina, Us

• Constructed and deployed an ETL pipeline as an Airflow DAG that loads comprehensive loan data to a Snowflake data mart daily; this was critical to the integration of a new lending facility, saving the company millions• Automated and migrated numerous business processes to cloud services (Snowflake) resulting in a reduction in manual labor, an increase in personal identifiable information security (using data masking, file encryption, and SSH File Transfer Protocol Servers), and a cost savings of $200-300k annually• Designed and managed databases within the data warehouse to provide optimal usefulness to business users • Developed solutions for business directors and analysts to internal and external business needs

North Kingstown, Ri, Us

I created reports and further developed packaging KPI's for Toray's automated packaging system. Smaller reports measuring shift performance will be used in monthly meetings. The biggest project, an on-display dashboard, provides shifts with live information detailing things such as throughput, roll storage status, rolls pending packaging, and more.

Financial Analyst – Assumed an open position. Major duty was preparing daily production report detailing operational KPI’s and daily and MTD Financial Metrics. Utilized SAP, GE Plant Apps, & Excel. Created Work instructions and trained new hire toward end of internship. Began the process of automating the daily report into Spotfire.• Spotfire – Created multiple dashboards and reports using BI Software Spotfire for newly deployed automated packaging line asset. Worked with IS to link Spotfire with GE Plant Apps to automate in real time the dashboards which are displayed on the production floor. Assisted Scheduling Manager with other Spotfire reports and special projects

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Operations Management