Financial Analyst

VB Macros expert

Mandatory Skills :

• Should have Expertise in VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas/loop)

• Experience with consolidating extracted data from multiple resources using automated tools (excel, VBA macro, SQL database), and/or from different system/tools/Database

• Expertise in building complex VBA scripts to automate Excel spreadsheet processes.
  
  

Location : Chennai

Timings : UK shift

About Tredence

 

Tredence is a global analytics service and solutions company. This is one of the fastest-growing startup in Silicon valley. We have recently raised our Series A private equity. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in bringing the right mix of technology and business analytics to create sustainable white-box solutions that are transitioned to our clients at the end of the engagement. We do this cost effectively using a global execution model leveraging our clients' existing technology and data assets. We also come in with strong IP and pre-built analytics solutions in data mining, business intelligence and Big Data. 

 

Responsibilities & Description of the role

 

Role requires working with cross-functional teams and involves following key responsibilities –

 

• Co-own the financial plan of the business unit along with the business head
• Revenue governance (including client interactions for deal closures and contracting; forecasting, revenue recognition)
• Margin governance (including cost take-out initiatives, systemic and sustainable cost control, rate hikes, cost analysis)
• Working capital governance (including unbilled reduction, timely invoicing and collection, improving debt ageing and PDD)
• Commercial Structuring and Deal pricing
• MIS for the business unit including sales performance tracking and other analytics
• People management - internal stakeholder management
• Critical attributes to success would be strong communication, cadence and resilience.
• “Can do” attitude and faster learning curve

 

 

Must have Skills

 

- CA/MBA Finance from Tier I college with 4-5 years of experience

- Proven working experience as a Business Finance Partner

- Experience with creating data models

- Experience with general ledger functions and the month-end/year end close process

- Excellent accounting software user and administration skills

- Working knowledge of Microsoft Office, BI tools, Oracle Netsuite

 

 

 

Why join Tredence?  

 

There is a reason we are one of the fastest growing private companies in the country! You will have the opportunity to work with some of the smartest, friendliest, hardest working people in the data analytics space. You will work with the latest technologies and interface directly with the key decision stakeholders at our clients, some of the largest and most innovative businesses in the world. Our people are our greatest asset and we value every one of them. Come see why we’re so successful in one of the most competitive and fastest growing industries in the world.

 

Tredence 5 core values

• Think Impact
• Be Entrepreneurial
• Constantly curious
• Do the right thing
• Pursue Excellence

 

Hi

Greeting from MNR

Urgent opening - Assistant Manager - Payroll & MIS

Skills - MIS Reporting, Excel Expert, Strong Analytics, Dashboard, Payroll

Location - Mumbai

Job Description -

Incumbent will be responsible for leading the entire portfolio of HR Payroll, Compensation & Benefits, HR analytics and reporting, administration support, HR compliances and HR data integrity management.

Responsible for the end-to-end process of Payroll, Comp & Ben and Monthly MIS reports.

HR dashboard creation for consumption by senior stakeholders including Management Committee reviews, HR leadership teams.
This process will involve consolidation of data from different HR teams, ensuring data hygiene, accuracy, timeliness of data inputs.
It will entail analysis and reporting critical HR metrics including Headcount, Attrition, Diversity, Recruitment etc., on a regular frequency (monthly/quarterly), along with servicing requests received from time-to-time from other relevant/senior stakeholders.
Leads the process on variable pay provisioning to provide an accurate estimate of the variable pay spends in the company.
Ensure accurate and timely processing of payroll updates including new hires, terminations, and changes to minimum wages.
Prepare and maintains accurate records and reports of payroll transactions.
Ensure compliance with statutory laws and best practices.
Facilitate audits by providing records and documentation to auditors. Identifies and recommends updates to payroll processing software, systems, and procedures.
Provide support on all compensation & benefits processes including but not limited to generation of increment and other compensation letters, calculations including maintenance of permanent & contractual salaries, benefits administration and policy updates, maintenance of relevant documentation across these processes, resolving any queries around benefits, creation and maintenance of master MIS files for leadership, transfer letters generation, calculation and disbursement related process of salaries etc.
Administer Query resolution related to payroll, PF, ESIC and full and final settlements.
Coordinate with external vendor/agencies to run the compliance process for unit HR.
Responsible for multiple MIS reports and Analytics regarding manpower, payroll and employee benefits with Standardization of reports for better decision making.
Verification & Reconciliation of monthly payroll, manpower, attrition data.
Work in close collaboration with the HR Operations team to ensure data integrity and process controls are instituted and maintained. Audits the quality of data and takes corrective actions with relevant teams including HRIT/ Shared services/ HRBP spocs/ COE spocs etc. from time to time to ensure reporting accuracy and quality are maintained.

