Post Job Free

Resume

Sign in

Data Oracle

Location:
Bengaluru, KA, 560001, India
Posted:
May 16, 2016

Contact this candidate

Resume:

Kadiyala Yamini Bharathi acust5@r.postjobfree.com

+919*********

Objective:

Work in a challenging environment and effectively utilize my skills towards the growth of the organization and eventually rise to a position of major responsibility through continuous learning.

PROFESSIONAL SUMMARY:

6 Years of experience in IT.

Oracle India Pvt. Ltd. – Application Developer ( 12th July 2012 to Present )

TCS, Hyderabad – System Engineer (30th Nov 2009 to 07th July 2012)

Result oriented professional with 3.6+ Years of experience in Oracle technologies.

Experience in implementation, support of Oracle E-Business Suite R12 of modules like Accounts Payable (AP), PAYMENTS (IBY), Accounts Receivables (AR).

Experience in development and customization using Oracle Forms 6i, Reports 6i, Form Personalization, Oracle API’s, Oracle Application Framework (OAF).

Good understanding of Procure to pay cycle.

Strong knowledge in AP-PAYMENTS, IBY PAYMENTS

Excellent technical skills working on PL/SQL, Java, Data Migration (Interface/ Conversions/APIs), and RICE Components.

Good Analytical and problem solving skills.

Willingness to learn, team facilitator and hard worker.

TECHNICAL SKILLS:

Application Development Tools

Oracle Forms, Oracle Reports, Oracle Application Framework

Application Package

Oracle Applications EBS R12

Databases / DB Tools

Oracle 9i/10g, TOAD, SQL*Plus, SQL Developer

Programming Languages

SQL, PL/SQL, Core Java, Servlets, JSP, Unix

Desktop Tools

MS Office suite 2003 and 2007

Operating Systems

Windows NT, Windows 98/2000/XP/Vista/7

Projects:

(1)

Company

Oracle India Pvt. Ltd.

Project Type

Development and Maintenance

Technologies

Oracle eBusiness Suite, PL/SQL

Platform

Windows XP / Seven, Unix

Duration

From July’12 to Present

Oracle Account Payables is a module in E-Business Suite Financials, which helps to carry out end-to-end business needs allowing users to create detailed, auditable, reconcilable accounting information. Account Payables includes key areas like Supplier setup & usage information, Invoice/Supplier Open interface, Invoice Workbench, Payment Workbench, Prepayments, AWT, PO matched invoices, Invoice and Payment Accounting, Cash basis accounting, AP trial balance, Period close, Reconciliation with GL .

Part of the development team of Accounts Payable, which is responsible for the development of new releases and enhancement and maintenance of existing releases. The project deals with fixing the data and code issues raised by account Payables customers worldwide; enhancing existing features/adding new features to the product and worked on issues related to the code/data/upgrade/implementation/integration of 11i and R12 Accounts Payable.

Responsibilities:

Worked on PAYMENTS which deals with PPR and payment workbench. PPR has been coded on Oracle Applications Framework (OAF). Payment workbench has been code on Oracle forms.

Worked on different BC4J Components for OAF customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).

Worked on OAF pages which includes simple search, advanced search, PPR (partial page rendering).

Worked on Release 12 product maintenance and builds enhancements for Oracle Payables module.

Handled issues for critical Customer issues like Amazon, Alcoa, Cisco and Amex to resolve show-stopper issues like PPR, payment workbench and IBY related issues and delivered solutions in less than 24 hours.

Handled Priority 1 (P1) issues where solution had to be provided in limited timeline.

Was responsible for identifying, analyzing, troubleshooting and resolving technical problems with Oracle applications by setting up Oracle test cases in replicated environments, analyzing data setups, modifying the code and data as per Customer needs, creating patches with code fixes and generic data fixes, and creating workaround solutions according to Oracle methodologies.

Fixed critical and complex code fixes in AP Payments area.

Worked closely with managers to prepare monthly reports on bug inflow.

