Summary

• 9 years of working experience in Oracle 8i,9i,10G,11G, SQL and PL/SQL procedures, functions, packages, triggers, cursors, view etc.
• Good experience in PL/SQL and ETL scripting and query optimization.
• Good experience in data warehouse systems.
• Good experience in UNIX shells scripting.
• Over 2 years of experience in Oracle Forms and Reports.
• Over 2 years of experience in SQL Server 2005/2008 and SSIS Package.
• Over 3 years experience developing and supporting Crystal Reports XI and Crystal
• Reports 8.
• 3 years of experience in Performance tuning of Oracle database.
• Basic knowledge of DOTNET C ,VB.NET ,Visual Studio 2008,Java.
• Extensive experience in MS Excel.
• Extensive experience in writing stored procedures, functions and views.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Involved in all phases of a migration project from Oracle 9i to10G.
• Done the data conversion from SQL Server and Oracle.
• Done the data conversion from FoxPro
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.
• Loaded the data using the SQL loader, Imports UTL files based on file formats.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query etc.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Used partitioning and sub partitioning of tables to improve performance.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
• Good Experience in Unit Testing, Integration Testing and Performance Testing.
• Worked heavily with relationship database models, schemas entity-relationship diagrams ERMs to create technical/system design documents.
• Expertise preparing report specifications and database designs to support reporting requirements
• Developed complex reports multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drilldown through On Demand Sub-reports, dynamic link labeling, complex functions, cross-tabs, charts, shared variables, imported parameters and record sets from stored procedures, conditionally suppressed sections, error handling/messaging, clean and attractive designs, user friendly with instructional ToolTips.
• Worked with team on customizing the abilities of Crystal Enterprise such as exporting, previewing, printing and emailing reports.
• Created Crystal Reports sourced from the Oracle database and flat files.
• Created ad-hoc reports as well as canned/recurring reports such as daily, monthly, and annual from simple drilldowns to complex summaries with charts/graphs, cross-tabs, running totals, multiple sections, etc.

Technical Skill Summary

Professional Experience

Confidential

Oracle PL/Sql Lead Developer

Project: DPM Data production and management

• Created lots of Triggers for validation.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• Done Configuration Management using VSS.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated HLD and LLD design documents.
• Created data model.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports UTL files based on file formats.
• Created lots of SQL script for ETL Process.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Created lots of UNIX shell script to automate the process.
• Experience in writing shell scripting for various ETL needs
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Created some database objects in SQL Server2008 like procedure, function, views, cursors etc.

Environment: Oracle 11g, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS, XP, Linux, Putty, SQL Server 2008, Informatica.

Confidential

Oracle PL/Sql Lead Developer

Confidential

• Created lots of Triggers for validation.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• Done Configuration Management using VSS.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated HLD and LLD design documents.
• Created data model.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports UTL files based on file formats.
• Created lots of SQL script for ETL Process.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Created lots of UNIX shell script to automate the process.
• Experience in writing shell scripting for various ETL needs
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Created some database objects in SQL Server2008 like procedure, function, views, cursors etc.

Environment: Oracle 11g, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS, XP, Linux, Putty, SQL Server 2008, Informatica.

Confidential

Oracle PL/Sql Lead Developer

Confidential

• Project: Enterprise Project Management
• Created lots of Triggers for validation.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• Done Configuration Management using VSS.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated design specifications.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports UTL files based on file formats.
• Created lots of SQL script for ETL Process.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Created lots of UNIX shell script to automate the process.
• Experience in writing shell scripting for various ETL needs
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Created some database objects in SQL Server2008 like procedure, function, views, cursors etc.

Environment: Oracle 11g, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS, XP, Linux, Putty, SQL Server 2008

Confidential

Sr Oracle PL/Sql Developer

• Project: Global Labor Scheduling
• Created lots of Triggers for validation.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• Done Configuration Management using VSS.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated design specifications.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports UTL files based on file formats.
• Created lots of SQL script for ETL Process.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Created lots of UNIX shell script to automate the process.
• Experience in writing shell scripting for various ETL needs
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Created some database objects in SQL Server2008 like procedure, function, views, cursors etc.

Environment: Oracle 11g, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS, XP, Linux, Putty, SQL Server 2008

Oracle PL/Sql Developer

Confidential

• Worked on performance tuning of the SQL queries to improve data conversion process.
• Created lots of procedure, package, and functions.
• Done the data conversion to move data from FoxPro system to Hansen 7.
• Created lots of Triggers for frontend validation.
• Project: Implement Restricted Parking Zone RPZ Permits into Hansen 7
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• I used Informatica Tool for ETL Process.
• Done Configuration Management using VSS.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated design specifications.
• Developed a variety of Management reports for users, using Crystal Reports 2008.
• Created parameterized reports and customized existing reports. Developed various sub-reports, running totals per period.
• Run the Reports from Business Object Info View.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way formatted the reports as per the user requirements.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports UTL files based on file formats.
• Created lots of SQL script.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Created lots of UNIX shell script to automate the process.
• Experience in writing shell scripting for various ETL needs
• Design and development of UNIX Shell Scripts to handle pre and post session processes.

Environment: Oracle 9i/10g, Crystal Reports 2008, Data Integrator, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS,XP, Business Object Info View, CMC, Linux.

Oracle Developer

• Involved in a large migration project moving from Oracle 9i to 10g and prepared the Impact Analysis Document prior to project launch.
• Worked on performance tuning including procedures, functions and SQL statements.
• Ran the ADDM Automatic Database Diagnostic Monitor Report for performance tuning.
• Conducted performance tuning of the database for optimal performance.
• Used partitioning and sub partitioning of tables to improve performance.
• Involved in the database design and prepared the detail design document DDD .
• Created procedures, triggers, functions and packages using PL/SQL
• Load the data from Excel file to oracle database.
• Conducted database and code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Analyzed and computed statistics to improve response time for queries.
• Performed Unit Testing, Integration Testing and Performance Testing.
• Developed a variety of activity reports for users, using Crystal Reports.
• Scheduled regular backups of data, universes, and reports.
• Developed complex reports using multiple data providers and report level variables.
• Developed materialized views and other database objects to optimize reports.
• Implemented different level hierarchies for drill down reports.
• Worked with developers for performance tuning of the queries to improve user experience.
• Created data dictionaries.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Worked on Fact and dimension table of data warehouse.
• Created UNIX shell scripts.
• Worked on data extraction, data cleaning, data transformation and data loading process.
• Created the bitmap index in data warehousing environment.
• Created lots of UNIX shell script to automate the process.
• Created materialized view to increase the performance in data warehousing environment.
• Used rollup and cubes for summary data.

Environment: Oracle 9i/10g, Crystal Reports XI, Data Integrator, MS Access 2003, MS Excel, TOAD, WebLogic, UNIX, and Microsoft Office

Confidential

• Wrote queries/procedures to retrieve and store data in the Oracle database.
• Coded and maintained PL/SQL Packages, Stored Procedures and Database Triggers.
• Tuned SQL queries and performed code debugging using TOAD.
• Developed complex queries including Sub queries, Unions, Intersect and Aliases.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Load the data from Excel file to oracle database and Oracle table to Excel file.
• Created parameterized reports and customized existing reports. Developed various sub-reports, running totals per period.
• Successfully involved in inclusion of linked as well as unlinked sub-reports along with the primary reports
• Prepared estimates for Change requests raised by the client.
• Conducted Configuration Management using VSS.
• Coded for Oracle Apex
• Involved in unit testing and writing test cases.
• Coordinated team activities
• Conducted enhancement and bug fixing.
• Involved in the code review.

Environment: Oracle Apex, Oracle 10g, Crystal Reports XI, Data Integrator, Visio, MS Excel, TOAD, Microsoft Windows XP Professional

Confidential

• Wrote queries/procedures to retrieve and store data in the Oracle database.
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Analyzed and computed statistics to improve response time for queries.
• Maintained version control in VSS.
• Load the data from Excel file to oracle database.
• Generated linked reports with complex cross-tab reports with multiple queries, conditions, global filters and multiple data providers.
• Developed Crystal Reports and RFC Cybage internal XML based tool
• Prepared test cases and conducted Unit Testing for this module.
• Prepared estimates for Change Requests raised by the client.
• Provided new reports development and enhancements to existing reports.
• Worked on enhancements and bug fixes.
• Developed custom reports that were formatted according to the user requirements using Business Objects functionalities like Functions and Formulas, etc.
• Created some database objects in SQL Server2005 like procedure, function, views, cursors, indexes etc.

Environment: Groovy, GAD/GAP Internal tool of client ,Crystal Reports XI, Data Integrator, MS Access 2003, MS Excel ,Oracle 10g, Visio, TOAD, Weblogic, Microsoft Windows XP Professional, Microsoft Office, SQL Server 2005

Confidential

Oracle PL/Sql Developer

