PREET KAMAL BAJWA
BUSINESS ANALYST (Supply Chain)
*****@*********.***
PROFESSIONAL SUMMARY:
A result driven, self-motivated and resourceful project coordinator with an in depth understanding of all aspects of project implementation. Experienced in supporting the delivery of new products and business enhancements that enable individuals and organizations to improve their productivity. Effective communicator with a great ability to write reports and prepare presentations.
Supply Chain Analyst with around 7 years of experience in Business Analysis, Insight Consulting and Supply Chain Analysis.
Experience in Business Requirement Gathering, Business Process Modeling, Understanding the Business Process Flow and Analysis and in testing the Deliverables
Profound knowledge of Information technology management, Research techniques, methods and procedures
In-depth knowledge of Systems analysis, development, planning and documentation methods and standards
Exceptional ability in Requirements Gathering techniques to verify and validate business and system needs.
Well versed in documentation of Product Definition Document (PDD), Business Requirements Documentation (BRD), Functional Specification Document (FSD), and System Requirement Specification (SRS).
Experience in full Software Development Life Cycle (RUP, Waterfall, Agile)
Extensive Experience in SQL to pull data out of the system.
Worked on research projects involving market segmentation, Product testing, advertisement testing, Satisfaction and Loyalty Analysis, Brand Awareness and Reach Studies
Experience in Application Testing and Development
Superior presentation skills and report-drafting abilities
Strong understanding of business requirements, business rules, business process
Excellent Skills in Performance Management to support strategic planning, goal setting, strengthen accountability, enhance decision making, and improve customer service.
Excellent Analytical skills to understand the business process and Functionality, Requirements
Developing functional specifications for business process refinement and automation, data modeling, conducting feasibility studies, scope.
Well versed in different management scenarios like change Control, Quality Assurance, Defect Tracking, System Integration and Scheduling
Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis, Portfolio Analysis and ROI analysis
Proficient in customizing already existing business practices, workflows, activities and deliverables
Requirements gathering, data modeling, Feasibility studies, Scope Documents, Requests for Proposal.
Proficient in the use of Microsoft Office tools including Microsoft Excel, Power Point and Project Office
Exceptional ability to show progression of responsibility throughout career
Excellent communication skills to interface with both internal and external resources
Excellent problem-solving and analytical skills
Ability to manage multiple priorities in a fast paced environment
Excellent problem-solving and analytical skills
TECHNICAL SKILLS:
Methodologies: SDLC, Agile (Scrum), Waterfall
Modeling Tools: MS Visio, MS PowerPoint, MS Word, MS Project, MS Access
Office Products : MS Office, Advanced Excel, PowerPoint, Outlook
SDLC Modeling Techniques
Content Management Systems
Project Management
SQL, HTML, SPSS, SAS, SAP, Minitab, Visual Basic, Fast React, NOW, Tableau, BI
ANALYTICAL SKILLS:
Eliciting project requirements
Gap Analysis
Strong Presentation Skills
Good interpersonal skills
Technical Integration and Documentation
Team Management
Excellent analytical, problem solving, and organizational skills
Strong verbal and written communication skills
Ability to work in a team environment and handle responsibilities
PROFESSIONAL EXPERIENCE:
Metsoft Technologies New Orleans, LA, 70112
Business Analyst (Supply Chain) May 2018 – Till Date
Responsibility:
Maintained the project schedule and ensured all tasks are updated at the agreed upon time.
Worked with the project and program manager to complete all required documentation in the defined process.
Managed the overall defined process throughout the project life cycle.
Oversaw management of scope changes, trends and change notices initiated from the project management system and reviewed time and cost implications.
Gather data and conduct analysis with the goal of improving the organization’s supply chain operations.
Identifies underperforming areas in the supply chain and may suggest improvements or resolutions to problems.
Compile easily understood plan outlining goals, objectives, scope, requirements etc. to be implemented.
Assisted in the development of market research analysis.
Supported data gathering and analysis of data.
Participated in data quality control and validation.
Expertise in Procurement and Management Services
BURNS HARBOUR, WESTCHESTER, IN
Business Analyst Aug 2017 – Dec 2017
Responsibility:
Found new opportunities for increased maritime cargoes through the ports of Indiana
Researched Business development opportunities to increase revenue
Coordinated the integration of multiple projects and programs, provided data, analyzed and reported to project managers.
Handled costs and schedules and associated documents and managed change documentation.
Assisted departments in implementation of project management controls.
Assisted project managers in performing variance analysis, conducting assessments, project forecasting, managing change and producing management reports.
Analyzed development of schedule, work breakdown structure, estimated packages during the different phases of a project.
Designed and implemented basic SQL queries for QA testing and data validation
Develop and manage timelines with business, development and testing teams to ensure projects stays on track and will be completed on-time and within budget
RED GOLD INC. ELWOOD, IN
Business Analyst May 2017- July 2017
Responsibility:
Designed an Excel based tool based on previous year data to analyze demand and order raw material
Analyzed the previous year warehouse data to devise best possible utilization of space distribution in between raw material, brite and finished goods keeping in mind the warehousing requirements through the year.
Reduced honeycombing in warehouse.
Analyzed data to predict during which months the company needs to approach 3PL warehouses
BRANDSCAPES WORLDWIDE MUMBAI, INDIA
Business Analyst Mar 2015 – April 2016
Responsibility:
Analyze and interpret insights from data sources and draw actionable conclusion
Planned, designed and conducted both quantitative and qualitative primary market research projects
Questionnaire design for data collection
Data Cleaning, Data Management, Data Integration, Data Mapping
Research studies to evaluate and design demographics, prices, distribution channels, Competitor’s profile, brand perception and marketing campaigns
Experienced with analyzing market trends in the FMCG and Apparel industry;
Completed projects for major clients in Myanmar, Indonesia and Indian Markets
Experience in market segmentation, Product testing, advertisement testing, Satisfaction and Loyalty Analysis, Brand Awareness and Reach Studies
LOWE LINTAS HYDERABAD, INDIA
Business Analyst Feb 2014 – June 2014
Responsibility:
Maintained the project schedule and ensured all tasks are updated at the agreed upon time.
Worked with the project and program manager to complete all required documentation in the defined process.
Managed the overall defined process throughout the project life cycle.
Oversaw management of scope changes, trends and change notices initiated from the project management system and reviewed time and cost implications.
Developed and implemented project cost and scheduled baselines, reported variance, raised issues and risk.
Applied appropriate metrics and tools for project control.
Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
Drafted proposal preparation- understanding of requirements, approach and pricing.
Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
Experience with data analysis using SQL for data validation and integrity Interpret data from primary sources using statistical techniques
Extract, consolidate and analyze data to generate effective visual presentation for a facial cream brand relaunch.
Applied advanced Excel functions to generate spreadsheets and pivot tables to analyze data on telecom brands and develop marketing mix for the same.
Collaborated in secondary and primary market research and developed a marketing mix for Rx-to-OTC switch for Dr Reddy’s Venusia Brand
GOKALDAS EXPORTS LTD BENGALURU, INDIA
Project Coordinator July 2012 – July 2013
Responsibility:
Successfully managed all aspects of supply chain from inception of Customer order through final shipment, with overall responsibility for sourcing, lab dips, sampling, production planning and control and material management
New Product development – women’s wear
Sampling and Sample approvals
Trims and fabric selection/ proposals
Follow Tech pack and other guidelines by customer,
Getting Best cost quotation - for Bulk fabric and trims, so that the product's quote cost fits in to Buyer's Target cost.
ERP entries for BULK.
Trims developments and approvals with Buyer
KMohan Pvt. Ltd. BENGALURU, INDIA
Business Analyst Jan 2012 – May2012
Responsibility:
Manage project development from beginning to end. Supported PM in defining and implementing project scope, schedule, and reporting and escalation management.
Proactively manage changes in project scope, identify potential crises, and devise contingency plans.
Manage project expectations with team members, as well as project leadership.
Create and execute project work plans.
Recorded and managed project issues and escalated where necessary.
Resolved cross-functional issues at project level.
Monitored project progress and performance using MS Project.
On site liaison for project updates, revisions and change orders.
Gathering data to find the GHG emissions for each operation and department
Calculated the Corporate carbon footprint of the garment manufacturing unit for a year by studying the complete life cycle and GHG emissions at each stage.
Suggested and analyzed different means to reduce the emissions and implementation of the same.
Shahi Exports Pvt. Ltd. BENGALURU, INDIA
May 2011 – July2011
Responsibility:
Overlooking Implementation of SAP
Overlooking the production floor productivity
Developing machine attachment database using Access and SQL to keep a track of attachments issued to different production lines
Developed a database to keep track of maintenance schedule of machines
Reduced material movement for two production lines
Arvind Mills Ahmedabad, INDIA
Business Analyst Internship Dec 2010
Responsibility:
Manage project development from beginning to end. Supported PM in defining and implementing project scope, schedule, and reporting and escalation management.
Proactively manage changes in project scope, identify potential crises, and devise contingency plans.
Manage project expectations with team members, as well as project leadership.
Create and execute project work plans.
Recorded and managed project issues and escalated where necessary.
Resolved cross-functional issues at project level.
Monitored project progress and performance using MS Project.
On site liaison for project updates, revisions and change orders.
Work with business owners and department leadership to identify process improvement opportunities.
EDUCATION:
MS (Global Supply Chain Management)
MBA (Marketing and Operations)
BFTech
Certificate in Business Administration Mgmt
Certification in SQL Scripting