We provide IT Staff Augmentation Services!

Ms Access/ Vba / Sql(qbe) Developer /data Analyst Resume

5.00/5 (Submit Your Rating)

Boston, MA

SUMMARY

Extensive background working as an Access Developer.

COMPUTER SKILLS

Microsoft Access; SQL (QBE); VBA; Macros; Excel (VLOOKUP, HLOOKUP, PivotTable); Word; Outlook; PowerPoint; SAP; BrioQuery; COEUS; QuickBooks (Certified ProAdvisor); Adobe Acrobat Professional

WORK EXPERIENCE

Confidential, Boston MA

Project accountant / Analyst / MS Access developer 

  • Download data from SAP system and review data for USG compliance
  • Develop new and improve existing MS Access databases for Confidential and other departments
  • Prepare invoices for government invoicing and analyze costs before billing to the government
  • Gather supporting documentation for Contracting Officer Authorization (COA) request

Confidential

General Accounting department

  • G/L accounts reconciliation and preparation of reports (using MS Excel)
  • G/L accounts reconciliation (clearing) in SAP

Confidential

Self Employment

Owner - MS Access developer, MS Excel consultant, QuickBooks ProAdvisor

  • Small business IT solutions development, installation, setup, training
  • MS Access / VBA / SQL(QBE) databases
  • MS Excel workbooks (Vlookup, Pivot table, graph, chart etc.)
  • Installation, setup, updating and upgrading of computer systems (Windows)
  • Installation and setup of computer hardware and software
  • QuickBooks ProAdvisor services- Consulting, Sales, Installation, Setup, Training

Confidential 

The Office of the Vice President for Finance

Staff accountant- Industrial / Foundations

  • Auditing and final reporting of federal and non - federal sponsors
  • Preparation of computer and manual invoices on a monthly, quarterly and annual basis
  • Preparation of internal cost audits on terminated grants and contracts
  • Maintaining and updating of all information concerning active and terminated grants and contracts.
  • Participation in running and reviewing various SAP billing systems

Confidential 

Owner- MS Access/MS Excel developer-consultant, QuickBooks bookkeeper

  • MS Access/ VBA / SQL(QBE) databases development
  • MS Excel consulting (Vlookup, Pivot Table, Chart, Graph)
  • Installation, setup, updating and upgrading of computer systems (Windows)
  • Installation and setup of computer hardware and software
  • QuickBooks bookkeeping
  • QuickBooks ProAdvisor services - Consulting, Sales, Installation, Setup, Training

Confidential 

MS Access/ VBA / SQL(QBE) developer /data analyst

  • Developed EVS (Eligibility Verification System) Database for billing department, which:
  • Checks information about clients health insurances
  • Highlights even minor changes in information
  • (personal information, changes in health insurance, restrictive messages etc)
  • Fixed, updated and improved quality management databases
  • Needs Assessment Database
  • Consumer Satisfaction Database
  • Human Rights Database
  • Incidents Database

Confidential

Data Analyst, MS Access/VBA/SQL(QBE) developer, MS Excel consultant

  • Checked and fixing of errors in budgeting tool in MS Excel
  • Created MS Access database for budgeting and monitori

Confidential

MS Access/ SQL(QBE) developer, MS Excel consultant, computer technician

  • MS Access /SQL(QBE) databases development
  • MS Excel consulting ((Vlookup, Pivot Table, Chart, Graph)
  • On site computer services
  • Installation, setup, updating and upgrading of computer systems (Windows)
  • Installation and setup of computer hardware and software

Confidential

MS Access /VBA/SQL(QBE) developer

  • MS Access/SQL(QBE) databases development, installation, setup and training
  • Services of computer technician
  • Executive and financial management of the company

Confidential

Assistant of CFO

  • Systemized correspondence and documents registration system
  • Created PowerPoint presentations of management reports
  • Created MS Excel worksheets for data analysis
  • Received data from accounting department, processed and represented in organized manner to the CFO

Confidential

MS Access/VBA/SQL(QBE) developer, computer technician, desktop support technician

  • Recommended to create a restaurant management program
  • Coordinated and participated in creation of the program
  • Purchased and installed hardware, software and internal network
  • Administered database, system and network
  • Guided and supported end users of the program
  • Created MS Access databases for day to day data analysis and statistics

Confidential

Chief accountant

  • Budgeted grant programs and monitored budget execution
  • Full charge bookkeeping
  • Prepared tax and statistic reports (payroll taxes, sales taxes, local and public taxes)
  • Prepared financial statements (Balance Sheet, Income Statement, Statement of Cash Flows, Statement of Owner's Equity)
  • Prepared financial and management reports for funders, management and co - chairpersons

We'd love your feedback!