Post Job Free
Sign in

Quality Assurance Us Citizen

Location:
Powell, OH
Posted:
December 02, 2024

Contact this candidate

Resume:

AppalaRaju Reddi (Raju)

US Citizen

Ph: 614-***-****, Email: *.**********@*****.***

Summary:

20+ years of professional work experience in system analysis, design, development,

quality assurance, automation testing, manual testing, integration, system, regression, uat testing of web and client/server applications.

Domain knowledge on FinTech, auto insurance, consumer credit, healthcare, retail, banking, telecom, pharmaceutical, testing & automation and taxation.

Expertise in test planning and test development, qa validations to ensure quality assurance.

Expertise in test automation development

Expertise in financial interfaces testing through manual and automation tools.

Strong technical expertise in property and casualty, functional testing, automation, regression, system, security, integration, user acceptance testing

Working knowledge in agile teams and interactive environments

Expertise in Jira defect dashboards and traceability matrix creation

Working knowledge in ERP journals, Frontier, Datawarehouse implementation

Knowledge in mobile platform testing android and iOS

Strong dedication towards work, ensure delivery of projects on schedule.

Expertise in win runner, load runner, silk tools and gherkin language

Have used with dev methodologies such as agile, iterative, waterfall process

Possess valuable experience and knowledge, working in various phases of software development lifecycle (SDLC) like requirement analysis, design, development, functional testing, maintenance, and support

Expertise in build/deploy/version control tools Jenkins, git, github, maven and harness

Technical Summary:

Testing/Automation tools postman, ruby, cucumber, tricentis tosca, restassured, watir-webdriver,

selenium, spec flow, page object model (pom), rest, quality center,

team foundation server (TFS),rational test suite, jira/zephyr, PractiTest, clear quest, defect tracker, rtc (rational team concert), soapuisplunk, phantom

Methodologies agile, iterative tdd, bdd, atdd

Databases sql developer, oracle 9i, sql, db2, sql server, Teradata, toad for oracle 11.0

Programming java/jsp/junit, java script, vba/vb script, ruby, cognos reports, dos batch, blaze

meter, jmeter, hadoop, git, git hub, bitbucket, jenkins, maven, IntelliJ, ide, eclipse

Project Planning tools microsoft office, microsoft office visio, microsoft project

ETL informatica power center/power mart, abInitio, SQL*Loader

GUI policy management system, mainframes

Languages c, c++,sql, rpg/400, c#, java, jsp, xml, pls/sql, perl, unixshell Scripting

OS windows, ms dos, linux

Internet asp 2.0, vbscript, javascript, html, dhtml

Middleware odbc, docusign, ado, com, mts, ERP, frontier, cabinet vision

CI/CD concourse, jenkins, harness, bitbucket, newmen

Insurance finTech,personal lines, property and casualty, auto, homeowners, tenant, condo,

boat, rv, policy admin, pci

Education & Certifications:

Bachelor of Engineering, Madras University, 1997, India

Masters in Information systems, 2002 (disc), USA

Microsoft Certified Solution Developer, 1999, India

Advanced Diploma in S/W Applications, 1998, India

Client appreciation letter from Nationwide Insurance, Columbus, Ohio, 2009, 2016

Five keys recognition from JPMorgan Chase, 2018

Tricentis TOSCA- Automation Specialist Level 1 AS1 – Nov 2019

Tricentis TOSCA- Automation Specialist Level 2 AS2 – Dec 2019

Client appreciation letter from Nationwide Insurance, Columbus, Ohio- 2021, 2022,2023, 2024

PROFESSIONAL WORK EXPERIENCE:

Company: Nationwide Mutual Insurance Sr Software Engineer Jan 2020 – Till Date

Columbus, OH

Project: PLS/PLDS Personal Lines Solutions- 3PO/2IB

The 2 Infinity& Beyond (2IB) team helps to integrate external partners onto Nationwide's web platform and API offerings, in the Personal Lines "Digital" insurance domain.

• Participated daily stand-up meetings, requirement review meetings as part of agile process

• Created detailed test designs, test plans, execute and monitor the testing using PractiTest

• Created and reviews test data for performing variety of test scenarios

