Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Mark Trevor Rajan

Mark Trevor Rajan

Sharjah

Summary

Dynamic Business Systems Analyst with a proven track record at Transcend IT Solutions, excelling in data mapping and analysis. Adept at enhancing user experiences and optimizing processes, I leverage Agile methodologies and strong attention to detail to drive project success and improve customer onboarding, resulting in significant engagement increases. Organized professional with superior work ethic and team player attitude. Exceptional quality control and inspection abilities. Commended for honesty, hard work and positive attitude. Comfortable standing for long periods of time and safely lifting heavy loads.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Warehouse associate – Stocking 1TA

Walmart
Dallas
10.2024 - 02.2025
  • Company Overview: Walmart involves the process of receiving, sorting, and stocking merchandise on the sales floor. This includes unloading freight from delivery trucks, organizing products in the backroom, and ensuring items are placed in the correct locations on shelves. The goal of Stocking 1 is to keep the store fully stocked, organized, and ready for customers, especially during overnight or early morning shifts.
  • Efficiently unload incoming freight from delivery trucks, ensuring that products are handled properly to prevent damage. Verify the accuracy of shipments by cross-checking items against packing lists and purchase orders.
  • Sort and categorize products based on type, size, and department to optimize storage in the backroom. Ensure items are easily accessible for efficient stocking and retrieval.
  • Accurately stock shelves with products, ensuring correct placement according to department guidelines. Maintain proper facing and ensure that labels, barcodes, and pricing are clearly visible to customers.
  • Regularly check stock levels across all aisles and backroom storage areas. Replenish shelves promptly to avoid stockouts and maintain a fully stocked sales floor during busy shopping hours.
  • Conduct regular checks to ensure products are in excellent condition. Report damaged or expired goods and assist in processing returns or exchanges.
  • Keep both the warehouse and sales floor clean, organized, and free from safety hazards. Follow company safety guidelines to ensure a safe working environment for yourself and your colleagues.
  • Support periodic inventory audits by counting stock and assisting with the identification of discrepancies. Collaborate with management to reconcile any inventory differences between physical stock and system records.
  • Work closely with warehouse and sales floor teams to meet daily stocking and replenishment goals. Communicate effectively with supervisors to ensure smooth operations during peak and off-peak hours.

Business Systems Analyst

Transcend IT Solutions
Frisco
10.2023 - 08.2024
  • The project was to enhance the existing Mortgage originating system which took care of the Mortgage loan application and servicing. It was to make user and customer friendly by adding more features. We also wanted to enhance the Loan Originating Module, Loan servicing module, ACH express module, Web Publishing Central module and updated KYC profiles in accord with KYC criterion.
  • Performed As-Is and To-Be Analysis, GAP Analysis, Cost to Benefit Analysis, impact analysis, Return on Investment analysis on the project. Designed and implemented robust trading platforms to facilitate buying and selling of corporate and government bonds on secondary markets.
  • Prepared RAID log to track and manage Risks, Assumptions, Issues, and Dependencies throughout the project lifecycle. It serves as a central repository that allows project managers to proactively identify, analyze, and respond to potential challenges and opportunities.
  • Conducted gap analysis between legacy systems and new proposed web application capabilities to clearly map all integration touch points required for unified data access. Developed flow diagrams and logic models to illustrate data movement across systems and applications to inform integration development efforts.
  • Actively participated in creating burndown charts, sprint backlogs, and creating the Product Backlog. And defined the DOD and DOR. Created Use cases, UML diagrams, interactive mock-ups, and wireframes for visualization of the process using MS Visio for BPMN diagrams.
  • Participated in Scrum Ceremonies like Release Plan, Refinement Meeting, Sprint Plan, Stand-up, Review, Retrospective.
  • Worked with Product Owner to plan the velocity and capacity and prioritize product backlog using KANO model, Value stream mapping for a sprint and with scrum team to estimate a user-story using Planning Poker, defined and prepared the DOR. We used JIRA for the entire process and to track the progress using Power Scripts.
  • Utilized data analytics tools and techniques to derive actionable insights from payment data, enabling data-driven decision-making and the identification of trends and opportunities.
  • Implemented database replication, failover clustering, and backup strategies to provide high availability and disaster recovery capabilities for mission-critical systems. Conducted thorough database security reviews and implemented controls like encryption, access management, activity logging, and masking to protect sensitive customer financial data.
  • Used Confluence for team collaboration, meeting agendas, and sharing documents and ideas on Confluence team pages.
  • Assisted QA team with Requirement Traceability Matrix (RTM) for rigorous test plan, test cases and test analysis reports.
  • Performed UAT, 508 compliance, performance, integration, unit, regression and production implementation verification. Logged results and shared with team members.

Business Systems Analyst

