Pramod Kumar Sahoo
Technical Lead - Data Engineering
Bangalore,KA
Work Preference
Summary
Dynamic and results-driven professional seeking a challenging position that fosters excellence through dedication and proactive approaches. Committed to leveraging strong analytical abilities and technical skills to contribute effectively to organizational success while achieving personal growth. A passion for delivering high-quality work drives a continuous pursuit of improvement and innovation in every task undertaken. Eager to make a meaningful impact within a forward-thinking organization.
Overview
16
16
years of professional experience
1
1
Certification
3
3
Languages
Work History
Tech Lead
TCS - Manulife (Client)
01.2026 - Current
- FHIR (Fast Healthcare Interoperability Resources) Implementation.
- Planning the best way for data ingestion.
- Providing a cost-effective solution for development.
- Built strong relationships with stakeholders, ensuring clear communication channels for project updates and progress reports.
- Grooming the team members.
- Planning for the sprint.
- Providing the demos to the stakeholders.
- Optimized resource allocation by effectively prioritizing tasks based on business needs and project timelines.
- Developed comprehensive documentation to facilitate knowledge sharing among team members and support long-term maintenance efforts.
Tech Lead - Canada
TCS - Manulife (Client)
01.2025 - 12.2025
- Planned for the development of 20 APIs.
- Ingesting data from AWS into Azure ADLS.
- Developed the Medallion Architecture.
- Build the Gold Data as per the APIs.
- Ingesting the gold data into the MongoDB as a JSON document.
- Created the Databricks Workflow Jobs and scheduled it from a 2-hour to a 15-minute interval.
- Implemented the CloudFiles and CDC.
- Mentored junior developers, fostering a culture of continuous learning and skill improvement.
- Collaborated with product managers to define technical requirements and develop innovative solutions for complex problems.
- Enhanced application performance by identifying bottlenecks and optimizing code.
- Reduced system downtime with proactive monitoring, timely troubleshooting, and efficient issue resolution.
- Successfully completed well in time and gained excellent feedback from the customer.
Senior Data Engineer
TCS - Manulife (Client)
12.2023 - 12.2024
- Data ingestion, curation, and creating the JSON data for the API calls.
- Dealt with TBs of data and generated the JSON data as per the API.
- Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
- Championed the adoption of agile methodologies within the team, resulting in faster delivery times and increased collaboration among team members.
- Participated in strategic planning sessions with stakeholders to assess business needs related to data engineering initiatives.
Associate Consultant
TCS - Manulife (Client)
04.2022 - 11.2022
- Python Development.
- Building KRIs reports using the Python programming language and scheduling it through the Airflow Scheduler.
- I worked as an individual contributor.
Tech Lead
Legato
03.2021 - 04.2022
- Analyst & Development
Database Developer, Report Developer, Hadoop Developer, Team Lead, Scrum Master
Accenture
02.2013 - 03.2021
- Creating Function & Procedure as per the client Requirement
- Scrum Ceremonies, Team Management & Development.
- Maintaining the Existing Code Inventory and Migrating to On-Demand Env. And Test, Bug Fixing.
- Offshore Report Migration Lead
Crystal Report Developer
CSC
12.2009 - 02.2013
- Developing the Reports and Fixes the issues both in the crystal report and database, Production Support.
Education
MCA - Computer Science
NIT
Rourkela 04.2001 -
B.Sc - Physics
G M College
Sambalpur01-2005
12th - Sambalpur
Kendriya Vidyalaya
Sambalpur, India01-2001
10th -
Kendriya Vidyalaya
Sambalpur, India01-1999
Skills
PySpark – Azure - Databricks
BIGDATA – Hadoop Ecosystem (HDFS, Hive, HBase, SQOOP, SPARK, KAFKA)
Database - SQL(Oracle – SQL and PL/SQL, HQL) & NO-SQL(MongoDB)
Scripting – Python, Unix Shell Script
Reporting – Crystal Report
Cloud Platform – Azure, AWS
Scheduling Tool – Airflow, Control M
Version Control – Bit-Bucket, Git-hub
Agile Framework – Jira
PROFESSIONAL SUMMARY
- Experience in Multiple Domain like: Cyber Security Analytics, Health-Care (Manulife, Anthem, Health-First, Stanford Hospital & Clinics, Resurrection HealthCare), Telecom (AT&T, T-Mobile, Telecom-New Zealand, SFR).
- Cyber Analytics KRI-Automation
- Automating the Existing KRI (Key Risk Indicators) using python script and scheduling it in Airflow.
- Getting the data through the API calls from different system and putting it in Azure Blob.
- Taking the data from the Azure Blob and transforming it based on the customer requirements.
- Keeping the processed data in the Azure Blob or else inserting it into the Postgresql Database as per the requirements.
- HealthCare – Insurance:
- Data Ingestion from Various Data Sources (File & DB Based) into Data-Lake and processing the data as per the requirements.
- Processing these data and stored into different zones as per the required format (.avro & .parquet).
- Doing the automation through the Unix shell script & python wherever its required.
- Performance Optimization of the PySpark Code using various technique like bucketing, partitioning, broadcasting smaller tables, repartitioning etc.
- Azure - ADB
- HealthCare – Provider (Hospitals) & Insurance
- Good hands-on experience on HealthCare Domain (EPIC-EHR product by Epic Systems Corp.) on both application support as well as technical implementations like Clarity reporting.
- Database & Crystal Report Development.
- Telecom: Callidus – ICM (Incentive Compensation Management).
- Writing the PL/SQL codes and creating the Crystal reports for the Business End Users.
- Managing the Access Level security for the reports through the SAP Console.
Certification
HL7 & BigData and Pursuing Databricks
Table Tennis, Bathroom Singer, Food.
Love to play Table Tennis and Sometime murmuring with the Bollywood Singer in Bathroom.
Accomplishments
Build Customer Satisfactory Solutions.
Provided the best cost effective solutions.
Highly Appreciated by the Customer.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Odiya
Bilingual or Proficient (C2)
Quote
You are the Captain of your own Ship and you are the master of your own destiny.
Pramod Kumar Sahoo
Timeline
Tech Lead
TCS - Manulife (Client)
01.2026 - Current
Tech Lead - Canada
TCS - Manulife (Client)
01.2025 - 12.2025
Senior Data Engineer
TCS - Manulife (Client)
12.2023 - 12.2024
Associate Consultant
TCS - Manulife (Client)
04.2022 - 11.2022
Tech Lead
Legato
03.2021 - 04.2022
Database Developer, Report Developer, Hadoop Developer, Team Lead, Scrum Master
Accenture
02.2013 - 03.2021
Crystal Report Developer
CSC
12.2009 - 02.2013
MCA - Computer Science
NIT
04.2001 -
B.Sc - Physics
G M College
12th - Sambalpur
Kendriya Vidyalaya
10th -
Kendriya Vidyalaya