Developer Data
Resume:
KRITHIKA
PANICKER
ORACLE PL/SQL DEVELOPER
CONTACT
PHONE:
EMAIL:
****************@*****.***
OBJECTIVE
Seeking a position that helps me utilize
my skills and abilities to achieve
professional growth while being
resourceful, innovative and flexible. To
add a valuable asset to your organization
by being an active member.
TECHNICAL SKILLS
Technologies: Oracle, AWS (currently
pursuing).
Languages: SQL, PL/SQL,
PostgreSQL, Python.
Software Tools: Toad, SQL developer,
PGAdmin3, Oracle 11g, Crystal reports,
Adobe Coldfusion, JIRA, Erwin data
modeler, Microsoft Visio
EDUCATION
B. Tech (SRM University):8.023 CGPA
(May 2015)
H. S. C (CBSE):84% (May 2011)
S. S. C (CBSE): 87.1% (March 2009)
PROFESSIONAL SUMMARY
4.10 years of experience in IT industry specializing in application development, maintenance and support.
Involved in all phases of the SDLC (Software
Development Life Cycle) from Requirement
Analysis, Data Migration, Application
Maintenance, Coding, Quality Reviews and
Testing, Implementation and Support with timely
delivery against aggressive deadlines.
Expertise in Client-Server application
development using Oracle 11g/10g,
PL/SQL, TOAD .
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, etc.
Created Tables, Views, Constraints, Index, etc.
Developed Complex database objects like
Stored Procedures, Functions, Packages and
Triggers using SQL and PL/SQL.
Developed materialized views for data replication in distributed environments.
Created Data flow diagrams using Microsoft Visio.
Good knowledge of data dictionary tables.
Partitioned large Tables using list and range partition technique.
Performance tuning in Oracle. Good knowledge
of key Oracle performance related features
such as Statistics gathering, Explain Plans and
Indexes.
Experience on Ref Cursor, External Tables, Collections and Exception handling.
Good knowledge on Cascading concept and Bulk
Processing of data.
Experience on Oracle forms for purge process
initiation, testing the forms after the purge process completion.
Experience on Crystal Reports.
Experience on data modeling using ERwin data modeler.
Rudimentary understanding of UNIX gathered as a part of purge process initiation.
Experience in Mainframe DB2.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Ability to work independently in a client facing role and having the zeal and aptitude to learn new technologies to enhance my skills.
WORK EXPERIENCE
COGNIZANT TECHNOLOGY SOLUTIONS (September 2015 – April 2020) Project - Merck Cornerstone Project (Oracle DBA/developer)
(March 2019 – April 2020)
Roles and responsibilities:
Functioning and maintenance of the data in the lower environments in three regions: APAC, LATAM and EURAM.
New User/Shema creation. Replicating access, maintaining user access privileges.
Performance Tuning of queries.
Partition creation/addition for tables.
Check for locks, monitor sessions, kill sessions.
Temporary Tablespace issue fix, DB Link creation, sequence reset.
Troubleshooting any issue raised by client.
Project - FPL AMI Data Scientist FB (Data Engineer- Oracle + PostgreSQL)
(August 2018 – March 2019)
Roles and responsibilities:
To analyze the tables present in Greenplum DB and Oracle DB and to gather the meter specific information for prediction.
Write complex queries to extract and transform data as required by the data scientists in my team for their prediction analysis
Created scripts to extract identified features from the events occurring for a meter. Evaluate the historical data to capture the events that may have resulted in a meter change in the past.
Captured the Random Forest Model predictions and other predictions in a GP table. Project – NVEnergy Banner Data Reduction Project (Oracle PL/SQL developer)
(June 2017 – July 2018)
Roles and responsibilities:
Analysis of the banner table data to figure out the parent-child mapping and to filter out the tables that are eligible for purge and the tables that are exempted from purge.
Creating VISIO diagrams for the table hierarchies using Microsoft Visio.
Unit testing, functional testing, system integration testing and regression testing for the purge eligible records.
Creating and executing the test cases for the tables. Identifying purge eligible records for each table, checking the orphan records and analyzing the exceptions.
Testing of multiple oracle forms to check if it maintains its integrity post certain modifications.
Running the pre and post purge crystal reports and analyzing the mismatches if any. Project – BNYM Flex Client Onboarding Project (Mainframe DB2 developer)
(March 2016 – April 2017)
Roles and responsibilities:
Involved in Requirements Analysis, preparing the Detailed Design Documents.
Code modifications in COBOL, JCL and DB2.
Making Changes, Unit Testing and Regression Testing, preparing Test documents.
Contact this candidate