SUMMARY:

• IT Professional with 8+ years of experience in Requirement Gathering, Analysis, Design and Implementation of back - end modules for applications using the Oracle Relational Database Management System (RDBMS).
• Skilled in all phases of the SDLC (Software Development Life Cycle).
• Excellent skills in Designing and Development of Applications using Oracle PL/SQL.
• In depth Knowledge and experience of Data Warehouse/Data Mart design, Data Migration and Implementation concepts.
• Hands on experience on Data Warehousing Design Methodology, Data Warehouse Concepts, Database Design/Architecture including both OLAP & OLTP data and complete lifecycle of project from Design to Development and Implementation.
• Experience with OLTP on Optimized data validation of incoming data during transactions.
• Excellent knowledge on UNIX Shell Scripting.
• Strong experience in coordinating and providing support to UAT/QA Team during testing phase of Project.
• Excellent SQL skills, experienced in writing complex queries.
• Good knowledge of Data Modeling using ETL tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Experience in Bulk Data loading using Oracle utilities like SQL Loader, External Tables.
• Experience in using Data sources/Targets such as Oracle, MS SQL ServerDB2, XML and Flat files.
• Expertise in Developing and Customizing Oracle Forms and Reports using Oracle Forms 11g/10g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database
• Strong experience on Advanced PL/SQL programming in implementing the concepts and features using Bulk Collect, Bind Variables, Ref Cursors, Execute Immediate, Exception handling, Procedures, Functions, Packages, Triggers, Autonomous transactions, Global Temporary tables, external tables, Hierarchical Queries, Aggregate Functions, Analytical Functions, Batch Jobs.
• Extensive experience in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized View, DBMS packages and exception handling, Global Temporary tables and Troubleshooting Oracle database issues.
• Good Knowledge on Client-Server application development using Oracle … PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• In depth knowledge of RDBMS concepts, with hands on exposure in the Development of Relational database environment using SQL and PL/SQL using database tools like PL/SQL developer, SQL developer, Toad, SQL Navigator.
• Proficient knowledge of PL/SQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections.
• Highly organized and efficient to prioritize and manage multiple tasks with an ability to adapt to new technologies and project environments.

TECHNICAL SKILLS:

Languages: SOL, PL/SQL, UNIX Shell Script

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2000, MySQL 5.5/5.0/4.0.

Development Tools: TOAD v11.0/v10.6/v10.5/v9.5/v9.0, SQL Developer 3.2/3.1/3.0/2.1, SQL Navigator, SQL* Loader, Oracle EXP, Oracle IMP, ODBC, FTP, VSS, Ultra Edit v17.0/v16.0/v15.0, SQL*Plus, ERWIN, Oracle Warehouse Builder (OWB), Oracle Enterprise Manager (OEM)

Operating Systems: Windows 2000/8/7/XP/NT, Linux, UNIX

Methodology/Best Practice: Oracle CDM Advantage 2.0

Database Management: Database Design, Development & Maintenance

Scripting: Bash Shell, HTML, XML, SQL

PROFESSIONAL EXPERIENCE:

Confidential - Duluth, GA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked with the project Stakeholders and Users in understanding the Business requirements for the project.
• Planning development timelines, Tracking development status and delivering all deliverables on time.
• Participated in day to day agile processes like scrums and sprints.
• Design and Develop Oracle Packages, Functions, and Procedure and Postgres functions.
• Install Postgres and Clone Production databases to Lower environments.
• Participated in the Analysis phase, preparing the technical specification, Development and Testing documents.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Responsible for System/Software upgrades configuration.
• Responsible for Code reviews.
• Involved in User Acceptance testing and Post production support. Ensured that all defects are resolved by team within time.
• Trained interns with System architecture, Project guidelines and Development processes.
• Build and maintain Oracle PL/SQL packages and stored procedures (using TOAD and PL/SQL developer), Workflows, and SQR reports as requested by client, for Processing and Analysis.
• Used Ref cursors and Collections for accessing complex data through joining many tables.
• Extensively involved in Performingdatabase, SQL's, API's tuning and optimization.
• Handled Exception extensively for the ease of debugging and displaying the error messages in the application.
• Coordinated with front-end Developers for implementing logic in stored procedures and functions for faster retrieval of data.
• Improved the application performance significantly by tuning SQL Queries and PL/SQL program units
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexing and Partitioning of tables.
• Performed need based DBA activities like DB schema creating and maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.
• Interacting with UI development team to Develop in tandem back-end solutions with front-end web executions.
• Designed and developed the data migration Scripts and Programs to upgrade the Development, QA, UAT and Production DB schemas upgrade to Oracle 12c from Oracle 11g in Development and Production Environments.
• Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.
• Worked as the Production support engineer for more TEMPthan 15 Universities.
• Developed test cases that were used in conjunction with the Quality Assurance team to validate code.
• Interacted with Business Users in creating Unit and System Test cases for enhancements in the existing application.
• Application support in resolving production problems for existing application and ensure all issues get resolved accordingly.
• Delivered tasks accurately in time provided.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL.
• Developed Oracle partitions, and performance tuning/query tuning.
• Created ETL transformations and jobs using Oracle using dynamic packages and procedures using oracle code.
• Used Git and Jira as our versions control and ticket submission tools.

