Data Engineer/ Data Analyst/ Business Analyst

ROHIT

ad4qcg@r.postjobfree.com

https://www.linkedin.com/in/rohit-v-21aa982ab/

+447*********

London, E12 6SL

Skills

• SQL (SQL Server, MySQL, PostgreSQL)

• Azure Data Factory (ETL, Apache Spark, Informatica)

• Tableau

• Excel (VLookup, Conditional Formatting, Pivot

Tables)

• Microsoft Azure (DataBricks, Azure Data Lake, Azure Data Warehouse)

• Azure Synapses

• Microsoft Power BI

Work Experience

DATA ENGINEER – Infinity Business Solutions September 2022 – December 2023

● Responsible to the technical and functional requirements of the business by carefully reading the specifications and taking suggestions from Stakeholders.

● Analyse, design, and build modern data solutions using different Azure PaaS service to support Data modelling, engineering, database design.

● Created schedule triggers to automate Data factory and Synapses pipelines, also used data factory to schedule data bricks notebooks notebook activity.

● Developed ADF pipelines to performing data cleaning, event enrichment, data aggregation, de-normalization and data preparation needed for BI reporting.

● Worked on Azure DevOps and CI / CD to automate ARM deployments.

● Successfully designed, implemented, and managed data integration projects using Informatica Intelligent Cloud Services (IICS), specializing in ETL processes, real-time data integration, and cloud data warehousing.

● Demonstrated proficiency in data governance, quality management, and metadata management utilizing Informatica Data Management Cloud (IDMC), ensuring data integrity, establishing governance frameworks, and providing comprehensive metadata solutions.

● Worked on user access control, and Azure Key vault to secure keys and passcodes.

● Created story telling dashboards using Power BI Desktop and published into Power BI services, and automated reports using gateways.

● Implemented and developed new reporting solution to allow operations and financial users to have access to Power BI reports, used DAX, Power Query.

● Published the reports, Create and Manage groups, Users, workspaces, Data sources and data connections in the Power BI services.

● Created complex Stored Procedures, Functions, designing and implementing of Database Triggers (DDL, DML), Views and designing and implementing Indexes.

● Proven ability to thrive in fast-paced, fast-growing environments, utilizing strong verbal communication skills and analytical thinking to drive data-driven decision-making, while demonstrating expertise in software testing, including SAP, Oracle, and Anaplan applications, ensuring responsive and detail-oriented solutions for complex problems in product and market growth scenarios.

DATA ENGINEER – Trust Financial Corp. November 2019 - December 2020

● Collaborated with Stakeholder to understand data structure to design an ETL pipelines on ADF which automated extraction of different types of data like .JSON, .XML and excel file from different source systems including on premises SQL.

● Design and create ETL pipeline using Azure Data Factory to automate extract data from local database, transform and load data into Azure SQL Data Warehouse.

● Worked on reusable Pipelines to maintain the data consistency. It compared the source and target after the ETL loading is complete to validate no loss of data during the ETL process and data movement from OLTP to OLAP.

● Implemented data streaming capability using ADF Tumbling Window triggers for multiple pipelines to process data for OLTP source system to OLAP.

● Develop and maintained BI models to design, develop and generate both standard and ad-hoc reports using Power BI and published reports into Power BI services.

● Used Power BI to develop data analysis prototype, and used Power View and Power Map to visualize reports, created RLS to restrict users access to the data.

● Implemented Complex business logic with User-Defined-Functions, Index Views and created User defined Data type, Clustered & Non-clustered Indexes.

BUSINESS INTELLIGENCE DEVELOPER– Comcast April 2019 - November 2019

● Gather requirements for data collection, transformation requirements and build report prototypes accurately after gathering requirements from stakeholders.

● Developed storytelling reports using Power BI, Tableau and published them into Services, which allowed end users to understand the data and insights.

● Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI and SQL databases.

● Developed Complex dashboards and used advanced chart visualizations in Power BI, Utilized Power Query to Unpivot and Pivot the data model for data cleansing.

● Written complex SQL statements to create joins, views, procedures, index’s, triggers which serve business needs and to support BI solutions.

● Utilized collaborative problem-solving and teamwork in deploying PowerShell scripts to ensure compliance and optimize cloud infrastructure.

● Strong problem-solving abilities demonstrated through collaborative work on complex data projects.

● Provided supporting on the existing Power BI reports to improve the performance.

● Performed data analysis required to troubleshoot data related issues and assist in the resolution of data issues by presenting data and business insights in reports.

● Experienced in conducting interviews, innovating solutions, and proficient in coding and analytics, with advanced proficiency in software development, R programming, and leveraging Microsoft Excel and PowerPoint for comprehensive data analysis and presentation.

● Spearhead operational improvements and implement best practices in fintech and finance domains.

● Provide strategic recommendations for product enhancement, conduct consumer interviews, and manage legal compliance while leveraging computer science expertise for application development. Education

MASTER OF SCIENCE IN DATA SCIENCE AND ANALYTICS – University of Hertfordshire – Hatfield, UK February 2023 Majors: Business Analytics, Data analysis, Data Mining, Python, Data Visualization, java BACHELOR OF SCIENCE IN ELECTRINICS AND COMMUNICATION ENGINEERING – Vardhaman college of Engineering

– Telangana, India April 2019

Certification

DP-203: Azure Data Engineer.

DP-300: Microsoft Certified Power BI Data Analyst.

Contact this candidate