SUMMARY

• About 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical) and in Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
• Good experience of Performance AnalysisandSQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans and Explain Plan.
• Confidential has over 8 years’ experience in the IT field entirely on the Data warehousing platform on Oracle Technologies, extensive knowledge and experience in Oracle 11g in windows and Unix environment.
• Database Analysis, development and support the projects usingOraclePL/SQL and Unix Shellscripting
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation and maintenance.
• Experience working in both Waterfall model and Agile methodology.
• In - depth Knowledge of Schema Objects (Tables, GT Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database links) and Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling.
• Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document.

TECHNICAL SKILLS

Operating Systems: Win 2003 XP 2000 NT Win-7, MS DOS, UNIX

Data Bases: ORACLE10g, 11g, MS-SQL Server 7.0, MS-Access, Teradata V2R13

Languages: C-language, C++, HTML,JAVA, PL/SQL

Utilities: SQL*Loader, Export/Import, Explain Plan.

Tools: PL\SQL Developer, SQL* Plus, Toad, Teradata SQL Assistant, Ervin,Eclipse, JDeveloper, Export Builder, ETL Informatica,, iSQL*PLUS, Jira.

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

Sr. PL/SQL Developer

Responsibilities:

• Primary responsibilities include estimation, design, development and maintenance of applications
• Creating PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Identifying query performance and resolved them in given service level agreement level
• Identified and modified the existing SQL stored procs, to suite underwriting requirement
• Created entity relationship diagrams for the new/modified tables/views/materialized views using Erwin
• Involved in creating ETL model, normalizing and documenting.
• Working on ETL (Extraction, transformation and loading) using PL/SQL to Extract, transform and load data into data warehouse (EDW System).
• UNIX shell scripting for creating new Programs and utilities, updating existing capability as per business request. Also doing migration and deployment of code through a version controlling tool Harvest.
• Process Monitoring in the current production environment and provide the resolution of any job/batch failure.Performing Root Cause Analysis for any issue happed in Production system and submit the report.
• Compile and build Reports using complex queries as per client request as a part of production support using Toad and Smartlook Query Designer application.
• Provide technical guidance to the team, in day to day application support. This includes working with stakeholders to identify and define new features, writing specifications, developing the code, testing functionality, and rolling it out to users.
• Build software enhancements, troubleshoot problems, and correct software defects.
• Perform code reviews and review modified programs, Manage Code Unit and Performance Tests.
• Data integration into fact or lookup tables and assist with availability of data sets.

Environment: Oracle 11g PL\SQL, Packages and Triggers, DDL scripts.

Confidential, Toledo, OH

PL/SQL Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Created entity relationship diagrams for the new tables/views/materialized views using Erwin
• Did performance testing and tuned the query to make it faster using Explain Plan and TkProof utilities.
• Created new scripts to schedule jobs in unix server and deployed the application in Unix box.
• Development of trustee server, which hosts a database for the users authorization information.
• Implementation of an interface to the shopping server, so as to receive authorization request and send back acknowledgement.
• Compile and build PL SQL queries in Toad.
• Design and develop the backend business logic and data access.
• Perform code reviews and review modified programs
• Manage Code Unit and Performance Tests.
• Assist with managing End-to-End System and Operational Readiness Testing
• Assist with the environment setup and availability of data sets.
• Coordinate regression tests and issue resolution withdevelopersand executors
• Process Coordinate scheduled and ad-hoc migrations with test programmer.

Environment: Oracle 10g, PL\SQL, XMLDB, SQL tuning, stored procedures, functions and triggers.

Confidential, Dallas, TX

Oracle Developer/Analyst

Responsibilities:

• Develop generic process flow logging and error logging module to track process flow and log runtime errors
• Reverse engineering existing Informatica workflows, sessions and mappings, document process logic for future reference. Data mapping for ETL.
• Built process to write CSV files to load in third party applications and Parse CSV files using EXTERNAL TABLES and load them
• Work with business users to understand reporting requirements and develop reports as per the user specifications
• Identifying bottlenecks in existing processes using DBMS HPROF and TKPROF, optimizing performance using forced hints and rewriting PLSQL logic
• Develop on demand refreshed materialized views to reduce network latency in distributed SQL queries
• Procuring existing documentation for knowledge transfer projects from share point, code repository like CVS and Clear case of legacy system.
• Enhance Range Partitioned tables to use Interval Partitioning feature rolled out with 11g latest release
• Developed DDL’s to add indexes on tables to improve performance of SQL queries
• Developing the PL/SQL script to extract data from database
• Develop scripts to deploy jobs using oracle DBMS SCHEDULAR to gather statistics on regular intervals to get better Execution plans

Environment: Oracle 10g/9i, TOAD, SQL plus,Unix, Informatica.

Confidential, Reston Virginia

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing of Dimensional model (Start Schema), Preparing ETL standards, Naming Convention and ETL flow documentation
• Developed ETL for data extraction, transformation and loading from legacy system into Teradata database using data Mapping, Conversions, PLSQL and shell scripts
• Develop DDL to Create schema objects like table, views, external tables, stored procedures, triggers, database links and non-schema objects like Directories, restore points to use Flashback
• Develop queries to fetch data from remote database using database links
• Involved in Configuring Crystal reports 10 with Oracle database and Developed several reports for monthly and yearly statements
• Develop scripts in Shell to automate jobs in and schedule resource intensive jobs and log detailed results
• Plan to gather stats, collect histograms for columns with high cardinality for tables with high data manipulation operations when low resource intense jobs are running and monitor performance
• Responsible for application unit testing, production Support, Version Control, Production Staging, implementation, Planning and Training

Environment: Oracle PL/SQL, Teradata, UNIX, Shell Scripts