Uploaded File
Ken
kenmix@bellsouth.net
904-563-1959
6270 Wiles Rd. #103
Coral Springs, FL 33067
Senior SQL Server T-SQL Developer
10 years experience W2
2
Recommendations
Average rating
236
Profile views
Summary

PROFESSIONAL SKILLS

Languages: SSRS, Crystal Reports 8.5,9,10, XI, 2008, 2012, 2013, Visual Basic 6.0, Access, VBA

Databases: SQL Server 2012, 2010, 2008 R2, 2005, 2000, T-SQL, Oracle 10g, 9i 8i, PL/SQL, Access, SQL Anywhere

Operating Systems: Windows 10, 8.1, 7 and, XP, 2000, NT 4.0, 95/98

CERTIFICATIONS

MCSD-VB6

Experience
Crystal Report Developer
Information Technology
Mar 2017 - present
  • Reformatted five Epicor reports to look like the same reports in their existing accounting system.
  • Modified the XSD files to import missing data for the reports.
  • Utilized Crystal Reports 2013
Crystal Reports XSD
Remove Skill
References
Average Rating

1 recommendation
Reporting Analyst/Developer
Information Technology
Mar 2016 - Dec 2016
  • Debugged and created several Crystal reports.
  • Used reports for identifying Date and Time fields as parameters.
  • Rewrote reports to optimize parameters.
  • Handled format clean-up.
  • Totaled the percentages as an average to calculate the correct percentage.
  • Modified several stored procedures.

SQL Server, T-SQL, Crystal Reports 2013 ​

SQL Server SQL Crystal Reports T-SQL
Remove Skill
References
Average Rating

0 recommendations
SQL Developer
Education
Jul 2016 - Sep 2016
  • Rewrote numerous stored procedures and made several structural changes archive database.
  • Created a SSIS package to copy the data and execute twelve stored procedures in parallel.
  • Utilized SQL Server, SSRS, SSIS, T-SQL
Stored Procedure SSRS SSIS SQL Server SQL Developer SQL T-SQL
Remove Skill
SQL Developer
Education
Jul 2016 - Sep 2016

  • Rewrote 13 stored procedures and made several structural changes archive database.
  • Created a SSIS package to copy the data and execute 12 stored procedures in parallel.

SQL Server, SSRS, SSIS

SSRS Crystal Reports SQL Server SQL Stored Procedure SSIS SQL Developer
Remove Skill
Reporting Analyst/Developer
Information Technology
Nov 2015 - Feb 2016

  • Created several complex SSRS and Crystal Reports.
  • Created pivot tables or Matrix reports.
  • Used 20 parameters to let the user extensively customize the report.
  • Created several SQL Server query reports.

SQL Server, SSRS, Crystal Reports 2013

SQL Crystal Reports SQL Server SSRS
Remove Skill
SQL Developer, Report Developer
Information Technology
Jun 2015 - Oct 2015

  • Created several Crystal and SSRS reports.
  • Crystal reports were made with sub reports and pie charts.
  • SSRS reports were developed with pie charts.
  • Created the SQL Server queries and embedded them in the reports.
  • Tables were made with over 100 million records.
  • Handled query optimizations to ensure they wouldn’t slow down the servers.

Crystal Reports 2013, SSRS, SQL Server

SSRS SQL Server SQL Developer SQL Crystal Reports
Remove Skill
Lawson Crystal Reporting Analyst/Developer
Healthcare
Oct 2014 - May 2015

  • Created and maintained hundreds of Crystal Reports.
  • Maintained 50+ T/SQL Stored Procedures.
  • Maintained Crystal Report Bursting Rights in Lawson.
  • Created tabs in Lawson that gave users access to new reports.
  • Setup and maintained Lawson report scheduling.
  • Used Dynamic Parameters to keep the report parameters current.
  • Modified Stored Procedures used with the reports.
  • Maintained the bursting rights of the report Users in Lawson.
  • Backed up data into a new table using SQL in a Crystal Command.

