1222 Pivot Table Jobs - Page 39

Looking for a MIS executive in Taloja for a US MNC. Candidate should be excellent in MS. Excel, Excel AI, Macros, Pivot tables, Male / female both can apply. 5 day working.

Job Summary: We are seeking an experienced and detail-oriented MIS Executive to manage and streamline our management information systems. The ideal candidate will have a strong background in Excel (including advanced functions, Macros, and Pivot Tables), Power BI, and data visualization tools. You will be responsible for data management, reporting, analysis, and creating dashboards to support decision-making processes across departments. Key Responsibilities: Develop, maintain, and automate MIS reports and dashboards using Excel, Power BI, and other tools . Create and manage Pivot Tables, Pivot Charts , and Macros to analyze large datasets effectively. Use Advanced Excel functions (VLOOKUP, HLOOKUP, INDEX-MATCH, nested IFs, conditional formatting, etc.) for data manipulation and reporting. Develop and publish interactive dashboards in Power BI to visualize performance metrics and KPIs. Perform regular audits of data for accuracy, completeness, and consistency. Collaborate with cross-functional teams to gather data and reporting requirements. Provide support in automating routine processes and enhancing existing MIS frameworks. Monitor performance trends and generate actionable insights to support strategic planning. Ensure timely delivery of daily, weekly, and monthly MIS reports. Required Skills & Qualifications: Minimum 3 years of experience in an MIS Executive or similar role. Proficient in Microsoft Excel (including Advanced Excel features, Macros, Pivot Tables & Charts). Hands-on experience in Power BI (data modeling, DAX, report publishing, and dashboarding). Strong analytical and problem-solving skills. Knowledge of basic SQL (optional but preferred). Excellent communication and presentation skills. Ability to manage multiple tasks and deadlines in a fast-paced environment. Bachelors degree in Computer Science, Information Systems, Business Administration, or related field.

ROLES & RESPONSIBILITY OF EXECUTIVE-PROJECTS Commercial & Compliance Validation - Reviewing and validating commercials, compliance documents, and manpower breakup details to ensure accuracy and adherence to policies. Invoice Compliance - Verifying GST details and ensuring compliance in customer invoices before processing. Customer Onboarding & Setup in SAP - Creating new customer codes, projects, WBS (Work Breakdown Structure), activities, and revenue structures in SAP for seamless onboarding. Revisions & Modifications in SAP - Managing MW revisions, incremental revisions, renewals, and other required modifications for existing customers in SAP. Additions of Existing Accounts in SAP - Facilitating the addition of customer codes, projects, WBS, activities, and revenue streams for existing clients. Customer Data Management in SAP - Updating critical customer information, including name, address, GSTIN, contract extensions, and other relevant modifications in SAP. Customer Account Closure in SAP - Ensuring the systematic closure of accounts for withdrawn customers in SAP. Document Maintenance (SAP & Common Folder) - Ensure all relevant documents (NCI, Supporting Documents, Revenue breakup, etc., ) are properly reviewed and stored as per process. Updating tracks (Kelsa) - Updating and releasing tracking reports to monitor project progress and financial data.

