EXL Service
300+ Interview Questions and Answers
Q101. How many type mode of Payments?
There are several modes of payment including cash, check, credit/debit card, wire transfer, and online payment.
Cash
Check
Credit/debit card
Wire transfer
Online payment
Q102. What is Prepaid expenses and where we see in the financial statement?
Prepaid expenses are expenses that have been paid for in advance but have not yet been incurred.
Prepaid expenses are assets on the balance sheet
They are expenses that have been paid for in advance but have not yet been incurred
They are gradually expensed over time as they are incurred
Examples include prepaid rent, insurance premiums, and prepaid subscriptions
Q103. Guesstimate - detergent used in hospital in a day
Approximately 500 gallons of detergent are used in a hospital in a day.
Consider the size of the hospital and number of patients
Think about the various departments that require cleaning
Take into account the frequency of cleaning tasks
Estimate based on typical usage rates in healthcare facilities
Q104. Name a senario where law of diminishing marginal utlity does not holds
The law of diminishing marginal utility does not hold in the case of addictive substances.
Addictive substances, such as drugs or alcohol, can lead to an increase in utility with each additional unit consumed.
The initial consumption of an addictive substance may provide a high level of utility, but subsequent consumption may not provide the same level of satisfaction.
For example, a person addicted to nicotine may experience increasing satisfaction with each cigarette smoked, d...read more
Q105. What RCA and CAPA? Tools which are used for quality analysis?
RCA stands for Root Cause Analysis and CAPA stands for Corrective and Preventive Action. Various tools are used for quality analysis such as Fishbone diagram, Pareto chart, Control chart, etc.
RCA is a process used to identify the underlying cause of a problem or an event.
CAPA is a process used to identify, correct, and prevent problems from recurring.
Fishbone diagram is a tool used to identify the possible causes of a problem.
Pareto chart is a tool used to identify the most s...read more
Q106. Tell me a project related to information extraction you have worked upon.
Developed a project to extract key information from legal documents using natural language processing techniques.
Used NLP tools like spaCy and NLTK to preprocess and analyze text data
Implemented named entity recognition to identify key entities like names, dates, and locations
Developed custom rules and patterns to extract specific information like case numbers and verdicts
Used machine learning algorithms to improve extraction accuracy
Collaborated with legal experts to validat...read more
Q107. How do you use cloud computing in digital transformation?
Cloud computing enables digital transformation by providing scalable and flexible infrastructure for data storage, processing, and analysis.
Cloud computing allows for easy access to data and applications from anywhere, at any time.
It enables businesses to scale up or down their computing resources as needed.
Cloud-based analytics tools can help organizations gain insights from large amounts of data.
Cloud-based collaboration tools can improve communication and productivity amon...read more
Q108. What is Bank reconciliation statement
Bank reconciliation statement is a document that compares the bank statement with the company's records to identify any discrepancies.
It is used to ensure that the company's records match the bank's records
It helps in identifying errors, omissions, or fraudulent activities
It includes comparing deposits, withdrawals, and bank charges
Reconciling items may include outstanding checks, deposits in transit, and bank errors
The statement is prepared regularly to maintain accurate fin...read more
Q109. How can you remove duplicates?
To remove duplicates from an array of strings, use a hash set or sort the array and iterate to remove duplicates.
Create a hash set and iterate through the array, adding each element to the set. If the element already exists in the set, remove it from the array.
Sort the array using a sorting algorithm like quicksort or mergesort. Then iterate through the sorted array and remove any duplicates by comparing adjacent elements.
Q110. How many verka lassi are sold daily in jalandhar?
Sorry, I don't have the available data.
No data available for daily sales of Verka Lassi in Jalandhar.
Q111. What is cross join
Cross join is a type of join operation in relational databases that combines each row from one table with every row from another table.
Cross join produces a Cartesian product of the two tables involved.
It does not require any matching condition or join predicate.
The resulting number of rows in the output is the product of the number of rows in the two tables being joined.
Cross join is also known as a Cartesian join or a cross product.
It is commonly used when you want to combi...read more
Q112. Guesstimates- Estimate number of kgs of paneer used in banglore per day
Approximately 500 kgs of paneer are used in Bangalore per day.
Estimate the population of Bangalore
Assume average consumption of paneer per person per day
Consider the number of restaurants and households in Bangalore
Factor in the demand for paneer-based dishes in Bangalore
Q113. What difference you create if you join exl?
I bring a unique blend of leadership, strategic thinking, and problem-solving skills to drive growth and innovation at exl.
Proven track record of successfully leading teams to achieve business objectives
Strong strategic thinking abilities to identify opportunities for growth and improvement
Expertise in problem-solving to overcome challenges and drive innovation
Experience in implementing effective processes and systems to optimize performance
Ability to collaborate with cross-f...read more
Q114. How do you digitize an Insurance Claim Process?
Digitizing an insurance claim process involves automating the process of filing, processing, and settling claims using digital tools.
Implement an online portal for claim submission and tracking
Use digital tools like AI and machine learning to automate claim processing
Integrate with third-party data sources to verify claims and prevent fraud
Provide real-time updates to customers on the status of their claims
Offer digital payment options for claim settlements
Ensure data securit...read more
Q115. 2. There are 2 cubes. You have to put digits on both the cubes so that one can form all the numbers from 1 to 31
Q116. Number of 0s in 1 to 1000
The number of 0s in 1 to 1000 is 192.
There are 1000 numbers from 1 to 1000.
Every 10 numbers have one 0 in the units place.
Every 100 numbers have ten 0s in the tens place.
Every 1000 numbers have one hundred 0s in the hundreds place.
Therefore, there are 1 + 10 + 100 + 81 = 192 0s in total.
Q117. 1. How was it participating in EXL Excellence Quotient 2011?
Q118. How do you automate a report using Excel?
Automating a report in Excel involves using macros or VBA code to perform repetitive tasks and generate the report automatically.
Use Excel's built-in macro recorder to record your actions and generate VBA code.
Write VBA code to manipulate data, format cells, and generate charts or tables.
Schedule the report to run at specific times using Excel's built-in scheduling tools or external tools like Windows Task Scheduler.
Consider using Excel add-ins or third-party tools for more a...read more
Q119. What are supervised and unsupervised learning models?
Supervised learning models are trained on labeled data with known outputs, while unsupervised learning models are trained on unlabeled data without known outputs.
Supervised learning models require labeled data for training, where the algorithm learns to map input data to the correct output.
Examples of supervised learning include linear regression, logistic regression, support vector machines, and neural networks.
Unsupervised learning models do not have labeled output data dur...read more
Q120. There are three switches and one bulb which is in another room. You need to find which switch turns on the bulb. You can only go once
Turn on one switch, wait for a while, then turn it off and turn on another switch. The switch left on is the one connected to the bulb.
Turn on switch 1 and leave it on for a few minutes
Turn off switch 1 and turn on switch 2
Go to the room with the bulb, the switch left on is the one connected to the bulb
Q121. What all softwares you have worked upon?
I have worked on various softwares including Microsoft Office Suite, Salesforce, SAP, and Oracle.
Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)
Salesforce (CRM software)
SAP (Enterprise Resource Planning software)
Oracle (Database management system)
Q122. What is Accounts Payable cycle?
Accounts Payable cycle is the process of managing and paying a company's outstanding bills and invoices.
It involves receiving and verifying invoices from vendors
Recording the invoices in the accounting system
Approving the invoices for payment
Issuing payment to the vendors
Reconciling vendor statements with accounts payable records
Managing cash flow to ensure timely payments
Examples of accounts payable include rent, utilities, and inventory purchases
Q123. How you will proceed to client problem ?
I will follow a structured approach to understand the problem and identify the root cause before proposing a solution.
Listen actively to the client's problem and ask relevant questions to gather more information.
Analyze the information gathered to identify the root cause of the problem.
Propose a solution that addresses the root cause and meets the client's needs.
Collaborate with the client to implement the solution and monitor its effectiveness.
Provide ongoing support to ensu...read more
Q124. Python code for factorial
Python code to calculate factorial of a number.
Use a loop to iterate from 1 to the given number.
Multiply each number with the previous result.
Return the final result.
Q125. What is P2P cycle / AP?
P2P cycle or AP refers to the end-to-end process of purchasing goods or services, receiving and verifying invoices, and making payments to vendors.
P2P stands for Procure-to-Pay, which encompasses all activities from requisitioning to payment.
Accounts Payable (AP) is the department responsible for managing and processing vendor invoices.
The P2P cycle starts with the identification of a need for goods or services and ends with the payment to the vendor.
Key steps in the P2P cycl...read more
Q126. Difference between having and where cause
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
HAVING is used with GROUP BY clause to filter the groups based on aggregate functions
WHERE is used to filter rows based on conditions
HAVING is applied after the GROUP BY clause, WHERE is applied before
HAVING can only be used with SELECT statement that contains a GROUP BY clause
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;
Example: SELECT * FROM em...read more
Q127. How many 0's in 100!?
The number of zeros in 100! can be determined by counting the number of factors of 10.
Count the number of factors of 10 in the prime factorization of 100!
Each factor of 10 is made up of 2 and 5, so count the number of 2's and 5's separately
There are more factors of 2 than 5, so count the number of factors of 5
There are 24 factors of 5 in 100!, so there are 24 zeros at the end
Q128. How do you conduct Process Transformation?
Process transformation involves analyzing and improving existing processes to increase efficiency and effectiveness.
Identify the process to be transformed
Analyze the current process and identify areas for improvement
Design a new process that addresses the identified issues
Implement the new process and monitor its effectiveness
Continuously evaluate and improve the process
Use tools such as process mapping, Lean Six Sigma, and automation to aid in the transformation
Involve stake...read more
Q129. Make 8 using 3,1,3,6
To make 8 using 3,1,3,6, we can use the equation (3+1)*(3+6)
Add 3 and 1 to get 4
Add 3 and 6 to get 9
Multiply 4 and 9 to get 36
Divide 36 by 4 to get 8
Q130. 3) SCD Type 2 dimension used in your old project
SCD Type 2 is used to maintain historical data in a dimension table.
SCD Type 2 is used to track changes in dimension attributes over time.
It creates a new record for each change and maintains a history of all changes.
It includes additional columns like start date, end date, and version number.
Example: Employee table with changes in job title, salary, and department over time.
It helps in analyzing trends and making informed decisions based on historical data.
Q131. What is proc report?
proc report is a SAS procedure used for creating tabular reports.
proc report is used to summarize and present data in a tabular format.
It allows users to define the structure and appearance of the report.
Users can specify variables, statistics, and formatting options.
It supports grouping, sorting, and summarizing data.
Output can be generated in various formats like HTML, PDF, and RTF.
Example: proc report data=sales; column region product sales; run;
Q132. Journal entry of Accounts payable
Journal entry of Accounts Payable
Debit Accounts Payable account for the amount owed
Credit Cash or Bank account for the amount paid
If a discount is taken, credit the Discount Received account
If a purchase return is made, credit the Purchase Returns and Allowances account
Q133. What are the main accounting concepts
The main accounting concepts are the principles and guidelines that govern the preparation and presentation of financial statements.
Going Concern Concept
Consistency Concept
Accrual Concept
Prudence Concept
Materiality Concept
Entity Concept
Money Measurement Concept
Cost Concept
Dual Aspect Concept
Q134. General accounting principles and practices
General accounting principles and practices refer to the basic rules and guidelines that govern the field of accounting.
These principles include the accrual basis of accounting, the matching principle, and the consistency principle.
They also involve the use of financial statements, such as the balance sheet, income statement, and cash flow statement.
Other practices include the use of double-entry bookkeeping, the recording of transactions, and the preparation of financial rep...read more
Q135. Elaborate PDV in SAS
PDV in SAS stands for Program Data Vector, which is a temporary storage area for data during program execution.
PDV is used to hold data values during program execution
It is created automatically by SAS and is used to store data temporarily
PDV is used to hold data values before they are written to a SAS dataset
It is also used to hold data values during data manipulation and analysis
Q136. How do you handle the estimations and client budget
I handle estimations by thoroughly analyzing project requirements and creating detailed budgets in alignment with client expectations.
Conduct a comprehensive analysis of project requirements to determine resources needed
Create a detailed budget outlining costs for materials, labor, and any other expenses
Regularly communicate with the client to ensure budget alignment and address any changes or concerns
Utilize project management tools to track expenses and monitor budget statu...read more
Q137. What are surgery global modifiers?
Surgery global modifiers are codes used to indicate the overall status of a surgical procedure.
They are used to indicate whether a surgical procedure was a minor or major surgery, whether it was performed by an assistant surgeon, and whether it involved a bilateral procedure.
Examples of surgery global modifiers include -54 (surgical care only), -55 (postoperative management only), -56 (preoperative management only), -62 (two surgeons), and -80 (assistant surgeon).
Q138. Difference between bagging and boosting
Bagging and boosting are ensemble learning techniques used to improve model performance.
Bagging involves training multiple models on different subsets of the training data and combining their predictions through averaging or voting.
Boosting involves iteratively training models on the same data, with each subsequent model focusing on the errors of the previous model.
Bagging reduces overfitting and variance, while boosting reduces bias and underfitting.
Examples of bagging algor...read more
Q139. Number of cycles sold in India annualy
The annual number of cycles sold in India varies depending on market trends and consumer demand.
The Indian bicycle market is highly competitive with a wide range of brands and models available.
Factors such as rising health consciousness, increasing traffic congestion, and environmental concerns have led to a growing demand for bicycles in India.
According to a report by Research and Markets, the Indian bicycle market is expected to grow at a CAGR of 7.5% during 2020-2025.
Howev...read more
Q140. Verify valdate invoice , All transaction code explain step by step
Validating and verifying invoices by explaining all transaction codes step by step.
First, review the invoice for accuracy and completeness.
Next, match the invoice to the purchase order and receiving report.
Then, enter the invoice details into the accounting system using the appropriate transaction code.
Finally, reconcile the invoice with the vendor statement to ensure all payments are accounted for.
Example: Transaction code 101 may represent a standard invoice entry, while co...read more
Q141. Explain the type of relationships and their use case.
Power BI supports three types of relationships: one-to-one, one-to-many, and many-to-many.
One-to-one: used when two tables have a unique relationship, such as a person and their social security number.
One-to-many: used when one record in the first table can have multiple matching records in the second table, such as a customer and their orders.
Many-to-many: used when multiple records in the first table can have multiple matching records in the second table, such as students a...read more
Q142. What is trial Balance
Trial balance is a list of all the general ledger accounts and their balances at a specific point in time.
Prepared at the end of an accounting period
Used to ensure that debits and credits are equal
Helps in identifying errors and omissions in the accounting records
If the debits and credits do not match, it indicates an error in the accounting records
Example: If the total debit balance is $50,000, the total credit balance should also be $50,000
Q143. What do you mean by PO?
PO stands for Purchase Order.
PO is a document used to request goods or services from a supplier.
It includes details such as item description, quantity, price, and delivery date.
POs are used to track and manage orders, and to ensure that the correct items are received.
POs are commonly used in business and procurement processes.
Example: A company may issue a PO to a supplier for 100 units of a particular product at a specified price and delivery date.
Q144. How many types of po and example of No po
There are two types of purchase orders: Standard PO and Blanket PO. An example of a No PO scenario is when a company makes a small, one-time purchase without a formal purchase order.
Standard PO: Used for one-time purchases of goods or services
Blanket PO: Used for recurring purchases over a period of time
Example of No PO: A company urgently needs to buy office supplies and the employee directly pays for them without going through the formal purchase order process
Q145. What are joins in explain types with examples
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FULL JOIN returns rows when there is a match in one of the tables
Q146. What is the diff between All and Allexcept
All returns all values in a table, while Allexcept returns all values except those specified in the argument.
All returns all values in a column or table.
Allexcept returns all values in a column or table except those specified in the argument.
Example: All(Table[Column]) returns all values in the specified column.
Example: Allexcept(Table, Table[Column]) returns all values in the table except those in the specified column.
Q147. What are differences between Append and merge
Append adds new data to the end of a dataset, while merge combines two datasets based on a common key.
Append adds rows to the end of a dataset, while merge combines rows from two datasets based on a common key column.
Append is useful for adding new observations to an existing dataset, while merge is used to combine datasets with related information.
Append does not require a common key, while merge requires a common key to match rows from both datasets.
Example: Appending a new...read more
Q148. Estimate the number of kgs of paneer used in Bangalore everyday
It is difficult to estimate the exact number of kgs of paneer used in Bangalore everyday without specific data.
Estimate based on population size and consumption habits
Consider the number of restaurants, hotels, and households in Bangalore
Look at the average consumption of paneer per person in Bangalore
Q149. Guesstimate case – Estimate the daily revenue of Delhi Metro Service
Q150. What is the journal entries for acvounts recievable
Journal entries for accounts receivable record the increase and decrease in the amount owed by customers.
When a sale is made on credit, the journal entry debits accounts receivable and credits sales revenue.
When a customer makes a payment, the journal entry debits cash and credits accounts receivable.
If a customer returns goods, the journal entry debits sales returns and allowances and credits accounts receivable.
If an account is deemed uncollectible, the journal entry debits...read more
Q151. What is OS What is pst and ost What is outlook What is group policy What is AD What is users Whai is OU
OS stands for Operating System, which is the software that manages computer hardware and software resources.
OS is the foundation of a computer system, providing a user-friendly interface and managing tasks and resources.
Examples of popular operating systems include Windows, macOS, and Linux.
Q152. How to make payment to Clint
Payment to Clint can be made through various methods such as wire transfer, check, or online payment portals.
Determine the payment method preferred by Clint
Obtain necessary payment information such as account number and routing number
Ensure that there are sufficient funds to cover the payment
Record the payment in the appropriate accounting system
Q153. Data warehousing approach and dimensions and facts
Data warehousing involves organizing and storing data for easy access and analysis. Dimensions and facts are key components.
Data warehousing involves extracting, transforming, and loading data into a central repository for analysis
Dimensions are the characteristics or attributes of the data, such as time, location, or product
Facts are the measurable data points, such as sales revenue or customer count
Data is organized into a star or snowflake schema, with dimensions surroundi...read more
Q154. How to deal with lack of work life balance?
To deal with lack of work life balance, it is important to prioritize, set boundaries, delegate tasks, and practice self-care.
Prioritize tasks and focus on the most important ones
Set boundaries by clearly defining working hours and personal time
Delegate tasks to team members or colleagues to distribute workload
Practice self-care by taking breaks, exercising, and engaging in hobbies or activities outside of work
Communicate with supervisors or managers about workload and discus...read more
Q155. What are the three examples of entries you are booking
I am currently booking entries for sales revenue, expenses, and payroll.
Sales revenue entry includes recording sales transactions and updating accounts receivable.
Expenses entry involves recording all expenses incurred by the company, such as rent, utilities, and supplies.
Payroll entry includes recording employee salaries, benefits, and taxes.
Q156. Puzzle: Number of minimum matches required to get a winner among N participants
The minimum number of matches required to get a winner among N participants is log2(N).
The formula to calculate the minimum number of matches is log2(N).
For example, if there are 8 participants, the minimum number of matches required is log2(8) = 3.
If there are 16 participants, the minimum number of matches required is log2(16) = 4.
This formula assumes a single-elimination tournament where each match eliminates one participant.
If the tournament has multiple rounds or a differ...read more
Q157. Guesstimate: Number of international cricket matches in a calendar year
Approximately 1,000 international cricket matches are played in a calendar year.
The number of international cricket matches varies each year depending on the schedule of different cricket boards.
In 2019, there were 1,082 international cricket matches played across all formats.
Factors such as the ICC World Cup and T20 World Cup can significantly impact the number of matches played in a year.
Q158. Explain SVM algorithm, Mention some of the kernels.
SVM is a supervised machine learning algorithm used for classification and regression analysis. It finds the best hyperplane to separate data points.
SVM is based on the idea of finding a hyperplane that best divides a dataset into two classes.
It can be used for both classification and regression analysis.
Some of the popular kernels used in SVM are linear, polynomial, radial basis function (RBF), and sigmoid.
Linear kernel is used when the data is linearly separable, while RBF ...read more
Q159. What is the guarantee of Stability
Stability in data processing can be guaranteed through proper system design, redundancy, and regular maintenance.
Stability can be guaranteed by implementing redundant systems to ensure continuous operation in case of failures.
Regular maintenance and updates to the data processing systems can help prevent issues that may lead to instability.
Proper system design, including efficient data storage and processing methods, can also contribute to stability.
Monitoring and analyzing s...read more
Q160. Estimate the number of bike owners in your city
There are approximately 50,000 bike owners in the city.
Estimate based on the number of bike shops and bike lanes in the city
Consider the population density and the popularity of biking as a mode of transportation
Survey a sample of the population to get a more accurate estimate
Q161. 5) different between truncate, delete and drop
Difference between truncate, delete and drop
Truncate removes all data from a table but keeps the structure
Delete removes specific rows from a table
Drop removes the entire table and its structure
Truncate and drop cannot be rolled back, but delete can be
Truncate is faster than delete as it does not log individual row deletions
Q162. What do you know about transaction monitoring
Transaction monitoring involves tracking and analyzing financial transactions to detect suspicious activities.
Transaction monitoring is a process used by financial institutions to identify and prevent money laundering, fraud, and other illegal activities.
It involves monitoring customer transactions in real-time or retrospectively to identify any unusual patterns or behaviors.
Automated transaction monitoring systems use algorithms and rules to flag potentially suspicious trans...read more
Q163. Difference between budgeting and for asting
Budgeting involves setting financial goals and creating a plan to achieve them, while forecasting involves predicting future financial outcomes based on past data and trends.
Budgeting is a proactive process that involves setting financial goals and creating a plan to achieve them.
Forecasting is a reactive process that involves predicting future financial outcomes based on past data and trends.
Budgeting helps in controlling expenses and allocating resources effectively.
Forecas...read more
Q164. How is GIL and how python handle multi threading
GIL stands for Global Interpreter Lock in Python, which limits execution of multiple threads at once.
GIL is a mutex that protects access to Python objects, preventing multiple threads from executing Python bytecodes at once.
Due to GIL, Python threads are not suitable for CPU-bound tasks but are still useful for I/O-bound tasks.
To handle multi-threading in Python, one can use multiprocessing module or asynchronous programming with asyncio.
Example: Using multiprocessing module ...read more
Q165. Practical implementation of few features on Tableau Desktop
Practical implementation of features on Tableau Desktop
Creating interactive dashboards
Using calculated fields for data manipulation
Utilizing parameters for dynamic filtering
Incorporating advanced analytics like forecasting
Implementing data blending for combining multiple data sources
Q166. What is Sql?, and performance tuneing
SQL is a domain-specific language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
It is used to communicate with databases to perform tasks such as querying data, updating data, and creating databases
Performance tuning in SQL involves optimizing queries, indexes, and database design to improve speed and efficiency
Examples of performance tuning techniques include using indexes, avoiding unnecessary joins, and optimizing query exe...read more
Q167. Implement backpropagation algorithm in python
Backpropagation algorithm is used to train neural networks by calculating gradients of the loss function with respect to the weights.
Initialize weights randomly
Forward pass to calculate predicted output
Calculate loss using a loss function like mean squared error
Backward pass to calculate gradients using chain rule
Update weights using gradients and a learning rate
Q168. Howto resolve internet connection issue
Q169. Are you comfortable with hybrid model
Yes, I am comfortable with the hybrid model as it allows for flexibility and collaboration.
Hybrid model combines remote work with in-person work
Allows for flexibility in work schedule and location
Encourages collaboration among team members
Example: Some days working from home and some days in the office
Q170. Explain the difference between Precision and Recall.
Precision is the ratio of true positives to all predicted positives, while recall is the ratio of true positives to all actual positives.
Precision measures how accurate the positive predictions are, while recall measures how complete the positive predictions are.
Precision is important when the cost of false positives is high, while recall is important when the cost of false negatives is high.
A high precision means that when the model predicts a positive, it is likely to be co...read more
Q171. What is the use of a router in the network
A router is a networking device that forwards data packets between computer networks.
Routes data packets between different networks
Acts as a gateway for devices to connect to the internet
Provides security by blocking unauthorized access
Allows for network segmentation and traffic control
Examples: Cisco, Netgear, TP-Link routers
Q172. Bid Management/proposal management experience.
Yes, I have bid/proposal management experience.
I have managed the bid process from start to finish, including RFP analysis, proposal writing, and submission.
I have experience in creating and managing proposal schedules, ensuring timely delivery of proposals.
I have worked with cross-functional teams to gather information and develop proposals that meet client needs.
I have experience in tracking and reporting on proposal metrics, such as win/loss rates and proposal costs.
I have...read more
Q173. What is order confirmation
Order confirmation is a document that verifies the details of a purchase order and confirms that it has been received and accepted by the supplier.
Order confirmation is sent by the supplier to the buyer after receiving a purchase order.
It includes details such as order number, item description, quantity, price, delivery date, and payment terms.
It serves as a proof of agreement between the buyer and supplier and helps to avoid any misunderstandings or disputes.
Order confirmati...read more
Q174. How to get the last row of any SAS dataset
Use the OBS option in a SET statement to read the last observation of a SAS dataset.
Use the OBS option in a SET statement followed by the keyword 'END' to read the last observation of a SAS dataset.
For example, to read the last observation of a dataset named 'mydata', use the following code: data lastobs; set mydata(obs=last end=last); run;
Q175. What are the P&L metrics of credit card?
P&L metrics of credit card include revenue, expenses, and profit generated from credit card operations.
Revenue: Total income generated from credit card fees, interest charges, and other sources.
Expenses: Costs associated with credit card operations, such as marketing, customer service, and technology.
Profit: The difference between revenue and expenses, indicating the financial performance of the credit card business.
Examples: Net interest income, interchange fees, annual fees...read more
Q176. What is budgeting and forecasting.
Budgeting and forecasting involve planning and estimating financial outcomes for a specific period of time.
Budgeting is the process of creating a detailed plan for how to allocate resources and expenses within a specific timeframe.
Forecasting involves predicting future financial outcomes based on historical data, market trends, and other relevant factors.
Budgeting helps in setting financial goals and monitoring performance, while forecasting assists in making informed decisio...read more
Q177. What is differed revenue
Differed revenue is revenue received in advance but not yet earned.
Differed revenue is also known as unearned revenue.
It is a liability on the balance sheet until the goods or services are delivered.
Examples include magazine subscriptions, prepaid rent, and gift cards.
Once the revenue is earned, it is recognized on the income statement.
Differed revenue is common in industries such as software, consulting, and real estate.
Q178. how to do RPA feasibility
RPA feasibility can be determined by analyzing the process, identifying potential automation opportunities, and evaluating the technology and resources required.
Analyze the process to identify repetitive, rule-based tasks that can be automated
Evaluate the technology and resources required for automation
Assess the potential benefits and ROI of implementing RPA
Consider the scalability and complexity of the process
Perform a pilot test to validate the feasibility of RPA implement...read more
Q179. What is Hypothesis testing
Hypothesis testing is a statistical method used to determine whether a hypothesis about a population is likely to be true or not.
It involves formulating a null hypothesis and an alternative hypothesis
Collecting data and analyzing it using statistical methods
Making a decision to either reject or fail to reject the null hypothesis
Examples include testing the effectiveness of a new drug, or whether a coin is fair or biased
Q180. What is the journal entry for accounts payable
The journal entry for accounts payable is a credit to accounts payable and a debit to the corresponding expense or asset account.
Accounts payable is a liability account that represents the amount owed to suppliers or vendors for goods or services received.
When recording the journal entry for accounts payable, the accounts payable account is credited to increase the liability.
The corresponding expense or asset account is debited to reflect the increase in expenses or assets.
Fo...read more
Q181. What is power bi report server?
Q182. Pizzas sold at Domino's
Domino's sells a variety of pizzas with different toppings and crusts.
Domino's offers classic pizzas like pepperoni and margherita, as well as specialty pizzas like the Philly Cheese Steak and the Wisconsin 6 Cheese.
Customers can choose from a variety of crusts, including hand-tossed, thin crust, and Brooklyn style.
Domino's also offers gluten-free crust and vegan options.
Pizzas can be customized with additional toppings like mushrooms, onions, and peppers.
Domino's also offers...read more
Q183. SQL question for finding highest paid salary
Use SQL query to find the highest paid salary.
Use the MAX() function to find the highest salary value.
Select the salary column from the relevant table.
Add any necessary joins or filters to ensure accuracy.
Q184. Explain logistic regression.
Logistic regression is a statistical model used to predict the probability of a binary outcome based on one or more predictor variables.
Logistic regression is used when the dependent variable is binary (e.g. 0 or 1, yes or no).
It estimates the probability that a given outcome is true using a logistic function.
The output of logistic regression is a probability score between 0 and 1.
It is commonly used in various fields such as finance, marketing, and healthcare for predicting ...read more
Q185. What is a Case management in Pega
Case management in Pega is a feature that allows users to track and manage cases or work items through a predefined process.
Case management in Pega involves defining the stages, steps, and actions required to complete a case.
Users can view the status of a case, assign tasks to individuals, and track progress through the case management system.
Pega provides tools for automating and streamlining case management processes, improving efficiency and visibility.
Example: A customer ...read more
Q186. How to select variable in model
Variables in a model can be selected based on their significance, relevance, and impact on the outcome.
Consider the purpose of the model and the specific research question being addressed.
Identify variables that are likely to have a significant impact on the outcome.
Use statistical techniques like regression analysis to determine the importance of each variable.
Consider the practicality and feasibility of collecting data for each variable.
Consult with domain experts to ensure...read more
Q187. What is Reconciliation?
Reconciliation is the process of comparing two sets of records to ensure they are in agreement.
It involves identifying and resolving discrepancies between the two sets of records.
Examples include bank statement reconciliation, accounts receivable reconciliation, and inventory reconciliation.
Reconciliation helps ensure accuracy and completeness of financial records.
It is an important internal control measure to prevent fraud and errors.
Reconciliation should be performed regula...read more
Q188. What is p2p cycle?
P2P cycle refers to the Procure-to-Pay cycle, which is the process of purchasing goods or services and paying for them.
The cycle starts with identifying the need for a product or service.
Then, a purchase order is created and sent to the supplier.
The supplier delivers the product or service and sends an invoice.
The invoice is verified and approved for payment.
Finally, payment is made to the supplier.
The cycle ends with recording the transaction in the accounting system.
Q189. SQL join types and difference
SQL join types include inner join, left join, right join, and full outer join.
Inner join returns rows when there is at least one match in both tables.
Left join returns all rows from the left table and the matched rows from the right table.
Right join returns all rows from the right table and the matched rows from the left table.
Full outer join returns all rows when there is a match in either table.
Q190. What is prepaid expenses
Prepaid expenses are expenses paid in advance but not yet incurred or used.
Prepaid expenses are recorded as assets on the balance sheet.
They are gradually expensed over time as they are used or incurred.
Examples include prepaid rent, insurance premiums, and subscriptions.
Prepaid expenses are common in industries such as real estate and insurance.
Q191. What do you know about BPMN?
BPMN stands for Business Process Model and Notation. It is a graphical representation of business processes.
BPMN is used to model and design business processes
It uses standardized symbols and notation to represent different elements of a process
BPMN diagrams can be used to communicate process flows to stakeholders
Examples of BPMN symbols include events, activities, gateways, and flows
Q192. Guesstimate: Number of Tubelights in your campus
There are approximately 500 tubelights in the campus.
Assuming an average of 10 tubelights per classroom and 50 classrooms in the campus.
Additional tubelights in hallways, offices, and common areas.
Some tubelights may be out of order or not in use.
Estimate may vary depending on the size and layout of the campus.
Q193. What is deffer income
Deferred income is a liability that arises when a company receives payment for goods or services that it has not yet delivered or rendered.
Deferred income is also known as unearned revenue.
It is recorded as a liability on the balance sheet until the goods or services are delivered or rendered.
Once the goods or services are delivered or rendered, the deferred income is recognized as revenue on the income statement.
Examples of deferred income include prepaid rent, prepaid insur...read more
Q194. Different layers of Deep Learning Architecture
Deep Learning Architecture has three layers: Input Layer, Hidden Layer, and Output Layer.
Input Layer receives input data and passes it to the Hidden Layer.
Hidden Layer processes the input data and passes it to the Output Layer.
Output Layer produces the final output based on the input data.
Each layer can have multiple nodes or neurons.
Examples of Deep Learning Architectures include Convolutional Neural Networks (CNNs), Recurrent Neural Networks (RNNs), and Deep Belief Networks...read more
Q195. Why was Gap in your carrier
Took a break to pursue further education and gain new skills.
Took a break to pursue higher education
Used the time to gain new skills and certifications
Took a sabbatical to travel and explore different cultures
Q196. Provision for income tax entry
Provision for income tax entry is an accounting entry made to account for future tax liabilities.
Provision for income tax is made to account for future tax liabilities.
It is based on estimated tax rates and taxable income.
It is recorded as a liability on the balance sheet.
It is adjusted periodically based on actual tax liabilities.
Example: If a company estimates that it will owe $10,000 in taxes for the year, it will make a provision entry to record the liability.
Example: If ...read more
Q197. What is P 2 P
P2P stands for Procure-to-Pay, a process that involves purchasing goods or services and paying for them.
P2P is a cycle that starts with identifying the need for a product or service and ends with payment.
It includes steps like requisition, purchase order creation, invoice processing, and payment.
P2P helps organizations streamline their procurement process and reduce costs.
Examples of P2P software include SAP Ariba, Coupa, and Oracle Procurement Cloud.
Q198. Recent developments in analytics
Recent developments in analytics
Advancements in machine learning algorithms
Increased use of artificial intelligence in data analysis
Emergence of big data analytics
Integration of analytics with Internet of Things (IoT)
Growing importance of predictive analytics
Rise of real-time analytics
Q199. Difference in concepts
Difference between concepts
Concepts are abstract ideas while differences are distinctions between two or more things
Concepts are generalizations while differences are specific details
Examples: Concept of love vs. differences in love languages
Q200. Code in Appian basis on use cases
Coding in Appian involves creating applications based on specific use cases.
Identify the use case requirements and design the application flow accordingly
Use Appian's low-code platform to build the necessary components and logic
Test the application thoroughly to ensure it meets the use case criteria
Iterate on the design based on feedback and updates to the use case
Top HR Questions asked in null
Interview Process at null
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month