Jan 2019 – Apr 2023 · 4 yrs 3 mos · Noida Area, India

• Tableau/ Power BI
• Tableau:
• Building, publishing customized interactive reports and dashboards, reports using Tableau Desktop and scheduling these Dashboards/ reports using Tableau server. •Building Proof of Concept (POC) and Request for Praposal (RFP) for the clients using Tableau Desktop. •Extensive knowledge in various reporting objects like Facts, Attributes, Cross Tab, Geographical Charts, Aggregates, Hierarchies, Charts, Table Calculation, Trend Lines, Calculated Measures and Dimension, Sets, Parameters, Data Blending, Actions & Filters, Joining of multiple data source, Optimization in Tableau. •End to end experience in Designing and Deploying data visualizations using Tableau. •Developed Tableau workbooks from multiple data sources using Data Blending. Developed Tableau Dashboards using data sources like Hyper, Tde, SQl Server, MS Access, Hadoop, CSV and Excel data set.
• Power BI:
• Expertise in writing complex DAX functions in Power BI and Power Pivot. • Automated Power Query refresh using power shell script and windows task scheduler. • Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.. . • Installed and configured Enterprise gateway and Personal gateway in Power bi service. • Created Workspace and content packs for business users to view the developed reports. • Scheduled Automatic refresh and scheduling refresh in power bi service. • Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques. • Weekly presentation to the business users about the reports and their changes as required. •Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. • Worked on all types of transformations that are available in Power bi query editor • Created stored procedures and SQL queries to pull data into power pivot model Data Analysis: •Manipulating, cleansing & processing data using Excel, Access, Macro, VBA and SQL.

May 2016 – Mar 2017 · 10 mos · Gurgaon, India

• Excel Modeling, Access Database, Spreadsheet Modeling and Spreadsheet automation.
• Boston Consulting Group: (March 2016 – March 2017) – Lead Analyst
• Worked in the Business Intelligence Practice and contributing towards design and developments of VBA Projects, Tableau Projects, Tableau Dashboard, Microsoft Office Automation, and Excel spreads sheet Automation, MS Word Automation, PowerPoint Automation, Outlook Automation and use of Databases like SQL server/MS Access in reporting.
• Key Responsibilities:
• Automated Projects and reports through scratch using Visual Basic and Application and Database.
• Created MS Excel based Models for Banking domain and also do the Analytics for projects
• Generated timely and accurate reports for analysis. Creating Dashboard/report and presenting it to the concern Client/Department.
• Created and published customized interactive reports and dashboards, report scheduling using Tableau server.
• Provided value addition to existing dashboards by sharing Tableau best practices and delivering performance optimization

Jul 2014 – Dec 2018 · 4 yrs 5 mos · Gurgaon, India

• Roles and Responsibilities:
• Specialties: Tableau Development, Tableau Dashboard, Excel, Advanced Excel, Pivot Table, PowerPoint, MS Access( Forms, Reports and Queries), Macros, VBA for Excel, SQL Server.
• 1. VBA Automation:
• Automation of Projects and reports through Visual Basic and Application and Database.
• Creating customize functions in VBA.
• Form designing and coding.
• Connectivity with Excel and SQL server through VBA coding.
• Performance tuning SQL queries, views and store procedures.
• Working on VBA to automate the Daily, Weekly and Monthly reports.
• 2. Tableau Development
• 6+ years of experience in Tableau development in Enterprise Environment using Tableau 8.1, 8.3, 9.0 and 9.1 and 10.5 as a Subject Matter expert and Developer.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Extensive knowledge in various reporting objects like Facts, Attributes, Cross Tab, Geographical Charts, Aggregates, Hierarchies, Charts, Table Calculation, Trend Lines, Calculated Measures and Dimension, Sets, Parameters, Data Blending, Actions & Filters, Joining of multiple data source, Optimization in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in Designing and Deploying data visualizations using Tableau.
• Created Customized and interactive dashboards using multiple data sources.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• 4. Data Analysis:
• Manipulating, cleansing & processing data using Excel, Access, Macro, VBA and SQL.
• Used data to identify trends, patterns and opportunities for streamlining the process.
• Extraction and consolidation of data from various sources, designing dashboards and
• Sharing with clients.

