Home

Raveena - Data Analyst, BI Analyst

[email protected]

Location: Mclean, Virginia, USA

Relocation:

Visa:

Raveena PROFESSIONAL EXPERIENCE Transurban Group, Mclean, Virginia| Data Engineer/Analyst Jul 2023 Present Provided insights on strategic initiatives, focusing on key metrics like Customer Acquisition Cost (CAC), LTV, and Revenue Growth, which drove a 15% increase in sales efficiency Collaborated cross-functionally with Sales and Marketing analytics teams to ensure data-driven financial strategies align with business goals Used Apache Kafka and Integrated data from external source like S3,ORC,Parquet, and Text Files into Snowflake Extracted a desired subset of data, transforming and converting data, creating mappings from source tables to destination tables, loading the result data into Cloud (AWS S3/Snowflake) Written complex SQL queries to perform ETL data process ensuring compatibility with all tables Built infrastructure using Python for data extraction and preprocessing in Visual studio, managed GitHub repositories, and migrated pipelines with data loading via AWS and SQL Automated and maintained reporting data pipelines through Airflow, enhancing reporting efficiency by 20% through automated, timely data availability Developed source file automation framework in Airflow which will send auto email to source team about missing file and the pipeline will resume automatically once file arrived reducing 20% operational cost due to manual intervention Managed 50+ critical defects in JIRA, reducing resolution time by 30% through agile collaboration Developed a Tableau-based self-service reporting system, optimizing toll revenue and transaction volumes, saving $5 million per quarter across 10+ vendors Deloitte, Hyderabad, India | Data Engineer- Sales Analytics Aug 2020 Aug 2022 Automated Budget spending report on monthly and YTD (Year to Day) basis using Tableau Ran ad-hoc analysis, analyzed existing schema, and designed new star schemas and data models for specific cases Interacted with the Business Partners (Marketing, Finance & Product team) to understand the business of the application, gather requirements to define key metrics and provide data for analysis Designed, applied, and maintained SQL, Python, and PySpark solutions and scripts to ingest, clean, transform, connect, store, and expose data for dozens of users across departments Member of a team focused on developing an enterprise data warehouse (EDW), aggregating databases and centralizing information from five subsidiary companies in AWS Developed and maintained methods to match source and target data through communication with stakeholders, database querying, analysis of raw files, and scripting Ingested CRM, billing, and network logs from S3 to Snowflake and built Tableau dashboards for customer retention analysis, tracking KPIs like Churn Rate, Customer Lifetime Value (CLV), and Complaint Resolution Time Developed and documented technical best practices for ETL-related activities including data movement, data governance, data aggregation, data quality, and data cleansing Conducted market research using regression analysis (scikit-learn) to identify consumer preferences and pricing gaps, resulting in 20% increase in market share and 15% quarterly revenue Demonstrated proficiency in Excel (VBA, pivot tables, array functions, VLOOKUP, power pivots) for data analysis Performed user lifecycle analysis in Tableau to identify key retention drivers, applying A/B testing to refine engagement strategies and increasing monthly active users by 5% SKILLS AND CERTIFICATIONS Programming Languages: Python, PySpark, R, SQL, Linux, Shell, MS Excel Tools: Looker, Tableau, Power BI, Quicksight, Google Analytics, Alteryx, Snowflake, Postgres, SQL Server, Oracle, Airflow, Informatica, UiPath, Splunk, GitHub, VS Code, Salesforce , Microsoft Office Suite Analytical Techniques: T-test, Hypothesis Testing, Linear Regression, Tree based models, K-Means Clustering, KNN, Cross- Validation, Time Series Forecasting, Bayesian Analysis, A/B Testing EDUCATION University of Cincinnati, Carl H. Lindner College of Business, Cincinnati, OH April 2024 Master of Science, Information Systems | Concentration in Data Analytics GPA: 3.9 Jawaharlal Nehru Technological University, Hyderabad, India April 2020 Bachelor of Technology, Computer Science and Engineering GPA: 7.2 Keywords: business intelligence sthree active directory rlang microsoft Ohio