Profile Picture

Hi, I'm Brandon!

A Data & Analytics Engineer with expertise in SQL, cloud technologies, and data visualization.

View My Projects

Accomplished Data Analytics Engineer with 5 years of experience in application development, data analytics, data migration, and reporting. Proficient in SQL, Tableau, JasperReports, and cloud data systems, with a proven track record of delivering scalable, data-driven solutions.

Professional Experience

Accenture Data Analytics Engineer - New York, NY - Feb 2022 – Present


    Client – Large Municipal Public Employee Retirement System
  • Led workstream of 3 resources that developed, deployed, and successfully delivered 30+ dynamic reports built using JasperReports (Java reporting tool) and Oracle SQL DB
  • Managed a Python-based ETL pipeline, orchestrated via Jenkins, to load over 64M rows per table of Box metadata into MS SQL Server
  • Reports delivered assisted client in providing access to pension entitlements for over 350,000 members
  • Re-sharded Box folder system, reducing largest folder size from 20M to under 1M files, enhancing file storage and collaboration performance by 25%
  • Developed Tableau dashboards used to drive decisions in planning of pension outreach programs

    • Client – Fortune 50 Managed Healthcare Company
  • Assisted client in move to new cloud system by converting 50+ old SQL scripts utilizing new updated cloud data model in Teradata
  • Led client project internal SQL code reviews for our team of 4 developers
  • Acted as subject matter expert on SQL, data engineering, and any other general technical questions in our internal team and thrived
  • Ran internal daily huddles and meetings to ensure deliverables for review with client met high standard
  • Set the standard for quality assurance processes and best practices for the client project team to follow

    • Client – Fortune 50 Telecommunications Company
  • Supported a large Network Engineering initiative using data and analytics to optimize processes and network deployment
  • Designed 15 SQL views for 5 dashboards supporting a multi-billion-dollar 5G initiative, enabling data-driven decision-making
  • Performed advanced data profiling and analysis, created views for visualization consumption in Oracle
  • Coded transformations of data (SQL, Python), and worked with business and visualization team to create assets that end users utilized in their daily operations, used data to provide executive business insights

Infosys Senior Associate Analyst - Basking Ridge, NJ - Apr 2021 – Feb 2022


Associate Analyst - Basking Ridge, NJ - Dec 2019 – Apr 2021

    Client – Fortune 50 Pharmaceutical Company
  • Developed ETL pipelines in Informatica Intelligent Cloud Services (IICS), leading to a 30% reduction in overall ETL pipeline runtime compared to previously developed pipelines in IBM DataStage
  • Designed detailed ETL mappings in IICS using joiners, expressions, lookups, and other data transformations to move data from a source table to a target table
  • Created and executed Mass Ingestion data tasks in IICS to move large quantities of data from an Oracle database to a Snowflake database, this allowed for a migration of data from multiple tables at one time
  • Successfully co-led an effort to modernize the issue tracking and version control of code repositories in our team, moving to Jira and GitHub
  • Wrote complex SQL queries in IICS and Snowflake for development and testing purposes
  • Performed unit testing, compared data outputs between Oracle and Snowflake to ensure the stability and accuracy of the newly created pipelines
  • Successfully created GitHub Actions workflow YAML file used for the purpose of continuous integration and continuous deployment
  • Designed Tableau dashboards detailing the technology support lifecycle of different applications on the Pharmaceutical platform
  • Demonstrated deep knowledge of IICS Data Integration, IICS Data Migration, and Snowflake Databases
  • Authored technical documentation for ETL migration project
Education

Rutgers University, New Brunswick, NJ 08854

Bachelor of Arts in Information Technology and Informatics
Minor in Business Administration

Technical Skills

Certifications

Data Architect Associate Professional Certificate (Accenture/MIT, July 2023), Databricks Lakehouse Platform Essentials (March 2022), AWS Certified Cloud Practitioner (September 2020)

Languages

SQL, PL/SQL, Python, JavaScript, HTML/CSS, YAML

Databases

Oracle, Teradata, Snowflake, DynamoDB, SQL Server, PostgreSQL

Tools & Platforms

AWS, Box CLI, Tableau, JasperReports, Informatica IICS, Databricks, Git, Jenkins