John Connolly

John Connolly

Database and System Administrator

Followers of John Connolly44 followers
location of John ConnollyPittsford, New York, United States

Connect with John Connolly to Send Message

Connect

Connect with John Connolly to Send Message

Connect
  • Timeline

  • About me

    Report Writer/Developer at LeChase Construction

  • Education

    • St Mary's University

      1988 - 1992
      Bachelor's degree Computer Science
    • Rochester Institute of Technology

      1992 - 1996
      Master's degree Computer Science
  • Experience

    • CDI at Xerox

      Apr 1993 - Apr 1995
      Database and System Administrator

      : I supported a Microsoft Access database used by a Xerox copier\printer test team. The database stored test results for 3-4 Xerox products during their testing cycle. I developed Access reports, administered the database and also performed system administration to get customers connected to the database. My role also consisted of fixing administration issues with print servers for Xerox employees.

    • EDS AT XEROX

      Jan 1995 - Dec 2002

      I was responsible for the maintenance and engineering of a Microsoft SQL Server running on Windows operating system. I maintained and developed several applications and scripts on the server that provided tools to the organization to help analyze, collect, deploy, backup, administer platforms across Xerox’s IT infrastructure. I used SQL Server, Visual Basic, Microsoft Access, SQL Stored procedures, SQL query optimization, and Novell Developer API. I obtained a Microsoft Certified Solutions Developer MCSD from Microsoft. All stages of the development cycle including user requirements, test plans, and operation guides were documented. Show less

      • Database Developer and Administrator

        Jan 1998 - Dec 2002
      • Remote Systems Administrator

        Jan 1995 - Jan 1998
    • MCC

      Jan 2001 - Apr 2001
      Adjunct Professor

      I taught a course at MCC for one semester in Visual Basic for windows

    • Business Owner

      Jan 2003 - Sept 2017
      Database Administrator and Developer

      I started and grew an online book business that grew revenue from $10,000 in 2002 to $750,000 in 2017. I designed software that populated a SQL database with 10 million available books that was continuously refreshed. These books were listed online. Software was written to enable MS Access to automate over 100 orders per day. I was responsible for providing customer service for all problems. I maintained a 5- star customer satisfaction for 15 years.

    • LeChase Construction

      Nov 2017 - now
      Report Writer/Developer

      I work in the LeChase IT Department as a Report Writer\Developer. I developed many Crystal and SSRS reports used by the Finance, Accounting, HR, Payroll, Risk Management, IT and Operations departments. The crystal and SSRS reports are imported into our construction ERP software called Viewpoint and then security access is granted to various departments. I participate in the importing and configuration of these reports using our ERP Viewpoint software. In addition to crystal reports I have created several SSRS Dashboards and a Power BI dashboard. The dashboards are used by Risk Management, OSG and Operations, they provide important metrics to assist in their daily responsibilities. I deployed the dashboards to our SSRS server and also created an ASP website frame to host the dashboards to provide another way for the teams to access the dashboards. I created a VB.Net application that uses JSON API calls to two different API platforms. The application linked Qualtrics API platform to Building Connected API platform so the marketing team could send out surveys to customers and link some of the responses to Building Connected. I created several Excel VBA applications that provided process improvements across LeChase departments. As part of my role, I created and maintained many reports that required creating SQL Server stored procedures, table valued, scalar functions and views that were data sources for crystal reports, power bi and SSRS. For over the 6 years I have worked for LeChase I coded and maintained over 40 notifiers that were distributed to all the LeChase departments that gave important metrics and information to assist in their daily tasks. I filled a need for the organization to administer a construction ERP called Procore. This required creating users, adding companies\vendors, creating projects and develop code linked to their API platform to deactivate projects and users. Show less

  • Licenses & Certifications

    • Microsoft Certified Solution Expert Data Management and Analytics

      Microsoft
      Nov 2018