Greg Lowe Email & Phone Number

Enola, Pennsylvania, Us

Enola, Pennsylvania, Us

● Manage Data Analytics Team consisting of Administrators, Engineers and Analysts● Strong Focus on People, Process and Technology to continuously deliver incremental business value● Develop Enterprise Information Strategy and Technology Roadmaps for Data Management● Architect Modern Data Warehouse with SQL Server and Azure Data Services● Administer high volume databases supporting highly critical applications serving 100k+ daily users● Develop Information Architecture for managing the movement of data throughout the Enterprise● Acting Data Governance Program Manager and Data Administration Manager● Architecting Solutions in Databricks, ADLS2 using Python and Delta Lake Tables● Leading Initiative for Metadata Management to document data lineage and impact analysis● Working on improving Enterprise Data Literacy and Data Ownership● Driving force for Agile processes including SCRUM and Kanban using Azure DevOps● Develop and Implement Change and Release Management Processes● Creating Descriptive and Predictive Analytic Models with Azure Data Lake and Databricks● Architect and Develop Data Integration across a range of technologies, sources and destinations● Develop models for databases, data flows, and business processes● Manage Data Security model and implementation (PCIDSS) across Data Services● Implement CI/CD for Databases and ETL deployments utilizing Azure DevOps and GIT● Lead Data Quality assessments and work processes to improve data● Implementing Data Science Program in support of Enterprise Initiatives● Manage a team building Power BI Dashboards to provide actionable insight into trends ● Architected Business Intelligence program leveraging Power BI in Azure (Including self service)● Mentor Data Engineers and BI Engineers to guide and continually improve skills● Manage a 100% Remote Team with Business Unit Stakeholders also working Remote● Drive Governance via Policy and Procedures, Standards, Guidelines for Enterprise Processes

I operate a small consulting business specializing in Data Management. I do Database Design, Project Planning, Data Migration, Backup and Recovery, Data Modeling, Data Warehousing and other functions of Data Management for small and medium size business in my area. I operate remotely in their systems and assist with projects where my expertise is needed. I am a Microsoft Certified Professional (MCP) in Querying Microsoft SQL Server 2012 (461).

York, Pennsylvania, Us

Manage and Administrate Operation SQL Server DatabasesManage and Administrate Data WarehouseManage and Architect Reporting Environment in SSRSDevelop and Architect ETL Process to load Data Warehouse using SSIS

York, Pennsylvania, Us

Mechanicsburg, Pennsylvania, Us

●Lead Data Modeler on Navy ERP●Use Erwin to model Logical and Physical SAP Database●Collect and maintain metadata for database objects●Maintain model with sustainment actives and work with development teams to keep models current●Maintain models to meet standards for DODAF requirements●Build work plans and assign tasks to team members●Onboard new team members and bring up to speed on tasks and policies

Mechanicsburg, Pa, Us

●Data Architect for Pennsylvania School Board Association – Focusing on Data Technologies for Insurance Services●Member of IT Management●Data Architect on Data Warehouse Implementation for Insurance Services●Data Architect on Enterprise Reporting Implementation for Insurance Services●Designed Dimensional Data Model for Data Warehouse incorporating data from four key source systems – Customer Relationship Management (CRM), Policy Creation, Policy Billing and Claims Processing●Evaluated work from prior consultants and produced documentation and presentations on their work, noting their strengths and deficiencies and made recommendations for improvement●Designed ETL Processes for the enterprise – Utilizing SQL Server Integration Services●Manage and administer reporting in SQL Server Reporting Services●Design, develop, administrate and maintain database management systems (DBMS) on Microsoft SQL Server 2005, 2008 and 2012●Migrate Microsoft SQL Server Databases from 2005 to 2008 and 2008 to 2012●Program database processes in T-SQL●Design Data Architecture for all data related functions●Database design for customer Portals and Intranets●Design database security and information security following Industry Best Practices●Work with project teams and help guide the technical needs of the organization●Discuss business needs with the project team and have them question current business process and offer suggestions on how information technology can simplify their functions●Develop budgets for projects and work to secure the funding for those projects●Developed Coding Standards for database programming and design●Utilize Embarcadero Data Architect tool to model existing databases and reverse engineer already existing databases that do not have documentation●Create and develop logical and physical models and distribute them throughout the IT organization to allow other developers and report writers to understand the database design

