CEM Analytic Dashboards is tableau Packaged solution where service engineer use tableau reader/desktop to check performance of network operation. It comprises media, Web analyzer, Benchmarking dashboards.
It helps Network Analytics team to monitor and analyze the network closely with respect to the performance As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product solution and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
 Created interactive data visualizations in Tableau, using relational and aggregate data sources.
 Created a script to load data into CSV file and upload tableau package in physical location.
 Use data blending technique to blend data from different data source.

SOC is a web based Customer Experience management tools developed by Ericsson and is used across multi Telecom service provider across the world. This product will help the telecom Network Optimization Engineer and Network Analytics team to monitor and analyze the network closely with respect to the performance.

 As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
 Created interactive data visualizations in Tableau, using relational and aggregate data sources.
 Creating users, groups, projects, Data connections, settings as tableau administrator.
 Load data in SQL server from different sources using SSIS. Create package to load data in tables.
 Involved in custom SQL queries to import data from SQL server to Tableau.
 Monitor SQL database health and management. Designed ER diagrams and mapping the data into database objects.

IP Dashboard is an application which show uses of system and servers. It provides details of Idle ad running system. Using this dashboard business line take decision on system/server.

 Built Strategic, Analytical, and operational dashboards using Tableau.
 Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to Tableau.
 Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
 Tested reports and uploaded Tableau dashboards on to server and provided production support for Tableau users.
 Created connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
 Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
 Administered user, user groups, and scheduled instances for reports in Tableau.
 Created SQL views to pull data from SQL Server and developed reports using advanced calculations, filters, and parameters

ESPA is a Network Performance Analyzer tool which provides measurement of network quality. All key quality indicators namely Integrity, Accessibility, retain ability, Capacity, Mobility, availability can be measured and analyzed under one roof using ESPA. This tool offers both UI and reporting features where the user can trend the performance of the network for specified period and generate the report for further analysis. This tools support multi-vendor (Ericsson, Nokia, and HWA etc.), multi-technology (2G, 3G and CDMA) and multi Domain (RAN & CORE).

 Designed ER diagrams and mapping the data into database objects.
 Database creation and management. Developed jobs, stored procedure for data aggregation. Analyzed long running queries and tuned the complex queries to optimize application and system performance.
 Involved in E2E design of Database layer, Mediation, performance tuning.
 Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries using MS SQL Server 2008/10.
 Generated parameterized/Drilldown, drill through & Cascaded reports using SSRS. SSRS server administration and maintenance.

Project involves development of a web Application which can track all inventory items.
Key features of this application are
• Inventory creation, reservation, transfer.
• Mail alerts to all required stakeholders at all steps of inventory movement.
• Inventory forecasting and reports of all inventory item including hardware and Software.
 Understanding the Business requirement, design of the Database and reviewing the updates daily.
 Developed a web application for end users.
 Requirement Analysis, Estimation, High level design.
 Application development, coding and stored proc creation

VSM (Volume Split Module) is an intranet web application used by JPMC IB division for account splitting. It is a sub module of ICAT (Intranet Collection Automation Tool) enterprise application for account splitting and movement across the regions

 Understanding the Requirements
 Preparing design (User Interaction Cases)
 User Interface Designing and Coding
 Creating optimized Stored Procedures for database interaction Code Review for
 Coding Standards and Code Optimization