Bryan Andrew has not entered any Education details yet.
Work Experience
February 2002 Present Access/SQL Database Administrator AM Technology Inc Chicago, IL
Performed the following duties at the following clients (Between February 2002 to Present)
Kraft Foods, ABN AMRO, Bank of America, Pactiv, DeVry, Alberto Cluver, Motorola, PepsiCo.
Develop tax calendar using MS Access. Create forms, quires, tables and reports using MS Access. Develop and maintain various MS Access databases across multiple departments. Migrated pervious version of MS Access database to MS Access 2007. Fine tune MS Access database to enhance performance and efficiency. Convert MS Access database to MS SQL database. Aggregate and transform data into meaningful information for senior management using MS Access, MS Excel, PowerPoint and Visio.
Develop reporting solution tailored to specific client needs. Develop, design, implement, scaling and support of a SQL Database. Security setup and permissions. Setting up database level clustering and database failover. Install changes to database software, service packs and hot fixes. Backup, restore, consolidate and reorganize. Optimize and tune database systems to maximize their performance and operation. Create dimension tables, transform and load data from flat files, database tables and other sources. Documentation of database management policies, procedures, standards. Create and implement stored procedures, triggers, and queries using T-SQL. Provide training and support to various clients on Microsoft Office Suite and on Database developed.
Developed an MS Access database at Kraft Foods to help with validating data to be transferred from current ERP system to SAP
Perform studies on current sales and use tax process and make recommendations on automation and or improvements. Implement and test procedures for tax automation (Vertex/Quantum, TaxWare) for sales and use tax. Coordinate with IT department to update Taxware, Vertex systems and resolve any issues.
August 2003 November 2005 Manager Crowe Chizek Oak Brook, IL/Indianapolis, IN
Analyzed and defined requirements for data, workflow, logical processes, hardware and operation system environments and system interfaces. Build case fro action from data gathered through a variety of techniques (e.g. workshops, work sessions and interviews). Identify and facilitate the resolution of requirements, process, and project issues. Assist in the development of project plans specifying project objectives, tasks, staff requirements, identify risks and contingency plan
Developed an application using MS Access to convert data from any ERP system to Taxware and Vertex data input format. Developed Tax Calendar to tract sales and use tax, audits. Developed an application to automate RAR fillings. Developed an application to automate use tax accruals and journal entries. Provide training and support for to clients and staff on all application developed and MS Office suite.
January 2000 December 2002 Senior Staff KPMG LLP Chicago, IL
Responsible for translation business requirements into process flow diagrams. Analyzed and defined requirements for data workflow, logical processes, hardware and operating system environments.
Developed and tailored tax calendar to meet client needs. Developed an application to streamline data collection process. Developed and created relational databases, tables, queries, forms and reports using MS Access.

$
£ GBP
€ EUR 
