SUMMARY

• IT experience 8 year in Data modeling, ETL design, development, programing, Testing, Troubleshooting, error handling in oracle technologies.
• Expertise inadvancedSQL, PL/SQL, Store procedure, Functions, Packages, DB triggers, Indexes,Forms & Reports for both development &customization.
• Experienced in Implementing and Tuning SQL statements and Procedures for enhancing the load performance in various schemas across database.
• Involved in the design of Data - warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• ExpertiseinDBA activities such as performance tuning, backup and RecoveryandUNIXoperating system andworked in Agile Environment.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Physical, Logical design, Resource Planning, Code Development.
• Developed UNIX shell scripts to automate repetitive database processes, regularbackup, instance start/shutdown and migrating data into tables.
• Hands on experience in modeling Business Requirement into Technical Requirement, Software Requirements and Technical documentations.
• Expertise in oracle database creation, table space management, creating database links, schemas profiles, roles, managing control, redo log, data files.
• Hands on experience in using tools such as Microsoft Office pack, HP Quality Center (QC), TOAD, SQL* Loader, SQL Navigator and SQL*plus,Site Minder V6.x, change management tool such as Bridge Clarify.
• Involved in data migration from database 10g to 11gusing Golden gate&Server maintenance activities like health check, archiving/cleaning log files/crash.
• Good experience in various Industry verticals like Heath Care, Finance, Insurance and telecommunication with appropriate oracle implementations.
• Experience in handling new project single handed thereby understanding the client requirements and putting them into practice without any escalations.
• Strong Team building and mentoring skills and excellent team lead capability and strong Logical and Analytical Reasoning, excellent Management, Excellent communication with good listening, Presentation and Intrapersonal.
• Motivated to take independent responsibility as well as to contribute to be a productive team member.

TECHNICAL SKILLS

Databases: Oracle 9i,10g, 11g, SQL Server 2005, MS Access

Operating system: Microsoft Windows 2000, 2003, 2007, XP, Solaris 9,10, Red Hat Linux, Sun OS, DOS, Unix, Perl

Languages: SQL, PL/SQL, Shell Scripts, C++, asp.net, Java, J2EE.

Internet Tech: HTML, DHTML, Java Script, and Xml

Oracle Tools: TOAD 12.0, SQL Developer 3.0, SQL*Plus, SQL*Loader

Reporting tools: Oracle reports 10g, forms 10g

Testing: Mercury Quality Center 9.2

Miscellaneous: Putty, HP QC, Bridge Clarify, SOAP UI, Site Minder V6.x, Microsoft Office pack, MS Visio 07, TOMCAT

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior Programmer / Analyst

Responsibilities:

• Worked from Analysis, Technical Requirements, Detailed Design, Development, Testing, Documentation and Production Support.
• Developed back end interfaces using PL/SQL packages, procedures, functions, Collections, Object types and Triggers and Indexes as per requirement.
• Work with the Business Analysts for requirements gathering, business analysis, deploymentation plan and testing and project coordinating.
• Oracle Golden gate is zero-downtimemigrations or upgrade to oracle database and application, used pump, trial, route for the data migration.
• Worked on golden gate installation setup till deployment in the project.
• Responsible for migrating the folders or mappings/workflows from development to Test and from Test to production environment.
• Developed workflow tasks like reusable Email, Event wait, Command, Decision.
• Designed and Developed User Interface for customer analytics project using Form Builder deployed to the client server and complied them.
• Worked on Performance tuning of SQL and PL/SQL that had performance issue.
• Developed &maintained scripts monitoring, troubleshooting, admintn of databases, utilized TOAD for developing all back end database interfaces and objects.
• Developed User interface for customer analytics projects using Form builder, deployed to client server and complied them as per the business requirement.
• Developed Perl,UNIX shell scripts to automate repetitive database processes, regularbackup, instance start/shutdown and migrating data into tables.
• Worked onSQL*Loader, Import/ Export, UTL FILE, DBMS XMLQUERY, DBMS PIPE and other oracle built in packages objects.
• Responsible for creating jobs according to data dependencies and source systems.
• Experience in using Exception handling to handle PL/SQL errors.
• Experience in java J2EE technologies like servlets, struts,framework like hibernate.
• Developed claims reports that would produce Excel output for the users and Generated claims reports weekly, monthly, and yearly as per requirement.
• Performed dimensional modeling and have very good understanding of Data Warehouse techniques and their use in the project as per requirement.
• Extensively involved in designing logical and physical of databases and created and managed database users, login ids and security as part of DBA.
• Developed PL/SQL functions to facilitate business functions and calculations and did require for modifications to the existing ones.
• Worked under tight schedule for successful development and implementation.
• Monitored performance and changed performance requirement through application of database tuning and performance optimization techniques.

Environment: Oracle 11g, TOAD 12, SQL Developer, Reports 10g, forms 10g, java, SQL *Loader, UNIX HP UX, Windows 7, ETL.

Confidential, CA

Senior Oracle Programmer

Responsibilities:

