Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Certification
Work Availability
Timeline
SoftwareEngineer
Arunagiri Ambalavanan

Arunagiri Ambalavanan

Oakley,CA

Summary

Results-driven Technical Lead with 16+ years of experience in Business Intelligence and Data Technology. Adept at optimizing data workflows, translating raw data into actionable insights, and implementing cutting-edge analytics technologies. Customer-focused mindset with a strong ability to understand diverse industry dynamics and deliver tailored solutions. Known for effectively collaborating with stakeholders to drive business success.

Overview

16
16
years of professional experience
1
1
Certification
3
3

Badge

Work History

Tech Lead to Principal Engineer

Altimetrik Corp
04.2013 - Current
  • Successfully migrated data from Salesforce to Snowflake, boosting processing speeds by 70%, cutting costs by 30%, and enabling real-time analytics, leading to a 15% rise in data-driven decisions and enhanced scalability
  • Implemented reusable data pipeline using PowerShell for TDS to automate AD authentication, reducing manual effort
  • Developed insights for Salesforce enablement CRM analytics platform, enabling customers to identify sales team performance and milestones, resulting in improvement in sales productivity
  • Created insights for Salesforce Trailhead Analytics Data platform, providing visibility of available Salesforce domain experts for B2B vendors, which improves vendor collaboration and support
  • Led end-to-end implementation of decisions.com framework, automating workflows and reducing Mean-Time-To-Deploy rate for FIS sales team
  • This results in cost reduction of $350k per year
  • Architected and generated insights about CS agents for PayPal, leading to actionable recommendations that improved click stream performance and resulted in 30% increase in customer contact rate
  • Established CI/CD infrastructure to automate AWS Cloud ETL pipelines for SVB Bank, improving deployment time and overall development efficiency
  • Successfully migrated enterprise data warehouse from on-premises to AWS cloud infrastructure
  • Enhanced CTA report generation performance for Visa Inc., reducing the generation timeline from 2 hours to under 5 minutes
  • Led implementation of analytics algorithms utilizing clustering techniques to identify outliers for PayPal products, enhancing anomaly detection capabilities and optimizing product performance
  • Spearheaded cross-collaboration efforts to implement an AuthN service for the image center product at FIS, effectively reducing security vulnerabilities and providing enhanced security measures for their B2C clients.

DBA

Technosoft Global Services
03.2011 - 04.2013
  • Successfully migrated multiple ETL pipelines, resulting in improved data integration efficiency and decreased data processing time
  • Migrated Informatica 8.x and 9.x client/server on Windows and UNIX platforms, enabling seamless data extraction, transformation, and loading processes
  • Proactively monitored and optimized ETL repository and performance improvements for system
  • Implemented and monitored ETL jobs to ensure optimal server space utilization, and reduced storage costs
  • Managed scheduling for ETL, Dataflux jobs, and Mviews using enterprise scheduler Active Batch, ensuring smooth execution of critical data processes and reduction in job failures
  • Key Accomplishments
  • Migrated legacy data to Snowflake data lake and documented the process
  • Implemented TLS 1.2 to Oracle DB servers and extended to ETL/BI tools
  • Championed advanced data encryption techniques
  • Led ETL integrations compliant with enterprise standards
  • Upgraded Informatica versions and repositories
  • Collaborated for server setups during Informatica's version upgrade
  • Standardized processes with Olympus release management tool integration
  • Automated data archival and addressed dashboard data quality issues
  • Optimized runtimes by identifying operational bottlenecks
  • Transitioned platforms from AIX to Solaris efficiently
  • Roles And Merits
  • Designed advanced Tableau and Power BI dashboards
  • Set up and managed BI servers, integrating data tools effectively
  • Led the implementation and upgrade efforts for Informatica v9 & v10
  • Orchestrated seamless ELT processes using Azure Data Factory
  • Continuously optimized complex database queries to improve performance
  • Established a robust ETL infrastructure, primarily focusing on AWS
  • Championed the CI/CD process, utilizing tools such as Bitbucket, Jenkins, and Nolio
  • Instituted automated data archiving and retention methodologies
  • Periodically conducted platform and database upgrades, ensuring smooth functionality
  • Integrated and maintained data platforms at an enterprise level
  • Enhanced data security with standards, classifications, and advanced encryption in Oracle
  • Played a pivotal role in the administration of systems like Data Flux and Active Batch V8
  • Masterfully crafted shell scripts to boost post-session data processing
  • Identified and addressed data bottlenecks, ensuring top-tier session pipeline performance
  • Fostered collaboration with cross-functional teams, driving solutions for Informatica challenges.

Previous Decade

Multiple Employers
06.2006 - 02.2011
  • Experienced professional with a diverse background working in multiple companies, holding roles as a Data Engineer and BI Developer
  • Refer detailed accomplishments: https://github.com/send2aarun/resume/blob/main/CV__Arunagiri_Resume_InDetail%20.pdf


Education

Bachelor of Science - Mechanical Engineering

Anna University
India
09.2008

Skills

  • Highly Adaptable
  • Cloud Technologies Microsoft/AWS/GCP
  • Expertise in Data visualization and reporting tools
  • Expertise in statistical analysis for business
  • Specialized Business Acumen
  • Expert in System Design and ETL pipelines
  • Effective communication
  • Rigorous thinking
  • Strategic Thinking
  • Microservices Architecture
  • Development Methodologies: Agile, Kanban
  • Technologies used: Power BI, Tableau, CRM Analytics, IDMC, AWS, ADF, HBase, Apache Spark, Snowflake, Teradata, Oracle, PySpark, R, Python

Accomplishments

    · Migrated legacy data to Snowflake data lake and documented the process.

    · Implemented TLS 1.2 to Oracle DB servers and extended to ETL/BI tools.

    · Championed advanced data encryption techniques.

    · Led ETL integrations compliant with enterprise standards.

    · Upgraded Informatica versions and repositories.

    · Collaborated for server setups during Informatica version upgrade.

    · Standardized processes with Olympus release management tool integration.

    · Automated data archival and addressed dashboard data quality issues.

    · Optimized runtimes by identifying operational bottlenecks.

    · Transitioned platforms from AIX to Solaris efficiently.

Certification

Snowflake : Data Warehouse, Data Applications Cognos : IBM Certified Designer Cognos BI Reports Social Profiles

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Tech Lead to Principal Engineer

Altimetrik Corp
04.2013 - Current

DBA

Technosoft Global Services
03.2011 - 04.2013

Previous Decade

Multiple Employers
06.2006 - 02.2011

Bachelor of Science - Mechanical Engineering

Anna University

Similar Profiles

CREATE PROFILE
Arunagiri Ambalavanan