SUMMARY

• Around 14 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Enterprise Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports and Oracle Discoverer.
• Expertise in ETL, Data Modelling, Data warehousing using SSIS and SSRS/SSAS.
• Experienced with NoSQL Database MongoDB collections and Cloud API Integrations.
• Experienced with Tera Data, converting ERIWN Data models into OLAP Objects for BI Applications.
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences, and Materialized views using SQL and PL/SQL.
• Expert level experience on PL/SQL that includes Cursors, Ref - cursors, Procedures, Functions and Packages, Objects, Partitioned Tables, Table Indexing and Oracle Advanced Queuing.
• Expertise in using user defined and system defined Exceptions for Error handling.
• Experience in creating composite data types and collections.
• Experience in using tools like Toad, SQL * Plus, SQL Developer, PL/SQL developer.
• Experienced in writing UNIX shell scripts for automating the process of data loading& Batch Processing.
• Expertise in Data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.
• Worked in analyzing and Implementing the ETL architecture using SQL * Loader, PL/SQL, SSIS.
• Good Function knowledge on Retail, E-Commerce, Procurement, AP/AR/GL and Inventory.
• Extensive expertise on Business Process Management and MIS Reporting Systems.
• Expert in Integration and Data interfaces between multiple systems.
• Experienced in Data Replication and Data Guard.
• Extensive experience in Database query tuning, Performance tuning of Reports.
• Experience in DML, DDL, and TCL operations.
• Expertise in RMAN backup, Archive log management and data export/import utilities.
• Experience in Migrations/database upgrades and 24/7 Production Support & Maintenance.
• Excellent analytical and problem-solving skills, can work independently and responsible team player.

TECHNICAL SKILLS

Databases: Oracle 8i/10g/11g/12c, Tera Data, MongoDB, Amazon RDS/SQL Server and SAP HANA

Languages: PL/SQL, SQL, C# and Shell scripting

Tools: TOAD, SQL Developer, Oracle Enterprise Manager, SQL*Plus, SQL*Loader, Oracle Forms 6i&10g /Reports 6i&10g, Discoverer 10g, Control-M, Rally/Jira, DBMastro, Erwin, MS Visual Studio, Crystal Reports, SharePlex and Data Guard

Operating Systems: Unix/Linux RHEL 4/5/6, WIN 2008/12 Server, SUSE Linux

ETL Tools: MS Data Tools (SSIS, SSRS, SSAS), Informatica Power Centre

Environment: s: EXADATA, RAC, JBOSS, WebLogic, RESTful APIs and Salesforce

Others: Jenkins, Confluence, GitHub/Bitbucket, Oracle EBS ERP, Splunk, Dash Board KPIs

PROFESSIONAL EXPERIENCE

Confidential, Deerfield Beach, FL

Sr. Oracle PL/SQL Developer

Environment: Oracle 11g/12c, MongoDB, Tera Data, Amazon RDS, MS SQL Server, SQL, PL/SQL, Toad, Advanced Messaging Queues, Mule-Soft, Informatica ETL, Sales Force, GitHub/Jenkins, confluence/Jira.

Responsibilities:

• Working with a biggest Finance & Insurance group of South East Toyota
• As a Senior Developer playing a crucial role in super massive remediation & re-architecture projects
• Built an Oracle based Integration Repository to serve multitude of on premise and Cloud Applications (25+), plus thousands Dealers across the USA
• Consolidated humongous data from heterogeneous sources and built complex data structures/models using Oracle Advanced PL/SQL
• Built scalable custom integrations using Oracle Advance Messaging Queues and Mule-Soft
• Developed MongoDB sync functionality using PL/SQL and JSON collections to support Salesforce base dealer applications/automotive GAP insurance systems
• Implemented logic to protect Data consistency/Data loss using Oracle DBMS hash functionality
• Created OLAP Data Models/Objects/Structure inside Tera Data to support Business Analytics
• Used Oracle Bulk Loading/Binding techniques to Load and process the huge amount of data inside Oracle Database
• Played an important role in a major upgrade from Oracle 11g to 12c, and did the code and data conversion.
• Developed and Modified the PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced techniques Bulk Processing , Queuing (En-queue and De-queue), Collections .
• Co-ordinate with multiple teams spread across globe and being part of release management.
• Being part of Deployments, Change requests, Production support and 24/7 Incident/Ticket management.

Confidential, Pasadena, CA

Senior Database/ETL Developer

Environment: Oracle 12c RAC, SQL, PL/SQL, Toad, DBMastro, LINUX, Java, Jenkins, Restful web services, Splunk, confluence/Rally, MS Data tools (SSIS, SSRS) Oracle Reports 10g and Oracle Forms 10g.

