Home

Vidit Sahoo - BI Developer

[email protected]

Location: Princeton, New Jersey, USA

Relocation: YES

Visa: H1B

Resume file: ViditSahoo_Sr BI Developer_1745268396610.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

VIDIT SAHOO PROFESSIONAL SUMMARY 13.8 years of experience in consulting, leading, managing and implementing large-scale End-to-End Data warehouse projects with major in Reporting Tools [IBM Cognos, Power BI, Tableau]. Highly result-oriented, motivated and dynamic player of change with a flair for conceptualizing, developing and implementing innovative practices. EDUCATION MS in Data Analytics, Clark University; Worcester, MA Expected May 2025 B.E. in Computer Science, GGITS Affiliated to RGPV University; India, Graduated First Class Jun 2008 CERTIFICATIONS & TECHNICAL SKILLS Certifications: IBM Cognos Analytics Author v11, IBM Cognos 10 BI Report Author, IBM Cognos 10 Administration, Microsoft Azure Data Engineer Associate, Microsoft Power BI Data Analyst Associate, Tableau 2019 Desktop Specialist, Business Intelligence: IBM Cognos Suite 8.4 to 11.1, MSBI Suite, Tableau 8.1.8/2019 Programming: Python, SQL, PL/SQL Databases: Oracle, MS SQL Server, DB2, Netezza Domain Knowledge: Telecom, Banking, Healthcare DATA ANALYTICS EXPRERIENCE Adecco Personnel Pte Ltd., Singapore, Senior BI Developer Apr 2021 Dec 2023 Client: Credit Agricole Investment Banking (CACIB) Solution Environment: Cognos 11.1, Microsoft Suite (SSIS, SSAS, SSRS {v2017} and Power BI {May 2022}) Led the team of 6 developers on Cognos Project for Singapore location and share the best practices among the Paris counterparts improving report efficiency by 20% Understanding the requirements and assisted the developers in report authorization in IBM Cognos 11.1 suite Worked on developing Counterparties KYC metrics to identify the improvement areas and reduce infra cost Build the solution spanning from extraction, loading and transformation of data based on the requirement using BeeEyes(inhouse framework used in CACIB) Develop 20+ reports using SSRS and 15+ complex dashboards using Power BI which involved RLS, DAX expressions and data modelling Performance Tuning of existing dashboards in Power BI U3 Infotech Pvt. Ltd., Singapore/Sydney, Senior Consultant Mar 2015 Apr 2021 Client: NCS Singtel Solution Environment: Cognos 10.2.2, Oracle 11g, Power BI Led the team of 5 developers and assisting them in the development Developed complex Framework Model which supported 450+ ODS Cognos reports Build 100+ reports for billing, ordering and CRM modules focusing on daily sales transactions analysis increasing customer retention by 12% 15+ complex dashboards creation on Power BI including Data level security setup Encora Technologies Pvt. Ltd., Malaysia, Cognos Consultant Jul 2014 Feb 2015 Client: Ambank Solution Environment: Cognos 10.2.1, Tableau 8.1.8, Netezza Designed 15+ BI reports using Cognos as reporting solution and tuned reports efficiency by 18 % for multiple modules within the bank Modeled dashboard for real-time KPI s to show Overall batches efficiency which helped batch loading optimization by 5 % Planned the Detailed level phase for the migration by restructuring Access Manager Security to Active Directory Groups and Migrated reports and cubes from 8.3 to 10.2.1, using the latest features of 10.2.1 KPIT Pvt. Ltd, India, Technical Lead May 2012 May 2014 Solution Environment: Cognos 8.3, Cognos 10.2.1, Oracle 11g Led the team of 7 developers and proactively performed reports optimizations by using the best practices defined by IBM resulting in 18% performance efficiency Devised Cognos Reporting Solution for manufacturing section which helped in regional sales by 14% Published 2 dashboards with key metrics on effectiveness of on-field marketing campaigns resulting in $1M savings Cybage Software Pvt. Ltd, India, Software Engineer Jul 2014 Feb 2015 Solution Environment: Cognos 8.4.1, DB2, SQL Server 2005 Implemented first certified healthcare Cognos reporting solution, that resulted in benefits of over $500K Performed data validation on patient-doctor reports identifying critical issues resulting in 10% savings Keywords: business intelligence microsoft procedural language Massachusetts