SUMMARY

• 8 years of experience as OraclePL/SQL developer in Analysis, Design and Implementation of Oracle E - Business Suite Applications
• Involved in all phases of teh SDLC (Software Development Life Cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance with timely delivery.
• Expertise in writing Packages, Stored Procedures, Functions, Views, Database Triggers using SQL and PL/SQL in Oracle.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Proficient knowledge in HTML and JavaScript.
• Specialized in writing NZSQL, NZLOAD and stored procedures
• Extensive experience in Netezza database design and workload management
• Experience in managing users and user groups in Netezza
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Created materialized views like primary key, rowid, and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Good understanding of teh Oracle database, related utilities and tools.
• Have extensive experience in Performance tuning by analyzing teh execution plans of teh query
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Excellent technical and analytical skills with clear understanding of OLTP and OLAP models.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.

TECHNICAL SKILLS

Operating Systems: Windows XP/7/8, UNIX, LINUX

Languages: SQL,PL/SQL, NZSQL and NZLOAD

Databases: Oracle 12c/11g/10g, NetezzaTwinfin/striper

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, SQL*Plus, SQL*Loader

Development Tools: Aginity, SQL Developer, PLSQL Developer and TOAD

Scripting Languages: Java Script, UNIX Scripting, shell Scripting, SQL and PLSQL

Web Technologies: HTML, Websphere and XML

PROFESSIONAL EXPERIENCE

Confidential, KY

Sr. Oracle PL/SQL / Netezza Developer

Responsibilities:

• Coordinated with teh front end design team to provide them with teh necessary stored procedures, functions, packages to view appropriate data at GUI.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Created new mappings, modified existing mappings using InformaticaPowercentre9.1
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving teh data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancements in teh application using TOAD.
• Createdindexes on teh tables for faster retrieval of teh data to enhance databaseperformance.
• Created dataload process to loaddata from OLTP sources into Netezza
• Designed table structure in Netezza
• Created external tables in NZLOAD process in Netezza
• Created Netezza stored procedures with complex business rules
• Experience in table distribution methods in netezza
• Knowledge in Netezza internal storage mechanism
• Knowledge in how zonemaps works
• Created test packages to validate all new and existing procedures and functions in Unit Testing Phase.
• Involved all SIT, QA, UAT and Production deployment.
• Handled errors using Systemdefined exceptions and Userdefined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Developed Rowlevel and Statement level Triggers for auditing tables in PL/SQL.
• Written Shellscripts to automate loading teh files into database using Crontab.
• Developed Views and Materialized Views for specific data retrieval for teh reports.
• Used Oracle supported DBMS STATS, DBMS JOB packages to gather teh statistics and schedule job respectively. Also used DBMS METADATA.GET DDL package to describe table structure.
• Used %TYPE and %ROWTYPE for anchoring teh variables to teh database data types.
• Worked with BulkCollects to improve teh performance of multiple-row queries.
• Made used Sub-query (WITH clause) to make complex SQL statements simple and make them more efficient.
• Created batch jobs to load data into our database using UNIX Shell Script and Control - M scheduling.
• Created adhoc reports to users in Tableau by connecting various data sources.

Environment: Oracle 11g/12c, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, AIX, Windows XP, Netezza, Informatica 9.1, IBM Clearcase

Confidential, MD

Medicaid Claims Adjudication System Sr. Oracle PL/SQL / Netezza Developer

Responsibilities:

• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance teh performance.
• Extensively usedbulk collectionin PL/SQL objects for improving teh performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Designed Technical design document based on teh business requirements.
• Created NZLOAD process to load data into datamarts in Netezza
• Created table structure for datamarts in Netezza
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used teh advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Handled errors usingException Handlingextensively for teh ease of debugging and displaying teh error messages in teh application.
• Written PL/SQL Cursors for transaction processing.
• Used Bulk collect feature to process teh data from Cursor/Ref Cursor.
• Developed Unix Shell Scripts and DBMS Jobs to automate jobs and loading data into teh Database using SQL* Loader.
• Worked extensively with teh universe team and database team and users to analyze teh gaps
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Upgraded teh existing database from Oracle 9i to Oracle 11g.
• Involved inLogical & Physical Database Layout Design.
• Created queries to minimize transactions table data size and copy into historical tables.
• Modified exiting UNIX Shell Scripts to schedule daily jobs.
• Improved teh performance of teh application by rewriting theSQL queries.
• Involved application deployment process and co-ordinate with DBA Team.

Environment: Oracle 10g/11g, PL/SQL, TOAD, Sun Solaris, AIX, Netezza, informatica, SVN

Confidential, KY

Financial Data Repository Sr. 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 and production support.
• Managing FDR applications and handling day to day support of teh batches using job scheduler Tidal.
• Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
• Create new Tables, Indexes, Views, Materialized Views, Table Partitions as per teh requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per teh requirement.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE
• Wrote complex stored procedures and packages
• Used FDR Scenario Manger to create new AML scenarios, writing complex queries Oracle.
• Developed daily, weekly, monthly Reports for alerts generated and scheduled Jobs.
• Worked on UNIX scripting for scheduling teh jobs.
• Created and monitored teh OracleDBMS JOBS as a part of weekly tasks.
• Involved in fixing bugs within Packages and Stored Procedures.
• Involved in all production support tasks and have working knowledge of Reporting Tool like Tableau.
• Involved in Tuning Database & Application performance using Explain Plan.
• Involved in teh Daily maintenance of teh database dat involved monitoring teh daily run of teh scripts as well as troubleshooting in teh event of any errors in teh entire process.
• Performed Unit Testing and Integration Testing of teh Application. Involved in preparing documentation and user support documents.
• Wrote ad-hoc queries to generate reports for business users.
• Extensive analysis and reasoning of alerts generated by teh system.

Environment: Oracle 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty and informatica.

Confidential

Vodafone DISHA Oracle PL/SQL Developer

Responsibilities:

• Interacted with teh users for understanding and gathering business requirements.
• Involved in teh analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such dat they perform well.
• Used advanced features of SQL in order to design and tune SQL to interface with teh Database and other applications in teh most efficient manner and created stored Procedures for teh business logic using SQL.
• Used indexes to enhance teh performance of individual queries and enhance teh Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning.
• Designed, developed and tested stored procedures, views and complex queries for Reports distribution.
• Developed database triggers and stored procedures using SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Created packages for transforming data from various data sources.
• Tuned SQL queries using execution plans for better performance.

Environment: Oracle 9i, Windows 2000/NT/XP, TOAD.