# Tarun Pandra Pragada > Software Developer at PamTen Inc Location: Fort Mill, South Carolina, United States Profile: https://flows.cv/tarunpandrapragada ## Work Experience ### Software Developer @ PamTen Inc Jan 2025 – Present | United States ### Senior Dotnet Developer @ LPL Financial Jan 2025 – Present | South Carolina, United States ### Senior Software Engineer @ EPAM Systems Jan 2022 – Jan 2025 | Hyderabad, Telangana, India Modernized the Data Access Layer by migrating from legacy ADO.NET to Entity Framework Core, enabling database-agnostic design and smoother Oracle adoption. Implemented Repository and Unit of Work patterns to improve maintainability and separation of concerns. Migrated T-SQL queries, stored procedures, and functions to Oracle PL/SQL, resolving data type, date, and function incompatibilities. Tuned Oracle performance using partitioning, indexing, and bulk data operations. Built RESTful services using ASP.NET Core Web API with dependency injection, middleware, and async/await to support high concurrency and improved responsiveness. Integrated Oracle Managed Data Access (ODP.NET) with .NET Core and aligned transaction scopes with Oracle locking and concurrency models for reliable data consistency. Introduced Azure Function Apps (HTTP triggers) to handle batch processing and data synchronization between SQL Server and Oracle, forming a scalable hybrid backend with .NET 6 APIs. Implemented secure configuration management using appsettings.json and Azure Key Vault to manage credentials and environment-specific settings. Designed and executed incremental SQL Server to AWS S3 migrations using flag-based tracking for idempotent and fault-tolerant data movement. Developed .NET 6 ETL services to orchestrate extraction, transformation, and load workflows. Leveraged high-performance ADO.NET for SQL Server data extraction and streamed bulk datasets directly to AWS S3 using the AWS SDK for .NET. Applied async and parallel processing in .NET Core to optimize throughput for large-scale migrations, with retry and recovery logic for long-running jobs. Developed .NET Core Web APIs for migration monitoring, job control, and data validation, implementing reconciliation checks using row counts and checksums. ### Senior Technology Specialist @ Wells Fargo Jan 2020 – Jan 2021 | Hyderabad, Telangana, India Provided production support and ongoing enhancements for a legacy VB.NET application with a SQL Server backend, ensuring system stability, defect resolution, and uninterrupted business operations. Acted as the technical owner for incident analysis, root cause resolution, and coordination with business stakeholders. Led the modernization initiative by migrating the legacy VB.NET frontend to React.js and reengineering backend services using .NET Core (C#). Planned and executed the phased transformation to improve performance, scalability, and user experience while minimizing risk to production systems. Designed and developed RESTful ASP.NET Core Web APIs to replace legacy business logic, supporting pricing, risk modeling, and interest rate calculations tied to LIBOR and alternative reference rates (ARRs). Enabled seamless integration between the React frontend and SQL Server using clean API contracts and secure service layers. Refactored and optimized large-scale SQL Server database objects, including complex stored procedures, functions, and views exceeding thousands of lines of T-SQL. Implemented Entity Framework Core alongside ADO.NET, applying indexing, partitioning, and query tuning to improve performance for high-volume transactional workloads. Implemented advanced React performance optimizations using memoization techniques (React.memo, useMemo, useCallback) and lazy loading to reduce re-renders and improve page load times. Established frontend coding standards and reusable component patterns to ensure consistency, scalability, and easier maintenance across the application. Integrated React applications with enterprise-grade tooling by implementing secure API consumption, centralized state management with Redux, and environment-based configuration handling. Established CI/CD and code quality practices using Jenkins, AWS CodeDeploy, and SonarQube to automate builds, deployments, and static code analysis. ### Technology Lead @ Infosys Jan 2018 – Jan 2019 | Hyderabad, Telangana, India Led backend modernization initiatives to achieve GDPR and global data protection compliance, strengthening data security, retention, and privacy controls without impacting existing frontend systems. Owned technical planning, task breakdown, and execution while coordinating with cross-functional teams to ensure on-time and risk-free delivery. Designed and implemented secure .NET Core 6 REST APIs to enforce GDPR workflows, integrating OAuth 2.0, OpenID Connect, JWT Bearer authentication, MFA, and layered authorization. Defined Role-Based Access Control (RBAC) and Policy-Based Authorization strategies in ASP.NET Core, guiding the team on secure coding standards and compliance best practices. Architected data retention, archival, anonymization, and purge services using .NET Core, background Worker Services (IHostedService), and asynchronous processing patterns. Oversaw integration with Oracle databases using Entity Framework Core and ODP.NET, while refactoring PL/SQL packages, procedures, and triggers to embed audit trails and retention logic. Built GDPR-compliant backend services including DSAR, consent management, and right-to-erasure endpoints using ASP.NET Core Web API. Managed end-to-end integration and validation across .NET Core services and Oracle PL/SQL layers through coordinated integration testing and defect resolution. Acted as technical lead and delivery owner by driving sprint planning, backlog prioritization, and progress tracking while mentoring developers on .NET Core, security, and database best practices. Streamlined collaboration by producing architecture diagrams, data flow documentation, and compliance artifacts for auditors and stakeholders, ensuring transparency and regulatory readiness. ### Senior Software Engineer @ Value Momentum Software Servics Private Limited Jan 2017 – Jan 2018 | Hyderabad, Telangana, India Designed and developed RateTrak rate management modules using ASP.NET MVC 5, C#, Razor Views, and the MVC design pattern to ensure clean separation of concerns. Implemented well-structured Controllers, strongly typed Views, and domain-driven Models for maintainable UI architecture. Developed and optimized complex SQL Server stored procedures, functions, and queries to support rate calculations and business workflows. Integrated data access using Repository and Unit of Work patterns within the DAL to ensure transactional consistency and scalability. Consumed RESTful ASP.NET Web API services from MVC Controllers and Views, enabling service-oriented communication between the presentation layer and backend systems. Applied Data Annotations and validation attributes across Models to enforce business rules at both UI and service layers. Built rich, interactive user interfaces using Telerik UI for ASP.NET MVC components such as Grid, DatePicker, and AJAX controls. Implemented server-side paging, sorting, filtering, and AJAX-based data binding using JavaScript and jQuery to improve performance and user experience. Managed source control and release activities using TFS, including branching strategies, build packaging, and IIS deployments following release management best practices. Collaborated with QA and cross-location teams using Agile/Scrum practices, participating in sprint planning, defect triage, and status reviews to ensure on-time delivery ### Associate Consultant @ Microsoft Jan 2014 – Jan 2016 Designed and developed multiple modules in an ASP.NET MVC web application using C#, Razor Views, and the MVC architectural pattern. Implemented Models, Views, and Controllers with clear Separation of Concerns, encapsulating business logic within a dedicated Business Layer. Built a scalable Data Access Layer (DAL) using ADO.NET and the Repository Pattern to manage database connectivity and stored procedure execution. Optimized SQL Server queries and stored procedures to improve performance and scalability in a high-transaction environment. Implemented robust validation mechanisms using Data Annotations for server-side validation and jQuery/JavaScript for client-side validation. Ensured data integrity and enhanced user experience through consistent validation, error handling, and UI feedback. Developed batch processing components to read and validate flat files and CSV inputs, automating data migration into SQL Server databases. Improved operational efficiency by reducing manual intervention and ensuring accurate, repeatable data processing. Integrated SonarQube into the CI build pipeline to enforce static code analysis, manage technical debt, and uphold code quality standards. Participated in peer code reviews, applied refactoring best practices, and adhered to SOLID principles for maintainable and extensible code. Managed source control, branching, and release workflows using TFS and Git, supporting IIS deployments with MSBuild and Web.config transformations. Led Change Request (CR) activities, collaborated with onsite and QA teams, conducted unit testing with NUnit, and mentored junior developers on MVC best practices and debugging techniques. ### Senior System Engineer @ Infosys Jan 2012 – Jan 2013 | Hyderabad, Telangana, India Worked closely with stakeholders to gather requirements, create use cases, and translate them into technical designs, ensuring traceability from business needs to implementation. Authored HLD and LLD documents covering ASP.NET Web Forms architecture, data models, workflows, and integration points. Designed, developed, and optimized SQL Server database objects including tables, views, indexes, triggers, stored procedures, and functions to support new features and enhancements. Handled large-scale data persistence, transformation, migration, and performance tuning for high-volume transactional and ETL processes. Built and enhanced ASP.NET Web Forms applications using C#, ASPX pages, code-behind, server controls, and event-driven programming. Integrated frontend components with backend SQL Server logic and implemented state management using ViewState, Session, and caching for performance optimization. Developed a robust Data Access Layer (DAL) using ADO.NET components such as DataSets, DataTables, SqlDataReader, and SqlDataAdapter to enable efficient and secure database interactions. Refactored and tuned legacy Web Forms applications to improve scalability, reduce page load times, and optimize SQL queries. Performed unit testing and integration testing using MSTest, along with end-to-end validation of SSIS packages to ensure ETL accuracy and data integrity. Collaborated with QA teams for defect triage, regression testing, root cause analysis (RCA), and delivery of permanent fixes. Managed source control and release processes using TFS, adhering to organizational SDLC standards and best practices. Facilitated offshore–onsite coordination, mentored junior developers, and conducted knowledge transfer sessions on ASP.NET Web Forms, SQL best practices, and debugging techniques. ## Education ### Bachelor’s Degree in Computer Science Joginpally B R Engineering College ### 12th Standard in MPC Sahiti Junior College ### SSC Dowhill high school ## Contact & Social - LinkedIn: https://linkedin.com/in/tarunpandrapragada --- Source: https://flows.cv/tarunpandrapragada JSON Resume: https://flows.cv/tarunpandrapragada/resume.json Last updated: 2026-04-13