• Created Database objects including Tables, Triggers, Views, Stored Procedure, Data Modeling, Indexes and Rule as per requirement in the project.
• Set database access privileges for different Users and User Groups as DBA.
• Created jobs data dependencies and source systems and monitor job history for maximum availability of data and to ensure consistency of the database.
• Worked on data migration of databasefrom10g to 11g using oracle golden gate.
• Created architectures of data warehouse and data flow for solving reporting problem for head office, top management, financial.
• Worked on oracle golden gate installation to deployment for data migration.
• Designed and Developed User Interface for customer analytics project using Form Builderdeployed to the client server and complied them.
• Created programs to transform data from Legacy system into oracledatabase.
• Worked on Reports to give parallel comparison of different fiscal years.
• Developed complex SQL queries, triggers for building reports using Form, form letter and mailinglabel report styles.
• Work with theBusiness Analysts for requirements gathering, business analysis, deploymentation plan and testing and project coordinating.
• Hands on experienced in SQL Profiler for getting the trace activity for the various Stored Procedures and used Indexes Tuning wizard for performance betterment.
• Expertise in Job, Scheduling batch, alert, and E-mail notification setting.
• Hands on experience in monitoring SQL server log files, tuning and optimizing queries and indexes and wroteUNIX shell scripts to run SQL scripts daily.
• Experience in using Exception handling to handle PL/SQL errors.
• Developed PL/SQL functions to facilitate business functions and calculations and did require for modifications to the existing ones.
• Worked under tight schedule for successful development and implementation.
• Monitored performance and changed performance requirement through application of database tuning and performance optimization techniques.
• Worked under tight schedule for successful development and implementation.
• Hands on experience in monitoring the Health of database servers for optimal performance and trace error/events logs for database errors.

Environment: Oracle 11g/10g, java, UNIX, PL/SQL, SQL*PLUS, Forms, Reports, SQL, TOAD, C, SQL*Loader, data warehouse.

Confidential, Philadelphia, PA

Oracle Programmer

Responsibilities:

• Worked from Analysis, Technical Requirements, Detailed Design, Development, Testing, Documentation and Production Support.
• Developed back end interfaces using PL/SQL packages, procedures, functions, Collections, Object types and Triggers.
• Work with the Business Analysts for requirements gathering, business analysis, and testing and project coordinating.
• Developed claims reports that would produce Excel output for the users. Generated claims reports weekly, monthly, and yearly.
• Experience in java J2EE technologies like servlets, struts,framework like hibernate.
• Developed PL/SQL functions to facilitate business functions and calculations and did require for modifications to the existing ones.
• Worked under tight schedule for successful development and implementation.
• Monitored performance and changed performance requirement through application of database tuning and performance optimization techniques.
• Extensively involved in designing logical and physical of databases and created and managed database users, login ids and security.
• Designed and Developed User Interface for customer analytics project using Form Builderdeployed to the client server and complied them as per the business requirements.
• Designed and developed user interfaces using Oracle Forms.
• Experience in using Exception handling to handle PL/SQL errors.
• Worked under tight schedule for successful development and implementation.
• Monitored performance and changed performance requirement through application of database tuning and performance optimization techniques.
• Hands on experience in monitoring the Health of database servers for optimal performance and trace error/events logs for database errors.
• Worked under tight schedule for successful development and implementation.

Environment: Oracle 10g, java, TOAD 12, SQL Developer, SQL *Loader, putty, Bridge Clarify, Windows 7.

Confidential

Oracle Programmer

Responsibilities:

• Created Database objects including Tables, Triggers, Views, Stored Procedure, Data Modeling, Indexes and Ruleas per the requirement in project.
• Set database access privileges for different Users and User Groups.
• Created jobs and monitor job history for maximum availability of data and to ensure consistency of the database.
• Utilized TOAD for developing all back end database interfaces and objects.
• Developed UNIX shell scripts to automate repetitive database processes, regular backup, instance start/shutdown and migrate data into tables.
• Designed and Developed User Interface for customer analytics project using Form Builderdeployed to the client server and complied them as per the business requirements.
• Designed and developed user interfaces using Oracle Forms.
• Created programs to transform data from Legacy system into oracle database.
• Worked on Reports to give parallel comparison of different fiscal years.
• Responsible for creating jobs according to the data dependencies & source systems.
• Experience in using Exception handling to handle PL/SQL errors.
• Hands on experienced in SQL Profiler for getting the trace activity for the various Stored Procedures and used Indexes Tuning wizard for performance betterment.
• Wrote UNIX shell scripts to run SQL scripts daily, and Enforced database integrity using primary keys and foreign keys, and Created DDL scripts for implementing data modeling changes as per requirement in project.
• Expertise in Job, Scheduling batch, alert, and E-mail notification setting.
• Expertise in monitoring SQL server log files, tuning & optimizing queries and indexes.
• Developed claims reports that would produce Excel output for the users. Generated claims reports weekly, monthly, and yearly.
• Worked under tight schedule for successful development and implementation
• Hands on experience in monitoring the Health of database servers for optimal performance and trace error/events logs for database errors.

Environment: Oracle 10g, TOAD, shell scripting, forms, reports, SQL Developer, SQL *Loader, Windows.

Confidential

Oracle Programmer

Responsibilities:

• Worked from Analysis, Technical Requirements, Detailed Design, Development, Testing, Documentation and Production Support.
• Developed back end interfaces using PL/SQL packages, procedures, functions, Collections, Object types and Triggers.
• Work with the Business Analysts for requirements gathering, business analysis, and testing and project coordinating.
• Developed claims reports that would produce Excel output for the users. Generated claims reports weekly, monthly, and yearly.
• Experience in using Exception handling to handle PL/SQL errors.
• Enforced database integrityusing primary keys and foreign keys.
• Created DDL scripts for implementing data modeling changesas per requirement.
• Hands on experienced in SQL Profiler for getting the trace activity for the various Stored Procedures and used Indexes Tuning wizard for performance betterment.
• Wrote UNIX shell scripts to run SQL scripts daily.
• Expertise in Job, Scheduling batch, alert, and E-mail notification setting.
• Worked under tight schedule for successful development and implementation.
• Monitored performance and changed performance requirement through application of database tuning and performance optimization techniques.

Environment: Oracle 9i, java, TOAD, SQL Developer, SQL *Loader, Windows.