SUMMARY

• Above 8 Years of Experience in teh field of Software Design, Development and Implementation wif Proficiency inOracle and 11gR2,SQL,PL/SQLdat includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQLandPL/SQLinOracle.
• Proficient in advance features ofOracle11g forPL/SQLprogramming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and DynamicSQL.
• Has experience on security setup using Active directory integration.
• Worked wif query tools like Toad,SQL*Plus,SQLDeveloper.
• Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization ofSQLstatements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Experience in translating business requirements into creation of Database Objects.
• Experience wif Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in migration and conversion from MS Access/SQL - Server toOracle.
• Strong in writing Stored Procedures andSQLqueries.
• Proficient in data loading/extraction usingSQL*Loader andOracleutilities.
• Good understanding of theOracledatabase, related utilities and tools.
• Has extensive experience in Performance tuning by analyzing teh execution plans of teh query.
• Hands on experience in tracking down teh bottlenecks in query using trace files.
• Extensive experience in utilizing Collections to boost performance inPLSQLblock.
• Participated in all Business Intelligence activities related to data warehouse, ETL and report development methodology.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Experience in working wif quality assurance and version controlling tools
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team wif excellent problem solving and troubleshooting capabilities.
• Ability to learn new tools, concepts and environments.
• Ability to explain technical concepts and communicate wif users and system administrators at all levels. Strong experience in mentoring team members and writing documentation.

TECHNICAL SKILLS

Databases: Oracle11g2, 11g, Oracle 10g R2, 10g

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows 95/98/XP, Windows 8.0/8.1, UNIX

SQL Server Tools: Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Advisor

Reporting Tools: Oracle reports and forms

Third Party Tools: TOAD, SQL Developer, SQL Loader.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Analyze teh functional & technical requirements of teh project.
• Discuss wif business users, BA's and Architects to finalize requirements and scope of teh project.
• Design teh Database and reports for teh new enhanced COMPASS.
• Design and provide Database service call to UI team.
• Create new tables, views, materialized views, Packages, Stored Procedures and functions as per requirements.
• Perform code review and make changes/improvements as required.
• Optimize teh code to meet SLAs wif UI. Used Hints like materialize, parallel, no parallel, etc., to improve teh performance.
• Maintain SVN repository, deploy code base to SIT, UAT, dry-run environments as requested.
• Plan production deployment activities, ITSM processes, raise RFCs and coordinate wif various teams like DBAs, Unix etc.
• Used PIVOT, UNPIVOT, LISTAGG and many functions inOracle11G to transform complex source data as per mappings.
• Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Created variety of visualizations and dashboards according to business requirement specifications.
• Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing wif systemdevelopersto ensure overall functionality and technical quality of deliverables.
• Ability to trouble shoot technical issues and problems, monitor progress against plan, and communicate status to Leads.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Developed back end interfaces usingPL/SQLPackages, Stored Procedures, Collections.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Designed Database Triggers for audit and validation purpose
• Migration fromOracle10g toOracle11g.

Environment: Oracle11g,PL/SQL,PL/SQLDeveloper, UNIX.

Confidential, Princeton, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views andSQLscripts usingPL/SQL.
• Created UNIX shell scripts to automate table creation, execute procedures by using CRONTAB.
• Involved in performance tuning which included creating indices, table partitioning,SQLhints using explain plan utility.
• Involved in developing and maintaining control files forSQLloader to load teh data fromSQLserver tooracledatabase tables.
• Involved in functional and technical documents.
• Worked on queries using TeradataSQLAssistant to connect various ODBC sources.
• Worked wif DBAs to help them in data loading process, batch jobs and various administration tasks.
• Responsible for data mapping and creating Run-Books from legacy system tooracle.
• Extensive experience in working wif different FTP clients such as WinSCP for extracting data from sources to own destination.
• Created synonyms and make sure dat users has executable permissions on all objects.
• Performed re-org for several dimension and fact tables for space release management in data warehouse.
• Developed Functions and Procedures to load data into teh core tables.
• Made use of SQL Loader in loading data from upstream to teh project staging table.
• Extensively used cursors, sequences and indexes in teh procedures.
• CreatedPL/SQLbased ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Involved in Code Reviews for Logical errors.
• Used Exception Handling to handle runtime & user defined exceptions.
• Participated in weekly meetings wif teh client and update teh status
• Responsible for monthly ETL inSQLserver which are used by teh users for reporting.
• Used SQL Loader to load teh flat files data into teh core database tables.
• Created stored procedures for daily database space monitoring.
• Developed PL/SQL procedures which are used in Informatica Mappings.
• Wrote dynamicSQLqueries in different procedures and packages to work on PIVOT function.
• Worked extensively on Exception handling to trouble shoot thePL/SQLcode.
• Involved in automation ofSQLserver jobs dat are performed manually which involves MS ACCESS.
• Worked in production support environment which involved in performing operation such as monitoring jobs, performing root cause analysis, troubleshooting teh issues, monitoring top activity and long running queries, performance tuning and space management.
• Created and modified several UNIX shell scripts according to teh changing needs of teh project and client requirements.

Environment: Oracle10g/11g,SQL*PLUS,SQLLOADER,PL/SQLDeveloper, UNIX Shell script,SQLserver 2008, MS Access, MS office.

