Harsh Trivedi Email & Phone Number

Ahmedabad, Gujarat, India

ETL and Data Integration ProjectI have a solid track record of performing ETL processes and creating source-to-target mappings (STTM) to enhance the analytics capabilities of quality assurance teams. By implementing these processes, I supported the team in overcoming significant challenges and improving data reliability. My expertise also extends to performing data cleaning, extraction, and analysis, and assisting in data modeling from relational databases, ensuring the data structure supports robust analysis and reporting.Big Data Analytics and SQL Reporting ProjectIn my role, I have extensively utilized Structured Query Language (SQL) to query large datasets, extract meaningful insights, and design comprehensive technical specification reports. These reports were instrumental in facilitating collaboration with various stakeholders, ensuring alignment on project goals and deliverables. I have hands-on experience working on the Hadoop platform and its ecosystem technologies, including HDFS and MapReduce. Through this, I developed Key Performance Indicators (KPIs) that provided critical insights into operational performance and guided strategic decisions.Automation and Financial Optimization ProjectDuring the COVID-19 pandemic, I automated a vital discount dashboard that became crucial for swift decision-making, increasing sales by 10% and providing real-time insights that helped the business navigate through uncertain times. Additionally, my efforts in maximizing total transaction value resulted in a 2% increase, while reducing discount burning by 3%, leading to substantial capital savings of $1.5 million. To streamline requirements gathering and project documentation, I leveraged tools such as Confluence, Asana, and Jira, ensuring project requirements were clearly documented, easily accessible, and effectively managed throughout the project lifecycle.

Ahmedabad, Gujarat, India

COVID-19 Data Tracking Website Project- Website Creation: Played a pivotal role in designing and developing a user-friendly website for tracking COVID-19 patient data across India. - Data Integration: Integrated data from various sources, ensuring accurate and up-to-date information on COVID-19 cases, recoveries, and vital statistics through thorough data cleaning, mapping, and alignment.- Data Quality Assurance: Conducted exploratory data analysis and preprocessing to maintain data quality, relevance, and reliability, ensuring the information presented was accurate and current.- Data Visualization: Implemented data visualization techniques, using charts, graphs, and interactive elements to present complex COVID-19 data in an easily understandable manner.Contributed significantly to creating a valuable resource that kept the public informed and safe during challenging times by providing real-time tracking of COVID-19 patients in India.Customer Sentiment Analysis Project- Sentiment Analysis Model: Developed and deployed a machine learning model using Python and NLP techniques to analyze customer sentiment from social media and review data, achieving an accuracy rate of 92%.- Data Pipeline Creation: Designed and implemented an automated data pipeline for real-time sentiment analysis, integrating data from multiple sources including social media platforms and customer reviews.- Dashboard Development: Created interactive dashboards using Tableau to visualize sentiment trends and insights, enabling stakeholders to make data-driven decisions.- Stakeholder Collaboration: Collaborated with marketing and customer service teams to provide actionable insights and strategies based on sentiment analysis, improving customer engagement and satisfaction.By leveraging advanced machine learning techniques and real-time data integration, significantly enhanced the organization's ability to understand and respond to customer sentiment.

Ahmedabad, Gujarat, India

Supply Chain Optimization and Business Analysis ProjectI successfully utilized data engineering frameworks to forecast demand and optimize supply chain operations, resulting in a 10% reduction in stockouts and an 18% decrease in expenses. Leveraging SAP for business analysis, I collaborated with stakeholders and QA teams to monitor ad-hoc reports, ensuring alignment with business requirements.Biometric Verification and Customer Loyalty Prediction ProjectI engineered a highly accurate (98%) hand image-based biometric verification model using Python and TensorFlow, applying image preprocessing techniques like normalization, resizing, and cropping to enhance process efficiency. Additionally, I developed a random forest algorithm to identify loyal customers and predict their purchasing likelihood, providing actionable insights for targeted retention strategies.Agile Scrum Facilitation and QA Testing ProjectIn a fast-paced environment, I facilitated scrum events such as daily standups, backlog grooming, sprint planning, and root cause analysis, fostering continuous improvement. I designed comprehensive test cases for UAT and PAT testing, along with user stories for software deployment, proactively preventing future issues and ensuring smooth rollouts. Working collaboratively with cross-functional teams, I contributed to research and quality assurance efforts, consistently delivering optimal solutions.