Mayur Patel
Associate Project Lead
Address: A-**4, Suvas Residency, Nikol, Ahmedabad, Gujarat Mobile: +91-972**-***** LinkedIn: https://www.linkedin.com/in/mayur-patel-06744224/ Email: *************@*****.*** SUMMARY:
• 15+ years of experience offering a proven record of success leading all phases of diverse technology projects like feasibility study, requirements gathering, project planning, system analysis design, development, integration and testing, installation, acceptance, maintenance and documentation
• Proficient at interacting with Product Owner, International Clients and Development Team for proper execution of the project and Software Development Life Cycle using ISO 9001:2015 and Agile/Scrum methodology
• Adept at leading cross-functional teams, mentoring junior developers, and collaborating with stakeholders at all levels to ensure the successful execution of projects
• Exceptional leadership and team-building skills, coupled with a talent for collaborating with stakeholders to align technology solutions with business objectives
• Proven ability to optimize data architecture, ensuring scalability, performance, and security
• Expert in Project management and data domain with various tasks such as data analysis, data cleansing, data transformation, pipelines and visualization
• Certified Scrum Master
EXPERIENCE:
Associate Project Lead
SPEC-INDIA 01/04/2023 – Present
1. Project Lead Machine Football (UK-based client)
• Designed and implemented a full end-to-end ETL pipeline from scratch using Apache Airflow, leading a team of 3 data engineers.
• Developed and optimized scalable transformation logic within Airflow DAGs to ensure maintainable and efficient workflows.
• Scheduled and orchestrated daily ETL processes, improving data delivery timeliness and reliability by 25%.
• Built and deployed REST APIs using Azure Functions and Docker containers, enabling real-time calculation of player attributes.
• Transformed raw MongoDB data into SPADL (Soccer Player Action Description Language) format and generated VAEP (Valuing Actions by Estimating Probabilities) datasets using Azure Databricks.
• Trained, monitored, and managed machine learning models end-to-end with MLflow, leveraging Scikit-learn, Pandas, and Matplotlib for model experimentation and analytics.
• Established CI/CD pipelines with Azure DevOps, enabling version control, automated deployments, and seamless team collaboration.
• Skills: Airflow, Azure Databricks, Python, Fast API, PostgreSQL, MongoDB 2. BI Project Manager Fursan Travel (Saudi Arabia-based travel industry client)
• Implemented Business Intelligence solutions, integrating data from travel booking platforms into Power BI reports for flight, hotel, sales, financial, and audit analyses.
• Built Freshdesk performance dashboards, enabling customer service performance tracking and reporting.
• Analysed business and operational data to provide actionable insights for the Revenue Manager and executive leadership, including CTO and COO.
• Developed, published, and maintained Power BI reports, ensuring data accuracy and usability for business stakeholders.
• Acted as a primary liaison for client communication, gathering requirements, managing expectations, and delivering data-driven solutions.
• Skills: Power BI, SQL, Data Analysis, SSRS, Business Intelligence, Stakeholder Management 3. BI Project Manager Sure Tree (Nigeria-based insurance client)
• Managed data engineering initiatives to enable data-driven decision-making for an insurance client in Nigeria.
• Implemented Azure Functions (C#) to extract and process Google Analytics data, improving visibility into website performance and user traffic insights.
• Analysed complex datasets to identify patterns and provided actionable insights to management for strategic planning.
• Enhanced and published interactive dashboards in Power BI, enabling real-time reporting and business intelligence.
• Collaborated directly with clients to gather requirements, clarify business needs, and ensure alignment between data solutions and business goals.
• Skills: Azure Functions (C#), Google Analytics, Power BI, SQL, Data Analysis, Client Communication 4. Project Lead ZooM SFA (Colombia-based FMCG client)
• Managed end-to-end business intelligence reporting for an internal Salesforce automation product using Power BI, analysing sales, order, route, and employee performance metrics to support strategic decision-making.
• Analysed complex datasets and delivered actionable insights to senior management, improving visibility into key business KPIs.
• Designed, developed, and released interactive reports and dashboards in Power BI, enabling integration into the client’s back-office web portal.
• Acted as primary point of contact for client communication, gathering requirements, managing expectations, and ensuring successful project delivery.
• Skills: Power BI, Salesforce Automation, Data Analysis, Project Management, Client Communication
5. Lead Data Engineer IMAPAC (Singapore-based Pharma client)
• Engaged directly with stakeholders to gather and refine business requirements for pharma research tracking.
• Developed three interactive reports to monitor the pharmaceutical research pipeline.
• Lead a team of 3 members across the full project lifecycle, from requirement gathering to report delivery, ensuring accurate role-based access.
• Administered Power BI for external users, implementing secure, role-wise access controls and governance.
• Skills: Power BI, SharePoint, Power BI Administration Team Lead
SPEC-INDIA 01/01/2016 – 01/04/2023
1. Principal VC++ Engineer PepsiCo (Spain-based FMCG client)
• Developed the Last Mile Tool (LMT) to enable distributors to track inventory levels across warehouses, distributors, and sales channels, reducing waste and minimizing out-of-stock situations.
• Implemented Rebex SFTP for secure communication, replacing legacy Afaria-based communication, significantly improving reliability and operational efficiency.
• Managed application development in VC++, ensuring high performance and scalability for enterprise-wide deployment.
• Facilitated client communication to gather requirements, provide technical solutions, and ensure alignment with business needs.
• Skills: Visual C++, MFTool API, Raima Database, Rebex SFTP (Client and Server), Shell Script, Client Communication
2. Lead VC++ Engineer PepsiCo (Greece-based FMCG client)
• Developed Route Power, a handheld computer application using Visual C++ and MFTool API, enabling GPS, scanner, and Bluetooth printing functionality to support route sales, pre-sales, and delivery operations.
• Enhanced operational efficiency by 25% through automation of sales workflows, from stock loading and route management to settlement and next-day preparation.
• Designed application modules to guide direct store delivery personnel through the end-to-end customer operations process, including invoicing and receipt generation.
• Built a Windows-based application for Handheld Computers (HHC), integrating with Raima Database for reliable offline and online transaction handling.
• Skills: Visual C++, MFTool API, Raima Database, Windows Application Development, Client Communication
3. Product Lead ZooM SFA (Laos-based FMCG client)
• Contributed to the ZooM Sales Force Automation solution using C#.NET, JavaScript, and SQL Server.
• Streamlined sales routines, surveys, customer feedback, and MIS reporting, resulting in a 20% increase in sales team productivity.
• Designed and optimized user interfaces with jQuery, HTML, and CSS, improving usability and system adoption among field sales representatives.
• Collaborated with stakeholders to define requirements and deliver scalable features aligned with business objectives.
• Skills: C#.NET, JavaScript, jQuery, HTML/CSS, SQL Server 4. Lead Engineer Exide VTS (India-based Battery Manufacturing client)
• Built a Vehicle Tracking System (VTS) for fleet management using GPS, cellular technology, and enabling real-time vehicle monitoring.
• Reduced overall fuel costs by 15% through optimized route tracking and improved fleet utilization.
• Developed the solution with a robust front-end and back-end integration, ensuring high system availability and scalability.
• Skills: jQuery, C#.Net, JavaScript, HTML/CSS, SQL Server Software Engineer
Fintech Global Center 01/08/2010 – 01/12/2015
• Developed a file parsing application for CME Exchange using C# and SQL Server, processing LZO files to create product-wise directories and charts, improving data retrieval efficiency by 30%.
• Built a trading system for TruMid using Beast Framework and C#, enabling real-time financial analytics and online trading, increasing transaction throughput by 20%.
• Developed Markitwire Trade Blotter (MTB) using Java and FpML, automating deal creation and management for credit default swaps, interest rate swaps, and options, reducing manual errors by 25%.
• Developed ICE Link (STP) system using C# and the FIX protocol, automating deal creation and management, improving trade processing speed by 30%.
• Created Trade Capture application for post-trading processes using C# and SQL Server, managing trading details and generating confirmation reports, streamlining compliance by 20%.
• Built a PDF editor for editing confirmation reports using Java and Visual Studio, enhancing report customization and reducing editing time by 15%.
• Skills: Visual C++, C#, FpML, Beast Framework API, Java, GEL IDE, Visual Studio 2010, SQL Server SKILL SET:
• Programming Languages: C, Visual C++, C#.NET, Python
• Database Technologies: SQL Server, Oracle, PostgreSQL, MongoDB, Raima DB
• Business Intelligence & Data Integration: Power BI, Power Query, DAX, Power BI Embedded, SSRS, Azure Data Factory, Airflow, Azure Data Bricks
• Web Technologies: HTML, CSS, JavaScript, JSON, Web Services, jQuery
• Version Control Systems: CVS, Pure CM, SVN (Apache Subversion), Git
• Project Management & Collaboration Tools: Microsoft Excel, MS Project, Trello, Pivotal Tracker, Jira, In-house task/resource tracking tools
• Soft skills: Effective Communication, Inspiring Leader, Creative CERTIFICATIONS:
• Certified ScrumMaster from Scrum Alliance
EDUCATIONAL BACKGROUND:
• Bachelor of Engineering in Computer from Gujarat University, with 60.24% in 2010
• H.S.C from H.S.E.B, Gujarat with 71.33% in 2006
• S.S.C from G.S.E.B, Gujarat with 69.29% in 2004