Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Sachin Mehta

Sachin Mehta

Georgetown,ON

Summary

An Experienced Ex-Banker & Airliner Business Analyst/Scrum Master, BSA (CSM/CSPO/CMA/MBA) with over 20+ years of diverse experience in BFS IT domain, with an emphasis on software development of applications and Business System Analysis on experience leading cross-functional teams in the documentation and delivery of process innovations driving the achievement of business goals. Understanding of Ruby on Rails Strong understanding and hands-on experience with Waterfall, Agile, Business Process Re engineering, and Unified Modelling Language. Experience gathering requirements through JAD, interviews, workshops, brainstorming meetings, surveys/questionnaires, and actively involving stakeholders. Knowledge of data governance and data management methods Use Cases, UML Modelling with Sequence Diagrams, Activity Diagrams, and Workflow Analysis to create business process models. User Acceptance Testing (UAT), Functional Test Cases, and Test Case documentation and assessment were all performed. Capable of collecting functional and technical documentation, converting requirements into system specifications, and creating test cases to ensure application and operational requirements are met.

Overview

22
22
years of professional experience

Work History

Senior Business Analyst

Kales Airline Services
05.2015 - 02.2023
  • As a lead BSA, I worked on a data warehousing and ETL initiative
  • Review and walkthrough methods were used to verify project stakeholders' requirements and analysis models
  • Maintaining and troubleshooting existing web applications
  • Integrating data storage solutions
  • Work on projects with large scale customer impact and showcase ability to operate under limited direction and minimal oversight
  • Display ability to delineate requirements to solve complex business problems using differing technologies and system views across multiple functional domains (within company and between company and its customer) on high profile projects
  • Exhibit in-depth knowledge and showcase the ability to represent all customer and industry needs; typically lead and coach a team of subject matter experts and help them to upskill
  • Support continuous improvement and post-cutover issues
  • Investigating alternatives processes
  • Analyzes Production logs & defects and recommends corrective action in collaboration with Development, Service Ops and Care teams
  • Develops business case and product plans
  • Works with other IT professionals to ensure requirements are met
  • Obtains funding and approval to develop products
  • Works closely with key stakeholders on proposals that affect business case
  • Adjusts product capabilities and strategy to maintain financial commitments
  • Documentation includes source extract specs (which define the source data and metadata), as well as data mapping from the source to the curated environment
  • Assured that system specifications met standards and requirements, as well as negotiated end-to-end solutions
  • To ensure the validity of the analyses, documentation was created
  • Maintaining existing requirements guarantees that the current situation is understood
  • Analytical assistance and insight were given
  • Connected with source and operational systems to transfer data into company warehouse, which was then channelled into the curated data environment.
  • Guided teams and refined Agile techniques throughout journey and evolution of delivery cycles, establishing documentation framework to support Agile methodology implementation with Waterfall-centric delivery team.
  • Maintained proficiency with latest database technologies.
  • Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.

Senior Business Systems Analyst, Data Management

Etihad Airways
05.2007 - 12.2014
  • Work closely with Business and Business partnership teams to collect data requirements that support the development of analytical components of projects
  • Conduct requirement and systems analysis and translate business data requirements into pure data requirements, aligned with data governance policies and data architecture
  • Lead the requirement gathering sessions with cross functional teams from Finance and Insurance domain
  • Perform analysis and prepare detailed requirements including rules for onboarding account-level data from source to General Ledger, enabling robust reconciliations process within TLM, as it relates to IFRS17 purposes
  • Support associated configuration work within TLM
  • Support development & unit testing, Quality Assurance Testing and User Acceptance Testing
  • Interface with LOB Information Risk Managers to identify and resolve potential access control risk issues.Follow process and procedures to ensure compliance with policy
  • Document access management procedures for assigned platforms, databases, and applications
  • Develop and drive the creation of standardized users’ profile within Credit IT
  • Responsible for auditing [checking for accuracy, proper approvals/authorizations] of IAM type requests processed via request, IdM, ServiceNow, Support Central and requirements derived from projects and/or Internal/External Audit requests
  • Works with IdM, WFDA (WorkForce Data Access)
  • Evaluate feasibility and best technology fit for analytics initiatives
  • Work as liaison between Data Delivery team and Business stakeholders to ensure delivery meets the business need
  • Provide support to other data analysts and help identify synergies in pursuit of their goals
  • Use strong analytical skills and support use of data for sound decision making
  • Establish standards for Business Data Analysis practices and oversee compliance
  • Become the point of contact and reference for knowledge and expertise around data for stakeholder teams
  • Balance technical depth with business acumen to deliver on tactical and strategic priorities
  • Collaborate with other data teams and organizational leaders to identify opportunities for process improvements.

BUSINESS ANALYST

