Krunali Marathe

Dedicated and skilled MSSQL Developer with over 13 years of experience in designing, developing, and maintaining database solutions. Proficient in T-SQL and PL/SQL in MSSQL Server programming, performance tuning, and database optimization. Seeking to leverage expertise in MSSQL development to contribute to a dynamic team and drive organizational success.

• 13+ years of experience in development and support of Microsoft SQL Server, Webservice, Windows and Web based application using ASP.NET with C#
• Hands on experience in database technology like Microsoft SQL Server 2008/2012/2016
• Proficient in Database design and creating SQL Stored Procedures, Functions, Views, and Triggers
• Delivered database deployment on live environment
• Hands on experience in ADO.NET as the database data consumer
• Used Object oriented programming methodologies
• Performed different types of testing like Functional testing, Regression testing and Retesting.
• Very good experience in Analyzing requirements (SRS), Developed the Web application and Web services to meet customer requirement.
• Software Integration with other software and hardware
• Collaborated with business support professionals to provide full system maintenance
• Improved the experience of software users by soliciting feedback and making software improvements

Labcorp Inc (Fortrea), Mumbai

Xcellerate Risk Review (XRR)

LabCorp or Laboratory Corporation of America Holdings, is primarily known as a leading global life sciences company that provides a wide range of clinical laboratory services and research such as central laboratory testing for clinical trials, biomarker testing, and companion diagnostics and for that purpose they have many projects maintaining the research related data. XRR is one of the project (Clinical Data Analytics) which is used for calculating the risk using available data and shows the risk related details and graphs. 

Roles and Responsibilities

• Study setup and running the monthly assessment and troubleshoot the bugs and analyze the data in database
• Maintaining IVRS data process of assessments
• Create or modify the query for the metrics and risk Indicators using MSSQL

Essen Energy Conversion Devices PVT. LTD., Mumbai

Asset Tracking and Management (Astrax)

Implemented at  Qualcomm (Hyderabad), HUL (Kolkata), HUL (Dapada), and Emami (Kolkata)

Asset Tracking consists of identifying and tracking the movement of physical assets and equipment within a location as well as their incoming and outgoing movement to and from the workplace. Inventory and Audit control is a process that manages the quantity of stock and tracks its movement through warehouse, manufacturing, and supply chain. It applies to every item from raw materials to work-in-process to finished goods and covers every stage from purchase to delivery

Roles and Responsibilities

• Involved in coding, testing, and completing the client's required enhancements
• Designed and developed the Web application modules
• Created SOAP webservice for exchanging data between android application and RFID application
• Created SQL stored procedures, views, functions, and triggers
• Performed functional testing, retesting, and regression testing
• Involved in Bug fixing

VETRA, Vehicle Tracking System

Implemented at Bharat Petroleum Corporation Limited (BPCL), (Mumbai), and Deepak fertilizers, (Mumbai)

RFID vehicle tracking system automatically track the vehicle. For every vehicle RFID tag will be given. RFID readers are present at the IN and OUT gates. Automatically RFID reader identifies the system registered RFID tags and sends the data to database server. Server authenticate vehicle and trigger the boom barrier, at a same time security guard was able to see the vehicle details on display screen. So it can increase the security and prevent loss of vehicles.

Roles and Responsibilities

• Involved in all facets of the project, including - requirements gathering, database designing, coding, testing, completing the client enhancements and implementing the application in the production environment
• Worked closely with the users to understand the various external systems to be integrated, and created webservice for exchanging the data between client's existing application and RFID application
• Creating application database logic, writing complex queries, stored procedures, functions and triggers
• I was the team leader for this project
• Also, created SOAP webservice for exchanging data between android application and RFID application

Shop floor Manufacturing and Extraction of Resource Activity (SMERA)

Production and Operation Management (PMS), Implemented at Hindustan Unilever Ltd. (HUL), (Khamgaon)

Production management system - is a solution developed by Essen RFID for managing and tracking various production and related activities in any manufacturing company. Every manufacturing house or trading company finds it difficult to manage the entire process flow starting from lead management, quotations, scheduling jobs, material management, machinery management, packing and delivery of produced goods, tracking at each stage. Production management system (PMS) is developed with the aim to first digitize the process, reduce the time and effort in managing these activities and finally to obtain the most useful information from the daily operations that help apply intelligence to business.

Roles and Responsibilities

• Client server data synchronization using windows service (console application)
• Created SOAP webservice for exchanging data between android application and RFID application
• Designed and implemented the underlying database structure and created the SQL stored procedures, views, functions, and triggers

Document Tracking and Management (Doctrax)

Implemented at TIFR (Mumbai), Mylan (Aurangabad)

Document tracking consists of issuing and tracking the movement of folder and documents within a location also detection upon entry and exit from the room. Inventory and audit is a process that manages the document and allows the user to identify the missing document or misplaced document at th location.

Roles and Responsibilities

• Designed and developed the Web application modules
• Created SQL stored procedures, views, functions, and triggers
• Performed functional testing, retesting, and regression testing
• Created SOAP webservice for exchanging data between android application and RFID application

• Date of Birth: 07/23/1987
• Marital Status: Married