SUMMARY

• 9+ years of software development experience in database administrator and database development in Oracle 11g and Oracle 10g - SQL and PL/SQL.
• Over 8 years of expertise in PL/SQL developing packages, stored procedures, functions and triggers, have extensively used collections, dynamic queries and cursors.
• Proficient in tools like SQL*Plus, SQL*Loader, PL/SQL Developer and TOAD.
• 2 years of development and administrator experience in ETL tools like Informatica Power Center, Data Quality and Address Doctor.
• 2 years of experience in MS-SQL Server 2000.
• Over 7 years of experience in UNIX Sun Solaris OS and Red Hat Linux.
• Experience in UNIX shell scripting.
• Familiar with ETL Tools like FME and SAS.
• Development expertise primarily on high volume database refreshing and maintaining activity.
• Currently playing the role of Database Administrator and ETL expert.
• Extensive work experience in complete software development life cycle (SDLC) including business interaction, requirement analysis, software architecture, design, development, testing and documentation phases in finance and legal domain.
• Well versed with client server architecture, web application development on RDBMS.
• Proficient in creating / managing database objects like Tables, Views, Indexes, Synonyms, Procedures, Triggers, Functions, Materialized Views and Sequences.
• Worked extensively on Packages, Stored Procedures, User Defined Functions, Analytical Functions, Exception Handling, Cursor, Cursor, Collections and Dynamic SQL.
• Good experience with oracle built in utilities like EXPLAIN PLAN, SQL trace and TKPROF, SQL*Plus Autotrace and Optimizer hints which are useful in performance tuning.
• Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets.
• Good knowledge of Unix, Linux, shell scripting and crontab job scheduling.
• Very Good Experience in Data Modeling of OLAP and OLTP database.
• Strong Communication, Interpersonal, problem solving, analytical reasoning skills and an Excellent Team Player.
• Expertise in working with distributed project teams across geographies.

TECHNICAL SKILLS

Databases: Oracle 11g, Oracle 10g, Oracle 9i, MS-SQL Server 2000

Languages: C, C++ and Java

ETL Tools: Informatica Power Center, Informatica DQS, Address Doctor

Platforms: Linux Red Hat, UNIX Sun Solaris, MS-DOS, Windows 98/ NT /2000/XP/Vista/7/8

GUI: Visual Source Safe, QVT - Term, TFS

Familiar With: Unix shell scripts, HTML, JavaScript

Tools: SQL*Loader, PL/SQL developer, Lotus Notes, NetBeans 5.5

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior Oracle Lead Developer

Responsibilities:

• Involved in SDLC gathering requirements from product owners. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Involved in RDBMS design and developed ER-diagrams. Participated in code walkthroughs and review sessions with the development team.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Developed stored procedures, functions, packages triggers to facilitate consistent data entry into the database.
• Written Package and Stored Procedures for common utilities.
• Developed database Triggers for audit and validation purpose. Writing validation packages using PL/SQL package.
• Code Review of other team member and developed Installation scripts for all the deliverables.
• Involved in performance tuning on SQL and Pl/SQL using AUTO TRACE, EXPLAIN PLAN utilities.
• Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.

Environment: Oracle 11g, Java, UNIX, TFS, Toad, PL/SQL, SQL*PLUS, MS-SQL Server 2000

Confidential, New York

Project Lead Analyst

Responsibilities:

• Involved in SDLC gathering requirements from business users. Participated in the system architecture and design, which included creating tables, views, synonyms.
• Responsible to build the Informatica application environments on Linux Red Hat for development, Production Test and Production systems.
• Responsible for Informatica Power Center tool and DQS installation and configuration, Acted as system Administrator for managing services and users.
• Subject Matter Expert for all the 105 databases.
• Created Oracle coding standard and naming conversion document. Code Review of other team member Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Involved in creating mapping and debugging Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, lookups, Stored Procedures and creating PL/SQL procedures, functions, Filters, Sequence, Router, Union and Update Strategy.
• Involved in design and development of Business Object Universe and Standard Reports.
• Involved in production support activities.
• Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.

Environment: Oracle 11g, Informatica Power Center, Linux, SQL, PL/SQL, SQL*PLUS, SQL Developer, Informatica Power Center 9.5.1, Informatica DQS.

Confidential, New York

Project Lead Analyst

Responsibilities:

• Involved in SDLC gathering requirements from business users. Participated in the system architecture and design, which included creating tables, views, synonyms.
• Responsible to build the Informatica application environments on Linux Red Hat for development, Production Test and Production systems.
• Responsible for Informatica Power Center tool and DQS installation and configuration, Acted as system Administrator for managing services and users.
• Subject Matter Expert for all the 105 databases.
• Created Oracle coding standard and naming conversion document. Code Review of other team member Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Involved in creating mapping and debugging Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, lookups, Stored Procedures and creating PL/SQL procedures, functions, Filters, Sequence, Router, Union and Update Strategy.
• Involved in design and development of Business Object Universe and Standard Reports.
• Involved in production support activities.
• Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.

Environment: Oracle 11g, Informatica Power Center, Linux, SQL, PL/SQL, SQL*PLUS, SQL Developer, Informatica Power Center 9.5.1, Informatica DQS.

Confidential, Houston

Oracle Consultant

Responsibilities:

• Involved in SDLC gathering requirements from business users. Participated in the system architecture and design, which included creating tables, views, synonyms.
• Developed stored procedures, functions, packages triggers to facilitate consistent data entry into the database.
• C and Java Program coding for reformatting (text and xml files) state data, C and Pro C Programs execution on Sun Solaris UNIX Environment.
• Writing SQL’s (insert, update, delete, create table and functions) pertaining to requirement.
• Writing SQL Loader scripts for loading raw data.
• UNIX Macro creation and execution.
• Verification and validation of uploaded data.
• Test case execution on Live, PT and as well as on Production Data also.

Environment: Sun Solaris, Oracle 10g, SQL*loader, PL/SQL Developer (5.1), Turbo C

Confidential

PL/SQL Developer

Responsibilities:

• Writing SQL’s (insert, update, delete, create table and functions) pertaining to requirement.
• Writing SQL Loader scripts for loading raw data.
• C Program coding for reformatting state data.
• C and Pro C Programs execution on UNIX Environment.
• Verification and validation of uploaded data.
• Test case execution on live and as well as on Production Data also.

Environment: Oracle 9i, SQL*loader, PL/SQL Developer(5.1), Turbo C