Open to opportunities

priyanka samal

@priyankasamal1

Message

Detail-oriented BI Developer with 15 years of experience in data solutions.

United Kingdom

Message

What I'm looking for

I am looking for a role that challenges my skills and offers opportunities for growth in a collaborative environment.

I am a detail-oriented and results-driven BI Developer with over 15 years of experience in designing, developing, and maintaining end-to-end business intelligence solutions. My expertise lies in data modeling, ETL development, and creating insightful dashboards and reports using tools like Power BI and SSRS. I have a proven track record of transforming raw data into actionable insights that support strategic decision-making.

Throughout my career, I have successfully designed and maintained over 100 ETL workflows, migrated numerous SSIS packages to Azure Data Factory, and developed Power BI dashboards that significantly reduced reporting cycles. My technical skills include proficiency in SQL, DAX, and various databases, along with experience in cloud platforms like Azure. I am passionate about leveraging data to drive business success and have mentored junior developers to foster a collaborative and innovative work environment.

Experience

Work history, roles, and key accomplishments

Current

SQL | Power BI Developer

Current

Group One Automotive

Sep 2018 - Present (6 years 11 months)

Designed over 100 SSIS packages to automate data integration from various sources, including SQL Server, Oracle, and APIs. Developed 50+ Power BI dashboards and paginated reports, improving decision-making in Operations, Marketing, and OEM departments with automated data refresh via gateways. Also, a Microsoft 365 admin to grant Power BI Group access to the new users as required.

SSIS Power BI SQL Server Oracle Azure DAX PowerShell Git Azure DevOps

BI Developer

Agile Solutions

Nov 2017 - Present (7 years 9 months)

Built custom Power BI dashboards tailored to client KPIs and operational business intelligence requirements. Developed SSRS reports incorporating charts, sub-reports, and dynamic parameters for client finance teams. Collaborated in daily stand-ups, sprint planning, and retrospectives in Agile development cycles.

Power BI Agile Data Visualization Stakeholder Management UAT

Associate

PWC

May 2015 - Present (10 years 3 months)

Designed ETL data mappings using SSIS and integrated logic into dimensional models and star schemas. Delivered SSRS reports covering tax, audit, and compliance use cases with daily SLA adherence. Maintained JIRA-based sprint backlogs, priorities, and status updates for each module release.

ETL SSIS Dimensional Models Star Schemas Jira UAT

Software Engineer

Capgemini

Jul 2010 - Present (15 years 1 month)

Designed and deployed SSIS packages to support nightly ETL pipelines across billing and CRM systems. Developed stored procedures, triggers, and constraints for Oracle and SQL Server transactional systems. Automated DQM (Data Quality Management) tests with alerts using internal frameworks and scheduled batches.

SSIS ETL SQL Server Oracle Stored Procedures Data Quality

Education

Degrees, certifications, and relevant coursework

CMR Institute of Technology

Bachelors in Engineering, Computer Science

2006 - 2010

Completed a Bachelor's in Engineering degree in Computer Science. The curriculum covered fundamental computer science principles and practical applications.