Sruthi Thogati

Sruthi thogati

bookmark on deepenrich
location of Sruthi ThogatiUnited States
Phone number of Sruthi Thogati+91 xxxx xxxxx
Followers of Sruthi Thogati640 followers
  • Timeline

    Jun 2019 - Dec 2021

    Application Development Analyst

    Accenture
    Hyderabad, Telangana, India
    Aug 2022 - Dec 2023

    SCAA Student Assiatant

    California State University - East Bay
    Current Company
    Mar 2024 - now

    Data Engineer and BI Developer

    Zions Bank
  • About me

    MSBA graduate student at Cal State Eastbay

  • Education

    • California state university - east bay

      2022 - 2023
      Masters business analytics 3.5
    • Srmist, kattankulathur, chennai ,tamil nadu

      2015 - 2019
      Bachelor's degree electrical, electronics and communications engineering
  • Experience

    • Accenture

      Jun 2019 - Dec 2021

      Designed and managed databases using SQL and MySQL Workbench, employing stored procedures to ensure efficient operations and seamless data flow. Leveraging tools like Lucid Chart, I performed comprehensive conceptual and logical data modeling, incorporating scraped data to enhance database management.Utilized Power BI to create interactive dashboards and reports, transforming complex datasets from SQL and Snowflake into actionable insights that improved stakeholder decision-making and supported organizational quality standards.Ensured data quality through rigorous cleansing and validation processes while implementing advanced security measures, including encryption, access controls, and data masking, to safeguard sensitive information. These efforts demonstrate my ability to deliver innovative, efficient, and secure solutions tailored to strategic business objectives. Show less • Optimized SQL queries and performed database defragmentation, resulting in an 80% enhancement in loading speed and overall database performance, prioritizing stakeholder benefits, quality assurance, and production support.• Transitioned SFTP operations from Axway to Control-M, increasing efficiency by 30% and reducing production costs by 15%, positively impacting sales, business performance, and risk management, with a strong focus on security measures.• Enhanced SQL and PL/SQL script efficiency by 20%, optimizing code for better performance, strengthening task management, and emphasizing troubleshooting for seamless operations and business analysis through Agile training. • Developed Informatica mappings, increasing extraction speed by 25% across diverse data sources, reinforcing quality assurance and advancing data analytics for quantitative analysis, aligning with Agile methodologies in information systems.• Utilized Dimensional Data Modeling techniques in Oracle 11g/10g, ensuring optimal data structuring and maintaining quality assurance standards for stakeholders. Awarded the BMW Best Performance Award for exceptional contributions directly impacting strategic planning, business growth, and emphasizing security practices in business intelligence.• Skilled in writing and optimizing SQL, PL/SQL, and SQL Plus scripts for data conversions, employing cursors and exception handling for efficient data retrieval and processing. Developed and maintained metadata repositories to document data lineage, transformation rules, and data definitions, ensuring transparency and traceability of data processes. Show less

      • Application Development Analyst

        Jul 2021 - Dec 2021
      • Associate Software Engineer

        Jun 2019 - Jun 2021
    • California state university - east bay

      Aug 2022 - Dec 2023
      Scaa student assiatant
    • Zions bank

      Mar 2024 - now
      Data engineer and bi developer

      Experienced Data Engineer with a strong background in designing and implementing data warehouses, ETL pipelines, and real-time data processing solutions for banking and financial services. Proficient in Snowflake, AWS (S3, Glue, Redshift, Lambda, EMR, Athena), and Azure, ensuring seamless integration, transformation, and analysis of large-scale datasets. Expertise in fraud detection, regulatory reporting, and customer insights through real-time transaction monitoring and big data analytics using Apache Spark, Scala, and Hadoop. Skilled in Power BI for developing interactive dashboards, real-time streaming analytics, and advanced DAX calculations to drive business intelligence. Strong hands-on experience with SQL performance optimization, achieving a 40% reduction in query response times and improving data integrity. Adept at CI/CD automation using Jenkins, Git, and implementing event-driven architectures for scalable data workflows. Collaborative team player with Agile experience, actively participating in sprint planning, retrospectives, and continuous improvement initiatives. Show less

  • Licenses & Certifications