Niharika Buyyani

E-mail: ad1g8g@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/niharika-buyyani-8023a9151/ Mobile: 475-***-****

SUMMARY

Results-driven Business analyst with 5+ years of experience in analyzing complex business processes and translating requirements into actionable insights. Skilled in conducting thorough data analysis, developing reports, and generating meaningful recommendations to drive informed decision-making. Proficient in using a variety of tools, including SQL, Excel, and data visualization platforms such as Tableau.Demonstrated ability to collaborate effectively with stakeholders from diverse backgrounds and facilitate cross-functional teamwork. Adept at identifying opportunities for process improvement, optimizing operational efficiency, and enhancing business performance.

Strong communication and presentation skills enable effective communication of findings and recommendations to both technical and non-technical audiences. Committed to delivering high-quality results and contributing to the success of business initiatives.

TECHNICAL SKILLS

Programming Languages: SQL, Python (NumPy, Pandas, sci kit-learn, Matplotlib, TensorFlow), R programming. Statistics/Machine Learning: Regression, A/B Testing, Forecasting, Neural Networks, Time Series, Decision Tree, Clustering. Tools: Power BI, Tableau, Looker Studio, SAP, Microsoft office, Qlik, Alteryx.

Databases: MySQL, MariaDB, Microsoft SQL Server, Oracle 11g, Agile methadologies.

Cloud & Operating System: Azure, Google Cloud Platform, Databricks, Snowflake, MS Windows, MS excel, MS powerpoint,Mac OS.

WORK EXPERIENCE

Business Analyst – IRIS – New haven, CT January 2023-May 2023

RStudio Azure SQL Python Power BI SAP .Net Databricks Jira Business Forecasting EDA Agile

●Collaborated with stakeholders to gather and document business requirements, ensuring clear understanding of project objectives and scope.

●Created process maps and flowcharts to visualize current and proposed workflows, aiding in the identification of inefficiencies and opportunities for optimization.

●Performed ETL and blending/wrangling on a variety of data formats from multiple disparate sources using complex SQL queries, R and Azure Databricks to enable stakeholders to gain business insights from data.

●Conducted data analysis to identify trends, patterns, and insights, providing valuable information for decision-making and process improvement.

●Used R programming for data analysis and implementing forecasting models on large volumes of machine performance data to track customer power consumption patterns and used data visualization tools to generate reports (Power BI).

● Conducted thorough market research to identify industry trends, competitive landscape, and potential opportunities for business growth.

●Experienced in designing intuitive dashboards, selecting appropriate visuals, and effectively presenting insights to stakeholders.

●Prepared comprehensive documentation, including business requirement documents, use cases, and user stories, facilitating effective communication among cross-functional teams.

●Adept at connecting to various data sources, transforming and shaping data and creating relationships between tables.

●Experienced in Power Bi administration tasks, such as managing workspaces, security roles and sharing options to collaborate effectively within your organization.

●Facilitated and led workshops with cross-functional teams to define and prioritize data- driven projects.

●Designed and Developed R-Shiny app for fault detection in customers machine and generate condition reports.

●Analyzing business requirements/queries and development of metrics/KPIs to report business state and performance.

●Develop SQL queries to research, analyze, and troubleshoot data via Microsoft SQL Server with data storage on Azure.

●Work on projects pertaining to in-depth analysis – trend analysis, historical data analysis and predictive analysis.

●Based on analysis, present the findings to key stakeholders enhancing their strategies for business decisions.

●Evaluate Data Operations for inefficiencies and identify areas to create, automate, and develop processes for the team.

Business Analyst– Graduate Assistant – University of New Haven – West Haven August 2022- December 2022

MariaDB Python Tableau Excel R Programming Data Mining Agile A/B Testing EDA Statistics

●Developed SQL queries and optimized database schema, including normalization, in Microsoft SQL Server.

●Configured RStudio Connect on the University infrastructure to enable students to share and showcase their personal projects.

●Participated in data extraction processes for business purposes and conducted data analysis to create easily understandable reports for a diverse range of audiences.

●Mentored students and instructed courses on constructing predictive models, business forecasting, and conducting exploratory data analysis (EDA).

●Utilized statistical tools to identify, analyze, and interpret data trends, enabling the diagnosis and prediction of business outcomes

●Improved the existing database design, including stored procedures, views, and performance optimizations, to enhance overall system efficiency.

●Participated in UAT activities, working closely with end-users to validate that solutions meet business requirements and are user-friendly.

