We provide IT Staff Augmentation Services!

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.

Hire Now