MILANA KRUPETSKY

917-***-**** ad0p4z@r.postjobfree.com

Professional Summary:

Remote based Senior BI Data Analyst with advanced technical background in database and system administration bringing top notch abilities in competitor analysis, business intel development and trend assessment to promote company progression and boost revenue performance. Productive and industrious in achieving targets by leveraging BI data and producing well planned recommendations. Possess communication, problem solving, analytical, project management and leadership skills. Skills:

● Data engineering, collection, cleansing, transforming, modeling, ETL, requirement gathering, interpretation, mapping: Oracle, SQL* Server, MS SQL, Redshift, Stitch, M3DB, Snowflake databases and warehouses, Big Data, Big Query, etc.

● Data Analysis: Statistical, Diagnostic, Exploratory, Predictive, Prescriptive using Looker, Tableau, Qlik, MatLab, Birst, Power BI, Funnel, Google and Oracle Analytics Suit, Amplitude, Adobe Analytics, Power Query, DBT, SSIS, MS Suit, Excel, Power Point, Google Sheets.

● Operational Assessment and defect tracking: Jira, Rally, Airflow.

● Business Development, Management, Support, Sales.

● ITIL Project Management and Strategic Planning.

● Systems: Windows, AWS, Redshift, Unix

● Languages: SQL / PLSQL, Python, JSON, API, Java

● Staying calm and maintaining a positive attitude in stressful environments. Work History:

Senior BI Data Analyst 01/2023 to Current Palmetto Solar

● Partner with teams across the organization (sales, marketing, product development, etc) to produce Looker dashboards and analytics solutions that allow them to make strategic business development decisions

● Collaborate with the Executive team to obtain inputs, drive decisions, and solicit feedback used to develop, refine, and finalize sales target deliverables.

● Collaborate with Sales team by conducting gap analysis of current to target sales funnels and define actionable data that can move stale milestones towards the sale

● Synthesized current business intelligence data from multiple sources( Snowflake, Excel, GA, Sales Force) to produce reports and polished presentations using Looker, Excel, Tableau, Birst highlighting findings and recommendations against OKRs, Partner Acquisitions and Success Management.

● Work with product developers to implement data strategies, build data flows, and develop conceptual data models

● On a daily basis maintained Data Warehouse ELT processes using DBT and GITHUB Senior Data Analyst 01/2020 to 11/2022 Twitter – Social Network Company

● Promoted marketing campaigns and brand development by conducting Audience Data and User Behavior web traffic analysis while making strategic recommendations for development and marketing solutions.

● A/B and regression testing on Vendor Signup and Retention strategies, Local Sales Team performance, Contract Management, Registry Billing and others.

● Choose reporting tools and oversee development processes while providing expertise on data needs for projects requirements gathering, deliveries, baseline, acceptance, deployment, testing. Senior BI Data Analyst 01/2017 to 01/2020 XO Group – Multi-brand ecommerce marketplace

● Conducted gap and growth analysis of current to target state business architectures (in case of existing solutions) and define roadmap and plans to achieve target state by combining data from multiple sources ( SQL, Snowflake, M3DB, GA, Excel) transforming data ( DBT ) and building Birst, Tableau and Looker dashboards.

● Collaborate with Business SMEs and upstream teams (e.g. Engineering, Product Design and Security) to obtain inputs, drive decisions, and solicit feedback used to develop, refine, and finalize business architecture deliverables by creating interactive BI Reporting Solutions. Director of Technical Operations/Business Analyst 10/2014 to 05/2016 Knoa Software Responsible for end-to-end client management in North America and EMEA: Establish business requirements by performing data gap analysis, perform POC implementations and recommend technical solutions, oversee all technical implementations and support of BI tools using SQL and Tableau with AWS as backend. Secured most challenging clients under sanctions and political restrictions while increasing sales in trusted regions by 60%.

Senior Analyst/Project Manager 09/2012 to 06/2014 Unirgy Software Managed all clients technical, pre-sales, sales and support activities while overseeing all phases of SDLC Magento extensions development. 98% client signup rate with 84% retention. Technical Project Manager 12/2011 to 06/2012 Bank of America Managed key projects to automate and coordinate Ecommerce Production Support issues across multiple platforms, systems, countries.

Additional Experience:

Senior Data Analyst 02/2010 to 12/2011 BEERS

Lead Production DBA 02/2008 to 02/2009 HBO

Senior Database Administrator 07/2006 to 12/2007 The Golden Source Senior Database and System Administrator 08/2005 to 07/2006 EPANA Senior Database Administrator 04/2002 to 08/2005 ICT Group Senior Database Administrator/ Architect 05/2001 to 04/2002 MEDWERKS.COM Senior Database Administrator 01/1999 to 05/2001 Bernard L. Madoff Investment Securities New York, NY

Database Administrator 01/1997 to 01/1999 CITIBANK Database Administrator 04/1996 to 01/1997 ASTEA INTERNATIONAL PHILADELPHIA, PA Oracle Developer 03/1994 to 01/1996 NORTHEAST SAFEGARD DISTRIBUTORS, PHILADELPHIA, PA

Office Management 04/1990 to 04/1994 ATLAS MEDICAL, PHILADELPHIA, PA Education:

● Development and Administration of Birst BI - 2017

● Google Analytics Introduction and best of practice - 2018

● Big Query Introduction and Development- 2018

Certifications:

● Project Management PMP/CAMP ITIL

● Oracle Database Administration and Architecture

● Unix System Administration

● Google Analytics

Contact this candidate