Vaishnavi Deshmukh
Pune
Summary
Highly skilled and reliable SQL, PLSQL with 3+ years of experience in company as in a MS Associate System Analyst, involved in Application Programming, Testing and Implementation. Hands on experience in technologies like Oracle SQL, PL/SQL, Oracle 10g, SSMS, SSRS, Visual Studio. Proficient in Oracle SQL, PL/SQL, SSMS, SSRS, Visual Studio, Ability to customizing existing logic to add new functionalities, use procedures to validate and to Process the business data proficient in writing SQL queries, Cursors, Subprograms like Procedures, Functions, Packages and Triggers in PL/SQL blocks and develop reports using SSRS. Communicating with client to identify requirement. Well acquainted in SQL queries.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
Work History
Functional Consultant
Icertis Solution Private Limited, Pune.
Pune
01.2024 - 02.2024
- This organization functions for managing end to end management of organizations contract for customer.
- Bolstered client relationships by maintaining open lines of communication throughout each project''s lifecycle-from proposal development through delivery completion.
- Responsible for create contract and writing SQL queries to achieve product requirements.
- Delivered high-quality results by implementing best practices in functional consulting methodologies and tools.
MS Associate Systems Analyst
Allscripts (Altera Digital Health Inc.(USA)) India Pvt. Ltd , Pune
Pune
10.2022 - 10.2023
- This organization functions for managing end to end business information for customer
- Communicating with clients to identify requirement an in-depth understanding of critical business requirements.
- Analyzing data to deliver logical conclusion, developing innovation solutions.
- Developed reports using SSRS that could be used to list patients information. Utilizing tools such as SSMS, Visual Studio, Servicenow to work on SQL.
- Responsible for working on the sql development part, writing complex sql queries, store procedures, updating tickets on servicenow, performance optimization and building report using SSRS on visual studio tool.
- To design a database where whole database from supplier to customer of the project to be stored safely in the database.
- Demonstrate the ability to communicate technical concepts to others across all levels of the business. Handling Daily support task and troubleshooting for application.
Software Engineer
Quadrect Infotech LLP, Pune.
Pune
03.2021 - 10.2022
- PROJECT NAME : Customer and supplier management of products.
- PROJECT DESCRIPTION : This project functions for managing end to end business information for customer, maintaining orders, inventory management, stock management, bill payment and logistics.
- ROLES AND RESPONSIBILITIES
- Managing views, Subprogram like Procedure, function, trigger, cursor and exception.
- Exceptions using Oracle tools like SQL developer and PL/SQL developer.
- Implement some performance tuning methodologies like indexing, bulk collect, etc.
- Create and maintain indexes, constraint, table PL/SQL stored procedure and packages and procedures queries to answer business questions services.
- Design, code, test, debug and document complex database solutions to ensure that data processing production system meet user needs.
- Help team members in knowledge sharing session and other duties as assigned.
Technical Support Trainee
Quadrect Infotech LLP, Pune.
Pune
09.2020 - 03.2021
- Started working as Intern Trainee and worked on Oracle SQL, PL/SQL technologies
- Performing DML & DDL operations. Use of constraint & joining.
- Creation of Simple, Complex and Materialize View. Creation of Procedure and Function.
- Handling Complex queries in case of reporting data.
- Sub-query concept of RDBMS SQL & PL/SQL.
- Handling PL/SQL Procedure in program units & PL/SQL functions.
- Actively listened to customers' requests, confirming full understanding before addressing concerns.
Education
Bachelor of Engineering Technology -
Yashwantrao Chavan College Of Engineering
Nagpur 08.2017 - 07.2021
Skills
Database : Oracle 10g, SQL Server
Tools : SQL Developer, PL/SQL Developer
Operating System: Windows 7,8,9,10
Programming Languages : SQL & PL/SQL
SSRS (SQL Server Reporting Services)
SSMS (SQL Server Management Studio)
SSIS (SQL Server Integration services)
Visual Studio
MLM (Medical Logic Module)
Azure Cloud
Timeline
Functional Consultant
Icertis Solution Private Limited, Pune.
01.2024 - 02.2024
MS Associate Systems Analyst
Allscripts (Altera Digital Health Inc.(USA)) India Pvt. Ltd , Pune
10.2022 - 10.2023
Software Engineer
Quadrect Infotech LLP, Pune.
03.2021 - 10.2022
Technical Support Trainee
Quadrect Infotech LLP, Pune.
09.2020 - 03.2021
Bachelor of Engineering Technology -
Yashwantrao Chavan College Of Engineering
08.2017 - 07.2021
Similar Profiles
Vaishnavi DeshmukhVaishnavi Deshmukh
Functional Consultant - Customer Support at Icertis Solution Private LimitedFunctional Consultant - Customer Support at Icertis Solution Private Limited
Rohita KoulRohita Koul
Lead Software Engineer - Associate Architect at Icertis Solutions Private LimitedLead Software Engineer - Associate Architect at Icertis Solutions Private Limited
Tejaswini KavarTejaswini Kavar
Python Backend Developer at Blueroad technologies private limited ,PunePython Backend Developer at Blueroad technologies private limited ,Pune