SUMMARY

• Over Seven (7+) years of IT experience in with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (SQL,PL/SQL) with strong experience on working with Oracle10g/11g
• Solid experience in translating business requirements into Technical Design Documents
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, Collections
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions
• Prepared BRD (Business Requirement Document) that gives the detailed information about the requirements
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX)
• Extensive experience on using SQL, PL/SQL, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS
• Proficient in writing complex SQL Queries, Stored procedures, creating Indexes, Functions, Triggers, Sub Queries, Global Temporary Tables
• Proficient in tuning queries used in the application
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required
• Experience in advanced PL/SQL concepts like Bulk collect and for all
• Expertise in Dynamic SQL, Records, Arrays and Exception Handling
• Hands-on experience with Oracle APEX 3.2/4.0/4.1 (Oracle Application Express).
• Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model
• Experience in understanding complicated performance issues and worked with DBA’s to suggest valuable ways to fix the problem
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects
• Possess excellent oral / written communication and interpersonal skills
• Good ability to quickly grasp and master new concepts and technologies
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs
• Experience on solving Production Support Tickets or Issues

TECHNICAL SKILLS

• Oracle 11g/10g
• Toad
• SQL*Plus
• UNIX with Shell Scripting
• Oracle Enterprise Manager
• Microsoft Visual SourceSafe
• Microsoft Silverlight
• TFS
• Windows Vista/NT/XP/7
• XML
• HTML
• C/C#/ C++ Builder 5
• JAVA
• ODBC/JDBC
• CRM
• Putty
• Erwin 4.1/4.0/3.5
• MS Visio
• Hudson
• Crystal Reports
• Oracle Forms and Reports
• MS Word
• Excel
• Access
• Winmerge
• Win SCP
• Web Services
• JBOSS
• SOAP
• REST

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Oracle Pl/SQL Developer

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required
• Used SQL loader to load the data from the files provided by the interfacing applications
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functionsas part of Project/Application requirements
• Created partitioned tables and partitioned indexes to improve the performance of the applications
• Wrote PL/SQL Database triggers to implement the business rules in the application
• Created external tables to handle huge volumes of data which is not used frequently
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making
• Implemented all modules logic by using Triggers and Integrity Constraints
• Good understanding of database objects and ability to triage issues
• Involved in PL/SQL code review and modification for the development of new requirements
• Created materialized views required for the application

Environment: C++, UNIX Shell Scripting, Forms, PL/SQL, Oracle 10g, 11g

Confidential, Reston, VA

Oracle PL/SQL Developer

Responsibilities:

• Worked with BA to collect and document database design requirements and do data modeling with DB architect using Erwin
• Implement the back end changes in existing product and in designing the database by gathering and understanding requirements from Business / System Analysts
• Analyzed the functional specs provided by the data architect and created technical specs for all the projects
• Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements
• Formulated SQL queries, functions and processes as per customization requirement for APEX
• Supported APEX applications and contributed with database designs and assisted in increasing response time for APEX reports
• Defined relationships using primary keys and foreign keys for the entities and normalized the entities
• Used BULK COLLECT, BULK INSERT and FORALL to decrease query execution time
• Reproduce Oracle schema objects includes tables, temporary tables, views, indexes, triggers and procedures, based on customer requirement
• Created test cases and test reports and worked with QA team to validate the data and scenarios
• Worked on various backend Procedures and Functions using PL/SQL
• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements
• Involved in Unit Testing Stored Procedures and Functions
• Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
• Created SQL*Loader scripts to load data into the temporary staging tables
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Created Materialized Views and partitioning tables for performance reasons
• Resolving the issues on priority basis
• Responsible for Analyzing and Implementing the Change Requests
• Involved in handling the changes in compiling scripts according to the database changes

Environment: UNIX shell scripting, Oracle 10g, PL/SQL, Clarify, Oracle 11g, Oracle developer 11g, Oracle EBS, ERP R12,Oracle Enterprise Manager, Toad for Oracle 9.0, PL/SQL, Erwin

Confidential

Database Developer

Responsibilities:

• Developed stored procedures to extract the data from different sources and load it into data warehouse
• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures
• Created data mapping files for the data coming from different web services
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process
• Developed procedures using Dynamic SQL
• Worked for designing Logical and Physical data models for Master Data and Transactional Data knowledge and experience in structured systems analysis and design techniques
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Worked with ETL team and architect to build data model for staging area
• Prepare the Mapping document which details out the mapping of source to the Confidential data model with application of business rules
• Importing and exporting the data into multiple environments
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database
• Involved in handling the changes in compiling scripts according to the database changes
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL tuning using Explain Plan, Hints and indexes
• Responsible for performing code reviews
• Created SQL*Loader scripts to load data into temporary staging tables
• Utilized SQL*Loader to load flat files into database tables

Environment: Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer