We provide IT Staff Augmentation Services!

Oracle Developer/ Team Lead Resume

Woodland Hills, CA

SUMMARY:

  • Experience of programming in Oracle PL/SQL.
  • Experience of programming in Oracle Forms 6i & Reports 6i.
  • Experienced in working with Oracle (9i, 10g, 11g), DB2, MS SQL Server 2000/2005, MySQL, Sybase databases on various platforms like UNIX (Solaris, AIX), Linux (RHEL, Fedora, SUSE) and Microsoft NT/2000/2003 Server.
  • Excellent skills in designing and development of applications using SQL, PL/SQL, Oracle Database 9i, Designer 2000, SQL*Loader
  • Expertise in PL/SQL functions, stored procedures/packages, triggers, constraints, cursors and views, writing test scripts, creating alerts.
  • Expert in creating indexed Views, complex Stored Procedures, effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
  • Strong development experience in SQL Server, SSIS, SSRS. Ability to tune queries to optimize performance
  • Expertise in loading data from legacy systems using SQL*Loader.
  • Worked in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
  • Knowledge of UNIX Shell scripting.
  • Experience with Performance Tuning.
  • Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by working in development area in using AWR as the main tool to tune SQL queries
  • Implemented database monitoring and tuning, application, and queries using TKPROF, Explain Plan, OEM, and custom scripts for optimum performance within testing, development, and production environments.
  • Working knowledge of different versions of Oracle database including 9i, 10g and 11g.
  • Knowledge of Oracle tools e.g. TOAD.
  • Knowledge of Oracle partitioning, hints and dynamic SQL.
  • Experience in training, mentoring and leading a development team.
  • Knowledge of quality processes.
  • Working knowledge of transportation and warehousing functions.
  • Experience of working in an AGILE environment.
  • Experience of customizing Alerts into Oracle HRMS 11i for multiple clients.
  • Experienced in creating configuration files, Logging, Error handling using Event Handlers in SSIS.
  • Experienced in writing Vb.net, C#.net, code for SSIS 2005/2008 packages
  • Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
  • Working knowledge of Oracle HRMS 11i.
  • Proficient in SQL, database concept, data warehouse and data modeling methodologies.
  • Extensive experience conducting Manual Testing and using defect management tools like Quality Center and Microsoft Excel.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java,Hadoop, Salesforce, SQL Server

Scripting Languages: Unix Shell Scripting

Markup Languages: XML

Database: Oracle 12c, 11g, 10g, 9i,8

Database Tools: Toad, SQL Developer, PL/SQL Developer, SQL * Plus

Version Control: Poly Version Control System(PVCS)

Data Migration Tools: SQL Loader

ETL Tool: Informatica

Operating Systems: Windows 8, Windows 7, Windows 2008/2003/2000/ NT/XP

CAREER EXPERIENCE

Confidential, Woodland Hills, CA

Oracle Developer/ Team Lead

Responsibilities:

  • Worked on production Support for the maintenance project by creating Change Requests.
  • Coordinated with and Managed Off - Shore and On-Site Team.
  • Supported development and deployment activities with full coordination with technical consultants.
  • Analyzed the issues during and after deployment and participated in data validation.
  • Created Change request and Impact analysis documents.
  • Worked with dimensional modeling, updating the fact and dimensional tables.
  • Worked as Transformation Analyst by analyzing the business logic and transforming the data before loading into target tables.
  • Tuned existing procedures to improve performance.
  • Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects.
  • Created packages to identify the duplicate customer numbers and updating the customer with new values
  • Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
  • Extensively used bulk collection in PL/SQL objects for improving the performing
  • Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
  • Worked Used SQL*Loader as an ETL tool to load data into the staging tables Test case/data preparation, execution and verification of the test results..

Environment: Oracle/PL/SQL, Oracle 12c, Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting.

Confidential, Agoura Hills, CA

Application Developer

Responsibilities:

  • Reviewing of BRD and HLD with Business and system analyst.
  • Created stored procedures to Load the data.
  • Worked with dimensional modeling, updating the fact and dimensional tables.
  • Worked on tuning slow running sql queries based on the AWR Report.
  • Worked as Transformation Analyst by analyzing the business logic and transforming the data before loading into target tables.
  • Responsible for design and development of ETL Process for data extraction
  • Worked on Proof of Concept of Sql server to Oracle Migration
  • Worked closely with Cognos developer and helped to tune the reports from the backend.
  • Mentored the new intern and trained him in Oracle.
  • Mentored and lead the team for the deployment.
  • Used Oracle SQL Developer Translator to convert MS-SQL Stored Procedure to Oracle.
  • Extracted all DDLs (like Global Temp Tables and any support objects) and Converted the additional objects in Oracle compatible
  • Deployed all Pre-Requisite objects and Converted Oracle SP in DB for Data warehousing applications.
  • Loaded the Day 0 data and verified the output

Environment: Oracle 11g, TOAD, SQL * Loader, Windows XP

Confidential, Champaign, IL

PL/SQL and UNIX developer

Responsibilities:

  • Responsible for creating UNIX shell scripts that modifies the existed procedures.
  • Worked on production Support for the maintenance project by creating Change Requests.
  • Coordinated with and Managed Off-Shore and On-Site Team.
  • Supported development and deployment activities with full coordination with technical consultants.
  • Analyzed the issues during and after deployment and participated in data validation.
  • Created Change request and Impact analysis documents.
  • Created adhoc scripts that updates/deletes/inserts records <500
  • Worked on Bulk Collect and Materialized Views
  • Worked on creating clean-up scripts
  • Worked on creating new scripts that cancels the subscribers or expires the existed records.
  • Created various Unix Shell scripts to create wrappers, customization of SQL queries, PL/SQL blocks and implementation of parallel execution (multi-threading) of SQL and PL/SQL scripts.
  • Responsible for Production Maintenance and change controls (CCs) and tracking all the problems/requests with production processes through Unified Ticketing System (Remedy) tool.