Are you ready to take your career to new heights? We're on the lookout for passionate individuals to join our dynamic team of Fortune 5 Risk Management Solutions LLP If you're excited about making a difference and want to be part of a thriving and innovative insurance family, look no further. Let's create a safer and more secure future together. #JoinFortune5 #InsuranceOpportunity #CareerGrowth #hiring Position :- General Insurance MIS & Payout Reconciliation Executive Location : Andheri East, Near Garware, Mumbai MH Experience: 4-5 years (Preferably from insurance broker or company ) Salary: 4.00 10.00 LPA Employment Type:Full-time Work Days: Monday to Saturday Job Description We are looking for an General Insurance MIS & Payout Reconciliation Executive with 4-5 years of experience in the insurance broking sector. The role involves data reconciliation, financial reporting, and trend analysis, ensuring accuracy and integrity . Strong Excel skills, problem-solving ability, and attention to detail are essential. If you excel in MIS and data accuracy, apply now! Key Skills: Prior Work Experience with GENERAL INSURANCE Agent / Broker / Insurance Company is MUST. Insurance & Brokerage Processes Understanding of premium collections, claims processing, policy issuance, and regulatory compliance in the insurance sector. Regulatory & Compliance Awareness Familiarity with IRDAI guidelines, financial audits, and risk assessments to ensure accurate reporting. Identify and resolve discrepancies in financial reports and records. Communication & Coordination – Working with cross-functional teams, finance, operations, and IT departments to align data accuracy. Knowledge of IFRS & Accounting Principles – Helps in understanding financial implications and reconciliation. Forecasting & Reporting: Using historical data to predict trends, assess risks, and improve operational efficiency. Advanced Excel Skills- Proficiency in VLOOKUP, HLOOKUP, Pivot Tables, Macros, Power Query, and Data Validation for efficient data handling. Financial & Data Reconciliation Understanding of ledger matching, premium reconciliation, policy tracking, and financial reporting in the General insurance domain. Reporting & Dashboard Creation Experience with Power BI, Tableau, or Google Data Studio for dynamic reporting and visualization. SQL & Database Management – Knowledge of SQL can help in extracting and analyzing large data sets from databases. (Good to have) Please Send your Resume with Below Replies and Details 1. Currently Where are you working or why did you leave your last job ? 2. What is your current Monthly Salary ? 3. Why do you want to change your job ? 4. What is the Notice Period in your Current Company ? 5. What is the Expected Minimum Increment ? Application Process: Interested Candidates, Kindly forward us your Latest Resume along with Recent Picture of yourself with the subject line: “[ MIS & Payout Reconciliation Executive ] – [Your Name]” at jobs@fortune5.in (CC: fortunefiveins@gmail.com)

Designation- Merchandising Executive - MIS Location- Head Office located at Sion Koliwada Experience - Min 1+ yrs. experience in MIS role Job Timings - 9am to 5.30pm Week off - All Sundays Salary - upto 20k in-hand + PF + other Benefits Skills Required:- Advance excel knowledge (Summation, Weekday, IF ,Discount%, Concatenate, Conditional Formatting Average, Percentage, Min, Max, V Look Up, H Look up, Pivot, Graph etc.) is Mandatory Job Profile: Stock Allocation. Call Back & Reallocation on system. Pull Out all merchandising reports from the systems. Coordinating with all departments as per requirement. Communication with all outlets as per Requirement. Generation of various MIS Reports. Analysis of all MIS Reports and submission of analysis to senior for action.. Assisting GM & Director on day to day activities. Manage & Prioritize multiple work require to meet deadline For further queries contact can on -career@gangar.in OR Call on-9594999602/ 8108999167 NOTE- We are 6 days working firm (only Sundays Off). Regards, Sharvari. HRD

About the Role: We are seeking a motivated and detail-oriented individual to join our Finance and Accounts team as an MIS Resource. This role will involve collecting, analyzing, and interpreting financial data to generate insightful reports and dashboards. The ideal candidate will possess strong analytical skills, a keen eye for detail, and a passion for leveraging data to drive informed decision-making. Job Description: Mid level MIS Resource (Finance & Accounts). Location:- Hyderabad Telangana Industry:- Engineering Construction Experience:- 5 to 8 Years in MIS & Accounting Education:- Graduation Role & responsibilities Data Collection and Cleaning: Gather financial data from various sources, including ERP systems, spreadsheets, and manual records. Clean and validate data to ensure accuracy and consistency. Data Analysis and Reporting: Analyze financial data to identify trends, patterns, and anomalies. Prepare accurate and timely financial reports, including monthly, quarterly, and annual reports. Develop and maintain financial dashboards to visualize key performance indicators (KPIs). MIS Development and Maintenance: Design and develop new MIS reports and dashboards to meet evolving business needs. Enhance existing MIS reports and dashboards to improve efficiency and accuracy. Ad-hoc Analysis: Conduct ad-hoc analysis to support specific business questions and initiatives. Process Improvement: Identify opportunities to streamline and automate financial processes. Implement process improvements to enhance efficiency and accuracy. Daksha Sindhi Voice / WhatsApp - 6353077232 E-Mail:- daksha@upman.in