• Worked on Product offerings with Auto Sales, Homeowners, Tenant, Condo, Boat, RV, Coarse

grain and Fine grain API and microservices resources.

• Developed Splunk dashboards and alerting to support error analysis & risk filters

• Files process through ILOG, ERP for Journals, Data Warehouse, Frontier Extracts and Reports

• Worked on Maestro Schedules to load data via xconman, schedules, jobs submission with

logical steps to load into Reports, ERP and Data Warehouse.

• Report pulled in Hyperion Reports using Interface, Journal Date, Load Id with filters on

specific Account number, load id, etc.

• Mappings verified, session log information from Informatica when the file failed to load data

into Reports.

• Interfaces processed through QTP via ILOG, Reports, ERP, ETL and Data Warehouse data.

• End-to-end flow to create postman collection payloads for different partners based on the requirements, retrieve quotes in nationwide express and process through payments/issue policy for auto sales, homeowners, condo, tenant and multi-products

• Validated functionality of external partner onboarding applications

• Onboardedpartners to additional states of a product, new API/experience API integration

• Worked with automation tools POSTMAN Web services

• Defects logged into the Jira board as identified

• Wrote SQL test scripts, analyzed and retrieving the data from Oracle SQL Developer

• Validated test results to match OAS

• Worked on validating the data from coarse grain rated quoting (RC1), API bind call (RC2), finalized quote (RC3), retrieve through nationwide express, payment process and issued policy

• Worked with partners Compare.com, Insurify.com, Matic.com, Openroadlending.com, Gabi.com, Covercasa, Pinnacle, Young Alfred, Policy Genius, Quin Street, Dealer policy, Salty, Goose Head, Progressive, Rivian, Gargella Group, VIU Hub, etc. and provided reason for failure and proposed solutions for each finding and therefore increase their quote success rateextremely

• Executedin System testing, Regression testing and User Acceptance testing

• Developed config yml files, apigee tests, feature files, nwx pages, some external library files for both auto and homeowners’ automation integration

• Developed quote rating, calculate down payment, setup billing account with bank card credit card, eft payments and generate policy.

• Created automated functional tests using tosca and ran tests to check data in splunk dashboards

• Created Tosca reusable components for regression test cases

• Developed automated scripts from tosca DI (data integrity) to ensure source systems and data warehouse to our reports, dashboards, and business processes

• Github shared repository created to maintain branching and merging strategies

• Integrated Billing APIs into end-to-end automation suite - Added billing calls to the API suite and mitigated challenges uncovered with data masking project from policy center

• Developed restassured and ruby cucumber automation suite to minimize the manual intervention.

• Created ci/cd pipeline-scheduled, created jobs to run automation suite nightly using 'run-evening' pattern.

Environment: Ruby, Cucumber, Postman, Restassured, Tosca, Concourse, Apigee, APIs, Jira/Scrum board, PractiTest, Git/GitHub Desktop, GitHub Admin, Agile, 3rd Party Onboarding, Guidewire Policy Center, OAS, Splunk iCloud, Tableau reporting, Oracle, SQL, ERP, Datawarehouse, XML, JSON, Figma, Microsoft Office, Windows

Company: TEKsystems Sr Consultant Mar 2017 – Jan 2020

Client: NI Source, Columbus, OH Nov 2019 – Jan 2020

Project: EASI to Workbrain

The project scope is to move the current NiSource employees who are using EASI as their timekeeping system, which is a legacy system written in-house in the early 1980s to Workbrain, version 6.0.1. Workbrain is the current enterprise timekeeping platform.

Worked on Agile methodology on different environments for this project

Created detailed test designs and test plans in HP ALM

Worked on calc group. security group, pay group and time codes of timesheets for the union and non-union employees for different companies

Worked on Test Scripts to create time entry, approval, and reporting processes in ventyx test and Workbrain test environments

Run the main job after timesheet submitted by pay group and validated time code rates in ventyx

Verified Shift Premium Rates at WLRS and Workbrain for the timesheets submitted in ventyx

Developed Test Automation using tosca

Verified functionality, capabilities of the DocuSign platform

Created Tosca reusable components for regression test cases

