Sangeeta Deka
Bangalore
Summary
Seasoned Data and Analytics Professional with 12+ years of experience in the data domain, specializing in digital marketing analytics, data management, and product ownership. Proficient in leveraging technologies such as Teradata, Amazon Redshift, SQL, and Treasure Data to deliver comprehensive data solutions. Skilled in Customer Data Platforms (CDP), data mapping, data modelling, and data quality assurance, with a strong focus on data governance and compliance. Experienced in using tools like Eloqua for marketing automation, and well-versed in Agile methodologies, Jira, and Confluence for project management. Proven track record as a Teradata Developer, Business Data Analyst, and Product Owner, adept at driving data-driven strategies, enhancing operational efficiency, and supporting business growth. Strong believer in teamwork, building cordial relation with people inside and outside the organization, innovate solutions for difficult programming problems, quick-learner, open to learn new skills and problem analyst.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior Business Data Analyst/Product Owner
Informa Markets
London
02.2022 - 02.2024
- Collaborate with stakeholders such as marketing teams, and data analysts to gather and understand their requirements and challenges.
- Create and maintain a backlog of user stories and requirements for data products, focusing on user needs and business value.
- Develop and manage the product roadmap, prioritizing features and improvements based on business needs and user feedback.
- Define and document product features, functionalities, and technical specifications.
- Collaborate with marketing teams to analyze campaign performance, customer segmentation, and user behavior, providing actionable insights to optimize marketing strategies.
- Work closely with cross-functional teams, including marketing, data engineering team, and testing team, to identify data needs, streamline processes, and implement data-driven solutions.
- Establish and enforce data governance policies, ensuring compliance with regulatory requirements and best practices in data privacy and security.
- Communicate findings and recommendations to senior management and other key stakeholders in a clear and persuasive manner.
- Oversee multiple data projects simultaneously, managing timelines, resources, and deliverables to meet business goals.
- Interpret data from various digital marketing channels such as social media, email campaigns, SEO, and web analytics.
- Oversee the collection and integration of marketing data from different sources, ensuring completeness and accuracy.
- Implement and monitor data quality standards, identifying and correcting any inconsistencies or inaccuracies.
Data Engineer
Nationwide Building Society
Swindon
05.2019 - 12.2020
- Designing highly scalable and performant BI solutions for Regulatory and Mortgages projects across the organization
- Responsible for key interactions with the business to convert BRS into technical solutions
- Responsible for creating Mapping documents and other technical documents
- Designing of the end-to-end solutions for a few Regulatory and Mortgages projects
- Responsible for performing Internal Data and Functional Validation from a business perspective
- Data Mining and Analyzing of Business Data Issues
- Working on Data quality issues
- Responsible for building the semantic layer and make data available for Reporting
- Responsible for validating the data being provided to the semantic layer by the Change data capture solution built by one of the vendors
- Modelling & code development for all new Use Cases
- Converting semantic layer data into meaningful business insights on Qlik sense.
Business Data Analyst
Allied Irish Bank (through Wipro Ltd.)
Dublin
01.2016 - 11.2018
- Business Requirement Gathering / Working on Mapping Documents
- Data Analysis on Teradata and Hive
- Writing SQL queries
- Testing
- Working with Data Quality team
- Working with Data Modelling Team
- Loading data from large data files into Hive tables
- Designed and developed Hive job to merge incremental file
- Responsible to manage data coming from different sources.
Data Analyst
Walmart (through Cognizant)
Bangalore
12.2014 - 12.2015
- Involved in 20% of Database migration from Netezza to Teradata
- Developing and optimizing SQL queries for migrating data scripts from Netezza to Teradata, ensuring compatibility and performance efficiency
- Developing business reports on SQL
- Generate reports as per business requirements on Tableau
- Developing and automating jobs on Talend
- Writing YAML scripts
- Query tuning
- Analyzing business data issues and providing solutions
- Converting semantic layer data into meaningful business insights on Tableau.
Data Engineer
Telstra (through Hewlett-Packard)
Bangalore
11.2011 - 07.2014
- Teradata Developer
- Working with Teradata Load Utilities (BTEQ, Fast load, Multiload, TPump, FastExport
- Datastage Support Analyst
- Query tuning
- Involved in RCA
- Responsible for Development, technical Design & documentation
- Active involvement in independent releases and deployments.
Education
Bachelor of Engineering -
North Maharashtra University
Maharashtra08-2010
AISSCE (All India Secondary School Examination) -
Kendriya Vidyalaya Khanapara
Guwahati, Assam05-2005
AISSE (All India Secondary School Examination) -
Kendriya Vidyalaya Khanapara
Guwahati, Assam05-2003
Skills
- Business Intelligence
- Data Warehousing
- Data Analytics
- Quality Assurance
- Solution Design
- Data Modelling
- Data Mapping
- Data Governance
- Digital Marketing - Eloqua
- SQL
- Redshift
- CDP: Treasure Data
- RDBMS: Teradata
- Teradata Utilities
- Unix
- Control-M tool (scheduling and optimization)
- Agile/JIRA
- Tableau/Qlik Sense
Certification
- CSPO in progress
- CDMP in progress
Timeline
Senior Business Data Analyst/Product Owner
Informa Markets
02.2022 - 02.2024
Data Engineer
Nationwide Building Society
05.2019 - 12.2020
Business Data Analyst
Allied Irish Bank (through Wipro Ltd.)
01.2016 - 11.2018
Data Analyst
Walmart (through Cognizant)
12.2014 - 12.2015
Data Engineer
Telstra (through Hewlett-Packard)
11.2011 - 07.2014
Bachelor of Engineering -
North Maharashtra University
AISSCE (All India Secondary School Examination) -
Kendriya Vidyalaya Khanapara
AISSE (All India Secondary School Examination) -
Kendriya Vidyalaya Khanapara
Similar Profiles
Joan Celestine PhuaJoan Celestine Phua
Customer Relationship Executive at Informa MarketsCustomer Relationship Executive at Informa Markets
SAMMY NAGELSAMMY NAGEL
Sponsorship Coordinator at Informa MarketsSponsorship Coordinator at Informa Markets
Akansha RoyalAkansha Royal
Marketing Manager at Informa MarketsMarketing Manager at Informa Markets
Lottie ElsonLottie Elson
Marketing consultant (contract May-Sept) at Informa MarketsMarketing consultant (contract May-Sept) at Informa Markets
Sapna MishraSapna Mishra
Lead Quality Engineer at BrillioLead Quality Engineer at Brillio