1016 Hlookup Jobs - Page 12

Develop & maintain MIS, using excel functions such as Pivot Tables, VLOOKUP, Conditional Formatting to identify trends, patterns & improvement opportunities. Design, build & automate Excel-based dashboards. Collaborate with cross-functional teams. Required Candidate profile Expertise in Advanced Excel (Pivot Tables, VLOOKUP, Conditional Formatting, Charts, Dashboards). Ability to interpret complex datasets and present findings in a clear, concise manner.

Prepare daily, weekly & monthly reports using Excel formulas Create presentations for monthly reviews Perform data analysis & generate insights Build dashboards & visualizations for management Collaborate with teams to gather reporting needs

Handling calls and mails regarding PF and Non-PF. Consolidation of Non-PF report.

1. The role would offer an opportunity to work on ops & growth related tasks & initiatives for Online Business. 2. Should possess an ability to work with multiple cross functional stakeholders. 3. Be responsible for handling day to day business operations and coordination with both external and internal stakeholders across varied industry segments. 4. Be responsible for management of monitoring, business reporting and any ad hoc reporting required from time to time. Proficient knowledge of excel/ google sheets is a must. 5. Strongly focused on execution, hustler, proactive learner with a go-getter attitude. 6. Merchant-first attitude. Coordination with various stakeholders while handling escalations on a day to day basis to provide prompt resolution to the merchants, ensuring best merchant experience. 7. Addressing internal queries, data requirements and escalations regarding category transactions. 8. Data Analytics Support & trendline reasoning - i. Monitoring & extracting relevant data points & MIS from our analytics dashboards for further actioning ii. Transaction analysis (increase/ dip) & follow-up with partners on reasons thereof iii. MCC mapping, coordination for MCC clean-up & monitoring iv. Biz & Product health analysis v. Track ETA vs closure of due analyses 9. Offers & CRM - Work closely with internal teams to set up offers, promotional 10. Collaborate with internal and external business + technical teams to spearhead integrations and go-live. 11. Following up for agreement closures and invoice payments. 12. Working with internal teams, to ensure timely account launches - by overseeing payment solution roll-outs. 13. Solving payments-related escalations and refunds & settlement-related issues 14. Providing a bridge between merchants operations/ accounts teams and our internal stakeholders. 15. Identifying areas of operations that require automation and coordinating with stakeholders for implementation of the same. : 1. Minimum work experience of 1-2 years in the operations/ fintech/ payments industry. 2. A-driver-personality - constantly pushing toward clarity and delivery while balancing the need for a great collaboration. 3. Orientation to execute multiple activities in a seamless manner. 4. Strong communication skills and ability to negotiate for one's requirements. 5. Strong stakeholder management skills. 6. Ability to deal with ambiguity in a fast-paced target focused environment 7. Advanced knowledge of Excel/ Google sheets. 8. Qualifications - Graduate/MBA from tier 1 or tier 2 college preferred. PhonePe Full Time Employee Benefits (Not applicable for Intern or Contract Roles) Insurance Benefits - Medical Insurance, Critical Illness Insurance, Accidental Insurance, Life Insurance Wellness Program - Employee Assistance Program, Onsite Medical Center, Emergency Support System Parental Support - Maternity Benefit, Paternity Benefit Program, Adoption Assistance Program, Day-care Support Program Mobility Benefits - Relocation benefits, Transfer Support Policy, Travel Policy Retirement Benefits - Employee PF Contribution, Flexible PF Contribution, Gratuity, NPS, Leave Encashment Other Benefits - Higher Education Assistance, Car Lease, Salary Advance Policy Working at PhonePe is a rewarding experience! Great people, a work environment that thrives on creativity, the opportunity to take on roles beyond a defined job description are just some of the reasons you should work with us. Read more about PhonePe on our blog. Life at PhonePe PhonePe in the news

