Eric Buchanan Email & Phone Number

Gilbertsville, PA, US

Royersford, Pennsylvania, United States

• Managed the end-to-end development lifecycle, from data modeling and system architecture to development, deployment and optimization.
• Oversaw a custom-written.NET and SQL Server-based sales commissioning application, a Salesforce development team, and an off-the-shelf cloud-based commissioning system.
• Designed and developed an online reporting system utilizing SSRS.
• Deployed ETL solution to provide cleaned and filtered Salesforce data for sales incentive calculations.
• Led a combination of onshore permanent, onshore temporary, and offshore permanent development and testing resources.
• Streamlined outsourced development team by combining development and testing resources, reducing development team cost by approximately 25%.

Collegeville, Pennsylvania, United States

• Managed the end-to-end development lifecycle, from data modeling and system architecture to deployment and optimization.
• Oversaw a custom-written sales commissioning application.
• Led a combination of onshore and offshore permanent development resources.
• Gathered customer requirements, architected database structure, and led development of system changes required due to frequent commission plan modifications.

• Managed the end-to-end development lifecycle, from data modeling and system architecture to deployment and optimization.
• Oversaw a custom-written sales commissioning application.
• Designed and supervised optimization of T-SQL stored procedure calculation routines, improving data integrity and increasing performance from about 60 minutes to about 20 seconds.
• Optimized client-based data import routine by porting it to SSIS, reducing lines of code by about 50%, increasing performance from about 90 minutes to under 60 seconds.
• Transitioned reporting from MS Access to Crystal Reports; removing the need for a client-side viewer.
• Led a combination of permanent and temporary development resources.

Exton, Pennsylvania, United States

• Filled various roles on various projects at this Systems Integration company. Projects include:RR Donnelley, Hills Pet Nutrition, Johnson & Johnson (Vistakon), Acutus Gladwin, Pillsbury, McDonalds, Texwipe, and.
• Developed WinForms production data collection and reporting application with SQL Server backend.
• Designed entirely new database structure to support normalized base data storage along with trigger-maintained quickly accessible reporting data.
• Worked closely with and eventually “won-over” an RRD technical resource resistant to outside involvement.
• System installed on over 100 bindery lines around the world.Hill’s Pet Nutrition
• Technical lead for a data reporting application.

Gilbertsville, Pennsylvania, United States

• Interned in the Function Test Lab, Quality System Department, and Production Engineering Department
• designed user friendly over-time calculation application
• created application for product specification tracking and charting
• developed ISO 9002 compliant document control and distribution application
• tracked raw material’s characteristics effects on final product
• analyzed manufacturing process capabilities