Experience

SUM Global Technology

• United States
• Information Technology & Services
• 1 - 100 Employee

• Senior Database Architect

  • Oct 2023 - Present

  Provide SUM Global clients with Database Architecture and Business Intelligence solutions. Provide SUM Global clients with Database Architecture and Business Intelligence solutions.



Juliette Fowler Communities

• United States
• Non-profit Organizations
• 1 - 100 Employee

• Business Intelligence Specialist

  • Apr 2023 - Present

  Provide Power BI consulting services to assist with financial reporting including KPI's and P&L statements. Provide Power BI consulting services to assist with financial reporting including KPI's and P&L statements.



ViaPlus

• United States
• IT Services and IT Consulting
• 100 - 200 Employee

• Senior Database Architect and Business Intelligence

  • Oct 2022 - Present

  ViaPlus provides fully automated, end-to-end transportation solutions that significantly improves revenue collection. Engagement responsibilities include the following: ● Create high performance SQL Server views and transformations to support Power BI Reporting. ● Design Power BI Service (cloud based) KPI visualizations, paginated reporting and executive dashboards. ● Interface Power BI Service with on-premise SQL Server using Data Gateway in near-real-time queries. ● Instruct and… Show more ViaPlus provides fully automated, end-to-end transportation solutions that significantly improves revenue collection. Engagement responsibilities include the following: ● Create high performance SQL Server views and transformations to support Power BI Reporting. ● Design Power BI Service (cloud based) KPI visualizations, paginated reporting and executive dashboards. ● Interface Power BI Service with on-premise SQL Server using Data Gateway in near-real-time queries. ● Instruct and train both internal and external Power BI users to perform Ad Hoc reporting. Show less ViaPlus provides fully automated, end-to-end transportation solutions that significantly improves revenue collection. Engagement responsibilities include the following: ● Create high performance SQL Server views and transformations to support Power BI Reporting. ● Design Power BI Service (cloud based) KPI visualizations, paginated reporting and executive dashboards. ● Interface Power BI Service with on-premise SQL Server using Data Gateway in near-real-time queries. ● Instruct and… Show more ViaPlus provides fully automated, end-to-end transportation solutions that significantly improves revenue collection. Engagement responsibilities include the following: ● Create high performance SQL Server views and transformations to support Power BI Reporting. ● Design Power BI Service (cloud based) KPI visualizations, paginated reporting and executive dashboards. ● Interface Power BI Service with on-premise SQL Server using Data Gateway in near-real-time queries. ● Instruct and train both internal and external Power BI users to perform Ad Hoc reporting. Show less



Clerin Consulting Group

• Owner/Database Consultant

  • Nov 1998 - Present

  Clerin Consulting Group provides experienced Database Design and Data Warehouse consulting services. Extensive experience with large database installations utilizing Microsoft SQL Server and Oracle RDBMS technologies. High performance database/data warehouse design using parallelization on SMP platforms and partitioned objects. Expert level development of Oracle PL/SQL and Microsoft T-SQL stored procedures and packages for custom n-tier Oracle/SQL Server application development. Expert SSRS… Show more Clerin Consulting Group provides experienced Database Design and Data Warehouse consulting services. Extensive experience with large database installations utilizing Microsoft SQL Server and Oracle RDBMS technologies. High performance database/data warehouse design using parallelization on SMP platforms and partitioned objects. Expert level development of Oracle PL/SQL and Microsoft T-SQL stored procedures and packages for custom n-tier Oracle/SQL Server application development. Expert SSRS report designer. Show less Clerin Consulting Group provides experienced Database Design and Data Warehouse consulting services. Extensive experience with large database installations utilizing Microsoft SQL Server and Oracle RDBMS technologies. High performance database/data warehouse design using parallelization on SMP platforms and partitioned objects. Expert level development of Oracle PL/SQL and Microsoft T-SQL stored procedures and packages for custom n-tier Oracle/SQL Server application development. Expert SSRS… Show more Clerin Consulting Group provides experienced Database Design and Data Warehouse consulting services. Extensive experience with large database installations utilizing Microsoft SQL Server and Oracle RDBMS technologies. High performance database/data warehouse design using parallelization on SMP platforms and partitioned objects. Expert level development of Oracle PL/SQL and Microsoft T-SQL stored procedures and packages for custom n-tier Oracle/SQL Server application development. Expert SSRS report designer. Show less



Ameritex Fabric Systems

• United States
• Maritime
• 1 - 100 Employee

