Services
About me
🙋🏻♀️Who am I?
👩💻5+ years of experience in analyzing complex business data and turning it into meaningful stories for leadership to make business decisions for start-ups and Fortune 500 companies in India, Ireland, and USA
📈 CCC Intelligent Solutions: I developed customized reports using ApacheSpark from the Hive database with 1M+ rows for BI leadership to identify claim processing trends based on historical data and drive key strategic business decisions and recommended proactively implementing programming logic to the existing data pipeline solution to support future Ad-hoc requests that resulted in saving about 40 hours of development work. I also Led quality assurance of customized reports by writing and optimizing complex SQL queries and by performing database tuning including joining 3 Hive tables resulting in zero discrepancies in final deliverables. Furthermore, I Automated reporting workflows by integrating and scheduling DAGS in Airflow which resulted in saving at least $34K by eliminating dependencies on the Data Engineering team for future report generation requests
📈 Citi Bank: I designed, implemented, and monitored ETL workflows to generate reports for software development teams to streamline and display customer transaction details for over 1.5 Million customers. I Oversaw data migration from legacy database to Hadoop cloud by writing and optimizing Linux scripts and complex SQL queries that resulted in saving $147K/year in storage and subscription fees.
🎯 My mission is to make complex data into meaningful stories for everyone! 🎯
📈 I love diving deeper to understand the trend and presenting it in a graphical and easy-to-understand format to leadership.
📁 What am I Bringing to the Table?
Programming Languages & Tools: Python, R, SQL, MYSQL, SQL Server, SAS/SPSS, Hive, S3
Data Integration and Data Engineering: Alteryx, Tableau, Spark (Py-Spark), EMR , Kafka, Airflow
Business Intelligence: Power BI, Tableau, AWS Quicksight, SQL Server Integration Servies(SSIS), SSRS
Please contact me at mshalvika@gmail.com to find out how I might contribute and add value to your organization.