Objective:

Seeking Oracle PL/SQL or SQL developer position in a dynamic and challenging environment to make positive and progressive contributions.

Summary:

• Over 8 years of experience in software analysis, design, data modeling, development, testing, implementation, support and documentation of applications with specialization in Oracle technologies
• Good exposure in SDLC projects with various database systems experience preparing use cases, functional specifications, technical design specifications, DFDs, Visios etc.
• Competent in developing flowcharts, algorithms and UML diagrams required for design/development
• Extensive solid hands-on experience in Oracle Development - SQL, PL/SQL, Shell Scripting bash/ksh/csh , Java classes
• Proficient in creation of ODI objects and tailoring knowledge modules to suit publishing needs.
• Proficient in creation of database objects like stored procedures, functions, packages, tables, indexes, triggers, snapshots etc. Good experience in performing data migrations, data loads using ETL tools
• Experience in writing OOP PL/SQL codes for applications demanding type objects, nested tables
• Strong experience in performing SQL tuning and PL/SQL application performance tuning with good understanding in Explain Plan, Statspack, SQL Trace TKPROF, SQL Analyze, DBMS traces and OEM/Diagnostics
• Good exposure to DBA routine tasks like managing users, roles, privileges, schema and objects, developing database triggers for user access audit and reporting
• Experience working with designing and reporting tools like Oracle Forms/Reports
• Good experience in database supporting languages like WMI, Perl, J/Python, VBScript and in using Oracle APIs OCI OCCI
• Experience working with geographically distributed team
• Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills and excellent interpersonal and communication skills, self-starter and a quick learner
• Experience in designing logical database models using Data Modeling tools like Oracle Designer, ERWin, WorkBench, SQL Developer
• Experience in job scheduling using CRON utilities, legacy AT scheduler, windows scheduler, Toad
• Experience in Oracle AQ Streams JMS PL/SQL coding of applications following publisher-subscriber model
• Enthusiasm for learning new technologies
• Strong problem solving and analytical skills

Technical Skills:

Work Experience:

Confidential

Role: ORACLE SQL DEVELOPER

Environment: Oracle 11g, RHEL 5, SQL Developer, PLSQL Developer, ODI, Apex, Putty, Perl, Python/Jython

Responsibilities:

• Wrote procedural and SQL analytic codes for publishing dataset for OEM catalogs
• Documented business rules, functional specifications, technical assessment and technical design specifications for service request SR and change request CR for application
• Analyzed C/Java sources to gather business rules for the application and converted them into PL/SQL codes
• Designed data flow diagrams, algorithms and flowcharts to assist in the Agile SDLC approach for implementing CR/SR and data migration
• Worked on data mapping documents to associate feeds with data models
• Analyzed older application's datasets to collect data pattern/constraints for migration purposes to a new development framework
• Wrote PL/SQL codes to apply data transformations from Oracle to SQL server and PostgreSQL
• Used Oracle Data Integrator ODI to create packages, interfaces, procedures, scenarios and load plans that assisted in publishing the data for part catalogs
• Wrote various levels of SQLs that utilized set based approach of handling datasets.
• Wrote business rules in Python, Jython and core Java

• Fine-tuned and tailored the knowledge modules in ODI to suit the performance thresholds of publishing operations
• Integrated SQL Developer unit testing framework with ODI scenarios and load plans
• Fine-tuned poorly running SQL queries by examining execution plans
• Used JIRA and Accurev to build change packages for source code promotions
• Utilized Total Recall Oracle Flashback feature to progress changes-only results to target entities via flashback differencing and versions queries
• Used SQuirreL tool for Transbase CD to push Oracle data/metadata for CD/DVD building of published data
• Created differencing cursors to push delta records to offsite production environments through exp/imp
• Created APEX pages for reporting purposes of ODI load plan runs and gathered DML metrics display

Confidential

Role: ORACLE DEVELOPER

Environment: Oracle 9i/10g, UNIX, Linux, Toad, Oracle Forms/Reports 9i, Oracle AS 10g, Putty

Responsibilities:

