Quality Assurance Engineer
Resume:
RAJENDRA NARAYANDAS (RAJ)
*************@*****.***
U.S.Residence Status: Green Card
PROFESSIONAL SUMMARY
• Over 14 years of experience in software quality assurance, business analysis and testing;
worked in all phases of software development life cycle, Software Testing Life Cycle and Defect
Life Cycle using industry accepted methodologies Agile Test Practice and Waterfall
• Experience in Insurance, Financials, Healthcare, Manufacture and Telecom industries.
• Experience in Guidewire Policy, Billing and Claims Center suite of products
• Experience in HealthCare Billing and Claims Processing systems.
• Knowledge in Edifecs technology/platform
• Set Testing Standards, implemented Best Practices and contributed for Process Improvement.
• Strong experience in writing Test Plans, Test Strategies, Test Scenarios, Test Cases, Test Scripts,
Test Reports, Test Coverage Matrix and Defect Metrics
• Performed regression testing using modular approach using User Defined Function Library,
Shared Object Repository, Static Data File, Calendar Sheet (Master Datasheet) and Dynamic
datasheet
• Participated in Test Review Meetings, Defect Triage Meetings, Mid Sprint Work Evaluations
• Thoroughly involved in Test Data Preparation and Test Environment set-up
• Strong experience in SOAP-UI, EDI, Quality Center, QTP and Business Process Testing
• Translated User Stories, Use Cases and Business Requirements into detailed test cases
• Vast experience in different testing procedures - Functional, Unit, Integration, Interface,
Regression, GUI, Browser Compatibility, Ad-hoc, Configuration, System Testing, Database
Testing, Performance, Endurance, Load & Stress Testing, UAT and Stability Testing
• Good working experience in using Black Box testing techniques like Boundary Value Analysis,
Equivalence Partitioning, Decision Tables
• Knowledge in Data Modeling using Ralph Kimball and Bill Inman’s approaches.
• Good knowledge of database schemas like star schema, snowflake schema in dimensional
modeling, Normalization, Business Process Analysis
• Clear understanding of OLTP, OLAP, Business Intelligence and Data Warehousing concepts
with emphasis on ETL transformations and reporting
• Good team player, quick learner, proactive, collaborative and self-starter, excellent oral and
written skills; worked under heavy work load and in fast pace environment
• Highly motivated, ability to work independently, organized and result oriented with excellent
interpersonal, communication and presentation skills with capability of adapting to new and fast
changing technologies
TECHNICAL SKILLS
Testing Tools: SOAP-UI, Quality Center, Quick Test Pro, WinRunner, Load Runner
OLAP Tools: Business Objects XI, InfoView, Webi, Designer, Dashboard Builder,
CMC/CMS/Supervisor, Crystal Reports, Cognos Report Net, Xcelsius,
RDBMS: Oracle 11g/10g/9i, SQL, PL/SQL, SQL Loader, MS SQL Server 2008/2005,
T-SQL, Microsoft Access
Operating Systems: Windows 7, XP/2000/NT. Solaris 2.6/7/8, UNIX.
ETL Tools: Informatica Power Center, Data Stage, Data Integrator/Data Services
Data Modeling: Erwin, Dimensional Data Modeling, Star Schema/Snow Flake Schema,
FACT Tables, Physical, Logical, Dimensional Data Modeling
Languages: C, Visual Basic, SQL, My SQL, HTML, XML
EDUCATION
• Bachelor of Science in Mechanical Engineering
• Post Graduate Diploma in Computer Applications.
• Certificate Course in RDBMS: Oracle 7.x.
PROFESSIONAL EXPERIENCE
MOTEN TATE INC – ORLANDO - FL
CITIZENS INSURANCE CORP - TALLAHASSEE - FL
Sr. Integration QA Engineer – PC/BC/CC/CM JAN 2013 – CURRENT
Project: Guidewire Policy, Billing & Claims Center
Citizens Property Insurance Company is a semi-federal government funded company, serves Florida
residents and business firms with Property & Casualty insurance for Commercial, Coastal and Personal
Lines.
Responsibilities:
• Collaborated with the business, technical and functional teams to identify test scenarios and detailed
test cases based on the User Story information, Detail Design docs and also use cases.
• Performed PC / BC / CC suite level integration tests using SOAP-UI tool
• Performed ETL testing on Source – Staging – Target systems on Control Flows and Data Flows.
• Performed ePAS Policy Data Migration Tests covering slowly changing dimensions, sorting,
filtering, merging transformations
• Performed Tests on Billing Center Reports developed in Cognos
• Performed Tests on Billing Center external Integration Points such as: Document Production
(Thunderhead), Document Repository (Alfresco), General Ledger (Pro-Financial), Escheatments
(Tracker), Check Printing, Aperta- Positive Pay, Clear Check Power-to-Pay, Virtual Data Transport to
Central Data Warehouse, Agency Commissions, NACHA – EFT Payments
• Performed Tests on Policy Center Integration Points such as: Rating (Insbridge), OFAC, IVR –
Interactive Voice Response system and Global Policy Search – GPS, ISO, Ephesoft, Address Book
(Contact Manager), Clearing House, FHCH-Florida Hurricane Catastrophe Fund, ePAS – Electronic
Policy Administration System, MMP – Manage My Policy
• Performed Tests on Claim Center Integration Points such as: ISO, XActimate, Metro, IVR,
Thunderhead, Alfresco, CheckPrinting – Power-2-Pay and Positive Pay
• Performed functional tests on Policy Submissions, Creation, Policy Changes (Endorsements),
Cancellations, Renewals, Reinstatements, Delinquencies
• Performed System Testing, Stability Testing, Configuration and supported UAT testing
• Performed Testing on User Roles, Security Roles and Created simulator datasheets, batch files for
Test Execution. Performed Database tests as part of Integration Tests
• Performed testing on Rules Engine (Rules Administration) in Policy Administration System
• Gained knowledge of Claim Center external interfaces like ISO, Metro, NCCI, SIU
• Created Test Coverage and Traceability documents
• Modularized regression test cases from functional and integration test suite then executed them for
regression phase. Performed regression tests using QTP automated tool
• Captured Policy & Billing Center user stories from out of the box system and wrote test cases;
• Performed ETL testing using SSIS and Billing Reports Testing which are developed in Cognos
• Used HP-QC to review and log defects. Involved in End-to-End Phase Defect Triage Meetings.
• Mentored new QA Testers with testing strategies, test plans, to oversee their test case writing and test
case execution and defect logging effort
• Followed Agile-Scrum methodology and used RallyDev tool for sprint management
• Participated in Daily standup SCRUM meetings, Sprint Planning Sessions, Sprint Review and
Sprint Retrospective sessions
Environment: Guidewire 7.0, HP-ALM/Quality Center, QTP 11, RallyDev, SQL Server, SSIS, Cognos,
SOAP-UI
MILLENNIUM SOFTWARE INC – SOUTHFIELD - MI
F ORD MOTORS - DEARBORN - MI
BA / QA Engineer Jun 2012 – Jan 2013
Project: Warranties & Claims Processing
Ford Motors offers extended service warranties like PremiumCare, ExtraCare, BaseCare, PowertrainCare
and also Maintenance plans like DentCare, EtchCare, TireCare, TripleCare through their dealer network.
Dealer’s website portals are interfaced to Ford Motors Central IT System through Oracle – OSB
technology.
My responsibilities were:
• To test integrations between dealer network and ford software systems using SOAP-UI tool.
• To test ETL transactions on SQL Server
• To interact with Business Product Owner(s) to capture the requirements, analyze them and break them
down into test scenarios and test cases in TFS
• To estimate test duration and resources required to execute and complete the QA effort
• Performed testing on Claims documents archival based on indexing.
• Performed Functional, End-To-End (System) testing which includes Database Testing
Environment: Team Foundation Server, CA-AgileVision, SQL Server, SOAP-UI, Documentum, Pega
IBM – CORPORATION
J P MORGAN CHASE - DALLAS - TX
SIT Engineer / Offshore Coordinator Jul 2010 – Jun 2012
Project: Views Portfolio Reporting (VPR) is a reporting platform that empowers clients with a single
point of access for information reporting, inquiries, investment and transaction services across various
business categories like ‘Online Trading’, 'Custody', 'Fund Accounting' and 'Private Banking'. VPR
application is built with Dot Net, Java technologies.
• Act as a single point of contact between development and offshore testers for iterations, testing and
deployment activities. Interacted with end users to determine requirements for data, reports, metadata
and performance.
• Tested Full and Incremental / Delta Loads. Conducted ETL & Reports Migration Tests.
• Processed (loaded) Data from warehouse system to Message Queue tool Webview.
• Verified mappings in the transformations and validated data in target system.
• Created and executed many SQL statements to validate the data on Target Systems as a part of
Database Testing. Validated Transformations and ETL logic using Data Services.
• Used Putty tool to connect to Unix server and executed Unix commands to archive/restore/delete the
messages on Message queue tool.
• Good experience in Designing, Development and Testing of Universes, Classes and objects which
suits the Standard, Analytical and Ad-hoc reporting requirements of the Business users.
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Performed data profiling at source and data auditing at target.
• Tested Income and Expense reports for higher level management using Cross tab and Chart Reports.
Performed Unit Tests once the reports are generated.
• Tested drill down reports based on Department by Account, by Employee and Invoice.
• Escalate the issues about the project requirements (resources) to the project manager.
• Created work breakdown structure (WBS) assigned the tasks to the offshore QA team members.
• Created and provided ETL tool usage document to the offshore team and mentored them.
• Prepared the agenda for the meetings and organized the meetings.
Environment: SAP Business Objects Reports, Oracle 10g/9i, PL/SQL Developer 7.1, Rumba –
Mainframe 3270, IBM Websphere – Message Queue, QTP, Quality Center 9.2, Dot Net, Java, Putty
INFOVISION – PLANO – TX
VERIZON – IRVING – TX
BI TESTER MAY 2009 – JUN 2010
• Involved in full life cycle of Business Objects reporting integration to SAP MM
• Analyzed the requirements, data layout, source layout, target layout (size, retention period) and
proposed schedule (load window timings) for the process flow
• Assisted in updating the logical model with all related entities, attributes and relationship with each
entities based on the rules provided by the business manager using Erwin 4.0.
• Analyzed and Documented End User requirements, Business requirements and Data Specifications
for Business Objects reports.
• Performed testing on Material Master, Vendor Master, Purchase Orders, Purchase Requisitions,
InfoRecords, Goods Receipts and Goods Issue, Contracting and Invoice configurations.
• Performed ETL testing using Informatica ETL Tool then performed database testing for data integrity.
Tested Universes, and Hierarchies for Multidimensional Analysis.
• Created and set up Universes for each reporting group.
• Tested Complex Reports by using functionalities like Slice and Dice, Drill Down, Master Detail, etc.,
tested Hierarchies to support drilldown reports, which allows the users to analyze the data.
• Tested graphical representation of reports such as Bar charts, Line Charts.
• Tested Web Intelligence documents describing Market Share by Product and Manufacturer, Terminal
Sales, Wireless Equipment Sales and Subscriber Growth for the CI Team
• Created and deployed WEBI Reports through Info View
• Tested scheduling Daily, Weekly, Monthly and Quarterly Reports using Broadcast Agent Server.
Implemented Security for the End Users based on groups and permissions
• Tested Multiple Universes in Designer in secure connection as well shared connection
• Trained users to Use, Interpret and Modify reports as and when needed
Environment: Informatica 7.1, SAP SD/MM, Business Objects XI Rel2, Designer, Oracle 9i, TOAD,
Windows 2000, SQL Server 2005, SQL Navigator, Visio, Xcelsius, Dashboards, Erwin. JIRA.
DECCAN CEMENTS LTD – HYDERABAD – INDIA
BA/Sr.QA Analyst AUG 2006 – MAR 2009
DCL Group is involved in Cement Manufacturing, Power Generation, Polypacks Manufacturing and
Financing business. DCL manufactures and sells cement and polypacks to the dealers and cement
manufacturing companies across India. Involved in Planning, Designing, Development of the Data Model
and Reports for the following modules across the organization:
Interacted extensively with various team members such as Sales, Production, Materials and Accounts
Dept. Performed Manual Testing in these following projects:
• Sales Order Processing System, • Financial Accounting
• Purchase Management System, • Payroll Process
• Inventory Management • DCL Mini Hydro Power Project
Supervised and coordinated with developers, testers, users and management to assess computing needs
and system requirements.
Executed and maintained program management processes and disciplines in the areas of: program
schedule and quality management; communications management; human resource management; cost
management; procurement management; risk / issue management; change management.
Participated in data management sessions with DBAs and production support team to discuss about
views, partitioning and indexing schemes case by case for the facts and dimensions.
Environment: SQL Server 2005, Dot Net, Crystal Reports 8.0, TOAD, Windows NT.
MOVE.COM – HOMESTORE INC – WESTLAKE VILLAGE - CA
QA ENGINEER AUG 2005 – JUN 2006
Move, Inc., the leader in online real estate, is the essential resource for consumers seeking the information
and connections they need before, during and after a move.
For the last ten years, Move has been providing information and decision support tools for consumers
looking for home and real estate-related information on the Internet. Visitors to Move's Web sites,
including Move.com and REALTOR.com, have access to the most comprehensive selection of existing
homes for sale, new homes, and apartments for rent and senior housing.
• Gathered requirements from the business users to build the reports
• Tested Earned Revenues, Written Revenues and Average Revenues Reports based on Time using
Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail
reports, formulas, etc.
• Involved in requirements study, design reviews and analysis of input/output flow
• Provided end user and production support after deploying the application into the prod env
• Involved in ETL and Reports testing process using Informatica
Environment: Oracle 8i/9i, ASP, Crystal Reports, TOAD, Autosys, Test Director, Windows 2000.
VAISHANO ACADEMY – HYDERABAD - INDIA
BUSINESS ANALYST / QUALITY ASSURANCE ANALYST AUG 2003 – JUN 2005
Vaishno Academy is one of the fastest growing movie production companies in Southern India.
Vaishno Academy produced more than a dozen feature films.
• I was involved in Pre-Production, Production, Post-Production phases and departments.
• My responsibilities were to monitored and reported the trends from Film & TV Media based Internet
content.
• Capture project requirements and provide solutions for Budget Estimation, Project Schedule
Planning, Resource Planning and Scheduling.
• Analyzed GAPs and submitted the GAP analysis document and provided solutions based on my Gap
analysis
• Involved in Quality Assurance during Post-Production Phase.
• Introduced I.T. systems into film making process and was in-charge of Quality Assurance department.
XL-SOFTEK INC - NJ
KAISER PERMANENTE – PASADENA – CA
EDI TEST ENGINEER SEPT 1999 – JUN 2003
Project-1: IDXRad suite implementation
Project-2: Claims Processing
Kaiser Permanente implemented IDXrad for its radiology information system solution with Scheduling,
Tracking and Billing functionalities in hospitals. RIS and clinical information system interfaces with other
existing Kaiser’s software applications to get ready as 'KP HealthConnect'.
• Captured, Analyzed and Maintained paper based clinical data from Legacy Claims System which
is later replaced with EPICs Claims solution in 2004
• Performed testing on Claims and Billing (Payment Processing) modules
• Performed integration testing with Medicare
• Analyzed and wrote Specifications of GAP for Claims and Billing Processing System Reports
• Tested Patients Personal Info and Demographics with respect to the Claims submitted
electronically and through paper
• Validated ICD-9 and CPT codes against the Claim Charges entered
• Claims auditing and follow-up with insurance companies
• Tested Claims adjudication process
• Tested Electronic Payments & Check Deposits and Balance Transfers posted to Accounts
• Performed event message testing and validating Facets EDI – Electronic Data Interchange
• Knowledge of business rules of Healthcare EDI transaction types such as 270, 276,, 834, 837
• In Billing module tested collections, workflows, delinquencies and credit reversals
• Helped load testing team to setup Test Data and coordinated with the load testing effort
• Tested medical records scanning and filing them into the repository based on indexing
• Tested Diagnosis reports, Claims / Revenue Analysis / Billing and Collections / Key Indicator
Summary reports for EMR systems
• Supported the production implementation of IDXrad application in various Kaiser hospitals
• Trained end users such as nurses, radiologist, transcriptionists, schedulers and file clerks
• Performed End to End test for two versions and eight builds of IDXrad
• Performed Interface test between legacy and conventional systems
• Performed migration tests when reporting has changed from Crystal Reports to Cognos (CRN)
• Managed defect tracking systems like VANTIVE in IDXrad and VANWEB in Kaiser Permanente.
• Management has sent me to Infosys - India to train and transfer the RIS knowledge to their QA
and Maintenance team as a part of its offshore process.
Environment: IDXRad, Oracle 8i, Seagate Crystal Report 8.0, ASP, PL/SQL, Vantive, Win 2K, WinNT,
Mainframe.
Contact this candidate