• Contributed to the database design and prepared detail level design document
• Developed/Coded in Oracle Forms/Reports
• Prepared test cases and performed unit testing.
• Provided estimates for Change Requests raised by the client.
• Performed Configuration Management using VSS.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Load the data from Excel file to oracle database
• Used Bulk Collect feature to improve performance.
• Prepared and updated design specifications.
• Reports responsible for included the following: General Ledger, Currency Conversion Rate, Payment sheet etc.
• Wrote queries/procedures/function/package to retrieve and store data in the Oracle database.

Environment: Oracle Forms 10G, Oracle Reports 10G, Oracle 9i/10g, MS Access 2003, MS Excel, TOAD, UNIX, Microsoft Office, VSS

• Involved in the database design and prepared detail level design document
• Developed/coded in Oracle Forms/Reports
• Prepared test cases and performed unit testing.
• Proposed Innovative ideas/architectural designs/changes those were approved and appreciated.
• Prepared and updated design specifications.
• Wrote queries/procedures to retrieve and store data in the Oracle database.
• Scheduled regular backups of data, universes, and reports.
• Tuned SQL queries and performed code debugging using TOAD
• Used Bulk Collect feature to improve performance.
• Developed complex queries including Sub queries, Unions, Intersects and Aliases.

• Maintained version control in VSS

Environment: Oracle Forms 6i, Oracle Reports 6i, Oracle 9i/10g, MS Access 2003, MS Excel, TOAD, UNIX, Microsoft Office, VSS

Oracle Developer

Confidential

• Developed/coded reports, implemented different level of hierarchies for drill down reports.
• Involved in developing both static and dynamic reports.
• Created Master/Detail reports, Cross-tabs, Matrixes and Charts, etc.
• Load the data from Excel file to oracle database.
• Controlled reports data by working with Universe and queries, using Filters, Sorts and Rankings.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Involved in the database design and prepared detailed level design document
• Prepared test cases and performed unit testing.
• Prepared and updated design specifications.
• Wrote queries/procedures to retrieve and store data in the Oracle database.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way formatted the reports as per the user requirements.
• Using Seagate Crystal Info 7.0, these reports were published to the Web with report data in HTML or easy-to-use Microsoft Office formats, including MS Excel spreadsheets and MS Word documents with charts and graphs.

Environment: Seagate Crystal Reports 8, MS Access 2003, MS Excel, Oracle 8i, TOAD, Microsoft Windows XP Professional, and Microsoft Office.

Confidential

DevelopeDescription: Vendor Management System is Software as a Service project. VMS is a software application delivery model where a software vendor develops a web-native software application, hosts and operates either independently or through a third-party the application for use by its customers over the Internet Customers pay not for owning the software itself but for using it. They use it through an API accessible over the Web and often written using Web Service.

• Developing Admin module
• Site Navigation Implementation
• Writing stored procedures and DB script generation
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Generating test cases, executed test cases
• Perform Unit, Integration, System and Acceptance testing

Environment: C .NET, ASP.NET 2.0, SQLserver2005, ADO.NET, HTML, MS Excel

Confidential

Developer

• Developed/coded in Oracle Forms/Reports,. Some reports were created using Crystal Reports.
• Prepared test cases and performed unit testing.
• Wrote queries/procedures to retrieve and store data in the Oracle database.
• Designed views and stored procedures in Oracle 8i to be deployed in the reports for better performance used these procedures and views in numerous reports.
• Created parameterized reports and customized existing reports developed various sub-reports, running totals per period.
• Tuned the database for optimal performance.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Developed SDLC technical documentation on the workflow and development process of universes and functional specifications of reports.
• Created the ramp-up document
• Created some database objects in SQL Server2005 like procedure, function, packages, views, cursors, indexes etc.

Environment: Oracle Forms 6i, Oracle Reports 6i, Oracle 10g, Crystal Reports 8, MS Access 2003, MS Excel TOAD, Microsoft Windows XP Professional, Microsoft Office.

• Developed Oracle Forms/Reports 6i
• Prepared test cases and conducted performance tests.
• Wrote queries/procedures to retrieve and store data in the Oracle database.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Load the data from Excel file to oracle database.
• Involved in developing both static and dynamic reports.
• Scheduled regular backups of data, universes, and reports.
• Coded and maintained PL/SQL Packages, Stored Procedures and DB Triggers
• Tuned SQL queries and performed code debugging using SQL Navigator.

Environment: Forms 6i, Reports 6i, Oracle 9i,SQL Server, Crystal Reports 8, Data Integrator, MS Access 2003, MS Excel ,TOAD, Microsoft Windows XP Professional, Microsoft Office.