Sql Developer Resume Profile
SUMMARY OF QUALIFICATION
- Eight plus years of IT experience as an Oracle developer, PL/SQL developer, System Analysis, Design ,Development Support of Oracle Database 9i,10g and 11g in Production, Staging, Development environments.
- Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and using the latest features to optimize performance Bulk Binds, Inline views, Global Temporary Tables, Flashback .
- Extensive Experience with Oracle tools like SQL, PL/SQL, SQL PLUS, Oracle Enterprise Manager, SQL Developer, Oracle9i/10g Developers suite Reports.
- Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref. cursors, varrays, nested tables and Dynamic SQL.
- Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
- Experience in application fine-tuning and database fine-tuning using Explain Plan, SQL Trace and TKPROF.
- Experience in working high transacted OLTP systems.
- Strong experience with Oracle utilities like SQL Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
- Well Versed with Crystal Reports 8.5/10/11 and using TOAD 8.5/8.6/9 in secure databases.
- Extensive knowledge of using DBMS Oracle supplied package like UTL FILE, DBMS JOBS and DBMS SCHEDULER.
- Expert in UNIX Shell scripting Bourne, Korn .
- Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
- Extensive experience with all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance.
- Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
- Knowledge of Relational Database Management System RDBMS .
- Clear communication and documentation of technical specifications.
- Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
- Expert Skills in time management, prioritizing tasks.
TECHNICAL SKILLS
Databases | Oracle 11g,Oracle 10g,Oracle 9i, MS-Access, MySQL, MS SQL Server |
Environment | UNIX Sun Solaris, HP-UX, AIX , Windows NT/2003/2000/XP/98 |
Utilities | SQL Loader, Export / Import, Expdp / Impdp, Explain Plan, Oracle Wrap, FTP,SFTP, Cute FTP |
Languages/ Editor | SQL, PL/SQL, Shell Programming, C, HTML, XML, Vi Editor. |
Tools | Oracle Form Builder, Advance Query Tool AQT , TOAD 9.5/8.5, Oracle Enterprise Manager, Putty, AutoSys, PL/SQL Developer 7, Oracle Developer 2000/ Oracle Developer Suite 10g, SQL Loader, iSQL Plus, ERWIN 4.14/4.0, Dreamweaver, MS-FrontPage, MS Office Suite, Oracle JDeveloper 10.1.3.3, Crystal reports 8.5 |
Operating Systems | UNIX, Linux, Sun Solaris 5.8, 5.9, HP-UX, IBM AIX 5.2/5.3 Windows NT, Windows NT/20X/9X, Windows XP, Windows Server 2003 |
Project Management: | Microsoft Office Project, Excel, PowerPoint |
PROFESSIONAL EXPERIENCE
Confidential
Application Developer
Responsibilities:
- Involved in Analyzing a system, creating Design Documents, Coding, Development, Unit testing and Implementation.
- Creating and enhancing Oracle database objects, develop Pl/Sql packages/procedures and forms/Reports, perform application tuning using Oracle tools and utilities.
- Created new forms, modified existing forms for the user to use as a front end of application
- Created tables, Functions, Triggers, procedures for different projects.
- Creating and monitoring CA Workload/Autosys control center jobs used for automation of various processes.
- Providing efficient solutions by developing documentation, flowcharts, layouts, diagrams etc.
- Extending support to the production environment in providing solutions to issues there by reducing the impact.
- Utilizing knowledge of scripting languages which provide access to UNIX, Linux systems.
- Performing technology upgrades to enhance the performance of the applications. .
- The Skillset required to perform the job duties include expertise in Oracle Pl/Sql, Oracle forms 10g/11g,
- Oracle Reports 10g/11g, Linux, Pro C along with few other Financial Insurance applications.
- Upgraded the oracle database from 10g to 11g and also changed the platform from HP to AIX and then Linux.
Environment: TOAD 8.5, Oracle Forms Builder 11g, Oracle Reports Builder 11g, Putty, AutoSys, PL/SQL Developer 9, SQL Plus, MS Office Suite, Oracle JDeveloper 10.1.3.3, Crystal reports 8.5
Confidential
Oracle PL/SQL Report Developer
Responsibilities:
- Involved in Coding, Data conversion, Development and Implementation.
- Created SQL codes to generate the reports according to requirement of the front users.
- Created tables, Functions, Triggers, procedures for generating some complex reports.
- Encrypted the PL/SQL code using wrappers.
- Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
- Involved in writing test cases to ensure that requirements are met in the developed application.
- Created Korn Shell scripts for automating tasks.
- Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE.
- Used the rollup and cube operators to generate summaries.
Environment: Oracle 11g/9i, Advance Query Tool, SQL Developer, SQL PLUS, SQL, PL/SQL, UNIX, Windows XP, Oracle Reports, MS Office 2010.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
- Loading of customer data from flat files using SQL loader.
- Created tables, Functions, Triggers, procedures and packages for implementing complex database intensive business rules.
- Encrypted the PL/SQL code using wrappers.
- Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
- Involved in writing test cases to ensure that requirements are met in the developed application.
- Created Korn Shell scripts, Bourne Shell Scripts and Bash Shell for automating tasks as well as for creating extracts.
- Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE.
- Used the rollup and cube operators to generate summaries.
- Created SQL codes to generate the reports according to requirement of the front users.
Environment: Oracle 10g/11g, Solaris 5.8, UNIX, Windows XP, PL/SQL, SQL PLUS,
Oracle Reports, SQL Developer.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Analyzed of customer specifications and custom design of applications successfully and
- implementing designs in new/existing application using PL/SQL.
- Developed PL/SQL-Packages, SQL Scripts and Database Triggers to populate the historic data in the tables applying business logic.
- Used to extract data from external source s and transform and load into data warehouse.
- Developed database objects like tables, views, indexes, triggers, stored procedures.
- Used SQL Loader scripts to load the flat files into the Oracle Database.
- Performed application SQL Tuning using SQL Trace Explain plan for better performance.
- Created various simple and complex by joining more than two tables views.
- Involved in coding and designing of the Transaction Module using PL/SQL Procedure.
- Used various SQL Expressions and Conditions in standalone procedures and functions.
- Used File Transfer Protocol FTP tool to transfer files from one server to other.
- Implemented Export/Import Oracle utilities to move data to different testing environments.
- Developed Oracle Reports to displayed sales margins for daily, weekly, monthly, and
- quarterly totals along with detailed inventory information.
- Worked on Unix Shell Scripting for Scheduling Batch Jobs using Crontab.
- Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.
Environment: Oracle 11g/10g, SQL, PL/SQL, SQL PLUS, Informatica, TOAD, UNIX
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Gathered the requirement from different clients and translated user requirements
- into data flows, detail technical specifications and database requirement.
- Created stored procedures, packages, triggers.
- Used Wrappers for code security.
- Used cursors, exception handling methods along with pragma exception init in
- order to associate our own created exception names.
- Monitored indexes and analyzed their status for performance tuning and query optimization.
- Created the Temp tables in the stored procedure for different applications.
- Automation of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in UNIX.
- Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS to tune queries for better performance and also extensive Usage of Indexes.
- Loaded data from flat files into Database using SQL loader.
- Created UNIX scripts for automated process.
- Used DBMS JOBS package for job scheduling.
Environment: Oracle 10g, Solaris 5.8, UNIX, Windows XP, SQL Developer, Crystal
Reports.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Good understanding on high level business scenario of the company's financial functional structure.
- Created SQL codes to generate the reports according to requirement of the front users.
- Created tables, Functions, Triggers, procedures for generating some complex reports.
- Involved in the development of database objects.
- Involved in Oracle User creation assigning Roles Privileges.
- Writing Tuned SQL queries for data retrieval involving complex join conditions.
- Wrote stored procedures, functions, Packages, Triggers.
- Involved in writing cursors and handling exceptions.
- Used Import/Export utilities of Oracle.
- Created and managed primary data base objects such as Tables, Views, Indexes, Sequences and Synonyms.
- Preparation of Pre and Post test cases.
- Unit testing of developed components.
Environment: Oracle 10g/9i, MS Access, SQL/PL SQL, UNIX, Oracle Reports 6i Windows NT/98.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Involved in all the phases of System Development Life cycle.
- Creation of storyboard.
- Loading flat files using SQL Loader.
- Used to extract data from external source s and transform and load into data warehouse.
- Created various database objects like tables, views, indexes, triggers, sequences, synonyms.
- Created PL/SQL procedures, functions, packages required for the application.
- Writing the queries to get the data from different sources
- Tuning application using tools like SQL Trace, Analyze, and Explain Plan.
- Partitioning of tables for faster data retrieval.
- Helped in the creation of summary tables.
- Use of DBMS JOBS package to automate jobs.
Environment: Oracle 9i, Unix, MySql, Informatica, SQL, SQL Developer