Business Analyst III

Alexander Rozinoyer

Missouri City, TX *****

www.linkedin.com/in/alexander-rozinoyer-165630135

adhu0b@r.postjobfree.com 281-***-****

Business Analyst III – Conversion

Results-oriented IT professional with many years of experience in computer system design and software development. Involved in all phases of System Development Life Cycle from Business Analysis to Development, Implementation and Support in Financial and Trading Operations. As Certified Professional Business Analyst successfully utilized various BA methods and techniques – from Elicitation of the Business Requirements to Process Analysis and Modeling. Comprehensive understanding of business process improvement approach and techniques, Applications upgrade and Conversion. Solid SQL skills and extensive experience with various Reporting and Analytical Tools. Active participation in the Systems Upgrades and new Applications Implementation processes, UAT activities. Champion customer focus, building close interactions and collaborative work approach with business stakeholders.

Business Requirements Elicitation Functional Design Data Analysis & Data Modeling

Financial aspects Process Improvements Systems Upgrade and Conversion Process Validation

SQL Development Reporting & Visualization Documentation Training Testing

Technical Skills

DBMS:

MS SQL Server, Sybase, Oracle, HANA, JD Edwards DW, MS Access

Presentation and Technical Tools:

MS Office, Visio, Power Point, SQL Server Management Studio, SQL Developer

BI, ETL, Analytics, Reporting Tools:

Power BI, Tableau, SSDT, SSIS, Spotfire, Actuate, Crystal Reports

Languages, Spreadsheets:

VB.net, VBA, Excel, SmartView, SQL, Phyton, DAX, VB6, C, Java, AVS

Project and Workflow Management Methods and Tools:

SCRUM, EDGE, MS PROJECT, SM9, Rational Clear Quest, HP ALM, JIRA, Confluence

Professional Experience

AIRSWIFT, Houston, TX Sep 2019 to Mar 2020

Developer - Contractor

Participated in conversion of the existing Company Financial system to new Dynamics 365 based Vendor Management System (VMS) as component of Order to Cash Process Improvement Project. Designed and Developed Excel/VBA based Timesheet Interface (FTI) Tools for Transformation and Reconciliation Invoices & Timesheets originated through the various VMS with Banks Payments and to transfer Detailed Remittance to new D365 based VMS.

Elicited Users requirements and designed FTI AR/AP processes. Developed BRD and Functional Requirements, mapped and reconciled data from the different data sources (Excel, VBA, Dashboards, Power BI, SQL, Visio), provided necessary documentation,

Developed and tested application, facilitated UAT and user Training.

Accomplished Hypercare support during implementation of the new process for each client.

UNIVERSE TECHNICAL TRANSLATION, Houston, TX Jan 2019 to Mar 2019

IT Business Analyst - Contractor

Developed OLAP Solutions for Company Financials built on the existing Data Storage (MS SQL data base - T-SQL, MS Access, Excel Spreadsheets & Share Point files). Built with Power BI the Data model and respective visualizations for Cost, P&L, ROI and its factors using the existing data sources.

Gathered Users requirements and performed Mockup for Output Visuals and Dashboards;

Mapped and reconciled Data, Developed documentation (BRD, Functional Specifications).

Researched the feasibility of the integration of existing data sources and conversion to SQL Server BI Stack, prepared Proposes Statement of Work (SOW)

Alexander Rozinoyer adhu0b@r.postjobfree.com Page Two

WEATHERFORD INTERNATIONAL, Houston, TX Jul 2018 to Oct 2018 2008 to 2018

Project Business Analyst, Planning and Materials Management Group - Contractor

Participated in the Inventory Management Improvements Activities.

Provided Proof of Concepts activities to convert existing Oracle BI module to MS SQL Server based analytical platform (SSIS, Power BI, Python). Developed ETL (SSIS based) process to transfer data from JDE ERP to MS SQL Server.

Modeled, developed various Power BI Visualizations and Dashboards based on JD Edwards Data Warehouse. Published to Power BI Server, provided with necessary documentation and training. Reconciled Inventory Roll data from Hyperion and JDE based monthly Inventory (Oracle, PL SQL) and new converted Data.

SHELL TRADING AND SUPPLY COMPANY, Houston, TX Feb 2008 to Feb 2018

Senior Applications Analyst / Business Analyst

Supported BackOffice operations during preparation to new Trading Management System go-live and Hypercare by shadowing Backoffice Financial processes (Inventory Control, Accounting, TB2Fin, Actualization), defects resolution for Risk management components (Deal Entry, DAH, Accounting, Settlement Desktop, C-Motion) in Endur, discussed possible improvements of the conversion process from Legacy System with Development Team.

Performed system (Endur) configuration process and Data Analysis, documented it, provided training and transition to Operation Support Team (SOM).

Accomplished SME and Business Analyst roles for Canada Crude Conversion and Canada Products integration Projects. Provided exploratory data analysis, functional requirements and data flow modeling for Data Transition Process from the legacy application to new system. Participated in development of system extraction queries according to new product specifications. (Oracle, OMS). Communicated with Development Team, Solution Architect and Vendor, determining project scalability and acquiring Scope of Work (SOW) sign off. Participated in Integration Testing and UAT. Established and provided support for user training.

Participated in Hypercare and Management Release activities for E2E Data Analysis and Reporting in new Shell Trading Product Management System; gathered business requests, mapped legacy Reporting system to new one, determined reporting requirements and recorded acceptance criteria, adjusted the existing reports and developed new ones, accommodating user’s requests, KPIs and SLA; was involved into Unit test for the Reporting Blocks and Integration Test, facilitated smoke test and UAT.

