Project Data

Revised: February ****

/** Westhampton Dr

Thornhill, On, L4J 7H3

Alexander Krutik, PMP

Phone: 647-***-**** e-mail:*******@******.***

Summary

1. Extensive experience in participating in various projects through all of phases of life cycle

2. Winning combination of personal, analytical, technical, management, influencing, negotiation and communication skills

3. Working experience in the organizations following CMMI standard practices

4. Experience in design and development applications with relational databases including DB2, Oracle, Netezza, MS SQL Server (stored procedures, views)

5. Expert in defining, managing and communicating users, functional and system requirements

6. Ability to investigate and document data flow and systems processes

7. Experience with managing project activities for various functional teams

8. Ability to communicate with both business and technical resources in terms they can understand and work cooperatively with architects developers and project managers to deliver implemented solutions

9. Ability to learn very quickly and apply new skills to arising challenges

10. Expert level of experience in Quality Assurance and Testing standards, practices and procedures

SKILLS

RDBMS

DB2, MS SQL Server, Oracle, Sybase, Access, Netezza

Languages

RPG/400, ILE RPG/400, VB, PL/I, VBScript, VBA, SQL

Operating systems

OS/400, MS Windows, Unix, Linux

ETL Tools

Integration services MS SQLServer, Ab Initio, Data Stage

Testing Automation Tools

QTP, LoadRunner

Information Delivery Tools

Cognos, Stratum, Query/400, QM Query 400, Business Objects, Infomaker

Other Software

Microsoft Project, MS Visio, Mercury Quality Center, VSTS, Issue View

File Transfer Software

FTP, Tumbleweed Secure Transport, CuteFTP, WS-FTP, FDX Client

EMPLOYMENT Experience

Feb11–Present Canadian Tire Toronto, On

QA Lead/ BSA

1. Coordinated QA activities for various BI initiatives sourced data from Enterprise Data Warehouse. Those initiatives projects (ETL/BI, Data integration).

2. Lead efforts of teams of individuals located both on-site and off-shore for preparation and execution of system integration, functional and user acceptance testing. Those activities were aimed to validate BI reports, ETL codes and data models.

3. Developed test strategies, test plans, test definition reports and test completion reports

4. Conducted defect: management (escalated issues, ran meetings with DA’s, SA’s Development, facilitated resolution)

5. Participated in Data mapping, Data modeling, Data profiling

6. Participated in deployment to production environment validated solutions

May09–Jan11 Polytainers Inc Toronto, On

Sr. BSA

1. Collected and facilitated business requirements for data collection system

2. Mapped business requirements to vendor’s supplied CRM analytics (sales data mart)

3. Developed business requirements and use case scenarios for customization of vendor’s software

4. Developed QA strategy for acceptance of vendor’s software

5. Lead team efforts for system integration and user acceptance testing (data control, code drop control, time and resource management, defect management)

6. Created user’s manual and conducted training sessions with end users

7. Coordinated implementation efforts for cross platform application

Aug08–May09 Bank of Montreal Toronto, On

QA Lead Data Warehousing Project/BA

1. Responsible for defining the strategy on how to incorporate the new data into the enterprise data warehouse and follow up with the overall design for the data mart

2. Lead a team of QA analysts for testing ETL and extract from source system processes

3. Created test strategy and test plans

4. Participated in test scope definition, resource and time estimation and planning

5. Coordinated efforts with other groups for testing environment setup and testing environment validation

6. Verified business and functional requirements outlined in Business Requirements Specifications, Data Inventory, Logical Data Model, Technical Infrastructure Diagram and Technical design specifications.

7. Monitored testing activities and escalated issues that will impact schedule, created and delivered progress reports.

Mar07–Aug08 CIBC Toronto, On

QA Lead

1. Coordinated and led team of testers for System Integration, Users Acceptance and Business Acceptance testing for various projects

2. Created test strategy and test plans (Traceability matrix, Test case summary, Test execution plan)

3. Performed requirements validation (requirements gap analysis).

4. Analyzed and evaluated requirements to create Test Scenarios and Test Cases

5. Ran interviews with stakeholders for elicitation of users and system requirements

6. Provided structured test execution feedback as well as structured analysis and management of test results.

7. Planned and utilized resources based on work forecast

8. Mentored, trained and provided guidance from a testing perspective to other team members.

9. Worked with the various functional groups (DBA’s, Developers, Operations support) in order to setup test environments.

10. Coordinated efforts of testers, developers and operations specialists in defining, investigating and resolving testing defects.

11. Worked with the developers and Business Analysts to create meaningful test data.

12. Prepared input data files as required to support test procedures

13. Created FDX (FTP) scripts for testing scheduled transfer of the files of special formats (EDI, EFT, ACH)

14. Coordinated cross channel testing with teams from various departments and operations team (third party)

15. Created user’s manual and conducted training session with end users

16. Prepared plan for business acceptance testing prior to implementation

Sep99-Mar 07 Polytainers Inc Toronto, On

Senior Business Analyst/QA Lead

1. Led implementation of Data Warehouse project for the Company

2. Created SQL scripts for test data creation and database manipulations

3. Developed and implemented structured QA methodologies

4. Set up test strategies and wrote test plans and executed them to ensure full test coverage and quality product releases

5. Worked with the business, development team and software vendor to ensure issue resolution retest and evaluated all changes

6. Analyzed and fine-tuned the performance of various queries to improve the overall response of the Data Tracker application

7. Designed and executed test scenarios that involved processing large amounts of data to test how the DT performs under extreme load conditions

8. Led the implementation of the QM Query/400 as a reporting/batch processing tool within the IT department

9. Led a team that was assigned to design, develop and implement an easy-to-use programming tool for building models for cost estimation

10. Managed home grown applications for Capacity planning and Master Production Scheduling

11. Introduced modifications into various BPCS applications (Order Entry, Inventory Control, General Ledger, Costing)

12. Mastered Cognos cubes on basis of customized business requirements.

13. Lead implementation of third party software for EDI transactions (850: PO and 810: Invoice) between hosts and customer’s ERP systems

Apr99–Sep99… ASE BV Best, the Netherlands

Consultant

1. Redesigned test scripts for invoicing strategy for EU-wide Corporation.

2. Automated Modified Order Entry and Billing application due to provide EDI functionality.

3. Lead Team efforts for User Acceptance Testing - Purchase order to Sales order project.

Aug98–Apr99.. Becton Dickinson Canada Inc Oakville, On.

Senior Programmer Analyst

1. Designed and implemented various modifications to the Rebate system and Quotes Work Up System resulted speeding-up customer’s rebate claim satisfaction and more accurate reporting.

2. Tested interface to the forwarder system. Implementation of this project resulted in a lower cost of delivery payments and provided better information exchange between the shipping department and the forwarder company.

3. Maintained databases of problems and solutions as well as test situations (SQL)

4. Changed Setup in the Sales Tracker (DW) resulted improving of functionality of this application package. Modified interfaces to it with updating history data due to provide correct annual sales figures.

5. Provided technical solution for implementation in company “Special Dealer Price Program”.

6. Developed data cleansing strategy, prior to migration to SAP.

Nov95–May98 ASE BV-Liraz Best, the Netherlands

Consultant

1. Provided technical support and end user support for more than 200 users of international company.

1. Managed cost and time of projects against baseline

1. Lead team efforts for implementation Lot Control system for selling products and European VAT/Intrastate reporting.

2. Designed and implemented extensions of various vanilla applications (Order Entry and Billing, Inventory Control) providing functionality of centralized commissioner structure of the company.

3. Redesigned distribution applications resulted improving of inventory turnover, higher-level automation of personnel tasks and increasing customer satisfaction due to faster delivery time.

Dec91–Oct95 G.N.Heshev Systems LTD Tel-Aviv, Israel

Programmer, Programmer Analyst

1. As part of a team developed and implemented logistic program complex aimed at trace through the manufacturing process.

2. Coded and tested application “Calculation of product cost” making it possible to estimate the most profitable way of production process.

3. Developed report and inquiry generators.

1989–1990 "Himki" Complex Moscow, SC

Programmer

1. Designed and implemented an application for Order Entry and Goods Shipping with interface to G/L for distribution company dealing primarily with department stores.

Education and training

1982–1987 Dnepr Tech University Ukraine

1. MS in Applied Mathematics, BS in Computer Science.

1991 IBM Israel Tel Aviv, Israel

1. RPG/400 -IBM AS/400.

1995 "Ashrot”-Microsoft Tel Aviv, Israel

1. Visual Basic -MS Windows

2000 School of Business York University Toronto, On

1. Project Management Course

2003 Hands on Technology Toronto, On

1. ASP.NET introduction

2004 Lean Enterprise Institute Erlander, KY

1. Value Stream Mapping

2. Creating Level Pull

2006 University of Toronto Toronto, On

1. Project management certification program

2007 BearingPoint Toronto, On

1. Enterprise Testing Methodology

References Available Upon Request

Page of

Contact this candidate