Vba macro developer

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. 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. 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 . 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. Assisted in the development of internal applications for marketing and customer relations departments. Developed macros for financial reports.