We provide IT Staff Augmentation Services!

Ssrs/ssas Developer Resume

0/5 (Submit Your Rating)

Reston, VA


  • 8+ Years of IT Experience including design, analysis, configuration, administration of Database and Business Intelligence solutions wif Microsoft SQL Server 2008/2012 in Development, Test and Production Environments in various business domains like Consulting, Financial, Pharmaceutical, Healthcare and Retail.
  • Excellent in MS SQL Server 2005/2008/2012 BI stack like SSMS, SSIS, SSAS and SSRS.
  • Extensive noledge in logical and physical data modeling, normalization
  • Good noledge of System Development Life Cycle (SDLC).
  • Experience in gathering customer needs, business requirements and resolving design issues
  • Participated in the testing process and works to improve the quality and efficiency of BI projects SQL Servicer Integration Services (SSIS)/ ETL
  • Extensive experience using Integration services (SSIS) and DTS for Extraction, Transformation and Loading data from various heterogeneous sources like Excel, Flatfiles, MS Access,Oracle, Teradata and DB2
  • Created, configured and deployed SSIS packages by applying various transformations and using various control flow tasks
  • Experience in designing custom components using C#
  • Expert in Migrating DTS Packages to SSIS 2005/2008/2012.
  • Configured SSIS packages in BIDS wif config file to execute packages across the different environment from development to test to production server
  • Implementation experience in running and scheduling SSIS packages, Fuzzy Look - up for cleaning bad data, validating data using SSIS wizard. SQL Server Analysis Services (SSAS)/OLAP
  • Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server)
  • Extensive experience wif SQL Server in Data Warehousing, OLTP/OLAP (MOLAP, ROLAP, HOLAP)environment
  • Experience in MDX development/conversions
  • Experience in developing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
  • Experience in working wif very large volume of relational databases and Cubes.
  • Proficient in developing Cubes and creating DSV’s,hierarchies, attribute relatioships,custom dimesions, partitions, aggregations and KPI’s wif SSAS.
  • Expert in creating calculated measures and dimension members using multi dimensional expressions (MDX)
  • Proficient in writing complex MDX queries for data analysis and reporting using SSAS & SSRS
  • Migrated and recreated existing Dimensions and Cubes using Star schema, Snow flake schema to achieve the efficiency of SQL Server Analysis Services (SSAS). SQL Server Reporting Services ( SSRS )
  • Experienced in report generation using Microsoft SQL Server Reporting Services (SSRS) as per the client Requirement and for the periodic analysis from relational databases and OLAP cubes
  • Experience in SSRS 2008/2012 design and deployment of Parameterized, Drilldown, Drillthrough, Sub, Linked, Snapshot, Cached, and Ad hoc Reports
  • Expert in defining Query for generating drill down reports in SSRS 2008/2012.
  • Experience in writing expressions in SSRS and Expert in fine tuning the reports.
  • Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint Database Design and Administration
  • Excellent in T-SQL programming like creating Stored Procedure, Triggers, Views, User defined functions and Indexes.
  • Experience in installation, upgrade, configuration and clustering of Microsoft SQL Server databases
  • Experirnce in SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
  • Created, altered, maintained system roles and permissions to users on various database objects.
  • Experience in optimizing the database performance by analyzing Execution Plan, creating various clustered, non-clustered indexes and indexed views
  • Performed daily tasks including backup, restore by using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • Experience in source control tools like Visual Source Safe, Team Foundation Server.


RDBMS: SQL Server 2008R2/2012, MS Access, Teradata, Oracle 10gDatabase Tools Enterprise Manager, Query Analyzer, SQL Profiler, Replication, BCP, DBCC

ETL Tools: SSIS, Informatica

OLAP/Reporting Tools: SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS), Crystal Reports, Business Objects, Performance Point Server, PowerPivot, SharePoint Dashboards, Power BI, Qlikview

Applications: MS Word, MS Excel, MS PowerPoint, Sharepoint

Languages: T-SQL, MDX, PL/SQL, HTML, C#

Scripts: VB Script, XML, UNIX, Javascript

Data Modelling Tools: Erwin Tool, Microsoft Visio, Kimball’s methodology


Confidential, Reston, VA

SSRS/SSAS Developer


  • Createdtabularandmatrix reportsinSSRS. Wrote stored procedures and functions to create SSRS reports.
  • Involved in thecreation and deploymentof the reports usingSSRSand configuring the SQL Server Reporting Server in SharePoint integrated mode.
  • Generated reports usingSSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from multiple tables.
  • Developed reports wif flexibility using Report Parameters Drop-Down Parameters Multi-Valued Parameters in order to meet the changing business needs (SSRS) and deployed to SharePoint site.
  • Created a high level design document which contains the specification details for the whole project.
  • Extensively used SSIS transformations in order to perform data cleansing and data mapping before loading the data in to data marts.
  • Created SSIS Configurations to migrate packages from Development to Test and to Production
  • Utilized T-SQL extensively in order to replace SSIS transformations in order to improve the performance of packages.
  • Used Microsoft TFS in order to share the code wif other programmers and as a source control
  • Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies, actions, partitions, aggregations based on the OLAP reporting needs.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes wif SSAS and in adding calculations using MDX.
  • Wrote the MDX queries for OLAP Reporting.

Environment: SQL Server 2008/2012, Sharepoint 2010/2013, MDX, SSRS,SSIS,SSAS

Confidential, Herndon, VA

