Technology Analyst Oracle

RENJITH RAVI

Mobile : +61-469-***-***

Email : **********@*****.***

Visa : Australian Permanent Resident

An Oracle Apps PL/SQL developer having 7 years and 10 months of experience with IT sector and working experience in PL/SQL codes - Package, procedures, functions, Oracle reports, BI Publisher, forms and unix shell scripting.

Experience working with MS SQL, SQL Server 2012, SSRS.

Possess active working knowledge of Oracle EBS Accounts Receivable, Oracle EBS Order Management, Oracle EBS Purchasing modules for serving various clients in my career.

Exposed to different tools viz., Oracle Report Builder, Oracle Forms Builder, TOAD, HP Project and Portfolio Management Workbench, HP Quality Centre, PVCS, BI Publisher, Putty, SQL Loader, $U, WINSCP, VSS, SQL Server Management Studio 2012.

Experience in Oracle Application development on 11i and R12 Platform.

Extensive technology knowledge; keen client needs assessment aptitude; client focused approach that fosters trust and allegiance; highly trustworthy, ethical and discreet.

Possess valuable insights, keen analysis and a team approach to implement best practices to achieve business excellence.

Eager to contribute in a team-oriented environment having inner desire to gel and work for business growth.

CORE STRENGTHS

Application Development

Logical & Analytical Skills

Requirement Gathering & Analysis

Quick Learner

Team Player

TECHNICAL SUMMARY

Technologies

Oracle SQL,PL/SQL, Oracle e-Business Suite 11i, Oracle e-Business Suite R12, Interface, Extensions, Unix shell scripting, MS SQL Server 2012, T-SQL

Tools

TOAD, Kintana, SSH Secure Shell, Oracle Report Builder 6i/11g, Oracle Forms Builder 11g, Project and Portfolio Management Workbench, HP Quality Centre, PVCS, BI Publisher, Putty, WINSCP, $U, SQL Server Data Tools (SSRS)

CAREER HIGHLIGHTS

Technology Analyst in Infosys Ltd. From 11th June 2007 till 21st April 2015

6 months of working experience in SYDNEY, Australia for Westpac client.

Key Deliverables & Contributions:

To gather and analyze the requirements from Functional Team and to create the technical detail design documents in a manner to give an overall view of the approach to the solution.

To develop interfaces, reports based on the solution in the design document signed off by functional team.

To prepare Unit test plans, test the module and document the same.

To performance tune the packages for better performance and work on the defect fixes and change requests.

Conduct Knowledge Transfer sessions for the new resources.

Mentor the team members with the technical changes in PL/SQL interface packages and reports.

To prepare SSRS reports from the historical data available in the database based on each use cases.

PROJECTS UNDERTAKEN

Project Name : Archival and Retrieval

Client : Westpac

Location : Sydney

Environment : SQL Server 2012

Duration : 6 Months

Team Size : 5

Platform Used : Windows 7

Technology /

Tools Used : SQL Server 2012, SQL Server Data Tools, SSRS

Description : Lloyds Archival and Retrieval (A & R) project is a subset of the Lloyds Integration program which is endeavored to merge the CFAL business into WBC, by migrating open accounts related data from Key CFAL system into WBC operating systems. A & R project provides a platform for Archival of historical/current CFAL production systems data to Near-Line Archive/backup tapes in WBC environment and the Retrieval (WBC Retrieval and Reporting Solution) to enable WBC IT retrieval team to access and retrieve the archived CFAL data to meet LBG retrieval requirements which can be consumed further by WBC regulatory, compliance, audit and legal business.

Responsibility:

Requirements gathering and Analysis.

Design approach and creation of Detailed Technical Design.

Working on project SSRS build and unit testing based on different use cases.

Mentoring and working with the team for solutions on technical requirement and development.

Providing better solution and approach for SSRS build.

Project Name : Cisco GTC Tax

Client : Cisco

Location : Hyderabad, India

Environment : Oracle Apps R12 and 11i

Duration : 24 Months

Team Size : 11

Platform Used : Windows 7

Technology /

Tools Used : Oracle Apps 11i/R12, PL/SQL, Advanced PL/SQL, XML Publisher, TOAD, PVCS, SSH Secure Shell, Project and Portfolio Management Workbench, HP Quality Centre

