AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF28226
profile image
Kumar s AXF28226 Active
Senior Associate Data  Analyst in hyderabad
With over 7 years of experience in data analytics and business intelligence primarily using Power BI and SQL Server I bring strong hands-on expertise in dashboard development, data modeling, DAX, and stakeholder management. I have worked extensively across domains including banking, utilities, and energy, and have delivered scalable Power BI solutions integrating data from various sources like SQL, Azure, and Denodo. I also have solid experience with SSAS, SSRS, and report optimization techniques. Additionally, I have handled client-facing responsibilities and project ownership in my current and past roles. I am available to join immediately and would welcome the opportunity to discuss how my background aligns with your team needs.
Industries : green energy, Oil and Gas, Ecommerce, Medical Equipment, Manufacturing
Share
Hire Kumar s
Download PDF
Availability
Full-time
Total experience
7 years
Technical skills
POWER BI
6 Years & 3 Months
SQL
5 Years
SSIS
4 Years
SSAS
2 Years & 1 Months
SSRS
1 Years
power BI
Projects
Next Era Energy View project
April-2025 to May-2025
Description
leading energy infrastructure company in North America, boasting the largest and most diverse portfolio of power generation solutions. It is also the world's largest electric utility holding company
Roles and Responsibilities
Maintaining and managing SSAS multidimensional cubes to support business intelligence and reporting needs. Regularly updated SQL Server Agent job scripts to accommodate changes in data availability
Technologies: SSAS
Industry: green energy
Williams Oil and Gas View project
November-2024 to March-2025
Description
Its core business involves processing, transporting, and delivering natural gas.
Roles and Responsibilities
Create paginated reports using Power BI Report Builder to meet business requirements Accessed Oracle Database to build paginated reports for detailed and structured reporting and Optimize query performance to ensure fast report rendering Performed data modeling and designed star schema and snowflake schema for efficient data storage and analysis in SSAS cubes
Technologies: SSRS
Industry: Oil and Gas
May-2023 to July-2024
Description
company that rents a wide variety of equipment, including general construction equipment, industrial tools, pumps, power generation, and climate control solutions. They have over 950 locations and offer more than 14,000 types of equipment, aiming to support customers in building and maintaining infrastructure.
Roles and Responsibilities
Accessed Denodo ODBC connector to pull data for reporting and analysis. Involved in creating power Bi reports in Import and Direct Query Mode. Data cleaning operation using Power Query. Conducted regular performance testing and optimization of SSAS cubes and tabular models to ensure high availability and improved query performance. Writing Data Analysis Expressions (DAX) like Aggregate Functions and Filter Functions and Time & Date Functions and Logical Functions. Created Calculated Columns and Measures with DAX functions. Created visuals like KPI, Line, Bar, Scatter Plot, table, matric, Waterfall Chart and Heatmap, Tree map, Card, Multi card, Area chart, Pie chart, Donut chart etc. Collaborated with business users to gather requirements and build custom reports/dashboards. Worked with Bookmarks, Selection Pane, Slicers and Edit interactions. Implemented Row Level Security (RLS) as per requirement. Scheduled Automatic refresh and scheduling refresh in power bi service
Technologies: Power BI
Industry: Ecommerce
September-2019 to April-2023
Description
a global healthcare company focused on developing and providing a wide range of health products and services.
Roles and Responsibilities
Create the agents based on business requirement and cache seeding the reports for better Prepared the queries for Reporting tables for some of the reporting requirements performance. Connected and imported data from multiple sources like SQL Server, Excel to Power BI. Involved in writing SQL Queries to pull the data from MS SQL Server. Involved in rendering the reports in the form .PDF, .CSV and Excel formats.
Technologies: power BI , SQL
Industry: Medical Equipment
Philips View project
February-2018 to August-2019
Description
health technology and manufacturing. The health technology sector aims to improve people's health and well-being through innovation.
Roles and Responsibilities
Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard. Building, publishing customized interactive reports and dashboards, report scheduling using Power BI Service. Documenting the dashboard needs, the critical success factors of the business, related KPIs and measures in the dataset, and the designs. Involved in creating interactive dashboard and applied URL to tiles in Dashboard. Created different types of visuals like bar, Pie, and Donut chart, tree map, KPI visual, Funnel etc. Developed various types of complex reports using buttons, bookmarks and Drill through, matrix.
Technologies: power BI , SQL
Industry: Manufacturing
Work history
Senior Associate Data Analyst • May-2023 to March-2025
Description: I have worked extensively across domains including banking, utilities, and energy, and have delivered scalable Power BI solutions integrating data from various sources like SQL, Azure, and Denodo. I also have solid experience with SSAS, SSRS, and report optimization techniques. Additionally, I have handled client-facing responsibilities and project ownership in my current and past roles.
Power BI Developer • February-2018 to April-2023
wipro
Description: using Power BI and SQL Server I bring strong hands-on expertise in dashboard development, data modeling, DAX, and stakeholder management.
Education
Bachelors degree in Electrical and Electronics Engineering
JNTU K
2008 to 2013
Language
English - Advanced