Post Job Free

Resume

Sign in

Office Analyst

Location:
Walled Lake, MI
Posted:
February 13, 2021

Contact this candidate

Resume:

Eduard Udovichenko

**** ******* **** ********, ** 48382 248-***-****

OBJECTIVE:

Seeking a challenging and rewarding position as a Software Quality Assurance Analyst COMPUTER SKILLS:

MS SharePoint 2003, MS Visio 2007/BPMN, Selenium, Oracle 10g, 9x, 8.x, SQL, TOAD, PL/SQL, Haddop, XML, HTML, JavaScript, Mercury Load Runner, Java, JSP, SQL*PLUS, SQL Server 2003, VSS

(Visual Source Safe), Visual Basic 6.0/5.0, Crystal Reports 7.0/6.0, Business Objects XI, MS Office 2000 (Word, Excel, Access, PowerPoint, Project), ASP, Visio, Windows XP/NT/2000, UNIX, Linux. EXPERIENCE:

08/2017 – present Global Professional Services (Contract), West Bloomfield, MI QA Analyst

Created test plans for various clients’ applications.

Reviewed and gained approval on the test plan with the clients.

Created and executed test cases, tracked and retested defects.

Assisted in creation and communication of release notes.

Performed data analysis as needed.

ENVIRONMENT: SQL, Oracle, Hadoop, Atlassian Products (Jira, Confluence), MS Office 360, Visio.

08/2012 – 06/2017 Diplomat, Specialty Pharmacy. Flint, MI QA Analyst

Responsible for the development and execution of test cases for custom web based pharmaceutical application (written in .NET).

Report defects found through QA testing using Jira.

Coordinate and execute integrated system test and regression testing.

Conducted Functional Walkthroughs and User Acceptance Testing (UAT)

Involved in the BRD (business requirement document) and FRD (functional requirement document) reviews; provide feedback and recommendations.

Responsible for Data Mapping for SSIS and SSRS reports and test of release packages.

Responsible for ETL testing.

Execute various SQL queries, scripts and procedure for back-end validation.

Perform UI functional testing (manual and automated testing).

Prepared Defect Summary reports and communicated to senior management, the project team and the business.

Make recommendations for improvement of applications to programmers and software developers.

ENVIRONMENT: SQL, MS SQL Server 8/12, Selenium, Automate 9, iWay, MS SharePoint 2003, MS Visio 2007/BPMN, MS Office 2007, SalesForce, Atlassian Products (Jira, Confluence). 05/2010 – 07/2012 Global Professional Services (Contract), West Bloomfield, MI QA Analyst

Create and execute functional and regression test cases for various applications.

Used Selenium for automated web application testing.

Created a test plan for an existing EDGE application.

Created and executed functional, non-functional and regression test cases.

Assist in data analysis of EDGE application that was required to migrate it to SalesForce.

Maintain traceability between requirements and test cases.

Communicated with the team on open defects and prioritization of the fixes.

Prepared test executive summary prior to each release. ENVIRONMENT: Selenium, MS SharePoint 2003, MS Visio 2007/BPMN, MS Office 2007, SalesForce

04/2007 – 04/2010 M&S Builders, Macomb, MI

QA Analyst

Develop an application test plan including System, UAT and Regression Test Cases

Responsible for Test Case Execution and Result validation

Document, analyze and track defects discovered during testing

Provide test planning and test execution statuses and metrics to the team.

Assist in gathering and capturing business requirements

Create various ad-hoc reports

Train business users on a new system(s), features. ENVIRONMENT: Oracle 10g, SQL, PL/SQL, TOAD, HTML, XML, JavaScript, Java, Vantive, MS Office (Word, Excel, Assess, PowerPoint, Project), SQL Server 2003, Business Objects XI, Visual Source Safe, Unix, Linux, Vantive Helpdesk 04/2006 – 03/2007 American Communication Network (ACN), Farmington Hills, MI Quality Assurance Analyst

Develop test cases and test scripts that reflect all logic paths and test all requirements.

Report defects found through QA testing using custom helpdesk software (Vantive).

Coordinate and execute integrated system test, regression testing and coordinate user acceptance testing for all business units (North America, Europe and Australia).