Skills required
High proficiency in MS Excel skills. (High Excel skills with analytics is a must)
Ability to deal with large amounts of data and put structure to the same.
Experience in making dashboards, reporting and analysis.
Strong analytical and problem-solving skills.
Exposure to HR payroll systems, will be an added advantage.
Attention to detail and delivery excellence.
Timeliness, responsiveness, accuracy and process compliance.
Ability to work with a large number of stakeholders.

 

To complete the financial analysis and projection modelling for ongoing monitoring of the high yield
loans for an UK based commercial bank
Analyzing and spreading the historical financial statements in excel
Analysis of financial statements including Income Statement, Balance Sheet and Cash Flow Statement
(incl. Free cash flow, funds from operations) of public and private companies
Going through the supplementary schedules, notes and MD&A for the detailed breakups and
normalizing the financial statements for exceptional items to arrive at the true profitability figures
Analyze the operating metrics to project the major line items like Revenues, EBITDA etc.
Preparing detailed capital structure and debt amortization schedules (tranche wise) including pro forma
adjustment for the acquisition. Candidate should have strong understanding of various classes of debt
(secured/unsecured/subordinated) and financing options used by the borrower for the deal
Analyzing the pro forma credit metrics like total leverage, interest coverage, fixed charge coverage etc.
Analyzing the financial covenants applicable to the borrower
Strong understanding of financial projections based on management guidance, company budget and
consensus estimates. This will include creating various scenarios like management case, sponsor
case, upside and downside case etc.
Screening the merger agreements and assessing synergies from the deal based on management
inputs and third party data sources
Strong understanding of calculating IRR and various valuation techniques like DCF, Peer multiple and
liquidation based recovery analysis for various debt pieces using recovery values for each asset type
Conducting detailed Quality Checks and delivering to the client
Responsible for achieving 100% quality
Meeting strict deadlines and ability to work under pressure
Ability to work individually and in the team
Update reporting manager on the tasks in hand, completed on a regular basis
Communicate with onshore Risk team for providing regular update and workflows
Provide inputs, involved in discussions and Implementing new ideas to generate efficiency

Requirements-
MBA (Finance) / CFA / CA (CPA equivalent)
Experience of 4 - 6 years in financial modeling and analysis using excel
Proficient in MS Excel
Prior experience of working on LBO models is preferred
Excellent written and spoken communication skills

JOB Description

A London based foreign bank has a requirement of shifting its credit MIS to back office and thus has an immediate opportunity for a contract role for the MIS function.

Job Responsibilities:

You will be required to prepare MIS based upon existing standard operating procedures (SOP).

Process	Description
ODA file	Update limits, limit expiry dates, calculate availment of limits for multi-currency OD limits, limits against FD etc
Limit Sanction statement	Preparation of list covering all the credit facilities sanctioned during the reporting month
Consolidated data	Preparation of industry-wise, country-wise data of entire credit portfolio of the bank
Credit dashboard	Pictorial representation of the credit portfolio based on various parameters
India based exposure	Reporting of India based exposure to parent bank
Real estate exposure	Add new accounts opened
Real estate exposure	Update exposure by updating the latest position of undisbursed loan amounts as on reporting date
Real estate exposure	Update value of security, cost of project, Gross Development Value etc
Real estate exposure	Add loans under process and loans sanctioned but not disbursed. Remove loans which have been disbursed.
Key risk indicators	Update the KRIs as requirement of Risk Department
Largest and second largest exposure	Select largest and second largest inflow
Restructured accounts	Reporting of accounts which have been restructured
Loan file	Instalment-wise breakup of the term loans in the credit portfolio and identification of addition of irregular accounts
Control of capital adequacy	Analysis of inflow and outflow based on proposals under process and expected repayments
Valuation, Visit, Insurance	Reporting of pending valuations, visits and insurance
IFRS 9	1. Collating information from various sources to populate respective information sheet (3c File data). 2. To assign staging to each loan account as per bank approved document.
BTL regulatory reporting	Reporting for Residential BTL Loans

