We provide IT Staff Augmentation Services!

Odi Developer Resume

St Pete, FloridA

SUMMARY:

  • Around seven years of IT experience in Implementation, Design and Development of Client/Server & Web - server applications using Oracle 12c/10g/9i/8i databases on UNIX & Windows Platforms. Expertise in Oracle 12c/10G/9i/8i, SQL, PL/SQL, Oracle Forms 10g/9i/6i, Reports10g/ 9i/6i and UNIX shell scripting.
  • Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications through out various phases of project life cycle.
  • Interacting with Business users, gathering and analyzing requirements.
  • Experienced in System Analysis, design and implementation. Logical and physical data modelling. Monitor database performance & Tuning
  • Good understanding of Oracle data dictionary and normalization techniques. Experienced in Oracle 10g/9i/8i/8.x/7.x systems, SQL*Loader, Export, Import and SQL*Plus.
  • Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships.
  • Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
  • Experience in writing Stored Procedures, Functions, Database Triggers, and Packages using PL/SQL. Enforcing data integrity using integrity constraints & database triggers.
  • Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures. Loading data from flat files into database tables using SQL*Loader.
  • Automating data loading, extraction, reports generation using UNIX Shell scripting.
  • Involved in Forms Migration from 6i to 9i using Migration Assistant Tool.
  • Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
  • Experience in developing applications using forms (10g/9i/6i) and reports (10g/9i/6i). Well experienced in backend programming (Triggers, Procedures, and Functions) using Oracle 10g/9i/8i/8.x and web enabled application development and deployment using Oracle application server.
  • Experienced in loading data using SQL *loader and using SQL *Plus. Sound experience in creating HTML pages using Oracle Web tool Kit on Oracle Web Server. Good in writing complex SQL queries according to business rules.
  • Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc for optimization process.
  • Involved in query tuning using Explain plan and TKPROF.
  • Developed Data Mapping and Data Conversion scripts using SQL, PL/SQL.
  • Extensively used UTL FILE package to write the data from oracle tables to a flat file.
  • Written complex SQL’s using joins, sub queries and correlated sub queries.
  • Wrote Test cases and performed data validation and process testing for application moving into production. Excellent in problem solving, logical and analytical abilities.
  • Team Player with Analytical skills, ability to quickly adept to new environment and available as needed for training.
  • Ability to work independently and as part of a team, deliver under pressure and tight deadlines.
  • Quick learning ability towards new technology. Easy adaptability to new environments.

TECHNICAL SKILLS:

RDBMS/Application Sever: Oracle 12c/11g/10g/9i/8i/, Developer 12c/11g/10g/9i/6i suite (Forms 10g/9i/6i, Reports 10g/9i/6i), Oracle Designer 2000/6i, Discoverer 9i SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, Erwin, Toad, Oracle Enterprise Manager

Languages: SQL, PL/SQL, Unix shell scripting

Operating System: Oracle Enterprise Linux, Redhat Linux, Sun Solaris for SPARC 8.0/2.6, HP UNIX 10.2, IBM AIX 4.1, Windows-2000/NT/98/95, MS-DOS

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Languages and Web Technologies: SQL, PL/SQL, Java, J2EE, Shell Scripting, XML, HTML/XHTML.

Hardware: SUN SPARC E5500, HP9000, IBM RS/6000, Dell Power Edge 6400, Intel x86, P-II/P-III/P-IV

WORK EXPERIENCE

Confidential, St. Pete, Florida

ODI Developer

Roles & Responsibilities:

  • Involved in various stages of system development life cycle such as requirement analysis, design, and development and testing.
  • Created SSIS Packages to export and import data from CSV files. Used Visual Studio TFS to check in the code.
  • Created various SSIS Packages to get the data from various databases in SQL Server and exported a Tilde delimited text file on the server.
  • Used Oracle Data Integrator (ODI) 12.1.3 to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse.
  • Expertise with all ODI tools and debugging.
  • Smart imported projects and knowledge modules into the work repository to implement the logic.
  • Used “File Loader Utility” which is an RJ customized method of loading the data into appropriate “FILL” tables using EXTERNAL TABLE concept in ODI.
  • Loaded the data into staging tables using some transformations and ODI Components.
  • Loaded data into proper owner tables which involved integration.
  • Exported the data from the table into a Text file onto UNIX server using ODI 12.1.3.
  • Worked with Data Warehouse team to pick up the exported file from UNIX and load it into appropriate Staging tables using RJ’s data loading standard.
  • Actively participated in the certification training course on “Intro for Experienced SQL Users and 12c: Develop PL/SQL Program Units” and “Oracle Data Integrator 12c - Integration and Administration” organized by Oracle team at Raymond James Financial.
  • Did unit testing and development testing at ETL level in my mappings
  • Involved in fixing bugs within Packages and Stored Procedures.
  • Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.

