Lorenzo Robinson

*** **** ****** ***.

Sugar Hill, GA 30518

Phone: 770-***-**** e-mail: acqic6@r.postjobfree.com

Objective: SQL Report Developers with more than 8 years of experience with Report Database Development and ETL. Skills include TSQL, SSIS, SSRS, Crystal Repots, on MS SQL 2012, 2008 R2,2005, MS SQL 2000, or Teradata. I also have 8 years experience using Excel and Access.

Summary of Technical Skills:

SSRS, Crystal Reports, Excel for Reporting tools

SSIS, FastLoad, as ETL tools for importing/exporting and transforming Data for MS SQL Server or Teradata databases.

Programming languages: SQL, PL/SQL, ASP.NET, C#, VB.NET, Java Script

TSQL for creating and maintaining database object such as Stored Procedures, Views, Tables(temp and perm), and UDF

Using SQL Server Management Studio(SSMS) or SSIS to create and scheduled Maintenance task such as Rebuilding/Reorganize indexes, Shrink Database, and setting up Database backup job.

Use SSMS to manage database and reports security.

Manage all levels of SDLC for database reports.

RDBMS: MS SQL Server 2008 R2, 2005, Teradata, MS SQL 2000, MS Access

Industry Experience: Telecommunication – Retail – Electronic – Transportation

Certification(s): MCSD, MCDBA

Experience

Jul Dec 2014 - May 2015 Invesco Atlanta, GA

Report/Database Developer

Develop analyze and support Global Financial reports utilizing MS SQL 2012 Business Intelligence tools from Business Analyst Requirements Documents.

Design and develop customer solutions using T-SQL ( queries/stored procedures/ functions)

Create and maintain indexes for improve query performance

Reconcile data and processing problems.

Development of reports which include parameterized reports (Static, Dynamic & Cascading Prompts), formulas, nested groups, manual running totals, summaries, conditional formatting and charts.

Jul Oct 2013 - Nov 2014 UPS Customer Solutions Alpharetta, GA

Database Developer

Utilize Microsoft Business Intelligence tools to create customer solutions from Business Analyst Requirements Documents.

Design and develop customer solutions using T-SQL ( queries/stored procedures/ functions)

Use ETL tool SSIS to provide an assortment of data sources for custom solution

Create and maintain indexes for improve query performance

Reconcile data and processing problems.

Development of reports which include parameterized reports (Static, Dynamic & Cascading Prompts), formulas, nested groups, manual running totals, summaries, conditional formatting and charts.

July 2009 - Aug 2013 AT&T Atlanta, GA

Database Report Analyst/Developer

Gathering reports requirements. Developing and maintaining reports per requirements spec's

Creating reports using tools SSRS, Excel, and MS Access.

Write TSQL/SQL for multiple RDBMS such as Teradata, and MSSQL system’s based on requirements provided by company’s analysts.

Created/participated in data validation of various - Functional Data Layer (FDL).

Working remotely and independently via VPN

April 2005 – June 2009 Chick-fil-A Corporation Atlanta, GA

MS SQL/Report Developer

Analyzed, designed, and created Crystal or SSRS Reports (web base or stand alone) on a SQL2005 database.

Developed TSQL projects using Stored Procedures, views, and UDF

Developed SSIS tasks to import and transform data

Using SQL Server Management Studio(SSMS) or SSIS to create and scheduled Maintenance task such as Rebuilding/Reorganize indexes, Shrink Database, and setting up Database backup job.

Use SSMS to manage database and reports security.

Use SQL profiler to monitor and tune SQL queries.

Developed dot net web application.

Debugged - maintain reports; Evaluated, prepared, tested, and implemented reporting solutions

Nov 2003 – April 2005 Inscape Shipping Services (ISS) Mobile, AL

Reports Developer / Application Support

Analyzed, designed/implemented Crystal Reports on SQL2000 database using Crystal vs. 8, 8.5, and 9.

Identified the appropriate authority and pass on level 3 service calls, track and supervise their successful timely resolution and closure.

Set-up new ISS customers with end users names, passwords and required desk top applications.

EDUCATION: Bachelor of Science degree in Computer & Information System

University of South Alabama - Mobile, Alabama

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate