Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

AKANSHA RAI

Pune

Summary

Results-driven Data Warehouse and BI Developer with proven skills in ETL processes, SQL optimization, and BI reporting tools. Out-of-the-box thinker, efficient at communicating clearly and concisely.

Overview

6
6
years of professional experience

Work History

Data warehouse and Business Intelligence Developer

Amdocs
Pune
03.2019 - 01.2025
  • Collaborated with cross-functional teams to gather requirements for reporting tools.
  • Designed interactive dashboards using BI tools for data visualization.
  • Implemented ETL processes to ensure data accuracy and consistency.
  • Created documentation for BI processes and user guides for end-users.
  • Mentored junior developers on best practices in business intelligence development.
  • Optimized existing reports for improved performance and user experience.
  • Designed, developed and tested ETL processes to extract, transform and load data from multiple sources.
  • Developed complex SQL queries involving joins with multiple tables and SQL scripts running on multiple parallel threads for optimization.
  • Reviewed and improved performance of SQL server.
  • Participated in team meetings discussing project progress and providing feedback about possible improvements in design and functionality.
  • Identified opportunities to improve existing processes through automation or process re-engineering initiatives.
  • Worked closely with other teams such as software developers and database administrators to ensure timely delivery of projects.
  • Resolved issues related to data integrity, accuracy and completeness while ensuring that all deliverables adhere to quality standards.
  • Assisted in designing database objects such as tables, views, indexes and stored procedures based on functional specifications.
  • Performed data migration activities from legacy systems to new applications.

Education

Post graduate diploma in advanced computing -

CDAC ACTS
Pune
01-2019

Master of Computer Applications -

Banaras Hindu Universal
Varanasi
01-2018

Bachelor of Computer Applications -

Symbiosis Institute of Computer Studies And Research
Pune
01-2015

Skills

  • ETL processes, Informatica, Oracle DB
  • SQL optimization
  • BI reporting tools ( Cognos)
  • Python programming
  • Proficient in Java
  • Version control through Git and Perforce
  • Experienced with Big data systems distributed on mapr cluster
  • Kafka data streaming and integration

Affiliations

  • Avid reader
  • Consistent contributor to the company's CSR activities

Timeline

Data warehouse and Business Intelligence Developer

Amdocs
03.2019 - 01.2025

Post graduate diploma in advanced computing -

CDAC ACTS

Master of Computer Applications -

Banaras Hindu Universal

Bachelor of Computer Applications -

Symbiosis Institute of Computer Studies And Research

Similar Profiles

CREATE PROFILE
AKANSHA RAI