Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Chithra Rajan

Dallas,USA

Summary

  • Business Data Analyst with more than 14 years of experience in Business Analysis and Data Analysis
  • Expert experience in analyzing and visualizing data, pattern and trend identification and working with multiple stakeholders at different levels of the organization
  • Excellent experience identifying and documenting critical requirements through analysis of existing systems and discussion with various levels of users
  • Strong focus on business knowledge and fast in learning and documenting new business processes
  • Experienced in developing test plans, test cases, Manual and User Acceptance Testing
  • Excellent Analytical, Problem-solving Teamwork and Leadership
  • Exceptional written and verbal communication skills
  • Organized, Process-oriented, and Result-oriented approach
  • Highly accountable along with effective project coordination capabilities to evaluate, plan, and deliver on time
  • Extensive experience in Sales, Forecasting, Retail, CPG, and Logistics
  • Proven customer relationship skills at all levels including Executives, Business, IT, and End Users

Overview

19
19
years of professional experience

Work History

Business Data Analyst

Neiman Marcus Group
Dallas, USA
11.2023 - 07.2024
  • Dashboard Standardization Team is entrusted with all data-related requests for the NM Group
  • This includes creating and maintaining databases, handling data analysis, and root cause analysis requests from different parts of the organization
  • Design, Visualization, and Maintenance of dashboards using Tableau /Qlik
  • Research, identify, and prioritize data-driven initiatives
  • Design and lead the development of KPI dashboards to maximize business productivity
  • Data consistency issues root cause analysis for business stakeholders
  • Requirements gathering, lead development, and stakeholder engagement for an application that will act as a hub for all reports across the organization

Data Analyst

PepsiCo Inc
Plano, USA
12.2021 - 03.2023
  • Data and Analytics team spearheads an innovative AI solution to help retailers predict promotions to maximize profit and margin
  • The project involves data collection, cleansing, outlier detection, and using the prepared data for forecasting an optimized solution
  • Requirements Gathering for Actual vs
  • Forecast dashboard
  • Data collection from different 3rd party sources
  • Data cleaning to update and remove corrupt and incorrect records
  • Analysis of large data sets using Excel, VBA scripts, SQL
  • Create business insights and dashboards using Tableau/Power BI for Business Decisions
  • User Acceptance Testing for Actual Vs Forecast dashboard
  • Weekly data maintenance, analysis, and reporting
  • Reviewing updated data from different sources
  • Evaluating different promotional calendars for different attributes

Business Data Analyst

Frito-Lay North America
Plano, USA
08.2015 - 03.2021
  • Sales Innovation project deals with the Sales Transformation and innovation in the field
  • This team develops customer-specific region growth plans & tactics, unlocks shopper insights, Forecast Sales & develops customer marketing plans
  • Weekly, Periodic, and Yearly sales and Point of Sales reporting for different customers
  • Data collection from different sources including databases, SAP Business Objects and Survey Monkey
  • Data cleaning to update and remove corrupt and incorrect records
  • Analysis of large data sets to create business insights and dashboards for Business Decisions
  • Ad-hoc reporting from SAP Business Objects for different business-critical activities
  • Creating and maintaining scheduled reporting for Sales Representatives' performance scorecard
  • Develop and maintain Tableau Dashboards for Visual Regional and Divisional Sales Performance Charts
  • Using Excel VBA to develop and maintain tools for forecasting and dynamic calculations
  • Also developed several tools for assisting users in several business functions
  • Built Advanced Excel calculations using pivots and formulas
  • Participated in Requirement Analysis and User Testing for large Visualization and CRM projects
  • Work with business partners, product managers, and developers to clarify project requirements and scope

Technical Analyst

Infosys Ltd
06.2005 - 01.2012
  • Started as a Software Engineer and worked with several Fortune 500 companies in Retail, CPG & Logistics domains to develop, implement and support software solutions
  • From coding, debugging and support progressed to requirement analysis and design ensuring successful project outcomes through effective communication and problem-solving skills

Education

Post Graduate Diploma - Business Analysis

Purdue University
01.2021

Bachelor of Engineering - Computer Science & Engineering

Mahatma Gandhi University
Kerala, India
05.2005

Skills

  • MS Excel
  • SAP Business Objects
  • Requirements Gathering
  • Business Process Mapping
  • Gap analysis
  • Data Analysis
  • Stakeholder Management
  • Change impact analysis
  • Project Management
  • Pivot tables
  • User Acceptance Testing
  • Tableau
  • Power BI
  • DB Visualizer
  • MS Visio
  • Azure Databricks
  • Confluence
  • Jira
  • Snowflake
  • Oracle
  • MySQL
  • MS Access
  • SQL
  • Excel VBA
  • MS Visual Basic
  • Windows
  • Unix
  • COBOL
  • JCL
  • Natural
  • Core Java
  • HTML
  • Microsoft Project
  • Microsoft Word
  • Microsoft PowerPoint
  • Microsoft Outlook
  • SharePoint
  • SnagIt
  • Adobe Photoshop
  • Star Team
  • Quality Center
  • File Aid
  • Endevor
  • Informatica
  • Salesforce

Timeline

Business Data Analyst

Neiman Marcus Group
11.2023 - 07.2024

Data Analyst

PepsiCo Inc
12.2021 - 03.2023

Business Data Analyst

Frito-Lay North America
08.2015 - 03.2021

Technical Analyst

Infosys Ltd
06.2005 - 01.2012

Post Graduate Diploma - Business Analysis

Purdue University

Bachelor of Engineering - Computer Science & Engineering

Mahatma Gandhi University

Similar Profiles

CREATE PROFILE
Chithra Rajan