Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
ADITYA RANA

ADITYA RANA

Noida,UP

Summary

Confident Analyst in Lead Generation and managing potential clients. Ability to skillfully pitch projects and communicate product information.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Application Support Analyst

BirchStreet Systems
09.2022 - Current
  • Managed daily hotel inquiries, increasing efficiency by 15% through streamlined communication using Salesforce service cloud.
  • Using list,dimension and list subsets for preparing a model to analyze the revenue of Hotels region wise within accurate vision.
  • Considering PLANS while structuring the model and focusing on less sparsity and more dynamic module.
  • Created lists, and calculated line items to get the revenue data for fiscal year 2024-2025.
  • Using Informatica intelligent cloud service for ETL and monitoring the jobs created against the workflows.
  • Worked on documenting a user guide of 200 pages containing detail level workflows.
  • Identified and resolved discrepancies in data sources, reducing reporting errors by 20%.
  • Analyze large datasets and provide consolidated data fetching from database using PL SQL in order to extract meaningful insight.
  • Using Excel to create pivot tables on a regular basis and send data to the verticals.
  • Collaborated with product teams to tailor data presentations, enhancing understanding and utilization of data-driven insights.
  • Ensuring data integrity and accuracy.
  • Reviewing SQL report views in order to understand the source data.
  • Creating Power BI dashboard to provide valuable business insights to corporate giants.
  • Troubleshooting of issues on a real-time basis.
  • Led cases of IHG hotels to streamline data reporting processes, demonstrating leadership and collaboration with multiple departments, resulting in a 25% reduction in report generation time into client sftp directory.
  • E-Procurement solution for Hospitality Industry (Hyatt, Hilton, Marriott, Aimbridge, Holiday Inn, Four Seasons, Melco)
  • Highlight your accomplishments, using numbers if possible.
  • Reporting Code Drops, Escalations Using JIRA
  • Using Salesforce Ticketing System to handle Client queries
  • Achieving desired target of process SLAs as well as KPIs

Associate Consultant

Planafin
01.2022 - 07.2022
  • Certified Anaplan Model Builder
  • Level 1, Level 2, Anaplan Way
  • Focused on Enterprise Planning and Performance Management zone
  • Analyzed and Integrate Data using Informatica Cloud (Anaplan Hyper-connect)
  • Documentation for Master Data, Transaction Data and System Administration work done in Informatica
  • Providing user access to particulars roles, roles-modules, roles-version, roles-action
  • Import using simple list, numbered list
  • Used Reference formulas module to module
  • Created Planning Calendar in UX
  • Created various Charts

Analyst

GLC
08.2019 - 10.2021
  • Gather, review, analyze and implement data requirements to produce business leads
  • Analyzed and created solution reports on historical datasets
  • Apply best practices for problem-solving and effective communication within the team & clients
  • Visualize data using business intelligence tools like Power BI
  • Used complex MY SQL queries to retrieve consolidated data from source database

Education

Bachelor of Technology -

Graphic Era Hill University
01.2019

Skills

  • Technical Skills
  • Advanced excel
  • Anaplan
  • Data Integration
  • Statistical Analysis
  • Data Visualization
  • Data Manipulation
  • Informatica Cloud
  • Jira
  • Lead Generation
  • Excel
  • ETL (Extract Transform Load)

Certification

  • Certified anaplan model builder level 1
  • Certified anaplan model builder level 2
  • Certified Anaplan Way

Timeline

Application Support Analyst

BirchStreet Systems
09.2022 - Current

Associate Consultant

Planafin
01.2022 - 07.2022

Analyst

GLC
08.2019 - 10.2021

Bachelor of Technology -

Graphic Era Hill University

Similar Profiles

CREATE PROFILE
ADITYA RANA