VIDYA CHIDANANDA
Plano,TX
Summary
Seasoned Business Analyst offer 6 years of Retail industry success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making.
Overview
7
7
years of professional experience
Work History
Data Analyst/Business Analyst
Claire's
03.2021 - Current
- Successfully used Agile Methodology for gathering business requirements from major Stakeholders and worked on adding User Stories to JIRA
- Worked closely with PMO and team leads for better strategizing teamwork and was involved actively in sprint and PI planning
- Working and managing cross-functional teams
- Performed Data analyzing, Data Cleansing and Data governance
- Involved in Data Mapping i.e., Source to Target Mapping, writing ingestion rules for middleware systems
- Involved in building mapping document from scratch and importing into database
- Involved in various activities of Unit testing and Regression testing
- Worked on Azure data Storage which involved in creating blob storage.
- Led cross-functional teams in analyzing and documenting business processes, identifying areas for improvement, and recommending solutions
- Collaborated with stakeholders to gather and define business requirements, translating them into functional specifications for system development
- Conducted thorough data analysis to derive actionable insights, enabling data-driven decision-making and process enhancements
- Facilitated workshops and interviews to elicit and document business requirements, user stories, use cases, and process flows.
- Developed and improved integrated reporting and analysis capabilities
- Provided evaluative judgment based on analysis of information in complicated and unique situations and contributed to formulation of standards and strategies for functional areas
- Integrated new products and entities into business structure
- Collaborated with stakeholders to define project objectives and criteria
- Provided technical support for troubleshooting analytics and reporting issues
- Generated standard and custom reports to provide insights into business performance
- Utilized data visualization techniques to present and explain complex data sets
- Implemented business intelligence solutions to increase operational efficiency
- Created data models to support decision-making processes
- Updated and developed scripts and queries to extract and analyze data from multiple sources
- Generated ad-hoc reports to evaluate specific business requirements
- Developed and maintained data warehouses and data marts to support business operations
Business Analyst (Project Analyst)
NXGTS
01.2020 - 03.2021
- Microsoft Visio was used to create various documents such as Use Cases and Activity Diagrams
- Used Microsoft project application to develop project plan
- Used SQL queries to pull information from various tables in database for data analysis.
- Collaborated with stakeholders to define project objectives and criteria
- Performed gap analysis to identify areas of improvement
- Interacted with internal customers to understand business needs and translate into requirements and project scope
- Conducted interviews with key business users to collect information on business processes and user requirements
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement
- Drafted reports on company financial metrics to assess successes and account for deficiencies
- Collaborated with teams in product line transition to streamline manufacturing footprint
- Analyzed open orders, backlog, and sales data to provide sales team with insights
- Assessed business requirements to forecast annual budgetary operational costs
- Delivered analysis of market, sales and consumer trend impact on long and short-term strategies
- Improved business direction by prioritizing customers and implementing changes based on collected feedback
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations
- Assisted with creating data cubes and OLAP models to improve data analysis
- Developed data mining algorithms to identify and classify patterns in data
- Developed and implemented data governance policies and procedures
- Developed and maintained data warehouses and data marts to support business operations
- Deployed predictive analytics models to forecast future trends
- Designed and developed data pipelines to acquire, clean and process data
- Updated and developed scripts and queries to extract and analyze data from multiple sources
Data Analyst
PepsiCo
08.2018 - 12.2019
- Gathered legacy system requirements by shadowing Customer Service Representatives (CSRs), Customer Relationship Representatives (CRRs), preparing questionnaires, to identify limitations in current system and GAPS in proposed system
- Created Functional requirement document (FSD), System Requirement Documents (SRD) and Test Cases and implemented test scripts
- Wrote complex, efficient, and accurate SQL queries utilizing massive data sets
- Write SQL queries, procedures to automate data modelling and cleaning
- Prepared logical data model in form of Business Context diagram to include various entities and attributes in order to facilitate design of Data model in form of ER Diagrams
- Studied current information structures and data models of current databases to better understand design of target data source
- Performed custom data conversions and developed custom software for risk management applications including vehicle accident and administrative tracking
- Performed all data field mappings
- Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against ORACLE database.
- Produced monthly reports using advanced Excel spreadsheet functions
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources
Business Analyst
Flipkart
06.2013 - 07.2015
- Business Analyst in developing scope and vision documents that defined primary goals, objectives and scope of project
- Facilitated SCRUM ceremonies Grooming, Sprint Planning, Daily Stand-Ups, Retrospectives, Review
- Developed data mining algorithms to identify and classify patterns in data
- Developed and maintained data warehouses and data marts to support business operations
- Optimized data access and storage to improve performance of analytics systems
- Updated and developed scripts and queries to extract and analyze data from multiple sources
- Created data models to support decision-making processes
- Generated standard and custom reports to provide insights into business performance
- Implemented business intelligence solutions to increase operational efficiency
- Analyzed data to identify root causes of problems and recommend corrective actions
- Collaborated with stakeholders to identify business needs and data sources
- Executed analysis of risks and identified risk mitigation strategies
- Generated business intelligence reports to inform strategic decision-making
Education
Bachelor of Science - Information Technology
Dr. AIT
Bangalore,IND07.2014
Master of Science - Electrical, Electronics And Communications Engineering
UMKC
Kansas City, MO12.2016
Skills
- TECHNICAL COMPETENCIES
- SDLC Methodologies
- Agile-Scrum, Hybrid
- Business Modelling & Designing Tool:
- VISIO, Jira
- Database
- SQL server, Oracle
- Reporting/BI
- Tableau , Microsoft Power BI
- Issue and Conflict Resolution
- Strategy Planning
- Risk Application and Mitigation
- Supply Chain Development and Management project Customer Quality driven
- MS Excel
- Extraction Transformation and Loading (ETL)
Timeline
Data Analyst/Business Analyst
Claire's
03.2021 - Current
Business Analyst (Project Analyst)
NXGTS
01.2020 - 03.2021
Data Analyst
PepsiCo
08.2018 - 12.2019
Business Analyst
Flipkart
06.2013 - 07.2015
Bachelor of Science - Information Technology
Dr. AIT
Master of Science - Electrical, Electronics And Communications Engineering
UMKC
Similar Profiles
Mary WillisMary Willis
Assistant Manager at Claire'sAssistant Manager at Claire's
Heather StanafordHeather Stanaford
Store Manager / Store Manager Trainer at Claire'sStore Manager / Store Manager Trainer at Claire's
Amanda HartmanAmanda Hartman
Director of Production, Jewelry at Claire'sDirector of Production, Jewelry at Claire's
Anna AmayaAnna Amaya
Store Manager/Training Manager/ Multi-store Manager at Claire'sStore Manager/Training Manager/ Multi-store Manager at Claire's
Andrew Cole-EmuzeAndrew Cole-Emuze
Network Manager at HanoverNetwork Manager at Hanover