Aldo ANGULO

Portland, OR

adtbvv@r.postjobfree.com

+1-971-***-****

Dedicated and Seasoned big data professional with skill in implementing and improving big data ecosystems using Hadoop, Spark, Microsoft Azure, Amazon AWS, Cloudera, Hortonworks, MapR, Anaconda, Jupyter Notebooks, and Elastic Search. Proficient in ETL and data pipeline methods and tools.

• 8 years of experience in the field of data analytics, data processing and database technologies

• 5 years of experience with the Hadoop ecosystem and Big Data tools and frameworks

• Ability to troubleshoot and tune relevant programming languages like SQL, Java, Python, Scala, PIG, Hive, RDDs, DataFrames & MapReduce.

• Able to design elegant solutions through the use of problem statements.

• Accustomed to working with large complex data sets, real-time/near real-time analytics, and distributed big data platforms.

• Proficient in major vendor Hadoop distribution like Cloudera, Hortonworks, and MapR.

• Creation of UDF functions in Python or Scala.

• Data Governance, Security & Operations experience.

• Deep knowledge in incremental imports, partitioning and bucketing concepts in Hive and Spark SQL needed for optimization

• Experience collecting log data from various sources and integrating it into HDFS using Flume; staging data in HDFS for further analysis.

• Experience collecting real-time log data from different sources like webserver logs and social media data from Facebook and Twitter using Flume, and storing in HDFS for further analysis.

• Experience deploying large multiple nodes of a Hadoop and Spark cluster.

• Experience developing custom large-scale enterprise applications using Spark for data processing.

• Experience developing Oozie workflows for scheduling and orchestrating the ETL process

• Excellent knowledge on Hadoop Architecture and ecosystems such as HDFS, configuration of nodes, YARN, MapReduce, Sentry, Spark, Falcon, Hbase, Hive, Pig, Sentry, Ranger.

• Developed Scripts and automated end-end data management and sync between all the clusters.

• Strong hands on experience in Hadoop Framework and its ecosystem including but not limited to HDFS Architecture, MapReduce Programming, Hive, Pig, Sqoop, HBase, MongoDB, Cassandra, Oozie, Spark RDDs, Spark DataFrames, Spark Datasets, Spark MLlib, etc.

• Involved in building a multi-tenant cluster, with disaster management with Hadoop cluster

• Experience in Mainframe data and batch migration to Hadoop.

• Hands on experience in installing, configuring Cloudera's and Horton distribution.

• Extending Hive and Pig core functionality by writing custom UDFs.

• Extensively used Apache Flume to collect logs and error messages across the cluster. Willing to relocate: Anywhere

Authorized to work in the US for any employer

Work Experience

Sr. Big Data Engineer

Present Siemens - Portland, OR

July 2021 to July 2021

Current project is a migration of a marketing automation and customer engagement platform from On Prem environment to the cloud. The tools that were used before the migration are Oracle OBIEE, Eloqua and Salesforce. They are being replaced with Braze, Segment and a collection of In-house built applications in the cloud using AWS and Snowflake. The main challenge of the project was to reduce licensing costs of multiple systems by creating a unified platform with a centralized expense account and with the advantages of the cloud. The project consisted in a Data migration mainly from Oracle Exadata server to Snowflake in the Cloud. I created a series of Replication Tasks using the Database Migration Service of AWS in order to transfer millions of records from Oracle on prem database to a RDS cluster running PostgreSql.

I created a series of jobs in AWS glue that transfers the data from different types of sources and to multiple destinations like RDS, DynamoDb, Oracle on prem databases and S3 buckets. The jobs are coded in pyspark and they read the records in PostgreSQL tables and write the data in json format in S3, that way they can be referenced in Snowflake by storage integration. I implemented a state machine (Lambda Step Functions) in order to orchestrate the execution of the previously mentioned tasks and jobs, so the data can be re-loaded on demand or in a schedule. I created a collection of rules in AWS Event Bridge to schedule the execution of the state machines daily and weekly, depending on how big the data is and how often the data needs to be refreshed. I created a series of Lambda functions to execute SQL statements in the databases, as well as to query and scan items in DynamoDb tables.