Requirement traceability matrix is complete, and all requirements are covered by at least one script

Risk-based test results reporting and metrics analysis

Wrote SQL test scripts and retrieving the data from Oracle SQL Developer

Working with Automation tools SOAP UI, REST API and POSTMAN Web services

Participated in System testing, Regression testing and User Acceptance Testing

Environment: Workbrain, WLRS, Ventyx, PeopleSoft HR, PeopleSoft Finance, Cognos/FDW, HP ALM Quality Center, TOSCA, Oracle, SQL Python, Developer, SQL, Microsoft Office, Agile, Jira/Scrum, Git/Github, XML, HTML, SOAP UI, Windows

Client: Safelite Auto Glass, Columbus, OH May 2019 – Oct 2019

Project: Customer Experience

Requirements Analysis, Requirements gathering, Business Rules and Functional specifications.

review

Attended grooming sessions to understand more on the functionality of the different applications.

Attending daily stand-up meetings, requirement review meetings as part of agile process.

Created detailed test designs and test plans in HP ALM

Created and reviews test data for performing test scenarios.

Defining technical requirements, configuring and customizing DocuSign application

Working on SV2 Sys, QA, Dev environments to create test data setup like Vehicle info, Insurance info, Type of auto policy, Windshield Coverage, Parts, Estimate, Scheduling, etc.

Work Orders, Referral Orders creating through Sv2, FixMyGlass, FixMyPowerWindow, Customer Portal

Working on validating the Data on Salesforce/Market Cloud, Workbench

Working on validating the data like Referral ID, Cash Order Flags, Insurance Order Flags, Cash Order Referral ID, Insurance Referral ID from Salesforce

Working with Automation tools SOAP UI, REST API and POSTMAN Web services

Environment: SV2,FixMyGlass, FixMyPowerWindow, Mule soft API, Salesforce Workbench, Salesforce Marketing Cloud, Customer Relationship Management (CRM), HP ALM Quality Center, Oracle, SQL Developer, SQL, Microsoft Office, Agile, Jira board, Git/Github, XML, HTML, SOAP UI, POSTMAN, Windows

Client: Huntington National Bank, Columbus, OH Sep 2018 – May 2019

Project: Control Uplift Program - Information Security (InfoSec)

Worked on Control Uplift Information Security (InfoSec) project, Monitoring & Analyzing, Data Protection/DLP Domains

Worked on Business Analysis Data Discovery, Data Analysis, Data Gathering, Requirement Management, Planning and Documentation

Worked on Orchestrate ISOC Alert (Pilot), Additional Asset Logging, Additional System Alerts, and Network Baselines projects from Cyber Security Operations Center

Requirements Analysis, Req gathering, Bus Rules and Functional specifications review

Test cases or test scenarios validations from Incidents/Alerts triggers for Credit Card Number, SSN, HB Account Numbers Sensitive Data for Data Discovery and DLP Endpoint

Worked on Waterfall, Agile methodology on different environments in this project

Created detailed Test designs, Test plans, Test Scenarios in HP ALM

Created test data and Test scripts for Integration, System, Regression Testing

Tested monitoring Alerts for MAC, Physical, VDI and Windows tabs devices in DLP Endpoint

Tested Alerts for different Internal databases for Shared Environment and Separate Environment in DLP Data Discovery

Created automated test scripts/frameworks with Ruby and Cucumber

Wrote Gherkin scenarios with keywords Given, When, Then, And, But

Executed test cases which are written for Phantom, Splunk, and SNOW

Worked through Phantom Playbooks, Apps, Sources, Events, Splunk Notables

Environment: InfoSec Operations, Orchestration Engine, Phantom framework, Configuration Management Database (CMDB), Service NOW (SNOW), SPLUNK, Data Loss Prevention DLP, DLP Endpoint, Data Discovery, Business Analysis, HP ALM Quality Center 12.21, Oracle, SQL, Ruby, Cucumber, Git, Github, Jenkins, Selenium, Java, Eclipse, TestNG, IIS, Microsoft Office, Microsoft Visio, Waterfall, Agile, Jira Zephyr, Windows and Unix

Client: JPMorgan Chase, Columbus, OH June 2017 – Sept 2018

