PROFESSIONAL SUMMARY:

• 10+ years of experience in design, development and maintenance of Oracle Database back - end applications for supporting Banking & Financial, Retail and Health care domain requirements.
• Extensive experience in Oracle SQL, PL/SQL Programing, and Import / Export Utilities and UNIX shell scripting.
• Experience in preparing table design as per the requirements specification by applying normalization techniques. Created normalized and de-normalized tables as applicable.
• Experience in adhering to naming and coding standards while developing application and create required documentation for future reference.
• Experience in end-to-end database application development and maintenance involving in Requirements discussions, database design, implementation, code review and data modelling.
• Experience with development of Data Warehouse applications, including requirements gathering, design, implementation, and maintenance.
• Involved in data analysis for source/target mappings, created scripts for data processing and automations. Implemented data migration and conversion process and migrated data from non-oracle database systems to Oracle Database 11g.
• Proactively identified and corrected data quality issues.
• Experience with credit card, gift card and paypal payment settlement system process. Functional knowledge of credit card authorization, settlement and refund process.
• Involved and familiar in Change management process for Code deployment, Firewall security changes, Database Access control and tablespace encryption etc.,
• Experience in supporting Organization Disaster and Recovery excise. Supported Data center switch, between Primary and Physical standby databases.
• Experience in working with RAC database system with dataguard (Physical standby)
• Functional knowledge on Information classification like confidential information, Official information and Public content etc., Involved in developing databases for intranet and public facing web applications.
• Experience in using sftp - secure file transfer protocol to transfer files to external servers outside firewall
• Involved in establishing connectivity between Web applications and Database server by setting up required firewall rules. Worked with security teams to accomplish the same.
• Knowledge of database password encryption mechanism in UNIX server. Involved in developing shell script utilities to store and use encrypted passwords.
• Expert level experience on PL/SQL that includes Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Objects, Collections, Partitioned Tables, Triggers, Materialized view, Table Indexing, Oracle Domain text index and Object oriented programming.
• Experience in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table.
• Extensive experience in using Complex SQL Queries, Dynamic SQL and bind variables.
• Extensive experience in improving the performance of Query by minimizing the number of context switches between the PL/SQL and SQL engines Using TYPES, Collections, Arrays, BULK COLLECT etc.,
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof and Oracle Hints.
• 6+ years of extensive experience in supporting Large production databases
• Proficient in using UNIX Shell Script and Perl script.
• Experience in scheduling UNIX cronjobs, Oracle Scheduler jobs. Worked with relevant teams to schedule UNIX batch jobs in Autosys.
• Proficient in using several data loading methods like SQL Loader, Export/Import and Datapump methods.
• Extensive experience in writing complex batch processes using PL/SQL.
• Extensive experience in using Oracle XML DB functions, xmltype datatype and CLOB data type.
• Experience in using OEM (Oracle Enterprise Manager) for database application administration activities.
• Experience in providing solutions for High load on database, Exceeding active sessions, hung sessions, locked sessions on database etc., Used several database data dictionary tables like gv$ tables and DBA tables like gv$session, gv$sqlarea to analyze the issues.
• Skillful problem solver with excellent analytical skills.
• Responsible for interacting with business analysts and business users to identify reporting needs and business requirements.
• Good communication skills. Strong interpersonal skills; ability to interact with people at all levels.
• Experience in supporting production database system with 24x7 oncall rotation support.
• Technically competent and result-oriented with problem solving skills.

TECHNICAL SKILLS:

Languages: Oracle SQL, PL/SQL

Scripting: UNIX Shell Scripting, PERL

RDBMS: Oracle 11g/10g/9i

Other Tools: TOAD, SQL Developer