Colsh Consultants LLC
North Brunswick
01.2023 - 09.2023
  • In an agile-scrum environment, acted as a link between management and the development team for the benefit of the project.
  • Conducted As-Is and To-Be, Cost Benefit, GAP and Return on Investment Analysis for project clarity and understanding.
  • Created detailed work breakdown structures and project schedules with dependencies, milestones and resource allocation for project management. Developed and managed budgets for software products and IT projects including cost estimates, financial analysis and budget tracking and recorded business rules in BRD.
  • Created clear documentation of system recovery priorities, outage protocols, minimum required functionality, and system interdependencies. Actively involved in interactive workshops, project manager (PM), subject matter experts (SMEs), stake holder, system architect to gather and document business, functional and non-functional requirements using different elicitation techniques like interviews, brainstorming sessions, JAD sessions, focus groups and conducting workshops.
  • Created use case document for the developing and the testing teams and the stakeholder to track the activities with business scenarios, developed high fidelity and low fidelity mock-ups and wireframes using Lucid Chart.
  • Decreased customer churn rate by leading cross-functional efforts to improve customer onboarding, enhance user engagement, and analyze customer usage data to identify at-risk accounts for targeted retention campaigns.
  • Assisted the Product Owner to develop MVP, prioritizing them using MOSCOW. Wrote User Stories and Acceptance Criteria in JIRA for development of features in three tier architecture. Managed tasks in JIRA board and reported project progress.
  • Performed velocity or capacity planning as required. Tracked progress by creating sprint burndown charts. Conducted specific scrum ceremonies (Sprint planning, Daily stand-ups, Sprint review and retrospective). Defined the Definition of Ready (DOR) and Definition of Done (DOD). Conducted combined daily stand-ups, retro meetings in the absence of scrum master.
  • Documented business capabilities, processes, applications, and technical infrastructure in Ardoq and developed interactive dashboards and visualizations to showcase architectures and relationships.
  • Performed Data Profiling to remove inconsistencies, anomalies, missing data, duplicated data, and orphaned data the data sources were integrated into datamart and Assisted in the collection of historical customer data and utilized ETL process for data mapping document from different sources to the target.
  • Led requirements gathering sessions and workshops with key stakeholders to understand business needs and integration goals for custom web application development projects. Developed functional specifications documents outlining proposed solutions, integration points, data flows, and technical diagrams to effectively communicate solutions to development teams.
  • Oversaw user acceptance testing efforts including developing test cases and scripts to validate functionality and data integrity through complex system integrations. Partnered with infrastructure and facilities management teams key business analyst to gather needs, document processes, and devise to modernize systems leveraging web platforms and API integration.
  • Worked closely with UX/UI designers and stakeholders to improve the user interface and overall user experience of payments software, resulting in increased customer satisfaction and adoption.
  • Worked as a liaison between QA and development team for bug life cycle management with Requirement Traceability Matrix with Cucumber. Helped QA team with management of test plan document and test cases, test scenarios, performed manual testing, integration testing, system testing, sanity testing, regression testing using HP ALM.
  • Hands on experience in User Acceptance Test (UAT), 508 compliance, performance testing, integration testing, regression testing, unit testing provided feedback and documented the results in Bug Log and Test Reports.
  • Maintain the Agile board using JIRA and documented various issues using confluence thus facilitating collaboration among stakeholders and team members and ensured the project was delivered on time by creating the project closure report.

Education

MBA - Business Administration

Indiana University of Pennsylvania
United States
05-2023

Bachelors - Commerce

Mar Ivanios College
India
06-2021

High School Diploma -

Bharatiya Vidya Bhavan
Kerala, India

Skills

  • Data mapping and analysis
  • Business planning and strategy
  • Campaign performance tracking
  • Quality assurance and testing
  • Microsoft 365 services and applications
  • UML diagramming
  • Jira and Confluence management
  • SharePoint collaboration
  • Inventory management systems
  • Requirements gathering and documentation
  • Generating ad-hoc reports using power BI

  • Database management techniques
  • Process optimization strategies
  • Customer onboarding processes
  • Project scheduling methodologies
  • Attention to detail skills
  • Agile project management
  • Cardboard baling operations
  • Labeling and boxing processes
  • Barcode scanning technology

Certification

Azure Polyphase - Project guide work

Have an US driving license.

Languages

English
Proficient (C2)
C2
French
Beginner
A1
Hindi
Intermediate (B1)
B1
Malayalam
Proficient (C2)
C2
Tamil
Advanced (C1)
C1

Timeline

Warehouse associate – Stocking 1TA

Walmart
10.2024 - 02.2025

Business Systems Analyst

Transcend IT Solutions
10.2023 - 08.2024

Business Systems Analyst

Colsh Consultants LLC
01.2023 - 09.2023

MBA - Business Administration

Indiana University of Pennsylvania

Bachelors - Commerce

Mar Ivanios College

High School Diploma -

Bharatiya Vidya Bhavan

Similar Profiles

CREATE PROFILE
Mark Trevor Rajan