Power Bi Sql Server

Location:

Frisco, TX

Posted:

August 08, 2024

Contact this candidate

Resume:

Deepthi K

(Power BI Developer/Power Analyst)

Email: ********.****@*****.*** Phone: +1-909-***-****

PROFESSIONAL SUMMARY

Around 9 years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, testing, and Implementation.

Strong experience in reporting tools like MS Power BI, and Microsoft SQL server.

Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end-users to better understand, analyze, communicate, and validate requirements.

Experience in SQL (DDL, DML, DB views, Synonyms, Indexes, Temporary column tables, table types, Partitioning), SQL script (Procedures, functions, Sequence, DB triggers) and CE-functions and Virtual Data Model (VDM), Core Data Services (CDS)

Experience in Information Models such as Attribute Views, Analytic views, Calculation Views (SQL script-based ), Hierarchies and Decision Tables.

Strong technical knowledge in SQL Server BI suite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS and various 3rd party tools.

Strong development skills with Azure Data Lake, Azure Data Factory, Azure Storage Explorer.

Implemented Copy activity, and Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.

Have a good understanding of different joins and unions like Inner, Left Outer, Right Outer,

Referential, Text joins and sizing, scoping, high availability, and Working with Query Editor to connect to different data sources and working on Data models. Creating new Calculated Tables, Calculated Columns and Measures.

Experience in developing custom reports, and different types of Tabular Reports, Matrix

Reports, Ad-hoc Reports, Drilldown, Parameterized, Cascade, Conditional, Table, Chart, and Sub Reports using MS Power BI. Creating relationships between different tables from different data sources and understanding of the Data modeling (Dimensional & Relational) concepts like star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Gained strong experience in Crystal Reports, Tableau and Actuate Reporting Suite with RDBMS like Oracle, MS SQL Server, Sybase, Teradata, DB2, MS Access, and with applications like Salesforce, Siebel and Maximo.

Extensively worked on Tableau Desktop connecting to various data sources including Excel, SQL Server, Oracle and DB2 databases.

Good understanding of Tableau Server options for publishing and sharing reports across various user groups.

Created complex dashboards and stories using several tabular and graphical worksheets and published on Tableau server.

Created reports connecting single and multiple data sources and also invoked stored procedures from server databases using Tableau Desktop.

Working with Power BI Service for creating Dashboards and sharing them to business users.

Working with DAX formula for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.

Extensively involved in design of Dashboard to display all the customer related information.

Developing all the visualizations which are requested by the business users using Power BI.

Design and developed the Power BI solution to create reports, visualizations, and dashboards as per the business requirements and published enterprise.

While designing the Power BI reports and dashboards, the measures are created using the DAX programming language. Writing all the calculations using DAX formulas.

Scheduled the data refresh for dashboards and reports to show the updated data.

Experience in integrating Power BI with MS Dynamics ERP systems (e.g., Dynamics 365 Finance and Operations, Dynamics 365 Business Central, Dynamics AX, Dynamics GP).

Leveraged Power BI's real-time capabilities to provide near-instant insights into MS Dynamics ERP data, especially in scenarios where real-time monitoring is essential.

Optimized the performance of Power BI reports when dealing with large volumes of ERP data.

Expertise in creating custom connectors to integrate with external systems, demonstrating your ability to extend the functionality of Power Apps and Power Automate.

TECHNICAL SKILLS:

Reporting Tools: MS Power Bl

ETL Tools: SSIS, Informatica.

Database: MS SQL, Teradata, Oracle.

Languages & Technology: SQL, Python

Markup Language: HTML, XML

Operating System: Windows, Linux

EDUCATION:

Bachelor of Technology in Information Technology, Anna University, India. 2016.

WORK EXPERIENCE

Sr. Power BI Developer/Power BI Analyst, August 2022 – Current

AllstateInsurance - Jersey City, New Jersey

Responsibilities:

Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.

Created Dax Queries to generate computed columns in Power BI.

Generated computed tables in Power BI by using Dax.

Involved in creating new stored procedures and optimizing existing queries and stored procedures.

Created Azure Blob Storage for Import/Export data to/from .CSV File.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.

Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Created various measures with Confidential and rich Power BI visuals for business and Configured security, Organizational Content Packs, data Gateways, refresh schedules for Power BI service.

Collaborated with the ETL/Informatica team to determine the necessary data models and UI designs to support Cognos reports by defining relevant attributes, dimensions, hierarchies, and metrics.

Explore data in a variety of ways and across multiple visualizations using Power BI.

Used Power BI Gateways to keep the dashboards and reports up to date.

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

Published reports and dashboards using Power BI.

