Senior Engineer

• Sep 2009 - Present

• Develops automated templates using Microsoft Access Data Objects to perform data processing tasks – removes duplicates, append / merge, match datasets and indexed • Establishes extraction, transformation and loading layers using Access for processing large datasets • Developes Access Data Macros for Auditing purposes • Interfaces SQL Server with Access • Develops MS Access database from survey system to evaluates performance. • Creates tables to store information on survey, evaluation and financial sales data for analysis. • Writes VBA to import MS Excel files directly into MS Access. • Creates MS Access 2007 client/server databases to track customer buying information; which involves creating the table design and structure of the database, the creation of multiple input forms and multiple reports. • Cleanins the imported Excel data to be able to parse it into multiple tables. • Technical Lead for the design and creation of a SQL Server back end database for the company website using MS Access Project and Visual Basic. • Creates automation processes to import data from Excel into SQL Server using VBA code. • Creates various stored procedures to implement the import process. • Designs and creates various maintenance forms and reports. • Involved in setting up MS-Access queries to track winnings for prize team. • Designs and develops MS Access and MSDE applications to handle recruiting. • Performs extensive data migration using queries and VBA code. • Designs and develops Microsoft Access 2000 budgeting application to handle multi-million dollar labor costs. • Application took advantage of the Microsoft Access replication and security features to collect data from numerous branches across the nation. Technologies used: VBA, SQL, MS Access, ASP, DAO, Local Area Networking Client/Server Development, Microsoft Access 2000 Replication/Synchronization Clients Include: Seneca, Sirius Satellite Radio, Starwood, Verizon Show less