SUMMARY:

• Over 6+ yrs of software development experience in Production Support, Development and Implementation of Oracle, SQL, PL/SQL applications.
• Extensively worked in Client - Server application development using Oracle 9i/10g/11g, Forms, Crystal Report (CITRIX Application) and CAVA Workload job scheduler.
• Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell-Scripts and SQL Loader scripts.
• Expertise in performing Data export, Import and various operations using TOAD.
• Experience on working with DBA activities Password change, creating users, granting and revoking privileges on database objects and working on Disaster Recovery Drill.
• Experience in using version control tools PVCS, SVN.
• Worked on HLD & LLD in Designing phase of SDLC.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, Hints provided by oracle.
• Improve the performance of the slow SQL queries by implementing proper Index, using FORALL and BULK COLLECT.
• Experience in UNIX, loading of .dat file in FTH (File Transfer Hub), checking log files, error files.
• Experience working with Extranet Team, to setup File Transfer Connectivity.
• Experience of object-oriented programming (OOPS).
• Knowledge of HTML, XML, AJAX, CSS.
• Possess good communication skills and quick learning ability.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i

Oracle Tools: TOAD, PL/SQL Developer, SQL Developer, SQL Tool, SQL Navigator, Crystal Reports, Forms, SQL*Plus.

ETL Tools: Informatica Power Center 9

Data Modeling Tools: Erwin 4.5/4.0/3.5

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams.

Programming Languages: C, C++, Java, HTML, CSS, XML, JavaScript, Unix Shell Scripting

Environment: Windows 7/ 95/ 98/ 2000/ XP, Unix, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Willsonvile, OR

Production Support (Oracle Developer)

Responsibilities:

• Provides technical production support for the Application Development in Production using MKS software.
• Respond to user issues regarding their queries.
• Worked in Development, Test and Production Database Environment.
• Worked on Request-Services, Request- Incident, Request-Access, Request-Change for Level (1,2,3 & 4).
• Understanding the client’s requirement then programming the requirements and deploying it to Production.
• Involved in Emergency releases Code Changes, uploading it into PVCS.
• Worked on FTH Migration from one Server to another Server.
• Scheduling and Monitoring Jobs on Hourly, Daily, Weekly and Monthly basics.
• UseOracleForms,scheduling of CrystalReports and PL/SQL for maintenance and enhancements.
• Worked on Scheduling of Crystal reports in BOXI .
• Involved in writing complex queries to generate reports as per client requests as part of production support.
• Coordinated with DBA during Disaster Recovery Drill, Password Change and Database refresh Activities.
• Worked with UNIX, Extranet, ACC, Production Control, BOXI, Disaster Recovery and DBA Team.

Environment: Oracle 9i/8i, PL/SQL Developer, TOAD, SQL* plus, Forms 6i/4i, Crystal reports, PVCS Web Client, UNIX, CAVA Job scheduler.

Confidential, Baltimore, MD

Oracle Developer

Responsibilities:

• Involved in gathering the requirements, Documenting and Review.
• Created stored procedures, functions, Packages, Database triggers, constraints, indexes, grants and sequences based on business requirements.
• Supported developers for efficient SQL query and performance.
• Handled database server tuning, application tuning and Normalized the database for better performance.
• Involved in creating Index’s, passing hints, analyzing the table statistics and Table partitioning. Improved performance of existing report views by using hints.
• The performance is increased by 100 percent in many of the reports.
• Solving day to day issues rose with the loading process.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Developed Procedures and Triggers for Oracle Forms and Reports.
• Involved in writing complex queries to generate reports as per client requests as part of production support.
• Coordinated with DBA in improving Database Performance.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g/9i, SQL* Plus, Toad, PVCS.

Confidential, Milpitas, CA

Oracle Developer

Responsibilities:

• Involved in gathering the requirements, Documenting and Review.
• Created stored procedures, functions, Packages, Data base triggers, constraints, indexes, grants and sequences based on business requirements.
• Involved in Functional Design and Business Requirement Design(BRD)
• Involved in Running production day deployment and implementation activities for multiple projects.
• Handled database server tuning, application tuning and Normalized the database for better performance.
• Used SQL*Loader to upload data into the staging files from flat files.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Wrote PL/SQL code for data migration.
• Developed Reports using complex queries as per client request as a part of production support.
• Developed complex Oracle Forms10/11g providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.).
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Providing production support solving Tickets created using the software CDP.

Environment: Oracle 10g, SQL Server, PL/SQL, Reports, Forms, Toad, PL/SQL Developer, SQL*Loader

Confidential, Minneapolis, MN

Oracle Developer

Responsibilities:

• Involved in gathering requirements for the new enhancements and participated in Database Design changes and prepared documentation of the application.
• Co-ordinate with Business and Data Analysts in reviewing the requirements, posing questions and translating business requirements to technical specifications.
• Worked with a team which Upgraded Oracle DB 10g to Oracle 11g.
• Used Various Database administrative tools to maintain development and productions Oracle, SQL, Sybase Databases such as Oracle Grid Control, SQL Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.
• ER diagrams are developed using TOAD Data Modeler.
• Involved in creating and maintaining Partitioned Tables and Indexes.
• Exposure to the entire process of Software Development Life Cycle.
• Developing and coding data loading processes.
• Involved in database design, tuning, triggers, functions, materialized views, Oracle Job Scheduler, Oracle Advanced Queuing.
• Strong understanding of medical malpractice insurance processes.
• Involved in Production Support.
• Experience with Oracle 11g Data Warehouse Star Schema to include fact / dimension tables and data marts.
• Involved in designing Logical and Physical data models using ERWIN.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Exception Handling, Records and Collections.
• Creation of the database objects like tables, views, Materialized views, sequences, Synonyms, database links and indexes.
• Fine Tuned procedures for the maximum efficiency in various schemas across the database using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.
• Tuned the SQL using Explain Plan, TKProf and Stats pack for better performance.
• Transferred the data between databases using Export, Import and Datapump utilities.

Environment: Oracle 10g/11g, SQL, TOAD, PL/SQL, SQL*PLUS, Informatica Power Center 8.6.1, Forms 10g, Reports 10g.

Confidential

Oracle Developer

Responsibilities:

• Creation & Installation of Database 9i/10g.
• Day to day monitoring like availability of system, listener, database, alter log file, trace file.
• Developing relational database models using a tool such as ERWIN or Microsoft Visio.
• Created various database objects like table, indexes and views.
• Used Oracle 10g new feature data pump utilities (EXPDP/IMPDP) for Copying of data from development server to test and production server using.
• Loaded data into the tables using the stored procedures.
• Used Explain Plan for the performance tuning of PL/SQL blocks.
• Wrote complex SQL queries and generated reports using Crystal Reports 6i/4i.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Controlling and monitoring users access to the database.
• SQL & PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, package, sequences, grants and synonyms.
• Monitoring and optimizing the performance of database.
• Created and managed users, roles and profiles, audited and monitored databases and user access.
• Granted and revoked privileges to users as per requests and maintained database security procedure. Performed SQL tunning by using Explain Plan and Tkprof.
• Improved Performance of the database by troubleshooting whenever payroll run happens on the database for high performance output.
• Created documentation for the application.

Environment: Oracle 9i/10g, PL/SQL, WINDOWS XP.