Involve in the BRD (business requirement document) and FRD (functional requirement document) reviews; provide feedback and recommendations.

Coordinate and support UAT, regression and production change controls.

Execute various SQL queries, scripts and procedure for back-end validation.

Perform UI functional testing.

Create data setup scripts and documentation to share with other QA team members.

Involve in developing Quality Assurance standards and processes.

Provide management team with test case coverage and defect metrics to assist in product/application launch decisions.

ENVIRONMENT: Oracle 10g, SQL, PL/SQL, TOAD, HTML, XML, JavaScript, Java, Vantive, MS Office (Word, Excel, Assess, PowerPoint, Project), SQL Server 2003, Business Objects XI, Visual Source Safe, Unix, Linux, Vantive Helpdesk. 06/2002 – 03/2006 Easy Loans, Oak Park, MI

Quality Assurance Analyst

Created, debugged and executed test cases for all internal and external applications.

Analyzed Business Requirement specifications.

Reported defects by using custom tool (QALOG) and re-tested them after the fixes were made.

Communicated the test results to the users to receive UAT sign off.

Re-tested the fixes in production environment after deployment.

Responsible for testing all major releases of the following applications: Survey system, CLS

(Customer Lead System), Loan by Phone app, Credit Check app, Easy Loans public web site – www.easyloansamerica.com).

Performed GUI testing as well as back-end validation.

Involved in load testing against internal applications and services using LoadRunner scripts to emulate users and monitor systems performance.

Executed SQL queries for back-end validations.

Assisted project manager with test estimates.

Executed customer lead loads into CLS on demand.

Created user documentation.

Trained users.

ENVIRONMENT: Oracle 9x, SQL, TOAD, HTML, JavaScript, ASP, QALOG, Mercury LoadRunner, MS Access, MS Excel, Genesis 2000, Point, Byte, MS Windows XP/2000. 12/2000 – 05/2002 American Blinds, Wallpaper and More, Plymouth, MI Programmer/Analyst

Participated in the analysis, design, and development and testing phases of the new decoratetoday site.

Met regularly with analysts and subject matter experts to confirm and implement business rules, procedures, and processes.

Created Web based forms, reports and search criteria for CIS applications.

Interfaced with other areas in information systems and departments to support existing production systems.

Part of three-person rotation on call support team. ENVIRONMENT: ORACLE 8.0, SQL, SQL*PLUS, PL/SQL, ASP, HTML, JavaScript, MS Office 2000, Windows NT/98/95, UNIX AIX

09/1999 – 12/2000 CompuSeek, West Bloomfield MI

Programmer/Analyst

Designed, implemented, and maintained Patient Satisfactory Survey System.

Created different Data bases objects: Tables, Sequences, Views, Stored procedures, and triggers.

Worked on performance improvements of the queries.

Tested and supported Payroll System.

Participated in system testing of other projects.

Provided user support and developed user and system documentation. ENVIRONMENT: ORACLE 8.0/7.3, SQL, SQL*PLUS, PL/SQL, Visual Basic 6.0, Crystal Reports 7.0, MS Office 97/2000, Windows 95/98/NT

06/1998 – 09/1999 GT Consulting, Southfield, MI

Programmer/Analyst

Participated in a team effort of design and development of the Client Order Entry System.

Created Tables, Queries using MS Access.

Created various screens for the application.

Generated many customized reports per user request.

Trained users and provided customer support.

ENVIRONMENT: Visual Basic 6.0, MS Access 97/95, SQL, Crystal Reports 6.0, and MS Office 95. 03/1997- 06/1998 Daring Co

Programmer

Programmed, tested and supported Daring Client Software.

Trained users to work with Windows 95 and Ms Office (Excel, Word, Power point, and Access). ENVIRONMENT: Visual Basic 5.0, MS Access 95/97, SQL, Unix and MS Office 95. EDUCATION:

2013 ITIL Certified.

1997-1998 Goal Training, Inc., Southfield, MI

Advanced ORACLE Training.

Certificate in programming with MS Access and Visual Basic. 1994-1997 Poltava State University, Poltava, Ukraine Associate degree in Computer Since

REFERENCES: Available upon request



Contact this candidate