Summary
Overview
Work History
Education
Skills
Websites
Data Analyst Skillsets
Data Analyst Experience
Previous Work Experience
Overall Skillsets
References
Timeline
Generic

SREEDEVI SELUKKA MADAN MOHAN

Dundas,Australia

Summary

Seeking Intermediate (Mid) level Data Analyst role having a strong background in Data Analysis, Testing and Data Quality assurance, willing for an opportunity to leverage analytical and problem-solving skills in the field of data analysis and quality. Eager to contribute to your dynamic organization that values integrity, offers a flexible hybrid working environment, and provides opportunities for growth and development. Proven offering a solid foundation in Data analysis, Data Quality, Reporting, and Visualization, along with a commitment to continuous learning and growth. Proven Problem solver with the ability to see the bigger picture and consistently perform at an exceptional level. Results-focused and Adaptive team player with an Analytical mindset tailored towards solving complex problems and delivering effective solutions within time frames. Excellent Interpersonal, Communication, and Presentation skills with extensive experience working alongside Clients, Data Scientists, Data Engineers & Analysts, Technical support teams, Insights team, Product Managers, Offshore Technical teams, and Senior Management across multiple time zones.

Overview

14
14
years of professional experience

Work History

Data Analyst

M&C Saatchi World Services Agency
09.2023 - Current
  • Business Name: NFPs Clients, Data Analysis and Reporting Project | AU Govt Clients | Waterfall & Scrum Development | Dbeaver SQL Editor | Various Media APIs | Google Looker Studio | Power Bi tool | Postgres SQL Querying | Python Querying VSC | Jira & Confluence
  • Collaborated with stakeholders to identify business needs and data sources.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Reduced operating costs by automating manual EXCEL data processes using scripting languages such as Python libraries like Pandas and Numpy.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Created data models to support decision-making processes.
  • Generated standard and custom reports to provide insights into business performance.
  • Established a culture of continuous improvement by fostering open communication channels and encouraging feedback on data analysis methodologies.

Data Quality & SQL Test Analyst

WooliesX
07.2020 - 01.2021
  • Business Name: Woolworths, MMMSupers Projects, BWS Integration with MMM Supers, ATL Banners, Category Offers | Retail Industry | Waterfall Methodology & Agile/Scrum Development | Big Query | Redshift SQL | GCP | AWS | Jira & Confluence

ETL/Data warehouse Test Analyst

MediaOcean
04.2018 - 04.2020
  • Client Name: WPP, HAVAS, IPG, DAN, OMD et al
  • ETL Testing in Data Warehousing & mScope Projects | Media Industry | Agile/Scrum Development | MS SQL Server | PLSQL Developer | SSIS Packages | JIRA | Confluence

Quality Test Analyst - Internship

Adactin Group Pty Ltd.
12.2017 - 03.2018
  • Client Name: Wrappli | Manual Testing | Agile/Scrum Development | Iteration-wise Test Plans | JIRA | Cross Browser Testing | Hybrid (Data Driven + Keyword Driven) framework using Selenium WebDriver | Automation Regression Test suites | NUnit
  • Client Name: Heritage Bank Limited (NPP) | Requirements Analysis Phase | Web Services Testing | Banking Domain | Payment transfer feature | Mocked Heritage Banking Application | SOAP UI | API Testing | JSON files | RESTAPI & POSTMAN | XML | CMS (Case Management System)

Software Developer and Test Analyst

Cognizant Technology Solutions
10.2009 - 01.2012
  • Client: WellPoint, USA | DMS (Disbursement Management System) Health Insurance Domain | Manual Testing | Mainframes Technology | Agile/Scrum Development

Education

Bachelor of Engineering (Electronics & Communications Engg) -

Mepco Schlenk Engineering College

Statement of Attainment in Emotional Intelligence -

TAFE NSW

