Shilpi Kumari
Santa Clara,CA
Summary
Adept at transforming complex datasets into actionable insights, I spearheaded data integrity projects at xFusion Technologies, enhancing data accuracy by implementing advanced ETL pipelines and machine learning models. My collaborative approach and proficiency in Python and SQL led to significant process optimizations, showcasing a blend of technical expertise and teamwork.
Overview
7
7
years of professional experience
Work History
Data Scientist
xFusion Technologies
Santa Clara, USA
04.2024 - Current
- Implemented robust cleansing procedures to ensure integrity and accuracy across complex datasets.
- Utilized SQL and data profiling techniques to transform raw data into actionable insights, reducing errors and inconsistencies by 25%.
- Designed and implemented scalable data pipelines with UDP solutions, reducing integration time by 30%, and improving efficiency.
- Mapped data elements between diverse source systems and Salesforce, ensuring seamless migration with 98% accuracy.
- Managed data loading into Salesforce, resolving inconsistencies through rigorous testing and validation, achieving a 95% success rate.
- Collaborated with stakeholders to align data mapping strategies with business requirements, streamlining processes, and reducing mapping errors by 20%.
- Tracked and managed data defects using Azure DevOps, delivering detailed reports, and reducing resolution time by 40%.
- Led data migration projects, achieving milestones through effective coordination with cross-functional teams, and reducing project delays by 15%.
- Developed a web scraper to collect over 500,000 public records, creating a regression model that optimized premium pricing for a commercial trucking insurer, improving profitability by 12%.
- Built a unified dataset from four disparate databases to train a GBM classification model, improving collections optimization by 18%.
- Conducted A/B testing that led to a net $500,000 increase in collections, validating the implemented model.
- Designed six unique features for a customer segmentation model, achieving a 10% reduction in collection costs for a late-stage agency.
Data Analytics Engineer
Red Hat, Inc.
Santa Clara, USA
06.2022 - 04.2024
- Collaborated with growth marketing and external agency partners to analyze the business impact of a $50M annual marketing budget, identifying strategies to optimize ROI by 15%.
- Designed and implemented marketing incrementality tests using causal inference techniques (e.g., A/B testing, matched markets, diff-in-diff), improving ROI measurement accuracy by 20%.
- Developed and deployed cLTV models, increasing customer segmentation accuracy by 25%, and enabling data-driven campaign prioritization.
- Established goal-setting frameworks and created performance dashboards, boosting campaign efficiency by 18% through real-time insights.
- Spearheaded the measurement framework for paid marketing initiatives in the New Verticals business, enhancing channel effectiveness by 22%.
- Built and managed an ETL pipeline using Luigi, onboarded RHEL, OpenShift, and Ansible, reducing data processing time by 30%.
- Monitored and resolved issues in 35 daily ETL jobs, maintaining 99% data quality and accuracy, with proactive troubleshooting.
- Assisted in migrating JDV to Starburst, resolving pre-production issues, and achieving 99% system uptime post-migration.
- Developed Tableau dashboards to track over 50 KPIs, enabling comprehensive campaign analysis and 20% optimization in ad spend allocation.
- Implemented an ML pipeline (linear regression and random forest) to predict opportunities and prioritize campaigns, improving lead conversion rates by 15%.
- Delivered monthly performance reports via Ansible, providing actionable insights that drove a 25% increase in stakeholder decision-making efficiency.
- Conducted SQL-driven analysis to verify campaign metrics and values, collaborating with cross-functional teams to ensure data accuracy, and stakeholder alignment.
Data Analyst
Cognizant Technology Solutions
Chennai, India
12.2017 - 05.2021
- Developed time to restore the Tableau report across cloud operation solutions to achieve SAP's global KPI of 99.95% service availability.
- Achieved 1.5X faster, optimized queries by scripting SQL queries and stored procedures for efficient data retrieval.
- Enabled SAP to track metrics such as Total Outage, Time to Restore, Bridge Call, Auto Resolved, Resolve by TICO, and System Monitoring.
- Reduced non-conformance costs and saved $0.8 million per year by calculating accurate high-level BoQs for pipes.
- Decreased response time by 5x for estimations during proposal preparation.
- Implemented linear and decision tree regression from scikit-learn to predict the quantity of pipes required to construct a power plant.
Education
Master of Science - Information Systems
Santa Clara University, Leavey School of Business
Santa Clara, CA06.2023
Bachelor of Technology - Biomedical Engineering
Vellore Institute of Technology
Vellore, India05.2017
Skills
- Python
- Microsoft Visio
- Data warehousing
- Data cleaning
- Machine learning
- Visual Basic
- Data Analysis
- Predictive Analytics
- Descriptive Analytics
- PySpark
- ETL
- Data Modelling
- MySQL
- SQL Server
- PostgreSQL
- Pandas
- NumPy
- Scikit-learn
- Seaborn
- Matplotlib
- Linear Regression
- Random Forest
- Decision Tree Regression
- Tableau
- Power BI
- Git
- OpenShift
- AWS Glue
- EMR
- Lambda
- S3
- Redshift
- Athena
- CloudWatch
- Luigi
- Salesforce
- C
- C
- MS Excel
- Data Governance
- Natural language processing
- Agile methodology
- Statistical Modeling
Timeline
Data Scientist
xFusion Technologies
04.2024 - Current
Data Analytics Engineer
Red Hat, Inc.
06.2022 - 04.2024
Data Analyst
Cognizant Technology Solutions
12.2017 - 05.2021
Master of Science - Information Systems
Santa Clara University, Leavey School of Business
Bachelor of Technology - Biomedical Engineering
Vellore Institute of Technology
Similar Profiles
Chartin MaengaChartin Maenga
Corporate Gifting & Retention Specialist at xFusionCorporate Gifting & Retention Specialist at xFusion
NINA KERUBONINA KERUBO
Customer Support Agent at XFusionCustomer Support Agent at XFusion
Monique KilonziMonique Kilonzi
Call Center Representative, Reservations Officer at XFusionCall Center Representative, Reservations Officer at XFusion
Dylan SpringsDylan Springs
Revenue Manager at SentinelOne, Inc.Revenue Manager at SentinelOne, Inc.
Katie PhamKatie Pham
Barista at BeasteaBarista at Beastea