We provide IT Staff Augmentation Services!

Data Modeler Resume

5.00/5 (Submit Your Rating)

New, JerseY

PROFESSIONAL SUMMARY:

  • Multifaceted professional with 11.5 years of experience in Information Technology
  • Experience in Oracle PLSQL Development & Data Modeling.
  • Well versed in ORACLE SQL Developer, TOAD and PLSQL Developer.
  • Familiar with all stages of the Software Development Life Cycle process.
  • Knowledge of Core Java, VB.Net and C#.Net
  • Hands - on experience in Oracle including database design, development of triggers, subprograms, packages, maintaining data integrity with constraints by using PLSQL and SQL.
  • Possess excellent communication, analytical, problem solving and interpersonal skills.

TECHNICAL SKILLS:

Operating System: Windows 98/00/XP, Windows 07/08/10

RDBMS: Oracle 9i/10g/11g with SQL and PLSQL

Coding Tools: TOAD, PLSQL Developer and ORACLE SQL Developer

Languages Known: Core Java, VB.Net and C#.Net

Data Modeling Tools: Erwin, Toad

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Data Modeler

Responsibilities:

  • To develop data model describing data elements.
  • Create and/or develop Database Access Layer (DAL) objects.
  • Create performance tuning of DAL objects.
  • Create database objects - table, indexes, partitions, sequences, procedures and functions.
  • Involved in developing packages, procedures and functions for implementing business logic and automation of all manual reports as per BRD's
  • Design logical & physical data model.
  • Develop migration scripts and data purging.
  • Performance tuning of DB objects and queries.
  • Create database script package for each build/patch/release.
  • Deploy scripts in non-prod environments.
  • Prepare Hermes package for prod deployments.
  • Coordinate with DBAs for DDL deployment & static schema creation.

Environment: Oracle 11g and Oracle PL/SQL, BO, MS.Net, Java/J2EE

Confidential

Project Lead

Responsibilities:

  • Involved in developing PL/SQL packages, procedures and functions for implementing automation of all manual reports as per BRD's
  • Creating or modifying database objects to add new functionality and to optimize performance
  • Creating report templates and configuring it in FDW

Environment: Oracle 11g and Oracle PL/SQL

Confidential

Onsite Lead

Responsibilities:

  • Led Team
  • Involved in designing and restructuring database
  • Developed PL/SQL packages, procedures, functions for implementing business logic as per client specification

Environment: Oracle 11g and Oracle PL/SQL

Confidential

Senior Developer

Responsibilities:

  • Involved in designing database
  • Developed PL/SQL packages, procedures, functions for implementing business logic as per client specification

Environment: Oracle 11g and Oracle PL/SQL

Confidential

Developer/Module Lead

Responsibilities:

  • Developed PL/SQL packages, procedures, functions for implementing business logic as per Client specification

Environment: Oracle 9i, Oracle PL/SQL and Geneva

Confidential, Rhode Island

Developer

Responsibilities:

  • Developed customized database routines specific for database attribute population, data validation and verification
  • Developed the quality assurance checks involving data entry QA check and database quality checks
  • Worked on creation and applications
  • Developed database objects such as procedures, functions and triggers

Environment: Oracle 10g and Oracle PL/SQL

Confidential

Developer

Responsibilities:

  • Developed customized database routines specific for database attribute population, data validation and verification
  • Developed the quality assurance checks involving data entry QA check and database quality checks
  • Worked on creation and applications
  • Developed database objects such as procedures, functions and triggers

Environment: Oracle 10g and Oracle PL/SQL

Confidential

Developer

Responsibilities:

  • Developed customized database routines for specific database attribute population, data validation and verification
  • Worked with Developer department in developing and maintaining the routines and procedures

Environment: Oracle 10g and Oracle PL/SQL

Confidential

Developer

Responsibilities:

  • Developed customized Database routines specific for database attribute population, data validation and verification
  • Developed the Quality assurance checks involving data entry QA check, Database Quality checks and legacy QC routine

Environment: Oracle 9i and Oracle PL/SQL

Confidential

Developer

Responsibilities:

  • Developed customized database routines specific for database attribute population, data validation and verification
  • Developed the quality assurance checks involving data entry QA checks and DBQC checks
  • Worked on creation and applications
  • Developed database objects such as procedures, functions and triggers

Environment: Oracle 9i and Oracle PL/SQL

We'd love your feedback!