mahender Kadari

Im recently graduated ,actively looking for the job 

A dynamic and skilled BI Developer, ETL & Data Engineer, and Analyst with 2 years of extensive IT experience. Highly proficient in data cleansing, data transformation, data analytic and visualization, as well as extracting and manipulating data from RDBMS. Provide clients with optimal solutions and insights into their business by leveraging industry leading BI tools. I am results-oriented with the ability to deliver measurable results and enhance organizational growth.

• Strong knowledge of data warehousing concepts and data modelling techniques such as dimensional, star schema and snowflake modelling in Kimball methodology.
• Commercial hands-on experience in building end-to-end meta driven pipelines using ADF, Synapses.
• Sound knowledge and experience in design and building story telling reports, dashboards that provides data and business insights at a glance using Tableau and Power BI.
• Hands on experience on migrating on premises SQL database into Azure SQL Database, and implement Data Lake solutions end-to-end, and migrate SSIS packages into Azure.
• Strong knowledge and experience in gathering requirements from technical and functional users, and conducting workshops, give presentations, and conduct user training sessions.

Technologies

Azure: ADF, Synapse, ADLS, Storage, Logic Apps

Databases: SQL Server, MySQL, Oracle

ETL: Azure Data Factory, Synapses, Alteryx

Reporting & BI tools: Power BI, Tableau

Professional Experience

Client: Cognizant Technologies, India from April 2022 to Dec 2022

Roles and Responsibilities:

• Worked with management and stakeholders to gather and review business requirements, and then translate them into clear and concise specifications and deliverables.
• Designing and implementing data integration solutions using Synapse and Data Factory to move data between various data sources, including on-premises and cloud-based systems.
• Worked on ARM templets to deploy in ADF pipelines to production using Azure DevOps.
• Used Data Factory Dataflows to build ADF data flow pipelines. Improved performance by using optimization options by effectively using partitions during various transformations.
• Built Data pipelines using ADF to extract, transform and load data from different sources like storage account, ADLS, files like. JSON, .XML, Parquet, .CSV to Azure SQL DB.
• Automated pipelines deployments from Dev to Test and Test to Prod using CI CD.
• Automated ADF pipelines and Synapse notebooks using various data factory triggers.
• Used Azure Key vault as central repository for storing, maintaining secrets and referenced the secrets in Azure Data Factory and in Synapses notebooks.
• Keeping up to date with emerging technologies and best practices in data engineering, and applying them to improve data processing efficiency, scalability, and reliability.
• Developed Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to different user groups in the organization.
• Interpret data and analyse results using various techniques to provide ongoing reports and actionable data and business insights using Tableau and Power BI.
• Track performance weekly in key doors and programs and communicate to teams to quickly.
• Worked on Power BI services to manage users, and schedule reports, provide maintenance.

     Environment: ADF, Data Lake, Blob, Azure SQLDB, SQL Server, Power BI, Synapsis 

Client: Rajasri Technologies, from October 2021 to March 2022

Roles and Responsibilities:

• Work cross functionally with analysts, business insights, report developers, and stakeholders to ensure a tight Development/QA/UAT process and quality deployments.
• Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different data sources like Excel, SQL Server, Csv, CRM Systems using ADF.
• Designed and implemented end-to-end data solutions on the Azure platform, utilizing Azure

Data Factory, Azure SQL Database, Azure Synapses, and Azure Data Lake Storage.

• Used Power BI, Power Pivot, Power Query, Custom Invoke Functions, Blank Query to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Designed and developed quality Power BI reports to clients by conducting quality assurance checks and recorded a 70% increase in controlling the orders transactions.
• Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Developed Power BI reports for large enterprise scale clients with story-telling visualizations.
• Worked on DAX to create calculated measure, column, and variable to extract the required metrics, KPI’s that shows business trend, pattern, and provide insights.
• Use data Power BI, and Tableau visualization tools to provide a user friendly, easy-to-understand interface for end users to quickly identify key themes within their data.
• Used Power BI service, and Azure Active Directory to create and manage user and control user access using Row Level Security, implemented auto schedule refresh on reports.

Environment: ADF, Data Lake, Blob, Azure SQLDB, SQL Server, Power BI, Synapsis, ETL

Education:

•  Masters of Computer Science Northumbria University, London

Masters In Computer Science