Systems Analyst

Jack Yuen

*** * **** *****

Chicago, IL *****

Phone: 773-***-****

Email: ******@*****.***

Objective: Seeking relevant permanent Application Development role. Script Languages: T-SQL, ASP.NET, Java-Script, HTML 5 Operating System: Windows 2012/2008 Server, Windows Vista, Windows 11, Windows 7, PowerShell, Active Directory

Software: SQL Server 2014/2016, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), Reports Builder, Microsoft IIS, Microsoft VISIO, Microsoft Visual Studio 2019, Adobe Photoshop, Microsoft Office, Microsoft SharePoint 2010, Amazon AWS Cloud, ChatGPT

St. Bernard Hospital

Systems Analyst: September 2017 – current

Develops and Implements SQL scripts to extract patient data and integrate it into SSRS reports used hospital-wide.

Manages end-to-end Projects in collaboration with vendors, including database creation, code testing, data verification, database backup and restoration, and granting appropriate database access to user groups.

Automates Processes using SSIS and SQL Server – including creating scheduled jobs and configuring email notifications for task completion.

Performs Data manipulation and Transformation between internal databases and external vendor systems using SSIS to ensure seamless data integration.

Designs and Maintains the Hospital Intranet using ASP.NET, C# and CSS, including creating a management directory, personnel forms, placeholder links, and migrating web pages and functionalities from previous intranet versions.

Provides Technical Support for the hospital’s AmTelco phone system application, coordinating software upgrades with vendors and ensuring all features are fully functional post-upgrade.

E-Financial/Fidelity Life Insurance

Application Support: February 2016 – August 2017

Troubleshooted and Resolved System-wide issues across the enterprise, ensuring minimal downtime and optimal performance.

Monitored Processes using SSH and Remote Desktop to maintain system stability and address potential issues proactively.

Collaborated with internal Sales Agents, external groups, and vendors to identify and resolve issues, ensuring seamless communication and effective problem resolution.

Worked closely with the Help Desk Support team to address and resolve break-fix issues, providing timely and efficient solutions.

Developed and Updated process documentation to reflect changes in practices and ensure accurate and up-to-date procedures.

Created ad-hoc SQL scripts to retrieve and analyze client and Sales Agent information, supporting data-driven decision-making.

Leveraged Amazon AWS cloud-based environments to access and retrieve historical insurance data for analysis and reporting.

Managed Data Migration – Importing and Exporting data between Access and SQL Server databases, ensuring data integrity and accuracy.

Chicago Public Schools

SQL Server Database Administrator: May 2013 – July 2015

Oversee the improvement and maintenance of databases – including rollouts, upgrades, and ensuring optimal performance.

Manage Backup & Restore operations in SQL Server 2008 R2, 2012 and 2014: o Investigating and resolving database blocking issues. o Creating and troubleshooting jobs to backup and restore databases across Development, QA, and Production environments.

o Troubleshooting SQL Server service and SQL Agent outages. o Restoring Production databases into Development and QA environments for testing purposes.

o Analyzing user roles and granting appropriate database access and permissions through role membership.

Install & Configure new SQL Servers in both stand-alone and clustered environments, ensuring proper setup and functionality.

Manage multiple SQL instances and versions across large-scale systems, maintaining stability and performance.

Deploy Software patches on database and web servers in non-production environments, ensuring thorough testing and bug-free implementation before rollout.

Develop SSIS packages to identify and report failed jobs across dynamic servers.

Create SSRS reports to monitor and retrieve critical metrics such as CPU utilization and database storage from dynamic servers.

Chicago Public Schools

Application Support: October 2006 – May 2013

Developed ad-hoc SQL script to retrieve student information, audit teacher information and historical data.

Deployed SQL code to fix application bugs.

Conducted detailed analysis of all defined systems specifications.

Performed application installation and upgrades using PowerShell scripts.

Analyzed and troubleshoot problems online and on-site.

Managed and Monitored Web servers and internal team database server.

Provisioned user roles and assigned relative application access privileges in Active Directory.

Tracked and Resolved issues to resolution using Peregrine ticket tracking database. iPort Media

Web Content Developer: June 2006 – October 2006

Collected and organized content for web publication.

Worked with scanned or digital photography using Adobe Photoshop CS.

Digitized audio and video files (AVI and MPEG).

Converted video content into FLV format.

Designed appropriate web page templates

Extended, updated, and maintained online content.

Managed existing dedicated web hosting resource to add access restrictions to the Web application.

Daily monitoring of database storage and usage.

Managed database user security.

Imported and exported data from one database to another. JPMorgan Chase (Contract)

QA Test Analyst: October 2005 – June 2006

• Evaluated software requirements and develop test plans and procedures based on business and functional requirements.

• Screen Format Testing

o Validated screen functionality against the Data Content Matrices and verify screen formats against the GUI prototype.

o Validated screen navigation betweens links to other web sites or applications.

• Developed, documented and executed test procedures.

• Provided regular status to the QA Lead and Manager.

• Logged necessary, timely, critical defects into the defect tracking system – Rational ClearQuest.

• Coordinated the software test, build and release process. Harold Washington College (Part-Time)

Lab Assistant / Technical Support: August 2005 – December 2011

• Created new users and edit existing user profiles in the class roster.

• Scheduled appointment for instructor.

• Provided students instruction to login and download NovaNet.

• Assisted students with Microsoft Office applications: o Setup margin, page headers / footers, footnotes, and endnotes. o Inserted picture, WordArt, background picture in a Word document. o Created formulas, functions and graphs in an Excel spreadsheet. o Created tables, queries and forms in Access database. o Created, designed, and implemented a simple webpage that connects to SQL Server or Access database.

o Debugged HTML syntax.

o Debugged simple Visual Basic syntax.

o Created animated PowerPoint slides.

• Provided technical assistance to Windows usage difficulties – such as Printer Configuration, Video Converting from AVI to VCD, and Email Attachments.

• Communicate with deaf students via writing.

Quality Assurance Analyst

SBC DataComm IT: January 2001 – February 2002

• Created Test Conditions for every defect in the ESS Oracle 11i Application. o Verified data by knowing new functionalities are functioning in Oracle Forms and Oracle Reports.

o Created and Executed Manual and automated testing based on the Requirement.

• Automation of Test cases using Mercury Tools (Test Director and Win Runner) – 1 month period.

• Experience in all phases of SDLC including analysis, design, development, and testing.

• Experience in various testing methodologies like Black Box, White Box testing.

• Reported bugs and track progress of application tool for version changes.

• Backend testing using PL/SQL Queries in UNIX; Pre-Production/Beta testing from existing and newly added functionalities.

• Conducted Test Walkthrough with Business Analysts and Business Users DePaul University

September 1996 – December 2000

Bachelor of Computer Science – Information Systems

Contact this candidate