Project: Capture Space-Captiva Batch Processing

Requirements Analysis, Requirements gathering, Business Rules and Functional specifications review

Reads, writes, extracts report from individual files

Performs and leads tests of software to ensure proper operation and freedom of defects

SQL test scripts wrote and retrieved the data from Oracle SQL Developer

Worked with business area personal to assure requirements are thoroughly defined and approved.

Worked on Captiva processes CMG, Correspondent Electronic, Correspondent Scan, Servicing, Doc2Data, MX, CAF, CAFMRL4T, Notary Logs, PRHE, HLDirect, Retail, Sworn Docs, OCROD, etc

Indexed exception batches are processed through Index Plus application and entered metadata to complete the batch process

Documents scanned and processed through Scan Plus and Index Plus applications are send to Paradatec Prokey tool to validate Doc Type/Page Type, Fields, and data though Classification, Extraction, Version and QC queues

Assigned pass or fail status and managed UAT testing results

Support of User acceptance testing, defect tracking and software implementation and deployment tasks

Validated end point validations like XML, Indexing Data, Filenet, iVault, SFTP Reports and Database

Environment: Capture platform, Captiva7.1, Scan Plus, Index Plus, Captiva Administrator, Captiva Desktop (Index), Paradatec Pokey, HP ALM Quality Center 12.21, Agile, JIRA/Zephyr, Selenium, SpecFlow, Page Object Model (POM), Java, Eclipse, Cucumber, Visual Studio 2015, nun it, SOAP UI, Oracle, Git/Github, Bitbucket, Jenkins, API, XML, SQL Developer, FileNet, vault, SFTP Reports, IIS, Microsoft Office, Microsoft Visio, Agile(TDD, ATDD, BDD), Waterfall, Gherkin, JIRA Zephyr Agile Board, Sprint Story Cards and Windows

Client: Huntington National Bank, Columbus, OH Mar 2017 – May 2017

Project: Velocity Upgrade

Role:

Requirements Analysis, Req gathering, Bus Rules and Functional specifications review

Attended Knowledge sessions to understand more on the functionality of the different applications

Worked on Test Scenarios for Initial Input Scenarios, Loan Closing Scenarios, Underwriter Scenarios, Booking Scenarios

Worked on Customer Search, Get Account Balance, Loan Info, Appraisal Values, Get Credit Scores validations

Validated Entity Information, Authorization Screen, Collateral Info, Covenants Screen, Customer Search, Debt, Disbursement Screen and Memo Background Screens.

Validated Entity Information Screen when Relationship Types selected as Borrower, Co-Borrower, Guarantor, and Grantor from the Velocity Workflow

Created Test data and Test scripts for Integration, System, Regression Testing

Defects logged in HP ALM Quality Center as and when defects identified

Environment: CME-Velocity, Oracle, SQL, Microsoft Office, Microsoft Visio, Waterfall, Agile, Jira Zephyr, Automated Financial Systems (AFS), HP ALM Quality Center, Windows and Unix

Company: MASTECH Inc, USA Sr Software Engineer Oct 2008 – Feb 2017

Vendor Company: TEKsystems, Columbus, OH

Client: Nationwide Insurance, Columbus, OH

Projects: Retirement Plans– DC Direct/Momentum/Keynote IK/CE

Role:

Projects that I worked on Nationwide are

DC Direct, RP, Momentum, Conversion Event 3, 4, 5 and 6, DCAR, Dollar Based Exchanges,Fresno, Acquisition, California, FinOps, In Plan Roth Rollover, NLPS, Relius, PAF, Auto Enrollment, KY, NY, Loan Enhancements, Payroll Automation, eAlerts, Fee Disclosure, Report Foundation, Account and Finance, Interest on cash, etc.

Teams that I worked on Achievers, Producers, Renovators, Transformers, Mantis, Mitosis,

Visualizers, Navigators both Private side and Public side

Requirements Analysis, Requirements gathering, Business Rules and Functional specifications review

Working on DC Direct Application end to end Regression Testing

Worked on RPPC Release 4 testing with Producers team

Worked on Conversion Event 2 Regression Testing

Processed files from RPPC Event 2 & 3 conversion activity

Performs and leads tests of software to ensure proper operation and freedom of defects.

Using TOAD, DB Visualizer tool to work on SQL test scripts writing and retrieving the data

Worked on DC Direct to use Account Services, Plan Administration, Plans, Organizations, Enroll Participants, Multiparticipant Transaction Administration, Suspense and Transaction Repository.

From Account Services Application window there will be search for Account Number or TaxID for Plan Sponsor

Worked on Plan Sponsor Account Summary, Exchange/Investment Elections, Distributions,

Transaction History, Investments, Payroll, Contributions and Census Updates.

Performs Integration testing, System Testing and Regression Testing for different applications at Nationwide

Worked on Web focus reports and DC Direct letters

Created automated test scripts with Ruby and Cucumber

Participates in defect management of UAT to ensure defects are fixed in a timely manner

Worked on Test Planning, Test cases and Test scripts in IBM Rational Test Manager

Performs and leads tests of software to ensure proper operation and freedom of defects.

Worked on Functional Testing, Performance Testing and Memory Leakage Testing for Android and iOS devices

Worked on Security testing, Location testing and Load Testing for Android and iOS devices

Executed test configuration management activities for complex work efforts.

Worked on Keynote application IK screens, SSC ISC

Worked on DC Direct application, RP Link, RSC, SSC and Web focus Reports

Environment: HP ALM Quality Center 12.21, Team Foundation Server (TFS), IBM Rational, IBM Rational Clear Case, IBM Rational Clear Quest 7.0.1, IBM Rational Test Manager 7.0.1,Policy Administration System, Guidewire PolicyCenter, Guidewire BillingCenter, QTP, Ruby, TDD, BDD, SOAP UI, DB Visualizer 7.1.4, IBM DB2, QMF, Data Warehouse, Data Mart, ETL, Informatica Power center 8.6.0,SSRS Reports, Oracle, Teradata, SQL, IIS, SQL Server, Microsoft Visio, QTP 9.1, Agile, Jira, Iterative, Waterfall, Android, iOS, UNIX, Hummingbird Connectivity v8.0 Exceed, Gherkin, Web focus, RTC, Story Cards, RRC, Ruby, Cucumber, Watir, Windows and Unix

Projects: Finance IT – FIBO & FIRM & FIL (Oct 2008 to Nov 2010) Sr Software Engineer

FIBO Finance Integrated Back Office is an ETL process which follows six logical steps until Data Loaded to the Data Mart Daily Fact table from multiple sources

Role:

Worked on Test Planning, Test scenarios, Test cases, Test scripts, Test sets, Test Lab in Quality Center

Maintaining the Test execution results and Review reports, validation of QC scripts.

Production flows/Work flows/Test requests have been processed two days a weekly in ST/IT/PT environments all the way through Reports and Data Warehouse.

Files management and Files copied to landing area which ILOG picks up in a different location from different servers like Powell, revenue, rupees and variance

Logs defects in Quality Center and submits defect summary report to the team and business

Process the files through ILOG, ERP for Journals, Data Warehouse, Frontier Extracts and Reports

Worked on Maestro Schedules to load data via xconman, schedules, jobs submission with logical steps to load into Reports, ERP and Data Warehouse.

Run through six logical steps LS1, LS2, LS5 (FIBO process) until Data Loaded to the Data Mart

Data pushed into Reporting tables via Logical steps

New Interfaces, Regression, Application clean up items, Business Rule clean up, Application Enhancements, Defect fixes testing

Report pulled in Hyperion Reports using Interface, Journal Date, Load Id with filters on specific Account number, load id, etc.

Checked at Mappings, session log information from Informatica when the file failed to load data into Reports.

Worked on batch scripts processing automation using Quick Test Professional QTP tool. Interfaces processed through QTP through ILOG, Reports, ERP, ETL and Data Warehouse data.

WinSCP tool used to connect different servers and copy and drop files in landing area environments.

