Vivek Adhav profile photo 1 on Tal

Vivek Adhav

MIS Reporting Executive | Data Analyst | Power BI Developer | Advanced Excel | Power BI | SQL | Business Intelligence & Reporting Automation

Pune Division

14+ years of work experience

Cognizant
Sep 20178 yrs 10 mosPresent

Pune City, Maharashtra, India

Built and maintained 10+ Power BI dashboards tracking SLA compliance, attendance shrinkage, and productivity KPIs for 300+ FTE operations teams. • Automated recurring reports using Power BI, VBA Automation, Advanced Excel functions, Pivot Tables, VLOOKUP, XLOOKUP, Power Query, and Macros, improving reporting efficiency. • Developed Python (openpyxl) scripts to generate formatted Excel workbooks with dynamic charts, enabling self-serve reporting for operations managers. • Partnered with HR and WFM teams to publish daily/weekly/monthly shrinkage and capacity utilization reports consumed by C-level leadership. • Developed and maintained MIS reports, dashboards, and analytical reports to support business decision-making and performance tracking. •Created interactive Power BI dashboards and visualizations for KPI monitoring, trend analysis, and management reporting. • Collected, validated, cleansed, and analyzed large datasets to ensure data accuracy, consistency, and integrity. • Generated daily, weekly, and monthly business reports for senior management and stakeholders. • Monitored operational performance metrics and identified trends, gaps, and improvement opportunities through data analysis. •Collaborated with cross-functional teams to gather reporting requirements and deliver actionable business insights. • Performed data reconciliation, quality checks, and exception reporting to support compliance and operational excellence. • Managed database records and maintained reporting repositories for efficient data retrieval and analysis. • Prepared ad-hoc reports, presentations, and executive summaries to support strategic planning and business reviews. • Utilized SQL queries for data extraction, validation, and reporting purposes. • Supported forecasting, budgeting, and performance analysis through data-driven reporting solutions. • Reduced manual effort by streamlining reporting processes and implementing automated reporting solutions. • Ensured timely delivery.
Mphasis
Jun 20151 yr 4 mosSep 2016

Pune District, Maharashtra, India

• Processed high-volume insurance transactions, policy servicing requests, claims administration activities, and customer account updates while maintaining 100% compliance with organizational policies and regulatory requirements. • Managed end-to-end insurance operations including policy issuance, policy maintenance, premium processing, claims support, policyholder servicing, and documentation review. • Developed, maintained, and analyzed MIS reports, operational dashboards, and management reports to support business decision-making, performance tracking, and process optimization. • Generated daily, weekly, monthly, and ad-hoc reports using Advanced Excel and reporting tools to provide actionable insights to management and stakeholders. • Conducted data validation, data verification, reconciliation, and quality assurance checks to ensure data accuracy, consistency, and integrity across multiple business systems. • Performed detailed document review and verification activities to assess completeness, accuracy, compliance requirements, and process adherence. • Supported underwriting operations by reviewing application data, verifying supporting documents, identifying discrepancies, and escalating exceptions for further assessment. • Assisted in risk assessment processes by validating customer information, reviewing supporting documentation, and ensuring compliance with internal control frameworks. • Managed employee verification processes including IRS Form 4506 and 4506-T verification activities, ensuring accurate income and employment validation for loan processing requirements. • Performed loan processing support activities including document verification, income analysis, record validation, compliance checks, and customer data review. • Coordinated with internal teams, clients, vendors, and stakeholders to resolve operational issues, improve turnaround times, and maintain service-level agreements. • Maintained detailed records, audit trails, and ops docs.
Infosys
Apr 20123 yrs 3 mosJun 2015

Pune Division, Maharashtra, India

