Shalini Srivastava

Shalini Srivastava E-mail-Phone:- Address:118/345 B Kaushalpuri, Kanpur. Areas of Exposure            Overall 2+ years of experience in Oracle development with emphasis on Analysis, Design, Development, Implementation of projects using Oracle (SQL, PL/SQL). Involved in database development, PLSQL development, Complex SQL queries and end to end implementation of projects having Oracle databases. Expertise in developing SQL Queries, PL/SQL package, functions, stored procedure, triggers, and cursors, database objects like tables, views, sequences, synonyms, indexes. Experience in working on oracle databases version 12c, and 19c. Data modelling, data flow strategies, creating data marts, data handling alternatives. Handling multiple data structures and data types. Application development, performance tuning, query tuning, explain plan. Worked with subject matter experts and project team to identify, define, collate, document and communicate the requirements. Knowledge on ETL processes, data warehousing, transformations and its validations. Knowledge on Azure cloud ecosystem. Troubleshooting implemented bug fixes and enhancements within tight deadlines along with Project deployment, issue resolution and reporting. Work experience Eagle TK Infotech SQL Developer Mar 2023 – Present Responsibilities Role:- SQL Developer Responsibilities: Project is designed to support business operations of various core projects..  Basically it has 8 modules as customer information node, Management information node, Transaction processing node, Decision support node, Office information, Expert system, Marketing information node and Admin module.  Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions,      Packages, DB triggers, Indexes as per business logics. Designing and creating database objects according to project requirement. Implemented sql query tuning techniques that improve database performance, data integrity and security. Analyzed explain plan to understand the query performance better. Basic knowledge of Unix commands. Involved in analyzing migration strategies for copying data from oracle to Azure cloud. Technical Skills   Cloud technology:Microsoft Azure Scripting Languages:- Oracle PL/SQL, UNIX, Shell Scripting    Operating Systems:- Windows, UNIX. Utilities:Oracle-Datapump, Export, Import, SQL*Loader SQL Tools:SQL-Developer, TORA, TOAD, SQL*Plus. Education Qualification  B.Com (Bachelor of Commerce)  HSC  SSC University/Board CSJM University Year 2019 U.P. Board U.P.Board - Personal Details  Father name : Mr. Prakash Srivastava  Mother Name : Mrs. Anjana Srivastava  Date of birth :-  Nationality : Indian  Gender : Female  Languages : English, Hindi  Permanent address : 118/345 B, Kaushalpuri, Kanpur-208012, Uttar Pradesh. I hereby declare that the information furnished above is true to the best of my knowledge. Place: Kanpur (Shalini Srivastava