SUMMARY

• 5+ years of experience in Information Technology with extensive knowledge and work experience in designing and developing Database applications in Client/Server environment accomplished using Oracle Database and PL/SQL.
• Expertise in Oracle 10g/11g, 9i, 8i databases, cluster databases, SQL - Server, PL/SQL, UNIX Shell Scripting, OEM Oracle Enterprise Manager/10g/11g Grid Controller.
• Strong experience in Requirement study, systems Analysis, design and development of complex software systems in Finance and Telecom domain.
• Experience in Design, Development, and Enhancement and Maintaining applications in Windows 9x/NT/2000/XP and UNIX environments.
• Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, and Packages, Database triggers and also SQL queries/reports and scripts.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing code and scripts.
• Experienced in Tuning applications using Explain plan and SQL Trace for optimizing cost and increasing efficiency.
• Data Warehouse experience using Informatica Power Center 9.x (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle Database.
• Experience in working with various types of source/targets, flat files like fixed width, CSV, and relational types like SQL Server & Oracle database tables, and XML Files.
• Proficient in requirement analysis, system design, and Object Oriented Design (UML).
• Experience in working with Agile environment and Software Development Life Cycle (SDLC).
• Worked in Automation scripting with UNIX-Shell scripting and Perl scripting.
• Ability to work collaboratively in a team environment and has the ability to handle multiple tasks under pressure.
• Good communication and interpersonal skills.
• Sharp to learn new concepts, adapts to new environments.
• Dedication in planning and executing a given job to perfection.

TECHNICAL SKILLS

Programming: Oracle SQL, PL/SQL, Unix Shell Scripts, Perl, Java (Basics)C Programming, VB6

Database: Oracle 10g/11g, 9i, 8i

Operating Systems: Windows 95/98/NT/2000/XP/Vista/7/Server2008Sun Solaris, UNIX

Tools: SQL *Plus, SQL Developer, Power Builder, Toad, Citrix, IBM Rational Rose

Scripts: UNIX shell scripting, Perl Scripting

ETL Tools: Informatica 9.1, 9.6

SCM tools: Serena

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Environment: Oracle Database 11g, PL/SQL Developer, SQL*Plus, TOAD, Power Builder, Windows, UNIX, Informatica 9.1/9.6

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• Developed and modifiedcustom triggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Developed database objects including tables, Indexes, sequences, packages and procedures.
• Worked in repository Configuration/using Transformations, Mappings, Sessions, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from various sources into Data Warehouses using Power Center 9.1/9.6.
• Developed Informatica mappings with various types of Informatica source and targets (XML,RDBMS and Flat files)
• Oversees the design/development and supports the data models/structures of DW OLAP using ETL. Performs quality testing prior to UAT, and reports progress throughout the project and enhancement life cycle.
• CreatedSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Involved in developing several UNIX shell scripts for data processing, Job scheduling, automating various manual tasks and also PL/SQL programming.
• Created DB links for connecting to remote databases accessing.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Automated installation, creating and replication of database, creating users, granting, revoking permissions to and from users.
• Involved in generating custom reports using Crystal 2008 designer tool and Deployed reports using crystal report server and published using IIS server.
• Made timely changes and fixes to all database modules on problems as reported.

Confidential

Oracle PL/SQL Developer

Environment: Oracle Database 11g, PL/SQL Developer, SQL*Plus, SQL*Loader, Windows Server 2003, UNIX

Responsibilities:

• Involved in design and development of ARMA system and their enhancement feature with backend programming with Packages, Procedures, functions and scripts according to the client’s requirements.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Used TOAD, PL/SQL developer tools for faster application development.
• Created DB links for connecting to remote databases.
• Worked on exception handling to troubleshoot PL/SQL code.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Created External Tables to load data from flat files where one to many and many to one relation exists between the flat files and Database tables.
• Developed database objects including tables, Indexes, sequences, packages and procedures.
• Used Oracle XML packages to load data.
• Extensively usedbulk collectionin PL/SQL sub-programs for improving database performance.
• Implemented complex Interface business rules using Oracle Database Triggers and constructs.
• Made timely changes and fixes to all database modules on problems reported by database administrator.
• Used version control tool SVN to keep the latest version of the code developed at a single place
• Extensively used Global temporary and Ref cursors for accessing database.
• Good understanding of Global temporary and Ref cursors.

Confidential

Oracle Developer

Environment: Oracle Database 10g, UNIX shell scripting, Accounting Software Application, TOAD

Responsibilities:

• Involved in developing warehouse, including requirement gathering, requirement definition, operations analysis, technical design and implementation.
• Created PL/SQL procedures in order to dump the data from staging tables to base tables.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Used Ref cursors, global temporary table and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in debugging and Tuning the PL/SQL code, tuning queries and optimization of the Oracle database.
• Data Integration is performed with metrics obtained from each node using different computation strategies are implemented in PL/SQL.
• Used Oracle XML packages to load data into the software.
• Performed subsequent alterations using SQL, PLSQL to make any changes on adhoc requirements.
• Developed various queries using views, correlated sub queries, joins, merge and grouping/ aggregation functionality.
• Incorporated business logic and computation methods using stored procedures and functions.

Confidential

PL/SQL Developer

Environment: Oracle Database 9i, SOLARIS OS, TOAD, PL/SQL developer, SQL*Loader, Stored Procedures.

Responsibilities:

• Data Mediator, SGw - Statistical Gateway, SMIA - Statistical Measurement and Initiation, etc., these are the Performance management applications on OSS-RC through which performance are monitored for different network element over a period and result set are computed to ensure accuracy.
• Used ORACLE 9i SQL queries for computing precision and accuracy parameter on ENIT-STAT tool that holds result set obtained from various applications like Fault Management(such as ALV, ASM, IMIM, and ALB) & Configuration Management(such as IMS-CM, MMCM,GPRS-CM) and Performance Management with measurable criteria.
• Developed PL/SQL procedure, triggers, functions for mapping and manipulating various results set obtained from different network topology.
• Data repository are designed, structured and maintained for various network elements and their performance database and logs are monitored.
• Core knowledge and experience on SQL for SQL* Reports.
• Usage of various Built-In PL/SQL packages based on requirements.
• Involved in automation scripting with UNIX and Perl scripting for automating different OSSRC application, log collection and used SQUISH tool for automating regression test cases.
• Also involved in upgrade of emergency corrections on the server and server upgrade for RV Deliverability server.