Jan 2021 – May 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.

Jul 2018 – Dec 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