Eric Geib Email & Phone Number

Bedford, Nh

Performed data refreshes for client schools, a semi-automated process that maintains role-based (e.g. parent, student, employee) user profiles in the Blackbaud database, including demographic data and user relationships.• Assessed the CSV data files uploaded by schools, verifying their adequacy for processing.• Executed SQL scripts in MS SQL Server to cleanse and process the files. Created ad hoc SQL queries to perform data fixes as necessary.• Supplied MS Excel reports to schools conveying processing results, including user profiles added and any errors found. Promptly addressed any questions or issues raised by the schools.• Trained & advised colleagues on how to perform data refreshes and data fixes.Assisted the data team with developing data imports, a fully automated process intended to replace data refreshes, which allow a school to maintain their user profiles without direct assistance from Blackbaud.• Conducted QA testing on data imports to verify proper functioning, and to identify possible bugs.• Helped to prepare documentation for the data imports, including data scrubbing steps and error message explanations.

Columbus, In

• Updated a custom ASP web app and MS SQL Server database for university employees to store and track faculty and HR data, including courses taught and professional achievements.• Used Crystal Reports to generate custom reports. Set up permissions via user groups to protect sensitive data.• Developed a custom web app for faculty to input and store academic major & degree program data in an MS Access database. Created web page templates used to output the information in a consistent and attractive format for a new campus website.

Columbus, In

• Developed a web app and SQL Server database allowing outside organizations to submit community grant proposals to the company via the corporate website.• Converted a web app from MS Access to MS SQL Server that tracks corporate environmental waste for each plant site.• Assisted with developing a web app for MS SQL Server used by the company’s worldwide sites to document their business operating procedures in compliance with Sarbanes-Oxley.

Columbus, In

• Developed an internal customer service rating system from scratch using MS Access 97, VBA and SQL. Set up user-level security on the database to protect sensitive data.

Columbus, In

• Developed an internal LAN app using MS Access 2000 and MS FrontPage 2000 to support the company’s daily billable cycle.

Columbus, In

Worked on a cross-functional team developing a gear train for a new heavy-duty diesel engine.

Groton, Ct

• Co-developed a computer expert system used by the shipyard trades to recommend construction adjustments in U.S. Navy Los Angeles class submarine torpedo rooms, with the goal to avoid or minimize costly construction reworks.• Worked on a design/build team developing a complex torpedo handing system for the U.S. Navy Virginia Class submarine, with a focus on gearboxes.• Did a couple of short stints providing shipboard construction support for U.S. Navy Los Angeles class submarine weapon shipping and handling systems.• Held a DOD Secret clearance while employed.

Bs, Computer Information Systems Technology

Bs, Mechanical Engineering Technology