SUMMARY Maintain department-wise MIS reports using Excel and connected tools Use automation (Apps Script/macros) or SQL queries to streamline data Build dashboards or data visualizations to support decision-making Extract and clean raw data for performance reports, audits, and weekly reviews Collaborate with cross-functional teams (sales, inventory, logistics, etc.) Present insights and help solve real business problems using data Requirements Proficiency in Excel (vlookups, pivot tables, logical formulas, etc.) At least one additional skill from the following - SQLPowerBI / Tableau / ZohoAnalytics / GoogleApps Script Comfortable working with Google Sheets and cloud-based documents Ability to clean, organize, and present large datasets clearly Willingness to learn and work across departments Stable employment history we prefer candidates with at least 1 year in one role

: Job TitleFund Accounting/ Reporting Analyst Location Jaipur, India Role Description Our Fund administration team is working with some of the top names in the fund industry. Youll be working in one of the teams responsible for managing the end to end processes related to securities and portfolio / fund valuation for client segments like Mutual Fund, Alternative Investment Fund, Portfolio Managers, etc. Our fund administration team uses one of the best platforms available in the fund accounting space which is robust enough and at the same time offers flexibility to parameterize the system as per local needs and regulations. Our team of experts will be there to coach and support your development to ensure you excel in this role. Enhance your career prospects through exposure to the diverse nature of funds like Money market, Equity, Arbitrage, Exchange traded, hybrid funds, etc handled and serviced by Fund administration division. What well offer you . 100% reimbursement under child care assistance benefit (gender neutral) Sponsorship for Industry relevant certifications and education Accident and Term life Insurance Your key responsibilities Computation and reconciliation of NAV, checking income accruals, NAV movement, etc Reviewing Bank and Holding reconciliations and resolving breaks, if any Processing and verification of all trades for the day processed in the system Valuation / pricing of securities Coordination with client for trades. Coordinate with Registrars for Unit Capital files and checking and processing the same in the system Monitoring the email instructions for trades and other instructions including Custody instructions. Computation of Income equalisation and distributable surplus Computation and Dissemination NAV to the Press, Registrar, etc. Trial Balance Scrutiny Audit co-ordination and finalization of accounts Your skills and experience 3-4years of experience Knowledge of Mutual Fund Accounting and operations Understanding of capital / Financial / derivative market Understanding of various valuation tools and methodology Good communication and presentation skill How well support you About us and our teams Please visit our company website for further information: https://www.db.com/company/company.htm We strive for a culture in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively. Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group. We welcome applications from all people and promote a positive, fair and inclusive work environment.

Designation: Key Account Manager Qualification: Any graduate with 1 year of experience/ MBA fresher Compensation: CTC Up to 29K Skills Required: Good Communication & Interpersonal Skills. Having business knowledge. And understanding of e-commerce platforms and products. Good at thought process and sales knowledge.Excel knowledge is Important.The candidate must know mathematical calculation. English and Hindi is mandatory. Role & Responsibilities: The candidate will be working as a Key Account Manager he/she will be given around 20 to 30 sellers under them which they have to take care of those entire account from business development, advertising, marketing, strategizing to increase revenue of these sellers by analyzing and comparing different data. The KAM Should have excellent E-commerce Knowledge. He/she should have an understanding of how e commerce works and various strategies to increase revenue. Some of the key responsibilities for this position may include: Conducting market research and staying up to date on industry trends, working on Price reduction, Advertisement revenue, ROI. Preparing and submitting regular reports on sales activities, including Sellers connect. Achieving and exceeding ROI & revenue targets. Innovative ideas for increasing sales and revenue of the sellers in E-Commerce marketplace. Mode of work: Work from Office Address: 41, St Johns Rd., Rukmani Colony, Shivaji Nagar, Bengaluru, Karnataka 560042 Google Map Link: https://goo.gl/maps/uu2BmhVF2cES2SKd7 Candidates can also walk in directly by mentioning Naukri as a reference. Contact Person: Shriti - 6203531372

