Open To Work
Hi, I’m
SAI RAMASAHAYAM
Dallas
Summary
Professional software developer with over 6 years in Oracle PL/SQL, ETL, and data warehousing. Demonstrated ability to design scalable data pipelines and collaborate with cross-functional teams to enhance system functionality using modern cloud technologies like AWS and Azure.
Overview
6
years of professional experience
Work History
Impelsys USA
Software Developer
02.2025 - Current
Job overview
- Delivered software design changes, application modifications, and testing for Air Force Personnel Center (AFPC) eBOSS, enhancing system functionality and user experience.
- Worked within a cross-platform architecture using C#, .NET, MVC, XAML and JAVA Rational Application Developer (RAD) running on a WebSphere Application Server (WAS) v8.5 with a Window Communication Foundation (WCF) library as mid-tier; connecting to an Oracle 11i instance.
- Designed and implemented scalable data pipelines using PySpark, AWS Glue, and Athena to ingest and transform large healthcare datasets from S3 into Redshift, improving data availability and query performance.
- Optimized data lake and warehouse performance by tuning storage formats and implementing efficient partitioning strategies.
- Utilized the latest JavaScript frameworks to upgrade the client side frontend UI using Angular 2, Typescript, Bootstrap and JQuery.
- Delivered ETL automation using Databricks and Delta Lake, ensuring ACID compliance and schema enforcement.
- Developed custom directives and services to interface with both RESTful and legacy network services.
- Wrote scripts in Python for automation of testing jobs and data migration using a combination of Shell script and Python.
- Coordinated with cross-functional teams to design event-driven server-side requirements using Node and RESTful/SOAP web services.
- Implemented a successful Cassandra DataStax 3.0 system wide driver upgrade; developing the necessary code testing with C#, NUnit for the .NET platform.
- Optimized Process Control Engine (PCE) web API in C# to efficiently handle hundreds of business process actions per second, leveraging a multi-node clustered Cassandra database across multiple data centers.
- Developed and executed automated testing scripts for React applications using Jest and React Testing Library to ensure functionality and performance.
- Automated test scripts using testing frameworks such as Selenium WebDriver, incorporating HTML element locators to validate the behavior of web elements and interactions.
- Developed NUnit and acceptance tests; coordinated sign-off from Quality Assurance team before initiating automated deployment using Jenkins.
- Supported DevOps and support teams in troubleshooting software issues and implementing bug fixes, maintaining daily JIRA ticket status updates to track progress.
- Impelsys is a leading provider of innovative technology solutions that empower organizations across the globe become digital-first, data-driven intelligent enterprises. Our services include Cloud, AI/ML Platforms and Products, Data and Analytics, End-to-End Quality Assurance (QA), Custom Application Development, and Learning Solutions.
- Environment: React, TypeScript, AWS Lambda, API Gateway, SQS, SNS, S3, DynamoDB, Java, Redux, Jest, Enzyme, Mocha, AWS CloudFormation, Selenium Web Driver, Java, JIRA, playwright, AWS, Apache Airflow, Power BI, Tableau, Apache Kafka
Synchrony USA
Software Developer
02.2023 - 01.2025
Job overview
- Analyzed, designed, implemented, and tested high-quality code for the business area. Maintained and supported mission-critical applications.
- Collaborated with development team to create internal management system for collecting and storing field research data, enabling validation of tests like the Wechsler Intelligence Scale for Children - Fifth Edition (WISC-V).
- Developed Field Research Portal alongside internal management system, enabling external partners to manage test-taking candidates efficiently using Silverlight, C#, VB.NET, and Java with Telerik controls.
- Designed and implemented seamless integration between Field Research Portal and Qualtrics Online Solution Survey web API, automating collection and storage of test results for examinees using Java and .NET MVC 5 with SQL Server 2008 backend.
- Created detailed test plans, strategies, and execution reports, including metrics, coverage summaries, and defect analytics for leadership visibility.
- Performed comprehensive API testing using Postman, Python (requests), Pytest, and REST Assured validated data integrity using SQL and backend logs.
- Automated web and API tests using Selenium, Cypress, Playwright, and Python; Jenkins improving test regression readiness and repeatability.
- Coordinated with teams in quality assurance, business analysis, project management, and end users to deliver high-quality software, creating testable requirements and executing unit tests.
- Created metadata-driven ETL frameworks using Python and Snowflake, standardizing data ingestion and transformation processes across multiple business units.
- Contributed to building real-time streaming pipelines using Apache Kafka and Spark Streaming, enhancing capability to process payment and customer behavior data.
- Applied changes to an existing Java Maven project to meet requirements that allowed the consuming of a RESTful web api which was implemented from within another C#, VB.NET project.
- Designed scalable Azure DevOps architecture supporting microservices-based systems.
- Environment: JavaScript, Restful Web services, JIRA, JSON, GIT, Tableau, Core JAVA, Selenium, REST/SOAP services, GIT, Bit bucket, Apache Airflow, Databricks, Power BI, Tableau, Kafka, Spark.
Lexicon Infotech LimitedHyderabad
Software Developer
02.2021 - 01.2022
Job overview
- Developed the frontend with React.js, HTML, CSS, Bootstrap, and media queries for a responsive design.
- Utilized Express.js for efficient API handling.
- Conducted API testing for REST and GraphQL services using Python, Postman, and TestNG; validated backend data via SQL queries.
- Using Agile development, JAVA, J2EE, JSP, HTML, XML, JavaScript, Tomcat/Apache, Oracle 11g, MySQL, Shell, Perl, iTrack/QC, SVN, Eclipse, make, and Sublime.
- Developed PL/SQL stored procedures, triggers, and packages to streamline database operations.
- Wrote complex SQL Queries, schemas, tables, views, indexes, cursors, unions and joins.
- Established MySQL setup, enhancing database performance and enabling software-defined networking.
- Executed data modeling and developed database schema, indexes, constraints, privileges, sequences, synonyms, triggers, stored procedures, SQL Loader, and managed database migration/conversion using TOAD 12.x and PL/SQL.
- Optimized data lake and warehouse performance through storage format tuning and efficient partitioning strategies.
- Designed and developed feature in the Confidential & Confidential Router Auto-Configuration System to support network inventory, ordering, and provisioning groups.
- Driven by our unwavering commitment to excellence, we specialize in providing comprehensive Cyber Security solutions, reinforcing our dedication to safeguarding your digital landscape.
EPAMHyderabad
Software Developer
05.2020 - 02.2021
Job overview
- Developed CacheDB application for confidential client, improving data management efficiency for My Vodafone Business.
- Designed and implemented end-to-end CI/CD pipelines using Azure DevOps for automated build, test, and deployment workflows.
- Implemented CI/CD practices using Git for version control, streamlining code changes through effective merge request processes.
- Deployed and monitored data pipelines, ensuring operational reliability in production environments and reducing downtime.
- Developed and executed API tests using Cypress for validating backend services.
- Implemented parameterized SQL queries in automated test scripts for dynamic and versatile data validation.
- Developed, tested, and debugged PLSQL code to facilitate live migration from Oracle 11g to Oracle 12c environment, utilizing in-memory concepts.
- Designing packages, stored procedure, functions as per functional Requirement.
- Worked for IDEA and Confidential consolidation project. Designed and developed process and programs for MVA and MVB data consolidation.
- Created complex queries, functions, and materialized views.
- Conducted performance testing of React applications to identify bottlenecks and optimize load times using tools like Lighthouse and WebPageTest.
- EPAM (NYSE:EPAM) is a global leader in AI transformation engineering and integrated consulting, serving Forbes Global 2000 companies and ambitious startups.
- Environment: AWS, Azure, Snowflake, SQL Server, PostgreSQL, React UI, JavaScript, ES6, MongoDB, automation testing using Selenium, Appium, Python (Pandas, NumPy), PySpark.
Education
University of North Texas
Masters from Computer Science
Anurag Group of Institutions
Bachelor of Science from Computer Science
Skills
- Java
- AEM 65
- AEM 62
- Adobe CQ5
- PHP
- JavaScript
- HTML5
- CSS3
- JSP
- Servlet
- XML
- JSON
- RESTful API
- Webservices
- Ajax
- DOM
- JQuery
- Free Marker
- Apache HTTP Server
- Selenium
- Cucumber
- SpecFlow
- SoapUI
- Postman
- JMeter
- Maven
- GIT
- SVN
- Command Line Interface
- Containerization
- Windows
- Linux
- MySQL
- Oracle
- Mongo DB
- Data Integration
- Data Warehousing
- Data Analytics
- QC
- Issue tracking
- Cloud Computing
- Eclipse IDE
- Oracle SQL Developer
- Issue tracking
- Data Integration
- Cloud Computing
- Data Warehousing
- Data Analytics
- Webservices
Work Preference
Job Search Status
Open to workSalary Range
$45000/yr - $200000/yrTimeline
Software Developer
Impelsys USA
02.2025 - Current
Software Developer
Synchrony USA
02.2023 - 01.2025
Software Developer
Lexicon Infotech Limited
02.2021 - 01.2022
Software Developer
EPAM
05.2020 - 02.2021
University of North Texas
Masters from Computer Science
Anurag Group of Institutions
Bachelor of Science from Computer Science