Hi, I'm Greg

As a Business Data Readiness Analyst, I ensured data accuracy, completeness, and readiness to support 3M’s migration from legacy systems to SAP. I collaborated with business and technical teams to validate and optimize data, facilitating seamless integration across applications, databases, and platforms.

Key Responsibilities:

• Data Validation & Integration: Partnered with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping for analytics initiatives. Ensured data integrity and successful integration across various systems.
• Stakeholder Collaboration: Worked with BI analysts and stakeholders to identify reporting needs and deliver tailored, data-driven solutions. Coordinated with Country/Area SMEs to define data mapping, transformation logic, and governance strategies.
• Reporting & Analytics: Developed and analyzed end-to-end readiness dashboards using Excel and Power BI. Addressed process-related errors in inter-company, subcontracting, third-party suppliers, and global trade services.
• Data Management: Created ad-hoc reports, stored procedures, and data extractions using SQL across Snowflake, MSSQL, and legacy systems, supporting reporting and analytics.
• Data Governance: Contributed to data governance by establishing and enforcing quality policies and best practices to ensure reliable data.
• Process Improvement: Identified and addressed gaps in data processes, collaborating with teams to enhance workflows and improve data readiness for system deployments.
• Communication & Documentation: Provided updates on project status, action items, and data gaps to Deployment Leads and stakeholders across global and regional teams.

Attended as a Full-time MBA Candidate at Maryville University. In addition to the core MBA courses, I have completed the following IT concentration courses:

Information Technology Management. This course presents the concepts needed to manage information technology resources. It specifically focuses on the role of a chief information officer; planning, scheduling, and risk considerations; and the strategic role of information technology systems in an organization.

Agile Analysis and Design. This course reviews the development of requirements, analysis, and design in an agile environment — and helps enhance critical thinking skills.

Database Principles. This course examines the design, development, and management of relational databases, and the integration of these databases with applications across the enterprise.

Data Analytics. This course serves as an introduction to data analytics — the use of data, quantitative analysis, and modeling to drive business decisions. It also covers specific data mining techniques to illustrate business decision-making.

VERIFY on blockchain: https://blockchain.maryville.edu/certificate/97459072625350ec9f8e4d021c1e3078

• Maintained current and accurate knowledge of data storage and management best practices.
• Installed, configured, and maintained SQL 2008, SQL 2008 R2, SQL 2012, SQL 2014, SQL 2016, SQL 2017, and SQL 2019 servers across physical, virtual, and clustered environments.
• Created installation scripts and procedures to streamline the installation process using T-SQL and PowerShell.
• Part of a team that provided 24x7 support on over 400 instances in various environments, including physical, virtual, and clustered.
• Ensured databases were implemented following specifications and standards, focusing on recoverability, performance, and efficiency.
• Gathered, organized, and provided statistical data/reports from assigned databases and maintained documentation and standards.
• Worked with application analysts to verify DB’s backup needs were identified and implemented.
• Worked with staff, clinicians, consultants, and vendors to identify system issues and provided conflict resolution.

Key projects:

• Created a Central Management Server (CMS) instance to store a list of instances of SQL Server and organized into CMS groups to save time during frequent maintenance processes.
• Updated maintenance plans to provide a more robust solution, and drastically improving Recovery Point Objective (RPO) and Recovery Time Objective (RTO).
• Created documentation that provides guidelines for maintenance tasks, policies, and procedures following industry best practices.
• Updated 104 SSIS packages changing a statically set OutputFolder location to a variable for ease of maintenance.
• Installed, and configured SSRS and created multiple reports for Infrastructure Team.
• Installed, and configured Grafana to monitor the top 12 databases.

Skills: Ad Hoc Reporting · Powershell · Database Administration · Data Analysis · Business Process Improvement · Technical Writing · Problem Solving · Data Analytics · SQL

• Worked with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions.
• Participated in IT technology governance and strategy to develop planning guidelines for integration efforts.
• Communicated complex technical concepts effectively, both verbally and in writing.
• Developed and monitored solutions using standardized integration engine and tools.
• Responsible for the efficient, compliant, timely, and secure acquisition, integration, provision, management, and exchange of the enterprise data.
• Created, executed, and documented unit test plans for ETL and data integration processes and programs.
• Monitored and administered automated and manual data integration and ETL jobs to verify execution and measure performance.
• Adhered to ETL, integration engines, and data warehouse best practices.
• Assisted other employees in the ETL tools, programs, processes, and best practices.
• Maintained appropriate system documentation in accordance with department standards.
• Served as liaison between IT and the end-user community.
• Ensured reports and information is provided to end-user on a timely basis.
• Provided data needed for meaningful use and compliance reporting.
• Configured and tested applications to validate systems will perform as intended prior to upgrades/implementations.

Key projects:

• Developed 27 custom financial and auditing reports using T-SQL, and MS Excel.