Pl/sql Developer Etl Developer Resume Profile
Las Vegas, NV
Summary:
- More than 7 year's experience with proven ability in the area of Client/Server and Distributed Multi-tier Application Development, Data modeling, Database Design, Data processing, Data Warehouse and Support mainly using Oracle technology on different platforms.
- More than 7 year's proven experience in PL/SQL that includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables IOT , SQL Loader, ETL Tools etc.
- Over 7 year's experience in Oracle data warehousing and Business Intelligence: Data modeling in Dimensional structures - Star/Snowflake schema, ETL, OLAP, OLTP, VLDB very large application .
- Expertise in Data Conversions/Migration from Legacy System of various sources flat files, Oracle, Non Oracle Database to Oracle system Using SQL LOADER , External table and Calling Appropriate Interface tables and API's.
- Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
- Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
- Developed different Business Intelligence OLAP report using OBIEE.
- Proficient in using UNIX and Shell Scripting.
- Experience in Advance Queue.
- Experience in Data flow Diagram, ER Diagrams using Oracle designer.
- Exclusively followed all phases of System Development Life Cycle SDLC and Best Practices.
- Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
Technical Proficiency:
Languages | SQL, PL/SQL, SQL Plus,MY SQL |
RDBMS | Oracle 10g/9i/ 8i, MS SQL Server, Ms-Access |
Business Intelligence Tool | OBIEE 10.1.3.4.1,Oracle reports 10g/9i/6i, Discoverer |
Modeling | Visio, Oracle designer, ERWIN,Oracle Data Modelar |
ETL | SQL, PL/SQL |
Other Tools | AdTempus jobs scheduler tools,TOAD 8.0/8.5/9.0/9.6, PL/SQL Developer,SQL Developer, SQL Navigator, XML, ISQL,PVCS, FTP, Toad, SDLC |
Operating Systems | Sun Solaris, HP-UX, AIX, Unix, Linux, Windows |
Professional Experience:
Confidential |
Role: PL/SQL Developer ETL Developer |
- Worked with Help Desk people to solve problem and create batch job.
- Created monthly campaign manifesto work for business improvement.
- Worked with Middle Tire and Guie for Design and Development for project.
- Wrote complex PL/SQL package, functions, procedures, batch processes using bulk processing, ref cursors and Pl/Sql Tables.
- Did Design Document and create ER Diagram for project development.
- Designed Data Flow, Entity Relation and others Diagrams with Erwin,
- Visio, SDPRO, Oracle Data Modeler tools.
- Coordinated with DBA in creating and managing Indexes, Db Links and Privileges.
- Exclusively followed all phases of System Development Life Cycle SDLC
- Created complex program unit using PL/SQL Records, Collection types
- Nested Tables and Varrays in complex backend packages.
Environment: Oracle 11g, 10g, PL/SQL, SQL Plus, Toad, SQL Loader, SQL Developer, Shell Scripting, AIX, Erwin, Windows XP Professional clients.PL/SQL
Developer.
Confidential |
Role: PL/SQL Developer ETL Developer |
Responsibilities:
- Did Extracting data from Teradata.
- Handled complex Exceptions.
- Packages using Oracle utilities like PL/SQL, SQL Plus, SQL Loader and
- Created database objects like Tables, Views, Materialized views, Procedures
- Designed the process flows to record the dependencies between the mapping runs.
- Did technical design document for future development process.
- Nested Tables and Varrays in complex backend packages.
- Created complex program unit using PL/SQL Records, Collection types
- Designed Data Flow, Entity Relation and others Diagrams with Erwin, Visio and SDPRO.
- Worked on production support team for EOM process issue.
- Coordinated with DBA in creating and managing Tables, Indexes, db links and Privileges.
- Testing and taking measures for maximum performance utilizing optimization hints,
- Indexes, partitions, parallelism, storages and query optimization.
- Experience in Advance Queue.
- Worked on performance tuning of SQL, PL/SQL and analyzed Tables.
- Detailed user requirement Analysis and Design of systems.
- Created UNIX Shell Scripts for automated execution of batch process.
- Developed Application Interfaces using PL/SQL stored Packages,
Procedures, Functions, Collections, Object types and Triggers.
Environment: Oracle 11g, 10g, PL/SQL, SQL Plus, Toad, SQL Loader, SQL Developer, Shell Scripting, AIX, Erwin, Windows XP Professional clients.
Confidential |
Role: PL/SQL Developer |
Responsibilities:
- Identified resources for information and source systems data flows.
- Did basic script using PERL.
- Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression, lookups.
- Designed the process flows to record the dependencies between the mapping runs.
- Code for Fact and Dimension table population using SQL, PL/SQL.
- Worked as a Data Warehouse Developer using OWB.
- Created metadata, ETL mappings using Oracle DB 9i later started building enterprise Data Warehouse using Oracle DB 10g and upgrading from 9i to 10g.
- Developed packages, procedures, functions and database triggers using SQL and PL/SQL.
- Use SQL Loader and External Table for data Load.
- Testing and taking measures for maximum performance utilizing optimization hints, indexes, partitions, parallelism, storages and query optimization.
- Used UNIX shell scripts to clean and re-organize tables from time to time.
- Data modeling using ERWIN tools.
- Created OLAP reports using Oracle Discoverer/OBIEE.
- Customizing Reports in Oracle Report Developer 6i.
Environment: Oracle Application 11.5.10 GL, AR, AP, PA, OM , Oracle Workflow,
Oracle Database 9i/10g R2, SQL, PL/SQL, Discoverer 10g and Developer Forms Reports 6i, SQL Loader Oracle Application Server 10g, UNIX, Red Hat Linux, Windows XP Professional clients, Toad.
Confidential |
Role: Oracle PL/SQL Developer |
Responsibilities:
- Wrote Stored Procedures for effective insertion and updating of the data in to the tables.
- Complex Sub-queries and joins were extensively used in select statements
- Involved in extensive coding in Oracle forms/reports using PL/SQL.
- Used SQL Loader to automate the load of data from Text files to Oracle Tables.
- SQL Loader was used to load the data from the file in CSV format to oracle tables.
- Worked on Oracle Forms and Reports 6i.
- Created matrix reports using Oracle Reports 6i.
- Used Collections like variable arrays, nested tables extensively.
- PL/SQL was extensively utilized for coding and writing complex stored procedures and packages.
- worked on performance tuning of SQL, PL/SQL and analyzed Tables.
- Database Objects Recreation on Development after Refresh from Production
- Worked on Table partition.
- Worked as a Data Warehouse Developer using OWB.
Environment: Oracle 9i/10g R2,Oracle Developer 6i, SQL, PL/SQL,UNIX, Windows 2000/XP, TOAD, Toad, SQL Developer, SQL Loader, Erwin.
Confidential Role : Oracle PL/SQL Developer |
Responsibilities:
- Created Dimensions, measures and hierarchies for providing drill down options in the reporting environment.
- Extracted data from Oracle database 9i and flat file, perform mappings and load it into target Oracle tables using PL/SQL.
- Designed and developed data cleansing, data validation, load processes ETL using Oracle SQL and PL/SQL and UNIX.
- Created report using Oracle Discoverer, Any report can further pivot, sort, stoplight, graph the data presented.
- Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
- Modified Korn shell scripts as per technical specifications in HP-UX/SUN OS environment.
- Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
- Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
- Developed forms and reports using Oracle Forms 6i and Reports 6i for Financial System.
Environment: Oracle Warehouse Builder 9i, Oracle Database 9i, Discoverer 9i, Oracle Developer6i, HP-UX, SUN OS, Windows 2000/XP, TOAD, Toad , SQL ,PL/SQL Developer, SQL Loader, Erwin.
Confidential Role: Database Designer |
Responsibilities:
- Integrated software system for Apparel Manufacturer.
- Maintained liaison with the client executives and technical teams.
- Functional requirements gathering, high-level and detail design.
- Designed Data Flow, Entity Relation and others Diagrams with Erwin, Visio and SDPRO.
- Designed and Created forms and reports with Oracle Developer6/6i/ Crystal Report, PL/SQL, Procedures, Functions, Triggers.
- User Interface elements and reports design.
- Coding, unit, integration and load test.
- Commissioning and system support.
- Installed and configured oracle 9i.
- Created instances, schemas, users, profiles and roles.
Environment: SQL, PL/SQL of Oracle 8i/9i and UNIX Shell scripting, Visio, Erwin and SDPRO.
Developer 6 forms Report and Discoverer EUL.UNIX, Windows 2000/NT Environment, Toad, SQL Loader.