﻿Yashaswee Singh Tomar
Architect 
Location: Pune Phone: +91 8380072723, Email: yashasweesingh@gmail.com                                                                           Immediate Joiner
Overview
Quantitative Management Leader with over 12 years of broad experience in Data Modelling, Data Engineering, Business Intelligence and Big Data Analysis.
Experience in modelling Operations/Business problems into mathematical models and solving them.
Experience in providing the right infrastructure for customers.
Business Intelligence expertise
Admin Experience     
User Tracking for Embedded Power BI reports
Created Log analytics workspace and enabled Microsoft insights provider.
Using the Log Analytics workspace, generated information related to Tennat Summary, Workspace Summary, Engine Activities, Dataset Refresh, User Activities and Error Summary.
Tracked user information who are accessing reports, in terms of UserId, Client IP, Workspace Name, Dataset Name, and Timestamp.
Power BI Audit Logs in admin portal, by Microsoft 365 Admin Center.
Used Audit logs to search for user activity by Dates, Files and Activities.
Managed on premise Gateways for refreshes and data transfers.
Created deployment pipelines to push reports from Dev-&amp;gt;Pre-Prod-&amp;gt;Prod environment.
Informed business users about licenses, which they can use like Pro, PPU and the cost involved.
Created workspaces in Dev and Prod environment and assigned premium capacity.
Created Azure AD groups for user specific access to different workspace.
Development Experience     
Designed Strategy, Roadmap, Enablement Strategy for various customers, including various fortune 100 Companies.
Always aim to assist Business Users to make quick and better decisions.
Developed Data Marts schemas for multiple business divisions.
Reverse engineered application specific name-value pair database into a query friendly normalised data model to support reporting.
Performed enterprise strategic BI DW Assessment and identified the gaps.
Created Paginated report Using SSRS and Report builder.
Prepared Synapse Data warehouse and migrated to Synapse.
Created User commentary using Power apps.
AD groups added to Power apps for users.
Used Direct query to refresh the data instantaneously using snowflake having Power-app License.
Power bi reports created for Manage accounts and revenue business.
Used Rest API for Embedded Power BI reports and manage its content.
Led, designed, and implemented data extract processes to derive measurable metrics.
Mentored teams in designing and developing multiple system enhancements.
Analytics expertise
Created predictive models using Python.
Compared data for previous demands, current demands and forecasting.
Created Regression models, conjoint analysis in Python.
Working experience in Azure &amp;amp; AWS cloud.
Working experience on Synapse real time analytics .
Statistical concepts: Linear Regression (Simple &amp;amp; Multiple), Logistic Regression, Conjoint Analysis, SVM, Bootstrapping, cross validation, Subset Selection (Beat, forward, backward &amp;amp; hybrid), Shrinkage (Ridge &amp;amp; Lasso), Non-Linear (piecewise function), Decision Tree (Bagging &amp;amp; Boosting).
Familiar with Static and dynamic graphs in Deep Learning and its relevant application for scenarios.
Data Engineering expertise
Created Snowflake schemas, data models and dynamic data masking in Snowflake.
Experience in SSIS, Talend, Azure Data Factory, Azure Analysis Service.
Created SSIS packages and supported system and acceptance testing.
Tuned ETL stored procedures, triggers, and user defined functions. Designed and developed DTS packages and enhanced OLAP cubes using SSAS.
Worked on Synapse Data science from problem formulation to insights.
Created data process, integration and scheduling using Azure Databricks and ADF.
Designed various ETL jobs from ingestion, processing to object structures in Data Warehouse.
Warehouse design and transformation for Enterprise Machine Learning.
Handled big data using Mongo db, and created real time data streaming for reporting.
Migration expertise
Business Intelligence
Strategized, planned, and spearheaded Migrations
OBIEE  Power BI, SAP BO/Crystal Reports  Power BI,
Tableau  Power BI, OBIEE  Qlik, OAC  Power BI, Qlik  Power BI
Data
Strategized, planned Migrations
DB2  Snowflake, SQL DWH  Snowflake, Redshift  Synapse, Teradata  Snowflake, 
Teradata  Synapse
ETL
Strategized, planned Migrations
SSIS  Informatica, SSIS  ADF, Talend  Informatica
Technical Skills 
Reporting/BI Tools:&nbsp;Power BI, Tableau, Report Builder, Familarity in Qlik sense, Spotfire
Programming languages:&nbsp;Python, Matplotlib, Pandas, Numpy, SQL
Data Processing:&nbsp;Databricks, Azure Data Factory, SSIS, Alteryx
Big Data and AI:&nbsp;Q and A,NLQ,NLP, Hadoop
Cloud services:&nbsp;Azure, Snowflake
Databases:&nbsp;  Oracle, DB2,Sqlserver, Azure Synapse, Snowflake, Mongo DB
Analytical Tools- SPSS, Google Analytics
Education
University Degrees
MBA: Operations &amp;amp; Business Analytics (IMT Nagpur)
BE: Electronics (Medicap&rsquo;s University, Indore)
Graded Certifications
Certificate: PL-300 (Microsoft)
Certificate: Tableau Desktop (Salesforce)
Industries worked for
Projects: Banking, Retail, Insurance, Finance, Energy,
Core Analytics &amp;amp; BI Work Experience (2010 &ndash; Present)
Architect &ndash; Business Analytics
LTIMindtree-Bny Mellon    (Oct 2021 &ndash; present)
Project- Handled the Managed Account of business for BNY Mellon. Managed account of business, assets, revenue, partners, and YOY revenue were some of the important parameters.
Created semantic layers, which acted as source for Business Unit.
Worked on Microsoft fabric from Analytics, Data Science and Power BI.
Created deployment pipelines and version control using github for reports.
Responsible for activities for Business Analytics; includes POC, estimates, strategy.
Used Git hub for version control and documentation on Confluence.
Designed various schemas including Star and Snowflake.
Integrated the data and ETL using Azure Data Factory
Designed Analytical Reports for Customers in various business divisions.
Created ETL processes, triggers, and user defined functions. 
Reverse engineered from Business Requirement to User Friendly Reports to Data Model to ETL requirements, which made Business Users benefit the most of it.
Performed enterprise strategic BI DW Assessment and identified the gaps.
Prepared Enterprise BI DW roadmap based on the findings from the assessment process.
Worked on various projects at an Architect Consultant capacity.
Architect&ndash; Analytics &amp;amp; BI
iLink Systems UAE - Banking Domain (Jan 2021&ndash; Oct 2021)
Project- Main scope of the project was to migrate from SAP to Power BI. Financial reporting, Transaction reports, agreement based- Murabaha agreement were created. Hybrid Architecture was created for the migration. Reports were also created in Arabic
Designed BI Solutions and identified KPI and KGI for the Client.
Worked on multiple RFPs and Proposals.
Created hybrid architecture for migration from SAP BO to Power BI, which included Semantics layers, licensing, load balancing, Capacity Management, and security.
Created Paginated and Power BI reports, implemented What if scenarios and forecasting.
Team Lead &ndash; BI Solutions
Altice USA- Telecomm (July 2018 &ndash; Dec 2020)

