SUMMARY

• 8+ Years of experience in Oracle Database Programming using PL/SQL, SQL, Database Design (both Physical and Logical), Database Modeling (Designer 2000), Application Support, Performance Tuning, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
• Extensive experience in database development (11g/10g/9i/8i) using various Oracle objects like cursors, ref - cursors, collections(nested tables, Varrays), Functions, Procedures, triggers, packages, views, DB Links, DB Export/Import utilities,External Tables and indexes, Materialized Views and also performed query optimization, database performance tuning.
• Created and maintained autosys jobs to schedule various tasks to implement business rules.
• Used Pipelined table functions, sql trace, partitioning and bulk binding techniques to improve teh performance of teh existing code.
• Competent in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, and Sequence Diagrams using Microsoft Visio and Erwin.
• Experience in Data migration Projects which uses SQL Loader, Import/Export PL/SQL Programming, coding Procedures, triggers and functions.
• Strong experience using Unix Shell Scripting, Pro*C, HTML, Oracle 11g/10g/9i/8i, Windows 2000, Windows NT 4.0, Windows 98/95/3.1, MS DOS 6.22
• Experience using PL/SQL, SQL, Pro*C, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes- B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL, Dynamic SQL. Expertise in writing and debugging Pro*C programs in both UNIX and Windows environment
• Experience in Installation, Setup, and Configuration, Maintenance and Tuning of Oracle 11g/10g /9i /8i under Windows NT/95/98/2000 environment.
• Exposure in using CASE tools like TOAD, SQL Navigator and SQL Developer for writing PL/SQL programs.
• Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Experience in numerous Oracle implementations through full infrastructure and performance optimizations including me/O optimization, Backup and Recovery Planning, Testing and Implementation.
• Extensive experience in a Data warehousing environment.
• Hands-on experience in implementing various query-optimization techniques and business rules in a DW environment
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Knowledge on Informatica 8.6, BI publisher, DAC, OLAP, OLTP and OBIEE.
• Have noledge on XML.
• Have good noledge on Orcle Argus and ArisG

TECHNICAL SKILLS

Oracle: Oracle 11g/10g/9i/8i, Oracle Developer 2000, SQL*Plus, SQL*Loader, TOAD 7.0, and Developer 2000, Tora Oracle Tkprof & Trace, Oracle Enterprise Manager

Databases: Oracle, MS Access 2000, SQL*Plus, SQL*Loader, TOAD, Developer 2000,OLTP,OLAP

Reporting Tools: TOAD, SQL Navigator, PL SQL, OBIEE

Languages: PL /SQL, SQL, SQL*Plus

Programming/Others: SQL, PL/SQL, Unix Shell Scripting, SQL*Loader, SQL*Plus, Pro*C, C, HTML 4.0

Others Tools: ODBC, OLAP, TCP/IP, MS Office 97/98/2000 and Dream Weaver, JIRA, SMS, Remedy

Operating systems: UNIX, Windows 98/NT/2000/XP

ETL: Knowledge on Informatica 8.6

PROFESSIONAL EXPERIENCE

Confidential, Stamford CT

Tech Lead/Project Lead

Responsibilities:

• Gathering teh functional requirements from users and converting them into Technical requirements.
• Migrating data from Siebel to Oracle Database.
• Creating database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL.
• Level 2 & Level 3 production support for dis project. Supported teh system round teh clock
• Responsible for identifying teh cause and resolving teh issues. Debug and fix any issues dat arise during teh course of any day
• Carry out teh month end load, and extractions processes. Communicate with other teams and business users to notify about teh newly loaded files and taking care of teh issues surface during dis process
• Implement teh necessary code optimizations and develop/automate processes to reduce errors in file loads
• Mapped data from Siebel to Oracle by creating a similar data model
• Using SQL* Loader and export/import mechanism for data migration for bulk upload.
• Perform Unit testing in development environment and had a close interactions with system test and user acceptance team to complete technical and functional testing.
• Working as a coordinator between teh onsite and offshore teams.
• Preparing RCA, TDD, FDD documents.
• Providing teh on-call support 24*7 to resolve RTS issues (Ready to Serve).

Environment: Oracle 10g/11g, SQL Developer, Quality Center, SVN, Informatica, Cognos,TFS,RemedyOracle Argus, ArisG

Environment: al Protection Agency, Washington D.C

Confidential

