arsenk.com Arsen Tura

Lead Business Systems Consultant


Location

Charlotte, NC

Phone

###.###.7100

About Me

Little bit about me

Solutions-driven business analyst with 10 years of experience leading cross-functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals. Skilled in Capital markets, Trading, Counterparty Risk, Data Warehousing Architecture, Data Analysis, and root cause analysis. Strong information technology skills to utilize my strong prioritization and analytical ability to achieve the results.

Highlights of Expertise

What I do...
01

Agile / Waterfall SDLC

I have eight years of experience working in Agile and Waterfall SDLC projects. Agile methodology is the complete opposite of the waterfall model. It does have all the steps that are mentioned in the waterfall model but instead of following it in a sequential manner, agile methodology follows the collaboration process of everyone involved in the SDLC.

02

Business and Functional Requirements Development

The documentation is useful to depict the requirements and the detailed discussion about new features and change request if any. Both business and functional requirements shapes the outlines of the project.

03

RTM / Test Plan Development

Requirement Traceability Matrix or RTM captures all requirements proposed by the client or software development team. RTM is the best way of keep tracking and capturing the requirements.

04

Multi-tier web/client application development

We live in the world where all multi billion corporation building custom softwares that can be web-based or client server application by using sophisticated layers of protection and customazation.

05

Stock Trading

I have been trading, testing and doing analysis of various types of instruments. All my financial background related to trading of fx, equities and commodities.

06

Reconciliation

In Accounting world all numbers should match and correctly captured by the systems. I have been working on balance sheet reconciliation implementation projects which brought 100% accuracy in reporting.

07

Business and Data Analysis

Business data analysis includes the activities to help managers make strategic decisions, achieve major goals and solve complex problems, by collecting, analyzing and reporting the most useful information relevant to managers' needs.

08

Oracle Business Intelligence Pro Support

Not every one knows SQL or come up with complex queries to their needs. In order to make our users life easier we have customized user friendly Oracle Business Intelligence Suite Enterprise Edition which doesn't require any knowledge of sql scripting.

09

Full Software Testing Life Cycle

STLC is a sequence of different activities performed by the testing team to ensure the quality of the software or the product which covers all type of testing required by the test plan.

10

Data Mining and Analysis

The difference between data analysis and data mining is that data analysis is used to test models and hypotheses on the dataset, e.g., analyzing the effectiveness of a marketing campaign, regardless of the amount of data; in contrast, data mining uses machine learning and statistical models to uncover clandestine or hidden patterns in a large volume of data.

11

Project Management

Project management is the process of leading the work of a team to achieve goals and meet success criteria at a specified time. The primary challenge of project management is to achieve all of the project goals within the given constraints.

12

Metadata Defect Management

Every big corporation has data quality teams those are responsible for validating accuracy of provided datasets, no one wants SHARP which is big a issue.

13

SQL and Unix Scripting

is a set of SQL commands saved as a file in SQL Scripts. A SQL script can contain one or more SQL statements or PL/SQL blocks.A shell script is a computer program designed to be run by the Unix systems.

14

Other tools

I have worked in different type of application for my daily activities but not limited to system configuration management, release deployment, statistical analysis, sql/unix scripting and graphic design.

Skills

Progress bars are still growing
95%

Software Development

93%

Testing and Analysis

91%

PROJECT MANAGEMENT TOOLS

83%

DATA WAREHOUSE / SQL

45%

Javascript + Frameworks

53%

GRAPHIC DESIGN

52%

Unix and Scripting

99%

Emotional Intelligence

Experience

Yes. I've been around.
Jun 2018 – Present

Wells Fargo

Lead Business Systems Consultant

Charlotte, NC

Corporate Accounting and Reporting Data Warehouse (CARD) - an application is responsible for the measurement, reporting, monitoring and oversight of market and counterparty exposures for Wells Fargo. We provide effective governance over activities that create market and counterparty risk, ensuring we have robust infrastructure to capture and report on exposures, and meeting a broad set of regulatory requirements for risk management, stress-testing and capital planning. As a Lead Business System Consultant my role is to plan, design, develop, and launch efficient business, financial, and operations systems in support of core organizational functions and business processes. This includes gathering and analyzing data in support of business cases, proposed projects, and systems requirements. I'm also responsible for generating and compiling reports based on the findings, complete with probable causes and possible solutions to systems issues. I will apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments.

Aug 2017 – May 2018

Wells Fargo Advisors

Systems QA Engineer

Charlotte, NC

X-Value Adjustment (XVA) - Risk Management and Analysis tool to help trader manage anything from several traders and a few positions to large trading groups and hundreds or thousands of positions with ability to monitor and manage risk properly to assist in running trading strategy. One of my primary tasks was to identify counterparty credit risk (CVA/DVA). CVA is the credit adjustment for a derivative that is "in-the-money" i.e. an asset and reflects the credit risk of the counterparty (likely the bank). DVA is the credit adjustment for a derivative that is "out-of-the-money" i.e. a liability and reflects the own credit risk of the reporting entity.

Sep 2015 – May 2017

JP MORGAN CHASE

Senior QA Engineer

New York, NY

Investment Account Application - a web-based trading software and single dealer platform that provides advisors with access to rich functionality across a diverse range of products and services.As a Functional QA Analyst, I have participated in full software testing life cycle (STLC), performing Functional, GUI, Regression and Integration tests on new software enhancement and modifications. Coordinated with test automation team, development team, and business analysts to mitigate risks and meet release deadlines. Developed test plans and test cases through Business Requirement Document (BRD) and Functional Specification Document (FSD) analysis; organized project requirements and test cases; logged and prioritized defects. Performed back-end testing using SQL queries to validate database records. Presented daily and weekly status reports to maintain strict schedule compliance.

Oct 2012 – Apr 2015

UBS FINANCIAL SERVICES INC

Software QA Analyst

New York, NY

FX Web Trading application - is comprehensive information platform with direct links to the UBS trading tools provides key FX market information about real-time prices, market research and offers quantitative analytics. FX Trading Web also helps to place a trade for Financial Advisors and Brokers for the benefit of clients. Application allows brokers to compare different Financial Portfolio options. That unique platform supports diverse business types: Capital markets, Derivative trading, Wealth Management, Fixed Income and used to create, trade, hold, and manage investments As a Software QA Analyst team member worked side by side with developers, business analysts, environment managers, release managers, and business partners to determine optimal test coverage and ensure high quality software delivered to our customers. Been responsible for planning, executing, and managing the testing effort for a variety of projects across multiple lines of business and technology platforms.

Education

OMG, 9 years.
2006 – 2010

University of Illinois at Chicago

B.S., Computer Science and Software Engineering

Chicago, IL

Graduated with Bachelor of Science degree in Computer Science and Software Engineering. University of Illinois at Chicago is one of the top public universities in Chicago, Illinois.

2001 – 2005

Jalal-Abad State University

B.S., Automated System Communications & Management

Jalal-Abad, Kyrgyzstan

Graduated with Bachelor of Science, Automated System Communications & Management. Jalal-Abad State University was founded in 1993 and it is a public university.