●Assisted in data validation and quality assurance processes to ensure accuracy and integrity of data used for analysis and decision-making.

●Led weekly lab sessions, providing guidance to a large group of over 200 students on research and analytical techniques.

●Assisted the team in leveraging MS Excel to generate visually impactful graphs for data visualization, supporting management in decision-making processes.

Business Analyzing Morris Garages – Hyderabad July 2020 - June 2021

MySQL Python Tableau Excel R Programming Data Mining Business Forecasting

• Utilized Python to analyze admission request data, categorize tickets by department, and generate reports on the number and types of tickets.

• Employed libraries such as NumPy and Pandas to clean the data effectively.

• Built a Machine Learning model to forecast customer propensity and identify potential long-term clients.

• Leveraged Tableau Prep to clean, transform, and model data, ensuring improved accuracy in metric calculations.

• Applied SQL programming and query optimization techniques to support and enhance data models and sources in Google Data Studio.

• Identified a significant opportunity for process refinement by automating report generation, consolidating data, and improving data gathering methods, resulting in a 30% reduction in campaign reporting preparation time.

• Conducted data mining to discover trends and correlations, generating insights to enhance business decision-making and contributing to a 15% increase in total revenue, equivalent to $2 million annually.

• Developed operational strategies and enhanced the business model by utilizing SQL (MySQL) to generate data reports.

• Created operational dashboards in Tableau to monitor student progress and facilitate personalized coursework development.

• Collaborated with cross-functional marketing and engineering teams to implement A/B testing using R and Python.

• Identified and reported key performance indicators to the social media team, marketing managers, and executives for analysis and decision-making purposes.

Business Analysing cell – Malla reddy engineering college for women – Hyderabad August 2018 - June 2020

MySQL Python Tableau Excel R Programming Data Studio Statistics Google Analytics 360

• Collaborated with product managers and developed key operational strategies for business intelligence products and improved data reporting and analyzing quality using complex SQL queries.

Translated team specific business logic into comprehensive business documents.

• Designed schema and data flow for complex projects spanning disparate data platforms and operations (targeting, personalization, analysis & reporting) using SQL, Google Analytics, Data Studio, Tableau, and local data warehouse.

• Conducted financial analysis, forecasting to identify and assess risk associated with capital expenditure.

• SQL development and enhancements for performance optimizations using Indexes, Normalization and Partitioning.

• Worked cross functionally with Sales, Marketing and Finance teams to monitor KPI data and measurements to support budgeting.

• Involved in improvising firm-wide processes by enhancing current flows and devising new process flow diagrams.

• Delivered presentation of analysis results and provided recommendations to software and product development teams.

• Performed data analysis and design reports by developing solutions that yield relevant information in a user-friendly format by collecting, analyzing, and leveraging data via Tableau, advanced Excel.

EDUCATIONAL QUALIFICATIONS

Master of Science in Business Analytics Global Supply chain management University of New Haven

Relevant modules: Business Analytics, Business Intelligence, Database Systems, Data Mining, Tableau, Machine Learning, Supply chain, statistics, Forecasting Time-series.

PROJECTS

Gold Sql Linear Regression R studio Sept 2022

• A linear regression model was created, trained, and benchmarked to forecast the cost of a home in Boston.

• Developed a front-end application and published it on the Heroku cloud platform.

• On the test set, the model was able to

achieve a mean squared error of 21.51, demonstrating its ability to produce reliable predictions.

Sentiment Analysis R Programming MySQL Power BI April 2022

●Conducted analysis on Amazon Alexa product review by scraping data from web to understand the customer intention about the product which would assist in taking business decisions.

●Extracted and cleaned user comments to fetch meaningful phrases to gauge polarity of sentiments.

●Power BI integration with MySQL to depict users’ will to purchase and till what extent using interactive views and drill downs.

Database for Hershey’s chocolate sales SQL MariaDB ETL Tableau RStudio Statistics Dec 2021

●Designed, implemented, and developed a SQL database engine using data modelling principles using MariaDB and RStudio. Used complex SQL queries to generate insights from data.

●Data Transformation and cleaning (ETL) of complex data sets using R programming to persist relational data in MariaDB.

●Prepared reports and rich graphs & charts for visualization using Tableau for statistical analysis.

Online Market Demo Aug 2021

●Developed an intuitive webstore i.e., ordering system with product browsing and ordering.

●Customized report generation / purchase history for customers and management.

●Used GIS using Google API for Vendor tracking and implemented transaction management, concurrency control using locks for parallel orders.

Contact this candidate