SUMMARY:

• Over 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 leading software development on software projects from conception through implementation, execution and maintenance with timely delivery against aggressive deadlines.
• Efficiently worked and deployed distinct Client - Server applications using Oracle 12c/11g/10g PL/SQL, iSQLPLUS, SQL *PLUS, TOAD and SQL*LOADER
• Proficient in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Packages
• Created Tables, Views, Constraints
• Created Shell Scripts for invoking SQL scripts
• Have automated many jobs using unix crontab in unix
• Have used Autosys as automated job control system for scheduling, monitoring and reporting jobs.
• Strong skill set in using Oracle utilities like iSQLPLUS, SQL*PLUS, SQL*Loader, TOAD.
• Loaded Data into Oracle Tables using SQL Loader.
• Expertise in complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.
• Partitioned large Tables using range partition technique.
• Tuned SQL queries to improve performance.
• Good knowledge on SQL Performance tuning using Cost-Based Optimization (CBO) and Exception handling.
• Good experience in Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in using Bulk collect, and Bulk binds
• Troubleshoot and debug system and/or data errors.
• Uncommon determination to learn and ability to learn fast

TECHNICAL SKILLS:

Database: Oracle 10g/11g/12c (SQL, PL/SQL)

Operating System: UNIX, Windows NT/2000, and Windows XP

Programming Languages: C, C++, Perl, Python, PL/SQL, Shell Scripting (sh/ksh/csh)

RDBMS: ORACLE

Markup Languages: XML, HTML, XHTML

Utilities: SQL*PLUS, iSQLPLUS, SQL*Loader, and TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Oracle Developer

Responsibilities:

• Worked on Commissions and fraud applications
• Used SQLDeveloper as oracle database tool.
• Worked on oracle 11g
• Loaded datas from different source systems to import database
• Used JIRA as ticket tracking tool
• Worked on data loading and calculation part for the commissions application.
• Worked on packages, procedures, functions and various other database objects
• Have fine-tuned sql queries
• Have worked on new requirements, as well as enhancements
• Have done couple of performance tuning using collections, bind variables, indexes, and partitioning
• Used GIT and Stash for version control to checkin and checkout code and to run scripts to make changes in database objects
• Have supported testing team whenever a bug is raised and worked on providing fix.
• Worked on Agile methodology and made releases every 4 weeks

Environment: Oracle 11g, GIT, Stash, SQL Developer, JIRA, Windows XP

Confidential, Alpharetta, GA

Database Developer

Responsibilities:

• Worked on data extraction and population process
• Implemented solutions for data quality issues
• Developed database objects to facilitate consistent data entry into the database
• Created staging tables to load data files from source systems
• Worked on views and Jsons to populate data to target tables
• Have done database masking for lower environments
• Worked on mappings before a table sits on database
• Worked on new requirements as well as enhancements
• Assisted testing team after the code has been moved from build stage
• Involved in creation of various indexes on relational tables
• Developed back end interfaces using packages and procedures
• Worked on query optimization and performance tuning
• Have done couple of performance tuning using collections, bind variables, indexes, and partitioning
• Used Tortoise SVN for version control
• Translated business into technical requirements

Environment: Oracle 11g, DB Visualizer, Tortoise SVN, Windows XP

Confidential, Tampa, FL

Oracle Developer

Responsibilities:

• Worked on risk and fraud control applications
• Followed agile methodology, a fast paced working environment and made releases every 2 weeks
• Used toad 12.1 as oracle database tool
• Created SCR (Software change request) to meet the business requirements
• Worked on oracle 11g
• Have used bulk data loading utilities like sql loader nad external tables
• Have done export / import schemas and tables
• Built the ETL source to Target specification documents by understanding the business requirements
• Used oracle hints like index, no index and parallel
• Have run queries in parallel to improve performance
• Worked on JavaScipt and AngularJS to support internal error report portal
• Developed mappings that perform Extraction, Transformation and load of source data into Target Schema and tables in Informatica
• Worked on large database having trillions of records
• Have done couple of performance tuning using collections, bind variables, indexes, and partitioning
• Used GIT for version control to checkin and checkout code and to run scripts to make changes in database objects
• Once the development and unit testing is done, rolled it to integration environments and finally to prod
• Supported the issues raise in QA and redelivered the patch on time

