Summary
Overview
Work History
Education
Skills
Father'sname
Projectsexecuted
Personal Information
Certification
Languages
Websites
Timeline
Generic
Binoy Sarma

Binoy Sarma

Hyderabad

Summary

Detail-oriented Data Engineering Consultant specializing in data modeling and ETL solution design. Achievements include enhancing code compliance and engineering reviews, resulting in a 20% increase in project efficiency. Recognized for rapid prototype design and logistical planning skills, consistently delivering projects ahead of schedule. Dedicated to integrating environmental sustainability into data solutions while experienced in designing HDL and LDL documents.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Data Engineering Consultant

Optum Global Solutions India Pvt.Ltd.
Hyderabad
06.2018 - Current

Associate Consultant

HCL Tech Ltd.
Hyderabad
11.2014 - 06.2018

IC (SO2)

Microsoft India (R & D) Pvt. Ltd.
Hyderabad
01.2012 - 10.2014

Senior DBA

Interglobe Technology Pvt Ltd.
Gurgaon
10.2009 - 01.2012

DBA

Tech Mahindra Ltd.
04.2009 - 10.2009

Software Engineer

Accenture Service Pvt. Ltd.
Hyderabad
04.2007 - 03.2009

Associate Programmer

AKS Software Ltd.
South-Delhi
12.2005 - 03.2007

Education

MSc - IT

Visva-Bharati University
01.2004

BSc - Chemistry

Gauhati University
01.1999

HSSc - Sc

AHSEC
01.1994

HSLC -

SEBA
01.1991

Diploma - Software Engineering

APTECH education Ltd.

Skills

  • Code compliance
  • Environmental awareness
  • Rapid prototype design
  • Logistical planning
  • Environmental inspection
  • Engineering reviews
  • Data Security

Father'sname

Late Shambhu Nath Sarma

Projectsexecuted

  • Quality Service of Members Compliant Data for STAR Ratings, United Health Corporation (UHC), Azure Data Factory, Snowflake, Azure SQL Server, Azure DevOps, GitHub, Collecting Members information to make them compliant for STAR Ratings., Collecting user requirements and converting to technical stories., Designing the solution and working with the business on acceptance., Defining the pipeline for correct data sets and removing duplicate., Designing a process to track Data Lineage for Master data., Working with Enterprise Security team to apply Security Standards.
  • Meta Data Management of Medical Records, United Health Corporation (UHC), SSIS, Power-BI, HIVE, SQL Server, SPLUNK, A meta data management of medical record related to health claim system., Gathering user business requirements and designing the solution., Developing and deploying a Dashboard on Power-BI., Developing a Dashboard for log analytics using Splunk., Migrating Hive queries to Spark for better performance.
  • An SME of SQL Server DB and SSIS/SSRS, HCL Tech Ltd., SSIS, SSRS, SQL Server, Azure-SQL, Multiple roles as an SME., Guiding team members on various issues., Migrating SQL Databases to Azure from On-premises., Decommissioning both database and application servers.
  • OM (Order Management), Microsoft Enterprise Commerce IT, SQL Server, .Net, MS-BI Tools, Application owner for Service operation., Coordinating with Business Team and service engineering teams., Working with different vendors on coordination and deliverables., Planning for all releases and maintenance windows.
  • STAR DATA MART, SITA, ER Studio Data Architect, Oracle 11g, ODI, A Data Mart Solution for Aviation Industry., Gathering user business requirements., Interpreting requirements and converting to a logical data model., Designing the data flow for Data Mart population.
  • Senior DBA Role, AIR India Express, SQL Server, SSIS, SSRS, Taking care of the DB infrastructure of AIR India Express., Confirming the availability of the DB, its security and performance., Working on data center migration and DB Upgradation.
  • DBA Role, D2hLtd., SQL Server, Windows, Taking care of the DB infrastructure for D2H ltd., Setting up the infrastructure for database., Setting up windows clustering for high availability.

Personal Information

  • Passport Number
  • Date of Birth: 10/01/75
  • Gender: Male
  • Marital Status: Married

Certification

  • DP-203 (Microsoft Certified Data Engineer)
  • AHM-250 (US Health Care)

Languages

English
First Language
Hindi
Proficient (C2)
C2
Spanish
Beginner (A1)
A1

Timeline

Data Engineering Consultant

Optum Global Solutions India Pvt.Ltd.
06.2018 - Current

Associate Consultant

HCL Tech Ltd.
11.2014 - 06.2018

IC (SO2)

Microsoft India (R & D) Pvt. Ltd.
01.2012 - 10.2014

Senior DBA

Interglobe Technology Pvt Ltd.
10.2009 - 01.2012

DBA

Tech Mahindra Ltd.
04.2009 - 10.2009

Software Engineer

Accenture Service Pvt. Ltd.
04.2007 - 03.2009

Associate Programmer

AKS Software Ltd.
12.2005 - 03.2007
  • DP-203 (Microsoft Certified Data Engineer)
  • AHM-250 (US Health Care)

MSc - IT

Visva-Bharati University

BSc - Chemistry

Gauhati University

HSSc - Sc

AHSEC

HSLC -

SEBA

Diploma - Software Engineering

APTECH education Ltd.
Binoy Sarma