Triaged inflow of bugs in the AP Payments area and successfully maintained the backlog to optimum level.

Developed generic data fix (GDF) scripts to identify and fix all the transactions having similar data corruption pattern which helps to fix all the transactions at one attempt and thereby reduced the number of bugs logged for similar issue.

Analyzed the code to find the root cause for data corruption while triaging data fix bugs and then fixed the code by doing root cause analysis (RCA).

Mentored new Engineers in the team.

Environment: Oracle E-Business Suite R12, Oracle SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, Oracle Application Framework (OAF), UNIX.

(2)

Project

Tata Teleservice ltd (TTSL)

Company

TCS (Tata Consultancy Service)

Project Type

Development and Support

Technologies

PL/SQL, core java, Servlets, jsp

Platform

Windows XP / Seven, Unix

Duration

From Nov’09 to July’12

I worked for WDS (Wireless data services) team. Team handles online and offline billing for wireless networks. The devices for which we do billing are CDMA products like Tata whiz, Tata photon, CDMA Mobiles. Overall our team involves in data usage charging like 2G and 3G services. We receive huge number of IPDR’s (Internet Process Data Record) and INDR’s (Intelligent Network Data Record) in the form of flat files. We have used technologies like UNIX, Java, and PL/SQL to load these flat files data into tables and follow the business logic to bill the data.

In short, using SQLOADER concept we load IPDRS and INDRS multiple tables. These tables have PL/SQL triggers to get there required information and to just consider the required fields from IPDR’s and INDR’s. Here the actual business logic starts and there we use Java coding to billing.

Our team also implements CVMS (Content Vendor Management Settlement) in which TTSL settles revenue share for service providers (3rd party vendors). 3rd party vendors provide few VAS services to TTSL customers. Based on business logic, we developed reports to calculate share of 3rd party vendors. These reports are sent to business on daily, weekly and monthly basis. The logic and conditions varies for different vendors.

The data of IPDR’s are INDR’s file counts are huge. We implemented multiple thread concepts where ever possible for better performance. And DB storage, performance issues and backup data all are considered.

Implemented API’s which shows voice calls, SMS, CRBT and VAS services for a particular MDN using Servlets and basic struts concepts. It is useful for customer care agents.

Responsibilities:

Involved in Requirements Gathering, Meetings with business, Analysis, Design, Development, Unit testing and UAT (User Acceptance Testing), Production movements, Post-production support.

Development and Maintenance of Code, Procedures, Functions, Unix Scripts, API’s.

Prepared and executed Unit Test Cases.

Involved in UAT, where user creates data traffic through mobile devices. And will check whether data usage and traffic reaching our systems properly or not. And data usage, accumulation and tariff calculation happening correctly or not for services like CRBT, VAS, Blackberry etc.

Involved in migrations from ALCATEL lucent chains to telecordia implementation.

Well verse with POOLS/BUCKETS used in telecom domain. And the offers concept and how it works at IN (Intelligent Network)

Developed technical documentation.

Environment: Oracle SQL, PL/SQL, JSP/Servlets, Core Java, UNIX.

Appreciation: Got appreciation multiple times from clients. Based on which TCS gave Gems as token of appreciation.

Education:

Degree/standard

Accreditation/board

Institution/school

Year

Percentage

MCA

Sri Padmavathi Mahila University

Sri Padmavathi Mahila University

2006-2009

69%

BSc

Sri Venkateswara university

Sri krishnachaitanya degree college

2003-2006

74%

Intermediate

Board of intermediate education

Sri shanthinikethan

Junior college

2001-2003

84.8%

SSC

Board of secondary education

Sri kasturi devi girls high school

2000-2001

83.3%

Personal Details

Father’s Name: Mr. Kadiyala Venkata Janardhana Rao

Date of Birth: 05th June 1985

Address: Hyderabad

Passport: Valid Until 2018

Certifications: I have done OCA certification

Went to Oracle Headquarters California USA, on L1B visa and stayed there for 6 months.

Yamini Bharathi



Contact this candidate