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.

Role: SAP Business Objects Developer.Team Size: 3 Members.Client: MAXIS, MalaysiaDomain: TelecomDuration: Mar-2020 to TILL DATE (End to End implementation / Support)Responsibilities:Information gathering - Interacted with the end user to understand the requirement and business 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 on 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.Environment: Business Objects 4.1/4.2, Web Intelligence, SAP BW7.5, SQL server, Sybase, Oracle, MS-Access, Windows Server 2008/12.

Role: Tableau Developer.Team Size: 2 Members.Client: DTAC, ThailandDomain: TelecomDuration: Jan 2020 – Apr- 2020Responsibilities:Alteryx:Have done requirement gathering from the end customer.Customer had heterogenous data sources from different vendors like Nokia, Huawei and Ericsson. Each source file from the vendor had different structure and format and data which was required to be merged.Have 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 desired functionality.Created sheets and dashboards for different LOBs 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 Tree maps, etc.Created custom charts filters and Action links to filter the data on 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 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.

Role: SAP Business Objects Developer.Team Size: 4 Members.Client: Mondi Group, Austria.Domain: Paper & PackagingDuration: Nov-2018 to TILL DATE (End to End implementation / Support)Responsibilities:Working on PPM Client tool to receive Incident and Development Request and Change 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 for 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 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 using Web 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.

Role: SAP Business Objects Developer.Team Size: 6 Members.Client: Worked with Kenya Pipeline Company Limited.Duration: Jan-2016 to Jan-2017(End to End implementation / Support)Responsibilities:Information gathering - interacted with the end user to understand the requirement and business logic.Created reports using Web Intelligence.Created Web Intelligence reports for various Portfolios using the Universes as the main data Providers.Created the reports using Business Objects functionalitys like Queries, Cross Tab, Master Detail and Formulaes etc.Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.Extensively worked with Ranks, Conditional Formatting (Alerters), filters, prompts, variables and calculation contexts in designing reports.Created Web Intelligence Report level conditions to restrict data, based on report requirements.Published and scheduled Business Objects Reports to users using Scheduler.Worked extensively on Web Intelligence for any new requests and performance issues.Involved in installing Web Intelligence, creating users, user groups and categoriesCreated Web Intelligence documents and published them to corporate documents.Environment: Business Objects 4.1, Web Intelligence, MS SQL server, Oracle, MS-Access, Windows Server 2008/12.