Badges
Certifications
zachary_guadagno has not earned any certificates yet.
Work Experience
Software Systems Development Analyst
Lithia Motors Inc.• July 2018 - Present
Developed and support several applications based projects: · Marketing dashboard ASP.NET web application that takes data from Google Analytics, Google AdWords, and several customer relationship management (CRM) systems and displays the in-formation to assist marketing executives on campaigning strategies · SSIS applications to take CRM data posted on a SFTP site and parse data to be inserted into a database · Tables to store data used for the marketing dashboard and stored procedures to transform the data into displayable charts, graphs, and tables on the executive dashboard · Automation of SQL job creation, scheduling, and monitoring for SSIS applications and stored procedures so daily incoming data could be manipulated and transformed to always provide up-to-date marketing data · Application that retrieves monthly CDK Global Inc. invoice data from a SFTP site, parses the da-ta to be inserted into a database, indicates charge items that have an incorrect amount, and visualizes month by month spending difference in charge types for each dealership.
Software Engineer
Tata Consultancy Services• June 2015 - July 2018
· Technical Lead for “Single Sign-on Medical Underwriting” project for Cigna · Implemented web service connections for Cigna with client applications · Utilized Java, JDBC, SQL, Microsoft SQL Server, XML Servlets, HTML to build “Single Sign-on” application · Supported client XML request issues – analyzing web services logs and Oracle SQL DBs · Provided Datapower / SAML certification support · Part of 24x7 on-call support team · Created weekly status reports to management regarding all aspects of the project. · Recognized by management multiple times through the following awards: “Certificate of Ex-cellence”, “Star of the Quarter” and “On the Spot Award”
Instructor
Black Rocket Productions• June 2008 - August 2013
· Instructed children ranging from ages 5-14 and presented complex topics in a manner that was easy to assimilate
Education
Rutgers, The State University of New Jersey
Computer Science, BA• September 2010 - January 2015
· Studied the problems, methods, processes, and tools involved in the development of large software systems that are reliable, maintainable, and meet their users' needs · Acquired a thorough understanding in the core principles and foundations of computer science - techniques of program design, creation, and testing, key aspects of computer hard-ware, and algorithmic principles · Demonstrations of prototype and final code with documentation for specification, architec-tural design, detailed design, and test plan
Rutgers, The State University of New Jersey
History, BA• September 2010 - January 2015
Links
Skills
zachary_guadagno has not updated skills details yet.