Mohammad Sohail

Analytical and results-driven Senior Business Analyst and Certified Scrum Master with over 7+ years of experience resolving thorny business challenges by merging data engineering with advanced business analysis. Highly adept at conducting industry trend analysis, translating complex datasets into actionable business insights, and writing production-grade SQL to architect data strategies. Proven track record of designing experimental frameworks to test hypotheses, building scalable ETL data pipelines, and deploying interactive reporting dashboards to optimize global operations.

Exceptional communicator skilled at managing cross-functional stakeholder alignment and delivering compelling, synthesized recommendations to influence senior leadership decision-making.

Business Analyst at Swarnasky Technologies Inc. (2025-10 – 2025-10)

Served as the primary Business Analyst for the "ClaimAssist" project, collaborating closely with US onshore stakeholders to translate complex requirements into technical solution designs. Applied advanced data modeling and relational database methodologies to define strict data quality standards for multi-layered reporting metrics.

• Leveraged complex SQL queries to run deep data analysis and trend evaluation, ensuring data completeness for critical risk and severity forecasting.
• Designed and managed end-to-end project lifecycles using Jira, maintaining alignment across cross-functional engineering teams.

Business Analyst at CremisiSoft Solutions, Inc. (2023-04 – 2025-01)

Migrated legacy, high-latency financial and operational reporting infrastructure into Snowflake, integrating dashboards with Power BI to power real-time, evidence-based leadership decisions.

• Engineered custom automated ETL pipelines to extract, transform, and load source data, mitigating recurring data errors and improving structural accuracy by 30%.
• Developed robust star and snowflake data schemas to support real-time data visualization and minimize ad-hoc query latency.
• Collaborated with product, engineering, and data divisions to construct functional user stories, technical definitions, and rigorous User Acceptance Testing (UAT) scenarios.
• Architected a custom Data Quality Monitoring framework driven by automated SQL validation rules and anomaly detection algorithms.
• Utilized Snowflake Tasks to fully automate recurring data loads, reducing manual engineering reporting time constraints by 60%.

Associate Business Analyst / Workforce Specialist at Amazon.com, Inc. (2018-03 – 2023-04)

Managed the end-to-end data collection and extraction processes from highly fragmented, complex database systems to drive global workforce operational strategies.

• Designed and deployed interactive dashboard frameworks in Tableau and QuickSight, providing leadership with actionable visibility into operational KPIs and performance optimizations.
• Conducted thorough industry and operational trend analysis to uncover correlation patterns, steering strategic planning and optimal resource scheduling.
• Delivered high-impact technical presentations and analytics training to cross-functional teams, driving the adoption of self-service visualization tools.

Risk Analyst at Google Contract via GlobalLogic and Wipro (2016-03 – 2018-03)

Evaluated massive high-volume digital asset submissions to maintain ecosystem compliance, identify security vulnerabilities, and mitigate fraud risks.

• Utilized targeted SQL analysis to uncover hidden risk patterns and system policy violations in fast-moving, ambiguous environments.
• Partnered with international cross-functional policy and risk engineering teams to design and implement strategic solutions aimed at safeguarding ecosystem integrity.

BMS Engineer at Al-Futtaim Engineering and Technology (2014 – 2016)

• Analyzed building management system data trends to systematically diagnose performance inefficiencies and deliver data-backed operational insight reports.
• Partnered with resource planning management to orchestrate optimal preventative maintenance timelines, reducing systemic operational downtime.

M.B.A. in Finance – Osmania University

B.E. in Electronics Engineering – Osmania University

Diploma in Electronics & Communication Engineering – SBTET