Oversaw SOX compliance and auditing reporting in Risk Control Management. Developed new SOX and Health Check Reports controlling consistency of Daily and Cumulative P&L and Exposure Changes and provided necessary reporting and analytical support during External Audit. Developed System and User documentation for SOX Reports. Developed routine to assure and prove the SOX compliance of the processes if SOX Report is broken.

Performed implementation and stabilization of Change Management Processes in the Reporting Area: incident control, root cause analysis (SM9, HP ALM, JIRA)

Accomplished “Soft Landing” and Decommission of the supported Legacy Applications (OMS and Actuate Reporting). Performed all the necessary procedures for IRM and SOX compliancy

Partnered in performance improvement activities for data reconciliation process between multi-environment Data Bases; recommended adjustments in Table and Views structure, tuned up indexes; optimized underlying SQL queries in Endur / EDS (Oracle) and provided reverse engineering to build HANA SQL queries using Tableau Reports.

Prepared test scripts and supported users during Integration and User Acceptance Testing.

Performed PM, SME and BA roles and provided proactive support, continuous improvement and expansion of Actuate Reporting suite (e-Reports. e-Spreadsheets) as major component of the Legacy reporting Landscape for Shell Trading and Supply operations system.

Provided requirements elicitation and analysis, built Users Stories and acceptance criteria, Business Requirements Documents, SRS, perform data modeling, development and support for Actuate based Reporting system; engaged Stakeholders (Vendors, Users) into discussions regarding various R&M aspects.

Completed Data Analysis & Modeling for reporting clusters, recommended changes in DDL; achieved performance improvement by optimizing underlying scripts according to new indexes (Oracle, Sybase).

Initiated and provided reliable L2 support for OMS - Crude Oil Marketing System for Shell Trading Canada (STC). Communicated with Vendor to discover, record & resolve issues. Was actively involved (as SME and Business Analyst) into development of Support Model. Designed daily transaction and price data transfer (Curves & Indexes) from OMS to Endur Market Manager using MS Access and SQL ODBC based transactions (Sybase, T-SQL).

Alexander Rozinoyer adhu0b@r.postjobfree.com Page Three

SHELL TRADING AND SUPPLY COMPANY (Continued)

Engaged stakeholders and facilitated processes for OMS upgrade, including interface to SAP and application switch to 64bit platform; controlled collaborated efforts from global Citrix, DBA, vendor and user teams. As result, performance and functional abilities of application were increased and usage of application was greatly expanded.

Accomplished Change control requirements related to Actuate and OMS systems – provided necessary documentation and Disaster recovery preparation process.

Accomplished Business Analysis (Requirements elicitation, Users Stories and acceptance criteria, System Requirements, Data Modeling), Design, Development and UAT for Prior Period Adjustments (PPA) Calculation Tool.

Provided projects requirements elicitation, Business Analysis, process modeling and analysis, engaging of various teams into discussions, feasibility and financial estimation for different approaches, participated in DDL adjustments, test scripting and deployment scheduling, participated in Integration Testing and led UAT activities.

Led (as Project Manager and BA) support and continuous improvement of “Schedulers Buy/Sell What If” Tool (delivery control and optimization application for Crude Schedulers). Tool enabled Business with additional financial analysis for scheduling and saved about $600K - $1200K per month in shipping fees. Fulfilled feasibility study and received Business Stakeholders agreement to upgrade Tool to .NET platform. Established User Group.

Prepared necessary User and System Documentation for applications above. Established and oversaw User Training.

Provided analysis and support for the scheduling and trucking – process improvement and analysis (ticketing procedures, delivery reporting).

EQUIVA TRADING / SHELL TRADING SERVICES CO, Houston, TX Dec 1999 to Feb 2008

Senior Systems Analyst / Team Lead

Provided Data Analysis and led design, development, and implementation of Trade Book vs. Financials Reconciliation Tool (TFR) for Crude. Engaged Business Stakeholders and Architecture Group into discussions regarding specific application requirements and technical solution. Utilized “Working Prototype” (agile, iterative development approach).

Completed Business Analysis (elicited requirements, built Users Stories, data & process flow) and Functional Design for “Schedulers Buy / Sell What If” Tool, building delivery balance control and optimization application for Crude Schedulers. Provided leadership for development and implementation of “Schedulers Buy / Sell What If” Tool using “Working Prototype” approach. Facilitated Acceptance Test, Hypercare Support and users training

Provided Project Management and Supervisory Functions for Stock Reconciliation Tool (SRT) for Refined Products Inventory Management application during transition to support by managing Support Transition Team, confirmed acceptance criteria, performing application adjustments, and Process Re-Engineering and Re-Modeling for Corporate Implementation. Conversion As-Is process to more effective To-Be. Engaged all levels of Business community into communications and improvements of supported product and stablished and managed SRT Users Group. Attempted to use UML during Process re-modeling

Accomplished business analysis, design, development and implementation for Trading Analytical and Reporting Tool (TART) for Crude traders, schedulers and Risk Control Analysts as a part of Trading System Conversion to new Endur based System. Completed BRD, Functional Requirements Document, Data Flow Diagram using Visio, Physical Data Model. Was responsible for the system testing and UAT.

Education

Master’s Degree, Mathematics, Major in Applied Mathematics, Azerbaijan State University, Baku, USSR 1978

Professional Certificate, Business Analysis, The George Washington University, School of Business, 2009

SCRUM Fundamentals Certificate (SFC), VMEdu, 2018

Relevant Training and Development

Preparatory course for SCRUM Master Certification Exam — Jul 2019

SCRUM Study (Right Management Resources) — Dec 2017

BA CBAP Certification Preparatory Class — August 2017

Tableau Fundamentals I Class — August 2016

Leadership classes — Basis of Financial Management; Influencing Skills — 2014, 2015

Business Analysis Classes toward BAP Certification (ESI 2008 — 2009)

Contact this candidate