EDUCATION

University of Management “Gladzor” **94 – 1999

Bachelor’s degree in Finance and Banking

Intuit

QuickBooks Certified ProAdvisor (2011, 2012)

“Business and Technical Training Center” College - Toronto, Canada July 2008 – August 2008

A+ certification training

• Trained for CompTIA A+ certification

Achieved certificate of excellence

“Soft and Safe” Training center March 2006 – June 2006

System and network administration, hardware and software service

• Trained for computer technical support

• Trained for MS Windows 2003 Server system administration

COMPUTER SKILLS

Microsoft Access; VBA; Macros; SQL (QBE); Excel (Macros, VBA, automation, VLOOKUP, HLOOKUP, PivotTable, Charts and graphs); Microsoft Power Tools (PowerQuery, M, DAX, PowerPivot); PowerBI (including M and DAX); Microsoft Report Builder; SSRS (SQL Server Reporting Services) Word; Outlook; PowerPoint; SAP; Oracle ERP; Salesforce; DataLoad; BrioQuery; COEUS; QuickBooks (Certified ProAdvisor)

WORK EXPERIENCE

State Street – Boston, MA (Remote) October 2022 – February 2024

Microsoft Excel, Access, VBA and Macros, Excel add-in developer, data and BI analyst

Excel Spreadsheet Development:

oDesign, develop, and maintain complex Excel spreadsheets and workbooks to meet specific business needs.

oCreate user-friendly interfaces, interactive dashboards, and data visualization tools within Excel.

oImplement formulas, functions, and conditional formatting to ensure accurate data analysis and reporting.

VBA and Macro Programming:

oDevelop custom VBA scripts and macros to automate repetitive tasks and streamline workflows.

oWrite efficient code to extend Excel and Access functionalities, enhancing overall user experience.

oDebug, test, and refine VBA solutions to ensure reliability and compatibility across various versions.

Excel Add-Ins Development and Programming:

oDevelop custom Excel add-ins using custom Excel VBA scripts.

oInstallation, setup, improvement and maintenance of Excel add-ins.

oImproving and maintenance of existing Excel add-ins.

Process Automation:

oIdentify opportunities for process automation and develop solutions to eliminate manual, time-consuming tasks.

oCollaborate with stakeholders to understand requirements and translate them into effective automation solutions.

oMonitor and maintain automated processes, making adjustments as necessary to accommodate changing business needs.

Transitioning and migrating to Windows 10 and Microsoft Office 365:

oMaking necessary changes and improvements in Excel spreadsheets, VBA code scripts, macros and add-ins to work in Windows 10 and Microsoft Office 365.

oCreating new datasources using Excel and Power Query.

Training and Support:

oProvide training and support to end-users on utilizing Excel, Access, VBA, and macro solutions effectively.

oCreate user guides, documentation, and tutorials to facilitate adoption and knowledge transfer.

oAddress user queries, troubleshoot issues, and implement enhancements based on user feedback.

Fox, Swibel, Levin & Carroll, LLP – Chicago, IL (Remote) July 2022– August 2022

Data analyst, Microsoft Excel developer

Data analysis

Microsoft Excel development

Data processing automation and improvement using PowerPivot and PowerQuery

Transamerica – Cedar Rapids, IA (Remote) May 2022– July 2022

Data analyst, Microsoft Excel VBA developer

Microsoft Excel VBA development

Data analysis

Data processing automation with Excel VBA

Data processing improvement using PowerPivot and PowerQuery

Data visualization (dashboard, charts, graphs etc.) using Microsoft Excel and PowerBI

MTX Group – Frisco, TX March 2021– January 2022

Data migration lead

Extracting data from clients’ legacy software, application and other sources using queries (SSMS - SQL Server Management Studio), or ETL tools (SSIS - SQL Server Integration Services or Pentaho)

Writing SQL queries to extract data

Transforming, analyzing, processing, and formatting data (using SQL, Excel and PowerBI) for loading

Data mapping, de-duplication (matching and merging data), data cleansing (matching, linking, updating records)

Loading into new Salesforce based applications using SSMS, SSIS and Pentaho

Candela (Syneron) Medical – Wayland, MA May 2019 – March 2021

