Edward Schug Email & Phone Number

New York, United States

• Developed and optimized data pipelines with Matillion and Airflow, maintaining code in GitHub and utilizing CircleCI for seamless migrations.
• Led the monthly data reconciliation process for a major client, ensuring accuracy and reliability.
• Enhanced database management by implementing efficient multi-gigabyte data purging processes.
• Created application usage reports using Splunk and SQL, delivering insights on system performance.
• Provided support for applications across AWS and GCP, ensuring high availability and performance.
• Resolved data gaps and inconsistencies in production systems to uphold data integrity.

New York, United States

• Maintained and updated AWS cloud infrastructure as part of the DevOps team, utilizing Docker, Kubernetes, Helm, Terraform, and AWS CLI.
• Implemented systems monitoring with New Relic, Kibana, and Elastic Search to ensure performance and reliability.
• Developed internal tooling and automation using Retool to streamline workflows.
• Utilized Atlassian Jira for project tracking and workflow management and maintained comprehensive documentation in Confluence.
• Managed continuous integration of GitHub commits with Travis CI, successfully migrating multiple repositories to GitHub Actions to improve concurrency while leveraging no-copy-clone features for efficient data.
• Led the migration of a legacy data warehouse (~500 GB) from AWS Redshift to Snowflake, enhancing data management capabilities

Greater New York City Area

• Developed and supported stored procedures and infrastructure for front-office trade data reporting applications at Morgan Stanley, leveraging Tibco data virtualization.
• Facilitated access to trade, booking, client, and reference data for equity and fixed-income products via Tibco stored procedures querying Sybase, DB2, and Greenplum servers.
• Created control databases for system metadata management, Autosys jobs, and automated tooling using Perl and Python within an Agile Scrum team.
• Managed production deployments from QA to pre-prod and production environments using Jira, including runbook creation, testing documentation, and release coordination with off-shore teams.
• Utilized internal migration tools for Sybase and DB2, Tibco utilities for stored procedure migration, and Jenkins/Perforce for version control.
• Collaborated with users to refine requirements for new applications and created online documentation on the department Twiki.

Jersey City, New Jersey

• Developed and supported DB2, MS SQL, and Sybase databases for ARCTIC, Credit, and FROST systems at Bank of America/Merrill Lynch.
• Updated batch processes to align with BAU requirements and decommissioned Sybase servers, transitioning to MS SQL and DB2.
• Developed a Data Quality Management (DQM) system on DB2 using Informatica Data Analyzer to enhance data integrity.
• Implemented MS SQL Server database compression and updated process flow diagrams (Visio) and Runbooks to reflect changes.
• Created and managed Autosys systems for process modifications and coordinated user change requests.
• Developed release packages for migrating process changes through development, QA, and production environments.

New York, United States

• Developed and provided Level 2/Level 3 support for regional and global trade surveillance models using Actimize Intelligence Server and Case Manager, including Front-Running and Wash Trades.
• Automated data feed processes for trades, market, account, and product data from flat files, WebSphere, and Reuters using Informatica, ksh, and Perl scripts.
• Designed and developed database objects (tables, stored procedures, triggers) while providing support for performance tuning and maintenance on Sybase and DB2 servers.
• Managed multiple environments, including integration, QA, UAT, and production, ensuring smooth transitions and stability.
• Collaborated with internal teams such as Unix ops, Windows ops, and Autosys ops for enhanced operational efficiency.
• Migrated scripts and processes from integration and QA to production environments, maintaining code branches with Perforce.

New Jersey, United States

• Developed and maintained multiple CRM systems for nationwide pharmaceutical sales forces at Innovex (now IQVIA).
• Implemented two-way replication between client laptops using Sybase ASA and back-office Sybase ASE.
• Managed periodic territory realignments and replication definitions to ensure data accuracy.
• Provided summary and trending reports to senior management for strategic decision-making.

Bsce

Mce