Ankita Kumar Email and Phone Number

•Provide advanced analytical support for business operations in all or some of the following areas: claims, provider data, member data, clinical data, HEDIS, pharmacy, external reporting•Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources•Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management•Develop reports and deliverables for management•Model data using MS Excel, Access, SQL, and/or other data warehouse analytical tools•Ensure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis•Assist with training and mentoring other Data Analysts. If you have any additional questions, please feel free to contact me

•Developed customized scripts for PCA and K-means clustering Machine Learning algorithms and visualizing using with Tableau using to visualize customer and product data•Conducted customized RFM (customer-oriented analysis) using Python to segment 10K+ Juniper customers into 6 tiers based on transactional data to identify high-value opportunities for the business•Used analytical tools to determine the top 15% clients to target for new offerings for Juniper software and hardware businesses•Built Data Flow Charts for orderly visual depiction of revenue and cost allocations for different product categories•Documented Data Processes to improve understanding of the data and workflows to ease the transfer of information•Delivered useful business insights appreciated by the VP and Executive Director of Big Data and Enterprise Analytics•Engineered a reporting dashboard for leadership to keep track of KPIs using Python and PowerBI, an effort that eliminated need for regular status checks and freed 500 man-hours annually

•Extracting, cleansing, transforming & preparing large volumes of data from multiple sources for analysis using SQL and other tool•Mapping billions of advertiser’s transactions data in semi-structured format via a series of data reductions techniques•Analyzing data trends to provide clear insights and recommendations to internal business partners using Tableau•Analyzed business needs during Sprint planning by understanding requirements, designing, executing test plans, & defect reporting•Built Tableau dashboard to visualize core business KPIs and develop optimized solutions for delivering all measures•Dealt with 10 billion transactions of ~ 4500 domestic branches with ~20% reduction in TAT for information extraction, review and validation•Built and automated data pipelines to combine datasets from multiple sources and improve data workflow.Mentored new trainees and 5 laterals for 3 months regarding the business project architecture and client supported tasks