RSS

Happy World Kindness Day!

Today, I noticed that my coconut oil is in semi-solid state which means winter has arrived. Time for some reflection.

What was your way of observing this beautiful transition of season?

Happy World Kindness Day 😇 – Don’t forget to do a random act of kindness today.

Cheers!

 
Leave a comment

Posted by on November 13, 2021 in General

 

Tags: , , ,

M/s. Mahawar Vijay & Co. – accepts Cryptocurrency

Last updated on November 20th, 2021 at 02:44 am

Dear Friends,

Wish you all a very happy diwali. May the coming year and days be filled will prosperity, wisdom, and strengthens our bond even more and brightens the lamp of love, success and friendship.

Special thanks to all our partners who had helped us what we are today.

Happy to announce that M/s. Mahawar Vijay & Co. now accepts cryptocurrency as one of the payment options. Check the payment options here. This is going to revolutionise the way transactions are made in global economy in near future.

What more we are waiving the charges levied on the transaction through our payment gateway partners for next one month as a Diwali offer.

Stay safe! Be Happy and We want the best for you as always !

Best Wishes!

 
Leave a comment

Posted by on November 4, 2021 in Finance, General, Management

 

Tags: , , ,

Conceptualisation to launch of website – A glimpse

Last updated on November 20th, 2021 at 02:41 am

Dear Friends,

In continuation to previous post for launch of M/s. Mahawar Vijay & Co. This article would give you a glimpse of various steps starting from conceptualisation to launch of www.vijaymahawar.com

We would like to take this opportunity to thank collaborators who were pivotal in this journey (visit gratitude corner for the same).

As core business of M/s. Mahawar & Vijay & Co. is not a tangible product but purely a service offering. The site had to be designed keeping this in focus. It cannot be claimed that this objective is fully completed, as it was initially thought of. But its still work in process and since the industry is very dynamic, service offerings and site is also designed with microservices framework. Each component can be changed without impacting other components.

Below is the reference to various tools, online utilities which were used to achieve this.

Step 1: Design and Develop the Brand of Mahawar Vijay & Co.

  1. Since site was fully designed and developed using in-house tools and skills available. The template and design was referred from W3Schools which also provided insight to the CSS and Javascript help. This was new to us and is also not a core offering of the business.

2. Favicon – This is the icon which shows on the title bar of the browser webpage when you open a site. Favicon can be your company logo or image. There is some special requirement to have it enabled for your website. First is the size of the file has to be 16 x 16 pixels and name can be anything but preferably favicon.ico (which is default). You can generate your favicon using online converter available here

3. Logo – Some image of the site had to be resized for this online utility were used available here. This may be important if you plan to register the Logo for your business.

4. Google Forms for Careers Form, Feedback Form and Grievance Form. Google forms was used to capture user feedback, suggestions, career details and grievance.

5. Integration of Web-hosting with Google Drive for organisation of content, resume bank and forms data.

Step 2: KYC requirements – MSME

  1. Udyam website for registration of M/s. Mahawar Vijay & Co. as MSME. This is required if you want to seek a payment for online transactions from your site as a merchant or business.

2. Secured Payment Gateway – Payment Link is created using – Razorpay payment gateway and Paytm for Business. Soon this would be enable to accept international payments to cater to the needs of international clients as well and also intergrated with Paypal for ease and convenience of international customers.

Step 3: Security and Privacy of users, visitors and customers

  1. During the various stages of business transaction and interaction of users, users might knowingly or unknowingly share personal data, financial data. Securing this analytics data is utmost important and core objective. Please visit the privacy policy and terms and conditions to see how we are safe guarding this sensitive data.

2. Both the site (www.vijaymahawar.com) and its blog (www.mahawar.net/blog) are secured using SSL certificates, which means its safe and secure for visitors like you and clients/customers.

Step 4: Search Engine Optimisation and Web Analytics

This in itself is huge topic to cover in this article (consider seeing this post as well). Shared here are few tools which were used and incorporated in the site.

  1. Google Analytics – Analytics importance for any industry has become a paramount importance. For this Google Analytics is used. This shows the engagement of visitors, customers at various levels of interactions. The demographic, time and place are captured which is protected and preserved as per the data privacy policy stated in the site. Out of the two options available to enable this, Google Tag Manager is used to configure and apply this in the website. This can be taken care by the development team.

2. Google Tag Manager – Generate Tag – This gives the snipped of code which you can ad to each page of website for which analytics has to be enabled. This again has to be taken care by the development team.

3. Google Knowledge Panel – This is great way to showcase how your webpage and business appears in Google Search Engine. For this you can register with Google Business and submit the necessary details as required by them. As a confirmation a post card sent to mailing address which contains a unique code. This code can be used to verify you business and post which the knowledge panel gets activated.

