Data Analyst Engineer

RONNIE SHAHRABANI

Aurora, CO ***** • 720-***-**** • ******.**********@*****.***

LinkedIn: www.linkedin.com/pub/ronnie-shahrabani/8/194/b11/

SENIOR DATA ENGINEER

PROFESSIONAL SUMMARY

Senior Data Engineer with over 25 years of experience working in software and development. Passionate about providing expertise in SQL, PL/SQL Programming and Tuning to improve process efficiencies. Proven ability to assess business trends and requirements, leveraging existing technologies to meet operational needs. Experience defining and developing data warehouse system solutions. Strong analytical thinking skills and in-depth knowledge of handling metadata to use data more accurately.

COMPETENCIES

Sr. Business Intelligence Architect • Database Developer • Lead Architect • Data Analyst

Business Intelligence (BI) • Architecture and Design • Data Warehousing • Project Management

Led Data Governance • Designed Platforms • Analyzed Databases • Executed Reporting

Systems Analyst Certification • OCP Certified • MCP Certified • Microsoft SQL Server Database

WORK EXPERIENCE

Senior Data Engineer Apr 2022 - Mar 2023

Alterra Mountain Company, Location: Colorado USA

●Designed, developed, and implemented multiple projects utilizing:

oSnowflake database.

oMatillion ETL tool.

oAzure containers.

oGitHub.

●Maintained ETL data Pipelines of the Financial Analytics developed in Python on Windows Servers, utilizing Snowflake stored procedures written in JavaScript and SQL.

●Maintained Stored Procedures on Snowflake.

●Administration wise - created Databases, Schemas, Roles, granted permissions Users, and allocated the roles to users on Snowflake.

●Converted ETL pipeline from Stored procedures on Snowflake to Matillion ETL tool.

●Maintain and enhanced the existing Staging and Datamart pipelines to support reporting and process needs.

●Liaised with BI group to identify reporting and metric needs and requirements.

●Participated on regular basis scrum meetings using Jira.

Senior Data Engineer May 2018 - Feb 2022

Lumen, Location: Colorado USA

●Spearheaded database platforms that supported Extract Transform Loads (ETLs), cube environments, reporting platforms, and data governance.

●Designed, developed, and implemented multiple projects utilizing Big Data technologies:

oBig Data technologies - Hadoop HDFS, HIVE (Partitioning, file formats), Cloudera, Impala, HUE, Sqoop, Beeline.

oPDI Pentaho with Linux, MsSql, Oracle 12, Hadoop HDFS, HIVE, Impala, Sqoop, Beeline.

Created, automated and maintained the ETL data Pipeline of the Financial Analytics and Data Scientists group using:

oPySpark / Python, Kedro, Docker-Airflow, GitHub, GitLab, Sourcetree, Microsoft Teams.

●Performed data migration from MsSql server to Hadoop HDFS, Cloudera, HIVE, and Impala.

●Converted ETL pipeline from SSIS to Pentaho on Oracle, SqlServer.

●Converted ETL pipeline from Pentaho to Sqoop on Hadoop HDFS, Oracle, SqlServer.

●Converted ETL pipeline from Sqoop to PySpark / Python and Kedro on Hadoop HDFS, Oracle, Sql Server.

●Analyzed and maintained database and cloud storage environments to support reporting and process needs.

●Generated performance reports on install, change and disconnect orders as well as performer tasks, actions, and revenue reporting.

●Sourced reporting and metrics from multiple order entry, workflow, and inventory systems.

●Liaised with multiple organizations to identify reporting and metric needs and requirements.

●Developed repeatable and intuitive SQL Server reports against organizational, group, and individual contributor performance measures to facilitate process and team improvement.

●Partnered with database analysts to ensure access to data for reporting analytical needs.

Senior ETL Data Warehouse Designer and Developer Feb 2016 - Jan 2018

Travelport, Location: Colorado USA

●Designed, developed, and implemented multiple projects utilizing Big Data technologies.

●Designed, created and fine-tuned the relevant schemas Staging, Warehouse, using:

Informatica with Linux, MsSql, and DB2 with the relevant Stored Procedures.

PDI Pentaho with Linux, MsSql, Oracle, DB2 and Hadoop HDFS, HIVE.

●Defined technical requirements/architectures for the data warehouse and analytics ecosystem with a focus on cost savings, high performance, high reliability, and quality of user experience.

●Coached team members in application of data warehouse and analytics architectural standards.

