Manager Engineer
Resume:
SANDEEP KUMAR
*.*******.*****@*****.***
Professional Summery
Result-oriented professional, offering around 8 years of experience
Software Quality Assurance (manual and automation) Looking for a
challenging position as a Quality Assurance Test Engineer using both manual
testing and automated testing tools like Mercury Test Director for Quality
Center.
. Excellent in performing Black box, functional, regression, parallel,
ad-hoc, diagnostic, System, concurrency, Integration Testing, Browser
compatibility, Oracle Apps Testing (Oracle eBusiness suite) and end-
to-end testing of the application
. Expertise in performing manual testing of the applications in Windows
and UNIX based environments
. Practiced AGILE software development methodology and worked very
closely with developers during many iterations
. Was part of iteration voting team for various AGILE stories/features
. Extensive experience in entire QA life cycle, which includes
designing, developing test plan, writing and execution of test cases,
test scripts and finding, reporting and prioritizing the defects of
the application
. Excellent in understanding of complete Software Development life cycle
(SDLC)
. Excellent in analyzing business requirements and software functional
requirements specifications of the application
. Excellent in back-end testing using SQL queries, generating
documents/reports to ensure data integrity and to validate reports as
per business rules
. Development experience in web-based and client/server applications.
used extensively SQL, TOAD,PL/SQL
. Documentation of test documents using MS Office tools - Word, Excel,
Power Point
. Excellent knowledge in Multi-tier and Cross-platform skills.
. Team co-coordinator with excellent communication and interpersonal
skills
. Self-starter with excellent understanding and goal oriented approach
to problem solving issues
. Excellent verbal and written communication skills and motivated to
acclimate to new technologies
. Involved in meetings, walkthroughs, demos and close interaction with
Business Analyst, Team lead and Developers for better understanding of
requirements, functionality and business processes for testing of the
application
Technical Skills:
Bug Reporting Tools : Mercury Test Director for Quality Center 9.0,
Defect Tracking System (In House Tool)
Platforms : IBM OS/360, Windows 95/98/2000/Me/NT/XP, UNIX, MS-DOS
Databases : MS-SQL Server 2000, Oracle 8i, 9i, DB2
Data Analysis Tool : SPSS
TRAINING AND CERTIFICATION: Diploma in Advance Computing from C-DAC, ACTS,
PUNE University.
(A Scientific Society of Ministry of Information Technology, Govt. of
India).
ACHIEVEMENTS : Best Achievers Award for SAS-IMPS 6.1 Project - 2006
: Effort Climber Award for in recognition for earnest efforts
for the success of Project - 2007
EDUCATION : Bachelor of Science B.Sc (Hon's) Mathematics
PROFESSIONAL QUALIFICATIONS: MBA, Dip. In Advance Computing, Dip. In
Management
PROFESSIONAL EXPERIENCE
QA TEST ENGINEER AT SAS, PRODUCT NAME SAS INTEGRATED MERCHANDISE PLANNING
SOLUTION (IMPS) 6.1.3/6.1.3M3; MIDDLETON, MA - OCT'08 - PRESENT
The product name is Integrated Merchandise Planning System 6.1.3./6.1.3M3
the motive is to give the power to know how to leverage enterprise data to
minimize risk and optimize performance. It makes one to know its customers,
market, finances leading to entire business in a whole new way. The
application is associated with Retailing System. The SAS-IMPS enables
optimal planning throughout the merchandising lifecycle, from Pre-season
planning to In-season management to Financial and Assortment Planning to
Performance Analysis. Results can then be integrated back into financial
planning for the next season. Integrated forecasting - which provides
retailers the ability to develop and implement optimal plans based not only
on historical data, but also on expected customer demand. IMPS also enables
clustering of stores based on custom attributes along side with the 3 pre-
defined hierarchies, Merchandise, Location and Time.
It's a web and Client Server application with 64 bit and DPE.SAS supports
financial planning, in-season planning, and assortment planning,
micromarketing and performance analysis for retail organization. Also it
includes core components like Template Manger, Dimension Manager, Business
view Manager, Dashboard, Trend Manager, Admin and Security, Manage
Assignments and favorites, Preference, System Monitor, Application Property
and Worksheets.
Responsibilities:
. Extensively working on the following modules, Financial Planning,
Assortment Planning, In season Planning, Performance Analysis,
Micromarketing and Metadata Manager within IMPS 6.1.3/6.1.3M3
. Conduct Business Process/Retail Workflow testing
. Responsible for customer defect validation and gap analysis
. Working with Customer Support and Technical Support teams to
identify regression testing areas based on customer reported
defects
. Identify defects and report in defect tracking system.
. Perform root cause analysis for defects to identify workarounds
. Participate in code reviews for defect fixes and involved in
discussions for unit testing the new code
. Conduct concurrency testing
. Write test design and test cases for product enhancements
. Conduct peer and CFT reviews for test design and test cases
. Working with mapfile/metadata to configure/modify KPIs to suit a
specific business process need and conduct testing based on the new
metadata
. Involved in automation of Batch Processor
. Install and configure builds on AIX, Windows and SUN environment.
. Install and configure builds for Micromarketing
. Conduct Smoke testing once builds were installed
. Extensive involvement in Cross Platform testing.
. Participate in daily scrum meetings, defect triage meetings
. Participate in voting of iteration stories in AGILE methodology
Environment: Windows 2000, 8.2Java, ASP, XML, SQL Server, MS Excel, Web
logic 6.1, Web sphere, UNIX, AIX 5.2, Solaris 5.9, Windows 2003, UDB 8.2,
Oracle 9i,10g, EJB, JSP, C++, VC++, Web logic 8.1, Apache, Active X, XML,
Java Script, SAS Graph Control/Worksheet Client,Windows 2000, Oracle 9i,
EJB, JSP, C++, Toad.
QA TEST ENGINEER AT Nike Inc. (WHQ), PRODUCT NAME SAS INTEGRATED
MERCHANDISE PLANNING SOLUTION (IMPS) and Markdown Optimization(MDO);
BEAVERTON,OR - APR'08 - SEP'08
Nike, Inc. is a major publicly traded sportswear and equipment supplier
based in the United States. The company is headquartered in the Portland
metropolitan area of Oregon at Beaverton. It is the world's leading
supplier of athletic shoes, apparel and sports equipment. The project is
SAS Integrated Merchandise Planning Solution (IMPS) and Markdown
Optimization (MDO). The motive is to give the power to know how to leverage
enterprise data to minimize risk and optimize performance. It makes one to
know it customers, markets, finances leading to entire business in a whole
new way. The application is associated with Retailing and Point Of Sales
System (POS) whose front end is JAVA and the backend is Oracle 9.0 with
different modules and authentication levels. The entire application
supports the integrated merchandise planning and optimization solution for
multi-channels. This project decided to use ETL for all interface options.
The combination of allowing the transformation and validation logic to stay
in the ETL tool regardless of which source system the data is coming from
and the ability to design and trouble shoot the data mapping
Responsibilities:
. Developed and Maintained overall Test methodology, Test strategy,
Documenting Test design, Test cases and editing and executing Tests
cases.
. Validated the Nike Metadata in ETL
. Validated data transformations in ETL for extracts & conversions
. Executed each business function with Nike test data
. Validated Excel Metadata models
. Tested Fact Data for Inventory, sales, On Order, Geo-Product,
Location Hierarchy, Merchandise Hierarchy
. Responsible for Oracle apps testing( Oracle eBusiness suite) like
Manufacturing, Order to Cash and Procure to pay, Oracle Financials
Payables, Receivables, and General Ledger
. Involved in functional, regression, integration, concurrency,
security and UAT
. Used Autosys, a cross platform scheduler to run the Job.
. Developed SQL Queries to test the application for data integrity with
extensive knowledge of database
. Identified defects and reported in bug tracking system.
. Interacted with developers to resolve technical issues
. Involved in checking the functionality of the system in pre/post
production release processes
. Responsible for weekly status updates showing the progress of the
testing effort and open issues to be resolved along with review
meeting.
. Created, validated and executed automated test scripts
. Participated in defect scrub meetings to discuss and prioritize
identified defects
. Responsible for Test Case creation, Execution and reporting bugs
using Defects Tools Quality Center 9.0
. Effectively communicated with BSA and AE team in added functional
requirements
. Collaboratively worked with Business Users to help them identify the
user acceptance scenarios before the GO LIVE.
. Helped the Business user in documenting the NIKE business processes
involved in SAS IMPS.
Environment: Windows XP, Mercury Quality Center 9.0, XML, Oracle 9.0, SQL
Server, MS Excel, UNIX, Toad for Oracle - 8.6, IBM iSeriese Access for
Window (AS 400), Informatica Power Center 8.5.1, Autosys.
QA TEST ENGINEER AT SAS (MarketMax 5.6), PRODUCT NAME SAS INTEGRATED
MERCHANDISE PLANNING SOLUTION (IMPS) 6.1 / 6.1.1 /6.1.3 / 6.2 / 6.1.2.;
MIDDLETON, MA - JUNE '05 - MAR'08
The product name is Integrated Merchandise Planning System
5.6/6.1/6.1.1/6.1.3./6.2/6.1.2 the motive is to give the power to know how
to leverage enterprise data to minimize risk and optimize performance. It
makes one to know its customers, market, finances leading to entire
business in a whole new way. The application is associated with Retailing
System.
Responsibilities:
. Extensively worked on the following modules Financial Planning,
Assortment Planning, In season Planning, Performance Analysis,
Micromarketing within IMPS 6.1/6.1.1/6.1.2/6.1HFs
. Subject Matter Expert for WS Creation, WS Functions, WS Template,
WS Set Editor, Micro Marketing, Plan Management, Template Manager,
Dimension Manager, and Batch Processor
. Conducted concurrency testing
. Conducted Business Process/Retail Workflow testing
. Wrote test design and test cases for all modules
. Conducted peer and CFT reviews for test design and test cases
. Installed and configured builds on AIX, Window and SUN environment.
. Installed and configured builds for Micromarketing
. Conducted Smoke testing once builds were installed
. Extensively involved in Cross Platform testing.
. Excellent skills in Black box Testing.
. Identified many defects and reported in defect tracking system.
. Performed root cause analysis for defects to identify workarounds
. Participated in daily status calls, defect triage meetings
. Conducted demos/training on various modules within IMPS
. Extensively worked on I18N (Internationalization) for 6.2
. Worked on HOT FIXES - 5, 6, 7, 8, 9, and 10 for different
customers.
. Mentoring new people onboard on the product
. Got Best Achievers Award for successful release of SAS-IMPS 6.1
Environment: Windows 2000, Java, ASP, XML, SQL Server, MS Excel, Web
logic 6.1, Web sphere, UNIX, AIX 5.2, Solaris 5.9, Windows 2003, UDB 8.2,
Oracle 9i,10g, EJB, JSP, C++, VC++, Web logic 8.1, Apache, Active X, XML,
Java Script, SAS Graph Control/Worksheet Client,Windows 2000, Oracle 9i,
EJB, JSP, C++, Toad.
QA ANALYST AT OMNI COMP INFOSYS, INDIA; CLIENT- FIFA, SWITZERLAND - MAY '03
- MAY'05
Description: FIFA is association of world Football soccer. This is an
official website for FIFA. It publishes all official information through
this site. It has been developed in Java, C++ and database is oracle.
Responsibilities:
. Involved in creation of Test plan and responsible for creating Test
cases from the Business Requirements.
. Supporting quality inspection activities of team the
. Responsible for participating in daily bug discuss meetings over
conference calls connecting two QA teams and development teams in
different places including offshore and identifying the severity of
the bug and discussing issues
. Responsible for functional, UAT, security, acceptance and regression
testing
. Responsible for executing the Manual test cases and reporting the bug.
. Responsible for smoke testing
. Responsible for UAT testing
. Used MS Excel for writing test cases
. Effectively communicated with business users resulting in added
functional requirements
Environment: Windows NT4.0, c++, c, Java, COBOL, ASP, SQLserver, MS Excel
websphere, UNIX
QA TESTER AT DIRECTWAY DATA SERVICES PVT. LTD., INDIA - MAR 02 -APR 03
Client: CITY BANK, Global Payment, Cash Management System
Description: This is a web based Transaction application dealing with
money transfer Transaction, Foreign currencies and Funds transfers to
various corporate clients. The main objective of the Global Payments
functionality was to bring together initiation capabilities currently
supported by three different Cash Management products-Cash, World and Pay
link. In global Payments application the user will enter all of their
payments- local payments, FX payments, checks, wires, Remote checks, from
a single point based on the customer's solution package, user entitlement
group access rights and processing branch profile parameters. The system
will then determine how, where and when the payment should be processed.
Responsibilities:
. Analyzing end user requirements, specifications and business rules to
prepare test plan and test cases.
. Writing test scripts and execute test cases
. Responsible for smoke testing
. Extensively communicated with business user and development team to
resolve issues
. Participating in the review of application designs, business/functional
requirements for pricing and stock market
. Developing/executing tests, documenting bugs, regression testing and
automated test scripts
. Documenting test cases corresponding to business rules and other
operating conditions.
. Analyzed user requirements attended change request meetings.
. Developed and conducted system and user acceptance testing before
installation of the application on user environment
. Written SQL scripts for populating and deleting the test data from the
database
. Reported bugs and interacted with developers to resolve issues
Environment: PVCS tracker, SQL, C++, JAVA and Windows NT, Oracle.
Equity products and instruments are including; order management system,
electronic trading capabilities, algorithmic trading, direct market
access, dark pools and crossing network.
Contact this candidate