Senior Oracle Developer

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Create detailed documentation for user approval.
• Create and modified data migration scripts/Pull Scripts.
• Loaded data from Existing database schema to new schema using Oracle Packages.
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Triggers and Packages.
• Writing database triggers for automatic updating teh tables and views.
• Create User Schemas, tables, indexes, sequences, views, directories.
• Verify, validate data using SQL queries.
• Modified existing Code according to teh requirements.
• Day to day production support.
• Troubleshoot and debug system and/or data errors.
• Tuned SQL queries using Tkprof utility to improve performance.
• Involved in Testing, Integration System test, Implementation (test with users).
• Converted data from legacy system to Oracle 10g using PL/SQL programs.
• Responsible for creating complex views.
• Use VSS and SVN for source control.
• Involved in migrating MS-Access systems to Oracle Database.

Environment: Oracle 11g/10g, Windows XP, VSS, SQL *Loader, JIRA, TOAD, Erwin, QC

Confidential, Scottsdale (AZ)

Technical Consultant

Responsibilities:

• Develop Stored Procedures, Functions, Views, Cursors, Packages and Exceptions.
• Configure teh server with product installation and batch set up.
• Troubleshoot teh issues related to SCPO.
• Manage data conversion from flat files to Oracle using Oracle SQL* Loader.
• Modify Oracle PL/SQL Procedures and Functions as per teh client requirements.
• Scrutinize SQL statements using “Explain Plan” to improve teh performance.
• Preparing Functional specification documents.
• Understand teh technical & functional specifications designing, developing, Testing, troubleshooting and debugging of teh applications.
• Monitor teh scheduled jobs using AS400.
• Handle SCPO and EP tickets as per teh request from client.
• Provide timely response to all client requests, including on-call support (L2) outside Normal business hours.

Environment: Oracle 11g/10g, AS400, Windows, SQL *Loader, TOAD, Unix

Confidential, Greater Chicago (IL)

Senior Oracle PL SQL Developer

Responsibilities:

• Verify, validate data using SQL queries and create text according to teh requirements.
• Modified existing Code according to teh requirements.
• Load teh created text in to teh normalized tables using PL/SQL Store Procedures, Functions and Packages.
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Ref Cursors Triggers and Packages.
• Troubleshoot and debug system and/or data errors.
• Tuned SQL queries using Tkprof utility to improve performance.
• Involved in Testing, Integration System test, Implementation.
• Source and target system Analysis.
• Co-ordinate/Discuss with Onsite team and leads for requirement clarification.
• Implement PL/SQL jobs as per teh client requirements.

Environment: Oracle 11g, Datastage, Autosys, Abinitio, Cognos, Remedy tool.

Confidential, Greater Chicago (IL)

Senior Oracle Developer

Responsibilities:

• Loading data from flat files into Oracle 10g database using SQL*loader
• Verify, validate data using SQL queries
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Ref Cursors Triggers and Packages.
• Troubleshoot and debug system and/or data errors.
• Create User Schemas, tables, indexes, sequences, views, directories.
• Create detailed documentation for user approval.
• Modified existing Code according to teh requirements.
• Involved in Testing, Integration System test, Implementation.
• Involved in development of SVI reports and share it with teh Orbit team.

Environment: Oracle 10g, Windows OS, Informatica 8.6, SQL Developer

Confidential

Oracle PL SQL Developer

Responsibilities:

• Create detailed documentation for Data conversion and migration.
• Loading large data into teh Oracle database objects. Importing/Exporting data from/to different databases using utilities like SQL*Loader and Import/Export.
• Wrote fine-tuned SQL queries to Migrate and Convert teh data.
• Verify, validate data before and after migration/Conversion according to teh requirements.
• Modified existing Code according to teh requirements.
• Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks to performed for better performance Used different joins, sub-query, nested query in SQL query, for reporting purpose.
• Wrote database triggers for automatic updating teh tables and views.
• Troubleshoot and debug system and/or data errors.
• Tuned SQL queries using Tkprof utility to improve performance.
• Involved in Testing, Integration System test, Implementation.

Environment: ODS, Oracle 10g, SQL Navigator, UNIX, PeopleSoft, Abinitio, Sql Loader

Confidential

Oracle PL SQL Developer

Responsibilities:

• Created and modified data migration scripts/Pull Scripts.
• Loading data from flat files into Oracle 9i database using SQL*loader and Unix script
• Verify, validate data using SQL queries
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Triggers and Packages.
• Write UNIX scripts to upload data from text files (and control files) to teh database using sqlloader.
• Create detailed documentation for user approval.
• Modified existing Code according to teh requirements.
• Add new functionality for fetching multiple records (for different dates) based on business logic.
• Involved in Testing, Integration System test, Implementation.
• Provide timely response to all client requests, including on-call support outside Normal business hours.
• Understand teh overall Confidential and Oracle RMS application.
• Key off-shore personal for noledge transfer, interface for Client team for RMS application.

Environment: Oracle RMS, Oracle Retek API, Message Queue, Oracle 10g/9i,TOAD, Unix, Pro*C,SMS ticketing tool