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
• Extracted data from a variety of sources, transformed it, and loaded into tables using Netezza SQL.

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
• Used KPI’s, Scorecards, Reports, and Filters to design and create Dashboards using PerformancePoint Services.

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

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.
• Designed and implemented new AS/400 chargeability system to distribute responsibility fairly among the service centers of claims for damages… Show more
• 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.

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

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
• Designed, implemented, and supported HR/Payroll network and workgroup security for a major client

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
• 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
• 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.
• 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
• 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.