Allison Park, Pennsylvania, United States
Experience Summary: Highly technical project leader/architect with experience in the design and execution of large Database Systems, Master Data Management Solutions (Oracle and Informatica), ERP Implementation (Oracle R12 and MS Dynamics AX), Data Warehouse, Data Analytic systems, Web E-commerce solutions, business process analysis, supply chain integration, cloud transformation, large scale network design/operation and the application of IT technologies to solve real world business needs. Extensive experience in the creation of B2B supply chain integration models and working with multiple upstream and downstream supply chain members to create integrated networks/API/Access points. Over thirty years of experience designing and supporting large scale Oracle, MS SQL Server, Teradata and other relational databases, Data warehouses, Data lakes and reporting systems. Technical Summary: Database: Expert level in Oracle RDMS (architect and DBA 30+ years) and applications, DB2, Teradata and Microsoft SQL Server Business Intelligence tools: Power Bi, IBI Webfocus, Cognos, AI Machine learning based reporting ERP Systems: Oracle E-Business Suite R12 ERP Manufacturing and Financials, Microsoft Dynamics AX for Manufacturing, MS CRM, Oracle Peoplesoft CRM Master Data Management: Oracle Data Hubs, Informatica (P360, C360, S360, R360), IBM Cloudpak ETL Technologies: Informatica Powercenter, IICS, Data Integrator, SSIS, SSAS Programming: Cobol, HTML, JS, C#, Python and VB OS (Support and install level): MVS, Linux, Windows, Openshift Integration Tools: Informatica Powercenter, Informatica IDMC, Snowflake, Denodo data virtualization, Oracle CIC, Weblogics. Data Stewardship: Creation of Data Extraction tools, Data Cleansing tools and Data loading tools. Cloud: MS Azure SQL, AWS, Redshift, Oracle SAAS, Oracle Cloud, XML, JSON, Hadoop, Metadata management Other: EDI x.12, Splunk Soft Skills: Extensive Project Management and Program Management using Waterfall, agile methodologies and hybrid project management. Experienced in Jira and Servicenow. Extensive C-Level reporting and project reporting experience. Exceptional skills in Data Architecture, Data Mining and Data Analytics. Expert skills in Data Warehouse, Data Marts, Data lake and enterprise data reporting functions. Advanced skills and experience in IT audit, Security, Sarbanes Oxley and SOX compliance
Senior project leader for redesign of menu. product, site and contact data domains using Stibo Step and extensive custom development. System drives front end of business with deep integration to POS, Digital sales channels and sales reporting.
Responsible for the establishment of a Data Stewardship/Data Quality practice with responsibility for enterprise data assets, metadata management and enterprise data catalog as well as establishing the Data Stewardship practice. Responsibilities include formation of teams, specification of technical architecture, creation of business use cases and requirements, inclusion of cyber security requirements for PII protection and executing of the Data Stewardship program. Leading a group of enterprise architects to transform IT from a centralized, application package oriented to cloud-based Azure, Hadoop and AWS technologies in support of expanding business objectives. Implementation of Middleware and Denodo data virtualization technologies. Project architect responsible for migration of Data Warehouse and Data Lake from on-prem legacy ad-hoc reporting to cloud based data analytics.
Founding member and senior data architect/Project Leader responsible for Master Data Management and Data Syndication using Customer, Supplier, Item and Reference data models. Project technology leader for establishment of Data Quality, Data Profiling, Metadata management and multiple downstream integrations of mastered data into ERP and CRM systems using API and Micro services. Establishment of Data Lake and reporting capabilities for enterprise MDM. Ownership of technology stack and data infrastructure using Oracle, Microsoft and Informatica technologies. Created multiple Web based sales enablement tools, using MDM as basis, to facilitate increased sales, cycle time reduction, cost reduction and expansion of product sets. Enterprise Data Architect for expansion of existing Data Warehouse, Data dashboards and integration technologies. Architect for enterprise data pipelines, ETL/ELT and micro-services to facilitate flow of data from multiple ERP/POS systems to reporting platforms. Hands-on coding of multiple custom and Informatica based ETL, data interface, data cleaning and API/micro service tools using C#, VB, Linux scripting, Oracle PL/SQL, XML, JSON, Flat file, X.12 EDI in a secure and controlled DEV/Ops environment. Senior project leader for multiple business M&A (Merger and Acquisition activities) project planning, business requirements elicitation and project coordination/execution across multiple teams of LOB based SME’s. Transformations include 16 acquired companies representing 70 new branch offices with $3.5B in net revenue addition. Broad technical expertise including Oracle E-Business Suite, Microsoft Dynamics AX, Epicor Profit21, Epicor Eclipse and multiple Wesco legacy systems. Senior architect for Oracle EBS ERP enterprise wide digital transformation and replacement of multiple legacy ERP systems. Area of responsibility centered in Item Master, Supplier Master and Customer Master as well as extensive product pricing analysis.
Manager of IT department for a $400M industry leading manufacturer for Doors and Window systems for the commercial and residential construction markets. Responsible for 10 FTE’s and 4 computing platforms including manufacturing production, production planning, product design and enterprise resource planning. Hands-on experience in Oracle EBS ERP Manufacturing and Financials ERP system and Oracle Peoplesoft CRM. Hands-on technical roles in the areas of Manufacturing SME, Data Designer, Data Warehouse designer and business analytic reporting designer. Manager responsible for budget, personnel management and technical infrastructure/Data Center. Chief designer and programmer for company E-Commerce web solution to provide direct B2B customer product links.
Formally TRW Corporation, Products and Services Division 07/02 – 03/06 Group Manager, Industrial Operations 8/99 – 07/02 – Program Manager, Outsourcing Engagement Chief designer/Group Manager responsible for design, programming and infrastructure to create the Opentrac and Steelpartner Cloud based SAAS systems. These systems provide SAAS ERP solution and B2B trading community to support the movement of flat roll steel products in North America. Program Director responsible for an IT Outsourcing/SAAS engagement at Wheeling-Pittsburgh Steel. Senior IT management resource at client site responsible for supervision and mentorship of 200+ staff and budget in excess of $2M/month in combined IT services. Leader of software modernization program to install Oracle ERP and modernize business practices at client.