SUMMARY

• Over 12+ year experience as an Oracle Developer in Application Development & Production Support.
• Very strong skills & clear understanding of requisites and solutions to various issues in implementation throughout the Software Development Life Cycle (SDLC) which include Analysis, Design, Development and Testing.
• Proficient in writing Packages, Stored Procedures, Functions, Views, Database Triggers, Collections and Analytical functions using SQL & PL/SQL in Oracle.
• Excellent understanding of the Oracle Architecture.
• Extensive experience in Analysis & Design of Database schemas.
• Created ER Diagrams (Logical/Physical data models) on Erwin, Microsoft Visio & SmartDraw.
• Experience using Bulk processing, REF cursors and Oracle Supplied DBMS packages.
• Excellent knowledge on Data migration & Data conversion.
• Hands on experience with Data loading using SQL*Loader and External tables.
• Experience in utilizing Oracle tools and methods like the use of merge statement, Pipelined functions.
• Expert in Performance Tuning & Query Optimization of SQL statements using EXPLAIN PLAN, SQLTRACE, TKPROF, DBMS Profiler and HINTS.
• Utilized Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), Automatic Diagnostic Repository (ADR) and SQL Performance Analyzer (SPA).
• Strong in using tools such as TOAD, Benthic, SQL*Plus and SQL Developer.
• Successfully utilized performance enhancements features of Oracle to optimize the batch processes.
• Excellent working and conceptual knowledge of Oracle Forms and Reports, Java and Java Script.
• Experience with shell scripting for creating UNIX processes, running background processes.
• Good knowledge in Pro*C modules to integrate with extraction and mapping tools.
• Worked on Data warehousing concepts i.e. Data Extraction, Transformation and Loading from different data sources into a common analytical data model using ETL tools like Oracle Data Integrator (ODI) & Informatica.
• Strong knowledge and experience with Oracle Data warehouse concepts - Aggregates, Hierarchy tables, Snapshot fact tables, etc.
• Good working knowledge on Oracle Application Express (APEX) development.
• Good knowledge in Web Based application development using .NET Framework1.1/2.0, Web Forms, VB.NET, C#, ASP.NET and ADO.NET, ASP 3.0.
• Experience in communicating with end users when working on Production Support.
• Strong technical aptitude, ability to rapidly assimilate and design practical applications of new technology.
• Guided and lead team members in various stages of the project
• Good team player and ability to work independently.
• Excellent logical and analytical skills, enthusiastic, excellent interpersonal & communication skills.
• Commitment to excellence proven by an outstanding career track.

TECHNICAL SKILLS

Operating System: Windows, UNIX

Database: Oracle 12C/11g/10g, MS Access, MS-SQL Server 2000/2005

Programming Languages: SQL, PL/SQL, C,C++, Pro*C, Java

GUI Tools: Forms 10g/9i,Reports 10g/9i, BO, SSRS

Tools: Toad, PL/SQL Developer, SQL* Plus, Erwin, SQL Navigator, Oracle Designer, Benthic (PL Edit/Golden), SQL Developer.

ETL: Informatica, Power Center, Oracle data integrator (ODI)

Web Technologies & Languages: Javascript, HTML, XML, Dreamweaver, VB, C#, .NET, Java, J2EE

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Sr. Oracle Developer

Responsibilities:

• Created PL/SQL stored procedures, functions and packages for moving the data from WMS to AMI.
• Created scripts to create new tables, views, queries for new enhancement in the application using SQL Developer.
• Involved in creating Logical Data Model (LDM) and Physical Data Model (PDM) using Erwin.
• Created DTD, XML scripts in order to send data from WMS to AMI through BizTalk.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Scheduled jobs using Scheduler (DBMS Scheduler) to create, run and manage jobs.
• Created and maintained daily/weekly jobs using Unix shell scripts.
• Knowledge of data modelling and ETL design
• Experience in designing and developing ODI mappings, Process Flows and ETL scripts
• Strong experience in create/modify custom & existing ODI Knowledge Modules
• Setting up topology, building objects in Designer, Monitoring Operator, Agents etc
• Experience in troubleshooting ODI data/runtime issues.
• Keeping manager informed on Project status, deliverables and issues. Ensure consistency in the quality of updates and messages going out from the WMS IT team.
• Maintain Development, Test and Production mapping migration Using TFS, also used TFS to maintain the metadata, security and Reporting.
• Unit tested the mappings by running SQL queries and comparing the data in source and target databases.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created Functional Design Documents, Technical Design Documents and Unit Testing Documents.

