Sr production support

Ayushi Desai

** ********* ******, ****** ****, NJ 07306 +1-347-***-**** ************@*****.***

Education

Master of Science in Information Systems – Pace University, New York, NY August 2015 - August 2017 Bachelor of Engineering in Information Technology -- University of Mumbai, Mumbai August 2011 - August 2014 Skills

• Languages: SQL (V12.0), PL/SQL, TSQL, Perl, HTML, KSH, PowerShell, Linux/Unix Scripting, Python, Java

• Business Tools: Microsoft Visio, Microsoft Access, Tableau, Jira, SharePoint, SAP Business Objects 4.0, Microsoft Office 365, Splunk, PROCOMON, Autosys, ServiceNow, Grafana

• Databases: SQL, TSQL, Oracle (12c,19g), Microsoft Access, SQL Server, Database tuning, Azure

• Analytical Skills: Requirement gathering, Scrum, ETL process, SQL Loader, data analysis, ServiceNow, RCA, incident management, change management, ITIL process, AWS EC2, S3, CloudWatch, Lambda Professional Experience

Sr. Application Support Developer – Global Atlantic Financial Group, New York NY August 2023 - March 2025

• Optimized Oracle PL/SQL web application database performance. Rewrote Packages, Stored Procedures.

• Deployed code and package changes to production and managed UNIX back-end processes.

• Assisted Data Management with Tidal job deployment issues.

• Developed new report distribution and user/client update functions using Oracle SQL.

• Provided Level 2 production support for FX trading (spot, forward, options) using Reuters and FXall platforms.

• Built SPLUNK dashboards for server and log monitoring per client requirements.

• Created documentation for performance testing and managed bug reporting; used Crontab for batch scheduling.

• Wrote and debugged Unix Korn Shell scripts for data manipulation and loading.

• Designed tables, stored procedures, and triggers in Oracle.

• Handled production support and manual data repair with direct SQL. Maintained build scripts in Windows.

• Developed error-trapping routines in Unix Korn Shell. Filtered and loaded cross-database data using Oracle PL/SQL.

• Designed and tested AutoSys and UNIX shell job scripts.

• Monitored and supported Control-M and Tidal Schedulers across UNIX and Windows platforms.

• Collaborated with vendors and internal teams to enhance FX trading systems and infrastructure.

• Designed, implemented, and supported Linux servers. Built ServiceNow dashboard for ticket analysis.

• Wrote PL/SQL scripts to analyze data integrity and resolve inconsistencies. Sr. Application Support Developer – Credit Suisse, New York NY May 2022 - July 2023

• Developed and maintained CloudFormation scripts, automating the provisioning of AWS resources including EC2 and S3.

• Updated existing modules and implemented new features by developing Python scripts.

• Created and executed Linux shell scripts to facilitate data migration between environments as required.

• Provided training and troubleshooting support within the production support team.

• Utilized GitHub for version control and deployed code to AWS Lambda.

• Managed and scheduled production and test jobs and events using Control-M and Tidal Job Schedulers, and prepared runbook instructions for job restarts.

• Assisted in the design and automation of core scripts for SPLUNK maintenance and alerting tasks; contributed to overall Change Management, Incident Management, Problem Management, and ITIL process implementation.

• Designed and developed ETL mappings and processes using Informatica. Supported maintenance releases for production environment stability.

• Responsible for capacity planning, space management, problem resolution, database monitoring, and performance tuning of production databases.

• Monitored production cycles via Control-M and Tidal Schedulers, interfacing with UNIX and Windows to meet SLAs.

• Developed ServiceNow dashboards for ticket trend analysis and rapid issue resolution, maintaining robust Python scripts to parse diverse unstructured invoice data.

• Designed tables, indexes, and constraints using SQL*Plus, and loaded data into databases with SQL*Loader. Sr. Application Developer – Geode Capital Management, Boston, MA September 2021 - May 2022

• Delivered ad-hoc reporting for database record changes and intraday trade updates per client requests.

