VAISHNAVI ANDOJU
****************@*****.*** Mobile: +1(216) – 412-0454 Linked In GitHub Cleveland, Ohio SUMMARY PROFESSIONAL:
Highly analytical Data Analyst with around 4 years of experience in data extraction, transformation, and modeling to drive informed business decisions. Expert at designing and automating ETL pipelines using SQL and Python, and delivering intuitive dashboards and reports in Power BI and Tableau. Adept at applying statistical techniques, A/B testing, and predictive analytics to uncover trends and optimize performance. Strong communicator with a talent for translating complex data into clear, actionable insights that improve operational efficiency. Holds a master’s in Information Systems and a history of collaborating cross-functionally to implement data-driven solutions. Education
Cleveland State University, OH, US May 2023 - May 2025 Master of Science, Information Systems
Vignan Institute of Technology and Science, India Aug 2018 - Aug 2022 Bachelor of Science, Electronics, Communication, and Engineering PROFESSIONAL EXPERIENCE:
NORTHERN TRUST BANK Jan 2024 - Present
DATA ANALYST Chicago,IIlinois
Built end-to-end ETL pipelines using SQL, Python, and Airflow across AWS and GCP, ensuring data quality, lineage, and automation.
Designed Power BI and Tableau dashboards, performed EDA, A/B testing, forecasting, and prepared data for ML pipelines.
Performed EDA, A/B testing, statistical modeling, and feature engineering to drive product insights and machine learning readiness.
Optimized performance in MySQL, PostgreSQL, and Big Query with advanced SQL, while supporting real-time reporting and governance.
Mentored analysts, led knowledge-sharing sessions, and contributed to forecasting, compliance, and cloud architecture improvements. FINASTRA SOFTWARE SOLUTIONS Jul 2021 - Apr 2023
DATA ANALYST Bangalore, India
Collaborated with legal, finance, marketing, and cybersecurity teams to ensure data compliance, governance, and strategic alignment.
Built anomaly detection systems, customer segmentation models, and forecasting tools using Python, SQL, and real-time pipelines.
Integrated geospatial and multi-channel journey data to support location-based decisions and engagement optimization.
Managed cloud data warehouse migrations, benchmarked performance, and ensured rollback safety and data integrity.
Developed reusable SQL/Python libraries, Airflow DAG templates, and self-service analytics frameworks for business users.
Led dashboard usability testing, implemented feedback, and enforced ML data annotation standards for model consistency PROJECTS :
Food Truck Sales Performance Dashboard Jan 2025
• Developing a Food Truck Sales Performance Dashboard involves various tools and technologies for data collection, processing, visualization, and reporting.
• For visualization, tools like Tableau, Power BI, and create interactive dashboards, while Python libraries offer customized visualizations.
• The final dashboard is designed with interactive charts, filters, and KPIs to provide actionable insights, helping food truck owners make data-driven decisions to optimize sales and operations.
Movie Database Management System Dec 2024
•Developing a Movie Database Management System (MDBMS) involves using MySQL, MongoDB, or SQLite for data storage.
•Performance is enhanced, and deployment is done on cloud servers for accessibility and scalability. Classification matrix (AI Project) Dec 2024
• Excel serves as the primary tool for data entry, processing, and analysis, utilizing features like Pivot Tables, Conditional Formatting, and Data Validation, to structure and classify titles effectively.
• The project likely follows a structured approach, including data collection, preprocessing, classification logic implementation, and visualization, enabling efficient title categorization and analysis. TECHNICAL SKILLS:
Languages & Tools: SQL, Python (Pandas, NumPy), Py Spark, Apache Spark Visualization & BI: Power BI, Tableau, Excel (Dashboards, Pivot Tables) Cloud Platforms: GCP (Big Query, GCS, Data Studio), AWS (S3, Redshift, Athena) Data Modeling & Analysis: Data Cleaning, Transformation, Trend Analysis, A/B Testing Collaboration & Governance: Git, GitHub, Jira, Stakeholder Reporting, Data Quality Checks Certifications:
Microsoft Certified: Power BI Data Analyst Associate (PL-300) 6/20/2025