We provide IT Staff Augmentation Services!

Ms Excel/vba Developer Resume Profile

Arlington, TX

Summary:

  • More than 5 years of experience in design, development and implementation of MS Excel MS Access/VBA based Applications.
  • Proven background translating cell formulas in Excel into VBA code.
  • Created Macros for Business Development.
  • Automating, modifying, and optimizing reports in Excel Access.
  • Experience in the development of financial applications using Excel and Access.
  • Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel Access 2007 / 2010.
  • Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, etc.
  • Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.
  • Experience in SQL statements, stored procedures using SQL server 2005/2008.
  • Experience in extracting, transforming and exporting data between different RDBMS and from flat file to Excel and vise-versa.
  • Used MS Excel/Access VBA SQL to send system generated e-mails, manage and report embedded Excel documents.
  • Created Dashboard in MS Excel.
  • Good experience in the implementation of all phases of Software Development Life Cycle SDLC from requirements gathering through implementation.
  • Prepared program level and user level documentation.
  • Experience working according to internal standards and external audit standards.
  • Excellent team co-ordination, organizational and interpersonal skills with result oriented approach.

Professional Skills:

Operating systems : Windows7, Windows XP/2000, Dos

Languages : T-SQL, PL/SQL, VB 6.0, Fox pro

VBA : MS Excel MS Access 2007/2010

Databases : MS Access, SQL Server, MySQL, Oracle, FoxPro

Reporting Tools : MS Access Reports, Crystal Reports, SSRS

Confidential

MS Excel/VBA Developer

Responsibilities:

  • Developed Excel VBA application that communicates with DB using ADO Objects and SQL.
  • Developed macros to verify and compare data.
  • Developed macros for accounting and financial purpose.
  • Built macros for updating customer orders in MS Excel Application.
  • Implemented several built-in excel functions and formulas.
  • Implemented pivot tables and charts in Excel for summarizing data.
  • Imported data into excel from flat files.
  • Developed and maintained Access Application for data retrieval. Previous method was taking Excel workbooks, translating to MS Access database, then exporting to SQL database.
  • Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Excel/Access/VBA.
  • Define reporting requirements and gather data, using Access and create management reports, also export data from MS access to MS Excel to create Pivot table for management do more analysis.
  • Created Access database from scratch.
  • Created physical tables and link tables.
  • Assist in Migrating prior versions of MS Office applications to 2010
  • Prepared program-level and user-level documentation.

Environment: Windows 7, Visual Basic, MS Access, MS Excel, VBA, SQL Server, SharePoint

Confidential

Excel /VBA Database Consultant

Responsibilities:

  • Developed Excel based application to move / format data between sheets based on selection criteria using the Excel Object Model, VBA, Events Combo boxes.
  • Enhanced an existing Excel applications consisting of several VBA programs and macros.
  • Developed VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries and linked the based module to enable automatic updates for excel workbooks.
  • Created advanced formulas, user defined functions and formulaic arrays for data analysis.
  • Converted Excel formulas into VBA code including VLOOKUP HLOOKUP .
  • Developed macros for data automation.
  • Designed Dashboard in excel.
  • Developed macros to export data from SQL Server to Access.
  • Created Tables, Link tables, Queries, Forms and Reports in Access from scratch.
  • Developed database queries to fetch data from Oracle databases.
  • Analyze chunk data and massage before importing to the Access database.
  • Created reports using crystal reports.
  • Connected databases through ODBC for Micro strategy reports.
  • Used Excel VBA/Macros, MS Access and SQL queries to make reports in different styles and then distributed them as PowerPoint slides to various level of management.
  • Performed testing, maintenance, debugging and documentation for every process.

Environment: Windows 7, MS Excel, VBA, MS Access, MS PowerPoint, SQL Server, Oracle, Test Cases, Oracle.

Confidential

MS Excel / Access VBA Analyst

Responsibilities:

  • Assisted in the development of internal applications for marketing and customer relations departments.
  • Developed macros for financial reports.
  • Created macros for calculation of equity interest.8
  • Assisted with the automation of finance department's manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
  • Developed macro for ETL and reporting purpose.
  • Created Dashboards for the financial reports in MS Excel.
  • Created tables, Queries, Forms and Reports in Access assigned relationship between the tables.
  • Used several types of data sources for connecting to different databases and files.
  • Created a macro to send email alerts with attachments through Outlook.
  • Advanced use of Pivot Tables on spreadsheet.
  • Used SSRS to create reports.
  • Assist in migration of MS Access Databases 2007 to SQL Server 2008 by using Import wizard and SSIS Packages in SQL Server.
  • Making up backup strategies while doing migration.
  • To bring the databases online after migration.
  • Collected data and design a relational database with queries and reports to meet customer requirements.
  • Trouble-shoot relational databases to isolate problems and fix.

Environment: MS Excel, VBA, MS Access, VB6.0, Windows, SQL Server, SharePoint.

Confidential

MS Excel VBA Developer

Responsibilities:

  • Designed an Application for in-house Accounting Systems in MS Excel Application.
  • Enhanced existing VBA application by performing VBA coding, modifying understanding existing VBA scripts.
  • Data extractions and Reports generation modules are written for management use.
  • Development of Macros and Formulas in Excel 2007.
  • Data Validation in MS Excel 2007, created forms for data entry while using data validation.
  • Created Pivot Tables Charts for Reports.
  • Develop Excel VBA macros and database calls.
  • Troubleshoot and maintain existing MS Access database for Company's Data Inventory System Department.
  • Extended the capabilities of an existing database used to track customer records in pure refined way after applying different queries.
  • SQL statement and stored procedures using SQL server 2005.
  • Import and Export databases between Microsoft Access, Microsoft Excel, Flat files and SQL.
  • Created documentation for future time and training to new onboard users.

Environment: Visual Basic 6.0, MS Access, MS Excel, VBA, Windows, SQL Server, SharePoint.

Hire Now