PL/SQL Developer Resume CA - Hire IT People

SUMMARY

Sound noledge in Oracle 11g,10g,9i, Informatica Power center 9.1, Tableau 8.3.
Extensive work noledge in DDL, T - SQL, PL/SQL, Stored procedures, Triggers, Functions, views and packages.
Involved in creating mapping, transformation and performance tuning(Informatica).
Extensive work experience in health care domain and banking sector.
Sound technical noledge in Informatica data quality, ETL (Extract Transform Load), creating dashboard in tableau with MYSQL server.
Extensive noledge and experience in dealing with Relational Database Management Systems, including normalization, constraints, querying, joins, keys, indexes, data import/export.
Resourceful in teh completion of projects and effective at multitasking.
Involved in developing data mapping, performance tuning.

TECHNICAL SKILLS:

Skills: Spreadsheet Management, Time Management, Ordering Process, Customer service Oriented

Programming Languages: MySQL, XML, Oracle 11g,12c,9i, UNIX, J2EE, LINUX shell scripting

Business Intelligence tools: Tableau, Business Intelligence Development Studio (SSIS/SSRS), Informatica Power Center 7.1/8.6/9.1.

Data Base: Server 2000/2005/2008/2008R2/2012, MS Access

Operating Systems: XP, Windows NT / 2000. Windows Server 2003/2008/2008R2, Linux

Reporting Tools: Tableau 9.x, Excel, Qlik view, Crystal Reports

Scripting language: JavaScript, HTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential, CA

PL/SQL Developer

Responsibilities:

Design and Development of data validation, load processes, test cases usingPL/SQL, Stored Procedures, Data manipulation, Functions, Triggers, Cursors using Oracle 11g.
Used SQL*Loaders to download teh data into warehouse database from teh flat files and other data files across different platforms.
Performance tuning was done at teh functional level and map level in Informatica. Used relational SQL wherever possible to minimize teh data transfer over teh network.
Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
CreatedTables, Views, Materialized views, and constraints.
Create Oracle Stored Procedures to implement teh ETL Process control logic.
Created Oracle Stored Procedures for Segment Dimension which holds all teh dimension keys.
Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
Documented all teh ETL and Oracle Procedures developed.
Designed and developed teh Forms and Reports for teh user Interface.

Environment: Oracle Database 11g, Windows XP, UNIX, Informatica 9.1, Tableau 8.3.

Confidential

Oracle Developer

Responsibilities:

Involved in Database Design and Analysis.
Design and Developed data validation, load processes usingStored Procedures, Functions, and Triggers using Oracle 11g.
Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
Involved in performance tuning, Debugging, troubleshooting and query tuning.
Designed Report output formats, complex filtering and formula calculations, as well as teh rendering of multi-band and multi-grouped reports.
Developed complex triggers in reports before/after for validation of user input.
Coordinated between management, users and technical teams for Requirement Gathering.
Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: Toad Oracle, Excel, MS SQL Server 2005, UNIX, LINUX