Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

FREEDA P UTHUPPAN

SENIOR DATA ANALYST
CHATSWORTH,CA

Summary

  • Detail-focused Data Analyst with knowledge in data warehousing, and process validation Proven to understand customer requirements and translate into actionable project plans.
  • Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
  • 16+ years of experience in the software industry.
  • Backed by strong credentials including a computer science degree, Master’s in business administration, Certified in Scaled Agile –SAFE FOR TEAMS and a ISTQB certificate, an advanced command of testing suites, agile methodologies and monitoring tools.

Overview

17
17
years of professional experience
4
4
Certifications

Work History

Senior Data Analyst/ETL Software Developer

Tetrasoft Inc
Los Angeles, CA
07.2021 - Current
  • Participated in requirements meetings to understand business needs.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Designed and developed data pipelines to acquire, clean and process data.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Leveraged text, charts and graphs to communicate findings in understandable format.
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.

ETL Data Analyst/ Senior System Analyst/Lead

SPS Provider R6 Migration(Elevance Health (Client)
Woodland Hills, CA
07.2023 - Current
  • Analyzing the issues reported by downstream teams and reporting the root cause of the issue
  • Work with various teams to fix the root cause so that claims are not impacted
  • Coordinate with multiple teams to ensure smooth transitioning of information is exchanged to support business continuity
  • Scheduling calls with different teams and triaging the issues, making those to closure.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Participated in requirements meetings to understand business needs.
  • Provided technical support for troubleshooting analytics and reporting issues.

ETL Data Analyst/ Senior System Analyst

SPS Provider CPF Migration( Elevance Health)
Woodland Hills, CA
04.2023 - 06.2023
  • Analyzing the issues reported by downstream teams and reporting the root cause of the issue
  • Work with various teams to fix the root cause so that claims are not impacted
  • Coordinate with multiple teams to ensure smooth transitioning of information is exchanged to support business continuity.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Generated ad-hoc reports to evaluate specific business requirements.

Senior ETL Analyst/Senior System Analyst

SPS Provider Digital Enrollment (Elevance Health)
Woodland Hills, CA
10.2022 - 03.2023


  • Creating quality input files for Dart as per the business need by writing Oracle SQL queries
  • Make sure all features are developed as per acceptance criteria
  • Validation of the providers after the Dart file load is completed to ensure the business needs are met.
  • Validated results and performed quality assurance to assess accuracy of data.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Queried databases for information needed for report processing.
  • Identified and resolved problems through root cause analysis and research.
  • Recommended process improvements to continually identify, analyze and fix constraints and challenges.

Senior ETL Quality Analyst/Developer

SPS DART Support (Elevance Health)
Woodland Hills, CA
01.2022 - 09.2022
  • Creating quality test files as per the business need by writing Oracle SQL queries
  • Make sure all features are developed as per acceptance criteria
  • ETL testing in all phases of the project ensuring no data loss from source files to target system
  • Detailed and Extensive testing includes validation of data mappings from source to target, writing complex SQL queries to verify data transformations, and assuring the correct data is loaded in target system.
  • Collaborated with management to provide training on improved processes and assisted with creation and maintenance of quality training.
  • Developed and maintained quality assurance procedure documentation.
  • Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
  • Defined and implemented quality initiatives to reduce risk.
  • Led process improvement projects to help operations meet and exceed quality standards and reduce costs.

Senior Quality Analyst/Developer/ETL tester

SPS ACES Data Migration (Elevance Health)
Woodland Hills, CA
07.2021 - 12.2021


  • Creating detailed, comprehensive and well-structured test plans and test cases
  • Plan and perform quality testing activities
  • Make sure all features are developed as per acceptance criteria
  • Work along with Test Automation Team giving the necessary domain knowledge and details needed for the scripts and assist in the Failure analysis
  • ETL testing in all phases of the migration project ensuring no data loss from source system to target system
  • Detailed and Extensive testing includes validation of data mappings from source to target, writing complex SQL queries to verify data transformations, and assuring the correct data is loaded in target system
  • Failure /Fallout analysis of data in different reports related to with business rules and Safety net errors
  • Logging defects, triaging those and giving the necessary guidance to different teams involved in data migration
  • Giving warranty support and analyzing the issues/defects reported by downstream systems.
  • Oversaw test planning, workload balancing and assignment delegation.
  • Created test cases and automation scripts.
  • Performed regression, exploratory and negative tests.
  • Communicated between product owners and developers to clarify features.
  • Developed and maintained quality assurance procedure documentation.

Senior Software Quality Analyst

UST Global Pvt Ltd
Los Angeles, CA
12.2015 - 07.2021
  • Recommended changes and corrections to developers for optimal software performance and usability.
  • Authored and maintained well-organized, efficient and successful manual test cases for entire team.
  • Tested functional and compatibility of new programs or updates in comparison to existing applications.
  • Advised developers on problems with databases, performance and other issues.
  • Kept scripts and test cases updated with current requirements.
  • Documented testing procedures for developers and future testing use.
  • Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
  • Monitored resolution of bugs, tested fixes and helped developers tackle ongoing problems by providing QA perspective.

Senior ETL Quality Analyst

SPS GA Data
Woodland Hills, CA
10.2020 - 06.2021


  • Creating detailed, comprehensive, and well-structured test plans and test cases
  • Plan and perform quality testing activities
  • Make sure all features are developed as per acceptance criteria
  • Work along with Test Automation Team giving the necessary domain knowledge and details needed for the scripts and assist in the Failure analysis
  • ETL testing in all phases of the migration project ensuring no data loss from source system to target system
  • Detailed and Extensive testing includes validation of data mappings from source to target, writing SQL queries to verify data transformations, and assuring the correct data is loaded in target system
  • Failure /Fallout analysis of data in different reports related to with business rules and Safety net errors
  • Logging defects, triaging those and giving the necessary guidance to different teams involved in data migration
  • Giving warranty support and analyzing the issues/defects reported by downstream systems
  • Provider Finder-‘Find a Doctor’ Application.
  • Collaborated with management to provide training on improved processes and assisted with creation and maintenance of quality training.
  • Developed and maintained quality assurance procedure documentation.

Senior Systems Analyst

Provider Finder-‘Find A Doctor’ Application
Woodland Hills, CA
04.2019 - 10.2020
  • Roles and Responsibility summary:
  • Instrumental in identifying and documenting the scope of the project, establishing timelines, researching and creating technical and business data documents
  • Involved in gathering functional, business and technical Requirements, solution design, Reviews and functional clarifications, Functional & Integration Tests and identifying the processes
  • Documented the requirements as Business Requirement Documents (BRD) for the business users and as Detailed Functional Design Documents (FDD) for development team
  • Created and documented the functionality of the system using Process Flow Diagrams, Data Flow Diagrams and Agile User stories in JIRA
  • Act as a liaison between the business users and the Technology team to better present the requirements
  • Established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents
  • Provided detailed analysis of data issue, mapping data from source to target, design and data cleansing on Data Warehouse
  • Worked as a team in conducting Gap Analysis on requirements traceability matrix to identify data anomalies and determined the cause/scope for these anomalies and suggested options for conversion and cleanup of data
  • Assisted the team on UAT and production testing
  • Sales Compensation and Licensing & Credentialing
  • Analyzed proposed and extant systems for technological limitations and conformation with current technology needs.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Resolved malfunctions with systems and programs through troubleshooting.

Test Analyst, Onsite Lead, Offshore

Sales Compensation And Licensing & Credentialing
Woodland Hills, CA
06.2017 - 03.2019
  • Lead
  • Roles and Responsibility summary:
  • Lead a 10-15 members UAT team in different Health Insurance Projects
  • Strong Business Knowledge in Individual, Small group and Large Group Business in Sales Compensation division
  • Provide Business analysis service and work closely with Anthem teams including business users of Anthem applications, project business sponsors and related IT contacts
  • Work to collate the project business requirements documentation, Project Management artifacts for identified projects and execute on the BA/SME/team deliverables stemming from the requirements
  • Perform requirements gathering and analysis, create Business Test plan and Test metrics and Test evaluation summary document
  • Preparation of test plans, test cases, test data and test scripts for the testing of software component(s), per company guidelines and standards
  • Provide accurate documentation of defects identified during testing to IT Team and track the defects to closure
  • Provide business sign off for User Acceptance Testing for various projects that provide expert support & guidance in the niche areas of Performance, Usability and functional testing
  • Define, maintain and share testing and quality best practices
  • Coordinating with business clients, supporting the application and implementing the process as per specifications provided.
  • Documented integration issues and vulnerabilities and outlined improvement recommendations.
  • Created successful test scripts to manage automated feature testing,
  • Identified bugs and issues within system and applied troubleshooting techniques for mitigation purposes.
  • Input test results to relational database management software for use in metadata compilation and study and consultation in future test design.

Test Analyst, Onsite Lead

WellPoint, V2 (Elevance Health)
Woodland Hills, CA
12.2015 - 05.2017
  • Interact with the client to ensure quality deliverables and work as an onsite QA lead
  • Involved in requirement walkthrough sessions and provide suggestions to clarify the requirements
  • Analyse requirement specifications, create a Requirement Traceability Matrix and contribute to developing the Test Strategy
  • Leading the frontend (Java/ETL) testing team
  • Develop /Review Test plan, Test strategies and Test scenarios
  • Involved in Smoke, Functional, Integration and Regression Testing
  • Involved in Database Testing
  • Documented integration issues and vulnerabilities and outlined improvement recommendations.
  • Created successful test scripts to manage automated feature testing,

Senior Test Engineer, Offshore Tester

UST Global Trivandrum
TRIVANDRUM, KERALA INDIA
10.2010 - 12.2015
  • Wrote and executed effective functional tests and carried out exploratory testing to assess product performance.
  • Supported, implemented and helped shape test approach by identifying solutions to recurring issues.
  • Defined and tracked test results, defect counts and performance discrepancies.
  • Trained junior testers in company standards, testing protocols and testing software.
  • Integrated collected data into business process enhancements to address ongoing business goals.
  • Maintained QA expertise in several programming languages.
  • Reproduced defects and documented findings.

Senior Test Engineer, Offshore Tester

Enterprise Provider Database Solution (Anthem)
Thiruvanthapuram, Kerala
07.2011 - 12.2023
  • Involved in frontend (Java) testing.

· Involved in Smoke, Functional, Integration and Regression Testing.

  • Involved in Database Testing.
  • Develop System Test Cases which clearly trace to software requirements and end-product requirements as per the Use Case and FDD documents.
  • Perform Requirement based testing.
  • Perform automation testing using QTP.
  • Conducted tests and diagnostic procedures using tools such as analyzers, multimeters, and power supplies.
  • Wrote and executed effective functional tests and carried out exploratory testing to assess product performance.
  • Analyse requirement specifications, create a Requirement Traceability Matrix and contribute to developing the Test Strategy.
  • Uploading the Test Cases in RQM.
  • Involved in preparation, reviews and updates Test Scenarios and other project documentation.
  • Reporting the Defects and posting them in the Defect tracking tool and keep track on them.
  • Worked as a Configuration Controller for the project.

Senior Test Engineer, Offshore Tester

ADESA
Thiruvanthapuram, Kerala,India
10.2010 - 06.2011
  • Creation and Execution of the test cases
  • Regression testing and Smoke testing
  • Bugs were reported and maintained through Clear Quest
  • Review of Test Cases
  • Interaction with onsite team to get clarification for bugs and resolve them
  • Wrote and executed effective functional tests and carried out exploratory testing to assess product performance.
  • Supported, implemented and helped shape test approach by identifying solutions to recurring issues.
  • Defined and tracked test results, defect counts and performance discrepancies.
  • Trained junior testers in company standards, testing protocols and testing software.

Script Developer /Test Engineer

Cell South Automation (Infosys Technologies Ltd)
04.2009 - 02.2010
  • Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
  • Script Designer
  • Script Developer
  • Integration Tester
  • Retesting the fixed defects.
  • Test script modifications.
  • Setting up the relevant setup (Test Environment) for Testing.

Test Engineer

British Telecom (Infosys Technologies Ltd.)
Thiruvanathapuram, Kerala,India
03.2007 - 04.2009
  • Communicated technical information both verbally and in writing in simple terminology.
  • Developed and maintained test and evaluation strategies for testing to show operational readiness and suitability with planned project decision points.
  • Researched new developments in testing methods and equipment and made recommendations to improve testing procedures.
  • Solved hardware and software interface issues to boost system integrity.
  • Developed comprehensive test plans and workforce breakdown structures for complete systems.

Education

Master of Business Administration - IT and Systems

ICFAI University

Bachelor of Computer Science - undefined

MG University

Completed Training Course - undefined

Infosys Learning Institute, Global Education Centre
Mysore, Karnataka

Skills

Tools: V B script, JavaScript, HTML, Visual basic, COBOL, HIVE, C, and Cundefined

Certification

Nternational Software Testing Qualifications Board

Timeline

ETL Data Analyst/ Senior System Analyst/Lead

SPS Provider R6 Migration(Elevance Health (Client)
07.2023 - Current

ETL Data Analyst/ Senior System Analyst

SPS Provider CPF Migration( Elevance Health)
04.2023 - 06.2023

Senior ETL Analyst/Senior System Analyst

SPS Provider Digital Enrollment (Elevance Health)
10.2022 - 03.2023

Senior ETL Quality Analyst/Developer

SPS DART Support (Elevance Health)
01.2022 - 09.2022

Senior Data Analyst/ETL Software Developer

Tetrasoft Inc
07.2021 - Current

Senior Quality Analyst/Developer/ETL tester

SPS ACES Data Migration (Elevance Health)
07.2021 - 12.2021

Senior ETL Quality Analyst

SPS GA Data
10.2020 - 06.2021

Senior Systems Analyst

Provider Finder-‘Find A Doctor’ Application
04.2019 - 10.2020

Test Analyst, Onsite Lead, Offshore

Sales Compensation And Licensing & Credentialing
06.2017 - 03.2019

Senior Software Quality Analyst

UST Global Pvt Ltd
12.2015 - 07.2021

Test Analyst, Onsite Lead

WellPoint, V2 (Elevance Health)
12.2015 - 05.2017

IBM Rational Functional Tester Certificate

07-2012

IBM Rational Manual Tester Certificate

07-2012

IBM Rational Performance Tester Certificate

07-2012

Nternational Software Testing Qualifications Board

01-2012

Senior Test Engineer, Offshore Tester

Enterprise Provider Database Solution (Anthem)
07.2011 - 12.2023

Senior Test Engineer, Offshore Tester

ADESA
10.2010 - 06.2011

Senior Test Engineer, Offshore Tester

UST Global Trivandrum
10.2010 - 12.2015

Script Developer /Test Engineer

Cell South Automation (Infosys Technologies Ltd)
04.2009 - 02.2010

Test Engineer

British Telecom (Infosys Technologies Ltd.)
03.2007 - 04.2009

Master of Business Administration - IT and Systems

ICFAI University

Bachelor of Computer Science - undefined

MG University

Completed Training Course - undefined

Infosys Learning Institute, Global Education Centre
FREEDA P UTHUPPANSENIOR DATA ANALYST