Inventory Data Analyst MS Excel / Access / VBA Database Developer

Develop reporting using PowerBI (including M and DAX), Excel (Macros, VBA, automation, VLOOKUP, HLOOKUP, PivotTable, Charts and graphs) and Microsoft Power Tools (PowerQuery, M, DAX, PowerPivot)

Compile month-end inventory analysis and assist the Operations Finance team

Develop trend analysis and risks with projections

Maintain and further develop total company inventory reporting related to inventory levels, financial, and operational turns

Measure, analyze, and communicate inventory levels that include goals, forecasts, and actuals in support of corporate objectives

Ensure SKU status codes are maintained and accurate in order to report on inventory health

Support Inventory Control teams in analyzing inventory accuracy, root cause, and improvement efforts as necessary

Develop Microsoft Excel / Macros / VBA automated reporting tools

Develop Microsoft Access / VBA databases and reporting solutions

Healthcentric Advisors – Providence, RI March 2019 – May 2019

MS Access / Excel / VBA Database Developer (temporary assignment)

Fixing issues in MS Access based federal government vouchering system (which uses data from accounting system)

Adding new features and functionality in federal government vouchering system (including new forms and reports)

Creating G&A (General and Administrative Expense) automated reporting tool (MS Access and VBA; data from accounting system)

Creating several automated federal government reporting tools (Excel and VBA; data from accounting system)

Creating “Budget vs Actual” automated reporting tools (Excel and VBA)

Data processing automation with Excel / Macros / VBA

Data reporting automation with Excel / Macros / VBA and Access

Designing comprehensive data analytics solutions and managing complex data projects

Various ad-hoc data analysis

Business analysis and needs assessment

Providing recommendations for improvements as applicable

Fresenius Medical Care – Waltham, MA August 2018 – January 2019

Data Analyst MS Access/Excel/VBA Developer (temporary assignment)

Data processing automation with Excel / Macros / VBA

Data reporting automation with Excel / Macros / VBA and Access

Development of new MS Access databases

Designing comprehensive data analytics solutions and managing complex data projects to meet the needs of various business users of ICA group

Supporting with business and system analysis in the development of various predictive models and ad-hoc reports

Assisting with creating Requirement Specifications (BRD, FRD), Technical Documentation and User guides

Various ad-hoc data analysis

Business analysis and needs assessment

Providing recommendations for improvements as applicable

Citi Bank – Tampa, FL June 2018 – August 2018

MS Access/VBA/SQL Database Developer (temporary assignment)

Development of new MS Access databases (mostly multiuser with SQL Server backend)

Business analysis and needs assessment

Data normalization

Database design and modeling

MS Access, VBA and SQL development/programming (coding)

Data migration

Testing, debugging, implementation and documenting of the program

Adding new features to existing databases

Troubleshooting and fixing existing databases

NTT Data – Boston, MA July 2017 – March 2018

Data analyst (temporary assignment)

Payroll and HR data analysis, data cleansing and scrubbing using:

oAdvanced Excel Functions

oComplex Formulas

oData Manipulation

oComplex Lookups

oMacros and VBA

oMS Access and VBA

Testing of Replicon (cloud time tracking application for timesheet and time off)

Participated in BRD (Business Requirements Document) review

Participated in creating test script and test cases/scenarios

Agero – The Cross Country Group – Boston, MA February 2017 – May 2017

MS Access/VBA/SQL Database Developer (temporary assignment)

Business analysis and needs assessment

Data normalization

Database design and modeling

MS Access, VBA and SQL development/programming (coding)

Data migration

Testing, debugging, implementation and documenting of the program

Creating Excel test models for analyzing data processed by the database

CohnReznick – Boston, MA August 2016 – January 2017

MS Access/VBA Developer (temporary assignment)

MS Access, VBA and SQL programming (coding)

Development, testing, debugging, implementation and documenting of program

Development of new MS Access databases

Creating Excel templates for data loading

Creating Excel test models for analyzing data processed by the database

Performing test plans to verify logic of new or modified programs

Creating appropriate documentation in work assignments such as program code, and technical documentation

OMGEO – Boston, MA October 2015 – May 2016

Data analyst (temporary assignment)

Migration of data from/to different sources and software

