Database Developer

BHARTI RAO

SQL BI DEVELOPER

Dallas, TX ***** 702-***-**** ******.*******@*****.***

SUMARRY:

Having 4+ years of IT experience in the areas of Microsoft Business Intelligence (MSBI) applications primarily using Microsoft SQL Server 2012/2014/2016.

Strong knowledge and Experience in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.

Strong T-SQL experience in creating different database objects Tables, Stored Procedures, DDL/DML Triggers, Functions and User defined data types. Skilled in writing and reviewing T-SQL code and maintaining coding standards.

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.

Experience with Relational and Dimensional data modelling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modelling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach.

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2014/2012/2008.

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

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 STAR Schema data warehouse design, slowly changing dimension,

Scheduling the ETL workflows SQL server agent jobs. Logging and Error handling during the ETL Process.

Creating packages for implementing ETL by using various control flow items like For Each Loop, For Loop, Execute SQL and Data Flow Transformations like Conditional Split, Multicast, Derived Column, Lookup, Sort, Union all etc.

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.

Expertise in Analysis Using Excel, Power Pivot Reports and Drill-Through Reports Dashboards Using Warehouse and OLTP Connections.

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.

Work History

DEC 2019 - PRESENT Power BI Developer

Care Source - Dayton, Oh

●Prepare source to target mapping data, like claims, insurance and provider related data.

●Worked on data modelling in Power BI.

●Utilized Power Query in Power BI to Pivot and UN Pivot the data model for cleaning and massing.

●Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.

●Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

●Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.

●Created views to restrict access to data in a table for security.

●Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

●Published reports and dashboards using Power BI.

●Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.

●Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.

●Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.

●Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.

●Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs.

●Utilized Power BI Gateway to keep the dashboards and reports up to date.

●Configuring Power BI Gateway for SSAS live connection.

●Developed complex DAX Queries to generate computed columns.

●Developed and published reports and dashboards using Power BI.

●Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services.

●Weekly presentation to the business users about the reports and their changes as required.

Environment: T-SQL, MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), Power BI Desktop, SQL Server Analysis Services (SSAS) 2016, Tableau, Visual Studio 2016, Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), SharePoint, MS Excel, Microsoft Windows Server.

MAY 2017–NOV 2019 SQL BI Developer

Blue Cow Software – Lynnfield, MA

●Participated in gathering User Requirements and System Specifications.

●Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.

●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 SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.

●Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.

●Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.

●Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

●Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.

●Design, deployment, and maintenance of various SSRS Reports in SQL Server.

●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.

●Backing up, restoring system & other databases as per requirements, and scheduled those backups.

●Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

●The project aims to help the company migrate from traditional reporting to more dynamic solutions and to continuously improve overall reporting performance.

●Actively participated in gathering Business Requirements that are focused on providing a user-friendly System usage or ambience

●Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).

●Involved in complete SSIS life cycle in creating SSIS package, building, deploying and executing the package in both the environments (Development and Production).

●Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.

●Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

●Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

●Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.

Environment: MS SQL Server, SQL Integration Services (SSIS), SSRS, Data Transformation Services, Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio, Windows 2012 Enterprise, MSOffice.

MAR 2014 - JAN 2015 ETL/SQL SERVER DEVELOPER

L&T - India

●Created T- SQL queries for data retrieval.

●Optimized queries tuned and monitored server performance.

●Monitored performance and optimized SQL queries for maximum efficiency.

●Created and modified Stored Procedures as per the business logic.

●Created other database objects like tables and indexes.

●Created views as per design needs for security reasons.

●Created SSIS packages to import/export sales data to/from the excel sheets, flat files, XML files or other databases as per the user requirements.

●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.

●Created tables for Data Ware Housing applications and populated the tables from the OLTP database using (SSIS) packages.

●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.

●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.

●Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.

●Managed up gradation of DTS packages to SSIS packages.

●Created SSIS packages to extract data from Excel File, Flat Files, and Text Files and Comma Separated Values (CSV) files using various transformations.

●Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using SQL Server Reporting Services (SSRS).

●Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizard.

●Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.

Environment: MS SQL Server, T-SQL, Windows Server, Erwin, SQL Server Profiler, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS, DTS, OLTP, XML.

EDUCATION

Bachelors in Commerce Berhampur university

TECHNICAL Skills

RDBMS: MS SQL Server 2016/2014/2012/2008/2008R2, MS Access, Sybase Server

Programming Languages: C, C++, Java, T-SQL, Oracle, VB scripts

Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business

Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET, TOAD

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),

Data Transformation Services (DTS), SQL Server Analysis Services (SSAS), MS Visio, Power BI

Application Packages: Microsoft Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, ProClarity

Operating Systems: Windows 10/8.1/8/7/XP, Windows Server 10/8.1/8/7/XP

Web Technologies: HTML, JavaScript, XML, Xpath

Contact this candidate