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
Bangalore
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
Bangalore
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
Bangalore
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
T-SQL
Oracle
Data Warehousing
ETL –Process
Data Analysis
Data Modeling
Microsoft Office(Excel,Powerpoint,Word,Google sheets)
Data Visualization –Dashboard Reporting
Good knowledge of - R, Python
Data Visualization and Presentations
Analytical Problem Solving
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