Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
Generic

Archit Trivedi

Marshalltown,IA

Summary

Experienced Senior Business Systems Analyst with a 7-year background performing analysis on various business platforms and technologies. Adept at supporting quality software development projects and developing functional and technical specifications. Proficient in working knowledge around Annuity Policy Admin system like ALIP and OPAS, Commission Management system like DCM, Payment systems like DTCC and Web Series and Accounting system like FAH/R12.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Business Systems Analyst

Athene Annuities
West Des Moines, IA
02.2021 - Current
  • Worked on Annuity source system ALIP, commission management system DCM, payment systems like CAPS, DTCC COM/STL to develop automated ledger entries via FAH/R12.
  • Got involved in accounting for Annuity, Registered and Variable accounting products.
  • Assisted building requirements to generate automated ledger entries rolling up to Common, GAAP and STAT ledger.
  • Provided and supported implementation of business solutions by identifying business needs and carrying out necessary practices and processes.
  • Identified areas of possible system improvement to enhance overall business performance, accounting for budgetary concerns and business goals.
  • Audited multi-system installations for conformance to business objectives, suggesting changes to meet performance thresholds.
  • Determined operational objectives by studying business functions, gathering information and evaluating output requirements and formats.
  • Utilized change management techniques to provide smooth transitions during new coding, configurations and infrastructure introductions.
  • Trained junior personnel in Policy Admin Operations Accounting during onboarding and through remedial education.
  • Improved systems by studying current practices and designing modifications.
  • Conducted meetings with stakeholders to discuss program specifications and process models.
  • Monitored project progress by tracking activities and publishing progress reports.
  • Elicited and clearly documented business and system requirements.
  • Performed internal system acceptance to deliver well-tested enhancements and meet business requirements.
  • Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.
  • Enhanced project management skills by defining and presenting system solutions and timelines for business needs or technical problems.
  • Analyzed existing systems and databases and recommended enhancements to solve business needs
  • Communicated and explained business requirements to team members to understand and implement functional demands.
  • Developed diagrams to describe and lay out logical operational steps.

IT QA Test Analyst III/QA Lead

Athene Annuities
West Des Moines, IA
08.2018 - 01.2021
  • Developed monthly, end-of-quarter and other statistical reports for leadership team and quality improvement programs.
  • Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
  • Collected and analyzed data and initiated improvements to increase security and performance.
  • Monitored KPIs to proactively address bottlenecks and quality issues.
  • Performing design, system analysis and programming activities related to automation of test cases for internal applications. (Technologies Used: SQL for ETL Validation and core Java)
  • Coordinated, analyzed, and worked on programming automation testing and system solutions.
  • Assisted with verification of requirements, design, and technical specifications.
  • Coordinated test data management in different environments.
  • Analyzed business requirements for testability and completeness using Functional Specification Documents, Business Requirement Documents and Technical Design Documents.
  • Developed requirements into test conditions, cases, and scripts, developed and executed automation scripts.
  • Logged, tracked, and verified resolution of software and specification defects using ALM/Quality Center, Zephyr JIRA plugin and qTest Test Management tools.
  • Developed and maintained quality assurance procedure documentation.
  • Used SQL queries to generate customized reports out of ALM, JIRA and qTest.
  • Communicated effectively and timely with onshore and offshore resources.
  • Coordinated daily activities and tasks of our offshore GDP (Global Delivery Partners) resources

IT QA Test Analyst II

Athene Annuities
West Des Moines, IA
02.2016 - 07.2018
  • Performed ETL Testing, Database Testing, UI Testing on Investment Accounting applications.
  • Carried out Boundary Value Analysis, Random Testing, Coverage Based Testing, Negative Testing, Smoke Testing, Regression Testing, System Testing in different Sprints.
  • Managed offshore testing team with their day to day testing strategy and activities, worked towards Testing Process Maturity.
  • Worked in Waterfall, Iterative and Agile based testing methodologies.
  • Used SQL, SSMS in order to carry out ETL Testing.
  • Utilized JIRA, Spreadsheet Compare, QC ALM 11/12.53 as Tools for Test Case Design, Test Case Execution, Requirement Coverage, Defect Management.

Grader

University Of Texas At Dallas
Richardson, TX
06.2014 - 05.2015
  • Assisted professors with classroom management and document coordination to maintain positive learning environment.
  • Set up visual aids, equipment and classroom displays to support professor's lesson delivery.
  • Graded for Java and C++ based projects and assignments.
  • Guided students in their projects and assignments by solving their queries and providing solutions.
  • Assisted students with infrastructure and resource setup for their projects.
  • Performed Code Reviews and Plagiarism Detection using Moss Tool.
  • Conducted workshops and camps of JavaScript, Java, .NET, Made with Code for high school students under CS Outreach Program held by Computer Science Department of University of Texas at Dallas.

Intern

Bharat Sanchar Nigam Limited, BSNL
Nadiad, Gujarat
06.2011 - 07.2011
  • Got training in Telecom Technologies with hands on experience over BTS and various Router’s / modem’s configuration, learned various networking technologies.
  • Responsible for designing architecture, Network Coverage Testing using CISCO Packet Tracer Software and testing the network.

Education

Master of Science - Computer Science

The University of Texas At Dallas
Richardson, TX
05.2015

Bachelor of Engineering - Computer Engineering

Gujarat Technological University
Ahmedabad
05.2013

Skills

  • Information Processing
  • Functional Improvements
  • Unstructured Data
  • Rational Rose
  • Business Processes and Procedures
  • Business Requirements Documents (BRDs)
  • Activity Diagram
  • Requirements Definition
  • Scrum Methodology
  • User Acceptance Testing (UAT)
  • Process Flow Diagram Creation
  • Coordinating Personnel
  • Leading Projects
  • Requirements Traceability Matrix (RTM)
  • HP Quality Centers
  • Business and Technical Analysis
  • UAT Support
  • Bug Resolution
  • Data Flow Diagrams (DFDs)
  • System Integration Testing
  • Writing Stories
  • SQL
  • qTest
  • JIRA
  • Confluence
  • Zephyr Plugin
  • Annuity Knowledge
  • Annuity Accounting

Accomplishments

  • Provisional Scholarship from Government of Gujarat for outstanding performance in Science school.
  • Won Hackathon in 2015 organized by PayPal at their headquarters in San Jose.

Certification

  • FSRI (Fellow Secure Retirement Institute) Level 1 by LOMA
  • ASRI (Associate Secure Retirement Institute) by LOMA
  • CFTL (Certified Tester Foundation Level) by ISTQB
  • CFTL - AT (Certified Tester Foundation Level - Agile Tester) by ISTQB
  • Scrum Fundamentals Certification by Scrum Study
  • Scrum Developer Certification by Scrum Study
  • Scrum Masters Certification by Scrum Study


Languages

English
Native or Bilingual
Hindi
Native or Bilingual
Gujarati
Native or Bilingual

Timeline

Senior Business Systems Analyst

Athene Annuities
02.2021 - Current

IT QA Test Analyst III/QA Lead

Athene Annuities
08.2018 - 01.2021

IT QA Test Analyst II

Athene Annuities
02.2016 - 07.2018

Grader

University Of Texas At Dallas
06.2014 - 05.2015

Intern

Bharat Sanchar Nigam Limited, BSNL
06.2011 - 07.2011

Master of Science - Computer Science

The University of Texas At Dallas

Bachelor of Engineering - Computer Engineering

Gujarat Technological University
Archit Trivedi