Alexandre Kagan
Philadelphia, PA 19116
Cell 267-***-****
Email: acgb0e@r.postjobfree.com
SUMMARY
• Extensive experience as a lead Quality Assurance Analyst.
• Expertise and thorough knowledge of Teradata, Netezza and Oracle databases.
• Experience working in a pharma industry.
• Skilled in all aspects of test planning and requirement analysis.
• Experience working in Agile Methodology.
TECHNICAL SUMMARY
PeopleSoft, PeopleSoft Tools 1/2, Reports Smith, PowerBuilder
Development Tools: 4.0/5.0, Oracle*Forms 4.0/4.5 Oracle*Report 2.0/2.5, TRIMREP,
TRIMAPP
Visual InterDev, HTML, ASP 2.0, Java Script, VB Script, WebFOCUS
Web development:
4.3.1.
SQL, SQL*PLUS, SQR, PL/SQL, PeopleSoft Code, Power Script,
Programming Languages:
PL/TRIM.
Oracle 7.0/11, SQL Server, Netezza, Teradata and Advanced Query
Database:
Tool
Hardware: HP700, RS/6000, and IBM PC
QA Tools: HP Quality Center, BugZilla and Jira
OMS, CSR, GSI Manager, JDA, SI Integrator, Payment Service, Order
Tools:
Service Harness, Test Harness, Talend and Filezilla.
Database Tools: ETL, DataStage (Designer and Director), Putty, Winscp
Operating Systems: Windows 7, Windows XP, NT, OS/2, UNIX, and MS/DOS
PROFESSIONAL EXPERIENCE
HBS/Catamaran, Warminster, PA 04/2014 – Present
Sr. Test Engineer (Consulting)
• Serves as Sr. Test Engineer to provide expert judgment and analysis for HBS/Catamaran.
Perform as QA for RxAxis and RxGenesys products.
• Participates in data migration for RxAxis (Linux) and RxGenesys (Windows), Winscp, FileZilla and
Sybase databases.
• Creating and updating testing documents along with other documentation to provide to our internal
departments to better help them understand and explain the system set up.
Page 1 of 6
Alexandre Kagan
421 Regina Street
Philadelphia, PA 19116
Cell 267-***-****
Email: acgb0e@r.postjobfree.com
• Tracking errors found in QA and communicating to the proper aria for correction.
• Creates Master Strategy plans, test plans and other test materials, execute test cases, review and verify
test results, identify and report issues, and provide summary test reports utilizing Rally.
• Work hand in hand with BA's to test new and current system functionality to ensure that the new
modifications work properly with our current plan set.
• Work with team to implement and document new and ongoing processes.
• Responsible for meeting turn around time/quality standard client performance guarantees.
• Participate in daily Scrum Meetings for Iteration Planning and grooming.
EBay Enterprise, King of Prussia, PA 08/2013 – 04/2014
Sr. Software Test Engineer
• Serves as Sr. Software Engineer to provide expert judgment and analysis for EBay Enterprise. Perform
as QA for Diesel (EB2C) client.
• Participates in data migration for Webstore, Wishlist, CSR, JDA and Feeds from V9 to V11 for Pet Smart
utilizing DataStage, OMS, CSR, Winscp, Filezilla, GSI Manager (Back Office), and Netezza Data
Warehouse and Oracle databases.
• Involves in Odin Project for upgrade the GSI platform for Open Invoice, Sofort, Ideal and PLCC.
• Participates in all stages of the testing life cycle for all projects above.
• Creates Master Strategy plans, test plans and other test materials, execute test cases, review and verify
test results, identify and report issues, and provide summary test reports utilizing Jira and Zephyr.
IBC Blue Cross, Philadelphia, PA 07/2012 – 08/2013
QA Tech Lead (Consulting)
• Worked as QA Tech Lead to provide expert judgment and analysis for Blue Core Project.
• Coordinated offshore testing team. Helped the new team members in ramping up to speed on various
solutions utilizing Teradata(Data Warehousing), ETL (DataStage), WinSCP, UNIX and Advanced Query
Tool.
• Performed QA for the following projects: Medical Management, Membership Gaps, Membership and
Provider Conversion.
• Imported and compiled jobs utilizing DataStage.
• Loaded files into tables utilizing Mload and ETL DataStage.
• Participated in all stages of the testing life cycle for all projects above.
• Created Master Strategy plans, test plans and other test materials, execute test cases, review and verify
test results, identify and report issues, and provide summary test reports utilizing Quality Center.
Page 2 of 6
Alexandre Kagan
421 Regina Street
Philadelphia, PA 19116
Cell 267-***-****
Email: acgb0e@r.postjobfree.com
• Trained/mentored offshore team and assisted QA Manager on Test Plan/Test Cases templates for QA
team.
Harte Hanks, Langhorne, PA 08/2011 – 07/2012
QA Lead (Consulting)
• Worked as QA Lead to provide expert judgment and analysis of technical products and systems.
• Helped the new team members in ramping up to speed on various solutions utilizing Oracle, Netezza
(Data Warehousing) and SQL Server databases.
• Performed QA for CRFs for the following clients: Mercedes, The Jones Group, Pet Smart, Amtrak &
Transact clients.
• Participated in all stages of the testing life cycle for new On Boarding and already existing Clients.
• Created test plans and other test materials, execute test cases, review and verify test results, identify and
report issues, and provide summary test reports utilizing Quality Center.
• Trained/mentored offshore team and assisted QA Manager on Test Plan/Test Cases templates for QA
team.
SDI Health, Plymouth Meeting, PA 08/200*-******
Test Engineer IV/Developer
• Provided expert judgment and analysis for the design, development and implementation of technical
products and systems.
• Resolved highly complex technical issues and conducts advanced research utilizing Oracle, SQL Server
and Access databases.
• Recommended alterations to development and design to improve quality of products and procedures.
Perform a variety of tasks.
• Participated in all stages of the testing life cycle. Create test plans and other test materials, execute test
cases, review and verify test results, identify and report issues, and provide summary test reports.
• Participated in data migration for all projects from EDW to IDW databases for Pharmacy Line.
• Developed ad hocs for the clients utilizing Oracle, Toad, SQL* Plus and PL/SQL.
American Red Cross, Philadelphia, PA 01/2005 – 08/2005
System Administrator and PeopleSoft DBA
• Was responsible for all phases of business application development process and operation support.
Page 3 of 6
Alexandre Kagan
421 Regina Street
Philadelphia, PA 19116
Cell 267-***-****
Email: acgb0e@r.postjobfree.com
• Participated in conversion of Emergency Services application from Cheers system to the Peoplesoft
using SQL Server database, SQL, PL/SQL, SQR, PeopleSoft Code and PeopleSoft Tools.
• Performed new release software upgrades, provided software installation and assistance to MIS users.
Accenture, Philadelphia, PA 11/2003 – 12/2004
System/Analyst (Astra Zeneca)
• Worked as part of a team on Contracts Management application product for new release Enhancement
6.2. Modify existing application utilizing PowerBuilder 7.0 and Oracle database on UNIX platform.
• Wrote store procedures and triggers using PL/SQL.
• Converted Compass application in PowerBuilder from version 7 to version 8. Preparation and QC of
sample reports for Client Management and Upper Management for sales efforts. Perform extensive QC
steps on all data and deliverables to ensure that all information sent to clients is of the highest quality and
accuracy.
• Participated in all stages of the testing life cycle. Create test plans and other test materials, execute test
cases, review and verify test results.
Home Care Hospice, Philadelphia, PA 11/2002 – 11/2003
Programmer (Consultant)
• Responsible for design, implementation and support of Home care application product that performs
detailed patient account information. Create database for that application, utilizing Access Database on
windows platform.
• Involved in the full testing cycle. Develop and execute test scenarios and cases.
• Performed GUI related tests, function, system, regression tests and various white box tests.
• Analyzed and documented software problems in the bug tracking database. Design detailed test case
specifications for validation testing.
Vertical Alliance, Norristown, PA 10/2000 – 10/2002
Programmer/Analyst (Team Lead)
• Was responsible for installation and support of Vertical Tracker application product that enables
businesses to communicate with their customers, E Commerce that allows businesses to exchange value
with their customers, using SQL Server/Oracle databases on NT/UNIX platforms.
Page 4 of 6
Alexandre Kagan
421 Regina Street
Philadelphia, PA 19116
Cell 267-***-****
Email: acgb0e@r.postjobfree.com
• Converted application from SQL Server to Oracle, utilizing SQL*PLUS, SQL. Move data from different
databases using Data Junction. Write store procedures using PL/SQL.
• Designed, implemented and maintained reports using WebFOCUS, OLAP and ColdFusion. Provide
software installation and assistance to MIS users.
• Participated in development and maintenance Peoplesoft 7.5 of new and existing application utilizing
PeopleSoft Code and PeopleSoft Tools for HR, Benefits and some Payroll. Perform upgrades of new
software release; provide software installation and assistance to MIS users.
Hyperion Solutions, Stamford, CT 04/2000 – 10/2000
Senior Staff Consultant
• Was responsible for installation, implementation and support of Hyperion Application Link and Hyperion
Integration Server.
• The Hyperion Application Link integrated relational databases, application interfaces, and flat files with
Hyperion’s package analytic applications, which provided organizations with a systematic process for
managing the conversion of data.
• Utilized Oracle, SQL*PLUS, SQL, Oracle Forms, wrote store procedures using PL/SQL, Windows NT,
ETL (Extract, Translate & Load) tools, EAI (Enterprise Application Integration) tools.
Industry Matematik, INC Marlton, NJ 05/1998 – 04/2000
Programmer/Analyst (Team Lead)
• Worked as part of a development team to implement the ordering and shipping applications for company
using Oracle Forms and Oracle database on UNIX platform This involved setting up numerous tables and
views as well as analyzing constraint requirements and data dependencies.
• Was responsible for design, implementation, and maintenance of company Internet/Intranet solutions.
• Designed and implemented Intranet/Internet ASP based data management application.
• The application provided standard data entry / management functionality along with data validation, data
security and password protected access.
• Utilized MS Visual InterDev 6.0, MS SQL Server Enterprise Manager, MS Query Analyzer, and MS VB
Script for middle tier objects and MS Transact SQL for transactions and performance.
Walsh America International, Newtown, PA 01/1998 – 05/1998
Programmer/ Analyst
• Was responsible for business application development using Oracle 7.2, SQL, and PL/SQL. Performed
software problem diagnostics and troubleshooting.
• Installed various software.
Page 5 of 6
Alexandre Kagan
421 Regina Street
Philadelphia, PA 19116
Cell 267-***-****
Email: acgb0e@r.postjobfree.com
• Participated in development and maintenance of new and existing application utilizing Oracle Forms 4.5,
Oracle and SQL Server databases.
• Performed GUI related tests, function, system, and regression tests. Reviewed, confirmed and certified
results of the unit test conducted by development team. Wrote Problem Reports, discussed defects and
resolved technical issues.
SKF USA Inc., King of Prussia, PA 01/1997 – 01/1998
System/Analyst
• Was responsible for all phases of business application development process and operation support.
• Participated in development and maintenance new and existing application utilizing PeopleSoft Code and
PeopleSoft Tools for HR, Benefits utilizing Oracle database, SQL, PL/SQL, SQR, Reports Smith,
PeopleSoft Code and PeopleSoft Tools.
• Performed new release software upgrades, provided software installation and assistance to MIS users.
EDUCATION AND CREDENTIALS
• Bachelor in Engineering Science, Major Industrial Engineering,
Kiev Institute of Engineering Technology, Kiev, Ukraine.
• Certified Oracle Developer Training
Vytag Advantage, Inc., Feasterville, PA
•
Certified in SQR and SQL Workshop.
Certified in Building
•
and Deploying Web FOCUS Reports
Certified in Hyperion Enterprise 5, Hyperion Essbase
•
and Hyperion Application Link.
•
Professional Training Program ADP Education, Atlanta GA
•
Certified in PeopleSoft: PeopleSoft Tools,
PeopleSoft Code and Reports Smith, Atlanta GA
REFERENCES: Available Upon Request.
Page 6 of 6