Data AnalysT/Tech Lead, CONFIDENTIAL

Mtableau team is a part of the IT Advanced analytics team. The team manages the tableau server, content, and licenses for all teams in the organization.

 

• Led and managed a team of 5 members to successfully design and implement a high priority migration project.
• Assisted users with tableau dashboard development/data preparation on Palantir and Postgre SQL.
• Defined and gathered requirements to build goal frameworks to track business metrics.
• Collated and translated business requirement to data prep team.
• Built SQL scripts, data sets and data lineage.
• Built complex visualizations on Tableau desktop and drew inferences for stake holders.
• Performed data blends on Tableau (SAP Hana and Postgre SQL).
• Conducted scrum calls with tableau development team and addressed blockers.
• Performed admin functions like publishing, adding users, report scheduling on Tableau server
• Improved performance of slow performing workbooks on server.

 

 

AUG 2019 – June 2021

CRM ANalyst/Business ANALyst,CONFIDENTIAL

The CRM analytics team works alongside marketing and campaign team. The teamgenerates campaign feed and analyzes campaign results.

 

• Completed 15 projects and multiple ad-hoc project requests.
• Using agile methodology, analyzed, defined, and documented project objectives to fulfil business requirements on Jira.
• Developed data analytics strategy and wroteSQL scripts.
• Queried, extracted, and validated data from server using PostgreSQL.
• Encrypted and tokenized PII data to ensure adherence to GDPR data regulations.
• Automated repetitive tasks by writing stored procedures/views and scheduling on need basis. 
• Worked on creating interactive Tableau dashboards and applied actions (Filter, Highlight and URL).
• Identified key areas in profit and loss reports where organization should improve, leading to 5% increase in revenue for the program.
• Analyzed the tele-sales performance, repeat and new customer revenue for various regions.
• Analyzed LTV of customers using cohorts.
• Forecasted sales for near future and validated forecasts with backward forecasting.
• Compiled results in a concise, meaningful, and actionable format using Tableau and shared findings with senior management.

 

OCt 2017 – Aug 2019

PURCHASE ANALYST,CONFIDENTIAL

The GP team procures goods/services for the home company and clients (WDS, Buck).

 

• Gathered business requirements from stakeholders.
• Analyzed purchase requests raised by various departments.
• Performed analysis of cyclical spend patterns across products.
• Created different Tableau visualizations using bars, pies, bubbles, tree maps, highlight tables, heat maps, custom charts (donut chart, waterfall chart, bump chart).
• Used table calculations, lod’s, filters, parameters, sets, groups, bins... for building viz on Tableau.
• Worked on topN and bottomN by using parameters.

Published the finalized results on server.