Neha Dalvi Email & Phone Number

Montreal, Quebec, Canada

Navi Mumbai, Maharashtra, India

Participated in requirement analysis, developing dashboards and reports to help clients make better business decisions.Performed feasibility study, reusability study, effort estimations, and task allocations for the project.Understand the relationships between source tables, analyze the data and build a robust data model in Qlik.Developed data models and managed data flow between source and applications.Participated in enhancement/support for Delivery Quality Release Dashboard… Show more Participated in requirement analysis, developing dashboards and reports to help clients make better business decisions.Performed feasibility study, reusability study, effort estimations, and task allocations for the project.Understand the relationships between source tables, analyze the data and build a robust data model in Qlik.Developed data models and managed data flow between source and applications.Participated in enhancement/support for Delivery Quality Release Dashboard, UCR Dashboard, TIDB Dashboard.Developed applications like Matomo Dashboard and Acknowledgement Dashboard.Wrote SQL Queries utilized joins and subqueries to simplify complex queries involving multiple tables while optimizing procedures also extracted data in CSV format business and users.Designed Excel reports for the applications that could be sent to the client through email on a daily basis.Used MS Excel for detailed data validation using different functions such as VLOOKUP, COUNTIF and so on.Utilised Set Analysis and Functions to simplify the complex logic.Optimized the scripts for better performance of applications.Modified the Data models according to the business process and fine-tuned the application for better throughput.Unit tested components, implemented and performed peer reviews for ensuring the quality of code.Created 2 dashboards using Power BI Desktop and published to the internal team for review and further data analysis.Enhanced existing reports in Power BI environment using Power Query and DAX.Converted Qlik Dashboard to Power BI Collaborated with cross-functional teams to analyze existing ETL processes and recommend improvements.Prepared technical documents for the applications.Mentored new resources and extended support to the other team members. Show less

Gathering project requirements, analyzing the requirements, business scenario(s) and developing the application.• In order to produce the HR Analysis report by keep in mind that what was the previous attritions rate and what would beupcoming attrition rate based on attrite reasons behind it. Comparison ratio with respect to Headcounts, Promotions, Age group,Gender, Tenure, Domain Type, BU, Divisions, Department, Equivalent Grade, Band and others etc.• Developed application on… Show more Gathering project requirements, analyzing the requirements, business scenario(s) and developing the application.• In order to produce the HR Analysis report by keep in mind that what was the previous attritions rate and what would beupcoming attrition rate based on attrite reasons behind it. Comparison ratio with respect to Headcounts, Promotions, Age group,Gender, Tenure, Domain Type, BU, Divisions, Department, Equivalent Grade, Band and others etc.• Developed application on Supply Chain Inventory containing KPI`s like Analysis of raw material finished material, Stock quantity,stock related kpi etc.• Developed Quality dashboard containing KPI’s Warranty Data management for Tractors such RPH, CPT, Warranty Cost for all MIS• Developed Stock Quantity Initiatives containing KPI’s Stock related information in dashboard also created Nprinting report foruser (HTML and Excel Report)• Supported application built for Motor Insurance.• Building data model and managing the data flow between source and application.• Used extensive set analysis to analyze data over time, used MTD, QTD, YTD, LYTD, LYMTD.• Used Set Analysis and Functions to simplify the complex logic.• Implemented section access in different levels as per the requirement.• Optimization of the script for better performance.• Data modelling changes according to the business process and fine-tuning the application.• Validating the application with source data.• Understanding the relationships between source tables.• Prepared technical documents for the applications.• Scheduling the jobs, tacking the reloads and assigning the CAL’s to users on QlikView QMC. Show less

Mumbai, Maharashtra, India

Master Of Computer Applications - Mca, Information Technology

Bachelor Of Applied Science - Basc, Chemistry