• Extensively used PL/SQL programming for creating/maintaining applications involving different databases
• Prepared technical specifications documents for procedures and packages
• Involved in the development of new procedures, functions, triggers and updating of the old ones based on the change requests
• Developed new forms used to extract data from different systems and criteria
• Utilized tools like TOAD during development of the application
• Responsible for running batch scripts and wrote shell scripts for migration process in UNIX
• Involved in direct discussion with the end users to study the requirements and helped in the development of functional specifications to meet their requirements
• Worked with PERL environment
• Compiled bash/ksh scripts for job automation
• Created materialized view/snapshots to increase the performance in data warehousing environment
• Fine tuned SQL Queries using explain plan, hints, virtual indexing, and SQL Analyze for maximum efficiency and performance
• Involved in the production support and solved the tickets that were raised by the end users
• Wrote korn shell scripts for automatic execution of the stored procedures
• Updating of the existing reports and forms with additional functionalities
• Automated sFTP and FTP process

Confidential

Role: ORACLE DBA/ PL-SQL DEVELOPER

Environment: Oracle 9i/10g, UNIX, RMAN, Oracle Application Server 10g, Toad, Oracle Forms/Reports 6i, Oracle JDeveloper 10g

Responsibilities:

• Directly involved in maintaining multiple Oracle 9i/10g databases
• Monitored production and development Oracle servers and conducted proactive maintenance
• Did some schema refreshes with import/export from development to production systems and vice-versa
• Documented the migration procedures required to convert 2-tier application model to 3-tier model with Oracle Application Server 10g plus Oracle FailSafe and wrote batch files to automate the migration
• Wrote PL/SQL procedures, functions, triggers and back-end modules for usages of standalone applications extensively
• Wrote shell scripts, VBScripts, WMI scripts and Java codes for applications to interact with databases
• Used SQL Analyze and Virtual Indexing and Explain Plan to fine-tune poorly running queries
• Wrote modules/packages for application involving Oracle AQ Advanced Queuing Streams systems for back-end data transfers with XML type objects
• Created multiple Oracle Forms/Reports for project purposes using Oracle Forms/Reports 6i and Oracle Developer Suite 10g
• Data loading from flat files using SQL Loader and external tables
• Exposure in writing some client Pro C codes for database downtime mgmt. by system admins
• Audited Oracle databases with benchmarks provided by Center for Internet Security CIS and rectified vulnerabilities
• Obfuscated high-priority PL/SQL packages using wrap utility and vaulted original sources in repos
• Configured scripts for centralized RMAN system for distributed databases and backup notifications
• Assisted other developers in compiling ActiveX scripts for multiple reporting/job scheduling purposes in MS-SQL Server 2005

Confidential

Role: PL/SQL DEVELOPER

Environment: ORACLE 10/9i, MySQL 5.0, RHEL 2.1 ES, Solaris 9, OEM, Toad, Oracle Designer, WorkBench

Responsibilities:

• Involved in the proactive and reactive tuning for SQL Queries in order to enhance the retrieval of data using EXPLAIN PLAN, TKPROF and SQL Trace
• Interacted with designers for preparing the detailed design and UML diagrams, delegated and communicated effectively with the team members and the QA team
• Extracted data from various distributed databases and loaded into Oracle Database on a monthly basis using SQL LOADER and external table
• Created PL/SQL stored procedures and functions in order to validate various new orders, it included deploying the entire packages using exceptions, constraints, auditing tools
• Created and scheduled numerous shell scripts useful for loading files into Oracle also involved in automating the file transfer process, report generation process
• Involved in the data extraction and data conversion of fixed format and CSV files using external tables
• Developed processing logic for data validation procedures and functions for verifying and uploading into respective schemas
• Involved with DBAs in creation of tablespaces, users, privileges, indexes, constraints, triggers, synonyms, roles, partitioning etc.
• Wrote anonymous PL/SQL blocks to BULK COLLECT large data and assist in data migration between multiple databases
• Involved in creating user authentication module for web based reports used PHP/HTML for front-end development and MySQL as RDBMS
• Hands on experience using MySQL Workbench for logical data modeling and schema export/import

Confidential

Role: Trainee/ Jr. Database Developer

Environment: MySQL, ORACLE 9i/8i, RHEL 2.1 ES, Windows 2000

Responsibilities:

• Involved in the installation of Oracle 9i/8i in RHEL/Windows
• Involved in the design of logical databases
• Involved in the conversion of logical database to physical implementation
• Assisted administrators in migration of servers running Oracle 8i to Oracle 9i
• Set up and managed user accounts/profiles
• Wrote SQL query to get data from the database related to ISP customers
• Wrote DDL scripts and created tables, indexes, views, synonyms, roles
• Created new tables, integrity constraints primary key/foreign key in Oracle 8i/9i
• Implemented business rules on data using stored procedures, functions and packages
• Wrote and suggested SQL and PL/SQL scripts to meet performance requirements