Data Sales
Resume:
Ranjit P Madhusoodanan Pillai
Sr. QA Test Automation Engineer
Sugarland,TX, USA-77498
Home: 281-***-****
Cell: 832-***-****
Email: ******.**@*****.***
SUMMARY
4+ years experience in Software Quality Assurance and Quality Control
Proficient in functional, negative, regression, system integration (SIT),
acceptance (UAT), load/performance, SAP TAO, Excellent knowledge and
working experience in with test planning, test execution and test results
analyses
Solid expertise in automated testing tools WinRunner, Quality Centre and
Test Director,QTP
Strong background in software for Financial Services, Group Benefits,
Retail Sales, Document Management, Social Care and Human Resources
Experience in Rational Rose Enterprise visual modeling solution for the
Unified Modeling Language (UML)
Excellent communication and presentation skills, self starter, quick
learner, team player
Requirements gathering, Business Case Development, Business Framework
Analysis, Business Process Re-engineering using UML.
TECHNICAL SKILLS
BW Reporting and Queries: Query Analysis and Report Generation using
Business Explorer, Query Designer, SAP BW,MM, Web
Application Designer, SAP Business Objects and Yotta,SAP TAO
RDBMS: Oracle 9i, SQL Server, Microsoft Access, SQL,PL-SQL
Scripting Language: VB Script, nUnit, JUnit, Perl
Operating System: Windows Vista, XP, Windows 7.0, Win 95,98,2000
Business Areas:
Functional Domains Consulting in Infrastructure Management, Manufacturing
process, Banking and finance process, Customer Relationship Management,
Maintenance, Retail and Process Automation
Project Management Tools:
MS Visio, MS Project, MS Excel, MS PowerPoint, Outlook, and Word, Lotus
Notes, SAP related to Business Warehouse, OOD Visual Basic, UML, and good
knowledge on Business Objects.
PROFESSIONAL EXPERIENCE
Digital Brand Group, California, USA/India
(April 2009 - Present)
Developed of testing strategies for Internet application.
Generated test scenarios, test cases and test data. Executed tests, created
problem reports
Worked on Oracle Transport Product Architecture and implement technical
solutions for Oracle's Transport Product
Different notebooks, Printers, Servers and software applications tested on
Vista Version.
Tested integration and validation of data from various sources to targets
using SQL queries and ETL process.
Performed ETL integration testing using Informatica PowerCenter 8, data
Integrity/validation, and backend testing and queried multiple relational
databases (Oracle 9i, 10g and SQL Server 2005) using TOAD, SQL Enterprise
Manager.
Review of ETL design documentation mappings/workflows and testing of ETL
mappings and data loading using Informatica PowerCenter 8
Worked on nUnit, jUnit
Assure that credit limits are monitored and recommend appropriate action if
limits are exceeded through .Net Applications
Review, verify and code company credit card invoices in a timely manner
Process credit applications for all locations
Process credit card payments through automated systems
Reimaging Vision workstations
Created test cases necessary to validate all ETL and data-handling
processes
Analyzed business requirements, functional specifications and mock ups of
financial to provide functional decomposition
Automated Scripts in Win Runner and used Quality Centre as the defect
tracking tool
Testing done in SAP BW and SAP TAO
Conducted installation and cross-platform testing of Internet Configuration
Wizard application
Demonstrated experience reviewing requirements and design to determine
appropriate tests including interfaces to legacy systems, Wrote test Plans
and Test Scripts for different application in Peoplesoft
Compile, organize, and review data for use by analysts and management
Writing SQL/PL-SQL queries and manipulating large amounts of data
Data mapping, detailed data analysis and metadata analysis, creating and
maintaining detailed mapping documents
Data Analytics and Reporting
Assist in the documentation of actuarial work products
Prepare special reports and exhibits with directions on Crystal reports
Reporting done in SAP BW,MM,SAP R/3 and Bex Analyser
May perform a variety of administrative duties for the unit.
Wrote Test plans and procedures for HP Monitor compatibility display
testing
Implemented website providing real time status on results to HP and US and
overseas vendors
Assist vendors with implementation of fixes needed to resolve monitor
issues
Project Managed BANA Midwest rollouts in 12 major cities with 27 field
techs
Scheduled the training, site surveys, site installs and hiring for the
complete project.
Scheduled and organized weekly Conference calls with HP and field
technicians.
Designed and organized a functional test lab for testing any type of
software or hardware on a wide range of operating systems and computers for
Digital blue Testing for different cameras and camcorders of Disney
Products
Utilize and maintain spreadsheet, mainframe, and other technical
applications used in the actuarial ratemaking process
Environment: Quality Center, Test Director, QTP, Win Runner, XML,Windows,
Unix, SQLServer, J2EE
FIDUS SOLUTIONS. India December 2008 -April 2009
Data Analyst/QA Analyst (Test Lead)
Clients:Sprint and Verizon
Responsibilities:
Documentation/Use Case Documentation/Function Documentation
Developed Test Plan/Scenarios and create Test Cases from the Requirement
Write business requirements, programming specifications, and training
material
Writing SQL/PL-SQL queries and manipulating large amounts of data
Worked on Finance Billing Applications like GL,AP,AR and Cash Management
modules.
Worked on Data Migration for SQL Server 2005/2008 and Informatica
Worked on Oracle Transport Product Architecture and implement technical
solutions for Oracle's Transport Product
Worked on WLAN, Bluetooth, Cellular/mobile broadband
Worked on Supplier Relationship Management is i2's suite of product that
focuses on design, sourcing, and procurement capabilities
Created test cases necessary to validate all ETL and data-handling
processes
Korn shell scripting for job execution
Used scheduling tool (Tidal) in informatica to execute jobs
Worked on nUnit, jUnit
Different notebooks, Printers, Servers and software applications tested on
Vista Version
Reimaging Vision workstations
Data mapping, detailed data analysis and metadata analysis, creating and
maintaining detailed mapping documents
Environment:,Quality Center, Test Director, Windows, XML, Unix, SQLServer,
XML,Oracle Applications,SAP CCS
GE Energy(General Electric)
March 2010-November 2010
Developed of testing strategies for Internet application.
Generated test scenarios, test cases,Test Plans and test data. Executed
tests, created problem reports
Worked on Progression and Regression Scripts.
Worked on Oracle Transport Product Architecture and implement technical
solutions for Oracle's Transport Product
Worked on Finance Billing Applications like GL,AP,AR and Cash Management
modules.
Worked on Data Migration for SQL Server 2005/2008 and Informatica
Performed ETL integration testing using Informatica PowerCenter 8, data
Integrity/validation, and backend testing and queried multiple relational
databases (Oracle 9i, 10g and SQL Server 2005) using TOAD, SQL Enterprise
Manager.
Develop end-to-end test plans for systems, integrated and user acceptance
testing based on project standards and testing strategy
Review of ETL design documentation mappings/workflows and testing of ETL
mappings and data loading using Informatica PowerCenter 8
Strong experience in designing and development of interfaces of legacy
system with Oracle Apps. for FA, GL, AP, AR, OM & Cash Management modules.
Assure that credit limits are monitored and recommend appropriate action if
limits are exceeded through .Net Applications
Review, verify and code company credit card invoices in a timely manner
Process credit applications for all locations
Process credit card payments through automated systems
Reimaging Vision workstations
Created test cases necessary to validate all ETL and data-handling
processes
Analyzed business requirements, functional specifications and mock ups of
financial to provide functional decomposition
Automated Scripts in Win Runner and used Quality Centre as the defect
tracking tool
Collect and collate appropriate data for use in databases and conduct
related research
Generate reports using IT / database systems and assist in their analysis
Assist in development and upgrading of database systems and analytical
techniques
Discuss information or business intelligence needs with internal staff
and/or external clients
Strong analytical, pattern detection and problem solving abilities
Excellent interaction with cross-functional teams
Implemented Test Cases and Test Plans using Quality Centre
Great customer interfacing skills and customer orientation
Environment:,Quality Center, Test Director, Windows, XML, Unix, SQLServer,
XML,Oracle Applications
GI info logics India, TVM September 2006 - 2008
Lead QA Analyst
Responsibilities:
Proficient in HP/Mercury tools like Quick Test Professional (QTP) 9.1 and
9.2, WinRunner, Quality Center 9.0 and 9.2, TestDirector 8.0, LoadRunner
8.1 and 9.0, HP Performance Center, Borland's Silk Performer, IBM
Rational Functional Tester 6.1, 7.0, IBM Rational Functional Robot,Client
/Server Web Databases, API and GUI Testing.
Working with development teams investigating and correcting software bugs
and deficiencies based on the testing results.
Performing various types of testing, such as functional, regression, user
acceptance, negative and installation testing
PeopleSoft application 9.0 testing on the following modules: Payables,
ePro,Receivables, Deal, Financial Gateway, Cash Management, Bank setups and
Processing, Special Requests, and Commitment Control.
Worked on Oracle Transport Product Architecture and implement technical
solutions for Oracle's Transport Product
Worked on WLAN (802.11), Bluetooth, Cellular/mobile broadband
Executed Batch scripts using perl scripts and Informatica
Worked on nUnit, jUnit .
Worked on Data Migration for SQL Server 2005/2008,SAP BW and Informatica
Strong experience in designing and development of interfaces of legacy
system with Oracle Apps. for FA, GL, AP, AR, OM & Cash Management modules.
Responsible for the implementation of i2 Demand Management Solution and for
assessing and modeling a forecasting process and implement a forecasting
workflow to enable them to accurately predict and track their forecasts
Updating customers on the product features, Sales and pre-sales activities
like supporting demo creation, participating in i2 external (marketing)
events
Involved in modeling their product hierarchies and sales organization,
analyzing trends in the sales history, modeling the affect of promotions
and integrating i2's Demand Planner with their operational systems.
Developed and updated Test plans, Test Matrixes, Test Scenarios, and Test
Cases for all company products
Korn shell scripting for job execution
Testing done on Openlink Endur application
Testing done in SAP BW,MM and SAP TAO
Demonstrated experience reviewing requirements and design to determine
appropriate tests including interfaces to legacy systems, Wrote test Plans
and Test Scripts for different application in Peoplesoft
Used scheduling tool (Tidal) in informatica to execute jobs
Different notebooks, Printers, Servers and software applications tested on
Vista Version
Reimaging Vision workstations
Conducted variance management by analyzing and verifying test results,
providing status and progress reports, using TestDirector 7.0i
Conducted system functionality testing: developed and executed test cases,
produced problem reports, suggestions, system test logs, and test incidents
reports
Scripting done In Perl and Unix
Created test cases necessary to validate all ETL and data-handling
processes
Expertise with Reporting tools like SAP Business Objects and Yotta
Writing SQL queries and manipulating large amounts of data
Data mapping, detailed data analysis and metadata analysis, creating and
maintaining detailed mapping documents
Data Analytics and Reporting
Implementing entire software development life cycle (SDLC) including
analysis, design, development and testing of software applications
Responsible for quality and timeliness of operations
Responsible for Onboarding of data from Users and analyzing from different
servers and database.
Responsible for creation of Data Definition Specification and helping data
modelers with different data models for Physical Data Model(PDM),Logical
Data Model(LDM) and Conceptual Data Model (CDM) for different Layers
Collect and collate appropriate data for use in databases and conduct
related research
Generate reports using IT / database systems and assist in their analysis
Assist in development and upgrading of database systems and analytical
techniques
Discuss information or business intelligence needs with internal staff
and/or external clients
Strong analytical, pattern detection and problem solving abilities
Excellent interaction with cross-functional teams
Implemented Test Cases and Test Plans using Quality Centre
Great customer interfacing skills and customer orientation
Environment: SAP Business Objects, Yotta, Quality Center, Test Director,
Windows, XML, Unix, SQLServer
Talent Groups
India
May 2006-September 2006
Lead QA Analyst
Responsibilities:
Developed of testing strategies for Internet application.
Generated test scenarios, test cases and test data. Executed tests, created
problem reports
Worked on Oracle Transport Product Architecture and implement technical
solutions for Oracle's Transport Product
Different notebooks, Printers, Servers and software applications tested on
Vista Version.
Tested integration and validation of data from various sources to targets
using SQL queries and ETL process.
Performed ETL integration testing using Informatica PowerCenter 8, data
Integrity/validation, and backend testing and queried multiple relational
databases (Oracle 9i, 10g and SQL Server 2005) using TOAD, SQL Enterprise
Manager.
Review of ETL design documentation mappings/workflows and testing of ETL
mappings and data loading using Informatica PowerCenter 8
Worked on nUnit, jUnit
Assure that credit limits are monitored and recommend appropriate action if
limits are exceeded through .Net Applications
Review, verify and code company credit card invoices in a timely manner
Process credit applications for all locations
Process credit card payments through automated systems
Reimaging Vision workstations
Created test cases necessary to validate all ETL and data-handling
processes
Analyzed business requirements, functional specifications and mock ups of
financial to provide functional decomposition
Automated Scripts in Win Runner and used Quality Centre as the defect
tracking tool
Testing done in SAP BW and SAP TAO
Conducted installation and cross-platform testing of Internet Configuration
Wizard application
Demonstrated experience reviewing requirements and design to determine
appropriate tests including interfaces to legacy systems, Wrote test Plans
and Test Scripts for different application in Peoplesoft
Compile, organize, and review data for use by analysts and management
Writing SQL/PL-SQL queries and manipulating large amounts of data
Data mapping, detailed data analysis and metadata analysis, creating and
maintaining detailed mapping documents
Data Analytics and Reporting
Assist in the documentation of actuarial work products
Prepare special reports and exhibits with directions on Crystal reports
Reporting done in SAP BW,MM,SAP R/3 and Bex Analyser
May perform a variety of administrative duties for the unit.
Wrote Test plans and procedures for HP Monitor compatibility display
testing
Implemented website providing real time status on results to HP and US and
overseas vendors
Assist vendors with implementation of fixes needed to resolve monitor
issues
Project Managed BANA Midwest rollouts in 12 major cities with 27 field
techs
Scheduled the training, site surveys, site installs and hiring for the
complete project.
Scheduled and organized weekly Conference calls with HP and field
technicians.
Designed and organized a functional test lab for testing any type of
software or hardware on a wide range of operating systems and computers for
Digital blue Testing for different cameras and camcorders of Disney
Products
Utilize and maintain spreadsheet, mainframe, and other technical
applications used in the actuarial ratemaking process
Environment: Quality Center, Test Director, QTP, Win Runner, XML,Windows,
Unix, SQLServer, J2EE
ETT, New Delhi, India
June 03 - August 06
QA Analyst
Responsibilities:
Preparation of credit applications, including new transactions, annual
reviews, renewals, temporary extensions, and waivers and amendments
Liaison with Risk for all credit-related issues
Preparation of Global Limit Requests
Management and reporting of global exposure
Covenant compliance monitoring
Maintenance of credit and documentation files
Review of documentation for syndicated transactions and for trading lines
requests
Preparation of Watch List reports and representation of the client
relationship in Watch List meetings
Proficient in HP/Mercury tools like Quick Test Professional (QTP) 9.1 and
9.2, WinRunner, Quality Center 9.0 and 9.2, TestDirector 8.0, LoadRunner
8.1 and 9.0, HP Performance Center, Borland's Silk Performer, IBM
Rational Robot, Client /Server Web Databases, API and GUI Testing
PeopleSoft application testing on the following modules: Payables,
Receivables,ePro, Deal, Financial Gateway, Cash Management, Bank setups and
Processing, Special Requests, and Commitment Control
Worked on WLAN, Bluetooth, Cellular/mobile broadband
Worked on nUnit, jUnit
PeopleSoft application 9.0 testing on the following modules: Payables,
Receivables, Deal, Financial Gateway, Cash Management, Bank setups and
Processing
Updating customers on the product features, Sales and pre-sales activities
like supporting demo creation, participating in i2 external (marketing)
events
Worked on Supplier Relationship Management is i2's suite of product that
focuses on design, sourcing, and procurement capabilities which enable
companies and their suppliers to collaborate and to create and manufacture
products with superior quality faster, and at lower cost
Creating automated test scripts, and documenting test scenarios, expected
results, actual results and determining pass/fail and criticality of failed
tests for People Soft Application
Excellent domain knowledge in Supply Planning and Demand Planning.
Testing done on Openlink Endur application
Tested many legacy systems in People Soft
Demonstrated experience reviewing requirements and design to determine
appropriate tests including interfaces to legacy systems, Wrote test Plans
and Test Scripts for different application in Peoplesoft
Different notebooks, Printers, Servers and software applications tested on
Vista Version
Executed Batch scripts using perl scripts and Informatica
Reimaging Vision workstations
Created test cases necessary to validate all ETL and data-handling
processes
Writing SQL/PL-SQL queries and manipulating large amounts of data
Data mapping, detailed data analysis and metadata analysis, creating and
maintaining detailed mapping documents
Responsible for creation of Data Definition Specification and helping data
modelers with different data models for Physical Data Model(PDM),Logical
Data Model(LDM) and Conceptual Data Model (CDM) for different Layers
Data Analytics and Reporting
Strong experience in designing and development of interfaces of legacy
system with Oracle Apps for FA, GL, AP, AR.
Provided proactive day-to-day support to Production and Maintenance teams
with respect to optimum, efficient and safe plant operation.
Education
Master of Computer Application (MCA) Calicut university - Post
Graduation: December 2006 GPA 3.22/4.0
. Member of Information Technology Advisory Committee
. Built many of the University's first departmental websites
. University Honors College participant
Bachelor of Science Computer Science
Kerala University Kerala, India- Graduation: May 2003 GPA 3.8/4.0
. Awarded for outstanding student achievement
. Dean's list and Honors graduate
Professional Development:
SAP Business Information Warehouse (BW) Training
* NAI Training, 2001, CMM (capability maturity model) Training, Rapid
Release Cycle Process Training
* Keystone Training, 2000, Borland Delphi 4 (object Pascal) programming
(standard, professional and client/server versions)
BW330 SAP BW Modeling, BW350 SAP BW Extraction
Contact this candidate