SUMMARY

• 10+ years of Information Technology experience as a database developer in various phases of software development including Analysis, Design, Development, Testing and Implementation.
• Strong experience in Oracle, SQL, PL/SQL, Sybase, UNIX.
• Experience in Banking, Finance and Insurance and Retail domains.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for Data warehousing environments.
• Created database objects like tables, views, sequence, synonyms, indexes using Oracle tools like SQL *Plus, SQL developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Experience in developing complex database objects like stored procedures, Functions, Packages and Triggers.
• Experience in Creating shell scripts for invoking SQL scripts.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP.
• Experience in Creating batch jobs, maintenance jobs, housekeeping jobs.
• Experience in Stored procedure optimization and Performance Tuning.
• Tuning of the SQL queries which takes long time to process the request using Explain Plan, hints to reduce the response time.
• Experience in preparing report specifications and database designs to support reporting requirements.
• Having knowledge in migration activates during the implementation of the new releases.
• Having knowledge on Oracle Forms, Reports.
• Excellent problem solving skills with strong technical, analytical and good interpersonal skills.
• Very good experience in full software development life cycle of development, maintenance & enhancement projects in both Traditional and Agile environments.
• Experience on version control tool SVN and CVS.
• Strong knowledge of data warehouse techniques and practices, dimensional data modelling (Star Schema, Snow Flake Schema, FACT & Dimension Tables) and design of Slowly Changing Dimensions (SCD) type1, type2.
• Making structural changes to the database objects.
• Executing, monitoring various UNIX ksh scripts, escalating and bug fixing the related issues as required, providing solutions, implementing code logic as per functional, adhoc requirements.
• Good experience in Unit Testing, Integration Testing and Performance Testing.
• Exposure and knowledge of designing logical and physical Data Model in Relational Database Management System (RDBMS).
• Expertise in batch processing, Unix shell scripting.
• Experience in writing Wrapper/Scheduler jobs and hands on experience in Autosys Tool.
• Experience in participating in creation and review of system technical design specs for projects/releases.
• Experience in Perl scripting.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import.
• Strong knowledge in Oracle 12c version.
• Done the data conversion from Sybase to DB2 and Oracle.
• Having Knowledge in JIRA tool.
• Dynamic team player with good communication skills who successfully coordinated cross functional teams with ease.

TECHNICAL SKILLS

Databases: Oracle 9i,11g,12c, Sybase Adaptive Server 12.5,15.5, DB2, Teradata

Programming Languages: SQL/PL - SQL, Unix shell scripting, Perl Scripting, Java, XML

Software/Tools: Eclipse 3.4, Putty, SSH tectia tool, Ops Console, HP Quality centre (QC), WinSCP, Rational Application Developer 7.5.3, Control M, Autosys, ERwin r7.1/7.2, Informatica

Database Tools: DB Artisan, Sybase ASE isql, Rapid SQL (Version 4), Squirrel Client tool, SQL Browser, Oracle SQL Developer, Toad

Operating Systems: Windows 7/2000/XP, Linux, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Goodlettsville, TN

Sr. Database Developer

Responsibilities:

• Analyze the design spec and developing PL/SQL as a part of business logic.
• Perform unit and acceptance testing.
• Perform system analysis to support business operations, develop recommendation for solutions to business problems and issues.
• Developed the shell scripts as a part of business logic.
• Agile development methodology with 2 week iteration planning.
• Involve in developing complex SQL, PL/SQL as a part of business logic.

Environment: Oracle 12c, SQL, PL/SQL, TOAD, SQL Developer, Unix, GitLab, ServiceNow, Windows 10.

Confidential, Miamisburg, Ohio

Sr. Oracle PL/SQL Developer

Responsibilities:

• Design and develop ETL spec documents.
• Analyze user requirements, procedures and problem to automate existing problems.
• Perform system analysis to support business operations, develop recommendation for solutions to business problems and issues.
• Perform analysis, design, and execution of procedures for data integration and migration.
• Involve in developing complex SQL, PL/SQL as a part of business logic
• Designed and developed DDL for Tables, views, rules, defaults for incorporating new or modifying existing functionalities
• Designed and developed Stored Procedures, SQL, PL/SQL, triggers, cursors for various change requests for incorporating new or modifying existing functionalities.
• Incorporating data normalization and referential integrity enforcement techniques.
• Done Stored procedure optimization and Performance Tuning
• Fine tuning/ Optimization of the database operation.
• Index creation, maintenance and fine-tuning of indexes, updating of statistics.
• Perform DDL/DML changes in QA, DEV, UAT, Production environments.
• Prepare improvement plan to avoid defects in Production releases.
• Review database design in architecture prospective in broader aspect and suggest the changes.
• Provide technical architecture overview and oversee the implementation of the same using various technologies required.
• Participate in creation and review of system technical design specs for projects/releases.
• Interacting with clients for collecting high-level user requirements, converting the business requirements into system requirements, estimating the time and effort require

Environment: Oracle 12c, SQL, PL/SQL, TOAD, SQL Developer, Java, HP Application Lifecycle Management (QC), CA SCM Workbench, UltraEdit, Unix, Informatica, Windows 7.

