Aakash Kapadia
Workforce Management Data Analyst at CVS Health
Data Analyst at CVS Health
I am a competent professional with over four years of work experience in Data Analytics. I am skilled in SQL scripting, Statistical Analytics, Data Visualization, Data Warehousing using ETL and Dashboard creation. I possess proficiency in advanced MS Excel.

Skills:

Programming Languages: R, Python, SQL
Data Analytics and Visualization: Power BI, Tableau, Minitab, Big Query, Google Analytics, Advanced MS Excel (Pivot Tables, VB, Macros, VLookup)
Databases: MySQL, SSAS, SSIS, MS Access, ETL
Applications: MS Visio, Amazon Web Services, MS Word, MS Powerpoint, MS Azure ML Studio

📧: ahkapadi@syr.edu
📞: +1 (315) 491-3718
CVS Health
https://www.linkedin.com/company/cvs-health
•	Developed an ecosystem of interactive Tableau dashboards for pharmacy operations to determine anomalously trending KPIs by setting up weekly alerts.
•	Collaborated with industrial engineering team to develop and track significant metrics based on their impact on labor hours variation, thereby reducing labor cost.
•	Automated SQL table update and incremental data refresh on Tableau Server to provide updated dashboards to field leaders and upper management.
•	Work on a weekly monitoring process to notify about breakages in the reporting ecosystem, thereby reducing the bug resolution time.
•	Analyzed the root cause behind anomalous trends of key metrics using regression and trend analysis and provided actionable recommendations to leadership to normalize the trends.
•	Collaborated with store operation teams to translate the business calculations around controlled substance production, script intake, script verifications and rejections, and POS workstations in SQL code.
•	Extracted and manipulated over 60M records of 400K+ employees and 9900 stores in Teradata and connected the data to R using DBI library to find cause for increased employee attrition rate.
•	Build views in Tableau to explore employee attrition data and use machine learning and time-series forecasting to determine high attrition stores and assist the leadership to efficiently invest $40M in employee retention.
https://media-exp1.licdn.com/dms/image/C4E0BAQEw3QnvP1SMWg/company-logo_100_100/0/1646143303403?e=1655942400&v=beta&t=_3mJ7HnJTF0HmiCBdLoTOkQ5kIj0OmaWVQjgMK4_V7w
Workforce Management Data Analyst
Cayuga Centers
https://www.linkedin.com/company/cayuga-centers
•	Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
•	Initiated digital transformation by deploying interactive dashboards to analyze internal employees’ and external clients' data and increased reporting efficiency.
•	Developed the staff vaccination report along with an event trigger whenever their health examination is due.
•	Developed and maintained a scheduled suite of Tableau dashboards to track the recruiting KPIs and helped the organization drive data driven hiring.
•	Extracted and reported the data by writing complex SQL queries including JOINs, nested queries and stored procedures.
•	Developed database objects, including tables, views and materialized views using SQL.
Auburn, New York, United States
https://media-exp1.licdn.com/dms/image/C4D0BAQGoRGwsDuw9tQ/company-logo_100_100/0/1596651050440?e=1655942400&v=beta&t=A9Ulyv-DKIlf6Y7wugFdQ8bl4qMePkJlg0e5U23wCB8
Data Reporting Analyst
Syracuse University
https://www.linkedin.com/company/syracuse-university
• Used Excel pivot charts and Tableau to analyse university’s enrollment data. Determined effect size for ethnicities
• Used Excel linear regression to determine factors affecting students’ grades. Improved counselling effectiveness by 20%
• Used SQL and Excel to ensure data quality and integrity. Identified and eliminated duplicates and inaccurate data records
• Developed R script to perform test item analysis on university-wide exams. Increased exam efficiency by 33%
• Used hypothesis testing in Excel to determine statistical significance between performance of various academic groups
Syracuse, New York Area
https://media-exp1.licdn.com/dms/image/C560BAQFAyZ5pXkHL9Q/company-logo_100_100/0/1597671966100?e=1655942400&v=beta&t=jIZwHEq4IOlt-akteEHG9msVudZCRBN5Wxkuz9qVzEs
Data Analyst
INFICON
https://www.linkedin.com/company/inficon
• Performed logistic regression model to determine the key parameters affecting the measurement variation in the process
• Designed Six Sigma (DFSS) to increase First Pass Yield (FPY) of production process
Syracuse, New York Area
https://media-exp1.licdn.com/dms/image/C4D0BAQGOTqBLyUslKg/company-logo_100_100/0/1635925956752?e=1655942400&v=beta&t=jE3JVkBLn7hWiE9HVmAKbxNJtKeWr0IVNbyB5EzOpnI
Data Quality Assurance
iConsult Collaborative at Syracuse University
https://www.linkedin.com/company/iconsult-at-syracuse-university
Syracuse, New York Area
https://media-exp1.licdn.com/dms/image/C4D0BAQFalzAjJC9RBw/company-logo_100_100/0/1628546113979?e=1655942400&v=beta&t=K7I64svncOXe5TS6hx-6FsnYRNOP5CoyGecLwdqH1D8
Consultant Intern
Sky Edusoft
• Managed ed-tech company’s marketing database and wrote SQL queries to extract demographic data of external clients
• Performed predictive analytics in Excel to help clients in market segmentation and increased customer growth by 15%
• Identified pain points of customers by building dashboard on Power BI and streamlining payment interface
Ahmedabad Area, India
Data Analyst and Business Intelligence
Ideabright Infotech Private Limited
https://www.linkedin.com/company/ideabright
• Designed ERDs, created tables based on business rules and tested an inventory management database system for e-commerce market using SQL Server
• Balanced supply and demand ratio by analysing web traffic and improved vendor efficiency by 22%
Ahmedabad
https://media-exp1.licdn.com/dms/image/C510BAQE8ZqPSVPsKdA/company-logo_100_100/0/1539450056445?e=1655942400&v=beta&t=HhJ0XT7AxtbsroVPjehfy-WUU1psLr2WAoTsIpPpMSQ
SQL and Analytics Intern
Anala Outdoors Pvt. Ltd.
https://www.linkedin.com/company/anala-outdoors-pvt-ltd
Ahmedabad Area, India
https://media-exp1.licdn.com/dms/image/C4E0BAQGPQaaR7RWRYg/company-logo_100_100/0/1519888635902?e=1655942400&v=beta&t=XJc1WVEpEssiKwbIQEchSm5kpkTF5lHLbxTGMzmD004
Risk and Emergency Management
Master of Science - MS
Management Information Systems, Data Science
https://media-exp1.licdn.com/dms/image/C4E0BAQGQDtcwhD3ERA/company-logo_100_100/0/1596118034724?e=1655942400&v=beta&t=ER8Fw_qWRWyqWy5NhwQRI4KisCw7EoK9tO8f_QEuTHc
Syracuse University School of Information Studies
https://www.linkedin.com/school/ischoolsu/
Bachelor of Engineering - BE
My coursework included learning key subjects like  Analog & Digital systems,Signal Processing, Object Oriented Programming, Basic Advanced & Integrated Electronics, Wireless communication, Embedded system, Visual Basic, Micontroller & Microprocessor
Electrical, Electronics and Communications Engineering
https://media-exp1.licdn.com/dms/image/C4D0BAQHfvameHidqKg/company-logo_100_100/0/1519911543702?e=1655942400&v=beta&t=oR048SJX6FM1Absf31LLSk7zj_xMtok_vns10qmNrdE
L.D. College of Engineering
https://www.linkedin.com/school/l.d-college-of-engineering---ahmedabad/
Center for Learning and Student Services CLASS
Academic Coach
Office of Professional & Career Development, Syracuse University
Board Member
Stevenson Educational Center
Academic Tutor
Indian Trainers' Association
Trainer
• Founded an educational technology company offering an online communication and collaboration platform to K-12 students and educators through web access • Evaluated products including open source modules and incorporated them into projects • Coordinated with backend team to determine & ensure necessary backend functionality based on client needs • Ensured that the project teams are adhering to the Agile principles • Orchestrated a qualitative database-driven digital marketing campaign & acquired 223 clients • Developed & managed a team of 37 top-tier school educators offering online & offline coaching
Sky Edusoft
Founding Director and Technical Head
Ideabright Infotect Pvt. Ltd.
Intern
Gujarat Ambuja Exports Ltd.
Corporate Trainer
Conducted a seminar on Positive Thinking with Board of Directors of Gujarat Ambuja Exports Ltd. (an agro based company in global market)
Mr. Sanjay Maniar - Deputy General Manager - Gujarat Ambuja Exports Ltd.
Appreciation
Cloud Management
IST 615
Data Science
IST 687
Database Management & Administration
IST 659
Enterprise Risk Management
IST 625
IT Project Management
IST 645
Information Technology & Management
IST 621
Management Principles for Information Managers
IST 614
Syracuse University
https://www.linkedin.com/company/syracuse-university
• Design and implement events to address critical issues of graduate student employability
• Participate in panels, colloquia and other pragrams targeting graduate students
• Serve as liaison to centers for international students, the Graduate Schools, and other related programs
https://media-exp1.licdn.com/dms/image/C560BAQFAyZ5pXkHL9Q/company-logo_100_100/0/1597671966100?e=1655942400&v=beta&t=jIZwHEq4IOlt-akteEHG9msVudZCRBN5Wxkuz9qVzEs
Member at Office of Professional & Career Development
Education
Syracuse University
https://www.linkedin.com/company/syracuse-university
• Help first-year students organize study habits for their assignments and exams on a weekly basis
• Teach students new and exciting research-based study strategies to maximize the productivity of their study sessions
• Trained by CLASS academic learning specialists about ways to interact and teach new students how to stay on top of their studies
https://media-exp1.licdn.com/dms/image/C560BAQFAyZ5pXkHL9Q/company-logo_100_100/0/1597671966100?e=1655942400&v=beta&t=jIZwHEq4IOlt-akteEHG9msVudZCRBN5Wxkuz9qVzEs
Academic Coach - CLASS
Education
Syracuse University
https://www.linkedin.com/company/syracuse-university
https://media-exp1.licdn.com/dms/image/C560BAQFAyZ5pXkHL9Q/company-logo_100_100/0/1597671966100?e=1655942400&v=beta&t=jIZwHEq4IOlt-akteEHG9msVudZCRBN5Wxkuz9qVzEs
Student Athlete Tutor
Education
L.D. College of Engineering
https://www.linkedin.com/company/l.d-college-of-engineering---ahmedabad
https://media-exp1.licdn.com/dms/image/C4D0BAQHfvameHidqKg/company-logo_100_100/0/1519911543702?e=1655942400&v=beta&t=oR048SJX6FM1Absf31LLSk7zj_xMtok_vns10qmNrdE
Chair, Entrepreneur Cell
Education
Sneh Acadmic Services Pvt. Ltd.
https://www.linkedin.com/company/snehdesai
https://media-exp1.licdn.com/dms/image/C4D0BAQFQXZqW15b2-A/company-logo_100_100/0/1631531493908?e=1655942400&v=beta&t=MBtig5RF2RFAxCrY1Ej3ziOMiiST3AIPzgmg-X1u_tg
Practitioner Trainer
Education
Indian Training Academy
https://www.linkedin.com/company/indiantrainingacademy
https://media-exp1.licdn.com/dms/image/C4D0BAQEtmtwzoWtBdw/company-logo_100_100/0/1519910382512?e=1655942400&v=beta&t=HhwKhrQxwgwKMa_dngh2fuLEYWiGnnX78wNWsxfR4Oc
Trainer
Education
Gujarat Ambuja Exports Ltd - India
https://www.linkedin.com/company/gujarat-ambuja-exports-ltd---india
https://media-exp1.licdn.com/dms/image/C510BAQFLeK4uppofOg/company-logo_100_100/0/1552027837601?e=1655942400&v=beta&t=s8Roj-WFzDe9YA9x1l_C5TUDDuBJDs4WVB_YOkSZJFs
Coach and Trainer
L.D. College of Engineering
drive.google.com
Certificate of Participation : Robotrix
https://drive.google.com/file/d/0B1fHnyUvSTZPRTlWX0Jkc2gzS0twblRfM2JkQU9uTEMxaXBB
L.D. College of Engineering
drive.google.com
Certificate of Participation : Teqnix
https://drive.google.com/file/d/0B1fHnyUvSTZPTld2UUVxRkpnT0xjRlpHQ3A2MDN1ZlA3Y2pR
Gujarat Ambuja Exports Ltd - India
drive.google.com
Corporate Training
https://drive.google.com/file/d/0B1fHnyUvSTZPaTB2WW12MlB3bzlXenBNc01VSlNxLWo1djJB
Anala Outdoors Pvt. Ltd.
drive.google.com
Group Lead
https://drive.google.com/file/d/0B1fHnyUvSTZPa3ZZbk0tdHQtVXpfa1pURlRucExVLWlLR2Vr
Sneh Academy
drive.google.com
Practitioner Trainer
https://drive.google.com/file/d/0B1fHnyUvSTZPSm16a1RJN1hGX0xOUU5Ta0pGX2ZwdV9Eb0lj/view
https://www.linkedin.com/in/rushilanand
Jersey City, NJ
Rushil Anand
Customer Success Manager - Architect at IBM
https://www.linkedin.com/in/saumya-arora-63624912b
San Francisco Bay Area
Saumya Arora
Data Analyst at CVS Health
https://in.linkedin.com/in/supriya-patil-5542a084
Delhi, India
Supriya Patil
Software Engineer at SafetyLabs Inc
https://www.linkedin.com/in/adesh-gadge
San Francisco, CA
Adesh Gadge
Data Scientist | Data Analyst | Business Technology Analyst
https://in.linkedin.com/in/pratik-prajapati-b2242614b
Ahmedabad
Pratik Prajapati
Founding & Executive partner at Out Of Box Services
https://www.linkedin.com/in/bridget-r-bridgetmreilly
Auburn, NY
Bridget R.
RDH:) Implementing solutions with a smile
https://www.linkedin.com/in/robert-murphy-587080b6
Hoboken, NJ
Robert Murphy
Senior Data Specialist
https://in.linkedin.com/in/rajeswari-vadhri-19237178
Hyderabad
Rajeswari Vadhri
Subject Matter Expert
https://in.linkedin.com/in/prashant-singh-210267a8
Noida
prashant singh
Linux Developer at SafetyLabs
https://in.linkedin.com/in/shreenika-rao-55996a228
Hyderabad
Shreenika Rao
Senior Research Analyst at IndustryARC™
https://www.linkedin.com/in/praful-praveen-badami
Boston, MA
Praful Praveen Badami
Business Technology Analyst at ZS
https://in.linkedin.com/in/devendra-singhal-841a0b29
Gwalior
Devendra Singhal
Senior Software Engineer at SafetyLabs.Inc
https://www.linkedin.com/in/ashwini-nadupuri-9546721b
Hartford, CT
Ashwini Nadupuri
Data Scientist at Aetna,CVS Health
https://www.linkedin.com/in/vanessa-oruska-4815b2107
Philadelphia, PA
Vanessa Oruska
Operations Assistant at ZS
https://www.linkedin.com/in/hilonia
Boston, MA
Hiloni Ashra
Project Manager at Urbanica
https://uk.linkedin.com/in/surbhi-puri
London
Surbhi Puri
Business Consultant, Patient and Consumer Health  at ZS
https://www.linkedin.com/in/chip-hodgkins-556802a
Fayetteville, NY
Chip Hodgkins
Owner at The Chip Hodgkins Team
https://www.linkedin.com/in/swapnil-d
New York, NY
Swapnil Deshpande
Product Marketing Analyst at Vimeo
Liked by Aakash Kapadia
https://www.linkedin.com/signup/cold-join
One promise I make, is if you fail the Microsoft online assessment.. I will reach out to you in 8 weeks and we will try again. I believe in potential…
Liked by Aakash Kapadia
https://www.linkedin.com/signup/cold-join
The wait is over ! We present to you LDCE's 75th Anniversary Logo. The new logo is our memorandum of our Centennial Vision. We have foresighted…
Liked by Aakash Kapadia
https://www.linkedin.com/signup/cold-join
#truth
https://in.linkedin.com/in/aakash-kapadia3
Mumbai
Aakash Kapadia
Senior Organizational Manager at IETE-TSEC and Publicity Head at IETE-TSEC
https://au.linkedin.com/in/aakash-kapadia
Victoria, Australia
Aakash Kapadia
Chartered Accountant | Financial Accountant | Business Services Accountant | XERO Certified Advisor | Cloud Accounting
https://www.linkedin.com/in/aakash-kapadia-137a868b
Utica, NY
Aakash Kapadia
Actively seeking Internship in the field of Computer Science.
https://in.linkedin.com/in/aakash-kapadia-696730182
West Delhi
Aakash Kapadia
Senior Sales Manager at Associated Scientific Corporation
Syracuse University - School of Information Studies (iSchool)
https://media-exp1.licdn.com/dms/image/C4D07AQHzQrcvW6uHxw/group-logo_image-shrink_92x92/0/1630998400411?e=1647691200&v=beta&t=hf-TFGY-_Xu2tm2-V9tAQuN2V_dJm8l9RnNDmIgMOc4
https://www.linkedin.com/groups/74275
Secure Cloud Architecture
https://media-exp1.licdn.com/dms/image/C5607AQH9CSrmNYYPeA/group-logo_image-shrink_92x92/0/1631001906507?e=1647691200&v=beta&t=cj3rwwq-33d5fdhScP6UNX0rLw3rE_0ZhM1wY59U_k4
https://www.linkedin.com/groups/13791608
L.D.C.E. Alumni Association
https://media-exp1.licdn.com/dms/image/C4D07AQGG_joKQc2vHg/group-logo_image-shrink_200x200/0/1631373941795?e=1647691200&v=beta&t=IzPifBMDim4My2Xl8OgxpX_mBrGvg9b8lBtMyLOe0WE
https://www.linkedin.com/groups/101838
WiTec: Worldwide Innovation Technology and Entrepreneurship Club
https://media-exp1.licdn.com/dms/image/C5607AQGSBihbHASZmQ/group-logo_image-shrink_92x92/0/1631001944402?e=1647691200&v=beta&t=7EhJZ6GLcU2FLERg-YPi57iBtFemd815Z5CLrRAaKjk
https://www.linkedin.com/groups/13791437