SQL / SSRS Developer Resume

TECHNICAL SKILLS

T - SQL, Select, Update, Insert, and Delete clauses.
All types of Joins including, Inner, Outer, Full Outer, Cross and multiple table joins.
Group By, Having, Union, Order By, Nested Case Statements & Exists Clauses.
Queries, Sub Queries, Correlated Sub Queries, Sub Reports & Aggregate Functions.
SSRS Expressions, Tablix Hiding. Tablix Filtering, and Nested Tablix Grouping.
SSMS, Stored Procedures, #Temp Tables, UDF’s & Parameter passing.

PROFESSIONAL EXPERIENCE

Confidential

SQL / SSRS Developer

Responsibilities:

Converted 60+ database reports from Crystal to an SSRS environment.
SSRS: Tablix hiding/filtering/grouping & nested tablix grouping.
SSRS: Matrix, rowNumber(), runningValue() & SSRS bar graphs.
SQL: Numerous joins, group by’s, aggregate functions, and nested case statements.
SQL: Creating, joining, & selecting from derived tables & derived columns.
Utilized queries, subQueries, correlated subQueries, numerous subReports & parameter passing.

Confidential

SQL / SSRS Developer

Responsibilities:

Rewrote all SSRS reports, Stored Procedures & T-SQL after conversion from Relational DB to Data Warehouse.
Worked Remotely from Dublin, Ohio to California successfully, smoothly and independently.
Utilized Tablix, Tablix Hiding, Tablix filtering, Tablix Grouping & Nested Tablix Grouping.
Utilized Single-valued, Multi-valued, Cascading, & Global Parameters. User Defined Function, UDF’s.
All reports include appropriate Header, Footer, Report Title, Page Number, Run Date & Corporate Logo.

Confidential

SQL / SSRS Developer

Responsibilities:

Developed numerous SSRS reports extracting Brand, Quantity Sold, Store Identification Numbers, Financial Totals, Vendor Numbers, & Date ranges.
Developed Linked Reports, enabling users to view another report by clicking a field in the main report.
Reported data on any combination of SSRS parameters using cross join technique.
Utilized Expressions, Visibility, Hiding, Publishing, Ranking & Interactive Sorting.
Stored reports on Team Foundation Server. (TFS). Published reports to website for end users.

Confidential

Entry Oracle DBA

Responsibilities:

Monitored Oracle Enterprise Manager (OEM) for critical alerts: listener issues, errors in alert log.
Resized table space .dbf files when over threshold. Ensured primary and standby DB’s were in synch.
Refreshed PA databases in Oracle via import, export, and SCP commands.

Confidential

Quality Control Testing

Responsibilities:

Performed numerous data validations including, row counts, column summations & date ranges via T-SQL.
Ensured no table contained duplicate rows and ensured no table contained orphaned no rows.
Created numerous Test Cases based on Functional Requirements and stored in Quality Center.
Executed Functional, Regression, and End to End Tests as required.