DIVYA SANGAL
Burnaby,BC
Summary
- 12+ years of work experience in complete Software Development Life Cycle of Analysis, Design, Development, Testing, Implementation, Post Implementation Support, Operations & Managerial Role.
- Certified as “Microsoft Power BI Data Analyst” by Microsoft and “Power BI in Data Analytics Virtual Case Experience” by PwC.
- 10+ Years of Experience as Data Analyst, and have worked on different business intelligence/data analytics tools such as Power BI, Tableau, SAP Business Objects, IBM Cognos.
- 10+ Years of Experience as Data Developer and have experience on Report/Dashboard Creation from the very scratch and have experience on SQL Queries as well.
- 10+ Years of Experience on Business Intelligence and Data Warehouse. Worked in an Agile Environment. Experienced on Data Warehouse Concepts like Dimension Tables, Fact tables, slowly changing dimensions, DataMart and dimensional modelling schemas.
- Strong expertise in relational database management system like Oracle, SQL server. Managed multiple customer projects in a fast-paced environment and provided clearly defined project expectations, timely delivery of critical milestones and measurable project results and ensuring that all projects are delivered on time and within budget.
- Experienced working on Cloud such as Azure DevOPS, Azure Databricks, AWS, Snowflake, Azure DataFactory.
- worked on creating dashboards from the scratch and applied visualization on data. Also, have created schedule refreshes for the dashboards and created gateway connection for the dashboard. Published reports to Power BI Service and Shared using APPS in Service.
- Expertise in designing customized and interactive Dashboards using multiple data sources like Sql Server, Hadoop, Azure Databricks, Azure DevOps, Excel, Oracle. Representing the data by using Visualizations like Columns charts, Bar charts, Line charts, Pie charts, Table, Matrix and Maps.
- Led Support teams, used agile methodologies to deliver the application on time. Implemented end-to-end tasks effectively throughout the project till its delivery to customer from Requirement gathering, analysis, design, development and implementation. Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
- Excellent Team member with good communication, analytical, interpersonal skills and ability to learn new concepts. Good experience in working as Lead managing small and large teams as well.
Overview
13
13
years of professional experience
Work History
Technical Lead, Senior Tableau/Power BI Developer
Tata Consultancy Services
04.2022 - Current
- Working as a Primary Resource and Leading the team from onshore and received appreciations from Onsite project manager and Senior Technical Leads, business lead for successful support of previous Releases
- Interacting with the client for requirements gathering and translate them to technical specifications
- Created different types of reports and dashboards using Tableau Cloud and Power BI for handling the vast Rogers data
- Publishing the reports in Power BI Service and sharing the dashboards to Rogers
- Experienced working on Cloud Platforms such as Azure DevOPS, Azure Databricks, Snowflake, Azure Data Lake, AWS
- Experienced working with Microsoft BI toolset, including creating and editing: Dim tables, Fact tables, Stored procedures (SQL Server), and Scheduled workflows (SSIS)
- Automated the process of different jobs on different servers through Power BI Dashboard and created extract refresh for the dashboard
- Worked on Data Modelling, Calculations, Conversions and Scheduling for data refreshes in Power BI Desktop
- Identify, analyze and interpret data trends and patterns to develop datasets and reports for business needs
- Proposing a new Architecture to Integrate the applications to the Global Platform and Automating the applications using Tableau Cloud
- Designing Dashboards as per the requirement and dashboard content which includes Power BI Desktop visualizations
- Extracted Data from heterogenous sources in Power BI like Azure DevOPS, Oracle, SQL Hive, Hadoop, Excel
- Perform query optimization to reduce overall processing times of BI Jobs
- Scheduling and creating the subscription for the BI jobs using Tableau Service
- Organizing all the automation activities across the board that reduces the manual intervention, improves the productivity with less resources in server
- Worked on Power BI Enterprise Gateways and ensured that Gateways are online for the smooth running of dashboards
- Written extensive SQL queries to do transformations on the bulk Rogers data to be used by dashboards in BI
- Design Workload Automation, handling complex inter-dependencies, resource contention, resource overload and complex automatic notification
- Involved in complete end to end code deployment process in Production
- Troubleshoot, test and fix the defects and document the solution as part of maintenance procedures.
Senior Tableau/Power BI Developer, Technical Lead
Tata Consultancy Services
05.2020 - 03.2022
- Worked on BI Reports & Dashboards using connection as SQL Server/Oracle/Azure Databricks, Azure DevOps
- Worked on Custom Visualizations like multi slicer and Hierarchy Slicer
- Worked on Calculations/DAX Expressions like Filters, Aggregates, Mathematical Functions
- Experienced working on Cloud Platforms such as Azure DevOPS, Azure Databricks, AWS
- Worked on On-Premises gateway to refresh the connection/created a live connection
- Published/shared the reports by creating content pack/ sharing the .pbix files.
Senior Power BI/Tableau Developer
Tata Consultancy Services, Novolex Holdings
07.2017 - 04.2020
- Scrum Master
- Facilitated Sprint Planning meetings, Daily scrum, sprint review, product backlog refinement meetings and sprint retrospective meetings
- Monitoring the BI jobs, identifying improvement areas and implementing adequate measures to maximize customer satisfaction level
- Setting up & maintaining SLA’s for the incidents in SNOW & achieving targets for the process and the team
- Reviewing monthly reports pertaining to process / productivity
- Perform sprint retrospectives to capture lessons learned and what can be improved in next sprint
- Ensuring smooth deliveries, supporting UAT and satisfying business queries.
BI/BO Developer
Tata Consultancy Services
05.2011 - 12.2016
- Managed and trained a team of 3 BO developers joined as a trainee
- Developing BI Reports for the client as per the requirements
- Played a key role in the production support & maintenance of various Business objects and Universes
- Provided onsite/offshore business objects support to multiple business applications
- Ensuring smooth delivering, supporting UAT and satisfying business queries
- Creation and maintenance of business objects universe and reports, Unit Testing and Integration Testing of Reports as a whole, Resolved the issues related to bug fixes and Enhancements, Resolution of Production Tickets as per the mentioned SLA
- Mitigated impediments during the sprint in terms of issues and risks
- Ensured timely review, approval and sign-off the deliverables.
BI/BO Developer
On Job Training, Tata Consultancy Services
01.2011 - 04.2011
- Involved Enhancements on BO Universe and Reports
- Enhancements on BO Universe and Reports
- Created BI Reports as per requirements mentioned
- Changes in existing reports and adding new functionalities
- Creating Adhoc Reports from the Scratch
- Understanding BI/BO Terminologies and implementing them as a Business Objects Report.
Education
Bachelor of Science - Computer And Information Systems
Gautam Buddh Technical University
06.2010
Skills
- PowerBI (Desktop/Service/Report Builder)
- Tableau (Cloud/Desktop/Service)
- SAP Business Objects
- IBM Cognos
- Database Systems : Oracle 10g/11g, MS SQL Server 2000/2005
- Operating Systems : MS Windows
- Microsoft Office suite (Word, Outlook, Power point, Excel)
Timeline
Technical Lead, Senior Tableau/Power BI Developer
Tata Consultancy Services
04.2022 - Current
Senior Tableau/Power BI Developer, Technical Lead
Tata Consultancy Services
05.2020 - 03.2022
Senior Power BI/Tableau Developer
Tata Consultancy Services, Novolex Holdings
07.2017 - 04.2020
BI/BO Developer
Tata Consultancy Services
05.2011 - 12.2016
BI/BO Developer
On Job Training, Tata Consultancy Services
01.2011 - 04.2011
Bachelor of Science - Computer And Information Systems
Gautam Buddh Technical University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Jung Hwa (Alice) ShinJung Hwa (Alice) Shin
Manager Data Services at Global RelayManager Data Services at Global Relay