Implemented various types of SSIS Transformations in Packages including Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.

Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups, and roles using Cognos Connection.

Involved in preparing Technical Design specification for the reports and transferred Technical Knowledge specific to Cognos tools and the existing data model to other team members.

Designing and Developing the Dashboard Reports in power BI using DAX.

Migration of the project from Micro Strategy to Power BI.

Implementing Agile methodology.

Provide SME support on issues/concerns for the Actuate to Crystal Reports and Tableau Migration project.

Extensively worked on Tableau Desktop to build worksheets, dashboards and stories for internal teams

Used Custom SQL feature on Tableau Desktop to create very complex and performance optimized dashboards

Provide technical support for the testing for Actuate, Crystal and Tableau reports for various applications as a part of Solaris EOL project including Solaris to Linux migration and Oracle database up gradation to higher version.

Performed peer review tasks for Actuate, Tableau and Crystal code/unit test case/unit test results.

Experience building Analytics Platforms using Python, in the financial sector with solid understanding of Python internals.

Developing the reports using POWER BI, Power Pivot and SSRS.

Implementing Drill Through & Hyperlinks in Power BI report.

Implemented error & failure handling in SSIS packages using event handlers, Row redirects, check points and used loggings for monitoring the execution.

SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

Created, tested, and implemented SQL backup strategy based on the business needs, utilize the combination of full, differential and transactional log backup to ensure all necessary business data is properly backed up.

Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.

Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.

Worked on knowledge transfer and documentation of various jobs developed and deployed into production.

Coordinated/Involved in deployment/migration of change requests to testing (System Integration Testing) and production environment.

Developing reporting of KPIs for teams using CD pipelines., company s internal CI system, providing a comprehensive API for CI/CD

Extracting data from MS Dynamics ERP databases and performing data transformations within Power BI using Power Query and M language.

Expertise in designing and implementing data models in Power BI, ensuring data accuracy, relationships, and performance for MS Dynamics ERP data.

Ability to create interactive and visually compelling reports and dashboards in Power BI to visualize ERP data.

Expertise in integrating Power Apps with various data sources, including SharePoint, Microsoft 365, SQL Server, Azure services, and external APIs.

Used Power Apps to automate business processes by creating workflows and triggers.

Implemented data push mechanisms within Power Apps to notify users of critical events or changes in real time. This could include features like push notifications or automated alerts.

capability to connect Power Apps and Power Automate to various data sources, including Power BI, to streamline data retrieval and sharing.

Sr. Power BI Developer/ Power BI Analyst, January 2021 – July 2022

Bank of America - Charlotte, North Carolina

Responsibilities:

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in the Development and Production environment

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.

Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

Designed and developed stored procedure, queries and views necessary to support the SSRS reports.

Created various Drill through, Parameterized, Tabular reports and matrix reports using SSRS and created subscriptions for users.

Extensively worked on development of new Crystal report (.rpt), Tableau workbook(.twb) and Actuate BAS and Report Design (ROD) files.

Worked with Data Extracts to create Tableau dashboards and scheduled extract updates at regular intervals for Invoice Team.

Built complex calculations to manipulate data and published final dashboards on Tableau server.

Implemented advanced techniques in filtering, grouping and sorting data as per user requirements using Tableau Desktop.

Developed various reports including Rebate, Market share, Exclusion, Summary and Details dashboards using Tableau Desktop.

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.

Worked on Creating, Modifying and updating the Views and Functions.

Used SQL Seach and SQL Prompt tools.

Modified the existing stored procedures to get the new functionality depending on the client requirement

Written Calculated Columns, Measures, and Queries in Power BI desktop and also Tabular model to show good data analysis techniques.

Worked on creating Power BI Dashboards using tabular model.

Created and Deployed reports using SSRS and configuring the SQL Server Reporting Server.

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

Extensive Dashboard design using Power BI

Developed a Canvas Power Applications and Workflows using Power Automation.

Publishing Power BI Desktop reports created in Report view to the Power BI service.

Environment: Windows server, SQL Profiler, SQL Query Analyzer, SQL Search, Power BI, SQL Server 2012, SSRS, T-SQL, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Power BI Developer, November 2018 – December 2020

United Health Care – Ridgefield, NJ

Responsibilities:

Gather Requirements, Data Warehouse Design, Semantic Layer (Tabular model) Design based on Requirement

Designed and documented the entire Architecture of Power bi Poc

Created various dashboards in the PowerBI desktop using table, matrix, bar, card, gauge, and slicer visualizations. Worked on DAX expressions like a filter, aggregate, mathematical functions, etc.

