SQL
Naveen Kumar MC
Business Intelligence Engineer
Bangalore,Karnataka
Summary
Experienced Automation and BI Engineer with over 10 years of experience in Market research. Excellent reputation for Automation, Tools development, resolving problems and improving customer satisfaction.
Overview
10
10
years of professional experience
Work History
Business Intelligence Engineer
Amazon.com
Bengaluru, Karnataka
05.2016 - Current
- Automating recurring works of tracker study and build in-house automated pipelines and systems to prevent vendor intervention as much as possible.
- Identifying appropriate Data sources and interacting with multiple Redshift Data warehouse tables and writing SQL scripts to extract and prepare data that could be potentially used for further analysis.
- Creating Redshift Tables and views to include data from multiple tables as per Business requirement and managing tables.
- Interacting between S3 and Redshift tables to publish data from Tables into S3 or Load data from S3 to Redshift Tables.
- Writing SQL scripts to identify root causes of anomalies and fixing issues through appropriate methods.
- Setting up data pipeline, building ETLM, and scheduling jobs to extract, transform, load data periodically.
- Building Tableau and QuickSight interactive dashboards and data visualizations to include Key Performance Indicators (KPI), Key metrics, Funnel Metrics, Perceptions, Trends etc.
- Projects:
- Tracker end to end Automation: Built automated pipeline which fetch raw data received from vendor, data cleaning, data manipulating, data aggregating and publishing it into Dashboard and reports.
- Brand Open-end coding: Built automated scripts which will map open end responses (verbatim) from raw data with historic data and assigns pre designated brand code.
- Built statistical tool for significance data testing like Hypothesis, Independent and Dependent testing at 90% and 95% Confidence level with One tail and Two tail testing.
- Input forms: Built Excel based input form which captures campaign details from Researchers and ingest data into Redshift tables.
- SharePoint Search Engine: Built Excel based tool which will search for key word(s) entered in file name and file titles from multiple SharePoint accounts and provides list of documents matched by search with document location and one click like to open file directly and with other features.
- BI dashboard: Built automated & interactive dashboard that tracks and provides information on Key Performance Indicators.
- One of this dashboard is useful in understanding Customers, Marketplace maturity, comparison of marketplaces etc.
- And other one helps to understand Key metrics at campaign level and comparison of multiple campaigns.
- ETLM set-up: Building pipelines, setting up ETLM process and scheduling jobs to Extract, Transform, Load data periodically as required.
Market Analyst
IDC Center for Consultancy & Research
Bengaluru, Karnataka
04.2015 - 05.2016
- Creating tools & Dashboards as per requirements of stakeholders.
- Tools that create Input Models Template & QC files, which helps in data accuracy.
- Tools to compare historical data & Create forecast as per users guidelines.
- Uploading Quarterly data to internal data server.
- Projects:
- Forecast Tool: Built tool which fetch historic data from internal server and predicts future three months data and re-uploads into server.
- Input Models Tool: Built tool which fetch data selected by researcher using dropdowns from internal server and allows to make changes of data as per researcher’s findings and re-upload data into internal server.
Data Visualization – Senior Executive
Blueocean Market Intelligence Pvt. Ltd
Bengaluru, Karnataka
09.2011 - 04.2015
- End-to-end development of Tool from requirement analysis to system study, designing, coding, testing, de-bugging, documentation and implementation.
- Responsible for functional and technical feasibility study.
- Developed and designed Solution as per process requirement using Automation tool and VBA.
- Provide support to users during UAT (User Acceptance Testing) and debug Root Cause of any issue for tool/dashboards developed.
- Responsible for successful deployment of project at client’s end.
- Coordinating with Ops team and stakeholders in Project Cycle.
- Projects:
- Lenovo Brand Consideration Tracker: Studying brand consideration for Lenovo monthly.
- End to end, multi-country project involving range of activities in primary research domain.
- Myntra Brand Tracker Research: Track performance of key brand health metrics like Awareness, Consideration, Familiarity and Preference of myntra.com across major Indian cities on monthly basis.
- Little People Zoo Brand Landscape Study: Research conducted in USA for mothers of kids aged between 12-60 months old to understand pattern of growth and what are most favored concepts desired by parent to her kids.
- Logitech Brand Tracker: Studying perception, requirements, usage pattern and familiarity about gaming mice, gaming keyboard, gaming headsets and gamepad controllers viz-a-viz its competitors based on its ownership/loyalty/age and different demographics of gamers in USA, Germany and China.
- Flipkart Brand Tracker: Studying online shopping patterns of buyers through website or mobile app or offline shopping.
- Another parallel study was conducted during Flipkart Big Billion Day campaign to study awareness and demand among buyers.
- Hershey’s Brand Equity Study: Analyzing purchase pattern of Hershey’s products in USA through both retail and online channels.
- Loving Family Doll House Study: Study conducted by Doll house toys brand in USA for mothers of girls to understand their purchase pattern and understanding their expectations from doll houses for their daughters.
- YouTube Music Driver Survey: Study conducted in USA to understand daily internet usage patterns of youth population through Google and other platforms.
MIS Executive
C-Cubed Solutions Pvt. Ltd
Bengaluru, Karnataka
09.2010 - 04.2011
- Creating weekly and monthly Automated reports using Excel formulas and VBA.
- Generating Excel reports based on sales daily and send automated mail to team leaders.
- Tracking customer’s issue status, customers connect back, mail sent report etc.
- Training new joiners with reports & excel tools.
Education
Master of Science - Information Technology
Bachelor of Computer Application - undefined
Skills
Knowledge of SQL, Python, MS Excel VBA to build Automation
Knowledge of SQL, Redshift, S3 to extract, validate load, publish data
Knowledge of SQL, Python, MS Excel to aggregate and analyze data
Knowledge of TABLEAU, QuickSight, Power BI, Microsoft Excel to include making charts, data manipulation, etc
Setting up data pipelines and building ETLM set-up to extract, transform, load data
Retrieving and aggregating data from multiple sources and compiling it into digestible and actionable format
Diving deep into data to find solution for Business problem and provide insights
Software
SQL Workbench
Redshift
S3
Python
PyCharm
HTML
Automation
ETML
Tableau
QuickSight
Power BI
Advance Excel with Macros
MS Access with Macros
MS PowerPoint with Macros
Bash
Timeline
Business Intelligence Engineer
Amazon.com
05.2016 - Current
Market Analyst
IDC Center for Consultancy & Research
04.2015 - 05.2016
Data Visualization – Senior Executive
Blueocean Market Intelligence Pvt. Ltd
09.2011 - 04.2015
MIS Executive
C-Cubed Solutions Pvt. Ltd
09.2010 - 04.2011