4. Sitemap is generated using online utility available here – Sitemap is very useful way to keep track of all pages of the website. This also gives search engines and crawlers to quickly scan all the pages of the site whenever they are changed. This makes them appear in the search result.

Hope you find this journey of site useful for establishing yourself in the online market place.

Feel free to write to us at vijay@mahawar.net and provide your valuable feedback here.

Best Wishes

 
Leave a comment

Posted by on October 31, 2021 in Data Science, General, Marketing

 

Tags: , , , , , , , , , , , , , , , , , ,

Website for Mahawar Vijay & Co – vijaymahawar.com launched

Last updated on October 25th, 2021 at 03:56 pm

Excited to announce the launch of Mahawar Vijay & Co website – http://www.vijaymahawar.com

#newproject #newwebsitelaunch #datascience #plsql #sql #python #transitionplanning

 
1 Comment

Posted by on October 15, 2021 in Data Science, DBA, General, Marketing, Oracle, PL/SQL

 

Tags: , , , , ,

Post Graduate Diploma in Data Science and Statistics (PGDDSS)

Last updated on October 14th, 2021 at 05:46 pm

Delighted to share that I have completed – Post Graduate Diploma in Data Science and Statistics (PGDDSS) with A+ grade. 

Thanks to Symbiosis Centre for Distance Learning, my colleagues, employers, managers past and present, peers, family and friends for continuous support, motivation and encouragement for the entire duration of the course. 

I am grateful to my alma mater especially for providing continuous and uninterrupted academic support during last 18 months – An unforgettable and memorable journey during the challenging times for everyone involved.

I cannot claim myself to be an expert Data Science specialist but this knowledge will surely be a beginning to help me bridge the gap and deliver a far superior and efficient solution to organisations seeking collaboration in their transformational journey.

Post Graduate Diploma in Data Science and Statistics from SCDL, Pune

#datascience #dataanalysts #pythonprogramming #machinelearning #oracle #sqldeveloper

PS: This post was initially posted on my Linkedin profile and is migrated today as part of transition plan.

 
Leave a comment

Posted by on August 14, 2021 in Data Science

 

Tags: , , , , , ,

Yoga Volunteer Certificate – Ministry of AYUSH

Last updated on November 9th, 2021 at 04:42 pm

Thanks to Ministry of AYUSH, Govt. of India and The Yoga Certification Board and Sri Sri School of Yoga for bestowing me with Yoga Volunteer Certificate. 

Hope my contribution helps spread message of peace, harmony, health and happiness both at gross and subtler level of existence to one and all 🙏

#ayush #govtofindia #YCB #yoga #yogateachers #iyd2021 #independenceday2021

YCB Yoga Volunteer Program - June 2021
YCB Yoga Volunteer Program – June 2021

PS: This post was initially posted on my Linkedin profile and is migrated today as part of transition plan.

 
Leave a comment

Posted by on August 1, 2021 in Yoga

 

Tags: , , , , , ,

Small step to heal the world.

Last updated on October 14th, 2021 at 05:35 pm

Small step to heal the world. Countdown to #IDY2021 #internationaldayofyoga

Yoga Appreciation Program – 2021

PS: This post was initially posted on my Linkedin profile and is migrated today as part of transition plan.

 
Leave a comment

Posted by on May 16, 2021 in Yoga

 

Tags: , , , ,

Project Accounting(PA) to Predictive Analytics – Part I

Last updated on October 14th, 2021 at 05:47 pm

Oracle E-Business Suite (Previously known as Oracle Apps) is one of Oracle Corp.’s major product lines. Also known as Oracle EBS, it is an integrated set of business applications for automating:

  • Oracle Financials
  • Oracle Human Resource Management System (HRMS)
  • Oracle Logistics
  • Oracle Supply Chain Management (SCM) Applications
  • Oracle Order Management (OM)
  • Oracle Transportation Management
  • Oracle Warehouse Management System
  • Oracle Customer Relationship Management (CRM), etc.

Below is the Oracle Fusion Application Product Families:

No alt text provided for this image

Notably, TCA (Trading Community Architecture) is used to store information of Banks, Customers and Suppliers – click here for more detail on this.

The focus of this article is on one integral suite called Oracle Projects (Oracle Project Accounting or in short called PA suite).

What is Project Accounting (PA)?

The Project Accounting (PA) suite provides timely and detailed solutions to project managers as well as the finance groups. The details give you improved visibility to project revenues, work breakdown structures, invoice accountability and overall profitability to any project. With the Project Accounting Module you can:

