SUMMARY:

• Worked on Global Temporary Tables (GTT) to work with session holding values.Experienced with Agile Methodology concepts.
• Excellent experience of 8+yearsas Oracle PL/SQL Developer with design, development, Quality Assurance, implementation, Support and maintenance of various business applications.
• Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built - in Functions and SQL Tuning.
• Expert at programming Packages, Stored procedures, Function, Triggers Views, Materialized Views, Varrays, DBlinks, Nested Tables and Oracle Objects.
• Experienced in various tuning techniques for offensive SQLs, using SQL Trace, Analyze Tables, Explain Plan, and TKPROF. Expert at using HINTS, Partitioning, Bulking techniques, and Indexes.
• Experienced in using Oracle utilities Import/Export, SQL * loader, Data Pump to load the data in to the database.
• Analysis, Design, Development and Maintenance of various software applications mainly in Data Warehousing.
• Also identified entities and relationships and how those all fit together in logical model, these are then translated into physical model using SQL Developer tool.
• Experience in Dimensional Data Modeling using SQL Developer and Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT& Dimensions tables, Physical & Logical data modeling, and Data Modeling Tools Visio.
• Experienced in Table Partitioning like Range, List and Composite Table partitions.
• Worked on Oracle 12c Inline PL/SQL functions/Procedures in the WITH clause.
• Worked on Oracle 12c Enhanced DDL Online and TRUNCATE TABLE CASCADE.
• WrittenTopN SQL queries using offset to fetch first n and last n rows.
• Experience in all aspects of Analytics/Data Warehousing Solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).
• Hands Experience in building the Physical layer, Business Model and Mapping Layer and Presentation Layer objects.
• Designed and created different kinds of Dashboards to show various Analyses, Trends Charts and Graphs for more readability of the data for users.
• Experienced in UNIX SHELL Scripting, scheduling Cron jobs.’
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Experienced in implementing code that performs well in a high volume OLTP Database&OLAP database environment.
• Created the logical data model using ER Diagram, generated the physical data model using Schema Diagram and database design transformer and generated the DDL for the tables and indexes.
• Developed Analyses with various graphs and charts using Answers for the users.
• Developed Dynamic SQL frame work for framing different SQLs in the Procedures, Packages.
• Developed and implemented distributed architecture making heavy use of Oracle Streams.
• Worked 11g pivot, partitioning, parallelism, materialized views, temporary tables, object types, result caching and optimizer hints to make queries performance-wise efficient
• Developed highly-sophisticated analytical queries with various grouping sets, analytical functions, pivoting, cross-tabs, etc.
• Excellent experience in application development and production support of large and critical network with 24/7 uptime.
• Experience with version control, change management and defect tracking systems.
• Onsite - Offshore Coordination, Support & Technical Assistance to the team members
• Recognized by clients for exceptional performance and sustained excellence in service delivery
• Excellent communication, coordination, organizational and follow-through skills. Efficient in the execution of all assignments, eager to take on new challenges.
• Experienced in creating MySQL Tables, Views, Stored Procedures, Functions and Triggers.
• Worked on MySQL Exceptions.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/ 12C

Programming Languages: SQL, PL/SQL,MySQL

Scripting Languages/Shell Scripting: Native using SQL, PL/SQL & Unix Shell Scripts

BI Platform: OBIEE 11g - RPD design & development, Building Analysis/Dashboards

Development Tools: Toad, SQL Developer, SQL*Plus, SQL*Loader, BI Admin Tool, Apex 4.0

Data Modeling Tool: SQL Developer Data Modeler

Reporting Tools: OBIEE, Oracle Discoverer, Oracle 6i Forms & Reports

Version Control Systems: Tortoise SVN, PVCS

Designing: Database & Data Warehouse Design, Data Mart Design using Dimensional Modeling, Business Process Modeling

Miscellaneous: HTML ERP OM, AR, OTA, GL

PROFESSIONAL EXPERIENCE:

Confidential, Braintree, MA

