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.• Managed workflows with Atlassian Jira, documented processes in Confluence, and facilitated automated deployments with CircleCI.• Delivered Level 1 production support and created comprehensive runbooks for knowledge transfer.

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 processing.• Led the migration of a legacy data warehouse (~500 GB) from AWS Redshift to Snowflake, enhancing data management capabilities • Replaced legacy Airflow processes with Stitch to load data from various sources including GitHub, Marketo, and Salesforce, ensuring efficient data pipelines.• Created user accounts and managed permissions for production processes, optimizing access and security.

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.• Reviewed query plans and optimized stored procedure logic for improved performance on Tibco and DB2 servers.• Provided weekend production support and coordinated with on-shore and off-shore teams.

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.• Collaborated with users to create SQL queries for both ad-hoc and production database needs.

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.• Created and maintained over 12,000 Autosys jobs in production and QA environments.• Developed Runbooks for near-shore and off-shore Level 1 production support, ensuring comprehensive documentation.• Tracked and developed bug fixes and new projects through the release process, collaborating with developers, project managers, and support teams.

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