Richard Hains Email & Phone Number

Calgary, Ab, Ca

Calgary, Alberta, Canada

- Performing ETL from various sources using SSIS, Azure, SSAS and Snowflake as final data storage. - Building various Data Models in SSAS using DAX. - Building various reports/dashboards using PowerBI to visualize data out of SSAS and models in Power BI service. - Migrated tabular models from SSAS to Power BI premium. - Developed a solution that refresh tabular models in Power BI Premium taking data from Snowflake and SQL Server. This app can be schedule to run in Visual Cron.

Calgary, Alberta, Canada

- I was the liaison between business users in Calgary as well as Edmonton and different IT groups (DBAs, Architects, and Developers).- Supported and maintain ETRM (Energy Trading and Risk Management) System (Allegro Horizon).- Accountable for stewarding applications developed in .NET that interface with Allegro Horizon.- Successfully upgraded Allegro from version 8 to version Horizon.- Developed a variety of .NET applications that interface with Allegro as well as applications… Show more - I was the liaison between business users in Calgary as well as Edmonton and different IT groups (DBAs, Architects, and Developers).- Supported and maintain ETRM (Energy Trading and Risk Management) System (Allegro Horizon).- Accountable for stewarding applications developed in .NET that interface with Allegro Horizon.- Successfully upgraded Allegro from version 8 to version Horizon.- Developed a variety of .NET applications that interface with Allegro as well as applications that business users use on a day to day basis.- Designed and developed a fair large amount of SQL server stored procedures that help to increase performance on business processes.- Succesfully converted Oracle Data Integrator (ODI) packages into SSIS Packages.- Designed and developed Reports in Sql Server Reporting Services to fulfill Business requests. Show less

Calgary, Canada Area

- I was the liaison between business users for Marketing and Power business units in Calgary as well as Denver and different IT groups (DBAs, Architects, and Developers). - Supported and maintained ETRM (Energy Trading and Risk Management) System (Allegro 7.7). This application is strongly integrated with TIBCO. - Accountable for stewarding applications developed in Java and .NET that interact with Allegro 7.7.- Responsible to gather information for SOX controls. Coordinated… Show more - I was the liaison between business users for Marketing and Power business units in Calgary as well as Denver and different IT groups (DBAs, Architects, and Developers). - Supported and maintained ETRM (Energy Trading and Risk Management) System (Allegro 7.7). This application is strongly integrated with TIBCO. - Accountable for stewarding applications developed in Java and .NET that interact with Allegro 7.7.- Responsible to gather information for SOX controls. Coordinated quarterly access review to Allegro application with business owners required for SOX.- Successfully coordinated and implemented the upgrade of application servers and database servers for allegro 7.7 from windows server 2003 to windows server 2008.- 80% allocated as a project resource to setup and configure application servers (install application, configure IIS, and authentication setup) for ETRM Allegro 8 as well as configuring the application. I am developing implementation processes, reviewing standards and creating support documentation.- Successfully implemented Phase 1 of Allegro 8 project on June 2015- Successfully implemented Phase 2 of Allegro 8 project on February 2016- Stewarding applications used by Power and Fundamental business areas. Show less

Calgary, Canada Area

Responsible for managing application services throughout their lifecycle. Oversee the delivery of services to Marketing and Risk internal customers. Act as a key interface between internal customers and support service providers. For live or operational services, responsible for ensuring delivery of reliable IT application services to the customer, while focusing on continually improving service delivery quality and efficiency.- Business Customer Relationship Management- Demand… Show more Responsible for managing application services throughout their lifecycle. Oversee the delivery of services to Marketing and Risk internal customers. Act as a key interface between internal customers and support service providers. For live or operational services, responsible for ensuring delivery of reliable IT application services to the customer, while focusing on continually improving service delivery quality and efficiency.- Business Customer Relationship Management- Demand Management- Service Design and release management.- Knowledge Management.- Change and problem management Show less

Calgary, Alberta, Canada

- Acted as a liaison between IT departments (DBAs, Network, Infrastructure, and Data Management) and internal clients in Marketing and Risk areas as well as external vendors.- Responsible for the management (maintenance, upgrades, releases) of the following applications:Market fundamental applications:o Market Information Machine (MIM) data warehouse servers for market information.o Market Information Machine Client (MIMC) frontend.Power market applications:o ZAPP… Show more - Acted as a liaison between IT departments (DBAs, Network, Infrastructure, and Data Management) and internal clients in Marketing and Risk areas as well as external vendors.- Responsible for the management (maintenance, upgrades, releases) of the following applications:Market fundamental applications:o Market Information Machine (MIM) data warehouse servers for market information.o Market Information Machine Client (MIMC) frontend.Power market applications:o ZAPP, Global Energy Decisions (GedEnerpise) and DropChute Enterprise.Crude oil application:o EgistixOil and EgistixOpen. Gas marketing applications:o ETRM Allegro 7.7, Allegro integrations through TIBCO, Pipeline Estimated Systems, Allegro Reports, Allegro JDE Export, Supply Reports, Allegro Batch among in house applications- Production/change management- Developed and maintained strong vendor relations, participated in application evaluations and product upgrades.- Software license management- Business o Understand how applications are used in support of the business o Maintain application knowledge o Training coordination Show less

