Professional Summary:

• Over 9 Years of experience in Analysis, Design, Requirements Gathering, Production Support, Performance Tuning, Trouble-shooting and Maintenance of databases.
• Excellent skills in Design and Development of applications using Oracle Database 11g/10g/9i ,SQL, PL/SQL, Oracle Forms Reports 10g/9i/6i.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Extensively developed PL/SQL code using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data and enforcing referential integrity.
• Experience in using tools like TOAD, PLSQL Developer, and SQL Developer.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Experience in designing data models using Erwin and Visio.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Expertise in working with built-in packages like DBMS SQL, DBMS SCHEDULER, DBMS STATS, DBMS MVIEW, DBMS DDL, UTL FILE.
• Experience with data warehouse design using Star Schema and Snowflake schema.
• Experience in loading data from flat files to database tables using SQL Loader.
• Experience in working with UNIX and expertise in UNIX Scripting.
• Strong experience in SQL Tuning using Explain Plan, SQL Trace and TKPROF.
• Experience with version control SVN, CVS , change management and defect tracking systems.
• Working Knowledge on testing tools like Win Runner, QTP, Quality center, Test Case manager
• 24/7 Production Database Support Maintenance
• Ability to work closely with clients to analyze data, determines project requirements, review functional requirements and develop detailed designs to meet requirements.
• Excellent analytical and problem solving skills with strong communication and interpersonal skills.

Technical Skills:

Experience:

Sr. Oracle PL/SQL Developer

Confidential

Responsibilities:

• Involved in Requirement Gathering, Analysis, Implementation, Development and production support of the application.
• Involved in Designing data models using Erwin/ Oracle Data Modeler.
• Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for better performance.
• Developed, modified and optimized complex queries for data retrieval and modification.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Developed maintained UNIX shell scripts to automate file transfers.
• Created Materialized Views and partitioning tables for enhancing performance.
• Used SQL Loader and External tables to load data from flat files into Oracle database.
• Extensively used the database utilities like Export, Import, Data pump UTL FILE.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges
• Performed Dimensional Data modeling and created Star Schema and Snow Flakes Schema data model to meet the OLAP needs dataware housing .
• Worked with Control-M Desktop and Enterprise Manager for Job scheduling and monitoring.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Extensively used Quality center to Run test cases and to report and track defects.
• Involved in Unit Testing for the application.
• Involved in solving day-to-day problems, giving support to the users.
• Provided 24/7 on call production support.

Environment: Oracle 11g, Linux, SQL, Erwin, SQL Plus, TOAD, Quality Center, SQL Loader, SVN version control, XML, Sql Developer , Control M, Business Objects, Sql Server 2005

Sr. Oracle PL/SQL Developer

Confidential

corporation. It is one of the largest mutual fund and financial services groups in the world

Responsibilities:

• Responsible for Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.
• Involved in designing Logical and Physical data models using ERWIN.
• Prepared High level design and Technical detail design documents.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Created modified PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privilege
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Extensively used Bulk Collect and Oracle FORALL features for increasing the performance.
• Implemented exception handling using autonomous transactions, Pragma Init, Locks, used save points, commits rollbacks to maintain transactional consistency database integrity.
• Involved in creating triggers, views and Materialized views based on the client Requirements.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Involved in developing UNIX shell scripts for Loading Database Tables.
• Developed and maintained UNIX shell scripts Korn Shell to process extracts and loads.
• Created database triggers for data security Consistency
• Used CRON JOB for job scheduling on UNIX as well as tools like AutoSys to run regular day to day administration scripts and setting up batch scripts.
• Involved in developing ETL Process to Load the Data from different sources.
• Usage of Dynamic Execute Immediate statements to fetch data as needed for Dynamic SQL.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Designed and developed mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Created the materialized views - Partitioned very large database tables using list partitioning to improve performance.
• Achieved optimum Performance Tuning using EXPLAIN PLAN and TKPROF functional utilities and also by creating Indexes.
• 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.
• Performed Unit Testing for the project.
• Involved in Production Support and troubleshooting data quality and integrity issues

Environment: Oracle 11g, AIX-UNIX, SQL Plus, SQL Loader, TOAD, PL/SQL, Perl, Pro C, PowerBuilder, Quality center, Toad, SQL Developer, Relational Clear Case, Erwin, Informatica9.1, Java.

Sr. Oracle PL/SQL Developer

Confidential

• Designed Entity-Relationship models using ERWIN and other design features.
• Involved in various stages of the project life cycle mainly analysis, design, Coding, testing and implementation of the application.
• Created new Tables, Indexes, and Sequences where needed.
• Developed PL/SQL packages using indexes, joins, bulk collects, and bulk variables.
• Developed control files for SQL Loader and PL/SQL programs for loading and validating the data into the Database.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Unit testing various PL/SQL blocks and GUI testing the user interface screens.
• Used Oracle Supplied Packages such as UTL FILE, DBMS JOB, DBMS SQL and DBMS ALERT.
• Used AutoSys for scheduling jobs.
• Created stored Procedures using EXECUTE IMMEDIATE Native Dynamic SQL and REF CURSORS.
• Involved in writing Perl Scripts for populating data on to WebPages.
• Involved in creating Index's, passing Hints, analyzing the table statistics and Table partitioning.
• Extracted Transformed and Loaded ETL data source database to data warehouse system.
• Involved in writing complex queries to generate reports as per client requests as part of production support.
• Designed and Created several Customized Reports using Oracle Reports.
• Designed and developed front-end applications using Oracle Forms.
• Wrote SQL statements in Pro C and replaced them with appropriate calls to functions in the SQL runtime library.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Coordinated with DBA in improving Database Performance.
• Provided test data QA team to validate front end application and also involved in unit testing.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Worked 24/7 Production support on rotation.

