ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
Deepika Chandnani E-mail: dc616140@gmail.com
Address: Kalyani nagar, Pune-14. Mobile: +91 8983102035.
Objective
? To associate with an organization, that allows me to utilize my competencies to the best use and
contributes to my overall growth as an individual.
Summary
? A logical, analytical thinker with exceptional database skills possesses rich experience of 2 years as
Oracle PL/SQL developer.
? Extensive experience in developing Stored Procedures, Functions, Views, Packages, Exceptions,
Joins, Sub Queries and Set Operators.
? Strong understanding of business processes with good experience in development.
? Good exposure on advanced topics Like Analytical Functions, Indexes, Partition Tables.
? Strong knowledge in SDLC and all phases of Application development.
? Good experience of coordinating with various teams like Deployment, Testing Team to speed up
Development process.
? Quick learner & Self-directed, consistently updating self with emerging trends in the industry.
Academic Qualifications
Exam College/University Year Marks
MCA PUNE University 2014 71.65%
BSC SRTM University 2011 68.94%
HSC SSC Board Maharashtra 2008 58.83%
SSC SSC Board Maharashtra 2006 64.53%
Professional Skills
Language : C programming.
RDBMS : ORACLE (11g), SQL, PL/SQL.
Tools : Toad, PL/SQL Developer, SQL *PLUS ,Hive
Operating Systems : Windows & UNIX
Job Scheduling Tool :Crontab
.
Employer
? Working as Oracle PL/SQL Developer in Glam India Pvt Ltd from May 2015 to till date.
Professional Experience
Organization : Glam India Pvt Ltd, Pune.
Designation : PL/SQL Developer
Duration : May,2015 ¨C Till Date.
Key Responsibilities
? Created packages, Procedures, functions, Materialized Views as per the Business requirements.
? Created partition and sub-partitioned table to speed up the speed of the execution of the ETL¡¯s and
Reporting SQL¡¯s.
? Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the
database.
? Created logging mechanism using Autonomous Transaction.
? Implemented logic for data syncing from Production to DEV and QA and calling packages over the
DBLINK¡¯s.
? Little Analysis of SQL queries using Explain Plan.
? Created Shell Script for ETL job scheduling.
Project details
1. Hadoop Data Load:
? The project is about creating a shell script to generate tsv/csv file from hadoop data source using hive
query. Then load this file into oracle table using the external table and apply business logic to transform
this data and further used for reporting.
2. Pax Partner Import:
? Data loading from different data sources using dynamic pl/sql and shell script, AWK script.
Certification
? SEED certified technology specialist.
Awards and Accomplishments
? Winner of intra college Programming contest.
? Awarded as ¡°Star of MGM¡±.
? Runner-up in intra college Basket¨Cball competition.
Interests
? Watching movies
? Collecting Coins
Personal Details
Full Name: Ms. Deepika Rajkumar Chandnani
Date of Birth: 25th
December 1990
Personal E-mail: dc616140@gmail.com
Languages Spoken: English, Hindi, Marathi, Sindhi

More Related Content

What's hot (20)

