Daniel Marcus Email & Phone Number

New York, NY, US

New York, NY, US

New York, NY, US

New York, NY, US

• DBA for all company PostgreSQL AWS RDS databases
• Reviewed developer PostgreSQL PRs and suggested code adjustments to maintain high back end performance of all services
• Optimized PostgreSQL code called throughout the tech stack by adding parameters to functions, rewriting heavy views, removing unneeded dependencies on plpgsql, adjusting indexes, and introducing optimizer hints where.
• Set up OpenSearch instance of ES on AWS and installed/configured Filebeat on 20+ Linux boxes to pull critical logs into Kibana per stakeholder specifications
• Created preprocessing pipeline for Filebeat data to parse raw log information into usable fields using grok matching patterns and custom Painless scripts
• Worked with stakeholders to create useful data visualizations in Kibana and set up alerting process to identify when issues arise on a box

New York, NY, US

• Maintained and managed complex Jenkins ETL pipeline delivering critical, time sensitive Operational Efficiency data to business stakeholders
• Created multiple T-SQL Stored Procedures involving looping, dynamic SQL, and complex conditional logic used to transform data from raw form into format needed for ingestion into Qlik Sense applications
• Created archive process for key production SQL tables and deployed process with no user downtime and transparent logging to monitor progress
• Continuously optimized back end processes by monitoring logical reads, adjusting indexes, and materializing sub-queries to improve performance as data volumes increase
• Created and taught classes 'SQL Server for the Bloomberg Business Professional' and 'T-SQL Optimization Techniques and Tricks' to help up-skill colleagues on their T-SQL skills
• Developed sustainable, scalable process for pulling unstructured data from Hive into Qlik Sense, involving exploding JSON array fields into name value pair records and repivoting to consume incrementally on the Qlik.

New York, NY, US

• Developed back end (SQL Server) and front end of Qlik Sense BI applications aimed at improving worker efficiency across the organization
• Created manual version control process to allow multiple users to develop Qlik Sense applications simultaneously without stepping on each other’s code
• Regularly performed Qlik Sense releases from QA to Production environment
• Performed extensive troubleshooting through all data layers of application to identify and address causes of missing or incorrect data
• Optimized stored procedures to improve application reload times by analyzing SQL Server logical reads and execution plans
• Performed QA on teammates’ code changes and identified issues to be addressed

Norwalk, CT, US

• Client: The Medicines Company, Parsippany NJ
• Created complex SSIS dataflows in Visual Studio involving lookups, conditional logic, sql tasks, dynamic connection managers and multiple parameters/variables
• Supported sales team with ad hoc queries and automated weekly reports run through SQL Server Agent
• Performed database backup/restores on local and cloud servers
• Migrated local SSIS integration packages to SAP S/4HANA Cloud Integration Platform
• Developed and maintained SSRS reports using Visual Studio

South Plainfield, New Jersey, US

• Wrote fTbl functions and stored procedures used in our client facing application involving advanced conditional logic, multiple loops, and customized string parsers
• Created automated jobs to pull data from DB at regular intervals and scheduled delivery to stakeholders via SQL Server Agent using SQL Server Email and Command Shell BCP functionalities
• Wrote and automated stored procedures used for regular database cleanup and maintenance tasks
• Regularly performed database staging and production releases
• Wrote data conversion scripts to assist onboarding team in quickly absorbing and integrating new client data
• Used SQL Server Profiler to identify and fix application issues in all environments and performed hot fixes to production

Denver, CO, US

• Performed full migration of internal corporate data from Microstrategy BI Tool to Looker
• Turned specific data requests from various internal teams into Looker dashboards, charts, and graphs with filterable inputs
• Wrote SQL to generate complex persistent derived tables in Looker from tables in attached MySQL and Redshift databases and scheduled these tables to rebuild nightly
• Supported internal and external clients with ad hoc data pulls, Looker 'Look' creations, and daily email scheduling
• Educated fellow colleagues and supervisors on Looker functionality and usage

New York, NY, US

• Wrote scripts to pull data from Vertica and Oracle dbs into SQL Server environment for multiple reporting tools to access
• Applied user specific calculations and logic to imported data sets and assisted users in making sense of this data
• Created dynamic reports returning different data sets depending on run date
• Wrote and adjusted complex stored procedures with multiple case statements and joins
• Rewrote old quarterly data code to change dynamically, eliminating the need for manual quarterly code updates
• Wrote code to automate reports that were previously made in excel with pivot tables and vlookup formulas

Armonk, New York, US

• Imported raw client excel files into SQL Server and cleaned up data to account for misspellings and name variations
• Mapped imported data to existing DB tables and modified fields to meet table requirements
• Created stored procedures and fVal functions to increase data conversion speed and accuracy
• Developed custom validation scripts to check converted data for accuracy against raw files