Talent's Information
-
Location
Bengaluru, India
-
Rate
$9.0 per Hour
-
Experience
4.3 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About Anil
A curiosity‐driven Power BI Developer, eager to leverage Python and data analytics to extract meaningful insights, make active decisions and solve challenging business problems. I ensure to contribute with my knowledge, logical thinking and analytical skills towards the consistent growth and
development of the organization and enhance my experience through continuous learning and teamwork. Interested in devising a better problem‐solving method for challenging tasks and learning new technologies and tools if the need arises.
Work Experience
Power Bi Developer
- January 2019 - March 2023 - 4 Year
- India
Projects
Humana Health Care
- March 2019 - October 2019 - 8 Months
Technologies
Role & Responsibility
Involved with business users for gathering the requirements and calls with clients.
Experience with creating reports and dashboards using Power BI.
Created Power BI reports‐ Matrix, Bar Charts, Line Charts, Pie Charts, Tree Maps, Sankey Charts, Donut Chart, and Bubble and stacked Bar Chart etc .
Created Dashboards apply the filters Drill through and Drill Down functions and created tooltip on sheet level as per requirement.
As per the data we using Aggregate Functions and Filter Functions and Time and Date Functions and Logical Functions using Data Analysis Expressions.
Creating Calculated Columns and Measures with DAX.
Creating Report level apply Individual, Report, Page level filters in power bi.
Implement Row Level Security (RLS) as per requirement.
Testing in My SQL data base to write query to check the data is matching in power Bi desktop.
Experience in Publish of Power BI reports to Power BI server.
Toyota Motor Sales
- November 2019 - July 2020 - 9 Months
Technologies
Role & Responsibility
-
involved in creating power BI reports in Import and Direct Query Mode.
Power BI development and administration.
Accessed various data sources to pull data for reporting and analysis.
Great experience with Power Queries to cleaning the data.
Good knowledge on creating calculations, advanced calculations, Parameters, slicers and Interactions.
Create the Calculated columns and measures with the use of DAX Expressions.
Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot etc. with Power BI.
Accessed and used various Custom Visuals available in Power BI.
Able to implement Row Level Security on data and have an understanding of application security layer models in Power BI.
Sharing of Power BI reports and managing workspaces in Power BI service.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
Transactional PO Processing Dashboard CZ
- September 2020 - April 2021 - 8 Months
Technologies
Role & Responsibility
-
POV Value and PO Count by Vendor Name by Using Butterfly Graph.
PO Count by ESN Mapping Donnut Char.
PO Value by POV Threashold Created Bins in Power Query Based in Requiremnt and Added Tooltip for PO Count by Vendor Name and Vendor Type.
Created Measure for Total PO,Catalog PO,Free Text PO,Catalog Ratio,3rd Party Ratio,ERP Falg Ratio.
Create the Calculated columns and measures with the use of DAX Expressions.
Slicer Window POP up and Hide and Also Reset Filters Created By Using Bookmarks and Selection pane.
Accessed and used various Custom Visuals available in Power BI.
Sharing of Power BI reports and managing workspaces in Power BI service.
NATURAL LANGUAGE PROCESSING [ NLP ]
- September 2021 - March 2022 - 7 Months
Technologies
Role & Responsibility
20818 Puma shoe product reviews and 3 columns[Review text,Review rating,sentiment class] tagged data given the company.
Analyzed the given data set is structured or not and identified duplicate reviews and dropped .
Done feature engineering[Created the separate stop words,Negative,Positive texts files].
Performed EDA for the product review’s. and sentiment class
Building Word Clouds for positive, negative and neutral.
Building Topic modelling for positive, negative and neutral.
Creates the google pre trained word2vec model to check the similar words.
Carried out with different Classification algorithm and selected the best Classification model based on the Good Precision and recall.
Deployment using FLASK and HEROKU. MO CS and BVI Metrics Role ‐ Power BI Develop Tools‐Power BI
MO CS And BVI Metrics
- January 2022 - December 2022 - 12 Months
Role & Responsibility
-
Status Count Based on Actioned Date and Supplier Response Date As Per Client Fiscal Year Converted Both Date Attributes.
Added Tooltip for Each Status Count Seperately (Open,Closed).
Worked on Calculation Logic for Easy Understanding and Named As Total 3 rd party Suppliers,MO Base Count and Response >6 and Re‐sponse<6,NO Response Measure.
Created Calender Table and Applied Realtionship With the Raw Data.
Worked on Relationship part for BVI Metrics Measures and Applied in Card Visuals.
Worked on the Calculation Part Based on The User Selection in The Slicer to Display the Required months in Card Visulas.
Created Measures Based on User Requiremnt for external Created Table Dates New Table.
Created Bookmark Action For Reseting The Slicers.
Soft Skills
Industry Expertise
Education
in B.Tech
EEE- June 2013 - June 2017
