Vidit Malhotra

Operations Associate

Noida, Uttar Pradesh, India14 yrs 6 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

13 years of experience in analytics and data management.
Expert in SAS, Python, and Tableau for data analysis.
Led a team of 5 in delivering analytical solutions.

Stackforce AI infers this person is a Healthcare Analytics Professional with strong expertise in data management and reporting.

Contact

Skills

Core Skills

Data ManagementAnalyticsHealthcare AnalyticsData Automation

Other Skills

.NET.NET FrameworkASP.NETAdvance MS ExcelAgile & Waterfall MethodologiesAgile MethodologiesAnalytical SkillsBase SAS CertifiedBusiness AnalysisC#CommunicationData AnalysisData AnalyticsData CleaningData Extraction

About

- Total Experience : 13years(5 years leading a team) - Current Designation : Manager(Analytics) at Ameriprise Financial LLC - Previous Employments : EXL Services.com || DXC Technology || Infosys Limited - Current Location: India, Noida(NCR, New Delhi) - Current Role(s) : Manager, Data Architect, Lead SAS Programmer - Major Skill Set : SAS (Base & Advanced),Python programming, Power BI, SQL Server, Tableau, Advance Excel, Agile Methodology - Education : Bachelor Of Engineering (2011, Manipal Institute Of Technology) - Certifications : Base SAS Certified (A00-211) - Onsite Exposure : Denmark(Europe) - Extra-curricular : Tutoring Students/working professionals in SAS(Base & Advance), Excel(Base & Advance), SQL Server, Basic Tableau

Experience

Ameriprise financial services, llc

2 roles

Manager - Analytics

Feb 2023 – Present · 3 yrs 1 mo · Noida, Uttar Pradesh, India

Data Architect

Aug 2020 – Jan 2023 · 2 yrs 5 mos · Noida, Uttar Pradesh, India

Leading team of 5. We provide end-to-end support for various analytical activities. The team manages Data, develops reports, refreshes and maintains analytical models and provides Campaign management support.
The data management team manages the critical datamart which comprises of around 400 daily, weekly, and monthly active data feeds needed for Analytics.
The reporting team automates generation and distribution of reports that support business decision making.
Model scoring teams helps in deploy, maintain, and validate statistical and Machine Learning models.
The campaign management team supports business in driving privacy and quality sensitive communication with clients and prospects.

SASTableauPython (Programming Language)Data ManagementAnalytics

Exl

Lead Assistant Manager

Nov 2018 – Aug 2020 · 1 yr 9 mos · Noida Area, India

1. Lead a project on MS-Access application which automates various checks on Excel files received, to match the correct LOB, Market place and Analysis of Eligible Population based of different Healthcare markets and different LOBs. [No. Of DRs- 03 ; Skill set- MS Access, MS SQL Server]
2. Worked for US Healthcare client, to get their certification cleared for various healthcare plans by checking their effectiveness with the US authorizing committee: NCQA.
[No. Of DRs- 05 ; Skill set- SAS(on SAS EG), Tableau,Hadoop/HIVE(on Aginity)]
Other skills: SQL Server, Advance MS Excel
3. Scratch coding done for a healthcare plan end to end which helps in analysing if a member qualifies for calculation of Star- Rating using HEDIS [Skill set- SAS(on SAS EG)]

SAS ProgrammingSASTableauSQL ServerAdvance MS ExcelHealthcare Analytics+1

Dxc technology

Product Developer

Sep 2014 – Nov 2018 · 4 yrs 2 mos · Noida Area, India

NOTE: DXC Technology is the joint venture of CSC India Pvt Ltd & HP Enterprises.
Worked as a SAS programmer to deploy information to the municipalities of Denmark & Sweden providing complete healthcare services to the citizens of the two countries.
Responsibilities:
1. Engaged in importing data as well as formulating data sets for analysis
2. Participating in data cleaning & formatting operations according to the requirements of the end-user
3. Formulating reports according to the ad-hoc queries & exporting this data
4. Performing statistical analysis on healthcare related data using SAS for peer review research paper and Business Intelligence for Danish authorities & deliverers
5. Engaged in coding, documentation and validation of SAS programs / macros / procedures to produce the standardized data display for VITAE project
6. Performing detailed design of modules such as patient’s home care facilities along with their implementation & documentation
7. Analyzing & modifying existing codes to incorporate new requirements & ad-hoc requests from the user requirements, wrote new codes as required

Microsoft SQL Server

Infosys

Senior System Engineer

Jul 2011 – Aug 2014 · 3 yrs 1 mo · Jaipur Area, India

1.
Title: Re-insurance (FSI)
Period: Jan’ 14 – Aug’ 14
Description: A finance domain project aiming reduction of client's exposure to loss by passing part of the risk of loss to a re-insurer or a group of re-insurers. Reinsurance can make an insurance company's results more predictable by absorbing larger losses & decreasing the amount of capital needed to provide coverage.
2.
Title: Operation Excellence Management System
Period: Jun’ 13 – Dec’ 13
Description: This project is implemented for one of the global leader in the manufacturing of commercial and industrial air-conditioning systems by including set of activities such as creating & routing of cases to various levels and indexing of the invoices based on some criteria
3.
Title: ATLAS COPCO SLAM
Period: Jan’ 12 – May’ 13
Description: The project aims the designing & development of a reporting tool that allows the capture & publication of the SLA performance measures, nominated performance indicators and transaction volumes.