Anurag Sharma

Experience

• 

  L&T Infotech

  Sept 2011 - Oct 2014

  Senior Software Engineer

  Requirement gathering, converting Business requirements into Analytical requirements. Involved in interactions with Business Analysts, Client team, Capacity planning and Up gradation of current systems.Creating visually appealing dashboards in Power BI and Tableau. Advanced Excel Ad-Hoc Reporting using Power View with Analysis Services OLAP Cubes. Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert, Fast Load and B-Teq. Programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2008/2012 with T-SQLHandled interactions with business stakeholders, gathered requirements and delegated activities to the offshore development team as the Onsite coordinator. Successfully delivered bug-free solutions and supported client teams for UAT. Trained and assessed the new joiners’ batch in the organization on Data-warehousing Fundamentals and MSBI.Managing successful large-scale Data Warehouse and decision support systems in BFS, Retail and MIS Domains. Verifying Data Mappings and Business Rules for transformation and Loading of data. Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team.• Received GEM(Going Extra Mile) Award–L&T InfoTech (July 2013)• Received Annual Individual Performance Award - L&T InfoTech (Dec 2013) Show less

• 

  PwC

  Nov 2014 - Sept 2016

  Consultant

  Pioneered the development of Dashboards and Multilevel Graphical Drill-through Reports forvarious projects, leading to cross-selling of BI Solutions along with the ERP Implementation.Designed User Friendly Retail Ad-Hoc Reporting framework for Business Stakeholders therebyeliminating lags in reports’ rendering and dependency on IT Team for day to day analysis.Exploratory analysis of data to apply suitable statistical techniques for data modelling.Understanding how findings affect business goals and delivering actionable insights to leaderswith effective visualizations. Developing Advanced Analytics solutions reflecting management &customer requests. Advising and improvising on the suitability of methodologies and suggestingimprovements related to overhauling and optimization.Using ARIMA model and Power BI visualizations to implement Budget Management and SalesForecasting systems for Branch/Product Managers. Implemented demand forecasting modelswhich improved upon forecast accuracy and reduced supply chain inefficiencies. Using SupportVector Machines and Decision trees for classification problems. Using word maps and sentimentanalysis from the CRM data. Show less

• 

  EY

  Sept 2016 - Oct 2017

  Senior Analyst

  Part of the advanced data analytics team within EY GDS working with global practice offices, primarily focusing on UK&I region. Adding value by Impactful analyses and forward-thinking strategies.  Lead several Activity Based Costing engagements. Baseline and allocate various costs in the supply chain, Sensitivity model for optimization of trade terms across geographies.  Developed a scalable financial pattern recognition model in R to detect anomalies in Trial Balance line items, to highlight Management Questions based on predefined and abrupt patterns  Various Transactions Support projects to analyze balance sheets, P&Ls and Trial balance data for acquirer and target. Storytelling dashboards to raise management questions and steer the discussions  Web scraping data from financial APIs like Thomson Reuters, APQC, Capital IQ and Yahoo finance working with the Transaction Pursuits team for benchmarks, financials, analysis of Beta returns  Replicating a core banking system for 4 products in Alteryx to create a shadow calculator for reconciliation and testing. Show less

• 

  Fractal Analytics

  Oct 2017 - Jun 2021

  Senior Consultant

  - For a government agency, on-premise application to enable digitisation of physical documents through custom DL algorithms and merge with structured inputs that gets fed into a cognitive AI engine to answer queries in natural language.- Strategic consulting to ANZ Telecom major for simplification of organisational KPIs and data governance roadmap.- Worked closely with a central government agency and global funders utilising digital data to tackle India’s nutritional challenges. The analysis helped central and state level government leaders identify hotspots of laggard service delivery and prioritize most influential factors of change.- For a Central Government Agency: utilising unstructured data to cluster people and organizations based on similar businesses. Developed solution helped the client to understand the types of businesses mentioned by users in their textual justifications, as well as the total amount of cash involved in each such business- Created an on-premise solution to standardize and map ~40M addresses without dependency on any external APIs for a Central Government agency.- Market Mix Modelling for a leading Toy manufacturer. Analysed the drivers of value sales for B&M and Online channels for three Brands. Quantified the contribution of price, distribution, media and trade promotion activities to value sales and thus calculating the potential return on investment for efficient marketing budget allocation. Show less

• 

  Everwell Health Solutions

  Jun 2021 - now

  · For one of the world’s largest digital health systems, I act as the primary liaison for clients and partners (donors, funders, government, tech partners) to meet budgets and timelines; refining requirements, tech solutioning, while managing internal team allocations. Represented organizational work at summits.· Led Spark ETL development, reducing data replication time by 70%; established self-serve BI with Apache Superset; democratized the tool from 20 core group members/stewards to 500 daily users.· Directed the production integration of 2 AI/ML models utilized by over 500,000 health facilities, co-designing interventions for improved patient outcomes and reducing microbiologists' turnaround time.· Linked JIRA and Git tickets via GPT+RAG app, streamlining L2 support and saving 800+ person-hours per year.· Directed initiatives that aligned Data solutions with governance frameworks (LGD, FHIR), ensuring compliance with data quality and metadata management standards. Show less

  • VP - Data Science and Innovation

    Apr 2024 - now

  • AVP - Data Engagements

    May 2023 - May 2024

  • Data Engagements Lead

    Jun 2021 - May 2023