ETL: Datapump techniques, SQL Loader

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Horsham, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in development tasks on Oracle SQL and PLSQL along with unit testing and generating scripts for deployment.
• Reviewed PLSQL code and made sure coding and naming standards are followed. Modified packages to implement Sanofi coding standards.
• Worked with development and QA teams to identify and address database code issues.
• Analysed database sessions and provided solutions for High Active sessions count, locked sessions, waiting sessions etc.,
• Worked with .NET team and provided necessary complex queries for data retrieval.
• Analysed and modified database packages, in order to fix the defects raised by QA teams.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved and handled technical activities across multiple project modules.
• Involved in implementing sftp jobs to transfer flat files between internal servers and external servers
• Worked with security teams to implement firewall rules for the intranet and external servers
• Involved in development tasks on Oracle SQL and PLSQL along with unit testing and generate scripts for deployment.
• Designed table structure and data flow for the new requirements and enhancements
• Reviewed PLSQL code and made sure coding and naming standards are followed.
• Developed UNIX shell scripts and create batch jobs as per requirements
• Developed and enhanced various modules like market place, vendor fulfillment and Sales feed for Finance and Data warehouse teams.
• Prepared script and schedule sheet for new batch job for production deployment.
• Modified existing UNIX script for better performance and to adhere coding standard
• Promote UNIX batch jobs using PVCS and verify the same.
• Created and modified database objects like PL/SQL packages, functions, procedures, tables, views, materialized views etc., according to the requirements of front-end applications.
• Worked with functional users/business users/other team members to identify and address issues with payment settlement process. Involved in implementing process to charge customer credit cards as per the invoices created.
• Involved in data analysis for source/target mappings, created scripts for data processing and loading automation. Implemented data migration and conversion process and migrated data from non-oracle database systems to Oracle Database 11g
• Materialized views creation and setting up automated refresh jobs using Oracle Scheduler.
• Used Oracle XML DB and XMLTYPE data type and Oracle inbuilt utilities to generate XML from table data and to parse XML data into Relational data.
• Writing Complex SQL and PLSQL script with Analytical Functions, Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections and Dynamic SQL.
• Designing/modifying database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Created hash and range partitioned tables. Creating corresponding local or global indexes.
• Co-ordinated testing efforts with others teams for QA and user acceptance.
• Scheduled compression and roll off of new partitioned tables.
• Worked as individual, as part of team and as production on-call as and when needed.

Confidential, Washington DC

Oracle PL/SQL Developer and Logical DBA

Environment: Oracle Database 11g, SQL Developer, TOAD, UNIX

Responsibilities:

• Created and modified database objects like PL/SQL packages, functions, procedures, tables, views, materialized views etc., according to the requirements of front-end applications.
• Involved in Oracle Database upgrade from version 10g to 11g.
• Worked on materialized views creation and setting up automated refresh jobs using Oracle Scheduler.
• Worked on Oracle Text using Intermedia indexes and CONTAINS clause for SEARCH capability within Oracle.
• Used Oracle XML DB and XMLTYPE data type and Oracle inbuilt utilities to generate XML from table data and to parse XML data into Relational data.
• Created complex PLSQL script using Analytical Functions, Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections and Dynamic SQL.
• Designed/modified database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Provided solutions for production issues like High load, High Active sessions count, locked sessions, waiting sessions etc.,
• Involved in performance tuning using explain plan and Oracle Enterprise Manager.
• Involved in tuning existing views and materialized views using hints and indexes.
• Used Oracle DBMS Scheduler jobs and involved in migrating cronjobs from UNIX crontab into DBMS Scheduler jobs.
• Used Oracle 10g Datapump feature to sync data between QA database and Production database.
• Synching up development, testing instances with production database.
• Used DBMS STATS for analyzing schema tables.
• Database monitoring and checking ADDM reports using Oracle Enterprise Manager.
• Created UNIX shell scripts and Oracle Scheduler jobs to perform periodical batch jobs.
• Used Informatica tool to load Projects master data from SAP BI and other metadata from remote Oracle database.
• Responsible for production code deployment for biweekly release.

Confidential, Washington DC

Oracle PL/SQL Developer

Environment: Oracle Database 10g and 11g, SQL Developer, TOAD, UNIX

Responsibilities:

• Worked with business users and front end application teams to understand user requirements and converted the same into Database requirements.
• Created database design documents as per the requirements specification.
• Worked with other team members to implement back end functionality and test the code.
• Participated in discussions with business analysts to understand Investment functionalities and implemented required validations and alerts to proactively notify application/business users to avoid issues.
• Conducted code review and provided feedback to improve the performance and made sure to follow proper naming standards, coding standards for feasible maintenance.
• Developed database reference documentation for future reference.
• Worked on materialized views creation and setting up automated refresh jobs.
• Created packages, types, procedures and functions, Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections, Dynamic SQL.
• Created and used auto partitioned tables for application data and history data as well. Worked with DBAs to periodically purge the old history data as per BANK’s guidelines
• Implemented various modules which enables BANK to provide countries with Financing, Global Knowledge, Technical assistance, review and releasing funds etc.,
• Create all required database objects and batch processes to achieve the same.
• Involved in performance tuning using explain plan and Oracle Enterprise Manager.
• Involved in tuning existing views and materialized views using hints and index.
• Used Oracle DBMS Scheduler jobs to schedule batch jobs.
• Worked with DBA on Database upgrade from Oracle 10g to Oracle 11g.

