4 Sumifs Jobs

Introduction: A Career at HARMAN Automotive Were a global, multi-disciplinary team thats putting the innovative power of technology to work and transforming tomorrow. At HARMAN Automotive, we give you the keys to fast-track your career. Engineer audio systems and integrated technology platforms that augment the driving experience Combine ingenuity, in-depth research, and a spirit of collaboration with design and engineering excellence Advance in-vehicle infotainment, safety, efficiency, and enjoyment About The Role Harman Automotive Services is looking for a Senior Associate Business Operations to join the Business Operations team. As a member of the Business Operations team, you would be involved in the day-to-day operations of the Automotive Services business to improve efficiency. In this role you would be collaborating with the Engineering Delivery, Finance, Procurement, HR, and Talent Acquisition teams to participate in activities required for the smooth functioning of the overall business. We are looking for a detail-oriented individual with experience in project operations, project tracking, and revenue forecasting. The ideal candidate should have strong expertise in Microsoft Excel, particularly in using advanced formulas for data analysis, and must be familiar with Monthly T&M (Time & Material) billing cycles. You will play a critical role in supporting project governance, financial tracking, and operational reporting to ensure successful project execution and delivery. What You Will Do Track and maintain project plans, milestones, and deliverables for ongoing projects. Support project managers in daily operations, including resource tracking, schedule updates, and financial summaries. Prepare and manage Monthly T&M billing, ensuring accurate and timely submission to clients and internal stakeholders. Collaborate with Finance and Delivery teams to prepare revenue forecasts and monitor actuals vs. forecast. Use advanced Excel formulas (VLOOKUP, INDEX/MATCH, SUMIFS, IFS, pivot tables, etc.) to consolidate and analyze project performance data. Create dashboards and reports for management on KPIs such as budget vs actuals, utilization, and revenue realization. Maintain documentation and ensure compliance with PMO standards and templates. Assist in project audits, data quality checks, and process improvement initiatives. Ensuring data processing, management, and hygiene and understanding the importance of managing a multi-tool, multi-source data gathering and information extraction system. Understand and closely monitor Organizational, Business, and function specific goals to impact overall Operational Governance. Partner with supporting functions (Finance, HR, TA) and provides reporting data for making key decisions. Regular sync-ups, present data efficiently using various dashboards, with business stakeholders to help them take decisions and actions for profitable business and growth. Managing the overall Workforce along with other members of the team and tracking the efficiency based on business KPIs to ensure resource optimization and operational efficiency. Accountable for executing and owning Workforce Management processes using tools/ system adapted by Harman. Follow up and ensure key steps in business processes are actioned on time and within SLAs Manage a completion-based follow-up cadence with the functional step owners in different business processes. Publish weekly reports for business processes flagging progress, risks, and pending actions. Ensure data validation based on Harman standards for tools in the Harman Ecosystem. What You Need To Be Successful Bachelors degree in Business, Finance, Engineering, or related field. 3-8+ years of experience within Project Coordination, Billing, Workforce Management, Bench Management, Sales Operations and Business Operations within the Software Services Industry. Proficient in Excel, with strong hands-on experience in formulas, pivot tables, charts, and data analysis. Experience with revenue forecasting and monthly T&M billing cycles is a must. Strong understanding of project lifecycle, project financials, and resource tracking. Excellent attention to detail and analytical skills. Ability to work cross-functionally and communicate effectively with stakeholders at various levels. Excellent and hands on experience on using PMA tools and Dashboard tools. Expert in data analytics and representation with the ability to create data visualizations using Power BI & Microsoft Excel for multi-source and multidimensional data. Exceptional presentation skills and ability to create and deliver presentations to multiple business stakeholders. Proven experience in creating presentations related to Business and Sales Operations including resources, Cost, Sales Pipeline, and Utilization. Creative problem-solver with the ability to work with a blank slate and inspire others. Excellent organizational and cross functional skills Strong verbal, written and presentation skills to have effective communication at all levels in the organization. Bonus Points if You Have Experience in working within an Automotive OEM or Tier-1 supplier in the Automotive industry Experience in using AI tools to maximize efficiency in Business Operations and Workforce Management Experience with project management tools (e.g., MS Project, Jira, Smartsheet, or similar) is a plus. What Makes You Eligible Willingness to travel. Willingness to work in an office. Any offer of employment is conditioned upon the successful completion of a background investigation. What We Offer Flexible work environment, allowing for full-time remote work globally for positions that can be performed outside a HARMAN or customer location. Access to employee discounts on world-class Harman and Samsung products (JBL, HARMAN Kardon, AKG, etc.) Extensive training opportunities through our own HARMAN University Competitive wellness benefits Tuition reimbursement Be Brilliant employee recognition and rewards program. An inclusive and diverse work environment that fosters and encourages professional and personal development. You Belong Here HARMAN is committed to making every employee feel welcomed, valued, and empowered. No matter what role you play, we encourage you to share your ideas, voice your distinct perspective, and bring your whole self with you all within a support-minded culture that celebrates what makes each of us unique. We also recognize that learning is a lifelong pursuit and want you to flourish. We proudly offer added opportunities for training, development, and continuing education, further empowering you to live the career you want. Show more Show less

