Power Bi Sql Server
Resume:
VENKATESWARLU
Power BI Developer
ad5u1s@r.postjobfree.com
Having 8+ years of experience in the software industry and am proficient in Microsoft Business intelligence tools like POWER BI and TABLEAU, SQL Server Excel, Advanced Excel, Power Pivot, Power Query.
Good experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, QA, UAT and Production Environment).
Extensively worked on Power BI Desktop and Service and worked on the Power BI Reports & Dashboards with SQL Server.
Worked with Business stakeholders, application developers, production teams and across functional units to identify Business needs and discuss solution options.
Experienced in using Standard visualizations like Slicer, Card, and Stacked Column Chart, Clustered column chart, Line and maps.
Comfortable in working with filters, calculated columns, measures and transformations of Edit query section.
Worked on DAX Functions to create Calculated Column and Calculated Measures.
Having good experience on creation and scheduling of SQL server agent jobs.
Knowledge in Data Warehousing Concepts.
Ability to work independently or as part of a team to accomplish critical business objectives.
Extensive knowledge on creating reports using power Query, power pivot and power view.
Strong experience in using sources like Excel, CSV, flat file to extract and transformations like Data Conversion, Derived Column, Audit, Conditional Split, Lookup, Merge and Union all, etc.
Worked on the Power Bi reports & dashboards with SQL Server sources.
Used Table, Matrix, Bar, Card, Gauge, Slicer’s visualizations.
Worked on Custom Visualizations like multi slicer and Hierarchy slicer, Scroll card.
Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, Creating Drill through reports and Dashboard Customization using Bookmarks.
Good Knowledge of Installing and Configuring Power BI Report server.
Worked on DAX expressions like filters, Date, Aggregate, Mathematical Functions, etc.
Worked on Period to date calculations like YTD, QTD, and MTD by using date functions etc.
Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
Worked on On-Premises Gateway to refresh the data sources/creating a live connection with SQL SERVER.
Implemented Role Based Security as part of security in Power BI
Connect, import, shape, and transform data for business intelligence (BI).
Experience in developing Visualization reports and dashboards using Power BI.
Visualize data, author reports, and schedule automated refresh of reports.
Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
Technical Skills:
BI Tools
Power BI, Tableau
Databases
SQL Server, Oracle, Azure SQL
Languages
SQL, PL/SQL, DAX
Tools
SSMS, Visual Studio
Operating Systems
Windows 8.1, Windows 10
Cloud Technologies
Basics in Azure Data Factory
Technical Certifications:
Tableau Desktop Specialist Certified
Microsoft Power BI
Professional Experience:
Blue Yonder, Coppel, TX Dec 2021 – Mar 2024
Data Consultant & Power BI Developer
Responsibilities:
Developed and published dynamic and complex Visuals, Reports, Dashboard in Power BI Desktop and Power BI services
Used DAX to create complex measure and calculated columns.
Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
Imported custom themes and page backgrounds for rich visual effects.
Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
Majorly involved in ETL development sessions and suggested better approaches based on business requirements.
Developing & retrieving data from various sources and used data transformations (SQL server, Oracle, CSV, Excel, Text, Json file)
Generated Table, Matrix, Chart, Parameterized and Drill Down reports
Performed YoY, MoM, QoQ Analysis Using Date Functions, LOD’s.
Used Parameters and input controls to give users to give their inputs.
Responsible for debugging applications using the tools provided by the Visual Studio.
To monitor the production jobs, to troubleshoot for failed packages.
Good Knowledge on agile methodologies.
Responsible for fine tuning of the database, troubleshooting, memory management.
Charts are used in making reports more user friendly for analysis purposes.
Involved in Dashboard development and Unit testing.
Data modeling for Dashboard design by writing SQL Queries.
Environment: SQL Server 2012/2014, Power-BI, ETL, Azure Analysis Services, Oracle, and Azure Synapse, Visual studio 2013/2015, Microsoft SQL Server Management Studio, SSIS.
Federated Insurance, Minneapolis, MN Feb 2018- Dec 2021
SQL server/POWER BI Developer
Responsibilities:
Understanding and analyzing the business requirements.
Connect to Different Data sources from Power BI.
Used Table, Matrix, Bar, Card and Slicer Visualizations.
Developed user interactive Reports as per client business needs.
Responsible to Schedule the dashboards according to frequently (Daily, Weekly).
Supporting the dashboards and enhancing the reports based on the client's requirement.
Implemented Row level and Object level securities using tabular editor.
Customized transformations such as adding calculated columns, managing relationships, creating different measures, removing rows, split columns, date, and time columns.
Responsible import the data from SQL Server and build a Dashboards as per Client requirement.
Created schemas, keys and indexes considering the granularity of the data.
Creating many measures to calculate the total revenue, Profit margins and trend over period using DAX functions Time Intelligent Functions, Filter Functions, Aggregative and Iterative functions, table manipulative functions like Group by, Summarize, Top n, Values etc.
Worked in Agile Scrum Methodology with daily stand-up meetings and great knowledge in TFS (Team Foundation Server) 2010.
Deploying Azure Resource Manager JSON Templates from PowerShell worked on Azure suite: Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis Service.
Created OLAP models based on Dimensions and Facts for efficient loads of data.
Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by Creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
Project includes extracting, transforming, loading data from ERP database in OLAP cubes.
Implementation of SQL Server Analysis Services (SSAS), design/change/deploy OLAP Cubes.
Environment: Power-BI, ADF, SSAS, Oracle, Data Visualization, Microsoft SQL Server 2005/2008, Microsoft SQL Server Management Studio 2005/2008, Data Modeling, Pivot tables
BHARATI AIRTEL, Bangalore Jan 2016 – Feb 2018
SQL server/Tableau Developer
Responsibilities:
Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
Involved in gathering the requirements for reports.
Involved in designing, developing, testing, publishing, maintaining, and supporting Tableau & Tableau Prep applications.
Designed, developed, and implemented Tableau Business Intelligence reports.
Developed Framework Model as per requirements.
Developed Standard Reports and Drill-Through Reports.
Scheduled the reports according to user requirements and business needs.
Prepared SQLs to test the reports.
Testing the reports as per the checklist, unit test cases
Handled change requests in the Reporting requirements.
Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.
Enhancing and deploying the SSIS Packages from development server to production server.
Performed Documentation for all kinds of reports and DTS and SSIS packages.
Designed and developed complex SSRS reports.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Environment: Tableau, SSIS, SSRS, Power-BI, Microsoft SQL Server 2005/2008, Microsoft SQL Server Management Studio 2005/2008.
Education: Bachelor’s in Civil Engineering from JNTU University, Hyderabad in 2012
Contact this candidate