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