RAJENDRA NARAYANDAS (RAJ)

214-***-****

acgytv@r.postjobfree.com

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