Confidential, Columbus, Ohio

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked on various phases of software development life cycle those including analysis, coding and production releases
• Involve in developing complex SQL, PL/SQL as a part of business logic
• Perform analysis, design, and execution of procedures for data integration and migration.
• Designed and developed DDL for Tables, views, rules, defaults for incorporating new or modifying existing functionalities
• Designed and developed Stored Procedures, SQL, PL/SQL, triggers, cursors for various change requests for incorporating new or modifying existing functionalities.
• Develop customized scripts for database extraction, Transformation and loading from one environment to other.
• Transferring bulk data to/from SQL Server using BCP.
• Checked feasibility of requirement with SQL and PL/SQL capabilities.
• Done PL/SQL Stored procedure optimization and Performance Tuning
• Fine tuning/ Optimization SQL, PL/SQL code of the database operation.
• Index creation, maintenance and fine-tuning of indexes, updating of statistics.
• Perform DDL/DML changes in QA, DEV, Production environments.
• Analysis cross database dependences and write complex PL/SQL stored procedure to resolve the cross database dependencies.
• Agile Scrum development methodology with 2 week iteration planning.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.
• Configure and schedule newly developed database maintenance jobs, housekeeping jobs etc.
• Develop scripts to modify existing database batch jobs, maintenance jobs, housekeeping jobs, Backups etc.
• Preparing Test cases and Fix bugs identified during testing.
• Analyze of AWR and ASH reports and improve the performance of the queries.
• Worked on Real Application Cluster (RAC) environment.
• Participate in various Phases of release in non-production and fix identified bugs, prepare improvement plan to avoid defects in Production releases
• Prepare troubleshoot document listing faced during project release in non-production environment
• Coordinate with DBA and developer team to analyze the performance issue of data servers and try to resolve it up to the business needs.
• Participate in creation and review of system technical design specs for projects/releases.
• Refreshing UAT/development data servers.
• Create script for database cleanup jobs to refresh non-production environment.
• Worked on migration from Oracle Database to Teradata Database.
• Interacting with clients for collecting high-level user requirements, converting the business requirements into system requirements, estimating the time and effort require
• Interacting with the client on a day-to-day basis to update work status, fill out any process related gaps and discussing new improvement plans.
• Manage team of 4 and responsible for timely delivery.

Environment: Oracle 11g, Oracle 12c, SQL, PL/SQL, TOAD, SQL Developer, Shell Scripts, UNIX, Perl, Control-M, XML, Java, Hadoop, Teradata, Rational Application Developer, XML Parser, HP Quality centre (QC), Windows 7.

Confidential

Sr. Database Developer

Responsibilities:

• Participate in requirement analysis.
• Wrote PL/SQL stored procedures, shell scripts, perl scripts in the enhancement projects.
• Preparing adhoc Reports and Scripts on Request.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers using Toad to implement the business logic.
• Worked on forms personalization and customization.
• Unit Test Scripts preparation and Unit testing.
• Providing L1 support to the Production issues.
• Product support and maintenance activities.
• Participate in Process Improvement efforts.

Environment: Sybase, Oracle, SQL, PL/SQL, Shell Scripts, UNIX, Perl, Squireel client tool, TOAD, SQL Developer, Putty, eclipse 3.4, Forms 6i/10g, ssh tectia tool

Confidential

Database Developer

Responsibilities:

• Worked on mapping of legacy attributes to new system (CLR) attributes.
• Developed Analysis and Design documents based on the Recovery business requirements.
• Worked on a part of this project (Claims Plan Migration) which was successfully completed and delivered.
• Worked on business services to translate legacy attributes to the respective ones in the new CLR system.
• Coordination with on-site team for any queries, allocate work for offshore team, monitor offshore work status.
• Conduct reviews at each phase and ensure timely good quality deliveries.
• Coding and Unit testing.
• Testing and Production support

Environment: DB2, C++, Q++, UNIX, Eclipse IDE, RAD 7.0, Star Team, Putty, MasterCraftTM

Confidential

Database Developer

Responsibilities:

• Worked on mapping of legacy attributes to new system (CLR) attributes.
• Developed Analysis and Design documents based on the Recovery business requirements.
• Coordination with on-site team for any queries, allocate work for offshore team, monitor offshore work status.
• Conduct reviews at each phase and ensure timely good quality deliveries.
• Developed Unit Test Cases and performed Unit testing.
• Fixed the defects in Developer Integration, Testing Integration & System Testing phases.

Environment: DB2, C++, Q++, Unix, Eclipse IDE, RAD 7.0, Star Team, Putty, MasterCraftTM

Confidential

Sr. Database Developer

Responsibilities:

• Analysis of the databases based on the regions.
• Communicating the owners of the databases for the migration time.
• Contributed in making automation of sending mails to the DB owners through Perl script.
• Written shell scripts to collect the data.
• Created the tables, indexes, and PL/SQL stored procedures as per the project requirement.
• Created the tables, indexes, and stored procedures as per the project requirement.
• Extensive interaction with thousands of teams and convincing them for Migration/Upgradation was carried out.

Environment: Sybase, Oracle, SQL, PL/SQL, UNIX, Perl, DB Artisan, SQL Developer, Putty, Edit Plus

Confidential

Database Developer

Responsibilities:

• Getting the owners of the databases, by analyzing and collection of the data.
• Communicating the owners that if the database is inactive raise a decommission request or provide the appropriate system to the database.
• Contributed in making automation of daily activity through Perl script.
• Created the tables, indexes, and PL/SQL stored procedures as per the project requirement.
• Analyzing and collection of the data.

Environment: Sybase, Oracle, SQL, PL/SQL, Shell Scripts, UNIX, Perl, DB Artisan, SQL Developer, Putty, Edit Plus

Confidential

Database Developer

Responsibilities:

• Creation of work orders (job specification) by analyzing the Sybase jobs and shell scripts.
• Configure equivalent job in DB2 framework.
• Perform testing, perform reconciliation for several days and prepare turnover related documentation for the configured jobs.
• I am also involved in analysis of any QC defects raised by the QA team.

Environment: Sybase, DB2, Oracle, SQL, PL/SQL, Shell Scripts, UNIX, Perl, DB Artisan, SQL Developer, Putty, Ops Console, HP Quality centre (QC), Edit Plus.