PATRICK HILL [email protected] PROFILE Highly skilled Software Developer with proven experience in software development, data-driven web application development, database administration, and project management. Offers hands-on technical expertise combined with excellent skills in written and verbal communication, business analysis, project management, team building, and training. Highly dedicated and dependable employee, with a passion for technology, ready to go the extra mile and make a long-term contribution. TECHNICAL SKILLS Languages: Java, VBA, VB 6.0, VBScript, ASP 3.0, HTML, CSS, JSP; Working knowledge of Android Development , C#, ASP.NET, VB.NET, PHP Database: SQL Server (Integration Services, Reporting Services, Stored Procedures, DTS); T-SQL; Microsoft Access; Crystal Reports 8.5, ADO; working knowledge of MySQL, Oracle Operating Systems: Windows, Ubuntu, Android, Mac OS, BlackBerry OS, iOS Other: Mobile device configuration, MS Office, Dreamweaver, Photoshop, Acrobat Pro, Salesforce; GIT Hub,; Hardware: strong in troubleshooting PROFESSIONAL EXPERIENCE MOUNT SINAI MEDICAL CENTER, New York, NY Data Coordinator II 2012 – 2013  Developed from the ground up, and continue to enhance and maintain, fire-safety department database system, which helps track Fire Department of New York (FDNY) violations.  Developed, maintain, and enhance software that consolidates in a single system all fire-safety department information, including occurrence reports (when a fire alarm sounds), monthly fire drill schedules, and FDNY and other violation logs—fully automating previously manual tasks, streamlining in new efficiencies and organization.  Developed and currently support and update database front- and backend; create reports, tables, stored procedures, triggers, and all other database-related elements and processes.  Leveraged communication skills in providing liaison between technology and business users, and between department and vendors, including for needs assessment and third-party product review, as well as for training whole department on new system developed (above).  Serving as the only IT associate in department, worked highly independently as self-starter and ‘first-responder’ for all technical concerns and needs, including support issues before escalation to help desk. QUICKCOMM SOFTWARE SOLUTIONS, New York, NY Developer 2008 – 2009  Enhanced and maintained Quickcomm, a telecom expense management software suite; developed accounts payable feeds; managed work queue in Salesforce.  Developed, debugged, and tested reports and stored procedures to ensure data integrity; created tables, views, and all other database-related elements and processes; designed scripts for reports, AP feed registration, and database updates.  Developed and implemented weekly backups of source code; led development testing with QA team. PATRICK HILL Page 2 2007 – 2008 CONSULTING SERVICES  Developer, Center for Employment Opportunities, New York, NY. Customized CRM to address needs by adding fields, setting up user groups, and views; programmed automation into CRM.  Web Developer, New York Film Academy, New York, NY. Developed intranet website; designed database, stored procedures, tables, queries, and database security for intranet and apps; designed data-driven dynamic web pages; installed and configured servers.  Quality Assurance Analyst, Portfolio DecisionWare, New York, NY. Tested and debugged project management system; helped conduct client training sessions. ARROW SOLUTIONS, Richmond Hill, NY 2006 – 2007 Developer  Enhanced and maintained Arrow Home Healthcare System medical software.  Performed business analysis, working closely with business clients to gather requirements and design new system features and reports; wrote custom utility applications; managed end user support.  Developed reports, stored procedures, databases, tables, views, queries, and maintenance plans/jobs. GABRIELS TECHNOLOGY SOLUTIONS, New York, NY Web Developer / Project Manager 2005 – 2006  Enhanced and maintained Real Estate and Autos web portals for more than 17 US newspapers.  Managed all 17+ client accounts, handling client development requests, including implementing Google Maps on both Real Estate and Autos products; project-managed all development work, including planning, coordination, scheduling, and other project management responsibilities.  Managed front- and backend data flow, troubleshooting, and debugging, addressing issues and delegating to database administrators as needed. SQUARE ONE, Holmdel, NJ 2005 Web Developer  Designed innovative web-based solutions as well as database structures, tables, and application front ends to meet needs and improve business processes of field-marketing company.  Performed business analysis role, partnering with account managers to develop specifications for new software, gather business requirements, and draft documentation.  Created databases, tables, queries, views, and stored procedures; administered/maintained databases. EARLIER RELEVANT EXPERIENCE STROOCK & STROOCK & LAVAN LLP, New York, NY 2000 – 2003 Application Developer  Designed, developed, tested, and supported database systems for one of New York’s largest law firms.  Contributed in key role to development, deployment, and maintenance of firm’s intranet site.  Advanced systems productivity and reliability by crafting programmatic enhancements, working closely with business users; developed web applications to effectively address business needs. EDUCATION Bachelor of Business Administration, Computer Information Systems (in process: complete in Dec 2014) BENARD BARUCH COLLEGE: ZICKLIN SCHOOL OF BUSINESS, New York, NY Associate of Applied Science, Programming and Systems LAGUARDIA COMMUNITY COLLEGE, New York, NY 1999