Summary

• Around 6+ years of working experience in Oracle 8i,9i,10G , SQL and PL/SQL procedures, functions, packages, triggers, cursors, view etc.
• PL/SQL and ETL scripting and query optimization.
• Good experience in data warehouse systems.
• Over 2+ years of experience in Oracle Forms and Reports.
• Over 3+ years experience developing and supporting Crystal Reports XI 8 and Crystal Reports 8.
• 2+ years of experience in Performance tuning of Oracle database.
• Basic knowledge of DOTNET(C#,VB.NET)
• Basic Knowledge of 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 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.
• 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

Reporting Tools:

Business Objects, Crystal Reports

Designing Tool:

Database:

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

Languages:

SQL, PL SQL, Oracle Developer 2000, C,C++, Java,HTML

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), Crystal Reports 8.0/XI, Forms 5.0,Forms 6i, Reports 6i, Forms 9i,Reports 9i,Oracle Reports 10G,Oracle Forms 10G, Oracle Apex.

Professional Experience

Confidential, Seattle, USA
Oracle PL/Sql Developer
Aug 2009 Feb 2010

Client: City of Seattle
Project: Implement Restricted Parking Zone (RPZ) Permits into Hansen 7

• Created lots of Triggers for frontend validation.
• Done the data conversion to move data from FoxPro system to Hansen 7.
• 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 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.
• Environment: Oracle 9i/10g, Crystal Reports 2008, Data Integrator, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS,XP, Business Object Info View, CMC.

Confidential, Pune, India
Oracle Developer
May 2006 Sep 2008

Project: Global PT, Jan 2008 Sep 2008

• 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.
• Environment: Oracle 9i/10g, Crystal Reports XI, Data Integrator, MS Access 2003, MS Excel, TOAD, WebLogic, UNIX, and Microsoft Office

Client: Confidential,Pune, India
Project: TTPRO (Issue Tracking Application), Feb 2007 to Dec 2007

• 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

Client:Confidential,Netherlands
Project: Catlogic Design Office, May 2006 Jan 2007

• 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.
• 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, India
Oracle PL/Sql Developer
June 2005 Apr 2006

Client: Confidential,Japan
Project: GL Subsidiary, Oct 2005 Apr 2005

• 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

Client: Confidential,Location India
Project: Financial Accounting System, Jun 2005 Sep 2005

• 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

Confidential,Gurgaon
Oracle Developer
Oct 2004 May 2005

• 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,Delhi, India
Developer
Apr 2004-Sep 2004

Client: SaraLee Corporation
Project: Vendor Management System
Description: 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,Delhi, India
Developer
July 2003 Mar 2004

Project: Banking Collection System, July 2003 Sep 2004
Client: ICICI Bank, India

• 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
• Environment: Oracle Forms 6i, Oracle Reports 6i, Oracle 10g, Crystal Reports 8, MS Access 2003, MS Excel TOAD, Microsoft Windows XP Professional, Microsoft Office.

Project: Management Information System, July 2003 Dec 2003
Client:Confidential,India

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

Education

• Master of Computer Application

Professional Certification

• Oracle Certified Professional (OCP) Aug 2007