EXPERIENCE SUMMARY

• Dynamic and techno-savvy Oracle Professional having over 12 years of international experience with expertise in Several Full Life Cycle Implementations in Oracle Applications/Database/ Forms/Reports, Project Management, Functional Consultancy, Solution Architecture, Transition Transformation and experience in implementation engagements.
• Proficient in design and development in relational database development, production support and maintenance of applications using SQL, PL/SQL, Oracle Database 6.x, 7.x, 8.i, 9i, 10g, 11g Developer 2000, Forms 3.x, 4.5, 6i, 9i , Discoverer 10g, Designer 2000, Shell Scripting, PRO C, SQL Loader,
• Formed, managed and mentored implementation teams with project delivery focus. Good cross-team management experience spanning across geographies.
• Worked with Fortune 500 companies like Verizon Wireless, AT T, Qwest Telecom, Bank of America, Wells Fargo, CISCO Systems, Lucent Technologies Inc., Wheeling Pittsburgh Steel etc.
• Extensive experience in replication using Materialized view, Advanced queues, Stream
• Ability to manage multiple complex projects under tight deadlines. Possess excellent working relationships with top executives, business analysts and end users.
• Good combination of technical and communication skills. Creative problem solver, able to think logically and pay close attention to detail. Proficient at gathering user requirements and customizing database solutions as per need.
• Acknowledged trouble shooter and a key decision maker with well-honed skill set in collaborating with project teams, interfacing with clients and deploying technology to build successful solutions for Clients.

TECHNICAL SUMMARY

• HARDWARE PC, SUN SOLARIS
• OPERATING SYSTEM WINDOWS 7, UNIX, Linux RHEL4, RHEL5
• LANGUAGES C, C , Pro C, PERL, Java.
• DATABASE S ORACLE 11g, 10g, 9.x, 7.x, 8.x, 8.0i, MS-ACCESS, FOXPRO
• Data ware housing Tools, Informatica, Oracle Ware house builder 9i, 10g, 11.g
• FRONT-END DEVELOPER 2000 Forms 4.5, Reports 2.5 , DEVELOPER 6.i, Forms 6.i, Reports 6.i , Jdeveloper 9, Developer Forms 4.5 6.i,9i and Reports 4.5 6.i,9i, Data Replication, Streams, Advanced Queues, Materialized Views.
• CASE TOOL S DESIGNER 2000
• Data Model Ervin, Toad
• OTHERS UNIX SHELL SCRIPTING, HTML SCRIPTING, XML, CRYSTAL REPORTS 10, PRO

Confidential

PROJECT EXPERIENCE

Confidential

Role: Sr. Oracle developer

Confidential Service is a customer facing web site. The goal of the web site is provide customer a powerful tool to customize and configure networking products according their company specific requirements. The web site provides real time configuration options and customer has an ability to customize almost any product available in Cisco System.

Responsibilities:

• Designed and Developed Packages for extraction transformation and loading of data from
• Performance management of data extraction and loading processes
• Designed and developed shell scripts to validate input files and load the data into Oracle tables.
• Lead the development of sql loader scripts for data extraction from data feeds to oracle database
• Identifying the performance bottlenecks , query rewriting for better performance
• Implemented table partitions for huge tables for Performance
• Usage of stats pack to take a snap shot on heavy load time and identifying instance problems using the stats pack report.
• Report collection using the data dictionary tables for Performance monitoring.
• Developed Data modes/ER Diagrams using Data modeling Tools Ervin
• Mentoring junior database developers in writing optimal and standard code

Environment: Oracle 11g, Toad, Sql Loader, Sun Solaris UNIX, Shell scripting

Confidential

Role: Sr. Oracle developer

This project defines a conversion process and tools to convert Transfer Schedules into OPS SOR. All transfer schedules are passed through HPS. Inter FI files are directly sent to OPS and PayDirt for offus account schedule conversion.The conversion files will be staged, validated and loaded into OPS following this conversion process. This process extends the current HPS to OPS conversion, and adds the following features It is restart able, state is added to staging table records, allowing the module to know where to start. It is reusable and easily extensible. The process can be followed for any file migration into OPS by following set of rules. Allows parallel migrations.

Responsibilities:

• Designed and Developed Packages for extraction transformation and loading of data from
• Performance management of data extraction and loading processes
• Designed and developed shell scripts to validate input files and load the data into Oracle tables.
• Lead the development of sql loader scripts for data extraction from data feeds to oracle database
• Identifying the performance bottlenecks , query rewriting for better performance
• Implemented table partitions for huge tables for Performance
• Usage of stats pack to take a snap shot on heavy load time and identifying instance problems using the stats pack report.
• Report collection using the data dictionary tables for Performance monitoring.
• Developed Data modes/ER Diagrams using Data modeling Tools Ervin
• Mentoring junior database developers in writing optimal and standard code

Environment: Oracle 11g, Toad, Sql Loader, Sun Solaris UNIX, Shell scripting Confidential Role: Sr. Oracle Developer/Technical Lead

Environment: Oracle 11g/9.2, Toad, Advanced Queues, XML, Sun Solaris UNIX, Shell scripting Confidential Role: Sr. Oracle Developer

Environment: Oracle 10g/9.2, Pl/SQL, Advanced Queues, XML, Sun Solaris UNIX, Shell scripting, Pl/Sql Developer