Business Analyst Data

NIHARIKA KOLLOJU

BUSINESS ANALYST

****************@*****.*** +1-786-***-**** LinkedIn

PROFESSIONAL SUMMARY

Results driven Business Analyst and Data Analyst and with expertise in data analysis, business process improvement, and cross functional collaboration across enterprise, consulting, and research settings. Proficient in SQL, Excel, Tableau, Power BI, and Python for transforming data into actionable insights. Experienced in gathering business requirements, creating dashboards and reports, and supporting end to end project delivery in Agile environments. Hands on with cloud platforms including AWS (S3, Lambda, Athena, Redshift), Azure

(Synapse, Data Factory, DevOps), and GCP (BigQuery, Google Sheets), and skilled in querying enterprise databases such as Teradata, Oracle, MySQL, PostgreSQL, and Azure SQL. Strong communicator with a background in stakeholder engagement, data quality validation, statistical analysis using SPSS and R, and mentoring. Proven ability to optimize data workflows and deliver insights that support strategic business decisions.

TECHNICAL SKILLS

• Data Analysis & Visualization: SQL, Excel (PivotTables, VLOOKUP), Power BI, Tableau, Python (Pandas), R, PySpark

• Databases: Teradata, Azure SQL Database, AWS RDS, Oracle, MySQL, PostgreSQL

• Communication & Collaboration: Slack, Microsoft Teams, Zoom, Confluence, Stakeholder Management, Client Presentations, Cross-functional Coordination

• Project Management Tools & Methods: Jira, Trello, Asana, MS Project, Agile Frameworks, Scrum, Kanban

• Business & Technical Documentation: BRD, FRD, User Stories, UML Diagrams, BPMN Workflows, Lucidchart

• Technical Tools & Platforms: APIs, Postman, Salesforce, SAP, ERP Systems, SharePoint, Azure DevOps

• Agile & DevOps Practices: Agile Methodology, SAFe Framework, CI/CD Processes, Git (Version Control), Jenkins

• Data Cleaning & Transformation: Pandas, NumPy, OpenRefine, Alteryx, PySpark

• Cloud Platforms & Services: AWS (S3, Lambda, Athena, Redshift), Microsoft Azure (Synapse, Data Factory), Google Cloud Platform (BigQuery, Google Sheets)

• Soft Skills: Problem Solving, Critical Thinking, Time Management, Adaptability, Team Collaboration, Negotiation PROFESSIONAL EXPERIENCE

Micron Technologies Business Analyst Jan 2024 – Present

• Collaborated with product, operations, and engineering teams to gather and analyze business requirements, leading to more efficient processes and stronger alignment between product development and business needs.

• Created detailed business process models and workflows to identify pain points and improve operations, helping reduce delays and enhance team productivity.

• Used data analysis tools such as Excel, Tableau, and Power BI to uncover trends and insights that supported cost-saving initiatives in supply chain and operations.

• Utilized Azure Data Factory and Azure DevOps to coordinate data integration tasks and support analytics project delivery in Agile environments.

• Built financial models and prepared business case documents to support new project proposals, helping stakeholders evaluate feasibility and prioritize investments.

• Managed end-to-end delivery of multiple projects, coordinating across internal teams and external partners to ensure timely, on-budget execution.

• Delivered user training and support for new systems and tools, which helped reduce Helpdesk queries by over 20%, improving efficiency and user satisfaction.

• Worked with Teradata and Azure SQL to extract, analyze, and manage large volumes of structured data for business reporting and operational insights.

• Supported data migration efforts from on premises systems to Azure cloud, ensuring data consistency, accuracy, and minimal disruption during the transition.

• Played a key role in the migration process by assisting with data mapping, validating transformed datasets, and coordinating user acceptance testing to ensure a smooth go live.

• Collaborated with QA and development teams to define data validation criteria and perform UAT (User Acceptance Testing), ensuring that delivered solutions met business expectations and maintained data integrity.

• Automated recurring reports using Power BI and Excel macros, saving time on manual tasks and increasing reporting efficiency. Deloitte Business Analyst (Intern) Aug 2023 – Jan 2024

• Worked closely with cross-functional teams including development, QA, and business stakeholders to deliver software solutions that aligned with business objectives and maintained high delivery accuracy.

• Used SQL and Excel to analyze datasets from multiple systems, uncovering insights that supported process improvements and helped reduce operational costs.

• Worked with Azure Synapse Analytics to analyze large datasets and generate insights for business reporting, improving data accessibility and reducing report turnaround time by 25%.

• Conducted stakeholder interviews and workshops with senior leadership to gather business needs, resulting in clear and actionable business requirement documents (BRDs).

• Created dashboards and reports in Power BI and Excel, allowing stakeholders to monitor KPIs and track progress toward goals by contributing to a 30% faster decision-making process.

