|
|
Mike Sachleben
617-686-8183
|
|
|
|
Specializing In:
Database Design, Development, and Tuning
Application and Web Development
Project Management
|
|
|
|
|
Core Technologies Used:
Databases: MS SQL Server (versions 6.0, 6.5, 7.0, 2000), MS Access (versions 1.1 to 2000), Sybase SQL Server, PostgreSQL
Languages and Tools: Visual Basic (versions 3.0 to 6.0), Active Server Pages, Microsoft Office VBA, Crystal Reports, SAS, SPSS, Microsoft Project
|
|
|
|
|
Professional Experience:
Outside the Classroom
Database Administrator and Developer responsible for building database components of online alcohol awareness course.
· Rewrote and extended major portions of the course, including pulling survey questions from a random pool, making questions reusable on tests and allowing institutional clients to customize their user’s navigation through the system.
· Created OLAP routines to extract data from transactional system, transform it to data mart schema, and load into reporting database (ETL).
· Optimized existing MS SQL database and optimized procedures, tables, and indices based on load and stress tests.
· Implemented Salesforce.com’s CRM and Campaign modules across organization. Ran needs assessment meetings and performed customizations as needed.
· Sourced applicants for part-time QA role, performing initial screening over 50 applicants and recommending 3 finalists.
· Created & refined Crystal Reports and MS Access reports to analyze collected data.
· Created MS Office application to automatically create PowerPoint presentations based on data in reporting database.
· Tightened security for interaction between database and web based survey tool.
|
EGrad/College Publisher/Y2M
SQL Developer & DBA at an online publishing & marketing organization.
· Created architecture for database components of BrokeScholar.com web site.
· Created database components for new features on EGrad.com, and all sites within the College Publisher network.
· Created stored procedures to register, authenticate & track click-throughs of individuals logging into web site.
· Built procedures to extract data from various sources and process it into a single “Leads” database (ETL).
· Built PostgreSQL database on LINUX server for serving banner ads to College Publisher web sites.
· Tuned table indices and wrote stored procedures which are called from the web, significantly speeding up web sites.
· Mentored members of development team in proper table design, as well as naming and coding standards.
· Imported multiple college & local newspaper databases into the College Publisher/Broadband Publisher framework.
· Imported multiple alumni association student lists into the common database framework.
· Automated multiple import/export routines to merge vendor data with SQL database on a nightly basis.
· Ported database back ends from MySQL & DB2 to MS SQL Server and validated relational structure of SQL database.
|
|
|
|
|
