Nishant Bhardwaj Email and Phone Number

Working as Senior Consultant for Client and Advisory program in applying various analytics and automating various manual processes using Oracle Sql, Python, Tableau, SAS, SSIS and adding further data analysis on them as per requirement.• Presently working in Wealth & Investment Management Analytics for Wells Fargo Advisors.• Work as an Senior technical analytics consultant to understand the various analytical requirements from business consultants and work with them to create those.• Create various dashboards as per the higher management's requirement through Tableau, Power BI and ThoughtSpot.• Automate various previously established manual tasks/ analytics to reduce man-hours and make it less error prone.• Work with various technologies like Python,Tableau, ThoughtSpot, SAS, SSIS, PowerBI.• Strategically collaborate and consult with peers, colleagues, and mid-level to senior managers to resolve issues and achieve goals.• Work closely with stakeholders to gather feedback and iterate on reporting solutions for continuous improvement.

Part of Client & Advisors Solutions in Wealth & Investment Management - Analytics || Finance

Taking ownership of more than 50+ reporting onto SAS EG / SAS GRID, SQL, and Tableau for Barclays Collections Team. Formulate structured and unstructured financial data using SAS and Teradata/ SQL and helping the organisation in making business models.Automated multiple excel reports in Tableau by using SQL Server and Teradata as data source and eliminating the manual work completely saving up to more than 1,500 hours.Creation of Monthly Business Report dashboard for all portfolios along with documented commentary & presentation of the same to stakeholders.Recommending changes in Digital Strategies and Collections Strategies to further create a presentation deck in form of story using Visualization tool like PowerPoint and Tableau to demonstrate the benefit to stakeholders. *Received Barclays Recognition Award thrice for excellence and delivering the work on time.Project 1: Launch and Adoption CampaignBehaviour of (Cycle 1&2) customers in terms of payments, inbound calls, complaints, BMB registration when the customer is notified via Email or SMS to make payment of their arrears amount vs when no customer notification is sent.•Data collected using SAS, Teradata, Tableau which help to reduce Call benefits, customers who have notified via Email/SMS to move them to mobile apps and documented them.Project 2: Payment Holiday Analysis Analyse and gather the account level Payment Holiday data from March 2020 onwards for all portfolios •To identify active payment hol accounts that are in arrears, customers coming off payment hol, what the cycle breakdown looks like over COVID period.•Data collected using SAS, Teradata and Tableau for further analysis which helps to analyze how many calls are coming down the PH Lines and does that account for overall increase in volume.Project 3: Trace AnalyticsValidate Customer Contact Info across all the products and portfolios. Mobile No, Email, Returned mail along with additional info like RPC, Cycle, etc using SAS

• Supports various functions which includes Data Management, MIS reporting, Campaigning, Trend Analysis.• Carried out data extraction and data manipulation using PROC SORT to create preferred customer list as per business requirements.• Extensively used SAS procedures such as PRINT, SORT, MEANS and TRANSPOSE for producing ad-hoc and customized reports and external files• Creating Dashboards for Client presentation and analytics• Generate reports in Excel according to client specifications.• Using Excel Skills like Functions/Formulas, Pivot Tables, Creating Graphs, HLook-up, VLook-up, Multiple keyboard shortcuts, etc. on daily basis.

Globallogic Technologies Ltd., as Senior Data Analyst for Client Google India Pvt. Ltd.• Develop new or modify existing SAS programs to load data from the source and create study specific datasets.• Interacting extensively with onshore counterparts on requirement gathering, analysis and documentation.• Analyzing raw data, drawing conclusions & developing recommendations.• Created reporting dashboards using Tableau that results in reducing manual data input by 80%.• Generate reports either in HTML, EXCEL, CSV formats according to the client specifications.• Working on the project titled Google Metadata Analysis & Reporting for the client Google using the tools SAS EG, MS Office. Project deals with understanding and extracting data from the data warehouse using SQL and the reports were produced .

>Responsibilities at Maruti Suzuki India Ltd. were to handle, search and analyse the database record and to make report on it using Oracle 10g builder.>Use SQL commands to fetch / extract the data.