Piyush Parmar

Operations Associate

Noida, Uttar Pradesh, India7 yrs 7 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Expert in Power BI and SQL Server analytics.
  • Proven track record in data visualization and reporting.
  • Strong background in technical recruiting and IT recruitment.
Stackforce AI infers this person is a skilled data analyst with expertise in BI tools and SQL, suitable for SaaS and utilities sectors.

Contact

Skills

Core Skills

Microsoft Power BiTransact-sql (t-sql)Sql ServerMicrosoft Sql Server

Other Skills

IT RecruitmentPower BITechnical Recruiting

Experience

Commdel consulting services private limited.

Analyst (SQL + POWER BI)

May 2022Present · 3 yrs 10 mos · Noida, Uttar Pradesh, India · On-site

  • Responsibilities:
  • Worked on data shaping, transformation, mapping, and modelling in Power BI.
  • Creating advanced chart types, visualizations and complex calculation using Measures and Calculated Columns.
  • Created reports/visualizations/dashboards in Power BI using Power Query, DAX Functions, visuals (Charts, Graphs, KPIs, Maps, Gauges, Power KPI, Matrix, etc.).
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
  • Worked on data analytics using Excel (Pivot table Analysis, HLookup, VLookup, Index & Match Lookups, Functions).
  • Worked on performance optimization on DAX Studio and Performance Analyzer.
  • Developed stored procedures and views to simplify complex joins, Sub-Queries, and merge queries from multiple tables using T-SQL.
  • Created measures, calculated columns, hierarchy, relationships, roles, KPIs, and perspectives in the Tabular Model and deployed to the Analysis Services.
  • Worked on SQL query optimization using indexes and using execution plan.
  • Created constraints, Common Table Expressions, Indexes and Subqueries.
  • Worked on ADF(v2) components: Pipelines, Activities, Datasets, Linked Services, Data Flows, and Integration Runtimes.
Microsoft SQL ServerTransact-SQL (T-SQL)Microsoft Power BI

Global pharma tek

Power BI Developer

Jan 2021May 2022 · 1 yr 4 mos · Hyderabad, Telangana, India · Remote

  • The Project aim was to replace 25 crore conventional meters with smart meters in India. Smart meters are connected through a web-based monitoring system which will help to reduce commercial losses of utilities, enhance revenues and serve as an important tool in power sector reforms. We were providing 24x7 Support to our client for smooth business functioning and execution through adoption of agile methodologies.
  • Responsibilities:
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal Case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Solve technical and data related problems to meet the needs of the business.
  • Advanced reporting skills using SQL Server. Created Conditional, Drill-down, Top N, Summary, custom reports.
  • Developed reports by different time intelligence like the year to date (YTD), Month to date (MTD), same period last year.
  • Power BI development Connect, import, shape, and transform data for business intelligence (BI).
  • Prepare Daily Performance KPI matrix for Team and share this report to Higher Management to Analyse or Evaluate organisations performance.
  • SQL Scripting, using Microsoft SQL Server Management Studio 2016 R2, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses
  • Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
  • Involved in writing T- SQL script for databases and tables.
Microsoft Power BISQL ServerTransact-SQL (T-SQL)

Invia

SQL Server Consultant

Jul 2018Dec 2020 · 2 yrs 5 mos · Noida, Uttar Pradesh, India · On-site

  • Responsibilities:
  • Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalizing the relations, creating Tables, Views, Indexes etc.
  • Used software development life cycle (SDLC) in the entire process of formal, logical steps taken.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures, Cursors and triggers maintaining Referential Integrity.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and implemented triggers and stored procedures and enforced business rules via checks and constraints.
  • Used T-SQL to develop Stored Procedures, User-Defined Functions (UDFs), Indexed View.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio..
  • Using Power Query to manipulate, clean, extract, transform and load data from multiple sources.
  • Creating different visualizations using Slicers, Funnel, Line & Stacked column, Pies, Histograms, KPIs, Scatter, Matrix, Waterfall chart, Filled Map, gauge etc. using Power BI Desktop
Microsoft SQL ServerTransact-SQL (T-SQL)Power BI

Education

Rajiv Gandhi Prodyogiki Vishwavidyalaya

Electrical — Electronic and Communications Engineering Technology/Technician

Jan 2013Jan 2017

Stackforce found 100+ more professionals with Microsoft Power Bi & Transact-sql (t-sql)

Explore similar profiles based on matching skills and experience