Processing data using MS Excel, MS Access, VBA

Development of new MS Access databases

Automation of data processing

Novartis Vaccines and Diagnostics – Cambridge, MA September 2012 – October 2015

USG group

Project accountant / Analyst / MS Access/VBA/SQL(QBE) developer (temporary assignment)

Development of new and improving existing MS Access databases

Migration of data from/to different sources and software

Downloading data from SAP system

Reviewing data for US Government compliance

Preparation of invoices for government invoicing

Analysis of costs before billing to the government

Monitoring and reporting of billing progress

Boston University – Boston, MA July 2012 – August 2012

General Accounting department

Staff accountant (temporary assignment)

G/L accounts reconciliation and preparation of reports (using MS Excel)

G/L accounts reconciliation (clearing) in SAP

Paper-Pusher Business Solutions – Watertown, MA March 2012 – December 2013

Self Employment

www.paper-pusher.com

MS Access/VBA/SQL(QBE) developer, MS Excel consultant, QuickBooks ProAdvisor - owner

Small business IT solutions development, installation, setup, training

oMS Access / VBA / SQL(QBE) databases

oMS Excel workbooks (Vlookup, Pivot table, graph, chart etc.)

Installation and setup of computer hardware and software

QuickBooks ProAdvisor services- Consulting, Sales, Installation, Setup, Training

MIT-Massachusetts Institute of Technology – Cambridge, MA April 2011 – March 2012

The Office of the Vice President for Finance

Sponsored Projects Accounting group

Staff accountant- Industrial / Foundations (temporary assignment)

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.

AccountingEZ – Watertown, MA November 2009 – May 2011

MS Access/VBA/SQL(QBE) developer, MS Excel consultant, QuickBooks bookkeeper - owner

MS Access/ VBA / SQL(QBE) database development

MS Excel consulting (Vlookup, Pivot Table, Chart, Graph)

Installation and setup of computer hardware and software

QuickBooks ProAdvisor services- Consulting, Sales, Installation, Setup, Training

Riverside Community Care – Dedham, MA July 2010 – September 2010

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

Development of EVS (Eligibility Verification System) Database for billing department, which:

oChecks information about client’s health insurances

oHighlights even minor changes in information

(personal information, changes in health insurance, restrictive messages etc)

Fixing, updating and improving of quality management databases

oNeeds Assessment Database

oConsumer Satisfaction Database

oHuman Rights Database

oIncidents Database

OTF Group – Belmont, MA May 2010 – June 2010

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

Checking and fixing of errors in budgeting tool in MS Excel

Development of MS Access database for budgeting and monitoring

MyComputerToronto – Toronto, Canada 2008 – 2009

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

MS Access /SQL(QBE) database development

MS Excel consulting (Vlookup, Pivot Table, Chart, Graph)

On site computer services

Vardaram – Yerevan, Armenia 2006 – 2008

MS Access/VBA/SQL(QBE) developer - owner

MS Access/SQL(QBE) database development, installation, setup and training

Computer technician services

Executive and financial management of the company

Electric Networks of Armenia – Yerevan, Armenia 2006 – 2008

Assistant of CFO

Systemization of correspondence and documents registration system

PowerPoint presentations of management reports

MS Excel worksheets for data analysis

Financial accounting information processing and representation to CFO

Sayat-Nova Complex – Yerevan, Armenia 2002 – 2006

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

Development of MS Access database for restaurant management program

oOrganization of the team

oCoordination and project management

oPurchase, installation and setup of hardware, software and network

oProgramming, testing, installation and setup

User training and day-to-day operations management and control

Database, system and network administration

Regular and ad-hoc reporting (including analysis and statistics)

“British Alumni Association” NGO – Yerevan, Armenia 2001 – 2002

Chief accountant

Grant funded programs’ budgeting, monitoring and reporting

Full charge bookkeeping

Tax and statistic reporting (payroll taxes, sales taxes, local and public taxes)

Financial and managerial accounting and reporting (to funders, management and board)

oIncluding Balance Sheet, Income Statement, Statement of Cash Flows, Statement of Owner's Equity

Certificate for “Above and Beyond” contributions supporting the Office of the Vice President for Finance of Massachusetts Institute of Technology

Contact this candidate