Responsible for handle Advance Excel

*** Tally Data Entry *** 1. Perform daily bookkeeping 2. Office work and file maintenance. 3. Maintain data in Excel *Read below* Required Candidate profile **** Preference will be given to candidates with *** - Knowledge of accounting standrds - Living in Gurgaon or nearby - Experience in *** Real Estate, Construction, Manufacturing & CA Firms . . .

*** Tally Data Entry *** 1. Perform daily bookkeeping, 2. Office work and file maintenance. 3. Duties like controlling, verifying, and generating invoices for suppliers 4. Maintain data in Excel *Read below* Required Candidate profile **** Preference will be given to candidates with *** - prior experience of Tally - Living in Dharuhera/ nearby - Experience in *** Real Estate, Construction, Manufacturing & CA Firms . . .

Roles and Responsibilities - Process loan application forms Verify data and make the correction. Verify KYC documents Review and verify the entries Online forms processing Maintain the Confidential records Completely working from the office Working Days / Hours / Benefits: 6 days week (Monday to Saturday) Growth Opportunity within the organization. Flexible working hours. Employee centric Organization.

An MIS (Management Information Systems) role involves supporting and improving existing information systems, generating reports, and analyzing business data to identify areas for improvement. Required Candidate profile Good Communication Skills. Candidate should be graduate. Good command on H look up, V look up and Advanced Excel. Minimum 1year of experience in making MIS Report.

Manage and maintain company databases spreadsheet and record Handle documentation filing and record-keeping efficiently Process and verify invoices purchase orders and financial record Coordinate with different departments to ensure smooth operation Required Candidate profile Bachelor’s degree in any field Freshers or candidates with experience in back-office operations data entry or administration. Proficiency in MS Office Excel, Word, PowerPoint and data management tools

1. Bookkeeping and Record Keeping 2. Financial Reporting 3. Accounts Payable & Receivable Management 4. Compliance and Taxation 5. Expense Management 6. Cash Flow 7. Voucher Entry 8. P&L 9. Balance Sheet 10. GST Filling

Job Title: SAP Associate Experience : 1-2 Years Education Criteria: Any Graduate Process : Chat & email support Shift Details: Rotational shifts (24/7 coverage) 5 working days with 2 rotational days off One-way cab facility provided Required Candidate profile Key Skills Required: Basic PC knowledge, keyboard shortcuts Microsoft Office: Outlook, Word, Excel Data handling skills Working knowledge of SAP and SQL Good communication Required