The candidate should have good knowledge of Microsoft Office Suite (Excel, Word) comprising of H/V Lookup, Data Flow Charts & Graphs, Pivot Table.

Candidate having knowledge of the following will be preferred

1. Fair understanding of credit functions

2. IFRS 9 application – ECL, stage 1/2/3

3. Banking products related to loans and advances TL, OD etc

4. NPA – days past due, standard, sub standard

5. LTV- LTC , GDV

6. Property type – Residential, Commercial, W/H, Industrial

7. ROI – Libor, fixed, floating

 

Desired Candidate Profile

What you need to have:

• MBA from a premier institute/ CFA (USA)/ CA (ICAI)
• 6 – 8 years of post-qualification experience
• Experience in an investment bank, consulting firm, rating agency or corporate finance/strategy division of corporate or financial institution
• Clear financial and quantitative concepts
• Strong logical and analytical abilities
• Good communication, presentation and inter-personal skills
• Very strong Microsoft Excel financial modelling skills
• Openness to travel overseas for extended periods (3-4 weeks) for client meetings and on-site execution    

VBA Developer With SQL
VB Script
VB.6
VB Advanced Excel
Bangalore/Chennai/Hyderabad

Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA Formats extracted data based on expected report output with batching capability and multiple data formatting requirements Consolidate and combine extracted data from multiple resources using automated tools excel, VBA macro, SQL database, and/or from different system/tools/Database in one single database using SQL queries to standardize data structure

Professional Attributes :
Gathers and analyse report requirements from stakeholders Identify the processing tool Excel / SQL and provide a robust solution which can be easily leveraged or extended to other domains Building complex VBA scripts to automate Excel spreadsheet processes

To develop Competitive strategy and operational effectiveness in Mergers and Acquisitions for the organisation.

The role demands high acumen in establishing expansion strategies for Recykal. Identifying business opportunities and planning integration for effective and strategic management of long-term growth through key investment initiatives.

The individual will be working collaboratively across functions (including Legal, Finance and People Operations) to identify and evaluate both acquisition and investment opportunities.

Key elements of the role include:

 

• Provide high-quality analysis on projects including critical industry or market analysis, company reports, ad-hoc requests, financial analysis, driven benchmarking and opportunity assessments through in-depth research
• Source deals through targeting and screening of potential acquisitions and other investments
• Develop inorganic growth strategies and priorities for practice areas
• Negotiating and structuring complex partnerships that provide the opportunity for strategic investment or eventual acquisition.
• Drive strategic analysis of investments (market and competitive analysis, business model development) and divestiture opportunities
• Support the development of the financial business case for investment
• Work cross-functionally with (Product, Business, Finance, etc.) to support diligence activities.
• Ensure that cross-functional teams are executing their respective M&A integration plans.
• Responsible for presenting business insights through Management meetings for improvising business Performance for Acquired Entities.
• Building financial models as it relates to deal analysis and completion.
•  Identify, track and monitor risks and issues for multiple projects.
• Support multiple concurrent acquisitions, divestitures and other transactions.
• Supporting sector/product teams and clients throughout the deal life cycle.
• Executing a range of tasks including but not limited to preparing pitch-books, modelling and valuation (merger models, accretion dilution, LBO, DCF, SOTP, etc.), industry studies and analysis, trading and transaction comps, company profiles, identification of potential targets and buyers, macro-economic analysis, market and sector updates, capital structure analysis, rating advisory etc.
• Exercise attention to detail while conducting the required analysis
• Build sector knowledge over a period, and add value and insights
  
  

We are looking for:

 