Environment: Oracle 12C, Oracle Data Integrator (ODI) 12C, SQL Developer, SQL Plus, Erwin, Visio, Notepad, Visual Studio 2013, Windows and Unix.

Confidential, New York City, NY

Sr. Oracle Developer

Responsibilities:

• Involved with data architecture team to design/modify Database Objects such as tables, indexes, views and materialized views.
• Developed PL/SQL packages, stored procedures and functions to business requirements.
• Extensively used oracle collections like nested tables and associative arrays.
• Utilized Oracle’s bulk processing techniques like Bulk Collect and FORALL.
• Conducted extensive performance tuning using Explain Plan and TKPROF utilities.
• Excellent in using Oracle Analytical functions.
• Utilized Dynamic SQL to build SQL statements dynamically at runtime.
• Involved in the modifying existing data model to add new requirements.
• Developed data migration and data conversion scripts using SQL & PL/SQL.
• Developed Informatica mappings between source data to target repository utilizing Informatica designer tool.
• Analyzed the whole process flow, PL/SQL packages, log files, error files, locations and descriptions.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.

Environment: Oracle 11g, Toad 10.6.0.42, SQL Developer, SQL Plus, Informatica, Power Center 8.6.1, Notepad and UNIX.

Confidential, Miami, FL

Sr. Oracle Developer

Responsibilities:

• Involved in the Analysis and Data Modeling (Logical to Physical data models).
• Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements using PL/SQL.
• Used Bulk binding/Bulk collection, REF Cursors, Dynamic SQL.
• Extensively used Oracle collections (Nested Tables and Associative Arrays).
• Utilized Oracle Analytical functions for optimizing SQL queries.
• Extensively used SQL (WITH clause, Rollup, Cube etc.) for aggregation in Data warehouse environment.
• Experience with setup of Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs in Oracle Data Integrator (ODI).
• Experience managing files, Oracle DB and XML's through ODI and ability to create Load-Plans and schedule the same.
• Experience creating alert on exceptions and error.
• Experience using and customizing Knowledge Modules (KM).
• Optimized database code to decrease response time of our front end application.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF.
• Utilized Automatic Workload Repository (AWR) & Automatic Diagnostic Repository (ADR) reports to analyze the database performance.
• Created and used DB-Links to import data from OFS (Oracle Financial Services) database to inbound part number and corresponding pricing information.
• Used Oracle’s External tables to load data into our DB.
• Created and maintained daily/weekly jobs using Unix shell scripts.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.
• Involved in preparing functional/technical specifications, release notes and other documentation.
• Had extensive Client interaction/provided support to end-users.

Environment: Oracle 11g, Oracle Data Integrator, SQL Developer, SQL Plus, CVS, Beyond Compare, GitHub, Microsoft Word, Visio, Textpad, Windows, Linux and Unix.

Confidential

Technology Specialist

Responsibilities:

• Created Database Objects such as indexes, sequences, synonyms, views and materialized views.
• Developed PL/SQL packages, stored procedures, functions and triggers to business requirements.
• Extensively used oracle collections like nested tables and associative arrays.
• Utilized Oracle’s bulk processing techniques like Bulk Collect and FORALL.
• Conducted extensive performance tuning using Explain Plan and TKPROF utilities.
• Excellent in using Oracle Analytical functions.
• Wrote Pipelined functions to migrate data from the External files into the oracle Database.
• Utilized Dynamic SQL to build SQL statements dynamically at runtime.
• Involved in the process of Data Modeling using Erwin.
• Developed data migration and data conversion scripts using SQL & PL/SQL.
• Designed and developed Informatica mappings between source data to target repository utilizing Informatica designer tool.
• Analyzed the whole process flow, PL/SQL packages, log files, error files, locations and descriptions.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.
• Worked in a DBA team as a junior DBA, by performing activities like taking DB backup, installations etc.
• Involved in preparing System documentation such as Technical Specifications, functional specifications, release notes, Unit Test Plan, Data Flow Diagram using MS-Word, Visio diagrams and other documentation.

