Software Engineer Senior

Priyadharshini Balraaj

Senior Software Engineer

Phone: 469-***-**** Email: ***************@*****.*** SUMMARY

• Overall, 10 years of IT Industry experience in ETL/ELT Tools, Azure/AWS Services and Business Intelligence in analysis, design, development, testing and deploying various software applications.

• Experience in Performance Testing and various testing methodologies implementing Automation Framework using JMeter, VUGen, LoadRunner, Selenium with Java and Unix Shell Scripting.

• Involved in developing load and performance test scripts with strong working knowledge in Web HTTP/HTML, Web Services, Client/Server Protocols, Directory services protocols such as LDAP using JMeter.

• Having good experience in developing Spark processing frameworks using PySpark and Spark SQL in Azure Databricks for extract, transform and load data for various big data file formats and other file formats.

• Having good experience in Azure SQL DW, Azure Data Lake Gen2, Azure Blob Storage services.

• Experience in developing pipelines, data driven workflows for data movements and transformations as part of ETL/ELT process using Azure Data Factory.

• Experienced with REST, JSON, XML, BeanShell and JavaScript.

• Experience with JMeter to create thread groups to test the web applications for various loads on key business scenarios.

• Analyzed JMeter results using various listeners to get the performance stats of the test such as response time, throughput.

• Experienced in identifying the KPIs that need to be monitored in identifying success and results.

• Experience in performance resilience testing on the web applications to measure their performance and behavior in chaotic conditions.

• Leveraged profiling tools (i.e. Dynatrace) to analyze and define performance characteristics of an application, recommended enhancements and trouble shoot bottlenecks like CPU Utilization, memory Utilization.

• Extensive knowledge in creating Business Requirement Document, Functional, Technical Specifications and QA test strategy.

• Worked on Power BI for developing dashboards and reports for data visualization and business analytics.

• Performed various types of testing including Functional, Performance, Load, Stress, Smoke, Black-Box Testing, White-Box Testing and UAT Testing.

• Experience in gathering System specifications, Functional and Technical requirements.

• Implemented & Managed the Continuous Integration/Deployment pipeline using TeamCity tool.

• Developed file comparison script using Perl Scripting.

• Automated SIT Testing for various applications like Credit Risk, Market Risk using Unix Shell Scripting, monitored the status of feeds in the application and generated automated reports showing the feed performance using HTML.

• Developed and executed automated test scripts using Selenium WebDriver with Java for web applications using Maven dependencies.

• Having Deep knowledge in Mobile Automation Testing for iOS and Android native mobile apps using Appium, Java, Selenium, and IntelliJ.

• Knowledge in working with Appium Drivers using Desired capabilities based on the platform.

• Expert knowledge in test case automation involving multi-tiered architecture using CA LISA DevTest Application.

• Experience in synthetic data generation for testing based on rules using GT Data Maker.

• Excellent interpersonal and communication skills and the ability to provide solutions from a functional and technical perspective, meet deadlines.

• Demonstrated ability to rapidly learn and apply new technologies and improve processes to make an impact as a productive individual contributor as well as team player.

• Worked in different software environments and can easily fit into new environments if required.

• Strong knowledge of the SDLC, Change Management, Quality Assurance, test case management and bug reporting tools.

• Expert knowledge in SQL and Database Performance tuning.

• Monitored project timelines using JIRA.

• Expertise in Test Management and Bug Tracking tools like Quality Center, ALM.

• Automated test reports using HTML5.

• Have good knowledge in Python.

SKILLS

• Programming Languages: C, C++, Shell Scripting, Perl Scripting, BeanShell, JAVA, Python, HTML5, PySpark, Spark SQL

• Microsoft Cloud Services: Azure Data Bricks, Azure Data Factory, Azure Synapse Analytics, ADLS Gen2, Blob Storage, Azure Data Lake or Delta Lake

• Amazon Web Services: S3, EC2, IAM, Lambda, Stepfunction, EMR

• Database Management: MYSQL, Oracle

• Testing Tools: JMeter, VUGen, LoadRunner, Selenium, Appium, IntelliJ, Eclipse, CA LISA DevTest Application, GT DataMaker

• CI/CD Automation: GitAction, Jenkins, Terraform, TeamCity

