VENKATA (RID : 13evlb6481yz)

POWER BI DEVELOPER

Location : INDORE, India

Experience : 6.1 Year

Rate: $21 / Hourly

Availability : Immediate

Work From : Offsite

Category : Information Technology & Services

Shortlisted : 0

Total Views : 176

Key Skills

Power BI SQL PYTHON LINUX MSBI

Discription

Venkata Subbaiah

SeniorDeveloper

PROFESSIONAL SUMMARY

Having6.10yearsofProfessionalExperienceinITinvolvedinvariousphasesofdevelopmentand implementing SSIS packages to get data from different sources consolidated and merged into one single sourceto generateReports andVisualizationsusing BusinessIntelligenceTools.
Designed and implemented relational databases, data marts and developed reports to allow users to easily access data.
Developed reports with consistent drill-down functionality including Drill-down report and Summary report.
Adopt in developing, publishing and scheduling Power BI reports as per the business requirements.
Able to properly understand the business requirements and develop data models accordingly bytakingcare oftheresources.
Good in developing and deploying the packages in SSIS.
Created Dynamic time-based calculations like MTD, QTD, YTD, Prior, % YoY etc.
Created Custom columns, Conditional columns, various measures, Partitions, Aggregations and KPI’s.
Created Bookmarks in Power BI to move from one page to other page for easy navigation and creating Interactive visuals, publishing, refreshing & scheduling dashboards.
DevelopedPowerBIReportsusingSlicerfilters, DAXcalculations, Bookmarks, DrillThrough andpublishedinPowerBIService.
Having good experience with Power BI automation in exporting and distributing Power BI reports.
Goodunderstandingofdimensionalmodelingtechniqueslikestarschemaandsnow-flakeschema.
Experienceincreatingarelationshipbetweentablesbyusingrelationshipsandcalculationsoncolumns andmeasuresusingDAXfunctions.
Expert in developing Power BI reports and dashboards from various Data Sources like Databases, Excel files. And data design, data modeling (star-schema modeling, snowflake schema modeling, and fact & dimension tables), development, implementation, In Power Bi.Created highly efficient and complex reports, dashboards using Power BI Desktop by using of create attractive & interactive visualizations, using custom visuals and prepare dashboards.
KnowledgeonSQLserver-SQLcommands, SetOperations, Joins, Views, CTE, StoredProcedures.
Participates in the design and maintenance of the Database Management System (DBMS) including data modeling, extraction, cleaning, aggregation, transformation and validating the data to ensure accuracy and consistency.
Good in database concepts like joins, sub queries, views, and procedures.
Excellent skillsinunderstandinginbusinessneedsandconvertingthemintotechnicalsolutions by transforming the data into visuals and reports.
Having basic knowledge on python and Linux.

TECHNICALSKILLS

Reportingtools : Power BI desktop, MSBI (SSIS, SSRS),Python

Database : MicrosoftSQLserver,Mongodb

Operating Systems : Windows Family and Linux

PROFESSIONALEXPERIENCE

Projects

Project Name : Retail Analytics

Environment: MSBI, Power BI, SQL Server

Role : Developer

Project Description:

Torrid is one of the country's largest retail store chains having thousands of stores in US. This project helps to micromanage efficient, high-performance decision support systems, which integrate and aggregate the data from sales data from all of its stores and measure the effectiveness of the sales by reporting key performance indicators like profits generated. This solution provides the retailer's thousands of store managers with up-to-the-minute analysis. This project helps to analyze the business transactions and information. Apart from this project I had worked on three more projects in same module (Her Universe, Hottopic and Blackheart).

Name	Amount	Days	Action
Premium	15000	30	Pay Now
Enterprise	40000	30	Pay Now

VENKATA (RID : 13evlb6481yz)

TECHNICALSKILLS

PROFESSIONALEXPERIENCE

stuff goes in here!