Developer Sql

Professional Experience Summary:

Over * years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Administration and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Certified Oracle professional with strong knowledge on Oracle Architecture and Database Design.

Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.

Excellent conceptual knowledge of Oracle12c/11g/10g/9i, PL/SQL, SQL *PLUS, SQL Developer, TOAD, PL/SQL Developer.

Experience in Database design using Normalization.

Good Knowledge on Anonymous Blocks, Autonomous Transactions, Procedures, Functions, Record Types, Collections, Analytical Functions, Dynamic SQL/PLSQL, Pipelining, Hierarchy Queries, Cursors, Exception Handling and Advanced Queuing.

Experience in writing SQL Queries, Sub Queries, Views, Materialized Views, Packages, Triggers, Ref Cursors, Dynamic SQL, Exceptions.

Experience in RMAN backups and recovery to include full and incremental backups and cloning a database, handled complex restoration scenarios.

Excellent experience in Installation and configuration of Oracle 9i, 10g and 11g in UNIX/LINUX and Windows environment and implementation of RAC, 11g Grid Infrastructure with ASM and ACFS File systems.

Experience in designing business requirements and modeling using oracle designer.

Experience in developing Joins, Indexes and sequences.

Experience in query optimization, performance and tuning using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.

Extreme Use of Exception Handling methods along with Pragma_Exception_init in order to associate our own created exception names.

Experience in Migrating from Legacy Mainframe to Oracle.

Experience in writing Technical Design Documents and Developing Unit Test Documents.

Experience in working on different applications using UNIX & LINUX Shell Scripting.

Experience in job schedulers like crontab.

Experience with ETL and data integration, Data quality.

Experience working in version controlling tools like CVS, SVN, Tortoise to manage project migrations and version controlling.

Experience in working with Putty Connection Manager.

Involved in production support activities like batch handling and monitoring.

Knowledge in data warehousing and dimensional modeling concepts.

A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

Certifications Summary:

Oracle Certified Associate - OCA

Oracle Certified Professional - OCP

Technical Exposure:

RDBMS

Oracle Exadata,12c/11i/10g/9i/8i, SQL Server

Oracle

SQL, PL/SQL, Forms & Reports, Apex

Scripting& Scheduling

UNIX Shell, Crontab

Languages

XML, HTML, JavaScript, HTML, C, C++, VB.Net, C#.Net

Tools

PL/SQL Developer, SQL Developer, TOAD, SQL plus, JIRA

Designing Tools

Erwin, Rational Rose

Applications

MS Office tools

Operating System

UNIX, LINUX, Solaris, Windows NT/2000/XP

Methodologies

Agile

Experience Summary:

Working with Keen Infotek Inc. as Programmer Analyst from Aug’14 to Till date.

Worked with Sonata Software Limited as Senior System Analyst from Sep’12 to Jul’14.

Worked with Verticle Technologies as Technical Associate from Feb ’08 to Sep’12.

Project Summary:

Sherwin Williams Sr. Oracle Developer

Cleveland OH April 2015 to Till Date

AR (Accounts Receivable) project designed for the automation of collection process. This involves converting the legacy system (Mainframe) to web based Collections Processing and Receivables. This module facilitates automatic creation of different types of accounts, generating invoices for the purchases and automatically determines accounts which are defaulted for collections.

Responsibilities:

Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing in designing business requirements and modeling using oracle designer.

Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers.

Developed scripts for Ftp’ing data from Oracle tables to Mainframes.

Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.

Used Collections, Objects for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling.

Developed DB Links to transfer data across the databases.

Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.

Implemented efficient Error Handling process by capturing errors into user managed tables.

Archived many applications in the existing system and retrieval of necessary data from them.

Performed SQL and PL/SQL Performance tuning and Application Tuning using Explain Plan.

Developed UNIX Shell scripts to automate table creation, fetch queries and execute procedures.

Environment: Oracle 11g, SQL Plus, SQL Developer, SQL*Loader, Exadata, UNIX Shell script, MS Access, PLSQL Developer, JIRA, Mainframes, Crontab, Exam diff, JAVA, Windows XP/2000.

Mercury Insurance Sr. Oracle Developer

Clearwater, FL Aug 2014 to March 2015

Mercury Insurance is an Auto Insurance company deals with pay your losses as defined in your policy. Auto insurance provides property, liability and medical coverage: Property coverage for theft of vehicle, Liability coverage pays for your legal responsibility to others for bodily injury or property damage, Medical coverage pays for the cost of treating injuries, rehabilitation….

Responsibilities:

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Loaded the data into database tables using SQL*loader from text and excel files.

Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.

Used eclipse SVN version control for changing the codes.

Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.

Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling.

Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

Archived many applications in the existing system and retrieval of necessary data from them.

Performed SQL and PL/SQL Performance tuning and Application Tuning using Explain Plan.

Developed UNIX Shell scripts to automate table creation, execute procedures.

Used ORACLE PL/SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, SQL Developer, Oracle Designer, Mainframes, FTP, UNIX, JAVA, Windows.

TUI - Cyrus Sr. Oracle Developer Luton, Engalnd Sep 2012 to Jul 2014

Cyrus is a revenue management system that builds on existing manual yield and revenue management practice. Cyrus automates this process. It aims to work in a similar way to More accurately, to much finer degree of detail and focuses on under-performing AND over-performing inventory

Responsibilities:

Involved in analysis, Design, Development phases of the project.

Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Involved in implementing the data integrity validation checks through constraints and triggers.

Created SQL*Loader control files for moving the data from flat files to staging area tables.

Worked on performance issues and used EXPLAIN PLAN for tuning the queries

Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.

Involved in Troubleshooting Performance issues and bugs within packages and stored procedures using dbms_output and Explain Plan.

Performance of the queries is enhanced by executing optimization techniques such as Index Creation, Table Partition and Coding Stored Procedures.

Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX Shell Scripts.

Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, PL/SQL Developer, Oracle Forms 10g, Reports10g, UNIX, Windows XP/2000.owb 10g.

Amway PL/SQL Developer

Grand Rapids, MI Feb 2008 to Sep 2012

Amway Corporation is an American-based pioneer in the direct selling industry. They manufacture more than 450 products that are sold through independent business owners (IBOs). They are primarily focused on health, wellness, and beauty products. This system maintains information about customer details, products supplied and inventory information. Other important feature of this application is that it keeps track of the details of customer complaints and the concerned action taken. Check statements/alert statements were designed using triggers, procedures and functions.

Responsibilities:

Developed SQL and PL/SQL scripts for problem solving.

Involved in SDLC including designing, coding and unit testing, Maintained onsite/offshore Coordination between onsite users and offshore project teams.

Tracking and ensuring timely deliveries as per SLAs committed to the client.

Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.

Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.

Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.

Using associative array from Perl programming for indexing and performance issues in UNIX environment.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.

Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Used Exception handling extensively for the ease of debugging and displaying the error messages in the application.

Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX, SQL Developer, Java.

Academic Details:

Bachelor of Computer Applications from Osmania University from 2000-2003.

Master of Computer Applications from Osmania University from 2004-2007.

Contact this candidate