Lilly Claro

  TECHNOLOGY

Programming Languages: SQL, Oracle PLSQL, Perl, Visual Basic, Java applications, Bash
Monitoring Systems: Tibco HAWK, AppDynamics, Splunk
Automation tools: Azure DevOps
Middleware:  Apache, JBoss. Tomcat, Weblogic,

EXPERIENCE:

Wells Fargo (contractor)
Lead Operations Systems Engineer
April 2023 – July 2024
• Supported in developing frameworks to drive automation of the production environment for toil reduction. ]
• Troubleshooted commonly known and basic issues relating to applications and data accuracy using SQL Server and Oracle PLSQL queries. Supported, managed and monitored basic systems, applications and infrastructure solutions, migrations, upgrades, system configurations.
• Responsible for the upkeep, configuration, and reliable operations of Linux and Windows OS, middleware on both on-premise and Azure Cloud. Level 2 application support, maintenance of Autosys jobs that ingest ETL and distributed data, patching, deployments, BCP testing and service outage response.  Responsible for incident/problem management on Service Now and Jira.
• Provisioning/de-provisioning accounts to/from application and system roles.  Coordinated with L1 teams to ensure they had the tools to provide support such as updated playbooks, demos and troubleshooting procedures.  

BNY MELLON (Modis contractor hired as employee), Jersey City NJ
VP - Senior Application Support Specialist
07/2018-04/2023
• . Provided documentation and training to staff and application users.
• L1 & L2 system administration and support of Kafka messaging systems built on Java/RHEL Linux.  Troubleshooting of topics, partitions, replicas, producers, consumers, users and system configuration  
• Resolved Jira and Service Now incidents/Problems and provided Change Management Approvals.
• System upgrades and administration of new systems and maintenance of existing servers. Responsible for onboarding new applications to the support teams using Permit To Operate controls.  
• Performed verifications of all servers after patching ensuring the environment was up and running.
• Ran daily health checks by using Ansible scripts, Grafana, Splunk and AppDynamics monitoring system. Troubleshooting server issues.
• Provided technical and coding support to users, understanding issues and escalated when needed
• Provided level 2 operations and supported Dynamics CRM on Azure Devops, GCP AppEngine. and server migrations


Altice USA (Purchased Cablevision Systems), Bethpage NY
Applications Support Analyst/System Administrator
06/2016-9/2017
• Full systems support on Voice, Data and Application Services Departments.  Maintaining and troubleshooting the front-end interface as well as the middle tier and backend services in Linux/Solaris environment.  
● Solaris migration of DB Reporting servers into Linux.  Upgraded existing Solaris Korn
● Shell scripts, testing to ensure all worked as it did in the Solaris environment once migrated completed.   Technical Lead on Optimum.Com website project.  This entailed working with networking, infrastructure, software and database upgrades and cloud Migration to Adobe Cloud in order to complete the project.  Built new Tomcat,JBoss servers and helped with system architecture.  Won leadership and collaboration company award for this project from the company executives.

Cablevision Systems (Purchased by Altice), Bethpage NY
Applications Support Analyst/System administrator
07/2008-06/2016
● Level 2 support of production, development and UAT environments Approved code and worked with QA/UAT teams prior to deployment to find errors that would affect production environment.
● Designed distributed cluster architecture for Kafka, Zookeeper, RabbitMQ and other messaging systems.
● Installed and maintained monitoring AppDynamics monitoring system for Kafka JMX events.  Created Splunk alerts and Dashboards.
● Supported our Toll-Free applications and services and manually fixed accounts that had not been serviced or provisioned.  I discovered over $100,000 in uncollected funds by performing data analysis and investigation using Oracle PLSQL scripts.
● Created and optimized PLSQL queries to provide temporary fixes to application defects.  
● System administration and support of BEA WebLogic, JBoss and Tomcat middleware connecting our Amdocs CRM, EPC and Sales Engine applications to the Oracle database.
● System Administrator and supported Tibco BPM applications, IProcess and EMS    
● Migration from Solaris to RHEL Linux.  Upgraded Korn shell scripts to resolve incompatibilities with Linux operating system.
● Responsible for reporting server performance and capacity planning to management monthly.
● Liaise with developers, networking, security and project management to ensure new Java applications had network connectivity, database connections, DNS names, SSL Certs, Splunk monitoring and connectivity to F5 load balancers.   
● Wrote technical documentation to train L1 team to support new applications.  

Goldman Sachs, New York     
Systems Analyst, Application Support
10/2006-06/2008
● Managed research application deployments of global applications and weekly ad hoc releases in Linux environment
● Planned and coordinated installation of Citrix NetScaler used by production and QA environments and assisted in planning fast failover procedures.
● Coordinated hardware maintenance and operating system upgrades.  
● Kept statistics of incoming incidents using Excel macros and presented them to management weekly.
● Wrote Perl scripts that served as support tools for the team.
● Provided Level 2 business client support of research Java applications. This required investigating the workflow in Unix and databases to resolve lags and troubleshooting exceptions thrown by java processes.  
● Updated stored procedures and SQL scripts with new business requirements as companies were initiated.
● Maintained and supported UAT and production environment on JBoss middleware that connected Sybase database.
● Provided weekend, off-hour and on-call follow-the-sun support on Linux and Windows servers.   


EDUCATION:

Devry University
Software Development with a focus on Big Data
Bachelors in Science
2024-in progress

Chubb Institute of Technology, New York, NY
Computer Programming
Trade School Diploma
1998-2000

La Guardia Community College, LIC, NY
Business administration and accounting
Associates in Applied Science
1991-1998

CERTIFICATIONS:
AZ-900 MICROSOFT AZURE CLOUD FUNDAMENTALS
DP-900 MICROSOFT AZURE DATA FUNDAMENTALS
GOOGLE CLOUD DIGITAL LEADER
AWS CLOUD PRACTITIONER BADGE