Skills

  • Data profiling
  • SQL and Databases
  • ETL processes
  • Database Model Conversion
  • Data Cleaning
  • Data Analysis
  • Attention to Detail
  • Database Management
  • Business Intelligence Systems
  • Data Mapping
  • Data quality assurance processes
  • Power Bi, Google Looker Studio, Microstrategy, Tableau BI Tools
  • Python For Data Analysis
  • Data Validation
  • Data Warehousing
  • Report Preparation
  • Data Visualization and Presentations
  • Compatibility Testing
  • A/B Testing
  • Data Integrity Validation
  • Technical Support
  • Data Mining
  • Specifications Documentation
  • Stakeholder Communication

Data Analyst Skillsets

  • Data Analysis and Reporting: Proficient in leveraging data to perform intensive analysis across various areas of the business and draw actionable conclusions.
  • Exploratory Knowledge: Strong understanding of data exploration and experimental design to provide data-driven recommendations and guidance on experiments.
  • SQL Proficiency: Able to manipulate, analyze, and model large volumes of data with a high level of accuracy using various formats of SQL.
  • Data Management and Visualization: Experience with modern BI tools, particularly MicroStrategy, Tableau, Power Bi, Google Looker Studio for data visualization and reporting.
  • Intermediate Excel Skills: Proficient in Microsoft Excel and Google Sheets for data analysis and modeling. Conducted data analysis by exporting SQL tables to Excel sheets to perform data cleansing, analysis which cannot be performed in MS SQL Server.
  • Python Automation and Data Analysis: Skilled in Python Automation for data analysis, utilizing a variety of libraries such as NumPy, Pandas, Matplotlib, and Seaborn for data extraction, analysis, and statistical research. Employed SQL queries within the Python environment using Visual Studio Code (VSC) for efficient and expedited data cleansing and analysis—tasks that would typically be more time-consuming with traditional tools like Excel or SQL Server. Consequently, final outputs were exported to Excel files for presentation and further examination.
  • Data Structures and Modeling: Good level of understanding of data structures, data modeling, and data optimization techniques.
  • Data Cleaning and Preparation: Experienced in extracting and cleaning data to ensure its accuracy and usability for analysis and end-user consumption.
  • Attention to Detail: Meticulous in identifying and rectifying discrepancies or errors within data and deliverables to ensure data integrity.
  • Learning Agility: Quick to grasp new concepts and technologies, applying strategies to enhance knowledge acquisition and effectively utilize new skills and abilities.
  • Problem-Solving: Smart, strategic thinker with excellent problem-solving skills.
  • Strong Communication: Ability to articulate technical concepts and insights to business stakeholders of varying technical literacy.
  • Startup/Tech Experience: Have previous experience in a startup (India) and various tech environment across various Industry domains like Health Insurance, Media Agencies, NSW State Government Clients, Retail domains.

Data Analyst Experience

  • M&C Saatchi WSA, Created and designed reports & dashboards for Media data using Google Looker Studio and Power BI tool for regular client reporting, ensuring accuracy and relevance. Heavily utilized Excel, Google Sheets, and Postgres SQL for data analysis and querying. Automated numerous repetitive Excel tasks and complex operations that cannot be performed using SQL Editor through Python scripting via VSC tool. Employed Python scripting for in-depth data analysis, employing statistical approaches to project future expected values for selected metrics and to understand their relationships.
  • WooliesX, Ensured Data Quality across various stages of the projects for Retail data using AWS Redshift SQL Querying, Google Big Query SQL Querying, using Python and JSON scripting ensuring accuracy and relevance for regular client reporting. Leveraged Redshift and GCP SQL querying for comprehensive data analysis and querying tasks. Implemented Data Quality with AGILE/SCRUM methodologies. Used JIRA and Confluence under the guidance of a SCRUM Master
  • MediaOcean, Prepared and designed reports using MicroStrategy BI reporting tool for regular client reporting, ensuring accuracy and relevance. Also, Alteryx was used for Data Preparation, Cleaning and Blending for some data sources which were not part of the ETL. Coordinated with Developers to normalize and de-normalize required tables and optimize Data enrichment streams, streamlining reporting and analysis processes to improve efficiency. Responsible for Quarterly product release report generation and maintenance of client-facing dashboards. Implemented effective database solutions and models to enhance Data management capabilities. Monitored system performance through various types of Testing phases, Troubleshooting, and Integration of new features. Assisted in Data analysis and modeling tasks, including Data profiling, transformation, and report generation. Conducted exploratory Data analysis on large datasets to identify trends, patterns, and anomalies. Collaborated with cross-functional teams to gather requirements and provide Data-driven insights. Presented findings and recommendations to Senior management and Stakeholders to support decision-making processes. Assisted Data scientists, ETL Consultants, Data Architect/Engineer with ad hoc tasks, contributing to project success.

