PROFESSIONAL SUMMARY

• 10 years of experience in Oracle 10g/9i/8i, SQL, PL/SQL as an Oracle Developer/ DB2 UDB 9.1/9.5 Developer in Analysis, Design and Crystal Reports.
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle/DB2 Database and many other facilities, such as Import/Export, SQL*Loader and SQL*Plus.
• Expertise in Conversion projects.
• Possess strong domain experience in Insurance, Power, Production, Finance and Pharmaceutical Industry.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Have experience using SQL, PL/SQL and Crystal Reports.
• Excellent skills in Triggers, Stored Procedures and Standard Packages.
• Experience in Application Development, Java, Java Script, Data Load using SQL*Loader and Crystal Reports Development.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and index.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Good experience in RDBMS development including Oracle, SQL, PL/SQL programs and stored procedures.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, SQL*Navigator and UTL_FILE.
• Extensive knowledge in GUI development using Oracle Forms and Reports Developer 2000.
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Good understanding of OOA and OOD concepts.
• Experience in DB capacity planning and handling Database security.
• Good knowledge in the Implementation of Business Applications using the ORDBMS.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Education/Certifications

• Master of Science (M.Sc), Osmania University, India
• Bachelor of Science (B.Sc), Osmania University, India
• Oracle Certified Professional (OCP)

TECHNICAL SKILLS

Operating Systems: Windows 9x/2000/NT/XP, UNIX, Solaris
Languages: SQL, PL/SQL, Java, J2EE, JSP, HTMl, CSS, Stored Procedures
Databases: Oracle 10g/9x/8x/7x, DB2 UDB 9.1/9.5, MS SQL Server 2000/7.0/6.5 & MS Access
Servers: JBoss, Jakarta Tomcat 5.x
GUI Tools: Crystal Reports 10/11.x, Oracle Forms 9i/6i/4.5, Oracle Reports 9i/6i/4.5/2.0,
Other Tools: TOAD, SQL*Loader, Forms Builder, Reports Builder, Schema Builder, Procedure Builder.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL Feb ’08 – Till Date

Conversion Developer/ Senior DB2/Oracle Developer
Description: BCBS implements integrated browser-based J2EE solutions and IBM iSeries solutions that enable users to track all information associated with Workers Compensation policies and claims in a seamless environment. PowerSuite is fully integrated yet modular Policy and Claims software that provides end-to-end core processing for Workers Compensation. It is a comprehensive All-in-One suite that takes care of policy administration/underwriting, claims administration, managed care, database and remarks tracking, and imaging needs.

Responsibilities:

• Converting Legacy data from various applications into PowerSuite.
• Involved in conducting Requirement, Systems Analysis, preparing Functional Specifications, Feasibility Studies, Design Reviews, Plan Reviews, Implementation and Post Implementation
• Participated in project planning sessions and all technical client meetings.
• Created Logical and Physical data base design using Sybase Powerdesigner
• Created Logical Flow of Data Conversion including source data analysis, data profiling and data cleansing for the historical data migration from Oracle 9i, Instar and DB2 Databases, CSV Files, Flat Files to DB2 UDB 9.5.
• Creation and Administration of OWB Repository and Run Time Repository, OWB Mappings to load the data from Flat File to Source Staging Area, OWB Mappings from Source Staging Area to Intermediate Staging Area by applying the Business Rules and OWB mappings to load the data from Intermediate Staging Area to Target Staging Area by applying all the business rules.
• Created Test Plans, Test Scripts and Perform the testing for data conversion process during all phases of Testing Starting from Unit, System, Integration and UAT
• Modified PL/SQL and Unix Shell scripts developed by the team and also created PL/SQL (Functions, Procedures, Packages and Triggers) and Shell Scripts for improving the performance of the System
• Some of the techniques used are: Analyzing the Explain plans, Tkprof, DBMS_Scheduler, Indexes, Partitioning, Materialized Views, etc
• Performed DBA activities like Installation, Import, Export, Backup, Restore, Migration and Management of Users and User Objects during the development of the Project
• Extensively used Collections (Index-by Tables, Nested Tables and Varrays)
• Defined problems in database design and determined alternatives and initiated corrective action to recover/restore data and return system back to normal operations
• Managing Start Team Version Control Tool for all database objects
• Supported Jboss (Websphare Server) for Maintenance activities like Start/Stop Application Service
• Provided the 24/7 Application Support for Post-Production Process
• Wrote UNIX Cronjob to scheduled batch processes, extensively KShell scripting for Wrapper scripts
• Developed Staging tables for all clients to extract data from legacy system.
• Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.

