Summary
Overview
Work History
Education
Skills
Software
Timeline
Generic

Deepika Verma

Lead BI Developer
Bangalore

Summary

Experienced over 13 years of IT experience in Analytics, Visualization & ETL.Around 6+ years of experience as BI development. Excellent reputation for resolving problems and improving customer satisfaction. Ability to prioritize work, meet deadlines, achieve goals and work under pressure in a dynamic and complex environment. Ability to research and report on a variety of issues using problem solving skills.


Overview

14
14
years of professional experience
4
4
years of post-secondary education

Work History

Lead Data Analyst

Dish Network Technologies
07.2019 - Current
  • Extensive experience in designing visualization reports and dashboards with large data volumes from diverse sources.
  • Proficient in the full Tableau report lifecycle: Analyzed business requirements, development, testing, and deployment.
  • Analyzed complex data to identify anomalies, trends, and risks, providing insights for internal controls improvement.
  • Provided reporting, analysis, and insights across multiple business areas to support corporate analytics.
  • Skilled in designing table structures, creating tables and stored procedures, and developing complex SQL for data integration from multiple databases.
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
  • Possesses the highly valuable ability to own a data solution from end to end, combining Data Engineering with Advanced BI Development.
  • Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.
  • Developed custom dashboards in Tableau for real-time tracking of key performance metrics across departments.
  • Presented actionable insights to executive leadership, driving informed decision-making on critical business issues.
  • Optimized data warehouse functionality for improved business intelligence reporting.
  • Increased efficiency by automating routine data processing tasks using Python scripts and AWS services.
  • Championed the adoption of agile methodologies within the analytics team, improving project delivery times and overall productivity levels.
  • Managed a team of junior analysts, providing mentorship and ensuring high-quality deliverables.
  • Trained new team members by relaying information on company procedures and safety requirements.

Team Lead- DataWarehouse

IBM India Pvt Ltd.
05.2016 - 06.2019
  • Prepared detailed reports on updates to project specifications, progress, identified conflicts and team activities.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
  • Expert in writing complex SQL Queries to check integrity of data to perform ETL in Teradata, Hive, Redshift.
  • Attended User Stories walkthrough sessions from Business Teams.
  • Assigned tasks to offshore team and helped them .
  • Assigned daily tasks to team with all required details and documents.
  • Had call regularly with offshore team to clear their doubts and issue faced during daily assignments.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture.

QA Engineer -DWH

IBM
02.2012 - 04.2016
  • Perform ETL/DW testing and BI report testing on Teradata, Informatica, Hadoop, MicroStrategy platforms.
  • Work closely with business analyst to gather requirements, define testing scope, test strategies and develop test plans for projects.
  • Develop complex SQLs for validating reports and data validation in Teradata SQL Assistant and Hadoop.
  • Had discussion with developers whenever defect encountered during testing. Retested it after getting fixes.
  • Designed test data to verify data flow from input files to stage tables is accurate in terms of data cleansing requirements and that lookups are correctly applied.
  • Provided test case walkthrough to ensure all possible scenarios covered in test cases.

Education

B.Tech - Information Technology

Mody Insitute of Technology & Science
Sikar,Rajasthan
08.2007 - 05.2011

Skills

Technology leadership work streams

Software

Tableau

Teradata

AWS Redshift

Hadoop

Snowflake

AWS services

JIRA

Timeline

Lead Data Analyst

Dish Network Technologies
07.2019 - Current

Team Lead- DataWarehouse

IBM India Pvt Ltd.
05.2016 - 06.2019

QA Engineer -DWH

IBM
02.2012 - 04.2016

B.Tech - Information Technology

Mody Insitute of Technology & Science
08.2007 - 05.2011
Deepika VermaLead BI Developer