Sohail Mohammed
Villa Park,IL
Summary
Dynamic Business Analyst/Data Analyst with a proven track record at BNYMellon, showcasing expertise in Guidewire implementations and SQL data analysis. Excelled in stakeholder collaboration and Agile methodologies, driving significant process improvements. Known for blending analytical prowess with effective communication to achieve strategic objectives.
Overview
10
10
years of professional experience
Work History
Business Analyst/Data Analyst
BNYMellon
, NY
11.2021 - Current
- Guidewire Expertise & System Implementation – Successfully implemented and upgraded Guidewire Policy Center, Claim Center, and Billing Center for auto and property casualty insurance, ensuring seamless integration and process optimization.
- Business Process Analysis & Gap Assessment – Conducted As-Is and To-Be analysis to identify gaps in current billing and claims systems, driving process improvements, and system enhancements.
- Requirement Gathering and Documentation – Led requirement elicitation, developing Business Requirement Documents (BRD), Functional Requirement Specifications (FRS), and user stories for automation solutions.
- Stakeholder Collaboration and Communication – Coordinated with business teams, developers, and testers to provide walkthroughs, secure sign-offs, and align requirements with compliance and legal teams.
- Data & Integration Management – Managed data migration strategies, data mapping, and system integrations with Planview, Jira, and ServiceNow, enhancing reporting, and workflow automation.
Business Analyst
Global Atlantic financial group
New York, NY
07.2020 - 11.2021
- Agile & Requirement Management – Led requirement gathering using Agile/Scrum methodologies, conducted JAD sessions, and developed detailed business use cases, user stories, and traceability matrices in JIRA.
- Data Analysis & SQL Expertise – Performed in-depth data analysis, data mapping, and transformation using SQL queries, SSIS, and Azure Data Factory; created parameterized reports and dashboards using Power BI, and SSRS.
- Cloud Migration & System Modernization – Managed cloud migration projects, documented dependencies, and collaborated with developers to ensure a smooth transition to Azure, VMware, and OpenStack environments.
- Healthcare & Insurance Compliance – Analyzed HIPAA compliance, EDI transactions (837, 835, 270, 271), and facilitated claims processing with FACETS, ensuring adherence to Medicare, Medicaid, and group insurance standards.
- Business Process Modeling and Integration – Designed and optimized business workflows using BPMN, UML diagrams, and Visio; integrated Health IT projects with interoperability networks using FHIR standards.
Guidewire Business Analyst/Data Analyst
State of North Carolina
Raleigh, North Carolina
03.2018 - 06.2020
- Provided technical support during user acceptance testing cycles.
- Aligned business strategies and objectives with the capabilities and constraints of business IT systems.
- Conducted detailed business analysis, outlining problems, opportunities, and solutions for a business.
- Identified gaps between current state and desired future state operations.
- Maintained or updated business intelligence tools, databases or dashboards.
- Created, analyzed, and validated detailed functional specifications.
- Created informative, actionable, and repeatable reporting that highlighted relevant business trends and opportunities for improvement.
- Operated equipment and machinery according to safety guidelines.
- Identified or monitored current and potential customers using business intelligence tools.
Business Analyst/Data Analyst
Health Spring
Nashville, TN
09.2016 - 02.2018
- Executed Agile methodologies, facilitating JAD meetings and creating thorough business use cases, user stories, and RTM within JIRA.
- Strategic Cloud Migration and Modernization – Spearheaded cloud migration projects by analyzing dependencies, coordinating with development teams, and ensuring a smooth transition to Azure, VMware, and OpenStack environments.
- Advanced Data Analytics and SQL Proficiency – Conducted complex data analysis, data mapping, and transformation using SQL, SSIS, and Azure Data Factory; created interactive dashboards and parameterized reports in Power BI and SSRS.
- Integrated FACETS for efficient processing of Medicare, Medicaid, and group insurance claims.
- Enhanced business workflows using BPMN, UML diagrams, and Visio.
- Facilitated workshops to align technical solutions with business requirements.
Guidewire Business Analyst
NJM Insurance
, Jersey
10.2015 - 09.2016
- Analyzed risk factors for commercial properties, collaborating with underwriters to ensure portfolio profitability.
- Executed data cleaning, profiling, and mapping using SQL and PL/SQL to enhance decision-making in finance.
- Ensured seamless integration of Guidewire Billing Center with Policy Center and Claims processes.
- Streamlined Agile workflows by utilizing JIRA to support Scrum teams during project lifecycle.
- Enhanced IT service management through comprehensive ServiceNow integrations.
- Engineered robust ETL solutions integrating various databases and systems into enterprise warehouses.
Business Analyst
Evolent Health
Pune, India
02.2015 - 08.2015
- Performed testing, data mapping, and validation on FACETS modules such as Membership, Billing, and Provider.
- Performed comprehensive research to ensure alignment with HIPAA guidelines across all involved processes.
- Collaborated with business owners and project managers to ensure alignment of needs with IT solutions.
- Designed test plans to ensure successful system implementation with minimal defects.
- Handled change notification requests to facilitate seamless collaboration between departments.
- Facilitated effective communication for timely project execution and precise reporting.
Analyst/Migration Specialist
- Spearheaded the evaluation, planning, and migration management for customer applications to cloud environments.
- Detected inefficiencies in current cloud migration processes to enhance workflows.
- Ensured data integrity and compliance during the transition of insurance applications from APPS to Guidewire.
- Built enterprise data warehouse (EDW) to enhance insurance analytics leveraging SQL, SSRS, Power BI, and ETL tools.
- Streamlined IT service delivery workflows through process enhancements on ServiceNow.
Education
Bachelor of Science - Information Technology
• KNRR Institute
Hyderabad, India07-2012
Skills
- Business Analysis and Requirement Gathering – Expertise in BRD, FRS, JAD sessions, user stories, and process flow documentation
- Guidewire expertise – strong experience with Policy Center, Claim Center, and Billing Center implementations, and integrations
- SQL & Data Analysis – Proficient in writing queries, data mapping, ETL processes, and working with databases like Oracle and SQL Server
- Agile and Scrum methodologies – hands-on experience in Agile, Kanban, sprint planning, backlog grooming, and JIRA/Confluence
- Insurance domain knowledge – extensive experience in P&C insurance, workers’ compensation, group insurance, and underwriting processes
- Cloud Migration and Modernization – Led cloud migration projects, working with Azure, VMware, and OpenStack environments
- ServiceNow and ITSM – Hands-on experience in IT process automation, incident management, and workflow optimization
- Healthcare and HIPAA compliance – knowledge of FACETS, EDI transactions (837, 835), Medicaid, Medicare, and health claims processing
- Business Intelligence and Reporting – Proficient in Power BI, SSRS, Tableau, and creating dashboards for data-driven decision-making
- Stakeholder collaboration and UAT – conducted user acceptance testing, defect tracking, and worked closely with cross-functional teams
Affiliations
- Facilitated daily stand-ups, sprint planning, backlog grooming, and retrospective meetings
- Performed data profiling, mapping, and cleansing using SQL, SSIS, and Azure Data Factory
- Led gap analysis and designed As-Is/To-Be business process models using BPMN and UML.
Timeline
Business Analyst/Data Analyst
BNYMellon
11.2021 - Current
Business Analyst
Global Atlantic financial group
07.2020 - 11.2021
Guidewire Business Analyst/Data Analyst
State of North Carolina
03.2018 - 06.2020
Business Analyst/Data Analyst
Health Spring
09.2016 - 02.2018
Guidewire Business Analyst
NJM Insurance
10.2015 - 09.2016
Business Analyst
Evolent Health
02.2015 - 08.2015
Analyst/Migration Specialist
Bachelor of Science - Information Technology
• KNRR Institute
Similar Profiles
Melissa O'ConnorMelissa O'Connor
Vice President Fund/ Client Accounting GIA at BNYMellonVice President Fund/ Client Accounting GIA at BNYMellon
Marc MAHIEUMarc MAHIEU
Director Business Analyst at BNYMellonDirector Business Analyst at BNYMellon
KUMAR SANKETKUMAR SANKET
Vice President (ERA) at BNYMellonVice President (ERA) at BNYMellon