Brian C. Email & Phone Number

Denver, CO, US

Denver, Colorado, United States

Provide technical support for sales channel, various front end systems and database administration including but not limited to SQL Server, Oracle, Integration Services, SQL, PL/SQL, Power BI, Power Platform Apps, Salesforce. ETL processing of sales and customer data from data warehouses/lakes in Oracle, SQL Server, Salesforce and external third party.

Denver, Colorado, United States

• Provide technical support for compensation systems and database administration work involving SSMS, Oracle, SSIS, HANA, SQL, PL/SQL, Visual Studio development and maintenance
• Migrate complex In-Region Partner payments from Oracle Incentive and Compensation system to an SAP Commission System to support accurate external partner commissions; streamlined process to reduced volume of records.
• Create ETL packages to transfer revenue data directly from Oracle to SAP HANA/Callidus
• Integrate data from external systems into SAP HANA for processing and exporting of data back for internal consumption
• Reconfigure queries to combine revenue in an Analysis Cube featuring external pay file data; combine revenue data sources from legacy OIC and new SAP commission system that calculate separately
• Processing and analytics of sales compensation data to identify potential over/under payment situations, validation of end of month processing to ensure accuracy, as well as running SOX audits to ensure compliance with.

Denver, Colorado, United States

Train incoming employees in all areas involved with providing copper/fiber services to customers. This includes Outside Plant facilities, fiber splicing, pole climbing, equipment usage, central office equipment, cross connects, as well as field equipment usage and maintenance. As part of this position, individuals were required to learn each area in-depth.