We provide IT Staff Augmentation Services!

Sr.sql/bi (ssis/ssrs/ssas) Developer Resume

5.00/5 (Submit Your Rating)

Fort Worth, TX

PROFESSIONAL SUMMARY:

  • Proficient as Microsoft BI Consultant for past 7+ years in its products like Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS).
  • Experienced in Understanding System Development life cycle ( SDLC) such as requirement gathering analyzing, design, development , testing, implementation, deployment & maintenance of Projects.
  • Very strong in Transact - SQL Development Skills which includes creating Complex Business Stored Procedures , Tables, Views, Indexes, Functions , Constraints and CTE to implement business logic using SQL Server.
  • Extensive experience in Microsoft T-SQL statements (DDL and DML) including features like Temporary Tables, Raking Functions, Joins, Pivot, etc.
  • Experience in Performance Tuning of T-SQL queries using Execution Plan, SQL Profiler and Database Engine Tuning Advisor, Index design and analysis.
  • Developed ETL packages by Extract Transform and Load (ETL) data from various data sources to MS SQL Server and performing different kinds of transformations using SSIS services
  • Experience in working with advanced concepts of SSIS like Package Configuration, Catalog Logging, Checkpoints, Break Points, Parameters, Event Handlers, Error Handling, Deployment, Scheduling, and monitoring the Jobs.
  • Having Good Experience of implementing Data Warehouse design concepts such as Slowly Changing Dimensions, Change Data Capture, Facts and Dimension models.
  • Created various Reports like Tabular Reports, Matrix Reports, Drill down Reports, cascading, parameterized, link reports and Charts using SQL Server Reporting Services (SSRS) for better interpretation of client data in various domains.
  • Development of reports using Functionalities of SSRS, Snapshot methods, Cache method, Subscriptions and rendered them to HTML, XML, PDF and Excel formats using Reporting Services. 
  • Hands on experience in building OLAP Cubes, facts and dimension defining Referenced Relationships creating Hierarchies in SSAS.
  • Having Knowledge in Designing the SSAS cubes using star schema and snowflake schema, Dimension modeling, attribute relationships and create calculations using MDX.
  • Good communication, analytical and interpersonal skills, self-motivated, quick learner and an active team player and team leader. Very flexible and ready to take new challenges.

SKILLSET:

Relational Databases: Microsoft SQL Server, Oracle 10g/11g, MySQL

Programming/Scripting Languages: SQL, T-SQL, PL/SQL, C#, JavaScript, HTML5, CSS

Reporting: SSRS, Crystal Report, Power Pivot

Microsoft BI Tools: SSMS, SSIS, SSRS, SSAS, BIDS, Visual Studio.

Others: Word, Excel, PowerPoint, Access, Power BI

WORK EXPERIENCE

Confidential

Fort Worth, TX

Sr.SQL/BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

  • Interact with Development Teams and Managers to analyze business needs. .
  • Created SSIS packages to validate extract transform and load data from Heterogeneous sources and legacy systems to SQL Server.
  • Implemented Incremental loads to transfer data from OLTP to data warehouses using Control flow and Data flow tasks.
  • Created SSIS package to integrate data using Execute SQL Task, File System Task, Execute Package Task, Send Mail Task, Sequence container and for each Loop container.
  • Using SSIS worked extensively on different transformations like lookup, merge join, derived column, aggregate, conditional split etc.
  • Enforced data consistency by Debugged SSIS Packages using Data Viewers, Breakpoints and check point s.
  • Designed ETL packages with Error Handling, Package Configuration and SSIS Logging.
  • Deployed SSIS Packages and scheduled the jobs in various environments by configuring it. 
  • Generated reports like Tabular Reports, Parameterized Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts according to client requirements using SQL Server Reporting Services (SSRS).
  • Working with all Collections in reports like Fields, User, Parameters, actions and Report Items.
  • Deployed SSRS reports into Report Server and managed reports subscriptions, delivery, generation, rendering in Report Manager.
  • Monitoring performance of the database and to optimize quires using Execution plan, SQL profiler, and SQL server performance alert.
  • Wrote T-SQL queries in creating Stored Procedures, triggers, indexes, tables, views and other SQL joins and statements according to requirement.
  • Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views attributes and dimension members using SQL Server Analysis Services (SSAS).
  • Worked on processing multi-dimensional cube, querying multi-dimensional cube using knowledge of SSAS.

