Dave Aiken Email & Phone Number

Rochester, New York

Having a broad set of skills I have contributed to the team throughout multiple areas of the project life cycle. Below lists the many hats that I have worn and the projects that have benefited from these roles.Roles include:Business Analyst: • Identified and gathered business requirements for internal system to submit and track job requests• Created and maintained system requirement documentation• Designed ticketing system for internal customer to log and track job requests Project Leader: • Assigned and monitored programming tasks of development staff. Updated management and internal customer of project statusSQL Developer:• Designed and Developed SQL Server databases and proceduresSQL Analyst: • Created prototype Power BI report of Financial Dashboard. Proved to team that internal resources could leverage the Power BI tool for more interactive reporting

Systems Integrator – Expert in migrating large volumes of data into and out of SQL Server databases. Uses SSIS to attach to and manipulate millions of records of data prior to loading into destination database. Work with customers to develop TSQL scripts to populate tables. Developer of complex SQL procedures and functions used retrieve and maintain data. Analyzed data and created SQL indexes to tune data and increase database performance.Account Manager – Main contact between customers and application development staff. Worked with customers to identify business needs within many different areas of their organization, many of which which, have materialized into successful projects. Keep customers informed on project budgets and project timelines. Provider of realistic expectations to customers and work with development staff to deliver quality projects. Project Manager – Responsible for coordinating and implementing projects . Worked with software analysts and customers to identify business requirements. Maintain constant daily contact with development staff and as needed contact with customer (hourly, daily, weekly) in keeping all parties informed about the state of their project. Work with customers to ensure a successful deployment of their projects.Systems Analyst – Asker of the “why” and “how’ question that result in spirited, yet successful discussions when architecting an application. In one instance, several design sessions were used to identify a customer’s true need. Creator of process diagrams, data flow diagrams. Created SQL database design, for relational database and data warehouses.Applications Developer – Creator a many windows and web based applications … mainly using Microsoft technologies. Tools used include: Visual Studio, ASP, ASP.NET.

Rochester, New York Area