Joseph Alan Wilkes
St. Petersburg, FL 33702
ac3vge@r.postjobfree.com
Qualifications
Excellent business analysis skills to provide comprehensive solutions to clients and business units
Ability to keep business units engaged in the project cycle, keeping changes to the project requirements at a minimum.
12 years of Database Development experience
Fluent in both SQL and Oracle
Created over 500 SSRS Reports
Created Over 100 SSIS Packages
Software Proficiencies
Languages: VBA, VB.NET, C#.NET
Environments: VB6 IDE, VS 2003, VS 2005, VS 2010
Databases and Reporting: SQL Server 2000, 2005, 2008, T-SQL, SSIS, DTS, SSRS, DB2, Informix, Oracle 11G, Oracle 12C, Tableau
CRM: ACT!, Mars, SalesPage
Experience
Senior Software Engineer, Eagle Asset Management, St. Petersburg, Florida, 7/05 – Present.
Worked as the lead developer, with major responsibilities include system architecture, design, and custom reports utilizing SQL databases and maintenance of SimCorp Dimension.
Implemented Bloomberg AIM From Charles River utilizing SSIS
Created multiple SSRS Reports utilizing multiple data sources including SQL and Oracle.
Created a new client statement using CoricReporting Tool.
Implemented SSIS packages to automate compliance reporting integrating a 3rd party tool to pull Bloomberg data.
Optimized SQL Queries and Stored Procedures.
Optimized Oracle SQL Queries and Procedures
Converted processes from VB6 and Excel to VB.Net/C#.
Converted Excel and Crystal Reports to SSRS Reports.
Successfully implemented third party CRM software for 50 associates.
Successfully implemented multiple IT projects for Accounting, Operations, Sales, and Client Services.
Created and provided application training for in house developed applications.
Created new processes based on departmental specifications.
Created stored procedures and function for the automation of processes.
Automation of processes to save hours of manual entry.
Optimized Oracle PL/SQL code to improve performance decreasing time to completion by 6 hours after 2 hours of work.
Technical Coordinator, Heritage Asset Management, St. Petersburg, Florida, 4/02 – 7/05.
I was responsible for maintaining and upgrading computer hardware and software within the company. I created maintained and fixed VBA code within the business units. I was responsible for converting MS Access to SQL.
Created macros that were used to automate steps in a process.
Successfully converted Access Databases to SQL. This was accomplished by creating a VB 6.0 application to interface with the SQL tables and stored procedures.
Successfully upgraded over 100 PCs to a new version of windows and office.
Identified and repaired hardware and software problems
Education
University of South Florida
BS in Management of Information Systems - April 2004