Confidential

Oracle PL/SQL Developer and Logical DBA

Environment: Oracle Database 10g and 11g, SQL Developer, TOAD, UNIX

Responsibilities:

• Wrote complex queries and created required views and materialized views for Confidential team to index the data.
• Created and modified database objects like PL/SQL packages, functions, procedures, tables, views, materialized views etc., according to the requirements of front-end applications.
• Used Oracle XML inbuilt functions and XMLTYPE to create required XML structures for Search application to consume and index the same for Confidential capability.
• Worked on materialized views creation and setting up automated refresh jobs.
• Created Complex PLSQL script with Analytical Functions, Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections, Dynamic SQL.
• Provided solutions for production issues like High load, High Active sessions count, locked sessions, waiting sessions etc.,
• Involved in performance tuning using explain plan and Oracle Enterprise Manager.
• Involved in tuning existing views and materialized views using hint index.
• Used Oracle DBMS Scheduler jobs and involved in migrating cronjobs from UNIX crontab into DBMS Scheduler jobs.
• Used Oracle 10g Datapump feature to sync data between QA database and Production database.
• Synched up development, testing instances with production database.
• Database monitoring and checking ADDM reports using Oracle Enterprise Manager.
• Responsible for production code deployment for biweekly release.
• Created UNIX shell scripts and Oracle Scheduler jobs to perform periodical batch jobs.
• Supported 12 production databases on Oracle 11g RAC dataguard (with one physical standby) environment. Four of these databases are of size more than 5TB and several tables have more than 20 million rows
• Involved in Data center switch over (from DC1 to Dc2 and vice versa) which is conducted twice a year as part of Business Continuity Plan. Provided Application DBA support for this activity.
• Involved in Oracle Database upgrade from 10g to 11g. As part of this upgrade, around 30 databases were upgraded to 11g.
• Resolved production database high load issues, hung sessions issues, locked objects issues and Maximum open cursors issues etc.,
• Worked with UNIX admin to implement Database firewall rules for external applications access.
• Improved slow production queries performance by query optimization (tracing the query execution plan and using hints and indexes)
• Provided many temporary resolutions for highly critical productions issues without any impact on the system functionality, so that business continues until the permanent fix is applied.
• Worked as application DBA and involved in creating new tablespaces, schemas, Roles, Releasing locked objects by killing related sessions, exporting/importing schema level data using datapump methods.
• Synced QA databases data with Production databases by using import/export or Datapump methods (expdp/impdp). This was the regular maintenance activity to support QA application testing.
• Executed stats collection by using DBMS STATS package to improve database performance
• Created Partitioned tables and indexes

Confidential

Oracle PL/SQL Developer

Environment: Oracle Database 10g, TOAD, UNIX

Responsibilities:

• Created and modified database objects like PL/SQL packages, functions, procedures, tables, views, materialized views etc., according to the requirements of front-end applications.
• Used CLOB datatype to store actual HTML content and created supporting procedures to exchange the data between Application server and Database.
• Created customized packages to create XML structure for Content metadata and enable search on the same using Intermedia index (Oracle Text Search Domain Index).
• Worked on materialized views creation and setting up automated refresh jobs.
• Provided solutions for production issues like High load, High Active sessions count, locked sessions, waiting sessions etc.,
• Involved in performance tuning using explain plan and Oracle Enterprise Manager.
• Involved in tuning existing views and materialized views using hint index.
• Used Oracle DBMS Scheduler jobs and involved in migrating cronjobs from UNIX crontab into DBMS Scheduler jobs.
• Used Oracle 10g Datapump feature to sync data between QA database and Production database.
• Synched up development, testing instances with production database.
• Used DBMS STATS for analyzing schema tables.
• Database monitoring and checking ADDM reports using Oracle Enterprise Manager.
• Created UNIX shell scripts and Oracle Scheduler jobs to perform periodical batch jobs.
• Responsible for production code deployment for biweekly release.
• Provided complex Search queries to Application teams by using CONTAINS clause on Intermedia indexed columns.

Confidential

SQL Server Developer and Application tester

Environment: SQL Server 2005

Responsibilities:

• Provide required SQL queries for the application functionality and reporting purpose.
• Creating SQL Server functions and procedures for front-end web applications process.
• Understanding business functionalities and testing application for various applicable test cases and providing overall Test report and feedback.
• Understanding and documenting business rules, for new enhancements.
• Improved query performance by query optimization
• Unit test and debug developed software.
• Enhance and test application code as per the new requirement specification