We provide IT Staff Augmentation Services!

Sr Vba Developer Resume

Sunnyvale, CA

EXECUTIVE SUMMARY:

  • Passionate MS Excel and VBA Developer providing 12+ years of consulting services to top Confidential 500.
  • Recruited to create custom applications using VBA in MS Excel, automate manual reports, and improve existing Excel workbooks and formulas.
  • 15+ yrs MS Excel (formulas, charts, pivot tables, macros)
  • 10+ yrs VBA Programming (report automation, custom application development, bug/error fixing, migration)
  • 08+ yrs Data Analyst (Data mining, dashboards, scorecards, big data)
  • 122+ Macros Created
  • 35+ User Forms Designed
  • 2,500+ formulas Developed
  • Average 22+ hours of time saved per automation

PROFESSIONAL EXPERIENCE:

Sr VBA Developer

Confidential, Sunnyvale, CA

Responsibilities:

  • Analyzed existing Excel macros and created enhancements per requirement
  • Created templates for the financial statement analysis and pivot tables/charts for sales analysis using Excel and VBA
  • Developed spreadsheet for cost and variation analysis using advance Excel functions and automated using VBA for reducing time for weekly reporting on it
  • Created data validation scheme to ensure that necessary data is entered for customers
  • Designed and developed user interface for viewing and printing of reports
  • Redesigned and modified existing program logic to improve overall system performance
  • Designed and installed user level security by defining roles for each user

Sr VBA Developer

Confidential, San Ramon, CA

Responsibilities:

  • Summarized data into report - quality format using MS Excel
  • Wrote Excel VBA procedures to automatically reformat monthly reports reducing completion time from five days to less than one day
  • Created VBA procedure to complete quarterly vendor rollup - previously a 2-day, manual task - in less than two hours
  • Developed and published routine and ad-hoc reports to project managers and other internal clients using MS Access and Excel
  • Wrote VBA procedures to automate the updating of routine reports

Excel/VBA Developer

Confidential, San Jose, CA

Responsibilities:

  • Analyzed trends in revenues and expenses
  • Prepared spreadsheets, graphs, and charts to help illustrate financial trends
  • Presented financial information to managers
  • Performed revenue and expense forecasts in order to make financial decisions
  • Created and reviewed financial records
  • Prepared budgets for future projects
  • Used MS-Access forms to design user interface and manipulated them through VBA
  • Created Front End Screens with user validations using Access VBA, Excel
  • Extensively used Excel and Access Macros and VBA with Excel Forms
  • Created stored procedure and views to retrieve the data from SQL server to Excel
  • Used VBA Excel and Access to retrieve data from SQL server and created and maintained

Excel/VBA Developer

Confidential, Santa Ana, CA

Responsibilities:

  • Debugged and fixed errors on six existing vba applications
  • Added new features to two existing programs
  • Decoded logic/rules on four vba applications
  • Automated two manual reports
  • General MS Excel assistance to 20 coworkers

Data Analyst

Confidential, Santa Clara, CA

Responsibilities:

  • Addressing and analyzing customer data through Customer profiling, Data analysis and Mining, External data enhancement, Break-even analysis
  • Collect, analyze and present data findings and recommendations; create data driven recommendations to improve marketing and operations
  • Set-up files for deployment on third-party systems like Sales Force Marketing Cloud (includes setting filters, suppressions, creating control groups, etc.)
  • Sorting/suppressing data for mailing/deployment and documenting data processing instructions
  • Supporting marketing needs in a timely and efficient manner demonstrating a sense of urgency, tenacity, and commitment to quality and excellent
  • Creating end deliverables in a variety of formats (PowerPoint, Excel, etc.) and participation in presentations to senior management
  • Built target customer segments for the marketing team campaigns and e-commerce deployments.
  • Develop monthly financial dashboards and visualizations through Tableau and Micro Strategy.
  • Built customer dashboards on campaign tracking and with data source Google Analytics & Salesforce Marketing Cloud
  • Pull data with SQL queries for segmentation analysis and creating Data Extensions in SFMC with SQL and setting up filter conditions.
  • Plan, design, and implement application database code objects such as stored procedures and views
  • Provide database coding to support business using oracle
  • Perform quality assurance and testing of SQL Server environment

Excel/VBA Consultant

Confidential, San Francisco, Ca

Responsibilities:

  • Created a macro to combine several workbooks together
  • Created a macro to download and determine missing vendors from SAP
  • Developed new KPIs/charts for two new dashboards
  • Provided general business insights to new reporting and general MS Excel assistance
  • Fixed bugs in 10 old reports to function in new version of MS Excel
  • Decoded 16 past written vba programs from a previous manager to understand the logic and rules used to create the individual reports for new manager

Hire Now