SUMMARY

• 11+ years of total experience in Analysis, design, development, and testing of various business applications using Oracle SQL and PL/SQL.
• Worked extensively on various RDBMS like Oracle 11g/10g/9i/8i.
• Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, Ref), packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.
• Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Proficient in Oracle tools and utilities such as PL/SQL Developer, SQL Developer, SQL Navigator.
• Experience in Data Warehouse design, Data Modelling and Schema Design.
• Strong understanding of data warehouse design methodologies, data structures, data modelling and RDBMS concepts.
• Extensive experience in performance monitoring and tuning in Oracle.
• Experience in optimization of SQL statements using SQL Trace and Explain Plan.
• Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
• Deep understanding of Software Development Cycle (SDLC) and implemented various models like Spiral, Agile (XP, SCRUM) and Iterative models.
• Proficient in transforming data from various sources (flat files, mainframe,Oracle) to Data warehouse usingSQL*LOADER and External table.
• Adept Knowledge in variousOracleUtilities like UTL FILE, DBMS SQL, SQL*LOADER, DBMS JOB/DBMS SCHEDULER, etc.
• Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Experience in Microsoft SQL Server Reporting Services (MS SSRS).
• Experience in UNIX shell scripting.
• Experience in No SQL (Hive SQL) and MongoDB.
• Good experience in SQL Developer, PLSQL Developer, Aqua Studio.
• Basic knowledge in Python scripting.
• Interacted with Clients/Business partners, Project Managers to gather the Business Requirements and developed the technical specification document.
• Created simple and medium complex reports in MS SSRS and oracle data base stored procedures to pull data for reports.
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
• Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.
• Extensive experience in integration and configuration.
• Strong Trouble - shooting, Problem solving, Analytical & Design Skills.
• Experience in creating Batch jobs, daily jobs, one time jobs
• Excellent team player, self-motivated, will create excellent work environment around.
• Good communication, Analytical and presentation skills. Ability to provide timely solutions and work within specific time frames.

TECHNICAL SKILLS

Reporting Tools: SQL Developer, SQL * Loader, SQL navigator, Aqua studio.

Database: Oracle 11g, 12C, MongoDB.

DB Utilities: SQL*Loader, Export/Import, DBMS SQL, UTL FILE, DBMS Package.

Languages: SQL, PL/SQL, XML, C, C++, VB Script, Java script, Python scripting

Operating Systems: UNIX, Windows NT/2000/XP

Version Control Tools: SVN, GIT Hub

Job Scheduler: Automic UC4.

PROFESSIONAL EXPERIENCE

Confidential, NYC

Database Developer

Responsibilities:

• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and grant privileges to them.
• Created stored procedures, Functions to facilitate the functionality for various complex modules.
• Optimized and fine-tuned the SQL queries by using Explain plan.
• Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.
• Designed and Developed and maintained the complex oracle scheduler chains for the load process.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Providing on-call support for data warehouse applications.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Performed unit testing, integration and regression testing for various applications developed in data warehouse.
• Involved in helping the application teams to rewrite and fine-tuned the existing applications.
• Responsible for performing code reviews and code fixing after identifying the Defects.

Environment: Oracle 11g R2, SQL Developer, UNIX, SQL Loader, MongoDB, Python scripting.

Confidential, NYC

Sr. Oracle Consultant

Responsibilities:

• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and grant privileges to them.
• Created stored procedures, Functions to facilitate the functionality for various complex modules.
• Optimized and fine-tuned the SQL queries by using Explain plan.
• Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.
• Designed and Developed and maintained the complex oracle scheduler chains for the load process.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Performed unit testing, integration and regression testing for various applications developed in data warehouse.
• Involved in helping the application teams to rewrite and fine-tuned the existing applications.
• Responsible for performing code reviews and code fixing after identifying the Defects.

Environment: Oracle 11g R2, SQL Navigator, UNIX, Windows 7. MS Visio, SQL Loader, EXPLAIN PLAN.

Confidential, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and grant privileges to them.
• Created stored procedures, Functions to facilitate the functionality for various complex modules.
• Optimized and fine-tuned the SQL queries by using Explain plan.
• Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.
• Designed and Developed and maintained the complex oracle scheduler chains for the load process.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Performed unit testing, integration and regression testing for various applications developed in data warehouse.
• Involved in helping the application teams to rewrite and fine-tuned the existing applications.
• Supporting the production environments 24/7, fixing the defects and high priority bugs.
• Responsible for performing code reviews and code fixing after identifying the Defects.

Environment: Oracle 11g R2, SQL Navigator, UNIX, Windows 7. MS Visio, SQL Loader, EXPLAIN PLAN.

Confidential

Oracle PL/SQL Developer/Analyst

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Created Data Structures including Tables and Views, and applied referential integrity.
• Participated in designing of data conversion/interface with the use of SQL*Loader.
• Created Form level objects i.e. Libraries, property classes.
• Created Triggers, Stored Procedures, Packages and SQL Scripts.
• Worked in the Production Support team and fixed high priority bugs.
• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
• Performed unit testing and integration testing for various development applications in ORACLE 10g.

Environment: Oracle 10g, PL/SQL, SQL Developer, Windows XP, UNIX shell scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Designed and created all the required tables, indexes, sequences and views using SQL*Plus and Toad.
• Involved in developing Object data types and collections.
• Developed various Complex Queries, Views for Generating Reports.
• Used Hints to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
• Written SQL scripts for implementation.
• Developed and Tested applications for loading inventory data into database tables.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Extensively used PL/SQL Procedures and Functions to transform data before the loading process.
• Optimizing database objects and streamlining applications.

Environment: RAD, Oracle 10g, Oracle Application Server 10g(10.3.1.3),IBM Web Sphere, Altova XML Spy, Microsoft Visual Studio6.0, Java and Java Scripts.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.
• Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL Developer.
• Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Created and maintained development environment, resolved Production and validated Environment problems.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer
• Developed and deployed the Reports using Oracle Reports.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Mapped the source and target databases by studying the specifications and analysed the required transforms.

Environment: Oracle 9i/10g, Oracle Reports & Forms 6i/9i/10g, PL/SQL, EXPLAIN PLAN