Rajesh Killamsetti

Rajesh Kumar K Mobile: +91-9611269419
Sr.Software Engineer Email: krkumar.oracle@gmail.com(Pref)
Rajesh.killamsetti@ennvee.net ________________________________________

Objective:

Looking forward for an opportunity in a challenging environment, where I can utilize my experience and skills in contribution effectively to the success of the organization and also for the improvement of my personal skills.

Professional Experience:

• Over 5 years of experience in Oracle Applications and Worked extensively in Development, Enhancement projects of Oracle Apps R12 and 11i.
• Technically having very good experience to develop the RICE Components and as well as customization in different Components.
• Exposed towards Oracle apps modules PO, INV, OM, AP, AR, GL Modules.
• Involved in Design and Development of XML/BI Publisher Reports in Oracle applications
as per client requirement as well as Customization.
• Worked on Inbound and Outbound Interfaces to load the data from legacy system to
Release 11i&R12 using PL/SQL, SQL* Loader and UTL_FILE package.
• Proficient in Oracle Technologies like SQL, PL/SQL and Developer Reports 10g/6i.
• Had good exposure in Conversions in SCM and Financial modules.
• Proficient in writing stored procedures, Packages and functions using SQL & PL/SQL
• Code review and testing and fixing the problems.
• Provided instant solutions to issues which were reported in the production instance.
• Well versed with Oracle Alerts development.
• Strong knowledge in Application Object Library (AOL) module.
• Preparing Technical Documents Like MD’S.
• Knowledge of functional (INV,PO & OM) modules.
• Knowledge of Workflows and AME.
Technical Skills:
Oracle Applications Oracle Applications R12(12.1.1.)/11i (11.5.9, 11.5.10.2)
RDBMS ORACLE 8.x, 9.x Enterprise Edition
Reporting Tools Developer 2000(6i&10G),XML Publisher(10G)
Other Tools Winscp, Putty, Snippy ,Snow, BMC, VPN Client And Rolta
Utilities Tools TOAD, SQL *Plus, SQL *Loader, FTP, Data Loader,Sql Developer
Operating System Windows NT 4.0/95/98/2000/XP,
DBMS Packages Oracle 9i/10g.



Experience Details:

 Currently Working as a Sr.Software Engineer at EnnVee Solutions Pvt Ltd in Bangalore, Mar 2015 to Till Date.
 Worked as Oracle Apps Technical Consultant at Herbalife International Pvt Ltd in Bangalore, July 2012 to Mar 2015.
 Worked as Mphasis on HP, Transaction Processing Officer Bangalore from Aug 2010 to July 2012.
Project 3 #

Client NEC, UK
Project type Development and Production Support
Organization EnnVee Solutions Pvt Ltd, Bangalore
Duration Mar 2015 to Till Date
Modules PO,INV,OM,AR,AP,GL & AME
Environment Oracle Applications R12, XML/BI Publisher Reports, TOAD, WinSCP, workflow & shell script, Oracle 10G, PL/SQL, Inbound and Outbound Interfaces
Role Sr.Software Engineer
Team Size 8
Client Description National Express LLC (NELLC) is a leading provider of student transportation, committed to getting students to school safely, on time and ready to learn. NELLC is the North American subsidiary of National Express Group, one of the premier transportation firms in the United Kingdom. According to the National School Transportation Association and the School Bus Information Council, school buses are the safest form of transportation to and from school.

Responsibilities:

• Development of Reports as per the Client requirement.
• Development of Interface programs as per the Client requirement.
• Doing feasibility analysis and preparing technical design documents MD-070
• Created staging tables in Oracle Applications
• Development of XML Reports.
• Used SQL*Loader to get the data from legacy system and loaded into staging tables.
• Unit Testing and System Testing. Involved in Production Support using BMC and SNOW.
• Developed oracle apps alerts.
• Preparing Technical Designing Documents.
• Development of Developer Reports.
• Customization of Existing Reports.
• Developing New Conversions & Interfaces.


Project 2 #

Client IFRS Turkey - HerbaLife International Pvt Ltd
Project type Development and Production Support
Organization HerbaLife, Bangalore
Duration Nov 2013 to Mar 2015
Modules PO,INV,OM,GL & Alerts
Environment Oracle Applications R12, XML Publisher, TOAD, WinSCP, Putty SNOW BMC, Oracle 10G, PL/SQL
Role Oracle Apps Developer
Team Size 12
Client Description Herbalife International is a multi-level marketing company that sells nutrition, weight management and skin-care products. The company was founded in 1980, The company distributes its products in 87 countries through a network of approximately 2.7 million independent distributors
Contribution: As a team member was responsible for

Responsibilities:
• Development of Reports as per the Client requirement.
• Development of Interface programs as per the Client requirement.
• Doing feasibility analysis and preparing technical design documents MD-070
• Created staging tables in Oracle Applications.
• Development of XML Reports.
• Used SQL*Loader to get the data from legacy system and loaded into staging tables.
• Created various PL/SQL procedures/packages according to the Client requirements.
• Provided instant solutions to issues which were reported in the production instance.
• Unit Testing and System Testing. Involved in Production Support using BMC and SNOW.
Project 1 #

Client HL Pickup Access Points – Spencer and More Stores
Project type Oracle Applications R12 Implementation & Production Support
Organization HerbaLife, Bangalore
Duration July 2012 to Oct 2013
Modules AP,AR,GL, PO,INV,OM,GL
Environment Oracle Applications R12, XML Publisher, Discoverer TOAD,WinSCP,PVCS,Oracle 10G, PL/SQL
Role Technical Consultant
Team Size 9
Client Description Herbalife International is a multi-level marketing company that sells nutrition, weight management and skin-care products. The company was founded in 1980, The company distributes its products in 87 countries through a network of approximately 2.7 million independent distributors

Responsibilities:
• Development and Customization of Developer Reports.
• Involved in development of Conversions in GL Module
• Development of XML Publisher Reports in AP, INV module.
• Involved in Form Personalization
• Involved in conversions through Data loader (Professional).
• Involved in preparing documents as per standards.
• Code review and testing and fixing the problems.
• Provided instant solutions to issues which were reported in the production instance.
Other Experience:

Client SCHWAB – USA
Project type US Stock Market
Organization Mphasis on HP, Bangalore
Duration Aug 2010 to August 2011
Role US Stock Market
Team Size 30

Job Profile:

• Experienced in processing Versus Purchase and calculating the Cost Basis for Mutual Funds, Equities & Fixed Incomes based on Corporate actions (SMR, CSMR, CMR, Spin-off, Call & Put Options, Redemptions, Exchange, Name Change, Reorganization, Forward and Reverse Split)
• Processing (Reconciling) the Accounts of US investors (US Stock Market) through online applications.
• Analysation of Investor reports of US Stock Market by researching the Xitek and updating the Cost basis up to date in their accounts.
• Processing (Reconciling) the Accounts of US investors (US Stock Market) through online applications.
• Preparation of Realized and Unrealized Gain/Loss reports to the investors for their Tax Purpose.
• Preparation of daily MIS to the Client Management, which includes daily productivity details, Quality Scores, Error Reports and other consolidated reports.
Personal Profile
Name : Rajesh Kumar Killamsetti
Nationality : Indian
Languages Known : English, Telugu.

I assure that the above furnished details are true and original as per my Knowledge.

Rajesh Kumar Killamsetti