Environment: Oracle Database 12c, Windows 7, Oracle Data Integrator 12.1.3, SQL Server data tools, Visual Studio, SQL Server Management Studio, UNIX, SQL Developer, XML, Putty.

Confidential, Tampa, Florida

Oracle PL/SQL Developer

Roles & Responsibilities:

  • Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
  • Worked with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.
  • Developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
  • Involved in SQL Tuning of PL/SQL modules developed. Used PL/SQL web toolkit to develop programs for web enabling.
  • Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
  • Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
  • Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools like Toad and PL/SQL.
  • Participated in system analysis and data modeling, which included creating tables, views indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Created and manipulated stored procedures, functions, packages and Created stored procedures using dynamicSQLto populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Wrote validation Packages using PL/SQLpackage.
  • Design, develop, implement, and assist and in validating ETL processes.

Environment: Oracle Database 9i/11g, Windows 7, Oracle Forms 6i/11g, Oracle Reports 6i/11g, UNIX, Toad, XML, SQL, PLSQL, Unix Scripting, Putty.

ETCC, Richardson, TX

Sr. Oracle PL/SQL Developer

Roles & Responsibilities:

  • Involved in SDLC gathering requirements, creating detailed Documentation HLD and TDD which includes all Business requirements and technical specifications.
  • Involved in scrum meetings, Business requirements meetings.
  • Developed stored procedures, functions, triggers and packages to facilitate consistent data entry into the database.
  • Participated in system analysis and data modeling, which included creating Tables, Views, Materialized Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
  • Set up Oracle advance queuing using DBMS AQ and DBMS AQADM packages, for both buffered queues and persistent queues.
  • Expertise in working with Records, Collections and Dynamic SQL.
  • Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
  • Involved in working with implicit cursors, explicit cursors, and REF CURSORS.
  • Experience in using various oracle PL/SQL collections Varrays, nested tables, associative arrays with INDEX BY VARCHAR2
  • Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
  • Create various user defined exceptions to control the process based on the business requirement.
  • Involved in generating numbers for primary key values using Oracle sequence objects.
  • Used several Oracle predefined functions like NVL, NVL2, DECODE, CASE STATMENT.
  • Extensive experience in design, development, and enhancement and managing applications oracle PLSQL.
  • Involved in integration of the data with SOA, OFS and JAVA teams according to the business specifications.
  • Testing the system integration closely with SOA, OFS and JAVA team and resolve the issues as per the business rules.
  • Experienced in handling all XML specific storage models (Structured, Unstructured - Schema Based and Binary XML-11g )
  • Developed PL/SQL API’s to provide the linking information in the form of XML’s.
  • Worked in all deployment processes to SIT, QA and Production Environments.
  • Handled various errors thrown throughout the integration process and coordinated with the team. Updated status of the development on daily basis.

Environment: Oracle Database 9i/11g, Oracle Forms 6i/11g, Oracle Reports 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, .Net, DTS, TOAD, Clear Case, VSS, UNIX.

Confidential, Racine, WI

Oracle Developer

Roles & Responsibilities:

  • Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
  • Involved in development of User Interface Objects (Forms9i and Reports9i) and Testing of entire module.
  • Extensively worked with forms 9i using the advanced features like beans, hierarchal trees.
  • Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
  • Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
  • Involved in migrating forms from 6i to 9i using migration assistant.
  • Involved in moving the code to production using Change Management Procedures.
  • Documented all the packages, procedures and functions involved in ETL process.
  • Written many database triggers for automatic updating the tables and views.
  • Responsible for back end stored procedures development using PL/SQL predefined procedures. Used Explain Plan and hints to tune the SQL
  • Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
  • Involved in loading the data from flat files to Oracle tables using SQL*Loader and C.
  • Involved in creating user documentation and providing End user training.

Environment: ORACLE10g, SQL* Plus, UNIX, Forms 9i, Reports 9i, PL/SQL Developer, C, FORTRAN, Windows XP, SQL * Loader, TOAD, PVCS.

Confidential, Greensboro, NC

Oracle Developer

