United States
Seasoned Data professional, Data Science enthusiast and accomplished Data Analyst with an innate knack for analytical skills who has provided business solutions to the senior leadership team of various organizations, with 8+ years of multi-domain experiences in Healthcare, Financial Services, and Social media industries. Consistently promoted throughout my career based on my abilities in identifying unique growth opportunities, Risk/Issue analysis, and building strong cohesive teams. Being a team manager, I empowered my team to share their opinions to optimize the solutions provided to the client and streamlined action plan towards the completion of the project deliverables. Proficient in Project elicitation & prioritization, Negotiation with stakeholders, Project management, Risk management, Project charter & status tracking, KPI Dashboards & Scorecards, and operated in fast-paced Agile environment projects. Experienced in Business Analytics, Data Warehousing, Data Analytics, Data Science, Data mining, Text mining, Regression Analysis, NLP, & ML algorithms (Linear & Logistic Regression, k-NN, K-means, Naïve Bayes, Decision tree, SVM, Neural networks, Time series) SKILLS AND METHODOLOGIES: ● Analytics & ETL Tools: Azure, Google Analytics, Power BI, IBM Watson, Tableau, QlikView, Statistica, RapidMiner, Informatica ● Database Tools: Microsoft SQL Server, Azure SQL, Oracle, Teradata, MS Access, SAP HANA ● PM Tools: MS Project, Jira, Kerika & Trello (Kanban), Excel (Pivot tables, Solver) ● Languages: R, Python, SQL, C, C++, C#, ASP.NET, HTML ACHIEVEMENTS AND CERTIFICATIONS: ● Certified R Programmer, Microsoft Certified Professional Developer, Red Hat Certified Engineer ● Magna Cum Laude candidate - Top 5% of the class ● Milgard Endowed Scholar - UW’s Scholarship for Business Grad. students ● Recipient of Accenture’s Topper of the Batch Employee Award If you are looking for someone to solve complex business problems, email me at [email protected]
● Optimized Teradata, GCP BigQuery to analyze 500M+ customer interaction & reduced refresh time by 80% ● Created 40+ executive Tableau dashboard & weekly report to track Digital KPI, Customer Engagement, Revenue, Churn, NPS & Channel Performance, raising decision-making by 75% ● Built enterprise-wide self-service BI solution for 5M+ users for real-time insight, reducing ad-hoc reporting by 70% ● Modernized legacy report with UI/UX visualizations, raising stakeholder adoption & report engagement by 80% ● Built unified 360° Customer analytics model for customer journey from 10+ heterogeneous data source, raising accuracy by 70% ● Designed end-to-end Customer Journey Analytics report for digital, assisted, omni-channel interaction & reduced customer fallout by 10% ● Built cross-channel model to track App Adoption, Digital Channel Hop, Conversion Rate, Customer Engagement, Journey KPIs & raised digital adoption by 40% ● Performed cohort segmentation, path analysis, customer behavior analysis, raising campaign click-through rate by 50% & customer retention by 20% ● Created customer segmentation & personalized campaign targeting report, raising campaign response rate by 50% with conversion by 25%, raising customer satisfaction by 40% & reduced turnaround time by 60% ● Improved data refresh with incremental loading, query optimization, reducing latency from 12 to 2 hours for real-time business insight ● Built scalable GCP cloud solution with BigQuery & EDA on Python (Pandas, NumPy), reducing query execution time by 75% & cloud costs by 50% ● Automated repetitive task & proof-of-concept delivery for users by 50% with Claude Code ● Used GitHub Copilot, Claude Code (VS Code) to refactor SQL query, Python script, Tableau development & reduced debugging effort by 200% & enabled leadership to find revenue optimization opportunity exceeding $10M ● Predicted customer behavior analysis with statistical & trend forecasting, raising churn prediction by 80% & saved annual costs by $5M
Project: Apple has AIML Data Operations | Analytics team that runs analytics jobs in the Apple workforce. This project was to analyze Radar tickets inflow, handle Datahub portal, & update insights to leadership team. ● Initiated Stakeholder analysis & organized requirement gathering meeting and documented necessary Business requirements along with expected deadlines of project & SLA timings for solving the issues ● Configured Hive and Trino in DBeaver database management tool to extract iceberg data & segregated data to 4 different zone tables (landing, refined, curated, & reporting) for efficient data storage using Git ● Created complex SQL queries with CTE, Recursive CTE, Temp tables & Views to avoid space complexity & improved performance on existing PostgreSQL code to ensure application meets industry standards ● Enhanced the data by executing SQL queries with advanced Window functions like ROW_NUMBER, LAG, LEAD, RANK, and DENSE_RANK and reduced run time to fetch data by 80% from 50 to 10 seconds ● Retrieved & validated financial data with SQL queries by connecting data to Tableau, and automated Tableau reports with Pareto charts, waterfall charts & used Level of Detail (Include, Exclude & Fixed) ● Evaluated ETL process & data using Python script & created data visualization to analyze Radar tickets ● Formatted data with Python and enhanced manual reports to dynamic reports & Tableau dashboards by implementing Row level security for users and summarized user data that saved monthly 25 hours ● Designed key metric reports and Tableau dashboards with KPIs like Average Throughput rate, Time grading, Time per Task (TpT), Gold Set Pass rate (GS pass rate) across the locales & projects in site wise ● Automated KPI metrics with DAGs in Airflow & provided necessary details to client in Quip document and conducted periodical stakeholder meetings saving monthly 30 hrs. and raised productivity by 2X (200%)
Project: Analyzing the Microsoft’s global Sales Data & providing insights for their Sales & Operations team and Finance team ----------------------------------------------------------------------------------------------- ● Singlehandedly analyzed and gathered the sales & revenue data for the Microsoft Senior Executives and performed the Data Modeling in Power BI with the necessary entity relationships, which ensured data integrity and eliminated data redundancy ● Created Dynamic BI reports & Power BI dashboards, against the current manual reports, with Quarter over Quarter & Year over Year analysis and summarized products sold & revenue generated, which saved quarterly ~15 hrs. for management team ● Analyzed & visualized sales data of Microsoft Surface products in Power BI by revenue generated across geographical regions and identified the region with minimum sales and explored the factors in improving the sales by 2% in that region by developing the KPI metrics and implemented them gradually, which increased the quarterly sales by ~1.2% and a quarterly profit of $0.3M ● Resolved 220+ critical tickets against a total of 400+ tickets with ‘0’ reopening defects, which increased the efficiency by ~30% ● Reviewed the key metrics and enhanced the revenue data by resolving the discrepancies in the previous reports and updated them periodically, which reduced the complexity of the reports by ~50%
Project: Establishing the Business Analytics team and analyzing the opportunities to establish Behavioral Health Hospital for MultiCare Health system in the Puget Sound region, WA ----------------------------------------------------------------------------------------------- ● Completed the HIPAA compliance, Privacy & Information security and EPIC tool training ● Implemented the Test cases in EPIC tool and Tested the EPIC tool for 2018 upgrade ● Assisted PeakCare team in implementing the user requirement documents ● Created use cases, UML diagrams, user stories & converted business requirements to technical specification documents ● Coordinated with Navos and Greater lakes team to collect the Data for Behavioral Health Hospital implementation ● Performed Data cleaning, Data mining, Predictive Data analysis and visualized the graphs & charts in Power BI ● Improved the SLA reports by interactive Power BI dashboards and saved monthly report generation time by 8 hours
Project: Opportunity analysis for consolidating surgical specialties to specific locations in Pierce county hospitals, WA ----------------------------------------------------------------------------------------------- ● Conducted the Healthcare Industry analysis, CHI Franciscan's SWOT analysis, PESTEL analysis and the Cost Benefits analysis ● Created use cases, UML diagrams, user stories and converted the business requirements into technical specification documents ● Analyzed Operation Rooms (OR) data for Pierce county hospitals for the past 5 years and identified OR underutilization bottlenecks ● Categorized patients based on the health conditions, surgery preferences & modified patient data in Azure SQL and performed descriptive & diagnostic analytics in Tableau, and confirmed the hypothesis of a decrease in hospital OR utilization rate with the results ● Revised & reorganized the data based on outpatient minor surgeries and performed predictive analytics on the new data, which resulted in an increase of the OR prime time utilization rate by 41% ● Conducted PCA on Operation Rooms data and extracted components by creating Correlation matrix & Scree plot ● Forecasted patients’ inflow for the next 2 years by time series forecasting (ARIMA model) and predicted an increase in the patients’ inflow by 32% ● Recommended the hospital management, to operate only Plastic and Podiatry outpatient surgeries in the same day surgical center, which would establish the hospital as centers of excellence for Plastics and Podiatry surgeries ● Suggested the hospital management to utilize the void and deficit created, by moving Plastics and Podiatry surgeries from other hospitals, in performing complex surgeries