Ms Sql Data Engineer

Norman Mast, MBA, PMP

*** ******* ****** ****, *********, TX 78063

785-***-**** **********@*****.***

Project Manager MS Database Developer SQL DBA SQL Developer ERP Specialist

Versatile IT professional with 20+ years of experience as an influential leader in IT management, database development, and project management. Adept at optimizing operational efficiency through innovative solutions and strategic management. Proven success in steering complex projects across large organizations, enhancing team performance, and implementing technology-driven improvements.

Skill Areas: Strategic & Operations Planning Staff performance improvement Matrix project management

Database Development MS SQL Project Management: Certified PMP Successful implementation ERP Administration Data Analysis & ETL Cloud Solutions Presentations P & L Management Process Improvement Cross Function Team Leadership Competitive Analysis Training Problem Solving Leadership Strong Interpersonal Skills Analytical Skills Client Relationship Management Team Management Communications

PROFESSIONAL EXPERIENCE

ERP Specialist

Kalmar (Subsidiary of Cargotec, Inc) June 2023 - November 2023

®Spearheaded ERP administration, efficiently managing user profiles, and optimizing job processes for heightened system performance.

®Applied strategic oversight to set up and modify user profiles, ensuring seamless operations of various tasks within the ERP system.

®Worked with the job shop software in putting work centers, and job routings into place.

®Developed reports using Cyberquery against the ERP database.

Data Analyst

BlackKnight (Contracted through Modis Consulting) June 2022 - June 2023

®Orchestrated ETL processes, ensuring the smooth loading and superior performance of Real Estate software

products.

®Executed data analysis, enhancing efficiency and reliability in data management tasks.

®Monitored ETL data loads.

MS SQL Developer

SkillPath, Mission, KS (Contracted through LRS Consulting) August 2021 - April 2022

®Drove the transition of data from AS400 to MS SQL, creating views, functions, and managing schema migrations.

®Played a pivotal role in executing strategic data movements and schema adjustments during the company's technological transition.

®Developed shell scripts for ETL unloading from AS400 and ETL loading into the MS SQL database.

®Developed many queries to be used for the MDM (Master Data Management) Python product.

MS SQL Developer

Ethnos360 March 2021 - August 2021

®Volunteered 20 hours weekly, contributing to the development of views, functions, and seamless schema transfers between databases both on-prem and in Azure.

®Applied technical proficiency to enhance data management and storage capabilities.

®Developed queries to copy data back and forth to Azure databases.

MS SQL DBA

State of Kansas, Department of Labor December 2019 - January 2021

®Contributed to the development of views, functions, and seamless schema transfers between databases.

®Worked closely with the development group in optimizing their software.

®Applied technical proficiency to enhance data management and storage capabilities.

®Managed databases for the Pandemic Unemployment Assistance group, overseeing backups, data copying, and SQL script writing for reporting

®Successfully led ETL processes, facilitating efficient data transfers between mainframe computers and banks.

Senior Systems Analyst & Project Manager

MidAmerica Point of Sale June 2012 - December 2019

®Championed the development of macro-enabled Excel reports, consolidating data from ERP and CRM systems for automated reporting to McDonald’s.

®I created many automated as well as Ad-Hoc BI reports to specifications for McDonald’s corporate.

®Led two successful system-level upgrades for the Great Plains ERP system, enhancing functionality and user experience.

®I was able to save this company about $5,000 per month by enabling the emailing of PDF billing instead of mailing the bills through the postal service.

Software Engineer

City of Topeka June 2011 - June 2012

®Oversaw the seamless integration of third-party online application software into Lawson ERP for HR, streamlining human resource management processes.

®I developed macro-enabled Excel pulls to download data from various banks for the Accounts Payable clerks.

Adjunct CIS Professor

Baker University, Ottawa University, Friends University June 2010 - Fall 2019

®Designed and delivered comprehensive courses in various IT disciplines, providing students with practical skills and knowledge.

Project Manager/Database Administrator

Baker University June 2005 – June 2020

®Created views and procedures for various applications around the campus using MS SQL.

®I was responsible for the development of the RFP for the new ERP system.

®I was responsible for the successful implementation of CampusManagement’s ERP system.

®I merged the data from the various applications through the campus. For example, a person could be listed in the Registar’s office, in the Financial office, in the Admissions office, in the Nursing School, in the Alumni office, and in the Graduate program office. The names, and addresses may be slightly different in all of them, and I had to figure out the most valid data.

Development Team Lead

Sprint PCS August 2000 – June 2005

®Led my 12 person team in developing ETL software. I would receive requirements from the Business Analysts and Project Managers and after walking through the requirements, assign the project to members of my team.

®The coding was done in C, hitting APIs on Oracle Databases on UNIX platforms.

®After the data was brought down to our system, it was then transferred to various departments around Sprint using FTP.

PRIOR EMPLOYMENT DETAILS

Senior Systems Analyst

Republic Group, Inc. 1994 – 1999

I was the Oracle Database Administrator for this company and helped implement PROMIX, an ERP system

I developed data loads and data pulls from the databases for the various departments as needed.

Systems Manager

Lowen Corporation 1992 – 1994

I implemented SYMIX, an ERP system.

My six member team built and installed PCs across the company.

We also put in dedicated data lines to make sure the entire company had access to the ERP system.

Systems Analyst

Computer, INC 1990 – 1991 (Pharmacy software)

At Computer, Inc, I developed and implemented a polling system to communicate every night with the 80 clients that we had, in order to download third party billing to us for processing, and update their systems with new drug prices.

Support Programmer/Analyst

Kmart Corporation (FoxMeyer Drug Company, subcontractor) 1984 – 1990

I was the programmer that supported the help desk for support the 1500 pharmacies that Kmart had.

The programming was done in C and COBOL.

PROFESSIONAL DEVELOPMENT & CREDENTIALS

Bachelor of Science, Management, Newman University, Wichita, KS

Master of Business Administration, Washburn University, Topeka, KS

Certified Project Management Professional (PMP), Project Management Institute, Certificate #534972, issued June 2008

Technology Proficiency: SQL (MS SQL, Oracle), ANSI C programming, ERP Systems (Great Plains, Lawson), Excel Macros and Reporting

Courses Taught: Introduction to Business Online Business Human Resource Management Organizational Behavior Leveraging Business Data Project Management Intro to IT Technology for the Workplace Telecommunications and Networking Integrating GIS in Your World Object-oriented Analysis & Design Operating Systems Database Design

Contact this candidate