Komal Mehta

• Reviewed code, debugged problems, and corrected issues.
• Analyzed existing software implementations to identify areas requiring improvement.
• Developed functional databases, applications and servers to support websites on back-end.
• Worked with back-end developers to design APIs.
• Developed unit test cases for testing and automation.
• Used NodeJS, ORM and SQL/No-SQL to develop and manage databases.
• Participated in requirements gathering to solidify prerequisites and determine best technical solution to meet business needs.
• Built databases and table structures for web applications.
• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
• Worked on Firebase Analytics to track users accessing the websites
• Write python script to store data into database by extracting data from excel
• Done App development and deployment on Android and ios

• **Summary:**
  
  Utilized Microsoft Azure, Power BI, Excel, and Power Query Editor to create a comprehensive Data Mashup solution, connecting diverse data sources. Enabled financial clients and key stakeholders, including governments, to access valuable data analytics and insights, enhancing their project involvement.
  
  **Key Achievements:**
  
  - Facilitated access to essential data analytics and insights for financial clients and government stakeholders, bolstering their project engagement.
  
  **Key Responsibilities:**
  
  - Acquired domain knowledge and comprehended business requirements.
  - Loaded and merged queries in Power BI to develop interactive dashboards.
  - Crafted DAX queries to generate measures and columns tailored to specific needs.
  - Conducted data cleaning and transformation using Power Query Editor.
  - Engaged in discussions with stakeholders, incorporating feedback for improvements.
  - Designed interactive elements such as slicers, pop-up filters, and menus in the dashboard.
  - Created Excel dashboards, starting with data cleaning and transformation in Power Query Editor, and utilized Power Pivot for Excel to build visualizations.
  - Published the dashboard as an App for broader accessibility.

Project Name: D2C (Direct to Customer)

• Platform and Technologies: MVC4, HTML, SQL Server 2012komaltoshamia@
• Developed first online platform for the company to buy policies by the customers

Responsibilities:

• Working as a Dot Net Application Developer developing the code in MVC, Dot Net, VB.Net and using SQL as a backend
• Preparing the Technical Specification Documents from the Functional Specification
• Document given by the Business Analyst
• Solving the UAT Jira tickets issue through SQL queries
• Feeding the JSON data into the portal to resolve the issues
• Helping Project Manager to update SLAs and SLOs with the evolution of projects
• Forming a code to validate if the entry into the system is correct as per the requirement
• Pushing the Json data through postman if some error occurred in the system
• Provide support to the testing team after the deployment for the smooth functioning of product.

Project Name: Unclaimed Application

• Platform and Technologies: ASP. Net, SQL Server 2012

Achievements:

• Made easier to claim the mature policies for the senior citizens easier
• Automated the claiming process of Unclaimed Amount

Responsibilities

• Maintaining the code with best practices and interacting with web service team for a smooth functioning of the system
• Effectively managing the process flow of scheduler and check for issues in JIRA and resolve them with SQL backend
• Manually pushing the data if web service fails to respond to the call made by unclaimed system
• Documented technical workflows and knowledge to educate newly hired employees.
• Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
• Providing support with Data Migrations to the client for smooth functioning of Data
• Warehouse Systems.