Naveenkumar S
Bangalore
Summary
I'm being Data Lake Architect & Engineer with 14 Years and 5 months of Crafting Data-Driven Solutions to the table. My expertise encompasses:
Cloud Data Engineering (Azure): Skilled in Azure Data Factory, Azure SQL, and Azure Data Warehouse for building cloud-based data pipelines and analytics platforms.
Data Science Tools: Experienced in Databricks, Python, and PySpark for data manipulation, analysis
Visualization and Applications: Hands-on with Power BI for creating compelling dashboards and Power Apps/Logic Apps for building low-code data-driven applications.
Database Development & Programming: Proficient in TSQL for database creation, stored procedures, triggers, and performance optimization.
Business Intelligence (MSBI Stack): Adept in SSIS, SSAS, and SSRS for end-to-end data warehousing and reporting solutions.
Version Control: Strong proficiency in Git for version control, including branching, merging, and conflict resolution. Experience with VSS, TFS, and Azure DevOps.
External Tools: Pulling in data streams from CRM, e-commerce, marketing automation, HR, project management, manufacturing, supply chain systems, and integration tools like Salesforce, Shopify, Marketo, SAP SuccessFactors, OpenAir, Jira, Workday, Bhoomi, Salesloft
Execution Methods: Proven ability to work effectively within Agile teams, contributing to project planning, execution, and continuous improvement in line with Agile principles.
Overview
14
14
years of professional experience
Work History
Data Analytics Developer
Google India Pvt Ltd
09.2020 - Current
- Collaborated on stages of systems development lifecycle from requirement gathering to production release.
- Worked in this project from procuring Azure subscriptions, established project environments with DevOps practices, designed data pipelines, and executed cross-cloud migrations.
- Architected Azure data infrastructure, including Azure SQL databases and Datalake storage, to support business intelligence and analytics.
- Integrated data from cloud-based applications (Salesforce, Jira), on-premise systems (Oracle EBS), and data storage (S3), utilizing both API and direct connection methods.
- Leverage Azure Data Factory and Databricks (PySpark) to build scalable data pipelines, handling diverse data sources and complex transformations.
- Enabled cloud adoption by configuring on-premises integration runtime (IR) to streamline data migration processes.
- Streamlined software delivery and enhanced code quality by setting up Azure DevOps GIT and CI/CD workflows.
- Expertise in integrating Azure Logic Apps and Power Apps to automate processes and extend functionality
- Defined fine-grained access control by creating custom Azure IAM roles and configuring access policies on cloud resources.
- Created interactive Power BI dashboards to enable data-driven decision-making, empowering stakeholders with self-service analytics.
Staff Engineer
Nextgen HealthCare
03.2020 - 09.2020
- Develop and deploy resilient Azure Data Factory pipelines capable of processing large datasets reliably.
- Establish data governance frameworks to uphold data reliability.
- Partnered with data science teams to enable model development and decision-making.
- Developed PySpark applications on Databricks to perform complex data cleansing, aggregation, and analysis on structured and semi-structured data.
- Enhance data processing efficiency and accuracy by designing robust SQL stored procedures in Azure SQL that implement business rules.
- Created interactive Power BI dashboards to enable data-driven decision-making, empowering stakeholders with self-service analytics.
- Streamlined workflows by designing and implementing Logic Apps and PowerApps for process automation.
Software Developer
Cognizant Technologies Solution
07.2014 - 03.2020
- Partnered with clients (e.g., Microsoft, Fluke Electronics, British SKY Broadcasting) to streamline data migration and enhance data warehouse capabilities.
- Established scalable Azure infrastructure (Azure SQL, Azure Data Factory, Azure Blob) to support efficient data movement and analysis, enabling data-driven insights.
- Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
- Built and deployed SSAS cubes, empowering business users with self-service analytics and data exploration capabilities.
- Accelerated query performance by analyzing execution plans and implementing targeted index and table optimizations, resulting in reduced response times and improving user experience.
- Accelerated analytics and reporting capabilities by implementing data warehouse models optimized for real-time data updates.
- Developed data ingestion pipelines using [tools or technologies] to extract and load data from Oracle, Teradata, SAP Successfactor, Shopify, COSMOS DB, and a wide range of file formats, enabling centralized data analysis.
- Optimized ETL processes by crafting efficient SSIS packages and SQL procedures, resulting in faster data availability for decision-making.
Apps Developer 1
XL Health (United Health Group, UHG)
12.2013 - 06.2014
- Optimized ETL processes by crafting efficient SSIS packages and SQL procedures, resulting in faster data availability for decision-making.
- Built and deployed SSAS cubes, empowering business users with self-service analytics and data exploration capabilities.
- Accelerated query performance by analyzing execution plans and implementing targeted index and table optimizations, resulting in reduced response times and improving user experience.
- Accelerated analytics and reporting capabilities by implementing data warehouse models optimized for real-time data updates.
- Developed data ingestion pipelines using [tools or technologies] to extract and load data from myriad systems and range of file formats, enabling centralized data analysis.
- Delivered actionable insights to stakeholders by building SSRS reports that effectively communicated business data.
Software Engineer
CGI Information Systems
06.2010 - 11.2013
- Engineered a data migration solution using SSIS to transition workloads from a legacy mainframe to a modern SQL Server environment.
- Collaborated in data validation and debugging, leveraging testing and data analysis skills to ensure data integrity after mainframe to SQL Server migration (SSIS)
- Proficient in performance troubleshooting and optimization of SQL queries using tools like SQL Profiler and Query Analyzer. Demonstrated ability to identify and resolve query-related performance bottlenecks, resulting in significant system performance improvements.
- Demonstrated expertise in SQL Server development, creating a range of database objects (tables, views, functions, stored procedures, triggers) and managing user access.
Education
BE - Electronics And Communication Engineering
Ghousia College of Engineering
04.2001 -
MTech - VLSI Design And Embedded Systems
PES College of Engineering
04.2001 -
Skills
Azure SQL, Azure Data Warehouse, Oracle, TerraData
Azure DevOps, GIT, TFS, VSS
Python, Pyspark
BigQuery, LookerCS, Dataflow
Interests
- Interested to read non fiction books, specifically with in categories of intelligence, Espionage and Military history.
- Enjoy regular swimming as recreational activity, promoting physical fitness and mental well-being.
- Enthusiastic Badminton player for agility and fitness through regular practice
Timeline
Data Analytics Developer
Google India Pvt Ltd
09.2020 - Current
Staff Engineer
Nextgen HealthCare
03.2020 - 09.2020
Software Developer
Cognizant Technologies Solution
07.2014 - 03.2020
Apps Developer 1
XL Health (United Health Group, UHG)
12.2013 - 06.2014
Software Engineer
CGI Information Systems
06.2010 - 11.2013
BE - Electronics And Communication Engineering
Ghousia College of Engineering
04.2001 -
MTech - VLSI Design And Embedded Systems
PES College of Engineering
04.2001 -
Similar Profiles
Aswathy PAswathy P
Data Analyst Apprentice at Google India Pvt LtdData Analyst Apprentice at Google India Pvt Ltd
BAIJNATH SINGHBAIJNATH SINGH
Software Engineer at Google India Pvt LtdSoftware Engineer at Google India Pvt Ltd
Srinivas RaghukumarSrinivas Raghukumar
Employee Relations Manager at Google India Pvt LtdEmployee Relations Manager at Google India Pvt Ltd