Objective:

Over 7 years of experience in the IT Industry with proficiency in Design and Development of SQL, PL/SQL, UNIX shell scripting and Autosys Projects. Complete understanding of Performance Monitoring and analysis of Products, Web-based and client/server-based systems on multiple platforms. Strong experience in analysis, design, development and deploying Business solutions using Oracle Technologies. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

Summary:

• Experience in requirement analysis, system design, development and testing of various Software applications.
• Expertise in Oracle10g, Tables creation, Stored Procedures, Triggers, Views, Functions Programming, Autosys, SQL loader.
• Expertise in UNIX Shell scripting.
• An Oracle developer with extensive experience in data transformations, conversion and interface, data loading, database modeling and performance tuning.
• Strong Coding and Designing Experience in Oracle PL/SQL SQL.
• Extensive experience in Oracle Back-end server-side PL/SQL Development i.e. Packages, Stored Procedures, Functions Triggers using SQL Developer and Toad as development tools.
• Good Knowledge on Fermat ORDBMS Architecture.
• Extensive experience in Performance Tuning of SQL queries Views using Explain Plan, SQL Trace TKPROF utilities.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Extreme experience in using SQL Loader for loading data into single table and multiple tables.
• Experience in developing External Tables, Joins, indexes and Database Triggers.
• Extremely used of the latest features to optimize performance like Bulk Binds, Bulk Collect, Ref. Cursor and Sys ref cursor.
• Proficient in using advance features for PL/SQL programming like Using cursor variables, Ref. cursors, System Ref. cursor and Dynamic SQL.
• Extreme Use of exception handling methods along with pragma exception init in order to associate our own created exception names.
• Experience in creating Global Temporary Tables.
• Hands on experience with Materialized views and Bulk loads.
• Experience in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables, normalization and de-normalization.
• Strong technical hands on experience in Oracle 10g/9i/8i databases.
• Involved in writing Test cases, doing smoke test as testing framework.
• Worked all phases of Software Development Life Cycle SDLC Requirement analysis, Specification, Implementation, testing, Documentation and Process management.
• Strong experience in PL/SQL, SQL, writing stored procedures, triggers, functions, packages and exposed to various databases
• Strong in Designing, Development coding , Testing, Implementation and Documentation as per Industry standards.
• Experienced in a Banking Industry.
• Committed to learning new technologies.
• Good organizational and prioritization skills.
• Working experience in Production, Development, Staging and QA environments.
• Exceptional ability to quickly master new concepts and capable of working in-group as well as independently with excellent communication skills.

Technical Skills:

• Skill-Profile : SQL, PL/SQL, VB, UNIX Shell Scripting.
• Operating System : Windows NT, Linux, UNIX and Sun Solaris.
• Databases : SQL, PL/SQL, Oracle 8i/9i/10g, MS SQL Server, MS-Access.
• Version Control Mgmt. : Harvest
• Tools : TOAD, SQL Developer, Autosys, Microsoft Office products Word, Excel, PowerPoint , HARVEST, Quality Center. SQL Loader.

Professional Experience:

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering the requirements by conducting meetings and prepared the technical design documents.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, DB triggers, Indexes and Collections.
• Developed database triggers for automatic updating the tables and views.
• Involved in development of User Interface Objects Forms9i and Reports9i and Testing of entire module.
• Analysed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Developed Database objects like tables, Indexes, triggers for Reporting Database.
• Involved in migrating forms from 6i to 9i using migration assistant.
• Documented all the packages, procedures and functions involved in ETL process.
• Maintained performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, SQL Trace and TKPROF, Indexes and Clusters.
• Created reports using data providers like universes, freehand SQL.
• Used PL/SQL collections, Bulking techniques, Table Partitioning to increase database performance.
• Good in optimizing SQL queries by reading Explain plan statistics.
• Used SQL Server Business Intelligence to make SSIS packages as part of ETL process.
• Implemented SQL Loader direct path option for bulk inserts into database.
• Designing new universes and modify existing universes using features like aliases, loops, contexts, joins. Creating dimensions, measures and detail objects which are grouped into classes.
• Involved in Unit testing the Oracle developed scripts.
• Modifying existing scripts for query performance using TOAD.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan

Environment: Oracle10g, SQL, PL/SQL, UNIX, Toad, Sql Loader, Forms 9i, Reports 9i, Business Objects XiR3, UNIX Shell Scripting, Microsoft Office Tools.

Confidential

Role: Lead Database Developer

Description:

