Steve Mcmasters Email & Phone Number

Lincoln, Ne, Us

Lincoln, Ne, Us

Lincoln, Nebraska, Us

Cincinnati, Oh, Us

Design and build architectural data solutions for Microsoft Azure. Create pipelines and workflows. Implement, and maintain client SQL data warehouses. Update, monitor and maintain ETL processes for loading data warehouses. Develop cloud based warehouses as a conduit for dynamically interfacing multiple applications. Develop and implement custom databases, views, tables and procedures to accommodate and standardize non-conforming client data sets. Work with Microsoft SQL Server Management Studio (SSMS) on a daily basis to implement these processes, including writing queries, designing and creating tables, designing and creating views, and other needed implements. Generate datasets for Power BI and SSRS based reports. Work in Power BI and SSRS to design, create, and edit dashboards and reports. Develop and lead client training sessions. Write product documentation, use guides, and other client documents.

Lincoln, Ne, Us

Implement, and maintain SQL data warehouse for the clients’ data. Update, monitor and maintain ETL processes loading client data into SQL data warehouse as well as using the warehouse as a conduit for dynamically interfacing multiple applications. Develop and implement custom data warehouse tables and procedures to accommodate and standardize non-conforming client data sets. Work with Microsoft SQL Server Management Studio (SSMS) on a daily basis to implement these processes, including routine analysis of performance and optimization using the Query Analyzer tool. Create and implement marketing models based on historical client account openings and traffic based cellular phone patterns. Analyze client’s market penetration within marketing routes and create visual displays based on analysis. Analyze client account openings for new and existing households within marketed routes and create visual displays based on analysis. Perform ROI analysis of marketing campaigns and generate client facing graphs and spreadsheets. Perform monthly EOM reports for clients, including openings, account categorizations, and standard customer demographics.

Lincoln, Ne, Us

Design, build, implement, and maintain SQL data warehouse for the various business systems. Develop, monitor and maintain ETL processes for updating information in SQL data warehouse as well as using the warehouse as a conduit for dynamically interfacing multiple applications. Create and use ETL process, stored procedures, and script files to allow for automatic transfer and update of application data, based on data in different applications. Work with Microsoft SQL Server Management Studio (SSMS) on a daily basis to implement these processes, including routine analysis of performance and optimization using the Query Analyzer tool. Work with Development department to design data models for use in analysis of member campaigns. Prepare, analyze, and present results of findings based on key performance data indicators. Perform ROI analysis of campaigns and events and create finding presentations. Maintain existing reports based on data from multiple applications across the data warehouse. Design and build reports and dashboards to convey campaign results, daily task functions, and any as needed reporting requirements. Supervise Business System Analysts and Customer Service Department. Manage, document, and maintain customer and financial database systems. Identify problems and areas of possible improvement, design, build and implement efficiencies into routine process to increase automation and reduce staff requirements for data tasks. Develop, redesign, and implement ASP.NET website application for donation module of primary customer management system. Design, develop, and maintain ASP.NET process application used to provide end user access to process initiation and data manipulation using cloud based application format on company intranet. Serve as primary technical contact with third party software and application vendors.

Lincoln, Ne, Us

Create integrations and datasets from multiple diverse enterprise systems for use in data analysis and reporting. Design, develop, and maintain functional reports/reporting system and BI/analytical reporting dashboards. Analyze student data and prepare executive presentations for Student Success initiative and KPI progress and achievement. Manage online reporting environment. Manage data documentation project. Design, develop, and maintain system wide reporting style template for online reporting system. Provide support and assistance for report writers throughout various colleges. Create reporting system documentation. Work on campus wide project to create single data warehouse to integrate various data sources via ETL and direct connections. Design and develop OLAP data warehouse architecture and data structures. Work with decision makers to define, develop and provide business intelligence data streams and analytical reporting based on individualized requirements. Worked as part of Data Governance group.

Provide analysis of software, hardware, and networking options and recommendations based on client needs and requirements. Implement new systems for clients. Manage projects from creation through implementation. Plan and implement the conversion of legacy data management systems into new systems. Train client personnel and provide augmented documentation specific to client processes. Support legacy software applications and systems, including upgrades, programming changes, report writing, and routine maintenance. Work with clients on designing web presence and developing strategies for using internet based systems in day to day business.

Worked with outside providers to setup and maintain IT services. Managed evaluation, purchasing, installation, implementation, and ongoing maintenance of third party software systems critical to the business needs. Redesigned and developed management information systems in client/server and online formats, using various programming languages including ASP.NET. Managed systems and system wide projects. Designed and developed various web services and ASP.NET applications. Administered SQL database system. Developed business and client assessment software solutions - guiding through full life cycle software development process, including design, programming, testing, data transferring, reporting, implementation, training, and documentation. Analyzed and processed raw assessment data for use in generating population norm sets. Designed, developed and maintained reporting servers and systems used on management information systems. Managed long and short term projects. Designed and implemented company wide data warehouse. Trained clients in use of software applications.

Implemented business solutions using an ASP modeled system. Managed short term client projects. Managed short and long term company projects. Designed, developed, and implemented web presence for clients in diverse industries. Worked directly with customers at all stages of product development and implementation. Created online catalog application. Developed storefront e-commerce ASP modeled application and worked extensively on order processing applications (payment processing). Took over development of major client's online inspection and auditing software. Developed online STOP Traffic program application used by the Lancaster County Attorney's office. Trained client personnel, provided customer support, and wrote documentation. Worked to develop marketing strategies and campaigns. Presented products at shows and conventions.

Master'S Degree (Working Towards), Survey Research And Methodology

Bachelor Of Science (B.S.), Computer Science