Roles and Responsibilities Manage day-to-day operations of HR Shared Services, ensuring efficient processing of employee data and records. Utilize advanced Excel skills to maintain accurate and up-to-date HR databases, reports, and dashboards. Collaborate with stakeholders to identify business requirements and develop solutions using MS Office tools such as Excel sheets, pivot tables, VLOOKUPs, conditional formatting, etc. Develop expertise in recruitment operations by managing end-to-end recruitment processes from job posting to onboarding new hires. Provide support for HR analytics initiatives by analyzing data trends and providing insights to inform strategic decisions. Share your cv on 6356708870

- 3–5 years of experience in an operations, analytics, or process management role - Advanced proficiency in Excel (pivot tables, lookups, nested formulas, macros), SQL - Strong analytical and problem-solving skills

We are looking for a seasoned MIS Manager to lead and manage all Management Information System (MIS) related activities within the Accounts Operations team. The ideal candidate will be responsible for designing, implementing, and maintaining robust reporting systems, dashboards, and data analysis frameworks to support decision-making, financial reporting, and operational efficiency. Key Responsibilities: Develop, manage, and maintain comprehensive MIS reports and dashboards for accounts and finance operations. Automate periodic reports and streamline manual processes to improve efficiency and accuracy. Perform data extraction, transformation, and analysis from various accounting and ERP systems (e.g., SAP, Tally, Oracle). Ensure timely and accurate preparation of daily, weekly, monthly, and quarterly financial/operational MIS reports. Analyse financial data to identify trends, variances, and performance indicators, and present insights to management. Coordinate with cross-functional teams (Finance, Audit, Compliance, IT) to ensure data integrity and alignment. Manage and ensure the accuracy of large data sets, ensuring data consistency and security protocols. Assist in budget planning, forecasting, and cost control analysis through data modelling and projections. Develop and implement controls and procedures to ensure data quality and governance. Train and support junior staff on MIS tools, reporting techniques, and best practices. Required Skills and Qualifications: Graduate/Postgraduate in Commerce, Finance, Statistics, or a related field. 10+ years of relevant experience in MIS management, preferably in finance or accounts operations. Strong command over MS Excel (advanced), PowerBI/Tableau, and SQL. Experience with ERP systems like SAP, Oracle, or Tally is a must. Strong analytical, problem-solving, and organizational skills. Excellent communication and presentation abilities. Ability to work independently and handle multiple priorities under tight deadlines. Work Type: Full-time | On-site Vadodara Office Compensation: As per industry standards

Roles and Responsibilities Prepare daily, weekly, and monthly reports on sales performance using Excel. Utilize HLOOKUP and VLOOKUP functions to analyze data and create insightful reports. Develop formulas to calculate metrics such as total sales, average sale price, and inventory levels. Create charts and graphs to visualize trends and patterns in the data. Collaborate with team members to identify areas for improvement in reporting processes. Desired Candidate Profile 0-1 year of experience in a similar role (preferably in retail industry). Bachelor's degree in B.Com or equivalent specialization (any discipline). Proficiency in basic computer applications including MS Office Suite (Word, Excel) with expertise in Excel Report Preparation.

Mis executive required at nathupur, sonipat Qualification - any graduate Salary- 18000 Timing- 9.30- 7

Skill required: Record To Report - Account Reconciliations Designation: Record to Report Ops Analyst Qualifications: BCom Years of Experience: 3 to 5 years About Accenture Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Technology and Operations services, and Accenture Song all powered by the worlds largest network of Advanced Technology and Intelligent Operations centers. Our 699,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries. Visit us at www.accenture.com What would you do You will be aligned with our Finance Operations vertical and will be helping us in determining financial outcomes by collecting operational data/reports, whilst conducting analysis and reconciling transactions.Posting journal entries, preparing balance sheet reconciliations, reviewing entries and reconciliations, preparing cash forecasting statement, supporting month end closing, preparing reports and supports in audits.A type of general ledger account which contains a summary of sub-ledger accounts. Because the reconciliation account only provides a summary, no transactions are directly posted to the account. What are we looking for ... Roles and Responsibilities: In this role you are required to do analysis and solving of lower-complexity problems Your day to day interaction is with peers within Accenture before updating supervisors In this role you may have limited exposure with clients and/or Accenture management You will be given moderate level instruction on daily work tasks and detailed instructions on new assignments The decisions you make impact your own work and may impact the work of others You will be an individual contributor as a part of a team, with a focused scope of work Please note that this role may require you to work in rotational shifts Qualification BCom

