Summary
Overview
Work History
Education
Skills
Accomplishments
Toolstechnologies
Training
Languages
Timeline
Generic
Praveen Kumar Singh

Praveen Kumar Singh

Gurgaon

Summary

IT professional with 12+ years of experience in the industry with 6+ years of experience in data science and data analytics. Good knowledge of Data Processing, Mining and Management on complex data and optimize the SQL queries for large and complex data set, good knowledge of python scripts for pulling data from social platform using RESTFUL API. Strong experience in GCP platform and its service like BigQuery , Cloud Storage, cloud function and many more. Also having experience in handling clients and stakeholders to meet the business expectation and drive insights to help them to increase their revenue.

Overview

12
12
years of professional experience

Work History

Manager (Marketing Science)

Annalect India
01.2024 - Current
  • Annalect India is a Integral part of Omnicom Group, the global leader in marketing and communications and one of the largest media and advertising agency holding companies in the world
  • Annalect play a key role for the group companies and their branded networks by providing stellar products and services in the areas of Media Services, Marketing Science (data & analytics), Technology, Creative Services, Market Research and Business Support Services
  • Client: Global bakery Company in Mexico Tool & Technology: SQL, Database, Python, GCP Responsibility: My responsibilities for this role are: Design and develop data solution & manage in data base for reporting and insights
  • Optimize the SQL queries for complex data set
  • Robust the data management process which includes automation, security , data Validation, reporting and avoid duplication of data
  • Manage the Data Pipeline in GCP using GCP functions, BQ, Storage and composer
  • Collaborate with cross-functional teams and business stakeholders to understand their data needs and requirements
  • Perform data analysis to identify trends, patterns, and insights that drive business decision-making
  • Develop and deliver clear and concise reports and presentations that communicate technical data flow and insights in business language
  • Create and maintain data visualization dashboards to track key performance indicators (KPIs) and present them to stakeholders
  • Strong problem-solving skills and attention to detail
  • Help team on technical aspects on their deliverables
  • Excellent organizational and time-management skills.

Lead BI Analyst

USEReady
04.2024 - 01.2024
  • USEReady is a Tableau Gold partner headquartered in NYC
  • USEReady was recognized as “Partner of the year” by Tableau Software
  • USEReady is also a Global Services alliance partner with Tableau and delivers several engagements on behalf of Tableau globally
  • Client: Leading global company specializing in Digital Marketing Title: Calls and Requests related analytical data using EDA and dashboard creations
  • Role: Lead BI Analyst Tool: PostgreSQL, AWS, Python, Looker and Datorama Responsibilty: My Role and Responsibilities were: Optimize and developed the existing finance SQL script which help media team to analyze the spend allocation across multiple channels
  • Automate the QA process to find the discrepancies of media KPI's
  • Design and implement the dashboard migration process from looker to Datorama
  • Standardize the media taxonomy and date governance compliance
  • Handle multiple clients and meet their expectation
  • Mentor the team on technologies which help deliverables on time with accuracy
  • Develop and deliver clear and concise reports and presentations that communicate technical data flow and insights in business language.

System Analyst

Cybage Software Pvt. Ltd.
11.2020 - 04.2022
  • Cybage software Pvt Ltd is a global software product engineering services organization, that designs and provides services in technology, strategy, and operations
  • Our scientifically-driven, data-oriented, and delivery-focused approach enables us to spot unmet needs, deliver concrete breakthrough products and services, and make organizations more innovative and agile
  • We work zealously with you, side-by-side building your institutional capabilities to better understand the market, uncover customer and user insights, evolve and create exceptional customer experiences, and successfully bring them to market
  • Client Name: Groupm Responsibilty: Writing a Python script to fetch the data from Restful API and store in common platform
  • Normalize the data which is coming from different data source
  • Generated the new datasets by combining the data from multiple data sources using SQL queries for predictive modeling
  • Developed an action plan in creating the ML model to predict the harmonized product, category with accuracy more than 80%
  • Visualize the data as per client requirement using tools like Datorama, Google DataStudio, tableau etc.
  • Proposed analytical features recommendation and integrated them with exiting model to improve accuracy
  • With the help of ML we track of its competitors who dominate a particular market, which in turn helps Colgate to trade in multiple markets efficiently
  • Interact with stakeholders to get their requirement
  • Team handling capabilities and help them in their blocker in tasks.

