Vladyslav Pilyavskyy
Philadelphia PA
********@*******.*** 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, Oracle Discoverer, Apptio/Cloudability, Postman, Power BI, Tableau, Alteryx
Programming: MS Access VBA, Toad, webMethods, 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
Consulting/Self-employed, Aug 2023 - present: property and asset management, trading stocks, options and crypto
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 AWS console functionality, 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.
Used Python scripts and Postman to get JSON files from Cloudability and visualize them in Power BI dashboards.
Communicated with Systems Analysts and Developers to facilitate improvements in Management reporting.
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 using Hyperion add-on for data retrieval and pivot tables in Excel.
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
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.