Data-Driven Business Analyst with 7+ Years Experience
Resume:
Sowmiya Jaganathan
Tempe, AZ +1-414-***-**** ****************@*****.***
Experienced Business Data Analyst with 7+ years of progressive industry experience with a strong foundation in data analysis, process optimization, and system analysis. Proficient in SQL, Power BI, Python and Jira for translating business requirements into scalable solutions. Experienced in Agile/Scrum environments, bridging the gap between stakeholders and developers to drive data-driven decision-making and digital transformation.
WORK EXPERIENCE
INFOSYS Banglore, India
Business Data Analyst Dec 2021 - Nov 2023
Project 1: Vanguard
● Drove end-to-end ownership of system monitoring and automation by leading cross-functional requirement gathering sessions, delivering scalable solutions that improved alert accuracy, system reliability, and incident response time.
● Led a 6-person engineering team to perform root cause analysis through structured business process review and proactive maintenance, achieving a 30% reduction in incident resolution time.
● Built and maintained dynamic Excel-based data models tracking 20+ KPIs, improving performance visibility and reducing monthly reporting errors by 35%.
● Designed and implemented an interactive Power BI dashboard to analyze 1200+ monthly support tickets, enhancing visibility into team performance and boosting productivity by 20%.
● Streamlined task management by designing a JIRA-based workflow optimization system, improving cross-functional collaboration and reducing maintenance turnaround time by 30%.
● Created and executed custom SQL queries on datasets exceeding 10 million records, uncovering system inefficiencies and driving a 35% increase in operational performance.
● Conducted stakeholder workshops to translate business needs into technical requirements, ensuring alignment between monitoring strategies and business objectives.
● Partnered with QA and DevOps teams to integrate monitoring insights into release cycles, proactively addressing system risks and improving deployment stability. Project 2: Morgan Stanley
● Monitored Smart Alert and Advanced Orders dashboards to track real-time system performance, ensuring operational integrity and early issue detection.
● Collaborated with cross-functional stakeholders to gather business requirements, communicate system changes, and bridge communication between business and technical teams.
● Investigated system alerts and escalated critical issues to the NOC, driving timely incident resolution and supporting continuous uptime.
● Facilitated root cause analysis sessions, providing insights and documentation to improve alert response workflows and reduce recurrence.
● Designed and validated health check processes for batch jobs, ensuring accurate table loads and pipeline consistency.
● Maintained data integrity across ETL pipelines, proactively identifying anomalies and implementing corrective measures.
● Developed a Smart Alerts dashboard using SQL and Python, enabling real-time monitoring and reducing critical incident response time by 40%.
● Documented standard operating procedures and incident handling playbooks, enhancing team readiness and ensuring knowledge continuity across support functions. MPHASIS Banglore, India
Business Analyst Dec 2016 - Nov 2021
Projects (Royal Bank of Scotland, DXC-AxsPSS, CBRE)
● Conducted root-cause analysis of business-impacting incidents across Linux, Oracle, and Splunk environments, interpreting technical logs to uncover underlying issues affecting application performance.
● Collaborated with cross-functional teams including developers, QA, and operations to implement corrective actions and long-term process improvements based on incident findings.
● Analyzed enterprise Java application workflows, identifying performance bottlenecks and translating technical diagnostics into actionable business insights.
● Developed and automated SQL-based diagnostic reports and disaster recovery strategies, leading to a 40% reduction in downtime for mission-critical systems.
● Designed and maintained scalable data pipelines using Alteryx and Informatica, supporting accurate and timely data delivery for reporting and analytics needs.
● Implemented a centralized ServiceNow monitoring and incident management framework across 50+ applications, enabling streamlined support and consistent SLA compliance over 24 months.
● Facilitated stakeholder communication by documenting business impact, issue resolution timelines, and preventive measures through structured reporting in ServiceNow. PROJECTS
Bank Customer Churn Prediction Modeling
● Applied Analytical skills to Build a predictive churn model on 1M+ customer records using Decision Tree, achieving 99% accuracy through advanced data preprocessing and model tuning.
● Enhanced model performance by 25% via feature engineering techniques like binning, encoding, and variable selection.
● Developed Power BI dashboards to track Key Performance Indicators and visualize churn trends, enabling business stakeholders to identify at-risk segments and reduce churn rate. Amazon Fulfillment Center Optimization
● Designed a Linear Programming model in Excel Solver to optimize labor, machine hours, and storage allocation across two warehouses.
● Reduced operational costs by $18K by implementing a cost-effective production and shipping strategy.
● Ensured 100% demand fulfillment while balancing capacity constraints and resource efficiency. Sentiment-Driven Product Improvement Using Customer Reviews
● Used Python + NLP techniques to extract sentiment and recurring complaints from 10,000+ customer reviews.
● Clustered insights using Excel and visualized trends using data visualization tools
● Provided actionable product recommendations, leading to a 12% decrease in negative reviews post-release. SKILLS
● Databases: SQL, Oracle, MySQL, Microsoft SQL Server
● Programming Languages: SQL, Python (NumPy, Pandas, Matplotlib, Scikit-learn, PyTorch)
● Business Intelligence Tools: Tableau, Power BI, DAX, MS Excel, Alteryx, Informatica, Splunk, Visio
● Project Management Tools: Microsoft Office 365, JIRA, SharePoint, Confluence, ITIL
● Machine Learning: Supervised ML (Linear and Logistic Regression, Decision Trees, Random Forest, XGBoost, Unsupervised ML (K-Means, PCA), Natural Language Processing (NLP), A/B Testing EDUCATION
ARIZONA STATE UNIVERSITY Arizona, US
Master of Science in Business Analytics, Big Data (GPA: 3.9/4) May 2025 MNM JAIN ENGINEERING COLLEGE Chennai, India
Bachelor of Engineering, Electronics & Communication May 2016
Contact this candidate