We provide IT Staff Augmentation Services!

Vba Developer Resume

2.00/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY:

  • An experienced, innovative Excel Application Developer who combines automating complex calculations with mistake - proofing, intuitive graphical user interfaces and advanced data visualization to leverage enterprise systems.
  • Proficient in Excel VBA for the development of dynamic stand-alone applications characterized by seamless operation.
  • 10+ years of experience in VBA programming.
  • Extensive use of dynamic range names, thus utilizing the vast array of Excel's built in lookup and reference functions (index, lookup, VLookup, HLookup, offset, indirect, etc.), as well as complex array functions.
  • Strong knowledge of Excel's built-in functions, ability to create multi-level nested functions, creation of custom worksheet functions in VBA.
  • User input directed through custom menu selections, toolbars, data entry validation, in cell drop-down control lists and conditional cell formatting, thus reducing possible user input errors.
  • Pivot Tables, Charts and advanced Data Filtering created and controlled through VBA coding.
  • VBA controlled interface with other programs/platforms: import/export with text files (csv, tab-delimited, etc.), with other Microsoft Office products (Word, Outlook, Power Point, Access, SQL Server, etc.)
  • Expert with Excel, Power Point, Outlook, Access, VBA macros and VB6.0
  • Worked in Collaborative Solutions for CPG, business-to-business (B2B), B2C and eCommerce domains.
  • Fast and self-studying learner of new and required technologies.

TECHNICAL SKILLS:

Operating Systems: MS Windows, UNIX, Linux, iOS

Languages: C, C++ and PHP

Scripting Languages: Excel VBA, PowerPoint VBA, VB Script, HTML, JavaScript, Office.js APIs, Angular JS, jQuery, Ajax

Databases: Oracle SQL Developer, MS Access, Oracle Sales Analyzer (OSA), MySql, Essbase

GUI Tools: Visual Basic 6.0

Text Editors: Epsilon, Vi, Emacs

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

VBA Developer

Responsibilities:

  • Design, develop, maintain, and deliver highly scalable and reliable Excel applications that interface with web technologies including HTML5, JavaScript, REST API.
  • Developing excel templates that use API to pull data directly from Essbase cube.
  • Building a new custom Office Ribbon bar for Excel to perform advanced text-based operations on rows of text in the Excel worksheet that contain custom information. 
  • Creation of efficient sheets by using drop downs, conditional formatting, error functions.
  • Creation of scenario sheet and use of simulations and solver.
  • Generate key reports and publish within the operations team to support the supply planning process. 
  • Work collaboratively with Demand Planning, Supply Planning, and Mfg Operations team.
  • Improve control environment by implementing automated checks in Excel-based reporting using VBA macros.

Confidential, San Jose, CA

VBA Developer

Responsibilities:
  • Working in a team to develop sets of Excel tools used by the company monthly financial campaigns using ADO & VBA.
  • Developed applications using VBA and Excel macros and numeric functions to satisfy business needs.
  • Analyzed requirements from business stakeholders to define and document functional processes and translate them into functional and technical specifications while processing the data using complex Excel routines.
  • Gathered and evaluated end user requirements for data and reports needs developed using Excel.
  • Supported customer needs by creating multiple Access databases and ad-hoc reports to process raw data, and wrote SQL queries to pull data from the company’s main databases.

Confidential

Lead Programmer

Responsibilities:
  • Automating the processes to reduce time spent in completing manual processes and help organization achieve quicker project turnaround times.
  • Initiating and writing VBA macros for high-impact quality reports leading to operational efficiency and higher productivity (Within Six Sigma, Lean process improvement methodology)
  • Extensive use of Excel functions, Graphs in developing new templates/reports deliverable to client.
  • Designed and Developed hundreds of Excel and PPT Reports that are deliverable to IRI’s end clients like Mars, Kellogs, Danone, Pascual, J&J, Gallina Blanca, Coca-Cola, Pepsi, Carrefour, Dia, Sabeco etc.
  • Maintenance of existing macros developed in VBA Excel and Powerpoint for the international clients of Genpact SMS.
  • Developed various GUI applications using Visual Basic.
  • Driving automation in the process to create efficiency and improve on quality of deliverables
  • Training and helping the associates in Excel, Powerpoint and other Process related tools.
  • Providing troubleshoot assistance.
  • GB Certified - Worked on Reengineering project, with productivity benefits worth $5000

Confidential

VBA Developer

Responsibilities:
  • Responsible for coding and developing GUI applications and also carrying out over all office automation work.
  • Responsible for developing Microsoft Office macros, databases, and applications.
  • Responsible for full cycle development of client requirements that includes analysis design, implementation, quality control testing and releasing of new versions of applications, and database administrating.
  • Extensive use of VBA coding with modules, procedures, functions and macros.
  • Created several Excel Workbooks with complicated formulae embedded in them.
  • Written several complicated VBA procedures for data processing in Excel.
  • Authored several Excel VBA applications for sorting and comparing large stores of Data in Excel
  • Created Reporting Tools using VBA Macro in Excel.

Confidential

Project Leader

Responsibilities:
  • Responsible for piloting new projects and systematizing processes for transition and performing quality review of special projects
  • Project Analysis and Scope of Work
  • Schedule Preparing
  • Providing the training and managing the use of extraction templates and formatting tools
  • Work allotment and follow up
  • Project Tracking
  • Customer Interaction
  • Suggestion of Automation process
  • Meeting the targets on time
  • Operationally managing content-manufacturing group

Confidential 

Data Analyst

Responsibilities:
  • Cleaning & Scrubbing Catalog Data, ERP Related Data
  • Data Enrichment (Adds Supplier & Buyer Specific Data)
  • Publishing Product Data in Various Market Places/Exchanges like Oracle, Commerce One, Ariba Exchange, SHAPE etc.
  • Data structuring, Data formatting (for eg. title casing, spelling) & Text Normalization (expansion of abbreviations and acronyms)of Multi linguistic Data
  • Maintaining Product Catalog like Updating Product Information
  • Product Classification & Taxonomy (UNSPSC / E-Class / NAICS / SIC)
  • Extraction of category specific attributes

We'd love your feedback!