Sachin Vilas Dhotre

Deloitte Consulting USI is a global leader in consulting, providing innovative solutions to drive business transformation and growth.

• Provided advisory and implementation services for large-scale data ecosystems, focusing on data management, governance, and integration of structured and unstructured data to generate actionable business insights.
• Leveraged cloud-based, web-based, and on-premise platforms to help clients maximize the value of their technology investments.
• Performed comprehensive data management tasks, including master data management, metadata management, data architecture design, data governance, data quality assurance, and data modeling.
• Developed business solutions utilizing automation, cognitive technologies, and machine learning tools to address complex client challenges.
• Designed and optimized database queries, triggers, procedures, functions, and packages to support robust reporting and advanced data analytics.
• Delivered industry insights and analytical support through data mining, pattern matching, data visualization, and predictive modeling, resulting in impactful analysis and algorithm development.
• Authored 'thoughtware' and 'point-of-view' documents on trending topics such as cloud computing, machine learning, and the Internet of Things.
• Rapidly adopted and applied emerging technologies—including predictive analytics, cognitive analytics, and machine learning—to develop innovative solutions for client needs.
• Participated in all phases of the data delivery lifecycle, including requirements gathering, business process analysis, scripting, code deployment, enhancement validation, defect triage, and issue escalation.
• Investigated and resolved user-reported issues by identifying root causes, implementing fixes, and facilitating communication between business stakeholders, end users, and technical teams.

Tata Consultancy Services is a global leader in IT services, consulting, and business solutions, renowned for its innovation, expertise, and commitment to delivering excellence to clients worldwide.

• Designed, developed, and maintained ETL processes to efficiently extract, transform, and load data from diverse sources into the data warehouse.
• Collaborated closely with business analysts to understand data requirements, and ensure data integration aligned with business objectives.
• Created mappings and workflows using ETL tools, such as Informatica, to support robust data integration solutions.
• Ensured data quality and integrity by implementing rigorous validation and cleansing techniques.
• Automated FTP processes using Autosys jobs and UNIX scripts, streamlining data loading, and reducing manual intervention.
• Optimized SQL queries to enhance data processing performance and system efficiency.
• Documented ETL processes and maintained comprehensive records to support ongoing operations and facilitate knowledge transfer.