Sneha Kumar
Merrimack
Summary
Experienced systems analyst with a strong foundation in data analysis and process automation. Implemented automation for Jira and Jira Align through Java and AWS, improving efficiency for a large user base. Developed insightful dashboards in Power BI and Tableau to facilitate informed decision-making. Dedicated to applying analytical expertise to foster business enhancements.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Principal Systems Analyst
Fidelity Investments
Merrimack
01.2024 - Current
- Modeled raw data into insightful reports that facilitated informed decision-making.
- Developed interactive dashboards leveraging Power BI to improve data presentation.
- Developed interactive dashboards using Tableau for data visualization and reporting.
- Improved report efficiency by refining DAX calculations and queries.
- Collaborated with cross-functional teams to gather requirements and define project scope.
- Assessed design feasibility through analysis of user needs and software requirements.
- Coordinated testing and validation processes during software development phases to ensure quality assurance.
- Partnered with developers to quickly address and fix defects.
Senior Systems Analyst
Fidelity Investments
Merrimack
01.2022 - 12.2023
- Developed automation utilities in Java, utilizing REST Assured to migrate 30,000 users and update 900 epic estimations, saving 100 hours of manual effort.
- Deployed six AWS Lambda functions within Confluence development infrastructure for automated data refresh.
- Analyzed Jira API node configuration, adding two nodes in AWS to prevent data discrepancies in Jira Align during API downtime.
- Evaluated Jira Align API responses for objectives, user programs, and portfolio data using Swagger Postman.
- Investigated complex issues, identifying root causes, and reported findings to vendor for Jira Align.
- Created Tableau reports to visualize data from PostgreSQL, Oracle, and Snowflake databases.
- Collaborated with cross-functional teams to implement technologies addressing complex business challenges.
- Participated in daily scrum sessions for sprint planning and backlog grooming to enhance project progress.
Test Automation Engineer
Fidelity Investments
Merrimack
08.2019 - 01.2022
- Leveraged CTG Test Automation Framework to build automation scripts with Selenium Web driver, Core Java, TestNG, POM, and Maven, validating 15,000 user statuses in Jira Align and integrating code in Jenkins & XRAY test management tool.
- Analyzed Jira Align API responses for objectives, users, programs, and portfolio data and utilized Swagger, Postman, and Rest Assured in Java for validating the same.
- Executed stored procedures and SQL queries to validate data from Domo Goals and Jira Align in Oracle database, ensuring accuracy and integrity of information across Leo BI and RDS Oracle Database Tables.
- Validated data in Snowflake database tables using Snow SQL queries and utilized ICEDQ for data validation to ensure that the right data is getting ingested from source and made accessible for Domo BI dataset reports.
- Performed integration testing to validate data flow from various sources to AWS S3 Bucket and Snowflake Data Lake, utilizing Java JSON Jackson library, NiFi, and control-m.
- Conducted regression testing on Jira Align components to validate vendor defect fixes.
- Developed regression testing suite for validating integration between Domo Goals and Jira Align Objectives.
- Worked with Developers to analyze on critical bugs introduced due to code changes or defect fixes and proactively worked on root cause analysis to help triage issues.
- Effectively added test cases in XRAY and implemented continuous integration testing using Jenkins, Git, Artifactory, Maven.
Test Engineering Senior Analyst
Accenture
Irving
04.2018 - 09.2019
- Led testing team of 4, managing test deliverables including Test Strategy, Test Plan, Test Scenarios, and designing manual and automated Test cases while documenting defects in Jira.
- Surpassed 86% test automation goal by adding more functional test cases and cut down the manual execution time by 70%.
- Developed and executed Data Driven Test automation test scripts using Selenium WebDriver, Core Java, TestNG, Apache POI, JDBC Connections, Maven, Junit for Banking application.
- Performed API testing using Rest Assured & Karate, mocked APIs using Mockoon, validated API response using Postman.
- Executed complex SQL Queries in Oracle & MS SQL database tables to validate the data against data quality rules.
- Collaborated with business users, developers, and product owners to establish testing standards and clarify requirements, contributing to achievement of business goals.
Application Development Senior Analyst
Accenture
Lake Oswego
01.2017 - 04.2018
- Implemented page object model (POM) based automation testing suite for claims processing web application using core Java, TestNG, Selenium WebDriver, and Maven.
- Increased test automation coverage by 40% through development and maintenance of manual and automated test cases.
- Contributed to functional integration and regression testing cycles by creating baseline test scripts and formulating comprehensive test scenarios.
- Tracked defects in HP ALM, re-tested defect fixes, and executed regression tests to ensure quality assurance.
- Participated in agile/scrum activities to promote team collaboration and enhance project progress during daily scrums, sprint reviews, and retrospectives.
Application Development Analyst
Accenture
Branchburg Township
06.2014 - 01.2017
- Developed and deployed MS SharePoint 2010 and 2013 application websites, configuring fast search components.
- Migrated sites to Office 365, enhancing accessibility and user experience.
- Enhanced email notification system for contact form submissions using HTML, JavaScript, jQuery, and C#.
Associate Software Engineer
Accenture
Mumbai
03.2010 - 05.2014
- Migrated legacy website to MS SharePoint 2010, maintaining system reliability through upgrades and security patches using PowerShell.
- Customized web pages by integrating external data sources and developing InfoPath forms and workflows.
- Developed software solutions for client projects utilizing Java and Python.
- Migrated legacy website to MS SharePoint 2010 and maintained through upgrades and security patches using PowerShell, ensuring system reliability.
- Conducted code reviews to ensure quality and adherence to established standards.
Education
Bachelor of Engineering - Computer Technology
Skills
- Programming Languages: Core Java, Python, SQL, HTML
- Data & Analytics: Snowflake, PostgreSQL, Oracle, RDS, Tableau, Power BI, JSON
- Cloud Services (AWS): S3, EC2, Lambda, RDS
- Testing & Automation: Selenium WebDriver, TestNG, API Testing (Postman, Swagger), Quality Assurance
- DevOps & Tools: Git, Jenkins, Maven, Artifactory, Eclipse IDE, Visual Studio Code
- Project Management: Jira, Confluence, Requirements Gathering, Systems Analysis
- Core Competencies: Problem Solving, Data Visualization, Attention to Detail, Automation Scripting
Certification
AWS Certified Cloud Practitioner (CLF-C01)
Timeline
Principal Systems Analyst
Fidelity Investments
01.2024 - Current
Senior Systems Analyst
Fidelity Investments
01.2022 - 12.2023
Test Automation Engineer
Fidelity Investments
08.2019 - 01.2022
Test Engineering Senior Analyst
Accenture
04.2018 - 09.2019
Application Development Senior Analyst
Accenture
01.2017 - 04.2018
Application Development Analyst
Accenture
06.2014 - 01.2017
Associate Software Engineer
Accenture
03.2010 - 05.2014