We provide IT Staff Augmentation Services!

Sr Msbi Developer Resume

Bethesda, MD

PROFESSIONAL SUMMARY:

  • Result - driven professional with 10 years of experience as MSBI developer in various stages of Software Development Life Cycle (SDLC) like Planning, Design, Production, Development, Implementation and Unit Testing.
  • Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, UDFs and Triggers using Microsoft SQL Server Management Studio.
  • Proficient in developing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models using Business Objects.
  • Experience in using ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
  • Proficient in Extract, Transform and Load process using SQL Server Integration Services (SSIS).
  • Extensively used all components of Power BI by creating different types dashboards as per the business requirement and deployed into report servers.
  • Experience in developing Azure data factory pipelines in V1 and V2, creating linked services, data sets, monitoring and scheduling ADF pipelines.
  • Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
  • Experience in creating various SSRS reports like Charts, Filters, Sub reports, Drilldown and Drill-Through, Cascade, Parameterized reports involving conditional formatting
  • Experienced in debugging and troubleshooting SSIS packages using breakpoints, checkpoints, error handlers, event handlers, etc.
  • Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning
  • Involved in troubleshooting of performance issues which were associated with Tableau reports.
  • Hands-on experience in creating cubes, perspectives and deploying using SQL Server Analytical Services (SSAS).
  • Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Staging and Snow-Flake Modeling.
  • Having knowledge on Data Warehouse concepts on designing like star schema, snow flake, dimension and fact table.
  • Designed and Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
  • Good team player, strong analytical, written, communicational and interpersonal skills.
  • Knowledge in Web technologies such as HTML, DHTML, JavaScript and XML
  • Strength in problem solving and effective team player with excellent analytical, troubleshooting, and conflict resolution.
  • Excellent team management skills with Onsite-Offshore work co-ordination, good business acumen, effective communicator with Business.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: QL Server Reporting Services ( 2016/2014/2012/2008 ), MS Access, MS Excel, Crystal Reports, Business Objects 4.0

Database: MS SQL Server 2016/2014/2012/2008 R2/2008, MS Access, Oracle 9i/8i

Programming Languages: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML and CSS

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Sr MSBI developer

Roles and Responsibilities:

  • The scope of the project is to perform ETL process and generate customized reports to determine customers eligibility.
  • Developed various reports like charts, tables, matrix, sub reports.
  • Created different kinds of Tabular reports like Drilldown, Drill through, Cascaded parameters.
  • Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
  • Deploying and Scheduling reports to generate daily, weekly, monthly and quarterly reports.
  • Developed stored procedures using T-SQL to retrieve data and used it to generate ad-hoc reports.
  • Used Text Boxes, DAX functions, Creating Tables and changing Table visualization
  • Experience in MS SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
  • Created SSIS Packages to load data from sources like Flat files, Excel, OLEDB, XML, and Oracle to MS SQL Server.
  • Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
  • Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
  • Scripting knowledge using C# or VB knowledge to work on script components for ETL purpose by replacing existing transformations or to add an additional functionality for the packages.
  • Creating SSAS cube deploying and browsing the cubes using KPIs.
  • Experience in Importing/Exporting Data from various heterogeneous data sources to SQL server using transformation of OLTP data to the Data Warehouse using SSIS.
  • Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Dashboards using cloud service.
  • Participated in Maintenance activities of SQL Azure. Writing stored procedures, functions and complex T-SQL queries in SQL AZURE Cloud.
  • Create the Data lake Store and Azure Storage to store the structured and un structured data and set up the firewall rules to specific users to access the data.
  • Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions and Views.
  • Created dynamic reports in SSRS for data driven subscriptions to be delivered to various clients in excel.
  • Expertise in using global variables, expressions and functions for the reports with experience in handling Sub reports in SSRS. Good knowledge in developing and designing reports through SSRS and Excel.
  • Expertise in designing, developing, debugging and testing of reports in SSRS.
  • Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures.

Environment: SQL Server 2016/2012, Microsoft SQL(T-SQL), Microsoft SQL Server Integration Services (SSIS) 2016/2014/2012/2008 R2, Microsoft SQL Server Reporting Services (SSRS) 2016/2014/2012/ 2008 R2, Microsoft SQL Server Analysis Services (SSAS) 2016/2014/2012/ 2008 R2, HTML, C#, .Net, Microsoft Team Foundation Server (TFS), Azure, XML, MS Excel, ETL, OLAP.

Hire Now