Kshitij Pathak Email and Phone Number

• Working as Assistant Manager(Data Analytics & Automation) with Genpact having 5+ years of Experience Providing end to end Services & Support to help the Business stakeholders to take Informed Business Decisions with the help of Actionable Insights in Report and Dashboards based on the business requirements for the Global/International Corporates/MNCs organization's using Tableau, Power BI, Azure,Power Apps, Power Automate, Advanced Excel, SQL, Power BI Report Builder, DAX, Power Query, Data Modeling, Data Visualization, Power Pivot, SSRS, SSIS, SSAS, SSMS,Power BI Services. Looking for the Better Opportunity with the Employee Growth Oriented organization.• Expertise in writing complex DAX functions in Power BI and Power Pivot. • Automated Power Query refresh using power shell script and windows task scheduler. • Used various sources to pull data into Power BI such as SQL Server, EXCEL, PYTHON, POSTGRE, SQL, PBRS, SSRS etc. • Installed and configured Enterprise gateway and Personal gateway in Power bi service. • Created Workspace and content packs for business users to view the developed reports.• Scheduled Automatic refresh and scheduling refresh in power bi service.• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques. • Weekly presentation to the business users about the reports and their changes as required. • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. • Worked on all types of transformations that are available in Power bi query editor. • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution. • Created Reports using Charts, Gauges, Tables, matrix. • Created Parameterized Report, Dashboard Report, linked report and Sub Report by Year, Quarter, Month, and Week. • Created Drill Down Reports, Drill Through Report by Region. • Support implemented BI solutions by addressing user questions and inquiries, monitoring performance, and communicating functional and technical issues.