Data Modeler Resume
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
