Narendra S Email & Phone Number

London, England, United Kingdom

* Participated in delivery of exceptional customer experience by building relationships through proactive outreach as well as proposing appropriate products, services, and digital solutions to help customers succeed in providing appropriate Business Intelligence, and Cloud based DWH solutions.* Implemented enterprise-level Azure solutions such as Azure synapse analytics, Azure Data Factory, Logic Apps, Azure Storage Account, and Azure SQL DB.* Worked on various SSIS data transformations… Show more * Participated in delivery of exceptional customer experience by building relationships through proactive outreach as well as proposing appropriate products, services, and digital solutions to help customers succeed in providing appropriate Business Intelligence, and Cloud based DWH solutions.* Implemented enterprise-level Azure solutions such as Azure synapse analytics, Azure Data Factory, Logic Apps, Azure Storage Account, and Azure SQL DB.* Worked on various SSIS data transformations such as Data Conversion, Derived Column, Script Component, Lookup, Execute SQL Task, and various containers etc.* Used Azure Key Vault as central repository for maintaining security and referenced the secrets in Azure Data Factory and in Databricks notebooks.* Analyse, develop, and construct modern data solutions that allow Power BI visualizations utilizing the Azure PaaS services. Determine the impact of the new implementation on existing processes by understanding the present status of the application in production.* Automated the manual data reconciliation process between the different sources, increasing the data accuracy and efficiency by 90% using Synapse and ADF.* Worked in a collaborative environment to develop and implement resilient pipelines, incorporating best practices and maintaining quality assurance at every stage of the data lifecycle, while also automating deployments through CI/CD pipelines Show less

Hyderabad, Telangana, India

* Collaborate with subject matter experts, analysts, and managers to resolve data and production issues, ensuring process quality in BI and ETL Projects.* Worked extensively on building data warehouse structures, including the creation of facts, dimensions, and aggregate tables. Employed dimensional modelling techniques and utilized Star Schema and Snowflake schemas to ensure optimal data organization and retrieval.* Created complex SSIS packages using various transformations and tasks… Show more * Collaborate with subject matter experts, analysts, and managers to resolve data and production issues, ensuring process quality in BI and ETL Projects.* Worked extensively on building data warehouse structures, including the creation of facts, dimensions, and aggregate tables. Employed dimensional modelling techniques and utilized Star Schema and Snowflake schemas to ensure optimal data organization and retrieval.* Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For Loop and Foreach Loop Container for data integration and loading.* Developing Power BI, Tableau reports for large enterprise-scale clients with story-telling and multiple drilldowns that have heavy transaction data with volumes of data represented.* Used Alteryx Designer to create analytical and ETL workflows to data transformations.* Developed and Published reports and dashboards using Power BI and wrote effective DAX formulas and expressions to derive the required metrics and Key Performance Indicators (KPI’s).* Used Power Query data preparation and shaping data in editing queries like Append queries, merge queries, add conditional columns, Pivot columns, and Unpivot Columns. * Strategically analyse data to inform Decision-making processes, considering the needs of stakeholders and employing problem-solving skills to optimize outcomes.* Published Power BI reports in Power BI Services, install and configured Gateways to schedule the report datasets, and assigned required permissions to users. Show less

Hyderabad, Telangana, India

* Gathered business requirements, definition, and design of data sources, reporting solutions.* Maintained and configured packages with checkpoints, breakpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.* Responsible for defining and designing implementation of Power BI and Tableau Reports and dashboards for Technology customer success for various BI projects.* Performed detailed data analysis to determine the structure… Show more * Gathered business requirements, definition, and design of data sources, reporting solutions.* Maintained and configured packages with checkpoints, breakpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.* Responsible for defining and designing implementation of Power BI and Tableau Reports and dashboards for Technology customer success for various BI projects.* Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems for Tableau and Power BI reporting solutions.* Generated ad-hoc reports in Excel Power Pivot and shared them with the decision-makers for strategic planning using Power BI, Tableau, and QlikView.* Facilitated Cross-functional communication, translating insights into actionable business recommendations that drove informed Decision-making within the organization.* Applied the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes to develop Power BI reports & effective dashboards which provides data insights and key business insights.* Created Time-based Calculations like MTD, QTD, YTD, Running Total, Rank &, and Dynamic Columns display based on the requirement for stakeholder analysis Show less

Master'S Degree, International Business

Bachelor Of Engineering - Be