Responsibilities:

• Part of a new generation tax engine development project, a major upgrade from Mainframes/DB2 to service oriented architecture.
• Responsible for database/application development using agile methodologies, support java based micro services.
• Migrating the existing functionality/data from legacy systems and customize as per the requirement.
• Designed Integration components to exchange data with multitude of systems.
• Involved in Performance tuning and resolve scalability issues without affecting the functionality.
• Responsible for code reviews, code builds and deployments to meet relevant milestones.
• Support production issues and bug fixes in real time environments.
• Upgrade the existing program units and optimizing reusable components for better performance.
• Part of QA regression tests and to maintain the product compliance with various govt. agencies.
• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
• Designed and implemented ETL Processes using MS Data Tools SSIS and supporting SSRS/SSAS.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Have converted old data from Flat files to Oracle database Using SQL * Loader and SSIS
• Developed screens and reports using Oracle Forms 10g/Reports 10g
• Designed and developed user interfaces for customers using Oracle 9i/10g Forms Builder.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.
• Worked on Data Modelling for both OLTP and OLAP.
• Performed performance tuning for queries on highly transactional OLTP database systems.
• Provided On-Call support for OLTP as well OLAP RDBMS and other maintenance jobs.
• Additionally, part of rotation on call DBA to support Production databases 24X7.

Confidential

Sr. Oracle PL/SQL Developer

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL * Plus, TOAD, SQL*Loader, ETL (SSIS, SSRS & SSAS), Shell Scripts, SQL Developer, Linux RHEL, JBOSS and Dashboard & KPI Designer.

Responsibilities:

• Played a major role Implementation of Data warehouse using ETL Tool SSIS and supporting Analytics
• Development and customization of master’s screen and user setup screens using Oracle Forms.
• Created and modified complex functions, stored procedures, packages, and Triggers by using Oracle PL/SQL based on the business rules.
• Used Oracle Advanced Queuing for integrating multiple applications over a messaging queue .
• Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle by using Oracle SQL Developer.
• Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS PROFILER, Hints etc.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
• Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading in the PL/SQL Packages.
• Extensively used Oracle 11g features like RESULT CACHE, Compound Triggers etc.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
• Facilitate timely approval of major milestones, approvals, and signoff.
• Report the project status and generate milestone reports.
• Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like Toad, PL/SQL Developer, and SQL* plus.
• Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project’s success.
• Create a risk plan and list all the mitigations and present the change requests for approvals.
• Facilitate and document the post implementation results in the form of closure reports.
• Conduct weekly status meetings.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Participate in requirements review, application design review and test plan reviews
• Coordinate activities with infrastructure, business, and QA teams.

Confidential

PL/SQL Developer

Environment: Oracle 11g/12c, Linux RHEL, SQL, PL/SQL, Toad 10.6, Win Server 2012, Putty, SharePlex, Apex 5.0, CSS, HTML, jQuery, JavaScript

Responsibilities:

• Working as a developer and Onsite coordinator.
• Responsible for assigning and explaining tickets to India team.
• Working on tickets to add new database changes as requested.
• Responsible for testing all our DB code in 12c after upgrade.
• Responsible to schedule jobs through control m using mainframe info command.
• Worked on integrating EBS AR&AP module to oracle APEX.
• Worked in Exadata environment.
• Writing PL/SQL procedure/packages/functions to put the processed data into final tables.
• Maintaining, and modifying Apex applications.
• Monitoring jobs and recovering if it gets abandoned.
• Involved in production support by efficiently debugging the production issues.
• Created Views, Dynamic SQLs.
• Worked on validating invoice receipt and payments through AR AP module of Oracle EBS. Invoice data, PO data, payment data were tested before being pushed to data warehouse for reporting use.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc. in different schemas.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Oracle Forms were being used to create and maintain PO and invoice forms.
• Apex is being used for small reporting applications.
• In Apex we have created Forms and reports.
• Reports included charts like bar, pie, interactive, Map charts.
• Created forms with dialogue pages.
• Created scripts to load the data into staging tables from other database using DB links.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Created reusable procedure code to gather incremental stats of tables after data gets loaded.
• Created reusable procedure to handle work table creation and populate partitioned tables using exchange partition for partitioned tables.
• Responsible for maintaining data-replication process using SharePlex.
• Used OBIEE for BI purpose.

Confidential

Oracle Developer

Environment: Oracle 8i,9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools.

Responsibilities:

• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for managing production, development & test databases, and applications.
• Wrote Stored Procedures per specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Creation of Users and Granting them privileges and roles.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creating databases, objects, roles, and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the SQL queries.

.