Archana C

About Archana C

Dynamic Business & Data Analyst adept in SQL, Python, and Tableau. Excels in data…

Experience

1. Senior Business Analyst

   Walmart

   Dec 2022 — Present · Bentonville, AR, US

   Involved in writing functional/non-functional requirements for report rationalization and re-platforming as per inputs from the business. Involved in performing data mapping (source to target) for report attributes identified during.Built geospatial datasets, Excel dashboards, and SSAS cubes for insights.• Followed agile methodology involving sprint planning/retro planning sessions with each sprint covering two weeks.• Worked as a business/data analyst to analyze existing business objects reports to identify the usability of the same.• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.• Designed use cases, data flow diagrams, process flows, data model and context diagrams to provide visual representation of data to the business users as well as achieve unified reporting data.• Shared the meeting minutes created with business to get approval and sign off from the business users and key stakeholders.• Developed python scripts to compare data across Teradata and Snowflake.• Translation of the Clip BTEQ scripts and data from traditional Teradata/SQL to cloud using AWS services (EC2, S3, Lambda) and JSON utilizing the quantum framework.• Learned new cloud-based services like snowflake and AWS components and involved in knowledge transition sessions.• Resolved user queries on the data present in Data Warehouse and AWS Cloud and help the users in providing the definitions and data usage. • Developed shell script that runs the python code, save the.csv file on EC2, S3 bucket and load the data into Amazon Redshift database. • Worked in AWS Environment for loading data files from Legacy UNIX Systems to UNIX system. • Performed SQL Testing on AWS Redshift databases. • Created dashboard Mockups in Excel using Pivot tables and graphs and pie charts for presenting in front of the business and also, to give an idea about potential dash boarding solution capabilities.