Doug Cox Email & Phone Number

Bostic, Nc, Us

Charlotte, North Carolina Area

Cardinal Solutions became part of Insight Digital Innovations

Charlotte, North Carolina Area

• Served as a Team Lead, managing and mentoring a team of Data Solutions consultants.• Performed pre-sales activities with clients around Data Warehousing, Azure SQL DB, Power BI, and on-premises BI Stack solutions.• Responsible for full life cycle software development in-house and at client sites.• Designed and built a marketing data mart for a nonprofit healthcare system.• Extracted data from a variety of sources, transformed it, and loaded into tables using Netezza… Show more • Served as a Team Lead, managing and mentoring a team of Data Solutions consultants.• Performed pre-sales activities with clients around Data Warehousing, Azure SQL DB, Power BI, and on-premises BI Stack solutions.• Responsible for full life cycle software development in-house and at client sites.• Designed and built a marketing data mart for a nonprofit healthcare system.• Extracted data from a variety of sources, transformed it, and loaded into tables using Netezza SQL.• Analyzed data from multiple sources and documented data definitions and system requirements.• Performed data quality assurance and testing of ETL processes.• Collaborated with Subject Matter Experts to assess business requirements and data availability.• Delivered training and presentations to clients centered around PowerBI, Big Data, and Azure Everywhere Show less

Kannapolis, Nc

• Responsible for designing, developing, testing, and troubleshooting SSIS packages that implement complex ETL processes.• Designed, built, and maintained OLAP cubes using SSAS.• Supported daily needs of BI Team’s data warehouse, including developing / debugging / monitoring daily ETL and Cubes.• Designed, developed, tuned, and deployed reports using SSRS against both the dimensional BI data warehouse and the legacy OLTP database.• Used KPI’s, Scorecards, Reports, and Filters to… Show more • Responsible for designing, developing, testing, and troubleshooting SSIS packages that implement complex ETL processes.• Designed, built, and maintained OLAP cubes using SSAS.• Supported daily needs of BI Team’s data warehouse, including developing / debugging / monitoring daily ETL and Cubes.• Designed, developed, tuned, and deployed reports using SSRS against both the dimensional BI data warehouse and the legacy OLTP database.• Used KPI’s, Scorecards, Reports, and Filters to design and create Dashboards using PerformancePoint Services.• Mentored and educated junior Report Developers.• Translated business requirements into technical designs to map and load data from source systems to data warehouses.• Ensured quality and accuracy of the data mapped from source environments to the target environments.• Developed ETL audits and controls to ensure the quality of data meets, or exceeds, defined standards and thresholds.• Assisted report developers in designing, building and maintaining customized reports in SQL Server Reporting Services (SSRS).• Communicated open items and issues to key stakeholders, including management, development teams, and business areas.• Maintained data repository with data definitions, relationships, linkages and sources.• Ensured all packages and procedures were migrated utilizing TFS source control process.• Participated in code review sessions with data warehouse team. Show less

Charlotte, North Carolina Area

• Responsible for full life cycle software development in-house and at client sites.• Served as a team leader for the BI Development Team at Cardinal Innovations Healthcare Solutions.• Authored reports using SSRS against legacy OLTP database and dimensional BI data warehouse.• Delivered presentations at local user’s group meetings including SQL Saturday on various BI topics.

Chattanooga, Tn

• Designed, developed, tuned, and deployed quality BI solutions within strict budgets and timeframes.• Produced BI solutions such as models, reports, dashboards, and multidimensional cubes.• Created data models for effective queries that perform within service level agreements.• Wrote ETL macros to query multiple sources and load to datamarts and OLAP cubes.• Organized and ran weekly Cognos and SharePoint educational user groups.• Facilitated data modeling sessions with… Show more • Designed, developed, tuned, and deployed quality BI solutions within strict budgets and timeframes.• Produced BI solutions such as models, reports, dashboards, and multidimensional cubes.• Created data models for effective queries that perform within service level agreements.• Wrote ETL macros to query multiple sources and load to datamarts and OLAP cubes.• Organized and ran weekly Cognos and SharePoint educational user groups.• Facilitated data modeling sessions with business partners to quantify BI needs.• Thrived in a fast-paced and rapidly changing environment. Show less

High Point, Nc

• Led a team of 3 - 5 RPG programmers throughout the system development cycle• Responsible for major rewrite of a routing tractors and trailers Dispatching System with a transportation company consisting over 125 service centers throughout the continental United States utilizing AS/400 RPG IV ILE (service modules and binding), CL, and Subfiles• Designed and implemented new AS/400 chargeability system to distribute responsibility fairly among the service centers of claims for damages… Show more • Led a team of 3 - 5 RPG programmers throughout the system development cycle• Responsible for major rewrite of a routing tractors and trailers Dispatching System with a transportation company consisting over 125 service centers throughout the continental United States utilizing AS/400 RPG IV ILE (service modules and binding), CL, and Subfiles• Designed and implemented new AS/400 chargeability system to distribute responsibility fairly among the service centers of claims for damages filed• Redesigned key elements of AS/400 relational database for Pickup and Delivery System and interfaces to other systems, touching virtually every Information System in the company. Introduced essential data elements to expedite the flow and insure the reliability of the interfaces Show less

