Purnendu Giri
Edinburgh,Scotland
Summary
Results-driven Data Analyst with 10 years of experience leveraging Python, SQL, Tableau and machine learning to optimize operations and ensure data quality. Skilled in designing data pipelines, automating processes, and delivering actionable insights that drive business decisions. Expertise in working with global stakeholders to resolve complex data issues, improve processes, and mitigate risks. Strong communicator with a track record of translating complex data into clear insights and aligning solutions with business goals. Proven ability to collaborate across teams and manage data quality and governance effectively.
Overview
10
10
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Data Analyst
Aegon UK (Company-TCS)
Edinburgh
09.2021 - Current
- Advised People Leaders on complex data-related issues, leveraging Python and SQL to translate analytics insights into actionable recommendations, enhancing data-driven decision-making.
- Identified and resolved data quality issues, increasing report accuracy and reliability, leading to a 10% reduction in manual effort through process automation and optimization.
- Developed and automated ETL pipelines, optimizing data movement and processing, resulting in a 5% reduction in daily execution time and improved system efficiency.
- Led cross-functional collaboration, working with finance, risk, and IT teams to align data strategy with business objectives.
- Supported financial and risk teams in preparing and validating data for regulatory reporting (COREP, FINREP, LCR), ensuring data accuracy and compliance with Basel III and CRR frameworks.
- Optimized trading operations by identifying and eliminating process inefficiencies, implementing auditing and data cleansing strategies, resulting in £2M in annual cost savings.
- Reduced project implementation cycles by 20% by mentoring a team of 5 junior analysts in advanced data profiling techniques, driving greater efficiency and faster delivery.
- Identified and corrected incorrect asset valuation logic, preventing 10% monthly overpayment to fund managers and improving system accuracy.
- Led the adoption of best practices in performance data management, ensuring high standards across the organization and improving data integrity.
- Analysed customer satisfaction metrics, identifying pain points and recommending actionable solutions that improved customer experience.
- Collaborated with developers to design and implement technical solutions that aligned with business goals, optimizing operational efficiency.
Technical lead
Aegon UK (Company- TCS)
Kolkata, India
04.2020 - 09.2021
- Led migration planning from Cognos Data Manager to IBM DataStage, overseeing the end-to-end transition to improve data management processes and ensure efficient system integration.
- Streamlined financial reporting processes, reducing report generation time by 30%, which allowed for quicker decision-making and improved financial visibility across departments.
- Consulted with stakeholders to evaluate business requirements, ensuring a clear understanding of project needs, and providing strategic mentorship to facilitate seamless delivery.
- Ensured project deliverables adhered to best practices and stakeholder expectations, implementing processes that ensured consistent quality and compliance.
- Contributed to Sprint planning and reviews, collaborating with cross-functional teams to ensure alignment of development goals with business objectives.
- Provided high-quality technical support to an average of 5 users daily, resolving issues promptly and ensuring smooth operational workflows.
- Conducted specialized knowledge sessions to refine business requirements, ensuring precise alignment between the development team and business stakeholders.
- Fostered a collaborative team environment, addressing challenges with empathy and leveraging problem-solving skills to support the development team in delivering high-impact solutions.
Software developer
Aegon UK (Company-TCS)
Kolkata, India
03.2015 - 03.2020
- Trained in Cognos Analytics and IBM DataStage, contributing to the development and implementation of various insurance domain projects.
- Strong knowledge of ETL and Data Warehouse (DWH) concepts, ensuring efficient data processing and integration across multiple systems.
- Worked extensively with Cognos Data Manager, Report Studio, Query Studio, and Cognos Framework Manager to design and deploy interactive reports, optimizing business intelligence operations.
- Optimized database performance by implementing Oracle SQL indexing techniques, reducing query execution time by 40%, and improving overall system efficiency.
- Automated key business processes, streamlining operations, and created detailed reports that drove customer satisfaction and contributed to securing new projects.
Education
Bachelor of Technology - Computer Science & Engineering
West Bengal University of Technology
India 07.2010 - 07.2014
Skills
Programming & Scripting:
- Python, SQL, Unix
Data Visualization & BI:
- Cognos Analytics, Power BI, Tableau
Data Engineering & ETL:
- Expertise in building and optimizing data pipelines
- Data transformation, data lineage tracking using tools such as IBM DataStage, Data Manager
- Data cleansing, validation, and regulatory compliance using Infosphere Quality Stage
- Applied Cognos Analytics for predictive modelling and deriving business insights
Business & Communication:
- Stakeholder management and cross-functional collaboration
- Skilled in presenting complex data insights to both technical and non-technical audiences
Problem-Solving & Automation:
- Automating manual data processes, enhancing efficiency and productivity across departments
Application Lifecycle Management (ALM):
- Proficient in using JIRA for issue tracking, bug management, and agile project management
Cloud Data Processing & ETL
- Hands-on experience using AWS Redshift, Glue and S3 bucket
Accomplishments
- Have received STAR Team award as a team lead.
- Have received STAR of the Quarter for outstanding individual performance.
- Have received several recognition for multiple charity events.
Certification
- AWS Certified Solution Architect
- Microsoft Certified Data Analyst(Power BI)
- IBM Certified DataStage Developer
Timeline
Data Analyst
Aegon UK (Company-TCS)
09.2021 - Current
Technical lead
Aegon UK (Company- TCS)
04.2020 - 09.2021
Software developer
Aegon UK (Company-TCS)
03.2015 - 03.2020
Bachelor of Technology - Computer Science & Engineering
West Bengal University of Technology
07.2010 - 07.2014
Similar Profiles
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Harkirt SinghHarkirt Singh
Financial Advisor at Aegon Life Insurance CompanyFinancial Advisor at Aegon Life Insurance Company
Sanjay ChaudharySanjay Chaudhary
AVP Digital Partnership & Business Growth at Aegon Life Insurance CompanyAVP Digital Partnership & Business Growth at Aegon Life Insurance Company
Riya BinduRiya Bindu
Business analyst at Tata Consultancy ServicesBusiness analyst at Tata Consultancy Services
Chloe LythChloe Lyth
Centre Manager at The Salisbury CentreCentre Manager at The Salisbury Centre