Kshiteej Mehendre

PROFILE SUMMARY

• Having 3.6 Years of Professional experience in IT industry, working on POWER BI, DAX, and SQL SERVER & SQL SERVER INTEGRATION SERVICES (SSIS).
• Used visualizations like Column Chart, Stacked chart, Pie chart, Slicers, Donut Charts, Row Cards, Tree Map, Line Chart, Tabular and Matrix Reports and KPI’s.
• Expert in Extracting Various Data functions in Edit Query and also Creating Data Models for Reports in Power BI Desktop.
• Imported Data from Multiple Data sources into Power BI Desktop, Created Relationships between Data, Created Calculated Columns & Calculated Measures using DAX Query.
• Having Good Experience in Power BI Desktop and Power BI Service & DAX.
• Involved in administering the Power BI service options and set up the Role based security to the data in the reports.
• Used DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions to create business Calculations based on requirements.
• Used On-Premises Data gateway to schedule the daily Data Refresh to Source files. Unnecessary columns hidden from reporting view in Power BI application. Experience in using Multiple Join statements to retrieve data from multiple tables.
• Designing the Accurate Data Models & adding the Calculated DAX Measure on Top of the Datasets wherever required. Developed the Power BI Dashboards.
• Knowledge on developing SSIS packages to performed ETL Operations like Derived column, Lookup, Conditional split, Merge join, Sort and Execute SQL task and Load data into database.
• Developed SQL Queries using Stored Procedures, Common Table Expressions (CTE), and Temporary table to support Power BI. Good in writing SQL Queries using Joins, Sub Queries to Retrieve Data from Database.
• Knowledge on warehouse design and testing, Containers like For Each Loop and Sequence Container to read the multiple source files, Error handling, error logging, check points, Break points and Debug SSIS packages.
• Experience in using Operators, Ranking Functions & Date Functions, Table variables, Views, Indexes.
• Good knowledge in Creating warehouse, database, schema in snowflake.
• Experience in performing different quires in snowflake.
• Hands on in connecting snowflake to power bi.
• Familiar with Snowflake architecture and warehouse implementation and management
• Working experience of cloud computing architecture Knowledge in creating file formater for importing the data in snowflake.
• Experience in Snowflake with data architecture, design, analytics & deployment.
• Worked on multi-cluster, shared data architecture. 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,append functions etc.
• Familiar with different libraries like pandas,numpy,matplotlib,seaborn etc. Experience in creating widgets using different dataframes.
• Experience in data manipulation using pandas and different operations like joins,append,extend and merge.