I created APIs to invoke those lambda functions in API GATEWAY developing what I call an “API factory” using the CDK framework with python.

I created a variety of objects in Snowflake that helped to import data residing in AWS S3 into Snowflake warehouses. The object types included Stage files, storage integrations, internal and external tables, snowpipes and file formats.

I configured S3 Bucket Event Notifications with SQS to alert the Snowpipes when a new object is created under an S3 preffix

Every aws resource was created using AWS Cloudformation templates in YAML, that helped to deploy the same resources in different AWS accounts. One account per environment. The work methodologies followed during the project were Scrum and Agile using Jira to assign user stories to each developer. Backlog refinement, Sprint planning, Sprint retrospective, periodical demos and work updates during daily stand-up meetings are some of the Agile ceremonies in which I participated during my stay in the project. CICD implemented with Git and Atlassian Bitbucket pipelines. Sr. Big Data Engineer

Capital One Financial Services - McLean, VA

October 2018 to October 2018

Active participant of two big data projects:

Credit Batch Processing

Credit Policies

Credit Batch Processing

I was part of the team in charge of developing a batch processing tool that reconciles every credit card transaction with VISA and Mastercard companies. The application processes 5 files provided in CSV, Parquet, Avro and JSON formats. The size of these files is tenths of gigabytes and all of them are provided in S3 buckets. The application processes the files using Spark SQL in an EMR cluster of 3 nodes of 8 cores each. After joining and transforming them, the application delivers a 20 GB file to VISA and Mastercard via SFTP containing details of accounts having made any transaction on a given day, each day. The log files are monitored using Splunk. We present stats about the daily execution of the app in dashboards and charts in Splunk. Also, it triggers alerts onboarded with PagerDuty that notify team members by e-mail, SMS and phone automatically if intervention is needed during or after the execution. The execution of this app is generating a revenue to the bank of 10 million dollars per year. Credit Policies

I am a developer in one of the multiple teams that develop credit policies. A credit policy in Capital One is a set of rules that determines if a credit card application is accepted or rejected. Data is collected in an online application form and Rules Engine, java-coded web service processes and evaluates the information collected according to the product selected by the applicant. My team is in charge of coding policies for 4 upmarket Capital One Credit Card products: The product owners write the rules in a Confluence page called ‘Intent’ which contains all the features and variables that need to be extracted from the application and the flow in which the rules need to be evaluated by the rules engine. As a result of the evaluation, some things like the amount of the assigned credit line and the APR for the customer will be determined.

The rules engine uses a second web service that returns fico scores from Equifax, Transunion and Experian credit bureaus for factoring into the determination. I write the rules in a Business Rules Management System (BRMS) called drools.

Every rule is tested in a local environment using Cucumber. Every policy requested to the team is developed by 3 engineers using a branch in Git, which is merged and submitted to Jenkins CI for QA testing using a web interface to match an existing product with the recently developed policy. All the rulesets are coded in drools, however, their relationship with a policy and a product is stored in a PostgreSQL relational database. That way the rules engine can decide what rules need to be evaluated when applying for a product. We also write the SQL scripts with DML statements to match a product with its rules.

· The project was divided in two main parts:

1) Files Provisioning (java program in an ECS cluster) 2) Files Processing (Scala program in an EMR cluster)

· Files Provisioning: The ECS cluster on Linux Red Hat, transfers files from different Amazon S3 storage. Coding is in Java using AWS API.

· Files Processing: Scala program in EMR cluster coded in Scala 2.11.0, implementing Spark 2.4, resulting in an average execution time is between 20 to 30 minutes.

· Participated in reinforcing the security of AWS services in order to maintain the security policy and to update the latest stable version of implementing technologies.