Environment : Oracle 8i/9i/10g, DB2, SQL Server 2005, PL/SQL, SQL*Loader, TOAD, Java, Reports 10g, MS- Office, UNIX (HP-UNIX, Solaris 8/9/10, Linux), Star Team, Clear Case, Oracle Warehouse Builder, Informatica, PL/SQL Developer, Aqua Data Studio, Oracle Designer 2000, HL7 3.0 and Business Objects X1.

Confidential, Foster City, CA Nov ’07 – Feb ‘08

Sr. Oracle Developer
Gilead Sciences, Inc. is a research-based biopharmaceutical company that discovers, develops and commercializes innovative medicines in areas of unmet need. Gilead has become one of the largest biopharmaceutical companies in the world, with a rapidly expanding product portfolio, growing pipeline of investigational drugs, more than 2,900 employees and operations on three continents. BusinessWeek magazine ranked Gilead third in its 2007 list of the Top 50 best-performing companies.

Responsibilities:

• Responsible for analyzing the business requirements of the project by collecting the Business Requirements from the end users.
• Responsible for system analysis, design, development, support and documentation.
• Responsible to Creation of database and database objects like Tables, Views, Materialized Views Procedures, Packages using Oracle tools like PL/SQL, SQL*Plus, SQL*Loader and Handled Exceptions.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Converted database schemas from SQL Server 2000 to Oracle 10g.
• Converted database from MS Access to Oracle 10g.
• Created Views for hiding actual tables and to eliminate the complexity of the large queries for Report Development.
• Created Various Indexes on tables to improve the performance by eliminating the full table scans.
• Responsible for maintenance, updates and daily backups of the schema.
• Write ctl files for loading database tables from Flat Files using SQL*Loader.
• Responsible for participating in Performance Tuning using Explain Plan.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle 10g/9i, SQL, PL/SQL, Toad, SQL *Loader, SQL Server 2000, MS Access, Visual SourceSafe (VSS), Windows XP.

Confidential, Costa Mesa, CA Jan ’07 - Nov ’07

Sr. Oracle Developer with Production Support
Commerce Energy Group, Inc. is a leading independent U.S. electricity and natural gas marketing company, operating through its wholly owned subsidiaries, Commerce Energy, Inc. and Skipping Stone Inc.
Responsibilities:

• Responsible for analyzing the business requirements of the project by collecting the Business Requirements from the end users.
• Responsible for system analysis, design, development, support and documentation.
• Responsible to Creation of database and database objects like tables, views, Materialized views procedures, packages using Oracle tools like PL/SQL, SQL*Plus, SQL*Loader and Handled Exceptions.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Created views for hiding actual tables and to eliminate the complexity of the large queries.
• Created various indexes on tables to improve the performance by eliminating the full table scans.
• Responsible for maintenance, updates and daily backups of the schema.
• Converted database schemas from 8i to 10g.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Developed and modified UNIX shell scripts and executed them as a Cron jobs.
• Responsible for participating in Performance Tuning using Explain Plan.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Plus, Toad, SQL *Loader, Web Services, Visual SourceSafe (VSS), Windows XP.

Confidential, IL Apr 06 – Jan 07

Oracle Developer
Tax Advantaged Investments
ZAIC a subsidiary of Swiss Insurance giant Zurich Financial Services A leading provider of commercial property, casualty insurance, the company offers a range of insurance coverage for businesses of all sizes from global corporations to medium size companies. Zurich has developed a variety of IT systems, which use a range of technologies and operating platforms. As part of their development team, I was involved in Analysis, Design, Coding and Implementation of their insurance products includes TAI (Tax Advantaged Investments) and CAPITA
Responsibilities

• Responsible for analyzing the business requirements of the project by studying the Business Requirement Specification document.
• Responsible for system analysis, design, development, support and documentation.
• Creation of database objects like tables, views, Materialized views procedures, packages using Oracle tools like PL/SQL, SQL*Plus, SQL*Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the business logic.
• Responsible for designing the front-end interface for the users, using Forms 6i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Created views for hiding actual tables and to eliminate the complexity of the large queries.
• Created indexes on tables to improve the performance by eliminating the full table scans.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Developed and modified UNIX shell scripts and executed them as a cron jobs.
• Responsible for participating in Performance Tuning using Explain Plan.
• Responsible for developing number of Reports using Crystal Reports 10.x
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Plus, Java, JavaScript, Perl Script, Crystal Reports 10.x, Windows XP.

