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
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