SUMMARY:

Certified Oracle Professional (OCP) with 13+ years hands on experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (Sql, PL/SQL).

EXPERIENCE SUMMARY:

• 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 and Web applications using SQL, PL/SQL, and Shell Scripts and relational databases like Oracle 9i/10g/11g/12c on UNIX and Windows platforms.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Extensive experience with SQL*Loader/External table for loading data from files.
• Proficiency in job scheduling tools with Cron Jobs and oracle Job Schedulers.
• Expertise in Bulk Collections for better performance and easy retrieval of the data by reducing context switching between SQL and PL/SQL engines.
• Developed DDL/DML scripts, Stored procedures required for migrating data from legacy systems.
• Proficient in Oracle, PL/SQL, Extraction Transformation and Loading (ETL) concepts.
• Expertise in UNIX shell scripting.
• Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers, creating tables, views and materialized views using Oracle SQL and PL/SQL.
• Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer.
• Proficient in Oracle SQL Tuning and PL/SQL debugging.
• Experience in performance tuning using various types of Hints, Partitioning, Indexes, SQL Trace, TKPROF, Explain Plan and AWR reports.
• Experience with Oracle supplied packages, dynamic SQL, records and PL/SQL tables.
• Extensive experience in client facing roles and working in multicultural, multi - geographic teams.
• Vast experience in support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle.
• Ability to be an effective team player and work under time constraints.
• Deep understanding of Software Development Cycle (SDLC) and worked on various models like Waterfall, Agile.
• Hands on experience in supporting QA/UAT testing and providing immediate resolutions/work around for production issues.
• Experience with data flow diagrams, entity relationship modeling and design techniques.
• Expertise in troubleshooting issues while building, deploying and in production.
• Ability to grasp latest technologies and applying new tools to build applications.
• Excellent problem-solving abilities, communication skills and diagnostic skills.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix

Programming Languages: PL/SQL, Core Java, HTML, CSS, XML, Pro*C, PythonUnix shell scriptingDatabases: Oracle 9i, 10g, 11g, 12c, MS SQL Server 2005

Tools: Toad, PLSQL Developer, SQL Developer, PuttyRobo Help, Inno Setup, Erwin, SQL*Plus, SQL Loader

Technologies: VB, Oracle Forms and Reports, Informatica

Job Scheduling: Cron jobs, Oracle user scheduler

Version control: SVN, GIT

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Responsible for gathering business specifications directly from the client and converting the specifications into technical/functional documents.
• Prepared the design specifications for the business processes and validations based on the gathered requirements.
• Involved in redesigning the application to accommodate the functionality of the legacy billing system while migrating to Confidential .
• Involved in migrating 12 legacy billing systems to Confidential successfully.
• Supporting integration and end user testing with efficient defect management process.
• Performed modifications in existing Packages and procedures and created new DB objects as well.
• Improved the performance of the application by rewriting the SQL queries.
• Identified and implemented programming enhancements.
• Extensively involved in analyzing the impacted components and providing solutions to it.
• Transformed the complex business logic and calculations into coding.
• Used Exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in production support by efficiently debugging the production issues.
• Involved in extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Modified complex functions and procedures to meet requirements, identified bugs and fixed them.
• Involved in performance tuning of the queries and PL/SQL code reengineering with the help of AWR report, SQL Trace and Explain Plan.
• Worked on data modelling with Erwin Data Modeler tool.
• Worked in SQL*Loader/External tables to load data using flat files from legacy system.
• Extensively used Cursors, Bulk operations, Procedures/Packages, Triggers etc.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle.

Environment: Oracle 11g, PL/SQL, Toad, Unix, Putty and Git

Confidential, Newark, DE

Responsibilities:

• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Analytical functions like Rank, Dense rank, lag and lead were used extensively.
• Exception handling involving user defined exceptions were used to log errors.
• Ref cursors were used to return multiple rows of data to API procedure calls.
• Query optimization techniques were adopted to improve the efficiency of long running queries.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Worked in Database Development like developing/creating Stored Procedures, Packages, Functions, Table creation scripts & Database Triggers, Synonyms, Indexes, Views, Materialized Views and Cursors.
• Involved in framing SQL queries for validating data between data warehouse and source systems.
• Implemented several types of constraints on tables.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Transformed the complex business logic and calculations into coding.
• Development of product enhancements and do unit testing after completing the code development.
• Extensively used Bulk Collect operations.

Environment: SQL, PL/SQL, Oracle 11g, SVN, Putty, UNIX Shell Scripting, UNIX, Windows.

Confidential, Newark, DE

Responsibilities:

• Gathering required data, data analysis and documentation of the plan.
• Gathering data elements needed for analysis of the data, decoding flat file data and loading into database tables using SQL* Loader.
• Created materialized views, partitions, tables, views and indexes.
• Involved in tuning and optimization of SQL statements.
• Created/modified the procedures, functions and packages to support data conversion.
• Responsible for data mapping from legacy system to Oracle.
• Created database objects like tables, synonyms, sequences, views.
• Used SQL hints and indexes to improve the performance of queries.
• Checked explain plan of the SQL queries to improve the performance.
• Wrote shell scripts for automating the process of data loading and daily process.
• Provide support as Oracle Developer for this application.
• Controlling and monitoring user access to the database.
• Involved in creating test scenarios for QA.
• Responsible for deploying code in higher environments.

Environment: SQL, PL/SQL, Oracle 11g, SVN, Putty, UNIX Shell Scripting, UNIX, Windows.

Confidential

Responsibilities:

• Gathering required data, data analysis and documentation of the plan.
• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in function and procedure.
• Generate SQL Scripts and create views for reports.
• Used Toad to Extract and test the data in the database.
• Developed Database Triggers to enforce security.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Prepare technical documents for all the programs developed & generated.
• Responsible in coding and debugging.
• Help QA for writing test cases by providing functional information.
• Involved in designing front end application using Developer 2000.
• Used cursors extensively.
• Used Sql loader to load data from flat files to target tables.

Environment: SQL, PL/SQL, Oracle 11g, SVN, Putty, UNIX Shell Scripting, UNIX, Windows, Forms & Reports