SUMMARY
- Around 8+ years of experience in programming as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) in Telecommunication sector as well in Real time projects.
- Over 6 years and 8 month 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.
- Expertise in Client - Server application development using Oracle 11g/10g/9i, PL/SQL, TOAD, SQL *PLUS, SQL*LOADER and SQL SERVER 2008
- Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
- Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
- Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
- Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
- Loaded Data into Oracle Tables using SQL Loader.
- Partitioned large Tables using range partition technique.
- Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
- Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
- Worked extensively on Ref Cursor, External Tables and Collections.
- Expertise in Dynamic SQL, Collections and Exception handling.
- UNIX Shell scripting experience.
- Good experience in core java
- Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
- Experience in Requirements Gathering, Business Analysis, Business Process Redesign and Mapping, Testing & User training, Documentation of activities, processes, test scripts and results and Client interaction.
- Created Shell Scripts for invoking SQL scripts.
- Use SED, grep for filtering and providing from huge amount of data.
- Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
- Interacting with clients to understand requirements
- Good in Understanding of Business logic and ability to work well as a part of a team and as an individual.
- Have a very good debugging and problem solving skills.
- Experience to provide solution for various billing requirements and can create the test environment for testing.
- Completed Engineering in Computer Science with first class and grade honors
TECHNICAL SKILLS
Operating System: Windows Families, UNIX
Languages: Core Java
Database: Oracle 11g/9i/10
Tools: winscp, putty, SQL Developer, Rational Clearcase, Tortoise CVS, Beyond Compare, Winmerge, Eclipse, Toad
PROFESSIONAL EXPERIENCE
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Develop GUI for DEALER portal
- Handling Enhancements in web application
- Preparing build and publishing
- Bug fix in oracle plsql
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Development of CR s
- Providing PR fixes and hot fixes
- Data loading from PROD to local machine
- Writing plsql packages, procedure etc.. as mentioned above. And involving in build activities
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Performing performance tuning of stored procedures
- Performing production deployment and production support after development
- Direct client interaction to understand requirement, fix the production issues
- Monitoring the production system
