Uploaded File
add photo
Divya
divyajnr03@gmail.com
385-313-0415
Salt Lake City, UT 84199
MSBI/Power BI Developer
5 years experience W2
0
Recommendations
Average rating
18
Profile views
Summary

An SQL Developer with 5+ years of IT experience in database design, development, and administration with MSSQL Server 2016/2014/2012/2008/2005/2000 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS)

  • Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
  • Strong knowledge and Experience in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.
  • Expert in creating Power pivots, power query, Power views, and SSRS reports using tabular model (DAX), Cubes (MDX), and SQL queries.
  • Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance.
  • Experience in Dimensional Modelling, Designing of STAR, SNOWFLAKE Schemas.
  • Migration of SSRS reports from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages, and Backup/Restore of a database.
  • Experienced in creating Quick Table Calculations, Static and Dynamic sets, Parameters, and Level of Detail using advanced logical and statistical functions in Tableau Desktop.
  • Experienced in URL Actions, passing parameters from Tableau to web applications.
  • Highly proficient in design and development of prototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
  • Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
  • Worked Extensively on ETL process using SSIS package.
  • Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries, and T-SQL Scripts in MS SQL 2012/2008/2005/2000.
  • Generated different reports using MS SQL Reporting Services and Crystal Reports.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Expertise in SQL Server Analysis Services (SSAS) for Developing Tabular Model, Creating Measures, Key Performance Indicator, Hierarchies, Attribute Relations, Creating Prospective and Translations.
  • Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modelling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, Common Table Expression (CTE), Views, User defined data types, functions, Cursors and Indexes using T-SQL.
  • Expertise in Power BI, Power BI Pro, Power Bi Mobile.
  • Expert in Creating and developing Power Bi Dashboards in to rich Look.
  • Knowledge in all types of Database migrations with all the versions of SQL Server.
  • Have basic knowledge on Informatica Power centre Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, and XML Source Qualifier.

Experience
MSBI/Power BI Developer
Information Technology
May 2020 - present

Responsibilities:

  • Designing, Developing, and Managing BI Solutions.
  • Collection of Data from Various Sources, storage in the Data Warehouse, and designing Database Solutions like OLAP cubes.
  • Performed Unit Testing and Troubleshooting. Strong Proficiency with SQL and it's variations among popular databases.
  • Experience with some of the modern relational databases, Skilled at optimizing large complicated SQL statements.
  • Maintained multiple versions of Tableau dashboards using SVN.
  • Schedule reports administer users and user groups for workbooks, data sources, and views in Tableau.
  • Worked on data modelling in Power BI and Provide BI reports and tools.
  • Knowledge of best practices when dealing with relational databases.
  • Preparing Technical Documents and reports using SSRS and securing them.
  • Analysing data and present data through reports that aid decision-making.
  • Design, Develop, test, and deploy Power BI Scripts and perform detailed analytics.
  • Ability to interact with business as well as technical Teams.
  • Analytical mindset with a problem-solving approach.
  • Strong analytical skills and basics of database warehousing, modelling, and representation along with comprehensive Power BI and MSBI (Microsoft Business Intelligence) tools knowledge.
  • Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
  • Understand business requirements in BI context and design data models to transform raw data into meaningful insights.
  • Performing Data Modelling in Tableau Desktop.
  • Develop SQL Data transformation and optimization processes. Ability to create, troubleshoot, and modify SQL procedures, such as DTS, SSIS, SSRS, or other ETL tool is required.
  • Ensure performance, security, and availability of databases.
  • Write and optimize SQL statements to store, sort, and retrieve data.
  • Prepare source to target mapping data, like claims, insurance and provider related data.
  • Perform SQL queries
  • design, code, test, and aggregate the results to create useful information.
  • Create Dashboards and interactive visual reports using Power BI.
  • Comprehensive knowledge of data design, data modelling, data management, and data visualization.

Environment: SQL Server 2014/2012, Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008/2003, Oracle 9i, Crystal Reports, Performance Point Server 2007, Informatica, Excel, XML, .NET.

BI Developer Business Intelligence Crystal Reports Data Management Data Modeling Data Visualization Data Warehousing ETL Informatica MS Power BI Oracle SQL SQL Server SSAS SSIS SSRS T-SQL Tableau Tableau Desktop Windows XML
Remove Skill
SQL Power BI Developer
Information Technology
Feb 2018 - Mar 2020

