Manager Software Developer

Christopher D. Ware *******@*****.***

M* Technical Consultant 678-***-****

Results driven professional with over 20 years of experience managing and or supporting IT business software, servers and processes combining software development, application and technical support.

PROFESSIONAL SUMMARY

6 years’ M3 Systems Administrator

5 years’ as a Production DBA managing and supporting Enterprise SQL Servers.

7 years’ software developer\application support, report writer and database development

TECHNICAL SKILLS

M3 Software: Core M3 Products, Xi\IOS, MRM, IBI (Business Intelligence),

Stream Serve, Life Cycle Manager, Optiva, Factory Track

Programming Languages: C#/VB.NET, ASP, HTML, Delphi, COBOL

Databases/Tools: SQL Server 2000-2017, Red Gate, SSIS, IGNITE

Related Software/Tools: Lawson ERP, Application Studio, d\EPM

Reporting Tools: SSRS 2005/2012, M3 Report Manager, COGNOS, Crystal Reports

WORK EXPERIENCE

Avaap

M3 Technical Consultant December 2016 - Present

Implemented M3 13.4 environment for Avaap demo system. Included LCM, M3 Foundation, M3 Business Engine, Infor Smart Office, StreamServe, MEC and MEC Tools, DMP, FactoryTrack and Infor OS.

Worked with multiple customers to install Core M3 applications, managed multiple LCM environments, installed other applications to interface with the M3 product exposing the applications from the Infor OS.

Managed MCPs\MCEs and related fixes, communicated outages as it related to this activity and the necessity to restart the M3 Grids.

Assisted customer with Security Matrix for on premise M3 security implementation

Performed Cloud Suite configurations for CFT (Cloud File Transfer) enabling file transfer between customer server and the application environment.

Installed, configured and managed the Stream Serve Server. Created service runtimes for the M3 application.

Perform multiple environment upgrades from M3 13.2 to 13.4 and new 13.4 installations.

Perform IOS upgrades from earlier version of 12.0.22 up to 12.0.40.

Installed and configured Optiva PLM, d\EPM and FactoryTrack.

Performed FactoryTrack and Optiva PLM application upgrades.

Georgia Pacific

Lawson ERP Systems Administrator Jan 2014 – December 2016

Applied and managed fixes and data refreshes across DEV, TST, PROD, EDU environments and installed mashups in these same environments to maintain consistency throughout all environments.

Installed SharePoint, Ming.le, ION, BPW, Application Studio for BI, Report Manager and responsible for all application upgrades and server outage communications.

Managed M3 security and access, media output selections and troubleshoot and rerun jobs left in MSG status.

Installed and configured SQL Server 2008 R2 and 2012 servers in a VM environment while managing all SQL servers for Lawson ERP system (DEV, SEC, TST, EDU and PROD) to include backups and restores.

Created SQL processes/objects to automate M3 security/Media output selections for new user onboarding processes providing additional level customization for the GP M3 Product.

Georgia Pacific

Database Administrator July 2011 – March 2016

Installed and configured SQL Server 2005, 2008, 2012 and 2016.

Administrative and Development DBA experienced in ETL, Backup, Recovery, job scheduling and database tuning.

Managed database migrations from SQL 2005 to SQL 2012 to include SSRS reports and subscriptions.

Managed SQL access adhering to access by AD group guidelines and provided a report by subscription to department owners. This was useful for auditing purposes and aided in keeping AD accounts clean as possible.

Maintained SSIS packages and processes for server monitoring and notifications.

Established and maintained sound backup and recovery policies and procedures.

Created, optimized and maintained database objects, i.e., stored procedures, views, triggers.

Worked with cross functional teams to architect database designs for custom in house applications.

Written DML scripts to add or modify data due to customer enhancement requests, resulting from a job/transactional process failure and/or acquisitions of additional business segments.

Added indexes where appropriate for optimized queries, defrag and rebuild indexes when needed. Use T-SQL daily for schema changes, analytics, BI, data modeling, data cleansing.

Worked as part of a team and provided 24 x 7 support on a rotational basis.

Consulted with support teams on processes, security and data integrity and other related SQL Server issues.

Georgia Pacific

Systems Analyst November 2004 – July 2011

Coordinated and Maintained System Design changes or enhancements to ensure compliance with SLA’s.

Coordinated the application design process to analyze, evaluate, implement, and maintain design developed for internal or external customers.

Researched and Identify ways to improve software design and process improvements.

Participated in weekly change control meetings to ensure all changes were represented before promoting to Production.

Extensive experience in creating reports such as drill down reports, parameterized reports, linked reports, and Chart reports using SQL Server Reporting Services.

Enterprise level report writer who translates functional and technical specifications into clear and concise Maintenance, Financial and Administrative reports.

Converted over 200 legacy reports from Crystal to SQL Reports supporting enterprise migration.

Written DML scripts to add or modify data due to customer enhancement requests, results from a job/transactional process/failure and/or acquisitions of additional business segments.

Expert level skill in Extraction, Transformation and Loading (ETL) in SQL Server databases.

Participated in complete project life cycle by collaborating with development teams and end users gathering requirements, production implementation and application support.

Developed SSRS reports and incorporated Dundas charting to deliver a more analytical report solution based on customer and business requirements to display key metrics.

Developed pilot application for maintenance purchases later developed into enterprise application for cost trending.

EDUCATION

1997 – 2000 DEVRY INSTITUTE OF TECHNOLOGY COLUMBUS, OH

BS, Computer Information Systems

Contact this candidate