Vineet Vihan

Bachelor of Technology graduate with 10.6 years of experience in Team Management, Client Engagement, Project Migration, Product Configuration, and Analytics. Expertise in Data Management, Reporting, and Process Automation using Advanced Excel, VBA, SQL, SSIS, SSRS, Power BI, Oracle, and SAP BO. Proven track record of leading cross-functional teams, improving operational efficiency, and driving data-driven decision-making in Agile environments.

Advisory Service Consultant – Optum India Advisory at OPTUM (United Health Group) (2024-04 – 2025-06)

• Was part of the Advisory Group at Optum, leading a 5-member team focused on healthcare pricing and product development.
• Primarily engaged with Stepwise, an in-house tool comprising: Formula Designer – used for creating complex calculations, building benefit tables, and modeling pricing logic.
• Portal Designer – responsible for user interface (UI) design and layout, including element placement and overall application usability.
• Currently leading the design and development of CompPricer, an advanced application aimed at building pricing models for commercial health plans. Key features include support for deductibles, copays, outofpocket maximums, and covered services.
• Collaborating closely with the U.S.-based Actuarial team to leverage normative data and benefit specifications to derive accurate allowed costs and provide benchmark pricing insights.
• Contributing to the creation of a comprehensive benefit pricing framework that enhances pricing capabilities and supports strategic decision-making and that too on basis Actuarial Data shared post connects with U.S.-based Actuarial team.
• Following Agile methodology and utilizing JIRA to manage sprints, backlogs, and cross-functional collaboration.

Team Lead Business Analyst - Asset Management Lead Finance Office Data Management at Ameriprise Financial (2019-09 – 2024-04)

Responsible for loading weekly, monthly, quarterly and yearly data for Asset Management business in Database (SQL Server AWS and Oracle), which help the business partners to generate the comp report for all the advisors and territories. Led the SQL Steering committee from India to improve the existing database and incorporating new data feeds. Responsible for driving innovative reporting practices and designing robust reporting dashboards.

• Load the Weekly, Monthly, Quarterly and Yearly data for Asset Management business in Database (SQL Server AWS and Oracle), which help the business partners to generate the comp report for all the advisors and territories.
• Identify and fix the SQL scripts to improve the existing queries and procedures and incorporate new data feeds into the database.
• Reviewing and ensuring data integrity and data processing results.
• Strong knowledge of developing schemas (Star Schema and Snowflake), tables, procedures etc.
• Provide training to the team members on various tools (SQL, SSIS, Advance Excel, and Power Query).
• Leading the SQL Steering committee from India to improve the existing database (queries, procedures, tables, schemas) and incorporating the new data feeds that we receive.
• Responsible for driving innovative reporting practices that include identifying new ways to analyze and visualize data to help leadership gain the insights they need to drive Business Results.
• Design and develop intuitive and robust reporting dashboards as per the requirement based on SQL, Excel, SAP Business Object, and Power BI.
• Lead projects and work with line of business to understand functional requirements, provide solutions and share insights based on in-depth research by using qualitative and quantitative analytics techniques.
• Handling projects using agile methodology through Scrum (worked on sprints), writing user stories in JIRA.
• Partner with different global business teams, delivering impactful presentations with actionable recommendations to senior management.
• Analysis the data each month before compensation cycle to check any data issues using BI Launchpad (SAP Business Object).

Senior Executive (Analytics) at EXL Services India Pvt. LTD (2017-08 – 2019-08)

Managed Insurance data using SQL Server and created SSIS packages and procedures to load monthly files. Developed complex reports and dashboards on monthly, weekly and quarterly basis. Identified opportunities to automate reports using VBA/Access/SQL to save time and create efficiency. Worked on various consulting and internal VBA projects.

• Manage Insurance data using SQL Server and create SSIS packages and procedures to load the monthly files.
• Regular connect with business partners to improve the existing data in SQL Server by moving those data into the new schemas.
• Fixing the SQL queries and procedures to incorporate the exceptions and new data feeds.
• Developed complex reports, created dashboard on monthly, weekly & quarterly basis and updated the other reports as per the new requirement using Excel Pivot tables, advanced formulas, Excel VBA and SQL.
• Identified opportunities to automate reports using VBA/ Access/ SQL to save the time & create efficiency.
• Working on various consulting and internal VBA projects and complete them on defined timelines.
• Collating data with different vendors and make Excel based reports.
• Ensure all reports are collected and compiled in time to draw suggestions or conclusions.
• Provided training & support within team wherever it is required.

Software Engineer at NetProphets CyberWorks Pvt. Ltd (2015-01 – 2017-04)

Worked with Reckitt Benckiser team to analyze media advertisement expenditure across countries. Manipulated, cleansed and processed data using Excel and created final reports. Automated Excel reports through VBA. Organized and validated data uploads to database using TELEVIDENT Software and MS SQL.

• Worked with Reckitt Benckiser team to analyze the total expenditure on Media Advertisement across countries.
• Manipulating, cleansing & processing the data using Excel and creating final Reports.
• Automating Excel reports like dashboard, coverage report and other reports through VBA.
• Day-to-Day Analysis of MIS Reports, follow up and coordination with cross functional teams to ensure timely flow of MIS.
• Organize, validate and upload data to database by using TELEVIDENT Software and MS SQL.
• Manipulating large data sets using MS excel and SQL.

Bachelor of Technology in Electronics & Communication – Vidya College Of Engineering (2010 – 2014)