Swapnil Kumbhar

Data Analyst @Tata Consultancy Services

Pune, IN

Having 3+ Years of Experience as a Data analyst with Business Intelligence tools like Power BI Desktop,Power BI Service and ORACLE/SQL, Snowflake & Basic Python.• Working experience of cloud computing architecture.• Worked on multi-cluster, shared data architecture.• Experience on gathering and translating end user requirements into effective & efficient dashboards.• Good knowledge on extracting the data from PowerBI Servers.• Expertise in importing data from multiple data sources into Power BI, created relationships between various datasets.• Experience in Data preparation in Enter Data and shaping data in Edit Query like add column, split column, pivot column, UN pivot column, changing data type, Merge queries and Append queries.• Experience on understanding DAX Functions in Power BI and created new columns and new measuresusing DAX.• Having valuable experience in creating Filters like Visual level, page level, report level.• Experience on creating hierarchies and implemented hierarchy filters in reports.• Experience in publishing reports to Power BI services.• Experience on sharing reports, gateways, creating content packs, giving credentials for scheduling,solution for troubleshooting of tiles, reports, dashboards.• Write SQL queries to extract, manipulate, and analyze data from databases. This includes creating complex joins, subqueries, and stored procedure.• Develop and optimize complex SQL queries, stored procedures, and triggers to support software applications and data analysis needs.• Knowledge on different operator such as number,string,tuple,sets,dictionaries and list.Working on different operations using operators such as slicing,indexing,updation,replace,appendfunctions etc.• Familiar with different libraries like pandas,numpy,matplotlib,seaborn etc.• Experience in data manipulation using pandas and different operations like joins,append,extend and merge.• Hands on experience on advance excel.