Requirement : As part of different releases, Brazil/UK/US/Australia was enabled as a separate Buy/Sell Entity, to migrate their present 11i system to upgraded R12 version within a single consolidate package, along with some implementations in interfaces, reports track and defect fixes in the present 11i system. This is an extensive development and upgrade project based on the Financial (AR mainly) modules of Oracle.

Responsibility:

Requirement Gathering and High Level Design

A thorough analysis of Brazilian/UK/Australia/US taxes and manual invoice creation.

Designing packages, functions, procedures for determining the required fields for tax calculation while auto-invoice run.

Designing of adapter packages, functions, procedures for pre-calculation and post-calculation of tax attributes from Sabrix.

Migration and re-engineering the core packages to R12 from 11i system for various releases like UK, US, Australia.

Performance tuning using tkprof, explain plan

Preparation of Technical Specification Documents based on the functional specifications provided by clients of the identified requests.

Finding a solution to decrease the complexity of existing business process.

Upgrade and testing of 6i reports and Database objects and Concurrent Programs.

Unit testing/regression testing for the components.

Thorough regression testing to ensure that changes don’t impact the existing functionalities.

Provide Major/Minor Production Bug fixes as part of Monthly/Quarterly Releases.

Involved in creation of Reports, data migration and upgrading coding requirements.

Checking in and checking out of files from PVCS (Version Controller)

Creation of Kintana Packages for migration.

Creation of $U jobs for scheduling concurrent programs.

Knowledge Transfer session to other Vendors.

Played the role of Defect Prevention Anchor of the team and submitting the defect reports to the team repository.

Project Name : Ricoh R2.2

Client : Ricoh Company, Ltd

Location : Hyderabad, India

Environment : Oracle Apps R12 and 11i

Duration : 36 Months

Team Size : 19

Platform Used : Windows 7

Technology /

Tools Used : Oracle Apps 11i/R12, PL/SQL, Advanced PL/SQL, XML Publisher, TOAD, PVCS, SSH Secure Shell, Oracle Report Builder 11g, Oracle Forms Builder 11g, Project and Portfolio Management Workbench, HP Quality Centre

Requirement : As part of Ricoh R2.2 release custom order management interface was created to interface orders in Oracle created from Siebel application through IBM websphere middleware. BI Publisher reports from purchasing form to showcase the requisition details. Forms personalization, custom.pll and form changes in the requisition form to build custom forms. Oracle reports 6i report change request to include multi organization. Performance tuning and defect fixing the Oracle reports and the order management interface as part of production support.

Responsibility:

Requirement Gathering and High Level Design with the functional consultants and the client.

Preparation of Technical Specification Documents based on the functional specifications provided by clients of the identified requests.

Developing BI publisher reports, oracle 6i reports, PL/SQL coding as part of change requests on Oracle Order Management interface, forms personalization, custom.pll, Form builder on the requisition forms, basic shell scripting.

Resolving defects for technical issues in Oracle reports, Oracle interface

VSS Configuration controller for the team to manage users and permission to the project repository.

Project Name : IKON CS

Client : IKON Office Solutions

Location : Hyderabad, India

Environment : Oracle Apps 11i

Duration : 22 Months

Team Size : 19

Platform Used : Windows 7

Technology / : Oracle Apps 11i/R12, PL/SQL, Advanced PL/SQL, XML Publisher, TOAD, PVCS, SSH Secure Shell,

Tools Used 10g, Project and Portfolio Management Workbench, HP Quality Centre

Requirement : As part of IKON CS solution CRM modules had to be upgraded to R12 from 11i, and hence delta changes documentation needs to be prepared for modules like email center, contact center, service contracts. Study the attributes in 11i and how they are different from R12 was the major analysis work involved.

Responsibility:

Delta changes documentation for CRM modules.

Technical document development of the project and communications with onsite on the scope and effectiveness of the scripts and reports to be developed.

Resolving technical defects with the current 11i system which was available in production.

AWARDS

Won the “Most valuable employee” for the quarter Q214

Spot award for the quarter Q113

ACADEMIC QUALIFICATIONS

B. Tech in Computer Science from Jawaharlal Nehru Technological University, with an aggregate of 73.7%.

Passed Higher Secondary Education with 91.1%.

Passed Secondary Education with 84.3%.

REFERRALS

Karthik Madhu Prasad, Project Manager at Infosys Technologies Limited, Sydney

Contact: +61-404-***-***

Rajesh Bafna, Project Manager at Infosys Technologies Limited, CA, USA

Contact: 408-***-****

Contact this candidate