PostgreSQL
Paulius Jankus
Data Engineer
Salem,MA
Summary
Skilled business solutions technology professional offering in-depth understanding of securing and leveraging data resources. Accomplished in building brand new systems that meet complex business requirements. Expertise includes ETL and SQL.
Overview
9
9
years of professional experience
Work History
Data Engineer
General Motors, GM
Detroit, MI
04.2019 - Current
- Supporting Performance Driven Marketing department of General Motors in automating flow of digital advertising data using Microsoft SSIS, Amazon S3, Hadoop, Spark, Hive, Python, Teradata, and Adobe Analytics APIs.
- Gathered, transformed, and ingested quarterly advertising metric data from 25 sources, allowing visualization team to create dashboard for Chief Marketing Officer
- Developed and implemented quality assurance processes and error handling to legacy ETL processes.
- Migrated 6 TB database from Teradata to PostgreSQL, translating all ETL jobs from SSIS to Python
ETL Developer
Carat
Detroit, MI
10.2017 - 03.2019
- Automated weekly database load process using APIs, Python, Microsoft SQL Server Integration Services, and Microsoft SQL Server, resulting in time savings of 12 hours per week
- Assisted in daily database maintenance (>100 TB) for General Motors global advertising data (EMEA, APAC, US, Canada, South America)
- Led training of co-workers in ArcGIS mapping software, creating new ways to visualize data, and optimizing work process flow
- Led project with Australian office to automate transfer of data between Amazon Redshift and Google BigQuery for dashboard reporting purposes
- Created and maintained Tableau dashboards for production reporting use
Interchange Pricing Analyst
North American Bancard
Troy, MI
06.2016 - 09.2017
- Researched root causes and proposed solutions to interchange pricing discrepancies and anomalies, resulting in $100k in annual savings
- Assisted in auditing and documenting platform conversion process for 10,000 existing merchants
- Utilized SQL and ETL to develop automated reports and dashboards
Statement Analyst
North American Bancard
Troy, MI
2012.06 - 2016.05
- Analyzed and optimized pricing for over 10,000 monthly credit card statements using Microsoft Excel, assisting in the boarding of 1,000 new merchants
- Provided daily customer service to outside sales agents, corresponding via phone and/or e-mail
- Maintained an average analysis turnaround time of 24-48 business hours since date of hire
- Assisted in the re-design and simplification of analysis presentation in Microsoft Excel, allowing for smoother communication between the sales agent and the potential merchant
- Automated parts of the analysis process using Excel VBA, reducing process time by over 75%
Education
Bachelor of Science - Information Technology
Walsh College of Accountancy And Business Administration
Troy, MI 06.2015 - 06.2018
Skills
Self-Motivated
Analytical and Critical Thinking
Problem-Solving
Active Listening
Software
Git
Python
SQL Server
Azure
API
SSIS
Hadoop
Timeline
Data Engineer
General Motors, GM
04.2019 - Current
ETL Developer
Carat
10.2017 - 03.2019
Interchange Pricing Analyst
North American Bancard
06.2016 - 09.2017
Bachelor of Science - Information Technology
Walsh College of Accountancy And Business Administration
06.2015 - 06.2018
Statement Analyst
North American Bancard
2012.06 - 2016.05