Shane Mccready Email & Phone Number

Fredericton, New Brunswick, Canada

•Upgrade existing VB3 and VB6 applications to .NET (Framework 4.5)•Interact with client to gather requirements and specs for upgraded application.•Use gathered requirements and existing VB3/VB6 code to create new application (GUI and database)•Environment: SQL Server 2008 - SQL Server Management Studio v.17, Microsoft Visual Studio 2008 - Visual Studio 2013, Microsoft Visual Basic (versions 3, 6), Intersoft Solutions Web Tools, Active Reports 6, 9, 11. Dynamic Source Safe.

Fredericton, New Brunswick, Canada

•Upgrade existing VB3 and VB6 applications to .NET (Framework 4.5)•Interact with client to gather requirements and specs for upgraded application.•Use gathered requirements and existing VB3/VB6 code to create new application (GUI and database)•Environment: SQL Server 2008 - SQL Server Management Studio v.17, Microsoft Visual Studio 2008 - Visual Studio 2013, Microsoft Visual Basic (versions 3, 6), Intersoft Solutions Web Tools, Active Reports 6, 9, 11. Dynamic Source Safe.

Fredericton, New Brunswick, Canada

•Design and build web pages to facilitate the management of Voter and Election management data using Visual Studio 2010/2012 with the C#.NET, MVC 4.0 framework, HTML, CSS, JavaScript and JQuery.•Create complex T-SQL queries and deploy custom reports using SQL Server Reporting Services (SSRS), Visual Studio 2010 and SQL server 2012.•Perform business analysis by meeting with the client to gather specific business requirements, business processes and ideas for screen layout and flow.•Create documentation for technical and user requirements and application user manuals.•Manage assigned tasks using the JIRA Task Management System.•Manage project source code using the Microsoft Team Foundation Server.•Environment: Visual Studio 2012 (MVC 4.0 Framework), SQL Server 2012, SQL Server Reporting Services, MS Team Foundation Server, JIRA Task Management System, Virtual Machine.

Fredericton, New Brunswick, Canada

•Perform maintenance and support duties for the Client Registry (IBM Initiate) section of the Electronic Health Record (EHR) project.•Use IBM Initiate Workbench to aid the DIS team in integrating their solution with the Client Registry element of the iEHR project.•Communicate with the QA team and OPOR Registry Unit in person, via phone or email to investigate issues, to answer any Client Registry related questions.•Use IBM Initiate Workbench application to create and manage an internal LDAP user security solution.•Meet with OPOR Registry Unit to gather requirements for any change requests or issues they may have.•Use Initiate Master Data Engine web applications to diagnose or resolve issues reported by the OPOR Registry Unit. Initiate Inspector is the most commonly used application in this process. •Create and maintain CR process documentation (i.e. CR Daily Checklist, Custom SSRS Reporting Solution). •Create ad hoc Oracle PL/SQL reports for the OPOR Registry Unit for statistical purposes. Worked with Andrea Creagh of the OPOR Registry Unit analyzing what values needed to be retrieved from the Initiate database. Created PL/SQL SELECT statements and scripts. The results from these “reports” are posted on the Client Registry SharePoint site on a daily, weekly, monthly and quarterly basis. •Create and deploy custom reports for the OPOR Registry Unit using SQL Server Report Services. Convert PL/SQL statements used in custom reporting to SSRS reports using Visual Studio 2008. Deploy reports to a production SSRS server to be used by the OPOR Registry Unit.•Environment: IBM Initiate Master Data Engine, IBM Initiate Inspector, IBM Initiate Web Reports, IBM Initiate Enterprise Viewer, Apache Tomcat, Rhapsody Management Console, Rhapsody IDE, Concerto Patient Viewer, Oracle 10g, 11g Database Server, SQL Server 2008, TOAD for Oracle, SQL Developer, SQL Server Reporting Services, Filezilla

Fredericton, New Brunswick, Canada

•Perform maintenance and support duties (via helpdesk requests) on NB Power applications in a prompt and efficient manner.•Communicate with client contact via phone or email to investigate and resolve issues.•Environment: Oracle SQL Developer 10g, Microsoft SQL Server (2000, 2005, 2008), Microsoft Access (1997, 2003), Microsoft Visual Studio 2003, 2005, 2008), Microsoft Visual Basic (versions 3, 6), Microsoft SQL Server Reporting Services.

Fredericton, New Brunswick, Canada

•Participate in various areas during the customization and build of the multi-release Correctional Information System (CORIS), using an existing system as its foundation. Emphasis placed on screen and report development.•Created tables, views, functions and stored procedures (using SQL Server) to be used as the foundation for global datasets, web pages and reports. •Convert existing Oracle stored procedures, functions and views to SQL Server and test. •Design and build web pages to facilitate the management of inmate information and inmate finances (i.e. restitution, inmate bank balances, inmate purchases, etc.) Languages used in creating pages were HTML for display and vb.NET and asp.NET to handle user initiated events and interaction with the database (code behind). Created and deployed over 100 web pages of varying degrees of complexity over 6 years.•Perform various SQL performance tuning tasks. Including identification of high-cost areas.•Create reports using Crystal Reports with a SQL Server database. Created over 50 SQL Server stored procedures that were called by the reports. •Play a primary role in the migration of data from 5 legacy systems into the new CORIS system. Created over 250 stored procedures, functions, and cross reference tables to accomplish this process.•Perform maintenance on the application in a prompt and efficient manner. Interaction with the client provided feedback which was organized into task based system. These tasks were created as either bugs or change requests and were worked on in order of importance.•Schedule and estimate tasks.•Maintain a .NET web application to track task (requirements, problem issue, and change request) for every state (Maine, New Hampshire, Virginia). •Environment: MS Visual Studio, IIS, Crystal Reports 9.0, Crystal Enterprise 8.5, MS SQL Server 2000, ODBC, MS Query Analyzer, MS Enterprise Manager, T-SQL, SQL, MS Visual Source Safe 6.0, Windows XP Workstation, Windows 2000 Server

Fredericton, New Brunswick, Canada

•Created tables, views, functions and stored procedures (using TOAD for Oracle) to be used as the foundation for web pages and reports. •Complete application development using Oracle PL/SQL, Oracle Designer Oracle Forms, Oracle SQL*Plus and Microsoft Access 7.•Create reports using Oracle Reports Builder.•Environment: Oracle RDBMS, Oracle PL/SQL, Oracle Designer 6.0, Oracle Form6.0, Oracle SQL*Plus, Oracle Report Builder 6.0, Windows NT 4.0, Windows NT Workstation 4.0, TOAD Server 7.0.4.

Bachelor Of Arts (Ba), English/History

Activities and Societies: Mount Allison Varsity Football Team, Mount Allison University Newspaper

Honors, College Preparatory

Activities and Societies: Saint Malachy's Varsity Football Team Saint Malachy's Varsity Rugby Team