Taranjeet Singh Gill
Business Analytics enthusiast with a global perspective and a passion for data-driven solutions 🗣📊
Have an interesting project for me to work on? 🚀
Or just want to connect in general? 🤝
Reach out to me via email at:
taranjeetgill737@gmail.com
Location: Dallas, Texas, US
Technical Skills
- Methodologies: SDLC, Agile, Waterfall
- Documentation: FRD (Functional Requirements Document), BRD (Business Requirements Document), SRS (Software Requirements Specification)
- Project Management Tools: MS Project, MS Excel, MS SharePoint
- Language: R, SQL, NoSQL, HTML, Python
- Visualization Tools: Tableau, Power BI
- Analysis Skills: Cost/benefit analysis, Impact analysis, GAP analysis, Risk analysis, SWOT analysis
- Tracking/Other Skills: Jira, Microsoft Visio, HP Quality Center, JAD (Joint Application Development), RTM (Requirements Traceability Matrix), UAT (User Acceptance Testing), Confluence, Figma, SQL, Microsoft Azure
Certifications
Google Analytics
Individual Certification
Lean Six Sigma
White Belt
Education
-
M.S. Business Analytics
University of Texas at Dallas, Dallas, US- Graduated?: May 2023 ✓
- Relevant courses: Database Foundations, Advanced Statistics, Agile Project Management, Supply Chain Strategy, Business Analytics with R, Marketing Web Analytics
-
Bachelors of Commerce (Honors in Taxation),
Barkatullah University, India- Graduated?: May 2018 ✓
- Relevant courses: Business Mathematics, Principles of Statistics, Computer and Information Technology
Experience
HOLT CAT, U.S.A
IT Transformation Business Analyst, March 2024 - April 2025
- Spearheaded the requirements gathering process for 5+ departments, including Marketing, Parts, Service, Safety, and HR, and presented findings to IT leadership to evaluate cross-squad impacts, resulting in a 30% reduction in project approval timelines and improved interdepartmental collaboration.
- Led cross-functional technical discovery sessions with engineering and stakeholder teams to gather, analyze, and document detailed workflows, system integrations, and both functional and non-functional requirements, enabling faster sprint readiness and improved delivery accuracy.
- Collaborated with product owners to craft user stories and epics, facilitated backlog grooming, and proactively removed blockers during sprints—resulting in a 25% improvement in sprint velocity and timely delivery of business-critical features.
- Championed agile best practices by coordinating daily stand-ups, retrospectives, and sprint planning ceremonies, while continuously introducing process enhancements that fostered a culture of iterative improvement and increased team collaboration.
- Extracted and analyzed large datasets using SQL to assess performance trends across multiple departments (HR, Safety, Service).
Uhnder Inc.
Product Analyst Intern, Austin, Texas, May 2022 - Aug 2022
- Worked with Development and Product Management to ensure new functionality met business requirements and performed as designed.
- Created a product roadmap for the career counselor product, including feature development and a communication plan.
- Created a Market Requirement Document by conducting market research and analysis to determine customer needs in collaboration with business and engineering teams to expand the company’s clientele by 35%.
- Ensured meticulous documentation of all project, program, and process development phases and maintained compliance with Company policies, including confidentiality, and safety protocols, resulting in zero policy violations.
- Developed KPIs (key performance indicators) dashboard like On-Time & In-Full, contributing to a 20% faster operations process by increasing visibility.
- Constructed and maintained detailed project plans, risk mitigation strategies, and issue logs in coordination with CoEs, ensuring seamless communication and reducing project risks by 15%.
- Assisted in the completion of the project in strict accordance with requirements, emphasizing cost control, resource utilization, and on-time delivery. Achieved a 98% adherence rate to project specifications and a 15% reduction in project costs.
- Identified and resolved operational gaps, resulting in a 20% reduction in data processing time and a 15% increase in data quality through the implementation of process and system-based improvements.
Kalpataru Power Transmission Ltd.
Business Analyst, India, Dec 2018 – Jul 2021
- Gathered, analyzed, and formulated business requirements for software applications according to functional and project management objectives.
- Administered SharePoint and Smartsheet for permissions, access, business documentation, and status updates as part of team management.
- Conducted thorough analysis of business processes, identified pain points, and recommended process improvements that resulted in a 15% increase in operational efficiency.
- Maintained and kept track of stakeholders’ requests for enhancements and changes using Rational Clear Quest.
- Created ad-hoc reports for users in Tableau by connecting various data sources, multiple views, and associated reports.
- Gathered business requirements to create Tech Specifications, Business Requirement Document, Data Mapping, and validation rules for 5 projects across 3 regions.
- Participated in Review meetings with software developers, QA engineers, Project managers, and suggested enhancements to the existing application from a business perspective.
- Established and fostered relationships with clients and internal stakeholders at all levels, including staff and senior management, to ensure effective communication and collaboration.
- Collaborated with cross-functional teams to analyze and extract important data trends, contributing to a 25% improvement in project outcomes and strategic planning accuracy.
- Supported data collection efforts for materials and financial resources, optimizing resource allocation and utilization. Contributed to a 20% improvement in resource tracking accuracy and decision-making.
- Conducted studies of emerging technologies, staying abreast of industry advancements to inform project decisions and enhance technological innovation within the organization.
Sodio Technologies
Business Analyst Intern, India, Jul 2018 - Dec 2018
- Developed As-Is flow diagrams and To-Be process flow diagrams, then assessed the changes from the current state to identify and deliver the training needs of business users.
- Conducted Impact analysis when there is any change in the requirements and updated the Business Requirements Document (BRD) and Systems Requirements Specification (SRS).
- Engaged in daily Scrum meetings with the Project team and change management team to address the requirement updates, change requests, and responsibilities.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Created and maintained project documentation, including project plans, and requirements documents.
- Conducted timely requirement review sessions with the Stakeholders and end users to ensure product verification.
- Assisted in maintaining high-quality deliverables by conducting rigorous QA testing and engaging stakeholders in UAT, ensuring 100% solution compliance.
- Translated Business Requirements into functional and non-functional requirements using industry standard documentation processes like Data Flow Diagram (DFDs) and UML Diagram (Use Case, Sequence, and activities Diagrams).
- Conducted market research, documented trends in the industry, and built an accessible industry research database for over 100 employees to inform business decisions.
Entrepreneurial Leadership Experience
Vindhyachal Resorts
Hotel Manager, Bhopal, Madhya Pradesh, India, Feb 2014 - May 2018
- Strategic Leadership: Spearheaded the management of Vindhyachal Resorts, displaying a visionary approach to business operations, and fostering a culture of innovation and entrepreneurship.
- Team Building and Development: Assembled and nurtured a dynamic team, emphasizing the hiring, training, and supervision of employees across various departments. Established effective communication channels and performance evaluation systems, resulting in a motivated and highly efficient workforce.
- Client-Centric Approach: Pioneered a commitment to excellence in client services, providing personalized attention to guest needs and concerns. Quickly resolved issues to ensure an exceptional guest experience, while also implementing feedback mechanisms for continuous improvement.
- Revenue Maximization: Applied analytical skills to assess market trends, manage occupancy rates, and implement pricing strategies that consistently maximized revenue and occupancy levels. Managed distribution channels, including online agencies, to optimize sales.
- Innovative Marketing: Led the development and execution of innovative sales and marketing strategies that attracted new customers and retained existing ones. Collaborated with the sales team to target corporate clients, agencies, and event planners.
- Financial Acumen: Demonstrated a keen financial acumen by preparing and managing budgets, monitoring expenses, and maximizing profitability. Regularly analyzed financial data, including revenue reports, profit and loss statements, and cost control measures.
- Quality Assurance and Brand Integrity: Enforced strict adherence to quality standards and brand guidelines, maintaining excellence in service, cleanliness, and operational efficiency through regular inspections and audits.
- Stakeholder Collaboration: Forged productive relationships with local suppliers, vendors, and tourism authorities to secure favorable terms and enhance the guest experience. Actively identified and pursued collaborations and partnerships to promote the hotel and attract new clientele.