SUMMARY

• Possesses 9+ years of IT experience in all phases of project such as interacting wif business analysts and developers to analyze the user requirements, functional specifications and system specifications, Application Development, Testing, production support, Implementation and documentation.
• Possesses 9+ years of strong hands on experience in Oracle 10g/9i/8i, PL/SQL, Oracle Reports 10g/9i/8i.
• Well experienced in data warehouse, data migration/data conversion
• Strong Coding Experience in Oracle SQL, PL/SQL, PRO*C, UNIX Shell Scripts.
• Strong technical hands on experience in creating and maintaining database objects like tables, views, materialized views, indexes, sequences, synonyms and database links
• Proficient in Oracle utilities and tools like SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, SQL Developer, PL/SQL Developer, SQL Navigator
• Extensive experience in developing stored procedures, functions, packages, views, cursors, collections (nested tables and varrays), records, REF cursors, bulk binds, object types and database triggers.
• Extensive experience in Performance Tuning using Explain Plan, SQL Trace & TKPROF utilities, DBMS PROFILER, DBMS XPLAN.
• TEMPHas good experience in designing Entity Relationship Diagram (ERD), Schema, Logical and Physical data models and Data Flow Diagram (DFD) for different database applications.
• Extensive experience in creating batch process, jobs and queue.
• Expert in using FTP, SFTP, NDM (direct).

TECHNICAL SKILLS

Languages: PL/SQL, Transact - SQL, SQL*PLUS, JAVA, HTML, Oracle Reports

Operating Systems: AIX, UNIX, Linux, Windows, MS-DOS

Databases: Oracle 8i/9i/10g, MS-SQL SERVER, SYBASE

IDE (Development Tools): PL/SQL developer, Toad, SQL Navigator, Rapid SQL

Protocol: FTP, SFTP, NDM (Direct)

Version Control tool: StarTeam, PVCS, CVS, Subversion (SVN)

Task management tool: JIRA, Elementool.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. ETL and PL/SQL Developer

Environment: Oracle 10g, SQL, PL/SQL, Reports 10g, Windows NT/2000, UNIX (AIX), Shell Scripting, batch files, Subversion, Rapid SQL, Toad, ElemenTool - Task management tool, SQL Server 2005, Sybase, Transact-SQL, ETL(data conversion/data migration), Data Warehousing.

Responsibilities:

• Implementing Facets (Integrated Healthcare solution), migrating data from legacy systems (SQL Server, Sybase, Amisys, etc..) into Facets database (Oracle) and into Data warehouse.
• Writing PL/SQL code to integrate data from multiple source systems into Data Warehouse and Facets.
• Doing heavy ETL using PL/SQL code. (stored procedures, functions, triggers, packages, batch jobs)
• Performing SQL and PL/SQL tuning using Explain Plan, Execution plan, SQL Trace utility, TKProf & DBMS PROFILER.
• Writing Korn shell scripts.
• Carrying out code review of other developers .
• Maintaining different versions of codes using SVN.
• Using SQL*Loader, BCP (bulk loader) to load data.
• Using DBMS JOBS, DBMS SCHEDULER to automate jobs.
• Writing Batch jobs, daily jobs, one time jobs and queues.
• Using Oracle Reports for reporting.

Confidential, Irving, TX

Sr. PL/SQL Developer

Environment: Oracle 10g, PL/SQL, Oracle Reports 10g, Crystal Reports, PL/SQL Developer, SQL * Loader, Version control software CVS, Korn Shell script, COGNOS 8.0 - Query Studio, Report studio, eclipse, performance tuning, data transfer using FTP, SFTP, NDM (Direct), Export, Import, JAVA, Windows NT, AIX.

Responsibilities:

• Created high performance queries and PL/SQL codes using Bulk Binds, Collections, REF Cursors etc for OLTP and ETL. Wrote high performance procedures, functions, triggers, packages, Korn shell scripts for ETL process.
• Wrote Data Cleaning scripts.
• Used SQL * Loader to upload data into the staging files from external files, using Export, Import, for data transfer from one domain to another domain using FTP, SFTP, NDM (Direct), JAVA interfacing class.
• Helped other developers in tuning queries and trained them to write well - tuned code.
• Did code review, checking code standard of other junior developers.
• Created and tuned various feeds/downloads, nightly jobs, and other daily/monthly reports/download.
• Did performance tuning using Explain Plan, Execution plan, SQL Trace utility, TKProf & DBMS PROFILER.
• Maintaining different versions of codes using CVS, Starteam, multiple task using JIRA.
• Performing Development testing, Unit testing, UAT, creating test plan for QA and preparing production implementation scripts.
• Doing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Korn Shell Scripts.
• Creating rollback scripts.
• Performing Development test, UAT, preparing production implementation scripts and test plan for QA.

Confidential, Richardson, TX

Sr. PL/SQL Developer

Environment: Oracle 10g, PL/SQL, Korn Shell Script, Window NT, AIX, FTP, SFTP, NDM, PL/SQL Developer, Toad 8.5, SQL*Loader, Version Control Software CVS, ElemenTool for Production Support.

Responsibilities:

• Understanding the existing business processes and Interacting wif Super User and End User to finalize their requirement.
• Has extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.
• Used SQL * Loader to upload data into the staging files from flat files.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Created Batch jobs, daily jobs, one time jobs and queues.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Maintaining different version of software (version control) using CVS.
• Providing production support solving Tickets created using the software ElemenTool.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.
• Preparing Production implementation plan & scripts.

Confidential, Dallas, TX

Sr. PL/SQL Developer

Environment: Oracle 10g, PL/SQL, Oracle Reports 10g, HTML, Korn Shell Script, Window NT, AIX, JAVA, FTP, SFTP, NDM (Direct), SQL Navigator 4.5, Version Control Software PVCS.

Responsibilities:

• Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Korn Shell Scripts.
• Analyzed, created new and modified existing reports, scheduled reports, oracle jobs using AIX, Oracle 10g, Oracle Web Toolkit, Reports (10g/9i), PL/SQL, Stored Procedures, Functions, Packages, Korn Shell Scripting, FTP, SFTP, NDM (direct).
• Did code reviews of other developers and provided suggestions to improve performance
• Wrote high performance queries/programs using Bulk Binds, REF Cursors etc.
• Helped other developers in tuning queries or programs and trained them to write well-tuned code.
• Provided expertise to development managers in design or preparing proof-of-concept testing.
• Converted Reports from 9i to 10g.
• Designed and Developed FTP, SFTP and NDM (direct) processes using Java, PL/SQL and Korn Shell Script.
• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
• Tuned batch jobs and other daily/monthly reports/downloads.

Confidential, Seatle, WA

Sr. Oracle Developer

Environment: Oracle Forms 6i/9i, Reports 6i/9i, PL/SQL, Oracle 9i, Windows NT, UNIX, JAVA, J2EE.

Responsibilities:

• Understood the existing business processes and Interacted wif Super User and End User to finalize their requirement. Provided technical support to the user wif regard to operational aspects.
• Designed, developed and enhanced Custom Oracle Reports according to the functional specification.
• Designed the reports that had complex SQL, PL/SQL code and Stored Procedures, as Oracle Reports developer.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Built and maintained production, test and development database environments
• Periodic database changes for continuous enhancements and system performance.
• Documented all Oracle Forms, Reports, Package development specifications.
• Provided Quality assurance for all the modules developed.