AREAS OF PROFESSIONAL

ORACLE DEVELOPER

Programming Languages: Oracle SQL, PL/SQL, UNIX Shell Scripting, MySql, SQL Server, DBA Level Activity

Secondary: ELT Tool ODI, OBIEE Reports HTML, Oracle Forms 6i and Reports 6i.

Operating System: Windows, UNIX, LINUX

Databases: Oracle, MS SQL Server, Mysql, MS Access

Version Controlling Tools: SVN,MKS

Backup Tools: RMAN, Export/Import Utility, Sql Loader

Tuning Tools: TKPROF, Explain Plan, AWR, ADDM, SQL Autotrace

Other Utilities / Tools: Putty, Visio, Toad, Oracle Enterprise Manager, SQL Developer, iSQL, MySQL Client, SQL Server Management studio, MS Office (2003 - 2010)

Database Versions: Oracle 9i/10g /11g R2, 12C MS Sql Server 2008,2012, MySql 5.1

Operating System: Window 7,8, Linux

RACLE DEVELOPER SYNOPSIS

• Highly accomplished IT professional with over 6.5 years of SQL/PLSQL Coding Developing an applications.
• Good knowledge of Data Warehousing Concepts, Oracle PL/SQL and OBIEE Reports.
• Worked on ELT Tools (ODI) - Mapping Designer, Workflow manager, Workflow Monitor, Repository Manager.
• Responsible for Extraction, Loading and Transformation of data from Multiple Sources to Data Warehouse.
• DBA Activities such as creating new user Schema, Granting Access as per role, Taking Backup Oracle dump files.
• Programming experience including stored procedures, triggers, functions, packages, Views, Collections.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in Analysis, Design, Development and Implementation.
• Good exposure to each phases of Software Development Life Cycle (SDLC).
• Analysis of Existing Scripts and Performance Tuning Cost-Based Optimization (CBO).
• Experience in requirements Gathering, development of Applications, Testing, Implementation and Maintenance
• Creation of ER-Diagram, Technical Dataflow Documentation.
• Creation of User manual Gide and Application Flow Document.
• Good experience to build new production /UAT DB server, installation/de-installation and Restore from primary to secondary server using RMAN /User managed Backups.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Monitoring the databases health weekly and taking necessary actions if needed.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Software Developer

Responsibilities:

• Provide stats as per business requirement and Report based on the incident for impact analysis.
• Extensively Worked on ODI (Oracle Data Integrator) Tools - Mapping Designer, Workflow manager, Workflow Monitor, Repository Manager.
• Created BI Analytical Reports based on the reporting requirements provided by the end users.
• Worked as a single point of contact for all development activities for all environments and DBA activities for Test / SIT / UAT environments.
• Perform development activity coordinating with enhancement department for release of new functionality or enhance on existing functionality.
• Creating autosys job to invoke PL/SQL procedures
• Effectively made use of Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. 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.
• Create a script in the RMAS tool which generates alert email if any failure occurs. This helps to take action to reduce the impact.
• Performance tuning on old codes using Cost-Based Optimization (CBO).
• Creating/refreshing development/test/QA databases from production data
• Troubleshoot critical issues and bug fixes
• Testing new functionality development
• Monitoring disk space usage and purging of old data
• Work with ETL tool for Data sync across datacenter

Technologies used: Oracle 12C database, MS - Sql server 2012 database, MySQL 5.1 Tool: Used: TOAD, PLSQL Developer, MS Sql server client, MySQL Client.

Confidential . IT Engineer

Responsibilities:

• Manage the Application and bugs fixing
• Understand the User Requirement and Generate a Report for the user and Higher Management
• Provide Technical Support to the End user.
• Prepare a functional flow document for better understanding for new requirement.
• Technical support incase issue in Hardware and low level networking
• Performance tuning.

Technologies used: SQL Scripts, Oracle 10g database Tool: Used: TOAD, PLSQL Developer, Oracle Forms and Reports 6i

Confidential

Sr. Software Developer

Responsibilities:

• Developed Sql Scripts, stored procedures, functions, packages and Views using ORACLE TOAD XPERT and PL/SQL Developer
• Partial DBA activity (Creating new schema, Importing objects, providing Grant and Revoke, Data Backup)
• Creation an Import Export of database, sql loader files in Linux operating system to load the data into table.
• Perform a Data Migration activity for building a new production Environment.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Performance tuning
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Performed application test
• Involved in bug fixing
• Creation of database Technical Data flow and user Manual
• Coordinating and Gather project requirements

Technologies used: SQL/PLSQL, Oracle 11g database Tool: Used: TOAD Xpert, PLSQL Developer

Confidential

Software Developer

Responsibilities:

• Developed Sql Scripts, stored procedures, functions and packages using PL/SQL Developer
• Preparing a Reporting Frame work by configuring the scripts to generate different case scenarios of
• E-Insurance Reports
• Prepared Scripts for UAT(User acceptance Test)
• Performed application test
• Involved in bug fixing
• Troubleshoot critical issues
• Gather project requirements and system design
• Performance tuning
• Developed nightly batch jobs for production environment

Technologies used: SQL/PLSQL, Oracle 10g database Tool: Used:

PLSQL Developer

Confidential

Responsibilities:

• Developed Sql Scripts, stored procedures, functions and packages using PL/SQL Developer
• Prepared Scripts for UAT(User acceptance Test)
• Performed application test
• Involved in bug fixing
• Troubleshoot critical issues
• Gather project requirements and system design
• Performance tuning
• Involved in data migration

Technologies used: SQL/PLSQL, Oracle 10g database Tool Used: PLSQL Developer

Software Developer

Responsibilities:

• Developed stored procedures and packages using PL/SQL
• Developed front end applications
• Performed application test
• Involved in bug fixing
• Troubleshoot critical issues
• Documented user