We provide IT Staff Augmentation Services!

Sr. Oracle Resume Profile

4.00 Rating

CA

Summary:

  • Nearly Eight 8 Years of extensive experience as a Sr. Oracle PL/SQL Developer/ETL/Datawarehousing developer in Analysis, Design, Development, Implementation of Business Applications using the Oracle relational databases management system on various platforms.
  • Worked with Data Modeling both Physical Logical using Erwin/ Designer 2000.
  • Proven ability to plan, coordinate and implement Full Life Cycle software development and maintenance projects.
  • Strong skills in Oracle are PL/SQL, SQL PLUS, Pro C, back-end programming like Packages, Functions, Stored Procedures, Database Triggers and wrote Shell scripts.
  • Strong in Database/Application Design, performance tuning and Database Administration.
  • Strong in Database Design, Creation, Migration, Upgrading, Performance Tuning, Logical and Physical Design, Disk Space Management, Database Tuning, Backup and Recovery Activities, Installation and Upgrade of Database.
  • Proven ability to plan, coordinate and implement Full Life Cycle software development and maintenance projects.
  • Implementation of large and complex Oracle character GUI based Client/Server applications and also web based applications.
  • Experience in Extraction , Transformation and loading using Informatica.
  • Experience with ETL tools Informatica Server Manager, Repository Manager, PowerCenter, Workflow Manager, Workflow Monitor, PowerMart , Oracle 9i/8i database.
  • Worked with Data Modeling both Physical Logical using Erwin/ Designer 2000.
  • Worked Extensively with an ETL tool, Informatica to gather data from relational sources and putting into the Warehouse.
  • Developed Data Warehouses/Data Marts/ODS and Business Intelligence applications.
  • Extensive experience in developing Data Warehouse using Ab Initio
  • Extensive Knowledge in conversion of Corporate Data Model into a Warehouse Star Schema or Snowflake Model
  • Worked extensively in data warehousing using ETL Extraction, Transformation and Loading tool Ab Initio, well versed with RDBMS's like Oracle SQL Server and Operating System concepts.
  • Strong skills in developing data management solutions using Ab Initio along with Enterprise Meta Environment EME .
  • Expertise in Working UNIX Shell Script and scheduling cron jobs.
  • Experience in Data Warehousing techniques like OLAP, ROLAP, MOLAP, and Star/Snowflakes Schema.
  • Experience in interacting with Business Users to analyze the business rules on requirements to design the database.
  • Good problem solving ability in diverse software environment. Very good communication skills and Team player.

Technical Skills:

  • Databases: Oracle 10g/9i/ 8i/8/7.x, MS-SQL Server, Access,
  • Languages: PL/SQL, SQL, Pro C, Java, UNIX K/B/C Script, JSP, VB Script,
  • Data Modeling: Designer 2000, Erwin
  • Tools: Designer 2000, Erwin 4.0, Developer 2000/6i/9i, Form Builder, Query Builder, Reports Builder, Forms 9i/6i/4.5, Reports 2.5/6i, TOAD, SQL Plus, SQL Loader, Explain Plan, Import/Export. Ab Initio GDE 1.13/1.12/1.11/1.10
  • REPORTS: Crystal Reports.
  • Operating System: Unix, Solaris, Windows 9x/2000/NT, DOS.

Confidential

Sr. Oracle/ ETL developer

Responsibilities:

  • 1 Four High Priority Projects GLIMR,NPSR,TKAS,TKAS
  • Analysed new requirements from the business users.
  • Wrote PL/SQL procedures, packages, triggers and Oracle Forms as required.
  • Built complex queries using SQL and wrote stored procedures using PL/SQL.
  • Created and modified Screens using Forms 9i/6i.
  • Developed and modified a number of Forms 9i and Reports 9i for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
  • Performed database development tasks such as Stored procedures, Indexes, Triggers, SQL Queries, Functions and packages.
  • 2 Built complex queries using SQL and wrote stored procedures using PL/SQL.
  • 3 Designed the ETL processes using Ab Initio to load data from Terdadata, Oracle, SQL Server and Flat Files target Oracle, Teradata databases.
  • Graph development using Ab Initio and Unix Shell scripts
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  • Developed and modified a number of Forms 9i and Reports 9i for various modules.
  • Testing - Unit testing Integration testing
  • Driving Run activity and UAT co-ordination.
  • Involved in developing Tiwoli and Jobtrac jobs for scheduling
  • Involved in Performance Engineering for the existing ETL

