Ms Access/ Vba / Sql(qbe) Developer /data Analyst Resume
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