Adarsh Kiran A

ADARSH KIRAN A SUMMARY Versatile and results-driven Data Analyst with 3+ years of experience in data analytics, reporting automation, and master data management across SAP, PIM, and e-commerce platforms. Skilled in Power BI, SQL, Excel, and VBA, with deep expertise in transforming raw operational data into interactive dashboards and performance insights. Proven ability to automate inventory, pricing, and catalog workflows using SAP-integrated solutions and custom logic. Known for aligning data models with business goals, resolving discrepancies through root cause analysis, and ensuring data integrity across systems. Strong foundational background in full-stack development (Angular, JavaScript, Oracle SQL), enabling a holistic understanding of both front-end reporting and back-end data structures. Adept at collaborating with cross-functional teams to deliver scalable, high-impact data solutions. PROFESSIONAL SKILLS • Data Analytics & BI: Power BI, DAX, Power Query, SQL, Excel (Advanced), Google Sheets, Python, KPI Design, Dashboarding, Data Visualization, Data Modeling, ETL Workflows, Master Data Management, Data Profiling, Cleansing, Validation, Root Cause Analysis, Sales & Pricing Reports, Demand Forecasting • Automation & Back-End Systems: SAP, PIM, Brandfolder, Power Automate, REST APIs, Dot-Digital, VBA, FTP Integration, Inventory Data Management, Workflow Evaluation • Development & UI: Angular 5, JavaScript, UI/UX Components, Git, Jira, Agile/Scrum • Collaboration & Operations: Stakeholder Communication, Stakeholder Analysis, Microsoft Office Suite, Vendor Relations, Training & Support Documentation WORK EXPERIENCE Data Management Administrator Moe's Home Collection Sep 2022 – July 2025 Vancouver, BC, Canada July 2025 – Present Kochi, Kerala, India (Remote) • Designed and deployed end-to-end Power BI dashboards and Excel visualizations to track product availability, pricing trends, and inventory turnover across 3,000+ SKUs, enabling data-driven decisions across sales and operations. • Developed custom DAX measures and calculated columns to support drill-through analytics, sales segmentation, and executive-level insights. • Authored and executed complex SQL queries to extract product lifecycle, customer, and order data from SAP and e-commerce databases for performance reporting and audit tracking. • Leveraged Power Query and Excel to model multi-source datasets and maintain frequent inventory and pricing dashboards for leadership and retail partners. • Automated repetitive pricing and product update workflows using Power Automate, VBA macros, and FTP pipelines, improving data refresh rates and minimizing human error. • Distributed structured product feeds and pricing updates to customers through FTP, API integrations, and Dot Digital email campaigns, ensuring timely availability and alignment with portal specifications. • Standardized master product and pricing data across SAP, PIM, and ERP systems through normalization, data profiling, and error resolution strategies. • Partnered with the IT team to build automation logic and implement feature enhancements for bulk pricing uploads, SKU launches, and multi-channel data syncing, resulting in a 70% reduction in manual workload. • Managed ongoing PIM governance, ensuring accurate product metadata, visibility controls, variant logic, and image mapping across all platforms. • Built reusable data pipelines and reporting templates for direct customer feeds using Excel, Power Query, PIM, and FTP-based automation tools. • Conducted root cause analysis on inventory discrepancies and pricing mismatches using SQL, Excel, and error logs, driving long-term data quality fixes. • Linked visual content from Brandfolder to product records in PIM, ensuring clean asset presentation across marketing, sales, and customer platforms. • Created executive-ready KPI dashboards and performance snapshots for sales, operations, and marketing teams using Power BI, Excel pivots, and SQL-driven summaries. • Led the onboarding of enterprise clients into SAP, configuring structured accounts, syncing pricing levels, and testing catalog integration workflows. • Partnered with IT, Sales, and Logistics teams to align reporting needs with platform capabilities, standardize sync schedules, and prioritize automation enhancements. • Built and maintained documentation for data handling procedures, dashboard refresh protocols, and sync logic, supporting cross-functional usage and audit readiness. • Interfaced directly with major customers and platform partners to resolve data sync issues, clarify technical specs, and align on delivery frequency and file structures. Service Specialist Save-On-Foods Feb 2022 – Sep 2022 Vancouver, BC • Supported pricing accuracy, product labeling, and inventory workflows, and developed a sharp eye for data consistency, anomaly detection, and quality control in a retail operations context. • Participated in weekly pricing updates and store audits, ensuring pricing data integrity across POS systems and shelf displays — directly reinforcing my later work in digital pricing workflows and SKU validation. • Assisted in preparing stock-level summaries, performance reports, and promotional compliance checks for store leadership, providing structured data input for decision-making. • Communicated directly with customers to resolve pricing or product issues — often investigating underlying data discrepancies and updating records in real-time. • Supported the onboarding and training of new staff, including tools, process documentation, and workflow tracking — developing habits around repeatable and auditable systems. • Gained foundational skills in workflow optimization, retail analytics, and team collaboration that transferred into my later Power BI and PIM-based analytics roles. Associate Software Engineer Classic Technology and Business Solutions May 2018 – July 2019 Kochi, Kerala, India • Developed and maintained internal enterprise platforms, including a custom Human Capital Management (HCM) system and Fleet Management (FLM) system, supporting 25,000+ employees and enterprise-wide vehicle operations. • Built and deployed full-stack web applications using Angular 5, JavaScript, SQL, and PL/SQL, covering modules such as Bulk Shift Assignment, Attendance & Leave Tracking, Payroll Processing, Accident Logging, and Vehicle Dispatch & Assignment. • Designed relational database schemas, managed stored procedures in Oracle SQL, and ensured scalable and secure handling of HR and fleet datasets across systems. • Extracted and analyzed HRM and fleet-related KPIs, enabling the creation of dashboards and automated reports used by HR, Safety, and Operations departments for strategic decision-making and compliance audits. • Conducted data mapping and system integration between internal ERP systems and new application modules, streamlining information flow and reducing redundancy. • Collaborated with cross-functional teams (HR, QA, DBA) to define requirements, prioritize bugs, and deliver updates in Agile sprint cycles, tracked using Jira. • Enforced data protection policies and security best practices for all internal-facing applications, performing regular code audits and access controls to protect sensitive information. • Supported QA testing, handled internal support tickets, and maintained documentation for user training and compliance. EDUCATION Post-Baccalaureate Diploma: Technical Management & Services Kwantlen Polytechnic University, Surrey, BC, Canada - Bachelor of Technology: Computer Science & Engineering Rajiv Gandhi Institute of Technology, Kottayam, Kerala, India - CERTIFICATIONS • • • • • • • Microsoft Power BI Data Analyst | Coursera Microsoft Excel: Data Analysis with Excel Pivot Tables | Udemy Microsoft Power BI Desktop for Business Intelligence | Udemy Fundamentals of Business Analysis | Udemy Google Analytics | Google Academy Big Data Technologies | IT Skills Python & Django | Zenrays