We provide IT Staff Augmentation Services!

Excel Vba Consultant Resume

0/5 (Submit Your Rating)

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

We'd love your feedback!