SSRS Developer Resume Example IBM - London, West Virginia

SSRS DEVELOPER

Professional Summary

With Over 7 years of IT experience in Data warehousing and Business Intelligence across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Experienced in Software Development on working as Data warehouse and BI consultant involving implementation of large scale Data Warehouse, Data Migration Strategy and Implementation and Multidimensional Cube Design.
Strong experience in Design and Build cubes using SSAS, Dimensional Data modeling (Kimball Methodology), Cube optimization, Aggregation design and Partitioning, Hierarchy handling (ragged), and MDX Querying.
Good experience in Data Migration Implementation, Handling complex SCD, Late Arriving Dimensions, Package Development and code review, Source system data analysis and Data Profiling, Implementing Data Governance.
Strong experience in T-SQL query optimization and developing ETL processes on data extraction, cleansing/data integration, and loading from different data sources using SSIS.
Proficient in using T-SQL for developing complex Stored procedures, Triggers, Index, Views, User Functions, Relational Database Systems following Data Integrity and normalization
Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error handling by using Event Handler for SSIS Packages
Good experience in Designing, Maintaining & tuning various RDBMS like SQL server, Ms Access Database, Teradata and strong knowledge of SDLC principles.
Designing and Deployment of Reports for the End-User requests using BIDS.
Good Knowledge in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler and PerfMon.
Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the ETL jobs using wrappers.
Experience in handling the System Testing Phase of the ETL system and Test Plan Creation and Test Case Development.
Experience in projects with 24/7 production and implementation support.
Exposure to delivery models including Onsite / Offshore model.
Self motivated, quick learner and extremely versatile, excellent critical thinking ability, good interpersonal and communication skills.

Skill Highlights

SSIS, Datastage 8.1,Informatica
SQL Server, UNIX Shell scripting, Python
SQL SERVER 2005/2008/2012, MS-Access ,Oracle and Teradata

Management Studio, Query man, Toad, BIDS
Clear Case, Remedy 8.0, SVN
Windows server, Linux
SSRS, Cognos, Tableau

Career Accomplishments

Appreciation for completing and delivering the Sunrise project successfully.
Received appreciations for Delivery Excellence of MNP and ICR projects.
Team Award for Optimization and Stabilization of BI-DWH Operations
Received Q3 Bronze Award from CISCO(2019-2010)

Experience

SSRS Developer 09/2014 to Current IBM

Directly Interacted with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
Used SSRS to create reports, customized Reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Implementation and delivery of BI platform solutions to develop and deploy ETL, Reporting on SQL Server 2012 using SSRS.
Involved in Installation, Configuration and Deployment of Reports using SSRS
Generated Reports using Global Variables, Expressions and Functions for the reports.
Maintained scheduling the subscription reports with the subscription report wizard.
Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server reporting Services (SSRS) based on client requirement.
Developed and optimized database structures, stored procedures.
Performed Capacity planning to accommodate the new tables.
Involved with Query Optimization to increase the performance of the Report.
Involved in writing Stored Procedures and Functions, handle database automation tasks
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SSRS based on Relational databases.
Raised Change requests using Remedy 8 for all the deployments.
Responsible for creation of Unit test plans and System test plans.
Involved in creating and reviewing the ETL test cases for both Unit and System testing
Prepared implementation plans and provided walkthrough to all the key business stake holders to get their approval before implementing the code in production
Addressed all the live issues/incidents on time during the project warranty phase to ensure that there are no business impacts due to the implementations.
Providing knowledge transfer to offshore team and assist them in creating technical designs and in build activities.

SSIS DEVELOPER 01/2013 to 08/2014 KLIKTEL

Created new SSIS/ETL packages to cleanse and transform data into the Warehouse.
Involved in building Data warehouse whose primary source of data comes from external vendors and corporate sources which includes the data from various source system like Oracle 10g, Flat files, and Microsoft Excel file, XML files.
Creation of complex stored procedures for reporting and database development needs.
Automation of manual data insertion/manipulation processes by writing stored procedures and scheduling jobs.
Working with teams around the world and prioritizing tasks both for reporting and development objectives.
Participating in weekly meetings with clients to deliver the high standard support in their reporting needs.
Active participation in decision making and QA meetings and regularly interacted with the Business Analysts & development team to gain a better understanding of the Business Process, Requirements & Design
Scheduled Jobs and Alerts using SQL Server Agent.
Participated in design of Staging Databases and Data Warehouse/Data mart database using Star Schema/Snowflakes schema in data modeling.
Maintaining & enhancing the existing codes as per the requirement.
Follow complete quality process for implementation and Implemented code changes for optimization.
Involved in performance tuning for better performance and to reduce the load.
Created Understanding documentation and Release Testing documentation on the tickets handled, and documented the issues in a central repository.
Answer the support queries regarding business logics maintained in report or any difficulty faced.
Troubleshoot production issues and provide resolution for same
Mentored the offshore throughout the development & unit testing phase to understand the project functionality and monitored the development progress and conducted code reviews to ensure the quality of the code.
Provided support for the code during system testing phase.

SSRS DEVELOPER 05/2010 to 11/2012 INTELLIGROUP

Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2008 and MS SSRS 2008/2005.
Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.
Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
Delivered reporting content utilizing SSRS and SSAS
Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
Provided SSRS and SSAS support for internal IT projects requiring report development.
Assisted with documentation and code deployments from Development, QA and Production environments.
Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.

SSIS DEVELOPER 06/2008 to 03/2010 CISCO

Design and develop ETL processes using SQL Server Integration services, which is used for gathering and manipulating with data across different platforms and systems later used for building business reports.
Writing documentation and specification for the developed SSIS Packages, stored procedures and database schema.
Worked with business users/Analytics team, data architect to identify the business requirements and developed designed document for ETL flow, analysis of database architecture
Using FTP task, Execute Process task, File System task, For each Loop Container, unzip the folder from particular web location and copy it on the Local Server.
Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.
Created dynamic package Configuration using Environmental Variable and SQL Server configuration to make package portable and created Event handlers for handling package error by using a Custom Logging.
Performed unit testing at various levels of the ETL and actively involved in team code reviews, Design/Develop Test Plans, Test Cases and documentation of various processes involved.

Education

Master of Science: Advanced Computer Networking

Resume Overview

Create a job alert for [job role title] at [location].

About About

Help & Support Help & Support

Languages Languages

Customer Service Customer Service

SSRS Developer Resume Example

Resume Score: 70%