SUMMARY:

• 7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling and Development of client/server and multi tired applications and Data warehouse environments using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance Analysis and SQL query tuning using Query Optimizer, Indexes, SQL Access Advisor, Hints, Explain Plan, and Tk - prof.
• Involved in all phases of software life cycle- Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and Support.
• Extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning.
• Strong knowledge in front end development using oracle forms/reports6i/9i/10g/11g
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports), Forms and Reports 11g/10g/9i, Oracle Developer Suite10g.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 12c/11g/10g/9i, PL/SQL back end applications development using Toad, SQL Plus, and PL/SQL Developer.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Scheduled complex cron jobs on UNIX platform using crontab format.
• Good experience with waterfall and Agile Scrum Methodology and Experience in Export, Import and SQL*Loader Utilities.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data which is stored at the OS level.
• Experience with oracle supplied packages like DBMS SQL, DBMS JOB and UTL FILE.
• Experience with Data modeling using ERWIN 4.0/3.5.2.
• Experience in Data Migration across various databases as well as within the same database across different systems.
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
• Good knowledge of Database Administration.
• Extensively used DBA Utilities, RMAN, Oracle Enterprise Manager, and Export/Import, Performance Monitoring, Backup & Recover.
• Ability to explain technical concepts and communicate with users and system administrators at all levels.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.

TECHNICAL SKILLS:

Databases: MySQL, ORACLE 9i/10g/11g/12c, SQL Server 2008, Microsoft Access.

GUI s: Developer/2000(Forms10g/9i/6i & Reports10g/9i/6i)

Programming languages: SQL, PL/SQL, C, JAVA and UNIX shell.

Web Technologies: CSS/CSS3, HTML/HTML5.

Operating systems: Windows, UNIX

Development Tools: TOAD, SQL Developer, SQL*loader, SQL*plus, Informatica Power Center, Oracle Enterprise Manager (OEM), GitHub, Forms Builder, Reports Builder, VI Editor, Salesforce.

PROFESSIONAL EXPERIENCE:

Confidential, Pennsylvania

Sr. Oracle PL/SQL Developer and QA

Responsibilities:

• Analyzing the new feature requirements, Impacts, designing the database table structure and code development design from technical perspective.
• Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
• Involved in Creation of tables, Partitioning tables, join conditions, correlated sub queries, nested queries and views for the business application development.
• 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). Created temporary tables and developed SQL*Loader control files to load the data into the temporary tables.
• 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.
• Extensively involved in writing SQL queries and PL/SQL programming.
• Participated in code review meetings with the development team.
• Copying of data from integration environment to component to test by using utilities like Export/Import.
• Created the Indexes, Oracle Hints as part of performance tuning.
• Developed PL/SQL Triggers on tables for storing the old and new values for reporting purpose.
• Moved the tables to different table space and rebuild the indexes.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Developed Unix Shell Scripts and loading data into the Database using SQL* Loader.
• Developed Batch jobs in PL/SQL to perform trades and to load bunch of data to tables.
• Raised and added service now requests for configuring the data at firms and PO’s levels.
• Worked extensively on Exception handling to error handling and tracking.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Trouble shooting performance issues using Explain Plan and TKPROF and SQL Trace. Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Documented business rules, technical designs, test cases, and user guides.
• Used Boxi for generating Reports.
• Used Informatica Power Center 9.1/8.6.1 as ETL tool for Extraction, Transformation and Loading data from various sources into Oracle Database.
• Fixed defects for existing code in production environment.
• Involved in the production support, to identify the root cause of the issue and query out the effected data and fix accordingly.
• Functional Analysis of the requirement and impacts across platform.
• Written and executed the Test cases for the new developed features.
• Performed Integration, Regression Testing.
• Involved in Agile methodology daily meetings and used Github and Rally tools for deploying the code and tracking the daily activities.

Environment: Oracle 10g/11g, TOAD, SQL Developer, Informatica Power Center 9.1/8.6.1, PL/SQL, Java, Windows.

