Now you can Instantly Chat with Surendra!
About Me
Dedicated IT professional having Overall 6 Years Experience on Business Intelligence(BI) tools using Tableau 8.x,9.x ,10.x,2018.x and Web Development Using PHP,Drupal,Wordpress. Tableau Developer with Strong DW and SQL Capabilities Worked with SQL to...
Show MoreSkills
Portfolio Projects
Description
Scope
End to end implementation of Tableau BI with focus on consolidation and comparison of data from multiple systems. The scope of the project was to standardize the input from multiple systems (SAP, Flat Files) and use the same to help the end-users to make informed decisions.
Deliverables
- Creating Data Visualizations as per customer requirements.
- Presales activities including demo, Proof of Technology, guided evaluation of different products.
- Elicit customers to understand their business processes, both micro and macro levels.
- Identifying the pain-point and recommend solution options to business units/users.
- Manage sub-contractors in case a part of the project is outsourced.
- Create and setup technology based solution architecture for proper functioning of BI.
- Creation of data models, warehousing and dashboards based on the KPIs identified.
- Extraction of data From SAP BI by using a Data Extraction tool “Theobald”.
- Heading a team of Tableau data analytics capable of three BI developer’s.
Description
- Worked on enhancements for the existed dashboards as per the business needs.
- Created Dashboards and deployed dashboards on all environments and tested with high security levels.
- Worked closely with business users and data team for requirements and to provide the deliverables on time.
Description
Scope of the project was to expand Tableau Business Intelligence replacing the existing system for Data analysis. The data from various sources had to be consolidated to a single data source in order to obtain a set of highly interactive dashboards.
Deliverables
- Provided solution to client through Tableau Server software Installation and setup for “Cluster setup (multi nodded Installation)”
- Setup Infrastructure to deploy dashboards and dynamic reports to Server
- Involved in requirement gathering to deploy servers on different Environments
- Deployed Server on testing and Staging Environments with all specifications and Configurations needed
- Deployed Server on production environment and tested on all security aspects
- Installed Tableau Server in a three node cluster which is one primary and two worker nodes
- Configured High availability and disaster failover recovery on server to avoid down time
- Configured Load balancer as a gateway in front of Cluster to share the users traffic
- Build the whole Administrative part those are creating Publishing, Projects, Users, Groups,
- Build Security on Servers of Project level, User level, Group Level and site level security as well.
- Created Dashboards and Deployed Dashboards on all environments and tested with high security levels
- Trained Customer on Tableau Server to use tableau dashboards with interaction.
Provided all documents related to project (Project Plan, Project Estimation, Business Requirements, Technical requirements, User Manual, Test Strategy etc.)
Show More Show LessDescription
Scope
Scope of the project was to expand Tableau Business Intelligence replacing the existing system for Data analysis. The data from various sources had to be consolidated to a single data source in order to obtain a set of highly interactive dashboards.
Deliverables
- Provided solution to client through Tableau Server software Installation and setup
- Setup Infrastructure to deploy dashboards and dynamic reports to Server
- Involved in requirement gathering to deploy servers on different Environments
- Deployed Server on testing and Staging Environments with all specifications and Configurations needed
- Deployed Server on production environment and tested on all security aspects
- Build the whole Administrative part those are creating Publishing, Projects, Users, Groups, schedules
- Build Security on Servers of Project level, User level, Group Level and site level security as well.
- Deployed Dashboards on all environments and tested with high security levels
- Trained Customer on tableau software to use tableau dashboards with interaction.
Description
Scope
Scope of the project was to expand Tableau Business Intelligence replacing the existing system for Data analysis.
Deliverables
- Provided data filtering solution to client through several reports to understand the Insurance KPI’s
- Modified existed dashboards with the new KPI’s about outstanding claims and total claims
- Developed trend analysis reports for the higher management to understand the insurance claims
- Worked on visualizations to improve the dashboards and worked on performance
- Worked on Oracle data source and excel files to generate Tableau reports
- Provided remote support to handle issues & support cases.
- Preparation of Test Scenarios, Test Cases and Execution of Test Cases
Provided all documents related to project (Project Plan, Business Requirements, Technical requirements, User Manual, Test Strategy etc.)
Show More Show LessDescription
Scope
As part of to develop the dashboard we need to extract the data stored on Insightly, the scope of this project is to extract the data from Insightly and process it in a clean format the store on data base to create Tableau reports on top of it.
Deliverables
- Architected Data warehouse based on the KPIs.
- Provided data solution to client to get overall data from the Insightly CRM
- Implemented complete Data Integration Part using Talend DI and processed the data.
- Developed Talend jobs to pull the data from Insightly through REST API
- Used different components to design jobs and push data into database
- Build dashboards on Insightly data to do Opportunities analysis.
- Warehousing was replicated using Talend in order to provide the client the independence of choosing a suitable data.
- Data warehouse was populated in order to accommodate multiple areas of operations.
- Highly interactive dashboards were created and further customized for specific activities.
Description
Scope
Scope of the project was to expand Tableau Business Intelligence replacing the existing system for Data analysis. The data from various sources had to be consolidated to a single data source in order to obtain a set of highly interactive dashboards.
Deliverables
- Provided Visual solution to client to understand the business KPI’s.
- Involved in requirement gathering and data analysis to create Business requirement doc’s
- Setup Infrastructure to deploy the dashboards into client Tableau server
- Generated dashboards to understand the complete retail business cycle
- Used excel sheet, flat files, CSV files to generated Tableau Adhoc reports
- Used Oracle, MS SQL Server to generated Tableau reports
- Generated dashboards to help understand Sales performance over period of times
- Generated reports from different data sources by using blending to combine data sources
- Developed dashboards on stock analysis and ware house management
- Developed dashboards with best visuals to understand business for business users on sales and profits
- Provided training on Tableau desktop and server administration to users to create their own reports
- Provided all documents related to project (Project Plan, Project Estimation, Business Requirements, Technical requirements, User Manual, Test Strategy etc.)