Working in McKinsey Center for Future Mobility -Helping stakeholders in the mobility ecosystem navigate the future by providing independent and integrated evidence about possible future mobility scenarios

• Worked on Leading edge Healthcare Analytics models• Created Projection models & Managed end to end data flow for 3rd Party Data assets• Built and successfully deployed complex analytics model with end to end data management and deployment

Working on cutting edge data science modeling and analytics case for COVID -19 ( CORONA VIRUS) - Model 1 - Worked on Real Estate Data Modeling for converting the real estate available into Hospitals - Model 2 - Worked on allocating bed with the demand based on severity of critical illness, so that hospital when run out of bed could be notified and bed capacity can be increased - Model 3 - Analyzing Data from Social Media for anticipating the impact during lockdownBuilt geography wide Index profile to give a high level identification of COVID affected zone by looking at severity - Working with largest healthcare provider of United KingdomWorking as a Solution Architect & ETL developer for Data Enrichment for biggest Healthcare Provider in England

Showcased data engineering skills at numerous projects, transitioned the system completely from SQL Server environment into Hadoop frameworkMy role and responsibility included • Data Migration from SQL to HADOOP• HIVE query optimization• Building Data export tool to reduce the effort involved in downloading data from HADOOP• Building tools to improve Data Import feature with just few clicks• Python coding and decision making • Tableau Dashboard designing• Advanced HIVE• Understanding Healthcare Marketplace• Linux and Shell Scripting• Understanding of HADOOP, HIVE, YARN• Map Reduce and HDFSIllustrative Experience : Specializing in Healthcare Analytics from a Data driven Application Development perspective in HADOOP frameworkEnd to End ETL process development complying PHI and NON-PHI standardsBuilding Interactive Tableau DashboardsHealthcare Expertise :- Provider Procurement- Analyzing Pharmacy Spend- In-depth visibility on pharmacy purchasesTechnical Expertise :HIVE, SQL, python, Tableau, SSIS, Excel, SSAS, Shell Scripting, HBase, YARN

My role and responsibility included • Worked on client side in Australia for designing the consumption model as a solution architect• Data warehouse development and Dimensional Modelling• Devloping ETL packages using SSIS• Development of SSAS cube for reporting and ad-hoc analysis• Development of SSRS reports as per client’s requirements• Use of SQL, MDX for calculation of KPIs as per interest of business• Exploration of new technologies to improve the usability of data• Solution architect for designing the cost consumption model

My role and responsibility included• Gathering client’s requirements and analysis• Development of Data warehouse SSAS cube and Tabular Model for data analysis• Development of web reports using HTML5, JavaScript and CSS• Building team skills and expertise• Exploration of new technologies to improve the usability of data