Rashmita Baral
Union City,CA
Summary
Over 13+ years of Professional experience in Information Technology with emphasis on Production support Analyst, Data analyst, Software Quality Assurance and Sales Force Admin in different domains and involved in implementing the best Data warehouse testing practices, methodologies for the clients using today’s cutting edge technologies. Well versed in demonstrating the deliverable to the stakeholders and problem-solving skills, quick learning and detailed analysis capabilities.
Overview
14
14
years of professional experience
Work History
Production Support Data Analyst
Apple (via Infosys)
11.2022 - Current
- 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
- Getting good knowledge of the AppleCare tool and calculates Earned and Deferred Margin for BuySell commodies and allocates to LOB
- Generate Forecast based on Sell Through / Billing / Booking Actuals (Run Rate based)
- Generate Forecast based on Hero Products (Apache Rate Based)
- Assisted with issues encountered and work with them to provide solutions
- Resolved Auto INC in configuration based on time and autosys script
- Communicated known problems and fixes to team members and other technical groups, submitting knowledge solutions as needed, notifying management and end user communities where applicable
- Learned different Apps based on AppleCare and Retail in SCI
- Worked on Apple SCI internal tool - SCOPE and Demantra application
- AppleCare’s Channel Service Planning (CSP) is using Oracle Demantra’s DM module to conduct demand planning and inventory planning processes, with SAP as their execution system
- The planners are organized by Channel and Region levels
- The regions are Americas (AMR), Europe, Middle East & Africa (EMEA), and Asia-Pacific (APAC)
- The CSP planning team will be using demantra to calculate the projected target stocking levels (TSL’s) and projected fill rates at the individual part number-ship to combinations
- SCOPE is Supply chain optimized project estimation
- Build on Rodeo framework, which uses excel as UI
- Users of the tool are apple internal planners
- Master data is setup by planners and transactional data (Inventory, backlog, demand and forecast) comes from SAP
- Manage the incident process to ensure issues are recorded, tracked, resolved, and follow-ups are done in a timely manner
- Take ownership of the issues reported by the customer and ensure that these are resolved effectively or escalated to other cross-functional teams with relevant data as needed in a timely manner
- Worked on database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, structure and to maintain data efficiently.
Production Support Data Analyst – EDW Analytics – Data Modelling
Apple (via Infosys)
09.2019 - 09.2022
- This project involves in development and support of numerous highly business critical applications in different areas like Sales, Operations, Marketing, Research & Development, Services, Human Resources, Customer Relationship Management, Finance etc for the Apple client
- This project plays a crucial role in the day-to-day operations of the client company Responsibilities
- Involved in understanding the business requirements for reporting and use requirements gathered to define design for building
- Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions
- Involved in creating database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, structure and to maintain data efficiently
- Generated Tableau Dashboard and BO reports with quick/context/global filters, parameters and calculated fields
- Interacted with Users, Data modeler, in order to generate the reports required and resolved existing issues
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
- 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
- Restricted data for particular users using Row level security and User filters
- Developed Tableau workbooks and BusinessObjects reports to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
- Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily
- Generated Tableau Dashboard and BO reports with quick/context/global filters, parameters and calculated fields
- Strong understanding of advanced Business Objects and Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions
- Create mappings and configure ETL pipelines to extract data from source systems and aggregate into Teradata tables using ETL tools – Spark, Kafka, Storm and Teradata tools/utilities
- Creation and deployment of PL/SQL procedures involving business logic to aggregate the data into reporting tables
- Analyze the issues reported by business analysts, perform short term and permanent resolution for issues Optimization of strategic as well as tactical queries involving join between multiple tables and views in Teradata
- Design, execution and performance tuning of PL/SQL procedures, review the query performance, optimizing code and monitoring the overall Data Warehouse Performance
- Strong experience in creating database objects such as Tables, Views, Functions, Stored procedures, Index, Triggers, and Cursors in Teradata
- Create and deploy processes in GIT repository for data induction from source systems to Teradata using Spark code as per the Business requirements
- Create and deploy Kafka topics with required configurations to store the intermediate data
- Monitor and fix the data as well as framework related issues by modifying the code accordingly to accommodate the changes
- Modify the spark configurations to optimize the memory and resource utilization and improve the overall performance of the system.
Tableau Developer / Data Analyst
Kar Auction service Inc
03.2017 - 08.2019
- Involved in developing Functional Design document based on client requirements
- Involved in developing dashboards using Tableau
- Make use of data modeling techniques in designing the data marts project
- Involved in creating database objects such as tables, views, procedures, triggers, and functions using PL/SQL to provide definition, structure and to maintain data efficiently
- 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
- Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis
- 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
- Resolved long running SQL queries in tuning SQL for better performance
- Used Python Scripts for Data Extract and Data Transfer.
Production Support Sales Force Admin/QA Analyst
KAR Global
03.2010 - 01.2017
- Production Support Sales force Admin/QA Analyst in wholesale and Retail auto auction Industry, serving customers both online and at its 70+ auction locations across North America
- 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
- Define SOW, Test Plan and Test Strategy
- Build a testing team of professionals with appropriate skills, attitude, and motivation
- Develop test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan
- Ensure content and structure of all Testing documents / artifacts is documented and maintained appropriate reviews and walkthroughs
- Involved in leading, guiding and monitoring the analysis, design, implementation, and execution of the test cases
- Involved in tracking and reporting of Test results using Dashboards
- Very proficient in Functional and Regression testing
- 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
- Create and maintain custom objects, object relationships, standard, and custom fields with the Salesforce Platform
- Manage dashboards, reports, forms, templates, page layouts, workflows, and approval
- 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
- Study workflows to identify problems and make recommendations for resolution
- Work with business analysts and clients to determine requirements and business user needs
- Coordinate significant changes to procedures, technology, applications, and identify solutions
- Develop project plans and manage implementation of solutions within the department and business units
- 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
- Study workflows to identify problems and make recommendations for resolution
- Work with business analysts and clients to determine requirements and business user needs
- Coordinate significant changes to procedures, technology, applications, and identify solutions
- 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 extensive experience in Quality Assurance testing like Black box testing, Functional testing, Integration testing, GUI testing, Backend testing, User acceptance testing, ad-hoc testing, Smoke Testing, Regression testing in different stage of Software Development Life Cycle (SDLC)
- Knowledge of Automation testing for regression
- Experience in manual testing on Web, Client/Server, and Windows environment
- Effectively involved in bug tracking, reporting reviewing and analyzing test result using Quality Center, JIRA and BugZilla
- Performed backend testing of databases by writing and executing SQL queries
- Expertise in preparing the Test Plans, Test cases and Test Reports based on the System Requirements and Design documents, Business requirement documents and Functional requirement documents
- 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
MS in Computer science -
Illinois Institute of Technology
Skills
- Software Development Life cycle (Agile, Waterfall)
- 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 (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)
Skills
TECHNICAL SKILLS:
Software Development Life cycle
Agile, Waterfall
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
Jira ,Quality Center, Test Director, Bug Zilla ,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
Achievements Certifications Awards
- 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
Timeline
Production Support Data Analyst
Apple (via Infosys)
11.2022 - Current
Production Support Data Analyst – EDW Analytics – Data Modelling
Apple (via Infosys)
09.2019 - 09.2022
Tableau Developer / Data Analyst
Kar Auction service Inc
03.2017 - 08.2019
Production Support Sales Force Admin/QA Analyst
KAR Global
03.2010 - 01.2017
MS in Computer science -
Illinois Institute of Technology
Similar Profiles
Chetan RamanChetan Raman
Technical Program Manager at Apple Inc. Client Via InfosysTechnical Program Manager at Apple Inc. Client Via Infosys
Suhas RaoSuhas Rao
Scrum Master at Apple (Infosys Ltd)Scrum Master at Apple (Infosys Ltd)
Reenu RanawatReenu Ranawat
Software Developer at Apple/InfosysSoftware Developer at Apple/Infosys