SUMMARY:

• Over 8 years of IT experience in Data modeling, ETL design, development, programing, Testing, Troubleshooting, error handling in oracle technologies.
• Expertise in SQL, PL/SQL, Store procedure, Functions, Packages, DB triggers, Indexes, Forms & Reports for both development & customization as per client.
• 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.
• Expertise in DBA activities such as performance tuning, backup and Recovery and UNIX operating system and worked 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, regular backup, 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.
• Expertise in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Good experience in various Industry verticals like Heath Care, Finance, Insurance and telecommunication with appropriate oracle implementations.
• 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.

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

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.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Worked on ASP.NET validation controls for side validation.
• Worked on Performance tuning of SQL and PL/SQL that had performance issue.
• Hands on experience in documented Informatica mappings in Excel spread sheet.
• 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 UNIX shell scripts to automate repetitive database processes, regular backup, instance start/shutdown and migrating data into tables.
• Worked on SQL*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.
• 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, Informatica tool, Reports 10g, forms 10g, SQL *Loader, UNIX HP UX, ASP.NET, Windows 7.

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 ASP.NET validation controls for side validation.
• Worked on data migration of oracle database from 10g to 11g using oracle golden gate.
• Implemented Informatica recommendations, methodologies and best practices
• Oracle Golden gate is zero-downtime migrations or upgrade to oracle database and application, used pump, trial, route for the data migration.
• Worked on oracle golden gate installation to deployment for data migration.
• Created programs to transform data from Legacy system into oracle database.
• Worked on Reports to give parallel comparison of different fiscal years.
• Work with the Business 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 wrote UNIX 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,Informatica tool, java, UNIX, PL/SQL, SQL*PLUS, Forms, Reports, SQL, TOAD, ASP.NET, C, SQL*Loader.

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.
• 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.
• 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 Rule as 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.
• 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

Intern + 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.
• Extensively involved in designing logical and physical of databases and created and managed database users, login ids and security.
• Experience in using Exception handling to handle PL/SQL errors.
• Enforced database integrity using primary keys and foreign keys.
• Created DDL scripts for implementing data modeling changes as 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.
• Expertise working with production and 24x7 on calls environments.

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