Environment: ILOG, FIL, ETL, Data Warehouse, Data Mart, Informatica Power center 8.6.0, Oracle, Teradata, SQL Tools, WinSCP, SQL, IIS, Microsoft Office, Microsoft Office Visio, HP ALM- Quality Center 9.2, TFS, QTP 9.1, Selenium WebDriver, Agile, Waterfall, Ruby, TDD, BDD, Cucumber, PTF, UNIX Putty window, Hyperion Reports Suite,-Interactive Reporting Studio 11.1, Essbase, Hummingbird Connectivity v8.0 Exceed, VB Scripting, RTC, Story Cards, ECIF, Windows and Unix

Company: CSC Covansys Corporation, USA Software Engineer May 2005 – Oct 2008

Client: Westfield Group, Westfield Center, OH, USA Dec 2007 - Oct 2008

Project: Business Intelligence - Agency Insight

The objective of the project is to enable agency and customer related business intelligence. The business has identified a need to classify agencies into categories based on a set of criteria indicatives of agency performance. Agency insight will also be gained by leveraging data to examine the composition of an agency's book of business thus identifying trends, challenges and opportunities.

Role:

Reviewed functional specifications and creation of test cases, test scripts and test steps

Extensively worked on test cases design for EDW, Adhoc, OLAP, Standard Reports

Interact with the Client directly to understand the Business Requirements

Performed Regression testing as and when required to ensure the stability of the application

Maintaining the test execution results and review reports

Validated Source - Target mappings applying various transformation rules and Lookups

Standard Reports tested in the areas of Agency Overview, Book of Business, Focus Level, Loss Analysis, New Business and Retention.

Test Cases Design- Policy, Claims, Agency, Test Scenarios- Data Warehouse

Standard Report Testing: Data Validation, GUI Validation, controlled data testing (dev7), controlled data testing (prod), 25 agencies load, 5 years data are done

Extensively created defects on issues and validations on defects for fixed ones.

Environment: Policy Management System, Mainframes (JCL, COBOL, QMF, VSAM), Data Warehouse, Informatica, Cognos 8, Query Studio, Report Studio, Analysis Studio, IBM DB2, QMF, DB Visualizer 5.1.1, SQL Server, MS-Access, SQL, IIS, Windows, Agency Information System, Claims, Waterfall, Test Planning, Microsoft Office, Microsoft Office Visio and HP ALM Quality Center

Client: Washington Mutual Corporation, Vernon Hills IL USA Apr 2007 - Nov 2007

Project: Capital Market - Home Loans Software Engineer

WaMu do Retail Banking, Home Loans, Commercial and Card Services

Role:

Worked on test cases design Home loan Reports

Interacted with the Client directly to understand the Business Requirements

Verified the functionality of the overall system

Performed Regression testing as and when required to ensure the stability of the application

Maintained the test execution results and review reports

Conducted Test plan reviews, Test case peer reviews

Worked on Risk Reporting and MRRDB applications

Tracked issues/tasks/defects, logging & resolving tickets on Remedy tool.

Provided weekly progress report and defect summary report

Environment: Quality Center, SQL Server, DB2, SQL, IIS, Mainframes COBOL, Remedy, Microsoft Office, Visio, Unix, Windows

Client: ERIC, Ohio, USA May 2005 - Apr 2007

Project: ETABS – Enterprise Taxation and Benefits Solution Software Engineer

Role:

Analyzed Business Rules, Data Specs, Flow Diagrams and Use Cases

Lead BI Team for 14 members as a Project Lead

Assigned and tracking issues/tasks/defects with team members as well as onsite

Conducted Causal analysis on defects recorded

Monthly PMR Presentations.

Connecting onsite servers remotely using Remote Desktop

Cognos Report net/Cognos8 software installation, configuration, Content Store creation.

Requirements gathering, Understanding the requirements and Data Mart design.

Worked on Cognos Report net 1.1 MRU version

Worked on Framework Manager, Report Studio and Query Studio

Design, Develop and Publish packages in FM

Executed SSIS packages for ETL batches to setup automated data load or extract

Generated reports in Cognos Report net and Cognos 8

Test scenarios, Unit Testing and Peer review.

Created Test data and Test scripts for System, Regression and UAT