· Created drools files with business rules to approve Credit Lines

· Write and created output log files monitored by Splunk

· Modified schema classes to match format of a Json object provided by an API

· Read avro files from S3 and generate a Dataframe with Spark using scala

· Worked with cluster management in AWS to ensure all data infrastructure to be replicated in East and West regions in AWS. High availability ensured through an activity that switched regions every 3 months in case of failure.

· Agile methodology followed with daily standups, and use of Jira.

· Blueprinted an infrastructure built in Terraform scripts, to maintain independence from AWS as cloud service provider.

· Tests are programmed using Cucumber for Acceptance Test-Driven-Development

(ATDD) quality process.

· Deployed manually with terraform commands and used Jenkins for automated deployment.

· Documented and managed the project using JFrog and Atlassian Confluence.

· Optimized Spark job significantly by proposing new file format, Avro, in a Spark process of joining multiple Data Frames in the program.

· Internal security provided by SPHINX.

Environment: Amazon Web Services (AWS)

Technologies: AWS EC2, EMR, Terraform, Scala, Hadoop, Spark SQL, Splunk, PagerDuty, Jira, Drools, Cucumber

Hadoop Data Architect/Engineer

Comcast Xfinity - Philadelphia, PA

May 2016 to May 2016

Involved in testing X1 products by gathering data from Comcast X1 Xfinity DVRs, which are used for search and play multimedia content for every subscriber. In exchange, Comcast gets an enormous amount of data - with the idea being that the data can be used to offer the most appropriate content for the user according to their likes and their experience of the platform. For example, selected menu options on the DVRs tell Comcast about utilization, type of content, and geographical variants.

· Involved in creating Hive Tables, loading with data and writing Hive queries, which will invoke and run TEZ jobs in the backend.

· Experience in optimizing the data storage in Hive using partitioning and bucketing mechanisms on both the managed and external tables.

· Worked on importing and exporting data using Sqoop between HDFS to RDBMS.

· Collect, aggregate, and move data from servers to HDFS using Apache Spark & Spark Streaming.

· Administered Hadoop cluster(CDH) and reviewed log files of all daemons.

· Used Impala where possible to achieve faster results compared to Hive during data Analysis.

· Used Spark API over Hadoop YARN to perform analytics on data in Hive.

· Used Spark SQL and DataFrames API to load structured and semi structured data into Spark Clusters.

· Migrated complex MapReduce programs into Apache Spark RDD operations.

· Migrated ETL jobs to Pig scripts for transformations, joins, aggregations before HDFS.

· Implemented data ingestion and cluster handling in real time processing using Kafka.

· Implemented workflows using Apache Oozie framework to automate tasks.

· Performed both major and minor upgrades to the existing Cloudera Hadoop cluster.

· Implemented High Availability of Name Node, Resource manager on the Hadoop Cluster.

· Integrated Hadoop with Active Directory and enabled Kerberos for Authentication.

· Created Hive external tables and designed data models in hive.

· Involved in the process of designing Cassandra Architecture including data modeling.

· Implemented YARN Resource pools to share resources of cluster for YARN jobs submitted by users.

· Performed storage capacity management, performance tuning and benchmarking of clusters.

· Performance tuning of HIVE service for better Query performance on ad-hoc queries.

· Performed performance tuning for Spark Steaming e.g. setting right Batch Interval time, correct level of Parallelism, selection of correct Serialization & memory tuning.

· Data ingestion is done using Flume with source as Kafka Source & sink as HDFS.

· For one of the use case, used Spark Streaming with Kafka & HDFS & Cassandra to build a continuous ETL pipeline. This is used for real time analytics performed on the data.

· Performed import and export of dataset transfer between traditional databases and HDFS using Sqoop.

· Worked on disaster management with Hadoop cluster.

· Designed and presented a POC on introducing Impala in project architecture.

