Systems Analyst

MELLISA SALDANHA

**** *** **** ****, *********, Tennessee 37210; Phone: 518-***-****

Email: *******************@*****.***; LinkedIn: https://www.linkedin.com/in/mellisa-saldanha/ SUMMARY

Systems Analyst adept at designing innovative IT solutions, problem-solving, enhancing existing systems with new features, database analysis and design. Strong written and verbal communication skills with experience in developing requirements specifications, user documentation, and architectural system research. WORK EXPERIENCE

BocaVox, Software Solutions August 2015-Present

Systems Analyst

• Developed, tested, and modified Custom and Maestro SQL Reports using Maestro SIS Reporting Tools.

• Analyzed and tested new applications before promotion to the production environment.

• Involved in Problem Solving, Data Cleaning and Data Integration between Maestro SIS and D2L.

• Optimized large, complicated SQL-statements to reduce run time and improve efficiency.

• Worked with customers/clients, trained new hires, and participated in client discussions.

• Monitored integrations, identified and fixed issues, managed database backup and recovery.

• Composed proposals and created initial solution designs. Assisted the tech team in resolving requirements.

• Involved with the product team in finding and resolving bugs, refactoring code for optimization and testing the same.

• Documented client requirements and conducted acceptance tests for new releases. New York Prosecutors Training Institute June 2014-May 2015 Intern, Web Application Developer

• Developed Stored Procedures, Triggers and Joins for the Prosecutor’s Case Management System v5.

• Created Simple and Complex Reports using table valued functions and Stored Procedures for PCMS v5.

• Re-factored the stored procedures of PCMS v4 to be compatible with PCMS v5.

• Added ASP.NET pages to the NYSLAWS website and used Tortoise SVN for Version Control. New York State Office of Mental Health March 2014-August 2014 Intern, Data Analyst

• Tested the working of MHARS system and was responsible for data cleaning using SQL Server Management Studio. ACADEMIC PROJECTS

Web Application module using MVC Architecture Jan 2014-May 2014 Technologies: JSP, Servlets, Amazon Web Services, MySQL

• Used MVC architecture to implement the user authentication module for a web application using JSP, Servlets and Amazon Web Services.

Chat application in Java February 2015-March 2015

• Developed and tested a chat application in Java to understand the concept and workings of chat applications. Worked on Data Wrangler and Google Refine Jan 2014-May 2014

• Researched and created a presentation to understand the benefits of these data cleaning tools. SKILLS

Programming Language: Java 8, C++, C#

Operating System: Windows, Linux, Ubuntu

Database: SQL Server Management Studio, MySQL, PostGreSQL, SQLite, Oracle, MS-Access Web Technology: HTML, CSS, XML, JavaScript, ASP.NET, JSP, Servlets, Google Maps JavaScript API Server: Apache Tomcat 7

IDE Tools: Eclipse, NetBeans IDE 6.5, Microsoft Visual Studio More Software: Rational Rose, Auto Cad, StarUML, Source Safe, Mantis, Zendesk EDUCATION

University at Albany, State University of New York August 2013-May 2015 Master’s in Computer Science GPA: 3.4

Mumbai University, Mumbai, India July 2008-June 2012 Bachelor of Engineering in Information Technology

Certifications

Oracle Certified Professional, Java SE 8 Programmer (1Z0-809) August 2018 Oracle Certified Associate, Java SE 8 Programmer (1Z0-808) November 2017

Contact this candidate