Responsibilities:

  • Developed SSIS ETL packages to extract data from CDC tracking tables and loaded into data warehouse from CDC (Change Data Capture) enabled tables.
  • As a part of new DW solution, SSIS ETL packages auditing database designed to audit DW refresh on every package/table with count of inserts, updates and errors.
  • Designed, developed Cubes in SSAS (star-schema & snowflake) and building attribute relationships for optimal performance of Hierarchies.
  • Performed data consolidation activities Extract, Transform and Load (ETL) data from various source/destination SQL, Oracle, .CSV, .txt and Excel from Client servers.
  • Designed and delivered database design, data modelling and data dictionary.
  • Power BI tool (Power view, Power pivot & Power map) introduced to business and delivered power view dashboards as a self-BI tool.
  • BI Reporting Solution designed with Microsoft Power BI (Power View, Power Query, Power Pivot).
  • Endure that the code is written keeping in mind any security issues such as SQL Injection.
  • Develop reports in SQL Server Reporting Services.
  • Design, Develop and Deploy SSIS Packages.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code and T-SQL code from developers and QA.
  • Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).
  • Created T
  • SQL queries for data retrieval.
  • Created data using SQL Server Integration Services (SSIS) and coordinated with ETL developer's team to ensure data extracted, transformed and loaded according to the specified requirements.
  • Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizard.
  • Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Utilized Power BI Gateway to keep the dashboards and reports up to date.
  • Configuring Power BI Gateway for SSAS live connection.
  • Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services.
  • Utilized Power BI Gateway to keep the dashboards and reports up to date.
  • Configuring Power BI Gateway for SSAS live connection.

Environment: SQL Server 2016/2012/2008R2/2008/2005, SSRS 2012, Power BI Desktop, Power BI Service, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office, and Visual source safe.

BI Developer Data Dictionary Data Modeling Data Warehousing Database Design DB2 ETL ETL Developer Microsoft Excel MS Power BI Oracle SQL SQL Server SSAS SSIS SSRS Stored Procedure T-SQL Visual Studio XML XSLT
Remove Skill
Developer
Information Technology
May 2016 - Feb 2018

ETL/SQL Server Responsibilities:

  • Created data using SQL Server Integration Services (SSIS) and coordinated with ETL developer's team to ensure data extracted, transformed and loaded according to the specified requirements.
  • Installing, configuring, administering and securing production and non-production servers. Installed and configured SQL Server 2008 on the server and client machines, provide connections and manage databases.
  • Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
  • Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using SQL Server Reporting Services (SSRS).
  • Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Reviewed SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Consulting with data management teams to get a big-picture idea of the company's data storage needs.
  • Designing and Coding the data warehousing system to desired company specifications.
  • Developed SSIS ETL packages to extract data from Oracle Static database schema (GTA Schema), tracking tables and loaded into Data warehouse (DWH Schema).
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code and T-SQL code from developers and QA.
  • As a part of new DW solution, SSIS ETL packages auditing database designed to audit DW refresh on every package/table with count of inserts, updates and errors.
  • Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2014/2012/2008/2016.
  • Scheduling the ETL workflows SQL server agent jobs. Logging and Error handling during the ETL Process.
  • Expertise in SQL Server Analysis Services (SSAS) for Developing Tabular Model, Creating Measures, Key Performance Indicator, Hierarchies, Attribute Relations, Creating Prospective and Translations.
  • Expert in Creating and developing Power Bi Dashboards in to rich Look.
  • Knowledge in all types of Database migrations with all the versions of SQL Server.
  • Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation, and loading.
  • Worked with ETL team on designing Oracle tables for multiple projects, data analysis, and SQL Query transform.
  • Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP)
  • Ability to troubleshoot and solve complex technical problems.
  • Direct and/or execute the technical characteristics of the overall strategy of the Data warehouse and ETL process.

Environment: SQL Server 2012/2008R2 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), ProClarity Server, Crystal Reports, XML, MS PowerPoint, MS Access 2003 & UNIX, Shell Scripting, oracle.

Crystal Reports Data Analysis Data Warehousing ETL ETL Developer Oracle Shell Scripts SQL SQL Server SSAS SSIS SSRS T-SQL UNIX XML
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
ECE
not provided 2011
Skills
Data Warehousing
2021
4
ETL
2021
4
Oracle
2021
4
SQL
2021
4
SQL Server
2021
4
SSAS
2021
4
SSIS
2021
4
SSRS
2021
4
T-SQL
2021
4
XML
2021
4
BI Developer
2021
3
Data Modeling
2021
3
ETL Developer
2020
3
MS Power BI
2021
3
Crystal Reports
2021
2
Data Dictionary
2020
2
Database Design
2020
2
DB2
2020
2
Microsoft Excel
2020
2
Stored Procedure
2020
2
Visual Studio
2020
2
XSLT
2020
2
Business Intelligence
2021
1
Data Analysis
2018
1
Data Management
2021
1
Data Visualization
2021
1
Informatica
2021
1
Shell Scripts
2018
1
Tableau
2021
1
Tableau Desktop
2021
1
UNIX
2018
1
Windows
2021
1
Data Conversion
0
1
Data Marts
0
1
Database Backups
0
1
Erwin Data Modler
0
1
SQL Developer
0
1