SUMMARY

• Around 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in Client - Server application development using Oracle 12c/11g/10g, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.
• Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• TEMPEffectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
• Created Tables, Views, Sequences, Constraints, Indexes (B* Tree, Bitmap and Function Based).
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, DBMS SCHEDULER, DBMS STATS.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables, and Collections.
• Experience in performance tuning and Query optimization using Explain Plan, TKPROF, HINTS and SQL Trace utilities.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution.
• Strong Experience in Extract, Transform & loading (ETL) data in Applications & Develop Data models using Star Schema & Snow Flake Schema’s.
• Experienced in UNIX shell Scripting.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Operating Systems: Windows 10/8.1/7/XP, Linux, UNIX, OS X

Languages: SQL, PLSQL, C

GUI’s Technologies: Oracle Forms 11g, Erwin, Oracle SQL Developer Data modeler.

Databases: Oracle 10g/11g/12c, SQL server 2014/2008/2000 , Oracle XML DB, MS Access.

Atlassian Tools: JIRA, Confluence.

ETL Tools: Informatica PowerCenter 10/10.1, MS SSIS

BI Tools: SAP Business Objects 4.1, SSRS

Utilities: SQL* Plus, SQL* Loader, Toad.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Responsibilities:

• Prepared program specification and development of PL/SQL packages, procedures and functions.
• Generated serverside PL/SQL scripts for data manipulation and validation.
• Loaded data into oracle database from flat files using SQL*Loader.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Optimized critical queries to eliminate Full Table Scans, reduce Disk I/O and Sorts.
• Created and scheduled the batch jobs using UC4 Scheduler.
• Used the Merge statement to select rows from one or more sources for update and insertion into one or more tables.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Used PL/SQL Collections (Nested Tables and Varrays) in complex backend packages.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, explain plan.

Environment: Oracle 12c/11g/10g, SQLSERVER 2017, Windows 10/8/7/XP, SQL*Plus, PL/SQL, SQL*Loader, Toad, SQL Developer, UC4 scheduler. FileZilla, Unix Shell Scripting, Microsoft TFS.

Confidential, Dallas, TX

Responsibilities:

• Direct interaction with the IT and Business teams for requirements gathering.
• Design and Code Reviews or any other deliverables prepared by the team members.
• Preparation of effort estimation for various tasks taken up.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Strong Experience in Extract, Transform & loading data in Applications & Develop Data models using Star Schema & Snow Flake Schema’s.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating SQL Packages to meet business requirements.
• Created mappings and workflows in ETL Tool Informatica PowerCenter 10.1.
• Created Web Intelligence reports using SAP Business Objects 10.1.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources
• Created Materialized Views for extracting the data from remote database.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to significantly improve performance.
• Good experience in physical and logical Data modeling using oracle SQL developer data modeler 4.1.1.
• Creating test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review).
• Strong experience with Bash and Korn Shell Programming.
• Involved in Creation of tables, Join conditions, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance.
• Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
• Used Explain Plan, SQL*TRACE for tuning the SQL statements by creating indexes.
• Supported the testing team with Defect Management, Requirement Analysis and SQL development for back-end and regression testing.
• Handled Production issues and manage the same in issue log.
• Involved in design SIGN OFF meetings with Architecture team and implemented the suggestions as per the meeting minutes.

Environment:: Oracle 11g/12c, Oracle PL/SQL, TOAD 11, WINSCP FTP tool, SQL loader, Informatica Powercenter 10.1, SAP Business Objects 4.1, Autosys Job Scheduler r11.3, Oracle SQL developer Data Modeler 4.1.1, JIRA, Confluence.

Confidential, Dallas, TX

Responsibilities:

• Rigorous technical analysis using Oracle’s 10g (upgrading to 11g) features for providing better solutions.
• Preparation of wrapper scripts for all the database processes and data quality checks using Unix Shell scripting.
• Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
• Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.
• Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• TEMPEffectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
• Implemented multiple-table links requiring Complex Join statements, including outer-joins and self joins.
• Involved in GO-LIVE zones and provided support through ON-CALL sessions.
• Created Tables, Views, Sequences, Constraints, Indexes (B* Tree, Bitmap and Function Based).
• Performed unit test on the developed code to ensure that its bug free.

Environment:: Oracle 11g, Oracle PL/SQL, TOAD 9.1/10.5, VI editor, FileZilla FTP tool, SQL loader, Oracle Times Ten, Autosys job scheduler.

Confidential, Austin, TX

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Discussed and analyzed business functionality with the client and the developers.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Good Understanding of OLAP Functions.
• Created PL/SQL program units to implement DML, DDL statements using Dynamic SQL.
• Used the Merge statement to select rows from one or more sources for update and insertion into one or more tables.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Used PL/SQL Collections (Nested Tables and Varrays) in complex backend packages.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan documents for all back end database modules.
• Good knowledge of using Control-M Scheduler.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution.
• Extensively worked on Explain Plans and various hints for Performance tuning.

Environment:: Oracle 10g/11g, Solaris 10, Windows XP, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, TOAD.

Confidential

Responsibilities:

• Created the Object Relational Database Tables with all the necessary Constraints.
• Direct interaction with the IT and Business teams for implementation of CDW and Developing the Data warehouse with multiple customizations pertaining to each country.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections and Triggers.
• Used All Control Structures like IF, CASE, For, While Loops for standard PL/SQL programming.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created and managed primary data base objects such as Tables, Views, Sequences, and Synonyms.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Loaded data from flat files to temporary tables in Oracle database using SQL*Loader, Collections for better performance.
• Worked in Maintenance of the system and debugging of the code whenever necessary.
• Used Exception Handling for validation of input and displaying the error messages in the application.
• Used Explain plan, TKPROF to gather the statistics along with analyze command for performance tuning.
• Tested, Installed, Documented and provided On Call Support for the Applications.
• Involved and halped application development teams to implement load tests to asses load on APPLICATION layer and DB layer and noticed the performance bottlenecks on DB side and provided fixes as per need.
• Created test data and performed various tests in load test environment to gauge the DB performance.

Environment: PL/SQL, Red Hat Enterprise Linux 6, SQL, SQL*Plus, SQL DEVELOPER, SQL*Loader, Oracle 10g, Windows XP.