Pl/sql Developer Resume
Edison, NJ
CORE COMPETENCIES AREA:
- Data analyst (SQL Queries, data reporting, advanced Excel, data modelling)
- Database programming (PL/SQL, stored procedure, triggers, cursors)
COMPETENCIES:
Systems: Windows, UNIX
Databases: Oracle 11g client, SQL developer, MongoDB
Programming: SQL, PL/SQL, Confidential - SQL, HTML, XML, Java8, Struts
Tools: Visual paradigms, eclipse, Toad, Talend 5.4, Oracle SQL developer
Skills: Data Analysis, Data integration, database modelling, Data migration, data warehousing, database programming, shell scripting
Other: Data warehousing, Documenting and commenting, BPM, advanced Excel
PROFESSIONAL EXPERIENCE:
Confidential, Edison, NJ
PL/SQL Developer
Responsibilities:
- SQL queries and test them before delivering to the software developers,
- Creating reports
- PL/SQL programming (Cursors, triggers, stored procedures, functions, Exceptions, records )
- UI modifications
Tools: Eclipse (Java8), Struts2 Framework, Toad, Oracle 11g client, RAD, Oracle SQL developer
Confidential
Oracle PL/SQL Developer
Responsibilities:
- ER diagram by using visual paradigm tool
- Normalization of tables
- Creating tables by using Toad tool DDL(data definition Language) part of SQL
- Import data from into tables by using flat files (Excel)
- Manipulate data by using queries DML (data Manipulation Language) that is part of SQL
- SDLC(Software Development life Cycle)
- Creating web services( we use C#)
- Shell scripting
TOOLS: USED: Visual studio 10, Oracle Client 11G, Easyphp 2.0b1, Filezila, Toad 11.6, Visual paradigm, MS office
Confidential
Oracle PL/SQL Developer
Responsibilities:
- SQL Queries (DDL,DML,DCL)
- Project budget
- Customer requirement
- SDLC
- PL/SQL
- Administration task
- Raking servers
TOOLS: USED: Visual studio 10, Oracle Client 11G, Toad 11.6, Visual paradigm, Microsoft project 2010.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Data modeling( Snowflake schema, star schema)
- ETL
- SDLC
- Reporting (Qlikview tool)
Tools: used: Oracle Client 11G, Toad 11.6, Talend 5.4, MS Project, SAS or SPSS, Toad for Oracle.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Data modeling
- Testing
- Debugging
- SQL Queries
- PL/SQL
- Shell scripting
TOOLS: USED: Toad9.6, Oracle 10g, UNIX
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Data modeling
- SQL Queries
- Creating the database in MYSQL by using Data Definition Language
- Creating user Interfaces by using Dreamweaver
- Connecting forms to the database
- Administrate the Database (create new users, give privileges, etc.)
- Documenting application interfaces
Tools: used: MySQL, PHP, Dreamweaver, UNIX, Easyphp.