Sql Server Power Bi

SREEJA GOGULA

937-***-**** ad5oku@r.postjobfree.com

Power BI/MSBI DEVELOPER

PROFESSIONAL SUMMARY:

Highly professional and well-versed MS SQL BI developer with 9 years practical hand-on experience in designing and developing with strong background in Data warehousing and ETL experience

•Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

•Technically and logically very sound in T-SQL Programming, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, Data warehousing, Business Intelligence etc.

•Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.

•Experienced in creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

•Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.

•Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization.

•Worked on DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.

•Efficient Experience working on OLTP and OLAP

•Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.

•Used Power Query to acquire data and Power BI desktop for designing rich visuals

•Experience in designing Star, snowflake schemas for Data Warehousing and OLAP needs

•Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS.

•Hands on experience on Power View and Tableau Software's for powerful and interactive platform for visual analysis and business intelligence

•Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drilldown reports using MS SQL Server Reporting Services.

•Experience in migration of Data from Excel, Flat file and Teradata to MS SQL Server by using SSIS packages

•Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

•Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.

•Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.

•Used Microsoft Azure platform for the building, managing applications and deploying web applications. Created Azure virtual machines

• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Joins, Inline views, Global Temporary Tables).

•Expertise in developing, enhancing and tuning of Oracle database objects and advanced PL/SQL programs.

•Experience in working in agile scrum development methodology.

•Excellent interpersonal abilities, communication skills, time management and team skills with an intention to work hard to attain project deadlines under stressful environments.

•Flexible and versatile to adapt to new- environment and technologies

P.S: Attached at the end are some sample Power BI dashboards I have worked on. Had to redact sensitive information.

TECHNICAL SKILLS

RDBM/Databases

MSSQL Server 2022/2016/2014/2012/2008 R2, Oracle 8i & 9i, MS Access, Microsoft Azure

Programing Languages

T-SQL, PL/SQL, C, MDX, HTML, Java, Python, C

Data Modeling

FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI (Power Pivot, Power View), Power Query, Power Map), SQL Server Analytical Services (SSAS), Visual Studio, Tableau, Power BI.

Tools/Database Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS).

Application Packages

MS Office, Microsoft SharePoint Server (MOSS)

Operating Systems

Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers, LINUX.

PROFESSIONAL EXPERIENCE:

Client: Crestwood Behavioral Health

Location: Stockton, CA

Duration: Jan 2022 - Present

Role: Power BI / MSBI Developer

Responsibilities:

Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data sources like MS Access.

Involved in Data Scrubbing and Data Cleansing using MDS, DQS.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.

Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.

Migrated multifarious sales reports in SAP business objectsres including complex cross tab, summary reports into Power BI.

Established the SAP business objects connectivity with SAP BW system and relational databases to implement the SAP Business object reporting requirement.

Deploy/ Design cubes in SSAS environment Snowflake/ Star schema designs for data warehouse purpose.

Implemented SSAS cubes, Facts and Dimension tables to perform analysis.

Optimized the SSAS tabular model process speed by properly designing data models and optimizing DAX calculations.

Involved in SSAS cube partition, aggregation and set KPI’s.

Creating Dashboard Reports using Power BI.

Implemented Power BI Power Query to extract data from external sources such as SQL Server, SAP BW, Oracle, and Azure SQL and modify the data to generate the reports.

Created various visualizations such as stacked chart, pie charts, Donut charts, cards according to business requirements. Worked on RLS to constrain the user access to the row level data.

Worked on both live and import data to Power BI for creating reports.

Worked with Power BI gateway to schedule daily job to refresh data

Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server

Managed relationship between Power BI using star schema.

Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.

Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks.

Environment: MS SQL Server 2022, SQL Server Integration Services 2022 (SSIS), SQL Server Analysis Services 2022 (SSAS), T-SQL, Microsoft Visual Studio 2022, JIRA, Import/ Export Tools, MDS, DQS, Power BI, TFS, Tableau, MS Access.

Client: Black Hawk Network

Location: Pleasanton, CA

Duration: April 2020 – Dec 2021

Role: SQL Server Developer

Responsibilities:

