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 5 years of experience in application development, data analytics, data migration, and reporting. Highly skilled in SQL, Python, AWS, Tableau, and JasperReports.

Professional Experience

Accenture Data Eng, Mgmt & Governance Specialist - New York, NY - Jun 2025 – Present


Data Eng, Mgmt & Governance 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 those eligible for automation and accelerating resolution timelines
  • Developed 40+ Oracle SQL queries to flag exception cases for manual review, improving triage accuracy
  • Utilized Python (Pandas, SciPy) and SQL to process and analyze 10M+ earnings records, uncovering payroll anomalies via trimmed mean techniques that improved audit readiness and data integrity
  • Built a fuzzy matching solution leveraging Levenshtein distance to reconcile discrepancies between paper-based forms and Oracle data, increasing match rates and reducing manual review 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 50 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

Certifications

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

Languages

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

Databases

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

Tools & Platforms

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