As a Senior Data Analyst with 5 years of experience, I specialize in various aspects of data management like analysis, warehousing, quality assurance, modeling, mapping, profiling, governance, and metadata management. I’m particularly skilled in ensuring data accuracy and integrity through profiling, cleansing, and master data management.In Business Intelligence and Visualization, I create engaging dashboards, reports, and data stories using tools like Tableau, Power BI, and MicroStrategy. I also have experience with BI development and testing using Cognos, and I’m proficient in generating detailed Excel reports and dashboards using various functions like VLOOKUP, HLOOKUP, macros, and pivot tables.My expertise also includes ETL processes, where I extract, transform, and load data from different sources into Data Warehouses and Data Marts using Informatica Power Center. I’m familiar with the Hadoop stack, including MapReduce, HDFS, Hive, Pig, and HBase, and have a good grasp of Big Data Technologies and Machine Learning. By applying strong data governance practices and using Informatica Data Quality tools, I ensure high data quality, helping drive informed business decisions and improve operational efficiency.
-
Data Engineer And Data AnalystTtsUnited States -
Data AnalystTd Aug 2023 - PresentI've created a variety of Tableau scorecards and dashboards using different chart types like bar graphs, scatter plots, geographical maps, heat maps, and Gantt charts to help with decision-making. In my role, I've designed logical and physical data models in ERwin, loaded tables into data warehouses, and retrieved millions of records from retail, financial, marketing, and sales databases. My work involves aggregating and cleaning data using SQL and SAS, performing regular and ad hoc queries, conducting regression analysis, and supporting ETL and report development teams. I also have experience with big data projects using Hadoop and Python, cloud environments, and analyzing data for migration from legacy systems to new systems.In addition to my technical skills, I've developed processes for capturing and maintaining metadata, collaborated with dev-ops teams for production deployment, and worked with upper management to resolve bottlenecks and errors in reports. I've extensively used tools like Informatica for data extraction and loading, Erwin for data modeling, and various SQL and PL/SQL scripts for data validation and testing. My experience also includes creating optimized RDBMS objects, developing Tableau dashboards for data visualization, and participating in Agile teams for project sprints. My goal is to leverage my comprehensive data management and analysis skills to drive business insights and operational efficiency. -
Data AnalystHcltech Jan 2019 - Jul 2022IndiaI have extensive experience devising end-to-end data quality practices, from data generation to business use, ensuring seamless data flows from external systems. My role involves utilizing change management best practices to embed data governance in project management (SDLC) and supporting leadership with data consultation, data gathering, and analysis. I excel in data validation and cleaning, using SQL and SAS to ensure high data quality and consistency, and participate in requirement analysis meetings to design physical and logical models using Erwin.In my work, I’ve extracted and cleaned large amounts of administrative and clinical data, developed Entity-Relationship diagrams, and modeled transactional databases and data warehouses. My expertise includes creating and maintaining data mapping and metadata, resolving data quality issues, and developing various ad hoc reports for different business teams. I’m proficient in using tools like Teradata, Oracle SQL, MS Access, and MS Excel, and have created dimensional logical models and business requirement documents, ensuring efficient support for BI and end-user needs.I have a solid background in developing robust ETL designs, generating SQL, Python, and R programs to fetch complex data, and performing database migrations from legacy systems to modern databases. My experience also includes working with data architects and business-specific data owners to maintain data quality standards, performing data profiling and validation, and applying data cleansing techniques.
Divya P Education Details
-
Master'S In Business Analytics -
Business/Commerce, General
Frequently Asked Questions about Divya P
What company does Divya P work for?
Divya P works for Tts
What is Divya P's role at the current company?
Divya P's current role is Data Engineer and Data Analyst.
What schools did Divya P attend?
Divya P attended University Of New Haven, Osmania University, Hyderabad.
Who are Divya P's colleagues?
Divya P's colleagues are Asfand Yar Javed, John Good, Daniel Felipe Beltrán, Samantha Waldon, Saikrishna Palani, Oakland James, Notin Soumahoro.
Not the Divya P you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial