Business analyst
Fahad Abdullah Mohammed
*****************@*****.***
Contact no:469-***-****
Summary
Proficient Business Analyst with 11+ years of insight managing complex departmental deployments. Thoroughly manages customer data, expertly applying problem resolution via audits and troubleshooting. Extensively familiar with updated standards governing information management. Expertly applies knowledge to optimize quality control and data retention.
Expertise inthe knowledge of Capital Markets, Initial Public Offering(IPO), Fixed Income Securities, Equity Securities, derivatives.
Generated and presented reports on change management metrics and progress to senior leadership, providing insights and recommendations for enhancing change management strategies.
Work experience as Insurance business Analyst and Operations Executive
Expertise inthe knowledge of Capital Markets, Initial Public Offering(IPO), Fixed Income Securities, Equity Securities, derivatives.
Experience in conducting a Gap analysis, User Acceptance Testing (UAT), SWOT analysis, Cost-benefit analysis and ROI analysis.
Performance tuning by analysing and comparing the turnaround times between SQL and QlikView.
Deep technical background and solid working knowledge of SQL Server Data warehouse systems.
Experience with COTS (Commercial off-the-shelf) and ERP (Enterprise Resource Planning) that are PeopleSoft and Microsoft Dynamics.
Expertise in Performance Tuning TableauDashboards and Reports built on huge Data sources.
Hard-core experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
Proven expertise in creating test plans, UML diagrams, flowcharts, screenmock-ups and systems requirements specifications.
Experienced in working with a Testing team, participated in writing Test Plan, Test Cases, Test Scenarios, RTM, Test Reports, and conducting various forms of testing, which include Integration Testing, Smoke Testing, Regression Testing.
Lead JAD sessions with corporate tax department and all source system SME's and prepared FRS for FATCA Reporting project.
In-depth knowledge of Rational Unified Process (RUP); risk engineering; data Modeling and mapping; and design using UML, Rational Rose, Visio,and other related tools.
Demonstrated ability to work actively in different phases of SDLC, Agile/Scrum in team’s fostered cooperation and collaboration among individuals in the work unit and helped team resolve conflicts constructively.
Broad understand and knowledge of Insurance Industry operations with emphasis on life and long term care insurance process.
Worked with PowerBI Service for creating Dashboards, tiles, and Q&as and sharing them to co-workers and end users in a secure manner.
Hands on experience and expertise in Guidewire PolicyCenter implementation and integration by leveraging Agile Methodology.
Experience on major business jobs of a PolicyCenter like storing information about a policy and managing a set of processes Vast experience in performing SDLC tasks - Requirement gathering, Analysis,and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low-Level Design documents etc.
Comprehensive understanding and experience of SDLC and project life cycle methodologies such as Waterfall, Agile, Rapid Application Development (RAD), and Rational Unified Process (RUP).
Solid Experience in developing Scope/Vision Documentation and Project Plan.
Excellent writing skills in generating, Project Charter, Project Plan, Business Requirements documents, Use Case Specifications Test Plan, Credit Risk Management Plan Liquidity risk assessment, and Publishing Regular Reports with status and metrics.
Conducted GAP analysis to capture functionalities of existing systems and analysis requirements of the proposed system followed various SDLC methodologies which include AGILE Scrum, AGILE Extreme Programming, Rational Unified Process (RUP), Iterative, and Incremental and Waterfall models to execute the proposed requirements.
Conducted Data migration from different platforms used for CRM and ERP data management to Salesforce Platform for companies better forecast and reporting abilities and streamline business sales process and future regional needs performed User & Data Management, setup users’ actionable analytics and security.
Project Methodologies
RUP, OOAD, UML & Business/Data Modeling, ER modeling.
Business Modeling Tools
MS Visio, Rational Rose
Requirement Management Tools
Rational Requisite Pro, Caliber RM, Enterprise Architect
Modeling tools
UML, MS Visio Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, User stories, JAD/JRP Sessions, Gap Analysis, Root Cause Analysis
Requirements Artifacts
BRD, SRS, Activity diagrams, Test cases, test plans, use cases, Use case diagrams, RTM
Quality Management
Dev Track, Bugzilla, Jira, Quick Test Professional
Defect Tracking Tools
Rational Clear Quest, Quality Center
Languages
C#, Java, HTML, .NET, XML
Web dev tools
Dreamweaver, FrontPage.
Databases
MS SQL server, Oracle 11g/12c, Oracle Clinical, MS Access
Methodologies
SDLC (Waterfall, Agile, Scrum), Six Sigma, RUP
Testing Tools
Test Director, Quality Center, Quick Test Pro, Load Runner
Tools
MS PROJECT, SQL, HTML, SharePoint, MS Office
BI/ETL
Tools Informatica, SSIS, OBIEE 11g, Informatica Power Center, SQL * Loader
Operating System
Windows, Linux, Unix, Mac, Solaris.
Documents & Processes
SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process
Technical Skills
EDUCATION
Bachelor of Commerce 2014
WORK HISTORY
BUSINESS SYSTEM ANALYST, 08/2023 – Till now
Eversana Intouch, Kansas, USA
Identified needs & defined business requirements and developed solutions with overall business strategy.
Observed and analyzed complex product workflows and processes, identifying areas for improvement and optimization, and suggesting to PMO, Account, Development and Testing teams.
Documented requirements using various techniques (e.g., use cases, user stories, data flow diagrams, creative assets and keep them up to date for team usage.
Worked with developers and testers to ensure technical solutions align with client system functionalities and user needs.
Developed and maintained ETL processes to streamline data integration from multiple sources, improving data accuracy and accessibility.
Facilitated cross functional requirements-gatherings between third party vendors and incubators.
Closely observed developed and maintained clear & concise documentations of functionalities as per client system processes and user guide.
Proactively identified potential changes in project scop, issues and risks and devised contingency plans along with various teams involved.Performed duties along with various team developing and deploying all digital assets for major top leading pharmaceutical manufacturers in US
BUSINESS ANALYST, 09/2021 – 07/2023
AmerisourseBergen, Dallas, Texas, USA
Prepared maintenance and compliance reports for executive summaries and presentations.
Worked with engineers and technical staff to recommend hardware and software adjustments and resolve design flaws.
Developed and updated tracking spreadsheets using Santa Cruz, Fresh Desk, Quick books, Tracking Systems.
Designed plans to improve operations and suggested changes to systems for overall organization.
Generated CRM reports to maintain client records on customer activity and personal data.
Designed data optimization and interfaces for user interaction.
Designed and implemented ETL workflows that reduced data processing time by using [specific ETL tool].
Monitored ETL processes and utilized performance tuning techniques to enhance data loading speed and reduce downtime.
BUSINESS ANALYST, 06/2017 - 08/2021
Chamsky LLC, Oakland, CA, USA
Collaborated with key personnel to verify data integrity and compliance with related regulatory guidelines and legal requirements.
Oversaw user provisioning efforts, verifying credentialing policies, security and maintenance to encourage safe sign-ins.
Collaborated constantly with the client and internal team to gather business requirements and performed Requirement Planning signoffs
Analyzed, converted and documented business requirement into BRD, User Stories and SRS.
Conducted JAD sessions for a better understanding of the project goal and refined the business requirements in coordination with multiple teams.
Project development with ULMmodeling and documentation, Kaizen and Six Sigma methodology, agile approach, project lead, project management training.
Involved in various stages of Software Development Life Cycle (SDLC).
Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules (Requirements, Test plan, Test lab,and Defects)
Worked closely with management teams to plan, develop, coordinate and execute technical strategies aligned to client's vision, mission and purpose.
Led and assisted technical upgrade projects for clients by working and coordinating with consultants and developers for integrations.
Facilitated best user experience through continuous support, training classes, webinars, improvements and communication of system changes.
Communicated regularly with customers concerning data exchange and technology integration.
Led team for software engineering services and supported key clients in development efforts, establishing standards, determining specifications and creating Service and Operational Level Agreements (SLA) and (OLA).
"Designed and implemented ETL processes using Informatica to integrate data from various sources, resulting in a 40% increase in reporting efficiency."
Analyzed data sets using SQL to identify inefficiencies in operational workflows, recommending process improvements that resulted in a 20% reduction in costs.
Developed complex SQL queries to identify trends and patterns in customer behavior, leading to a 15% increase in customer retention.
Assisted in the development and maintenance of ETL processes, using SQL to ensure accurate data migration and transformation.
BUSINESS ANALYST, 06/2015 - 05/2017
Bohr Solutions,India
Conducted one to one interviews with the Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
Conducted interviews with key business users to collect information on business processes And user requirements.
Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
Tracked UAT issues/bugs and prepared reports.
Analyzed data and performed data trending for stability studies using Excel (Excel Solver) and JMP.
Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
Use advanced Microsoft Excel to create the pivot table and use VLOOKUP functions
Responsible for defining, designing, and leading implementation of PowerBIreports and dashboards for our client.
Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
Designed workflows and allocated permissions within SharePoint.
Created project WBS (work breakdown structure), allocated resources to projects and project activities in PeopleSoft and Clarity (project & portfolio management tool).
Designed and developed Project document templates based on SDLC methodology.
Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
Improved business direction by prioritizing customers and implementing changes based on collected feedback.
BUSINESS ANALYST, 05/2014 - 05/2016
Technology Networks, INDIA
Investigated and addressed system issues to enhance usability and improve functionality.
Oversaw installation of software programs and hardware systems to meet requirements.
Organized system infrastructure documentation and operating procedures, strengthening controls and enhancing overall performance.
Documented procedures and business processes and shared information with appropriate stakeholders.
Guided divestiture activities, drawing on deep understanding of various internal operational processes.
Managed the project using the Agile Methodology and implementing Scrum development methodology
Interacted with business heads to finalize the Business Requirements for the application.
Analyzed business processes and data used to support the reporting and analytics for multiple departments
Analyzed the Source data and do data Profiling as needed to support design work Led the effort to the Business Rules, matching rules, and survivorship rules.
Represented business in meetings with IT team validated the Mastered Data and defined strategy for Data cleansing and Standardizing.
Developed communications and presentations for high-level audiences with Visio and PowerPoint.
Collaborated closely with upper management to drive strategy through development and implementation of new processes.