Oracle Apps Resume

Oracle Apps 5+ Years experience Resume 

MADHU KARHTIK.R.                                                                      Email:**************@gmail.com                                                                                                                           Contact: 91-*********

PROFESSIONAL SUMMARY:

•Sr.Oracle Application Analyst with 5 Years of experience in Analysis, Design, Development, Testing and Implementation.
•Experience in Oracle Business IntelligenceEnterprise Edition – Presentation Layer, Development and Maintenance of Dashboards, Catalog Manager, Admin Tool, User Training, Project delivery.
•Involved in post-production support on various modulesimplemented in OBIEE 10g as below.
 o General Ledger
 o Project Resource Management
 o Account Receivables
 o Service Contracts
 o Project Contracts
•Experience in Oracle E-Business Application Support.
 o Modules: General Ledger, Service Contracts, Account Receivables, Project Contracts,  Project Resource Manager.
 o Experience in Customization / Enhancements.
 o Experience in User Training.
 o Experienced in SQL, PL/ SQL, Forms Personalization, Discoverer Reports, Alerts and Post Production Support.
•Functional skills in Project Billing, Costing, Project Resource Management, OTL (Projects), iExpenses, Sales Online.
•Experience in Project Life Cycle.
•Extensive Experience in Problem Management, Issue Management, Scheduling, Planning / Monitoring with timely and quality based delivery and closure.
•Excellent Communication Skills.
•Quick learner with Strong analytical and problem solving aptitude.
•Motivated team player with ability to work independently as well as Team management experience
•Achievements: Star Performer Award for FY 2009 – 10.

EXPERIENCE SUMMARY:

•Worked for Accenture from  june 13 to till date.
•Worked for Stone Apple Solutions(Singapore) from jan 12 to May 13
•Worked for ASM Technologies from Aug 10 to jan 12.
•Worked for TCS from Sep 08 to Jul 10.

CERTIFICATIONS:

•Oracle Certified Administrator for 10g - OCA
(Introduction to Oracle 9i SQL (2008) + Oracle Database 10g Admin 1 (2009))
•Oracle Certified Professional for 10g – OCP
(OCA + Oracle Database 10g Admin 2 (2009))
•Oracle E-Business Suite 11i Certified Professional (2009)
 (Patch, Installation, Maintenance and workflow)
•ITIL Foundation V3 (2009)

IT SKILLS:

Applications     :Oracle Applications R12/11i, Salesforce.com, Baan
Domain           : CRM – Sales & Marketing, Field Service, Install base, SCM – Inventory, Order Management, Purchasing , EDI Gateway, Finance – Fixed Assets, Accounts Payables, Account Receivables
Industry         :Communications, Products, Resources, Financial
RDBMS            :ORACLE 9i, 10G Enterprise Edition
Reporting Tools  :Developer 2000 (6i&10G), XML Publisher (BI Publisher), BI Discoverer(4i&10G)
Utilities Tools  :TOAD, SQL *Plus, SQL *Loader, FTP, Data Loader, Sql Developer
Integrations     :Oracle Apps with Servigistics, Red Prairie, Salesforce.com and third party vendors
Version Management Changeman, CA Harvest, VSS, Tortoise, Clearcase
Testing          :Mercury Quality Center, Mercury Loadrunner
Ticketing Tools  :Peregrine, BMC Incident / SR,
Scheduling Tools :Kintana, Autosys
Project Management     MPP, Custom Estimators, Time Reporting Tools – MSPS,  Plan IT

Education qualification:

M.C.A        C.S.J.M Univ.        I.E.T Kanpur                            2003-2006       69.5%
B.Sc.        C.S.J.M Univ.        V.S.S.D.college                             1998-2001    52%
Intermediate     U.P.Board        K.V.M Inter college                1996-1998    59%
High School    U.P.Board        K.V.M Inter college                1994-1996     64%


Project #1 :

Temenos India Pvt. Ltd, Chennai. may13 – Present
Sr.Business Intelligence Analyst

As Senior BI Analyst, my responsibility includes Analyzing, Designing, Developing solutions on Projects / Assignments for Modules: General Ledger , Project Resource Management , Account Receivable , Service Contracts , Project Contracts.

Currently part of OBIEE 11g implementation.

•Migrating reports from 10g to 11g
•Testing the reports in 11g.
•Organizing meetings with end users to get their requirements
•Maintenance of Catalog Manager for all the Dev Servers during the implementation.
•Performing the data comparison between 10g and 11g reports as part of testing in UAT with end users.
•Setting up of security for the shared folders
•Creating security groups in Repository based on each module that we are implementing.
•Monitoring the reports causing performance issue in “Manage Sessions”
•Handling “Manage Privileges” accordingly based on the security set for the different groups that we have created to access respective “Subject Areas”

Responsibilities as part of daily support in 10g:

