Senior Pl/sql Developer Resume
Detroit, MI
SUMMARY
- 7+ years of experience in IT, as Software Engineer in Data Warehousing with SQL and PL/SQL development activities
- Hands on experience using query tools like TOAD, SQLDeveloper and PLSQLdeveloper
- Working experience in AGILE methodology for software development.
- Strong Exposure in writingSimpleandComplex SQLs, PL/SQL Functions and Procedures, Packagesand creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
- Experience in Tuning SQL Statements and PL/SQL Procedures for enhancing teh load performance of applications in various schemas across databases.
- Expertise in using SQL utility tools: TOAD, SQL*PLUS, SQL Developer and SQL navigator.
- Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries.
- Having experience in ETL processes and Interfaces, mapped teh columns and load teh data from source systems by using ODI (Oracle data integrator),SQL* Loader.
- Good experience of end to end ETL design and Development, Transformation and Loading in a complex, high-volume environment.
- Good experience in Oracle Database Integrator and Control-M Scheduling tool.
- Strong problem solving & technical skills and significant experiencein24/7 ProductionEnvironment Support.
- Excellent analytical, interpersonal and communication skills to assimilate new technologies and tools.
- Excellent ability to work in groups as well as independently.
TECHNICAL SKILLS
ETL Tools: Oracle Database Integrator (ODI), Ab Initio & SQL Server Integration Services (SSIS)
Database: Teradata V12, Oracle 11g, Microsoft SQL Server, MySQL
Reporting tools: Cognos BI, Microstrategy
Language: C, SQL, PL/SQL
Operating Systems: Windows XP, Windows 2007, UNIX
PROFESSIONAL EXPERIENCE
Confidential, Detroit, MI
Senior PL/SQL developer
Responsibilities:
- Designed/developed/Modifiedtables, views, materialized view, stored procedures, packagesandfunctions.
- Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied teh procedures into an existing ETL process.
- Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
- UsedSQL loaderto load teh data from teh files provided by teh interfacing applications.
- Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
- Createdpartitioned tablesandpartitioned indexesto improve teh performance of teh applications.
- WrotePL/SQL Database triggersto implement teh business rules in teh application.
- Createdexternal tablesto handle huge volumes of data which is not used frequently.
- Optimized lot ofSQL statementsandPL/SQL blocksby analyzing teh execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
- Developed various backend application programs, such asViews, Functions, Triggers, ProceduresandPackagesusingSQLandPL/SQLlanguage for teh top management for decision making.
- Performed Unit test, System integration test to make sure teh deliverables are match with business requirement
Environment: Oracle 11g, PL/SQL, TOAD, UNIX
Confidential, Rochester, MN
Oracle developer
Responsibilities:
- Creating PL/SQL Stored Procedures, Functions and Triggers
- Coding according to teh mapping sheet and debugging teh code.
- Oracle Application Performance Tuning and SQL Query Tuning.
- Data Migration Using SQL Loader
- Client interaction.
- Reviewing teh test scripts and involved in preparing technical specification documents.
- Unit Testing
Environment: Windows/XP, UNIX, PL/SQL, TOAD, UNIX and Oracle9i
Confidential, Ann Arbor, MI
PL/SQL developer
Responsibilities:
- Extensively involved in writing procedures, functions, triggers and packages
- Involved in Analyzing and Performance Tuning of teh SQL queries using optimizer hints for joins, parallelism and Explain plan.
- Involved in Unit Testing teh codes.
- Involved in debugging and fixing teh codes dat had performance issues.
- Worked with teh Table Partitions to further improve teh performance while using tables containing large number of columns and rows.
- Used SQL*LOADER to store data in teh Oracle database from different types of flat files.
- Provided support in SIT/UAT phases of teh project.
- Coordinated with various project stake holders for delivery.
Environment: Oracle10g, SQL, PL/SQL, TOAD, SQL*LOADER, UNIX, Oracle Reports 10g, Linux.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Developing highly complex applications using Oracle 11g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
- Responsible for analyzing, Design and developing teh code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for teh real production environments.
- Developed Packages and customized functions and Triggers based upon teh business logics.
- Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
- Utilized SQL*Loader to load flat files into database tables.
- Used PL/SQL developing to load data from teh source table to teh target table based on teh business logic.
- Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
- Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database.
- Responsible for performance tuning activities in oracle.
- Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
- Used Materialized Views in order to improve teh performance.
- Proposed and coded enhancements on Oracle PL/SQL
Environment: Oracle Database 11g, TOAD, PL/SQL, Oracle Application Express 4.2, UNIX (Solaris), PUTTY.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Created many Generic Stored Procedures, Functions, Database Triggers, Packages, Tables, Indexes, Views, Synonyms, Sequences using SQL and PL/SQL.
- Extensively used PL/SQL programming in back end and front end Functions, Procedures, and Packages to implement business logics/rules.
- Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
- Analyzed teh system requirements and performed logical and physical design of teh database.
- Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout teh development wherever needed.
- Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
- Created application schema as tables, view and indexes and customized teh stored procedures and database triggers in PL/SQL.
- Exception handling and cursor management in PL/SQL.
- Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do teh transactions.
- Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per teh requirements.
- Designed Conversion and Interface Programs using PL/SQL procedures and packages.
- Analysis, Development, Testing and Implementation using Oracle 11g/10g.
Environment: Oracle 11g, Oracle performance tuning, SQL* loader,SQL, TOAD, PL/SQL.