Environment: Oracle 11g, Oracle VM Virtual Box, SQL Developer, SQL Plus, Informatica, Power Center 8.6.1, Microsoft Word, Visio, Notepad, Windows XP, Unix and Linux.

Confidential

Tech Lead/Sr.Oracle PL/SQL Developer

Responsibilities:

• Involved in requirement gathering, analysis, design and development of the application.
• Mapping client requirements to the existing Confidential products and if required providing the gap document.
• Designed ER diagrams and data flow diagrams for custom solutions.
• Created Database Objects - Tables, indexes, sequences, views and materialized views.
• Extensively used PL/SQL packages, procedures and functions.
• Building custom solution based on existing ECP platform using Appstudio tool.
• Modifying existing Appstudio packages/Product packages to move the data based on the customization.
• Worked with Javascript to modify the screen layout.
• Developed and modified existing Javascript code to meet customer requirements.
• Performance tuning - Working with the system to improve the application response time.
• Used Explain plan to performance tune SQL queries.
• Used TKPROF utility to identify the performance intense sql queries.
• Used oracle’s bulk collect features to improve the performance.
• Took regular DB backup and also monitored the system performance.
• Utilized Oracle Virtual Private Database (VPD) to create security policies to control database access.
• Defined general coding methodologies, naming standards.
• Involved in technical code review, defining standards and other documentation.
• Guided and lead team members in various stages of the project.

Environment: Oracle 11g, Javascript, Toad, SQL Developer, Appstudio tool, Mozilla Firefox, Internet Explorer 8, SQL Plus, Microsoft Word, Visio, Textpad, Windows 7, Unix and Linux.

Confidential, Richfield, OH

Sr.Oracle ODI Developer

Responsibilities:

• Involved in requirement gathering and analysis.
• Created Database Objects - Tables, indexes, sequences, views and materialized views.
• Developed several back-end PL/SQL Packages, Procedures, Functions and Triggers.
• Developed packages, interfaces and models in Oracle Data Integrator (ODI).
• Transformed data into the required format using ODI interfaces & packages utilizing ODI’s Designer and monitored the flow using ODI’s Operator.
• Worked extensively on handling exceptions, logging bugs to JIRA and sending out email notifications using ODI.
• Extensively used Oracle Analytical functions, Oracle collections like nested tables and associative arrays.
• Utilized Oracle’s bulk processing techniques like Bulk Collect and FORALL.
• Expert in performance tuning using Explain Plan and TKPROF utilities.
• Involved in the Analysis, Design, Coding and Testing of the application.
• Prepared ER Diagrams (ERD), Data flow diagrams based on the requirement.
• Created various Dynamic SQL and PL/SQL scripts for verification of the required functionalities.
• Reviewed data transformation rules, provided technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Optimized the batch processes in-order to improve the performance, there-by reducing the total time required for data conversion process.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Prepared functional/technical documentation to describe the application which was developed using Mapping documents, Data flow diagrams using VISIO and other Microsoft word documents.

Environment: Oracle 11g, Oracle Data Integrator 10.1.3.6.0 , SQL Developer 3.0.04, SQL Plus, Microsoft Word, Visio, Textpad and Windows 7.

Confidential, Harrisburg, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created Database Objects such as indexes, sequences, synonyms, views and materialized views.
• Developed PL/SQL packages, stored procedures, functions and triggers to business requirements.
• Wrote PL/SQL packages/procedures for transferring a bulk amount of case/individual data between Oracle DB and mainframe DB.
• Used Ref cursors and Oracle User-defined types (UDTs) to return required Result set to a .NET DataReader Object.
• Extensively used oracle collections like nested tables and associative arrays.
• Utilized Oracle’s bulk processing techniques like Bulk Collect and FORALL.
• Conducted extensive performance tuning using Explain Plan and TKPROF utilities.
• Excellent in using Oracle Analytical functions.
• Wrote Pipelined functions to migrate data from the External files into the oracle Database.
• Involved in maintenance of Confidential ’s Customized Refernce table matrix.
• Involved in the process of Data Modeling using Erwin.
• Designed and developed Informatica mappings between source data to target repository utilizing Informatica designer tool.
• Provided back-end support (Developed PL/SQL packages & procedures) while developing reports using SQL Server Reporting Services (SSRS).
• Successfully involved in rolling out counties by creating Day 0 scripts.
• Tested new enhancements and fixed various bugs before Deployment into the Production environment.
• Worked along with DBA team as a junior DBA, by performing daily activities like taking DB backup, installations etc.
• Involved in preparing System documentation such as Technical Specifications, functional specifications, release notes, Unit Test Plan, Data Flow Diagram using MS-Word, Visio diagrams and other documentation.