Jun 2012 – Jun 2014 · 2 yrs · Gurgaon

• Roles and Responsibilities:
• Specialties: SQL, MIS, Excel, Advanced Excel, Pivot Table, Powerpoint, MS Access( Forms, Reports and Queries), Macros, VBA for Excel, SQL Server.
• 1. VBA Automation:
• Automation of Projects and reports through Visual Basic and Application and Database.
• Creating customize functions in VBA.
• Form designing and coding.
• Connectivity with Excel and SQL server through VBA coding.
• Importing, Exporting data from SQL to Excel through VBA and vice versa.
• Preparing graph using Macro.
• Analyzing raw data, drawing conclusions & developing recommendations.
• Data auditing, creating data reports & monitoring all data for accuracy.
• Designing, developing and implementing new functionality.
• Database designing in SQL Server and Access for better performance.
• Performance tuning SQL queries, views and store procedures.
• Working on VBA along with the design and maintenance of database.
• Working on VBA to automate the Daily, Weekly and Monthly reports.
• Strong Knowledge of Remedy and New ITSM (ARS System ) tool.
• 2. Database Skills:
• Creating and maintaining the database for new and existing clients.
• Designing the SQL queries/ Stored Procedure/Views/Trigger /PL SQL etc.
• Using joins to join the tables, use of user define Functions (UDF) and System Functions..
• Scheduling daily, weekly and monthly tasks.
• Creating macros to run Access database.
• Resolving errors encountered, updating and amending queries.
• Use of Linked server, CTL and Merge in SQL Server.
• MS Access Queries and designing of forms and pivots.
• 3. Data Analysis:
• Manipulating, cleansing & processing data using Excel, Access, Macro, VBA and SQL.
• Used data to identify trends, patterns and opportunities for streamlining the process.
• Converting business requirements into technical specifications
• Extraction and consolidation of data from various sources, designing dashboards and
• Sharing with clients.

Oct 2011 – Jun 2012 · 8 mos · noida

• Designed and created VBA applications to perform data aggregation and consolidation, ensured consistent processing and accurate results.
• Automated reports used for analysis and optimization of the organisation's internal process using Visual Basic Applications and MS Access Database.
• Built macros for updating customer orders in MS Excel Application.
• Imported data into excel from flat files.
• Developed and maintained Access Application for data retrieval. Previous method was taking Excel workbooks, translating to MS Access database, then exporting to SQL database.

Oct 2009 – Oct 2011 · 2 yrs · Noida

• Roles and Responsibilities:
• 1. Reporting & MIS:
• Working on VBA to automate the Daily, Weekly and Monthly reports.
• Strong Knowledge of Remedy and New ITSM (ARS System OR Active Response System) tool.
• Recording and modification of Macros in the Remedy.
• Preparing Daily, Weekly, Monthly and Service Level Reports.
• Preparing Ad-Hoc reports as per Client requirements.
• Responsible to meet the SLA in Daily, Weekly and Monthly reports.
• Knowledge of ITIL concept.
• 2. Database Maintenance:
• Creating and maintaining the database for existing clients.
• Designing the SQL queries.
• Scheduling daily, weekly and monthly tasks.
• Creating macros to run database.
• Resolving errors encountered, updating and amending queries.
• Trouble shooting and designing of database queries on the basis of requirements.
• 3. Data Analysis:
• Extracting data from different systems (Remedy, MS Access).
• Extracting the data from New ITSM\Remedy 10 (Active Response System 10).
• Designing the macros to extract data from Remedy Automatically.
• 4. Remedy Administration:
• Handling Incidents, Service Requests, Changes and the Problems related tickets and also providing
• Their SLA’s and Asset numbers.
• Developing Macros to automate the tasks and reduce the workload
• Working on various schema’s for logging and also extracting the data
• Writing DDE scripts to link Remedy Macro’s with their concerned template.
• Resolve ad-hoc queries accurately and on a timely manner.