Mohanram Muthukrishnan Email & Phone Number

Coppell, TX, US

NJ, USA

• Implemented DWH solution consisting of ETLs, On Premise to Cloud Migration and expertise building and deploying batch and streaming data pipelines on cloud environment.
• leveraging features such as virtual warehouses, data sharing, and clustering to enhance performance and scalability.
• Designed and implemented partitioning strategies for large datasets within Snowflake, improving query performance by optimizing data distribution and minimizing I/O operations.
• implement SnowPipe pipelines for real-time data ingestion into Snowflake, enabling seamless and automated data loading from external sources such as cloud storage or streaming platforms.
• Use DBT to debug complex chains of queries. They can be split into multiple models and macros that can be tested separately.
• implement incremental data processing techniques in DBT to optimize performance and reduce processing time for large datasets, enhancing efficiency in data pipelines.

India

• Used Model Mart of ER win for effective model management of sharing, dividing, and reusing model information and design for productivity improvement.
• Designed SSIS packages to populate the data into MDS using staging tables and stored procedures from SQL server.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Created Data-driven Packages in SSIS as part of the automating the process for the Referral Process.
• Developed SSIS packages for data transformation from legacy claims processing systems and built Cubes from fact/dimension tables (OLAP). Ad-hoc reporting using Report Server.
• Involved in Designing, Analyzing, building, and testing OLAP cubes in SSAS and adding calculations using MDX.

India

• Writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS).
• Created Scheduled task of SSIS packages to load data from SQL server into SQL data warehouse.
• Use reverse engineering to create Graphical Representation (ER diagram) and to connect to existing database.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Developed front end web base dashboard with trending data, animated pipeline charts, and demographic charts with drill downs functions that displays a breakdown of Regional/States sales, utilizing data aggregation from.
• Migrated existing self-service reports and ad-hoc reports to Power BI

Master Of Business Administration - Mba, Operations And Projects Management, First Class

Bachelor Of Engineering (Be), Electrical, Electronics And Communications Engineering

Education record