Technical notes—————CV—————Books & Readings


Pavel Slepiankou

As a cross-functional software engineer, I'm deeply passionate about data engineering and analysis, as I believe that data is the most valuable asset of any modern company. Skilled in data engineering, cloud computing, data warehousing and general software engineering. Solve business problems with code, low-code, no-code, and common sense. I can work closely with users and stakeholders to understand business needs, collect and analyze requirements, design solutions, develop them from the very beginning to the ultimate conclusion, deploy them in production, and ensure their adoption accross user base. Proficient with several programming languages, especially with Python and JavaScript.

▸ Krakow, Poland. Available for B2B contract on EDG
▸ pavel.slepenkov@gmail.com | +48-571-087-630
▸ github.com/pavel-slepenkov | 0x4ad.com
▸ stackoverflow.com/users/798335
▸ linkedin.com/in/pavel-slepiankou
WORK EXPERIENCE
Apptio - www.apptio.com
Apptio is a software company that develops technology business management (TBM) applications. It helps customers optimize their IT budgeting, forecasting and financial analyses. It is based in Bellevue, Washington, has over 1,300 employees and serves more than 1000 customers worldwide.

Feb 2021 - Present (Senior Data Engineer)

  • Building Snowflake data warehouse with data vault model from scratch
  • Building ETL/ELT pipelines with Python and AWS
  • Building tooling for data science team
  • Work on simple data science tasks like running and minor tuning forecasting models
  • Migrate MSSQL and AWS Redshift datawarehouses into Snowflake
  • Migrate legacy ETL/ELT system (Luigi clone) to Airflow
  • Automate code deployment, testing
  • Developed complext data migrations with T-SQL & DBAmp using graph abilities of MSSQL databases
Targetprocess - www.targetprocess.com
Targetprocess is a software company that develops a visual platform for enterprise agile management. It helps customers plan, track and prioritize work from the strategic portfolio of projects and products to the software delivery team

Nov 2016 - Feb 2021 (Data Software Engineer → BI & Data Lead)

  • Developed ETL pipelines and datawarehouses: data ingestion from different sources (GA, FB, LiveChat, Outreach, Salesforce, MSSQL, Postgres, Redis) via API with Python, cleanup and transformation for further data analysis, with final destination in AWS Redshift/S3. Processing data with AWS Glue for analysis in Athena
  • Ongoing development and support of SaaS application telemetry system: processing stream of telemetry data, storing it in temporary storages, cleaning up and further processing with python with final destination in datawarehouse
  • Developed Quote-to-Cash application which saves ~$80k/year for a company
  • Built new derivative metrics based on gathered data in order to improve analysis
  • Developed a predictive lead scoring model for incoming lead prioritisation which resulted in huge reduce in manual SDRs and AEs work
  • Built reports in Tableau for C-level management and external auditors
  • Involved as data analyst in due diligence during company acquisition event
  • Interviewed people for data analyst/engineer position
Epam Systems - www.epam.com
Epam Systems is a company that specializes in software engineering services, digital platform engineering and digital product design. It is based in Newtown, Pennsylvania and has over 43,000 employees worldwide.

Sept 2011 - Nov 2016 (SWE → Senior SWE → Lead SWE)

  • I successfully completed over ten projects for Epam's customers including Fortune 100 companies.
  • Managed team of 5 developers on migration Visualforce community cloud application to Lightning components framework
  • Developed financial applications with a complex credit scoring algorithms and wide set of integration via REST & SOAP API to 3rd party credit scoring systems
  • Performed a security audits and code reviews for parallel projects
  • I was a trainer in Salesforce developer's Labs and a leader of local Salesforce developers community
  • Organizator and speaker of developers meetups
  • Interviewed people for SWE/Senior SWE positions
BelWillesden (IT Dept of retail chain)

Nov 2009 - Sept 2011 (Lotus Domino Developer)

  • Developed document management app in part of financial statistics and budgeting modules.
  • Developed internal Help Desk: tickets, team allocation, statistic module
KEY SKILLS
  • Python: pandas, matplotlib, seaborn, django, asyncio, funcy
  • Advanced Analytical SQL
  • AWS: EC2, S3, Athena, Glue, Lambda, IAM and security
  • Databases: Snowflake, AWS Redshift, AWS RDS, Postgres, MSSQL, NoSQL
  • Message Queues: Celery+Redis, Kafka
  • JavaScript: Nodejs, ES6, React, Lightning Framework, AngularJS
  • ETL/ELT Tools
    • Apache Airflow, Luigi, dbt
    • In-house built ETL frameworks
    • Fivetran, StitchData, Pentaho
  • Tableau and JupiterLab
  • DevOps & CI/CD Pipelines: Docker, Jenkins, TeamCity, Ansible, Bash, GH Actions
  • Fullstack Salesforce developer: Apex, VisualForce, Lightning, Salesforce APIs, Managed packages development
  • Aware of modern HTML/CSS
  • Software testing: unit and integration testing, UI testing with Selenium
  • Full range of modern developer tooling
  • Have wide experience in Agile methodologies
Education & Certification
  • 7 semesters of software engineering specialization at Belarusian National Technical University
  • Certified Force.com Developer (Winter'13)
  • Salesforce.com Certified Administrator (Spring'13)
❖ 2023, Krakow, Poland. available for B2B contract on EDG ❖