SUMMARY:

• 8+ years of profound working experience in SQL, PL/SQL programming, System Analysis, Design, Development, and Support of Oracle Database … in Production, Staging, Development, and Testing Environments.
• Expertise in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Experience in developing External Tables, Joins, Indexes, and Sequences.
• Experience in query optimization, performance, and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Experience in using several built - in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, and DBMS SQL to name a few.
• Experience in all the phases of SDLC, including requirements gathering, system design, Development, Unit testing, Integration testing, implementation, and production support.
• Solid development skills in Oracle tools and technologies including Oracle Forms and Oracle Reports.
• Designed and developed various Oracle Forms and Reports for both Oracle Applications and Custom Development.
• Experience in Scripting using SQL, PL/SQL, UNIX Shell programs and providing production Support.
• Experience in Database design using Normalization and E/R Diagrams.
• Experience in configuration, development, and testing of AutoSys and other scripts.
• Experience in data loading from other databases and text files into Oracle database using SQL*Loader.
• Used Query tuning techniques for better performance and execution through suitable Indexes, primary-foreign key constraints.
• Experience in working with SQL Server Reporting Tools (SSRS) and SQL Server Integration (SSIS).
• Hands on experience in ETL process using different ETL tools and using PLSQL to populate the tables in OLTP and OLAP Data warehousing environment.
• Experience with XML packages, XML parsing and loading into Oracle.
• Experience in COBOL to analyze and modify Open Cobol modules.
• Expertise in using tools such as TOAD, Oracle SQL Developer, SQL*Plus.
• Experience in writing Technical design documents and developing Unit Test documents.
• Very good knowledge in C/C++, Java Script, Core Java.

TECHNICAL SKILLS:

Operating System: Windows 7/10, Linux, UNIX (Sun Solaris, HP-UX).

Oracle 12c/11g/10g/9i, MS: SQL Server.

Web Technologies: HTML, DHTML, Java Script, XML.

Languages: C, C++, SQL, PL/ SQL.

Scripting Languages: UNIX Shell Scripting

Database Tools: SQL*PLUS, TOAD, SQL*Tool, PL/SQL Developer

MS: Office (Access, Word, Excel, PowerPoint)

Version Control: CVS, SVN, GITHUB

Agile Tools/Methodologies: Jira, RTC, SCRUM

PROFESSIONAL EXPERIENCE:

Confidential, Portland,Oregon

Oracle PL/SQL Developer

Roles & Responsibilities:

• Developed various PL/SQL objects like procedures, functions, packages, and triggers in accordance with the business needs.
• Involved in interacting with the end-user (client) to gather business requirements and modeling the business requirements.
• Participated in analyzing the requirements for the logical and physical design of the database.
• Involved in tuning and query optimizing SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Collaborate with the DBA and Development Team in successful implementation of data warehouse release.
• Populating the data warehouse tables using SQL*Loader.
• Implemented complex views, procedures, functions, packages, and triggers in PL/SQL.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Applications database pool monitoring and thread monitoring in the JVM.
• Developed PL/SQL packages and procedures for the back-end processing of the proposed data base design.
• Created JavaScript to create end-user application, conduct testing and training, design user interface.
• Coded PL/SQL Procedures, Functions, and Packages for batch processing of the applications.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 11g/10g, SQL, PLSQL, Shell Scripting, Putty, JavaScript, Oracle SQL Developer, Toad, AutoSys, UNIX, Notepad++.

Confidential, Dallas, TX

Oracle PL/SQL Developer.

Roles &Responsibilities:

• Worked to Analyze, Design, Development, and testing of the application.
• Participate in development of the application by writing procedures, Functions, Triggers, Cursors, Complex SQL queries etc.
• Developed, Analyzing, and writing PL/SQL scripts. Ability to use advanced features such as ref cursors and built in package/complex SQL statements using multi table joins, exist clauses and ability to tune SQL.
• Worked on the scripts for Open COBOL modules according to the business requirement.
• Developed Test plans and Unit Testing, System Integration Testing through Production implementation
• Developed Oracle Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 11g/12c and Oracle Forms builder 11g/12c respectively in Web logic environment.
• Developed reports using complex queries as per business user request as a part of production support.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Developed Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Interacted with requirements team for new business requirements or enhancements or change requests to implement in the application.
• Created high quality and well documented code according to standards.
• Involved in daily status calls and meetings through Agile.