· Configured Spark streaming to receive real time data from Kafka and store the stream data to HDFS. Environment: HDFS, PIG, Hive, Sqoop, Oozie, HBase, Zoo keeper, Cloudera Manager, java, Ambari, Oracle, MYSQL, Cassandra, Sentry, Falcon, Spark, YARN, MapReduce Hadoop Data Architect/Engineer

City of Long Beach - Long Beach, CA

May 2015 to May 2015

The city of Long Beach, California is using smart water meters to detect illegal watering in real time and have been used to help some homeowners cut their water usage by as much as 80 percent. That's vital when the state is going through its worst drought in recorded history and the governor has enacted the first-ever state-wide water restrictions.

· Analyzed Hadoop cluster using big data analytic tools including Kafka, Pig, Hive, Spark, MapReduce.

· Configured Spark streaming to receive real time data from Kafka and store to HDFS using Scale.

· Implemented Spark using Scala and Spark SQL for faster analyzing and processing of data.

· Built continuous Spark streaming ETL pipeline with Spark, Kafka, Scala, HDFS and MongoDB.

· Import/export data into HDFS and Hive using Sqoop and Kafka.

· Involved in creating Hive tables, loading the data and writing hive queries.

· Design and develop ETL workflows using Python and Scala for processing data in HDFS & MongoDB.

· Worked on importing the unstructured data into the HDFS using Spark Streaming & Kafka.

· Wrote complex Hive queries, Spark SQL queries and UDFs.

· Wrote shell scripts to execute scripts (Pig, Hive, and MapReduce) and move the data files to/from HDFS.

· Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs, Python and Scala.

· Worked with Amazon Web Services (AWS) and involved in ETL, Data Integration and Migration.

· Handled 20 TB of data volume with 120-node cluster in Production environment.

· Loading data from diff servers to AWS S3 bucket and setting appropriate bucket permissions.

· Apache Kafka to transform live streaming with the batch processing to generate reports

· Cassandra data modeling for storing and transformation in spark using Datastax connector.

· Imported data into HDFS and Hive using Sqoop and Kafka. Created Kafka topics and distributed to different consumer applications.

· Worked on Spark SQL and DataFrames for faster execution of Hive queries using Spark and AWS EMR

· Implemented Partitioning, Dynamic Partitions and Buckets in HIVE for increasing performance benefit and helping in organizing data in a logical fashion.

· Scheduled and executed workflows in Oozie to run Hive and Pig jobs

· Worked with Spark Context, Spark -SQL, DataFrame and Pair RDDs.

· Used Hive, spark SQL Connection to generate Tableau BI reports.

· Created Partitions, Buckets based on State to further process using Bucket based Hive joins.

· Created Hive Generic UDF's to process business logic that varies based on policy.

· Developed various data connections from data sourced to SSIS, and Tableau Server for report and dashboard development.

· Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.

· Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data. Environment: Hadoop, HDFS, Hive, Spark, YARN, MapReduce, Kafka, Pig, MongoDB, Sqoop, Storm, Cloudera, Impala

Hadoop Data Engineer

Gulfstream - Savannah, GA

January 2014 to January 2014

Offloading Oracle or Teradata Data Warehouses to Hadoop Data Lakes for better scaling, more analytics and cost savings. Created multi-node Hadoop and Spark clusters in AWS instances to generate terabytes of data and stored it in AWS HDFS.

· Deployed the application jar files into AWS instances.

· Used the image files of an instance to create instances containing Hadoop installed and running.

· Developed a task execution framework on EC2 instances using SQL and DynamoDB.

· Designed a cost-effective archival platform for storing big data using Hadoop and its related technologies.

· Connected various data centers and transferred data between them using Sqoop and various ETL tools.

· Extracted the data from RDBMS (Oracle, MySQL) to HDFS using Sqoop.

· Used the Hive JDBC to verify the data stored in the Hadoop cluster.

· Worked with the client to reduce churn rate, read and translate data from social media websites.

