Vladyslav Pilyavskyy

Philadelphia PA

ad37n8@r.postjobfree.com Cell: 267-***-****

Summary:

15+ years of experience in harvesting data from complex information systems and providing vital analytics for strategic decision making, planning and financial improvements in Telecom operations, Mobile App development, Banking, Insurance and Consumer Retail industries.

Established framework of financial controls for multiple mobile app development projects.

Developed Costing model utilizing VB macros, facilitated transition of the model from Excel to Web-based Service Catalogue through requirement gathering, documenting procedures and applying Agile methodologies.

Skills:

Accounting: Great Plains, QuickBooks, MS Excel

BI and Analytics: Cognos Powerplay, MicroStrategy, Oracle Discoverer, Alteryx, Apptio/Cloudability, Power BI, Tableau

Programming: MS Access VBA, Toad, Python 3.6

Databases: DB2 on AS/400, RMS, SQL Server, Oracle 11i\ NoSQL, ServiceNow

Education:

Master’s Degree in Business Administration

LaSalle University (December 1999), Philadelphia, Pennsylvania, USA

Major: Finance / Management Information Systems

Bachelor of Business Administration / Commerce

Lviv Academy of Commerce (June 1996), Lviv, Ukraine

Experience:

Bristol-Myers Squibb, Princeton, NJ March 2022 – August 2023

FinOps Analyst – Digital Capability Management, Cloud and Automated Application Services (Pyramid consulting)

Monitored resource consumption and provided Unit Costs across BMS’s accounts, departments and applications by utilizing Apptio analytics platform, applying APIs and advanced Excel functions to enable Core Infrastructure, DevOps, Commercialization IT and other teams to operate Cloud services more effectively and achieving over $14M in annual savings.

Communicated with Systems Analysts and Developers to resolve technical issues and facilitate improvements in Management reporting, designed Tableau and Power BI dashboards for tracking Cost Optimization initiatives.

Comcast, Philadelphia PA Aug. 2019 – Dec. 2020

Senior Analyst – Digital Sales and Marketing (Apidel Tech contract)

Supported My Xfinity, SEO and Digital Media business units by managing $150M overall budget, submitting financial adjustments, and presenting periodic and ad hoc analytics to senior leadership.

Designed trackers and established cost controls related to vendor contracts, evaluated proposed changes in partners’ fees and commission structure for Affiliates and Etail programs.

Created Power BI dashboard for tracking KPIs, budget vs purchase requisitions and procurement status.

Cigna Philadelphia, PA May 2018 – Jun. 2019

Business Analyst / Solutions Design Engineer, Global Infrastructure Services

Provided Cost estimates and analysis for development of Cigna’s Global IT Infrastructure: Databases, Analytics platforms, Network upgrades and Web Products.

Developed Costing model utilizing VB macros, facilitated transition of that model from Excel to Web-based Service Catalogue Application and kept it up to date with technical components and vendor quotes.

Sprint PCS, Reston, VA Aug. 2017 – Nov. 2017

Financial and Operations data Consultant

Analysed capital expenditure, operations data, current technology, and RF-engineering statistics to predict cost and determine Network synergy benefits of merger with T-Mobile

Evaluated revenue models for Sprint’s corporate transformation using Excel pivot tables, functions, charts and wrote VB code to consolidate due diligence and technical data into PowerPoint presentations.

AT&T, King of Prussia, PA Jul. 2014 – Jul. 2017

Financial Analyst - AT&T - Network Operations / Power Infrastructure

Maintained expenditure reporting for power infrastructure and network operations projects, provided $200 million budget allocation and capitalization forecasts to national headquarters based on data in proprietary Vendor Management system, Oracle and Excel trackers.

Produced over $ 20 million of annual savings by developing and presenting cost comparisons used for awarding vendor contracts and improving production mix

Developed Excel VB macros for KPI dashboard updates, cycle time evaluations, automation of Hot-Cut scheduling, tracking of corporate assets using Google Maps APIs, etc.

Extracted data from Oracle and vendor PM systems, developed dashboards to support decision making.

Amphetamobile, Upper Darby, PA Feb. 2013 – Jul. 2014

Manager of Finance and Operations

Established framework of financial controls for multiple mobile app development projects.

Managed communication with stakeholders related to scope definition, design and development phases, ongoing maintenance, technical support, and updates.

Supervised development and customization of cloud-based CMS used as SaaS platform for Continued Medical Education and similar Question/Answer apps.

Bosley’s, Richmond, British Columbia, Canada Oct. 2010 – Jan. 2013

Financial Analyst

Designed OLAP Business Intelligence tools for tracking sales and inventory, created Decision Support models used for Product Mix, Pricing and Supply Chain Optimization.

Assisted Controller with monthly and ad hoc requests related to Trial Balance, P&L statements, Accruals, Audits and Budgeting.

AT&T Nov. 2007 – Nov. 2009

Network Operations, UMTS Project

Maintained expenditure reporting and accounting updates for UMTS network development projects in NE markets, provided budget allocation and accrual forecasts to national headquarters.

Best Buy Canada - Burnaby, British Columbia, Canada 2005 - 2006

Business / Financial Analyst, Financial Planning and Analysis

Communicated with Systems Analysts and Database Administrators to resolve various technical issues and facilitated improvements in Management reporting.

Developed predictive models for Planning and Marketing Resources Allocation utilizing industry research and reports from AC Nielsen and NPD Group.

Implemented and automated several projects for Merchandising, Marketing, Finance and Accounting, created VB applications for assigning various expenses by GL codes and product categories used for budgeting and month-end closure.

Cross Country Bank, Wilmington, DE 2000 - 2004

Systems Analyst - Applied Card Systems

Monitored Cross Country Bank's database and its First Data Resources system compliance, facilitated data exchange between the bank, vendors, and FDR.

Implemented and automated several CRM projects for Collections, Marketing, Risk Management and Recovery departments using SQL, Visual Basic, RPG and CL programming.

Lincoln Investment Planning, Wyncote PA 1998 - 2000

Mutual Fund Accountant

Prepared Net Asset Value reconciliations, Balance Sheets and Statements of Retained Earnings.

Contact this candidate