• Supported communication between business and technical teams, improving project delivery timelines by streamlining handoffs and reducing misunderstandings.

• Queried and analyzed datasets from Azure SQL and Oracle databases to support business reporting, ensuring data accuracy and alignment with stakeholder requirements

• Contributed to data migration efforts by assisting with pre and post migration validation, helping identify data discrepancies early and maintain data quality across systems

• Participated in the development of data lineage and mapping documentation, enabling smoother communication between business analysts and data engineering teams during system transitions

Florida International University Research Assistant Jan 2022 - Aug 2023

• Managed and analyzed data from surveys and interviews using SPSS and R, creating reports and visualizations that supported the publication of academic research.

• Collaborated with a multidisciplinary research team to design and implement experiments, ensuring compliance with research protocols and improving project efficiency.

• Led meetings with faculty and graduate students to present findings and provide data-driven insights, influencing the direction of ongoing studies.

• Mentored and trained undergraduate research assistants on data collection, analysis, and academic writing, contributing to their involvement in two published papers and improving team productivity by 20%.

• Conducted literature reviews using tools like PubMed, JSTOR, and Google Scholar to identify relevant studies and enhance the quality of research methodologies.

• Used Google Cloud Platform (GCP) tools such as BigQuery and Google Sheets for storing, processing, and sharing large-scale research data across collaborators in real time.

• Worked with structured datasets stored in MySQL and PostgreSQL databases to retrieve and analyze research data, supporting hypothesis testing and academic reporting.

Humana Junior Data Analyst Aug 2020 – Dec 2021

• Collaborated with cross-functional teams to understand data requirements and deliver accurate, actionable insights that supported key business initiatives.

• Analyzed existing workflows and operational data to identify inefficiencies, contributing to a 10% reduction in processing times through data-driven process improvements.

• Managed data workflows using AWS services such as S3 and Lambda and utilized Tableau and Excel to transform raw data into visual reports for stakeholders.

• Developed and delivered monthly reports for leadership, highlighting key performance indicators (KPIs) and providing insights to inform strategic decisions.

• Wrote and optimized SQL queries to extract, clean, and analyze large datasets from internal systems, ensuring timely and accurate reporting for project tracking.

• Created interactive Tableau dashboards to enhance real-time visibility into business performance, resulting in a 25% improvement in decision-making speed across teams.

• Queried and analyzed large datasets stored in Amazon RDS (MySQL and PostgreSQL) and Oracle databases to support operational reporting and performance analysis

• Used Amazon Athena to run serverless SQL queries on structured and semi-structured data stored in S3, enabling faster insights without additional infrastructure

• Worked alongside data engineers to validate data quality and optimize query performance in Amazon Redshift and Oracle environments, ensuring consistency across reporting layers

EDUCATION

Master of Science in Computer Science

Florida International University Miami, USA GPA: 3.5/4.0 Graduation Date: Dec 2023 Relevant Coursework: Data Analytics, Business Intelligence, Machine Learning, Database Management Systems, Big Data Analytics, Data Visualization, Software Engineering

Bachelor of Engineering in Computer Science

Veltech Rr & Dr. Sr Institute of Science and Technology Chennai, India GPA: 7.7/10 Graduation Date: May 2021 Relevant Coursework: Data Structures and Algorithms, Database Systems, Software Project Management, Probability and Statistics, Operating Systems, Web Technologies

PROJECTS

Customer Churn Analysis and Retention Strategy

• Analyzed customer behavior to identify churn patterns and built dashboards highlighting at-risk segments. Provided actionable recommendations to reduce churn and improve customer retention strategies.

• Tech: Python, Pandas, NumPy, Scikit-learn, Power BI, Excel, Git Stock Market Prediction with Neural Networks

• Applied neural networks and predictive modeling techniques to forecast stock prices. Cleaned and visualized time-series data, and interpreted model outputs to guide investment strategies.

• Tech: Python, Pandas, NumPy, Scikit-learn, Keras, Matplotlib Helping-Hands Web Platform

• Collaborated with a cross-functional team to develop a web platform connecting volunteers with individuals in need. Led requirement gathering and contributed to data modeling and user experience improvements.

• Tech: Python, Django, JavaScript, Node.js, MongoDB, HTML5, CSS3, Git Cab Fare Prediction System

• Built a data-driven fare prediction model using historical ride data. Designed a user-friendly interface and implemented machine learning algorithms to optimize fare accuracy for users and drivers.

• Tech: Python, Pandas, Scikit-learn, Django, MySQL, HTML, CSS, JavaScript Transactional Data Pipeline and Dashboard Automation

• Built an end-to-end data pipeline using SQL and PySpark to process large volumes of transactional data, and automated dashboard creation in Power BI to monitor business KPIs and trends in real time.

• Tech: SQL, PySpark, Power BI, Python, Azure Data Lake, Git

Contact this candidate