Basavaraju S

Key Responsibilities:

• Led dashboard design and development.
• Built and architected reporting automation, including the entire dashboard reload process.
• Engineered and automated pipelines for dashboards and reports.
• Optimized existing Qlik data warehousing scripts.
• Migrated critical reports to the cloud for easier decision-making.
• Analyzed retail data to create models and customer segments for targeted campaigns, increasing sales and retention.
• Developed solutions to improve operations and optimize workflows, reducing costs.

Retail Sales and Operation Dashboard

• Role: Lead Designer
• Tools: QlikView, QlikView Object Extension
• Methodology: Web-like UI/UX Design
• Actions: Designed a multi-page dashboard with a button and navigation object extension using HTML/CSS.
• Impact: Improved retention rates for top fashion retail brands in India.

Campaign Factory Product for Top Fashion Retail Brands

• Role: Lead Designer and Co-Developer
• Tools: QlikView, QlikView Server and Publisher, Shell & Batch Scripting
• Methodology: ETL, Process Automation, Data Modeling
• Actions: Designed a web-like UI dashboard, automated the ETL process, and optimized data load times.
• Impact: Improved decision-making and retention rates, leading to a 30% increase in incremental sales.

Inventory Trend Analysis Dashboard

• Role: Lead Designer and Developer
• Tools/Languages: QlikView, Python
• Methodology: ETL, KPI Reporting, Data Normalization
• Actions: Extracted and transformed JSON data, ensured data normalization, and built the dashboard.
• Impact: Enhanced inventory visibility for internal teams.

Inventory Visibility Dashboard

• Role: Lead Designer and Developer
• Tools/Languages: QlikView, Python
• Methodology: ETL, KPI Reporting
• Actions: Aggregated data for visibility across channels, cities, states, and regions.
• Impact: Optimized inventory decisions for Vijay Sales.

Open Orders Dashboard

• Role: Lead Designer and Developer
• Tools/Languages: QlikView, Batch Scripting
• Methodology: ETL, Data Normalization
• Actions: Extracted and transformed data from MySQL, built an aging report with master filters.
• Impact: Assisted in reducing orders stuck in certain statuses.

MIS Report Optimization and Migration from QlikView to Snowflake

• Role: Lead Developer
• Tools/Languages: Snowflake, Snowflake SQL
• Methodology: ETL, Data Normalization, Views, CTEs
• Actions: Migrated reporting from Qlik to Snowflake, ensured data quality and tested reporting.
• Impact: Reduced report delivery time from 7 hours to 20 minutes.

Web Scraping: Sellers Information from Marketplaces

• Role: Lead Developer
• Tools/Languages: Python, Jupyter Notebooks, NodeJS, JavaScript
• Methodology: Browser Automation, Data Scraping
• Actions: Scraped contact information of sellers from various marketplaces.
• Impact: Collected 5K+ seller contacts for new customer acquisition.
• Developed dashboards using QlikView and QlikSense with data from MySQL, AWS S3, and CSVs.
• Optimized ETL pipelines, improving data processing efficiency by up to 50%.
• Implemented data validation processes to maintain data integrity.

Additional Projects

• Developed dashboards using QlikView and QlikSense with data from MySQL, AWS S3, and CSVs.
• Optimized ETL pipelines, improving data processing efficiency by up to 50%.
• Implemented data validation processes to maintain data integrity.

Key Responsibilities

• Assisted seniors in commissioning, site onboarding, and data flow setup.
• Provided root cause analysis reports and client education.
• Interacted with technicians for remote issue resolution.
• Used data analytics for proactive issue troubleshooting.
• Established SOPs and processes for the team.
• Generated monthly, weekly, and quarterly management reports.

Key Projects:
Remote Energy Management for JOANN and PETCO
Role: Project Analyst
Technologies/Tools: Excel, Control System LGR WEBCtrl
Methodology: Data Reporting, Anomaly Detection
Actions: Preventive maintenance analysis, alarm & dashboard management, client reporting, live technician support for HVAC and RTUs.
Impact: Improved energy efficiency, reducing electricity costs.

Key Responsibilities:

• Resolved customer issues and provided updates.
• Answered customer inquiries via calls and emails. Managed approximately 200 calls a day.
• Streamlined processes for faster response times.