Excel Programmer Resume
There are many things one can do in Excel apart from creating spreadsheets, sorting data, and doing numerical calculations. The best use of this strong applications is done by Excel programmers. These programmers use VBA, and C# knowledge to create specific Excel templates which is then used to fill in source data, verify the data, import data from the database into Excel, read and modify worksheet data, and develop interface between Excel sheet and the database. To apply for an Excel programmer position, your resume need to show experience in VBA and C# programming.
Excel Programmer Resume Example
Thomas G. Douglas
4657 Victoria Street
Chicago, IL 60631
Phone: 224-871-6325
Email: thomas.douglas@anymail.com
Career Summary:
Detail-oriented, competent, and certified 'Excel Programmer' with over 5+ years of experience in writing code for Excel macros, maintaining database, and timely completion of assigned tasks. Expertise in ensuring updated data records and preparing apt reports with the help of formulas. Familiar with entire project life-cycle, ability to gel well with the team, and have excellent mathematical as well as written/verbal communication skills.
Summary of Skills:
- Complete knowledge of Excel functions and macro programming
- Outstanding VBA and C# programming skills
- Expertise in SQL server database design and development, and capable of maintaining clean, accurate, and updated data records
- Adept in developing programs using different languages, including C++, Java, VB.NET, C# and SQL according to project requirements
- Excellent understanding of software development life cycle
- Knowledge of Oracle, MySQL, and Unix Scripting
- Skilled in loading and extracting data from databases into worksheet
- Ability to document test events and coding details
- Adept in troubleshooting technical problems and creating Excel templates
- Superior communications and organizational skills
Work Experience:
Excel Programmer
Alpes Computer Software Inc., Chicago, IL
April 2017 - Present
- Create Excel templates to be used for specific purpose or as per requirement
- Developing and executing complex SQL scripts for fast and effective retrieval of required data from the database
- Program the templates that is easy to download, fill in data, update, and upload it to the server
- Export and import data to and from database into Excel sheet
- Plan, test, and implement templates
- Provide technical support to end users
- Design, and write automation code for database queries and resolution
- Create training manuals for end users
- Provide on-site and off-site assistance for solving technical problems
Excel Programmer
CUBIX Technologies, Chicago, IL
January 2015 - March 2017
- Resolved operating system problems
- Reviewed, and modified codes for better functionality
- Documented changes done and codes implemented
- Worked with software team to design, develop, support and document custom scripts to monitor system performance, system availability as well as system security using C#, Power Shell, T-SQL and Excel VBA
- Coordinated with the team to loop Excel sheets or files in correct sequential logic and implement data manipulation for projects
- Handled import and export of data to and from database
- Wrote accurate SQL queries to check efficiency of data retrieval from project database, and made modifications in the code as and when required
- Analyzed needs of modification and implemented development
- Provided maintenance and security to Excel worksheet and database
- Remodeled user-defined functions and tabs for different instructions
- Developed mail automation and reporting functions
Junior Excel Programmer
Nexant Solutions, Chicago, IL
July 2013 - November 2014
- Worked as per project manager's guideline to design and program scripts to load historical data and monthly data into database
- Performed routine data standard requests with the senior member of Data Management team to ensure accuracy and confidentiality of the data
- Coordinated with the team to maintain/create a SAS macro and developed methods to ensure data consistency as per industry standards
- Assisted to write Excel macros to automate routine tasks, import the data to meet the business reporting requirements
- Worked under the supervision of senior developers to develop, test, and modify VBA macros run on Excel Visual Basic Editor to ensure the code delivers expected results
- Participated in business requirement discussions with different operation teams to develop and maintain multiple dashboards using Advanced Excel with help of formula as well as charts
Education:
-
Bachelor's Degree in Information Technology
The University of Chicago, Chicago, IL
2012
- High School Diploma
Crystal Elementary School, Chicago, IL
2008
Training/Certification:
- Microsoft Certified Solutions Associate, 2013
- Completed 6-month online training in Excel VBA Programming, 2013
Reference:
On request.