Mark Greenstein
Verified Expert in Engineering
Database Engineer and Developer
New York, NY, United States
Toptal member since May 30, 2024
Mark is an experienced data professional specializing in data analytics, system integration, and database management. He offers expert consulting, tailors bespoke solutions, and delivers actionable insights derived from data to inform strategic decisions. Mark's proficiency spans SQL Server, Oracle, Visual Basic for Applications (VBA), SQL Server Reporting Services (SSRS), Microsoft Power BI, and Power Query.
Portfolio
Experience
- Data Analysis - 12 years
- SQL - 12 years
- IT Business Analysis - 12 years
- Investran - 10 years
- Visual Basic for Applications (VBA) - 10 years
- Microsoft Excel - 10 years
- SQL Server Reporting Services (SSRS) - 7 years
- Power Query - 4 years
Preferred Environment
Visual Basic for Applications (VBA), SQL, SQL Server Reporting Services (SSRS), Power Query, Microsoft Excel, Transact-SQL (T-SQL), Databricks, Spark
The most amazing...
...thing I've done is deconstruct a business process and leverage VBA and SQL to reduce the workload by the equivalent of two months of full-time employee effort.
Work Experience
Managing Member
Self-employed
- Delivered data-backed solutions for an M&A advisory group, managed Salesforce CRM data migration, analyzed AI's effects on finance, and deployed mobile device management (MDM) systems for an investment bank client.
- Developed VBA and SSRS custom solutions, leveraging APIs for data migration and reporting for a venture capital client.
- Designed and implemented custom apps and reports, oversaw data feeds and partner relations, and co-managed disaster recovery for private equity investor relations.
Senior Consultant
Lionpoint Group
- Advised the alternative investment sector on strategy, operations, and technology.
- Participated in multiple projects related to operational transformation, technology strategy, system implementation, data cleansing and migration, system integration, data governance, reporting, and analytics.
- Managed 15 client relationships within the financial service sector.
Business Analyst
Apollo Global Management
- Supported fund accounting and investor reporting systems, including vendor products like Investran and custom applications, by designing and implementing tailored solutions.
- Designed and implemented databases for custom applications, encompassing schema design, stored procedures, functions, triggers, and dynamic SQL execution.
- Created custom reporting packages using APIs and SQL to extract and format data for VBA analysis and reporting.
- Conducted system upgrades, verified front- and back-end integrity, integrated systems, and developed documentation and training for end users and operations.
Business Analyst
Citi
- Gathered business requirements, analyzed 3rd-party vendor data, and provided detailed specifications for data processing and implementation of a golden copy of financial instruments.
- Analyzed, mapped, and validated data using SQL to ensure accurate ETL changes and client onboarding implementation.
- Headed the change management process for internally developed applications and resolved issues to ensure software delivery.
- Provided comprehensive documentation necessary for software development lifecycle, covering technical specifications, user guides, release notes, and test cases for user acceptance testing.
Experience
Custom Reporting Package
Education
Bachelor's Degree in Civil Engineering
University of Delaware - Newark, DE, United States
Skills
Tools
Microsoft Excel, Power Query, Microsoft Power BI
Languages
Visual Basic for Applications (VBA), SQL, Excel VBA, Transact-SQL (T-SQL)
Storage
SQL Server Reporting Services (SSRS)
Frameworks
Spark
Platforms
Databricks
Other
Investran, Data Analysis, IT Business Analysis, Custom Solutions, Complex Problem Solving
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring