Praveen Nalla
Software Engineer
Amalapuram
Summary
Results-driven Software Professional with 5.5 years of experience in data warehousing and software application development using Microsoft Business Intelligence Tools. Skilled in optimizing BI applications through ETL packages, reports, and cubes with SQL Server, SSIS, SSRS, and SSAS. Integrates diverse data sources, writes complex stored procedures, and delivers tailored reporting solutions.
Overview
6
6
years of professional experience
Work History
MSBI Developer
Eclerx
Mumbai
08.2022 - 01.2026
- MSBI Developer — EClerx (08/09/2022–01/08/2026)
- Implemented real-time CDC replication from legacy systems to Odessa using HPE Data Bridge, enabling low-latency, filtered data synchronization.
- Built SSIS packages and ETL pipelines with incremental loads, data validation, and error handling to ensure daily CER table refreshes.
- Automated CER data refreshes via SQL Agent jobs and optimized complex SQL procedures to improve processing and reporting performance.
- Developed stored procedures and functions to aggregate campaign and sales metrics for actionable CER reporting.
- Led legacy-to-modern data migrations and designed archival strategies ensuring data integrity and zero-downtime continuity.
- Created cross-platform integration solutions and database objects to support insurance data warehousing and analytics.
MSBI Developer
Surge Soft Info Technologies
Banglore
05.2020 - 07.2022
- MSBI Developer — Surge Soft Info Technologies (10/05/2020–19/06/2022)
- Maintained SSIS solutions and ETL pipelines extracting from databases, flat files, and APIs.
- Improved query performance via indexing and SQL optimization, reducing report runtime.
- Provided end-user BI support, resolving tool-related queries and usability issues.
- Handled L1–L2 incidents for Assurant’s insurance oversight system, triaging and escalating to meet SLAs.
- Supported Isuzu’s dealership system, resolving dealer/user data and configuration issues.
- Performed routine production checks and post-release verifications to ensure system stability.
Education
Bachelor of Technology - Civil Engineering
Swarnandhra College of Engineering And Technology
Narasapuram 04.2001 -
Skills
Technologies: Microsoft Business Intelligence Tools (MSBI)
SSIS ETL tools
Databases: SQL Server2017, 2016 and 2012
Power-Bi
Operating Systems: Windows 10, Windows 7
Timeline
MSBI Developer
Eclerx
08.2022 - 01.2026
MSBI Developer
Surge Soft Info Technologies
05.2020 - 07.2022
Bachelor of Technology - Civil Engineering
Swarnandhra College of Engineering And Technology
04.2001 -