Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sougandhi Kalapala

Ashburn,Virginia

Summary

Data Visualization Specialist with proven expertise in creating impactful dashboards and enhancing SQL Server management, achieving a 20% increase in database efficiency at MasterCard. Skilled in Tableau and SQL for insightful data analysis, excelling in project scheduling and structured problem solving to drive data-driven decisions across teams.

Highly detailed Senior Systems Analyst offering outstanding testing, documentation, and team oversight skills. Self-motivated and committed to resolving critical issues through attention to detail. Known for great work and reliability.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Systems Analyst/Data Analyst

MasterCard
St. Louis, USA
04.2022 - 10.2024
  • Developed more than 10 organizational dashboards.
  • Constructed visualization reports leveraging DOMO, providing an alternative solution to Tableau.
  • Developed Python-based application to track and assess revenue.
  • Managed data definition language tasks aligning with enterprise objectives.
  • Enhanced SQL Server database architecture, boosting design efficiency by 15%.
  • Enhanced operational efficiency by 20% through effective SQL execution.
  • Proficient in managing databases through ALM and SQL Server technologies.
  • Developed extensive summary documents using log axes, trend lines, statistics, groups, and hierarchies.
  • Optimized reporting accuracy with thorough join modifications and basic SQL checks in Tableau.
  • Handled data analysis, design, development, implementation, and testing of ETL processes.
  • Created customized reports using DOMO to meet specific needs.
  • Developed survey cards in DOMO, integrating them into the required Executive and Leadership Culture Dashboard.
  • Implemented visual content for Guilds Dashboards sourced from the MasterCard Hub.
  • Developed analytical dashboards using DOMO platform's capabilities including API functionalities.
  • Proficient in applying ETL methods within DOMO environment.
  • Developed a dashboard integrating customer feedback survey data.
  • Developed milestone tracking dashboard for specified deadlines.
  • Designed an interface to track and manage schemas for comprehensive dashboard analysis.
  • Implemented ETL workflow to produce new datasets utilized in Risk Guild dashboards.
  • Demonstrated Executive Dashboards to senior leadership and team members.

Tableau Developer/Senior Process Engineer/Data Analyst

USAA Client
San Antonio, USA
10.2020 - 04.2022
  • Enhanced current dashboards to meet evolving requirements in the Deposits and Credit Bureau Disputes (FCRA Program).
  • Developed Tableau scorecards, dashboards with stack bars, bar graphs, scatter plots.
  • Developed advanced Tableau dashboards with comprehensive elements such as data blending, actions, and parameters.
  • Created detailed summary reports with trend lines, statistics, log axes, groups, and hierarchies.
  • Revised fundamental SQL queries and modified join clauses in Tableau Desktop.
  • Created predictive analytics report using Python and Tableau.
  • Applied advanced techniques such as polynomial transformation to optimize regression models.
  • Collaborated with various teams across the company to develop customized Tableau workbooks.
  • Transformed Business Objects reports into Tableau dashboards.
  • Engineered effective data integration solutions within Alteryx.
  • Utilized Alteryx tools to blend, prepare, and model diverse datasets.
  • Engineered advanced queries and constructed dashboards in Tableau.
  • Generated Ageing report since April 2021 enabling MBT team to fulfill 30-day SLO.
  • Contributing to the design of a process map for Military Protection team.
  • Produced a detailed operational dashboard aimed at enhancing oversight of Military Benefits and SCRA QA.
  • Automated 90-day reports in Tableau for business reconciliation of work items.
  • Generated ad hoc reports based on business requests.
  • Designed and maintained Operational Reports including Daily EWL Volume.
  • Facilitated seamless transition of data migrating to Snowflake from Netezza database.
  • Facilitated the creation of the AML Forecasting Report by extracting necessary data from Snowflake.
  • Ensured daily updates to the Asana Dashboard with necessary work items.
  • Collaborated on developing Level 5 process maps.
  • Engaged with the KC governance team to execute procedure updates, obtain approvals, and ensure publication.
  • Supported achievement of almost 10,000 request remediations by the RPA team.
  • Upgraded RPA systems for compatibility with updated MBT technology.

Tableau Developer

CVS Health
Maryland, USA
08.2016 - 10.2020
  • Engineered application for presenting multiple report types on a Tableau platform.
  • Analyzed requirements and application functionality based on specifications.
  • Developed and tested Tableau functional reports per user demands; ensured ongoing maintenance.
  • Mastered deployment of advanced graphic displays with interactive elements.
  • Designed comprehensive Tableau data visualization including Cross tabs, Heat maps, Box and Whisker charts among others.
  • Established guidelines for JIRA workflow management.
  • Applied statistics and table calculations for comprehensive data analysis.
  • Created comprehensive summary reports with adept use of grouping elements and advanced data metrics.
  • Skilled in applying industry-leading visualization and design techniques.
  • Supported business objectives through tailored SQL writing.
  • Performed administrative tasks including setting permissions, managing ownerships, and providing user access.
  • Managed the development lifecycle of T-SQL procedures built on sophisticated database interactions.
  • Managed engineering elements including testing protocols and performance adjustments along with designing dashboards.
  • Utilized Alteryx for data preparation, subsequently using Tableau for visualization and reporting.
  • Created visualizations enhancing decision-making capabilities.

Education

BE - Electronics & Computer Engineering

JNTU University
Visakhapatnam, INDIA
05.2011

Skills

  • Data Visualization with Tableau
  • SQL Server Reporting Services
  • SQL Server Management
  • Data Analysis Using Access
  • MS Office Suite
  • SharePoint Management Skills
  • Project Scheduling Expertise
  • SQL Query Specialist
  • Database Organization
  • SQL Server Management Studio
  • SQL Server Integration Services
  • Windows Operating System Expertise
  • Structured Problem Modeling
  • Schema Development Expertise
  • Data Dimensional Modeling
  • Star Schema Implementation
  • Data Interpretation
  • Dimension Analysis
  • Data Entity Analysis
  • Core Competencies

Certification

Certified in Tableau Desktop Specialist

Timeline

Senior Systems Analyst/Data Analyst

MasterCard
04.2022 - 10.2024

Tableau Developer/Senior Process Engineer/Data Analyst

USAA Client
10.2020 - 04.2022

Tableau Developer

CVS Health
08.2016 - 10.2020

BE - Electronics & Computer Engineering

JNTU University

Similar Profiles

  • Susan Vinson

    Susan VinsonSusan Vinson

    Customer Relationship Management Specialist at MasterCardCustomer Relationship Management Specialist at MasterCard

  • Sydney Bechtel

    Sydney BechtelSydney Bechtel

    Americas Sales Analyst at MastercardAmericas Sales Analyst at Mastercard

  • Rafal Trepka

    Rafal TrepkaRafal Trepka

    VP, Customer Solutions, Central Asia & Caucasus at MastercardVP, Customer Solutions, Central Asia & Caucasus at Mastercard

  • Jacopo Grabar

    Jacopo GrabarJacopo Grabar

    Site Reliability Engineer II at MastercardSite Reliability Engineer II at Mastercard

  • Isha Vepa

    Isha VepaIsha Vepa

    Preschool Teacher (Capstone Project) at Loudon MontessoriPreschool Teacher (Capstone Project) at Loudon Montessori

CREATE PROFILE
Sougandhi Kalapala