Data Management Engineer
Resume:
Anthony (Tony) Christi
********.***@*****.***
Professional Summary
Seasoned IT professional with over 25 years of experience in data management, database development, and analysis.
Technical / Application / Database
Data Migrations
Property & Casualty
Labor Relations; Legal & EEO
Construction Development (MTA)
Supported Departments, Divisions
Financial support reporting
Studio Enterprise Account RMS
Data Management,
RDBMS Data Management (Redpoint)
Identifying Issues / Resolving Issues
UAT, User Interaction; Implementation
Generated Reports Auditing
BI Information Support
Strong Analytical
Worked on Large Databases
Past Activities, Trends, Tableau
Analyzed Data
Problem Solver
MS Access / VBA.
SQL, SSMS
Excel, Pivot Tables
ServiceNow
Financial Forecasting Reports
PowerPoint, Toad
Professional Experience
FFTP- Non Profit Organization in FLORIDA (REMOTE) MARCH 2021 TO Present
Data Engineer / Developer & Report Specialist
Spearheaded the redesign of data processing systems using Redpoint RDBMS, enhancing efficiency and handling large files of data sets. Reported on Current Trends, Loss to Value (LTV), Weekly, & Monthly Department Counts.
Automated P&L reporting implementing SQL, MS Access and Developed SQL Scripts and procedures in-depth technical database analysis, generating critical reports. Loss to Value Account reporting. Telephone Updates.
Interacted with outside vendors, BCC providing Co-Op Vendor File Transfer FTP, and correspondence.
Provided SQL Scripts and RDBMS output files to Business Information Team (BI) in support to User Community.
Authored an Audit SQL script within DMS to identify data faults, data validations, data quality issues, enhancing data integrity and reducing redundancy data. Developed Solutions to current Challenges by providing Audit Report CSV and converting to Server files.
Summarized data for generating Statistical and Analytical reports to data governance initiatives support.
Authored SQL scripts and utilized Access VBA Code and Excel to create advanced reporting tools, including Pivot Tables and VLOOKUPs, for weekly insights.
Generated, maintained and distributed periodic and ad hoc reports.
Developed and implemented databases and data collection system Data Analytical TEAM accessing RMS for Record Validations.
Conducted training sessions on efficient SQL coding, SSMS navigation, and data management best practices.
Manhattan Transit Authority (MTA), New York, New York Jun 2016 TO Jul 2020
Project Lead Data Engineer / Developer & Report Specialist,Report Specialist SQL, MS Access
Led the migration and redesign of legacy database applications to Windows 10 and MS Access 2016, ensuring seamless UAT testing and implementation while enhancing data integrity and productivity.
Developed a database application for technicians’ deployments, trouble reports and completions, interfacing with multiple data structures and improving operational reporting.
Supported Labor Relations by adapting applications for program changes and enhancements, contributing to efficient management of Drug Programs and Holiday observances.
Played a key role in monitoring and analyzing data integrity issues, conducting root cause analysis across various MTA divisions, and improving data sharing and reporting processes.
ServiceNow - Worked with Team to predict future trends and shape strategic.
I was able to effectively communicate complex data analysis, understand their issues with problems and correct their Database Issues. Modified numerous Database systems for Labor, Financial, Railroad Systems, Bridge departments,
NYC hurricane sandy, New York, New York Jan 2015 TO Jun 2016
Data Engineer / Data Analytics / Developer & Report Specialist Microsoft Access
Managed critical reporting for Construction Work Orders; grants; reports; work status, ensuring accurate and timely d delivery to support reconstruction efforts.
Innovated within database applications, leading to improved team contributions and problem-solving capabilities.
Aligned, scrubbed, and linked data through ETL processes, enhancing data integrity and facilitating accurate reporting.
PepsiCo, purchase, New York Jul 2005 TO Jan 2015
Project Lead Data Engineer / Developer & Report Specialist
Created and managed multiple departmental Matrix & Scoring Reports, streamlining data analysis and reporting functions.
Served as a technical liaison within the Treasury Department, reconciling claims and insurances cases, and facilitating data linkage and ETL processes for accurate source data identification.
Collaborated with security personnel to develop a Global Security (SCAT) for beverage plants, improving security measures across international bottling plants.
Designed a production reporting application for Quality Control International, enhancing the timing capture process for beverage production.
Property Insurance assisting the Treasury Department investing and seeking out improvement opportunities for reducing Insurance Premiums.
Previous Professional Experience
Lehman brothers, New York, New York Jun 2004 TO Jul 2005
Project Lead Data Engineer / Developer & Report Specialist,Financial Reporting
Developed critical sales and statistical reporting tools for International Group Managers, enhancing year-end review processes. Visual Data Analyst using MS Access.
Created a Travel & Expense database for reporting statistics and awareness reports.
Developed mappings in Informatics and tested batch workflows using SQL to import multiple data structures.
Memorial Sloane Kettering, New York, New York Jan 2004 TO Jun 2004
Project Lead Data Engineer / Developer & Report Specialist MS Access, SQL
Developed and implemented a procurement system that significantly reduced annual costs through efficient data management and reporting.
GE capital, Stamford, ct. Jun 1996 TO Jan 2004
Project Lead Data Engineer / Developer & Report Specialist MS Access, SQL, TOAD Design AGILE
As a Business Analyst I provided innovation by providing solutions to multiple departments, including Legal, HR, Sourcing, through custom database applications and data analysis.
Sourcing – Developed Asset Management named STARTRAC, application. I designed, implemented, and trained personnel on the STARTRAC System. This system contained a warehouse depository for all payable transactions. Spend trends by suppliers, commodities, departments, etc. Main purpose was to be used as a tool by the Sourcing Department to look for opportunities for savings.
Developed an in-house Facility Management database Application incorporating alert indicators, reports, and quick lookup statistics. In addition to Asset Management & Leasing Management applications.
Assisted with SQL Scripts creating SQL Queries to Business Information Team (BI) in support to Dept Power Users.
Technical Expertise
Software: MS Access; SQL; SSMS; VBA; Tableau; Microsoft Products; Data Management Development.
Project Leader for Software Migrations & Conversions; Data Linkage, Scrubbing & Alignment; Reduce Data Redundancy; Q&A; UAT.
Certificates
New York School of Computer Technology; US Air Force Computer Training;
Contact this candidate