Calgary

- Implemented new functionality using Perl language to Authorization module.- Implement WSUS (Windows Server Update Service) to Husky retail sites.- Provide operation support to automated applications build in Perl, C# and Java using Sql Server and Oracle Data Base.- Followed ITIL processes to implement changes required to the supported applications.

Calgary, Alberta, Canada

- Provided operational support to Credit and Debit Card and Dealer Settlement application running on OpenVMS using PL/SQL, Pro*C, VMS scripts and Oracle Forms.- Implemented new functionality for projects that are related to the supported applications.- Worked with other project team members and stakeholders providing input to the design of new requirements.- Designed and implemented new requirements developed in Pro*C and PL/SQL.- Delivered User Acceptance Test Plans.-… Show more - Provided operational support to Credit and Debit Card and Dealer Settlement application running on OpenVMS using PL/SQL, Pro*C, VMS scripts and Oracle Forms.- Implemented new functionality for projects that are related to the supported applications.- Worked with other project team members and stakeholders providing input to the design of new requirements.- Designed and implemented new requirements developed in Pro*C and PL/SQL.- Delivered User Acceptance Test Plans.- Defined technical requirements to migrate C and Pro*C programs into Unix platform from OpenVMS platform, as well as VMS scripts into shell scripts.- Followed ITIL processes to implement changes required to the supported applications. Show less

Calgary, Alberta, Canada

- Provided operational support to Credit/Debit Card and Dealer Settlement application (Stingray) running on OpenVMS using PL/SQL, Pro*C, VMS scripts and Oracle Forms.- Implemented new functionality for projects that are related to the supported applications.- Worked with stakeholders from business unit to analyze, design and implement new enhancements.- Delivered User Acceptance Test Plans.- Defined technical requirements to migrate programs into UNIX platform from OpenVMS… Show more - Provided operational support to Credit/Debit Card and Dealer Settlement application (Stingray) running on OpenVMS using PL/SQL, Pro*C, VMS scripts and Oracle Forms.- Implemented new functionality for projects that are related to the supported applications.- Worked with stakeholders from business unit to analyze, design and implement new enhancements.- Delivered User Acceptance Test Plans.- Defined technical requirements to migrate programs into UNIX platform from OpenVMS platform- Followed ITIL processes to implement changes required to the supported applications using Service Center.- Re-wrote ISQL jobs into PL/SQL Oracle 10g procedures that interface with JDE applications.- Technical Subject matter expert on various pieces of the application (Loyalty, Transaction Loads, SSI (Sales Stock Inventory), RFID EasyPay / IVR).- Participated in various projects like the KeyStone project (Transition Credit Card billing from Stingray to TCH), Phoenix Project (New Radiant devices rollout), GOP Enabler for RBA Canada (Calculating Fuel Commission) and Stingray Port Project (migration to UNIX platform). Show less

Calgary

- Provided daily operational support.- Analyzed and designed new requirements developed in PL/SQL and UNIX scripts that increase corporate productivity.- Defined technical requirements, analyzed technical impact, planned system test.- Worked with business unit to ensure all requirements have been defined.- Work closely with clients to assess individual needs and support effectively.- Delivered Functional Design to client including User Acceptance Test Plan.- Wrote… Show more - Provided daily operational support.- Analyzed and designed new requirements developed in PL/SQL and UNIX scripts that increase corporate productivity.- Defined technical requirements, analyzed technical impact, planned system test.- Worked with business unit to ensure all requirements have been defined.- Work closely with clients to assess individual needs and support effectively.- Delivered Functional Design to client including User Acceptance Test Plan.- Wrote analysis and detail technical design documents to be submitted to development team.- Created Conditions, Scenarios, and Scripts – and oversaw their execution during the Assembly, Performance, Application, and Integration Test phases. - Delivered detailed deployment plans that include component identification, implementation steps, verification procedures, roll back instructions, and environment impact analysis. Show less

Argentina

Calgary, Canada Area

Argentina

Argentina

Certificate In Business Intelligence And Analytics

Activities and Societies:

Business Analyst Certificate, Information Systems And Services

Ingeniero En Sistemas - Bachelor Science In Computer Science, Information Systems And Services