Rohit Nath Nallam

•Designed and integrated employee resource and building access data using advanced snowflake schema techniques, ensuring optimal data structure and performance.

•Developed robust ETL pipelines within Azure Synapse, transforming raw data sources into structured silver and gold level tables in AZURE SQL for streamlined data access and management.

•Enhanced corporate office insights by enabling BI tools to leverage campus-level utilization data, providing critical insights into office space usage and access frequency.

• Built and managed data tables. Stored procedures and views in MySQL for business reporting requirements.
• Constructed ETL pipelines using Python and R for business automation.
• Visualizing sales transactional data on Tableau to accomplish descriptive data analysis for airline flight data and Corporate customer ticket/coupon transactional data.
• build UI apps on in-house CRM software(Optymyze).
• Supported in migration of MySQL to Snowflake cloud.

•Performed technology tool option analysis to find the right products/services for client as per the needs for data orchestration.

•Identified processes and drafted the RACI matrix for all the data assets within the fabric to improve efficient data sharing.

•Crafted business reporting dashboards tailored for diverse teams, leveraging both Tableau and Power BI to provide actionable insights.

•Spearheaded the transition of the Tableau data transformation layer to Snowflake. Engineered database views within Snowflake to significantly enhance query performance and reduce refresh durations.

•Delivered substantial savings for the client by constructing granular views and visualizations in Snowflake. This enabled precise tracking of each query's cost and duration, facilitating the identification and refinement of production queries for optimization.