Junior SSRS Report Developer Resume Bolingbrook, IL - Hire IT People

SUMMARY:

Junior SQL Developer with experience using SQL Server Management Studio and Visual Studio 2008
Highly analytical candidate with experience in the design, development, and management of application systems.
Understanding of data modeling and ER design.
Solutions - oriented working with teams and demonstrated competency in building scripts and queries.
Proficient in creating packages within SSIS. Skilled at building and deploying multi-valued parameterized reports including matrixes, charts, and gauges in SSRS. Excellent written communication and interpersonal skills.

TECHNICAL COMPETENCIES:

Microsoft SQL Server 2008, 2008R2, 2012
Query Performance Tuning
T-SQL
Data Flows
DB Security and Encryption
Scripting & Custom Components
Reporting Services
Package Deployment/Management
SQL Server 2008 Implementation
Error Logging & Handling
Advanced SQL Querying & Programming
SQL Server Management Studio
Business Intelligence Development Studio
MS SQL Server 2008 Integration Services (SSIS)
MS SQL Server 2008 Reporting Services (SSRS)
Microsoft Office 2013
Wordpress
Microsoft Access

PROFESSIONAL EXPERIENCE:

Confidential, Bolingbrook, IL

Junior SSRS Report Developer

Responsibilities:

Developed, updated and maintained various reports in Report Builder for company clients.
Built simple reports to more complex reports utilizing parameters for user customization.
Some reports fed off existing SQL stored procedures or queries while others needed a new query or stored procedure to be built to pull the data.
Updated and maintained reports by fixing bugs in already existing queries and/or stored procedures and added functionality to reports by updating current code to accommodate user/client requests, and used the tools in Report Builder to give the reports a nice aesthetic.
Deployed reports with Report Builder to report site, and used Report manager to modify reports to add recipients to report distribution list.

Confidential, Homewood, IL

Junior SQL Developer

Responsibilities:

Developed, updated and maintained various SSRS reports for internal users at company being fed of existing stored procedures in SQL that were used for various reporting purposes for correcting issues that were manually incorrectly inserted or just for analysis/reporting purposes.
Worked on a project to convert processes that existed in Access to exist and function in management studio. Started with a stored procedure template to create specific stored procedures based off of group requirements. Then used SSIS expressions to build bank Positive Pay output files that would have header, trailer and/or detail rows. Expressions were used to build this format to match sample files that were originally built in Access, which needed to be converted to SQL. Each group had its own unique file format and then later schedules for these output files were created via SQL agent to send file to clients on a schedule. All packs fed off an existing stored procedure that loaded a table with data to prep it for the generation of the output file.
Developed SSIS packages that used variables to store values for various purposes such as directory paths, file naming formats and conventions, and also dynamic updating date stamps for file names. Used one or many to combine variable expressions to create a string for a file name or for a file path to feed data into SSIS for the creation of specific Confidential output files. Also created Excel files with specific formats as well.
Used SSIS to insert records into tables for purposes of auditing to purposes of comparing values from the company’s data to data from another source.
Developed and maintained company wide Intranet for internal users using the Wordpress platform.
Developed and maintained a stored procedure to compare two different sources of data for purposes of comparing Health Claims information to see which groups and/or claims were missing from one source but were in another. Once missing claims and groups were identified the data could be inserted into a table and sent out every night so that daily charges differences could be updated on clients end and so that charges balanced out.
Designed stored procedure logic to select back everything from a table but only if a new row was added to the source that would be picked up and put in the copy table. Or if something changed in the source that was not like that in the copy the copy table would be updated. Or if something was deleted from the source then that would be deleted from the copy as well.

Confidential, Chicago, IL

Technical Assistant

Responsibilities:

Created advertising and marketing for the business using Google Ads.
Developed, managed and promoted a website using WordPress for small business to widen exposure.
Created, and managed Facebook page and also used it to advertise and market to attract new clients.
Created business documents and communicated with clients.

We provide IT Staff Augmentation Services!

Junior Ssrs Report Developer Resume

Bolingbrook, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship