|
Chad Marsh |
||||||||||||||||||||||||||||
|
2930 Meadowbrook Dr § Wooster, OH 44691 § Phone: 330-601-0959 § chad@micaden.com |
||||||||||||||||||||||||||||
|
DATABASE ADMINISTRATOR/DEVELOPER Multi-certified technology professional with experience in administration and development of Microsoft SQL Server 7.0/2000/2005/2008, Progress, MySQL, Sybase and Oracle databases. Strong background in data modeling, T-SQL, ETL, EDI integration/development and database design. Experience with data warehouse design, implementation, maintenance and user support. Eleven years client/server development with various tools. Seeking opportunities that promote growth, learning advancement, and a good working environment. Expertise Highlights
Professional Experience
Software development/consulting. Work with a company called Maintenance Connection as their Integration Specialist. Custom web site/ client server application development, Database administration and ERP integration Key Results: § Commercial Soybean Breeding web site § Behavioral Health Professionals web site with web service integration and credit card processing § Maintenance Connection - Integration Specialist § DuPont client server applications
Manage application development projects, collect and analyze business requirements from users, Code solutions in VB/C#.NET, MSSQL 2005, and Oracle. Provide full support for a data warehouse consisting of 7 cubes. Schedule the developer resources for completing requests, quality check developer code. Meet with the business on a regular basis to assess needs and priorities. Key Results: § Led new data mart development efforts and migration to SQL2005 § Developed and supported integrations efforts between Oracle and SQL2005 via SSIS packages and stored procedures § Implemented new quality improvement standards for SQL development as well as applications in C# § Designed and built new web applications in .Net 2005/SQL 2005. § Managed the Application Development Team by assigning work, tracking process, and code quality assurance testing. § Database Administration for 4 SQL servers. Designed and deployed maintenance/backup plans for critical and non critical databases. § Automated previously manual, time-consuming processes to drive gains in data tracking/accuracy, workgroup efficiency and profitability. § Data analysis with cubes, excel, and presentation with SSRS. § Configure and Maintain transaction replication between multiple production databases § Manage EDI communications and develop solutions to handle integration with the ERP
Database Administrator Database responsibilities:
Maintain/optimize 5 SQL Servers. Develop stored procedures, functions,
triggers, and CLR user- defined functions. Develop all SSIS jobs for
transferring data from a Progress 91D database. Develop and maintain a data
warehouse. Build SSAS projects. Prepare data requests for Crystal Reports. Programming
responsibilities: Design and compose project charters and technical
specifications. Code client server applications, web services, and ASP.Net
web sites in VB/C#.NET. Troubleshoot and debug software. Maintain and update
software written to run machines via PLC. Key Results: § Key player in large data migration effort from a progress database to SQL Server 2005 § Converted MS Access programs written in German to SQL Server for a more stable environment. § Developed better data entry and integration systems using SQL Server 2005 and C#.NET
Web Developer Analyze project requirements. Design and develop web applications and client server software with .NET 2003/2005, PHP, JavaScript, Microsoft SQL 2000/2005, Integrated Services, MySQL, and Sybase. Train users, and maintain existing code and databases. Build and maintain IIS and Linux/Apache web servers. Coordinate the implementation of new applications, and major development Key Results: § Redesigned and migrated DTS packages to SSIS § Built a complete intranet with employee time off system § Built an event registration application to replace a third party application and eliminated maintenance fees.
Research Associate Develop custom software upon request using VB6, .NET 2003, SQL Server 7.0, MSAccess and Sybase. Install, maintain, and support PC Systems. Train users and work with personnel at other centers across NA, Chile, and Puerto Rico to implement new technologies. Full life cycle development on software to interact with PLC's on combines, and Pocket PC development. Supervisory duties over 5 staff members Key Results: § Designed and built software to automate lab duties and data gathering § Earned a patent on technologies designed for automated harvesting and plant selections. Patent No 7,403,855 Education
Bachelors in Computer Science 2004
Associates of Applied Science 1996 Technology Summary
|