Responsibilities:

Alteryx:

• Have done requirement gathering from the end customer.
• Customer had heterogeneous data sources from different vendors like Nokia, Huawei, and Ericsson. Each source file from the vendor had a different structure and format and data which was required to be merged.
• Have an automated module to fetch, combined data from different sources, and performed data transformation as per the business logic.
• Created Macros in ETL with the help of Alteryx.
• Stored the transformed data into Amazon Redshift Database and Tableau Hyper format.

Tableau:

• Designing the Reports using Tableau file and Redshift database.
• Created Actions to achieve the desired functionality.
• Created sheets and dashboards for different LOB's like PS, CS, and IMS.
• Implemented Data Blending concepts in my Tableau Reports.
• Worked on Dual Axis & Blended Axis concept while working with reports.
• Created Filters on Tableau Reports.
• Worked on Calculated Fields and Parameters.
• Worked on multiple tableau visualization charts like Heat and Treemaps, etc.
• Created custom chart filters and Action links to filter the data on the dashboard.
• Created and modified some of the existing reports and dashboards.
• Publishing dashboards on server Using Tableau Desktop.

Environment: Alteryx, Excel, CSV file, Text file, Tableau 2020.3.

• Information gathering - Interacted with the end-user to understand the requirement andbusiness logic.
• Involved in maintaining Universes by using Universe Designer.
• Created Classes and Objects in Universes, According to Functional specifications.
• Created reports by taking data from different data source.
• Created reports using Web Intelligence.
• Working on Standard as well Customized reports.
• Scheduled Business Objects Reports to users using Scheduler.
• Publish Reports to the number of Key users.
• Knowledge of ENM and ENIQ Ericsson Products.

Simultaneously handling Vodafone-Idea and Bharti airtel Migration Projects for different Circles like Maharashtra, Gujarat, and Rajasthan since Sep-2019.

• Information gathering - Interacted with the end-user to understand the requirement andbusiness logic.
• Involved in maintaining Universes by using Universe Designer.
• Created Classes and Objects in Universes, According to Functional specifications.
• Created reports by taking data from different data sources.
• Created reports using Web Intelligence.
• Scheduled Business Objects Reports to users using Scheduler.
• Publish Reports to the number of Key users.

Knowledge on ENM and ENIQ Ericsson Products

Basic Knowledge on Python, Alteryx, Network Analysis

• Working on PPM Client tool to receive Incident and Development Request Daily.
• Working on Auto reporting Client tool to publish report to the number of Recipients as per the requirement based on Webi report prompts value.
• Working on Different Kernels of Client like COCA (Corrugated Packaging), PPCA (Paper & Packaging), CCA (Coatings), ISCA (Industrial Bags) and PEx System.
• Information gathering - Interacted with the end user to understand the requirement and business logic on Every Tuesday and Thursday.
• Involved in Creating and maintaining Universes by using Universe Designer.
• Created Classes and Objects in Universes, According to Functional specifications.

· Created reports by taking data from different data source Like (SAP BW, ORACLE, and SQL SERVER).

• Involved in the modifying and Building of Universes, Classes and objects.

· Created objects and defined them accordingly into measures, dimensions and detail.

• Used joins concept by taking different tables from different data sources in the Universe.

· Set up Universe level conditions to restrict data based on Functional specifications.

• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity.
• Resolved data mismatch issues that are raised from end users.

• Created reports usingWeb Intelligence.
• Scheduled Business Objects Reports to users using Scheduler.
• Creating Auto reports (Publishing) using client tool Auto reporting, Write sql server script to deliver webi reports based on report prompt value.
• Publish Reports to the number of Key users.

Environment: Business Objects 4.1/4.2, Web Intelligence, SAP BW7.5, SQL server, Oracle, MS-Access, Windows Server 2008/12.