Confidential,Boston, MA Feb 05 – Mar 06

Global Relationship Management
WMC, LLP is a financial asset management company headquartered in Boston, USA. Worked for the Global Relationship Management (GRM) team where in I converted ms access database to Oracle 9i and I also prepared different kinds of financial reports based on the requirements inputs from the business client group. Involved in develop, maintain production and customizes enterprise reports with huge computation queries of different data streams with various report layouts based on the requirements inputs from the business client group. Also involved in preparation of developing new reports, Functional Specifications, Scenario Matrix, ER- Params, query/report analyzing, validation and testing the reports.
Responsibilities

• Responsible to convert existing database(MS Access) to Oracle 9i.
• Responsible for analysis, database design, coding, and implementation.
• Responsible for creating various SQL and PL/SQL scripts for verification of the required functionalities.
• Used different Joins, sub-query, Inline views, Case construct, nested query, etc in SQL Query, for Reports.
• Extensively used PL/SQL in reports to perform calculation and to get desired output.
• Tuned SQL queries for optimum results.
• Created various Database triggers using PL/SQL.
• Used extensively PL/SQL, to develop packages, stored procedure, functions.
• Responsible for writing Unix scripts to run the reports for GRM standards.
• Having good knowledge in fixing the Enhancements and Bugs to previously developed Reports, done with System Testing and documented the entire report.
• Worked with various business groups, functional experts to implement their business and functional knowledge into working Procedures.
• Report layout design, Data models, Parameter forms which used Placeholder, Summary, and Formula Columns preparation of user manual and development of the program using Reports 6i.
• Responsible for developing different types (Transaction, Holding, Equity, Fixed Income, investment, etc…) of Reports which pulled the thousands of records.
• Developed input screens using Forms 6i.
• Responsible for conducting testing with the Co-ordination of users.

Environment: Oracle 9i, SQL*Plus, HTML, Java, JSP, Unix Shell scripts, PL/SQL Developer, Windows 2000.

Confidential,Topeka, KS Mar 04 – Jan 05

Oracle Developer
Human Resource Application
Project was to automate the HR department of Stormont-Vail Healthcare. This aim of this project is to minimize the paper work that needs to be maintained and makes the day-to-day operations of the department easier.
Responsibilities

• Responsible for designing and development of the system using Oracle Case Generation Methodology.
• Analysis and Data Modeling of Logical to Physical Data models using ERWin.
• Responsible for design and generation of Forms and Reports.
• Creation of SQL and PL/SQL scripts, calling C external routines from within PL/SQL for transfer of data between the databases.
• Responsible for designing and Generation of Reports using REF Cursors.
• Responsible for Integration and Implementation of the system & Trouble Shooting.
• Involved during User Acceptance Testing of the application.
• Participated in Code and Design Reviews for the ODS project for backend Data population and reporting system.
• Participated in status meeting and walkthroughs.
• Generation of Forms using Developer 2000 also responsible for creating Reports using Developer 2000.
• Responsible for creation of Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
• Use of Shell Scripts for day-to-day use of queries on Data Dictionary and other common tasks on Unix.
• Prepared the documentation of Forms and Reports.
• Responsible for implementing at the Clients site and imparting user training.

Environment: Oracle 9i, SQL*Plus, Forms 4.5, Oracle Report Writer 2.5, PL/SQL, Unix, Windows NT.

Matsushita Television & Network System Co., (M) Sdn. Bhd, Malaysia May 03 – Jan 04

Confidential,
Oracle Developer
M/s MTV have implemented Oracle Applications 11i, an ERP Product. For the application few Organization specific reports and forms are to be customized.
Responsibilities

• Requirement gathering and Report Generation in Oracle Fixed Assets, Oracle payables, Oracle Receivables for that I have used Procedures, Functions and Packages.
• Involved in installation/registration of the reports and imparting training to users on these reports.
• Responsible for defining new menus and assigning responsibilities to them defining new printers, concurrent programs, registering new executables.
• Responsible for developing new Forms, according to the Client Requirements.

Environment: Oracle Applications 11.5.7, Oracle Database 8.1.7, Developer 6i (Forms 6i & Reports 6i), Toad 7.0, SQL*Loader, Windows NT.