SQL Server/ SSIS Developer


  • Converted the DTS Packages into SSIS using Migration Wizards
  • Migrated data from Excel, SQL Server 2000 to SQL Server 2005 via SSIS.
  • Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
  • Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from multiple tables
  • Developed SSIS packages wif which data resources such as Excel, SQL server for the daily load in order to create and maintain a centralized data warehouse
  • Designed and configured SSIS packages to migrate the Customer Information, Contracts Information and other important data from the Excel, Oracle,legacy System using various transformations.
  • Created Jobs to extract data from different sources using SSIS packages that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures for troubleshooting
  • Used SSIS packages to roll our data to Live Tables and to Reservation Processing Database
  • Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation
  • Worked on data modeling and developed different complex models as per given user requirement wifout any closed loops, Synthetic tables and ambiguous relationships
  • Developed SQL Scripts, database objects, procedures, functions and packages to support the Qlikview reports and dashboards
  • Scheduled and monitered the SQL Server Agent jobs to run the SSIS packages and stored procedures

Environment: SQL Server 2008, Windows Server 2003, Qlikview Developer 10.0, Sharepoint, SSISSSRS

Confidential, Austin, TX

SQL BI Developer


  • Involved in logical and physical data modeling, database design, star schema, data analysis.
  • Designed, developed and deployed Business Intelligence solutions using MS BI stack (SSIS, SSRS and SSAS)
  • Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
  • Migrated old data from legacy system into SQL Server 2008 using SSIS Packages
  • Built efficient SSIS packages for processing fact and dimension tables wif complex transforms and type 1 and type 2 slowly changing dimensions
  • Wrote lot of Stored Procedures and developed lot of SSIS Packages in DW environment. Responsible for ETL jobs scheduled to run and daily DW load
  • Created and configred various SSIS packages for optimal performance by studying the parallelism, buffer sizing and design approaches.
  • Migrated data from Oracle to Teradata data warehouse using Integration services (SSIS) and Informatica to generate the reports using SSRS for different SSAS Cubes
  • SSAS Cubes are built on top of the Oracle and Teradata data warehouses.
  • Make modifications and add new MDX to query the cube
  • Created partitions and aggregated cube for better performance.
  • Processed cube to perform incremental updates.
  • Built MDX queries for Analysis Services (SSAS) & Reporting Services (SSRS).
  • Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint
  • Constructed Cubes based on data volumes mostly adhering to Star Schema
  • Created complex SSAS cubes wif multiple fact measures groups, multiple dimension hierarchies and defined attribute relations based on the OLAP reporting needs
  • Built cube partitions using MOLAP, HOLAP,ROLAP methods for faster query performance and processing speed
  • Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports

Environment: MS SQL Server 2008R2, Erwin, SSIS, SSRS, SSAS, Oracle 10g, Sharepoint 2007, T-SQL, PL/SQL, MDX, Toad, Teradata, Informatica

Confidential, Des Moines, IA

SQL BI Developer


  • Worked wif business users to define and analyze problems, create logical data model, implement physical data model, and considers the implications of business solutions using MS BI stack to the current and future environment.
  • Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package
  • Conducted data migration processes in the SQL Server environment using SQL Server Integration Services
  • Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle using SSIS
  • Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
  • Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008
  • Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
  • Wrote MDX using various aggregate functions
  • Worked on designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing cubes using MDX.

Environment: MS SQL Server 2005/2008, Windows Server 2003 Enterprise manager, Query Analyzer, SSIS, SSRS, SSAS, DTS, PPS, ASP.NET, ADO.NET, C#.net, UNIX, Performance Monitor, Query Optimizer, T-SQL

Confidential, PA

SSAS/SSRS Developer


  • Involved in requirements gathering, analysis, design, development, change management, deployment and user training
  • Defined requirements and comprehended the complex business rules required for writing the code.
  • Involved in analysis, design, development, and enhancement of the data warehousing application.
  • Transformed data from various data sources using OLE DB connection; also scheduled automated tasks.
  • Created reports that call Sub reports in SSRS. Created Custom reports, datasets for reports using TSQL.
  • Generated multiple reports (SSRS) in drill mode using tables, cross tabs and charts.
  • Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports
  • Created partitions and aggregations for large measure groups in SSAS.
  • Wrote complex MDX queries for calculated members and measure groups.
  • Created Datawarehourse Cubes in SSAS 2005 and migrated them to SSAS 2008
  • Created SSIS packages and used Analysis Services (SSAS) processing task to update the cube wif current data, build the Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS)
  • Played a major role in the production support of SSAS cubes and SSIS jobs.
  • Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
  • Designed and Imported KPI’s into PPS score cards.
  • Created score cards wif executive summary dashboards using Performance Point Server 2007 Dashboard Designer and deployed them to Sharepoint server
  • Created interactive reports, canned reports wif SSRS using report parameters, query parameters, filters and expressions.
  • Performed Sorting, formatting, and Grouping to custom reports in (SSRS).

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS, PPS, TSQL,, C#.Net, ASP.Net UNIX Oracle 10g, Access

Confidential, Bloomfield, CT

SQL Server Developer


  • Took part in the meetings wif Sr. Business Analyst and managers and understood various process plans, business process, and functionality for developing applications using MS BI stack
  • Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using DTS.
  • Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
  • Developed Store Procedures and User defined functions (UDF) to access data from Data Mart.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created new cubes and modified existing cubes using SSAS to make data available for the decision makers.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
  • Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS, SSAS, SSRS, SQL Enterprise Manager, Windows XP, Oracle, TFS, MS Access, MS Excel, Windows 2003, HTML, VB.

We'd love your feedback!