AASTHA KHARE

Client 1: CISCO (USA) - 3.5 Years

• Business Requirement Elicitation: Partnered with cross-functional stakeholders to define project scope, perform data analysis, gather detailed requirements, and translate strategic objectives into scalable data driven analytical solutions, supporting operational and leadership decision-making.
• Technical Solution Design & Development: Designed and delivered enterprise analytics using SQL, Excel, and Tableau, engineering complex SQL queries (joins, window functions, and stored procedures) (100M+ records) while applying strong data modeling, and validation processes to ensure accuracy and governance.
• Strategic Reporting & Impact: Created dynamic, detailed dashboards in Tableau dashboards and scalable data products providing real-time KPI visibility, trend analysis, and drill-downs to improve operational efficiency and stakeholder self-service.
• Agile Project Leadership: Served as Scrum Lead, coordinated with Project Managers and technical teams, managed user stories, defects, and enhancements in Jira, improving sprint execution, delivery timelines, and execution of migration, validation, and data engineering initiatives.
• Team Leadership & Mentorship: Established governance, lineage, and audit frameworks while mentoring junior analysts through code reviews, technical guidance, and best-practice standards to strengthen data reliability and team productivity.

• Business Process Understanding: Collaborated with business users to understand reporting needs and operational challenges, translating requirements into data warehousing, ETL, and visualization solutions.
• ETL Development & Automation: Designed and optimized SSIS pipelines to automate process from multiple data sources (Excel, flat files, relational databases) into a centralized data warehouse supporting North America-wide users.
• Business Intelligence & Visualization: Built high-impact Power BI dashboards delivering unified visibility into sales, inventory, and operational KPIs, enabling data-driven strategic and operational decision-making.
• Data Performance Optimization: Optimized SQL and SSIS workflows using indexing, query tuning, and execution-plan analysis, reducing processing runtimes by 70%, cutting reporting discrepancies by 30%, and strengthening audit readiness.
• Data Quality & Governance: Maintained comprehensive governance documentation including business rules, metadata dictionaries, lineage mapping, and audit artifacts to support compliance and change management.

• Business Process Support: Leveraged SQL to extract, transform, and analyze data for trend analysis and variance reporting, supporting informed business decision-making.
• Data Validation: Supported senior analysts and business users by preparing clean, well-structured datasets for dashboard development and delivered recurring and ad-hoc reports using advanced Excel functions (VLOOKUP/XLOOKUP, Pivot Tables, INDEX/MATCH, IF/THEN).
• Data Compliance: Conducted and streamlined data quality assessments aligned with compliance standards, identifying and escalating critical issues for timely resolution.
• Stakeholder Communication: Developed PowerPoint presentations, translating complex analytical findings into clear visuals, insights, and actionable recommendations for business stakeholders.
• Analytical Support: Implemented A/B testing analytics pipelines and performance monitoring frameworks to drive engagement optimization.