We provide IT Staff Augmentation Services!

Sql Reporting Analyst Resume

0/5 (Submit Your Rating)



  • 7+ years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
  • Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
  • Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2008.
  • Working Experience on SQL 2000/2005/2008/ R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • SQL Server 2005/2008/2008 R2 RDBMS database development including T - SQL programming.
  • SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
  • Developing reports on SSAS & SSRS on SQL Server ( 2005/2008/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture using BIDS
  • Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
  • ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
  • Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
  • Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008 and Transformation.
  • Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
  • Experience in creating Gauge Reports with KPI’s, Report Model and Report Builder 1.0, 2.0.
  • Thorough understanding of Kimball’s’ theory, KPIs and Perspectives, SQL 2008 Architecture.
  • Developed MDX Queries against SSAS cubes to generate reports using BIDS
  • Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Worked on Data modeling, creating star and snowflake schemas in SSAS.
  • Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
  • Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
  • Hands on Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R2/2005/2000 and excellent communication and analytical skills, understands business requirements in various domains.


SQL Server Tools: SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, Informatica 7.1.3/6.2

Databases: SQL Server 2000/2005/2008/ 2008 R2,2012 MS Access, Oracle

Programming Languages: SQL,T-SQL,PL/SQL,VB

Operating System: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0Windows XP/98/95, MS DOS, Linux.

Scripting: HTML, XML,VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET, ADOMD.NET

Tools: Erwin, Visual Studio 2008/2005 and SharePoint, Report Builder 1.0/2.0/ 3.0


Confidential, FL

SQL Reporting Analyst


  • Involved in reviewing the E-commerce application and interacted with business users to understand the report requirements for creating documents like data dictionary and technical specs.
  • Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
  • Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012.
  • Created reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services and SharePoint.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Involved in migration of several reports of SQL Server 2005 to SQL 2008.
  • Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2008 and then created reports using this data using SSRS 2008
  • Configured and maintained Report Manager and Report Server for SSRS
  • Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
  • Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
  • Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
  • Developed an automated report subscription process using SSRS 2008.
  • Developed user requested reports using Crystal Reports and Excel
  • Applied conditional formatting in SSRS to highlight key areas in the report data
  • Created report links to refer other reports in a particular report. And also created report links for different servers.
  • Created report snapshots to improve the performance of SSRS.
  • Developed several sales, marketing, finance reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI’s
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
  • Worked with SharePoint 2010 to publish documents and share reports for various Users.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005 and SQL 2008
  • Developed complex reports against SSAS Cubes and MDX Queries.
  • Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS transformations.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
  • Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.

Environment: SQL Server 2008, 2008R2 and 2012, T-SQL, SQL Profiler, Report Builder, SSRS, SSIS, Visual Studio 2005/2008, XML, Crystal Reports, Excel.

Confidential, NJ

SQL BI Consultant.


  • Involved in reviewing the insurance application and interacting with business users to understand the user requirements.
  • Involved in migration of SQL Server .
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Managed AMO (Analysis Management objects) using BIDS.
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL using Business Intelligence development studio.
  • Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
  • Developed MDX Queries against SSAS cubes to generate reports.
  • Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
  • Designed, developed, tested deployed, supported, maintained and documented (KPIs), Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server 2007 and SQL Server Analytical Services.
  • Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
  • Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Worked with SharePoint to publish and share reports for various clients.
  • Taking Database full Backup, Transaction log backup & differential backup in daily Routine.

Environment: SQL Server 2005/2008, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, MS Visio

Confidential, MN

MS SQL Server Developer/SSAS/SSRS/SSIS.


  • Participated in creating reports that deliver data based on stored procedures.
  • Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
  • Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
  • Experience in creating SSIS packages using dashboard.
  • Involved in writing classes for business logic layer using C#.
  • Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes using Business intelligence development studio.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Developed several Web controls -- composite and standard web controls -- using VB.NET and C#.
  • ETL capabilities of SSIS were used to define imports of the data, build scheduling packages.
  • Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
  • Iteration planning for new features and user stories in Agile Development methodology.
  • Configured and maintained huge OLTP databases.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).
  • Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes.
  • Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
  • Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Making a Report as per user requirement using MS Reporting Services 2008 (SSRS).
  • Created SSIS Packages to migrate slowly changing dimensions.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Worked on improving the performance of the system.
  • Involved in the tuning of the existing Database Objects.

Environment: SQL Server 2008, SSIS, SSAS, SSRS,, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003 & UNIX, .NET, C#, Agile Programming, Shell Scripting, Oracle, Crystal Reports.

Confidential, Atlanta, GA

SQL BI Developer


  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
  • Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Installation and configuration of SQL Server 2008.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.
  • Created SQL Server Analysis Project using MS SSAS 2008.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Created complex SSAS cubes with multiple fact measures groups.
  • Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
  • Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system using Business intelligence development studio.
  • Used performance Point Services, SSRS, excel as the reporting tools.
  • Wrote the expressions in SSRS wherever necessary.
  • Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Modifying report content and exporting reports in multiple formats based on the business requirements.
  • Designed and implemented Parameterizedand cascading reports using SSRS 2008.
  • Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
  • Created derived columns on the final fact and dimension tables as per the business requirements.
  • Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
  • Created Analytical reports by PROCLARITY tool.
  • Played a major role in production support of SSAS (cube refresh), SSIS jobs.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle

Confidential, Atlanta, GA

SQL BI Developer


  • Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
  • Migrated SQL Server 2000 DTS packages to SSIS 2005.
  • Developed SSIS 2005 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations.
  • Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
  • Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
  • Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
  • Developed, deployed and monitored SSIS Packages.
  • Developed custom reports and deployed them on server using SSRS.
  • Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
  • Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
  • Formatted reports using Global Variables, Expressions and Functions for the reports.
  • Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
  • Published dashboards on an intranet site using SharePoint Server.
  • Configured Report Model for developing ad-hoc reports by the end-users.
  • Uploaded reports on to the report manager and organized them into folders.
  • Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
  • Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
  • Assisted in the application development, debugging, configuration, and optimization from database perspective.
  • Involved in implementation of replications like Snapshot and Transactional.

Environment: - MS SQL Server 2005, Windows Server 2008,.MDX, DTS, SSIS, SSRS, PPS, SharePoint, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008.


SQL Programmer


  • Created new tables, written stored procedures for Application Developers and some user defined functions
  • Created SQL scripts for tuning and scheduling.
  • Involved in Migration of databases of SQL Server 2000 to SQL Server 2005.
  • Performed data conversions from flat files into a normalized database structure
  • Created and managed users, roles and groups and handled database security
  • Created Triggers to enforce data and referential integrity
  • Defined Check constraints, Business Rules, Indexes, and Views
  • Configured Server for sending automatic mails to the respective people when a DTS process failure or success
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server
  • Data migration (import & export - BCP) from Text to SQL Server
  • Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
  • Performed development support, document reviews, test plan, integration of the system
  • Creation/ Maintenance of Indexes for fast and efficient reporting process
  • Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
  • Creation/Deletion of Linked Servers
  • Managing historical data from various heterogeneous data sources (i.e. Excel, Access)

Environment: SQL Server 2000 and 2005, T-SQL, PL/SQL.

We'd love your feedback!