• Managed end-to-end insurance operations, including policy administration, policy servicing, claims processing support, and customer account management while ensuring compliance with company policies. • Processed and administered various insurance products, including Term Life Insurance, Whole Life Insurance, Accidental Death Claims, and TROP (Term Return of Premium) policy payouts. • Handled policy issuance, policy renewals, endorsements, beneficiary updates, policy maintenance, and customer service requests with a strong focus on accuracy and turnaround time. • Supported claims administration by reviewing claim requests, validating claim information, verifying supporting documentation, and ensuring timely claim settlement processes. • Investigated claim discrepancies, identified data inconsistencies, and coordinated with internal stakeholders to facilitate claim resolution and minimize processing delays. • Performed detailed policy verification and eligibility assessments to ensure compliance with underwriting guidelines. • Assisted policyholders and beneficiaries by providing information regarding policy coverage, claim status, premium details, policy benefits, and settlement procedures. • Managed insurance documentation, policy records, customer files, claim files, and regulatory documents while maintaining confidentiality and compliance. • Supported underwriting teams by reviewing applications, validating customer information, assessing documentation and identifying potential risks. • Maintained accurate records of insurance transactions, claim activities, policy updates, and customer interactions within organizational systems. • Generated operational reports, productivity reports, quality reports, and management reports to support business performance monitoring and decision-making. • Collaborated with cross-functional teams including Claims, Underwriting, Compliance, Operations, Customer Service, and Management to ensure seamless service delivery.
Maharashtra Media Services and Public Relations
Jun 20119 mosFeb 2012

Pune City, Maharashtra, India

Assisted in planning and executing public relations campaigns to enhance client and organizational visibility. Drafted press releases, media briefs, newsletters, and communication materials for internal and external stakeholders. Coordinated with media representatives, journalists, and publication houses to ensure timely dissemination of information. Managed media databases, tracked press coverage, and prepared media monitoring reports. Supported event planning, press conferences, promotional activities, and stakeholder engagement initiatives. Assisted in content creation for marketing communications, corporate announcements, and promotional campaigns. Maintained communication records, documentation, and reporting to support PR operations. Collaborated with cross-functional teams to ensure consistent messaging and brand representation. Conducted research on market trends, competitor activities, and media opportunities to support communication strategies. Handled administrative and coordination activities while ensuring timely execution of PR and communication projects.

Education

Savitribai Phule Pune University

Master's in Communication Studies (M.C.S), Media Research

Savitribai Phule Pune University

20092 yrs2011

Join Vivek and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Vivek Adhav on Tal

Headline

MIS Reporting Executive | Data Analyst | Power BI Developer | Advanced Excel | Power BI | SQL | Business Intelligence & Reporting Automation

About

MIS and Data Analytics professional with 13+ years of experience across BPO and IT services, specializing in workforce reporting, SLA tracking, and operational dashboards. Proficient in Advanced Excel, Power BI, SQL, and Python (openpyxl) to automate reports and build interactive dashboards that drive data-driven decisions. At Cognizant, I own end-to-end MIS reporting for large-scale operations — from designing attendance and shrinkage trackers to building Power BI dashboards consumed by senior leadership. My dashboards have reduced manual reporting effort by 40% and enabled near-real-time visibility into team KPIs. Open to roles in Data Analytics, MIS Reporting, People Analytics, and Business Intelligence.

Location

Pune Division

Work experience

Senior Data Analyst at Cognizant, Sep 2017 - Present · 8 yrs 10 mos, Pune City, Maharashtra, India, Built and maintained 10+ Power BI dashboards tracking SLA compliance, attendance shrinkage, and productivity KPIs for 300+ FTE operations teams. • Automated recurring reports using Power BI, VBA Automation, Advanced Excel functions, Pivot Tables, VLOOKUP, XLOOKUP, Power Query, and Macros, improving reporting efficiency. • Developed Python (openpyxl) scripts to generate formatted Excel workbooks with dynamic charts, enabling self-serve reporting for operations managers. • Partnered with HR and WFM teams to publish daily/weekly/monthly shrinkage and capacity utilization reports consumed by C-level leadership. • Developed and maintained MIS reports, dashboards, and analytical reports to support business decision-making and performance tracking. •Created interactive Power BI dashboards and visualizations for KPI monitoring, trend analysis, and management reporting. • Collected, validated, cleansed, and analyzed large datasets to ensure data accuracy, consistency, and integrity. • Generated daily, weekly, and monthly business reports for senior management and stakeholders. • Monitored operational performance metrics and identified trends, gaps, and improvement opportunities through data analysis. •Collaborated with cross-functional teams to gather reporting requirements and deliver actionable business insights. • Performed data reconciliation, quality checks, and exception reporting to support compliance and operational excellence. • Managed database records and maintained reporting repositories for efficient data retrieval and analysis. • Prepared ad-hoc reports, presentations, and executive summaries to support strategic planning and business reviews. • Utilized SQL queries for data extraction, validation, and reporting purposes. • Supported forecasting, budgeting, and performance analysis through data-driven reporting solutions. • Reduced manual effort by streamlining reporting processes and implementing automated reporting solutions. • Ensured timely delivery.

