Aparajita Ghosh
Edinburgh,United Kingdom
Summary
Driven professional with knack for critical thinking and problem-solving, coupled with strong analytical and communication skills. Proficient in data interpretation and presenting actionable insights to stakeholders. Committed to delivering impactful analysis and strategic recommendations in Data Analyst role.
Overview
11
11
years of professional experience
1
1
Certification
Work history
SENIOR DATA & BI ANALYST
Tata Consultancy Services Limited
Edinburgh, United Kingdom
02.2023 - 07.2025
- Architected and implemented enterprise data models facilitating analytics across multiple departments, utilizing star schema design principles.
- Developed and maintained interactive dashboards in AWS QuickSight, enabling real-time insights into business trends, market value, increasing decision-making efficiency.
- Led migration of legacy reporting systems Logi analytics to AWS cloud infrastructure, including AWS Athena , Postgres and S3, reducing reporting latency by 30%.
- Managed data governance frameworks, ensuring compliance with privacy standards, and controlled access via role-based permission using RLS .
- Mentored junior analysts in data modelling, SQL techniques, and QuickSight dashboard development.
Data analyst
Tata Consultancy Services Ltd
Edinburgh, United Kingdom
01.2022 - 01.2023
- Designed ETL approach to retrieve the data and loading into stage, dimension & Facts using SSIS.
- Created interactive dashboards using Power BI for easy data interpretation and presentation.
- Utilised SQL to extract relevant information for reporting purposes.
- Analysed patterns in large volumes of data, provided key insights.
- Performed Best practices, Query Optimization and Performance Tuning.
- Collected and analysed complex datasets for business strategy enhancement.
- Translated complex findings into understandable documents, increased company-wide understanding of critical metrics.
- Collaborated cross-functionally to meet project deadlines, delivered consistent results.
- Detailed project planning, development, and maintenance and managing project scope and change control and escalating issues where necessary.
DATA WAREHOUSE DEVELOPER
Tata Consultancy Services Ltd
Kolkata, India
11.2017 - 12.2021
- Led team of junior developers, fostering collaborative work environment.
- Creation, Development and Deployment of SSIS packages in SQL Server 2012.
- Develop stored procedures and SSIS packages to support ETL Process.
- Designed ETL processes to streamline data extraction, transformation, and loading.
- Designed various SSIS modules in order to fetch data to data staging environment based on different types of incoming data
- Enhanced data retrieval times with optimisation of SQL scripts.
- Streamlined business intelligence reports using BI tools such as Logi Analytics, Power BI for improved decision-making.
- Utilised agile methodologies during project management, improving workflow efficiency.
- Worked successfully under Agile methodologies to deliver on-time projects.
IT ANALYST
Tata Consultancy Services Ltd
Kolkata, India
11.2016 - 11.2017
- Responsible for creating Autosys jobs using CA Autosys tool for Job scheduling.
- Created business process for both inbound and outbound transactions to Claim Centre with other internal and external applications as per business needs using BPML in Sterling Integrator.
- Configured adapters, services, service configurations and protocol setups as per business needs.
- Hands on expertise in Sterling File Gateway by using various adaptors File, Schema, XML, Database, Email, SFTP, FTP, MQ Suite etc. and responsible for setting up various communications using Protocols FTP, HTTP, SMTP with trading partners.
- Incorporating new changes in both inbound and outbound transactions maps - including XML, CSV, PSV, EDI file.
- Responsible in setting up Trading Partner Identities, for both inbound and outbound partners.
- Extensive Experience in preparing Test Plans, Test Scenarios, Test Cases and executing them based on Business rules and System requirements.
SYSTEMS ENGINEER
Tata Consultancy Services Ltd
Kolkata, India
03.2014 - 11.2016
- Used Log4j for logging purpose.
- Maintaining version control using IBM ClearCase.
- Developing and consuming SOAP Web service to be used by other enterprise application.
- Prepared JUnit & EasyMock test coverage report.
- Preparing unit test plans and test application accordingly.
- Used dozer mapper to transform complex Business Object Model into another, which includes many custom configurable converters.
- Adding new BOM attributes to XSD and WSDL, generating JAXB classes from XSD and finally adding dozer mapper for copying data from one object to another.
- Bug fixing using core java concepts and handled release of multiple versions of product successfully.
Education
BACHELOR OF TECHNOLOGY - COMPUTER SCIENCE & ENGINEERING
Narula Institute Of Technology
IndiaST X II / H.S.C. - SCIENCE
Krishna Bhabini Nari Siksha Mandir
IndiaSSC / X STD. - Science
St. Anthony's High School
IndiaSkills
- Programming and querying : Python(Pandas), SQL
- Statistical Data Analysis , Visualisation & Business Intelligence : AWS quicksight, Power BI,Logi Analytics
- Data Modeling & Data Warehouse Design (Star/Snowflake Schemas)
- SQL & Big Data Technologies (Postgres, S3, Athena)
- ETL & Data Pipeline Management
- Data Governance & Security Best Practices
- Devops CICD pipeline : Jenkins,Git,SVN
- Team Leadership & Cross-functional Collaboration
Certification
- AWS Partner: Generative AI Essentials( Business)
- Databricks Generative AI Fundamentals Accreditation
Timeline
SENIOR DATA & BI ANALYST
Tata Consultancy Services Limited
02.2023 - 07.2025
Data analyst
Tata Consultancy Services Ltd
01.2022 - 01.2023
DATA WAREHOUSE DEVELOPER
Tata Consultancy Services Ltd
11.2017 - 12.2021
IT ANALYST
Tata Consultancy Services Ltd
11.2016 - 11.2017
SYSTEMS ENGINEER
Tata Consultancy Services Ltd
03.2014 - 11.2016
BACHELOR OF TECHNOLOGY - COMPUTER SCIENCE & ENGINEERING
Narula Institute Of Technology
ST X II / H.S.C. - SCIENCE
Krishna Bhabini Nari Siksha Mandir
SSC / X STD. - Science
St. Anthony's High School
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
Sandeep NanjundappaSandeep Nanjundappa
Scrum Master at Tata Consultancy Services LimitedScrum Master at Tata Consultancy Services Limited
Gouri RashinkarGouri Rashinkar
Consultant at Tata Consultancy Services LimitedConsultant at Tata Consultancy Services Limited
Jicson Babu DanielJicson Babu Daniel
Operations coordinator at NielsenIQOperations coordinator at NielsenIQ
Erin PotterErin Potter
Operations Executive at JacTravel (A TourPartnerGroup Company)Operations Executive at JacTravel (A TourPartnerGroup Company)