Project Portfolio
|
PROFESSIONAL EXPERIENCE:
BENCHGEEKS
|
|
|
|
|
|
Client: ServiceNow
|
|
|
|
January 2024 to Present
|
Role: Sr Tableau developer
ServiceNow is making the world of work, work better for people. Cloud-based platform and solutions deliver digital workflows that create great experiences and unlock productivity for employees and the enterprise. It is growing fast, innovating faster, and making an impact on ServiceNow customers' and employees' lives in significant and important ways. With over 6,900 customers, serve approximately 80% of the Fortune 500, and it’s on the 2020 list of FORTUNE World's Most Admired Companies. ServiceNow is a platform-as-a-service provider, providing technical management support, such as IT service management, to the IT operations of large corporations, including providing help desk functionality. The company's core business revolves around management of "incident, problem, and change" IT operational events.
• Analyze and determines information need to the customer Out comes reports. Coordinates new data development, ensuring consistency and integration with existing data warehouse structure.
• Participates in continues improvement efforts in enhancing performance and providing the increased functionality.
• Providing the support to do enhancements of dashboard for the ServiceNow users and provide an accessing for the required level of permissions in tableau server.
• Worked on GraphiQL to finding the no of data source, top viewed workbooks and sheets in Tableau Server toanalyze on it.
• Worked on the select portal metric to design different KPI metrics like number of tickets raised, total number of rooms assigned for each select license id and Total number of RMA count.
• Designed the reports as per client requirements and addressing the Scrum calls/Daily Standout’s, Participated in Sprint Reviews and Addressing the stories based on the Priority level.
• Worked on the customer out comes repots with implementing various business logic into the report level and enhancing the existing reports and dashboards.
• Created Custom Hierarchies to meet the Business requirement in Tableau and Publishing sheets and dashboards on server Using Tableau Desktop.
• Created complex reports utilizing the feature like hierarchy, Parameters, Calculated, Tables, graphs, line Charts and Bar Charts.
• Used Measure names and Measure Values fields to create visualizations with multiple measures and dimensions.
• Test the dashboards to ensure they meet the business requirements and published them to the server.
• Participated in weekly meeting and communicating with stakeholders and business groups.
Environment: Tableau Desktop 2020.1,2021.2 Tableau Server, MS Excel, Oracle, SAP HANA.
Client: Maxis Telecom Aug 2019 to Dec 2024
Role: Tableau developer
Maxis Communications or Maxis Berhad is a communications service provider in Malaysia. Headquartered in Kuala Lumpur, Malaysia, providing a variety of communication products. Applications and value-added services for consumer’s large enterprises and small & medium business owners. Communication connectivity in Peninsular Malaysia is covered by both fixed and wireless infrastructure such as fibre network, Asymmetric Digital Subscriber Line (ADSL) network, mobile base stations, earth stations and microwave link stations. Communication connectivity in East Malaysia mainly provided by the coverage of fibre network, ADSL network, earth stations, mobile base station and microwave link stations.
• Designed the reports as per client requirements and to understanding the Data on reports and developed into tableau dashboards.
• Involved in Design Stage to Mapping the required development information of Hive, Talend based client business logics.
• Extracted data from various sources Oracle, SQL Server, AWS and Hive, HDFS is used as data storage for hive tables by using Tableau and performed join across, data blending to connect with different Data sources.
• Developed dashboards which are allow users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created TopN and BottomN Sets, Bins, Groups and Hierarchies of drill down and drill up. Worked on the Lod’s To perform the aggregation at the required dimensionality level by using level of detail expression keywords.
• Performed system integration of given data to Oracle Data base and replacing with data base fields names in Tableau.
• Worked on groups, Parameters, sorts, sets and to created filters focused and effective visualizations.
• Created different types of dashboards based on user requirements like toggling dashboard or popup dashboard, Index dashboard and Master dashboard.
• Performed SQL scripts for testing and validating data on various reports and dashboards.
• Test the dashboards to ensure they meet the business requirements and published them to the server.
Environment: Tableau Desktop 2019.3 Tableau Server, MS Excel, AWS,Oracle, SQL Server.
Client: USPI Health care
Role: Tableau Developer Oct 2016 to Aug 2019
United Surgical Partners International (USPI) Healthcare is one of the largest healthcare technology companies in the United States. The company has a team of 17,000 that help customers improve efficiency, reduce costs, increase cash flow, and manage complex workflows. USPI Based in Addison, Texas, UNITED SURGICAL PARTNERS INTERNATIONAL (USPI) Healthcare provides improvement for before, after, and in-between care episodes. The company enables better patient care, choice, and outcomes at scale. The company had partnerships with 4,000 physicians and 50 health systems in the United States.
Responsibilities:
¨ Designed the reports as per LLD’s and Develop Tableau dashboards using various data sources and release to business on Tableau server.
¨ Worked with closely data modeling and data warehouse team to get the client required reports.
¨ Worked with Actions in Reporting, Drill Down, and Drill Through reports.
¨ Created complex reports utilizing the feature like hierarchy, Parameters, Calculated, Tables, graphs, line Charts and Bar Charts.
¨ Created and modified some of the existing reports and dashboards.
¨ Publishing sheets and dashboards on server Using Tableau Desktop.
¨ Implemented joins & blending concepts in Tableau Reports.
¨ Generated Dashboards with Quick filters, Parameters and to handle views more efficiently.
¨ Extracted data from various sources and performed data blending.
¨ Created views with different axis like individual axis, Blended axis and dual axis for comparison.
¨ Developed maps manually using custom Geo-coding.
¨ Experience with Extracting and loading with ETL Talend for in big Data.
¨ Developed dashboards which are allow users to understand the data on the fly with the usage of quick filters for on demand needed information.
¨ Test the dashboards to ensure they meet the business requirements and published them to the server.
¨ Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
¨ Performed Unit testing and Created SQL scripts for testing and validating data on various reports and dashboards and handled performance issues effectively in Tableau.
Environment: Tableau Desktop 10.x/2018.1, Tableau Server, SSMS, MS Excel, SQL Server.
Client: Belk
ROLE:Tableau Developer Mar 2015 to Aug 2016
Belk operates mainline and retail department stores primarily in the southern United States. Its stores offer fashion apparel, shoes, and accessories for women, men, and children, as well as cosmetics, home furnishings, house wares, jewellery, gifts, and other merchandise. The company's selected stores also include hair salons, spas, restaurants, optical centres, and other amenities. In addition, Belk stores offer exclusive private label brands. The company sells its products online and through its four flagship stores. The products and sales data are collected from different branches. The main aim of this project is to develop reports for the client which helps them to take better decisions.
RESPONSIBILITIES:
¨ Designed the reports as per client requirements and addressing the Scrum calls/Daily Standout’s, Participated in Sprint Reviews.
¨ Created Custom Hierarchies to meet the Business requirement in Tableau.
¨ Designed, developed and implemented Tableau Business Intelligence reports.
¨ Used groups, Parameters, sorts, sets and filters to create focused and effective visualizations.
¨ Involved in execution of Test Cases.
¨ Worked with Complex Filters and Calculated felids with LOD’s for Complex reports.
¨ Used Measure names and Measure Values fields to create visualizations with multiple measures and dimensions.
¨ Create calculations including arithmetic calculations, custom aggregations, date math and quick table calculations.
¨ Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
¨ Reviewed basic SQL queries and edited inner, left, right joins in tableau desktop by connecting live/dynamic and static datasets.
¨ Performed system integration of sample data to SQL Server Data base and replacing with data base fields names in Tableau.
¨ Interacting with the client on regular basis while releasing the dashboards in Server.
Environment: Tableau Desktop 9.3, 10.1 Tableau Server, MS Office Suite, MS Excel, SQL Server.
Client: Meijer retail domain Description:
Meijer is one of the biggest Organizations in Retail Market in USA. This project is aimed at evaluation of sales performance of the business to improve customer loyalty and market share. It aims at consolidating the sales data from various stores into a centralized sales data mart. The sales data system is helpful in Analyses of sales for marketing group and reporting for sales group.
Roles & Responsibilities:
¨ Developed reports using various functions, operators, report filters and variable.
¨ Restricted the data using the Prompts and filters.
¨ Created basic calculations including string manipulation, basic arithmetic calculations
¨ Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters.
¨ Developed many Reports using different Analytics Views using numerous functions and features for better visualization.
¨ Created Sets, Bins, Groups and Hierarchies.
¨ Interacted with the Business Analyst and the Managers in gathering the business requirements to design and develop reports.
¨ Modified existing tableau reports and supported UAT process.
¨ Created various reports and dashboards using Tableau Desktop and published to the internal team for review and further data analysis.
¨ Blended data taken from multiple sources by selecting primary key from each database for data validation.
¨ Created bar graphs, pie charts, and heat maps to visualize and provide enough detail and thorough insight into the data by region that allow users to take necessary actions.
¨ Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports. Performed SQL scripts for testing and validating data on various reports and dashboards Involved in migrating code between the dev - test –production environments.
¨ Performed a Unit testing and validating data on various reports and dashboards in Tableau.
Environment: Tableau Desktop 9.3 Tableau Server, MS Office Suite, MS Excel, SQL Developer, Oracle Server.