T-SQL, Crystal, SSIS, Lawson Reports

SQL Crystal Reports Stored Procedure SSIS T-SQL LAWSON
Remove Skill
T-SQL Developer
Information Technology
Oct 2014 - Oct 2014

T-SQL, SSIS, Lawson Reports

  • Created and maintained hundreds of Crystal Reports. Maintained 50+ T/SQL Stored Procedures. Maintained Crystal Report Bursting Rights in Lawson.
  • Created tabs in Lawson that gave users access to new reports.
  • Setup and maintained Lawson report scheduling.
  • Used Dynamic Parameters to keep the report parameters current.
  • Modified Stored Procedures used with the reports.
  • Maintained the bursting rights of the report Users in Lawson.
  • Backed up data into a new table using SQL in a Crystal Command.
Stored Procedure T-SQL SSIS SQL Crystal Reports LAWSON T-SQL Developer
Remove Skill
Reporting Analyst/Developer
Education
Jun 2014 - Oct 2014

  • Created SQL and SSRS reports based on user requests
  • Reports extracted data from SQL Server and Oracle using attached databases.
  • Built an SSIS project that extracted data from Oracle and SQL Server and copied the output files to a secure FTP site.
  • Helped clear up 9 months of backlogged reports.

SSRS, T-SQL, PL/SQL, SSIS

SQL SQL Server Oracle SSIS SSRS T-SQL PL/SQL FTP
Remove Skill
Access Programmer
Insurance
Oct 2013 - Feb 2014

  • Maintained a large Access system used to enroll customers in auto insurance plans.
  • Used SQL server through ODBC and reports use SSRS.

VBA, Access, T-SQL

VBA SQL Server T-SQL SQL
Remove Skill
SQL Developer
Banking/Financial
May 2013 - Oct 2013

  • Converted Oracle SQL reports to SQL Server.
  • Used TOAD and SSMS to edit the queries.

PL/SQL, T-SQL, SQL Report Writer

SQL Oracle T-SQL SQL Developer TOAD SSMS PL/SQL SQL Server
Remove Skill
Report Writer/Analyst
Information Technology
Mar 2013 - Apr 2013

  • Created and modified Crystal Reports for customer surveys.
  • Modified several SQL Server Stored Procedures to return additional data from new tables. Created an ER diagram of the database using Visio.
  • Worked closely with the business analysts to understand the requirements. Used Business Objects to promote changed reports.

T-SQL, Crystal Reports

Business Objects Business Analysis SQL Server SQL T-SQL Crystal Reports Stored Procedure
Remove Skill
Programmer/Report Analyst
Information Technology
Aug 2011 - Feb 2013

  • Create Excel VBA programs to generate interactive reports.
  • Spreadsheets used SQL through ODBC to extract data from a MySQL database and format the data for the customer.
  • Used forms in Excel to collect parameters that were inserted into the SQL statement.
  • Complex reports were used to join 7 or more tables.
  • Migrated all reports in Excel and Crystal to SQL Server 2008 in 4/2012.
  • Created many ad-hoc reports for upper management using pivot tables and charts.

Crystal Reports, MySQL, T-SQL, VBA

VBA T-SQL SQL Server SQL MySQL Crystal Reports Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Certifications
MCSD-VB6
Skills
Basic
2002
1
Visual Basic
2017
1
SQL
2016
4
T-SQL
2016
4
Crystal Reports
2021
3
SQL Server
2016
3
Microsoft Excel
2013
2
MySQL
2013
1
SSIS
2016
1
SSRS
2016
1
VBA
2014
1
Business Analysis
2013
1
Business Objects
2013
1
FTP
2014
1
LAWSON
2015
1
Oracle
2014
1
PL/SQL
2014
1
SQL Developer
2016
1
SSMS
2013
1
Stored Procedure
2016
1
T-SQL Developer
2014
1
TOAD
2013
1
Windows
0
1
XSD
2021
1