Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Trained in SQL Trained work on Tableau Reporting Certified Sales force Admin through Sales force App
Timeline
Generic

Rashmita Baral

Union City,CA

Summary

Dynamic Production Support Data and Operations Analyst with a proven track record at Apple, skilled in optimizing workflows and enhancing team productivity. Expert in SQL and data visualization, I excel in delivering actionable insights and fostering collaboration. Adept at problem-solving, I consistently drive operational improvements and support high-quality service delivery.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Production Support Data And Operations Analyst

Apple
09.2019 - 07.2023
  • Managed multiple projects simultaneously, delivering results within tight deadlines while maintaining high-quality standards.
  • Optimized operational efficiency by analyzing and streamlining processes.
  • Improved team productivity by implementing effective workflow strategies and time management techniques.
  • Created custom reports and visualizations to support decision-making processes.
  • A supply chain is a system of organizations, people, activities, information, and resources involved in moving a product or service from manufacturer/supplier to end customer
  • Learn Supply Chain Terminology and work on Auto and Business inc based on Response and update SLA
  • Assisted with daily event, both critical and high incident, and problem management, following documented ITIL-based processes to support enterprise service delivery.
  • Performed regular system monitoring tasks.
  • Provided 1st-level triage and troubleshooting under supervision, contributing to the timely restoration of services and isolation of system failures.
  • Supported installation, configuration, and updates of monitoring and administrative tools, ensuring systems operated within expected parameters.
  • Documented all support actions and incidents clearly and accurately for knowledge sharing.
  • Involved in understanding the business requirements for reporting and use requirements gathered to define design for building
  • Before initiating any incident response, always perform troubleshooting and delegated system administration tasks to support the restoration of services or isolation of failing systems or components.
  • Assist in the installation, configuration, and updating of administrative and monitoring tools to ensure optimal system performance.
  • Participated in enterprise patch management cycles, applying updates to administrative utilities, system libraries, and security tooling in accordance with established change control protocols and compliance standards.
  • Working with large data sets; collect and capture large data sets, organizing and managing the sets and retrieve the data while using the projections to get the fastest performance using Teradata and Vertica.DB
  • Proven track record in analyzing, designing and implementing software applications in multiple domains.
  • Handover smooth shift turnovers by coordinating with incoming/outgoing staff, ensuring accurate transfer of operational updates and ongoing task status.
  • Collected and organized data to assist in drafting reports and metrics related to system capacity, performance, and service availability, contributing to improved visibility and planning.
  • Performed routine print operations by following documented procedures and prioritization guidelines, ensuring consistent and timely output in a high-demand environment.
  • Helped troubleshoot issues with both hardware and software in high-speed printing systems and their connection to mainframe computers, ensuring minimal disruption to operations.
  • Reported and escalated technical problems to the appropriate teams or vendors, while keeping track of repair progress to help restore printing services quickly and effectively.
  • Supported backup and disaster recovery processes by following step-by-step procedures to safely protect and recover data during scheduled routines or emergency situations.
  • Followed SDLC and ITIL-based service management practices to maintain consistent, high-quality IT operations and service delivery across the enterprise.
  • Designed and implemented standardized workflows and automated tasks, contributing to continuous service improvement and operational efficiency.
  • Maintained technical documentation using tools such as CA Service Desk Manager, SharePoint, TFS, and Microsoft Office Suite to support knowledge sharing and process clarity.
  • Researched and evaluated new technologies to troubleshoot persistent issues, modernize infrastructure, and support the rollout of new services.
  • Participated in formal and informal training to stay current with evolving technologies and operational practices, and regularly shared insights with team members to foster a collaborative work environment.
  • Communicated service disruptions, project updates, and operational concerns clearly using established tools and channels, ensuring stakeholders remained well-informed.


Kar Auction Service Inc - Production Support Analy