Union National Bank
05.2005 - 04.2007
  • Self starter with experience in Sales CRM platforms
  • Knowledge of Investment Banking and Sales cycle
  • Working with technology, business partners, and stakeholders to do data mapping, data analysis, order, and trade data mapping from federated systems
  • Complete assigned inventory for Loss Analysis or Claims within established SLA’s
  • Interacts directly with investor liaison representatives to explore solutions for increased financial recoveries
  • Test, validate, and deploy solutions to production environment using full SDLC cycle
  • Create artifacts required for deployments
  • Create Data Mapping documents using MS-EXCEL for report configuration in Axiom
  • Performed mapping between Axiom Database and CDW for regulatory reporting
  • Project II: FIXED PROTOCAL/GLOBAL TRADING
  • Collaborate with our global trading and operations teams to understand and deploy connectivity needs across asset classes and markets
  • Build a knowledge base of FIX protocols and their application to financial services workflows within Order Execution Management Systems, Electronic Communication Networks and Post Trade Confirmations
  • Back up team members during absences Verify information and uphold internal controls:
  • Ensure internal control standards are being met
  • Ensure completeness and accuracy of information
  • Check and reconcile information to ensure accuracy and resolve discrepancies
  • Occasionally review files and information prepared by others
  • Ensure up to date documentation
  • Project III:- CAPITAL TRADING
  • Define scope and requirements for technology projects and information systems
  • Gather functional, non-functional, and data requirements from various stakeholders and document them accurately and logically
  • As a product owner, develop project vision for development team, manage product backlog, prioritize product needs, manage product roadmap, oversee development, and support agile development teams
  • Lead product functional design based on business and user knowledge
  • Translate product roadmap features into user stories and acceptance test criteria
  • Develop specifications for business processes, processing workflows or data flows
  • Verify the target solution and support the technology to ensure that the target system will meet the requirements
  • Test the solution to validate the project requirements and objectives
  • Develop effort estimation for requirements elicitation activities
  • Facilitate meeting/interviews and communicate requirements to sponsors, stakeholders and project team members
  • Investigate and assist in resolving data issues in risk systems
  • Help and support other team members.

Change Management, SME Analyst

Alliance Air
12.2000 - 04.2005
  • Compile data and communicate suggestions Processing live/batch feeds, data modification, cleansing, and quality control (SQL/Informatic), including duplicate, outlier, and missing value identification
  • Compile and analyze monthly P&L and margin variances
  • Work with other departments to understand and manage variances to budget, forecast and prior year
  • Generate financial reporting metrics and analyze financial performance trends vs
  • Business objectives
  • Contribute to the gathering, analysis and reporting of business performance indicators
  • Develop financial modeling of all major business drivers as required
  • Provide ad hoc analysis on those main business drivers
  • Develop business cases for key strategic initiatives/capital investments/other Finance projects
  • Regularly provided project-related information to management and end users throughout the Software Development Life Cycle SDLC
  • Agile Scrum, Microsoft Office, Microsoft Visio, Microsoft Project, JIRA, SharePoint, Rally, UML, and SQL are included in the environment
  • Gather requirements from the customer directly, interpret them into system requirement, document requirements, convert business processes into application rules and configurations, create and test scenarios, collaborate with customer during validation phase, until system cutover
  • Work on projects with large scale customer impact and showcase ability to operate under limited direction and minimal oversight
  • Project 2: - DBS for Internal department
  • Display ability to delineate requirements to solve complex business problems using differing technologies and system views across multiple functional domains (within company and between company and its customer) on high profile projects
  • Work closely with internal stakeholders to successfully implement Airport Management software systems within the planned duration and budget
  • Develop a thorough understanding of the application’s user interface, both from functional business and technical process standpoint, to implement, install and help in solution adoption and integration into customer’s business processes
  • Project 3: -, Leads a project from a subject matter expert perspective covering aspects of determining & documenting scope (Interactive Pilot) through understanding customer business process, configuring system per customer requirements, training of customer key users and successful support of customer validation testing
  • Test and document new releases and/or new or change functionality in modules
  • Ensure that approved methods, processes, and tools are consistently used
  • Demonstrate effective teamwork skills
  • Show ability to work solo end-to-end on projects performing different functional roles as a SME, analyst, trainer, installer, and project manager (on small-scale projects)
  • Comfortable in self-starter mindset, demonstrates experience in taking initiatives, identifies challenges which are opportunities for continuous improvement
  • Implementation consulting roles assessing customer organizational, technical and functional efficiencies aimed towards successful adoption of system
  • Perform system adoption health checks to tweak and refine customer business process and/or targeted application fixes and improvements aimed at improving customer value.

Education

Agile Professional 2020 -

Professional Diploma - Programming/language

IGNOU

PMP from - undefined

PMI

Certified Management Professional From - undefined

ICMA

QA Testing Professional Certificate from Option - undefined

Certified Scrum Master (CSM - undefined

Alliance

Certified Scrum Master Product Owner (CSPO) - undefined

Scrum Alliance

Persuading and Exam in - undefined

MSSQL for Data Analytics and BI – Udemy - undefined

2022

Data analytics - IBM certification - undefined

2021

Skills

  • Financial Markets
  • Activity Diagram
  • Customer Experience Control
  • Technical Design Documentation

Affiliations

Masters in finance and IT from ICTM, India in May 2012

Timeline

Senior Business Analyst - Kales Airline Services
05.2015 - 02.2023
Senior Business Systems Analyst, Data Management - Etihad Airways
05.2007 - 12.2014
BUSINESS ANALYST - Union National Bank
05.2005 - 04.2007
Change Management, SME Analyst - Alliance Air
12.2000 - 04.2005
- Agile Professional 2020,
IGNOU - Professional Diploma, Programming/language
PMI - PMP from,
ICMA - Certified Management Professional From,
- QA Testing Professional Certificate from Option,
Alliance - Certified Scrum Master (CSM,
Scrum Alliance - Certified Scrum Master Product Owner (CSPO),
- Persuading and Exam in,
- MSSQL for Data Analytics and BI – Udemy,
- Data analytics - IBM certification,
Sachin Mehta