Tableau
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
Teamwork and Collaboration
Critical Thinking
Data analysis
Snowflake
AWS Services
Data warehousing
ETL processes
Business intelligence
SQL expertise
Data visualization
Software
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