Environment: Informatica, ETL, Cognos Report net, DB2, Mainframes, COBOL, SQL Server, UNIX, XML, HTML, JSP, Mercury Tools (Test Director), HP ALM Quality Center, QTP, Remedy Windows, MS-Word, Microsoft Excel, Microsoft Project, Visio, Windows NT/00

Company: INTEQ Software Ltd, Hyderabad, India Jul 2003 - Apr 2005

Client: ETFS Inc, Montreal, Canada DataWarehouse Engineer/Developer

Project: Expert Travel Financial Security

The ETFS Financial Group consists of four companies: ETFS, Globe trek Travel Insurance Management Inc., Special Risks International and Global Excel Management Inc. The Project is purely related to healthcare and travel insurance programs.

Role:

System Design, Code review and preparation of test plan and test cases

Worked with JDBC Database connectivity and createdmulti-dimensional reports using Cognos Powerplay

Developed IQD’s in Report net to create Model and Cubes in Cognos Powerplay and Reports.

Worked on SQL DTS packages, Dimensions and DTS mappings

Worked on executing SSIS packages while creating ETL batch

Test Automation Development

Generated reports in Powerplay and Report net

Environment: Cognos Report net, Impromptu, Powerplay, Transformer, ETL, Java, SQL Server, Oracle, SQL, DTS, Quality Center, Win Runner, Test Director, VB Scripting, C#, Windows

Daimler Chrysler, Auburn Hills, Michigan, USA Sep 2002 – Jun 2003

Project: CFC-COIN Integration Software Engineer

Role:

Gather and Define Business requirements

Providing security and multi-user access using Access Manager.

Automation Strategy and Test Plan preparation using IBM Rational suite

Preparation of Test Plan and Testing Process plan for component testing across various levels

Complete Test scenarios, Test Plan and conducts a walk-thru with Workflow leaders

Interacted with end users for analyzing and document business functions.

Involved in the preparation of the Gap document for the designated modules.

Environnent : Cognos Impromptu, Power Play, Cognos Transformer, Java, C++, Cognos Script

Editor, SQL*Loader, Oracle, VB, MS Access, Rational Req. Pro, Rational Functional

Tester, Clear Quest and Windows NT.

Cypress Semiconductors, Minneapolis, MN, USA Dec 2000 – Aug 2002

Project: CIM Automation Software Engineer

Role:

System Design, Code review and preparation of test plan and test cases at client site

Reviewed System Requirement Specification (SRS) and User Requirement Documents (URD)

Coordinated automation of scripts, system testing, performance testing and Quality Center activities

System, Regression, Integration, Performance and UA Testing

Prepared test summary reports for each level of testing

Environment: Quality Center, Test Director, QTP, VC++, XML, IIS Server, SQL, Station Works 2.1A, Oracle and Windows NT

Luxtron Corp, Santa Clara, CA, USA Jun 2000 – Nov. 2000

Project: Optima 9300 Plasma Etch Endpoint Controller Software Engineer

Role:

Prepared and review of test plan, testscripts/reports

Defect Management and Analysis

Supported UAT & Pre-Production Testing

System Design, Code review and preparation of test plan and test cases at client site

RS-232 Serial Interfaces setup for communicating Real Time Controller with Monochromator.

Environment: Test Director, UNIX, MS-Office, Silk, VC++, Visual SourceSafe, ASP, T-SQL, ODBC,

Bounce Checker, SQL Server, Windows

Defense Research and Development Laboratory, India Jan 1999 – May 2000

Project: Real-Time Graphical Displays for C4I Software Engineer

Role:

Developed Graphical Simulation using Applets, Servlets and XML.

Established JDBC connection to Oracle database to transfer data back and forth.

Designed and coded User Interface in MFC, CSS, XSL and DTD.

Coding and Testing VC++ modules.

Used Data Access Objects (DAO) to do the data manipulations.

Used Oracle for Database operations to store and retrieve data

Validations of web forms are done by VB Script and Java Script.

System design code review preparation of test plan and test cases at client site

Environment: VC++, MFC, Java, Applets, Servlets, C++, C, Visual Interdev, TCP/IP, ASP, VB script,

Java Script, Socket Programming, COM, Multithreading, XML, and Oracle, Windows NT, AS/400



Contact this candidate