Anudeep Goyal Email and Phone Number

• Fetched and integrated data from ERP LN and Training Portal into Microsoft SQL Server using Infor LN UI for enhanced reporting on different departments Role, BU, Functions etc•Implemented DAX queries to automate conflict identification between employee roles, departments, and functions. Conflicts were flagged with a "Conflict/Non-Conflict" status based on the roles and they functions provided to them, reducing manual intervention and improving reporting efficiency by 40 percent

• Analyzed inventory data across 32 parameters and created different dashboards using - line charts, pie charts,and bar graphs etc in Power BI to track trends, cost fluctuations, and warehouse distributions,Identified that20 percent of total inventory value was attributed to just 10 percent of items, optimizing stock managementand improving cost efficiency.• Fetched data from ERP and Training Portal using Infor LN UI into Microsoft SQL Server. Integrated SQLdatabases with… Show more • Analyzed inventory data across 32 parameters and created different dashboards using - line charts, pie charts,and bar graphs etc in Power BI to track trends, cost fluctuations, and warehouse distributions,Identified that20 percent of total inventory value was attributed to just 10 percent of items, optimizing stock managementand improving cost efficiency.• Fetched data from ERP and Training Portal using Infor LN UI into Microsoft SQL Server. Integrated SQLdatabases with Power BI, consolidating employee data from multiple sources, enhancing data accessibility by 30 percent, and reducing reporting time by 25 percent.• Consolidated 8 SQL tables into a unified dataset using DAX Query by identifying their primary keys andestablishing relation between the tables, thus increasing reporting efficiency by 40 percent and enabling faster data analysis Show less