NITESH KUMAR
New Delhi
Summary
I have done B.E in Electronics & Communication from Panjab University in Chandigarh. I have more than 9 years of working experience in IT, Retail, Gaming, KPO & Healthcare domain. Expertise in Data Extraction, Data Preparation, Data Modelling, Data Analysis & Reporting. Worked on various projects on Machine learning such as Regression Model , Decision Tree & Classification Models using python. Although, I am majorly using Tableau, SQL, Python & MS Excel in my daily work, but also very flexible to work on any other tools & programming languages which require for a project.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior Analyst
Cactus Communications Pvt. Ltd.
2022.04 - Current
- Designing and development of Tableau Reports
- Creating Customized SQL Queries for various Tableau Reports
- Created a classification model using python on categorising Marketing Costs to analyze effectiveness of various marketing campaigns run within the organisation.
- Handling all theTableau Server maintennace activities and performance issues
- Created Python Script to extract Table names from custom SQL Queries for each workbook in Tableau Reports
- Created some Reports on Tracking Email Marketing Campaigns in Power BI using DAX Calculations
- Provided Key Insights leads to better business decision
- Handled Tableau Server upgrade from version 2020.1 to 2022.1.9
- Created various Dataflows and Datasets for Power BI reports
- Support business, product and marketing teams for ad-hoc analysis and also lead impactful projects to drive data based decision making.
Data Analyst
CRG Solutions Pvt. Ltd.
2021.05 - 2022.03
- Performing Root cause analysis on data issues and recommend data quality controls to resolve issues using core SQL
- Work directly with business users and analysts in comprehending business requirements and modelig appropriate Business Analytics to meet requirements
- Deliver weekly project reports to clients regarding progress, including analysis trends and highlighting any issues
- Derive insights and recommendations from analyses and create story based reports in Tableau
- Collaborate with cross-functional teams to enhance analyses / insights
- Monthly & Weekly Data Uploaded on MS SQL Server using SQL Server Management Studio
- Maintaining Tableau Server admin Tasks which includes Server Backup & Server Clean up
- Created Triggers for Auto Scheduling of Tableau Dashboards along with Dashboard Scheduling on Tableau Server & Tableau Online
- Created Scripts for Automatic scheduled Downloads of Tableau Reports using Tabcmd Commands
- Using Alteryx & Tableau Prep for Data Cleansing and Data preparation & published them on Tableau Server for use as data source for Tableau Desktop.
Data Scientist
Passion Gaming Pvt. Ltd.
2018.09 - 2021.04
- Writing Customize SQL Query to fetch the data and clean it for further analysis and visualization
- Single handedly Created Dashboards in Tableau for several departments which including Marketing, Retention & Customer Service Teams
- Created some regression models using python to predict the players gaming activity on weekly and monthly basis.
- Provide best practices are utilized in delivering Reporting/Analytics Solutions
- Created Target Rake Reports & Cohort Analysis Reports for Retention Team
- Created Different types of Marketing Dashboards based on KPIs like Avg Rake, Churn FTD, CPA & D1, D7, D14, D30Activity of Players
- Provided Deep Analysis of Players Deposits, Played Games & Withdrawals on hourly basis to maximize company's profit
- Created Customer Segmentation of Players to focus more on low performing Users Manage Tableau Online platform and daily monitored refresh of all the dashboards
- Done A/B Testing to identify potential users who can provide maximum ROI without providing bonus.
Senior Contact Discovery Executive
RT Global Info Solutions Pvt. Ltd.
2016.01 - 2018.08
- Data Mining & Research using different sources such as LinkedIn, Jigsaw, Zoom info, Hoovers, One Source, Bloomberg, Reuters, Discover.org etc
- Implementing Research Strategies to pull out the information through search engines
- Analyze and Researching on the US Market on ERP Technologies like SAP, Oracle, JD Edwards
- Design and develop Revenue vs Marketing Spent reports in Tableau
- Doing Market & Financial Research using Bloomberg, Hoover & DCF Database Management
- Verification of Contacts
- Weekly and Monthly data analysis in MS Excel on prospects who converted to leads
- Finding Direct contacts and Email Ids of the prospects and hence generating leads for the business development team.
Jr. Online Marketing Executive
CS Soft Solutions Pvt. Ltd.
2014.12 - 2015.12
- To Identify an overall Internet Marketing and Search Engine Optimization strategy that has a measurable ROI
- To drive more 'organic' website traffic via white hat SEO strategies
- To maximize their footprint on the Internet by making use of social media
- Working on the SEO, SEM, SMO and Increase website conversions
- Google Analytics Report generation and Analysis
- Website Keyword Research, Performance Tracking and Competitor Analysis.
Education
B.E. in Electronics & Communication Engineering -
U.I.E.T
06.2012
Skills
- Tableau
- SQL
- Python
- Power BI
- MS Excel
- Data Analysis
- Alteryx
- SSIS
- R Programming
- SAS
Certification
- Data Science Certication Training - R Programming, Simplilearn, 05/2018
- Data Science With SAS Training, Simplilearn, 03/2018
Timeline
Senior Analyst
Cactus Communications Pvt. Ltd.
2022.04 - Current
Data Analyst
CRG Solutions Pvt. Ltd.
2021.05 - 2022.03
Data Scientist
Passion Gaming Pvt. Ltd.
2018.09 - 2021.04
Senior Contact Discovery Executive
RT Global Info Solutions Pvt. Ltd.
2016.01 - 2018.08
Jr. Online Marketing Executive
CS Soft Solutions Pvt. Ltd.
2014.12 - 2015.12
B.E. in Electronics & Communication Engineering -
U.I.E.T
- Data Science Certication Training - R Programming, Simplilearn, 05/2018
- Data Science With SAS Training, Simplilearn, 03/2018
Similar Profiles
Sachin ShindeSachin Shinde
Senior Process Manager at Cactus Communications Pvt LtdSenior Process Manager at Cactus Communications Pvt Ltd
Mayur LokhandeMayur Lokhande
IT Analyst at Cactus Communications Pvt LtdIT Analyst at Cactus Communications Pvt Ltd
Geemon MathaiGeemon Mathai
Finance Manager at Cactus Communications Pvt LtdFinance Manager at Cactus Communications Pvt Ltd