Shadid Rezwan
Baring,TX
Summary
Business Analyst professional with experience in business analysis, Data Analysis, Full Software/Systems Development Lifecycle (SDLC), ERP, CRM 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. Reliable and goal-oriented with acommitment to excellence in every project.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Business Analyst
IMC Financials
01.2022 - Current
- Leads business Data analysis effort- business systems product development, data reporting, documents business requirements, liaise clients/stakeholders in SDLC –Waterfall/Agile-hybrid project environment, supports Salesforce- SaaS based Real Estate mortgage- Loan Origination Systems (LOS) Finance/insurance web application- collaborate Enterprise BI/ Data Visualization team to test, clean, and standardized data to meet the business requirements
- Utilizes JIRA for daily project tasks, perform admin functions-related to Salesforce users, roles, workflows and reports prepares data report, utilizes MS Project, fully implemented accounting cycle following GAAP and financial statements Analysis along with full data migration of accounting, inventory, customer and vendor data from legacy systems
- Assists assets and wealth investment portfolio team, developed custom financial and sales reports, Designs process flow with BPMN 2.0, prepare salesforce data report using MS Excel, 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
- Prepare UAT plan, assists testers to functional-regression testing, Azure DevOps (ADO) for project management
- 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)
- Uses Clarizen process meaningful data Developed automated anomaly detector to increase efficiency and accuracy Created data visualization, utilizes skill on BI SSRS migration/ SSMS functions -MS SQL, MS Excel (Formulas, VLOOKUP, pivot tables, X-Lookup) for data integration to current Nissan system
- Experience using Tableau, including data management and Data visualizations, developing comprehensive charts, strong aptitude for correlating data and finding critical data trends- building and creating reports and dashboards in Salesforce.com building interactive reports and self-service dashboards using Tableau Desktop to represent KPI data; using Power automate to synchronize files, get notifications, and to collect data; used JIRA for project tasks
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
- Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
- Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
- Improved business processes by analyzing current practices and recommending optimization strategies.
- Collaborated closely with stakeholders to identify opportunities for process improvements and drive continuous innovation in the organization.
Business /Systems Analyst
Freeman
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 MS CRM related system Build and publish interactive BI dashboard
- Assists Financial team with Accounts Receivable and Payable and financial statements with NetSuite ERP-Streamlines invoicing and billing processes, ensures timely collection and payment, and provides detailed reports for better cash flow management
- Utilizes JIRA for daily project tasks, perform admin functions-related to Salesforce users, roles, workflows and reports prepares data report, utilizes MS Project, fully implemented accounting cycle following GAAP and financial statements Analysis along with full data migration of accounting, inventory, customer and vendor data from legacy systems
- Developed custom accounting and financial and sales reports for clients, allowing senior management to efficiently make critical business decisions
- Collaborate Enterprise BI/ Data Visualization team to test, clean, and standardized data to meet the business requirements
- Prepares Clarity/Clarizen for project reporting Utilizes JIRA for daily project tasks, perform admin functions-related to Salesforce users, roles, workflows and reports prepares data report
- Assist Data Azure Data Migration from SQL Server- Analytics/Business Intelligence team Data handling: Define and document data requirements for data integration and campaign lead list creation
- Assists Designed and developed data pipelines, data warehouses and data marts to integrate new data sets from different sources into a data platform
- 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/Python to find patterns and signals in data to flag potential risks in ordering from suppliers and business opportunities by capturing demand signals from customers
- Prepare Power BI desktop dashboards for advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards, utilizes SSRS and SQL for joins
- Collaborated with cross-functional teams to gather requirements and configure ServiceNow modules to support ITIL processes, resulting in 25% increase in service desk efficiency
- Assist data migration/integration to Azure cloud project
- Maintains data quality, instantly identify the root cause of migration issues to help accelerate resolution and minimize business impact
- Perform data mapping
- Quickly find security vulnerabilities and remediate them before become real issues
- Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs
- Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs
- Multiple data and reporting migration projects from On-prem to cloud
Business Intelligence Analyst
Santander Consumer USA
10.2020 - 04.2021
- Liaise with clients/vendors, works closely with Product Owner /Clients shareholders, utilizes ServiceNow ticket remediation tool to support business operations, Utilizes Azure DevOps for SaaS project support payment processing
- Designed BRDs, FRDS
- 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 MS CRM related system Build and publish interactive BI dashboard
- Builds Dynamic 365 forms, screens, and views as well as workflows and reports, customizes business logic with client-side scripting and plug-ins as appropriate, utilizes Smartsheet for Project analysis, data cataloging and data governance for reporting
- Perform Data Analysis-Tableau, including data management and visualizations, developing comprehensive charts, strong aptitude for correlating data and finding critical data trends- building and creating reports and dashboards in Salesforce.com
- Stakeholders on regular basis, prepares detailed Business Requirement Document (BRD), functional specifications (FRD) for dealer auto finance/insurance 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 Python fundamentals.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
Business Analyst/Data Analyst
DFW Airport
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, ensures data quality Improvement, or solution development for Salesforce-Supply chain related system implementation
- Analyzing business processes, gathering and documenting requirements, and providing recommendations for process improvements, worked closely with the Dynamics 365 CRM Functional 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
- Perform Power BI tools, Help team implement important BI systems, Increase company efficiency by 30% by identifying and adjusting key performance indicators
- Creates Relationships, actions, data blending, filters, parameters, fields using Tableau BI Utilizes skill on MS SQL, MS Power BI DAX functions, MS Excel (VLOOKUP, pivot tables, VBA) for reporting Reviews test cases, assists UAT testing, regression testing with the QA team
Business/Data Analyst
Global Payments
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, Python, dashboards, KPI matrices graphs for data visualization/reporting Documented business requirements from business users and subject matter experts SMEs
- Perform Data Analysis-Tableau, including data management and visualizations, developing comprehensive charts, strong aptitude for correlating data and finding critical data trends- building and creating reports and dashboards in Salesforce.com
- Created Process flow chart using MS Visio for non-technical users Performs PMO coordination, investment and wealth management 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
- Prepare 7 sales Tableau desktop dashboards for advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards-SSRS, SQL for joins
Business Systems Analyst
Citi Bank
01.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 management
- Prepare Power BI desktop dashboards for advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards, utilizes SSRS and SQL for joins
- Ensures data quality implementation for Citi real estate mortgage operations (LOS) project
- 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
Business/Data Analyst
Willis Towers Watson
05.2016 - 12.2016
- Prepare Data report for Willis internal data migration project
- Documents business/Technical requirements
- Helped prepare data model for performance and sales trend analysis Perform GAP analysis, data validation, quality control for project reporting
- Utilizes JIRA for Creating 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
- Perform admin functions-related to Salesforce users, roles, workflows and reports prepares data report Utilizes skill on BI SSMS functions /operators
- Prepare-MS SharePoint workflows, MS SQL, MS Excel (Formulas, VLOOKUP, pivot tables, X-Lookup) for data integration to current Nissan system
Education
MBA - Finance and Banking
Texas A& M University System
01.2015
BBA - Business Administration and Management
University of Dhaka
01.2012
Skills
- SDLC-Waterfall
- Agile-Scrum-Kanban
- Six Sigma
- Kaizen
- Statistical analysis
- SharePoint
- Python
- MS Visio
- MS Project
- Skype for Business
- SQL Server
- Tableau
- JIRA
- Desktop 101
- Azure DevOps
- Alteryx
- BO-Crystal Report
- Miro
- Lucid Chart
- CRM
- BPMN 20
- Azure Cloud
- Invision
- Windows 10
- Windows 11
- Data Analysis
- Requirements Gathering
- Microsoft Office Suite
- Project Management
- User Acceptance Testing
- Workflow Analysis
- KPI Tracking
- SQL Proficiency
- Business Process Mapping
- Gap analysis
- Software development life cycle
- CRM Systems
Certification
- Project Management
- IIBA- Business Analysis
- CBAP
- PMI-Agile Scrum
- Salesforce CRM
- Azure Cloud
- SQL
- Tableau
Clearance
DoD-Active Secret
Workauthorization
US Citizen
Personal Information
Citizenship: US Citizen
Affiliations
- IIBA
Timeline
Business Analyst
IMC Financials
01.2022 - Current
Business /Systems Analyst
Freeman
05.2021 - 12.2021
Business Intelligence Analyst
Santander Consumer USA
10.2020 - 04.2021
Business Analyst/Data Analyst
DFW Airport
03.2019 - 09.2020
Business/Data Analyst
Global Payments
01.2018 - 03.2019
Business Systems Analyst
Citi Bank
01.2017 - 12.2017
Business/Data Analyst
Willis Towers Watson
05.2016 - 12.2016
BBA - Business Administration and Management
University of Dhaka
MBA - Finance and Banking
Texas A& M University System
Similar Profiles
SANTOSH SHINGARESANTOSH SHINGARE
Assistant Manager- Admin at Rurash Financials Pvt LtdAssistant Manager- Admin at Rurash Financials Pvt Ltd
KETAN GULATIKETAN GULATI
Customer Service Officer at EKDANT FINANCIALSCustomer Service Officer at EKDANT FINANCIALS
S BINDU BHARGAVIS BINDU BHARGAVI
Process Analyst L2 at Broadridge FinancialsProcess Analyst L2 at Broadridge Financials
RITCHEL SOTTORITCHEL SOTTO
Laboratory Technician at Shemberg Biotech CorporationLaboratory Technician at Shemberg Biotech Corporation
Angela BurdetteAngela Burdette
Patient Accounts at Preferred family healthcarePatient Accounts at Preferred family healthcare