SUMMARY:

• Over 8 years of extensive experience as Oracle PL/SQL Developer which involves Data analysis, design, development, implementation, integration, testing and support.
• Besides the PL/SQL development, have experience in developing Oracle Forms & Reports using Reports 10g/6i and Forms 10g/6i.
• Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Robust experience in RICEW modules and held positions where major responsibilities included coding, unit testing reports, interfaces, conversions & enhancement programs, workflows and performance tuning on the backend side and considerable experience in UNIX Scripting.
• Experience with Partitioned Tables, DB Stats, PL/SQL object types.
• Experience with data flow diagrams, data dictionary, and database normalization design techniques.
• Experience in the Client - Server application development using Oracle 11g/10g/PL/SQL, SQL PLUS, TOAD and SQL Loader.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Proficient in making changes to the existing DB objects without impacting the other logic.
• Proficient in writing complex queries wherever required with the optimized plan.
• Proficient in implementing Autonomous Transactions and Exception Handling in a well-structured manner.
• Registering of Custom Applications/Table/Schemas in Oracle Applications.
• Extensive experience in using database tools like TOAD, SQL Developer, SQL*Loader, SQL *Plus, MS Access.
• Implemented SQL program to load data from Excel files, Flat files into temporary table using UTL FILE utilities and SQL loader.
• Experience in using several built-in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, and DBMS SQL to name a few.
• Immensely worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Menus, Functions, Value sets and Flex fields in Oracle Applications using AOL, UNIX shell scripts.
• Proficiency in writing PL/SQL Packages, Stored Procedures, Functions, Packages, Database Triggers, views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects, Indexes, Sequence, Synonyms, Roles and privileges using SQL and PL/SQL.
• Involved in development of custom reports using Reports 10g and XML/ BI Publisher.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions based on the client's requirements.
• Worked on Forms Personalization to handle the form customizations.
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Developed reports using Oracle Discoverer (D2k) by creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
• Involved in generation of custom XML reports incorporating client's emblems and other JPEG images for the fancy and quality facilitated reports.
• Experienced in Database Design, Migration, Data Modeling, and Systems Architecture, Planning, Testing and Trouble Shooting, Schema Design.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Worked with both Onsite-Offshore project models and proven characteristics of being highly motivated.
• Strong interpersonal, problem-solving and analytical skills. Self-Starter and ability to work independently without any supervision.

TECHNICAL SKILLS:

DATABASE: (8 years), PL/SQL (8 years), SQL (8 years), UNIX (7 years), SHELL SCRIPTS (5 years)

Operating Systems: UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows & Windows XP.

Data Modeling: Erwin 3.5.2, 4.0

Languages/Utilities: SQL, PL/SQL, UNIX shell scripts, Java, XML, C and COBOL.

Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ

WORK EXPERIENCE:

Sr. Oracle PL/SQL Developer

Confidential, MD

Responsibilities:

• Created various database objects like tables, views, materialized views, procedures, functions and packages using oracle tools like Toad, SQL Developer and SQL* plus in Agile Methodology.
• Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Design, develop, test, implement and support the data visualization/presentation platform in WebFOCUS via reports, portals and info assist.
• Managed, Access, and maintained development, test, and production of Web Debt Management Module of WebFOCUS servers.
• Wrote reports in WebFOCUS and reuse existing reports using SQL Pass thru method.
• Transferred SQL and Korn shell programs into ODI and created data extracts.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Developed DAO layers in applications to access the DB objects from Java.
• Pipelined, Java Stored Procedure, External Procedure, various DBMS and UTL package.
• Worked on Azure Networking - VNET, VPN-S2S, P2S, Express route, SonicWALL, SSL, Azure VMs, Azure Web/App, Azure Logic Apps, Azure Functions, Azure POWER BI, Azure Billing, Azure Subscription and Account management, Azure NSG, Azure Load Balancer, and AZURE ASM to ARM migration.
• Involved in requirement analysis, preparing functional specifications, system design, development and database administration.
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Designed DW tables, scripts, ETL maps and ODI Extracts, Configured ODI modules and ETL tools and supported accessible applications, and Documented and maintained ETL specifications and processes.
• Worked on custom development of data warehouse, operational data store, and OLTP systems.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
• Created Shell Scripts for invoking SQL scripts.
• Customized few forms for the Business manages to validate the data.
• Involved in creating Pseudo code documents for writing stored procedures.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Environment: Oracle 10g / 11g/12c, Java, SQL, Agile, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell Scripting

Sr. Oracle PLSQL Developer

Confidential, MD

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation in Agile Methodology.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Azure Networking - VNET, VPN-S2S, P2S, Express route, SonicWALL, SSL, Azure VMs, Azure Web/App, Azure Logic Apps, Azure Functions, Azure POWER BI, Azure Billing, Azure Subscription and Account management, Azure NSG, Azure Load Balancer, AZURE ASM to ARM migration.
• Wrote reports in WebFOCUS and generate graphs through Info Assist.
• Analyzed existing data and reports in WebFOCUS Metadata and MS-SQL environment for new reports in WebFOCUS.
• Fix open ticket as created by users that includes code modification and issue data analysis.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Analyzed C/Java sources to gather business rules for the application and converted them into/SQLcodes.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Optimized the performance using PL/SQL table types and record types.
• Did SQL and PL/SQL programming for ODI and oracle.
• Developed AR Credit memo and AR Customers forms.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the clean-up process.
• Played a major role in designing the dimensional modelling of star schema for the enterprise data ware house of ODS.
• Participate in upgrading Oracle database(s) and Oracle Warehouse Builder to Version 11.2.0.4
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed DAO layers in applications to access the dB objects from Java.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Wrote SQL queries to developed test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
• Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed and multiple instances of a job were run using DataStage Director.
• Created complicated reports using reporting tool Cognos.
• Used DS Erwin MetaBroker to import Erwin 4.x Metadata into DataStage Repository.
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
• Created & Deployed SSIS (SQL Server Integration Services) Projects, Schemas and Configured Report Server to generate reports through SSRS SQL Server.
• Involved in Unit testing and Integration testing of forms and reports.
• Coding of documents in XML for data transformation.
• Developed test procedures to Unit test the application.
• Worked on Oracle OLAP tool to produce analytic measures, including time-series calculations, forecasts.
• Implemented table and index partitioning of various tables with huge data.
• Wrote a Perl-based server to generate reports of trades, and tickets in PostScript and HTML formats.
• Developed scripts in Korn shell and Perl for network management
• Provided Post production Technical Support to the users.

