Pawankumar Puthran

Pawankumar Puthran

$40/hr
Data-Driven Growth | Business Intelligence & Analytics Leader
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
35 years old
Location:
Pune, English, India
Experience:
13 years
PAWANKUMAR PUTHRAN Pune, Maharashtra, India |-| - (Immediate joiner) SUMMARY Versatile Data & Analytics Leader and Cloud Architect with over 13 years of experience driving business intelligence, cloud solutions, and team leadership. Adept at delivering scalable data architectures, actionable analytics, and aligning technical strategies with business objectives. Proficient in Google Cloud Platform (GCP) and big data technologies, with a strong track record of leading cross-functional teams to develop innovative data-driven solutions. Skilled in stakeholder management, data integration, and governance frameworks, with hands-on expertise in BigQuery, Terraform, Kubernetes, and CI/CD pipelines. WORK EXPERIENCE Engagement Manager | Fractal.AI (formerly Fractal Analytics), Pune | Oct 2023 – Nov 2024 • • • • • Managed end-to-end delivery of data and cloud solutions for enterprise clients, leveraging GCP services and advanced analytics. Spearheaded a team of 15+ professionals, integrating cloud-native data pipelines and delivering actionable insights. Boosted operational efficiency by 10% through BigQuery performance tuning and ETL automation. Collaborated with stakeholders to design and implement data governance frameworks, enhancing compliance and security. Achieved a Net Promoter Score (NPS) >75, driving client satisfaction through seamless project execution. Senior Consultant | Fractal Analytics, Mumbai | Apr 2018 to Sep 2023 • • • • Architected data platforms integrating Dataflow, Dataproc, and BigQuery, streamlining analytics workflows and reducing processing time by 30%. Established cloud infrastructure using Terraform, automating resource provisioning for large-scale deployments on GCP. Enhanced data governance by implementing IAM policies and audit logging, ensuring compliance with enterprise standards. Designed and executed advanced BI solutions using Power BI, Tableau, and Looker Studio, empowering business users with self-service analytics. Consultant | Fractal Analytics, Mumbai | Apr 2014 to Mar 2018 • • • Developed and optimized data pipelines using Python, SQL, and BigQuery, delivering insights with minimal latency. Created dashboards and reporting tools integrated with GCP datasets, increasing decision-making efficiency by 25%. Automated reporting workflows with Excel VBA and Python, reducing manual efforts by 30%. Analyst | Fractal Analytics, Mumbai | Apr 2012 to Mar 2014 • • Supported enterprise reporting for finance and insurance clients, building BI solutions with Tableau, Excel, and BigQuery. Delivered optimized reporting mechanisms, enhancing data accessibility and accuracy. Trainee Analyst | Fractal Analytics, Mumbai | Sep 2011 to Mar 2012 • • Automated custom reporting tools using Excel/VBA/Tableau, focusing on automating key financial processes. Gained foundational experience in data analytics, visualization, and business intelligence. EDUCATION • • Post Graduate Diploma (Computer Application) | IGNOU (Distance) - 2014 Bachelors in Science (I.T.) | Mumbai University – 2011 TOOLS & SKILLS • • Technical Expertise o Architecture Cloud Platforms: Google Cloud Platform (BigQuery, Cloud Storage, Cloud Composer, Dataflow, Pub/Sub, Looker Studio) o DevOps: Terraform, Kubernetes, Docker, CI/CD pipelines, Cloud Build, GitOps o Programming: Python, SQL, JavaScript, Go, Shell scripting o Data Engineering: ETL/ELT pipelines, Data Modeling, Data Governance, DBT, Databricks o Analytics & Visualization: Power BI, Tableau, Looker Studio, Advanced Excel, Fabric Other Skills o Data strategy, Agile/Waterfall methodologies, Stakeholder management, Strategic planning o Leadership, problem-solving, collaboration, and communication skills KEY PROJECTS • • • • • AMEA Data Hub Program (AMEA) - Fortune 500 CPG major o Led the support program, integrating data from over 50 sources to track 2500+ KPIs for 600+ users across the AMEA region leveraging BigQuery & GCS. Streamlined data accessibility and reporting, reducing time-to-insight by 30%, and enhancing decision-making at the market & regional level. o Navigated through different market specific projects to foster smooth operations, for instance – ▪ RSA Consumption – Enabling secondary sales reporting across South Africa market using third party vendor API based data. ▪ ANZ TPM – Optimizing, planning, execution and analytics of promotional activities for Australia & New Zealand market which leverages data from SAP, Salesforce TPM, Manual files, etc. This helps streamline sales processes and enhance decision making for trade promotions and drive better ROI on marketing. o Established & enforced pillars of Governance & Sustainability for both Internal & External stakeholders including but not limited to data quality, security & compliance with regulations. Project MARCO (Global) - Fortune 500 CPG major o Orchestrated & developed a global analytics initiative, to unify reporting capabilities across 20+ data sources and 1000+ KPIs. Spearheaded the integration process, resulting in a 25% reduction in report generation time and empowering global teams with quicker insights. o Guided the team on technical and development best practices to ensure quality deliverables. Trade Promotion Optimization (Canada) - Beverage giant o Conceptualized a tool which boosted sales by 15% and increased annual revenue through data-driven promotion optimization. o Formulated the baseline calculation using the sales volume and promotion details to determine incremental sales/uplift to generate insights on the promotion program. E-commerce Reporting (Global) - Fortune 500 CPG major o Designed and implemented a Global E-commerce Reporting solution to consolidate data from 5+ platforms, providing real-time insights across 50+ markets. o Directed cross-functional teams to build automated dashboards, standardize KPIs, and ensure data accuracy by collaborating with data engineering teams. o Reduced reporting time by 30%, boosted e-commerce revenue by 15% through targeted optimizations, and empowered stakeholders with self-service analytics tools. Brand Growth (US) - Fortune 500 CPG major o Built a dashboard which helped Brands achieve 20% revenue growth and a 5% market share increase by refining brand strategies across key markets. INTERESTS & LANGUAGE • • Interests: Travel, Hiking, Dance, Cricket Language: English (Proficient), Hindi (Native), Tulu (Native)
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.