Prerana Rout

Prerana Rout - |- LinkedIn | GitHub | Power BI Portfolio INTRODUCTION: An Experienced Software Engineer (Data) with 1.6 years of hands-on experience in designing & developing complexcode, now seeking to pivot into a data analyst role. possesses a solid foundation in programming, problem-solving, data manipulation, and is eager to apply these skills to extract valuable insights from data. EDUCATION: B.E., Electronics and Communications Engineering Dayananda Sagar College of Engineering, Bengaluru, Karnataka, India Jul’2022 EXPERIENCE: Software Engineer, Persistent Systems Ltd, Bengaluru Feb’2022 – Aug’2023 ● Developed reusable .Net components and implemented respective MS Test unit test cases for streamlined application and improved the Code Coverage by 40%. ● Designed a dynamic and browser-compatible UI aligned with business requirements. ● Collaborated with Data Team to help design data pipelines for ETL from various sources to data warehouse. Data Analyst Intern, AtliQ Technologies Aug’2023 – Dec’2023 ● Worked with senior data analysts & engineers to analyze and interpret large datasets using python and MS-Excel. ● Implemented ETL on data from various sources and developed interactive dashboards & reports using power bi & Tableau. ● Conducted quality assurance checks on data to ensure accuracy and completeness. Market Research Analyst, Techwire Studio (Start Up- Self Employed) Dec’2023 – Present ● Spearheaded market research initiatives for my Web development Company including market research, data collection, analysis and interpretation, using power bi resulting in great head start for the company. ● Implemented targeted marketing campaigns by utilizing various marketing & analytical tools like Mailchimp, Google Analytics to track performance and optimize efforts. ● Collaborated with cross functional teams to integrate research findings into strategies, resulting in improved ROI and customer Engagement. SKILLS Analytical Tools: ● Power BI ● Tableau ● Advanced Excel Programming Languages: ● SQL ● Python ● C++ & .net Database: MySQL PROJECT Experience: Data Professional Survey Analysis - Comparison Report [Power BI | SQL] GitHub Repo | Live Dashboard Nov’2023 ● Created a dashboard in Power BI, for analyzing the survey results done for data professionals. ● Provided insights into 3 major aspects of KPI (Country, Average salary by job title, average age) ● This report will facilitate them to spot potential data trend and allow them to take significant changes in order to tally with the market. Bike Sales data analysis - [Excel | pivot-table ] GitHub Repo | Live Dashboard Oct’2023 ● Designed a dashboard in Excel, for analyzing the sales based on average income of customers in a particular region & occupation. ● Provided insights on overall sales of bikes in various countries and sales based on customer’s commute distance. ● The analysis can provide a basis for developing new strategies to improve the marketing & overall sales by 15%. Hospitality Analysis - Hotel Chain Business [Python | Pandas | Excel] GitHub Repo Sep’2023 ● Atliq Grands noticed a loss in their market share and revenue over a few months. To diagnose the cause of this loss, they needed a way to analyze this. I streamlined an analysis report in jupyter(Python) using 3 months of data. ● With this analysis, the Revenue team of Atliq Grands was able to gain insights into their revenue trend. This could help in regaining their revenue and market share by 20% in the next month. Document Generation System – [MS Visual Studio| Python] July’2023 ● Streamlined Reusable UI & .net components and wrote MS Test unit test cases for application development. ● Improved overall code coverage for the .net components via unit testing by 40% CERTIFICATIONS / AWARDS: ● High-Five Award (Persistent Systems) ● Microsoft Certified Fundamentals of Azure (AZ-900) ● Codebasics certified Excel, SQL, python and Power BI OTHER ACTIVITIES: ● Hacker Rank SQL 5 star Holder