Clemmons, Nc

• Developed 18 month custom application using RPG IV, FTP, CL, and Subfiles• Maintained and supported RPG IV applications• Enhancements to existing RPG IV applications to meet the changing requirements of the company as it grew• Designed, implemented, and supported HR / Payroll network and workgroup security • Migrated System 36 payroll system over to AS/400 during critical communications disaster• End user support and training• Documentation of existing and newly… Show more • Developed 18 month custom application using RPG IV, FTP, CL, and Subfiles• Maintained and supported RPG IV applications• Enhancements to existing RPG IV applications to meet the changing requirements of the company as it grew• Designed, implemented, and supported HR / Payroll network and workgroup security • Migrated System 36 payroll system over to AS/400 during critical communications disaster• End user support and training• Documentation of existing and newly developed applications Show less

Clemmons, Nc

• Lead developer for long-term support contract with multi-national corporation working on AS/400 RPG III and PC platforms Visual Basic programming• Programmed AS/400-to-website business database application, using RPG III, CL, Visual Basic, SQL, FTP and Cold Fusion• Function as the MIS Manager for an AS/400 client, including programming and support at all levels of business• Developed EDI-enabled Visual AR business application using Visual Basic and Gentran• Designed… Show more • Lead developer for long-term support contract with multi-national corporation working on AS/400 RPG III and PC platforms Visual Basic programming• Programmed AS/400-to-website business database application, using RPG III, CL, Visual Basic, SQL, FTP and Cold Fusion• Function as the MIS Manager for an AS/400 client, including programming and support at all levels of business• Developed EDI-enabled Visual AR business application using Visual Basic and Gentran• Designed, implemented, and supported HR/Payroll network and workgroup security for a major client• Interview with users gathering requirements, turning requirements into specifications, developing utilizing RPG III, documentation, testing, and training on finished product Show less

High Point, Nc

• Designed, configured, and installed new LAN and WAN using AS/400 Integrated PC Server card (FSIOP) and Novell 3.14• Trained end users in use of PC’s and PC software as improvement over and replacement for AS/400 5250 terminals• Completed ORACLE training for use in major Client/Server business application, as well as developing custom code and SQL statements to link AS/400 data with ORACLE tables• Implemented Pick Ticket Management System (PkMS) for warehouse control and… Show more • Designed, configured, and installed new LAN and WAN using AS/400 Integrated PC Server card (FSIOP) and Novell 3.14• Trained end users in use of PC’s and PC software as improvement over and replacement for AS/400 5250 terminals• Completed ORACLE training for use in major Client/Server business application, as well as developing custom code and SQL statements to link AS/400 data with ORACLE tables• Implemented Pick Ticket Management System (PkMS) for warehouse control and distribution, using Symbol Bar Code Scanners, CL, and AS/400 RPG III programs with Subfiles Show less

Greensboro, Nc

• Programmed in RPG III and CL, using Subfiles, as the key Unifi member on team chartered to plan, program, test, implement and train users on Image-enabled customized Accounts Payable system on AS/400• Implemented Purchasing and Receiving programs that transmitted data to central AS/400 to feed Image-enabled AP database and to create R/DARS documents, and directed the efforts of other programmers on these systems• Documented and supported end-users of Image AP system and… Show more • Programmed in RPG III and CL, using Subfiles, as the key Unifi member on team chartered to plan, program, test, implement and train users on Image-enabled customized Accounts Payable system on AS/400• Implemented Purchasing and Receiving programs that transmitted data to central AS/400 to feed Image-enabled AP database and to create R/DARS documents, and directed the efforts of other programmers on these systems• Documented and supported end-users of Image AP system and R/DARS• Member of multiple teams designed to implement Lawson integrated software systems. Analyzed, planned, and implemented conversion and interface RPG programs to Inventory Control, Purchase Orders, Requisitions, and Accounts Payable• Analyzed and devised plan to link Lawson to R/DARS using API’s and User Exits Show less

Winston-Salem, Nc

• Project Manager for 300+ Man-hour Conversion of complete Transportation Auditing and Billing system from ITX system to Novell PC Network• Installed of multiple Token-Ring LAN's connecting to a WAN and providing access to AS/400's• Modified and converted custom software systems from IBM PC and IBM System 36 bases to IBM AS/400• Programmed in RPG III to implement an Electronic Direct Deposit of Payroll and Allocations Payables for a local branch of a major Non-profit organization… Show more • Project Manager for 300+ Man-hour Conversion of complete Transportation Auditing and Billing system from ITX system to Novell PC Network• Installed of multiple Token-Ring LAN's connecting to a WAN and providing access to AS/400's• Modified and converted custom software systems from IBM PC and IBM System 36 bases to IBM AS/400• Programmed in RPG III to implement an Electronic Direct Deposit of Payroll and Allocations Payables for a local branch of a major Non-profit organization, consisting of download of data from IBM Midrange Computer to Novell PC Network and then transferring converted data to the Bank’s ACH via modem Show less