SUMMARY

• Over 7+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL Developer.
• Expertise in SQL and PL/SQL programming and strong knowledge on Oracle architecture and database design
• Expertise in loading data from flat files to teh Database Tables usingSQL*Loader, External Tables, UTL Utilities
• Strong experience in designing and developing SQL Queries, PL/SQL packages, Functions, Stored Procedures, Views, Triggers and Cursors, Oracle objects Views, Materialized Views, Sequences, Synonyms, Database Links, and table - spaces
• Experience in advanced PL/SQL programming using Records, Collections and Bulk collect, Nested tables, Types, V-arrays involving in Landscape of Database
• Experience in client-server application development using Oracle 12c/11g/10g/9i/8i, Toad, SQL* Plus, SQL *LOADER and PL/SQL developer
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables
• Experienced in Unit testing and Integration Testing with excellent debugging skills
• Experience in query optimization, performance and tuning (PL/SQL) using SQLTrace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning
• Experience in developing SQL Loader control programs and PL/SQL validation scripts for validating teh data load from staging area to production.
• Sound knowledge in UNIX Shell scripting
• An expert withExcel/VBA and well aware of teh close relationshipExceland Oracle have
• Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse
• Experience on teh implementation of ETL Tools by using Oracle Warehouse Builder (OWB)
• Designed teh Data Warehouse/ ETL processes usingInformaticaPower Center 9.6 to extract, transform and load data from multiple input sources
• Experience on Data Warehousing, developing strategies for Extraction, Transformation & Loading (ETL) mechanism-usingTeradataand UNIX
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements
• Integrated Excel spreadsheets into Oracle using SQL*Loader
• Exposure to Waterfall, AGILE software development methodologies
• Sound knowledge in PHP, Python and programming proficiency in .NET
• Expertise in Java, Algorithms, data structures and problem solving skills
• Experience with Software development life cycle (SDLC) process - performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration
• Developed normalized Logical and physical database models to design OLTP system
• Good understanding in teh areas of Users, Roles, Privileges, Schema and Object management & Session monitoring
• Worked on production support, troubleshooting teh application and resolving bugs
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings
• Facilitated user training to build skills in teh advanced use of MicrosoftExcel

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, Java, UNIX/LINUX Shell Script

Database Tools: PL/SQL Developer, Toad, Oracle SQL Developer SQL*Plus, SQL*Loader, Oracle APEX, Oracle procedure Builder,ESP

Databases: Oracle 12c/11g/10g/9i and MySQL

Data Warehousing: Informatica Power center 9.x/8.x, Power exchange, Repository Manager, Workflow Manager, OWB, Oracle Data Integrator

PROFESSIONAL EXPERIENCE

Confidential, Mahwah, NJ

PL/SQL Developer

Responsibilities:

• Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL
• Involved in walk-through sessions with users during teh Analysis, Design, and development phase, written PL/SQL Stored Procedures, Functions, and Packages to meet teh requirements
• Loaded teh data into database tables using SQL*loader from text andexcelfiles
• Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them
• Developed scripts to create new tables, views, queries for new enhancement in teh application using TOAD
• Involved in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf and Indexing
• Worked on Korn shell scripts onUNIXplatforms
• Worked with Architects, Business Analysts, ETL developers, and QA testers to translate data requirements into teh physical schema definitions for Oracle
• Code review to ensure dat teh existing code is complaint with teh coding standards
• UNIX shell scripting was used for scheduling batch jobs. Teh system was used to run batch processes and reports dat utilized PL/SQL and Oracle Reports
• Converting teh existingInformaticamappings to SQL queries for teh data migration from Oracle
• Creating new process flow using SQL scripts to extract, transform and load teh data from different databases to Oracle
• Responsible for decreasing Load times ofDataWarehouse by optimizing ETL procedures using PL/SQL and Business ObjectsDataIntegrator
• Bug Fixing and Defect resolution from teh code logic using Oracle SQL Developer IDE
• Involved in Importing and exporting teh Tables, Users, and Schemas
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Triggers
• DevelopedUNIXShell scripts to automate table creation, execute procedures using dynamic SQL statements
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures
• Used Clear case tool to manage various versions of teh procedures and functions of teh application
• Provided Production Support, problem resolutions and bug fixing, actively involved in resolving teh issues and coordinating with business users and resolving teh issues

Environment: Oracle 11g, SQL, PL/SQL, SQL Navigator, PL/SQL Developer, FTP, Unix, OBIEE 11g, Informatica Power center 9.6, Oracle Data Integrator, Data Guard, IBM Rational Clear case tool

Confidential, Beaverton, OR

Oracle PL/SQL Developer

Responsibilities:

• Involved in teh meetings with Line of Business for requirements gathering and modified procedures according to teh business requirements
• Created and used Materialized views and DB links for remote instances to retrieve data from other databases
• Modified views, procedures and data objects to support data migration from new application.
• Involved in preparing technical documentation for development of code and process flow
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per teh Design Documents
• Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from teh existing application in teh form of flat files and load teh extracted data into teh new proposed application, as a part of migration
• Developed back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
• Developed teh code as per teh client's requirements using SQL, PL/SQL and Data Ware housing
• Designed and implemented client-server application. Developed various complex User Interface screens using Oracle Forms Builder 11g
• Experienced in teh use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum
• Experience in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF and Profiling
• Created and Modified existing functions and procedures based on business requirements

Environment: Oracle 11g/10g, SQL, PL/SQL, Oracle SQL Developer, Unix Shell scripts, Sql*Loader, TOAD, Informatica 9.5, Windows, Oracle Reports 10g, Oracle Forms 11g.

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

• Involved in analysis, design, development, and testing of teh application Agent Front End.
• Participated in database designing by developing teh logical Data Model for teh application
• Developed Procedures, Functions, Cursors, Triggers and Packages using PL/SQL Developer to implement business logic
• Developed Scripts for creating/altering of tables, indexes and sequences using PL/SQL
• Worked on Inbound/Outbound interfaces
• Developed Stored Procedures to extract variable data for POS documents
• Responsible for delivering different database objects to other environments
• Responsible for Data Extraction, Transformation, and Loading teh data into database tables using PL/SQL
• Provided transition documentation about teh system to teh new team
• Experienced in Tuning SQL statements and procedures for enhancing teh load performance in various schemas across database

Environment: SQL, PL/SQL, Oracle 11g, PL/SQL Developer, UNIX Shell script, Planet Press, MS-Office, Service Now defect Tracking System, HP ALM

Confidential

Oracle Developer/Analyst

Responsibilities:

• Involved in full Software development cycle of Analysis, Design, Development, Testing and Implementation
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions
• Upgraded data bases from Oracle 9i to 10g in different environments, implemented new features by retaining teh existing business rules
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based
• Worked on XML along with PL/SQL to develop and modify web forms
• Designed Data Modeling, Design Specifications and to analyze Dependencies
• Creating indexes on tables to improve teh performance by eliminating teh full table scans and views for hiding teh actual tables and to eliminate teh complexity of teh large queries
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization
• Used Discoverer 2000 to provide end users easy access to data and halp in data analysis
• Created custom reports and forms for teh end users to check teh details and errors

Environment: Oracle 10g, SQL*Plus, PL/SQL, Erwin, Oracle Designer 2000, Windows 2000, Toad, FTP, GIT, SQL Developer, TOAD, UNIX