Anthony Obregon Email & Phone Number

Albuquerque, New Mexico, United States

As a Senior Data Engineer at Rocket Lab, I currently lead efforts to optimize data infrastructure, driving significant cost reductions and enhancing performance. I have reduced PowerBI cloud costs by 50% ($120k annually) by continuously optimizing report query performance and retiring obsolete reports. By engineering a data warehouse solution, I have alleviated the SQL server processing load by 30%, improving overall reporting efficiency. I oversee the development and administration of 300+ PowerBI reports, providing critical real-time insights into financial and manufacturing data. I also mentor several engineers, helping them refine their PowerBI and SQL skills. Leveraging AI technologies, I accelerate code development and streamline data transformations. Additionally, I manage ETL processes through a Python API, integrate data using SSIS, and troubleshoot production issues, all while ensuring alignment with business needs through cross-department collaboration and Agile project management.

Tampa, Florida, United States

As a Dynamics CRM Data Engineer at USF, I contributed to enhancing the Dynamics 365 platform and improving CRM data management processes. I utilized C#, JavaScript, and Angular to build enhancements to the Dynamics platform and the Recruitment Events Portal. I developed C# plugins to implement Duplicate Detection logic, significantly reducing duplicate data in the system, and created SQL-based reports to analyze duplication causes. Additionally, I built a Workflow Management application to clear excess workflow data that was inaccessible from the CRM UI. I analyzed the Dynamics Higher Ed Module for integration with existing CRM architecture. I Developed and enforced comprehensive data management policies and procedures for CRM systems, ensuring the accurate and secure handling of customer information. Using AGILE methodology, I gathered and refined enhancement requirements from the Admissions department, while also developing PowerBI reports and PowerApps to deliver insights into recruitment events and improve data quality across the CRM platform.

New York, New York, United States

As the founder and manager of an online drop shipping business, I specialized in selling classical Japanese art prints through Etsy and a dedicated business website. I created and managed the product line, enhancing public domain images using Photoshop to create visually appealing prints and mockups staged in interior environments. To drive sales, I launched and optimized advertising campaigns on Facebook and Google Ads, resulting in increased traffic and revenue growth for the business. Through a combination of creative product development and targeted digital marketing, I successfully built a niche e-commerce business.

Greater New York City Area

As a Data Integration Architect, I led the architecture and deployment of over 50 IBM Manta Data Lineage integrations for clients, encompassing a wide array of data sources and destinations such as SQL databases, SSIS packages, Oracle, Teradata, Informatica PowerCenter, Snowflake, Tableau, and more. I assessed clients' technical landscapes to determine the suitability of IBM Manta for their environments, providing customized solutions. I conducted sales presentations and interpreted data lineage reports for CIOs, Network Engineers, Project Managers, and other stakeholders, helping them understand their data flows. Additionally, I provided technical support, assisting with installation and configuration, troubleshooting issues, and escalating confirmed defects to the development team for resolution.

Greater New York City Area

As a Systems Engineer for the world’s largest Mortgage Real Estate Investment Trust (REIT), I monitored and resolved service disruptions to mission-critical Financial Management applications, ensuring smooth operation of Trading, Position/Risk Management, Trade Execution, Accounting, and Financial Reporting systems. I collaborated with an external accounting firm to design a SQL data warehouse solution, capturing daily snapshots of critical accounting data for reporting and dashboard use. I regularly authored SQL queries to investigate and resolve data inconsistencies, improving data accuracy across the firm’s systems. I also analyzed complex data flows between FTP input files, SQL tables, in-house .NET applications, and external vendor platforms, resolving defects and enhancing data access via SSRS reports and Excel plugins.I developed enhancements and bug fixes for various applications and data integrations, and created a fault-tolerant application for synchronizing daily Constant Prepayment Rate (CPR) data using Bloomberg’s .NET API and VisualCron Server Scheduling API to support trading and risk management analytics. As the primary Application Administrator, I utilized AGILE methodology to collaborate with stakeholders and developers to manage project constraints, design enhancements, and ensure the firm’s systems were capable of managing billions of dollars in assets and liabilities.

Greater New York City Area

As a Solutions Developer Consultant at Avanade, I served as the Technical Lead for a year-long Microsoft CRM engagement, driving over $1.5 million in revenue. I managed a geographically distributed development team of seven members across onshore and offshore locations, overseeing the full lifecycle from technical analysis and design to testing and implementation. I collaborated closely with key client stakeholders, including CIOs and directors, providing strategic technology advice and ensuring that software solutions aligned with business objectives.I developed an Account Location Mapping Tool for an insurance company’s loss control department, leveraging C#, Dynamics CRM API, Bing Maps API, JavaScript, HTML, and CSS to validate and plot over 1 million client addresses. Additionally, I reverse-engineered data warehouse SQL queries by comparing outputs between AS400 and SSRS reports and implemented SSIS data integrations from legacy AS400 systems into a Dynamics CRM 2015 SQL database. This role required me to design and optimize SQL stored procedures and SSIS packages for efficient data transformation and integration.Throughout my projects, I consulted directly with business users and leadership to gather requirements and deliver technology solutions tailored to the clients' needs, ensuring the success of each engagement.

Greater New York City Area

As an IT Intern, I designed and developed an application to automate Active Directory (AD) membership and privileges, streamlining the management of user access within the organization. In addition to application development, I provided technical support to internal employees, troubleshooting and resolving issues with company hardware and software. My responsibilities included diagnosing network connectivity problems, resolving software errors, and assisting with the setup of computers and mobile devices. Throughout the internship, I ensured that all technical issues were handled promptly, delivering excellent customer service to ensure minimal downtime for end-users. This experience honed my skills in IT support, system administration, and customer service within a corporate environment.