· Integrated Kafka with Spark Streaming for real time data processing

· Imported data from disparate sources into Spark RDD for processing.

· Built a prototype for real-time analysis using Spark streaming and Kafka.

· Transferred data using Informatica tool from AWS S3.

· Using AWS Redshift for storing the data on cloud.

· Collected the business requirements from the subject matter experts like data scientists and business partners.

· Involved in Design and Development of technical specifications using Hadoop technologies.

· Load and transform large sets of structured, semi structured and unstructured data.

· Used different file formats like Text files, Sequence Files, Avro.

· Loaded data from various data sources into HDFS using Kafka.

· Tuning and operating Spark and its related technologies like Spark SQL and Streaming.

· Used shell scripts to dump the data from MySQL to HDFS.

· Used NoSQL databases like MongoDB in implementation and integration.

· Worked on streaming the analyzed data to Hive Tables using Sqoop for making it available for visualization and report generation by the BI team.

· Configured Oozie workflow engine scheduler to run multiple Hive, Sqoop and pig jobs.

· Consumed the data from Kafka queue using Storm

· Used Oozie to automate/schedule business workflows which invoke Sqoop, MapReduce and Pig jobs as per the requirements.

Environment: Hadoop, Spark, HDF, Oozie, Sqoop, MongoDB, Hive, Pig, Storm, Kafka, MapReduce, SQL, Acro, RDD. SQS S3, Cloud, MySQL, Informatica, Dynamo DB Hadoop Data Engineer

Alibaba - Remote

August 2012 to August 2012

Involved in building our Data Warehousing solutions for banking industry, pulling data from various sources and file formats.

· Worked with several clients with day to day requests and responsibilities.

· Involved in analyzing system failures, identifying root causes and recommended course of actions.

· Worked on Hive for exposing data for further analysis and for generating transforming files from different analytical formats to text files.

· Wrote the shell scripts to monitor the health check of Apache Tomcat and JBOS; daemon services and respond accordingly to any warning or failure conditions.

· Utilized Java and MySQL from day to day to debug and fix issues with client processes.

· Developed, tested, and implemented financial-services application to bring multiple clients into standard database format.

· Assisted in designing, building, and maintaining database to analyze life cycle of checking and debit transactions.

· Excellent JAVA, J2EE application development skills with strong experience in Object Oriented Analysis, extensively involved throughout Software Development Life Cycle (SDLC).

· Strong experience of software and system development using JSP, Servlet, Java Server Face, EJB, JDBC, JNDI, Struts, Maven, Git, JUnit, SQL language.

· Rich experience of database design and hands-on experience of large database systems: Oracle 8i and Oracle 9i, DB2, PL, SQL.

· Hands-on experience of Sun One Application Server, Web logic Application Server, Web Sphere Application Server, Web Sphere Portal Server, and J2EE application deployment technology. Environment: Java, JDBC, JNDI, Struts, Maven, Subversion, JUnit, SQL language, spring, Hibernate, JUnit, Oracle, XML, Putty and Eclipse.

Hadoop Big Data Administrator

Blue Cross Blue Shield of North Carolina - Charlotte, NC January 2012 to January 2012

Responsible for administration of big data system using Hadoop on premises including data loss prevention policies, optimization, backup and restore of databases and management of Hadoop clusters on servers.

· Administered Hadoop cluster(CDM) and reviewed log files of all daemons.

· Involved in scheduling Oozie workflow engine to run multiple Hive, Sqoop and Pig jobs.

· Implemented workflows using Apache Oozie framework to automate tasks.

· Used Zookeeper for various types of centralized configurations, GIT for version control, and Maven as a build tool for deploying the code.

· Involved in scheduling Oozie workflow engine to run multiple HiveQL, Sqoop and Pig jobs.

· Developed workflow in Oozie to automate the tasks of loading data into HDFS and pre-processing with Pig and Hive.

· Configured Fair Scheduler to allocate resources to all the applications across the cluster.