Environment: Oracle 11g, TOAD, SQL * Loader, Linux

Confidential, Los Angeles, CA

Oracle Developer/Business Analyst

Responsibilities:

  • Interacted with the Business Analysts to get design requirements.
  • Interacted with the User’s and Subject Matter Expert’s to Created Spec’s.
  • Initiating design and code walkthrough sessions with the stakeholders and user groups.
  • Analyzing existing code and data for performance bottle necks.
  • Tuning and optimization of the existing as well as new code as needed using Oracle hints.
  • Conducting peer review for the scope items developed by team members.
  • Utilized SQL*Loader to load flat files into database tables.
  • Created PL/SQL based ETL process to transfer data from sources.
  • Used PL/SQL developing to load data from the source table to the target table based on the business logic.
  • Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
  • Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Trigger.
  • Extensive knowledge of Unified Modeling Language (UML). Modeled views in Rational Rose and Microsoft Visio.
  • Created packages to identify the duplicate customer numbers and updating the customer with new values
  • Worked as Transformation Analyst by analyzing the business logic and transforming the data before loading into target tables
  • Proficient in creating Use Cases, Context diagram, Activity diagram, Class Diagram and Sequence Diagram.
  • Created Activity diagrams, ER diagrams, Sequence diagrams in Microsoft Visio.
  • Developing of PL/SQL packages, stored procedures and functions for the project as per the requirements using performance enhancement techniques like partitioning, dynamic Sql in Oracle 11g.
  • Developing ETL process for the data warehouse in Oracle 11g
  • Unit testing of the modules of the project.
  • Tested new enhancements and bug fixes before Deployment into the Production environment.
  • Worked on Agile methodologies

Environment: Oracle database 10g, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professionaland UNIX.

Confidential, Los Angeles, CA

Sr PL/SQL Developer

Responsibilities:

  • Worked in System Analysis, Design, Coding, Testing, Development and Documentation.
  • Worked in validating and developing the design and logical phase of the requirement.
  • Extensively worked in developing many packages with procedures, functions with cursors.
  • Worked with PL/SQL advanced features like collections and records and PL/SQL objects types, involved in performance tuning and development.
  • Worked in writing many stored procedures, various functions, triggers and developed monthly and weekly reports.
  • Created views, materialized views and indexes on tables as a matter of performance improvement and optimization.
  • Worked with Native dynamic SQL in various stored procedures and functions.
  • Export and Text IO packages and Written many Stored Procedures and in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
  • Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
  • Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
  • Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
  • Writing Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* loader utility. Embedded programming using Pro*C.
  • Merging & updating of Tables using Merge features of SQL*PLUS.
  • Worked with Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
  • Worked on tables in various databases by linking the databases.
  • Worked in data transfer and retrieval through various schemas used TOAD and MySQL.
  • Worked with many complex SQL queries with joins, date functions, inline functions, sub queries to generate reports.

Environment: Oracle database 10g, Linux, Toad, Filezilla, Oracle Developer Suite 10g, PUTTY.

Confidential

PL/SQL Developer/ Business Analyst

Responsibilities:

  • Interacted with the business users on a regular basis to collect Business Requirements and Specifications.
  • Liaison between stakeholders, system users, clients and managers, software development team and the QA team to gather requirements
  • Created Business Requirements Document and converted them into System Requirement specifications Document.
  • Responsible for the development of Reports using SSRS.
  • Writing queries and Stored Procedures in SQL Server 2005.
  • Developing client side reports using SSRS and integrating with Windows Applications using Report Viewer
  • Used Rational Clear Quest for defect tracking and change management request and reported them.
  • Tested new enhancements and bug fixes before Deployment into the Production environment.
  • Worked as part of a team to launch new Application Releases under strict time deadlines
  • Coded database Triggers, Package, Functions, and Procedures using PL/SQL and maintained the scripts for various data feeds.
  • Optimized and Tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries.
  • Responsible for designing and maintaining fully integrated and multiple levels help system for the modules.
  • Experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
  • Writing Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* loader utility.
  • Well versed in creating Dynamic SSIS packages, using containers & variables, configuring the packages, and scheduling the packages.
  • Experienced in creating configuration files, Logging, Error handling using Event Handlers in SSIS.
  • Experienced in writing Vb.net, C#.net, code for SSIS 2005/2008 packages
  • Prepared functional specifications, release notes, training materials and other documentation.
  • Prepare Test Plan, Test schedules and release estimates.
  • Expertise in development of test plan, test cases, test scenarios and test data based on the business rules and functional requirements.
  • Attend and update daily testing activity in the scrum meeting.
  • Participate and contribute in Sprint planning, Sprint review and retrospect.
  • Participate in QA/Dev meetings to discuss issues on current release testing.
  • Reviewed unit test plan with developers, QA manager, and team and execute entrance criteria of system testing with developer.
  • Prepared weekly status reports to the project management team that reflects the progress of testing and bug fixes.
  • Worked proactively with client to handle all issues and resolved them in a timely fashion.
  • Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
  • Managed, documented and controlled all test cases, test script and test results.
  • Managed Defect Tracking and Defect impact via Rational Clear Quest during the testing phase.
  • Review of Security policies in the SQL Server and ensuring its effective implementation
  • Maintenance of up-to-date documentation

Environment: Windows XP, UNIX, ORACLE (11g), PL/SQL, AGILE methodology, SVN.

Hire Now