William Rescigno

Experience

• 

  Princess Cruises

  Dec 2005 - Dec 2009

  Database Analyst

  I authored instructional materials such as manuals, process & software documentation for end users & clients. We provided on-the-job training for new hires, demonstrating employment responsibilities on an individual basis. This included collecting & organizing feedback on initial reaction to new database functionality & departmental programs.We hosted & presented training workshops at our corporate headquarters attended by our field-based associates. I supported partners & clients with assistance solving computer problems, malfunctions and program problems.I helped oversee implementation of company's loyalty award program & managed deployment to our remote clients. I also documented occurrences of user difficulties indicating essentially needed improvements to database processes.I managed problems/complaints/suggestions e-mail & inbox for internal & external customers, and delivered live, on-call hardware & software support & diagnostics to intra & interdepartmental colleagues. We communicated with remote users & clients based in other countries via email, fax & telephone.I interfaced between business & IT segments to facilitate smooth functionality of databases. I monitored input of, validated, cleansed & extracted data in accordance with quality assurance guidelines. I helped coordinate roll out of database program enhancements with local divisions, remote users & outside clients. We tested databases processes, identified errors & inefficiencies & suggested appropriate modifications.Created Excel & Access macros, forms & reports for data organization customized to user's specifications. We produced nationality, earnings, and performance & retention personnel statistics reports for Directors & VP’s, and Tactfully relayed suggestions to upper management & conveyed corporate I.T. directives to department staff. I tracked corporate standards complicity by auditing database records & analyzing possible input error patterns. Show less

• 

  National Office Outlet

  Dec 2009 - Feb 2012

  Jr. Database Architect/Administrator

  I wrote, updated, & maintained software packages to handle specific jobs such as storing and retrieving data; designed interfaces, data transfer mechanisms, data partitions, & function-based indexes; and programmed & maintained archived procedures, procedural codes, and queries for applications.I also developed data models for applications, metadata tables, views & related database structures, and established database architectural strategies at the modeling, design & implementation stages. Show less

• 

  Premier Auto Credit

  Feb 2012 - Apr 2015

  Currently building company Intranet to centralize organization information, documents & policies for more efficient use.Construct reports determining monthly sales bonuses & merit-based compensation; construct and refine reporting for vital key performance indicators (KPIs) for Collections department; and created live Excel reporting containing up-to-the-minute dashboard-like information for Funding department.Aggregate & validate monthly financial information for dissemination to major institutional lender.An integral part of transition to new telephony, fax system & physical servers.Managed in-bound & out-bound eFax accounts, GPS, alarm and key card system, customer payment systems. I administering GPS inventory, & designed and implemented Access Database to capture all pertinent information.Was the most knowledgeable IT expert for company of 50 employees and the in-house IT troubleshooter for the entire company. I was responsible for setup of employees with all essential computer components, applications & electronic accounts. Show less

  • IT Support Specialist

    May 2014 - Apr 2015

  • Accounting Lead

    Aug 2013 - May 2014

  • Business Analyst

    May 2013 - May 2014

  • I.T. Analyst

    Feb 2012 - May 2013
• 

  Global Vision Systems

  Apr 2015 - Apr 2016

  Engineering Project Manager

  Load our software product on client servers using PowerShell scriptsSetup Windows Server on physical and virtual servers: configure IIS, Component Services, Task SchedulerCorrespond with business-side client contacts to establish business needsPerform Data Validation, Data MappingManage my own projects, and those of teammates located locally and overseasCustomize SQL Server: configure SSRS, Visual Studio + SSIS Data Tools Business IntelligenceConstruct & update Project Plans & TimelinesConfer with IT-side client contacts to determine technological constraintsIntegrate our software product with both common and atypical financial institution core systemsInstall product updates using windows command line batch scripts Show less

• 

  Advanced Access Controls

  Apr 2016 - Jul 2018

  IT Project Manager

  Ran Ethernet, Fiber cabling between multiple parking lots and Parking Management OfficesInstalled & configured Parking controls software, peripherals, according to PCI compliance standardsSetup client Servers and Workstations with appropriate Window versionsProgrammed Cisco Managed switches, generic and (Trustwave) branded SonicWall according to engineering specificationsProvided remote (via LogMeIn) & on-site support for clients Regarding both software & hardware issuesTroubleshooting: router/VPN/general connectivity issues, including cabling and local/external IP conflicts Show less

• 

  CMIT Solutions

  Jul 2018 - now

  VBA/SQL Developer (MS Access + Excel + SQL Server) | Data Analyst

  Data Analysis & Report Construction/Maintenance (MS Access, Excel, Website front-end)Database Development (SQL Server, PostGreSQL, MariaDB, MongoDB & MySQL database building, maintaining, tuning, migration, normalization, backup & restore, etc; Programmed in SQL, VBA, Python, C+, C#, Java, R)Data Entry & Cleansing (Paper & online ballot initiative petitions)Small Business Specialist (Website & SEO setup (using HTML/CSS/JavaScript/PHP/Perl), on-site equipment setup & maintenance)• Programmed VBA modules from the ground up following Object-Oriented Programming (OOP) principles• Established permanent SQL query connection with backend Access database to fetch relevant records & columns• Enabled 1-button press spreadsheet creation/removal based on employee onboarding/termination• Populated presentably formatted spreadsheets with work order information for on-site technician deployment• Setup Macro to publish PDFs from spreadsheets to employee and department folders within Windows file system Show less