Data Scientist with expertise in SQL, Snowflake, and Tableau, previously at Cognizant Technology Solutions. Achieved a 50% increase in data ingestion speed and enhanced system performance through collaboration. Proficient in data visualization and analytics, delivering effective business intelligence solutions. Experienced in leading teams to meet project objectives.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Scientist
Cognizant Technology Solutions
Hyderabad
05.2022 - Current
Efficiently integrated data from diverse sources using Hive, Spark, and Scala to create comprehensive data views for BI tools like Tableau.
Leveraged Spark with Scala to distribute data processing across large streaming datasets, achieving a 50% increase in ingestion speed.
Collaborated with engineering team members to optimize system loads, resulting in a 20% improvement in overall system performance.
Designed and implemented a real-time data pipeline, integrating 10 million raw records from multiple sources using Spark and Scala.
Developed over 100 interactive filters, parameters, and calculations for Tableau dashboards and worksheets, enhancing user interactivity and data exploration.
Successfully migrated existing Scala code to Snowflake, resulting in a 50% enhancement in pipeline performance.
Developed Snowflake code to create data pipelines, which were subsequently used as data sources for Tableau dashboards.
Senior Software Developer
IQVIA
Bangalore
05.2019 - 05.2022
Collaborated with upper management to successfully implement 3 strategic processes, resulting in a 25% improvement in overall operational efficiency.
Oversaw the maintenance and design of 12 applications in Tableau, Power BI, and SSRS, ensuring continuous enhancement and optimal functionality.
Led major enhancements on 15 existing dashboards, resulting in a 30% improvement in user satisfaction.
Coached and mentored a team of 5 members, resulting in a 20% increase in overall team productivity.
Collaborated with internal stakeholders, collecting and analyzing requirements for 15 customer projects to ensure precise project alignment and successful execution.
Coordinated with the Project Management team, resulting in a 25% improvement in the planning process and timely project completion.
Application Development Specialist
IQVIA
Bangalore
09.2016 - 04.2019
Developed and delivered Tableau and SSRS reports tailored to meet the unique needs of diverse clients, resulting in a 25% increase in client satisfaction and improved decision-making.
Engineered SSIS packages and implemented robust stored procedures for data loading and validation, leading to a 30% reduction in data processing time and enhancing data accuracy.
Spearheaded process optimization for a database exceeding 1 GB, resulting in a 20% improvement in Tableau report generation efficiency and a streamlined data management workflow.
Provided expert technical support for troubleshooting reports and dashboards, resulting in a 15% decrease in issue resolution time and improved overall system reliability.
Actively participated in integration, performance, and user acceptance testing of BI solutions, contributing to a 20% reduction in system bugs and ensuring the successful deployment of high-quality business intelligence tools.
Implemented effective Application Management solutions for various client projects, resulting in a 30% decrease in system downtime and increased overall operational efficiency.
Senior Business Intelligence Developer
Aroha Technologies
Bangalore
03.2016 - 09.2016
Provided technical support to end users in resolving their queries related to the usage of BI tools and dashboards developed by us.
Collaborated with stakeholders to identify opportunities for improved data analysis and insights through dashboard design and visualization techniques.
Implemented ETL processes using SQL and additional tools to migrate data across different systems.
Created complex SSIS packages with multiple transformations such as derived columns, lookups, conditional splits, script tasks and execute SQL tasks.
Involved in developing reports using SQL Server Reporting Services based on the requirements gathered from stakeholders.
Collaborated with database administrators to design database objects including tables, views, stored procedures and user-defined functions required for ETL process.
Database Engineer
EsyaSoft Technologies
Bangalore
05.2015 - 03.2016
Designed, implemented, and maintained relational databases for data storage and retrieval.
Optimized queries for maximum efficiency and scalability in a production environment.
Identified, protected and leveraged existing data.
Assisted other teams with troubleshooting complex SQL queries or stored procedures.
Updated and maintained databases with current information.
Achieved cost-savings by developing functional solutions to problems.
SQL BI Developer
Aroha Technologies
Bangalore
05.2013 - 04.2015
Analyzed existing T-SQL scripts used in ETL processes and identified opportunities for improvement or optimization.
Created SSIS packages to extract, transform and load data from multiple sources into the Data Warehouse.
Worked with Business Intelligence tools such as SSRS and Tableau for creating interactive dashboards.
Investigated issues reported by end users related to data quality and accuracy within the Data Warehouse environment.
Developed and implemented data warehouse models for various reporting requirements using SQL Server 2008, 2012, 2014.
Optimized existing ETL processes using SSIS best practices to reduce run times of jobs.
Designed, developed and maintained complex stored procedures, functions, views, tables and other database objects in T-SQL.
Education
Bachelor of Science - Information Technology
Punjab Technical University
Kolkata, WB
01.2010
Skills
SQL and database management
Business intelligence and analytics
Data visualization and reporting
ETL and data integration
Data warehousing and pipelines
Tableau and Power BI expertise
Apache Spark and Hive proficiency
Version control with Git
Scala programming skills
Certification
MTA: Database Fundamentals, Microsoft, 2021
Tableau 10: Mastering Calculations, Lynda.com
Creating Interactive Dashboards in Tableau 10, Lynda.com