logo

Powered by
Codebasics DA Bootcamp

Hello, I am

kumar raja vanumu.

1

Excel Project

About Me

I started my career as an SAP BW Consultant at Maberu Creations, where I was involved in data migration projects—handling tasks like data extraction, cleaning, and transformation. Later, I joined Wipro, where I was initially selected for a data analysis role but continued to work primarily on data migration.
Although this experience gave me a solid foundation in working with large datasets, I realized the need to upskill in core data analytics. To focus on this, I took a planned career break for professional development.
During this time, I built hands-on expertise in tools like Excel, Power BI, SQL, and DAX, and worked on self-driven projects to strengthen my analytical thinking. I'm now actively seeking data analyst roles where I can contribute to data-driven decision-making and generate real business impact.

Key Skills

Power BI

Excel

SQL

Python

My Experience

Experience
Mar 2022 – Sep 2024

Wipro, Coimbatore - Data Analyst

       Delivered SQL migration solutions as part of the Wipro Data Intelligence Suite (WDIS) project, converting queries across RDBMS platforms such as Oracle, SQL Server, and PostgreSQL.

       Engineered a Python script leveraging regex in PyCharm to automate 80% of SQL conversions within the Smart Pro Tool, boosting team efficiency by 150% and saving 20 hours weekly.

       Revamped over 500 complex SQL queries (SELECT, INSERT, UPDATE, DELETE, REVOKE) across Oracle, SQL Server, and PostgreSQL, guaranteeing syntactic precision and optimized functionality to improve data integrity.

       Gained hands-on experience in cross-platform SQL dialects, query optimization, and automation in real-world enterprise workflows.

       Performed post-migration testing by validating SQL queries on the target platforms to ensure successful conversion.

       Built Power BI dashboards with key KPIs for high-level client analysis, enabling faster issue detection. Used Power Query in Excel for efficient data cleaning, reducing manual effort by 30%.

       Analyzed large datasets with Excel functions (VLOOKUP, INDEX-MATCH) to support financial planning.


==================================================================================================================

Apr 2018 - Feb 2022

Maberu Creations, Visakhapatnam – Data Extraction and Loading (ETL) – SAP BW

       Developed ETL processes using SAP BW to consolidate raw data from company databases, built data models with star and snowflake schemas resulting in the first centralized data repository.

Awards & Certificate

img

Excel: Mother of Business Intelligence

img

Get Job Ready: Power BI Data Analytics for All Levels 3.0

img

SQL Beginner to Advanced For Data Professionals

img

Python: Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.