SUMMARY:

Multi - certified technology professional with experience in administration and development of Microsoft SQL Server 7.0/2000/2005/2008/2012 , Progress, MySQL, Sybase and Oracle databases.Strong background in data modeling, T-SQL, ETL, EDI integration/development, programming and database design. Experience with data warehouse design, implementation, maintenance and user support. 21 years client/server development with various tools.Seeking opportunities that promote growth, learning advancement, and a good working environment.

EXPERTISE HIGHLIGHTS:

Data warehousing

ETL with SSIS/DTS/SSRS

Data/Business/Systems Analysis

Data Flow & Process Mapping

C#/VB.NET Programming

Database Design & Management

Major Software/Systems Implementations

Agile Development

Testing/Scripting/Documentation

Technical Writing (Manuals/System Specs)

TECHNOLOGY SUMMARY:

Applications: Microsoft SQL Enterprise Manager, Microsoft SQL Query Analyzer, Microsoft Project,, Microsoft Visio, pcAnywhere, Macromedia Dreamweaver, Microsoft FrontPage, Microsoft Office, Microsoft .NET 2003/2005/2008/2015 , Microsoft Expression Studio, Lotus Notes, Macola, Microsoft Dynamics

Systems: Windows, Linux

Languages: C#.NET, VB.NET, SQL, PL/SQL, HTML, PHP, JavaScript, Progress, CSS, VB6

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer / Development Team Lead / Integration Specialist

Responsibilities:

• Built external components in .NET to perform file transfers, integrations, and functionality not available in the system.
• Design, Develop, and Debug Core code of our enterprise product.
• Successfully converted legacy code to HTML5
• Added many new features to the software
• Many integrations involving SSIS, .NET, and SQL.

Confidential

Senior Programmer / Analyst/ IT Director

Responsibilities:

• Design and oversee all development efforts pertaining to ERP implementation.
• Includes process analysis, integrations with existing systems, custom UI design and implementation, reporting, and new data warehouse design and implementation.
• Mentor junior developers.
• Developed a new system for production demand reporting
• Designed and implemented a new data warehouse with SSAS from the ground up using SSRS for reporting.
• Developed 98% of all integrations with a new ERP system.
• Designed and coded custom UI screens for the new ERP system.

Confidential

Senior Software Integration Engineer

Responsibilities:

• Installed, configured, and built integrations for their newborn screening applications.
• Supported the prenatal screening program for Canada and Mexico.
• Developed custom applications to support new products coming from research and development.
• Lead engineer for the prenatal newborn screening program in Canada and Mexico
• Determined specifications and developed a custom file conversion applications that provided a way to increase sales of $2,000,000 in European markets
• Mentored various junior engineers and helped enhance their SQL Server and C# skills
• Designed and developed various code libraries to help standardize installations across all customers

Confidential

Owner/President

Responsibilities:

• 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
• 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

Confidential, NAVARRE, OH

Application Development Team Lead

Responsibilities:

• 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.
• 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 to support production.
• 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

Confidential, CANTON, OH

Database Administrator

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.
• 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 player in large data migration effort from a progress database to SQL Server 2005 and a $600,000 ERP implementation
• 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

Confidential, Wooster, OH

Web Developer

Responsibilities:

• 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
• Redesigned and migrated DTS packages to SSIS
• Built a complete corporate intranet.
• Built an event registration application to replace a third party application and eliminated maintenance fees providing a cost savings of approximately $4,000 per event.