Step 1: Define statuses of any project

Step 2: Maintain draft, baseline and original versions of the project budget

Step 3: Utilize the power of a flexible work breakdown structure and provide accurate and up to date information to finance and the project managers regarding spend rates and burdened costs for materials or labor.

Step 4, Step 5 and Step 6: Put the power of data into the hands of the project managers.

Project Accounting - Step 4-5-6

Here is a very short video from YouTube which gives overview on Oracle Projects

Basic terminologies of PA:

Project: A project is a primary unit of work that can be broken down into one or more tasks.

Task: It is the small unit of work created under the project against which transaction can be created. Note: we cannot create transaction/expenditure items directly on the project, hence it is mandatory for each project to have at least one task.

 Project Classes: Oracle PA has provided three pre defined project classes.

  • Indirect projects – Track overhead activities and costs of the organization. Note: Does not generate revenue and invoicing process.
  • Capital projects – Track asset development activities and costs, and costs are capitalized as one or more assets.
  • Contract projects – Contract projects created with external customer to track cost, revenue, and billing.

Project Type:

The project type controls how Oracle Project Foundation creates and processes projects, and is a primary classification for the projects your business manages. You must set up at least one project type to create projects. You must set up project types for each operating unit.

  •  Examples of Indirect project: Admin Project, Transport Facility etc.
  • Example of Contract project: External Project, Intercompany project etc.

Expenditure category: It is the category created to classify the different types of cost an organization may incur.

Revenue category: It is the category created to classify the different types of revenue an organization may earn.

Expenditure type: It is the identification of cost that is associated to an expenditure item.It is assigned to the expenditure category and revenue category during the setups.

Expenditure class: It is the classification for an expenditure type as how the expenditure type can be used to create transaction. When an expenditure type is classified for a certain type then only those expenditure class transactions are allowed to enter.

 In Oracle Project Costing we have predefined expenditure classes.

Labor:

Straight Time: For standard time entry. We use the cost rate multiple with number of hours.

Overtime: Labor cost calculated using a premium cost rate multiplied by hours.

Non-labor project costs:

Expense Reports – Expense reports from Oracle Payables or Oracle Internet Expenses. You cannot enter expense reports directly into Oracle Project Costing. Expense reports that you import into Oracle Project Costing must be fully accounted prior to import.

Usages – You must specify the non-labor resource for every usage item you charge to a project. For each expenditure type classified by a Usage expenditure type class, you also define non-labor resources and organizations that own each non-labor resource.

Supplier Invoices – Supplier invoices, discounts, and payments from Oracle Payables or an external system, and receipt accruals from Oracle Purchasing.

Miscellaneous Transaction – Miscellaneous Transactions are used to track miscellaneous project costs. Examples of uses for miscellaneous transactions are:

  • Fixed assets depreciation
  • Allocations
  • Interest charges

Burden Transaction – Burden transactions track burden costs that are calculated in an external system or calculated by Oracle Project Costing as separate, summarized transactions. These costs are created as a separate expenditure item that has a burdened cost amount, but has a quantity and raw cost value of zero. You can adjust burden transactions that are not system-generated.

Work In Process – You use this expenditure type class for Oracle Project Manufacturing WIP transactions that you interface from Manufacturing to Oracle Project Costing. You can also use this expenditure type class when you import other manufacturing costs via Transaction Import or when you enter transactions via pre-approved batch entry.

Inventory – This expenditure type class is used for the following transactions:

  • Oracle Project Manufacturing transactions that you import from Manufacturing or Oracle Inventory.
  • Oracle Inventory Issues and Receipts that you import from Oracle Inventory in a manufacturing or non-manufacturing installation.

Example:

No alt text provided for this image

In the above examples for line number 1, time can be entered for expenditure type “Standard_Time”. 

Similarly for line number 2 & 4 the respective expenditure class transactions can be entered.

For line number 3 supplier invoices & expense reports can be entered as it has been classified for two different classes.

Types of Currencies

Transaction amounts are stored in the following currencies:

  • Transaction Currency: The currency in which a project transaction occurs.
  • Expenditure Functional Currency: The functional currency of the expenditure operating unit.
  • Project Functional Currency: The functional currency of the operating unit that owns the project.
  • Project Currency: The user–defined project currency.

When you enter transactions in a currency that is different from functional currency or project currency, Oracle Project Costing must convert the transaction amount to the functional and project currencies. To convert transaction currencies, Oracle Project Costing must first determine the exchange rate type and exchange rate date.

 Task Type:

  • Billable Item: It is a functionality associated at the task level identifying the expenditure items created against the task to be billed to the client.
  • Non Billable Item: It is functionality associated at the task level identifying the expenditure items created on the task is only to record the cost incurred against it.

