Manoj Kumar Y Email and Phone Number

•Extracting the data from Salesforce cloud, SQL databases and Cisco for creating data tables and reports using analytics on the Microsoft Excel.•Creating the Pivot Tables and Pivot Charts using the data created on the Excel sheets.•Performing the Data Validation of the data making sure the created data is appropriate and creating messages that appear when incorrect data has been entered.•Using the Excel functions like VLOOKUP, SUM, IF, OR, MAX, MIN, SUMIF, COUNTIF, ROUND, CONCATENATE and other formulas to perform calculations on the data to obtain the desired results.•Running the Macros on Excel by recording the actions and saving as Visual Basic Applications(VBA) for the automate and repetitive tasks.•Customizing the reports on the Salesforce platform according to the data fields requirement and exporting those reports to excel sheets for analyzing the data.•Performing Data Collection, Data Exploration, Data Validation, and Data Visualization useful in creating the reports which are helpful for the organization

•Developed statistical and predictive models to support business insights that led to fact- based decision making.•Involved in data extraction, transformation and loading (ETL) from source systems.•Created Tableau worksheets, developed dashboards and designed presentations, summary reports.•Developed and implemented databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality. •Created report schedules, data connections, projects, and groups in Tableau server.•Acquired data from primary or secondary data sources and maintain databases/data systems.•Identified, analyzed and interpreted trends or patterns in complex data sets.•Assisted in the development of policies and procedures for the usage of end-user and information systems.•Assisted in monitoring data assets and reports anomalies, errors, inaccuracies or inefficiencies and making recommendations as needed.•Acquired and manipulated data from the organization’s central data lake and conduct in-depth data cleansing to prepare data for analysis. •Aided in the identification of additional data sets that can drive strategy, improve decision making, and automate process.•Developed documents, month end and year end reports and ensuring accuracy of data.