We provide IT Staff Augmentation Services!

Senior Oracle Developer And Data Analyst Resume

Houston, TX

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

Hire Now