• Operating Systems: UNIX, MS Windows

• Software Development Methodology: Agile, Waterfall

• Scheduling Tools: Databricks Scheduler

• Data Visualization: Power BI

• Version Control: GitHub, SVN

• Defect Tracking: JIRA and ALM

WORK EXPERIENCE

The Bank of Nova Scotia, operating as Scotiabank, Canada July 2020 – Dec 2023 Senior Software Engineer

• Established metadata framework within Azure Data Factory for improved data management and organization.

• Involved in requirement gathering and design discussions to ensure alignment with project objectives.

• Implemented transformations and business logic using SparkSQL within Databricks notebooks to ingest data from the bronze layer to silver and gold layers.

• Utilized Databricks notebooks with PySpark & SparkSQL to register and transform large volumes of raw data into structured formats.

• Implemented parameterized linked services and datasets within Azure Data Factory (ADF) to enhance pipeline flexibility, reusability and efficiency in our data extraction processes.

• Written SparkSQL, PySpark transformations in Databricks notebooks to facilitate data movement across different layers in ADLS and Database.

• Implemented automation workflows.

• Collaborated with Dev Team, Business stakeholders, Product Owner to analyze the testing scope, create test plan, create tasks and subtasks with the required estimates (story points) for testing.

• Worked on synthetic data generation for testing various scenarios based on rules provided by Business Analyst using GT Data Maker.

• Created traceability matrix to ensure all the requirements are traceable with use cases and test scripts.

• Automated the test scripts using Selenium WebDriver Framework with Java using synthetic data being the test data as part of regression testing.

• Automated performance/load test scripts using JMeter and BeanShell scripting, managing the load under test using Thread Group and analyzed performance test results such as Throughput, Response Time etc. using various types of listeners.

• Integrated the E2E flow and DB validations using CA LISA DevTest Application installed in a Unix test Environment and the test results are published in DevTest Portal and stored in a Database.

• Automated the test report based on the test results published in DevTest Portal and Database using HTML5 for better understanding to signoff the testing for the release.

• Identified bugs/issues if any during the testing process and reported to Developers using JIRA and ALM.

• Closely worked with Development and Business Analyst to create test scenarios based on KPIs. Credit Suisse June 2015 – June 2020

Application Development Senior Analyst

• Designed, executed, and maintained load/performance test scripts using Web HTTP/HTML, Web Services, Client - server protocols, Directory Services Protocols in JMeter with VUGen LoadRunner to record the request-response for the Web Applications.

• Responsible for E2E testing of the applications including - Unit Testing, Smoke, Functional, Stress, Performance and Regression Testing.

• Analyzed the results of the test and reported bugs to the development team.

• Created One Click Automation framework in Unix Shell Scripting to run/execute robust data feed files in the application server using CA LISA DevTest tool.

• Integrated AWS Lambda functions to perform serverless transformations and enrichments in data pipelines.

• Created and managed data lakes on Amazon S3, implementing efficient storage and access patterns (e.g., partitioning, Parquet, and ORC formats) for big data workloads.

• Integrated the code using TeamCity CI/CD framework and created builds to execute the test.

• Collected the status of feed files from application database (SQLDBX), published it to TeamCity artifacts and stored in Database (Oracle PL/SQL) for report generation using charts/tables in HTML5.

• Designed and implemented IAM roles and policies for fine-grained access control across AWS services, ensuring data security and compliance with organizational policies

• Worked on Defect Management using JIRA and Quality Center.

• Experience with centralized version control system such as Subversion (SVN).

• Proven ability to work in fast-paced, deadline-driven environments.

• Developed file comparison script to compare PROD and UAT files having 100+ columns and millions of records and highlighted the differences in an excel file using Perl Scripting.

• Achieved 100% success rate across all performance tests conducted due diligence during every step of the process; monitored client feedback closely & implemented necessary changes within 24 hours where required.

• Received “Client Championship Award” from the client for my continuous commitment in innovation and automation. EDUCATION

Bachelors in Chemical Engineering Aug 2011 – May 2015 Anna University, Chennai, India

CERTIFICATIONS

• Certified in C, C++ Programming from National Institute of Information Technology (NIIT), Chennai, India.

• Microsoft Certified: Azure Developer Associate.

Contact this candidate