Environment: Oracle 9i/10g, PL/SQL, Forms 9i, Reports 9i, Ab Initio GDE 1.14. Ab Initio OS 2.14.1, Teradata, Windows NT 4.0, UNIX, TOAD Quest

Confidential

Sr. Oracle Developer

Responsibilities:

  • 4 Worked in Production Support Environment as well as QA /TEST environments using MAGIC tool for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Mentored junior programmers in Oracle database design and development.
  • Wrote PL/SQL procedures, packages, triggers and Oracle Forms as required.
  • Built complex queries using SQL and wrote stored procedures using PL/SQL
  • Wrote Oracle batch scripts that migrate Oracle Streams between databases.
  • Wrote Korn Shell Scripts for Data loading and DDL Scripts.
  • Tuned Oracle Queries.
  • Developed reports using Reports 9i and invoked Triggers, etc.
  • Worked in Production Support Environment as well as QA /TEST environments using Mercury Quality Center tool for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc..
  • Involved in Logical Physical Database Layout Design.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from sql server database to oracle database
  • Worked with various departments team members.
  • Provided user training and general production support.
  • Wrote and modified PL/SQL procedures, packages, triggers and JAVA and JSP codes as required.
  • Did research and analysis and debugging for various cases and scenarios for high volume transaction processing as well as nightly batch jobs with unix shell scripts,.
  • Used Abinitio to create mappings to generate custom reports.
  • Worked with front-end developer teams and helped testing and QA team to unit/regression test migrated code
  • Worked with XML data coming from the front end and saved into Oracle database and Executed queries and did the data validation. Load the data using SQL Loader.
  • Did performance tuning of PL/SQL codes and queries to make application run faster.
  • Worked with DBA team to fine tune various queries and views using EXPLAIN PLAN, TKPROF, hints and analyzing tables and indexes involved in queries.
  • Worked on Oracle SEQUENCE to change them or reset them during regression testing.
  • Did lots of follow-up and approvals in emergency database migrations
  • Worked in Oracle 9i and 10g versions and used HARVEST as version control tool for grouping PL/SQL Codes Changes under MAGIC Tickets

Environment: Oracle 9i/10g, TOAD, SQL, PL/SQL, Abinitio, EXPLAIN PLAN, TKPROF, SQL Loader, Java, JSP, XML, SQL Plus, Shell Scripts, Unix, Windows, HARVEST

Confidential

Sr. Oracle/ETL Developer

Responsibilities:

  • Created Mappings using Informatica PowerCenter 6.x in order to populate the CDW in Oracle from different sources like flat files, Access, Oracle and SQL Server. Reusable Mappings were created to load data from heterogeneous sources.
  • Designed and developed Data Warehousing using Erwin and Informatica.
  • Pre and Post Session Scripts for dropping and recreation of indexes.
  • Analysis of a PL/SQL procedure producing flat files on a different server and conversion to an Informatica mapping.
  • Documented business rules, functional and technical designs, test cases, and user manuals
  • Participated in the full software life cycle.
  • Designed coding specification and documentation.
  • Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
  • Generated SQL and PL/SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, sequences, grants, Db Links and synonyms.
  • Created packages, stored procedures and triggers for the application using both static and dynamic SQL.
  • Most of the transformations used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
  • All mappings that were touched analyzed, modified or created a fresh were documented and result from the new production run was compared successfully to the earlier production information.
  • Troubleshoot error prone mappings and improved the mapping performance by performance tuning and using SQL overrides.
  • Sessions were created to run the data loading and documentation of exiting mappings as per standards.
  • Populated slowly changing dimensions according to Kimball methodology
  • Used Unix Shell Scripts using Shell to automate the process of running jobs batches created hierarchies on the Work Flow Manager

