Abarajithan Arunachalam

* Toptal Projects - Data modeling, Databricks, Redshift WLM Optimization and Data Analytics KPIs for USA and European clients. * Portfolio Projects - COVID19 and IPL cricket social media analytics data engineering/business intelligence project using Serverless architecture and BigQuery on Google Cloud Platform(GCP). Please refer to my Github page.

* Worked on data infrastructure using serverless framework and architecture on Nodejs. * Developed AWS Lambda functions for posting events to third party API Amplitude for behavioral analytics. * Built AWS Kinesis streaming platform for pushing mobile events into Redshift data warehouse. Developed ERB templates for auto class files generation, terraform for deploying AWS infrastructure components and circleci for CI/CD development.

• Built complex data models and SQL/JINJA template based data pipelines in Amazon Redshift for Product Managers and Analysts. • Worked closely with Analysts for LOOKER reporting and deep dive business analysis.

- Designed and developed legacy Oracle and Amazon Redshift data pipelines for key reporting needs of Product managers. Successfully led and implemented data/ETL migration effort from Oracle to Amazon Redshift for over 100 TB of data.
 - Implemented a sub-second query platform for one of the largest datasets in ElasticSearch and Kibana. Performed Proof Of Concept for next generation Reporting platform including Open Source and AWS offerings.
 - Onboarded long running ETL pipelines onto Hive/EMR platform.

• Worked on optimization of 12 Node - Redshift Clusters for handling over 60 TB data and building toolset around Amazon Redshift. • Performed operational tasks for Python based ETL framework and performed query analysis/review of Business users/analysts and Data Scientists.

• Designed and Developed scalable SPLUNK ETL using Splunk Java SDK and Talend with Amazon Redshift MPP database for processing unstructured web log data.
 • Involved in Cassandra Data Modeling with Product Development team. Developed custom Cassandra ETL using Datastax java drivers for partner reporting. 
 • Implemented data integration packages using Talend and built reports/visualizations in Tableau for User growth, mobile platform, sales and other business teams.

• Developed Product KPI Data Model and Dashboards using OracleDataIntegrator and Business Objects. • Developed a data pipeline using Informatica Cloud, PL/SQL & Microsoft SSAS for Marketing datawarehouse and SalesForce Analytics. Designed and Developed Data Models that provides 360 degree view of a customer to assist in Customer Acquisition and SalesFunnel Analysis. • Developed a custom java based ETL solution to migrate large volumes of data from over 80 POSTGRES databases across 8 data centers.

• Bug Reporting and Triaging. • Full feature, Scenario, Alpha and Beta tests, Regression Tests, installation/un-installation tests. • Built Scalable Keyword driven Automation framework using Borland SilkTest. • Learning Management System (LMS) first point of contact. • Handled the responsibility of resolving customer issues.

• Formulated test plans, test scenarios and test cases based on client requirements. • Achieved 100% automation of test cases in AGILE mode of software development.

Business Intelligence and Analytics (BIA)