Excel VBA Consultant Resume

SUMMARY

More than 4 years of experience in design, development MS Excel/VBA, Access/VBA based applications
Developed dashboards in Excel using Pivot Tables, Power Pivot. Automation of tasks using macros and Excel packages
Developed VBA/Macros to verify and compare data for Reconciliation
Developed VBA programs to automatically update workbooks in different locations
Designed and developed Reports using Excel VBA/Macros, Access and SQL Queries
Experienced in Developing Reports using complex SQL queries to fetch data from Oracle & Access Databases.
Experienced in Developing stored procedures, functions using SQL, PL/SQL
Experienced in Developing customized applications using Oracle Forms Builder and Reports Builder
Good at Relational databases and data modeling
Exposure to MS Access and SQL while studying Business Accounting Diploma in Sheridan College
Strong skills in Visual Basic for Applications, with experience in developing automated reporting from multiple database sources
Verbal and written communication skills, listening skills
Excellent interpersonal skills with the ability to communicate, maintain positive relationships and work effectively as part of a team
Customer service focussed, technical and analytical skills

TECHNICAL SKILLS

Databases: Excel, Access, Oracle 10g/11g, SQL Server, My SQL

Languages: VBA/Macros, SQL, PL/SQL, Python, ActiveX Controls

Reporting Tools: Crystal Reports, Oracle Reports Builder

Accounting Tools: QuickBooks online, Sage 50 ERP

PROFESSIONAL EXPERIENCE

Excel VBA Consultant

Confidential

Responsibilities:

Designed and Developed VBA for Reading data from and writing data into Excel files using VBA for Automation of reconciliation
Develop dashboards in Excel using Pivot Tables, Power Pivot. Automation of tasks using macros and Excel packages
Created link - based module to enable automatic data updates for excel workbooks, closed and open
Worked with third party portals and importing financial data into Excel sheets for reconciliation
Developed VBA programs for Automatic data populations and performing automatic calculations on excel spread sheets.
Developed VBA code for populating and saving data in workbooks in different locations after reconciliation
Converted Excel Formulas into VBA code
Experience in extracting, converting and exporting data between different RDBMS and from flat file to Excel
Developed Dash bords for applications using Excel VBA/Macros
Designed and developed Reports with KPI’s using Excel VBA/Macros, Access and SQL Queries
Experienced in Developing Reports using complex SQL queries to fetch data from Oracle & Access Databases.

Oracle VBA Developer

Confidential

Responsibilities:

Participated in gathering business requirements, involved in design and development of the application modules of order processing system.
Participated in financial analysis and developed Reports
Converted Excel Formulas into VBA code
Experience in extracting, converting and exporting data between different RDBMS and from flat file to Excel
Developed Dashboards for applications using Excel VBA/Macros
Designed and developed Reports with KPI’s using Excel VBA/Macros, Access and SQL Queries
Experienced in Developing Reports using complex SQL queries to fetch data from Oracle & Access Databases.
Experienced in Developing stored procedures, functions using Oracle SQL, PL/SQL

IT Technical Customer Support

Confidential

Responsibilities:

Supported internal and external clients on Oracle Database Access Management, Oracle Application access Management and Incident management based on SLA
Created Database Roles & Privileges for Database Access and Application Access and assigned to external and internal users to access the databases and applications.
Documentation on methods of Change Management/Incident Management processes
Developed complex SQL Queries for data retrieval, conversion and loading into target databases
Designed and developed Applications and performed Oracle Database Management
Developed Reports using SQL, PL/SQL & Oracle Forms Builder and Reports Builder