Nikhil S Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

● Solution Design: Drafted and operationalized an Azure cloud architecture blueprint, enabling flexible, robust, and portable data pipelines for real-time integration that reduced table load time by 15 minutes● Invented Scalable Data Warehouses: Developed robust scalable data warehouse solution on Snowflake using Azure cloud services (ADF, DevOps) by consolidating multiple data sources which reduced data retrieval time by 20 minutes● Ownership Of Data Pipelines: Designed and developed end-to-end transaction validation automated ETL pipeline for 5TB to 10TB data using Python, PySpark, SQL, and ADF that decreased manual intervention by 50%● Streamlined Deployment: Optimized SQL/Python scripts for batch data processing and deployed using Azure Dev-Ops CI/CD, accelerating the data ingestion process time by 20%, empowering the team to make data-driven decisions promptly● Customer Focus: Utilized Databricks, PySpark, and Spark SQL to identify key trends, leading to a 10% increase in customer acquisition and a subsequent 15% boost in sales● Power BI Data Refresh time Optimization: Remodeled Power BI data refresh via API, reducing refresh time by 15 minutes for seamless real-time data updates and enhanced reporting accuracy by 20%● Troubleshoot Production Pipelines: Resolved production issues with avg 2 mins response time, identified root cause by analyzing systems logs and error messages, prevented prolonged downtime● Cross-Functional Collaboration: Fostered a positive and productive working relationship between teams, leading to an increase in successful end-to-end project implementations

● Swift Data Integration: Successfully migrated 30TB of complex data to Big Query from 10+ diverse sources, utilizing Airflow ensuring seamless ETL configuration, and minimizing downtime by an average 1 hour● Effective Data Processing: Accomplished 98% data quality and consistency by implementing a robust data pipeline using Apache Spark, integrating and transforming raw data into a structured format for accurate analysis● Structured Reporting: Enhanced reporting productivity by 10% through the implementation of automated reporting solutions using Tableau, ensuring timely delivery of critical business metrics● Revenue Growth: Enhanced data-driven marketing strategies by analyzing customer behavior patterns in MySQL to attract more customers, leading to a 2% increase in revenue

● Optimal Analysis: Conducted in-depth analysis of campus FAQs, Reduced lost & found items by 30%, leading to a more organized campus environment and improved student satisfaction● Optimized Power BI Dashboards: Upgraded Power BI dashboards by analyzing lost & found items data in MS SQL Server, enhanced the processing time by 2%

Pune

● Telecom Inventory Management and Savings: Led a team of 5 in maintaining the telecom inventory for 5+ customers using SQL Server, resulting in annual savings of 8% with major service providers including AT&T, Verizon, Granite Telecom● Cross-Functional Collaboration and Inventory Maintenance: Managed inventory of customers valued at $10M-$40M through effective collaboration with cross-functional teams, utilizing SQL and MS Excel for accurate data management ● Tableau Dashboard Development and Client Acquisition: Developed interactive Tableau dashboards showcasing $96K in savings for clients, leading to successful credit back and acquisition of new business opportunities● Enhanced Cost Savings Reporting: Refined cost savings reporting processes, achieving a 10% increase in profit by assembling annual savings reports using SQL and Tableau dashboards● Decision-Making Enhancement: Improved decision-making processes by accelerating data competency by 5%, ensuring timely delivery of inventory for clients before deadlines, enhancing overall operational agility