SUMMARY:

• Over 8 years of experience in Information Technology, designing and developing oracle based applications.
• Deep understanding of all stages of software development life cycle (SDLC).
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Synonyms, Sequences, Triggers, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• 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.
• Working knowledge and experience in writing SQL queries, PL/SQL functions, packages, procedures, cursors, collections, triggers, exception handlers, PL/SQL tables in Oracle11g, 10g, 9i, 8i.
• Experience with data dictionary techniques, Entity Relation modeling and data flow diagrams.
• Experienced in Database Administrative duties like Grants, Loads, and Backup/Recovery & Performance. Experience Includes Database Administration activities like Installation of Oracle Database, Oracle 10g Application Server, configure Database with DBCA, Oracle Enterprise Manager, Oracle Net Listener Configuration, Creating and managing Schema Objects, User and their Privileges, Backup and recovery.
• Currently I am/was working on different applications at Raymond James.
• Commendable knowledge in SQL and PL/SQL with regard to Data manipulations, Complex Ad-Hoc query requests and Data Profiling apart from having good knowledge of Database Administration
• Quick learner and a team-player with strong communication and interpersonal skills.
• Experienced with Crystal Reports.
• Extensive experience in writing SQL queries, PL/SQL procedures, functions, packages, triggers, exception handlers, cursors, collections, PL/SQL tables in 11g, 10g, 9i, 8i.
• Expert in Performance Tuning, SQL Tuning, Data optimization, query optimization, job scheduling.
• Good at UNIX and Shell Scripting.
• Punctual and ability to manage and meet project deadlines.
• Worked on Production Support, troubleshooting the application and resolving bugs.
• Has working knowledge in Data modeling using Erwin and logical and physical database design.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g,12c, MS Access

Scripting: SQL, PL/SQL, UNIX Shell Scripting

Languages: C, Java, HTML/DHTML, XML

Operating Systems: Windows 2000/NT/XP/7/98/8, OS X and UNIX

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL* Plus

Other Tools: SQL*Loader, ODI, MS-Visio, MS Project Professional 2003, SoapUI, Rational Rose, Microsoft Office Suite- MS-Word, MS-Excel, MS-Power point

PROFESSIONAL EXPERIENCE:

Confidential, St.Petersburg, FL

Oracle Developer

Responsibilities:

• Worked on one of the main components of a huge project CDS (Consolidated Data System).
• Worked on the transactions part called CCAL (Consolidated Client Assets and Liabilities).
• Made good use of the latest version of Oracle to build queries and process the data.
• Mostly worked on the performance of CCAL.
• Was part of Ops Analyst Tool, which was an immediate deliverable.
• Worked in tandem with the UI Developers to get the screens up and running for the tool.
• Also had a chance to work on another component of CDS called CCSI (Consolidated Client Static Information)
• Developed procedures to fetch the data to the front end.
• Developed crystal reports for the transactions in the CDS project.
• Worked on performance tuning for the transactions project.
• Worked on various reports for CCSI and CCAL projects.

Environment: Oracle 12c, PL/SQL, SQL*Plus 10.1, SQL Developer, ODI 12.1.2, Erwin 4.1.4, Toad 8.6 & 9.1, UNIX, Windows.

Confidential, Southfield, MI

Oracle Developer

Responsibilities:

• Worked with External Tables to access and import the required information.
• Worked in a fast paced environment and also worked after hours and a few weekends too.
• Made use of the UTIL FILE package to create delimited text files.
• All the business requirements were met by creating database objects like tables, synonyms, views, sequences, indexes etc.
• Creating ad-hoc reports as per the requirements.
• Has designed a Data load framework for dynamically adding Tables replicating from one system to another.
• Created PL/SQL Tables, Collections, and Records, Partitions and Used Dynamic SQL and triggers.
• Made use of cursors, collections, bulk binds etc., to generate high performance queries and PL/SQL code.
• Made use of Data partitioning by range, list and also sub- partitioning to increase the performance of the system.
• Worked on developing crystal reports for various automobile clients.
• Analyzed software specifications by interacting with business analysts and developers.
• Worked on UNIX k-shell to start and monitor the CRON jobs on the server.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Was part of the building team for the Erwin physical data model, laying out ER-Diagrams, defined table structures and involved in high level database design.
• Numbers of complex PL/SQL procedures, functions and packages have been developed for the specifications of the application.

Environment: Oracle 10g, Oracle 11g, PL/SQL, SQL*Plus 10.1, SQL Developer, Erwin 4.1.4, Toad 8.6 & 9.1, UNIX, Solaris, Windows.

Confidential, Peoria, IL

Oracle Developer

Responsibilities:

• Has partitioned various domains in the database to suit the needs and also to make the system faster.
• Performance tuning was extensively needed in these projects and played a major part in it.
• Worked intensively on PL/SQL Tables, Procedures, Records, and Used Dynamic SQL and triggers.
• Created the data model for the given schema.
• Wrote Cleanup procedures to clean up the data that is too old.
• Have worked on tasks like monitoring the number of records received, calculating the threshold of the counts and sending email from oracle when the threshold is not met.
• Analyzed the record count for a given domain, calculated the mean, standard deviation, the upper and lower limits for the same and illustrated them in excel charts.
• Also worked on tasks like file frequency, where an email from oracle has to be sent when there is any delay in receiving the file from dealer and also check the status of the file.
• Was part of Job scheduling for Snapshot tasks like inserting history data into history tables when the original tables are overloaded and the data needs to be moved.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Provided alternative approaches when faced with performance bottlenecks. Approaches like range partitioning, global temporary tables.
• Supported file loading process and solved the errors involved.
• Wrote extensive Exception handling procedures to handle exceptions.
• Played an important role in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• In order to increase the performance, partition table with partition index has been introduced.
• Performance tuning and query optimization were extensively needed in these projects and worked on the same.
• Have worked on testing the database after the patch (Gathering table stats, refresh table stats, recreating the indexes, etc).
• Worked on indexes, rebuilding indexes online, invisible indexes, parallel hint.
• Dealt with various production issues in an efficient manner.
• Made use of cursors in procedures to generate high performance queries and PL/SQL code.
• Scheduled different jobs using job.submit and also using DBMS Scheduler.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Analyzed software specifications by interacting with business analysts and developers.
• Created Materialized views and Materialized view logs.

Environment: Oracle 9i, Oracle 10g, Oracle 11g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Toad 8.6 & 9.1, UNIX, Windows.

Confidential, Plano, TX

Oracle Developer

Responsibilities:

• Has designed a Data load framework for dynamically adding Tables replicating from one system to another.
• Created PL/SQL Tables, Collections, Records, and Used Dynamic SQL and triggers.
• All the business requirements were met by creating database objects like tables, synonyms, views, sequences, indexes etc.
• In order to increase the performance partition table with partition index has been introduced.
• Made use of cursors, collections, bulk binds etc., to generate high performance queries and PL/SQL code.
• Analyzed software specifications by interacting with business analysts and developers.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Was part of Reverse Engineering framework for Data Stage Jobs
• Played an important role in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Have worked on Oracle Express, Discoverer & Reports
• Made the Business Requirement Document by collecting the requirements and interacting with the business users.
• Was part of the building team for the Erwin physical data model, laying out ER-Diagrams, defined table structures and involved in high level database design.
• Number of complex PL/SQL procedures, functions and packages have been developed for the specifications of the application
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• In process of developing a data purging framework .
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Provided basic understanding of the project to the new members of the team.

Environment: Oracle 9i, Oracle 10g, Oracle 11g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 8.6 & 9.1, UNIX, Solaris, Windows.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Was actively present in the analysis, requirements gathering, functional specification, development and deploying.
• Gathered the requirements from the business users and prepared the Business Requirement Document.
• Data transfer from the SQL Server and Oracle Source systems to Oracle Target System was made easy by the creation of an environment for development and production.
• Identifying the key features for scalability of the application, was part of the building team for the Erwin physical data model, laying out ER-Diagrams, defined table structures and involved in high level database design.
• Bug fixing in PL/SQL code and resolving issues with DDL scripts for the indexes and tables in different cases.
• Being alert about the arising situations and escalating issues about possible impact on the application functionality.
• Testing at various levels: Unit level, Module level, Application etc.
• The application functionality was explained in detail by organizing meetings with system analyst.
• Was able to actively provide resolutions to time-sensitive ad-hoc requests for information from management.
• Made good use of Explain plan and Analysis for performance tuning and optimizing SQL queries.
• Tuning Database and SQL for Optimal Performance, Redesign and build the Schemas to meet optimal Performance measures.
• Optimal Performance measures were met by the building and redesigning of schemas and also by tuning database.
• Analyzed all business functionalities related to backend database interfaces.
• Business functionalities related to backend database interfaces were analyzed and documented.
• Utilized Analytical function, bulk collect and Dynamic SQL for generating complex SQL script.
• Multi-tasking with performance statistics, integrity monitoring, maintenance, capacity planning and recovery of databases.
• Made use of the datapump for the migration of data from one database to another.
• Advanced queuing and oracle job scheduling.
• Maintenance of project process documents and procedural documentation.
• Involved in Development, testing, and release management.

Environment: Oracle 11g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 10.1, UNIX, Solaris, Windows.

Confidential, Plano, TX

Oracle Developer

Responsibilities:

• Prepared the technical requirements document by working with business analysts and understanding the business requirements.
• Played an active role in the designing and analysis part. Also responsible for backend development activities.
• Covered the fundamentals of Software Development Life Cycle (SDLC).
• Different constraints on database were created and maintained.
• SQL*Loader to perform bulk data loads into database tables from external data files.
• Bulk data loads into database tables from external data files was performed by using SQL*Loader.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Identifying performance bottlenecks, suggesting and implementing alternative approaches like range partitioning of tables, use of global temporary tables.
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• DBMS SCHEDULER was used to schedule oracle jobs.
• Transfer of tables across schemas and databases by developing SQL/PL SQL scripts.
• Worked extensively on complex Oracle SQL Development.
• The ETL process was automatized by developing UNIX Shell scripts.
• Maintaining the system by being up-to-date with the latest Oracle features and related products.
• Performing query optimization for the improvement of query performance.
• Tracing the query execution plan (Explain Plan).
• Helping out new members by providing training and support with the ongoing project.
• Provide resolutions to time-sensitive ad-hoc requests for information from management.
• Optimization of SQL queries, and performance tuning by using Explain plan and Analysis.
• Took part in code review, design meetings and test review meetings.
• Normalized the database, handled database server tuning and application tuning for better performance.
• Responsible for Unit level testing, Module level testing and Application testing.
• Responsible for writing high quality and well documented code according to standards and documentation of various processes.
• Was responsible for documentation of various processes and writing high quality code according to the standards.
• Resolved production issues in efficient manner and also on time.

Environment: Oracle 10g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 10.1

Confidential

Sales Management System

Responsibilities:

• Involved in the design phase of the application.
• Keeping track of the network usage.
• Changing of code in certain modules.
• Maintained the company website.
• Also involved in marketing of the product.

Environment: C, Java, MS- Excel, HTML