SUMMARY

• About 8+ years of experience in the field of information technology, proven ability to leverage technology to improve business processes, with special expertise in requirements analysis, database development, debugging, problem solving and user support.
• Proficient in database, backup and recovery, monitoring and performance tuning, development of stored procedures, packages, triggers, SQL queries, reports, forms and scripts.
• Client Interaction for activities such as initial Requirements gathering, Tracking requirement changes, building functional test scenarios, coordinating performance testing, user acceptance testing and Production Support
• Extensive experience in designing and developing Packages, Stored Procedures, Functions and Triggers using PL/SQL.
• Very good experience in building applications from scratch such as defining Schema Objects, Users, Roles, Views, Materialized Views and Indexes as per the application requirement
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re - Write
• Efficient in writing complex SQL queries, Hierarchical queries, use of analytical functions, Regular expressions and also aware of new features in oracle 11g.
• Effectively made use of PL/SQL features such as Bulk Collections/Exceptions/Inserts, Bulk Binding, Ref-Cursors, Multi Table inserts, SQL Types in Bulk Operations for better performance and readability
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof.
• Extensive experience in Data Migration, ETL & Content Management, implemented various Extraction, Transformation and Loading architectures involving tools and technologies such as ETL Tools, XML, XML Schema, SQL Loader, PL/SQL, Materialized views
• Did POC on Mongo DB using Python.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, Mongo DB

Scripting: SQL, PL/SQL and UNIX shell scripting.

Languages: C, C++, python, java, XML.

Query Tools: TOAD, SQL Navigator, SQL*PLUS and Pl/SQL Developer.

Operating Systems: Windows 2000/NT/XP, Windows 95/98, UNIX, LINUX 9.2/9.3

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point.

Other Tools: SQL*Loader, Oracle Export/Import Utility, Erwin, MS-Visio.

Other Tools Used: ERWIN, TOAD, SQL Developer, Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Milpitas CA

Sr Oracle PL/SQL Developer

Responsibilities:

• Responsible for the whole development life cycle activities like gathering requirements, analysis, code development, unit testing, migration and user acceptance testing.
• Developed an application called Enterprise Discounts management system (EDMS), through which the discounts are created and honored.
• Closely worked with frontend developers to design the transaction application called, Accuprice to honor the discounts.
• Designed a search engine to search the created discounts based on the filters provided by the user.
• Actively involved in designing the functional tags specifications from business requirement and converting them into technical specifications.
• Performed key role in being liaison between business and technical team to conduct discussion, gathering business requirement and gap analysis.
• Did POC on Mongo DB using Python for reporting purpose.
• Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Leveraged Partitioning techniques for better performance.
• Most of the development work involved the coordination between backend and frontend.
• Extensively used PLSQL Object tables to pass the output to the frontend.
• Used Refcursors and pipelined tables as well to pass the output to the frontend.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification.
• Proactively performed the task of bug analysis and fine-tuning the long running queries utilizing SQL Trace, Explain plan, Dbms Profiler and Tkprof.
• Worked on performance tuning and used Explain Plan, TK-Proof, and SqlTrace for tuning the queries.
• Optimized existing queries for better performance and less impact on database.
• Supported nightly builds and deployments and also part of 24/7 support team.
• Responsibly followed build and release process
• Involved in Unit Testing, Integration testing, Performance testing and Regression testing.

Environment: Oracle 11g, SQL, PL/SQL, SQL*Plus, Kintana, SQL Developer 7, Pvcs, Toad for Oracle 10.6, MS Visio 2007.

Confidential, Phoenix AZ

Sr. PL/SQL Developer/Analyst

Responsibilities:

• Responsible for the whole development life cycle activities like gathering requirements, analysis, code development, unit testing, migration and user acceptance testing.
• Analyzed the existing system, re-architect, and reverse engineered and re-designed data model to fit the new architecture.
• Performed key role in being liaison between business and technical team to conduct discussion, gathering business requirement and gap analysis.
• Actively involved in designing the functional tags specifications from business requirement and converting them into technical specifications.
• Involved in planning release activity, code migration, code review and standardization.
• Involved in an innovative idea of multi-processing, though Oracle is a single threaded architecture. Oracle scheduling, for cursor updates, cycles, queuing and no wait exceptions are the few techniques that were used to achieve parallelism for processing large volumes of data.
• Analyzed, debug and modified the engine to meet the new business requirements.
• Created and modified the database objects such as tables, triggers, indexes, procedures, functions and packages.
• Developed Shell scripts for automation and used them on daily basis, weekly basis and monthly basis for data export/import, purging of data and reporting.
• Heavily used Dynamic SQL and table driven approach in engine to build the queries on fly and flexible system.
• Designed the application for restartability, exception/error handling and reprocessing capabilities.
• Proactively performed the task of bug analysis and fine-tuning the long running queries utilizing SQL Trace, Explain plan, Dbms Profiler and Tkprof.
• Extensively used analytical functions, pivoting and Materialized Views for reporting purposes.
• Used external tables, to load the data coming form source system and users.
• Data Stage and PERL are the new technologies that I have got hands on while reverse engineering.
• Prepared test data, test cases
• Involved in Unit Testing, Integration testing, Performance testing and Regression testing.

Environment: Oracle 11g, SQL, PL/SQL, Putty, SQL*Plus, Winscp, Tortoise SVN 1.7.1, Jira, SQL Developer 7, Toad for Oracle 10.6, MS Visio 2007.

Confidential, Wilmington DE

Sr. PL/SQL Developer

Responsibilities:

• Worked as a Run the Engine resource (RTE).
• Involved in the design and implementation of the process for loading the weekly loads coming from flat files in to staging tables in the Oracle Data base using SQL* Loader and also developed a script to load the staging data into the production tables using PLSQL.
• Used Bulk inserts/loads wherever required.
• Created and worked on partitioned tables on very huge data.
• Worked on Oracle Import and Export utilities for data backup to resolve the space issues by exporting the partitions and then truncating the partitions to save the space and importing the partitions back whenever the data is required.
• Developed and maintained UNIX shell scripts to process extracts and loads and assigned them to the crontab for automation.
• Developed a script to run the reports for weekly health checkups, finding free tablespace, weekly production load report, and process adherence reports and tracking table reports.
• Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Optimized existing queries for better performance and less impact on database.
• Used Dynamic SQL for interface programs and exception handling routines.

Environment: Oracle 10G, SQL, PL/SQL, Putty, SQL*Plus, Winscp, Cygwin, SQL Developer.

Confidential, Pittsburgh PA

Oracle Developer

Responsibilities:

• Responsible for tracking requirements by interacting with business team
• Enhancement of Logical and Physical models to in corporate new features
• Defined Views and materialized views for simplifying reporting queries and performance.
• Developed PL/SQLStoredprocedures, Triggers and Functions and embedded them in packages.
• Involved in designing the Technical design documents for the Functional design documents.
• Designed ABPP Reports for published plans.
• Migrated the reports and forms from 6i to 9i and then to 10g.
• Designed dynamic workflows for the factory planner using ABPP.
• Performed Query optimization and PL/SQL tuning to maximize performance
• Supported nightly builds and deployments and also part of 24/7 support team
• Responsibly followed build and release process
• Involved in Unit Testing, Integration testing, Performance testing and Regression testing.

Environment: Oracle 10G, SQL, PL/SQL, Oracle Forms and Reports 9i/10g, Shell Script, Erwin, Toad, Clear Case, Ant, and See Beyond.

Confidential, Plano, TX

Oracle Developer

Responsibilities:

• Created complex queries using SQL and PL/SQL to summarize data, which are used as views on which reports are based.
• Designed Entity-Relationship models using ERWIN and other design features.
• Interacted with Business Analyst and client Representatives and understood the requirements using the functional documents and the client specified documents.
• Used SQL*Loader to load data into Oracle database.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Effectively used Oracle Reports for generating PDF reports according to the client’s requirements.
• Developed and maintained UNIX shell scripts to process extracts and loads.
• Usage of Dynamic Execute Immediate statements to fetch data as needed for Dynamic SQL.
• Created database Triggers for data security and used SQL* Loader for bulk data load.
• Monitored user interaction with the system and made improvements to tune applications to shifting business and user needs.
• Developed software test plans, test design specifications, and test scripts for various test scenarios.

Environment: Oracle 10g, AIX-UNIX, SQL*Plus, SQL*Loader, Developer Suite (Forms 10g, Reports 10g), TOAD, PL/SQL, Quality Center, Toad, SQL, ETL, Erwin.