Vivek Singh

Highly experienced Data Engineer with proven expertise in Power BI and Snowflake. Bring 5 years experience in designing data architecture, developing ETL and BI solutions, and optimizing performance. Proudly designed robust data architectures and significantly improved data load time.

• Constructed new ELT processes to move and transform data from various sources into data warehouse, reducing data retrieval time by 20%
• Collaborated with 3 cross-functional teams to design a data architecture strategy, resulting in a 40% increase in data accessibility
• FHIR resource handler and gathering/capturing resources in tabular format using snowflake. I used to hope on call with the client to understand the data structure and trend in order to incorporate the business requirement by adding different work around and technical solutioning.

• JavaScript
• Informatica PowerCenter 10.x
• Pentaho
• Matillion
• Snowflake
• MySQL
• Data warehousing
• Data modeling
• Python
• Data visualization (Power BI, Dax queries)
• Cloud platform (AWS, GCP)

• Data Engineer, It was a Product enhancement project and data Migration where I had to work on data integrity and mapping along with client's satisfaction, Interoperability Engineer, SQL, HL7, FHIR, FileZilla, WinSCP, Matillion, Python, Mirth Connect, JavaScript, XML, HTML, RestAPI, Power BI, I was able to deliver the project within the TAT. We do have bi-weekly calls with the client to validate the data and push it to Production environment. I used to work on Creating ETL/ELT pipelines, data mapping, setup, Unit testing, Prechecks and data load to ingest the data from sources and transformed for meaningful business visualization.
• Product Engineer, Primarily focused on designing and optimizing data architectures to meet the client's analytical and reporting needs., Product Engineering, SQL, Snowflake, HL7, FHIR, FileZila, WinSCP, Informatica PowerCenter, Python, MirthConnect, JavaScript, XML, HTML, I was able to deliver the project within the TAT. We do have bi-weekly calls with the client to validate the data and push it to Production environment. I was responsible for validating the vendor's specifications and creating workaround. I was taking care of connection setup using different tools. I was responsible for data implementation and Creating bridges for the client using different skills.
• Senior Integration Engineer, This is a HealthCare Claims Processing Project which involves processing of scanned Healthcare claims forms and converting it to client specified data files. Plot data into different Relational databases instance (SSMS). Processing of claims involves data capture, validation, quality check and final quality check. Manual testing of the applications required for the above-mentioned activities. This was carried out in onsite/offshore mode with average team size of 12 associates., Senior Engineer, Pentaho ETL, SQL, SSMS, HL7, FHIR resource, JavaScripts, XML, HTML, Data Mapping, Data integration, Validating the data from source, once migrated from source to stage. Worked on AWS EC2 instances for creating security groups and assigning it to different host systems. Worked on data extraction from legacy system and load them onto stage site in new system using ETL tool. Creating validation report for validating the records from source to target. Once validated, I use to create interface for the new software to the different EHRs/EMRs

• B.tech (Mechanical), WBUT
• Diploma (Mechanical), WBSCTE

Highly experienced Data Engineer with proven expertise in Power BI and Snowflake. Bring 5 years experience in designing data architecture, developing ETL and BI solutions, and optimizing performance. Proudly designed robust data architectures and significantly improved data load time.

Lead Engineer

• Snowflake for Data Engineers
• Power BI for Data Professionals
• Postman API Fundamental Certified
• Advanced SQL for Data Engineers