We are looking for a highly proficient Excel Developer with over 4 years of experience in advanced Excel development, data modeling, automation using VBA/macros, and dynamic reporting. The ideal candidate will be responsible for designing and maintaining robust Excel-based reporting solutions, transforming raw data into meaningful insights for business users. Exposure to Power BI and basic data visualization tools is a plus, but Excel will be the primary focus of this role. Key Responsibilities: Design, develop, and maintain advanced Excel-based dashboards and analytical tools. Use Power Query, PivotTables, Power Pivot , and formulas (e.g., INDEX-MATCH, SUMIFS, array formulas) for data transformation and reporting. Develop automation tools and workflows using VBA and Macros to streamline data processing. Collaborate with stakeholders to gather reporting requirements and deliver customized Excel reports. Ensure accuracy, consistency, and data integrity across all reports and templates. Conduct regular data audits and troubleshoot data issues within Excel models. Provide training and support to users on advanced Excel features and tools. Maintain version control and documentation for all developed solutions. Optimize large Excel workbooks for performance and scalability. Required Skills & Qualifications: Bachelors degree in Computer Science, Information Systems, Data Analytics, or a related field. 4+ years of hands-on experience in Microsoft Excel at an advanced level . Strong command of: Power Query Power Pivot PivotTables Advanced formulas and conditional formatting VBA and Excel Macros Ability to handle and manipulate large datasets in Excel efficiently. Basic exposure to Power BI and an understanding of DAX is a plus. Knowledge of SQL is a bonus. Strong problem-solving skills and attention to detail. Excellent verbal and written communication skills. Ability to work independently and manage multiple projects under tight deadlines. Preferred Qualifications: Microsoft Excel Certification or similar credentials. Experience with cloud-based Excel integrations (e.g., SharePoint, OneDrive). Experience working in cross-functional teams with business users and IT teams.

Designation: Accounts and Finance Executive Position Overview This position is required to work on the debtors reconciliations, accounting of debtors, ensuring the accounting is happening timely. Required to report to the Associate Manager Finance for all the purposes. Must adhere to the book-closure timelines and work with the team to comply with the same. Should be a good team-player. Academics and Experience B.com/ M Com/ MBA-Finance 2 Years experience in accounting domain Must have worked in a mid-sized company and have basic knowledge of SoX Compliances and statutory audit exposure Roles and Responsibilities 1.Good accounting knowledge is a must 2. Performing account reconciliations 3. The ability to communicate and articulate efficiently within the teams and cross teams. 4. Experience in an Saas company is an added advantage 5. Maintaining accounts receivable files and records 6. Good communication skills Skills 1. ERP- Tally and Microsoft D365 2. Good working knowledge of MS Excel is required (Vlookup, Xlookup, Sumif, Pivot tables etc) 3. Knowledge of Mail Merge 4. Usage of google- emails, chats, calendar 5. Proactive approach towards work, knowing when to escalate 6. Driving towards closure, detail oriented About Company Bitla Software is a dynamic and innovative product company that specializes in cutting-edge software solutions. We are the world's largest technology and solution provider to the Bus Industry. With SaaS, Cloud and Mobile Technology Solutions, Bitla has transformed the life of bus operators by maximizing revenue, optimizing operational costs, and helping bus operators stay fully in control of their business performance. Founded in 2007, Bitla is part of India's leading online travel company MakeMyTrip Limited. By offering products which adapt to the bus operator's business process, reliable under all conditions, easy to use by anyone, Bitla is serving 2500+ bus operators with 20,000+ buses on a daily basis. Other than India, Bitla has operations in Southeast Asia and Africa.

We are hiring for TOP MNC for Data Analyst Note- Must have strong exposure in- SQL, Tableau, Power BI, Python & Excel. Note- Must have worked in E-commerce projects as data analyst. Location - Chennai Experience - 3+ - 10 Years Salary - 3.50LPA to 7.50LPA Max. Note- Flexible to work in night shift and work from office Notice Period - Immediate Joiner Only. Qualification- Any graduate & postgraduate. Skills Required Must have worked for Ecommerce projects as data analyst. Should have strong experience in SQL, Power BI, Python, Excel & Tableau. Good communication skills. Flexible to work in shifts including night and work from office. Interested Applicants can reach out to below contact: Amzad Ali @ 9900024952 Amzad@inspirationmanpower.co.in

Education preferably Graduate, Knowledge of Advance excel, MIS Knowledge of Loading and Unloading process Warehouse experience is must

1. MIS Development and Management 2. Data Collection and Analysis 3. Database Management 4. Project Tracking and Reporting 5. Coordination and Collaboration 6. Process Optimization 7. Compliance and Governance

