AMAN SAINI
Faridabad
Summary
Results-driven Oracle Consultant and Data Analyst with extensive experience at Inyxa Informations Pvt Ltd. Expert in SQL and PL/SQL development, performance tuning, and project management. Successfully optimized database applications, enhancing performance and user satisfaction. Proven ability to collaborate with cross-functional teams to deliver innovative solutions and meet project goals efficiently.
Overview
6
6
years of professional experience
Work History
Oracle Consultant | Software Engineer
Inyxa informations pvt ltd.
Faridabad
09.2021 - Current
- Developed complex SQL queries for data retrieval and reporting purposes.
- Designed and optimized PL/SQL procedures to enhance application performance.
- Collaborated with cross-functional teams to gather requirements and define project scope.
- Analyzed user needs and software requirements to determine design feasibility.
- Conducted unit testing of stored procedures and functions developed in the database layer.
- Modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.
- Reviewed project requirements to identify customer expectations and resources needed to meet goals.
- Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
- Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.
- Analyzed code and corrected errors to optimize output.
- Developed shell scripts to automate the daily maintenance tasks of the databases.
- Designed new tables, views, materialized views, indexes and sequences according to user requirements.
- Performed code reviews, debugging, optimization and fine-tuning of SQL queries and PL and SQL programs.
- Managed multiple projects simultaneously while adhering to strict deadlines.
- Designed, developed and tested custom packages, procedures and APIs.
- Analyzed existing database objects for performance issues and implemented tuning solutions.
- Supported code migration changes to fit production environment.
- Developed complex Oracle PL and SQL packages, procedures, functions and triggers to support application development.
Data Analyst
AIIMS
New Delhi
02.2019 - 03.2021
- 1 Year 2 Months Hands on Practice on Data Extraction, Transformation, and Loading, Data Wrangling and Data Exploration, Machine Learning Algorithm, Data Visualization, Web Scraping Statistics using python language
Education
M.C.A -
Swami Vivekanand Subharti University
Meerut01.2022
B.C.A -
SAM HIGGINBOTTOM UNIVERSITY of Agriculture, Technology & Science (SHUATS UNIVERSITY)
01.2019
Diploma - Multimedia & Animation
01.2016
12th -
Haryana Board of Open Education
Faridabad, Haryana01.2015
10th -
K.L Mehta Dayanand Public School
Faridabad, Haryana01.2012
Skills
- Code debugging
- Project management
- Performance tuning
- Oracle e-business suite
- Oracle forms and reports
- Oracle REST data services
- Oracle data integrator
- Oracle integration cloud
- SQL and PLSQL Development
- Oracle performance tuning
- Design and development
- Database programming
Languages
English, Hindi
Hobbies and Interests
Swimming, Travelling, Chess, Electronic Gaming
Projects
Work On Automated Attendance System Using Face Recognition in DUCAT.
Disclaimer
I hereby declare that the above mentioned information is true to the best of my knowledge.
SOFTWARE
- Oracle SQL Developer
- Toad for Oracle
- Oracle Fusion
- Oracle E-Business Suite
- Oracle Form and Report Builder
- Postman
- PYTHON, PY-CHARM, ANACONDA, SPYDER, JUPYTER NOTEBOOK, DJANGO
Languages
Hindi
First Language
Hindi
Intermediate (B1)
B1
English
Intermediate (B1)
B1
Affiliations
- Reading books
- Gym
- Travelling
Timeline
Oracle Consultant | Software Engineer
Inyxa informations pvt ltd.
09.2021 - Current
Data Analyst
AIIMS
02.2019 - 03.2021
M.C.A -
Swami Vivekanand Subharti University
B.C.A -
SAM HIGGINBOTTOM UNIVERSITY of Agriculture, Technology & Science (SHUATS UNIVERSITY)
Diploma - Multimedia & Animation
12th -
Haryana Board of Open Education
10th -
K.L Mehta Dayanand Public School
Similar Profiles
Rajat DasRajat Das
Customer Service & Sales Executive at Silaris Informations Pvt LtdCustomer Service & Sales Executive at Silaris Informations Pvt Ltd
Mahesh RMahesh R
Front - End Software Developer at ZOITECKH Informations SolutionsFront - End Software Developer at ZOITECKH Informations Solutions
Blas LopezBlas Lopez
IT Support Specialist at General Dynamics Informations TechnologyIT Support Specialist at General Dynamics Informations Technology
Jasbir Singh SidhuJasbir Singh Sidhu
Senior Technical Program Manager at FreechargeSenior Technical Program Manager at Freecharge
Shushant VasisthShushant Vasisth
Manager - Climate and Environment at Fair Climate Fund, IndiaManager - Climate and Environment at Fair Climate Fund, India