Java Developer resume
Java Developer resume Java Developer resume
Java Developer resume
Pavel Plakhotnik
?
Pawan CV 5.10 Years
Pawan CV 5.10  YearsPawan CV 5.10  Years
Pawan CV 5.10 Years
Pawan Kumar
?
Logesh_Chandrasekar
Logesh_ChandrasekarLogesh_Chandrasekar
Logesh_Chandrasekar
LogeshChandrasekar1
?
Anindo Choudhury
Anindo ChoudhuryAnindo Choudhury
Anindo Choudhury
anindo18
?
Resume_Yogesh_Jain
Resume_Yogesh_JainResume_Yogesh_Jain
Resume_Yogesh_Jain
yogesh jain
?
Resume_Sankar
Resume_SankarResume_Sankar
Resume_Sankar
sankar naren
?
PAVAN testing
PAVAN testingPAVAN testing
PAVAN testing
Pavan Ch
?
Sujit-CV
Sujit-CVSujit-CV
Sujit-CV
sujit chaudhari
?
Niranjan_Ingale
Niranjan_IngaleNiranjan_Ingale
Niranjan_Ingale
Finally Suru
?
PRAKASH_PVSSR_CV
PRAKASH_PVSSR_CVPRAKASH_PVSSR_CV
PRAKASH_PVSSR_CV
prakash pvssr
?
devika
devikadevika
devika
devika reddy
?
Chandrakant pandey java j2ee developer resume
Chandrakant pandey java j2ee developer resumeChandrakant pandey java j2ee developer resume
Chandrakant pandey java j2ee developer resume
Chandrakant Pandey
?
Rhonda Edwards Resume
Rhonda Edwards ResumeRhonda Edwards Resume
Rhonda Edwards Resume
Rhonda Edwards
?
Resume (2) (1)
Resume (2) (1)Resume (2) (1)
Resume (2) (1)
Vidya Muralidharan
?
Omkar_Resume (1)
Omkar_Resume (1)Omkar_Resume (1)
Omkar_Resume (1)
omkar nachankar
?
Resume
ResumeResume
Resume
pavan kumar
?
Curriculum vitae Deepak kumar
Curriculum vitae Deepak kumarCurriculum vitae Deepak kumar
Curriculum vitae Deepak kumar
Deepak Kumar
?
Mugilan Resume
Mugilan ResumeMugilan Resume
Mugilan Resume
mugilan b
?
Resume
ResumeResume
Resume
Laxmikant Anjankar
?
Resume_Varnika
Resume_VarnikaResume_Varnika
Resume_Varnika
varnikaneha
?

Viewers also liked (10)

iTHEMBA PRESENTATION
iTHEMBA PRESENTATIONiTHEMBA PRESENTATION
iTHEMBA PRESENTATION
jennylee Bryson
?
Limousine home
Limousine homeLimousine home
Limousine home
rohan sarka
?
business cycles
business cyclesbusiness cycles
business cycles
gitika deshmukh
?
INDIBRAND_CORPORATE
INDIBRAND_CORPORATEINDIBRAND_CORPORATE
INDIBRAND_CORPORATE
Abhijeet Bhadani
?
Technology makes us a marketing tool
Technology makes us a marketing toolTechnology makes us a marketing tool
Technology makes us a marketing tool
ÁéÐù Lingxuan Íõ Wang
?
mnsappsdba
mnsappsdbamnsappsdba
mnsappsdba
naveen mudrageda
?
Sejarah bab 5 nasyi
Sejarah bab 5 nasyiSejarah bab 5 nasyi
Sejarah bab 5 nasyi
najwa insyirah
?
Resume_Asmita Patel
Resume_Asmita Patel Resume_Asmita Patel
Resume_Asmita Patel
Asmita Patel
?
Sejarah bab 5 nasyi
Sejarah bab 5 nasyiSejarah bab 5 nasyi
Sejarah bab 5 nasyi
najwa insyirah
?

Similar to Deepika_plsql (20)

Kisan_CV_Latest
Kisan_CV_LatestKisan_CV_Latest
Kisan_CV_Latest
Kisan Senapati
?
Rahul_CV
Rahul_CVRahul_CV
Rahul_CV
Rahul Bhatia
?
Swetha_informatica_developer
Swetha_informatica_developerSwetha_informatica_developer
Swetha_informatica_developer
swethagp
?
Pradeepa dharmappa
Pradeepa dharmappaPradeepa dharmappa
Pradeepa dharmappa
Pradeep Pradeep
?
Khushal Patil New
Khushal Patil NewKhushal Patil New
Khushal Patil New
Khushalnana Patil
?
Muhammad Amir Hossain CV
Muhammad Amir Hossain CVMuhammad Amir Hossain CV
Muhammad Amir Hossain CV
Muhammad Amir Hossain
?
Pradeepa dharmappa
Pradeepa dharmappaPradeepa dharmappa
Pradeepa dharmappa
Pradeep Pradeep
?
Daman_CV
Daman_CVDaman_CV
Daman_CV
Damanjeet Singh
?
Yogesh_CV_Aug15
Yogesh_CV_Aug15Yogesh_CV_Aug15
Yogesh_CV_Aug15
Yogesh Sharma
?
CV_Anantha_Krishnan_Senior_Oracle_ETL_PLSQL
CV_Anantha_Krishnan_Senior_Oracle_ETL_PLSQLCV_Anantha_Krishnan_Senior_Oracle_ETL_PLSQL
CV_Anantha_Krishnan_Senior_Oracle_ETL_PLSQL
Anantha TMS
?
Kanakaraj_Periasamy
Kanakaraj_PeriasamyKanakaraj_Periasamy
Kanakaraj_Periasamy
Kanakaraj Periasamy
?
Hasan jawaid cv
Hasan jawaid cvHasan jawaid cv
Hasan jawaid cv
Hasan Jawaid
?
Gulshan_resume
Gulshan_resumeGulshan_resume
Gulshan_resume
Gulshan Kumar Singh
?
Avinash Kumar
Avinash KumarAvinash Kumar
Avinash Kumar
Avinash Sharma
?
Wangshuang
Wangshuang Wangshuang
Wangshuang
shuang wang
?
avinash_resume
avinash_resumeavinash_resume
avinash_resume
Avinash Sakroji
?
AJAY RESUME
AJAY RESUMEAJAY RESUME
AJAY RESUME
Ajaykumar Palani
?
MyExperience Resume
MyExperience ResumeMyExperience Resume
MyExperience Resume
Lokesh Smiley
?
ABHINAV KAUSHIK(IT Professional)
ABHINAV KAUSHIK(IT Professional)ABHINAV KAUSHIK(IT Professional)
ABHINAV KAUSHIK(IT Professional)
Abhinav Kaushik
?
Shreya_Resume_
Shreya_Resume_Shreya_Resume_
Shreya_Resume_
Shreya Jain
?

