Subramanian Selvaraju

Subramanian Selvaraju

Senior Data Analytics Engineer
United States of America

About Me

Results-focused collaborator with expertise in designing, developing, and implementing robust BI architectures, data warehousing systems, and analytics platforms. Highly skilled in creating insightful data visualization …

Experience

Lead Analytics Engineer

Meta
Sep 2023 - Present · 2 years 10 months

The individual in this role is responsible for designing and implementing data analytics solutions specifically tailored for Meta's Global Security organization. Their main duties include:

Crafting effective data analytics solutions: Designing strategies and systems to manage large and complex datasets efficiently.

Enhancing ETL (Extract, Transform, Load) processes: Optimizing the processes involved in extracting, transforming, and loading data, leading to a 30% reduction in data processing time and a 20% improvement in system efficiency.

Integrating data from multiple sources: Consolidating data from various external APIs and internal databases to create a unified and comprehensive dataset for analysis.

Implementing and managing analytical tools: Leading the adoption and utilization of analytical tools within the organization, thereby promoting a data-driven culture.

Implementing rigorous data quality checks: Establishing quality control measures to ensure the accuracy and reliability of critical datasets, resulting in a 15% decrease in data errors and maintaining a 98% accuracy rate.

Overall, this role involves leveraging data analytics to support Meta's Global Security organization by optimizing processes, integrating data, fostering a data-driven culture, and ensuring data accuracy and reliability.

BI Solution Architect

HARLEY-DAVIDSON, Remote
Jan 2022 - Jan 2023 · 1 year

Orchestrated end-to-end design and implementation of data-driven analytic solutions for diverse clients in a fast-paced environment, ensuring seamless alignment with strategic goals and product design.
Streamlined BI solutions to optimize performance, ad-hoc queries, and ETL/ELT processing, resulting in a 40% improvement in overall system efficiency.
Collaborated with the marketing and sales team to develop a customer segment analytic model, contributing to 60% growth in running campaigns for vehicle sales
Partnered closely with executive leadership and cross-functional stakeholders to identify data / user requirements, establish KPI metrics, and translate user requirements into actionable analytical solutions, driving 15% improvement in operational efficiency.
Developed an efficient automated system using Python for creating campaign tracking codes that cut down on manual workload by 80% for businesses.
Designed dashboards and Key Performance Indicators (KPIs) to monitor various aspects, including inbound and outbound campaigns, lead conversions, parts and accessories analysis, vehicle sales, and registration, among others
Orchestrated integration of external data sources, expanding breadth of available information for analysis and enriching user-centered decision-making capabilities.

Senior Data Analytics Engineer

APPLE (Deloitte), Cupertino, CA
Jan 2018 - Jan 2022 · 4 years

Directed cross-functional teams in executing complex technical aspects of data analytics projects, leveraging agile methodologies to ensure on-time and on-budget delivery, while maintaining client satisfaction and fostering collaborative relationships.
Utilized advanced proficiency in Tableau to provide impactful dashboards aimed at elevating productivity of Apple media product business users.
Spearheaded consolidation and integration of Apple features across multiple sources, establishing a singular source of truth. Notably, achieving an impressive accuracy rate of 95%.
Proficient in leveraging Python, PySpark, Git, Airflow, Teradata, Hadoop & JSON to extract, transform, and load (ETL) large datasets for insightful analysis.
Designed and developed robust data pipeline workflow from diverse sources , driving integration and preparation of data for analytical and quantitative solution.

Technical Architect

VISA (Infosys), San Francisco, CA
Jan 2015 - Jan 2018 · 3 years

Evaluated all major system modifications and development requests to determine potential benefits and impact on business and information system operations.
Collaborated with finance business unit to develop, and implement self-service solutions.
Provided statistics analytic solution that helped approximately 14K financial banks to identify and forecast card holders eligible for upgrades and analyze upgrade opportunity.
Conducted collaborative weekly meeting to communicate status and roadblocks / issues to stakeholders and make proactive recommendations to remove roadblocks, leading to on-time project delivery.
Implemented data governance best practices designed to optimally retrieve and process data from various interfaces going into and out of Denodo virtualization layer, creating a single source of information for stakeholders.

Senior BI Consultant

CISCO (Tech Mahindra), Milpitas, CA & Hyderabad, India
Jan 2007 - Jan 2015 · 8 years

Led interviews with stakeholders to identify KPI’s and metrics and developed customized UI / visualization to track business performance and trends.
Prepared test-cases and detailed use cases based on system requirements.
Executed performance-tuning and optimization of existing BI solutions, resulting in 60% improvement in report generation.
Created dashboard in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
Participated in gathering, analyzing, and documenting business requirements, and data specifications for converting Crystal Reports to BO reports, providing business analysts with centralized source for data reporting, visualization, and sharing.

Lead Analytics Engineer

Meta (Formerly Facebook), Fremont, CA
Jan 2023

Responsible for crafting effective data analytics solutions tailored to manage large and complex data sets for Meta’s Global Security org.
Enhanced ETL processes, resulting in a 30% reduction in data processing time and a 20% improvement in overall system efficiency.
Integrated data from multiple sources, including external APIs and internal databases, to create a unified and comprehensive view for analysis.
Spearheaded the implementation and management of analytical tools, fostering a data driven culture within the organization.
Implemented rigorous data quality checks, leading to a 15% decrease in data errors and ensuring a 98% accuracy rate in critical datasets.

Skills

Business Objects SQL Database Azure Google Cloud Platform Hadoop MicroStrategy Spark Power BI Tableau Data Analysis Debugging Optimization Dashboard Development Report Development Data Pipeline Development Relational Data Modeling GAP Analysis Project Management Agile Methodologies SDLC Team Leadership Written Communication Verbal Communication ETL ETL/ELT BI Data Warehousing Data Visualization Data Governance GDPR Probability Statistics Python PySpark Git Airflow Teradata JSON Denodo Crystal Reports BO Reports Databricks Snowflake
Report this Profile?