Technical Analyst
University of Calgary
Total years of experience :19 years, 1 Months
Production Support, Systems Analysis and Application Development:
•Proposed solutions to units to automate existing manual processes using Archibus IWMS system.
•Provided production system support for Archibus IWMS and installed upgrades and patches to servers.
•Developed new modules in Archibus using javascripts and AXVW markup language.
Requirements Gathering and Analysis:
•Worked with various units to elicit stakeholders and identify requirements.
•Involved in documentation of requirements deliverables, test cases and design documents.
Client Technical Support and Training:
•Responded to tickets from clients regarding bug fixes or enhancements to the Archibus IWMS.
•Provided technical training to users regarding usage of various Archibus IWMS modules.
Technologies and Skills Used:
•Business Analysis, change management, stakeholder analysis and technical support to users.
•Archibus, PeopleSoft, pl/sql, Excel Pivots, Sharepoint 2013, .NET Programming, javascript, SVN.
Proposed solutions related to reporting and business intelligence to higher management including the Vice President of Research to implement measures to improve data retrieval, analysis and quality.
•Proposed solutions to management to implement measures for improving data reporting and quality.
•Lead a team of data analysts on projects, mentored team members and provided training to end users.
Requirements Gathering and Analysis:
•Facilitated with stakeholders to identify needs and requirements related to reporting, business intelligence, fund development, students and alumni projects.
•Documentation of requirements deliverables, design documents, processes, and business rules pertaining to data capture and data quality management and other project deliverables as needed.
•Assisted in the implementation and testing of new functionalities and business processes.
Client Technical Support and Training:
•Responded to client tickets for various data requests including the generation of excel exports.
•Provided technical training to clients regarding usage of reports, PeopleSoft ERP and Raisers Edge CRM.
•Assisted with the integration of data between the various systems on the University of Calgary campus.
•Performed ad-hoc data extraction from the data warehouse and from external funding agencies.
•Responded to requests from clients for assistance and design/implementation of queries and exports.
Data Analysis, Reporting and Application Development:
•Developed data maintenance queries using for Raisers Edge CRM using PL/SQL.
•Developed Reports using Tableau, Cognos Report Studio, Crystal Reports and Excel Power View.
•Developed applications using C#.NET and VB.NET.
Technologies and Skills Used:
•Business Intelligence, Business Analysis, stakeholder analysis and 2nd Level Technical Support.
•PeopleSoft, SQL server, pl/sql, Tableau, Cognos Reports Studio, Crystal Reports Excel Pivots, Sharepoint.
•Raiser’s Edge, Netcommunity, Zendesk, Sharepoint, Visual Studio.NET, Web Services, jQuery, javascript.
Requirements Gathering and Analysis:
•Interacted with faculties to identify requirements related to new process development.
Client Technical Support and Training:
•Assisted with new employee workstation set up and worked in collaboration with the IT department.
•Installed and setup computer learning software on staff and student workstations and handheld devices.
•Configured client access to the CRM system, fixed any access issues and worked closely with vendors.
•Provided technical support, assistance and training in person on IT related issues to staff members.
Technologies Used:
•SQL server, pl/sql, Crystal Reports, SSRS, iMIS System, Moodle, Mobile OS, 1st and 2nd Level Support
http://objectifi.com)
Requirements Gathering, Analysis and Testing:
•Worked as a consultant with American Express to gather requirements for Data Mining solutions.
•Involved in Review and Quality Analysis of requirements documentation and maintain test documents.
•Tested SQL queries and scripts for data quality before moving to production.
•Test Execution either manually or with Test Automation Tools; used HP Quality Center extensively.
ETL Processes and Application Development:
•Developed DTSX packages to run scheduled ETL processes to gather data from various data sources.
•Developed queries in Sybase DB and Oracle and web applications using .NET languages.
Technologies Used:
•SQL server, stored procedures, Oracle pl/sql, Infor Epiphany, Oracle RTD, .NET, Excel, HP Quality Center
Requirements Gathering and Analysis:
•Worked with units at the university to identify requirements for courses and ranking evaluation data.
•Involved in gathering statistical data and to provide analytics to various university departments.
•Coordinated between business units and IT.
Client Support, Report and Application Development:
•Involved in development of applications using .NET for internal stakeholders.
•Used SunGard Banner and Oracle database to update existing modules using PL/SQL
•Administered SAP Business objects enterprise and developed reports using Crystal Reports
Technologies Used:
•SAP Business Objects Enterprise, Crystal Reports 11, SunGard Banner, Banner Workflow
•Visual Studio .NET, IIS, Windows Server 2003, SQL Server, Oracle PL/SQL, stored procedures, Access
Software Application Development and Testing:
•Worked with the Enterprise Architecture group to develop and update Core Banking applications for various business units; involved in writing stored procedures using Oracle PL/SQL and t-SQL.
•Developed web services and Enterprise Applications using mainly C#.NET and Java.
•Developed reports for various banking areas using Crystal Reports/BO Enterprise.
•Developed prototype for proposed web site for http://www.nbad.com using Bitrix CMS.
•Used Weblogic and Tomcat application servers for deploying JSP’s, web applications and web services.
Client Support and Training:
•Liaised with vendors on an ongoing basis to develop banks new corporate website http://www.nbad.com.
•Provided technical training to users on installation and usage of various applications.
Technologies Used:
•C#.NET, VB.NET, ASP.NET, t-SQL, Database design, Web Services, IIS, Crystal Reports, PL/SQL, stored procedures, Excel, .NET Framework 1.1, 2.0 and 3.5, Java, JSP, BEA Weblogic, HEAT Helpdesk System.
Client Support, Development and Training:
•Development and support of employee collaboration software for corporate customers.
•Worked with clients to gather requirements and develop modules using C#.NET and SQL Server.
courses: Oil Sands: Overview and Environmental Impacts Course completed
courses: Certificate in Business Analysis completed
courses: ITIL V3 Foundations certification completed
,