SUMMARY:

• Over 12 years of software development experience in data analysis, database administrator and database development in Oracle 12c, 11g and Oracle 10g - SQL and PL/SQL.
• Over 10 years of expertise in PL/SQL developing packages, stored procedures, functions and triggers, have extensively used collections, dynamic queries, subroutines and cursors.
• Proficient in tools like SQL*Plus, SQL*Loader, SQL Developer, PL/SQL Developer and TOAD.
• 3 years of development and administrator experience in ETL tools like Informatica Power Center, Data Quality and Address Doctor.
• Good understanding of data warehouse concepts, techniques and methodologies.
• 4 Years of experience in scrum/agile projects.
• 1 Year of development experience in Tableau
• 1 year of experience in MS-SQL Server 2000.
• Over 5 years of experience in UNIX Sun Solaris OS and Red Hat Linux.
• Experience in UNIX shell scripting.
• Familiar with ETL Tools like MS SSIS, FME and SAS.
• Development expertise primarily on high volume database refreshing and maintaining activity.
• Currently playing the role of Senior Oracle Developer Lead.
• Datastax certifications on Cassandra Architecture and CQL(No Sql).
• 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, Reference 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.
• Working with the XML files.
• 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 12c, Oracle 11g, Oracle 10g, Oracle 9i, MS-SQL Server 2000

Languages: PL-SQL, No Sql, C, Pro 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, Rally, Jira

Familiar With: Unix shell scripts, HTML, JavaScript, XML

Tools: SQL*Loader, Toad, PL/SQL developer, SQL Developer, NetBeans 5.5, SQL Modular

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Oracle Developer and Data Analyst

Responsibilities:

• Agile methodologies for this project involved in planning, backlog grooming, and daily stand-ups, retrospective and showcase sessions.
• Two weeks iteration (sprint) to complete design, development and testing.
• Closely work with product owner, business analyst and system architect.
• 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.
• Analyze the communications, informational and programing requirements of clients; planning, developing and designing business programs.
• Interact with business analysts, subject matter experts, front end developer team, Reporting team, DBA team, testing team and developing database related objects for PT-DMS.
• Involve in Logical and physical data modeling and database design.
• Create database standard for the project and code review.
• Manage more than 10 server instances and involved in code and data migration process, Work in different environments like development, test and production.
• Create application’s data access layer with packages, store procedures, functions and triggers.
• Create new tables, integrity constraints (Primary Key/Foreign Key), Indexes, Sequences, Views MVs and Oracle Collections. Created Scheduled jobs with DBMS JOB.
• Carry out SQL code tuning, Query Optimization and database performance tuning, statistics gathering of tables and schema.
• Work with BO and Tableau developer for data analytics.

Environment: Oracle 12c, C#, .Net, UNIX, Rally, Toad, PL/SQL Developer, Informatica PC, SQL*PLUS, SQL Modular, Tableau 10.0, Scrum, XML

Confidential, Denver, CO

Senior Oracle Developer Lead

Responsibilities:

• Agile methodologies for this project, involved in planning, backlog grooming, daily stand-ups and showcase sessions.
• Three weeks iteration (sprint) to complete design, development and testing.
• Closely work with product owner, business analyst and system architect.
• 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, Informatica PC, SQL*PLUS, SQL Modular, MS-SQL Server 2000, Autosys, Scrum, Jira, Harvest, XML

Confidential, New York City

PL/SQL Developer Lead

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, SQL Modular, MS-SQL Server 2000, Informatica Power Center, Scrum, TFS

Confidential, Houston

PL/SQL Developer Lead

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 database 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, SQL Modular, Informatica Power Center 9.5.1, Informatica DQS, C and Pro C, TFS, Control M

Confidential, Houston

Lead PL/SQL Developer

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.
• Performance tuning of PL/SQL code.
• 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, TFS, Control M

Confidential, Houston

Senior PL/SQL Developer

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.
• PL/SQL code review and performance tuning.
• 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, VSS, MS DOS

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, SVN, MS DOS