Developing VBA code: Writing errorfree VBA code and building automated workflows for Excel
Maintaining applications: Developing and maintaining MS Office applications and creating and maintaining technical documentation
Analyzing data: Analyzing data within Excel and performing routine analysis like data mapping and database updates
Managing databases: Managing SQL databases and creating SQL Server views stored procedures and queries
Optimizing workflows: Optimizing workflows between Office programs like Excel and Access
Supporting existing processes: Supporting existing processes with automation and working with trading desk personnel to enhance workflow efficiency
Handling ad hoc requests: Handling any ad hoc requests to generate data files
Defining system scope: Defining system scope and objectives based on user requirements