OBJECTIVE: A database developer, analyst, or administrative opportunity as a certified SQL MCTS developer, Microsoft Access, and certified Microsoft Excel2007 expert with VBA knowledge. Liaison with IT and Accounting workgroups.

“A unique blend of accounting, IT, programming and data manipulation skills”

SUMMARY OF QUALIFICATIONS:

• T-SQL Server 2008 R2- queries, scripting, stored procedures, triggers, views, indexes, backup, restore, database security, XML, DML (INSERT, UPDATE, DELETE and MERGE).
• Certified Microsoft Office Specialist, Data Analyst having expertise in analyzing the data using MS Excel (V-lookup, H-lookup, pivot tables, VBA (Visual Basic), macros, what-if analysis, scenarios, link cells, charts), MS Access and SQL.
• Proficiency in MS Access- in depth experience creating databases, queries, designing tables and reports.
• Understanding and performance of normalization, database creation and indexing.
• Knowledge of accounting GAAP and current accounting standards and practices.
• Accounts Payable, Accounts Receivable, QuickBooks.
• Excellent mathematical aptitude, Strong MS Office to include Word, Outlook, PowerPoint.
• Experience working within project based team environments with strong commitment to tasks, completions deadlines and attention to detail.
• Excellent verbal, interpersonal and communication, organizational skills, broad business experience.

CAREER EXPERIENCE:

Confidential, Dec 2010 - Present 
Developer, Analyst Atlanta, GA

• Extensively use SQL Server and MS Access; generate SQL queries, design and load tables, import data, set up constraints to ensure data integrity, non-clustered indexes, create views to join tables and filter tables.
• Querying and extracting data in MS Access and transforming to MS Excel and SQL.
• Review T-SQL code in SSMS for production and create non-clustered indexes to improve query execution.
• Develop SQL views, stored procedures, triggers, and merging tables for better performance and overhead.
• Interpret complex information to create test plans, scripts, test cases and create test data.
• Working with aggregate values in SQL using COUNT, SUM, GROUP BY and HAVING.
• Build and schedule data extracting jobs to run automated.
• Use Database Engine Tuning Advisor and monitoring tools for database analysis.
• Make recommendations based on data trends and analysis.
• Exposure to database administration principles and practices including security, permissions and alerts.
• SQL Server, T-SQL, OLTP, ETL, XML, MS Access, MS Excel

Confidential, Aug 2009 - Dec 2010
Data Analyst, Accounts Receivable Norcross, GA
IT work

• Demonstrated proficiency in SQL and Access for data query and updates.
• Extracted, manipulate and analyze data and create reports using T-SQL and MS Access 2007.
• Automate payroll and collection systems by adding SQL triggers to capture time of transaction and insert into payroll and accounts receivable systems for processing.
• Liaison with IT on Business/Accounting needs.
• Built macros to improve frequently executed tasks in Excel to be generated more efficiently and quickly.
• Wrote procedures using VBA to automate data entry into spreadsheets in Excel by clicking a button.

Accounting work

• Managed daily cash receipts, used online banking to record deposits.
• Research and resolve reconciling items reported by accounting management.
• Posted payments from debtors, reconciling accounts and collected cash payments from walk-in debtors.
• Ensured high-quality data input and output.
• Used Excel in setting up pivot tables to create various reports using a set of data from an SQL query.
• MS Excel, MS Access, SQL, T-SQL, VBA

Confidential, April 2002 - June 2009
Database coordinator, Accounting Assistant Duluth, GA
IT work

• Set up Excel tables of data to organize and maintain data for vendors, products, clients, members and staff.
• Designed database in Access from data in Excel linking them so any changes in Excel are automatically reflected when the linked table is viewed or queried in Access.
• Created data validation rules for entering data and importing data from Excel spreadsheets.
• Used Excel VBA to create user interface that produced quotes for members and staff.

Accounts Payable & Accounts Receivable work

• Was in charge bookkeeping using QuickBooks.
• 3-way matching of purchase orders, invoices and received inventory.
• Recorded inventory and related account payable.
• Reconciliation of inventory vendor monthly statements.
• Used subsidiary ledgers to maintain specific inventory quantities at proper levels to prevent excess inventory with Month-end reconciliation of accounts payable sub-ledgers to the General Ledger
• Prepared expense reports.
• Maintained accounts receivable balances.
• Process customer payments, allocate payments and resolve unidentified payments.
• Make collection contact with all assigned accounts via telephone, email, fax, or mail.
• Determine the need for and negotiate credits to customer accounts.
• Updated transactions using QuickBooks.
• QuickBooks, MS Excel, MS Access, VBA

EDUCATION/CERTIFICATIONS:

• Associates: Accounting
• Certification in Excel 2007/2010
• SQL Server 2008 R2- Developer