Viral PatelBusiness System Analyst
About Me
Business Systems Analyst with 7+ years of experience across ERP, data analysis, reporting, and operational systems in manufacturing and supply chain environments. Strong background in SAP, SQL based reporting, UAT leadership, and process optimization. Known for delivering audit ready insights, improving operational efficiency, and bridging business and technology teams across full SDLC and STLC cycles.
Adept in requirements gathering, Agile delivery, UAT coordination, and stakeholder communication. I bring strong technical skills in SQL, Power BI, Python, JIRA, and ERP systems, with a focus on traceability, process improvement, and technology delivery practices.
Technical Skills & Competencies
Requirements Elicitation
BUSINESS ANALYSIS
BRD & FRD Documentation
DOCUMENTATION
Use Case Development
BUSINESS ANALYSIS
User Story Creation
AGILE
Change Impact Analysis
PROCESS
SQL Queries & Validation
TECHNICAL
Power BI Dashboards
ANALYTICS
Advanced Excel
ANALYTICS
Data Quality Assurance
QUALITY ASSURANCE
Python Programming
TECHNICAL
ERP & SAP Systems
SYSTEMS
UAT Planning
TESTING
Test Case Execution
TESTING
System Integration
TECHNICAL
Workflow Optimization
PROCESS
JIRA & Confluence
TOOLS
Postman
TOOLS
Microsoft 365
TOOLS
Tableau
ANALYTICS
Agile Methodology
AGILE
Key Achievements
Professional Experience
Data Analyst
-York Region Education Services|- ▸Analyzed and consolidated transactional sales data across 30+ retail locations to produce monthly, quarterly, and annual performance insights supporting executive decision-making
- ▸Defined and validated province-level KPI logic and business rules, reducing reporting rework by ~30% and improving data confidence for leadership reviews
Data Analyst
-Pkg Place|- ▸Translated logistics stakeholder requirements into validated tracking dashboards, improving delivery visibility and forecasting accuracy by 25%
- ▸Standardized warehouse and cross-dock workflows across manifests, dispatch, and SKU labeling, reducing process variation and improving operational efficiency by 20%
- ▸Performed pricing and vendor charge validation using SQL and Excel analytics, reducing billing discrepancies by 15% and strengthening financial and inventory controls
Business System Analyst
-ArcelorMittal Nippon Steel|- ▸Translated cross-functional business requirements into SAP MM and finance reporting solutions, improving audit readiness and financial accuracy by 25%
- ▸Led SAP MM master data and purchase document changes by owning functional documentation, impact analysis, and UAT sign-off, delivering zero-downtime, zero-defect releases
- ▸Designed and governed multi-source Tableau KPI dashboards for leadership, reducing recurring reporting cycles from ~2 days to hours
- ▸Automated change request and report-publishing workflows, strengthening delivery governance and eliminating missed deadlines
Business System Analyst
-Essar Steel Pvt. Ltd.|- ▸Supported live shipping and goods auctions by documenting requirements and implementing automated bidding logic, contributing to $500K+ annual cost savings
- ▸Executed SAP MM purchase document changes with structured impact analysis and UAT support, ensuring stable, error-free production releases
- ▸Automated auction reporting and stakeholder notifications, reducing manual coordination and improving delivery timeliness
- ▸Optimized SAP vendor aging and debit reports using BAPI and performance tuning, reducing runtime from 15+ minutes to under 3 minutes
Key Projects
Delivered impactful solutions across enterprise systems
SAP FICO Solution
Business Place GL Analysis & Trial Balance
Integrated SAP FI-CO reporting solution enabling multi-entity trial balance analysis, GL reconciliation, and intercompany eliminations across business places.
SAP FICO Solution
GL Accrual Management & Reporting
Comprehensive accrual lifecycle management with GRR-to-invoice matching, variance detection, and automated reversal recommendations.
SAP FICO Solution
Debit & Credit Transaction Report
Transaction-level transparency tool providing detailed debit/credit analysis, posting validation, and comprehensive audit trails.
New Request
Reverse Auction Portal Enhancement
Led 7-member team for auction creation and publishing features with automated email notification system for vendors.
Change Request
Change Request Automation & Email Send
Developed report publishing button and auto-bid submission feature with automated auction notification scheduling.
Dashboard Development
Material Management KPI Dashboard
Built interactive Tableau dashboards from 5+ data sources with strict access control mechanisms.
Change Request
Company Name Change on Purchase Documents
Acted as domain expert for requirements analysis and prepared Solution Documents, FS, UT, and FAT.
Change Request
Purchase Document Name Change
Created comprehensive BRD, FS, UT, FAT, UAT documentation and led 5-member cross-functional team.
Report Development
Vendor Aging and Debit Report Optimization
Developed financial reports using BAPI functions with enhanced performance and usability.
Professional Certifications
Requirements analysis and business process modeling with SAP Signavio
AWS Cloud Practitioner
AWS cloud services, core services, security, and architecture best practices
SAP ERP & Supply Chain Management
SAP ERP systems & supply chain management processes
Education
Conestoga College
Ontario, Canada
Postgraduate Diploma
Software Quality Assurance and Test Engineering
Conestoga College
Ontario, Canada
Postgraduate Diploma
Project Management
Gujarat Technological University
Bharuch, Gujarat, India
Bachelor of Engineering
Computer Science Engineering
Get In Touch
I'm always interested in hearing about new opportunities, collaborations, and challenges. Whether you have a project in mind or just want to connect, feel free to reach out!