Sr. Oracle PL/SQL Developer / Database Administrator II

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Involved in the production support, to identify the root cause of the issue and query out the effected data (patient data) and fix accordingly
• Wrote Package containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures for validation purpose.
• Involved in Creation of tables, Partitioning tables, join conditions, correlated sub queries, nested queries and views for the business application development.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table, V array & Dynamic SQL.
• Created the indexes and analyzed the table for better performance.
• Developed PL/SQL triggers on master tables for automatic creation of primary keys values.
• Made modifications to existing Oracle forms and Oracle Reports.
• Developed custom forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked with Oracle Enterprise Manager, Net configuration assistant.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Developed Unix Shell Scripts and loading data into the Database using SQL* Loader.
• Copying of data from development to test and production by using utilities like Export/Import.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Wrote the shell scripts and scheduled with using cronjob for the database backups and old archive log deletion. Also done the logical backup (database structure export only) of the development instances every day using shell scriptExtensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Documented business rules, technical designs, test cases, and user guides.
• Used BI tool Tableau for generating Reports.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Used Informatica Power Center 9.1/8.6.1 as ETL tool for Extraction, Transformation and Loading data from various sources into Oracle Database.
• Involved in Upgrading Oracle 10g to 11g software in different environments for latest features and also tested databases.
• Granted access and created tickets to other development teams for supporting applications.
• Resolved tickets that are assigned to AOC for database accessing issues.
• Fixed defects for existing code in production environment.
• Fixed code defects by replicating same errors from production in test and development environment.
• Worked on SQL tickets to grant logins to server level using SQL server and performed user actions on DB.
• Worked closely with management to prioritize business goals and information needs.

Environment: Oracle 10g/11g, TOAD, SQL Developer, Informatica Power Center 9.1/8.6.1, UNIX, Tableau, Oracle Forms 11g/10g, Reports 11g/10g, PL/SQL, .Net, Microsoft SQL server 2008, Windows.

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages and Procedures accordance with Business Requirements and also to extract the data from different sources and load it into tables.
• Involved in redesign of the Application according to the new business requirements by creating the Partitioned tables and indexes for better performance of application.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Cursors, Triggers.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects.
• Involved in tuning SQL queries by using EXPLAIN PLAN.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Developed many process improvements using the Bulk Collect and FORALL (Bulk Bind) methodology and also by using hints for queries.
• Involved in developing UNIX shell scripts for Loading Database Tables, running SQL files, Packages and Procedures.
• Loading data from flat files into database tables using SQL* Loader.
• Involved in creating the Command line, Box and File watcher jobs using the scheduler tool AutoSys 4.0 and AutoSys r11.3 versions.
• Developed front end Forms and created form level triggers by using Oracle Forms 10g.
• Modified the existing Forms based on requirement.
• Designed the ETL mappings using Informatica power center tool for loading data from flat files into data warehouse.
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, maintenance, reorganization, and recovery of databases.
• Involved in unit and integration testing of the jobs and prepared documentation.
• Responsible for writing high quality and well documented code according to standards and documentation of various processes.
• Worked with a team which Upgraded Oracle DB 10g to Oracle 11g.
• Responsible for Analyzing and Implementing the Change Requests.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.

Environment: Oracle 11g/10g, TOAD, SQL * Loader, Windows XP, Java, Informatica power center 9.x/8.x, Oracle Forms 10g.

Oracle PL/SQL Developer

Responsibilities:

• Translated business requirements into Technical Design and documentation.
• Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
• Enforced database integrity using Primary keys and Foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Designed coding specification and documentation.
• Wrote complex SQL queries, generated views for the administrative department.
• Performance tuning of database queries using TKPROF, Explain plan and SQL trace.
• Extensive use of CRONTAB in UNIX environment for scheduling routine tasks.
• Used packages like DBMS JOBS to schedule running of certain stored procedures.
• Managed and resolved design issues during development.
• Developed documentation to support the business and the IT support team.
• Assisting other developers for the application performance tuning using TKPROF.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, and using Optimizer Hints.
• Designed and generated reports using Oracle Reports.
• Wrote queries involving multiple-joins to generate user reports.
• Wrote both Implicit and Explicit Cursors to capture rows within a PL/SQL block, and applied business rules on them.
• Extensively used Cursors and Ref Cursors in order to generate various reports.
• Involved in Testing and implementation.

Environment: Oracle 10g/11g, Oracle SQL Developer, SQL*Loader, SQL*PLUS, UNIX Shell Scripting, Informatica Power Center 8.x.

Oracle PL/SQL Developer

Responsibilities:

• Involved in Developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24-hour production support.
• Supporting legacy systems with backups of all cases to/from parallel systems.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.
• Created Shell scripts to generate oracle reports and send to e-mail.
• ER diagrams are developed using TOAD Data Modeler.
• Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.
• Involved in creating and maintaining Partitioned Tables and Indexes for better performance of application
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Involved in handling the changes in compiling scripts according to the database changes.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning

Environment: Oracle 10g, Toad, SQL * Loader, Toad, PL/SQL Developer, SQL*PLUS, UNIX Shell Scripting, Oracle Reports, HTML, and XML, Informatica.