• MBA with 5+ years of relevant experience in M&A strategy / corporate development team
• Experience in deploying and supporting enterprise solutions to Retail, High Tech, Healthcare and/or Manufacturing industries
• The candidate should have the ability to work as part of the team and independently as per the requirement
• Expertise in financial analysis, modelling and valuation Core competencies
• Expertise in business model development, M&A diligence, and/or investment analysis
• Expertise in the application of strategic frameworks and analysis to business problems
• Strong & structured problem-solving skills in an ambiguous and unstructured environment
• Excellent valuation/analytical and problem-solving skills
• Stakeholder Management and Ability to build relationships with people across all levels and organisations, internally and externally
• Exhibits business and financial acumen to develop meaningful business recommendations
• MS Office skills - should be good in MS PowerPoint, MS Excel, and MS Word
• Excellent communication skills

About Recykal

Recykal is India’s first w-commerce company to provide end-to-end solutions to all stakeholders in the waste management ecosystem, beginning with bridging gaps in supply-demand of recyclables with Marketplace ; Helping brands fulfil their sustainability targets with EPR Loop ; and digitising local waste management centres with Smart Centre Solutions , and more.

 

We operate in 28 states and 6 Union Territories, successfully channelising 250,000 MT+ of waste in 2021; with a target of achieving 2 million MT in 2025. We are partners with 190+ Urban Local Bodies (ULBs), 210+ brands (e.g. Marico, Pidilite, Unilever, Samsung, LG), 325+ recyclers and 1050+ aggregators.

 

We have been recognised on a global platform by the World Economic Forum, Forbes, Circulate Capital and more; on a national level we have won accolades for innovation by FICCI, CII, and NASSCOM.

 

At Recykal, we harness and promote talent, innovations and everything groundbreaking. Interested? Let us build a futuristic solution for one of the biggest challenges we are facing as of today.

Job Description:

 

ABOUT THE COMPANY

 

KORCOMPTENZ is a technology transformation solutions integrator. Over 17 years of experience providing technology transformation services for over 200 clients. Microsoft Gold Partner with certified functional and technical resources. Extensive experience serving Fortune 500 companies, SMBs, and non-profits with a trusted global delivery model.

 

KORCOMPTENZ is a people-oriented company that provides our associates with opportunities to grow as professionals, domain experts, and leaders. We offer an open work environment, state-of-the-art infrastructure, transparency, constant training for technical and soft skills, competitive opportunities to test employees’ critical thinking and creative abilities, and much more.

 

If you are looking to make a significant impact on your career and overall growth, KORCOMPTENZ is the right place. We offer an energetic work culture where learning is an everyday affair. We encourage our employees to achieve their fullest potential by providing independence, the right environment, and guidance.

 

Job Title: AX D365 F&O Finance functional consultant

Roles & Responsibilities:

 

• 5-8 years of overall professional experience in Microsoft Dynamics 365/AX Functional.
• Should have minimum 2-3 implementations on D365 Finance and operations for a Global organization.
• Ability to translate business requirements into functional solution design.
• Extensive experience in Finance, GP, AR, AL
• Experience with setup, configuration, implementation, integration and testing of AX / D365 F&O solutions using best practices implementation methodology and/or Microsoft Sure Step methodology.
• Excellent understanding ERP Business Processes, industry vertical knowledge.
• Experience in design and creating test scenarios, functional test cases and User acceptance testing.
• Coordinating with the Technical Team for development / customization.
• Certified on Dynamics AX / D365FO at desired levels.
• Excellent communication and good customer approach.
• Must be able to work effectively both in a team environment and individually.

Qualification:

 

• Preferably a Post Graduate / Graduate with relevant Dynamics work experience.

 

Other Requirements

 

• Can do attitude.
• Highly motivated to bring fresh thoughts to the table.
• Highly creative and most importantly willing to exercise it
• Self-starter and Self-learner focused on research and learning.
• Ability to play a variety of roles and most importantly take accountability.

Hello All, Hope you are doing well! We are hiring for :Finance Executive ; Fixed off (Saturday & Sunday) Location-Kharadi,Pune, Shifts starting from 6:30PM. Preferable Candidate's who have past experience in B2B domain . In case due to current project you are unable to work with us, I would highly appreciate if you can refer any of your colleagues who might be interested for this position