Roles & Responsibilities:

  • Created and managed many objects in large Oracle Databases containing millions of records.
  • Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
  • Developed logical and physical data models for central model consolidation.
  • Created databases, tables, views & schemas. Performed users’ access authorization, Defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
  • Involved in the Database design and application development to support the creation and management of online business units for business users and customers usage.
  • Troubleshoot jobs using the debugging tool.
  • Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
  • Involved in reverse engineering of the application using Erwin.
  • Used Erwin to transform data requirements into data models.
  • Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
  • Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
  • Participated in Performance Tuning using Explain Plan and Tkprof.
  • Loaded and unloaded data sets from or to Oracle Databases using various kinds of data loading tools such as SQL*Loader and Oracle Import/Export Utility.
  • Design, development and implementation of web-based applications using developer 6i to enable customers to make sub payments through internet & to receive up to date information about their client and their payment schedule etc.
  • Involved in UNIX script changes and creating new scripts accordingly.
  • Analyzed the performance of the jobs during the project. Utilized standard techniques for enhancing the performance.
  • Created job sequences and schedules for automation.
  • Authored User reference documents on all the deliverables created for future reference by Business Users and conducted training sessions.
  • Used hints with Indexes for query optimization.
  • Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Sun Solaris 8.0, Windows NT 4.0/2000 Oracle 9I, PL/SQL, TOAD, Forms 6i, Reports 6i, Shell Scripting (Korn)

Confidential

Oracle Developer

Roles & Responsibilities:

  • Developed Oracle forms, database triggers, cursors, stored procedure
  • Developed PL/SQL Packages, Functions. Utilized SQL*Loader to load flat files database tables.
  • Responsible for SQL tuning and optimization using Analyze, EXPLAIN PLAN, TKPROF utility and optimizer hints
  • Utilized PL/SQL developer tool in developing all back end database interfaces
  • Worked on responsible for performing code reviews.
  • Developed user documentation for all the application modules. Also responsible for writing testplan documents and unit testing for the application modules.
  • Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYSand IOTs
  • Developed graphical interface of Adobe Designer enables users to quickly design forms,Maintain form templates.
  • Created database scheduler scripts and applications using Unix shell scripts, SQL *Plus script
  • Maintained performance tuning by using SQL-Related Performance Tools like SQL Trace and TKPROF, Indexes and Clusters etc.
  • Worked on Report generated for Inventory, Sales and Material Planning
  • Analyzed data flow in the business process
  • Upgraded, maintained and troubleshooter for Oracle Forms and Reports
  • Oracle Forms created the back-end system for administrators
  • Worked on Screen designed, table designed preparation of user manual and development of the program using Developer Forms 6i, Designer 6i, Reports 6i, PL/SQL.

Environment: Oracle 10g, PL/SQL Programming, PL/SQL Cartridge, Web logic 9,9.1,10, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Discoverer, Adobe Designer, VB.net, Unix/korn/Perl, ASP.net, OWB, Erwin, TOAD, JSP MessageQ, IBM MQ Series, DCL, CVS, Data Modeler, SQL, C, PRO*C, K-shell, SQL*Loader, EXPLAIN PLAN and TKPROF tuning utilities

Confidential

Oracle PL/SQL Developer

Roles & Responsibilities:

  • Developed screens using Forms 6i.
  • Developed PL/SQL modules-Administration Manager (AM), Cession Manager (CM), ReportManager (RM), Database Utility (DU) modules.
  • Extensively involved in SQL Tuning of PL/SQL modules developed. Used PL/SQL web toolkit to develop programs for web enabling.
  • Used Web request broker and PL/SQL agent for the connection to the Oracle database.
  • Created reports in Oracle Discoverer by importing PL/SQL functions on the Admin Layer, in order to meet the sophisticated client requests.
  • Developed Billing and Policy exhibit reports using Reports 6i which are sent to reinsures on regular basis
  • Developed extract reports using Reports 6i to upload information to the policy valuation/Accounting system as well as custom reports for internal use
  • Conducted Unit and Functionality Testing of the above modules
  • Performed the documentation of the modules and reports generated
  • Implemented shell scripts for scheduling batch jobs, diagnostics
  • Responsible for Performance tuning of the Forms and Reports code modules using EXPLAIN

Environment: Sun Solaris 8.0, Windows NT 4.0/2000 Oracle 9I, PL/SQL, TOAD, Forms 6i, Reports 6i, Shell Scripting (Korn)

Hire Now