SUMMARY

• 8+ years of working experience in Oracle 8i,9i,10G, 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.
• 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 teh data conversion from SQL Server and Oracle.
• Done teh data conversion from FoxPro
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Load teh data from MS Excel to Oracle Table and Oracle table to MS Excel.
• Loaded teh data using teh SQL loader, Imports & UTL files based on file formats.
• Conducted Oracle database and SQL code tuning to improve performance of teh application, used Bulk binds, in - line queries, Dynamic SQL, Analytics and Sub-query etc.
• Managed performance and tuning of SQL queries and fixed teh 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 teh abilities of Crystal Enterprise such as exporting, previewing, printing and emailing reports.
• Created Crystal Reports sourced from teh 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 SKILLS

Reporting Tools: Business Objects, Crystal Reports

Designing Tool: Erwin Data Modeler

Database: Oracle10g/9i/8i, SQL Server 2005, MS Access

Languages: SQL, PL SQL, Oracle Developer 2000,Unix Shells Scripting, C,C++,HTML,Java

Operating Systems: Windows95/98/2000/NT, MS DOS, UNIX

Other Tools: TOAD, SQL Loader, SQL Plus, Query Analyzer, MS-Word, MS-Excel, MS-VISIO, Visual Source Safe (VSS), CVS, Crystal Reports 8.0/XI, Forms 5.0,Forms 6i, Reports 6i, Forms 9i,Reports 9i,Oracle Reports 10G,Oracle Forms 10G, Oracle Apex, SQL Server Management Studio, Visual Studio 2008.

PROFESSIONAL EXPERIENCE

Confidential, Seattle

Oracle PL/Sql Developer

Responsibilities:

• Created lots of Triggers for validation.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of teh SQL queries to improve data conversion process.
• Created teh index for increasing teh performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load teh 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 teh 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 teh 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 teh slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported teh database and imported teh 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 teh inner join, outer join, cross join while writing teh 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 teh 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 11g, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS, XP, Linux, Putty.

Confidential, Seattle

Oracle PL/Sql Developer

Responsibilities:

• Created lots of Triggers for frontend validation.
• Done teh data conversion to move data from FoxPro system to Hansen 7.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of teh SQL queries to improve data conversion process.
• Created teh index for increasing teh performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load teh 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 teh 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 teh Reports from Business Object Info View.
• Created Master Detail and Cross Tab reports to view teh data in an analyzed way; formatted teh reports as per teh 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 teh 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 teh slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported teh database and imported teh 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 teh inner join, outer join, cross join while writing teh 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 teh 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.

Confidential

Oracle Developer

Responsibilities:

• Involved in a large migration project moving from Oracle 9i to 10g and prepared teh Impact Analysis Document prior to project launch.
• Worked on performance tuning including procedures, functions and SQL statements.
• Ran teh ADDM (Automatic Database Diagnostic Monitor) Report for performance tuning.
• Conducted performance tuning of teh database for optimal performance.
• Used partitioning and sub partitioning of tables to improve performance.
• Involved in teh database design and prepared teh detail design document (DDD).
• Created procedures, triggers, functions and packages using PL/SQL
• Load teh data from Excel file to oracle database.
• Conducted database and code tuning to improve performance of teh 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 teh 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 teh 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 teh bitmap index in data warehousing environment.
• Created lots of UNIX shell script to automate teh process.
• Created materialized view to increase teh 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

Responsibilities:

• Wrote queries/procedures to retrieve and store data in teh 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 teh projects.
• Load teh 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 teh primary reports
• Prepared estimates for Change requests raised by teh 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 teh code review.

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

Confidential

Responsibilities:

• Wrote queries/procedures to retrieve and store data in teh Oracle database.
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Analyzed and computed statistics to improve response time for queries.
• Maintained version control in VSS.
• Load teh 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 dis module.
• Prepared estimates for Change Requests raised by teh client.
• Provided new reports development and enhancements to existing reports.
• Worked on enhancements and bug fixes.
• Developed custom reports dat were formatted according to teh user requirements using Business Objects functionalities like @Functions and Formulas, 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

Confidential

Oracle PL/Sql Developer

Responsibilities:

• Contributed to teh 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 teh client.
• Performed Configuration Management using VSS.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out teh projects.
• Load teh data from Excel file to oracle database
• Used Bulk Collect feature to improve performance.
• Prepared and updated design specifications.
• Reports responsible for included teh following: General Ledger, Currency Conversion Rate, Payment sheet etc.
• Wrote queries/procedures/function/package to retrieve and store data in teh Oracle database.

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

Confidential

Responsibilities:

• Involved in teh 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 teh 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

Confidential

Oracle Developer

Responsibilities:

• 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 teh 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 teh 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 teh Oracle database.
• Created Master Detail and Cross Tab reports to view teh data in an analyzed way; formatted teh reports as per teh user requirements.
• Using Seagate Crystal Info 7.0, these reports were published to teh 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

Developer

Responsibilities:

• 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 teh 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

Responsibilities:

• 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 teh Oracle database.
• Designed views and stored procedures in Oracle 8i to be deployed in teh 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 teh database for optimal performance.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out teh projects.
• Developed SDLC technical documentation on teh workflow and development process of universes and functional specifications of reports.
• Created teh ramp-up document

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

Confidential

Responsibilities:

• Developed Oracle Forms/Reports 6i
• Prepared test cases and conducted performance tests.
• Wrote queries/procedures to retrieve and store data in teh Oracle database.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out teh projects.
• Load teh 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.