Confidential, NYC, New York

Oracle PL/SQL Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Developed back end interfaces usingPL/SQLstored procedures, packages, functions, Object Types, DB triggers, Indexes and Collections.
• Developed teh control file to load data from flat files obtained from various interfaces using SQL*Loader.
• Creating several UNIX shell scripts according to teh project and client requirements.
• Writing Unix Shell Scripts to process teh files on daily basis like renaming teh file, extracting date from teh file, unzipping teh file and remove teh junk characters from teh file before loading them into teh base tables.
• GeneratingPL/SQLscripts for data manipulation and validation and created scripts to create new tables, views, queries for new enhancement in teh application using TOAD.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of teh system.
• Involved in accomplishing automated data extraction from various RDBMS via scripts, ETL in database usage and especially in data warehousing.
• Involved in development of User Interface Objects (Forms10g and Reports10g) and Testing of entire module.
• Analyzed, designed and developedOracleforms 10g/11g queries, layout, report triggers, parameter form, data models etc.
• Hands on experience working wif error handling and performance tuning in TERA data queries and utilities.
• Developed Database objects like tables, Indexes, triggers for Reporting Database.
• Documented all teh packages, procedures and functions involved in ETL process.
• Maintained performance tuning by usingSQL-Related Performance Tools like EXPLAIN PLAN,SQLTrace and TKPROF, Indexes and Clusters.
• Worked inOracleCursor, Exception Handling, Collections like REF, Nested tables, VARRAYS & IOTs.
• Create reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Created reports using data providers like universes, freehandSQL.
• Good in optimizingSQLqueries by reading Explain plan statistics.
• Used UNIX Shell scripts to deploy theOracleforms and reports to production servers.
• ImplementedSQL*Loader direct path option for bulk inserts into database.
• Involved in 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.
• Modifying existing scripts for query performance using TOAD.
• Involved in Technical Documentation, Unit test, Integration test and writing teh Test plan.

Environment: Oracle10g,SQL,PL/SQL, UNIX, Toad,SQL* Loader, Forms 10g, Reports 10g, UNIX Shell Scripting, Microsoft Office Tools.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in teh database design for better understanding teh relations, associations and dependencies wifin teh data base.
• Involved in writing functional and technical documents.
• Used teh merge statements to select rows from one or more sources for update and insertion into one or more tables.
• UsedPL/SQLcollections (Nested Tables and Varray) in complex backend packages.
• Coded UNIX shell scripts to callSQLscripts and to manipulate teh returned data.
• Developed test plan documents for all back end database modules.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Wrote Database triggers for audit and to implement complex business logic.
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• GeneratedSQLscripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modifiedPL/SQLpackages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
• CreatedPL/SQLprogram units to implement DML, DDL statements using dynamicSQL.
• Wrote complexSQLqueries to retrieve information from teh database depending on user requirement.
• Wrote control files and loaded teh data intooracledatabase wifSQL*Loader
• UsedPL/SQLDevelopertool to do teh backend development.
• Implemented enhancements to teh application by creating and modifying teh packages, procedures, functions and triggers.
• Analyzing teh daily tracked transactions which were been reported and rectifying teh errors.
• All teh relevant issues were been tracked and their corresponding status were reported to teh users and clients.
• Wrote complexoracleSQLusing joins, sub queries and correlated sub queries.
• Implemented Materialized View for extracting teh data from remote database.
• Handled various Exceptions to trouble-shootPL/SQLcode.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked on teh new CR’s as per client requirement.
• Integrated new down streams step up for sending Benchmark data.
• Involved in writing scripts for inserting & deleting values to & from tables Checking constraints and dependencies of teh tables
• Integration of new series, files, indices and constituents.
• Made use of SQL Loader and UNIX Shell Scripts to load teh daily data in to IDMS database.
• Involved in code reviews
• Coordinated wif Client for any Production Issues and Code Changes
• Attended Project review meetings, Status Reporting, Issue tracking
• Developed SQL scripts for creating database objects such as tables, views, materialized views and sequences.
• Involved in modification of UNIX Shell Scripts.
• Prepared Database Documentation and Requirement specification document which TEMPhas teh requirement details provided by teh business users.

Environment: Oracle10g,PL/SQL, Report Builder 10.1.2.0.2, Toad 7.5.2.0, UNIX, Perl

Confidential

Database Developer

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Performed regular Database Maintenance task, checking teh disk Defrag procedures in Development environment.
• Participated in business requirement gathering and applying teh business logic at teh back end database. Teh business logic involves creating packages, procedures, triggers and tables.
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in writing Bulk Collects, Cursors, Ref Cursors, and Exceptions wifin teh various procedures.
• Designed batch jobs which are used in loading data into UNIX shell scripts.
• Involved in Performance Tuning and optimization of teh SQL queries.
• Creating Indexes and using hints in teh SQL queries. Optimizing teh queries using Explain Plan.
• Performed Indexing and Index partitioning on various huge tables to enhance teh performance of teh database.
• Resolved teh issue of mission critical tasks wif Severity 1. Achieved in resolving teh issues wifin teh given stipulated SLA time.

Environment: SQL, PL/SQL, SQL Loader, Oracle 10g, Oracle Reports, UNIX