Environment: Oracle 11g/12c, MongoDB, SQL, PL/SQL, TOAD, Oracle Developer, SQL*Loader, SQL*Plus

Confidential - Phoenix, AZ

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, database design, coding, and implementing
• Understand business requirements, design and document technical design for the business requirements
• Developed Oracle objects and Forms for loading and summarizing data and creating front-end application
• Loaded data into multiple tables using SQL Loader
• Used extensively PL/SQL, to develop packages, stored procedure, functions and database triggers
• Tuned SQL queries to improve performance
• Used Microsoft Visio for Dataflow and Entity relationship diagram
• Developed procedures, functions for different forms
• Used different joins, sub-query and nested query in SQL query, for reports
• Extensively used PL/SQL in reports to perform calculation and to get desired output
• Developed single HTML page to serve as a centralized menu for the web application, and tan broadcast URL
• Developed automated notification of Emails, using Unix shell script, to the users in case of failure in the process from time to time
• Implemented the technical and functional aspects of DEPOT project
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs
• Testing, Integration System test, Implementation (test with users) and documented the entire project

Environment: Oracle 9i, SQL*PLUS, SQL* LOADER, PL/SQL, Reports 6i, HTML, Java, Unix Shell scripts, Windows NT

Confidential

Oracle PL/SQL Developer

Responsibilities:

• me was part of Common Repository team to build a common data warehouse to support mobile reporting databases
• Developed Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase
• Many previous utilities in Pro C and C++ were written in PL/SQL to enhance their performance using oracle 10g database.
• Developed stored procedures / packages to run ETL jobs to extract customer information from OLTP database into data warehouse.
• Developed stored procedures to extract data to generate WEBFOCUS reports.
• Optimized many previously written utilities to perform better compared to their performance using oracle 9i.
• Implemented performance tuning using indexes, inline views and sub queries.
• Responsible in the migration efforts of NEXTEL customers from BCGI platform.
• Developed UNIX Shell scripts, Batch file to perform job scheduling and execute the utilities.
• Created installation libraries for the installation of the application on test and production, using WISE Software Packaging and Installation Tools.
• Converted the Functional requirement to technical design document, wrote utility release notes and install documents

Environment: Oracle10g, PL/SQL, Toad, Windows NT, UNIX Shell Scripts, Web focus Reporting, Wise Package Studio 7.0

Confidential

PL SQL Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Created and managed many objects in large Oracle Databases containing millions of records.
• Coded and debugged the Stored Procedures, Packages, Views and Materialized Views in Oracle Databases.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans, profiling and Trace sessions for Cost based Optimization.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Used SQL*Loader and UTL FILE for moving the data from flat files to staging area tables.
• Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
• Used shell scripting to change and modify data.
• Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and collecting statistics.
• Worked with OLTP database.
• Created and modified Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.
• Worked on ETL code conversion and DATA Stage in one of the Migration projects.
• Wrote PL/SQL procedures to created database objects dynamically based on user inputs.
• Involved in Unit testing and Integration System testing

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Cron), SQL*loader, Oracle Forms 10g, reports 10g, Stored Procedures/Triggers