• Confidential an American multinational telecommunications corporation, headquartered at Confidential. Confidential is the second largest provider of mobile telephone and the largest provider of fixed telephone in the United States, and also provides broadband subscription television services.
• Work in Agile-Scrum environment, coordinating in a big group 20 people located in multiple locations and time zones On-shore, near-shore, off-shore model .
• Interact with the business specialists every Sprint in identifying the code defects, and providing fix by performing root cause analysis
• Transform business requirements into Technical specification, involved in root cause analysis, database design, coding and implementing, Unit as well as Regression testing
• Load Billions of rows from multiple kinds of sources e.g National Data Warehouse Teradata, Biller system - Oracle, CPOS SQL Server into oracle tables using DB Link, external table, SQL Loaderas well as ETL tool Pentaho
• Tuned SQL queries using EXPLAIN PLAN, Optimizer Hints and Indexes simple as well as Composite
• Improved performance of large database 10 TB by creating index, partitioning tables, indexes, creating and tuning Materialized Viewsetc.
• Frequently used MS excel like Pivot tables, charts, VLOOKUP for reporting purpose
• Advanced Oracle and PL/SQL features like Collections, Bulk collect, Dynamic SQL, Analytic functions e.g. row number, rank etc. in the new routines as well as to modify the existing routines work more efficiently
• Load data to salesforce.com DB through complex Pentaho-Kettle job, transformations for advanced analytics
• Regularly involved in Testing, Integration, production deployment and documentation of the project

Environment: Oracle-11gR2, TOAD-11.5, SQL Developer-3.1, Windows 7, MS Excel 2013, Pentaho 4.4, Eclipse 4.3.2, Cygwin 1.7, Tortoise SVN

Confidential

Role: Senior PL/SQL Developer

Responsibilities:

• Successfully led, mentored, and supervised team of 6 developers in designing, customizing, developing, deploying, tuning, and supporting Inventory Management.
• Participated in Requirements collection, designing and development.
• Implemented various processes, strategies and automations in prepaid systems, for the enhancement and better performance.
• Application Development using Oracle Forms 10g.
• Developed Reports by extracted data from Flat files, Oracle, DB2 and SQL server sources to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Developed Database triggers to ensure Data Integrity and additional Referential Integrity.
• UTL File Packages used for interface programming.
• Implemented Exceptional Handling mechanism in Procedures for the ease of Debugging and displaying the error messages.
• Created Database links to retrieve data from multiple servers.
• Responsible for uploading and downloading flat files from UNIX Server using FTP.
• Created Indexes on the Tables for faster retrieval of the data and to enhance Database Performance.
• Utilized Rational Clear Case for Version Control.
• Prepared complex SQL Queries including Inline Queries and Sub Queries for faster data retrieval from multiple Tables.
• Created Materialized Views for accessing data from other databases that refreshes in certain intervals of time.
• Developed complex PL/SQL Procedures with multiple Loops Simple/ For/ While Loops using Implicit and Explicit Cursors.
• Generated code using Database techniques like PRAGMA types Atonomous Transactions, Exception Init .
• Engaged in Database Recovery process using DBMS FLASHBACK packages.
• Familiarized with Database Collections Associative Array, VArray and Nested Tables .
• Explored various Database Hints for optimizing Query Executions.

Environment: MS SQL Server 2008, Excel 2007, T-SQL, SQL Loader, TOAD, PUTTY, SQL Trace, Oracle Forms 10g,TKPROF, UNIX Shell Scripting

Confidential

Oracle PL/SQL Developer/Lead

Description:

Confidential is one of the leading banks in the world with a base in US and spreading its services across the world. Confidential is also a leading Mortgage Company. The database links static historical data with actual client performance and acts as a comprehensive information warehouse that gathers stores and analyzes the data necessary to facilitate target marketing and risk management decisions in its Financial Risk Warehouse FRW .

Responsibilities:

• Participated in Requirements collection, designing and development.
• Created PL/SQL packages using collections like Nested tables and Varrays.
• Created PL/SQL packages using ref cursors and dynamic SQL.
• Created database Triggers for inserting primary keys and auditing of user records.
• Developed Unix Shell Scripts and called from PL/SQL packages.
• Developed Custom Menus using Menus and menu items in OracleForms.
• Improved PLSQL program unit's performance by tuning PL/SQL.
• Usage of bulk inserts to insert the data into multiple tables.

Environment: MS SQL Server 2008, Excel 2007, T-SQL, SQL Loader, TOAD, PUTTY, SQL Trace, Oracle Forms 10g,TKPROF, UNIX Shell Scripting.

Confidential

Team Lead, SQL, PL/SQL developer

Description: Confidential is a comprehensive Confidential addressing the entire gamut of operations of a bank including Retail and Risk Management activities. It is based on client server technology and Branch Banking, Credits, Asset management NPA , User security and Standing Instruction. Some of the features are Signature/Document scanning and retrieval, Tele-banking, ATM interface, Any Branch Banking etc.

Responsibilities

• Written PL/SQL stored procedures for converting the bank's legacy data to the retail banking format.
• Involved in ETL activities like Data extraction, Transformation logic as per business rule using PL/SQL stored procedure, data mapping, cleansing, standardizing
• Verifying business object documents, database design documents. ER Diagrams and maintaining database objects.
• Revisit stored procedures/views for identified client needs.
• Written ad-hoc SQL queries, for testing end-to-end process.
• Escalate critical issues to seniors to take necessary actions.
• Involved in QA, implementing the application, doing parallel run and day to day support activities.
• Developed new modules using the application frame work, business frame work in n-tier architectures.
• Involved in Enhancements and Customization of modules.
• Given demonstration and user training to end user.
• Environment: PowerBuilder 6.5, Windows 95/98, Novell Netware 3/4.x, Erwin Database: SYBASE SQL Anywhere 5.5.x