Sr Msbi Developer Resume
Bethesda, MD
SUMMARY:
- An accomplished Senior Microsoft BI Developer and Data Analyst with over 10+ years of experience in design, development, testing, Implementation and staging environments for small to large - scale enterprise data warehouse. Expertise in working with all phases of Software Development Life Cycle (SDLC) and Agile Methodologies.
- 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.
- Experienced in medium to large scale environments in various domains like Finance, Retail and Healthcare.
- 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.
- Experienced in optimizing Stored Procedures, query performance tuning using SQL profiler.
- Proficient in Extract, Transform and Load process using SQL Server Integration Services (SSIS).
- Developed complex SSIS packages for processing type 1, type 2 and type 3 data with multiple transformations like Slowly Changing Dimension, Merge, Lookup, Derived Column, conditional split.
- Strong experience in automation of SSIS packages by scheduling jobs, creating and monitoring alerts.
- Experienced in debugging and troubleshooting SSIS packages using breakpoints, checkpoints, error handlers, event handlers, etc.
- Expertise in creating multivalued parameterized reports, multi-level cascading reports, drill down, drill through, sub reports, charts and ad-hoc reports using SQL Server Reporting Services (SSRS).
- 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 and Snow-Flake Modeling.
- Knowledge in logical, physical, star and snowflake schema, data mapping, and data normalization.
- Proficient in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, UDFs and Triggers using Microsoft SQL Server Management Studio
- Good team player, strong analytical, written, communicational and interpersonal skills.
- Have proven track record Developed various kinds of visualizations like donut, pie, word count, stacked bar/ column charts, scatter plots and tree maps using Power BI.
- Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings working with various environments and a valuable ability to quickly pick up new technologies and become an asset to the company in a minimal amount of time.
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
Operating Systems: Windows (10/8/7/Vista/XP), Windows 2015/2012/2008 Server
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.
- Developed reports using single value parameters, multi-value parameters with queried and non-queried parameters.
- 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.
- Created SSRS report templates for report development.
- Experience in 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 SQL Server.
- Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
- Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
- Created views and worked on slow running SQL to improve performance.
- 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 creating indexed views, complex stored procedures and useful functions.
- Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data marts.
- 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.
- Working experience in AGILE methodology and with DevOps Tools.
- Created data mapping document for all the clients by analyzing the data which is used in ETL process in SSIS.
- Skilled in error and event handling using precedence Constraints, Break Points, Check points and Logging.
- 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.
- Microsoft SQL Server Integration Services (SSIS), Analysis Services (SSAS) (Designing OLAP databases, MDX, DAX Queries), Reporting Services (SSRS), Tableau (10.1) Reporting (Report Creation and Administration), Power BI with Database/ Back end Testing.
Environment: SQL Server 2016/2012, Microsoft SQL(T-SQL), SSIS, SSAS, SSRS, HTML, XML, MS Excel
Confidential, Bluebell, PA
MSBI Developer
Roles and Responsibilities:
- The project mainly focuses to increase the annual sales that went down by 3% and to establish a database that can be efficiently used for online ordering.
- Proactively participated in gathering Business requirements to implement functional and technical specifications.
- Created data extracts and reports based on business requirements.
- Design and develop SQL procedures, views, functions, and triggers to fetch data from different tables by using joins.
- Troubleshoot and resolve complex issues and Error Handling in SSIS.
- Experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
- Created Data driven Tabular, Drill-down, Charts, Parameterized, Linked, Aggregate reports using SSRS Report Builder.
- Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
- Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
- Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
- Worked with SQL Server 2012 and created the SQL objects like tables, views in-order to pull the data and make modifications as per the business rules and provide the reports to the client.
- Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using SSRS.
- Generated Parameterized Reports and cascaded Parameterized Reports.
- Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
- In-Depth knowledge of SDLC, understanding of various phases like Requirements, Analysis, Design, Development and Testing.
- Reviewed many T-SQL issues using management studio for better performance.
- Generated Table, Matrix, Sub reports, Drilldown reports, Drill through reports, parameterized reports and linked reports from queries in SSRS as per the Client Requirements.
- Created dynamic reports in SSRS for data driven subscriptions to be delivered to various clients in excel.
- Developed tabular, sub report, drill down, cascaded, multi-valued parameterized reports using SSRS.
- Developed ETL packages using SSIS to load the data from various clients into specific tables
- Generated daily, weekly and monthly reports for the managers.
- Expertise in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
- The BI reports are developed to support the TRIA executive for better analysis with the history of data available from ERP. In this process, we have developed the reports from multi-dimensional data mart (Tria Mart)
- Developed various kinds of visualizations like donut, pie, word count, stacked bar/ column charts, scatter plots and tree maps using Power BI.
Environment: SQL Server 2014/2012, Microsoft SQL (T-SQL), SSIS, SSRS, MS Excel
Confidential, Boston, MA
MSBI developer
Roles and Responsibilities:
- The project mainly focuses on collecting, managing and analyzing data by translating data into actionable information.
- Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles. Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
- Designed and developed reports using Microsoft SQL Server Reporting Services (SSRS).
- Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Custom report and Drill down reports using SSRS.
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
- Responsible for requirement gathering from business users.
- Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
- Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.
- Designed Data flows, Workflows and jobs to load data from source to target.
- Responsible for data warehouse ETL development and maintenance, SSRS report creation, and SQL query performance tuning.
- Developed, enhanced, and supported processes using Transact SQL and SSIS which moved data from the Oracle system and other sources into the SQL Server warehouse. Assisted in conversion of ETL processes from Oracle to SQL stored procedures.
- Involved in integration of SSRS reports to embedded Power BI reports and deploy them on to power BI service.
- Developed diagnostic and descriptive analysis on various services offered to determine KPI's using Power BI and published the reports into Power BI service
- Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Created XML, PDF, EXCEL files using SSRS.
- Proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, multicast, Union All, Merge Join, Merge and Slowly Changing Dimension to load data into SQL Server destination.
- Experience in designing data source, data source views, dimensions, user defined hierarchies, and cubes using SSAS.
- Involved in performance tuning of dimensions, cubes for achieving better processing performance and quick query response.
- T-SQL development included queries using joins, subqueries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
- Developed various packages to extract the data from different source like relational tables and flat files.
- Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dump the data in to SQL Database.
Environment: SQL Server 2012, Microsoft SQL (T-SQL), SSIS, SSRS