· Performed maintenance, monitoring, deployments, and upgrades across infrastructure that supports all Hadoop clusters.

· Used Zookeeper and Oozie for coordinating the cluster and scheduling workflows.

· Managed jobs using Fair Scheduler to allocate processing resources.

· Developed job processing scripts using Oozie workflow to run multiple Spark Jobs in sequence for processing data

· Configured Zookeeper to coordinate the servers in clusters to maintain the data consistency and to monitor services.

· Automated all the jobs for pulling data from FTP server to load data into Hive tables, using Oozie workflows.

· Used Oozie workflows and coordinators for integrating MapReduce workflow- including Java REST service consumption and MongoDb/Neo4j ingress, and scheduling the data flow pipeline. Systems Administrator

Jan 2012 GRUPO - SALINAS, Mexico

September 2011 to September 2011

Optimized the performance of the database (DB2) of credit and collection of Elektra stores by tuning queries, creating user groups and assigning permissions and authority to them. I managed the backups and recoveries of programs and objects in the database. I automated the collection of statistics

Power server performance through programs encoded in ILE-RPG and stored procedures in DB2 for i. I was a member of the Circle of Excellence of the systems management. Programmer

Devant IT - Mexico

May 2010 to May 2010

Developed functions, stored procedures in Transact-SQL and triggers for SQL Server 2008. I participated in the development of the system of maintenance logs to Federal Police aircraft using Java with Hibernate, Spring and ZK frameworks. Education

Degree Diploma of Administration in Computer Engineering NATIONAL AUTONOMOUS UNIVERSITY OF MEXICO

Skills

• Programming Languages & IDEs

Unix shell scripting

• Object-oriented design

• Object-oriented programming

• Functional programming

• SQL

• Java

• Hive QL

• MapReduce

• Python

• Scala

• XML

• Blueprint XML

• Ajax

• REST API

• Spark API

• JSON

• Avro

• Parquet

• ORC

• Jupyter

Notebooks

• Eclipse

• IntelliJ

• PyCharm

DATA & FILE MANAGEMENT

Apache Cassandra

• Apache Hbase

• MapR-DB

• MongoDB

• Oracle

• SQL Server

• DB2

• Sybase

• RDBMS

• MapReduce

• HDFS

• Parquet

• Avro

• JSON

• Snappy

• Gzip

• DAS

• NAS

• SAN

• PostgreSQL

• MySQL

• MemSQL

• OLTP.

Methodologies

Agile

• Kanban

• Scrum

• DevOps

• Continuous Integration

• Test-Driven Development

• Unit Testing

• Functional Testing

• Design Thinking

• Lean

• Six Sigma

Cloud Services & Distributions

AWS

• Azure

• Anaconda Cloud

• Elasticsearch

• Solr

• Lucene

• Cloudera

• Databricks

• Hortonworks

• Elastic MapReduce

Big Data Platforms

• Software

• & Tools

Apache Ant

• Apache Cassandra

• Apache Flume

• Apache Hadoop

• Apache Hadoop YARN

• Apache Hbase

• Apache Hcatalog

• Apache Hive

• Apache Kafka

• Apache MAVEN

• Apache

Oozie

• Apache Pig

• Apache Spark

• Spark Streaming

• Spark MLlib

• GraphX

• SciPy

• Pandas

• RDDs

• DataFrames

• Datasets

• Mesos

• Apache Tez

• Apache ZooKeeper

• Cloudera

Impala

• HDFS

• Hortonworks

• MapR

• MapReduce

• Apache Airflow and Camel

• Apache

Lucene

• Elasticsearch

• Elastic Cloud

• Kibana

• X-Pack

• Apache SOLR

• Apache Drill

• Presto

• Apache Hue

• Sqoop

• Kibana

• Tableau

• AWS

• Cloud Foundry

• GitHub

• Bit

Bucket

• Pentaho

• Kettle.

Contact this candidate