Environment: Oracle 10g, Sun Solaris 10 SQL Plus, SQL, Pro c, Perl, PL/SQL, SQL Loader, TFS, Erwin, TOAD, Java, CVS, Perl, XML, Autosys, Forms10g, Reports10g

Sr. PL/SQL Developer

Confidential

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Analysis and gathering of new business requirements from the business resources.
• Worked thoroughly on coding and debugging of stored procedures, functions, packages and other Oracle objects to implement Business Rules.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Modified the existing procedures according to the new enhancements.
• Responsible for making decisions on coding standards and documentation.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in Performance tuning of SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• Created Global temporary tables to maintain session data and improved the performance of data retrieval.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Created UNIX Shell scripts to Import and Export data and user schema.
• Used Bulk collect and Forall for bulk fetch operations.
• Loading data from flat files into database tables using SQL Loader.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Writing scripts for Data Staging, Loading and cleanup process.
• Experience in developing various kinds of triggers and used sequences to generate values for surrogate keys in data warehouse tables using Before Insert triggers.
• Created Materialized Views and partitioning tables for performance reasons.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively used Nested tables, PL/SQL tables to code Procedures and Functions.
• Implemented common/generic routines utility functions to standardize backend processing.
• Worked with DBAs to tune long running queries, used Explain plan and SQL trace to analyze query execution plan.

Environment: Oracle 10g , SVN, TOAD 10.1, Clear case, SQL Plus, Sql developer, SVN, MS VSS, Share Point,.net, Sun Solaris/Windows

Oracle Developer

Confidential

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD Business Requirement Document that provides detailed information about the requirements.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Developed SQL loader scripts to load data in the custom tables.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages depending on the requirements.
• Created Unix Shell scripts for automating the execution process
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections Nested Tables and Arrays , and Error Handling.
• Developed UNIX shell scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL Loader.
• Conducted meeting with System Analyst to explain the application functionality.
• Responsible for creating PL/SQL libraries to handle security of the application, Error handling, general validation, screen activations etc.
• Created database triggers for data security Consistency.
• Created Materialized views normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance.
• Designed and developed front-end applications using Oracle Forms.
• Developed and maintained New Oracle Reports based on the Requirements.
• Data migration and conversion done utilizing Oracle utilities: Export/Import
• Involved in Extraction transformation and Loading
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Developed scripts for checking oracle errors in alert log and trace files for every 30 minutes.
• Involved in 24 x 7 production support for any adhoc or hot fix requirements.

Environment: Oracle 10g, Red Hat Linux 9/windows NT, SQL Plus, SQL, Pro c, Perl, PL/SQL, SQL Loader, Forms 9i, Reports 9i, Erwin, TOAD, Java, Perl, XML,

PL/SQL Developer

Confidential

Responsibilities:

• Worked in Data modeling, Data mapping and Data flow using Erwin
• Involved in Requirement gathering and writing Functional and Technical documents
• Created materialized views, Inline Views normal views where business requirements needed.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequences Synonyms.
• Tune the SQL queries and complex procedures to improve performance
• Experience in writing procedures, functions and packages for new requirements
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications
• Participated in Performance Tuning using Explain Plan and TkProf.
• Created bit map indexes and b-tree indexes for fast retrieval of data
• Analyzing user requirements and writing optimized queries to retrieve data from Oracle database
• Developed SQL loader scripts to load data from various forms of flat files into staging tables in Oracle database
• Created Materialized views normal views where business requirements needed
• Developed packages for processing data in the staging tables according to the Clients requirements
• Maintained and Updated existing applications of Oracle Forms and Oracle reports according to requirement.
• Writing UNIX Shell Scripts to automate load process, scheduling batch jobs in Crontab.
• Involved in analyzing Schema's, Tables and Indexes as part of OPTIMIZATION.
• Worked in unit, integration and performance testing.
• Documented changes and enhancements in code
• Involved in Code review before dropping into QA/UAT
• Coordinated with the team of java developers to accomplish complex financial calculations.
• Involved in the deployment of code into QA and Production environment
• Used CVS for version control of applications

Environment: Oracle 10g, UNIX, SQL Plus, SQL Loader, Toad, JAVA, CVS, PL/SQL Developer, Oracle Reports 6i, Oracle Forms 6i, Perl, Erwin, Pro c, XML, Windows XP.

PL/SQL Developer

Confidential

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing
• Used SQL Loader to load data into different tables
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers
• Extensively used PL/SQL to extract data from different tables with millions of records in some of the tables
• Created Materialized views normal views according to the requirement.
• Involved in solving day-to-day problems, giving support to the users
• Tune the SQL queries and complex procedures to improve performance
• Developed, modified and optimized complex queries for data retrieval and modification.
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.
• Extensively used SQL PL/SQL in reports. Cardinalities and Joins were used
• Incorporated validation rules for promotion history table and updating tables
• Participated in status meeting and walkthroughs
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.

Environment: Oracle 9i, SQL Plus, PL/SQL, Toad, MS Windows 2000, C, C