SURAJ TALREJA

Managing the data analytics team of four people and helping them to understand the requirements. Actively communicate with Finance Team to understand the business requirements and provide the analytical solutions. Prepare the functional and technical documents. Build the data pipeline in Alteryx for inputting the data in Tableau Dashboards. Fetch the data using SQL, Impala and hive queries. Implement the aesthetic Dashboards in Tableau and TIBCO Spotfire for the business users. Provide the ad-hoc analysis using R, Python and MS Excel to the business users. Automated the existing dashboards in Tableau. Created a new CAPEX dashboard in Tableau which is helping finance team to track how much they are spending in various IT Projects. Created a new Competitive Bid Dashboard in Tableau which is helping finance team to track if the SOWs with $50K are going in competitive Bid or not. Created a complex automated Alteryx workflow for Competitive Bid Dashboard to create a single data source using multiple tables. Created a new Business vs Actual Dashboard in Tableau which is helping finance team to track how much they are spending with respect to the planned amount. Created more than 10 reports for 3PI team in tableau. Created a new dashboard for Procurement Team to track if the vendor team is working as per SLAs or not.

Actively communicate with Business users to understand the business requirements and provide the analytical solutions. Prepare the functional and technical documents. Fetch the data using SQL queries from the SQL Database Tables. Implement the Tableau Dashboards for the business users. Provide the ad-hoc analysis using R, Python and MS Excel to the business users. Provide the insights on ETL Pipeline to ETL team.

Actively communicate with regional heads of Corporate and Global Banking to understand the key business requirements. Created the Tableau Dashboards for the business users and setup the ETL pipeline using Alteryx and SQL. Provide the data analysis and created the Dashboard to track the status of Account Plans of Priority Clients. Created a new Calling Dashboard for Transaction Banking Sales team to track the frequency and quality of calls. Created a new OPAC and QDL Dashboard to track the movement of OPAC and Quality Deployable Liability. Worked with a resource to create the Client Coverage Dashboard which is helping management and relationship managers to see the coverage of clients and relationship managers. Created the Global Banking Performance Dashboard to track the YTD revenue for the High Value Clients against the forecasted revenue.

Played an active role to analyse the business requirements in analytical terms and helped the team to understand the requirements. Created the multiple Tableau Dashboards to track the Insurance KPIs for the Business and setup the Data pipeline using Spectrum ETL tool. Actively participated in regular meetings with different stakeholders to discuss project status and associated challenges. Improved Sales and Revenue KPI & Metrics Performance by 70% with data analysis and creating predictive dashboards.

Played a key role in helping Data warehousing team in the design and modelling of the warehouse which helped the company to use the aggregated data effectively for analysis and visualization. Created Tableau dashboards first time in the organization which helped management to check the revenue and sales figures effectively, presented findings and recommendations which helped the organization to make data-driven decisions.

Optimized the SQL queries which helped the client to save the time more than 35% while fetching the data for analysis from back end servers. Created aesthetic & interactive dashboards using Tableau to analyse the number of Insurance policies being sold in different regions by different agents, which helped the client to increase the revenue up to 20% by focussing on regions where revenue and profit are lagging.

Successfully completed all the learning which includes Data warehousing, Statistical concepts, Data Analysis and Machine Learning in R & Python, Big Data tools such as Hive, Spark and Sqoop, and assignments such as Acquisition Analytics Modelling, Supply-Demand gap analysis, HR analytics modelling etc with excellent grades.