Divya Davanam

'm a Data Analyst with 3 years of experience. In my previous projects, I focused on improving the Configuration Management Database (CMDB). I gathered business requirements, managed inventory using tools like SERVICENOW, Device 42, and created dashboards in Tableau for data analysis.
I'm skilled in translating business needs into technical solutions, maintaining data accuracy, and collaborating with cross-functional teams.

Gathered business requirements by driving user-group meetings and working with various global, cross-functional, and virtual teams.
Identified key action items for CMDB enhancements and defined the process for Configuration Items lifecycle.
Managed and maintained 16 different assembly line computer stations using live data generated by Device 42 IT asset manager and IBM Watson Manager for all mobile devices, including mobile phones, tablets, and laptops.
Gathered and defined product epics and user stories in Jira and communicated system requirements by documenting in Confluence.
Managed data with ServiceNow tables, CMDB import sets, Users, Groups, and roles.
Acted as an administrator for the company's CMDB inventory system using Device 42 software.
Updated inventory and tracked gateways, domains, and subs using Device 42.
Created instructional document for server migration, retirement and decommission processes for related software applications in CMDB.
Interacted with business stakeholders to understand their decision-making parameters, analysed the available data to build Tableau dashboards, and managed the delivery.
Worked with Data Governance and Data Quality team to initiate DQ Rules & Controls and Enterprise Data Management/Modeling policies.
Established best practices for Enterprise Tableau environment and development processes.
Identified source and target data, performed data mapping and data profiling, developed governance processes and transformation processes using Informatica, and applied business rules to engineer ETL process and populate Redshift.
Analysed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.
Analysed requirements for various reports and dashboards and created them using Tableau Desktop Server.
Created user stories and visual design supporting the system functionality.
Created ER-Diagram using Erwin Data Modeler.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Coordinated multiple project teams of technical professionals through all phases of the SDLC using technologies including Erwin, Data Stage, Data Warehousing, and Cognos.
Performed logical data modelling and physical data modelling, including reverse engineering, using the Erwin Data Modeling tool.
Managed and led the implementation of data governance using Microsoft Project, Visio, PowerPoint, SharePoint tools and multiple training programs.
Created data models for Redshift and Hive from dimensional data models.
Responsible for mapping and modelling the conceptual, logical and physical models specific to Redshift and capturing data from the database.
Responsible for creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
Used Erwin tool for relational database and dimensional data warehouse designs.
Responsible for designing complex data models utilising Erwin.
Used Erwin to capture data by creating Entity-Relationship and Use Case diagrams.
Documented solutions using SharePoint, Confluence and used reporting tools like Tableau, Power BI, and Excel.
Used Jira and Confluence for converting requirements to user stories by assisting the Product Manager.
Gathered requirements, created user stories, and built backlogs for the product.
Groomed user stories and defined user acceptance criteria for Base Data management project.
Successfully used Agile/Scrum method for gathering requirements and facilitated user stories workshop.
Documented user stories and facilitated story point discussions to analyse the level of effort on project specifications.
Created digital roadmaps by aligning client stakeholders on prioritised goals.

Gathered, analysed and documented business and technical requirements from both formal and informal sessions and validated the needs of the business stakeholders.
Held collaboration meetings with Program Managers and various other counterparts to help guide them through Jira and Confluence methodologies.
Assisted in implementing a new asset tracking system Device 42.
Identified the current data sources for each of the fields including the intervening detailed mappings and logic/transformations using tools like Erwin data mapper.
Involved in a proof-of-concept project in implementing the CMDB with Discovery and ServiceWatch.
Provided expertise assistance for constructing data models with conceptual, logical and physical models using Erwin.
Involved in implementation, customization and maintenance of ITIL modules such as Incident, Change, Problem, Knowledge, Service Catalog, CMDB, Reporting and Integrations in ServiceNow.
Involved in testing and validation of CMDB data at time of seamless upgrade.
Validated different mapping associations generated via the integration on the new version.
Using Tableau, created multiple rich dashboards visually telling stories of the business status, strength and weakness, potentials, and interacting with data as necessary.
Participated in Data Governance working group sessions to create Data Governance Policies.
Supported the data governance team in conducting moderately complex data analysis to help drive data quality improvement initiatives.
Used SQL to query the database for performing data analysis and data modelling using Erwin.
Involved in implementing Structure and Portfolio plug-ins to better assist teams using Jira/Confluence.
Created conceptual and logical data modelling using Erwin Data Modeler, identifying various data elements for finding various entities and their relationship to integrate business processes with data rules.
Created epics, user stories, acceptance criteria in Jira and uploaded in Confluence for group collaboration.
Used Jira and Confluence to track user stories.
Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
Involved with the team to use Python to create test scripts to test the functionality.
Created and maintained data model/architecture standards, including master data management (MDM).
Performed mapping documents and data extraction and data compilation using SQL queries.
Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
Performed data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data and upgrading and patching of SharePoint and its related systems.