Summary
Overview
Work History
Education
Skills
It Software Tools
Timeline

Shadid Rezwan

Summary

Business Analyst professional with experience in business analysis, Data Analysis, Full Software/Systems Development Lifecycle (SDLC), ERP, data analytics, project management, and business intelligence (BI). Partner with business users and act as a liaison between business and technical teams. Versatile, flexible, and willing to work within constantly changing priorities with enthusiasm

Overview

6
6
years of professional experience

Work History

Business/Data Analyst

Latitude Inc. (Client: Nissan)
Maryland
01.2022 - Current
  • Leads business analysis effort- business systems/software product development, documents business requirements, liaise clients/stakeholders in SDLC –Waterfall/Agile-hybrid project environment SaaS based Dealers Management Auto Finance web application-(Vehicle Lease, Servicing) Prepare data reports SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) Utilizes skill on MS SQL, MS Excel (VLOOKUP, pivot tables, VBA) for reporting Develop relevant BRDs, prioritize user stories for logical development during the sprints
  • Writes MSSQL/T-SQL queries to retrieve data from Azure Cloud database related product and customer data, prepare joins, execute aggregate functions
  • Supports ERP accounting team, drive functional process drive and key financial functions through the reporting, planning and performance analysis processes following GAAP (Accounting Rules)

Business /Data Analyst

Freeman
Dallas, TX
05.2021 - 12.2021
  • Perform GAP analysis Data quality reporting, analyses KPI matrices Works closely with the end-users, business clients, and stakeholders to define business requirements for defect resolution, process improvement, or solution development for Salesforce CRM related system Build and publish interactive Data report using Alteryx, SQL and Power BI for KPI/sales trend analysis Utilizes MS Power Automate function to refresh the datasets behind Power BI reports, and also send alerts if a data threshold is exceeded, created flows Collaborate Data reporting team to test, clean, and standardized data to meet the business requirements
  • Utilizes Tableau Desktop (dashboard creation, report authoring and troubleshooting, data source management) to create dashboards, deliver data driven insights for strategic decision making Perform GAP analysis related to databased system, Data quality reporting, analyses KPI matrices Developed Tableau BI data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Create interactive filters, parameters and calculations for preparing dashboards and worksheets in Tableau.

Business/Systems Analyst

Santander Consumer USA
Dallas, TX
10.2020 - 04.2021
  • Liaise with clients/vendors
  • Stakeholders on regular basis, prepares detailed Business Requirement Document (BRD), functional specifications (FRD) for dealer auto finance application development Assist with the scoping and planning of Salesforce.com and CRM related projects Support and contribute to RFP responses and other sales related activities Create documentation (e.g., training, release notes, user stories, test scripts, process flows) Participate and coordinate the delivery of work product with offshore teams across project phases Assisted auto sales team with monthly sales Data Analysis, reporting and trend analysis Advanced skill on MS Excel 2013/16 (VLOOKUP, Macros, Formulas, Tables, Graphs) Assist Product Owners with UAT planning and execution integrated with QA test planning Experience in B2B sales
  • Preference for experience in a managed service-related industry with direct sales and client interaction, proven record of sales and sales leadership

Business Analyst/Data Analyst

DFW Airport
Euless, TX
03.2019 - 09.2020
  • Utilized SQL server for queries, analyzed data and generate useful business data reports Works simultaneously in multiple aviation projects estimated $1.5 million -related to airport safety and security, manages requirements meetings and project timelines Assists DFW solution development team implement companywide M365 collaboration tools (SharePoint, Exchange, MS One Drive) project Elicits business requirements, creates epics, and writes features/user stories utilizing Azure DevOps agile project tool Utilizes Jira-Confluence for project documentation, user stories, and release sign-off Perform GAP analysis, requirements validation, quality reporting, analyses KPI matrices Developed Tableau BI data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
  • Creates Relationships, actions, data blending, filters, parameters, fields using Tableau BI Utilizes skill on MS SQL, MS Excel (VLOOKUP, pivot tables, VBA) for reporting Reviews test cases, assists UAT testing, regression testing with the QA team

IT Business Analyst

Assurity Staffing (Global Payments)
Plano, TX
01.2018 - 03.2019
  • Collaborate with internal stakeholders to define business requirements Created epics, user stories, and acceptance criteria, prioritized product/sprint backlog Managing the product backlog and prioritizing them based on changing requirements  Assists enterprise SaaS implementation project-(SaaS Application Customization, workflows, reports Perform data analysis, prepares data flow chart, data mapping using MS Excel, SQL Meets with internal and external clients/stakeholders to map out “As-Is” and “To-Be” process flows writes MSSQL, dashboards, KPI matrices graphs for data visualization/reporting Documented business requirements from business users and subject matter experts SMEs Created Process flow chart using MS Visio for non-technical users Performs PMO coordination and works across the organizations/cross functional teams Prepares detailed Business Requirement Document (BRD), functional specifications (FRD), perform business Process Modelling using BPMN 2.0 creating wire-frames and helping with user acceptance testing

Business Systems Analyst

Citi Bank
New York, NY
07.2017 - 12.2017
  • Elicits, documents and validates business requirements for Citi commercial real estate mortgage and loan application following SDLC- Waterfall/Agile hybrid project environment Act as a liaison between management, end users, the corporate IT department, and third-party vendors regarding all business systems issues and projects related Salesforce product managment Helped prepare financial model for real estate team, performance and sales trend analysis Perform GAP analysis, data validation, quality control for project reporting Created user stories, assists in managing product backlogs, works with Product owner/SMEs Prepares Tableau BI dashboard -data prep, data blending, LOD calculations and reporting Performs PMO coordination and works across the organizations/cross functional teams Utilizes skill on MS Office-SharePoint, Word, PowerPoint MS Excel 2013/16 (VLOOKUP, Macros, Formulas, Tables, Graphs

Education

BBA - Business Administration And Management

University of Dhaka, Bangladesh
05.2013

Skills

  • Competitive Market Analysis
  • Reusable Knowledge Assets
  • Executive-Level Presentations
  • Spreadsheet Development
  • Process Improvement
  • Business Requirements
  • BI Tool and System Design
  • Presentations and Decks

It Software Tools

  • Process Management: SDLC-Waterfall, Agile-Scrum-Kanban, Six Sigma, Kaizen, Statistical analysis
  • Operating System: Windows 7, 8. 0, 8. 1, 10 MAC OS X, Linux
  • Software tools: SharePoint, Python, MS Visio, Skype for Business, SQL Server, Tableau, JIRA, Desktop 10.1, Azure DevOps, Alteryx, BO-Crystal Report, Miro, Lucid Chart, CRM, BPMN 2.0, Azure Cloud, Invision

Timeline

Business/Data Analyst - Latitude Inc. (Client: Nissan)
01.2022 - Current
Business /Data Analyst - Freeman
05.2021 - 12.2021
Business/Systems Analyst - Santander Consumer USA
10.2020 - 04.2021
Business Analyst/Data Analyst - DFW Airport
03.2019 - 09.2020
IT Business Analyst - Assurity Staffing (Global Payments)
01.2018 - 03.2019
Business Systems Analyst - Citi Bank
07.2017 - 12.2017
University of Dhaka - BBA, Business Administration And Management
Shadid Rezwan