Skill required: Record To Report - Fixed Asset Accounting Designation: Record to Report Ops Analyst Qualifications: BCom/Any Graduation Years of Experience: 3 to 5 years About Accenture Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Technology and Operations services, and Accenture Song all powered by the worlds largest network of Advanced Technology and Intelligent Operations centers. Our 699,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries. Visit us at www.accenture.com What would you do You will be aligned with our Finance Operations vertical and will be helping us in determining financial outcomes by collecting operational data/reports, whilst conducting analysis and reconciling transactions.Posting journal entries, preparing balance sheet reconciliations, reviewing entries and reconciliations, preparing cash forecasting statement, supporting month end closing, preparing reports and supports in audits.Design and implement process and solutions to record and process all aspects of fixed assets accounting. Includes chart of accounts alignment, back office integration, folio management, payment processing, transfer & retirement of assets, physical inventory and Construction In Process (CIP) project accounting. What are we looking for Record to reportRecord to report Roles and Responsibilities: In this role you are required to do analysis and solving of lower-complexity problems Your day to day interaction is with peers within Accenture before updating supervisors In this role you may have limited exposure with clients and/or Accenture management You will be given moderate level instruction on daily work tasks and detailed instructions on new assignments The decisions you make impact your own work and may impact the work of others You will be an individual contributor as a part of a team, with a focused scope of work Please note that this role may require you to work in rotational shifts Qualification BCom,Any Graduation

Key Responsibilities: Create and maintain daily, weekly, and monthly MIS reports. Use Advanced Excel functions (VLOOKUP, HLOOKUP, INDEX-MATCH, Pivot Tables, Macros, etc.) for data analysis and reporting. Automate reports and improve existing reporting processes. Analyze large datasets and provide actionable insights to management. Ensure data accuracy, integrity, and timely updates of all reports. Support cross-functional teams with data-driven reports and dashboards. Collaborate with departments to understand reporting requirements and deliver solutions.

Maintain daily order trackers (Excel/Google Sheets),Manage dispatches and track shipments with 3PL partners ,Escalate issues like delays, damages, and returns, Support order fulfillment on Shopify,

Role Purpose The purpose of the role is to provide timely, accurate and quality MIS reports, dashboards to the external & internal stakeholders of account(s) as per the defined process and standards of security and compliance Do Prepare timely and accurate MIS reports and dashboards as required by the stakeholders Interact and work closely with management, internal stakeholders & clients to understand the business information needs Ensuring all reports & dashboards are prepared as per stakeholder requirements as per the desired frequency (weekly/ monthly/ quarterly) Ensure regular review with the MIS Team Lead for 100% accuracy before populating any customized dashboard or generating any customized report Track and follow up with relevant stakeholder for timely updation and data management of parameters (key SLA metrics such as run-rate etc.) Generate account level reports (billable and non-billable) on forecasting, scheduling (both onshore and offshore) and performance against SLAs, CSAT, Quality etc. Ensure zero non-compliances on process audit on data security and compliance Support and adopt tools and systems for efficient MIS generation and reporting system Continuous support to the manager in rolling out new techniques and initiatives to increase productivity Providing update to the manager on the progress of any new MIS initiatives Perform periodic maintenance and servicing of MIS system to improve operational efficiency Adopt new tools, technology solutions and develop capability through training to improve own productivity. Develop analytical skills and understanding of statistical analysis to suggest improvement in the quality of analysis Deliver No.Performance ParameterMeasure1.MIS Management and ReportingQuality of Analysis Zero errors in reports Zero non-conformance on timelines with respect to the client/ stakeholder requirements2.Stakeholder ManagementCustomised dashboards as per client and functional requirements Zero escalations on data reporting Zero non-conformance on security or compliance requirements3.Team ManagementTeam attrition %, Employee satisfaction score Mandatory Skills: L&P Policy Acquisition & Servicing. Experience3-5 Years.

