LAXMAN RANGAPUR

Streamlined the extraction, transformation, and loading (ETL) of large financial datasets from Azure and Snowflake, ensuring seamless data integration and system performance. Designed and delivered detailed cost reports for executive leadership, employing advanced Excel and Tableau analytics to provide actionable insights. Spearheaded the cross-validation of financial data using Azure Cost Management, rectifying mismatched cost centres to enhance reporting accuracy by 20%. Developed and optimized complex SQL queries, creating dynamic tables and views for daily ad hoc financial analysis. Created interactive Tableau dashboards, enabling real-time visualization of cloud cost breakdowns and trends for decision-making. Conducted critical analysis of raw billing data, addressing discrepancies and ensuring compliance with reporting requirements. Applied in-depth knowledge of cloud economics to identify inefficiencies, reduce cloud costs, and deliver detailed variance analyses.

Led the Contact Merge project, identifying and merging over 1.1 million duplicate customer records, resulting in improved data quality and integrity. Built data pipelines using Azure ADF and Databricks to process and transform high-volume customer data, ensuring real-time data availability and reducing data latency by 30%. Analysed customer data to create reports and Power BI dashboards that provided critical insights into customer behaviour, improving decision-making for marketing and customer support teams. Conducted thorough data validation and cleansing to maintain data accuracy, leading to a 13% improvement in data quality. Developed and optimized complex SQL queries for better data retrieval and reporting efficiency. Collaborated with cross-functional teams, ensuring the seamless integration of data from various sources into a central database. Automated data processing workflows, reducing manual data handling time by 40%.

Managed the CWB ESG project, developing data-driven ESG reporting tools that tracked key sustainability metrics for regulatory compliance. Created an ESG DataMart and developed ESG KPIs benchmarking using data from S&P and Idealratings, improving data accessibility and analysis. Built automated reporting dashboards in Power BI, enabling real-time visibility into ESG performance and compliance. Worked closely with stakeholders to ensure that ESG data reporting met regulatory standards and improved transparency. Analysed and cleansed large datasets to improve the accuracy of ESG reporting, leading to better business insights. Managed the data migration of SCB’s on-premises data warehouse to Microsoft Azure Cloud, improving scalability and reducing operational costs by 25%. Developed data pipelines to integrate diverse data sources into the cloud, enabling real-time analytics and reporting. Collaborated with cross-functional teams to ensure seamless data integration and migration to Azure, reducing downtime by 20%. Utilized machine learning algorithms to optimize ATM cash management, analyzing over 12 million data points to improve cash forecasting accuracy by 30%.

Conducted in-depth data profiling of steam turbine performance datasets, identifying and addressing data quality issues to improve operational reporting accuracy. Performed data cleansing and validation processes to ensure accurate and reliable data for performance analysis and reporting. Collaborated with cross-functional teams to enhance data models and automate key reporting processes, improving efficiency by 30%. Provided data insights to support root cause analysis and predictive maintenance efforts, reducing downtime and improving overall turbine performance.

Taking Part in developing CAD automation tools for product designing and smart calculation tools using Excel VBA and achieved 100% of Project OTD.