• Supported End-to-End Equities Market UAT and automated recurring tasks to reduce costs.

• Automated data validation and loading using Unix shell scripting.

• Translated business requirements into functional specifications in collaboration with stakeholders.

• Utilized Oracle PL/SQL for efficient data filtering and loading from production databases.

• Debugged JAVA and R codebases alongside technical teams.

• Used Cron Tab to troubleshoot and implement Linux batch scripts.

• Developed performance testing documentation and provided production support, logging issues in JIRA and ServiceNow.

• Validated and committed code changes using GitHub and regular expressions.

• Created integration scripts for JIRA with Eclipse and Spotify.

• Resolved daily production incidents using shell scripts and ad-hoc reporting.

• Monitored operational performance with SPLUNK, loggers, and connectors.

• Deployed code updates on UNIX and LINUX platforms in production. Sr. Production Developer – T.Rowe Price LLC, New York, NY September 2020 – September 2021

• Produced and delivered ad-hoc reports based on client requests to insert, update, or delete records in databases, facilitating trade changes during intraday operations. Provided comprehensive support for End-to-End Equities Market UAT environments and automated recurring tasks to optimize costs.

• Developed a monitoring framework utilizing Python, Perl, and HTML, and generated various SLA reports in alignment with business requirements.

• Designed advanced SQL queries and stored procedures to produce data reports, ensuring timely delivery in production environments.

• Successfully onboarded four equities applications, including EAGLE App, Front Office DB, Unity, and MS (Research Management System), by establishing comprehensive end-to-end plans encompassing AutoSys job configuration, documentation, and alert modifications to promptly notify the EASE team during failures, with adequate provisioning.

• Implemented a serverless architecture leveraging API Gateway, Lambda, and DynamoDB, and managed AWS Lambda code deployments from Amazon S3 buckets. Created Lambda deployment functions and configured event triggers from S3 buckets.

• Optimized developer workflows for efficient delivery of small-scale serverless applications, utilizing a Lambda-based platform comprising both pipeline and runtime components.

• Employed CloudWatch to monitor CPU utilization and system memory of AWS EC2 instances.

• Collaborated closely with the Kafka Administration team to establish Kafka cluster modules in both QA and Production environments.

Sr. Production/App developer – Goldman Sachs, Salt Lake City, Utha January 2019 – August 2020

• Maintained Equity Plan tops production system using job scheduling tools (Autosys, Promon, JIRA) and automated support tools with shell scripting.

• Diagnosed and resolved JAVA application, Tomcat, and Apache server issues on Linux to ensure system stability and efficiency.

• Developed a core automation app in UNIX to structure unorganized business data, reducing operations time andcost.

• Supported multiple 2-3 tier applications for over 300 users, with Oracle and SQL Server backends; analyzed logs and monitored application health.

• Designed and implemented batch processes for OMS on Linux, including global match management tools using shell scripts and Perl.

• Partnered with internal clients to set SLAs and developed compliance reports.

• Applied SEMI Standards protocol for factory automation, improving noise alert accuracy by 50%.

• Ensured all production changes followed Goldman Sachs compliance standards, including rigorous pre-prod validation and change approval processes.

Associate Application Developer – Tufts Health Plan, Boston, MA November 2017 – December 2018

• Developed complex PL/SQL database objects (functions, packages, procedures, triggers).

• Collaborated with business operations to resolve application failures and support HealthEdge.

• Designed and developed ETL processes to move Salesforce data to Redshift data marts.

• Fixed bugs and generated Salesforce reports in the ticketing system.

• Provided system administration for Oracle, MySQL, Apache, Tomcat, and Splunk applications.

• Automated HRP Application processes with shell, Perl, and Java scripts.

• Managed Salesforce administration, including profiles, roles, security, customizations, workflows, dashboards, and reports.

• Supported HealthRules Payor Application by coding dynamic SQLs in Oracle 11g during failures.

• Analyzed and exported Salesforce member data for comparison between Express and HRP apps.

Contact this candidate