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