•Designed Answers based on requirement in available architecture
•Developed Dashboards based on the scenarios.
•Managed Key Dashboards as super user
•Monitoring IT Helpdesk System for issues raised by end-users.
•Analyzing the issues and performing a test and provided solutions based on severity of the issue.
•Provided Object Level Security.
•Enabled Security for Groups in repository based user profile from Oracle Applications.
•Created Shared Folders in Catalog Manager.
•Managed responsibilities related to Shared Folders in Catalog Manager.
•Interaction with End Users to analyze the challenges in a better way.
•Performed Requirement Analysis based on End-Users analysis.
•Based on End-Users requirements analyzed Reports / Dashboards.
•Performed online-support for end user and helped create reports based on scenario.

Project #2:

Client            :Sony Electronics
Role            :Technical Consultant
Duration        :jan 12 to May 13
Environment        :Oracle Applications R12
Modules Involved    : AP, FA and GL            
                    
Project Details:

          Sony has grown steadily over the years to become a leader in the consumer electronics market. Today, its operations in Singapore include regional headquarters' functions, sales and marketing, engineering and manufacturing, logistics, IT, treasury services, as well as entertainment.

Responsibilities:

•Development and Customization of Reports as per the client requirement.
•Preparing master data using SQL and PL/SQL.
•Developed Inbound and Outbound interfaces.
•Worked on Data migration.
•Forms personalization’s and Customization.
•Define Concurrent program, Request sets and Executable.
•Define Menu and Sub menu.
•Developed SQL queries to obtain specific information as per requirements.
•Written stored procedures, functions and triggers using PL/SQL.
•Developed custom views and tables.
•Performed AOL activities such as creation of Value Sets.
•Preparing MD070 documentation for the customizations done.
•Preparing Unit Test Specification and Report.
•Creating patches for the developed objects.
•Giving support to developed customizations.

Project #3:
ORACLE INDIA PRIVATE LIMITED:

Project Description:
 Working as an Apps DBA in Oracle On Demand, Supporting around 550 Customers from Worldwide Consisting of Oracle Apps 11i, R12 and RAC Databases. Profile Includes Day to Day Apps and DB troubleshooting, Application Performance issues

Client        :Many customers
Duration      :Aug 10 to jan 12
Role          :Oracle Apps DBA

Contribution:   
•Upgraded Database from 10g to 11g on a test box
•Implemented Secured Socket layer (SSL)
•Configuring Private & Public Middle tiers
•Convertion of Forms Connection mode for performance tuning.
•AUTOCONFIG stabilizations and maintaining customizations
•Worked on Apache stabilizations projects.
•Implemented Parallel Concurrent Processing for On-demand RAC Customers
•Efficient in troubleshooting the issues with Apache, SSWA, forms, Concurrent Manager, and Workflow Mailer.
•Periodic Review of Customer Environments analyzing issues faced by them through Service request and giving solutions to ensure long-term stability and Higher Availability.
•Worked on Data Warehouse and Hyperion Applications.

Project #4:

Sourcing Digitization

Project :Sourcing Digitization
Client    :GE Energy Environmental Services (US, Europe, China)
Project Type:Software Digitization, Solution, Reporting and Support.
Role    :Manager, Digitization and Automation, Solution Provider
Technology/Software:Oracle Applications SCM, AP. Cognos, Oracle PL/SQL, MS Access
Duration : Sep 08 to Jul 10
       
Key Result Areas:

•Achievement: Studying additional Business requirements and justification for Software Digitizing, client negotiations and getting contract extension to 3 years from 1 year.
Solution and Quality
•Data Mining, Reporting Solution by creation of OLAP Cognos Cube for Sourcing (Part I and II) , Development of Reports using Cognos Studios in Cognos. Imparting Training on QS and Reports across globe.
•Developing Digitization and Automation Solution and Ad hoc reports from Oracle Applications ERP SCM and AP modules via Oracle backend procedures, jobs and GE SC tool. Working with SMF and Item Master.
•Performed 4 Kaizens (Lean quality projects) to generate a greater Business Impact.
•Contributing greatly to ideas and initiatives like WCRM, Blue board, trends and charts.
Development, Coding, Testing
•Providing Technical and functional support on Oracle Applications EBS SCM INV, Purchasing PO, OM and AP modules and on Cognos.
•Working with Data modeler to develop data model for package cube to be used for Cognos reporting.
•Developing Interface and Conversions for Axapta using Oracle, PL/SQL and GE SC tool.
•Creating technical documents, CF250, MD200, Business case justifications, Benefits summary for Reports.
•Reports Testing at different stages of SIT, UAT and Implementation. Verification and validation. Testing in Development Staging and Production instances.
•Digitization of Open PO Reports, Receipts reports, summaries and Spend reports, Direct and Indirect Receipts Reports, ABC Analysis Reports and many other reports.

Personal details:

Full Name               :  Madhu Karthik Ramanath
Sex            :  Male
Marital Status        :  Married
Languages Known        :  English, Hindi, and Kannada
Passport Number        :  xxxxxxx
Permanent Address    :  MADHU KARHTIK.R.
                           #336/2, 10th Main, 7th Cross,
                           Bhuvaneshwarinagar, Kattriguppe,
                           B.S.K. 3rd Stage,
                           Banglore-560085.

0 comments:

Post a Comment