Prasanna Kumar HN
Bangalore
Summary
To serve the organization with commitment, dedication and to the best of my abilities and to gain immense practical exposure and become professionally trained to handle critical situations in the field of computers. Aspired to work in a reputed concern. Contribute profitably to the company. Learn to enhance my expertise.
Overview
10
10
years of professional experience
Work History
Sr. Software Engineer
HCL Technologies Ltd.
10.2019 - Current
- I analyzed user requirements, designed, and developed DataPipeline processes to load enterprise data into the Data Warehouse.
- Developed and implemented data models, database designs, data access and table maintenance codes.
- Optimized existing queries to improve query performance by creating indexes on tables.
- Developed Python scripts for extracting data from web services API's and loading into databases.
- Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
- Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
- Developed and deployed machine learning models for predictive analytics, utilizing Spark and NLP.
- Managed version control and deployment of data applications using Git, Docker, and Jenkins.
- Implemented data visualization tools like Tableau and Power BI to create dashboards and reports for business stakeholders.
- Automated data quality checks and error handling processes to ensure the integrity and reliability of datasets.
- Provided technical mentorship to junior data engineers, guiding them on best practices and project execution.
- Conducted data analysis using SQL and Python to derive insights and support decision-making processes.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Developed and managed enterprise-wide data analytics environments.
Sr. Software Engineer
Tech Mahindra Ltd.
01.2018 - 10.2019
- Achieved significant reduction in data load time from 10 days to 13 hours by developing an optimized loading package for Thomson Reuters.
- Conducted development work involving C#, ASP.NET, SQL, and SSIS within various enhancement projects.
- Designed and optimized stored procedures, SQL jobs, and views for improved database performance.
- Executed performance tuning strategies on SQL Server versions 2008 through 2016.
- Employed advanced SQL features like triggers for effective database management.
- Collaborated with business representatives to accurately capture report requirements.
- Performed both basic and ad hoc analyses to facilitate informed decision-making.
- Involved in comprehensive project planning, implementation, and deployment activities.
Senior Software Engineer
Tertium Technologies pvt ltd
Bengaluru
08.2015 - 08.2017
- Developed and maintained robust web applications using .NET technologies.
- Designed and optimized complex SQL queries, stored procedures, and data pipelines for efficient data retrieval and processing.
- Automated and standardized report generation to improve accuracy and reduce turnaround time.
- Collaborated with business stakeholders to define KPIs, and deliver actionable insights through tailored reports.
- Played a key role in data validation, reconciliation, and ensuring the accuracy and completeness of reports.
- Facilitated clear communication across departments to resolve issues beyond standard guidelines.
- Consistently recognized for outstanding performance, and delivering high-quality results under tight deadlines.
Education
B.E - Computer Science and Engineering
Rajeev Institute of Technology
Hassan01.2012
Skills
- Python programming
- Pyspark
- Pandas
- Airflow - workflow orchestration tool
- Temporal
- MS SQL, PostgreSQL
- NLP - Natural Language Processing
- Data visualization: Tableau and Power BI
- Data pipeline development
- Data analysis
- Machine learning
- Docker
Projects
Project: Appdata.com – B2B Business Intelligence Platform Project: Akmatics – Email Verifier Tool Project: Leads Camp – Email Campaigning Tool Project: Enterprise Data Warehouse
Company: Tertium Technology
Role: Full Stack Developer / Data Analyst
Client: Internal
Description:
Appdata.com is a B2B database platform offering curated information about business professionals. It aggregates data from internal databases, analyzes it, and provides actionable insights for sales, marketing, and business development.
Responsibilities:
- Collected and analyzed requirements from stakeholders.
- Designed and developed relational database structures.
- Built tables and performed data analysis to support decision-making.
- Implemented core application functionality in ASP.NET.
- Collaborated with inter-department teams for integration.
Company: Tertium Technology
Role: ASP.NET Developer
Description:
Akmatics is a utility tool that verifies email addresses via internet protocols without sending actual messages, used primarily for validation in lead generation and marketing.
Responsibilities:
- Developed and optimized core application logic using ASP.NET and C#.
- Designed user interface using HTML and CSS.
- Enhanced tool performance and accuracy in email verification.
Company: Tertium Technology
Role: ASP.NET Developer
Description:
Leads Camp is a bulk email campaigning tool designed for digital marketing professionals to reach international audiences effectively.
Responsibilities:
- Developed campaign engine using ASP.NET, C#, and jQuery.
- Participated in database design and integration.
- Contributed to the front-end development and user experience.
Company: Tech Mahindra
Role: Data Warehouse Developer
Client: Thomson Reuters
Description:
This project involved developing a centralized Enterprise Data Warehouse for Thomson Reuters to facilitate analytics and reporting across multiple business units.
Responsibilities:
- Designed and implemented data warehouse schemas (star/snowflake models).
- Extracted, transformed, and loaded (ETL) large volumes of data using SQL Server Integration Services (SSIS).
- Ensured data consistency, integrity, and availability for business intelligence tools.
- Worked closely with business stakeholders to gather requirements and deliver actionable insights.
- Contributed to performance tuning and database optimization.
Languages
- English
- Kannada
Personal Information
- Date of Birth: 07/28/90
- Nationality: Indian
- Marital Status: Single
Disclaimer
I hereby declare that all the above information’s given by me are true to the best of my knowledge. In case if I am selected I will assure you that I will fulfil the expectation of your Company.
Timeline
Sr. Software Engineer
HCL Technologies Ltd.
10.2019 - Current
Sr. Software Engineer
Tech Mahindra Ltd.
01.2018 - 10.2019
Senior Software Engineer
Tertium Technologies pvt ltd
08.2015 - 08.2017
B.E - Computer Science and Engineering
Rajeev Institute of Technology
Similar Profiles
Chetna SinghChetna Singh
Assistant Manager-Strategic Bid Management at HCL TECHNOLOGIES LTD.Assistant Manager-Strategic Bid Management at HCL TECHNOLOGIES LTD.
DIVYA THAKURDIVYA THAKUR
Manager – Risk and Compliance – Contract Risk at HCL Technologies Ltd.Manager – Risk and Compliance – Contract Risk at HCL Technologies Ltd.
Sunil KotthakotaSunil Kotthakota
Consultant - Information Security at HCL Technologies Ltd.Consultant - Information Security at HCL Technologies Ltd.
ASHISH PRIYADARSHIASHISH PRIYADARSHI
Senior Team Leader at HCL Technologies Ltd.Senior Team Leader at HCL Technologies Ltd.
Rachit MathurRachit Mathur
Senior Software Engineering Manager at Akamai TechnologiesSenior Software Engineering Manager at Akamai Technologies