EXECUTIVE SUMMARY:

• 8 years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (Sql, PL/SQL).
• 7 years of experience working with Oracle 9i/10g including PL/SQL programming.
• Solid experience in translating business requirements into creation of Database Objects.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
• 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 forall.
• Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
• 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.
• Significant experience in 24/7 Production Environment Support.

TECHNICAL SKILLS:

• Oracle 11g/10g/9i/8i, Toad for Oracle Expert 12
• Ultra Edit Professional Text/HEX Editor 20, SQL*Plus
• Microsoft Visual SourceSafe, Microsoft Silverlight
• Mantis Bug Tracker, TFS, Windows Vista/NT/XP/7
• UNIX with Shell Scripting, Oracle Developer Suit
• Oracle Enterprise Manager, Developer 2000
• Oracle Discoverer, SQL*PLUS, Toad 8.6/8.5/6.0
• SQL, TSQL, PL/SQL, XML,HTML,C/C#/C++, Borland C++ Builder 5
• JAVA, ODBC/JDBC, CRM,Putty, Erwin 4.1/4.0/3.5, MS Visio, Hudson
• Crystal Reports, Oracle Forms and Reports 9i/6i, MS Word, Excel, Access, Winmerge, Win SCP

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

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, TFS

Confidential, Lenexa, KS

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.
• 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, MS SQL server management studio 2008, Toad for Oracle 9.0, PL/SQL, Erwin.

Confidential, Plymouth, MI

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 target 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.

Confidential

Systems Engineer,

Responsibilities:

• Created several new interfaces and enhanced the existing interfaces to adapt to a complicated Warehouse management system (WMS), implemented using SQL, PL/SQL, Unix, Pro*C and shell scripting.
• Implemented stored procedures, functions, triggers, views and other application database code objects using SQL, PL/SQL.
• Improved the efficiency of Interface jobs by tuning the PL/SQL queries, Oracle SGA, troubleshooting of various slow performances database tables, indexes and memory.
• Developed complex SQL queries with inline queries and sub queries for faster data retrieval from multiple tables and used cursors and collections to access large data.
• Extensively used SQL*LOADER for data loading, used Export and Import Utilities for Logical backups.
• Created a new technical system which accepts and process XML messages from WMS using J2EE, Spring & iBATIS.
• Automated generation and publication of reports for Process Improvement, implemented using JAVA, JSP.
• Created and modified shell scripts according to the project requirements for scheduler.
• Worked in all phases of SDLC waterfall environment.
• Prepared test strategy preparation, test case creation, test execution, bug tracking and preparing technical documents for the same.
• Involved with Component Integration Testing, System Testing, Load Testing and Regression Testing
• Developed testing tools in C/C++ during User Acceptance Testing phase.
• Responsible for the maintenance of Version Description Document (VDD) to track the control versions of software to be deployed in production environment.
• Developed tools to automate generation and publication of reports in actual production environment.
• Scheduled and Monitored Control-M jobs, Created Batch Jobs and Scheduler jobs in Unix
• Involved with code deployment in Production Environment.
• Provided offshore support for technical issues as part of Production support.
• Involved in gathering and analyzing the requirements and creating Functional & Technical specifications documents.
• Performed Functional and Technical Analysis of PL/SQL packages for interactions between client and the data warehouse.
• Developed High Level Design for developing new interfaces for the back end of the inventory distribution system by working with various stakeholders, developers and production teams.
• Designed and developed a Data Model for Warehouse-Store inventory distribution. Developed ER Diagrams, Data flow diagrams based on the requirement specification.
• Supported a 3-member team that designed and created low level design for the inventory system.
• Documented Solution Architecture Design for transferring the inventory from Mini-Load system to Bulk Areas.
• Involved in constant interaction with clients during implementation phase and analyzed new business requirements, enhancements and change requests and prepared change analysis and gap analysis documents.
• Responsible for Data Migration activities like extracting, transforming, migrating (ETL) and validating data from one Distribution Centre to another.
• Developed end to end implementation plan by coordinating with various interface teams.
• Re-instantiated the required schemas from the phased out data base to the new data base, synchronized the schemas and altered the data model.

Confidential

Oracle Developer

Responsibilities:

• Developed functions, procedures and packages as re-usable application programs that translated complex business logic using PL/SQL and SQL to transform data between source staging area to target staging area. Extensively used PL/SQL tables, cursors and exception handling.
• Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
• Involved in developing interactive forms and customization of screens using Oracle Forms.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Maintenance included enhancing the existing stored programs, forms and reports with additional procedural and non-procedural programming logic to meet complex user requirements and fixing the bugs on priority basis.
• Importing data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database source schema tables using SQL*loader.
• Responsible for creating and maintaining the Table spaces, Users and assigning Roles and Privileges.
• Developed, Tested and Migrated the Oracle PL/SQL scripts to Production.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Extensively worked on developing KORN shell scripts for scheduling the jobs using CRONTAB and invoking the procedures through shell scripts.
• Involved in implementing bug fixes and enhancements within packages, forms, and reports.
• Responsible for preparing user manuals and quick guides.

Environment: Oracle, Forms, Reports, PL/SQL, SQL Navigator, Oracle Enterprise Manager, Exceed, Humming Bird, JSP, Java Script, HTML