It Production Support Analyst Resume
3.00/5 (Submit Your Rating)
NC
SUMMARY
- Provided L1/L2 support for prime brokerage applications (Unix and Window)
- Responded to all user issues/queries within published timeframes
- Monitored application logs and infrastructure capacity using ITRS Geneos
- Monitored/managed jobs using Autosys
- Created and updated support noledge on Confluence
- Coordinated with DBA, development, deployment teams to perform weekend releases deployed into Unix and Window servers
- Liaised with internal development teams to accurately report on users’ requests and incidents that require software changes
TECHNICAL SKILLS
- Excel, ADP ReportSmith, SQL, PL/SQL, Unix/Linux, Ctrl - M, ITRS Geneos
- Languages - Chinese, Japanese (conversational level)
PROFESSIONAL EXPERIENCE
Confidential, NC
IT Production Support Analyst
Responsibilities:
- Provided L2 support for regulatory reporting applications (Unix and Windows)
- Troubleshot data quality issues on AxiomSL and Ctrl - m job failures
- Responded to all user issues/queries within published timeframes
- Monitored, managed and scheduled jobs using Ctrl-m to ensure SLA adherence
- Created and updated support noledge documents on SharePoint
- Liaised with internal development teams to accurately report on incidents requiring software changes
- Performed weekend support for releases, upgrades, and DR/BCP tests
- Created PowerPoint presentations for monthly matrix
- Reported on problems and incidents using Service Now
- Debugged PL-SQL codes to resolve data quality issue
- Ran ad-hoc reports and inserted/updated users’ info using SQL queries
Confidential, NY
Payroll Reporting Analyst (seasonal)
Responsibilities:
- Communicated with end users to ensure that all requirements and criteria are fully understood
- Ran payroll and headcount analytics reports for 50,000 US employees by creating simple to complex SQL queries involving self joins, correlated sub-queries in ReportSmith
- Ensured the accuracy and relevancy of information in the report with Excel formulas (vlookup, match &index, advanced filter etc.)
- Ensured the information is accurately reflected in ADP Enterprise
- Restructured Excel worksheet information with Pivot Table based on users’ preferences
- Wrote VBA scripts to speed processes and maximize accuracy of creating and reviewing reports
Confidential, NY
Application Support Analyst Trainee
Responsibilities:
- Created complex SQL queries to extract data for reporting
- Used shell scripting to create a safer command that persists deleted files to a recycle bin
- Used sorting, filtering and data manipulation functions of Excel to perform an extensive data cleanse and produced reports using Pivot Tables and Pivot Charts