Life Insurance Quality Assurance
Resume:
EMILIYA REVICH
East Brunswick, NJ *****
********@*******.***
http://www.linkedin.com/in/emiliyarevich
SUMMARY: Senior Business Systems and Quality Assurance Analyst with
over 10 years experience in investment transaction processing, life
insurance, annuities, and corporate services. Expertise in: Business
Analysis, Software Specification and Testing Large Merger
Application Software Integration. Strong technical and problem-
solving skills with expert eye for detail.
PROFESSIONAL EXPERIENCE:
CANON BUSINESS SOLUTIONS, Jamesburg, NJ 2009 – Present
Business Analyst, Business Process Reengineering
Working in the area of Canon Sales and Incentive Compensations
• Responsible for daily support of Canon Oracle applications.
• Work closely with sales support group to understand the business requirements and
translate them into IT Functional Design in order to expand Canon Business Acumen
Create and perform functional testing of all system defects modifications as well as system
enhancements.
Work closely with Oracle development resources to insure proper communication of Canon
business requirements.
Review technical documents to insure cross application integrity is considered.
• Assist with routine testing and upgrades, and overseeing the conversion of data and
testing of interfaces/extensions.
• Recommend business procedures improvements
• Provide functional analysis of legacy system decommission and required
customizations to the new SFA tool – Salesforce.com. As part of this project’s
functional team, participate in data conversions from Oracle to Salesforce.com.
BLACKROCK SOLUTIONS, Plainsboro, NJ 2006-2008
Senior Business Systems Analyst (AVP) – Client Data Interfaces
Responsible for over 15 interfaces built for the Merrill Lynch Investment Managers - Blackrock
integration.
• Successfully specified, built, and deployed significant number of key interfaces into
and out of the Blackrock Aladdin application in order to successfully integrate the
two infrastructures. This was accomplished within 10 months of the merger
announcement to the public.
• Gathered client business and systems requirements for client data interfaces.
Authored detailed and effective business systems specifications in order to resolve issues
and recommend effective solutions that meet client requirements.
Analyzed data quality in order to reduce data related production issues and improve
overall interface performance.
Provided development teams with full interface documentation including the interface overview,
data mapping, jobs setup, timing, test cases, and support and troubleshooting steps.
Worked with project management, business unit, and development teams to insure that all the
requirements are met.
Supported full product lifecycle for instruments traded in Domestic and Foreign Equities, Bonds,
MBS/TBA, Options, and Futures.
Prepared use cases for system and user acceptance testing of the upcoming releases.
Constructed and coordinated execution of system, regression, and user acceptance testing.
Wrote internal and external product release documentation.
Coordinated and led Client Data Interfaces team efforts at the annual Russell Rebalance event in
2008.
CHENOA INFORMATION SERVICES, Edison, NJ 2002-2006
Lead Business Systems Analyst
Life Insurance and Immediate Annuities Payout Project for AIG SunAmerica Financial.
• Played a key role in conversion of legacy Vantage system to the Navisys Home
office (PowerBuilder/C application), Front office (WEB interface), and Oracle
DBMS.
Worked with AIG business analysts and systems users on business and systems requirements
gathering.
Created process flows, charts, and diagrams of Navisys user interface and database schema that
helped AIG client business unit in planning of conversion from legacy Vantage to new Navisys
system.
• Wrote Business Requirements Documents (BRD) and System Requirements
Documents (SRD). These documents outlined enhancements to Front Office (Policy
Administration module) and Home Office (Account Management, Product
Specifications, and Supervisor modules).
• Led the group of 4 QA analysts in System, Regression, and User Acceptance Testing.
This resulted in bug-free system that is running successfully for over 3 years.
Created and executed test scripts for system testing of the Payout functionality.
Validated expected testing results using both front end and database schema.
Ran SQL queries to validate changes in the database.
Analyzed issues and worked with developers to resolve them quickly and efficiently.
• Participated in data conversion and data stability projects.
NAVISYS ENTERPRISE SOLUTIONS, Edison, NJ 1998-2002 Senior
Programmer/Analyst
Led a development team of 5 responsible for implementation and customizations of the
company’s main product LifeCAD/MP, a package of multi-tier insurance applications supporting
administration of universal life insurance and annuity product lines, for some of the largest
insurance companies. Over years developed an understanding of various insurance products such
as Variable Universal Life, Deferred Annuities, Term Life, Single and Joint Life products.
For CNA Life Insurance Company, Prudential and Allmerica Financial:
• Designed and programmed various enhancements to LifeCAD/MP which include modifications
to immediate and deferred annuity, single and joint life functionality.
• Conducted design and implementation of Payout Project (immediate annuities).
• Coordinated walkthroughs of Functional Specifications, database design, code reviews, and man-
hours estimates needed for client requested enhancements.
• Developed in PowerBuilder and created stored procedures, packages, and triggers in Oracle and
Sybase databases.
• Facilitated client production meetings and supported system tests.
Accounts
OGILVY, ADAMS & RINEHART, New York City 1993-1998
Payable Supervisor
Wrote and implemented accounting control procedures resulting in more effective time
management and reduction of production issues. Managed processing of vendor invoices,
expense reports, and wire transfers. Supervised Accounts Payable month closings, assisted
controller with General Ledger closing. Communicated with all levels of employees and vendors,
managed trouble shooting.
LANGUAGES: SQL, PL SQL, PowerBuilder (7.3, 6.5, 5.0), HTML, Java Script,
XML
OPERATING SYSTEMS: Windows (95, 98, NT, 2000), Oracle (8, 8i, 9, 11i), Sybase, MS
SQL, HP UNIX
SOFTWARE: Salesforce.com, PAM, APEX Data Loader, Oracle Financials, Oracle Forms,
Visio, TOAD, SQL Plus, PVCS, VSS, SQA Suite, PR Tracker, LifeCAD/MP, Aladdin, Microsoft
Word, Excel, Access, Power Point, Project, SharePoint, WIKI pages
HARDWARE: IBM PC and compatibles, SUN UNIX Servers
EDUCATION:
B. S. in Accounting, Academy of Technology,
o
Kharkiv, Ukraine
• Effective Business Writing and Communications Class, BlackRock Education
Course
• Associate, Annuity Products and Administration (AAPA), LOMA Education
Programs Designation
Oracle DBA Course, Comet Technology, Edison, NJ
o PowerBuilder Development
and Oracle Programming
Course,
Cope Institute, New York, NY
• Computerized Accounting and Business Communication Course,
Syrit Computer Schools System, Brooklyn, NY
• Application Design and Database Development Classes,
Institute of Advanced Programming, Kiev, Ukraine
Contact this candidate