Data Analyst Real-Time

Rohan Thammi Setty Data Analyst

Summary

Accomplished Data Analyst with over 3+ years of extensive experience at leveraging SQL, Python, and cloud platforms like AWS and GCP for robust data extraction and predictive analytics. Proficient with advanced visualization tools including Looker Studio, PowerBI, and Tableau, have a track record of driving significant enhancements in business processes and revenue optimization. Skilled in developing real-time dashboards and predictive models, he excels in delivering strategic insights that enable data- driven decisions and market agility in fast-paced environments. Technical Skills

Programming Languages: Python (NumPy, Pandas, SciPy, Statsmodels), R, SQL, Java, Scala

Data Visualization: Tableau, Power BI, Looker Studio (GCP), AWS QuickSight, Matplotlib, Seaborn, Plotly

Database Management: MySQL, PostgreSQL, MongoDB, BigQuery (GCP), AWS Redshift, Snowflake, Oracle

Big Data Technologies: Apache Spark, Hadoop, Hive, HBase

Data Management & ETL Tools: Apache Airflow, Talend, Alteryx, AWS Glue, SSIS, Informatica

Cloud Platforms: AWS (S3, Redshift, Lambda, SageMaker, Glue), GCP (BigQuery, Looker Studio, Cloud Functions, Dataflow, Dataproc)

Other Tools: Excel (Advanced Functions, VBA, Power Query), Jupyter Notebooks, Jira, Confluence, Google Analytics, SAS, RapidMiner

Professional Experience

Data Analyst, Mars Inc. 07/2023 – Present Remote, USA

Worked on a sophisticated real-time dashboard aimed at monitoring competitors' pricing and promotions, thereby enhancing data- driven strategic decision-making within the competitive retail landscape without explicitly identifying market participants.

Engineered automated SQL-based data extraction processes, ensuring comprehensive and efficient management of competitive data. Utilized Google Cloud Platform's BigQuery for robust and scalable data storage, facilitating swift data retrieval and processing.

Employed Python for rigorous data cleansing and preparation, establishing a foundation of high-quality data essential for generating accurate competitive insights and analyses, pivotal in driving strategic business decisions.

Conducted in-depth market trend analysis and competitor strategy evaluations using advanced analytics techniques. Developed predictive models that forecast competitor behavior, significantly enhancing strategic planning and competitive positioning.

Designed and deployed an interactive dashboard using Looker, providing stakeholders with dynamic visual reports and real-time insights into competitive activities. Enhanced user engagement and decision-making capabilities through intuitive data visualization and interaction features.

Delivered strategic insights that enabled proactive adjustments to pricing and promotional strategies, leading to improved market responsiveness and strategic agility. These adjustments contributed directly to a measurable enhancement in competitive positioning and business performance.

Data Analyst, Wipro 01/2020 – 12/2021 Remote, India

Separated customer transaction data from MySQL using advanced SQL techniques like CTEs, window functions, and joins, ensuring high-quality datasets for analysis by cleaning and transforming data with Python (Pandas, NumPy).

Engineered predictive features such as purchase frequency, recency, average order value, and inactivity periods using Python, and utilized Excel’s Pivot Tables and Power Query to summarize and analyze key trends.

Integrated Logistic Regression and Random Forest models into the analytics workflow using Python, optimizing them with hyperparameter tuning to achieve an 87% accuracy rate in predicting customer churn.

Designed interactive Tableau dashboards to showcase churn metrics, segmented behaviors, and actionable insights, and created detailed reports for non-technical stakeholders using advanced Excel functions like VLOOKUP and INDEX-MATCH.

Migrated large datasets to AWS Redshift for centralized storage and optimized query execution, and automated data ingestion pipelines with AWS Lambda for scalable and efficient data processing workflows.

Collaborated with marketing teams to recommend personalized campaigns and retention strategies, leveraging Excel scenario modeling to demonstrate potential outcomes, achieving a 20% reduction in churn over six months.

Created dynamic Power BI dashboards for real-time churn monitoring and effectiveness tracking, and automated reporting pipelines with Python and SQL, reducing manual effort by 40% while ensuring timely insights delivery. Education

Master of Science, University of North Texas Denton, TX, USA Information Technology 01/2022 – 05/2023

Bachelor of Engineering, Malla Ready Engineering University Hyderabad, India Electronics and Communication 08/2016 – 05/2020

*****@***********.*** 817-***-**** USA LinkedIn

Contact this candidate