Technical Lead

M C Saatchi Mobile India LLP
02.2019 - 11.2020
  • M C Saatchi Mobile India LLP is registered company in India whose parent company is M&C Saatchi Performance in London(UK), organization is a global digital media agency that takes a human approach to connect brands with people, across all channels
  • Its innovative media strategies are underpinned by data, compelling creative and informed media buying to deliver business growth for its clients
  • I joined here as Technical lead
  • Responsibilities: Collected the data form different sources and create the database using AWS, SQL & python scripts
  • Create the data model for API from multiple data sources(like email,SAN platform, attribution latform etc.) by using python script
  • Using AWS and SQL queries to prepare the database and make the data standardized as the per the requirement
  • Clean the data by using Python Script using pandas, numpy etc.
  • Libraries
  • Create the Rich Dashboard in Datorama with multiple pages to create compelling dashboards to deliver actionable insights
  • Perform the Analysis on data and provide the insights to client about optimization, performance and efficiency
  • Responsible for interaction with business stakeholders, gathering requirements and timely delivery of reports
  • Presented and communicated the findings in an understandable and actionable way tailored to the audience and customer's needs

Team Lead

Akal Infrormation System Ltd
01.2013 - 01.2019
  • I was hired by Akal information system ltd and deputed to client location “National Informatics Centre (NIC)” which is an attached office under Ministry of Electronics and Information Technology (MeitY), Government of India
  • NIC provides infrastructure to help support delivery of Government IT services and delivery of some of the initiatives of Digital India
  • Responsibilities: Working on end to end project modules of Data Ingestion, Data Cleansing, Data Preparation, Data Splitting, Model Preparation and validation
  • Involved in working with distributed computation of large datasets, data retrieval, data preparation, data cleansing, modelling, exploratory analysis, predictive modelling, model tuning and optimization etc
  • Provide analysis and insights on the data and proactively asking for any data missing that can have impact on improving accuracy
  • Provide exploratory data analysis report and insights like variable importance, outliers or any anomaly, pattern discovery, hypothesis testing report, relationship among variables, etc
  • Interacting with client to explain the data models and showcasing the technical capabilities.

Education

B-Tech(ECE) -

Bharti Vidyapeeth's College of Engineering
01.2010

Skills

  • DataBase Management
  • Data Warehouse
  • Python, SQL
  • GCP, AWS
  • Visualization tool(Looker, Datorama, PowerBI)
  • Complex Problem-Solving
  • Project Management
  • Teamwork and Collaboration
  • Team building
  • Business Analysis and Reporting

Accomplishments

  • Design, develop, implement and maintain data solutions, troubleshooting as required.
  • Taken the lead on data process and timely delivered with quality of work with good accuracy.
  • Managed Team and help them on efficiency, optimization and ways of improvement on their tasks.
  • Worked closely with clients and stakeholders to support them for project deliverables.
  • Delivered best in class projects that help clients to support the wider department.

Toolstechnologies

  • Data Visualization: Datorama, Data Studio, Tableau Desktop, Power BI, Looker, Amazon QuickSight
  • Database: PostgreSQL, Big Query, Redshift
  • Programming Languages: Python, R, Java
  • Cloud Technologies: GCP, AWS
  • Data Visualization Tool: Datorama, Power BI, Tableau, Looker, Google data Studio, Amazon QuickSight
  • Development Platform: Github/Gitlab
  • Reporting Tools: Microsoft Office
  • Management: Client handling & their stakeholder, Team Management, timely deliverable.
  • Project Management Technology: Jira, Agile

Training

  • Datorama Certified - 2019
  • ML Training - 2018
  • Matillion - 2023

Languages

English
Bilingual or Proficient (C2)

Timeline

Lead BI Analyst

USEReady
04.2024 - 01.2024

Manager (Marketing Science)

Annalect India
01.2024 - Current

System Analyst

Cybage Software Pvt. Ltd.
11.2020 - 04.2022

Technical Lead

M C Saatchi Mobile India LLP
02.2019 - 11.2020

Team Lead

Akal Infrormation System Ltd
01.2013 - 01.2019

B-Tech(ECE) -

Bharti Vidyapeeth's College of Engineering

Similar Profiles

CREATE PROFILE
Praveen Kumar Singh