Raman Keshari

Raman Keshari Email and Phone Number

Data Analyst @ Staples
framingham, massachusetts, united states
Raman Keshari's Location
Greater Toronto Area, Canada, Canada
About Raman Keshari

● Nearly 3+ years of expertise in data analysis, including data visualization, data management, data modeling, and data cleansing. Skilled in designing interactive and intuitive Excel dashboards that provide actionable insights● Proficient in Power BI, Tableau, and Looker for data visualization and analysis, creating interactive dashboards, reports, and charts. Utilized advanced features such as Power Query, DAX, and complex DAX functions for sophisticated data analysis and modeling● Experienced in programming with Python, R, VBA, and SAS, leveraging these languages for data manipulation, automation, and advanced analytics. Skilled in using data manipulation libraries such as Pandas and NumPy● Extensive experience in database management using MS SQL Server, Snowflake, and Presto, with strong SQL skills for querying and managing data across various platforms● Expert in data transformation using ETL Tools, SSIS, and SSRS, developing ETL solutions and generating comprehensive reports to facilitate data-driven decision-making● Advanced Excel Specialist, proficient in VLOOKUP, Macros, Pivot Tables, Power Query, and Power Automate to streamline processes and deliver actionable insights● Skilled in Customer Relationship Management (CRM) software, adept at managing and analyzing customer data to drive business decisions● Demonstrated expertise in the creation of stored procedures, views, triggers, and tables using SQL, reflecting a deep understanding of database structure and manipulation● Proficient in data analysis and modeling, using tools and techniques like DAX, NumPy, Pandas, statistical analysis, and predictive modeling to uncover insights and forecast trends● Experienced in machine learning and cloud services, including TensorFlow, sci-kit-learn, PyTorch, and Azure, for advanced analytics and cloud integration● Adept at identifying, defining, and tracking KPIs to measure business performance, providing insights and recommendations for growth● Expertise in using Jira for project tracking and management, effectively aligning data analysis projects with Agile practices and committed to continuous professional development, staying abreast of the latest trends and technologies in data analysis to drive innovation and efficiency

Raman Keshari's Current Company Details
Staples

Staples

View
Data Analyst
framingham, massachusetts, united states
Website:
staples.com
Employees:
29840
Raman Keshari Work Experience Details
  • Staples
    Data Analyst
    Staples Mar 2022 - Present
    Canada
    ● Composed complex SQL queries utilizing various features such as joins, aggregate functions, subqueries, and set operations to retrieve and manipulate data● Collaborated with cross-functional teams to develop a statistical forecasting model, accurately predicting sales for the next quarter within 10% of actual results● Developed a customized automated change tracking process using Python for the Marketing team, reducing errors and man-hours by approximately 70%● Engineered a self-sustainable reporting system for executives, eliminating the need to create new SQL queries in case of changes, resulting in a 90%time savings during report updates● Conducted in-depth analysis of marketing strategies and store enhancements using statistical methods such as A/B Testing, contributing to the development of a long-term strategic plan and influencing key decisions around sales and growth● Designed automated reports in Tableau and Power BI to track cost per carton, total expenses, various surcharges, and total transportation volume on a weekly, periodic, and quarterly basis at hub, region, and carrier levels● Developed a tool using MS VBA and Python to update courier rate changes directly into the database, facilitating the business team’s work with transportation rates● Created process mapping using MS Visio for combining the promotional marketing emailing processes across various business groups● Constructed a comprehensive database encompassing all Staples products and associated companies' products detailing SKU numbers, dimensions, weights, associated child or parent SKUs, rates, discounts, availability, locations, and other product-level information
  • Middle East Insurance Services Llc
    Reporting Analyst
    Middle East Insurance Services Llc Jun 2020 - Mar 2021
    Oman
    ● Spearheaded the development of advanced visualizations and dashboards using SQL and Power BI, significantly enhancing data-driven insights● Dramatically improved the performance of long-running SQL queries through meticulous optimization with Execution Plans● Removed duplicate records, managed missing values, and fixed data inconsistencies to improve data quality● Worked on processing unstructured data into a form suitable for analysis, perform data analysis required to troubleshoot data-related issues, and assist in the resolution of data issues● Utilized advanced Excel features and VBA scripting for task automation, leading to improved operational efficiency● Produced reports, graphs, summaries, and presentations that convey analytic results in an easy-to-understand ● Used a systematic approach to plan, create, and maintain data architectures while keeping them aligned with business requirements. Initiated work on the database to obtain data from the right sources. After formulating a set of dataset processes, stored optimized data● Analyzed and manipulated large sets of data to inform stakeholders including shortcuts and formula functions, building charts and graphs, sorting, and filtering data, utilizing pivot tables, macros● Prepare and present data-driven reports and insights to stakeholders, highlighting key findings and recommendations

Raman Keshari Education Details

Frequently Asked Questions about Raman Keshari

What company does Raman Keshari work for?

Raman Keshari works for Staples

What is Raman Keshari's role at the current company?

Raman Keshari's current role is Data Analyst.

What schools did Raman Keshari attend?

Raman Keshari attended St. Clair College, Maulana Azad National Institute Of Technology, Indian School Muscat.

Who are Raman Keshari's colleagues?

Raman Keshari's colleagues are Chris Moccia, David Slarskey, Tyler Harding, Irene Ndivo, Michael Andrews, Emanuel Luna, Riley Sullivan.

Not the Raman Keshari you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.