Environment: Informatica Power Center RT, ETL, Oracle,SQL SERVER, V8.0, PL/SQL, SQL Plus, ERWin, Windows 2000, UNIX.

Confidential

Oracle Developer

Responsibilities:

  • Worked in modules : INTERFACES and ODSBI
  • Generated entities in DESIGN EDITOR and RON Repository Object Navigator inside Designer for data modeling of schema.
  • Generated front-end forms from Designer entities.
  • Worked on designing schema, tables, indexes, constraints and sequences.
  • Wrote and modified PL/SQL procedures, packages, triggers and JSP codes as required.
  • Developed and modified a number of Forms 9i and Reports 9i for various modules.
  • Responsible for following up bugs reported by various users and suggesting possible patches to be applied.
  • Developed reports using Reports 9i and invoked Triggers, etc.
  • Created Drill-down and matrix reports using Reports 9i.
  • Did unit integration testing for various scenarios, created manual data for same.
  • Changes programs for design changes for columns, datatypes, constraints, indexes.
  • Wrote batch and SQL LOADER control scripts for data loading for DCA STATION/TECHNICIAN and DMV VEHICLE.
  • Worked on manual dimensions base tables when design model was ready
  • Wrote shell scripts to automate batch processes.
  • Worked on Query tuning and performance tuning and write documentation for same.

Environment: Oracle 9i/10g, Oracle Warehouse Builder, PL/SQL, TOAD, SQL Loader, JSP, Designer 9i, Forms 9i, Reports 9i, Jdeveloper, OWB, SQL Plus, RMAN, XML, STARTEAM, Shell Scripts, Sun Solaris 9, Windows XP.

Confidential Oracle Developer

Responsibilities:

  • Involved in building Enterprise wide Logical and Physical database design using the Designer 6i/2000.
  • Configured and deployed Forms and Reports to the Forms 6i and Reports Server.
  • Installation and set-up of Oracle 9i/8i database.
  • Created and modified Oracle Schema objects like Tables, Indexes.
  • Involved in process of normalization. Developed Entity relational Diagrams ERD .
  • Involved in SQL PL/SQL programming for stored procedures.
  • Involved in extraction and loading of data from legacy system Mainframe to Oracle database.
  • Worked on performance tuning of SQL queries involved in the reports, indexes partitioned tables to improve overall performance of RIM system.
  • Worked on creating interfaces between other WB systems and RIM system using PL/SQL procs and Pro C and created load programs to load data from flat files with necessary business validations using Pro C.
  • Generated Triggers for data integrity, Created views to resolve complex queries.
  • Designed/ created Oracle database objects, Roles/ Privileges and schemas.
  • Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
  • Worked on creating batch programs using C , Java, Pro C, Perl and C-Shell also developed Oracle jobs.
  • Fine tune SQL queries and resolve performance issues.
  • Web enabled Oracle reports using Reports 6i and put it on the Intranet for the managers

Environment: Oracle 9i/8i, PL/SQL, SQL, Designer 6i/2000, Erwin, Stored Procedures, SQL Loader, Import/Export, Reports 6i, Forms 6i, Perl, Java, C , Shell Scripts, SQL Navigator 4.0, TOAD 7.4, UNIX and Win NT.

Confidential

Oracle Developer

Responsibilities:

  • Involved in requirement analysis and prepared system design documents. Involved in designing forms, validating form objects including ActiveX components, Data access using Oracle as the backend and ADO and RDO as data facilitating objects.
  • Designed and developed table structures, Stored Procedures and Database triggers to implement business rules.
  • Designed User Interface Screens and involved in coding and testing of the applications.
  • Created multiple PL/SQL procedures, functions and Cursor as stand-alone schema package spec/body.
  • Created a PL/SQL table with indexing it using BINARY INTEGER to handle a table record in PL/SQL block. Designed Visual Basic classes for UI and database access modules.

Environment: Windows NT, Oracle 8i,PL/SQL, SQL, SQL PLUS.

We'd love your feedback!