⚓ Jonas Pranckevicius Email & Phone Number

New York, United States

• Designing and delivering orchestration, modeling, security, and strategy to enable elastic cloud data warehousing
• Deploying Snowflake to Fortune 500 accounts
• Looker BI strategy, implementation and training

New York, NY, US

• Fully built out and maintain company’s first data warehouse and BI infrastructure (AWS/Looker).
• Designed and developed all data integrations between fulfillment/inventory and ordering systems.

New York, New York, US

• Developed data pipeline features (Python) as part of bigger project to consolidate advisory fees.
• Supported data warehouse ecosystem in AWS RDS (MySQL and Postgres).

New York, NY, US

• Directly managing a team of 3 engineers (recruited myself).
• Develop and manage extensive royalty reporting data product.
• Oversee our transition to hadoop-based environment.
• Architected, implemented and maintaining MSSQL data warehouse cluster.
• Utilized partitions and other advanced SQL Server techniques to handle multi billion row tables.
• Developed various ETL packages using SSIS and Python to load into MSSQL DWH.

NEW YORK, NY, US

• Directly managed a team of 5 engineers.
• Managed entire cloud infrastructure of over 150 Amazon EC2 instances running Windows/MSSQL.
• Architected and implemented SQL replication topology to load balance data distribution and make it more resilient to outages (7 publishers with over 100 subscribers).
• Designed, implemented and deployed data related ETL, data acquisition, cleansing, validation, data replication and data processes and procedures.
• Re-designed data marts to be more efficient with Microstrategy based BI tools.
• Revamped monitoring of the infrastructure (custom SQL monitoring, Nagios, etc.).

• Built websites for the food, hospitality and law industries, consisting of e-commerce capabilities, backend ETL processes, password protected pages, MySQL/PHP reporting and logins, utilizing HTML, CSS, and JavaScript
• Redesigned doriegreenspan.com, the blog of award winning cookbook author Dorie Greenspan to support advertising and integrate social media. Named a Top 50 Food Blog by the London Times.
• Other blogs include: kristinekidd.com, rickrodgers.com and goddessofbakedom.com (Sarabeth Levine)

New York, NY, US

• Oversee and troubleshoot underlying data procedures of core revenue generating system.
• Recouped $3 million in revenue, along with preventing future issues by executing vast improvements in data flows.
• Design and develop automated financial data ETL system to replace manual processes utilizing SQL server and 50 SSIS packages that load and massage data from various sources, third parties, and formats, in order to.
• Manage replication system to the data warehouse, monitoring server resources and planning hardware replacement or upgrades with 24/7 on call support.
• Overhaul old reporting system to create a more central, standardized system accessible for internal Excel reporting as well as complex partner reporting with custom rules and formats.
• Provided operations support and revenue assurance with detailed information based on queries and performed corresponding database, messaging and subscription adjustments.

New York, NY, US

• Oversee and troubleshoot underlying data procedures of core revenue generating system. Includes: - user flows, billing, and performing backend SQL development and correcting queries; - recouping $3 million in revenue.
• Provided operations support and revenue assurance with detailed information based on queries and performed corresponding database, messaging and subscription adjustments.
• Discovered a serious issue related to an existing re-index utility that caused tables to be skipped, resulting in 40% improvement in query response due to removing an outdated index hint.

New York, NY, US

• Designed and developed internal applications to automate database change processes, security requirements and daily administrative tasks; write custom scripts to automate database administration operations.
• Developed, tested and maintained new invoice validation system.
• Redesigned core stored procedures and functions utilizing industry standard T-SQL techniques resulting in a 50% increase in query response time.
• Developed data warehouse system as proof of concept; including data warehouse modeling, full cycle ETL processes using SQL Server Integration Services (SSIS) and OLAP cube implementation using Business Intelligence.
• Built custom reports to monitor and report daily operations using SQL Server Reporting Services.
• Responsible for SQL server access control and planning that complies with SOX guidelines and passes SAS70 audit.