Data Analyst Analysis
Resume:
SAI SARAYU VADA
*************@*****.***
Around 4 years of experience in data analysis and business analysis. Worked in various enterprise applications in different business domains. Quick learner with strong work ethic. Great team player with excellent communication skills.
EXPERIENCE
Data Analyst/Workforce Coordinator, CCRI (Jan 2023 – ) Worked on various projects related to report building, data validation and data cleansing for various departments in CCRI. Projects accomplished…
• Worked on workforce registration analysis as part of marketing reports.
• Data analysis and data cleanup related to class grades report in the Augusoft tool used across CCRI.
• Composed active and archived student list from Handshake data source based on given criteria. Did a lot of data validation as part of this effort using various Excel features.
• Modified Non-degree credential report based on given requirements.
• Created a complex report called Overall Enrollment report by collecting data from Argos using various tools in excel, including pivot tables.
• Created visualizations like bar charts, pie charts in Excel for demographics management report.
• I also handle many day-to-day activities as part of my job. Technical details:
• Used Excel for data analysis, data manipulation, and report generation using complex logic.
• Worked on Augusoft, a SaaS solution specializing in enrollment solutions.
• Extensively worked in Banner, an ERP solution for higher education institutions.
• Expert in Argos reporting tool.
Data Analyst, Nterprisers (Apr 2024 – Sept 2024)
Worked on various initiatives including data scrubbing, cleanup, analysis, data transformation and quality assurance in this startup. Following are the details.
• Data scraping: Gathering, sorting and processing data related to RI based manufacturers. Also did peer review and QA to ensure data quality.
• ETL: Using PostgreSQL and Python, implemented ETL jobs on various tables handling multiple scenarios.
• Data modeling, normalization & optimization: Did analysis on key tables and came up with normalized and optimized solutions for overall maintainability of our flagship web application. Worked on data cleansing and deduping.
• QA: Did manual testing on our primary web application and reported many issues. Helped in stabilizing the web application.
• BA: Created data automation plan for future automation effort. Identified and listed all major tasks.
• Data analysis: Worked on IBIS stats to compute revenue per employee ratio to determine quality confidence of various categories of manufacturing companies we processed. Technical details:
• Mainly worked on the technologies PostgreSQL, Python and MS Excel. Data Analyst, Interpak (Sept 2021 – Jan 2022)
Implemented multiple challenging enhancements related to financial data model using various data analysis tools. Projects accomplished…
• P&L Pvt Comp: Implemented drill-through and added sub-total in Financial Model.
• Inventory P&L: Current month/year amount, Previous month/year amount, difference &
% difference. Also added provision to pick any two months. Implemented using both Measures & Calculation groups.
• P&L Monthly Report using Calculation Groups in Financial Model.
• Waterfall chart for financial data model: Letting the user pick any month and generate waterfall chart between the previous and current months for Trade Sales. Technical details:
• Developed Power BI reports and effective dashboards after gathering and translating end user requirements.
• Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX Query.
• Experience in creating different custom visualizations like Dough nut chart, waterfall chart, table, Matrix table and bar chart etc.
• Published/shared the reports by creating a content pack in app.powerbi.com/sharing the pbix file.
• Imported data from multiple data sources into Power BI Desktop from various data bases like SQL Server, Excel, and CSV etc.
• Creating Formatting, Advanced Formatting in tooltip labels like descriptive tooltips, and conditional formatting.
Business Analyst, Rhode Island State Government Internship Program (Jan 2021 – Apr 2021)
Worked as a Business Analyst for a mobile app called Voice of RI. Played major role in requirement gathering, story refinements and implementing PoC (Proof of Concept)
• The Voice of RI is a prototype of Rhode Island Government website-based app where any resident will be up to date with any bills or laws that are being implemented by the state.
• By following specific bills users can keep up to date with all bills or laws that the state is moving forward with.
EDUCATION
Community College of Rhode Island (CCRI) Warwick, RI Certificate in Computer Studies and Information Processing 2019 GPA 3.8/4.0
Awards: Magna cum laude
Jawaharlal Nehru Technological University Hyderabad, India Bachelor of Technology in Electrical and Electronic Engineering TECHNICAL SKILLS
• Programming Languages: JavaScript, Python, C#, and .Net Framework
• Web Design: CSS and Dreamweaver
• Database: MS SQL and MS Access
• Technologies: Power BI, DAX, Data visualization, Power Query, Excel
• Tools: Microsoft 365, Visual Studio, Power BI, Tabular Editor 3.0, SSRS, Augusoft, Report Builder, Argos, Banner
Contact this candidate