Predictive Analytics - Planned and projected Skillset requirements and SLA adherence for all new projects.
Designed workflows in Alteryx.
Used Google analytics used for measuring customer trends and preferences.
Provided strategy, Roadmap for Data infrastructure.
Provided various Dashboards for Operations, HR, and the Executive Board
Provided various Insights for the clients which included Cash flow prediction, Claims Intelligence etc within the Altice Operations domain.
Used high assurance session for salesforce, also connected Tableau to Power BI Datasets.
Recovered projects worth $1.1 million in red and transpired them into BAU.
Manager &ndash; SPG &amp;amp; BI
Western Union- Financial Services (July 2017 &ndash; July 2018)
Examine cash flow and financial statements, generate summary reports, monitor rate changes, develop financial models, and complete forecasting reports for financial projects.
Designed and Managed PMS for the whole Organisation. Instrumental in redefining the JD for all incoming employees for the entire company spanning 3 geographic locations.
Apart from the regular reports on AP, AR, and GL, we provided various Dashboards for the Organisational Operations, ROI, and balance Sheet ratios.
Gathered Business Requirements by interacting with Contract Owners and SMEs.
Defined best practices for Tableau &amp;amp; Power BI report development.
Senior Consultant &ndash; Analytics &amp;amp; BI solutions
AllState- Insurance (July 2016 &ndash; June 2017)
Analyst &ndash; Operations &amp;amp; BI
Sears Holding- Retail (April 2014 &ndash; July 2016)
System Engineer &ndash; MIS
TCS- Credit Susisse (March 2010 &ndash; June 2012)



