Resume

Sign in

Software Engineer Sql

Location:
Saint Petersburg, Florida, United States
Posted:
January 01, 2018

Contact this candidate

Joseph Alan Wilkes

**** ********** *** **

St. Petersburg, FL 33702

727-***-****

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



Contact this candidate