PROFESSIONAL SUMMARY:

• Around 8+ years of IT experience in developing software applications using Oracle 12c/11g/10g/9i and its products in wide range of applications including Manufacturing, Banking and Telecommunication applications.
• Solid experience working on Oracle 12c/11g/10g/9i,Developer 2000/6i (Oracle Forms 6i and Reports 6i), PL/SQL, UNIX and Discoverer.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Good experience working in Agile Scrum Methodology, offline code review and Test Driven Development ensuring high quality of work is delivered.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Designed database schema's using Entity relationship modeling with ER diagrams& database normalization principles.
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Knowledge on Oracle Forms, Reports and Menus.
• Solid experience in writing and debugging stable and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, C, and UNIX scripts.
• Supported advance PL/SQL using Cursors, REF Cursors, and Dynamic SQL.
• Experienced with SQL performance tuning and optimization using execution plans.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind features with Collections instead of using cursors and FOR loops.
• Excellent analytical, verbal & written communication, interpersonal, team work skills and assertive leadership abilities with a high degree of professionalism and dedication to exceptional quality.
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.
• Solid managerial and administrative skills with good business understanding and excellent versatility and adaptability to manage multiple tasks.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i, MS ACCESS 2010

Languages: SQL, PL/SQL

Tools: TOAD, SQL Developer 3.0, SQL*Plus, SQL*Loader, Oracle Forms and Reports 10g/9i/6i.

Scripting: Unix Shell Scripting

Operating Systems: Windows 7, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Farmington Hills, MI

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked on Service Reminders, LiveRamp and Recall projects.
• Script and automate weekly chains using Appworx application in the UNIX environment for Mazda and Ford for the automation tasks.
• Update and modify PL/SQL procedures for Service requests, CIF (Customer Information) and DIF (Dealer Information) data based on Mazda business requirements.
• Modified Unix Shell scripts to get executed when Automation Chain is invoking the shell script from the remote server location.
• Wrote PL/SQL procedure for automation where email processing records are processed and sent automatically based on the schedule.
• Create new scripts for Data Extracts, Apply Process and Suppression Process chains.
• Update and create in Team Foundation Server Issue tracking mechanism.
• Involved in new project requirements and design implementation for both Mazda and USA accounts.
• Involved in migrating applications to the new release versions.
• Based on production data issues, analyze and locate the issue in the packages and procedures. Make modifications if required to proceed the weekly production process.
• Deploy data files to the vendors using SFTP as part of the weekly chain outputs and ensure the file data is right using data automation.

Environment: Oracle Database 12c/11g, UNIX, SQL, PL/SQL, PUTTY, Filezilla, Appworx, Team Foundation Server.

Confidential, Ann Arbor, MI

Sr. Oracle Developer

Responsibilities:

• Creating Stored Program Units in the form of Packages,Functionsand procedures for implementing the complex database intensive business rules.
• Document requirements and create technical specification documents
• Developed many batch jobs in Unix/Perl Shell Scripts for batch processing and to load bulk data files into database and generate outbound files
• Designed and developed EAA subprograms to move the data from legacy systems.
• Used TOAD/SQL Developer extensively to develop dB packages, triggers and views to implement business logic.
• Conducted meeting with System Analyst to explain the application functionality.
• Used Cursors to implement the Bulk Load and improve performance
• Extensively worked on Table Partitions,Materialized Views for speeding up the response of SQL queries.
• Developed SQL Loader programs to load data from flat files.
• Developed master-detail, matrix, and nested summary detail reports, using Reports builder and Discoverer.
• Extensively worked on SQL and PL/SQL performance tuning, improved performance of many application queries and batch processing jobs.
• Extensively used Analytical functions in the business application development.
• Involved in Code Reviews and preparing Unit test cases.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Submitted Quarterly review data from 2013 to FERC (Federal Energy RegulationCommissions) using Python scripts.
• Developed shell scripts for batch processing and database transactions.

Environment: Oracle Database 11g, SQL Developer, Oracle Reports Builder6i/10g, UNIX, ClearCase, WINSCP, SQL, PL/SQL, PUTTY, Windows 7.

Confidential, Jersey City, NJ

Oracle DBA

Responsibilities:

• Production and Development instance support.
• Maintenance and Enhancement Support. (Cloning, patching, Backup, Invalids, RM etc.).
• Plan and implement the DCC along with support to legacy databases.
• Tracking the entire request from the central tick tracking system.
• Maintain high availability of all the databases.
• Move the database to the centralized data center and co-ordinate with the Siebel application team for configuration during this we had used standard export import strategy for transfer.
• Optimized and enhanced the existing Procedures and SQL statements.
• Created/Updated Shell Scripts for automating the execution process.
• Followed Confidential ’s software process to implement the software solutions.
• Debugged Packages, Procedures, and Functions and fixed them according to the business requirement.
• Involved in daily based client data analysis and solving issues as required.

Environment: Oracle Database 11g, TOAD, UNIX, VSS, WINSCP3, SQL, PL/SQL, SQL*Loader, PUTTY, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g, Erwin.

Confidential, Kansas City, MO

Oracle PL/SQL Developer

Responsibilities:

• Designed and Authored Technical Specifications from Functional Specification (Detail Design) documents.
• Used SQL*Loader to load data from various sources into an Oracle database. Created automated scripts for handling multiple files and emailing the status of individual data loads.
• Created various PLSQL blocks to validate data using functions and procedures, and used dynamic SQL to identify client specific requirements and loading into Oracle core tables form staging.
• Wrote PLSQL programs required for retrieving data from the Data repository using Cursors, UTL File I/O. Extensively used Exception handling for error handling.
• Wrote various PL/SQL Packages, Functions and Procedures to implement the Business Logic for the specified client application.
• Created various database triggers for implementing data security across multiple financial sensitive tables.
• Involved in Integration test, System test and Implementation.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexes to gain performance.
• Proficiently developed test cases in Quality Center.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, PL/SQL Developer, UNIX, PUTTY, Quality Center, CVS Version Control, Microsoft Visual Studio, ERWin Data Modeler r7, Informatica Power Center 7.1.2, Windows XP, AIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created numerous web based Forms and Reports using Oracle Developer 6i.
• Defined Editors, created List of Values and Record Groups in Oracle Forms 9i.
• Designed, developed and tested Reports using Report 6i and Discoverer 4i.
• Developed Forms, Packages, Triggers and Shell Scripts to load the staging table data into Analysis Data Mart System.
• Developed Stored Procedures to maintain details of the vendors and maintained them in Packages.
• Developed reports as per the requirements collected from the users using Discoverer and Oracle Reports 10g.
• Good Experience working on TOAD, PL/SQL Development for database access.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
• Created Shell Scripts for automating the execution process.
• Involved in migrating applications to the new release versions.
• Performed Data validations and mappings at staging table level.
• Created Complex Dynamic / Static / Parameterized Reports and Charts using Report 6i.
• Assessed the efficiency of the SQL statements using SQL Trace and TKPROF

Environment: Oracle 8i/10g, SQL, PL/SQL, Developer 2000 (Forms 6i, Reports 6i), Oracle Report Builder 10g, HP UNIX, Secure Shell, TOAD, XML, HTML 4,