Summary
Overview
Work History
Education
Skills
Personaldetail
Affiliations
Accomplishments
Certification
Languages
Timeline
Generic
Sweety

Sweety

Ghaziabad

Summary

With 8 years of experience as an Oracle PL/SQL developer, I have led and developed commercial and non-commercial applications on the Oracle platform. My expertise includes working with Oracle RDBMS, SQL (Views, Indexes, Sequences, Constraints, Triggers), PL/SQL (Functions, Procedures, Packages), Analytical Functions, and Collections. I have handled composite data types such as Records, Varrays, Nested Tables, and Associative Arrays. Additionally, I have extensive experience with Oracle Forms and Reports (D2k, 10g, 11g), performance tuning, and migrating forms and reports to 11g. Proficient in Agile methodology, I possess strong client interaction and presentation skills.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Principal Engineer

Mercer
Gurgaon
02.2022 - Current
  • WebCAS is an internal application used at Mercer to manage various administrative, billing, and operational tasks.
  • Designed, developed, and maintained PL/SQL Forms and Reports for WebCAS, improving user interface and functionality.
  • Collaborated with cross-functional teams to gather requirements and implement new features, resulting in a 10% increase in system efficiency.
  • Understanding and Collecting requirements from Business user side or Business Analyst and convert that requirement to SQL queries or PL/SQL.
  • Creating complex views, materialized views on multiple table as per customer requirement.
  • Developed Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens.
  • Used PL/SQL Tables(collection), Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.

Senior Software Engineer

HCL Technologies Pvt Ltd.
11.2018 - 02.2022
  • Contributed to the optimization of IKEA's supply chain management system by developing and implementing efficient data processing algorithms in PL/SQL, enhancing inventory tracking and distribution processes.
  • Understanding and Collecting requirements from Business user side or Business Analyst and convert that requirement to SQL queries or PL/SQL.
  • Designed and maintained stored procedures, functions, and packages to support various supply chain operations, ensuring seamless integration with other enterprise systems.

Software Developer

MM Infosystems Pvt. Limited
11.2015 - 02.2018
  • Customize new Forms, Reports, Procedure, Views, Index, Triggers and Functions
  • This project is based on oracle D2K Technology which consists of Oracle Forms and Reports
  • Implement and Customize forms and reports as per the requirement of the client and provide support to the client for running the Application and provide online support to client.

Software Developer

Indiabulls Ventures Limited
  • Analyze and convert business requirements to technical requirements, followed by design and implement the solutions.Developed stored procedure and fuction, trigger, view package for generating data intensive reports
  • Developed user test cases for testing purpose
  • Create acceptance criteria, develop automated test frameworks, and validate work products
  • Development of forms and reports as per user's requirement
  • Handling request made by clients
  • Help write and optimize in-application SQL statements

Education

B.Tech -

Aryan Institute of Technology, Ghaziabad
01.2015

Oracle Certification in SQL -

Oracle University
01.2015

Skills

  • Oracle PL/SQL
  • Oracle RDBMS
  • SQL
  • Analytical Functions
  • Collections
  • D2k
  • Forms
  • Reports
  • Performance Tuning
  • Migration
  • Agile Methodology
  • Client Interaction
  • Presentation Skills

Personaldetail

Late Sh. Rambabu, Govindpuram, Ghaziabad, 201013, English, Hindi, Net Surfing, Listen Music, Reading News Paper.

Affiliations

Led company-sponsored visits to local schools, managing and coordinating educational initiatives to support community development and enhance student learning experiences.

Accomplishments

Excellence award - Performance award for outstanding performance - Mercer

Certification

Oracle Pl/SQL certification.

Languages

English
First Language

Timeline

Senior Principal Engineer

Mercer
02.2022 - Current

Senior Software Engineer

HCL Technologies Pvt Ltd.
11.2018 - 02.2022

Software Developer

MM Infosystems Pvt. Limited
11.2015 - 02.2018

Software Developer

Indiabulls Ventures Limited

B.Tech -

Aryan Institute of Technology, Ghaziabad

Oracle Certification in SQL -

Oracle University

Similar Profiles

CREATE PROFILE
Sweety