Previous Work Experience

  • M&C Saatchi World Services Agency, Sydney CBD, Sept 2023 - Present, NFPs Clients, Data Analysis and Reporting Project | AU Govt Clients | Waterfall & Scrum Development | Dbeaver SQL Editor | Various Media APIs | Google Looker Studio | Power Bi tool | Postgres SQL Querying | Python Querying VSC | Jira & Confluence
  • WooliesX, Sydney, Jul 2020 - Jan 2021, Woolworths, MMMSupers Projects, BWS Integration with MMM Supers, ATL Banners, Category Offers | Retail Industry | Waterfall Methodology & Agile/Scrum Development | Big Query | Redshift SQL | GCP | AWS | Jira & Confluence
  • MediaOcean, Gladesville, Sydney, Apr 2018 - Apr 2020, WPP, HAVAS, IPG, DAN, OMD et al. | ETL Testing in Data Warehousing & mScope Projects | Media Industry | Agile/Scrum Development | MS SQL Server | PLSQL Developer | SSIS Packages | JIRA | Confluence
  • Adactin Group Pty Ltd., Paramatta, Sydney, Dec 2017 - Mar 2018, Wrappli | Manual Testing | Agile/Scrum Development | Iteration-wise Test Plans | JIRA | Cross Browser Testing | Hybrid (Data Driven + Keyword Driven) framework using Selenium WebDriver | Automation Regression Test suites | NUnit
  • Cognizant Technology Solutions, Chennai, TN, India, Oct 2009 - Jan 2012, WellPoint, USA | DMS (Disbursement Management System) Health Insurance Domain | Manual Testing | Mainframes Technology | Agile/Scrum Development

Overall Skillsets

  • Data Reporting & Visualization & Dashboard Creation
  • Data Analysis & Interpretation
  • SQL Querying
  • Big Query & AWS RedShift SQL Querying
  • PLSQL/Oracle SQL Querying
  • DBeaver Postgres SQL Querying
  • MS SQL Server SQL Querying
  • Datawarehouse/ETL Testing
  • SSIS Packages & SQL Procs Understanding
  • Microsoft Excel for Data Analysis - Intermediate Level
  • Python for Data Analysis - Intermediate Level
  • Alteryx for Data Preparation, Cleaning and Blending
  • Gathering Insights
  • MicroStrategy BI tool Reporting
  • Google Looker Studio, Power BI & Tableau BI tool
  • Understanding of OOPs Programming - Python & C#
  • Cloud-based Software (AWS, Google Cloud Platform)
  • Data Extraction, Transformation, and Loading
  • Database Management (SQL,DB2,Oracle and JSON)
  • JIRA & Confluence
  • Stakeholder Engagement
  • Agile & SCRUM Methodologies
  • Good Communication and Collaborative Skills
  • Problem-Solving and Timeline Management
  • Detail-Oriented
  • Adaptability

References

Available upon request.

Timeline

Data Analyst

M&C Saatchi World Services Agency
09.2023 - Current

Data Quality & SQL Test Analyst

WooliesX
07.2020 - 01.2021

ETL/Data warehouse Test Analyst

MediaOcean
04.2018 - 04.2020

Quality Test Analyst - Internship

Adactin Group Pty Ltd.
12.2017 - 03.2018

Software Developer and Test Analyst

Cognizant Technology Solutions
10.2009 - 01.2012

Bachelor of Engineering (Electronics & Communications Engg) -

Mepco Schlenk Engineering College

Statement of Attainment in Emotional Intelligence -

TAFE NSW
SREEDEVI SELUKKA MADAN MOHAN