RAJEEV SINGH

**** **** **** *****, ************, TN 38017 adgdnq@r.postjobfree.com / 901-***-****

WORK EXPERIENCE

SENIOR ORACLE PL / SQL DEVELOPER 08/2015 - PRESENT

Atos-Syntel (FedEx), Collierville, TN

Creating views, stored procedures, functions and packages using PL/SQL best practices.

Reviewing and improving legacy database objects and query performance.

Strong knowledge in writing SQL Queries that varies from single table simple SQL’s to multiple tables complex SQLs

Performed SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN and AUTOTRACE

Extensively used the advanced features of PL/SQL like Records, PL/SQL tables, Object types and dynamic SQL.

Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.

Used BULK bind for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines

Proficiency in Relational Database Management Systems (RDBMS)

Participate in design reviews and provide input to the design recommendations

Document concise design, development, and testing processes for assigned projects

Good knowledge on logical and Physical data modelling using normalization techniques.

Exceptional analytical and debugging skills

Responsible for building and deploying database updates to real-time production, working with several environments and QA processes

Provides database support by coding utilities, responding to user questions, and resolving problems

Experience in Distributed Multi-tier Application Development, Database Design, Data processing and Support mainly with Oracle technology on different platforms

Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables

Proficiency using TOAD, SQL Developer, SQL*PLUS or equivalent developer tools for Oracle and QMF for DB2

Lead the code review process and mentors/coaches other developers to help accelerate their learning and capabilities

Provide technical and thought leadership

Managing the project delivery along with Supporting customer in process improvements

Participate and contribute in scrum events.

Working on Ad-hoc requests especially on data analysis and specific reports for senior management

ORACLE PL / SQL DEVELOPER 10/2011 – 07/2015

Syntel Inc (FDCS), Memphis, TN

Developed advanced PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic using TOAD

Used standard packages like DBMS_SQL, UTL_FILE and PL/SQL collections. Used BULK bind in writing database procedures, functions and packages for Front End Module.

Consumed web service in PL/SQL code.

Used DBMS_JOB package extensively for daily/ weekly/ monthly reporting purposes.

Identify application code-related issues. Review and provide feedback to the related stakeholder.

Experience in Database Application Development, Query optimization, Performance tuning.

Developed several PL/SQL scripts to address business immediate needs to manage customers with immediate effect.

Performed data analysis and data quality analysis to prevent potential problems and gave heads up to the management beforehand.

Involved in file ingestion on HDFS to reproduce these data on Hive tables.

Performed data quality analysis using ATACCAMA Data Quality tools.

Code reviews and mentoring of development team

Conducted SQL sessions for the Full Stack Developers’ training program.

ORACLE PL / SQL DEVELOPER 02/2007 – 09/2011

Syntel Pvt. Ltd (FDCS), Pune, India

Analyzed database and have written several Oracle Packages, Stored Procedures, Functions and Triggers used by webpages and Crystal Reports

Identified and Incorporated performance-tuning changes in the existing queries.

Analyzed and modified exiting Crystal Reports as well as their underlying queries.

Conducted Oracle training for application developers for their better understanding about database

Actively participated in internal and external audits like PCI-DSS, SAS-70.

Good Understanding of Oracle Exadata platform and DBMS concepts

Extensively used External table for reporting purposes. It gave an option for client, to change the resultant report without changing any business logic.

Extensively used DBMS_JOB package for daily/ weekly/ monthly reporting purposes.

ANALYST PROGRAMMER 12/2005 – 01/2007

Datacons Pvt. Ltd (i-flex), Mumbai, India

Written several Oracle Packages, Stored Procedures, Functions and Triggers

Written complex SQL queries to fetch data from different tables of remote databases using join, sub-queries and DB links.

Have used UTL_SMTP for sending internal emails to different stakeholders.

Conducted user trainings and provided production support.

Improved the performance of the application by re-writing the existing SQL queries

Migrated T-SQL stored procedures into PL/SQL stored procedures.

SOFTWARE ENGINEER 10/2003 – 11/2005

Gateway TechnoLabs/Ace Infotech/Tata Teleservices, Ahmedabad, India

Created Packages, Procedures, Functions and Triggers.

Worked on complex SQL queries with extensive use of CLOB and BLOB data types

Created various DML statements

Written simple and complex SQL queries including hierarchical queries and sub queries

Got an exposure of ASP.Net and JavaScript.

Worked on VB.Net Web services and Crystal Reports

Worked on ASP3.0 and Crystal Reports and SQL server queries

SOFTWARE TRAINEE 02/2003 – 09/2003

Crystal Info, Pune, India

SRS Documentation

Written Java programs for billing system

Written SQL queries

EDUCATION

UNIVERSITY OF PUNE 2000 - 2003

Master of Computer Applications

Bharti Vidyapeeth UNIVERSITY, PUNE 1997 - 2000

Bachelor’s Degree in Science

CERTIFICATIONS

Project Management Professional (PMP) 08/2013 – 08/2022

Oracle Certified Associate (OCA) 05/2009 – Present

Scaled Agile Framework Scrum Master (SSM) 01/2019 – 01/2020

Scaled Agile Framework Practitioner (SP) 12/2016 – 12/2017

PROFESSIONAL SKILLS

Extensive programming experience as an Oracle PL/SQL developer in Analysis, Design and Implementation of business applications using the Oracle Relational Database Management System (RDBMS).

Highly-skilled software development professional in software design, development and integration. Advanced knowledge of Oracle SQL, PL/SQL and MS T-SQL

Experience with Data flow diagrams, Data Dictionary, Database Normalization theory techniques, Entity Relation modelling and Design techniques.

Expertise in client server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL*PLUS, TOAD, SQL Developer and MS SQL Server 2000.

Effectively made use of Table Functions, Indexes, Table partitioning, Views, Analytical Functions, Materialized Views and Query re-write.

Knowledgeable Oracle developer skilled in Data collection, Analysis and Management. Works well under pressure and consistently meets deadlines and targets while delivering high quality work.

Developed complex database objects like Packages, Stored Procedures, Functions and Triggers on different databases using PL/SQL and T-SQL.

Excellent technical and analytical skills with clear understanding of design goals

Experience with Oracle supplied Packages such as DBMS_SQL, DBMS_JOB, UTL_FILE and UTL_SMTP

Worked extensively on Ref Cursor, External Tables, Collections, Bulk Binding and Exception Handling.

Experience with performance tuning for Oracle RDBMS using Explain Plan, AUTOTRACE and HINTS

Experience with data analysis and data quality analysis as per defined business rules.

Experience with DB2, Crystal Reports, HDFS and ATACCAMA data quality tools.

Excellent communication skills, co-ordination skills, self-motivated, process oriented

Eager to learn new skills and improve existing skills

Leading skills and experience with passing on knowledge to junior developers, mentoring and coaching within a technical environment.

Strong team-building and collaborative talents, including maintain communication with stakeholders at multiple levels.

Experience of software development methodologies, SDLC and Agile

Contact this candidate