• Technical Expert on database redesign for a system upgrade• Participated in collaborative meetings to design the new system based on customers prior experiences and process changes to produce the most efficient system for the customer• Database modeling and relational design of new database in Erwin• Assisted in 10g to 11g Upgrade – Updated scripts, tuned queries for 11g Optimizer• Designed and produced a versioning system to allow the system to be audited and rolled back to any state in time using PL/SQL packages and triggers• Developed data migration procedures and code to migrate from old version of the database to the new version in PL/SQL• Developed and deployed database encryption mechanisms for PII in production system• Experience implementing Oracle Database Security Technical Implementation Guide• Developed Unix scripts in KORN to complete database tasks such as loads and processing jobs• Monitor Database jobs, parse errors and resolve logic errors in the database• Write complex queries for data calls and reports for clients

Participated in a Pilot project for an SAP ECC 6.0 implementation in Portugal at two manufacturing facilitiesLead technical data conversion of legacy systems into SAP for a new SAP implementationProvide subject matter expertise on data management topics such as metadata management, data interoperability standards, data quality, data governance, data development, reference and master data management, data integration, data warehousing and data security managementExperienced in providing technical data & information architecture leadership on large, complex, enterprise class SDLC projectsFacilitate meetings with technical and business stakeholders to determine data and interoperability requirementsExperienced in identifying, analyzing and translating business requirements into conceptual, logical and physical data models in complex ERP environmentsExperienced in identifying and documenting data integration issues and challenges such as duplicate data, non-conformed data, and unclean dataExperienced in developing global data conversion processes, develop conversion rules with business, produce documentation and instructions defining the process, develop technical process (Oracle database coding), manage developers and data team members, communicate process and information throughout the companyExperience working with global teams, remotely and on location, that consist of many cultures to meet project milestonesDBA for Oracle data warehouse that is used to store company data; data is loaded from legacy systems, converted by using custom Oracle scripts and formatted to load into SAPDevelop and maintain Legacy System Migration Workbench (LSMW) applications used to load flat file data into SAP Hands-on Dimensional modeling and ER data modeling experienceKnowledgeable in OLAP, BI and Data MiningData analysis skills using SQL, TOAD or SQL Developer toolExperienced in delivering quality work on time with multiple, competing priorities

• Project Manager – Work with business process experts to develop business requirements for new software projects. Develop project plans and scopes of work. Schedule projects balancing resources which are primarily time and personnel. Coordinate all requirements with Application Developers, Testers, Report builders and DBAs. Work with developers to make sure requirements are met and with customer to ensure all needs are met. Manage upwards of six projects simultaneously. Track projects in MS Project and use Project Workspaces to store all documentation, keep it version controlled, track issues, risks and involve customers in the project throughout the process.• Oracle DBA - Design, development and maintain Oracle 10.2.0.3 Databases: Production, Test and Development. Production databases are used by 12 applications and a user size of 800. Maintain backups and monitor and tune for performance. Develop scripts using PL/SQL for database operations. Develop complex reports to allow Lean Six Sigma Team to track and improve operations. Operate in a Windows Server 2003 environment. • Oracle AS Administrator - Administer Oracle Application Server 10.1.2.2 & 10.1.3.1: Production and Test environment. Configure OHS, Web Cache, Forms and OC4J. Maintain configuration of all servers, manage user accounts using Oracle Identity Management and apply OPatches to keep installations up to date. • Application Developer - Create Applications using Oracle Application Express (Formerly HTML-DB). Have developed 7 applications in two years.• Developed a database and application that will be used by all Directorates to track all Contract and IMPAC Depot Purchases. Users record all items purchased, supervisors approve purchases, all receipts are recorded and the Directorate of Contracting records payments of all depot contracts. Application replaced six others and increased visibility of purchases.

Ms, Computer Systems Management

Bs, Computer Science