Stephanie Sims

1 Dice Street  |  New York, NY 11101  |  000-000-0000  |  stephanie.sims@dice.com

Talented VBA Developer with 6 years of experience developing successful custom applications

SUMMARY OF QUALIFICATIONS

• Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.
• Extensive experience implementing software user interface improvements based on client needs.
• Proven background completing projects under aggressive financial and time constraints.
• Use Rapid Application Development (RAD) Programming techniques to develop and execute applications and manage end-to-end tactical solutions to meet business challenges.
• Exceptional communication, analytical, and project management skills.

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Develop GUI interfaces using Open Database Connectivity (ODBC) to connect to Oracle and Sybase Relational Database Management Systems (RDBMS).
• Ensure projects are completed on time and within budget, achieving 97% success rate.
• Extensively use Excel functions in development, focusing on read/write integration to databases.

• Assisted with automation of finance department's manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Prepared visible columns and formulas; imported data from SAP and exported data for metrics.
• Exported information from report generated by accrual database to accrual upload in SAP.
• Worked directly with investment bank group to develop and implement priority solutions.

• Aided in development and management of Access database solutions using SQL Server, including macros and reports.
• Helped migrate legacy spreadsheets from front-office technology to valuation framework.
• Assisted in creation of internal applications for marketing and customer relations departments, including financial reporting tools and reports.
• Analyzed and tested systems. Provided on-site support and training for new users.