Note: We can adjust the task at the expenditure item window to make the non billable as billable and vice versa. This is called as expenditure item adjustments.

Employee/Job bill rate Override: Incase a different rate needs to be updated for a particular job or employee the same can be updated at the project or task level.

The employee name needs to be entered along with the bill rate, currency and period applicable. The rate at the task level overwrites the rates at the project level and the rates at the project level overwrites the rate of the bill rate schedule attached at the project level.

Cost rate: It is the rate defined at the job or employee level to derive at the basic cost for a particular expenditure item. The cost rate scheduled are defined in the OU functional currency.

The cost rate can be defined at two levels:

  • In the setups -> Expenditure -> Rate schedule.
  • Overrides: Labor Costing Overrides

( Navigation: PA Responsibility->Setup->Costing->Labor->Labor Costing Overrides.)

Bill rate: It is the rate defined at the job or employee level to derive at an amount which will be billed to the client.

The bill rate can be defined at two levels:

  1. In the setups -> Expenditure -> Rate schedule.
  2. Overrides: At the project level as employee or job override.
  •  For employee override: Navigation: Project -> Options -> – Bill Rates and Discount Overrides -> Employee Bill Rate and Discount Overrides
  •  For job override: Navigation: Project -> Options ->  Bill Rates and Discount Overrides -> Job Bill Rate and Discount Overrides

Transfer Price Rules and Schedule: Transfer price rules control the calculation of transfer prices for labor and non-labor cross charged transactions. To drive transfer price calculation for cross charge transactions between the provider and receiver, use the Transfer Price Schedule window to assign labor or non-labor (or both) transfer price rules to the provider and receiver pair on a schedule line

ICB: It is a process, where we have different legal entities involved, and the OUs under these LE owns the employees and projects.

  • The OU to which the employee is assigned is called PROVIDER OU.
  • The OU to which owns the project is called RECEIVER OU.

 Note: In ICB process, an internal invoice is generated in provider OU.

Borrowed And Lent: It is a process, where we have one legal entity involved, and the OUs under the LE owns the employees and projects. The employee and project can be in the same OU or different OU but the LE has to be same.

Note: No internal invoice is generated in B&L process, only accounting happens to post cost.

Labor: When an employee enters time on a specific project it is known as charging efforts of the employee on the project for a given time frame. This time further has some cost defined to calculate the actual cost incurred by the employees on the project.

The calculation process of the raw cost for such labor/time entered is called as Labor Cost.

The time can be entered via a third party tool or via the PA pre approved batch.

 Overtime – Labor cost calculated using a premium cost rate multiplied by hours.

Non labor expenditure types: The expenditure items created via supplier invoices or expense reports are called as non labor expenditure types. The expenditure types created need to be added in the non labor expenditure schedules.

Navigation: PA -> Setups -> Expenditure -> Rate schedule.

To be continued …

References:

https://docs.oracle.com/cd/E28271_01/fusionapps.1111/e15525/intro.htm (Oracle Documentation)

https://knoworacle.wordpress.com/2014/08/26/r12-oracle-project-accounting-few-basic-concepts/

https://pushpal.wordpress.com/2012/10/02/23/ (TCA – Trading Community Architecture)

 
Leave a comment

Posted by on January 21, 2020 in Oracle

 

Tags: , , , , , , ,

Completed training on “Oracle Database 12c R2: Advanced PL/SQL”

Last updated on October 14th, 2021 at 05:47 pm

Dear Friends,
I am glad to share with you all that I completed the training on demand on “Oracle Database 12c R2: Advanced PL/SQL”.
Thanks to Oracle University and my faculty Brent Dayley for providing this training on demand.
Oracle Advanced PL/SQL in Oracle 12c R2
The training covered important features in Oracle PL/SQL in 12c R2 version. It was well designed and gave a good head-start from the technical perspective.

I would also like to thank Oracle University which provides wonderful platform for such courses.

My detailed resume can be found here.

Cheers!
Vijay

 
Leave a comment

Posted by on January 2, 2020 in Oracle, PL/SQL

 

Tags: , ,

Happy New Year 2020!

Last updated on October 14th, 2021 at 05:48 pm

Happy New Year 2020 to all friends.

Here is what the world searched on Google in year 2019.

May you and your family be showered by blessings of the almighty in abundance! Wish you a happy and prosperous new year 2020 🙂

Cheers!
Vijay Mahawar

 
Leave a comment

Posted by on January 1, 2020 in Entertainment, General

 

Tags:

 
snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake
%d bloggers like this: