VAISHALI KUMAR
Aurangabad
Summary
Oracle PL/SQL Developer with over 6 years of experience in database management and data solutions. Expertise lies in crafting and optimizing complex PL/SQL queries, implementing robust ETL processes, and ensuring data integrity across Oracle databases. Proficient in leveraging Azure Cloud technologies to design scalable data solutions and streamline data workflows. Demonstrated ability to enhance database performance through effective tuning and troubleshooting. Committed to delivering high-quality technical documentation and collaborating with stakeholders to achieve project success. Expert in data modeling and performance tuning, consistently delivering projects that exceed business requirements.
Overview
7
7
years of professional experience
Work History
Senior Software Engineer- PL/SQL
Merit Data and Technology
Chennai
10.2023 - Current
- Developed database schemas, scripts, and models in collaboration with application developers to meet project requirements.
- Creating and optimizing PL/SQL queries, procedures, functions, packages, and other database objects for Oracle databases.
- Performing database schema modification, structuring, and maintenance using PL/SQL.
- Ensuring data integrity and security through PL/SQL coding practices.
- Developing complex PL/SQL code for business logic and data processing as per business requirements.
- Participated in data modeling sessions, contributing to the development of logical and physical database designs.
- Tuning PL/SQL code for improved database performance.
- Developing clear troubleshooting instructions.
- Designing and implementing ETL processes for Oracle databases, data warehouses, or data marts.
- Developing ETL workflows with error handling, and monitoring the process flow.
- Optimizing ETL performance and scalability with PL/SQL tuning.
- Creating technical documentation for PL/SQL code and database design and technical documentation for ETL processes and mappings.
- SCCM Run Book, System Center Configuration Manager.
- Managing SCCM infrastructure, deployment, and configuration.
- Monitoring and managing SCCM collections, inventory, and updates.
- Keeping run books updated with system changes.
- Collaborating with the client and other stakeholders for a successful SCCM implementation.
- Created test cases for unit testing of new or existing PL/SQL code.
PL/SQL Developer
Tata Consultancy Service
Pune
08.2021 - 10.2023
- Closely working with the Business Analyst to understand the requirements and specifications of the project in a detailed manner, translating the same into system requirements, and developing design strategies accordingly.
- Involved in the full development cycle of planning, analysis, design, development, testing, implementation, and support, and delivering projects within the established timeline according to business needs.
- Creating Azure data pipelines, data flows to extract and transform data. Working on ADLS and Blob Storage Account.
- Developing pseudocode and testing the functionality.
- Building actual code that adheres to PL/SQL coding standards.
- Involved in creating and managing tables, indexes, DB links, and privileges.
- Working on the Oracle SQL queries and PL/SQL objects, like functions, procedures, packages, triggers, views, and cursors.
- Modify, maintain, and develop PL/SQL codes for new customer requirements, which involve cursors, functions, procedures, triggers, and collections.
- Schedule jobs to automate different database-related activities, including backup, file moving, file copying, and archiving of business files.
- Using SVN version management to manage various versions of the procedures and functions of the application.
- Resolved customer issues by establishing workarounds and solutions to debug, and create defect fixes.
- Building actual code that adheres to PL/SQL coding standards.
- Involved in creating and managing tables, indexes, DB links, and privileges.
- Working on the Oracle SQL queries and PL/SQL objects, like functions, procedures, packages, triggers, views, and cursors.
PL/SQL Developer
AvenData Technologies
Mumbai
04.2021 - 07.2021
- Generating SQL queries from the given structure and logic of legacy systems.
- Coordinate with various developers, project managers, and analysts to prepare designs for new applications, and document all processes to ensure effective evaluation of all applications.
- Generating, debugging, and executing a stored procedure.
- Resolving complex database queries.
- Analyzing existing queries and developing, testing, and debugging new or old queries.
PL/SQL Developer
Kamalnayan Bajaj Hospital
Aurangabad
04.2019 - 04.2021
- Writing SQL, PL/SQL, and SQL Plus programs is required to retrieve data using cursors and exception handling.
- Create, optimize, and maintain SQL queries that support application functionality and operational activities.
- Creating indexes on tables to improve performance by eliminating full table scans and views for hiding the actual tables, and to eliminate the complexity of large queries.
- Involved in updating procedures, functions, triggers, and packages based on the change request.
- Creating new forms and reports using the application GUI.
- Working with end users and developers to maintain the data flow of performance metrics between the user interface (UI) and the application.
- Proving technical and functional support to end users.
- Communicating and working effectively with the Application Team to coordinate successful design, development, and testing efforts of assigned application components.
- Designing Workflow Process of different HIS Modules
Graduate Trainee
Vodafone Shared Services Limited
Pune
05.2018 - 10.2018
- Designing Workflow Process of different HIS Modules
- Working on pre-defined SQL queries and modifying them according to the business needs
- Creating tables, functions, and stored procedures
- Indexing table to improve the quality of performance
- Fetching and Handling Data
Education
Master of Science - Computer Science
Vivekananda College
Aurangabad01.2021
Bachelor of Science - Computer Applications
Deogiri College
Aurangabad01.2017
Skills
- PL/SQL Control Statements
- PL/SQL Objects: Types, Records, Cursors, Triggers, Functions, Stored Procedures
- Oracle Temporary Tables and Global Tables
- Views, Materialized Views
- PL/SQL Collections and Records
- CRUD operation
- Exceptional handling
- Dynamic SQL
- Windows analytical functions - RANK(), DENSE_RANK(), ROW_NUMBER()
- Partitioning and indexing
- Data modeling and design
- Data Extraction and Processing
- XML and JSON processing
- Performance Tuning and Query optimization techniques
- UNIX
- LINUX
- Oracle 19c, 11g
- MySQL, SSMS
- ETL Process Development
- Agile development methodologies
Languages
- Fluent English
- Hindi
Timeline
Senior Software Engineer- PL/SQL
Merit Data and Technology
10.2023 - Current
PL/SQL Developer
Tata Consultancy Service
08.2021 - 10.2023
PL/SQL Developer
AvenData Technologies
04.2021 - 07.2021
PL/SQL Developer
Kamalnayan Bajaj Hospital
04.2019 - 04.2021
Graduate Trainee
Vodafone Shared Services Limited
05.2018 - 10.2018
Master of Science - Computer Science
Vivekananda College
Bachelor of Science - Computer Applications
Deogiri College
Similar Profiles
Miraj AliMiraj Ali
Senior Research Analyst & Subject Matter Expert at Merit Data and Technology , Ambattur, ChennaiSenior Research Analyst & Subject Matter Expert at Merit Data and Technology , Ambattur, Chennai
DHANASHEKAR SDHANASHEKAR S
Senior Research Analyst at Merit Data and Technology Pvt LtdSenior Research Analyst at Merit Data and Technology Pvt Ltd
BERYL EUNICE ZIPPORAHBERYL EUNICE ZIPPORAH
TEAM LEAD at MERIT DATA AND TECHNOLOGYTEAM LEAD at MERIT DATA AND TECHNOLOGY
Rodney MonteiroRodney Monteiro
Financial Research Analyst at Merit Data and TechnologyFinancial Research Analyst at Merit Data and Technology
Bhushan SatheBhushan Sathe
Manager (Business Development) at Ellantra Automation Pvt LtdManager (Business Development) at Ellantra Automation Pvt Ltd