Sql Developer

Ankit Gupta

#***, *** ****, **** *****, BEML Layout, Kundanahalli,

Bangalore, KA, 560066

Cell: +91-991*******

***************@*******.***

Job Objective

Over 2.5 years of IT experience as PLSQL developer, a highly versatile, hardworking, and motivated with great interest in Application development seeking challenging assignment with an organization of repute which enables me to use my skills to achieve organizational goals and objective.

Achievements

Awarded Accenture Star performer for delivering requirement to client satisfaction since last three business quarters.

Summary

Over 2 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Experience with Data flow diagrams, Database normalization theory techniques, Entity relation modelling and design techniques.

Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD, and SQL Developer.

Created Tables, Views, Constraints, Index.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, and Query Re-Write.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Good experience in Data warehouse concepts, ETL.

Good knowledge on logical and physical Data Modelling using normalizing Techniques.

Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables, and Collections.

Worked extensively on Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Experience in UNIX Shell Scripts for invoking SQL scripts in Job Scheduling using $Universe.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Technical Skills

Databases: Oracle 10g/11g (SQL, PL/SQL, Packages, Stored Procedures, functions, Triggers).

ETL Tools: INFORMATICA (Power Center 9.1.0), SQL*Loader.

Operating Systems: UNIX, Windows 8/7/98/95/2000 & Windows XP.

Languages/Utilities: SQL, PL/SQL, UNIX shell scripts, Java, XML, and C++.

Other Tools: $Universe, Turquoise SVN, WINSCP, APPSDB, PVCS, Putty, ARTIFACTORY, and HP-QC.

Professional Experience

Project Name: ACCENTURE POST TRADE PROCESSING (APTP)

Organization: ACCENTURE Client: SOCIETE GENERALE

Role: Oracle PL/SQL Developer Duration: Jan 2015 – Present

Description:

Accenture Post-Trade Processing (APTP), develops and support key post-trade processing functions such as settlement, books and records, asset servicing, operational management and control, real-time data access and administrative accounting, leveraging collective trade volumes to reduce costs per trade and provide real-time information regarding overall trading activity. It automates the post-trade lifecycle from trade capture through to settlement.

Project Name: CSCC- Cisco Service Contract Centre(Quote to Order)

Organization: Accenture Client: CISCO

Role: Oracle PL/SQL Developer Duration: Jan 2013 – Dec 2014

Description:

CSCC provides unified sales & service experience to simplify & identify opportunities, view forecasts, create quotes and manage contracts all under one Single Application. It delivers a consistent global and streamlined method to Configure, Order, manage, and register new service as well as their renewal.

Responsibilities

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Written SQL queries to obtain data from multiple table to spool into CSV format and provide extracts to business and users.

Created and modified several UNIX Shell Scripts, created UPROCS, and JLONS, to schedule SQL Jobs in $U scheduling tool.

Involved in the continuous enhancements and fixing of production problems.

Created PL/SQL stored procedures, functions and packages for various business needs and processes.

Created scripts to create new tables, views, queries for new enhancement.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Extensively used bulk collection in PL/SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Extensively used the advanced features of PL/SQL like Records, 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.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL Developer, Shell Scripts, UNIX, Windows 7

Education Qualifications

B. Tech. (Geo-Informatics Engineering) from UPES, Dehradun, Uttaranchal with 84 % (2008-2012).

Contact this candidate