Shodh Singh

BUSINESS ANALYST - DATA

TATA CONSULTANCY SERVICES•  November 2022 - March 2023•  US FEDERAL GOVERNMENT

Enhanced process efficiency and data accuracy by automating backend data integration into front-end insurance forms for 100,000 users in US, reducing manual entry errors and fraudulent claims. Collaborated with cross-functional teams and business stakeholders to understand and align on business objectives, translating them into actionable data requirements and user stories. Developed data visualization reports on insurance and tax-related data, enabling key stakeholders to track behavioral changes, facilitating data-driven decision-making for policy adjustments. Analyzed financial data to optimize SQL queries & data models by streamlining joins and indexing, improving data accuracy, reducing processing time by 30% for faster decision-making. Performed quality assurance audits and defect analysis on data pipelines, enhancing overall system reliability and user satisfaction by debugging and optimizing batch jobs. Provided detailed documentation of database architecture and processes for new team members, updated status on Azure Boards (Azure ADO) and build alignment with Eng and data teams.

DATA ENGINEER

TATA CONSULTANCY SERVICES•  August 2021 - November 2022•  GSK

Automated ETL processes, reducing manual workload by 39%, and improving the efficiency of data pipelines critical for product development. Developed and implemented data models that supported business intelligence and product decision-making for GSK's data products. Created Clinical Trial dashboards and reports using PowerBI to track key business metrics and provide key insights, driving strategic decisions within the organization. Responsible for cleaning, curating, and storing millions of records to improve dashboards consumed by business teams. Leveraged VOC (Voice of Customer) data for qualitative analysis, presented actionable insights to business teams to drive informed decision-making. Developed complex queries to ensure accessibility while optimizing the performance using Azure Databricks, Blob storage and Azure Synapse. Designed entity-relationship diagrams and data mappings for different databases, helping find the source of the target data.

ENGINEERING INTERN

NEURAPSE TECHNOLOGIES•  August 2020 - January 2021

Developed a chatbot for website engagement using Google's Dialogflow and Flask framework, enhancing user interaction and support. Conducted data analysis and visualization reports for student data, providing valuable insights for product and business decisions.