Sql Server Power Bi

Rekha Virupaksha G

Email: ad3jfj@r.postjobfree.com Phone: 765-***-****

Address: Lafayette IN (47905)

PROFESSIONAL SUMMARY:

Having 5+ 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.

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

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 of business applications using Power BI SQL Server 2016/2014/2012, DTS, SSIS, SSAS and SSRS 2012/2014.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Migrated on premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM, and developed and maintained databases across both on-premise and cloud deployments.

Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications.

Worked Extensively on ETL process using SSIS package.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.

Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.

Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS).

Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.

Experience in Migrating Data from an older version to newer version of MS SQL Server 2012.

Expertise in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross- Tab, Conditional, OLAP and Sub reports in Business Intelligence Development Studio.

Very good T-SQL Programming skills. Experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

Expertise in Functional testing, Manual Testing, Automated Testing, User Acceptance testing (UAT), System testing in working environments.

Experienced in creating interactive dashboards and scorecards utilizing Power BI.

Hands on experience in Power BI service.

Hands on Experience in Data Migration from MS SQL Server to Oracle ERP Systems.

Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

TECHNICAL SKILLS

RDBMS

MS SQL Server 2016/2014/2012, 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

EXPERIENCE SUMMARY:

Client: Evolent, Arlington, VA Mar 2022- Present

Role: Power Bi Developer

Responsibilities:

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

Designed and documented the entire Architecture of Power BI POC

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Automated Power Query refresh using power shell script and windows task scheduler.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Created Workspace and content packs for business users to view the developed reports.

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

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Created stored procedures and SQL queries to pull data into power pivot model.

Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.

Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing.

Extract Transform Load (ETL) development using SQL Server 2012, SQL 2012 Integration Services (SSIS).

Designing and Customizing data models for Data warehouse supporting data from multiple sources on real time.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.

Worked on all type of transformations those are available in power bi query editor.

Working with import and direct query, creating custom table in the Power BI.

Created PowerApps using wide variety of data connectors along with Common Data Service (CDS) to demonstrate KPIs and data visualizations.

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

Experience in refreshing dataset using Power BI gateway.

Using query editor in Power BI performed certain operations like fetching data from different file.

Having worked on configuring and developing Power BI dashboards.

Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Developed application in PowerApps using Common Data Service CDS,Flow,Excel,Forms and SharePoint online.

Developed complex DAX Queries to generate computed columns.

Storage development and design utilizing Blobs, Tables, Queues, Files

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

Defines and captures metadata and rules associated with ETL processes

Environment: T-SQL, MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), Power BI Desktop, Azure Data Factory (ADF), 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.

Client: Anthem, Atlanta, GA May 2020 –Feb 2022

Role: MSBI/SQL Server Developer

Responsibilities:

Interacted with business resources on a daily basis for analyze business processes, requirements progress and deliverables.

Used various Transformations such as For loop container, For Each loop container, execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow.

Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.

Created packages using the various control flow task such as data flow task, execute SQL task.

Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Generated monthly reports and budget analysis to drive forecast production plan with SQL Server Reporting Services (SSRS).

Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Created database objects like tables, users, roles, stored procedures, triggers.

Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

Worked on Data Warehouse Modelling with SQL Server Analysis Services (SSAS).

Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.

Optimized queries by using Execution Plan for better tuning of the database.

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Having worked on configuring and developing Power BI dashboards.

Involved in automating SSIS Packages using SQL Server Agent Jobs. Generated Parameterized reports, Sub reports, Drill down and Drill through reports using SQL Server Reporting Services (SSRS) working along with MDX queries.

Involved in Analyzing, Designing and testing of OLAP cubes with SQL Server Analysis Services (SSAS) 2014.

Debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.

Developed dashboards with Power BI which display key KPIs for business analysis and decision making.

Published reports on Power BI services, shared dashboards utilizing within the office 365.

Environment: MS SQL Server 2014, Micro Soft Visual Studio, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, Oracle, ASP.Net and C#.

Client: Easy Pay, Carlsbad, CA June 2018-Apr 2020

Role: SQL Server/ETL Developer

Responsibilities:

Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs

Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.

Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS

Installed, configured and maintained SQL Server Integration Services (SSIS).

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.

Development of Packages, Procedures, Functions,In dexes, Triggers and Packages.

Experience with the Share point 2007 to upload the SSIS packages in to Web portal.

Participated in requirement gathering, cube design, application design, SSAS development, training operational users.

Implemented SQL Server OLAP services (SSAS) for building the data cubes.

Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.

Exposure to CMMI, ISO, change control management, source safe, version controlling etc.

Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.

Developed reports using SSRS and published as PDF, Excel, and CSV formats.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Designing and building data load procedures using MS SQL Server.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Configured product meta-data tables to support client data reporting needs.

Incremental and full database recovery with experience of complex recovery scenarios.

Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries

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 Computer Application

Contact this candidate