●Created models for new data warehouse development and/or changes to existing data stores.

●Identified inefficiencies and gaps in current data warehouses and leveraged solutions.

●Designed systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets.

●Planned capacity and resource expansion to ensure data warehouse scalability.

●Identified data discrepancies and worked to ensure data consistency and integrity.

Data Analyst ETL and Database Developer Sep 2013 - Jan 2016

Stoneriver, Location: Colorado USA

●Implemented and maintained Data Warehouse and Business Intelligence applications.

●Analyzed data loaded into data warehouse for accuracy and efficiency.

●Led architecture, development, and execution of ETL processes, requirements, and standards.

●Conducted technical analysis of Business Intelligence and Data Warehousing solutions.

●Recognized as an expert in SQL, PL/SQL Programming, Optimization, and Tuning.

●Enhanced the performance of the Data Warehouse and Data Mart - Dimensions and Facts.

●Improved team’s knowledge base in SQL tuning in Oracle and SQL Server, JavaScript as well as Pentaho Performance, pushing the Pentaho capabilities to the limit.

ETL and Database Developer Oct 2012 - Aug 2013

Epsilon, Location: Colorado USA

●Improved performance and time span of selected framework jobs (i.e., decreasing a major process run time from 6 hours to 1/2 hour), eliminating violating the SLA.

●Practiced ETL architecture, designed, developed, and implemented ETL processes, requirements, and standards for marketing database projects.

●Enhanced processes in Data Mart/Data Warehouse to work more efficiently and gain performance applying merge, parallelism, hints, indexes, cursors with bulk collection.

Software Expert Aug 2009 - Sep 2011

National Business Center/U.S. Department of the Interior, Location: Colorado USA

●Designed reports and maintained software of Federal Financial System on IBM Mainframe.

●Automated reports saving clients thousands of dollars in manual report preparation.

●Provided help with data cleansing, developing queries to gather statistical data for reporting.

●Optimized existing as well as new SQL, PL/SQL programs anonymous blocks and stored procedures to improve/better the efficiency of the processes.

ADDITIONAL RELEVANT EXPERIENCE

Software Expert and Senior Team Leader, AMDOCS Inc., Location: Israel, Australia, USA

Team Leader, Designer and Programmer, Solmal Inc., Location: Israel

EDUCATION

Associate Degree, Computer Software Engineering

Tel Aviv University, College of Engineering, Israel

Data Processing, Systems Analyst Certification

Sivan Computer College, Israel

ORACLE DBA - OCP Certified, Microsoft SQL Server DBA - MCP Certified

Tel Aviv College, Israel

TECHNOLOGIES and CERTIFICATIONS

Programming and Development Tools/Languages: Snowflake database, Matillion, Azure containers, PySpark/Python, Kedro, Docker-Airflow, GitHub, GitLab, Sourcetree, Microsoft Teams, Pentaho and Hadoop Framework Fundamentals, HDFS, HIVE, Cloudera, Impala, HUE, Sqoop, Beeline, Informatica Power Center, PDI - Pentaho Data Integration with JavaScript, on Oracle DB2 and MS SQL Databases, SQL Server Management Studio, PL/SQL Developer, DBeaver, AquaData, DbVisualizer, SSIS with Visual Studio, Oracle SQL Developer, UNIX/Linux Shell Scripting, SQL, PL/SQL, T-SQL, SQLPlus, TOAD, BRIO, SubVersion SVN, JCS, COBOL, DYL, SAS, RPG, FORTRAN, JCL, File-AID/MVS, Quality Center QA testing Tool, WinRunner, Microsoft Office Applications, Microsoft Project, Exceed

Operating Systems: SUN/HP/UNIX, Linux, MS Windows, IBM MVS-OS/390, VAX/VMS, MS-DOS, IBM Mainframe, IBM 34/36/AS400

Databases: ORACLE 6 to 12, SQL Server (MS SQL v 2008/v 2012/v 2014/v 2016), Informix, DB2, Microsoft Access

Certifications: Pentaho and Hadoop Framework Fundamentals - Pentaho Corporation, ETL Training, Data Processing, Systems Analyst Certification - Sivan Computer College, OCP Certified - ORACLE DBA/MCP Certified - Microsoft SQL Server DBA - Tel Aviv College, Windows 2000 Server, Administering Microsoft SQL Server 2000 Database, Microsoft ACCESS, UNIX, IBM-MVS (OS/390)/IBM-AS400/IBM-DB2, WinRunner

Contact this candidate