UMAIR

KHAN

**** * *** ******* ****, Pleasanton, Ca 94588 https://www.linkedin.com/in/umair01

916-***-**** adyg0y@r.postjobfree.com

** ***** ********** ** *********** technology with a focus on Microsoft technologies. Primary Skills: Microsoft SQL Server database development, MS Access and Excel application development, project management, managing remote and local teams. Training colleagues in SQL, SSIS, database design.

EXPERIENCE

VP DATA & INFORMATION SYSTEMS

AP Equipment Financing, Walnut Creek, Ca.

2018-PRESENT

Manage information systems and data flowing through various systems. Administer SQL Server, developer stored procedures. Set up backups and restore databases. Manage SQL Server security. Set up SQL Server Agent jobs.

Work with Demand Tools to automate updates and append data to Salesforce. Use MS Access to create databases, cleans data remove duplicates, import leads into Salesforce. Deduplication data.

Manage process of getting leads into Salesforce. Train team members in database design, SSIS, Demand Tools, SQL.

Major Accomplishments: Automate data transfers between systems using SSIS & Demand Tools from external systems. This involved over 100 tables and 300 columns of data. Set up alerts for exception reports. Set up error handling.

DATABASE DEVELOPER

Fourstar Seafood, Inc

2016-2018

Develop and manage Inventory management database built in Microsoft Access. Design database, tables and set relationships. Write reports, automate tasks.

INFORMATION TECHNOLOGY CONSULANT

Northern California

2010-2018

Database development, application development. Support existing SQL Server and MS Access databases. Excel application development.

EDUCATION

BACHELOR OF BUSINESS ADMINISTRATION, MAJOR IN MANAGEMENT INFORMATION SYSTEMS

California State University, Sacramento Graduated 1997

SKILLS

Microsoft SQL Server

Microsoft Access

Microsoft Excel

Demand Tools

Managing Teams

ETL’s Development with SSIS

Database Design

SQL, Stored procedures

VBA

Project Management

Contact this candidate