OnBenchMark Logo

SIVA (RID : 6v6vlwp8g81t)

designation   POWER BI

location   Location : PUNE

experience   Experience : 7 Year

rate   Rate: $17 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 0
Total Views : 39
Key Skills
POWER BI SQL TABLEAU PYTHON AZURE ETL
Discription

 

SIVA SAI RAM                                                                        

 



 

 

 

Experience Summary:

Having 7+ years of professional experience as Business Intelligence Developer using SQL, SSIS and Power BI, A dynamic, talented, and experienced data analyst with excellent knowledge in data modelling and analysing large data, building, deploying, and maintaining data support tools. Expertise in BI research and development of software tools. Possess excellent communication and leadership skills.

Professional Summary:

  1. Very good experience in creating Stored procedures, Views and User defined functions (UDF) using various DDL and DML Commands
  2. Having experience in creating and maintaining database objects like Triggers, Cursors, Synonyms, and Indexes.
  3. Experience in Query Optimization and Performance Improvement of SQL queries.
  4. Involved in database design & Implementing Data Warehouse, by using relational integrity constraints, OLAP & OLTP Systems.
  5. Created packages in SSIS Designer using Control Flow and Data Flow Transformations to implement business rules.
  6. Expertise in using data flow task components like Conditional split, Derived column, Aggregate, Row count, OLE DB command, Sort, Multicast and Data conversion.
  7. Hands on experience in performing incremental loading and maintaining the historical data using Look up and SCD Transformations.
  8. Experience in Importing data from different data sources by using connection modes like Import and Direct Query and Live Connection.
  9. Experience in creating relationship between different Data Sources by using Data Modelling and manage relationships.
  10. Good Experience in Writing complex Measures and Calculated Columns by using Dax functions like Time Intelligence functions, Text functions , Table manipulation functions, Logical functions , Date & Time Functions and Filter functions.
  11. Hands on Experience with Visual level, Page level, Report level and Drill Through filters and various visualizations like PIE chart, column chart, bar chart and custom visualizations
  12. Implementing RLS security as well as Incremental refresh using various different gateways for scheduling refresh data by configuring and managing for power bi data gateways.
  13. Involved and Maintaining workspaces and admin activates.
  14. Good experience in writing DAX queries and designing reports using Power BI.
  15. Involved in Deployment ,Migration and Schedule Jobs

 

 

Education:

B.Tech (Electrical &Electronics Engineering) from JNTUA (2010-2014) Job details:

    • Worked with Confidential as Senior Data Engineer from Oct 2023 to Till Date
    • Worked with Confidential as SQL & Power BI Developer from April 2022 to June 2023
    • Worked with Confidential as Power BI Developer from Nov 2016 to March 2022

 

 

Power Platform

Power BI Desktop, PowerBI.com (services), DAX, M-language, Power App, Power Automate

Excel BI Skill

Power BI, Power View, Power Pivot, Power Query, Power Map)

Languages

M-Lang (Power Query), DAX (Power Pivot), T-SQL, R (Programming)

 

Database/Azure

SQL Server, SSAS Tabular, Azure Analysis Services, Statistical data modeling. Azure Data bricks, Azure SQL, Data lake gen2,Blob

ETL

SSIS, Power Query, Tableau Prep, Python Script, Data Flow

Visualization

Crystal Report (Business Objects), Power BI

 

Project details:

 

Project#1:

 

Employer           :    Shodat.INC

Team Size          : -3

Client                 : Shodat

Duration             : Oct 2023 to Till Date

 

Technology à Microsoft power BI, Azure Data Factory, DBT Cloud, Data Bricks.

 

Project Description:

 

Founded in 1951 by the Swedish Tell family, Piab supplies vacuum ejectors, conveyors, lifters and suction c

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!