Profile Picture

Hi, I'm Brandon!

A Data Analytics Engineer with expertise in SQL, Python, cloud data systems, and data visualization.

View My Projects

Data Analytics Engineer with 6+ years of experience building SQL and Python-based data pipelines, financial calculations, and reporting solutions for large-scale enterprise and public-sector systems.

Professional Experience

Accenture Data Analytics Engineer Specialist - New York, NY - Jun 2025 – Present

Data Analytics Engineer Sr Analyst - New York, NY - Feb 2022 – Jun 2025

    Client – Large State Pension Program – Data Analytics Lead
  • Led data analysis of 95,000 backlog recalculation cases, identifying automation-eligible populations and accelerating backlog resolution timelines
  • Designed and implemented a Python (Pandas, NumPy) calculation engine to model multi-year COLA eligibility, partial-month proration, retroactive payments, and recovery schedules for pension members
  • Developed 40+ optimized Oracle SQL queries to identify exception cases for manual review
  • Processed and analyzed 10M+ earnings records using Python and SQL, applying trimmed-mean techniques to identify payroll anomalies
  • Built a fuzzy matching solution using Levenshtein distance to reconcile paper-based pension forms with Oracle records, increasing match rates and reducing manual review effort by 40%

    • Client – Large City Pension Program – Technology Architect
  • Led a 3-person workstream delivering 30+ JasperReports solutions built on Java and Oracle SQL DB
  • Orchestrated a Python ETL pipeline in Jenkins to load 64M+ rows of Box metadata into MS SQL Server
  • Re-sharded Box folders, reducing the largest folder size from 40M to under 1M files and accelerating document retrieval by 60%
  • Developed Tableau dashboards used to drive decisions in planning of pension outreach programs
  • Refactored and migrated JRXML code for 29 Production letters to AWS CodeCommit

    • Client – Fortune 50 Managed Healthcare Company – Lead Data Analyst
  • 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 – Platform Engineer
  • 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 100 Pharmaceutical Company – Integration Engineer
  • 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

Languages

SQL, Python (Pandas, NumPy, SciPy, thefuzz), HTML/CSS, YAML, XML

Certifications

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

Databases

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

Tools & Platforms

AWS, Box CLI, Databricks, dbt, Git, Informatica IICS, JasperReports, Jenkins, Jupyter Notebooks, Tableau