Experienced Developer with 10 + years of experience in creating programs based on specific requirements. Adaptable, diligent and knowledgeable in Microsoft Power BI,ETL Testing and Azure Data Engineer.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Microsoft Power BI Developer
Epsilon
06.2023 - Current
Collaborated with stakeholders to define project objectives and criteria.
Interacted with internal customers to understand business needs and translate into requirements and project scope.
Generated business intelligence reports to inform strategic decision-making.
Collaborated with stakeholders to identify business needs and data sources.
Developed customized reports, summarizing and presenting data in visually appealing format.
Provided technical support for troubleshooting analytics and reporting issues.
Generated standard and custom reports to provide insights into business performance.
Developed complex dashboard and reporting tools to track business performance metrics.
Utilized data visualization techniques to present and explain complex data sets.
Updated and developed scripts and queries to extract and analyze data from multiple sources.
Assisted with creating data cubes and OLAP models to improve data analysis.
Power BI Developer and ETL Testing
Zek Systems India Pvt Ltd
04.2019 - 01.2022
Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
Published Power BI Desktop to the cloud.
Created interactive reports customized for the business using Power BI Desktop.
Installed and configured and maintained Power BI Report Server.
Developed SQL Scripts to validate the data after the loading process.
Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
Involved as primary ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software.
Prepared Data Mapping Documents and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
Azure Data Engineer/Infrastructure Specialist
Atos India Pvt Ltd
05.2012 - 03.2019
Created reusable pipelines in Data Factory to extract, transform and load data into Azure SQL DB and SQL Data warehouse.
Developed transformation and loading logic in Data Factory, Databricks and Stored procedures to integrate data from multiple sources to MS SQL Server in cloud.
Created Pipelines in ADF using linked services/datasets/Pipeline/to extract, transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data Warehouse, write -back tool and backwards.
Developed JSON scripts for deploying the pipeline in Azure Data Factory that process the data using the SQL Activity.
Utilized Azure Databricks to transform data using Python.
Provisioning and managing of ADF jobs and managing Integrated Runtimes.
Demanding / canceling/ Holding a job / job stream. Late Job analysis and Modifying Predecessors, successors, time conditions accordingly.
Performing various actions in Autosys, like force-starting, and marking the job to success, changing the job status to on hold, on ice, terminating and killing the job.
Follow the documentation for the jobs failed and action to be taken accordingly, handling all ad hoc requests Escalating, re-assigning, and resolving Incident tickets on Remedy.
Education
Bachelor of Science - Computer Science
Visveswaraya Technological University
Belgaum
08.2009
Skills
Power BI Desktop
Power Query
Power Pivot
Power BI Reports
Power BI DashBoards
Power BI Services and Gateway
DAX
SQL
Azure SQL
Azure Data Factory
SSIS,SSRS
Python
unix
Autosys, Remedy, IBM Tivoli, Autosys, BMC Remedy and Service now