Environment: Oracle 10g / 11g/12c, SQL, Agile, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting, HP PPM, Oracle Warehouse Builder 11.2.0.2, Subversion (SVN), CVS, Perl

PL/SQL Developer

Confidential, Hartford, CT

Responsibilities:

• As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
• Created Database links to connect to remote databases and to be able to pull data, perform joins to manipulate the data.
• Created Stored Procedures, Packages, and Functions to massage data, validate data and to implement complex business rules.
• Developed database objects such as stored procedures, packages, functions, types.
• Reviewed the business requirement, functional requirement document for various modules so as to have good understanding of the application.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Played an important role in performance tuning most complex SQL queries using Hints, Indexes.
• Extensive documentation of the source and target tables and the description of the objects in the Excel document and developed Excel Report using the procedural code.
• Worked on Table structures along with the Triggers, Indexes like Bitmap and Function based Indexes.

Environment: Oracle 11g, PL/SQL, SQL*Plus, Agile, SQL developer, TOAD

PL/SQL Developer

Confidential, New York, NY

Responsibilities:

• Worked on HR database of Direct TV to move it from different sources to a specific format.
• Parameterized SQL Scripts based on the business logic to move them into core tables.
• Created views in Vertica to implement logics and casting the columns to desired format.
• Performance tuned queries for the faster and efficient transactions.
• Created JSON files for implementing and populating the data in to HUB tables.
• Worked with operations and deployed the required scripts and JSON files.
• Created materialized views, views, tables based on the data model.
• Used SQL Loader to retrieve the data into the database tables from flat files and comma separated files (CSV).
• Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
• Worked on advanced concepts of PL/SQL such as Records, Collections and Dynamic SQL.
• Widely used PL/SQL tables and Bulk Collect for processing the load on tables and retrieving into oracle.
• Participated in code review meetings with the development team.
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
• Performed SQL and PLSQL tuning and Application tuning using various tools like EXPLAINPLAN, SQL*Trace and TKPROF.
• Worked on creating PL/SQL Tables, Views, Stored Procedures, Triggers and Functions which are used in generating the Crystal Reports and also in the INFORMATICA Mapping.
• Developed complex SQL queries to perform the back end testing of the Oracle database using UNIX shell commands.
• Worked on converting row based data into column based data i.e., from Oracle to Vertica database.
• Used Toad Data point to work on converting codes from oracle based to Vertica.
• Performed DBA activates of taking backups (Cold and Hot). Table level, schema level and table space level backups.

Environment: TOAD, SQL*Loader, Vertica, DB Visualizer Agile, Toad Data Point, Oracle 11g, AutoSys, Shell, Tortoise SVN, APEX Data Loader

SQL Developer

Miami, FL

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using Parallel Queries, Java stored procedure, HTTP Package and WEB.SHOW DOCUMENT.
• Participated in change and code reviews to understand the testing needs of the change components.
• Worked on troubleshooting defects in timely manner.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Involved in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Lifecycle.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing.
• Extracted data from the XML file and loaded it into the database.
• Designed and developed Oracle forms & reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Used Crystal Reports to track logins, mouse over's, click - through, session durations and demographical comparisons with SQL database of customer information.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding
• Involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance.
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Involved in data replication and high availability design scenarios with Oracle Streams.
• Developed UNIX Shell scripts to automate repetitive database processes.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX Shell Scripting

Oracle Developer

Confidential, Auburn Hills, MI

Responsibilities:

• Involved in discussions with data analysts in gathering the requirement and with client for any better enhancement of the application.
• Involved in development and enhancement of various modules.
• Involved in all phases of SDLC from requirement, design, development, and testing.
• Wrote packages, stored procedures for storing the client information and modifying the views to resolve any possible bugs.
• Created database objects such as tables, views, synonyms, indexes and sequences.
• Created views based on multiple tables and performed data changes using Instead of triggers for the underlying tables.
• Setup run time environment, creating and maintaining shell scripts to run stored procedures, packages to populate the valid data in staging tables and invalid data into error tables which will be sent back to sender notifying the errors.
• Constructed the required data involving complex JOIN statements, including outer - joins, intersect and union all.
• Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
• Used DBMS JOB to automate the regular tasks and improve time-constrained performance.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Created PL/SQL Procedures, Functions, Triggers and Packages to meet the business requirement of the project.
• Avoided mutating table errors using the new functionality in Oracle 11g i.e., Compound triggers.
• Used Global Temporary tables to access the repeated data within a session and improved the performance.
• Used SQL loader for importing the flat files which consists of several records of customer's information into the different tables in the database.
• Performed Unit testing using the PL/SQL code.

Environment: Oracle 11g, SQL, PL/SQL, EXPLAIN PLAN, SQL developer, UNIX