Environment: Oracle 11g, TOAD, GIT, SQL Developer, Windows XP

Confidential, Auburn Hills, MI

Oracle PL/SQL Developer

Responsibilities:

• Worked on a banking application that involves lots of transaction, Financial information and lot other details in Oracle database
• Using Shell scripting and Oracle as database worked on database development and maintenance project
• Wrote tuned SQL queries to fetch huge number of data without any time delay and processed it as required
• Created database objects like procedures, functions, triggers, views to accommodate the new functionality as per the client requests
• Extensively Worked on Packages, Procedures, Functions, Views, cursors, ref cursors, table functions and Triggers in Oracle PL/SQL 12c/11g
• Changed database objects without affecting the other modules which depend on it and have done the regression testing, if required
• Used SQL*LOADER to load data into database from flat files
• Worked with high volume data and Performance Tuning using various types of Hints, Partitioning and Indexes
• Have automated data loading in database from various format flat files by creating unix shell scripts
• Extensively used global temporary tables and ref cursors to store and process data
• Actively involved in creating indexes and partitions on tables for Optimization and Tuning for enabling maximum database efficiency
• Created functions for complex data parsing of multiple input parameters in Oracle
• Used Autosys JIL (Job information Language) to create jobs.
• Created new documents as well as maintained and updated the existing documents of the project

Environment: Oracle 12c, 11g, SQL * Plus, iSQLPLUS, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, Troy, MI

Database Developer

Responsibilities:

• Involved in various phases like Analysis, Detailed design, Development, Maintenance, Testing and deployment
• Created User Schemas, tables, indexes, sequences, and views.
• Created and developed Oracle PL/SQL packages, stored procedures, functions, and anonymous blocks
• Involved in creating UNIX shell scripting.
• Have done defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Modified existing Code according to the requirements
• Documented all modules for user level and system level maintenance
• Performed complex scripting and querying in both the development, testing as well as production environment
• Worked on Data Transformations, Data Loading, Database Modeling and Performance Tuning
• Worked on troubleshooting defects in timely manner.
• Resolved technical related issues and documented procedures

Environment: Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, UNIX Shell scripting, Windows XP

Confidential, Greensboro, NC

Oracle PL/SQL Developer

Responsibilities:

• Worked for a billing Application Maintenance Project on which maintained and extended the application system for better performance and efficiency
• Created and reorganized all types of Oracle database objects including tables, views, indexes, sequences, synonyms and setting proper parameters and values for all the objects
• Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks for better performance
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created Shell Scripts for invoking SQL scripts
• Created and modified several UNIX shell scripts according to the changing needs of the project.
• Used different joins, sub-queries and nested queries in SQL query
• Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, and Materialized Views
• Used the Cursor for Loop to fetch unconditional number of rows
• Imported/Exported data from/to different databases using utilities like SQL*Loader
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Involved in the continuous enhancements and fixing of production problems.
• Verified and validated data using SQL queries
• Analyzed and prepared High and low level designs
• Made clear, maintainable, efficient and reusable codes

Environment: Oracle 10g/11g SQL, PL/SQL, UNIX, SQL*Loader, SQL Navigator, TOAD, SQL DEVELOPER

Confidential

Programmer Analyst

Responsibilities:

• Programmed in Perl using Oracle as database on UNIX environment to accomplish the requirements of the client
• Have done production support with 24/7 uptime
• Have done debugging, monitoring and support kind of work
• Developed a mapping technique using Perl script that would take the SQL data and generate the XML output file on the UNIX system
• Created Tables, Views, Constraints
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Worked on C, C++ and data structures
• Created High level and Low level design documents to make enhancements in the existing database and on Unix server
• Responsible for gathering requirements
• Used Oracle utilities like SQL*Loader, TOAD, SQL*Navigator
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique
• Worked on CRs(Change requests) as equal as the new requirements
• Written bug free code to the possible extent and tested by self to avoid the bug elevation to the testing environment
• Identified the problem and fixed it, when something went wrong in production environmrent
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Had inter team and client interactions and discussions before the start of any work to avoid the miscommunication and to get the work neatly done.

Environment: UNIX, SQL*Loader, TOAD, SQL*Navigator, Oracle 9i/10g database, Shell scripting, Perl, XML