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