• Information Technology Consultant

  • Jan 2009 - Present

  Designed and developed customer solutions to enhance core Made2Manage ERP solution to provide labor tracking, job/shop floor tracking, job production scheduling, shipping label production and management/executive dashboard reporting. Designed and developed customer solutions to enhance core Made2Manage ERP solution to provide labor tracking, job/shop floor tracking, job production scheduling, shipping label production and management/executive dashboard reporting.



Solstice Innovations

• United States
• Insurance
• 1 - 100 Employee

• Database/Data Warehouse Architect

  • Oct 2021 - Oct 2022

  Designed high performance, no/low code ETL solutions to replicate AWS DynamoDB data into a multi-tenant PostgreSQL relational data warehouse for reporting, KPI dashboards and business analysis tools. Near-real-time data replication using Fivetran data pipeline, native Postgres SQL and pg_cron scheduling. Created complex SQL and Postgres Functions to support business reporting and KPI visualizations. Designed high performance, no/low code ETL solutions to replicate AWS DynamoDB data into a multi-tenant PostgreSQL relational data warehouse for reporting, KPI dashboards and business analysis tools. Near-real-time data replication using Fivetran data pipeline, native Postgres SQL and pg_cron scheduling. Created complex SQL and Postgres Functions to support business reporting and KPI visualizations.



Lippert

• United States
• Automotive
• 700 & Above Employee

• Information Technology Consultant

  • Nov 2017 - Feb 2022

  Provide value added solutions and business reporting to the MAPICS ERP system running on IBM AS/400. Designed and developed item pricing management system for model year price increases. Designed and developed manufacturing capacity planning system to predict achievable customer delivery dates based upon firmed demand and manufacturing capacity. Interfaced SSRS reporting with IBM DB2 database and developed 100+ SSRS reports to improve manufacturing through put and financial reporting. Provide value added solutions and business reporting to the MAPICS ERP system running on IBM AS/400. Designed and developed item pricing management system for model year price increases. Designed and developed manufacturing capacity planning system to predict achievable customer delivery dates based upon firmed demand and manufacturing capacity. Interfaced SSRS reporting with IBM DB2 database and developed 100+ SSRS reports to improve manufacturing through put and financial reporting.



Taylor Made Systems

• Mechanical Or Industrial Engineering
• 1 - 100 Employee

• Information Technology Consultant

  • Jan 2011 - Feb 2022

  Designed and developed a windows based Management Reporting/Executive Dashboard application integrated into the Infor™ MAPICS ERP system running on IBM AS400 servers to present both real-time and historical integrated graphical views of all aggregated sales orders, invoiced sales and inventory. Designed and developed custom Item Pricing system to apply what-if pricing models, generate customer pricing sheets and apply approved price changes to ERP system. Designed and developed a windows based Management Reporting/Executive Dashboard application integrated into the Infor™ MAPICS ERP system running on IBM AS400 servers to present both real-time and historical integrated graphical views of all aggregated sales orders, invoiced sales and inventory. Designed and developed custom Item Pricing system to apply what-if pricing models, generate customer pricing sheets and apply approved price changes to ERP system.



AnyTransactions, Inc., doing business as AnyTrax

• United States
• Public Safety
• 1 - 100 Employee

• Oracle Consultant

  • Nov 2007 - Nov 2017

  Responsible for all data architecture and database design for the entire company. Evaluated database and application software architecture of existing production database/applications and delivered recommendations to improve system reliability, flexibility and performance. Implemented plan to convert production system into an Oracle n-tier architecture utilizing Data Access Layer (DAL) and Business Logic Layer (BLL) packages in PL/SQL. Designed and implemented a "Language Manager" framework… Show more Responsible for all data architecture and database design for the entire company. Evaluated database and application software architecture of existing production database/applications and delivered recommendations to improve system reliability, flexibility and performance. Implemented plan to convert production system into an Oracle n-tier architecture utilizing Data Access Layer (DAL) and Business Logic Layer (BLL) packages in PL/SQL. Designed and implemented a "Language Manager" framework to enable the telephony system to speak to callers in 17 different languages. Developed sophisticated event scheduling algorithms to create events and actions to occur on random and recurring schedules. Responsible for the design and server-side development of client payment collection system with interface to Authorize.Net and PayPal. Show less Responsible for all data architecture and database design for the entire company. Evaluated database and application software architecture of existing production database/applications and delivered recommendations to improve system reliability, flexibility and performance. Implemented plan to convert production system into an Oracle n-tier architecture utilizing Data Access Layer (DAL) and Business Logic Layer (BLL) packages in PL/SQL. Designed and implemented a "Language Manager" framework… Show more Responsible for all data architecture and database design for the entire company. Evaluated database and application software architecture of existing production database/applications and delivered recommendations to improve system reliability, flexibility and performance. Implemented plan to convert production system into an Oracle n-tier architecture utilizing Data Access Layer (DAL) and Business Logic Layer (BLL) packages in PL/SQL. Designed and implemented a "Language Manager" framework to enable the telephony system to speak to callers in 17 different languages. Developed sophisticated event scheduling algorithms to create events and actions to occur on random and recurring schedules. Responsible for the design and server-side development of client payment collection system with interface to Authorize.Net and PayPal. Show less