Job Title: Sr. Executive MIS Location: Badvel Plant Job Summary Responsible for collecting, analyzing, and reporting production, sales, and dispatch data to support operational decisions. Uses SAP, Power BI, and Excel to create dashboards and MIS reports. Key Responsibilities Generate MIS reports and dashboards using Excel and Power BI. Extract and analyze data from SAP (invoices, dispatch, production). Support system/application issues related to MIS. Visualize key metrics and insights for plant operations. Perform data analysis using Excel and related platform Skills & Qualifications Proficient in SAP , Power BI, Advanced Excel, and SQL. 8+ years of MIS experience, preferably in manufacturing. Strong analytical and problem-solving skills.

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: Excel.

Role Purpose The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions. Do 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement Deliver NoPerformance ParameterMeasure1.Analyses data sets and provide relevant information to the clientNo. Of automation done, On-Time Delivery, CSAT score, Zero customer escalation, data accuracy Mandatory Skills: Data Science Consulting. Experience5-8 Years.

Role Purpose The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions. Do 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement Deliver NoPerformance ParameterMeasure1.Analyses data sets and provide relevant information to the clientNo. Of automation done, On-Time Delivery, CSAT score, Zero customer escalation, data accuracy Mandatory Skills: Big Data. Experience5-8 Years.

Role Purpose The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions. Do 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement Deliver NoPerformance ParameterMeasure1.Analyses data sets and provide relevant information to the clientNo. Of automation done, On-Time Delivery, CSAT score, Zero customer escalation, data accuracy Mandatory Skills: Data Visualisation for Data Science. Experience5-8 Years.

Role Purpose The purpose of this role is to execute the process and drive the performance of the team on the key metrices of the process. Do Ensure process is executed as per the client contract Conduct briefings before every shift to drive focus on key metrices and debrief at the end of the shift to drive focus of the team on quality and adherence to contract compliance processes Prepare notes from the huddle meetings and share it with the team Prepare and share the performance data of the team with the client at the end of the shift Interact with the client and prepare note to share updates and changes with the team Review the performance on the key process metrices and conduct RCA to improve quality parameters Prepare presentation on weekly and monthly performance data for the manager to be shared with the client Collaborate and influence internal key stakeholders to manage and resolve issues to ensure fulfillment and flawless delivery of projects Be part of the discussion between manager and WFM team on forecast and number of agents required Organize fun hours on Friday for the team to promote team engagement Identify opportunities for automation within the account and share it with the manager Provide details and data to the automation team to support the automation initiative Drive performance of the team on the identified metrices of the process Review last 6-8 weeks performance data (RAG) and identify low performers Provide feedback and coach the outliers/ low performers to improve their performance metrices Prepare Performance Coaching & Counselling Plan (PCCP) to document and support the low performers Handhold the employees on performance on process and monitor for improvements Identify training needs for new joiners especially and track their daily progress Conduct process trainings as well as refresher trainings are provided to bridge the capability gap or if there is any change from the client’s end Stakeholder Interaction & Management Coordinate with internal and external stakeholders to ensure compliance and quality in the delivery for accounts Interact and engage with the client manager to communicate and update progress against account plan, project delivery etc. Participate in monthly review meetings with Account Delivery leadership updating them on the status and progress of the account Work with quality team to ensure the quality improvements as per the delivery standards of the contract Provide timely assistance in case of an escalation and support resolution of escalations/ issues Effective Team Management Resourcing Hire adequate and right resources for the team Talent Management Ensure adequate onboarding and training for the team members to enhance capability & effectiveness Build an internal talent pool and ensure their career progression within the organization Manage team attrition Drive diversity in leadership positions Performance Management Set goals for the team, conduct timely performance reviews and provide constructive feedback to own direct reports Ensure that the Performance Nxt is followed for the entire team Employee Satisfaction and Engagement Lead and drive engagement initiatives for the team Track team satisfaction scores and identify initiatives to build engagement within the team Mandatory Skills: IT Operations Management. Experience1-3 Years.