Ramakrishna Muvva CV
Ramakrishna Muvva CV
Ramakrishna Muvva CV
Email: [email protected]
Mobile: +91 - 7799133233
SUMMARY PROFILE
11+ years of Experience in Oracle Applications 11i, R12 – as an Oracle Apps
Technical consultant and Technical lead.
Work Experience across the Oracle HR&Payroll, General Ledger, Payables,
Receivables, Purchasing, Inventory and self-service modules.
Hands on experience in supporting Oracle Financial modules like AP, AR, GL,
Payroll, FA, PO and Inventory.
Work Experience in Analysis, Design, Development, Customization and Trouble
shooting of SQL, PL/SQL, 10gReports, 10gForms, OAF
Involved in Business requirement gathering, Technical design, Development and
post Go-live support of Custom Applications within and interacting with Oracle E-Biz Suit.
Experience in trouble shooting post implementation issues in Oracle R12 in
AP,GL,PO,HR Self service, Check, EFT printing and PO modules
Work Experience in Configuring Mass data upload tools like Data Loader and SQL
Loader
Well versed in Support tools like SVN version control tools.
Worked on XML publisher reports.
Expert on reconciliation of transaction accounts.
OCA (Oracle PL/SQL Developer Certified Associate) and OCP (Oracle
Advanced PL/SQL Developer Certified Professional) certified holder.
Oracle form personalization according to client requirements.
Leadership – Experience in leading teams of various size in Oracle Apps FMS, HR
&Payroll space in various business engagement at onsite.
Mentoring – Able to mentor the new comers to the project in Oracle applications
as well as Client’s business, Technology Environment.
PROFESSIONAL EXPERIENCE
TECHNICAL SUMMARY
PROJECT HIGHLIGHTS
Project #1
Project : Non-Banking Financial Regulatory Authority
Client : Non-Banking Financial Regulatory Authority, Botswana
Duration : Jul 2015 - till date
Module : HCM, Payroll, AP, GL, AR, Inventory, Purchasing, FA
Technologies : SQL, PL/SQL, JDeveloper (10g),
Reports, BI Publisher, Workflow builder, Oracle 10g
Role : Technical Lead
Tools : Pl/SQL Developer, BI Publisher
Executed at : Non-Banking Financial Regulatory Authority
Description:
The project was to implement and support Oracle R12 for the client’s
business needs. This involves configuring Oracle Setups, Data migration carrying out the
customizations and enhancement request, post go live support and documentation.
Roles & Responsibilities:
Involved in Analysis, design, development, Integration testing and implementation of
RICE components (SQL, PL SQL, Forms, Reports, Workflow and BI Publisher).
Business mapping, addressing the setup, technical development in the modules AP,GL
AR,FA, HR & Payroll, Projects ,Properties.
Addressing the business critical production issues arising out of Oracle Apps Financial &
HR-Payroll modules.
Developing, customization of Web Forms (OAF), Reports and alerts, Interfaces.
Reporting the summary of all issues, CRs on a weekly basis to the IT Manager
Leading the 6 member Oracle Apps Technical Team from people management aspects
to providing technical guidance on the day to day work
Project #2
Project : DTCB
Client : Diamond Trading Company of Botswana, Botswana
Duration : Jul 2013 – Jun 2014
Module : HCM, Payroll, AP, GL, AR, Inventory, Purchasing, FA
Technologies : SQL, PL/SQL, JDeveloper (10g),
Reports, BI Publisher, Workflow builder, Oracle 10g
Role : Technical Lead
Tools : Pl/SQL Developer, BI Publisher
Location : Botswana
Executed at : Diamond Trading Company
Description:
The project was to implement and support Oracle R12 for the client’s
business needs. This involves configuring Oracle Setups, Data migration carrying out the
customizations and enhancement request, post go live support and documentation.
Roles & Responsibilities:
Involved in Analysis, design, development, Integration testing and implementation of
RICE components (SQL, PL SQL, Forms, Reports, Workflow and BI Publisher).
Business mapping, addressing the setup, technical development in the modules AP,GL
AR,FA, HR & Payroll, Projects ,Properties.
Addressing the business critical production issues arising out of Oracle Apps Financial &
HR-Payroll modules.
Developing, customization of Web Forms (OAF), Reports and alerts, Interfaces.
Reporting the summary of all issues, CRs on a weekly basis to the IT Manager
Leading the 6 member Oracle Apps Technical Team from people management aspects
to providing technical guidance on the day to day work
Project #3
Project : Botswana Hosing Corporation
Client : Botswana Housing Corporation (BHC), Botswana
Duration : Jan2013 – Jun-13
Module : AP, GL, AR, Inventory, Purchasing, FA, HR&Payroll
Technologies : SQL, PL/SQL, JDeveloper (10g 10.1.3.3.0),
Reports, BI Publisher, Workflow builder, Oracle 10g
Role : Technical Lead
Tools : Pl/SQL Developer, BI Publisher
Executed at : Botswana Hosing Corporation
Description:
The project was to implement and support Oracle R12 for the client’s
business needs. This involves configuring Oracle Setups, Data migration, Integration with GTS
Properties, carrying out the customizations and enhancement request, post go live support and
documentation.
Roles & Responsibilities:
Involved in Analysis, design, development, Integration testing and implementation of
RICE components (SQL, PL SQL, Forms, Reports, Workflow, BI Publisher and UNIX
scripting).
Business mapping, addressing the setup, technical development in the modules AP,GL
AR,FA, HR&Payroll, Projects ,Properties.
Addressing the business critical production issues arising out of Oracle Apps Financial,
SCM and HR-Payroll modules.
Developing adhoc, scheduled reports using SQL/PL SQL, Oracle Reports builder for the
quick needs of the higher managements regularly.
Developing, customization of Web Forms (OAF), Reports and alerts, Interfaces.
Reporting the summary of all issues, CRs on a weekly basis to the IT Manager
Leading the 8 member Oracle Apps Technical Team from people management aspects
to providing technical guidance on the day to day work
Project #4
Project : University of Botswana
Client : University of Botswana (UB), Botswana
Module : AP, GL, AR, Inventory, Purchasing, FA, HR &Payroll and Custom
Modules of VFMS and ESM.
Technologies : SQL, PL/SQL, JDeveloper, Reports, Oracle 10g, BI Publisher
Role : Technical Lead
Duration : Jan 2012 – Dec2012
Tools : Pl/SQL Developer, BI Publisher, Oracle Workflow Builder 2.5
Location : Botswana
Description:
The project was to implement and support Oracle R12 for the client’s
business needs. This involves configuring Oracle Setups, Data migration, Integration with
PeopleSoft, carrying out the customizations and enhancement request, post go live support and
documentation.
Roles & Responsibilities:
Business mapping, addressing the setup, technical development in the modules AP,GL
AR,FA, HR &Payroll.
Addressing the business critical production issues arising out of Oracle Apps Financial &
Hr-Payroll modules.
Developing Scheduled reports using SQL/PL SQL, Oracle Reports builder for the quick
needs of the higher managements.
Developing, customization of Web Forms (OAF), Reports and alerts, Interfaces.
PeopleSoft Campus Solutions 9.0 to EBS Financials (General Ledger) Integration(Using
BPEL)
Reporting the summary of all issues
Leading the 8 member Oracle Apps Technical Team from people management aspects
to providing technical guidance on the day to day work
Project #5
Project : Botswana Life Insurance Limited
Client : Botswana Life Insurance Limited (BLIL), Botswana
Module : AP, GL, AR, Inventory, Purchasing
Technologies : SQL, PL/SQL, Forms, Reports, BI Publisher, Oracle 10g
Role : Senior Technical consultant
Duration : Jun2010 – Dec2011
ERP : Oracle R12 (12.1.3) and 11.5.10.2
Tools : Pl/SQL Developer, BI Publisher
Location : Botswana
Description:
The project was to migrate all the CEMLI objects from 11.5.10.2 to 12.1.3
and support the post go live issues as per the client’s business needs. This involves identifying
the affected (changed / added/ removed) Tables, views and other DB objects and carrying out
the customizations and making sure that the migrated RICE components work without any
issues as it used to be in 11.5.10 by ensuring comprehensive testing.
Roles & Responsibilities:
Senior Technical Developer for PL/SQL interface, Reports, Forms personalization and
Alerts ,Interface developments
11i Support Activity on call basis.
Leading the team of 5 junior developer in the development activities, requirement
gathering.
Involved in identifying the structural changes in DB objects between 11i and R12 and
mapping the DB columns as per the new table structure.
Involved in Assessment & Retro fitment phase of the R12 migration strategy for
Inventory, PO , OM modules
Check printing using BI-E-text template
EFT File Generation using BI-E-text template
Upgrading the CEMLI objects from 11.5.10.2 to R 12.1.3 for the OM, PO, Inventory
modules and deploying the same for unit, functional testing
Involved in preparing the training documents
Integrating with third party Life system Insurance Application, Acquire Loan system.
Project #6
Project : Local Enterprise Authority
Client : Local Enterprise Authority, Botswana
Module : AP, GL, AR, FA, HR&Payroll
Technologies : SQL, PL/SQL, Forms, Reports, BI Publisher, Oracle 10g
Role : Senior Technical Consultant
Duration : Jun2009 – Jun2010
ERP : Oracle R12 (12.1.3)
Tools : Pl/SQL Developer, Data loader
Location : Gaborone
Team size : 15
Executed at : Software Application and Information Solutions (SAiS).
Description:
The project was to implement and support Oracle R12 for the client’s
business needs. This involves configuring Oracle Setups, Data migration, carrying out the
customizations and enhancement request, post go live support and documentation
Responsibilities:
Member of the Technical team for the R12 implementation, customizations.
Involved in development and addressing technical issues, debugging the technical
components
involved in requirement gathering, business mapping stages for AP, GL, Purchasing
Involved in trouble shooting the functional issues and providing post go live support for
the SCM (AP, GL, AR, Purchasing, Inventory, HR&Payroll) modules in R 12.1.1
Assessed the customization efforts (Reports, Interfaces, Conversions, and Extensions),
identified the AIM deliverables
Wrote customised interfaces in Payroll for third party payments, EFT Payments (Bank
Transfers), Cash Management, Payslip (Bulk printing using pre-printed stationery,
through employee self-service)
Wrote Customised interface in AP,GL,PO, FA, Payroll Element creation
R12 bulk Check printing using BI Publisher- E text template
EFT Generation using BI Publisher - E text template
Developed Custom applications like HR Recruitment module, PMS module
Executing Integration test cases, migrating development components to UAT and
Production using ITG (Change Control tool) Mercury tool.
Involved in preparing the training documents
Project #7
Project : National Development Bank
Client : National Development Bank (NDB)
Modules : AP, GL, AR, HR& Payroll
Technologies : SQL, PL/SQL, Forms 6i, Reports 6i, Oracle Alerts
Role : Technical Consultant
Duration : Jan2008 – Jun2008
ERP : Oracle 11i (11.5.10)
Database : Oracle 8i/9i
Tools : Pl/SQL Developer
Location : Gaborone
Executed at : National Development Bank
Description:
The project was to support client’s Oracle ERP systems as well as
executing new enhancements in the form of projects. This involves supporting seeded Oracle
modules, troubleshooting technical, functional issues and supporting client’s custom modules
and interfaces.
Roles & Responsibilities:
Supporting interface between Oracle Applications (Payables, Receivables) with Legacy
system (Bank master)
Supporting and maintenance of Oracle modules viz. General Ledger, Payables,
Receivables, Cash Management, Fixed Assets, Loans, Purchasing, HRMS & Payroll.
Bespoke development including customization of new forms, reports, custom.pll,
packages and procedures.
Involved in addressing technical issues, debugging the technical components
Involved in Month end, Quarter End, Yearend closure support processes from Oracle
Operations side (like inventory period closure, clearing, reprocessing error transactions
from all interface tables etc.
Involved in trouble shooting the functional issues and providing production support for
the Oracle Financial and HR Payroll modules.
Involved in Analysis, design, development, Integration testing and implementation of
RICE components (SQL, PL SQL, Forms, Reports, Workflow, BI Publisher, UNIX scripting.
Involved in interacting with business users, BPEs and translating the business needs into
functional specifications, detailed technical plan and comprehensive test case scenarios.
Involved in understanding, documenting the client’s business practices and ERP system
architecture and dependencies on various non-ERP applications and interfaces.
Project #8
Project : Botswana Meat Commission
Client : Botswana Meat Commission (BMC)
Modules : AP, GL, AR, HR & Payroll
Technologies : SQL, PL/SQL, Forms, Reports,
Role : Technical Consultant, Support team
Duration : Sep2005 – Dec2008
ERP : Oracle 11i (11.5.10)
Database : Oracle 8i/9i
Tools : Pl/SQL Developer
Location : Gaborone
Executed at : Botswana Meat Commission
Description:
The project was to support client’s Oracle ERP systems as well as
executing new enhancements in the form of projects. This involves supporting seeded Oracle
modules, troubleshooting technical, functional issues and supporting client’s custom modules
and interfaces.
Roles & Responsibilities:
Supporting interface between Oracle Applications (Payables, Receivables) with Legacy
system (Kill system)
Supporting and maintenance of Oracle modules viz. General Ledger, Payables,
Receivables, Cash Management, Fixed Assets, Loans, Purchasing, HRMS & Payroll.
Debugging and Bug fixing including testing, deployment etc.
Bespoke development including customization of new forms, reports, custom.pll,
packages and procedures.
Involved in addressing technical issues, debugging the technical components
Involved in Month end, Quarter End, Yearend closure support processes from Oracle
Operations side (like inventory period closure, clearing, reprocessing error transactions
from all interface tables etc.
Involved in trouble shooting the functional issues and providing production support for
the Oracle Financial and HR Payroll modules.
Involved in Analysis, design, development, Integration testing and implementation of
RICE components (SQL, PL SQL, Forms, Reports, Workflow, BI Publisher.
Involved in interacting with business users, BPEs and translating the business needs into
functional specifications, detailed technical plan and comprehensive test case scenarios.
Involved in understanding, documenting the client’s business practices and ERP system
architecture and dependencies on various non-ERP applications and interfaces.