Vijaya Dhanshetty
Fort Collins,CO
Summary
- An Aspiring Power BI Developer with a motive of Analyzing data and presenting it through reports that could help decision-making for the business.
- Strong knowledge of Power BI to import data from various sources and create Dashboards, Reports, Power Views, Workspaces, Row Level Security (RLS) Implementation, and Sharing dashboards.
- Worked on all types of transformations that are available in the Power BI query editor.
- Developed custom calculated Measures using DAX in power BI .
- Configured Enterprise Personal Gateway in Power Bi Services, Scheduled Automatic refresh and scheduling refresh in power bi service
- Hands-on experience in MySQL and MS SQL Server Database.
- Good Knowledge of Power BI Data Modeling and Data Warehousing concepts like Star Schema, Snow Flake Schema, Dimensions, and Fact Tables.
- Knowledge of SSIS Packages to Extract, Transform,m, and Load (ETL) data into the Data warehouse from SQL Server.
Overview
5
5
years of professional experience
Work History
Operations Processor III
AppleOne Employment Services
09.2019 - 10.2020
- Supported the Home Equity Line Management Operations team with various customer account maintenance requests and servicing tasks.
- Hands-on experience in processing and servicing Home Equity Loans.
- Ensured all applicable steps are completed in a timely and accurate manner to process payoff and close requests from CSR to close an account via email.
- Handled and Tackled Meticulous customer requests using the Salesforce tool.
Product Design Engineer
Cummins India Limited
08.2015 - 11.2017
- Worked on the development of failure analysis reports and presentations for management and external customer.
- Assisted in the cost reduction projects for rail engines and Marine engines.
- Performed rapid root cause analysis for issues that are seen in the field and during product development and test phases.
- Studied Different Turbochargers and Actuators used in Diesel engines.
Created actuator model utilized in Variable Geometry Turbocharger in Simulink/MATLAB which incorporates Electromagnetic, Mechanical, and thermal equations of actuators.
Education
Masters of Technology - Mechatronics Engineering
Vellore Institute of Technology
Chennai, India04.2016
Bachelor of Engineering - Mechanical Engineering
B.M.I.T
Solapur, India05.2013
Skills
- Tools: Power BI Desktop, Power BI Service, Sharepoint
- Languages Known: SQL, DAX
- Database: MS SQL Server and MySQL
- Productivity Tool: MS Office Suite
Power Bi Projects
1. Adventure works
Created a report using AdventureWorks data files. First restored the Adventure work database in SQL Server and then created the report in Power BI with a ‘Summary’ page showing the ‘Top Selling Products’ and ‘Top buying Customers’ with their respective ‘Regions’. Added a ‘Customer Details’ page showing the customer’s information in detail and at last the ‘Product Details’ page reflecting the details of the products ordered. We could easily navigate between the pages using Drillthrough options.
2. Meal Delivery Company
Created a report which includes Volume and dollar trends and their growth, Top meals, Cuisines, and centers, and How the Operation of area, marketing, and discount affected sales.
3. Superstore data, Mavens Pizza Challenge, Adventure works for Motorcycles and bikes, Vehicle accident analysis
Imported data from different sources, worked on Data modeling, created DAX for required Output.
Created reports for understanding how Organizations work. Total sales, Factors affecting the sales, Top customers, Discounts using different charts, Bookmarks, Drillthrogh, Tooltips, and Custom Visuals.
Timeline
Operations Processor III
AppleOne Employment Services
09.2019 - 10.2020
Product Design Engineer
Cummins India Limited
08.2015 - 11.2017
Masters of Technology - Mechatronics Engineering
Vellore Institute of Technology
Bachelor of Engineering - Mechanical Engineering
B.M.I.T
Similar Profiles
Kimberly HarvileyKimberly Harviley
Revenue Support Rep at AppleOne Employment ServicesRevenue Support Rep at AppleOne Employment Services
Greta LoyGreta Loy
Program Assistant for SDG&E at AppleOne Employment ServicesProgram Assistant for SDG&E at AppleOne Employment Services
Nicole LairdNicole Laird
Sr. Office Assistant (Temporary/County of Sonoma) at AppleOne Employment ServicesSr. Office Assistant (Temporary/County of Sonoma) at AppleOne Employment Services
Ashley FountainAshley Fountain
Customer Service Representative at AppleOne Employment ServicesCustomer Service Representative at AppleOne Employment Services
Michael BowlesMichael Bowles
Buyer/Sales Associate at The CupboardBuyer/Sales Associate at The Cupboard