Cedar-Sinai Hospitals focused, modern, adaptable, innovative and inclusive system. The major responsibility was to create a centralized data warehouse in SQL Server 2012 to match the needs of clients.

Drew the flow chart of the trigger logic to remove the repetitive pattern in T-SQL to reduce dependencies

Extensively involved in Data Extraction, Transformation and loading from OLTP to OLAP system in SQL Server 2012 by creating cubes that uses the relational data warehouse as sources to its dimensions and facts.

Involved in the troubleshooting of several packages related to execution, development and performance.

Involved in implementation and maintenance of disaster recovery solutions like Replication.

Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Used SSAS MDX to extract data from cubes and create MDX script for representing cube calculations.

Involved in creation and deployment of reports using SSRS and configuring the SQL Server Reporting Services.

Generated database monitoring and data validation reports in SQL Server Reporting services

Deployed SSRS reports in Microsoft share point portal server.

Used Power Pivot to develop data analysis prototype and Power Map to visualize reports also created analytical reports and dashboards using Power View.

Experience in working with Azure SQL Database Import and Export Service, also deploying SQL Databases in cloud (Azure).

Environment: MS SQL SERVER 2016, SQL Server integration services (SSIS), SQL Server Analysis services (SSAS), and SQL Server Reporting services (SSRS), T-SQL, Microsoft Visual Studio 2016, Report builder / Designer, Share Point 2013, MDS, Power View, Microsoft Azure.

Client: San Joaquin General Hospital

Location: Stockton, CA

Duration: Feb 2019- March 2020

Role: SSIS/ SSRS/ SSAS Developer

Responsibilities:

Involved in automating SSIS Packages using SQL Server Agent Jobs. Created an ETL summary report which consists of the summary information for all the loading activities done each day and month.

Rewriting and optimizing Queries, Preparing Documentation and specification.

Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.

Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.

Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI Functionality of SQL Server.

Expertise in creating Perspectives, partitions and design aggregations in cubes using SSAS.

Involved in design implementation and modifying the python code and MYSQL database schema on the back end.

Wrote and executed various MYSQL database queries from Python-MYSQL connector and MYSQL db. Package.

Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.

Worked on formatting SSRS reports using global variables and expressions.

Experience in using SQL Profiler, SQL Server Agent and database Engine Tuning Advisor.

Used SQL Server Profiler to monitor and record database activities of users and applications

Environment: MS SQL SERVER 2012, Python 2.7, T-SQL, Microsoft Visual Studio 2012, SQL Server integration services (SSIS), SQL Server Analysis services (SSAS), SQL Server Reporting services (SSRS), MS Excel, SQL Server Profiler.

Client: AAA Mid Atlantic

Location: Mount Laurel, NJ

Duration: July 2017- Dec 2018

Role: SQL Developer

Responsibilities:

Installed and configured SQL Server 2012 for Development Purpose.

Created DTS packages to transfer the data from Oracle to SQL Server 2012.

Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.

Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time).

Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.

Involved in performance tuning of the database and T-SQL queries using Explain plan.

Designed and developed MS SQL server stored procedures using T-SQL statements from scratch.

Developed triggers on views to populate these tables.

Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.

Handling database objects with Enterprise Manager.

Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote complex SQL queries to perform Data Validation and Data Integrity testing. Used TOAD against Database.

Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.

As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Environment: MS SQL SERVER 2012, PL/SQL, TOAD, T-SQL, Dynamic SQL, SSMS, SQL Profiler, Query Analyzer, Enterprise Manager, Windows XP.

Client: Axis Bank

Location: Hyderabad, India

Duration: Jan 2014 - May 2015

Role: Software Engineer

Description:

The project involved in creating tables, views, indexes, stored procedures, functions, trigger, SSIS, ETL Packages, and various formats of reports in SSRS.

Responsibilities:

Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.

Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.

Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.

Responsible for quick response of SQL statement and connectivity from front application to the database servers.

Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Created SSIS packages to populate data from various data sources.

Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.

Environment: MS SQL Server, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS Excel, T-SQL.

Sample Power BI Dashboards:

SamplePow

Contact this candidate