Mukesh Sriwastava

Business Intelligence Developer

Clarivate Analytics•  June 2020 - Present•  Noida

Develop, Customize, Deploy, maintain SSIS packages in Visual Studio with multiple concepts such as- reading multiple files, Error handling, Archiving, Configuration creation, Package Deployment. Troubleshoot packages to address critical production issue, Error handling and creating Batch Jobs, Deployment, Scheduling Jobs, and Performance tuning. Managed and optimized SSIS packages and Power BI reports enhancing their performance by 40%. Designed and developed T-SQL procedures to automate data loads reducing processing time by 20%. Develop interactive charts, graphs, and other visualizations to present data insights and Implement user authentication, access control, and customization options for personalized dashboards. Conduct unit testing of the reporting and dashboarding system and publish dashboards and reports and schedule refresh. Drill-down data and prepare reports with utmost accuracy and Monitoring reports and dashboards and make necessary changes in dashboards resulting in a significant decrease in time spent on data analysis.

Principal Analyst

CPA Global•  March 2014 - May 2020•  Noida

Search for company names, subsidiaries, and name variations and formulate search strategies to be run on commercial patent databases. Extracting patents assigned to the company and their subsidiaries, remove any irrelevant patents appearing in the search results. Run standard process steps to bring the data in a format suitable to Analyses. prepare charts, tables and presentations based on the client requirements and ensure timely delivery of these reports.

Analyst

WIPRO•  November 2012 - November 2013•  Noida

Prepare excel report on resource mailbox data, performing Reconciliation with processed data and sending its completion Status. Generate reports and analyze total data incoming after certain campaigns and preparing PowerPoint Slides and sending to the concerned team. Fetch and share the data of QuickBooks accounting software and User details for refund with concerned team to communicate.