Transaction Processing Executive at Mphasis, Jun 2015 - Sep 2016 · 1 yr 4 mos, Pune District, Maharashtra, India, • Processed high-volume insurance transactions, policy servicing requests, claims administration activities, and customer account updates while maintaining 100% compliance with organizational policies and regulatory requirements. • Managed end-to-end insurance operations including policy issuance, policy maintenance, premium processing, claims support, policyholder servicing, and documentation review. • Developed, maintained, and analyzed MIS reports, operational dashboards, and management reports to support business decision-making, performance tracking, and process optimization. • Generated daily, weekly, monthly, and ad-hoc reports using Advanced Excel and reporting tools to provide actionable insights to management and stakeholders. • Conducted data validation, data verification, reconciliation, and quality assurance checks to ensure data accuracy, consistency, and integrity across multiple business systems. • Performed detailed document review and verification activities to assess completeness, accuracy, compliance requirements, and process adherence. • Supported underwriting operations by reviewing application data, verifying supporting documents, identifying discrepancies, and escalating exceptions for further assessment. • Assisted in risk assessment processes by validating customer information, reviewing supporting documentation, and ensuring compliance with internal control frameworks. • Managed employee verification processes including IRS Form 4506 and 4506-T verification activities, ensuring accurate income and employment validation for loan processing requirements. • Performed loan processing support activities including document verification, income analysis, record validation, compliance checks, and customer data review. • Coordinated with internal teams, clients, vendors, and stakeholders to resolve operational issues, improve turnaround times, and maintain service-level agreements. • Maintained detailed records, audit trails, and ops docs.

Process Executive at Infosys, Apr 2012 - Jun 2015 · 3 yrs 3 mos, Pune Division, Maharashtra, India, • Managed end-to-end insurance operations, including policy administration, policy servicing, claims processing support, and customer account management while ensuring compliance with company policies. • Processed and administered various insurance products, including Term Life Insurance, Whole Life Insurance, Accidental Death Claims, and TROP (Term Return of Premium) policy payouts. • Handled policy issuance, policy renewals, endorsements, beneficiary updates, policy maintenance, and customer service requests with a strong focus on accuracy and turnaround time. • Supported claims administration by reviewing claim requests, validating claim information, verifying supporting documentation, and ensuring timely claim settlement processes. • Investigated claim discrepancies, identified data inconsistencies, and coordinated with internal stakeholders to facilitate claim resolution and minimize processing delays. • Performed detailed policy verification and eligibility assessments to ensure compliance with underwriting guidelines. • Assisted policyholders and beneficiaries by providing information regarding policy coverage, claim status, premium details, policy benefits, and settlement procedures. • Managed insurance documentation, policy records, customer files, claim files, and regulatory documents while maintaining confidentiality and compliance. • Supported underwriting teams by reviewing applications, validating customer information, assessing documentation and identifying potential risks. • Maintained accurate records of insurance transactions, claim activities, policy updates, and customer interactions within organizational systems. • Generated operational reports, productivity reports, quality reports, and management reports to support business performance monitoring and decision-making. • Collaborated with cross-functional teams including Claims, Underwriting, Compliance, Operations, Customer Service, and Management to ensure seamless service delivery.

Junior Public Relations Associate at Maharashtra Media Services and Public Relations, Jun 2011 - Feb 2012 · 9 mos, Pune City, Maharashtra, India, Assisted in planning and executing public relations campaigns to enhance client and organizational visibility. Drafted press releases, media briefs, newsletters, and communication materials for internal and external stakeholders. Coordinated with media representatives, journalists, and publication houses to ensure timely dissemination of information. Managed media databases, tracked press coverage, and prepared media monitoring reports. Supported event planning, press conferences, promotional activities, and stakeholder engagement initiatives. Assisted in content creation for marketing communications, corporate announcements, and promotional campaigns. Maintained communication records, documentation, and reporting to support PR operations. Collaborated with cross-functional teams to ensure consistent messaging and brand representation. Conducted research on market trends, competitor activities, and media opportunities to support communication strategies. Handled administrative and coordination activities while ensuring timely execution of PR and communication projects.

Education

Master's in Communication Studies (M.C.S), Media Research, Savitribai Phule Pune University