Business Analyst Power Bi

Datvi Panchal

Business Analyst

Indiana, USA 551-***-**** *****************@*****.*** LinkedIn SUMMARY

Business Analyst with 4 years of experience in bridging the gap between business needs and technical solutions. Proficient in eliciting, documenting, and analyzing business requirements using tools like JIRA, Confluence, and Microsoft Visio, ensuring alignment with business goals and stakeholder expectations.

Skilled in data manipulation and visualization using SQL, Excel (pivot tables, macros), and tools like Power BI and Tableau to generate actionable insights and optimize business performance.

Expertise in analyzing current business processes and redesigning workflows using methodologies such as BPMN, Lean Six Sigma, and frameworks like Agile Scrum to enhance operational efficiency.

Adept at facilitating cross-functional collaboration, conducting stakeholder interviews, leading workshops, and preparing clear documentation like BRDs, FRDs, and user stories.

Experienced in bridging business and technical teams with knowledge of ERP systems (e.g., SAP, Oracle), CRM platforms (e.g., Salesforce), APIs, and system integration, ensuring seamless implementation of technical solutions. SKILLS

Methodology: SDLC, Agile, Waterfall, Kanban

Programming Languages: Python, R

Database Management : SQL, MS XS, MS Excel, Requirements Traceability Matrix (RTM) Documentations: FRD, BRD, SRS, User Guide, User Stories, Use cases Project Management Tools: MS Project, MS Excel, MS SharePoint, Asana, Trello, Rally Visualization Tools: Tableau, Power BI,

Business Analysis: Cost/benefit Analysis, Impact Analysis, GAP Analysis, Risk Analysis, SWOT Analysis Tracking Tools: Jira, HP Quality Center, Rational ClearQuest, RTM Cloud Computing Platforms: AWS, Azure

ERP Planning & CRM: SAP, MS Dynamics Nav, Salesforce, HubSpot Technical Skills: KPI, UAT, Test Plans, Alteryx, Requirement gathering, Google Analytics, Data Analysis, MS Visio, JAD, MS 360, Web XP, Software development & testing, Data Modelling, Database Knowledge, Business Intelligence (BI) Tools, Process Mapping, User Experience (UX) Understanding, Quality Assurance (QA) Knowledge, Prototyping

Soft Skills: Time management, Leadership, Management, Problem-solving, Negotiation, Decision-Making, Documentation, and Presentation, Verbal communication, Sprint Planning EXPERIENCE

Business Analyst Elevance Health, MD Oct 2023-Present

Led a process improvement initiative to optimize workforce administration and staff scheduling systems, achieving a 20% reduction in scheduling errors and cutting overtime costs by 15% through automation and data-driven scheduling with Tableau and Python.

Collaborated with cross-functional teams to elicit, analyze, and document business requirements, translating them into actionable functional specifications and system designs, utilizing SQL and Power BI for data extraction and visualization.

Designed and executed User Acceptance Testing (UAT) plans, identifying and addressing 95% of system issues pre- deployment, leveraging tools such as JIRA and Excel for defect tracking and reporting.

Conducted business process analysis using tools like Visio to re-engineer workflows, resulting in a 30% increase in task turnaround time and improved interdepartmental communication.

Oversaw configuration and optimization of HR, payroll, and benefits systems, reducing payroll processing time by 40% and improving data accuracy by 15%, leveraging SQL for data validation and ETL processes with SSIS.

Authored and maintained comprehensive documentation, including FAQs and support guides, leading to a 25% reduction in support tickets, while enabling user empowerment through Power Automate-driven self-service solutions.

Performed data analysis using Python (Pandas, NumPy) and Power BI to identify inefficiencies and bottlenecks, driving a 20% improvement in productivity and service delivery.

Acted as a critical link between IT teams and business units, ensuring effective communication, issue resolution, and on-time project delivery, resulting in 90% stakeholder satisfaction measured through feedback surveys and Excel-based reporting. Business Analyst Infosys, India Jun 2020-Aug 2022

Analyzed and understood business needs and goals related to enhancing the functionality and user experience of an e- commerce platform, ensuring alignment with broader business objectives.

Developed and implemented data-driven e-commerce strategies to optimize website performance, resulting in a 15% increase in online sales and improved user engagement metrics.

Collaborated with cross-functional teams including IT, marketing, and product management to ensure e-commerce initiatives aligned with overall business objectives, improving workflow efficiency by 20%.

Conducted extensive consumer behaviour and market trend research to identify key opportunities for product enhancements and marketing campaigns, which led to a 12% improvement in conversion rates.

Recommended technology solutions such as integrating personalized AI-based recommendations and payment gateway improvements to enhance customer experience and streamline operations.

Performed regular A/B testing and analytics on key e-commerce site features, identifying performance bottlenecks and implementing UX/UI improvements, which boosted site load time by 30%.

Monitored and evaluated the effectiveness of e-commerce strategies through KPIs and dashboards, making necessary adjustments to optimize platform performance and customer satisfaction.

Created detailed reports and presentations on e-commerce performance, consumer behaviour insights, and actionable recommendations, which were presented to stakeholders for decision-making.

Worked closely with IT and marketing teams to ensure the seamless integration of new features such as multi-channel marketing campaigns and mobile-optimized pages, improving mobile traffic by 25%.

Ensured compliance with e-commerce regulations and best practices, including data privacy laws (GDPR, CCPA), during the development and deployment of new features, maintaining a secure and compliant platform. Artificial intelligence intern Ultria Software, India Jan 2020-May 2020

Designed and implemented AI models for text classification and image analysis, improving image classification accuracy by 85%.

Developed a Handwritten Text Recognition System using TensorFlow, streamlining the process of digitizing paper-based contracts.

Assisted in aligning AI solutions with business goals and collaborated on promotional materials to support product marketing initiatives.

EDUCATION

Master of Science in Information Systems

– DePaul University, Chicago

Bachelor of Technology in Computer Science

– Pandit Deendayal Energy University, Gujarat, India PROJECTS

Business Intelligence Project

• Developed an interactive Tableau data sheet for Chicago crime rates to inform decision-making with comprehensive crime category and related statistics.

SAP Enterprise System

• Built an ERP SAP Client Integrated business solution for a company. Analyzed data and managed renewable energy source website.

• A Scrum board was established, and management tactics were implemented to tackle group concerns. CETIFICATIONS

• Project management principles and practices: initiating and planning projects (Coursera)

• Strategic leadership and management: foundation of daily leadership (Coursera)

• Internet of things held by national program on technology enhance learning (NPTEL)

• UI/UX design: visual effects for user interface design (Coursera)

Contact this candidate