Pranay Sinha

Recently Joined the Data Team to Re design the SSAS Tabular Model and Closely working with USA Power BI reporting Team.

• Responsible for people Management, including goal setting and providing performance feedback.
• Team Lead under Microsoft Technology Services and Handled the responsibility to Deliver Internal Project.
• Working as Sr BI Developer & Sr Data Engineer for one of the Biggest Pharmacy and Retailer giant of UK.
• Gather Business Requirement along with Product Owner
• Built various Report and Dashboard for the Business user, which Includes Monitoring Report, Sales and MI Report, Budget and Forecast Monthly and Weekly Report.
• Created Complex Measure using DAX to Show Business Metrics.
• Worked on Creating Data Model in Azure Analysis Services.
• Implemented the Row Level Security in AAS Model.
• Created Perspective in AAS as per the Business Requirement.
• Created ADF pipeline to Refresh the Tabular Model both Dimension and Fact Table.
• As part of Modern Data warehouse Worked on Creating the Parquet File using ADF and Creating External Table and Building the AAS model using External Table to Build Power BI Report.
• Built Product Dimension and Site Dimension from Scratch in Synapse.
• Modified the Existing Store Procedure and View as Per the Requirement.
• Built all the SQL Object for the Budget and Forecast Project.
• Work on Data Mapping Document and Cube Mapping Document.

• Gather Requirement from Onsite SPOC
• Analyzed the Data quality, Data validating, Data
• Mapping to migrate data to SQL Server database
• Design the table based on Data File provided by the vendor
• Build efficient SSIS packages for processing fact and dimension tables using load strategy Like
• SCD 1, SCD 2, Moving window, Append and
• Truncate and Load
• Worked on creating a Generic Package to upload and Download the Files from SFTP and Amazon
• S3 Bucket
• Worked on creating HASH Key to using SQL
• Server and C sharp to keep the record of
• Historical Change
• Worked on creating the SSIS package to export the view data to customer at SFTP in the required file format
• Worked with different source like CSV, Text File,
• SQL server and XML
• Worked with the third party Cozyroc Custom component
• Created SQL Jobs to schedule SSIS Package
• Looking for root causes in case of solution failures
• Handling the orphan rows in Dimension and Fact tables
• Worked on SQL Server DB Table partitioning
• Created the dashboard in Power BI showing various trend and alerts
• Created Visualizations with drill down, drill through features in Power BI,
• Created various visualizations like matrix, Table,
• Card, Bar Chat, Line Chart , Area Chat , Book
• Mark etc
• Worked on Import, Direct query, composite models and Aggregated Table
• Created Incremental Flow in Power BI Desktop
• Created Workspace APP for business users to view the developed reports
• Worked on Scheduling data set refresh using
• Power BI Gateway
• Worked with streaming dataset to capture the form response and created a dashboard
• Experience in different levels of Row level security
• Implemented several DAX functions for various fact calculations for efficient data

• Gather reporting requirements from Business user
• Direct and manage all activities related to the delivery
• Provided customer with daily communication, and status updates
• Managed and resolved escalations for customer, if any
• Involve in Project security Audit and PMR

• Gather reporting requirements from Business user along with Onsite Lead
• Involved in the design and development of data
• Migration using SSIS from the healthcare application to the newly development application
• Created Various ETL using different Types of transformation to achieve the goal
• Performed testing of designed ETL Using various
• Business scenario
• Created KPI and Reconciliation report using
• SSRS to compare before and post data migration in old and new System

• Gather reporting requirements from Business user/ Customer
• Worked along with the business functionality and requirements of the new pharmacy application (eMAR) along with boots (SME'S)
• Worked on creating various types of SSRS report and their subscriptions.

• Worked as Analyst for one of the UK Based
• Pharmacy System
• Created Tables, Stored procedures, Triggers, jobs for generating extracts from SQL Server 2000/2008
• These extracts catered to various business requests from client
• Monitor the daily loads and resolve in case any job fail
• Created SSIS Package and schedule based on the business requirement using various
• Transformation Slowly Changing Dimensions,
• Look up, Aggregate, Derived Column,
• Conditional Split, Fuzzy Lookup, Multicast and
• Data Conversion
• Certification & Badges