Workday Finance Senior Consultant
Resume:
SUMMARY
EDUCATION
Workday Functional Finance & Reporting Consultant (Formerly certified in Contracts to Cash certified) having 15 years experience into all modules of Workday Finance Functional & Reporting
Handling/solving issues/identifying and implementing requirements relating to Workday Finance Module on a daily basis for the finance teams of our clients.
Hands on experience on complex workday financial reports and dashboards. Have experience in working for both workday customer, partner organizations and workday consulting firm.
CA Finalist from ICAI, New Delhi
B.Com. (Hons.) from Shri Ram College of Commerce, Delhi University in 2008 with 63.52%
EXPERIENCE
Company Name Designation
Duration
: Assist Now India Private Limited, Chennai
: Workday Finance Consultant
(Independent Contracting)
: Oct 2023 to Present
Company Name Designation Duration
: Coreteam, (Based out of UK)
: Senior Consultant Workday Finance
: Jul 2023 to Sep 2023
Company Name Designation Duration
: Kognitiv India Private Limited (USA Based)
: Senior Consultant Workday Finance.
: Mar 23 to Jun 23
Company Name : IBM India Pvt Ltd, Gurugram
Designation : Workday Finance Consultant
Duration : Nov 2021 to Feb 23
Company Name Webhelp India Pvt Ltd, Gurugram
Designation : Workday Finance Specialist
Duration : Sep 2020 to Nov 2021
Company Name : Masterex Tech, Delhi
Designation : Senior Accountant
Duration : Jan 2011 to June 2020
Company Name : N Sharma & Associates, Delhi
Designation : Articled Assistant
Duration : Jan 2011 to June 2020
DETAILS OF WORK:
Assist Now India Private Limited
Worked extensively on the Supply Chain Module :
a)Procurement module-
Built the FDM Model for Procurement- including spend categories, purchase items, mapping to spend categories, tax defaulting for suppliers
Match Exceptions- building match set rules configurations as per the specific user requirement (example- sum of invoice lines being equal to PO, sum of receipt lines being equal to invoice- if invoice lines is greater than receipt lines – a create receipt trigger should generate, PO auto populating on the create receipts task, workarounds whereby buyer can add notes which can be seen on the override BP.
Withholding tax issues – example withholding tax not appearing for customers to wrong tax point configurations of withholding tax, mass inactivation of suppliers, issues in custom reports – whereby figures are not matching/as expected, defaulting of worktags in intercompany transactions by leveraging posting rules.
On the invoice workbench- if PO override is selected - Supplier item identifier cannot show as an item on the column preferences grid as that feature is not configurable- used the workaround whereby values will show up as custom worktags.
For complex payment terms which cannot be built using the inbuilt workday logic – used settlement run report filters as a workaround – the incorporating those payments terms into a report.
b)Vendor Portal- Implementing a new vendor process flow integrating supplier request, review of questionnaire documents, supplier/vendor portal, validations and supplier approval based on sub category of suppliers. Presented the same as a feasibility analysis
c)Inventory Module Worked on Inventory issues as AMS tickets -Inactive stocking locations, mass cancel framework for inventory, wave picking, restrict access to ad hoc put away, manage serial settings after completed transactions, consignment replenishment (min/max) and convert MPN & Manufacturer to primary attributes
d)Strategic Sourcing Module – Worked on strategic sourcing configuration and enhancements like Requestor progress visualization, Requisition to Project: Prevent Currency Mismatch, Configure Pricing Visibility, Configure Custom Fields For Public Site, Generate Contract Summary (AI/ML) – EA, Make Supplier Mandatory for Workday Contract Types, Auto-Renewal Enhancement, Questionnaire Usability Enhancements, Supplier Bank & Tax Visibility, Audit History: User List
End to end implementation of the Workday Grants Module and solved issues pertaining to : Done the grants implementation of 2 US Universities.
Priority
1=high priority, 2=medium, 3=low
a)Invoicing issues
How does WD determine how to invoice for expenses that are beyond the billing max, ie split and F&A
2
What controls the billing.. Authorized Amount? Billing beyond that for an Installment award, how?
2
If an award is overspent, on billing what becomes of the remaining amount (sitting in Partially Billed)
1
How to write off to a grant other than the grant itself?
1
How to write off less than $100 unspent, what ledger or spend cat to use
How to manage drawing more or less than what we invoiced . What are the steps for application of payment
1
How is budget date determined based on expense type
1
How to bill for expenses Pending Award Line Date Review – how to see more detail
1
How to find balances on account and apply them
How to refund if not all billed/paid was mapped, is this an issue
How to unapply payment from an invoice
b) Task issues
Template that will help populate quarterly financial reporting tasks
2
Milestone billing: how it works. What are best practices to monitor Installment awards?
2
Setting up notifications for tasks to Grant Managers?
3
c) Reporting
How to find cost reimbursement lines between two dates
2
FIN2075
Report of sponsor Approved invoices by award with invoice date, payment date, payment amount, remaining amount
2
USNH91375
How to add Employee name to reports
1
What are the business processes that each role is involved in: PI, grant manager, grant approver
1
How to find awards with no award group
1
How to find award lines not associated with a billing schedule
1
How to find cost share or program income award lines on a billing schedule?
F&A earned by FY report (by award and grant and PI)
3
Awards by Sponsor report modification to include the Prime Sponsor and Sponsor
Pay history by grant
SEFA
Subcontractor encumbrances
Update Grant Manager dashboard for Pis, and Grant Administrators
New: Drawdowns by award and date
e)Set up issues
Why is the grant getting F&A Recovery posted to it? How will the Trial Balance ever be clear for closing if so?
1
Should we migrate PIs to Eligible PIs?
2
Grant hierarchy: How to establish and optimize. Should we have a hierarchy for each PI? Are there other Grant hierarchies that we should be using/setting up?
2
Could you assess security roles set-up? Are there roles in Workday that we haven’t taken advantage of?
2
How do we set up email notifications to be sent from the Workday tenant?
2
How do we see what triggers Award Cost Processing?
f)Future state
How can we automate running zero-dollar Cost Reimbursement Installment invoices, or is that not necessary?
3
How can we print all supplier invoices included in a particular sponsor/customer invoice?
3
Can we format all reports to export with headers already filtered and freeze panes so we don't have to do it on every report?
3
How can we set up a SF425 integration so financial reporting is not manual?
3
g)Best Practices
Financial Aid
2
Letter of Credit
1
Carry forward
2
Closeout: what we should be looking for before inactivating award lines/grants/awards (which one(s)?)?
And how to ensure nothing posts to them?
2
Worked on the Workday Projects Implementation: (Completed the below requirements)
Project cannot proceed to approval stage until ALL details are entered
Summary with Key metrics to be generated
Function required for Stage 1 and Stage 2 approval process
Ability to Have sub-Projects
Project Owner must have ability to update project details
Project Reporting – Project vs Actuals
Reports Creation
Dashboards Creation
Alerts/ Notifications before project end date within 2months, 1 month and day of completion
After completion, if status still open (to allow for final payments) regular reminders to close project at earliest opportunity
Prompt when spend budget is almost exhausted
Cannot book spend if there is no approved (budgeted) funds
All relevant details must be entered and loaded to complete/ close a project
Capitalization
Fixed assets to capitalize the project after the project end date
Automatic Population of spend category
End to end tax implementation of Indian companies using third party integration, handling of various issues relating to tax . Building consolidation reports, tax reports, banking reports and other finance functional reports .
Handling of incidents, change requests and finance reporting requests. Assisting the team in resolving queries in service now on all modules – example break fix incidents related to requisition sourcing lines, double entered receipts, condition rules fixes. Handling client knowledge transfer and training . Issues worked on include workday new tax configuration and setup, payment application rules setup, revaluation reports, issues and discrepancies in multi-currency environment, finding workarounds for intercompany issues like payee not having bank accounts, payments not crediting to payees, intercompany requisition routing.
Day to day fixing of reporting issues (advanced and composite). Implementation of project module, building of complex custom reports with multiple data sources (budget, actuals, forecasts etc). Finding workarounds to specific issues in project accounting like defaulting worktags. Implementation of vendor portal and procurement module. Implementation of major changes to the project accounting module- Composite reports showing budgeted vs actuals (PO & Non-PO ) spends, capex vs actuals report, workarounds for spend category from projects defaulting on requisitions, alerts for project end date closed to project managers, adding forecasts to projects and reporting, making reasons on project end date change to be mandatory in projects through calculated fields on business processes.
Leading the AMS project for functional workday finance for a leading mobile network in the Caribbean. Handling of incidents, change requests and finance reporting requests. Assisting the team in resolving queries in service now. Handling client knowledge transfer and training . Issues worked on include workday new tax configuration and setup (SLU Levy) for St. Lucia, payment application rules setup, revaluation reports, issues and discrepancies in multi-currency environment, finding workarounds for intercompany issues like payee not having bank accounts, payments not crediting to payees, intercompany requisition routing.
CoreTeam
Completed the workday finance implementation of a German University which also involved merger. Modules specifically worked on FDM, Financial Accounting and Taxation. Configuration workbooks and test scripts created for these modules. Basic training for the core finance team members. Also handled previous backlog of AMS ticketing for all modules. Tax returns for UK, Singapore prepared in Workday. Previous system data conversion done using EIB’s. Merger activities like consolidation, chart of account listing, FDM impact analyzed and implemented. Also built complex composite reports like Gross Income roll forward reporting, Flux Balance Sheets and P/L, Invoices and Payments Reporting, Partnership reporting
Kognitiv India Private Limited
Worked on complex reporting requirements like cash flow statement with custom worktags for balancing, Investor and Third Party and other equity holder analysis, multiple layer drill down analysis reports, report bursting and grouping requirements, building substitutes to workday delivered reports for example building self-service reports in place of the requisition worklet.
Worked on complex incident handling situations like business process routing issues due to effective date issues, discrepancies in project labor cost entries during project labor cost summarization, advanced routing based on events like modifications to tasks/events, receipt accrual issues, routing based on step condition rules built out of calculated fields, workarounds for depreciation pro- ration on for disposal, workarounds for adjusting accounting when capitalized amounts on project assets still shows on the project, workaround for partial payments of intercompany payments etc.
Worked on partial/module implementation of the expenses and business asset module.
Built configuration workbooks for banking and settlement- including delivery assurance review templates.
Presentation given on chosen topic (Brown bag presentations)- Inventory Accounting
Internal certifications on Advanced reporting, matrix reporting, calculated fields and intermediate security
IBM India Private Limited
Worked in phased workday implementation- Requirement gathering, analysis, design. development, testing and post deployment product support. Worked with teams in end-to-end testing, preparing test cases for client specifications . Worked in preparing the specifications for the different financial modules. Functional experience in reporting, business process flows, business analysis, presentation and negotiation abilities. Also involved in the implementation finance module-wise on business assets, customer accounts and revenue management, banking and cash management. Developed many custom reports including composite reports for procure-to pay, accounts payables,accounts receivables,financial accounting & banking and settlement . Worked on data conversion and mapping using EIB and I-Loads for assets, conversion assets, customer invoices, bank and settlement functional areas.
Worked on the implementation of Project Labor for Financial Ombudsman UK– Defining the posting rules for Project Labor Costs and Project Labor Recovery, Standard Costing and Fully Burdened Costing, capitalization of projects (defining the work in progress account posting rule and WIP exclusion rules), project time entry calculations, investigating labor cost summary reversals, defining standard project cost sheets by creating project rate rules.
Part of AMS (Annual Maintenance Services or post production support) – Workday Finance team– Handling incidents, service requests, and complex change requests for the client. These are governed by strict SLA’s to which we need to adhere to. Identifying requirements, discussion, analysis and testing with users on the various modules of workday finance. Presenting the new release features for workday finance (presentations and demos). Conducting requirement analysis and feasibility of new features as well as implementing client acceptable workarounds for feature limitations. Involved in designing the Workday 2022- R1 and R2release requirements. End to end support is provided. Built composite reports, advanced reports for financial accounting and procurement modules. Handled issues during closing- for example changes in the business process required when control thresholds are not present. Building various calculated fields to fetch financial data in reports. Built matching rules and exceptions, included them in business processes to adhere to the procurement function- for example routing to the requisition requester, when total of supplier invoices is greater than purchase order or when any supplier invoice line is not attached to a receipt.
Webhelp India Private Limited
Assisted with the implementation of Workday, for over 1,000 employees in multiple locations across the world-like Nordics, APAC, South America, Greece. Created user guides for managers to follow when entering data into Workday as well as assisted with troubleshooting issues that arose during the implementation process.
Worked closely with implementation partners Kainos to fix the issues in the specifications and assisted other developers in building financial reports.
Worked as security administrator, maintain the user access to implementation tenants and configured maintained user based and role based security for employees and contingent workers
Analyse the user sign on audit report for the tenants and review the reports project manager. Built advanced reports for security audits.
Working through the internal ticketing software of company for handling/solving issues relating to Workday Finance Module on a daily basis for the finance team at Webhelp (internal users).
Worked with the implementation team – which managed the go-live of various new companies in the region. Part of planning, testing, business process analysis, analyzing reporting requirements and hyper-care support for the users.
Provided training to end users (finance team) on usage related to all workday finance modules
Part of implementing new projects (like major change requests involving major modification in the existing configuration/ new configuration) internally for workday finance modules like customer, supplier, banking, procurement expenses & financial accounting- involving requirement analysis, testing, presentation and implementation
Created the accounts payable and receivable & procurement dashboard.
Identifying and implementation of improvements to the finance end users- including analyzing the reporting requirements, implementing new workday features in the half yearly releases
Created advanced and simple reports based on user requirements for Workday Finance- like alerts for creating receipts on the purchase order, failed settlement run reports, prepaid amortization balance reconciliation
Identifying & troubleshooting errors related to EIB’s related to all workday finance modules. Suggesting the right EIB’s as per analysis of the user’s issue.
Scripting the storyboard (videos) for the internal learning dashboard for Webhelp for all modules
Masterex Technologies
Process Suppliers invoices with 100% accuracy
Book invoices PO, Non-Po and ensure compliances with tax
Resolve, in collaboration with Business operations, supplier billing discrepancies and related inquiries
Supplier Payments Domestic / International, as per guidelines.
Assisting in review and audit with external and internal auditors and maintaining the documentation.
Manage payments as per agreed PO terms, ensure adjustment of advances & TDS
Book Advances as per agreed terms in PO/Sub-contract
Process Intercompany invoices (book & allocate)
Manage Monthly /Quarterly Accruals (book & reverse accruals) for Project & non-project activities
Monitor Purchase Orders and liaise with procurement team for PO receipting / GRN and resolving PO discrepancies
Ensuring accuracy and quality, application of appropriate taxes / VAT on invoices
Process accounts payable adjustments for errors or omissions
Create and produce accounts payable related reports for management or other review
Ensure correct liability booking and reversal every month/quarter end/year end.
Timely tracking of yearly liability reversal as per statutory requirement and ensure reversal of TDS every month.
Manage Intercompany reconciliation confirmation process as per GL balances
Help desk for internal and external requests
Performing vendor and account reconciliations, open balances analysis and other AP month end activities as per statutory requirement
Working on payment gateways and other methods of Collection Receivables.
Manage SOD compliance and internal audit/External audit requirement
Manage internal training
Managing the Accounts Payable & Receivable cycle & GL for the smooth operations
Enabling operations of the Accounts Receivable (AR) section with focus on ensuring efficient processing (payment allocation, reconciliation and month-end reporting) of company receivables through SAP and timely collection in accordance to company policies
Facilitating reconciliation of accounts receivable trial balances with the general ledger control account. Ensuring payments schedules by due date and Postings cheques after Reconciliation with Accounts ledger & supplier statements and performing reconciliation – Bank, Intercompany & General Ledger
Gained expertise in ensuring accurate data management related to payment status and projected payment dates for forecast and other real-time reports. Generating weekly and monthly reports and analyzing AR data, providing analyses to management. Preparing outstanding ageing report and statement for Debit Balance & Unaccounted Documents
Ensuring documents data recorded with correct code after certification, allocation & verification (with invoice with accuracy and timeliness. Timely posting of all supplier invoices– checking documentation for completeness, accuracy, approvals as per policy, matching and input of supplier invoices.
Ensure that revenue pertaining to all projects is accounted for on time. Provide support to the global revenue and Billing Team for all billing matters where require. Driving time compliance for account to minimize late billing and lost billing.
Maintaining vendor & client relationships, responding on inquiry & resolving financial issues correlating with project team. Analyzing outstanding supplier commitments and taking timely action. Manage vendors list- Review supplier accounts; at the minimum, bi-annually and recommend de-activation of accounts that have been inactive for the last 6 months. Reconcile goods and other services supplier ledger balances to supplier statements. Soliciting quotations and preparing sheets for evaluation for procurement
Financial Analysis, Budgeting, Forecasting, highlighting financial impact of key risks and opportunities.
General Ledger; performing ledgers scrutiny with supplier/subcontractor SOA & keeping ledger balances up to date for monthly/quarterly & year-end closing. Posting JV entries after allocating Expenses & preparing schedule such as utilities, camp rent, office expenses and depreciation. Posting Adjustment entries in year-end closing
Auditing; Managing internal & external audit query & accomplishing documentation for audit compliance
Accounting Functions:
Maintaining fixed assets register & stock management for account closing with all related details, asset tagging, asset movement, asset disposal, repairs & maintenance etc.
Assisting to accounts manager in Preparing Cash flow, Trial Balance, P& L & Finalizing balance sheet
Tasks include Accounts Finalization, bank and credit card reconciliation reports, 3 way Goods Received Note (GRN) Matching, GRN Consumption, petty cash accounting, supplier invoicing and invoice posting, MIS reports in Excel and power point, making of Cash flow statements, receivables and payables reconciliations, Inventory, payables and receivables ageing, Recognizing unusual transactions, trends, variations and communicate findings. Publish Dashboard including health of the company, and create ad hoc reports as required. Liaising with for accounts closure, managing offsite team of 2 to 5 member in India and ensure prompt achievement of all deliverable targets, handling day to day queries relating to financial matters. Submission of Monthly reports & reconciliations by the last date of the month and ensuring all transactions have been entered on a real-time basis to the accounting system
Analyzed & filed financials of the company; prepared reports for filling investment proposals, accounting in Xero software, Prepare accrual analysis, journal entries and lead the month end close process, ensure prepayments are reconciled and cleared on time. Carrying out monthly allocation of staff Accounts and ensure relevant adjustment journals are passed. Processing staff TA’s, Travel Expenditure Report (TER’s) &Project/workshop expenditure reports.
Checking mathematical accuracy and internal consistency of financial statements, reconciling figures from financial statements to trial balance and bank confirmations, using pivot tables and vlookup to extract financial information from raw files and linking them to financial statements and recalculation of financials.
N Sharma & Associates
Monitored variety of tasks such as preparation of:
Statutory books of Accounts, Bank Reconciliation, Party Reconciliation and Consolidated Reports in compliance with time & accuracy norms
Financial reports, charts, tables and other exhibits as well as day-to-day general ledger accounting entries. Summarizing current financial status by collecting information & preparing the balance sheet, profit and loss statement, and other reports
ROC compliance activities such as preparing and filling of Form 23AC, 23ACA, 20B, 23B, DIN
(Director’s Identification Number)
Recording various intercompany transactions and cost allocations
Filing of Income tax returns, service tax returns, TDS returns and tax challans
Preparation of Vouchers, bank reconciliation and bookkeeping on Tally for various individuals and companies
.
Contact this candidate