Senior PL/SQL Developer

Responsibilities:

• Design and implementation of new databases and modifications of existing databases. (Perform data modeling, data architecture, schema management, data object management and other necessary activities).
• Created Technical design documents for new or existing screens changes.
• Design, development and maintenance of any related triggers, packages and stored procedures.
• Involved in OBIEE 11g rpd development & building analysis/dashboards.
• Hands Experience in building the Physical layer, Business Model and Mapping Layer and Presentation Layer objects.
• Designed and created various Dashboards to show different kinds of Analyses, Trends Charts and Graphs for more readability of the data for users.
• Writing complex SQL Queries for the management reports.
• Tuned the long running queries with various tuning techniques using SQL Trace, Analyze Tables, Explain Plan, and TKPRO,HINTS, Partitioning and Indexes.
• Used Global temp tables for holding the data in the sessions.
• Used DB links to access the source data.
• Troubleshoot/Resolve any database/application issues.
• Used PVCS Version control tool to promote the code to production.
• End to end testing of the application.
• Prepared the patch scripts and promotion documents during the code promotion.
• Interacting with different teams towards task completion.

Environment: Oracle 11g R2 SQL & PL/SQL, TOAD 9.6, Win SCP, Putty, VI Editor, DOORS 9.0, Rational Clear Case/Clear Quest, Rational Clear Quest, Remedy, Microsoft Office, Visio 2003, and Windows XP Professional.

Confidential, Atlanta, GA

PL/SQL Developer

Responsibilities:

• Developed AdvancePL/SQL packages, procedures, triggers, functions, Indexesand Collectionsto implement business logic usingTOAD for CIS data.
• Generated server side PL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Created management analysis reporting usingParallel Queries, Java stored procedure API.
• Participated in change and code reviews to understand the testing needs of the change components.
• Worked on troubleshooting defects in timely manner.
• Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Experience inDatabase Application Development, Query Optimization, Performance Tuning andDBAsolutions and implementation experience incomplete System Development Life Cycle.
• Extracted data from the XMLfile and loaded it into thedatabase.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingformas per change request and maintained it.
• UsedCrystal Reportsto track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL.
• Involved in data replication and high availability design scenarios withOracle Streams.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.

Environment: Oracle 11g R2 SQL & PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, TOAD, XML, UNIX shell scripting.

Confidential, WARREN, NJ

Oracle Developer

Responsibilities:

• Wrote complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number ofFormsand for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts forData loadingandDDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Worked in Agile Environment as an Oracle Developer to fine tune and optimize the queries in resolving the defects.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved inLogical & Physical Database Layout Design.
• Performance tuning of Oracle Databases and User applications.
• UsedDTS Packagesas ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Provided user and production support.
• Improved the performance of the application by rewriting theSQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential

Sr PL/SQL Developer

Responsibilities:

• Cloned databases for development and testing. Coordinated with the developers and customizing the modules.
• Extensively used Export and Import of databases for Logical backups and restores.
• Created and dropped users, granting and revoking rights and privileges as and when required.
• Discoursed the tips on evaluating the backup and recovery procedure periodically.
• Defragmentation of tables and indexes for improve performance and efficiency.
• Creation and maintenance of table spaces, rollback segments and data objects.
• Creation and maintenance of control files, redo log files and data files. Monitoring alert log/system log.
• User access Auditing and security aspects of the database.
• Checked Alert Log errors and make necessary actions to rectify them.
• Performed monitoring and management of the databases using tools like Enterprise Manager, TOAD, and SQL developer.
• Used SQL*Loader and External tables to load data from flat files.
• Created and Managed Oracle Database Links between Servers.
• Database resource monitoring (table space usage and fragmentation, I/O loads, rollback segments, space planning etc.).
• Upgraded of databases applied patches, patch sets and critical patch updates.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental).
• Extensively worked on UNIX, Linux, VI editor to setup monitor for log files, file systems, databases and servers.
• Performed technical troubleshooting, changes, and daily tasks for Enterprise Monitoring Applications and Systems with providing operation and production support for Enterprise Monitoring Applications.
• Coordinated incident resolution with infrastructure and application support groups and implement changes to prevent problem recurrence.
• Maintained Remedy incident tickets and service online request cases in a timely and efficient manner, and resolve the request using vi editor, Shell scripting, Unix, Linux environment, managing and escalate issues according to the proper procedures.
• Worked closely with UNIX, Network, Database, and WINTEL support groups, and with business application groups, to understand and prioritize their requirements for the effective implementation of monitoring solutions and to maximize the effectiveness of the monitoring environment.
• Participated in supporting user requests and daily maintenance duties and in the 24x7 L2 on-call primary support rotations with other L2 team members.
• Performed incident ticket trending and analysis to identify root cause and reduce overall problems and perform approved L2 change controls per documented procedures.
• Troubleshoot, resolved and documented resolutions for incident tickets, also updated Operations Guides, and system procedures based on incident resolutions.

Environment: Oracle 11g/10g/9i, Red Hat Linux, UNIX, AIX, HP-UX, Sun Solaris, Windows 2000/2003/XP, SQL Server, RAC, ASM, RMAN, Data Guard, SQL*Plus, SQL, PL/SQL, SQL*Loader, Remedy, Exadata, Autosys, Clear Case and Clear Quest.

Confidential

Senior pl/sql developer

Responsibilities:

• Participated in all phases of development like System Analysis, Design, Coding, Development and Implementation and provide support to existing client databases.
• Wrote UNIX shell scripts and incorporated PL/SQL procedures and functions to automate the daily process as per the business requirement.
• Created several daily, weekly and monthly jobs to generate reports on request by users.
• Extensively involved in writing SQL queries (Sub queries, Nested queries and Correlated), PL/SQL programming.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Worked on creating several reports using Business Objects.
• Extensively used the advanced features of PL/SQL like collections, nested table, Varrays and dynamic SQL.
• Used User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
• Created Indexes and sequences for faster retrieval of the customer billing information and enhance the database performance.
• Written database triggers for automatic insertion of tables on different schema.
• Created procedures to automatically drop and create partitions on tables.
• Used TK PROF and AWR report for tuning the SQL statements.
• Used packages to analyze various tables and their indexes in order to improve the performance.
• Also used DBMS STATS to update different table statistics.
• Worked with production support team for code migrations, object creations and code implementations.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Created DB LINK to create materialized views to maintain copies of remote data on the local node.
• Closely worked with UAT to clarify and resolve various business queries.
• Responsible for creating Application Design Document (ADDs) that highlight the code change for every release. The ADDs were finalized based on review sessions with the business users and the impacted upstream/downstream Applications.

ENVIRONMENT: UNIX, HP-UX, Sun Solaris 5.10, Oracle 8i, Oracle 9i, Windows XP, PL/SQL, SQL*PLUS, TOAD 9.0.1, SQL Loader, Core FTP Lite, Telelogic Synergy and Telelogic Change, PVCS, CVS, HP open view service desk

Confidential

Software developer

Responsibilities:

• Responsible for the Implementation of new features, handling maintenance requests and issues in the POSTSALE module.
• Written the technical specification for the major enhancements.
• Prepared the Impact analysis documents for minor enhancements and research works
• Coding and Unit testing of the design parts
• System and Integration testing of the code
• Prepared unit and system test cases
• Involved in code reviews
• Proactively responded to customer issues
• Analyzed the customer issues
• Initiated discussions for the customer issues with development team
• Mailing the daily activities happening at the customer place to the development team
• Responsible for Internal releases
• Prepared the release notes to the customer
• Responsible for bug fixes and providing the required reports
• Responsible for immediate and timely manual Unix batch job runs

ENVIRONMENT: Oracle 10g SQL & PL/SQL, Forms 6i and Reports, UNIX Shell Scripting (ksh), Pro* COBOL.