Ch Ram

Experience

• 

  VCARVE

  Jun 2019 - Jan 2021

  Data Analyst

  • Created many complex Queries and used them in Power BI Reports directly to generate reports on the fly.• Working as SQL Server Analyst / Developer / DBA using SQL Server 2008 for Atlas Data warehousing Project. • Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS), • Actuarial Data Mart (ADM), Reference DB according to the user requirements. • Source Controlling, environment specific script deployment tracking using TFS • Export the current Data Models into PDF out of Erwin and publish them on to SharePoint for various users • Developing, Administering, and Managing corresponding databases: Consolidated Data Store, Reference Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart • Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain Physical Structures. Show less

• 

  Solv4x.ai

  Jan 2022 - Apr 2022

  Data Engineer-Student intern

  • This project flow is to extract the data from PJM website about the history of the Power generation by different sources and create a forecasted model to show case the trends of power generation and utilization. • Created a Machine learning model which can understand the trends and create a forecast for next day. With these trends create a dashboard and submitted to the client where they can understand the power generation by different sources and utilization.

• 

  MNP

  Dec 2022 - now

  Data Engineer

  In our current setup, we've meticulously crafted workflows using Informatica to seamlessly extract data from a diverse range of sources, including structured/unstructured files and SQL server tables. These workflows, scheduled at different intervals, undergo various transformations before updating designated target tables and files, orchestrated by the Argent scheduler. Now, presented with the opportunity to embrace Azure's cloud services, such as Azure Data Factory, Azure Data Bricks, Blob Storage, Key Vaults, Azure DevOps and Logic Apps, we're aiming to migrate and optimize these workflows onto Azure. This shift would not only involve adapting the workflows for the cloud but also configuring them to smoothly integrate with Azure's tools. The goal is to unlock the advantages of cloud scalability, efficiency, and integration while ensuring the uninterrupted flow of our crucial data processing activities.Working for one of the porvincial regulator to migrate their project from on premise to cloud systesms Show less