Data Financial Analyst
Resume:
Varma Kalidindi ETL, Database & Web Testing
Phone: 682-***-****
Email: adb4l8@r.postjobfree.com
Professional Summary:
15+ years of experience in ETL, Functional & Web services Testing with hands-on experience in Informatica, Oracle and SoapUI
Have also worked at Client location in an Onsite – Offshore model have carried out the different phases of the projects effectively by excellent co-ordination with all stakeholders
Worked extensively in Teradata databases, Content management, Document Management
Good working experience in Web services testing, Database, ETL tools – Informatica and Strong in other areas, Data Warehousing Concepts
Experience in Agile Methodology and other Testing approaches across Banking, Pharma, Manufacturing domains.
Experience in handling PHI & HIPAA Compliant projects and Claims related data and analysis
Hands on experience in Operations - Production Support/CR’s, QA and development
Familiar with tools like Informatica, Dollar U, HP Kintana, SoapUI, HP QC/ALM, JIRA
Extensive experience in Test data management and Test data generation
Experience in Analysis, Designing and Manual Testing Methodologies
Actively working in different phases of the software testing life cycle beginning with Requirements Gathering, test planning, test scenario and case design, Test data preparation, suite design, test case execution, defect management and reporting for projects across the STLC
Excellent Communication, presentation, interpersonal, intuitive, analysis and leadership skills
Creative problem solving/analytical skills, strong organizational skills, and the ability to understand new technologies quickly
Have the motivation to take independent responsibility and strong work ethic with desire to succeed and make significant contributions to the organization.
Strong interpersonal and team-player skills also motivated and dedicated to getting the job done right
Providing training to end users and post Implementation Support
Technical Expertise:
Tools
Informatica, TOAD, SoapUI, $U
Configuration Management Tool
HP Kintana
Test Management Tools
Quality Center, JIRA
Languages
Java, SQL
Scripting Languages
Unix Shell
Databases
Oracle, Teradata
Operating Systems
Windows XP, Windows 8
Educational Qualification
Degree Name
Bachelor’s degree in Computer Science
Project Experience
Project Name: Analytics 2.0 NCOTS, Client : Blue Cross Blue Shield Association July 2016 –June 2019
Test Lead
Project Description:
The Objective of Analytics 2.0 NCOTS Project is to replace existing third-party applications for the purpose of enhanced BI and Analytics. Analyze on Enrolment, Claims, Medicaid, Medicare, Benefits Affected by the ICD conversion and HIPAA complaint security issues which also supports HEDIS Reporting. claim highway is a platform which can receive various type of claims and route in appropriate exits.
Since this is FEP related project, cannot disclose much details.
Responsibilities
•Collaboratively elaborates analyse and estimates user requirements with the team
•Defines and manages test plans, strategies, results reporting and metrics
•Collaborates with the team to design test scenarios, build automated scripts and data and execute the scripts
•Validates test results and works with developers to research and resolve defects
•Identifies appropriate test strategy mix of manual and automation testing methods (leveraging automation where possible)
•Coordinates and plans test runs
•Maps requirements to tests and test results
•Creates and modifies detailed automated test scripts/modules
•Works with test automation architect to expand and/or improve automation framework and trouble shoot technical issues
•Maintains solid knowledge and expertise in automated testing tools and techniques
•Identifying Test scripts for a Regression Suite on Claims Highway
Environment: DB2, TOAD, Control Center, UNIX, AB Initio, JIRA, HP ALM
Project Name: Citi Financials, Client: Citi Group USA and Canada July 2016 –June 2019
Test Lead
Project Description:
The Objective of Harmony Project is to replace existing home grown backend application “Action” with industry pioneer FiServ’s LoanServ application. All Canada Data is moved to compatible FinServ databases through Ab Initio ETL. Fiserv exposes its services as web services which will be invoked by Citi’s TIBCO applications using SOAP protocol over http transport. This project will help CITI to cut the cost involved in loan processing by using the best services provided by the Fiserv in the banking domain.
Responsibilities
•Preparation of Test Plan.
•Understanding Technical Requirements.
•Involved in the Daily Scrum calls & Project related meetings.
•Review the Test Scenarios & Test cases.
•Continues Follow up with the development team for bug resolution.
•Involved in Defect triage call to discuss the defects and resolution.
•Executing and reporting the defects to developers on daily basis.
•Preparing Daily, Weekly & Defect status reports.
•Provided KT sessions to the team
•Mentoring and coaching juniors and new joiners in the project.
•UAT Test case Preparation document provided to UAT users
Environment: Oracle, XML, DAT, UNIX, AB Initio, Windows 8
Project Name: AGGS, Client: Genentech USA August 2014 –June 2016
Test Lead
Project Description:
The scope of the AGGS( Aggregate Spend Solutions) focuses on Federal, State, and Institutional policies, regulations, and laws around disclosure requirements, i.e. value that is provided to Healthcare Professionals (HCP’s) and organizations from Genentech, Inc. and Genentech, USA. Value can be given to HCP’s in the form of gifts, meals, services, and compensation paid for contracted services. Value can be given to Organizations for grants, contributions, and contracted services. The HCO requires the timely, complete, accurate and comprehensive tracking of meals, gifts, and payments associated with contracted services between Genentech and customers, including healthcare professionals, organizations, and institutions in our markets.
Responsibilities
•Requirement Assessment.
•Developing Functional and ETL, BO Reports Test Cases in Mercury Quality Center
•Execution of Functional and ETL, BO Reports Test Cases Test Cases.
•Verification if AGGS MGMT Tool Functionality.
•Verification of ETL Mappings in Various DB Schemas
•Verification of BO Reports and Data through Web services on SoapUI.
•Bug Reporting.
•Document preparation and Management
•UAT Test case Preparation document provided to UAT users
•Interact with Client on a daily basis and with the Onsite Coordinator whenever required to update the Status of the Offshore Activities.
•Prepared VBScripts for Data Comparison and Verifying the Spend Policy Rules
•Prepared VBScript to copy the Data from Excel to Mercury Quality Center
•Testing on mobile application with the live product testing.
Environment: Oracle, XML, Informatica, TOAD, SoapUI, APEX, Salesforce.com, Windows 8
Project Name: Moody’s Risk Analyst, Client: Scotia Bank, Canada July 2012 – Jul 2014
Test Lead
Project Description:
Scotia Bank currently uses two Moody’s Analytics software products – Moody’s Financial Analyst (MFA) and Moody’s Risk Advisor (MRA) to analyze the financial statements of non-retail borrowers and determine the bank’s internal risk ratings for those borrowers in order to achieve an “Advanced Internal Ratings Based (AIRB)” status. The MFA/MRA software product has been withdrawn from the market by Moody’s Analytics and it must be replaced with a newer version and the bank has decided to upgrade the existing MFA/MRA application to Risk Analyst in order to maintain the Bank’s Basel-compliant risk rating system. The Risk Analyst uses the Scotia banks standard defined terminology for the spreads and Rating Models named “Industry Model” like BNSCORP, BNSHIP, BNSCARIB, SBNSINT, etc. Moody’s RA will analyze customers’ financial statements and determine borrower risk ratings as a part of the credit origination and adjudication process in all of the Bank’s non-retail business lines.
Responsibilities
•Understand the Functional flow of the RA functionality and took part in part in the Test Plan preparation with the Lead and Preparing the Test Script flows.
•Understand the workflow of the application and the Changes in the upgrade
•Reviewed the functional, GUI and End to End test cases.
•Understand the main difference and analyse the impact of new features that differ from older version.
•Performed Black Box testing
•Involved in Peer-Review
•Conducted Functional Testing, GUI Testing and Regression
•Bug report generation, and reviewed the bugs
•Preparation of the Test scripts.
•Involved actively in Preparation of Test Plan.
•Identifying the critical business transactions.
•Scenario design.
•Analysing the Results
Environment: Oracle, XML and Moody’s Applications, Windows XP, Windows 2003 on Citrix
Project Name: Philips Test factory, Client: Philips, Nederland March 2011 - June 2012
Test Lead
Philips IT has different portfolio of applications CMC and DMS plays a key role in marketing Philips products online. Testing is performed rigorously for every new Interfacing and enhancement within CMC and DMS areas. Different kinds of data like PDF, Images, Video, textual information is extracted from different tools within specified locales.
Responsibilities
Analysis of the specifications provided by the client.
Helping the team to meet the base timelines.
Preparing Test Plans and getting them approved by the customer.
Participating in code reviews.
Coordinating with the stakeholders and notify the teams about the changes in the production codes.
Reviewing and Preparing the Test case scenarios
Providing sample test data and helping offshore team to prepare test data sets.
Reviewing Test defects and assigning to concern teams.
Following up with stake holders to zero defects.
Participating in Daily Weekly Meetings and reviews.
Environment: LCB for local content, Pikachu for XML parsing and interfacing, CCR for Images, Rendering for PDF content
Project Name: Cisco-EDW CQA, Client: Cisco INC April 2008 – Feb 2011
Module Lead
The application is Enterprise Data Warehouse – CISCO Quality Assurance.
This involves end to end functional testing of data which is done on individual tracks (subject areas).Loading data directly from source systems ODS i.e. (maintained on ORACLE DBMS) and reporting directly from EDW2B is the approach used.
Informatica is used as the primary ETL tool with possible use of Teradata SQL.
Teradata environment is used to support Staging, Error, Work and 3NF data Warehouse.
Data is extracted from source into flat files and subsequently loaded into Teradata staging tables.
ETL Approach is followed for all data loading into Teradata. Data is extracted from source and loaded into Teradata staging tables, having the same structure as source tables, using Teradata utilities.
Informatica will be used for transformation moving data from staging to work tables.
Data is then transformed, restructured, filtered, etc. into the normalized tables.
Finally Reports are generated by the users by the Business views built on these Normalized tables.
Responsibilities
•Analysis of the specifications provided by the client.
•Helping the team to meet the base timelines.
•Testing CRs (Change Requests) and deploying in production environment.
•Participating in code reviews.
•Coordinating with the stakeholders and notify the teams about the changes in the production codes.
•Reviewing and Preparing the Test case scenarios
•Loading the Data manually or through $U.
•Testing the data from source to Target.
•Resolving the Issues raised by the SIT and BAT teams
•Responsible for overseeing the Quality procedures related to the project.
•Assigning the work requests to the team members based on priority and commitment.
Environment:
Quality Center - for uploading Test cases, executing test cases & raising defects.
$U- Launching and scheduling the sessions for Data load to the Teradata environment.
Kintana- Code Migration to different Environments.
Project Name/Client: ACE- Aashray Real Estate September 2007 – March 2008
Module Lead
The present system of Aashray Real Estate is an automation process of buying and selling of land/ plots, Flats/Apartments for rent or lease etc., manually. The “Aashray Real estate Online” is designed to focus around Customer satisfaction and ease to maintain the system. This is an independent system which will be used to reduce the difficulty in activities like Data redundancy, insufficient information with the customer, Difficulty in generation of Lists.
Responsibilities
Involved in Prototype design using HTML and JavaScript.
Prepared System Requirement Speciation.
Prepared High-Level Design.
Hands on enhancements and coding.
Writing all Test Cases for Module.
Environment: NetBeans, Tomcat5.0, HP QC, Windows XP
Certifications
ITIL Foundation
ISTQB FOUNDATION LEVEL
SCJP 5.0 Sun Certified Programmer for the Java 2 Platform, Standard Edition 5.0
NCR Teradata Basics V2R5
Internal HIPAA Certifications by Tech Mahindra & BCBSA
Personal Details
Name
Venkata Satya Surya Ravi Kumar Varma Kalidindi
Email Id
adb4l8@r.postjobfree.com
Location
Plano, TX USA
Mobile
Visa
H1B Visa
Contact this candidate