As a candidate for the role, you should possess strong financial acumen and demonstrate a proven ability to solve complex problems through analytical thinking. You should be a self-starter with the capability to independently initiate projects and drive them to successful completion. You are expected to be proficient in SAP, PowerPoint, and advanced Excel, including skills in Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP, IF statements, SUMIFS, INDEX/MATCH. Experience in VBA would be advantageous. Familiarity with Business Intelligence (BI) tools such as Databricks, Qlik, Tableau, SAP BW/BEx, etc., is considered a plus. In this role, you will collaborate closely with North American Sales Operations and Sales teams on various activities including month-end close, budgeting, forecasting, compensation, and scorecard activities. Your responsibilities will involve analyzing financial and operational KPIs to identify opportunities for process improvements with a positive financial impact. You will be required to develop actionable insights based on a deep understanding of sales operations KPIs and drive initiatives for further automation. Additionally, creating clear, concise, and effective reporting to simplify decision-making for business partners will be a key part of your role. It is crucial to maintain strong relationships with key stakeholders across the organization, including Sales, Marketing, Finance, IT, and Supply Chain, to inform, influence, and align on business objectives. Personal attributes essential for success in this role include a strong work ethic, proactive and positive attitude towards responsibilities, and the ability to be bold, responsive, and take ownership of the end-to-end process.,

As a Data Reporting Specialist at Hogarth Studios, you will play a crucial role in translating complex marketing data into compelling, Excel-based reports for our pharmaceutical clients. Your expertise will drive strategic decisions by identifying key trends, patterns, and anomalies within the data, providing actionable recommendations that add value to our client's business. Your responsibilities will include designing, developing, and delivering high-quality marketing performance reports using Microsoft Excel. You will clean, organize, and analyze large datasets related to pharmaceutical marketing campaigns, digital performance, and sales activities. Understanding the specific reporting needs of our clients and translating their business questions into data-driven answers will be essential in this role. Collaboration is key in our team, as you will work closely with marketing teams, account managers, and data stakeholders to refine reporting requirements and deliver impactful solutions. Ensuring the accuracy, consistency, and integrity of all reported data is a priority, reflecting your meticulous approach to data accuracy and report presentation. To excel in this role, you should have at least 4 years of experience in data reporting, data analysis, or business intelligence. Proficiency in Microsoft Excel, including complex formulas, pivot tables, and charting, is crucial. Experience working with various types of marketing data and familiarity with the pharmaceutical industry context are highly advantageous. If you have a passion for data, a knack for presentation, and a proactive problem-solving mindset, we encourage you to apply and make an impact with your data skills at Hogarth Studios today!,

Process: MIS Reporting BAND: A2(Senior Executive) Location: Bangalore - Work from office Transport: Cab provided for Pick up and drop. Shift: 4:00PM to 1:00AM Qualification: MBA, M. Com & BBA Must Have Skills: - Understanding of MS-Office (Excel functions and Formulas) VLOOKUP, HLookup, X-lookup, Index match, Data Validation, Filter, Pivot Table, Concatenation, Sumifs. Experience of 1 to 3 years in Non-Finance MIS Reporting process or any other product related domain or Retail business. Non-Finance Supply Chain Understanding of MS-Office (Excel functions and Formulas) VLOOKUP, HLookup, X-lookup, Index match, Data Validation, Filter, Pivot Table, Concatenation, Sumifs. Excellent spoken communication skills, stakeholder management and interaction, good presentation skills Analytical, Multi-tasking, Decision making Non-Finance Supply Chain Primary Responsibility Working on day-to-day activities with accuracy Responding to the emails Client call handling Preparing SOP/ Process document Performance Parameters Productivity Monitoring and Reporting TAT & Accuracy Schedule Adherence Analysis of data and Feedback Calibration Role Responsibilities Production with accuracy PO Creation, SKU Creation Reporting Email handling Team co ordination Primary Internal Interactions PE Assistant Manager PE Manager PE AVP Primary External Interactions Supervisors at the client end for the purpose of seeking clarifications & answering queries Operations, process owners for calibrations and process related updates. Client QA team for calibrations