Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Interests
Timeline
Generic

Monalika Ranjan

Senior Data Analyst
Bangalore

Summary

Tech Analyst with over 5 years of experience providing insights to stakeholders from APAC, AMESA and EU region in order to drive successful business solutions. Aiming to utilize technical, analytical, and data crunching skills for advancing in career.

Overview

5
5
years of professional experience
3
3
years of post-secondary education
1
1
Certification
3
3
Languages

Work History

Senior Data Analyst

Aptean
Bangalore
06.2021 - Current

Working on snowball report which shows changes in ARR over time based on combination of Asset data which shows ARR values and opportunity data which explains the changes.


Utilizing my SOQL, SQL, EXCEL and POWER BI skills to optimize and correct data from salesforce.


Working on asset reload which is responsible to modify/ load the asset entities into Salesforce.


Heading India data team for data visualization and enhancing current process.


Documenting processes for smooth training. And training resources to expand India Data team.


Enhancing snowball report for better reporting by using analytical skills.

Application Devl Spec 1

IQVIA
Bangalore
06.2017 - 05.2021

Worked on IQVIA CRM MI (Mobile Intelligence), OM (Organization Manager) and OCE (Orchestrated Customer Engagement). Handled multiple clients across the globe. Integrated OneKey Database and ETL tools for internal job handling.


Developed reports in accordance of client requirement which further helped in data analytics using SQL, Excel and Tableau.


Analyzed client data and integrated into system using ETL tool (KOMODO), processed logic to provide accurate information to our business partners.


Resolved escalated issues using SOQL on salesforce based CRM and handled administration and configuration of OCE (salesforce CRM).


Trained clients to handle the business tasks smoothly.

Education

Bachelor of Science - Computer Science And Programming

Lovely Professional University
Jalandhar, India
08.2014 - 05.2017

Skills

    SOQL

undefined

Accomplishments

    Won Platinum award in 2017. Our team got recognized world wide.

    In 2015, I was appointed as POC (Point of Contact) for APAC region.

Certification

Salesforce Admin 201 Certification

Interests

Trekking

Doodling

Dancing

Timeline

Senior Data Analyst

Aptean
06.2021 - Current

Salesforce Admin 201 Certification

12-2019

Application Devl Spec 1

IQVIA
06.2017 - 05.2021

Bachelor of Science - Computer Science And Programming

Lovely Professional University
08.2014 - 05.2017
Monalika RanjanSenior Data Analyst