Oracle PL/SQL Developer Resume

SUMMARY

More than 15 years of experience on Information Technology;
Extensive knowledge and experience in the application of processes and tools in the area of agile software development, product management and marketing;
Ability to effectively translate user needs and requirements into relevant software solutions with a sound sense of quality for design and usability
Delivering significant business results, i.e. increase of turnover, traffic, user satisfaction and sustainable development
Strong interdisciplinary thinker and creative problem solver, goal oriented, with a strong drive for quality, value and innovation
Proficiency in Oracle PL/SQL Programming.
Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
Strong knowledge PLSQL Developer and TOAD.
Good knowledge in BI
Attention to Detail
Proven problem-solving abilities
Highly self-motivated
Flexible during times of change
Able to learn, understand, and apply new technologies

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008 , SAP Tables and MS Access.

ETL Tools: SQL*Loader.

Reporting Tools: Crystal Reports, and Oracle Reports 2.5

Operating Systems: UNIX(LINUX), Windows NT/98/95/2000 & Windows XP.

Data Modeling: Erwin 4.0

Languages/Utilities: SQL, PL/SQL, Unix shell scripts,Visual Basic, XML, CSS, JBoss, and C.

Other Tools: WIN CVS, Excel, Oracle Data Dictionary, Oracle trace, MS-Office, MS-Visio, MS-Project.

Methodologies: Agile software development with Scrum, use Case Modeling and requirements engineering, principles of good usability and user experience, and fundamentals of software quality assurance.

PROFESSIONAL EXPERIENCE

Confidential

Product and Services Manager

Responsibilities:

Product Owner for product area mortgages and loans
Development of strategic product road-map and prioritization of product backlog
Responsible for design, development, maintenance and launch of new products, improvement and life-cycle management of product offers
Manage budget, support technical recruitment process, and planning team grown

Confidential

Oracle PL/SQL Developer

Responsibilities:

Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Developedmaterialized viewsfor data replication in distributed environments.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
Experience inOracle packages,Dynamic SQL, RecordsandPL/SQL Tables.
Loaded Data into Oracle Tables usingSQL Loader.
Partitioned large Tables usingrange partition technique.
Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
Worked extensively onRef Cursor, External TablesandCollections.
Expertise inDynamic SQL, CollectionsandException handling.
Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
Good knowledge of key Oracle performance related features such asExecution PlansandIndexes.
Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship