Resume

Sign in

Oracle PL/SQL Developer

Location:
Jersey City, New Jersey, United States
Salary:
75000
Posted:
February 22, 2018

Contact this candidate

LAVANYA LAKKU

+1-609-***-****

ac4kog@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/lavanya-lakku-aa4243139

PROFESSIONAL SUMMARY

•Over 2+ years of experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). This includes design, development, post implementation maintenance support of Oracle EBS.

•Expertise in SQL and PL/SQL programming and strong Knowledge of Oracle Database Design.

•Trained on Oracle Application Framework and Oracle Transportation Management.

•Excellent Analytical, conceptual and root cause analysis and problem-solving skills.

•Experienced in Oracle PL/SQL Development I.e. Stored Procedures, Packages, Functions & Triggers.

•Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.

•Developed new Concurrent Programs and Oracle Pages with good knowledge of Application Object Library.

•Well versed with client server environment and tools like SQL Plus, SQL Loader, Toad, Oracle Forms & Reports, JDeveloper and customized them as per client specification.

•Experience as an Application DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.

•Good understanding of Oracle Data Dictionary, RDBMS, Normalization techniques.

•Experience with database query optimization and performance tuning using Explain Plan, TK-Prof oracle utilities.

•Developed technical design documents such as MD070 (Application extensions technical design), MD120 (Installation routines), TE020 (unit test scripts), TE070 (unit test), TE110 (system test) documents.

•Coordinated with support team to resolve issues, implement minor enhancements and creation/follow-up of Oracle service requests (SRs).

•A good team player with excellent communication and interpersonal skills, ability to work independently and well-organized.

EDUCATION

•Masters in Computer Science from University of Bridgeport – Bridgeport, Connecticut May 2017

•Bachelor in Computer & Science Engineering from JNTU - Hyderabad, India May 2012

RELEVANT COURSE WORK

OOP with Design Patterns

Data and Computer Communications

Advanced Database

Network Security

Analysis of Algorithms

Unix System Programming

Computer Communications and Network Analysis

Operating Systems

TECHINCAL SKILLS

ERP: Oracle E-Business Suite R12

Databases: Oracle 9i/10g/11g, Oracle R12

Languages: C, Java, SQL, PL/SQL, Shell scripting

Tools: Oracle Apps, Oracle Application Framework (OAF Pages), Oracle Transport Management (OTM), JDeveloper, Toad, Sql Loader, Microsoft Word, Excel, PowerPoint

Code Management: MS Team Foundation Server, Release Tool, SVN

Bug tracking system: Remedy Tool

Operating Systems: Mac OS, Windows and Linux

Certifications: Cisco CCNA Routing and Switching: Introduction to Networks

WORK EXPERIENCE

Infosys Limited Hyderabad, India

Senior Systems Engineer September 2013 to November 2015

Project #3: Migrating Oracle Transportation Management 6.3 to 6.4

Client: APL Logistics Ltd.

Duration: August 2015 – November 2015

Description:

APL Logistics Ltd. (APLL) is a freight forwarding and transportation company. As a global supply chain specialist, APL Logistics offers a comprehensive range of origin and destination services in more than 60 countries, serving the automotive, consumer, industrials, and retail verticals, as well as providing transportation as a service.

Responsibilities:

Gathered requirements and prepared High-Level Design and Detail Design.

Worked on Oracle Transportation Management project involving version migration from 6.3 to 6.4

Involved in testing OTM screens such as Automation Agent, Reports, User Configuration, User Management & Transmissions etc.

Used Informatica Power Center 8.6 for extraction, transformation and generation of xml files that were used as sample test data.

Prepared test plan, executed testing scenarios for unit and end-to-end testing.

Tested overall modified functionality and created MD120, TE070, TE110 documents using AIM Methodology.

Used MS Team Foundation Server as test case repository and bug tracking.

Keep track of execution of scripts, documentation and status reports. Involved in developing, execution, reviews, bug tracking, preparing consolidated issue logs for different phases of testing.

Establish global, standard processes for entry and maintenance of status of regulatory data.

Functional testing And Fixing bugs.

Resolving user issues/tickets and consistently maintained high SLA.

Environment: Oracle 11g, PL/SQL, SQL*LOADER, TOAD, Shell Script, OWB 11g, Informatica Power Center 8.6, Rational ClearQuest, Rational ClearCase.

Project #2: Ricoh US Oracle 11i Enhancements

Client: Ricoh US

Duration: September 2014 - July 2015

Description:

The Ricoh Company, Ltd. is a multinational imaging and electronics company. Ricoh produces electronic products, primarily cameras and office equipment such as printers, photocopiers, fax machines, offers Software as a Service (SaaS) document management solutions such as DocumentMall, RicohDocs, document solutions such as GlobalScan, Print&Share and offers Projectors. In the late 1990s through early 2000s, the company grew to become the largest copier manufacturer in the world.

Responsibilities:

Developed, Implemented and Enhanced Oracle pages using Oracle Application Framework.

Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.

The ability to understand and tune how a database interacts with a specific application.

Produce data extracts for Data Cleansing Team and data update processes to re-load cleansed data, including error checking and record logging.

Created Schema objects like Indexes, Views, and Sequences.

Integral participant in cross-functional troubleshooting of complex systems, applications and programs; deliver recommendations for solutions and improvement.

Developed Interface to load header and line values by into the created Staging Tables and performed validations using PL-SQL package into the headers and line interface tables and then to base tables.

Tested CRFs and prepared Test plans for iSupport Module- Meter Sync issues.

Involved in Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff and provided post-production support.

Tested the data and data integrity among sources and targets using Unit Testing, UAT.

Associated with Production support team in various performances related issues.

Used debugger to test the data flow between source and target and to fix the invalid mappings.

Environment: Microsoft Windows 2014 Server, SQL, MySQL, ERP systems, T-SQL, Microsoft Reporting Service, MS Visio.

Project #1: Migration of Customer Contacts from Oracle 11i to R12 upgrade for Ricoh US

Client: Ricoh US

Duration: September 2013 – August 2014

Description:

The Ricoh Company, Ltd. is a Japanese multinational imaging and electronics company. Ricoh produces electronic products, primarily cameras and office equipment such as printers, photocopiers, fax machines, offers Software as a Service (SaaS) document management solutions such as DocumentMall, RicohDocs, document solutions such as GlobalScan, Print&Share and offers Projectors. In the late 1990s through early 2000s, the company grew to become the largest copier manufacturer in the world.

Responsibilities:

Gathered requirements and prepared High-Level Design and Detail Design.

Modified reports, forms, views, triggers, packages, procedures, functions, workflows, Personalization’s and configuration.

Developed PLSQL code sources for data migration from Oracle 11g database to Oracle R12 database.

Created new value sets, concurrent programs, registering reports and PL/SQL procedures and functions

Tested overall modified functionality and created MD120, TE070, TE110 documents using AIM Methodology.

Import data across multiple instances using BULK INSERT.

Hands-on experience in Performance Tuning and Index Tuning.

Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.

Wrote complex SQL queries using Joins, Sub queries and Group functions

Used Team Foundation Server as revision control tool to maintain the code and documents repository & BMC Remedy Action Request System for bug tracking.

Involved in Go-Live activities and Post Production Support.

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Created Materialized Views for performance reasons.

Used debugger to test the data flow between source and target and to fix the invalid procedures and functions.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.

Environment: Oracle 10g, SQL, PL/SQL, TOAD 9.5, UNIX, Microsoft Visio, SQR, Oracle Forms 9i/10g/11g, Erwin Data Modeler 7.2.



Contact this candidate