Environment: MS SQL Server 2014/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), SSAS Tabular, Cubes, MS SQL Server Analysis Services (SSAS), MS Visual Studio 2010, MS Excel, T-SQL

Confidential

Plano, TX

Sr. MSBI (SSIS, SSRS, SSAS) Developer

Responsibilities:

  • Used ETL to implement the Slowly Changing Dimension to maintain Historical Data in Data warehouse.
  • Created SSIS Packages to migrate data from heterogeneous source using Data Flow Task, Execute SQL Task, Bulk Insert Task, Send Mail Task, Sequence container and for each Loop container.
  • Developed SSIS packages for File Transfer from one location to the other using FTP task.
  • Used various SSIS Operations such as Conditional Split, Derived Column, Multi Cast, Mergeand Union all to perform some bussiness logic.
  • Developed SQL scripts to view the variable data, indexes, complex queries for data analysis and extraction.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
  • Performed Unit testing of ETL packages and reports to ensure the quality of data and which helps to identity problems before reach end user.
  • Involved in developing database objects such as triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
  • Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages.
  • Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using SSRS and deployed on report server.
  • Optimized existing reports and process reports like cache method,snapshot and implemented subscriptions using report manager.
  • Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views attributes and dimension members using SQL Server Analysis Services (SSAS).
  • Designing Cubes and Implementing Calculations in Tabular modeling using SSAS.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS(Tabular Model, Cubes), MS Visual Studio 2010 OLAP, OLTP, T-SQL, C#, SQL Profiler, SQL Server Mail Agent, MS Office 2013, MS Excel, Windows 10.

Confidential

Glen Allen, VA

MSBI Developer

Responsibilities:

  • Determined and wrote SQL quires and reviewed data to ensure data integrity, accuracy and validity.
  • Identified data quality issues and worked with appropriate teams to resolve them.
  • Extracting data from multiple sources like flat files and SQL server and transforming, cleansing, validating data and loading into final Destination.
  • Developed new mapping documents and used transformations like Look Up, Aggregation, Derived Column, Data Conversion etc transformations to match the needs of the business case.
  • Performed ad hoc reporting functions for special needs and requests, Designed and formatted data reports utilizing TSQL
  • Developed reports (Table, Matrix reports, Chart, Drill down, Drill through, Parameterized, Cascading, Conditional, Dashboard and Sub Reports, etc.) used by management group and clients to retrieve information.
  • Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
  • Used T-SQL for creating various complex objects like Tables, views, functions, stored procedure for storing and processing data in required form.
  • Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Agile, Multi Dimension, Cubes, Tabular Modeling, Management Studio, Data Transformation Services, Visual Studio, MS Access, T-SQL.

Confidential

Knoxville, TN

MSBI Developer

Responsibilities:

  • Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
  • Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in visual studio using SSIS.
  • Created SSIS packages using various control flow tasks and operations like Character Map, Aggregate, OLEDB Command, Multi Cast and Conditional Split.
  • Used Event/Error handling by assigning events at package and task level to handle errors.
  • Debugging control flow tasks, data flow tasks and SSIS packages by creating Data viewers check points and breakpoints.
  • Add logging information to SSIS packages to keep track of the package execution results.
  • Deployed SSIS Packages and scheduled the jobs in various environments by configuring it. 
  • Generated reports of various types including, sub reports, charts drill down, drill through, ad hoc, matrix, linked and parameterized reports using SSRS.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Modified the existing stored procedures to get the new functionality depending on the client requirement.
  • Optimized the performance of queries with modification in T-SQL queries, normalized tables, Established joins, and created indexes.
  • Experience working on Data Modeling, creating Star Schemas and Snowflake schemas in SSAS and creating Cell Level Security in cubes using SSAS.
  • Good in creating Cubes and Dimensions building, deploying, processing and maintaining cubes using SSAS

Environment: MS SQL Server 2008 MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Microsoft Visual Studio 2010, MS Excel, T-SQL.

Confidential

MSBI Developer

Responsibilities:

  • Extracting data from multiple sources like flat files and SQL server for transforming, validating the data to load into final Destination.
  • Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
  • Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
  • Created Event Handlers for the Packages for Error Handling.
  • Created Configurations to change the package properties dynamically. Maintained log information in SQL tables to track Errors and to record package execution status.
  • Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
  • Development of reports using different SSRS Functionalities like cascading parameters, Multi Value Parameters.

Environment: MS SQL Server 2008/2005, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), and MS Excel, Microsoft office Suite (Word, Excel, and PowerPoint)

We'd love your feedback!