Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Prathap Kumar

Prathap Kumar

Senior Data Engineer and Analyst

Summary

Detail-focused Senior Data Analyst with 7+ years knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Aiming to utilize my Data engineering skills to achieve the company's business goals while sticking to vision, mission, and values.

Overview

7
7
years of professional experience

Work History

Data Analyst

Vistaar Finance
2 2019 - Current
  • Work with Business Intelligence tools such as NANOBI & Tableau and Business Objects to develop reports and provide insights to stakeholders
  • Creating End to End Business Analytics solutions using BI Tool
  • Strong knowledge in designing and developing dashboards by extracting data from different sources like SQL Server, Oracle, Flat Files, Excel files, MongoDB, etc
  • Gathered & analyzed business user needs, and translated them into proper technical requirements, implementation, and delivery of solutions/projects as per the requirement
  • Dashboard and data validation as per the business logic shared by the clients
  • Proactively manage relationships with business stakeholders to ensure relevancy and timeliness of delivery to business goals
  • Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions
  • Administered and monitored databases to identify and resolve problems with diverse servers
  • Worked closely with various departments to verify database operation maintains alignment with company standards
  • Coded, edited, and installed stored procedures for populating databases and scripts
  • Created data models and database designs to deliver on project requirements and performance objectives
  • Maintained data integrity through diligent database design and development, eliminating error and risk.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
  • Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.
  • Developed and maintained data warehouses and data marts to support business operations.

Data Analyst & BI Consultant

Nanobi Data and Analytics
02.2017 - 02.2019
  • Worked on ETL Process, Design, Development, Testing, and Implementation of Business Intelligence applications
  • Strong knowledge in designing and developing insights by extracting data from different sources like SQL Server, Oracle, Flat Files, Excel files, etc
  • Involve in Onsite-Offsite coordination in delivering Business Intelligence Solutions and created a training manual for companies to understand and use the tool, conducted training programs, and interacted with customers/partners at individual/group levels
  • Experience in dimensional & relational concepts like Star-Schema Modelling, Fact and Dimension tables, Stored Procedures, Tables, Views, Indexes, Joins, Sub-queries, different date functions, writing complex queries, CTE, ETL Process for different clients
  • Dashboard and data validation per the business logic shared by the clients
  • Analyzed operational improvements against KPIs to measure progress
  • Developed SQL queries to obtain complex data from tables in on-site and remote databases.
  • Utilized data visualization tools to effectively communicate business insights.
  • Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.

Support Engineer

Deepbiz Technologies pvt ltd
02.2013 - 02.2016
  • MS-Sql backend support

Education

Bachelor's of Engineering - Electronics And Communications Engineering

Govt.Engineering College
Kushalnagar, India
04.2001 -

Skills

MS-SQL

Languages

English
Kannada

Timeline

Data Analyst & BI Consultant

Nanobi Data and Analytics
02.2017 - 02.2019

Support Engineer

Deepbiz Technologies pvt ltd
02.2013 - 02.2016

Bachelor's of Engineering - Electronics And Communications Engineering

Govt.Engineering College
04.2001 -

Data Analyst

Vistaar Finance
2 2019 - Current

Similar Profiles

CREATE PROFILE
Prathap KumarSenior Data Engineer and Analyst