Sabre Corporation

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data Management Consultant

  • Nov 2010 - Dec 2010

  Evaluated the enterprise data architecture and recommended Data Management/Data Governance solutions for the entire company. Provided technology consulting and strategic planning services to the CTO and Airline Solutions executive management. Evaluated the enterprise data architecture and recommended Data Management/Data Governance solutions for the entire company. Provided technology consulting and strategic planning services to the CTO and Airline Solutions executive management.



Priority Web Design

• Owner

  • Jan 2003 - Jan 2008

  Founder and primary developer for complex and attractive websites requiring database backend for efficient storage and retrieval of information. Specialized in Microsoft ASP.Net technologies using Microsoft Visual Studio (VB, C#) interfacing to high-availability instances of IIS and using SQL Server as the database backend. Implemented several e-commerce solutions using Authorize.Net and PayPal as payment gateways. Founder and primary developer for complex and attractive websites requiring database backend for efficient storage and retrieval of information. Specialized in Microsoft ASP.Net technologies using Microsoft Visual Studio (VB, C#) interfacing to high-availability instances of IIS and using SQL Server as the database backend. Implemented several e-commerce solutions using Authorize.Net and PayPal as payment gateways.



Shepherd Systems

• IT Services and IT Consulting

• Founder/Chief Software Architect

  • Jan 1983 - Nov 1998

  Shepherd Systems (now known as Travelport Business Intelligence™) is widely recognized as the most experienced company in the field of market intelligence for the travel industry. Shepherd Systems provides a range of web-based solutions and services for airlines, airports, travel agencies and travel-related companies. Main areas of focus are market planning, competitive analysis, sales intelligence and network planning. Shepherd's technology is used to identify areas of quantifiable missed… Show more Shepherd Systems (now known as Travelport Business Intelligence™) is widely recognized as the most experienced company in the field of market intelligence for the travel industry. Shepherd Systems provides a range of web-based solutions and services for airlines, airports, travel agencies and travel-related companies. Main areas of focus are market planning, competitive analysis, sales intelligence and network planning. Shepherd's technology is used to identify areas of quantifiable missed revenues and redirect an airline or airports' focus to regaining these opportunities quickly allowing them to respond more effectively to market conditions, minimize costs and maximize profitability. Show less Shepherd Systems (now known as Travelport Business Intelligence™) is widely recognized as the most experienced company in the field of market intelligence for the travel industry. Shepherd Systems provides a range of web-based solutions and services for airlines, airports, travel agencies and travel-related companies. Main areas of focus are market planning, competitive analysis, sales intelligence and network planning. Shepherd's technology is used to identify areas of quantifiable missed… Show more Shepherd Systems (now known as Travelport Business Intelligence™) is widely recognized as the most experienced company in the field of market intelligence for the travel industry. Shepherd Systems provides a range of web-based solutions and services for airlines, airports, travel agencies and travel-related companies. Main areas of focus are market planning, competitive analysis, sales intelligence and network planning. Shepherd's technology is used to identify areas of quantifiable missed revenues and redirect an airline or airports' focus to regaining these opportunities quickly allowing them to respond more effectively to market conditions, minimize costs and maximize profitability. Show less



Tenneco Oil & Gas

• Houston, Texas, United States

• Data Security Administrator

  • Nov 1981 - Jan 1983

  Responsible for all data security for Tenneco Oil & Gas. Responsible for all data security for Tenneco Oil & Gas.



Shell

• United Kingdom
• Oil and Gas
• 700 & Above Employee

• Programmer Analyst

  • Jul 1979 - Nov 1981

  I joined Shell Oil Company after graduating from Virginia Tech with a BS in Computer Science. I was responsible for the Shell Personnel and Payroll System (SPPS). The programming environment was PL/1 accessing an IMS database. I joined Shell Oil Company after graduating from Virginia Tech with a BS in Computer Science. I was responsible for the Shell Personnel and Payroll System (SPPS). The programming environment was PL/1 accessing an IMS database.