KAR Auction Services Inc.
03.2017 - 08.2019
  • Involved in developing Functional Design document based on client requirements.
  • Involved in developing dashboards using Reporting Tools.
  • Make use of data modeling techniques in designing the data marts project.

  • Created Source to Target mapping documents detailing Source rules, Target rules, Transformations required, Error handling etc., and worked with the team of ETL developers to implement the same
  • Designed database tables to feed Promotions, Campaigns, Customer, Sales data for effective targeting and direct marketing campaigns
  • Performed incremental extracts for OLAP database
  • Developed Tableau dashboards with combination charts for clear understanding
  • Participated in Regulation of financial Project and requirements gathering and translate business requirements into report visualization specifications design documents
  • Creating users, groups, projects, Data connections, settings as a tableau administrator
  • Using Tableau Prep for Data preparation and combine them into single source of data using joins and unions


  • Developed Scripts to load data into Hive and work with multiple data connections including Hadoop/Hive and by data blending
  • Creating SQL agent jobs after successful development of ETL packages and SQL codes
  • Maintained technical documentation using tools such as CA Service Desk Manager, SharePoint, TFS, and Microsoft Office Suite to support knowledge sharing and process clarity.
  • Researched and evaluated new technologies to troubleshoot persistent issues, modernize infrastructure, and support the rollout of new services.
  • Participated in formal and informal training to stay current with evolving technologies and operational practices, and regularly shared insights with team members to foster a collaborative work environment.
  • Communicated service disruptions, project updates, and operational concerns clearly using established tools and channels, ensuring stakeholders remained well-informed.


Production Support Operation Analyst

OPENLANE
02.2012 - 09.2017
  • Openlane was bought by Adesa/KAR auctions, did integration testing with other applications during consolidation/integration across applications
  • Identify and implement automated processes, staging and deployment of new SSO capabilities and enhancements
  • Work with internal and external customers to integrate hosted applications to help drive adoption of SSO services
  • Work closely with Product Managers, Business Analysts, Architects to define business requirements, to verify vehicle life cycle
  • Strong testing Quality Assurance experience within Agile environment.
  • Monitored and analyzed operational performance metrics, identifying trends and inefficiencies to support data-driven improvements across departments.
  • Collaborated with IT and business units to streamline processes through automation and standard operating procedures, enhancing workflow efficiency and service delivery.
  • Created, maintained, and presented operational reports and dashboards using Excel, SQL queries, and visualization tools to provide real-time insights to stakeholders.
  • Documented and updated operational procedures in SharePoint and knowledge bases to ensure consistency and clarity in task execution and training.
  • Assisted in incident and service request management using platforms like ServiceNow or CA Service Desk Manager, adhering to ITIL best practices.
  • Researched and evaluated new tools and technologies to improve system capabilities and reduce manual efforts, contributing to ongoing innovation and modernization.
  • Supported business continuity and disaster recovery processes, ensuring readiness through routine checks and documentation updates.
  • Worked on Management tools like JIRA, Azure DevOps, Quality Center/ALM, RQM, Clear Quest and Mantis bug tracking tool
  • Worked as an Interviewer on the Interview Panel for Testing Project Engagements
  • Maintain data quality and data cleanup in CRM system through data quality rules to remove duplicate data and cleanse inaccurate data including the movement of relevant Data to Tableau
  • Able to standardize data entries, scheduled data analysis, scheduled reports, bulk data loads, and validation rules
  • Produce quality deliverables that will scale as our system and data footprint is growing super-fast
  • Design, build and enhance integrations using middleware or REST APIs with various systems, including Infotainment Cloud and ERP systems, and ensure data integrity
  • Work with end-users to provide best practices and tips on Salesforce usage including training, documentation, and support as necessary
  • Prepare test plan, test strategy by carefully going through requirement document
  • Interact with Internal and external client and get clarifications regarding the business logic
  • Related to large-scale applications, systems, databases, and other technical products and services
  • Perform migrations from development to production, upgrades, installations, and configurations
  • Work with development teams to coordinate bug fixes and application roll outs
  • Develop project plans and manage implementation of solutions within the department and business units
  • Planning, Designing, Implementing and Executing Tests Using Rational Test Suite
  • Writing the Test Plans, Test cases and Test scripts
  • Hands on experience with all phases of Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC)
  • Well conversant with software testing methodologies including developing Test plans, Test scenarios, Test cases, Test procedures, Test reports and documenting manual tests
  • Have experience to test small desktop applications and web base application
  • Communicated with developers, business and other team members to thoroughly understand the requirements to ensure high quality software
  • Played a key role in timely delivery of the product
  • Ability to handle multiple tasks and work independently as well as in a team, good team player with excellent communication, analytical, interpersonal and writing skills.