Deepika_plsql

  • 1. Deepika Chandnani E-mail: dc616140@gmail.com Address: Kalyani nagar, Pune-14. Mobile: +91 8983102035. Objective ? To associate with an organization, that allows me to utilize my competencies to the best use and contributes to my overall growth as an individual. Summary ? A logical, analytical thinker with exceptional database skills possesses rich experience of 2 years as Oracle PL/SQL developer. ? Extensive experience in developing Stored Procedures, Functions, Views, Packages, Exceptions, Joins, Sub Queries and Set Operators. ? Strong understanding of business processes with good experience in development. ? Good exposure on advanced topics Like Analytical Functions, Indexes, Partition Tables. ? Strong knowledge in SDLC and all phases of Application development. ? Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process. ? Quick learner & Self-directed, consistently updating self with emerging trends in the industry. Academic Qualifications Exam College/University Year Marks MCA PUNE University 2014 71.65% BSC SRTM University 2011 68.94% HSC SSC Board Maharashtra 2008 58.83% SSC SSC Board Maharashtra 2006 64.53% Professional Skills Language : C programming. RDBMS : ORACLE (11g), SQL, PL/SQL. Tools : Toad, PL/SQL Developer, SQL *PLUS ,Hive Operating Systems : Windows & UNIX Job Scheduling Tool :Crontab .
  • 2. Employer ? Working as Oracle PL/SQL Developer in Glam India Pvt Ltd from May 2015 to till date. Professional Experience Organization : Glam India Pvt Ltd, Pune. Designation : PL/SQL Developer Duration : May,2015 ¨C Till Date. Key Responsibilities ? Created packages, Procedures, functions, Materialized Views as per the Business requirements. ? Created partition and sub-partitioned table to speed up the speed of the execution of the ETL¡¯s and Reporting SQL¡¯s. ? Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database. ? Created logging mechanism using Autonomous Transaction. ? Implemented logic for data syncing from Production to DEV and QA and calling packages over the DBLINK¡¯s. ? Little Analysis of SQL queries using Explain Plan. ? Created Shell Script for ETL job scheduling. Project details 1. Hadoop Data Load: ? The project is about creating a shell script to generate tsv/csv file from hadoop data source using hive query. Then load this file into oracle table using the external table and apply business logic to transform this data and further used for reporting. 2. Pax Partner Import: ? Data loading from different data sources using dynamic pl/sql and shell script, AWK script.
  • 3. Certification ? SEED certified technology specialist. Awards and Accomplishments ? Winner of intra college Programming contest. ? Awarded as ¡°Star of MGM¡±. ? Runner-up in intra college Basket¨Cball competition. Interests ? Watching movies ? Collecting Coins Personal Details Full Name: Ms. Deepika Rajkumar Chandnani Date of Birth: 25th December 1990 Personal E-mail: dc616140@gmail.com Languages Spoken: English, Hindi, Marathi, Sindhi