Power Bi Supply Chain

*/*

AMOL BHASKAR SAWANT

BI Consultant Reporting Visualization

Mobile : +91-992******* E-mail : *********@*****.*** Address : 701/A Vanashri CHS, Vazira Naka, Borivali West, Mumbai – 400 091 With over 20+ years of experience in the technology industry, I am a seasoned BI Architect and Technical Lead with a proven track record of designing, implementing, and managing database solutions, across domains like Retail, Manufacturing/Supply Chain, Logistics, Pharma, Hospitality/Services, Banking. My core expertise includes MS-SQL(SSMS/SSRS/SSIS/SSAS), MS-Power BI, Azure cloud platforms (ADF, Azure SQL

/Synapse), DBT-Snowflake (intermediate). Exploring new data analytics cloud platform MS-Fabric & Databricks. As BI Consultant, looking forward to leveraging my experience and enthusiasm for Data Management/Engineering & Visualization to contribute meaningfully to organization’s success in data and analytics platforms PROFESSIONAL SUMMARY

As a Project Lead

o Collaborated and coordinated with cross-functional teams like IT & operations, stakeholders, and vendors to ensure the smooth development and functioning of the entire database structure o Analyzed business processes, reporting requirements & pain points in the existing environment o Designed, Developed & implemented organizational data strategy with thorough understanding of legacy data source systems. Document end to end data mapping flow (data dictionary) o Followed systems development life cycle, project management techniques, design, and testing procedures

o Empowered & encouraged team to adapt problem solving approach as well as share, learn & unlock experience/ knowledge

As Tech lead

o Leveraged expertise in data modeling using tools like Erwin/SQL Power Architect/Visio to design conceptual data model, define entities and their relationships o Utilized SQL SSMS and database programming language to design ETL scripts to load & process source data into ODS/data marts

o Analyzed and optimized data processing workflows to enhance speed and insight generation using performance optimization functionalities/tools like Explain Plan /SQL Profiler o Assisted team in identifying and resolving production and application development problems o Demonstrated hands-on expertise in database programming, Azure Cloud, Azure SQL/Synapse, snowflake with extensive experience in MS-SQL technologies (SSMS/SSRS/SSIS/SSAS) and Power BI reporting tool

o Designed ADF pipelines, Dataflows, Data Models & interactive dashboards o Executed data modeling for OLAP, dimensional, structures to support organizational analytical reporting needs

o Utilized deep knowledge of relational databases (SQL Server, Oracle, PostgreSQL) for managing structured data

o Managed Power BI workspaces, user access & data gateway configuration for on-premises databases

As Data Manager

o Managed Loyalty Points Redemption programs by performing data analysis and designing Operational/MIS reports/Dashboards in MS-BI tools (Excel, Power BI). Developed point statement paginated reports in SSRS & automated process thru SSIS packages in SQL Server PROFESSIONAL CERTIFICATION

Microsoft Azure Data Fundamentals (DP-900)

MCDBA – Microsoft Certified Database Administrator

Oracle 9i DBA – Oracle Certified Professional (OCP) CERTIFICATION COURSES COMPLETED

Complete Database Design and Modelling

Pipelining data with Azure Data Factory, Azure Data Lake

MS Azure Fundamentals AZ-900 Certification

Advanced Power BI & Data Modelling with DAX

Power BI Essentials & Power BI Complete Introduction - 2020 Edition

In Progress

o Databricks Certified Associate Engineer

o Data Engineering with Snowflake DB

o Azure Data Studio

2/3

TECHNICAL SKILLS

Cloud : Azure SQL/Synapse, Azure Data Factory, Snowflake, Databricks (beginner)

RDBMS : SQL Server, PostgreSQL, Oracle8i/9i, My-SQL

BI Reporting/ETL Tools: MS Power BI, MS-SSRS/SSAS/SSIS, MS-Excel, Tableau, Crystal Reports 11

Data Modelling Tools : SQL Power Architect, Erwin, Visio

Version Control/Tracking Tools : Visual Source Safe 6, MS Projects, SharePoint 2007

Loyalty Platform : ConnectRM, Smart Button - ALP SaaS (AWS cloud base) EDUCATION

Bachelor of Science – Mumbai University, 1994

ACHIEVEMENTS

Tata Consultancy Services

o Star Team Award

o Applause Award

o Service Commitment Award

AIMIA India Loyalty Management Pvt. Ltd

o Performer of the year 2013 award

o PASSION award for Originality 2014 - Displaying throughout their work imagination, creativity, originality and novel ideas in finding solutions for the business and clients o PASSION award for Nimbleness 2014 - Displaying agility in thinking & action to the changing needs of the market and client

WORK EXPERIENCE

TCS Projects Overview – Consultant, Data Architect (May 2019 – present) a. Largest Asian Automobile Components Manufacturing company wanted to perform Spend & Purchase Analysis and identify Potential Savings across Plants, Business Units, Vendors, Materials

Designed conceptual & physical data model using SQL Power Architect tool.

Created Staging & Operational Data Source (ODS) in SQL database to load flat files in raw form and transform data into reporting layer.

Developed Stored Procedures to perform CCA analysis and apply business logic.

Designed report-based star schema data model in Power BI taking into consideration business naming convention so that Q&A functionality can interpret natural language efficiently to answer questions accurately.

Developed performance analysis dashboard to identify top 10 performers by Materials, Vendors, Business Units, Plants by time intelligence and identify potential savings b. Global leader in Logistic domain wanted to enable Near Real-time automated data intelligence tool on cloud platform called Pricing/Transportation Discount Anomaly Detection Tool (Over/Under Billing) Anomalies occurred due to loosing discounts when customer contract is expired or customer hierarchy is changed where pricing is applied. Source system was inhouse DLRS/Shipping legacy system and Tibco SpotFire was analytical tool which had some limitations & performance issues thus decided to migrate shipping data to Azure cloud platform.

Designed raw, curated & reporting data layers

Designed ADF pipelines to load data into Azure Synapse

Designed stored procedures to perform data cleansing activity

Dashboards developed in Power BI to analyze shipment anomalies by EAN, Customer Hierarchy (Group, Division, Facility, Country) with KPI’s Revenue Threshold, Period, Total Shipments, Total Revenue, Under Billed Shipments,

% Underbilled, Over Billed Shipments, % Overbilled, Net Rate Variance. Delinquency Report c. Global CPG company’s Power BI Reporting Factory team were seeking Tactical Solution to develop and maintain in-house reports in Power BI. Data Sources were excel/csv, SQL data, PBI dataset, JIRA database, SharePoint Links, Azure SQL

Designed semantic data models and dashboards as follows o Portfolio Management dashboard – prioritizing execution of projects in pipeline based on parameters like Reach, Impact, Confidence, Effort (RICE).

o Capex Performance Management Dashboard

o Financial reports (P&L, Balance sheet)

o Security Incidents Dashboard

o Marketing Business Services Dashboards

d. Global largest toys manufacturing & entertainment company wanted to migrate all reporting data to Azure cloud using Power BI visualization tool by evaluating all retailer’s POS & Stock data to analyze product performance in the market and maximize replenishment

Migrated SQL stored procedures supporting web application to Databricks to enhance performance

Developed dataflows & PBI datasets to aggregate reporting data

Developed dashboards to perform POS data validation

Developed Pricing Analytics dashboard

Global Shipment Dashboard

Security Compliance Dashboards connecting various security tools like JIRA, Nagios, ServiceNow, Tidal 3/3

e. Asian largest liquor beverages brand was facing dashboards performance issues Power BI was connected to Azure SQL database to fetch near real time data

Dashboard performance improved by

1. Optimized data model to adapt star schema design 2. Removed M-to-M, Bi-directional relationships

3. Eliminated unwanted data

4. Full refresh was replaced with incremental refresh to refresh data on weekly basis f. Prior to TCS – Project Manager Consultant – Data Design Solutions (before 2019) Customer Loyalty Programs for Banks & Retail Companies Loyalty Rewards Program allows eligible members to earn & accumulate points for purchase/spend transactions and redeem those reward points. Loyalty engine was used to maintain customer’s item level transaction details and rewards points.

Using data modeling tool Erwin/Visio built conceptual entity-relationship data model.

Bronze, Silver, Gold data layers created in SQL database to maintain all profiling, earn/burn transaction details

Complex logic was built using stored procedures to extract campaign data and generate store wise liability report on FIFO basis.

Developed daily/monthly MIS & analytical reports/dashboards in excel & SQL Reporting Services

Co-ordinated with business team to develop a project plan to deliver project objectives/milestones within estimated timeframe

Identified team capabilities and assign project tasks accordingly. Encouraged team members to enhance skillsets to identify quickest possible solution to resolve project related issues

Managed and maintained project documentation

Organization Designation Duration

TATA Consultancy Services, Mumbai Senior Consultant – Data Architect since Jul - 2019 AIMIA India Loyalty Mgmt Pvt Ltd, Mumbai Sr Manager – Data Design Solutions 2012 –2019 Saifee Burhani Upliftment Trust (SBUT), Mumbai Sr Manager - (MIS) 2011 – 2012 Aurovision Software Pvt Ltd, Mumbai Project Manager 2004 – 2011 Krypton Direct Integrated Services, Mumbai Database Consultant 2003 – 2004 Leo Burnett India Ltd, Mumbai Sr Database Executive 2001 – 2003 Thompson Connect Worldwide, Mumbai Sr Software Engineer 2001 – 2001 Direct Mktg Services Pvt Ltd, Mumbai Software Programmer 1995 – 2001

Contact this candidate