Role - Business Analyst/Data Analyst Location - Gurugram (Haryana) Only Female Candidates are required to apply. Freshers are considered with Good Advance Excel. Roles and Responsibilities Formulates reports highlighting different trends leading to fulfilling business goals. Analyze data sets, draw meaningful insights by presenting through excel-based charts. Coordination with cross-functional teams and conducting virtual calls daily with respective teams. Microfinance knowledge would be added advantage. Be self-motivated and looking to do additional work by spearheading additional reporting clean-up/projects. Validate various data-pulls for accuracy and completeness. Effectively communicating with the Sr. management and helping them take business decisions by transforming data to meaningful analytical reports. Very strong reporting skills couples with business intelligence to get a deep understanding of the stakeholders reporting requirements so that they can be represented simply adequately to drive operational excellence . Qualification Graduate/ Post-graduate Key Skills Analytical Creative Passionate Presentable Communication Skills Good interpersonal and communication skills Computer Skills Should be well versed with MS Excel (Advanced) VLOOKUPS, Pivots, Conditional Formatting, Nested Ifs, COUNTIFS, SUMIFS, Data Validation, Slicers, etc. Interested candidates can directly apply or share their updated cv at nandini.singh@satincreditcare.com

Explain about admission procedures and courses offered to the prospective students and their parents through phone calls, emails and face to face meetings. Support parents throughout the admission process by answering their queries and helping them to complete the required documents. Maintain the target metrics by converting prospective students into confirmed admission and succeed in achieving the performance goals. Review the student applications for the eligibility and academic qualification. Participate in the decision-making process for student admissions based on school policies and guidelines. Prepares and presents reports to the centre head / Management as and when required. Maintain regular communication with students, parents, colleagues and external agencies for coordinating admission activities and resolving problems. Perform centre administrative and clerical activities when needed. Educational qualifications preferred Category: Bachelor's Degree Industry: EdTech Role: Counsellor Required Knowledge: Counselling Knowledge and Prior Experience in Counselling will be added advantage Local and English language proficiency Excel and Google Sheet Knowledge Required Skills: Communication Skills Team Work Critical Thinking and Problem Solving Planning and Organizing Activities Natural curiosity to learn Proficiency in Excel/Google Sheets

We are seeking a detail-oriented and analytical MIS Executive to join our team in Chennai. The ideal candidate will be responsible for managing and maintaining our Management Information Systems, generating reports, and supporting data-driven decision-making across departments. Key Responsibilities Design, develop, and maintain MIS reports and dashboards. Collect, analyze, and interpret data to support business operations. Ensure data accuracy and integrity across systems. Coordinate with various departments to understand reporting needs. Automate repetitive reporting tasks using Excel, SQL, or other tools. Monitor system performance and troubleshoot issues as needed. Maintain documentation for processes and reports. Required Skills & Qualifications Bachelors degree in Computer Science, IT, or a related field. Proficiency in MS Excel (VLOOKUP, Pivot Tables, Macros). Knowledge of SQL and database management is a plus. Strong analytical and problem-solving skills. Excellent communication and organizational abilities.

