Stephen Baron
Brooklyn,NY
Summary
Data Analyst with 5+ years of experience analyzing large datasets, developing Power BI dashboards, automating reporting, and translating data into actionable insights for business stakeholders. Experienced with SQL, Power Query, DAX, Excel, APIs, data quality, KPI reporting, and cross-functional analytics. Skilled at identifying trends and communicating findings to support strategic and operational decision-making.
Overview
7
7
years of professional experience
Work History
Data Analyst and Data Visualizations
MTA Headquarters
09.2020 - Current
• Manage and collaborate with an analytics team of 2 for analyzing large datasets for reporting solutions to support high level managers, field operations, and stakeholder’s requests for the MTA Homeless Program Office.
• Designed and maintained Power BI dashboards and recurring KPI reporting to analyze large datasets, identify trends, monitor performance, and provide actionable insights to senior leadership and business stakeholders.
• Managed and maintained large datasets utilizing Power BI ETL Power Query tool for ETL, Dax calculations, and API connections form data stored in various sources such as Microsoft Excel, Azure, and ArcGIS.
• Prepare senior level reporting and presentations to outline analysis based on business requirements for strategic planning, enhancing data accessibility and driving an increase in strategic decision-making efficiency for analytical solutions.
• Revamped data collection and storage processes using Microsoft SharePoint, resulting in 30% faster data retrieval enhancing operational efficiency by 40%.
• Engineered a comprehensive homeless train survey data management app, Complaint Tracking Systems, and workflow processes using Microsoft Power Apps, improving data collection accuracy by 60%
• Created flows in Microsoft Power Automate to streamline task automation, update datasets, and generate custom automated reports.
Database Back-End Database
Tictic Inc.
11.2019 - 01.2020
· Revamped the application database ERD, enhancing data retrieval and improving table relationships.
· Audit and update all tables and fields for data redundancy, consistency, and data quality.
· Developed SQL queries for manipulating tables in the database using phpMyAdmin platform.
· Audit and update store procedures to comply with APIs.
· Streamlined database schemas, cutting down table sizes by 35% and reducing join complexity, which accelerated data retrieval by 30%.
· Created and managed execution plan for making changes to the application and database.
Information Technology Specialist
Bethpage Garden OBGYN
11.2019 - 11.2019
- Received and managed tickets using custom ticketing system software.
It Specialist management technical support and customer support services for all offices.
Manage Nactel phone systems support.
Maintained and service office printers, faxes, and scanners.
Education
Bachelor of Science - Computer Information Systems
New York City College of Technology
Brooklyn, NY06-2020
Skills
- SQL & Databases: PL/SQL, DML, DDL, SQL Server, Oracle SQL Developer, database design, views, stored procedures, complex queries, indexing, and data modeling
- Data Analytics & Visualization: Power BI, Tableau, Weka, data visualization, reporting, dashboard development, and data analysis
- Excel: Proficient with formulas, PivotTables, data analysis, and reporting
- Programming: Python and Java application development
- Web Development: HTML, CSS, PHP, and web application design and development
- Database Modeling: UML diagrams, database schemas, data relationships, and Neo4j graph databases
- Microsoft Technologies: Microsoft Office Suite, Microsoft SQL Server, Power BI, and Excel
- Development Tools: NetBeans, Komodo, Oracle SQL Developer, and Weka
- Technical Support: 2 years of experience in computer hardware/software troubleshooting and IT support
Timeline
Data Analyst and Data Visualizations
MTA Headquarters
09.2020 - Current
Database Back-End Database
Tictic Inc.
11.2019 - 01.2020
Information Technology Specialist
Bethpage Garden OBGYN
11.2019 - 11.2019
Bachelor of Science - Computer Information Systems
New York City College of Technology
PROJECTS
Banking Transaction Management System Database Application
· Built Banking application to automate the management of customers information, banking transactions, bank accounts, and banking locations such as branches and ATM machines.
· Using the project management methodology to design, implement and maintain the application.
· Created a conceptual ER and EER diagram that demonstrates the design of the database schemas and the relationships of each entity.
· Designed a normalized logical model that depicts the design approach that minimizes data redundancy and optimizes data structures.
· Built a Data dictionary and used DML and DDL to implement the database application on Oracle SQL Server.
· Created Store Procedures to manage and update data for application.
· Build reports based on data and business requirements for making analytical decisions.
Microsoft SQL Server/ Database Administrator
. Assigned roles, permissions to users, and implementing security.
· Created views, indexes, and store procedures to generate reports.
· Developed and executed DBA scripts, enhancing database maintenance, resulting in a 20% speed increase in report generation.
· Scripted Transaction SQL using Rollbacks and commits.
· Implemented and designed Banking System with security features and backups.