Education

Master of Science - Computer Science

Illinois Institute of Technology
565 W Adams St, Chicago, IL 60661
12-1998

Skills

  • Software Development Life cycle (Agile, Waterfall)Agile / Scrum Basics
  • ETL Tools (Informatica, DataStage, Ab Initio, Sqoop)
  • Programming Languages (SQL, Unix, Shell Scripting PLSQL, AWS, T-SQL, Shell Scripting, Python)
  • Operating Systems (Windows, Unix, Linux, Macintosh, Ubuntu, Mac OS X, Safari)
  • Databases (Teradata 16, Oracle 20c, SQL Server, Vertica, Teradata, Oracle 10g/9i/8i, MS SQL Server 2000/2005, MS Access 2000, Teradata, Oracle)
  • Test Management Tools (Share Point,Jira, Quality Center, Test Director, BugZilla, Help Central for Incident)
  • Tools and Utilities (Quality Center, Rally, Test Director, SQL Assistant, TOAD, SOAP UI, TOAD, Clear Quest, Erwin Data Modeler, GitHub, ETL - Spark, Kafka and Storm, Keystone, Splunk, Autosys)
  • Advanced Excel (PivotTables, VLOOKUP, Macros)
  • Performance Metrics & KPIs
  • Workflow Optimization
  • Root Cause Analysis
  • Dashboards & Data Visualization (Power BI, Tableau)
  • Forecasting & Trend Analysis
  • Verbal and Written Communication
  • Stakeholder Reporting
  • Problem Solving & Critical Thinking
  • Change Management Support
  • Training and Knowledge Sharing

Accomplishments

  • Used Microsoft Excel to develop inventory tracking spreadsheets.
  • Documented and resolved high-priority incidents, minimizing system downtime and restoring business-critical operations within SLA limits, resulting in a 30% improvement in incident resolution time.
  • Captured detailed incident logs in ServiceNow and coordinated resolution efforts across departments, leading to faster root cause analysis and enhanced team knowledge sharing.


  • Achieved smoother shift handovers and improved task continuity by effectively helping with shift transition documentation and communication between teams.
  • Achieved greater team efficiency by helping streamline print operations and proactively resolving system errors using documented protocols..

Certification

  • Trained in SQL
  • Trained work on Tableau Reporting
  • Certified Sales force Admin through Sales force
  • Appreciation for outstanding contribution, achievement and sheer commitment towards work

Trained in SQL Trained work on Tableau Reporting Certified Sales force Admin through Sales force App

I’ve also completed hands-on training in Tableau, where I learned how to build interactive dashboards and visual reports that communicate data trends clearly and effectively to both technical and non-technical stakeholders.

Additionally, I am a Salesforce Certified Administrator, trained through the official Salesforce platform. This certification has equipped me with the skills to manage users, automate workflows, customize layouts, and maintain data quality within the Salesforce CRM—contributing to better customer engagement and business operations.

Together, these tools have helped me gain a well-rounded understanding of data analysis, reporting, and CRM platform administration. I’m confident in using them to solve real-world business problems, support decision-makers, and streamline daily operations.

Timeline

Production Support Data And Operations Analyst

Apple
09.2019 - 07.2023

Kar Auction Service Inc - Production Support Analy

KAR Auction Services Inc.
03.2017 - 08.2019

Production Support Operation Analyst

OPENLANE
02.2012 - 09.2017

Master of Science - Computer Science

Illinois Institute of Technology