Job Description Supervise and manage housekeeping staff to ensure office cleanliness and upkeep. • Conduct bank transactions and errands as required. • Manage vendor bills including verification, submission, and timely payment processing. • Deliver important documents securely and promptly • Execute various office errands to support daily operational needs. • Maintain accurate and organized records and files. • Assist in administrative projects as directed by management. Requirements Basic proficiency in Microsoft Excel. • Strong organizational skills and attention to detail. • Ability to handle multiple tasks efficiently and independently. • Good interpersonal skills for managing and interacting with housekeeping staff and external vendors. • Dependable, trustworthy, and capable of maintaining confidentiality. • Minimum qualification: High School Diploma; additional education or certifications in administration preferred. • Good command of spoken and written English. • Knowledge of local languages is advantageous. ( Only Female Candidates can apply ) Benefits : Compensation: Competitive salary with performance-based incentives. Health: Comprehensive health insurance and wellness programs. Development: Opportunities for professional development and career advancement. Culture: Fun and collaborative work environment with regular team-building activities

Job Title: Business Analyst for FMCG co at Chennai Department: Strategy / Commercial / Business Intelligence Location: Chennai Reports To: Head of Business Job Purpose: To provide data-driven insights and strategic recommendations to support key business decisions across sales, marketing, supply chain, and finance functions within the FMCG sector. Key Responsibilities: Data Analysis & Reporting Analyze sales, distribution, market share, pricing, and promotional performance across channels and categories. Create and maintain dashboards and KPIs using tools like Power BI, Tableau, or Excel. Conduct trend analysis and forecasting to support demand planning and sales strategy. Business Insights & Strategy Support Translate data into actionable insights to support growth initiatives, product launches, and market expansion. Support cross-functional teams in identifying performance gaps and opportunities for operational efficiency. Category & Market Analysis Conduct competitive analysis and benchmark company performance against key FMCG players. Work with marketing teams to evaluate campaign effectiveness and ROI. Cross-functional Collaboration Liaise with sales, marketing, supply chain, and finance teams to collect business requirements and ensure data alignment. Collaborate with IT or data engineering teams to improve data infrastructure and quality. Project Management & Support Support strategic initiatives and business transformation projects with data modeling, financial analysis, and scenario planning. Prepare executive presentations and business review reports for senior management. Qualifications & Experience: Bachelors degree in Business, Economics, Statistics, Engineering, or related field. MBA is a plus. 3+ years of experience in business analysis, preferably in FMCG, retail, or consumer goods. Proficient in Excel, SQL, and BI tools (Power BI, Tableau, or similar). Experience with ERP systems (SAP, Oracle) is advantageous. Strong analytical and problem-solving skills with attention to detail. Key Competencies: Business acumen and commercial awareness Strong communication and presentation skills CTC: Maximum gross up to 9 LPA based on current salary If your experience suits our JD, Pl send your updated resume to jobs@banyantalenthr.com

Job Title - Executive Service Operations (Settlement) Exp. - 1-5 years Location - Marol, Andheri East (Mumbai) Areas of Responsibility Timely claims submission to insurers with desired accuracy. Discrepancy management and responsible to conduct timely reconciliations Flexible to work in calibration with internal and external stakeholders. Qualification & Experience Required Graduate or Equivalent. Minimum 1 year experience in General Insurance Claims processing in back end operations of insurance/broking industry. Skills Required Excellent knowledge of MS Excel. Good written and verbal communication skills. Familiar with general insurance claims terms and concepts Ability to work in collaboration with multiple stakeholders Strong follow up skills. Flexible to work for extended working hours and in shifts, if required Interested can share CV on given id sangeeta.rajput@techguard.in

Prepare flowcharts for business process Coordinate inter department Data entry in Excel Sending Emails Maintain project details Maintain all project bill Share reports Required Candidate profile Gender Female candidate within Age 35 years to 40 years Skills Advance Excel, Google Sheet , PowerPoint Notice Period 15 days only preferred Salary Rs 15,000 pm

Preparing MIS reports on daily, weekly and monthly basis. Cooperate closely with department heads. Well versed with vlook up, hlook up & Pivot Table. Must have exposure in handling vast data.