Environment: Oracle 12c/11g, TOAD, Oracle SQL Developer, Shell Scripts, Microsoft Visual Source Safe, Core FTP LE, PUTTY, Open Cobol, Forms Builder, Forms API Master, Oracle Forms 11g/12c, Oracle Reports 11g/12c.

Confidential, Austin, TX

Oracle PL/SQL Developer.

Roles &Responsibilities:

• Developed PL/SQL Packages, Procedures, and Functions in accordance with the business requirements for extracting legacy data and loading data into database tables as part of data migration.
• Involved as a key team member for Requirement Analysis during the design phase and developed various Design documents according to the user requirements.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Created technical mapping documents as part of data modeling and design.
• Created data stores, interfaces, procedures, packages, and scenarios in ODI repositories.
• Designed and generated Oracle Forms and Oracle Reports.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Generated dynamic web-reports using HTML, JavaScript.
• Efficiently designed the Database schema suitable for the client requirements. Implemented the Client-side HTML/ java script based Pages for User Interaction with the system.
• Coded several Unix Scripts to interface with several external databases, Sybase ASE and SQL Server and packaged applications. customers in troubleshooting issues with their applications in AutoSys.
• Physical Data Warehouse design, table partitioning, indexing strategy, materialized views, hands on with PL/ SQL, SQL development using packages and program units.
• Developed PL/SQL functions to facilitate business functions and calculations and did required modifications to the existing once.
• Created complex stored procedures, views, SQL joins and scripts.
• Create and edit SSIS packages including error management and logging.

Environment: Oracle 12c/11g, UNIX, Sybase 9.0, TOAD, JavaScript, Oracle SQL Developer, Oracle Forms 11g, Oracle Reports 11g, Putty, Shell Scripts, AutoSys

Confidential, Woonsocket, RI

Oracle PL/SQL Developer.

Roles & Responsibilities:

• Developed PL/SQL Procedures and Functions accordance with the business requirements for loading data into database tables.
• Created PL/SQL packages for calculation of metrics statistics across 13 states by including state and domain wise parameters which resulted in reducing the report generation time by almost 90%.
• Developed the SQL code for performance and penalty statistics calculation.
• Analyzed and framed the business logic for the ETL process as per the requirements.
• Created ETL Processes using Informatica Version 9.0.
• Executing Daily and Monthly reports in UNIX and automated the scripts using shell script.
• Created SQL Loader scripts to load data into temporary staging tables.
• Created scripts for Views, Materialized Views and Partitioned tables.
• Responsible for Analyzing and Implementing the Change Requests
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Created complex stored procedures, views, SQL joins and scripts.
• Writing high quality and well documented code according to standards.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in daily status calls with clients.

Environment: Oracle 11g/10g, SQL*Loader, SQL, PLSQL, Putty, Shell Scripting, Informatica 9.0, Oracle SQL Developer, TOAD.

Confidential

Oracle Developer

Roles & Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages, and SQL Scripts.
• Created numerous web based Forms and Reports.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• Developed Forms, Packages, Triggers, and Shell Scripts to load the staging table data into Traffic Mart System.
• Writing scripts to create partitions, exchange partitions, analyze for performance tuning.
• Developed packages, functions, procedures, database triggers as part of the ETL process.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, developing, coding, and testing.
• Creation of database objects like tables, views, procedures, packages using SQL* Plus and PL/SQL.
• Performed Data validations and mappings at staging table level.
• Created Complex Dynamic / Static / Parameterized Reports and Charts using Report 6i.

Environment: Oracle 10g, SQL, PL/SQL, Oracle Forms, Oracle Reports, Java, Putty, TOAD, XML, HTML, UNIX, SQL*Loader.