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.
• Strong work experience in Oracle Database (11g/10g/9i/8i). SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes - B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities.
• 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 I/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.

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 the 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.
• 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 the onsite and offshore teams.
• Preparing RCA, TDD, FDD documents.
• Providing the on-call support 24*7 to resolve RTS issues (Ready to Serve).

Environment: Oracle 10g/11g, SQL Developer, Quality Center, SVN, Informatica, Cognos

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 the tables and views.
• Create User Schemas, tables, indexes, sequences, views, directories.
• Verify, validate data using SQL queries.
• Modified existing Code according to the 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 forecasts from multiple demand streams: Orders, shipments, POS and Customers
• DC’s withdrawals.
• Select from multiple forecasting models and optimally tunes parameters.
• Support flexible hierarchies across products, locations and channels for reviewing/reconciling
• Forecasts across multiple levels.
• Provide attribute based forecast and review management.
• Manage product lifecycle from new product introductions through phase-out.
• Decompose baseline demand to improve forecast and manage promotions.
• Develop multi-tier, time phased order, shipment, receipt and inventory plans.
• Optimize constrained supply allocations for deployment network-wide.
• Support multiple safety stock strategies and date sensitive items.
• Build feasible, optimized and responsive production plans.
• Optimize materials, resources, changeovers and capacities across multistage/
• Site manufacturing, distribution and supplier networks driven by prioritized customer demand.
• Develop Stored Procedures, Functions, Views, Cursors, Packages and Exceptions.
• Configure the server with product installation and batch set up.
• Troubleshoot the 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 the client requirements.
• Scrutinize SQL statements using “Explain Plan” to improve the performance.
• Preparing Functional specification documents.
• Understand the technical & functional specifications designing, developing, Testing, troubleshooting and debugging of the applications.
• Monitor the scheduled jobs using AS400.
• Handle SCPO and EP tickets as per the 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, Chicago (IL)

Senior Oracle PL SQL Developer

Responsibilities:

• Verify, validate data using SQL queries and create text according to the requirements.
• Modified existing Code according to the requirements.
• Load the created text in to the 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 the client requirements.

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

Confidential

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 the requirements.
• Involved in Testing, Integration System test, Implementation.
• Involved in development of SVI reports and share it with the 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 the 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 the data.
• Verify, validate data before and after migration/Conversion according to the requirements.
• Modified existing Code according to the 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 the 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 the database using sqlloader.
• Create detailed documentation for user approval.
• Modified existing Code according to the 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 the overall Confidential and Oracle RMS application.
• Key off-shore personal for knowledge 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