Home

Munagapati sathwik varma - Data analyst

[email protected]

Location: Tampa, Florida, USA

Relocation:

Visa: OPT

Varma Munagapati [email protected] (813) 683-6409 SUMMARY Experienced Data Analyst with 5+ years of expertise in data modeling, dashboard development, and end-to-end ETL pipeline implementation across SaaS and technology sectors. Proven track record in transforming raw data into actionable business insights through advanced SQL queries, Python scripting, and BI tools like Power BI and Tableau. Skilled in designing and deploying scalable data solutions using cloud platforms including Azure, AWS, and Snowflake. Adept at collaborating with cross-functional stakeholders to align analytical strategies with business objectives, increasing operational efficiency. Strong background in real-time and batch data processing using Apache Kafka, Airflow, and Azure Data Factory. Delivered measurable business impact by building automated reporting systems that improved decision-making speed and accuracy. Hands-on experience with REST APIs, Git-based version control, and data encryption techniques to ensure secure and compliant analytics environments. Certified Azure AI Engineer with deep understanding of data lakes, star/snowflake schemas, and ML feature store design for enterprise-scale analytics. SKILLS Languages & Scripting: SQL (T-SQL, PostgreSQL), Python (Pandas, NumPy), R, Bash ETL & Orchestration: Apache Airflow, SSIS, Azure Data Factory, Alteryx, AWS Glue, DBT Databases & Storage: Snowflake, Azure Synapse, AWS Redshift, PostgreSQL, MySQL, Cosmos DB, SQL Server Cloud Platforms: Microsoft Azure (Synapse Analytics, ADF, Azure Data Lake), Amazon Web Services (AWS EC2, Redshift) Visualization Tools: Power BI (Power Query, DAX), Tableau, SSRS, Excel (PowerPivot, VBA, Lookups, Macros), Qlik Sense, Google Looker Studio, AWS Quick Sight, R-shiny, Stream lit, DOMO Version Control & DevOps: GitHub, Git, Jenkins, Azure DevOps, CI/CD, Bitbucket, DBT Testing, Confluence Monitoring & Logging: Splunk, AWS CloudWatch, Azure Monitor Security & Compliance: OAuth2, Azure Key Vault, RLS, Data Encryption API & Integration: REST API Development, JSON, Webhooks Data Modeling: Star, Snowflake Schema, Data Lakes, Feature Store WORK EXPERIENCE SAAS GLOBAL SOLUTIONS Remote, US Sr Data Analyst May 2024 - Present Performed end-to-end ETL using Azure Data Factory and DBT to streamline data ingestion, resulting in a 30% reduction in processing time. Developed Power BI dashboards to visualize SaaS KPIs (ARR, churn rate, MRR) for leadership, improving decision-making speed by 15%. Automated recurring reports using Python and SQL to reduce manual workload by 25 hours weekly, increasing reporting accuracy by 98%. Implemented Kafka pipelines to process real-time application data, enabling instant insights and reducing latency by 40%. Collaborated with product and finance teams to align reporting with business goals, resulting in a 40% boost in report adoption. Engineered Snowflake feature stores for ML models to accelerate training cycles, reducing model prep time by 20%. Configured RLS and Azure Key Vault to enforce data security policies, ensuring 100% compliance with internal access controls. Utilized Azure Monitor and Splunk to track pipeline health, maintaining a 99.9% job success rate through proactive error handling. Migrated legacy SQL Server datasets to Azure Synapse, doubling query performance and enabling scalable data analysis. Built CI/CD pipelines with GitHub Actions and Azure DevOps to enable automated deployments, reducing release errors by 60%. Created KPI scorecards to monitor financial and operational metrics, increasing budget adherence by 10%. Ingested external engagement data via REST APIs to centralize marketing analytics, enabling a unified customer view. Documented data pipelines and metrics definitions in Confluence to streamline onboarding, reducing ramp-up time by 50%. Performed anomaly detection on business metrics and implemented alerting, decreasing reporting errors by 35%. Led monthly executive review sessions and delivered insights that influenced pricing and retention strategies. Partnered with DevOps to build resilient data systems and automated logs, improving pipeline observability and fault tolerance. Standardized data validation tests using DBT, improving trust in analytics outputs and reducing QA issues by 40%. DIVO TECHNOLOGIES Hyderabad, India Data Analyst Jun 2019 - Aug 2023 Performed data extraction and transformation using SQL and SSIS to consolidate information from CRM, sales, and web analytics sources, resulting in a 35% improvement in reporting accuracy. Developed Tableau dashboards to visualize operational KPIs across supply chain and sales teams, reducing reporting turnaround time by 40%. Performed Python-based data cleaning and preprocessing for customer and transaction data, streamlining model readiness and improving downstream data quality by 25%. Analyzed sales performance trends using SQL and Excel to identify underperforming regions, enabling sales leadership to take corrective actions and boost regional revenue by 12%. Designed and implemented star schema models in MySQL to support self-service reporting, improving query performance by 2x. Performed customer behavior segmentation using SQL and Power BI to inform targeted campaigns, leading to a 10% increase in engagement rates. Created automated Excel dashboards using VBA and SQL connections to support real-time insights for nontechnical stakeholders, reducing manual effort by 20 hours per month. Monitored daily data pipelines using Airflow and resolved ETL job failures proactively, increasing overall data availability to 99.8%. Collaborated with product and marketing teams to evaluate the impact of feature releases using A/B testing and trend analysis, leading to a 15% increase in user retention. Integrated external APIs to pull market and competitor pricing data, enabling dynamic pricing analysis for leadership. Created SSRS reports for operations and finance teams to track metrics such as order fulfillment time and payment cycle, improving process transparency. Worked cross-functionally with engineers and data architects to identify data discrepancies, improving source-toreport accuracy by 30%. Developed SQL procedures to automate recurring monthly reports, reducing manual preparation time by 60%. Led effort to migrate reporting from Excel-based templates to interactive Power BI dashboards, improving executive visibility and dashboard engagement. Built ad-hoc analytical models to support internal strategic decisions, such as vendor performance evaluation and warehouse optimization. Performed root cause analysis of missing or inconsistent data records, resulting in enhanced data pipeline validation and a 25% reduction in reporting errors. Documented ETL workflows, data definitions, and dashboard KPIs for internal knowledge sharing and faster onboarding of new analysts. Certifications: Microsoft Certified Azure AI Engineer Keywords: continuous integration continuous deployment quality analyst artificial intelligence machine learning business intelligence database active directory rlang