Tushar Xavier Joseph Email & Phone Number

Chennai, Tamil Nadu, India

Chennai, Tamil Nadu, India

ACTIONS:# Developed Power BI Reports for investor client in North America. The technical stack involves SQL Server DB; ETL (SSIS); SSAS Tabular Model (DAX for Measures, Columns, Calculation Groups); Power BI Desktop (Jan 2022) with Report Server to upload PBIX files; Dot Net Web Application to embed PBI Reports; DevOps to manage overall project development. # Collaborated with multiple stakeholders (Product Owner, Senior Manager, Power BI DAX & Visualization developers, QA, ETL & Data Dependency team).# Consultant (Power BI, SQL Server DB) for Agri Tech project development team that works to deliver better farm insights, improved analytics, more targeted policies for Indian State government.ACHIEVEMENTS:# Appreciation from client for POCs and alternate solutions to complex requirements.# Delivery Manager appreciated my support & dedication. Mentioned that I am an asset to any team.

Chennai, Tamil Nadu, India

ACTIONS:# Maintained EUC metadata lineage in AXON – Informatica based on analysis of Data flow transformations between source and output systems for various End-User Computing (EUC) applications belonging to Financial Liquidity & Treasury Risk projects of client-Standard Chartered Bank.# Explored Power BI Desktop by importing Excel report files, Modelled Lookup and Data tables, Applied DAX formulas to add calculated columns and measures, designed reports with interactive visuals/ charts, slicers, filters.# Explored Microsoft Azure to migrate databases & applications from on-premises to Cloud.ACHIEVEMENTS:# Analysed and documented transformation logic processes from beginning to end within estimated timelines for 30+ complex EUC applications belonging to Financial Liquidity & Treasury Risk projects of Standard Chartered Bank.# Held a perfect attendance record.# Winner of Risk & Compliance Tagline contest hosted by Standard Chartered Bank at organization level.

Barsinghausen, Lower Saxony, Germany

ACTIONS: # Designed, Developed, Migrated, and Scaled Sales and Operations Planning System from 1 Business Unit to 8 Business Units at Corporate level for Federal-Mogul Powertrain. It is now an Enterprise scale product. The architecture involved implementation of ETL (T-SQL Stored Procedures, scripts, SSIS), Data Warehousing (DWH DB in SQL Server), Business Intelligence (Power BI, SSAS cubes) concepts.# Administrated SQL Server databases: Modelled tables with Entity-Relationships in normalized form; Managed SQL job failures; Tuned and Optimized performance of SQL scripts; Managed database backup, security, roles & user permissions.# Developed Power BI reports for Sales & Marketing team: Imported data from SQL Server; Transformed queries and data in Power Query Editor; Modelled tables and relationships; Used DAX to create measures for KPIs and chart visuals; Designed PBIX report pages with interactive visualizations, slicers, filters; Pinned certain visuals to create Dashboard on app.powerbi.com service.# Relaunched some applications.# Trained users. Reduced downtime and improved performance of applications.# Brainstormed design of Capacity Planning System.ACHIEVEMENTS:# Received Go-Live incentive from Information Systems Director towards successful launch of Sales Planning System at Corporate level.# Did performance tuning for several SQL Server stored procedures, views, jobs.# Migrated SQL Server DB from 2000 to 2005 and from 2005 to 2008 and from 2008 to 2014.# Implemented reusability concepts like Error handling, DB connections, scalar functions.

Chennai Area, India

ACTIONS: # Gathered requirements from Sales & Marketing users.# Developed short-term Sales forecasting tool titled Midmonth using Advanced Excel VBA macros.# Optimized complex & time-consuming SQL based reports with ETL (SSIS), Data Warehousing (SQL Server) and Business Intelligence (SSAS) concepts.# Production Support.# Minimized redundant features. Reduced number of Cubes, harmonized Measures & Dimensions. Built reusable methods through web services. Developed web applications (maintain master data, import external data, administrative tasks).ACHIEVEMENTS:# Received Best performer award from TRW CIO (Matt Peterson).# Received Star performer of the year award. # Received Associate of Month award.# ZERO Escalations reported from Customers.