SUMMARY

• About 6+ years of experience in application software as Oracle PL/SQL Developer by involving in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and support/maintenance
• Extensive experience in Analysis and Design of Database.
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Strong experience in designing and developing oracle objects Tables, Views, Indexes, PL/SQL Stored Procedures, Functions, Packages, Triggers.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Dynamic SQL, Analytical functions, PL/SQL Collections, Bulk Collections, Nested Tables, VARRAYS, Records, Type.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
• Skilled in creating dynamic and customized packages for ETL from various data sources
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specification.
• Experience in utilizing methods like External Tables, MERGE statement, and Pipelined functions.
• Proficiency in working using Analytical functions and oracle supplied packages like UTL FILE, DBMS LOB, DBMS JOBS, DBMS SQL, UTL FILE and DBMS SCHEDULER packages.
• Performance Tuning & Query Optimization of SQL statements
• Comfortable with working with Composite Data Types
• Experience in Debugging, Testing, and Deploying the Applications
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Expertise in working with Oracle 10g/11g, TOAD, SQL * Loader, Forms 11g/10g/6i and Reports 11g/10g/6i for both development and customizations as per client specifications.
• Experienced in environments requiring direct customer interaction during design specification, development, and product implementation phases.
• Worked on production support, troubleshooting the application and resolving bugs.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter - personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS

Databases: Oracle 11g/10g, SQL Server 2008, MS Access

Developer Tools: Oracle Developer Suite 11g/10g, SQL Loader, SQL* Plus, Forms/Reports 11g/10g/6i.

Operating Systems: Windows 7/XP, UNIX(Solaris, HP-UX), Redhat Linux

Programming Languages/Utilities: SQL,PL/SQL, Shell Scripting, HTML, C, C++,Java, Java Script, XML

Third Party Tools: TOAD, Pl/Sql Developer, Win-SCP, Putty, Erwin, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Sr. Oracle Pl/Sql Developer

Responsibilities:

• Requirement Gathering: Worked with client to gather the requirements for converting data to new databases.
• Design Documentation: Created detail system design documents according to the requirements
• Translate Requirements: Translated the requirements through technical work plans to facilitate the build.
• Data Modeling: According to requirement and business needs to support the application changes that are made to the existing application by adding new tables and clearing the unrequired data.
• Data Model Changes: Submitting data model changes according to the requirements.
• Build: Built complex Pl/sql stored procedures and Sql queries to convert data or push data from one database to other.
• Version Control: Used Tortoise SVN to maintain version of the build/code.
• Job Scheduling: Scheduled the jobs during integration run using Autosys.
• Tuning: Tuned SQL queries for better performance and identifying bottlenecks for long running queries.
• Optimize Query Performance: Done the query optimization by creating indexes and hints.
• Integration Run: Loading source data, creating conversion database, creating user schema schedule jobs to insert data into target tables, run masking to protect data during testing, creating dump files and exporting them different environments.
• Supporting Development and Testing: Generated test cases for unit testing, integration testing, system testing and user acceptance testing.
• Enhance existing pl/sql packages to fix data quality issues and address bug fixes.
• Data extraction from files to intermediate tables using UTL FILE/DBMS FILE TRANSFER.
• Atomized loading large data from flat files into database using Sql*Loader.
• Designed and developed technical solutions like Forms/Reports, Customizations, Interfaces and Data migration.

Environment: Oracle 11g, Version Controller, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows 7

Confidential, Peoria, IL

Oracle Pl/Sql Developer

Responsibilities:

• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Worked extensively onRef Cursor, External TablesandCollections.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Implemented Materialized view as part of improving the performance of the application.
• Analyzed tables and indexes for cost based optimization (CBO) to work efficiently.
• Extensively used Bind Variables and Dynamic SQL to improve application performance.
• Used the advanced features of PL/SQL like Arrays, Records, Nested Tables, Bulk collect and Dynamic SQL
• Created Ad-hoc queries to generate data for business analysis.
• Created Batch Job Interfaces for data cleaning, processing and loading using shell scripts and SQL Loader.
• Created Batch Job Interfaces using Unix Shell Scripts and PL/SQL for daily file transfers using FTP and SFTP.
• Was part of Job scheduling for Snapshot tasks like inserting history data into history tables when the original tables are overloaded and the data needs to be moved.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Wrote extensive Exception handling procedures to handle exceptions.
• Have worked on testing the database after the patch (Gathering table stats, refresh table stats, recreating the indexes, etc.).
• Created database Triggers for the security purposes.
• Worked on indexes, rebuilding indexes online, invisible indexes, parallel hint.
• Made use of cursors in procedures to generate high performance queries and PL/SQL code.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Created Materialized views and Materialized view logs.

Environment: Oracle 11g/10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX/LINUX, Windows 7

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Used Oracle 10g features such as merge for various transformations.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages using SQL and PL/SQL for the Audit Trail using Oracle 10g as backend.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Creating Test scripts for the generated final Reports.
• Attended meetings and review to discuss current issues and processes to tackle issues.

Environment: Oracle 10g, SQL Server 2008, SQL * Plus, TOAD, SQL*Loader, Shell Scripts, UNIX, Windows 7/XP.