Andrew Afable Email & Phone Number

Los Angeles, Ca, Us

Los Angeles, California, Us

•Help build a research-based and data-driven approach to optimize mobile customer engagement using Artificial Intelligence•Focus on deep diving into a broad variety of exploratory initiatives to improve segmentation, tailoring and personalization of mobile engagement. •Work with the Data Analytics and Engineering team to refine and develop data science and analytics product roadmap. •Support Redshift Data Warehouse cluster management including monitoring, performance tuning, and optimization. •Responsible for data loads and data extracts from transactional data in PostgreSQL and Oracle to AWS Redshift via Apache Airflow DAG, AWS DMS and Python code. •Engaging in exploratory A/B studies to extract data features and determine the relative value of multiple data types. •Build rich and interactive data visualizations to display findings from A/B studies, guide and inform exploratory data analysis, to deepen customer engagement. •Understand and apply data mining techniques, including NLP, clustering algorithms and regression analysis to generate deep insight and discover effective solutions to challenging problems. •Use AWS Kinesis and Firehose for streaming data extracts and upload to S3 via dockers and other containers software.•Design and implement robust end-to-end ETL pipelines from multiple database to Redshift •Architect, develop and maintain enterprise AWS Redshift data warehouse using python and Airflow•Create and manage ETL data pipelines from data ingestion of multiple databases like PostgreSQL, SQL, Oracle, streaming data, flat files and various web APIs to data transformation using various AWS tech stack •Integrate data from data warehouse into 3rd party tools to make data actionable•Provide ongoing maintenance and enhancements to the data pipeline•Ensure data quality through automated testing using unit and stress scripts•Collaborate with analysts, engineers, product managers and business users to design and implement solutions

Thousand Oaks, Ca, Us

•Responsible for all Data Related activities like Extraction, Transformation and Loading (ETL) using python and data sources from SQL Servers and PostgreSQL•Design, develop, test, deploy, maintain, and improve backend Java and python programs•Develop data models to meet the needs of the organization's information systems•More than 10 years’ experience with Data Integration tools •Take lead responsibility for the data migration: analysis, design, implementation, testing, validation, and acceptance by all parties.•Responsible for the development of data pipelines on AWS using SQL, JAVA, SSIS and Databricks Spark.•Assemble large, complex data sets that meet functional and analytics business requirements.•Work as DBA to implement relational models and assist in Capacity Planning and performance tuning and release implementation•Work closely with application development team on designing, developing, testing and deploying cloud-based application•Manages the flow of information across various applications and departments using relational databases•Maintains data integrity by working to eliminate redundancy. Stays informed of the ways the organization uses its data.•Interact with Users and SMEs to understand reporting requirements and identify the data sources to fulfill those reporting requirements•Create and maintain documentation for all projects using Confluence

•Create medium to large sized HTML/CSS/JS applications from start to finish. This includes but is not limited to the following: customer interaction, validating requirements, system design, development of complex SQL queries, and interaction with REST/SOAP web services, development builds, application deployments, integration testing, and support of applications within a production environment.•Platform and Skillset expertise: Web Development: HTML, CSS, Java Script Cloud Services: AWS, RDS, S3 Database Development: SQL Server, MySQL, PostgreSQL Integrated Development Environment: Eclipse for Java and PyCharm for Python•Write responsive, front-end code •Rapidly address issues and fix defects discovered during deployment•Evaluating and integrating with third party vendors•Execute best practices on AWS platform and services•Hands-on experience with bug and issue tracking software

Master Of Management Information Systems

Post Baccalaureate, Computer Programming

Bachelor Of Engineering - Be, Civil And Structural Engineering