Environment: Oracle 10g, Toad, Benthic (PL Edit/Golden), SQL Plus, SQL Developer, Oracle XML, Informatica, Power Center 8.6.1, Visual Studio 2008, Erwin, Visio, HTML, XML Spy, Unix and Windows XP.

Confidential, Jefferson City, MO

Oracle PL/SQL Developer

Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom PL/SQL packages and procedures tailored to business requirements.
• Creation and modification of various SQL and PL/SQL scripts.
• Designed and Developed GUI front-end using Oracle Forms 10g for User interaction with the database.
• Wrote stored procedures/functions/packages/triggers while developing Forms 10g.
• Created Object Libraries, Object Groups, Property Classes and PL/SQL Libraries to keep the same standard and consistency in Forms.
• Designed and developed Reports according to user specification, using Reports 10g.
• Prepared ER Diagrams (ERD), Data flow diagrams based on the requirement.
• Created various Dynamic SQL and PL/SQL scripts for verification of the required functionalities.
• Involved in various Data warehousing techniques like logical and physical database design, Star Schema design, Identified Fact Tables, Dimension Tables.
• Reviewed data transformation rules, provided technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Involved the date extraction, transformation and loading (ETL) process.
• Involved in Data loading using UNIX Shell scripts, SQL*Loader.
• Developed Pro*C modules to extract data with user interface capabilities.
• Developed UNIX shell scripts to automatically notify the systems and management personnel on status of backups, pending database concerns and unsuccessful job runs that needed to be resubmitted. Debugged the scripts when required.
• Designed, Visualized and delivered reports using Crystal Reports.
• Created KORN shells to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Used Pre - Post Stored Procedures for Source/Target to perform additional checks before loading the data with respect to table size check and recreating indexes.
• Involved in extensive server side and client side validations.

Environment: Oracle 10g, Forms 10g, Reports 10g, TOAD, SQL Loader, SQL Developer, Oracle XML, Oracle Designer, Crystal Reports, Informatica, UNIX, Java, J2EE, Pro*C, Lotus Notes and Microsoft Office.

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Created Database Objects such as indexes, sequences, synonyms, materialized views, PL/SQL packages and procedures.
• Wrote PL/SQL procedures for creating batch processes, used to calculate claim information and summarize data which run at the end of each month.
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting.
• Wrote Pipelined functions to migrate data from the External tables into the oracle Database.
• Developed various PL/SQL packages, using Oracle's features such as Bulk binding/Bulk collection, REF Cursors, Dynamic SQL, Nested Loops and VARRAYS.
• Analyzed the whole process flow, log files, error files, locations and descriptions, PL/SQL packages, process codes and descriptions.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Integrated Shell Script, PL/SQL, SQLPLUS and Used CRON to schedule batch jobs.
• Used SQL*Loader and UTL FILE Packages for data interfaces.
• Created SQL and PL/ SQL scripts and also called C external routines from within PL/ SQL for transfer of data between the databases.
• Built Perl programming in UNIX environment to acquire and process multiple varied data formats.
• Involved in Web Application, developed User Interface (UI) using Web-forms, web controls using asp.net and C# as code behind.
• Involved in preparing functional specifications, release notes and other documentation.

Environment: Oracle 9i, ASP.NET 2.0, MS-Visual Studio 2005, HTML, C#, SQL *Loader, Oracle Tuning Pack, Oracle JDC & ODBC, Erwin, Toad, Visio, ETL, Perl, UNIX shell scripting, Visio, Java and UNIX.