Created hierarchies and attributes as part of dimensional modeling.

Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting, and scorecard/dashboards on SQL Server 2008 using SSAS, SSIS/DTS, and SSRS.

Involved in designing, developing, and testing of the ETL strategy to populate the data from various source systems using SSIS.

Created SSIS packages to Extract-Transform-Load (ETL) from transactional system (OLTP) to analytical system (OLAP).

Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports, and parameterized reports to provide visible data for data analysts and business using SSRS.

Installation of Azure Data Factory gateway, Microsoft Power BI gateway, and Power BI desktop.

Participated in the Agile methodology's daily scrum and other sprint meetings; developed and prioritized product backlogs and the sprint burnt-down charts etc. to meet the daily deliverables and timelines.

Worked as Power BI Service Administrator.

As a part of Power BI Administration, configured Usage metrics, Users, Audit logs, Tenant settings, Dashboard settings, Power BI Apps settings, Power BI premium and Premium Capacity settings.

Used Power Apps visuals in power BI desktop.

Experience in developing custom business applications using Power Apps.

Worked with canvas apps in power App

Worked on all types of transformations that are available in Power bi query editor

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

Changed DB SQL server to snowflake cloud and migrated reports to snowflake.

Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset

Written calculated columns, DAX, Measures query’s in power bi desktop to show good data analysis techniques.,

Converting the existing Report from SQL Server to Snowflake DB.

Environment: Power BI, SQL Server 2012, Snowflake SSMS, SSIS, SSRS, T-SQL, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

ETL Developer, November 2017 – October 2018

Savitr Software Services, India

Responsibilities:

Creation, manipulation and supporting the SQL Server databases.

Involved in the Data modeling, Physical and Logical Design of Database

Helped in the integration of the front end with the SQL Server backend.

Created Stored Procedures, Triggers, Indexes, User-defined Functions, Constraints, etc. on various database objects to obtain the required results.

Import and export of data from one server to other servers using tools like Data Transformation Services (DTS)

Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, etc. to SQL Server using SSIS/DTS using various features like data conversion, etc. Also Created derived columns from the present columns for the given requirements.

Supported team in resolving SQL Reporting services and T-SQL related issues and Proficient in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.

Provided via the phone, application support. Developed and tested Windows command files and SQL Server queries for Production database monitoring in 24/7 support.

Created logging for ETL load at package level and task level to log a number of records processed by each package and each task in a package using SSIS.

Developed, monitored, and deployed SSIS packages.

Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drill-downs, drill through, sub-reports, navigation reports (Hyperlink), etc.

Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to minimize the report execution time and to limit the no of records required

Worked on all types of report types like tables, matrix, charts, sub reports etc.

Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.

Environment: Microsoft Office, Windows 2007, T-SQL, DTS, SQL Server 2008, HTML, SSIS, SSRS, XML.

SQl Developer/Programmer, September 2016 – October 2017

Glance IT Solutions, India

Responsibilities:

Created a spend reporting solutions that provides executives with user-customizable reports based on detailed general ledger data.

Replaced an existing database system for clients and standardized all application modules with cutting edge SQL methods.

Tested and implemented SQL driven applications from the ground up that offers solutions for real world issues.

Performed SQL, PL/SQL and application tuning using multiple tools, including EXPLAIN PLAN, SQL*TRACE, TKProf, and AutoTrace.

Wrote SQL queries to obtain data from multiple tables to spool into CSV format and provide extracts to all company businesses and users.

Utilized dialogue-mapping procedures to gather all the necessary requirements, in customer and client satisfaction.

Demonstrated expertise in using Oracle data modelling to boost departmental productivity and cut the overall production cost by 10%.

Managed the ETL process, developed physical data models, and created Stored Procedures, Views, and Functions.

Developed an ETL Database Model to carry out new procedures while creating various database warehouse dimensions to accept ETL outputs.

Led Oracle to PostgreSQL migration projects ensuring data integrity and system performance.

Created SSRS reports for in-depth business analysis.

Performed database defragmentation while optimizing the entire SQL queries, improving database performance and loading speed.

Gathered all necessary departmental requirements from business analysts, subsequently developing physical data models using Erwin while creating DDL scripts to design database schema and database objects.

Created Stored Procedures, Views and User Defined Functions the automation of data entry by a front-end application.

Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.

Created packages with several Transformation in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.

Created different kinds of SSRS reports such as Drill Dow, Drill Through, cascaded Parameterized, Linked, Ad-Hoc, Sub-Reports for in depth business analysis.

Tools: SQL, PL/SQL, Oracle, PostgreSQL, SSRS, SSIS, Erwin, Stored Procedures, Views, Functions.