- Featured in:
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Computer Software Resume Samples
SSRS Developer Resume Samples
No results found
0-5 years of experience
Developed and implemented a vital process in the migration and transition of all internal reports From Sybase to SSRS
- Extracted data from internal data warehouse system to SSRS
- Tracked trouble ticket request for request made by end users
- Created ad-hoc reports
- Modified SP’s and formulated basic coding and scripting to be utilized for reports within the organization
- Analyzed data models, data relationships, and dependencies for greatest optimization
- Designed and developed stored procedures, queries and views necessary to support SSRS reports
- Performed functional and performance QA testing
0-5 years of experience
Migrated all SSIS 2005 packages to SQL Server Integration Services 2008 and modified the packages accordingly using advance features of SSIS.
- Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
- Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
- Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
- Store procedures, User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
- Experienced in creating, designing, processing of cubes using SSAS.
- Responsible for creating and maintaining Analysis services objects such as cubes, dimensions, measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes.
0-5 years of experience
Created the SSIS package to load, change and clean the data various data sources to database.
- Designed ER diagrams and mapped the data into database objects and involved in normalization of the database in OLTP.
- Set database permission, backup, Maintenance Plans, SQL Server jobs.
- Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.
- Add package configuration and package parameters to ensure the package execution in another server.
- Developed cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes, dimension members, calculation, actions, partitions and perspective using SQL Server Analysis Services 2008R2 to analyze data based on sales information.
- Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
0-5 years of experience
Created Audit Reports based on CDC feature of SQL 2008
- Network Load Balancing Environments were built for [company name] BI Stack.
- Complex cubes were designed and developed with SSAS and delivered BI reports.
- Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
- Very good knowledge of MDX queries.
- As SME, provided guidance to other developers
- Worked with other developers in performance tuning of Databases and SSAS Cubes.
0-5 years of experience
Created and maintained T-SQL stored procedures, functions, created database objects like tables, views, triggers. Updated and maintained database data.
- Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, supported more than 20 client companies’ general business reports and benefit plan administration processes.
- Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2008/2012.
- Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
- Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
0-5 years of experience
Interacted between internal users and the third party Project Manager to determine which datasets should and should not be integratede over.
- SQL Scripting, using Microsoft SQL Server Management Studio 2008 R2, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses.
- Implemented a project for Product Lifecycle Management, using Visual Studio 2008, to create packages that would upload the current information into the new system.
- Setup batch purge processes for data older than a year.
- Some exposure to Windows Command Batch File, with adding a process that would kick off an e-mail upon error.
- Created a fragmentation report for heavily used tables, with information from a pivot script.
- Setup SQL views to pull specific information for SSIS packages.
0-5 years of experience
Create complex SQL stored procedures using SQL 2008
- Develop new reports and perform maintenance of existing reports
- Used to TeamPulse to track progress of projects
- Advise proper SSRS standards and created documentation on standard set forth for report formatting
- Creating reports using SQL SSRS 2008
- Code and document new utility applications using VB.Net
0-5 years of experience
Provided Dynamics AX reporting. Designed reporting frameworks and provided documentation for enhanced customization of the reports for the Operations team.
- Tracing data models in Dynamics AX 2009 for BI and reporting
- T-SQL, Stored Procedures and debugging
- SSRS installation and configuration
- VB.net and SSRS development
- Customized reporting and management pack development Service Center Operations Manager
0-5 years of experience
[company name] is a return-refurbish-repair company that works with returned, defective and broken electronic devices(Cell phones/Tablets/Videogames) from major wireless services carriers like AT&T, T-Mobile, Verizon, Sprint etc. The main goal of the project was to create a database solution for processing all those devices and create reports for management and business users.
- Involved in gathering Report Development Specifications (RDS) and SOWs for creating reports.
- Developed parameterized reports which were used for making current and future business decisions.
- Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.
- Created reports that projected business goals for future.
- Used table variables and Common Table Expressions (CTEs).
- Worked closely with the offshore team in finding solutions to arising problems.
- Identify the associated Store Procedures and parameters used for the reports
- Followed a priority based
- Involved in job scheduling and alerts.
0-5 years of experience
Worked as a SSRS Developer developing and maintaining new and existing reports. Working on a team of three with extensive use of Microsoft Management Studio 2008. Also, work to optimize and fine tune stored procedures.
- All reports are stored procedure driven by SQL Server 2008 with output of reports in Micrsoft Visual Studio
- 95% of work is done in SQL Server 2008
- Optimizing and Performance Tuning SQL Scripts in order to make reports run smoothly and efficiently
0-5 years of experience
Consultant; project completed
- Created HIT Metrics Data Warehouse cube.
- Stage data from ChangePoint time management system, import weekly into data warehouse via SSIS.
- Created numerous management reports in SSRS for HIT managers.
- Created SSRS functional reports for in-house TBS Thermocoupler tracking Asp.net C# web app.
- Tested data for data warehouse exported from Oracle and imported into Microsoft SQL.
- Developed requirements definitions for Supply Chain Management for daily snapshot of bookings and shipments.
- Created Mold Sheet ASP.net Visual basic Web App for Engineering Department – created requirements documentation, function design, code web app, test and create user documentation.
10+ years of experience
- Created and maintain a SQL Server database to store all data returned in HIPAA 835 and 837 files. Created interactive, parameter driven SSRS reports allowing clients to review and analyze their claims and remits from a Web based application.
- Write interfaces into client systems to extract data. Provide reporting for management and clients on workflow, productivity, comparative statistics, inventory and financial data.
- Create SSRS reports that call SQL Stored Procedures that initiate database updates and job calls based on actions taken by report user, enabling SSRS reports to function as an interface into a SQL database.
- Created SQL databases and stored procedures to import Credit Card transaction data from a Vendor’s FTP site for validation and creation of posting files, with SSRS report to reconcile input data with actual posted transactions.
- Wrote a SQL based vacation and PTO accrual system with monthly and weekly posting of amounts earned and automatic increments of accrual rates based on hire date and associated reporting.
- Create and maintain SSRS reports as Invoices and Monthly Summary Reports for clients.
- Use scripting software (Boston Workstation) to create projects to automate database posting in client and company systems, based on database information, as an enhanced productivity tool.
- Work with outside Vendors in collaborative projects.
SSRS Developer Duties and Responsibilities
SSRS developers perform a range of duties depending on the organization they work for. Based on job listings we analyzed, those duties typically involve:
Retrieve Data from Databases SSRS developers optimize SQL server queries to efficiently and quickly retrieve data. As teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.
Design Data Solutions SSRS developers create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.
Create and Maintain Reporting Processes SSRS developers maintain a record of the different reporting processes in place. They also develop ways to improve how a team currently operates with regard to data management.
Resolve IT and Data Issues When database issues arise or support requests come in through the help desk, SSRS developers work to resolve these problems. This requires an understanding of legacy solutions and issues.
Provide Delivery Plans and Estimates for Projects SSRS developers can work on multiple projects at any given time. They are often tasked with providing estimates and plans for these initiatives to different departments and company stakeholders.
SSRS Developer Skills and Qualifications
SSRS developers are highly skilled with computers and coding languages. They’re also critical thinkers and competent multitaskers. Typically, employers require a degree in computer science or a similar subject, as well as the following abilities:
- Analytical thinking – SSRS developers need to be analytical and able to spot problems that may otherwise be overlooked
- Problem-solving skills – one of the SSRS developer’s key tasks is finding a problem’s source and fixing the issue, so they need to be excellent at troubleshooting and finding resolutions to issues as they arise
- Teamwork – SSRS developers work closely with the IT team on different projects, so it’s important that they work well with others and remain professional at all times
- Computer literacy – SSRS developers need to be highly skilled with technical software and programming, since most of their day-to-day work depends on this knowledge
- Communication skills – SSRS developers must clearly relay technical information and actively listen to team members, so strong communication skills are beneficial to this job
SSRS Developer Education and Training
The minimum education requirement to become an SSRS developer is a college degree in a related field, such as information technology or computer science. Most companies also expect to see demonstrable development and programming skills, such as a portfolio or previous experience in a similar role.
SSRS Developer Salary and Outlook
The median annual salary for SSRS developers is nearly $72,000, according to PayScale. SSRS developers in the 10th percentile earn around $48,000 annually, while the highest paid earn close to $100,000 a year. Some companies offer packages that reach up to $9,000 from bonus structures based on individual or group performances, and profit-sharing opportunities of up to $3,000. Location and career duration have the biggest impact on salary, and over 70 percent of employers offer dental plans and medical insurance as part of their benefit packages. The Bureau of Labor Statistics predicts that this sector will grow 24 percent through 2026.
Helpful Resources
We’ve collected some of the best resources to help you start a career as an SSRS developer:
SQL Server Developers – more than 59,000 people have joined this LinkedIn group for SQL professionals, making it an ideal starting point for SSRS developers in the making. From sharing knowledge and experiences to discussing the latest SQL updates and trends, it’s a great way to get involved with important and beneficial conversations with others in the industry
Microsoft SQL Server 2016 Reporting Services – now in its fifth edition, this book covers the key components of working with SQL databases and SSRS capabilities, including new and enhanced features. From planning and configuring reporting services to enhancing reports and building reusable templates, this book covers everything necessary
Beginning SQL Server Reporting Services – this book turns novices into skilled developers, covering all of the key features of SSRS development. From building reports and dashboards to interactive features worth benefitting from, it’s a comprehensive look at this interesting and incredibly useful development environment
SSRS Developer Red-Hot Career Guide – including over 2,500 questions to prepare for interviews for SSRS developer roles, this book helps demystify the job search process and boosts readers’ confidence in their skills and knowledge of this field