Saroj Wagh

Tableau Developer/Business Intelligence Analyst

adwpye@r.postjobfree.com

201-***-****

S U M M A R Y

• Tableau Developer with 6+ years of extensive IT experience in Software Development, Integration, Implementation, and Maintenance of Business Intelligence applications and related Database Platforms.

• Experience in Tableau Desktop, Tableau Prep, Tableau Server, Reader, Public, and Mobile in recent and current versions of Tableau.

• Proficient in the design and development of various dashboards, and reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization, and others making use of actions, and other local and global filters according to the end user requirement.

• Experience in creating dashboards with relational and multi-dimensional databases including SQL, and Oracle at gathering and manipulating data from various sources.

• Strong understanding of project life cycle, and SDLC methodologies including RUP, RAD, Waterfall, and Agile.

• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, and logical, component, and deployment views to extract business process flow.

• Expertise in Tracking, Documenting, Capturing, Managing, and Communicating the requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.

• Excellent analytical, problem solving and Tableau and SQL debugging skills.

• Organized Joint Requirement Planning sessions, Interviews, and Requirement Elicitation sessions with end-users, clients, Subject Matter Experts, and the technology group.

• In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.

• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.

• Deployed and managed users’ permissions for reports and dashboards on Power BI web portal.

• Introduced Power BI after presenting POCs to the higher management.

• Experience in using various MS office tools for analyzing, arranging, and presenting data.

• Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel on various environments.

• Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on Windows.

• Gathering and manipulating data from various sources like SSMS, MicroStrategy metadata, Prism and HANA.

• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

• Experience in creating and implementing interactive charts, graphs, and other user interface elements.

• Business Objects Analyst with strong functional and technical skills to help create reports from scratch to support global financial organization.

• Experience working directly with business users, eliciting requirements, developing complex reports using Webi, using SQL, and delivering reports is required. S K I L L S

Data Visualization, Business Intelligence (BI), Software Management, Data Collection, Tableau, Tableau Desktop, Tableau Server, Tableau Prep, Tableau Server Administration, SAP ERP, SAP S/4 HANA, SAP Fiori, SAP GUI, SAP Business Objects, Crystal Reports, MS SQL Server, Oracle, SQL Server Management Studio, SQL Server Reporting Services, MicroStrategy Desktop, MicroStrategy Development,

MicroStrategy Architect, SQL, HTML, MS PowerPoint, MS Excel, MS Word, Windows 7/8/10, Analytical Thinking and Problem Solving, Detail-oriented, Accuracy, Variance Analysis, Defining Business Requirements.

E X P E R I E N C E

Triveni Group LLP, NJ Jan 2023 - Current

Role: Business Intelligence Developer

Responsibilities:

Tableau

• Preparing data for use by Tableau and establishing connections to Data Sources.

• Adding or Creating Dimensions, Measures, and Calculations as well as performing Data Modeling in Tableau Desktop.

• Developing Workbooks and Hyper Extracts on Tableau Desktop, publishing Workbooks and Data Sources to Tableau Development and QA sites and refreshing Extracts on Development and QA sites.

• Developer with expertise to create visualizations that provide business insights for our customers and business partners.

• Monitoring the status of extract schedules on QA site while performing Unit Testing on Development and QA sites.

• Resolving any data or performance issues related to workbooks and data sources and management of the application's user/group and integration with Active Directory.

• Documenting contents in a data warehouse and meta-data storage; and creating technical documentation for BI tools.

• Expertise in SQL can independently mine data to translate Business data needs into creative visualizations.

• Support peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting, analysis of results.

• Participate in business analysis activities to gather required reporting and dashboard requirements. SAP Business Objects

• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources

• Participate with other specialists to convert legacy reports (primarily Cognos) to Business Object reports

• Provide support to an external system in creating Business Object Universe, data mapping, validating the universe, and providing technical assistance as needed Design report layout and determine the best way to offer data to end users.

• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users

• Hands-On experience on the entire SAP Business Objects product suite, which includes Universe, Reports, Dashboards, EPM components development

• Hands-On experience with Microsoft SQL Server, PostgreSQL, Stored Procedures, and Entity Relationship diagrams

• Hands-On experience in Business Object Administration i.e., user, content, and server management.

• Experience in developing and maintaining Business Object reports universe and metadata. Charter Communications, MO Feb 2020 – Dec

2021

Role: Business Intelligence Analyst III

Responsibilities:

Tableau

• Creating dashboards with relational and multi-dimensional databases as the requirements from various departments within the organization using Tableau.

• Monitored Application Server and Tableau Data server activity to track performance and system availability while tuning the performance of workbooks, data sources and providing best practices for user community.

• Management of the application's user/group and integration with Active Directory.

• Tableau server user/group setup, permission controlling, security roles, configuration of trusted ticket authentication.

• Utilize knowledge on Tableau desktop, Tableau viewers and Tableau server. SAP and SAP Fiori, SAP Business Objects (Web Intelligence), HANA

• Analyzing reports and fulfilling the business needs using SAP and Fiori from all environments. Extensive - knowledge in Business Objects BI Platform (BOBJ) - Migration, Deployment, Universe Design, Advanced Information Design, Web Intelligence, BI Launchpad, and Analysis.

• Analyze business requirements to determine appropriate technology solutions. Analyze change requests to determine feasibility in relation to existing business requirements and processes.

• Leverage knowledge of data warehouse and BI methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, developing timelines, and resource estimates.

• Define and drive a current and future state architectural HANA reporting roadmap that ensures that all initiatives are aligned with the goals of the business and projects are completed with the highest level of quality.

• Designing, developing, and testing data models and calculated views for report building. Integrating SAP Business Objects (4.2/4.3) tools with BW Queries and HANA views.

• Ability to adjust HANA calculation views as needed and perform the validation against the data from the source systems. Interface with developers and business analysts to understand whether we can meet business and technical requirements.

• Design, document, and implement unit, integration, and regression test plans.

• Work with business partners and the testing team to develop acceptance criteria/test cases to develop a comprehensive test plan and perform needed application testing.

• Develop and modify new/existing universes and reports.

• Have expert-level knowledge of Business Objects universe configuration (parameter settings, etc.) and universe design aspects (resolving loops, contexts, aliases, cardinality, etc.) Expertise with SAP Information Design Tool.

• Work interactively with both technical and non-technical staff to build Business Objects universe layer that adheres to the underlying data model and effectively delivers data to end users.

• Understand logical and physical data modeling and methods for optimizing the Business Objects universe against the physical model. Have expertise in SQL.

• Work with customers gathering requirements for creating Complex reports and dashboards.

• Have extensive experience working with Business Objects Web Intelligence.

• Excellent ability to present data in a meaningful and visual way.

• Be principally responsible for designing Business Objects universe layer for business intelligence solutions. Optimize the performance of Business Objects constructs. As necessary, communicate with data modelers/DBAs to optimize database for reporting performance.

• Test developed reports to validate whether requirements have been met and assist users in testing.

• Maintain all documentation, including business and technical requirements, report requirements, and support documentation.

MicroStrategy

• Designing and creating various analytical reports and automated dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using MicroStrategy.

• Investigate and manage development of design and procedures for metric reports.

• Work with executives and key business users to define, develop and maintain a set of core dossiers to improve department efficiency and track departmental KPIs.

• Analyze complex business problems and issues using data from internal and external sources to provide insights to business leaders.

• Create specifications for reports and analysis based on business needs.

• Communicate data model and reporting requirements to IS team.

• Provide consultation to users and lead cross-functional teams to address business issues. Produce datasets and reports for analysis using system reporting tools. JUUL Labs, MO Sept 2019 – Feb 2020

Role: Tableau Developer

Responsibilities:

• Developed various dashboards illustrating data visualizations using Tableau Desktop.

• Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects, and scheduling instances for dashboards in Tableau.

• Defined best practices for Tableau report development.

• Involved in creation of users, groups, projects, workbooks, and the appropriate permission sets for Tableau server logons and security checks.

• Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.

• Created drill through reports in dashboard.

• Involved in creating data blending in case of merging different data sources.

• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.

• Worked on Data Zen and had a good knowledge in creating the dashboard which best suites the requirement.

• Understanding of relational database structures, theories, principles, and practices.

• Monitored Application Server and Tableau Data server activity to track performance and system availability. Roche, OH Jan 2019 – Aug

2019

Role: Tableau Developer

Responsibilities:

• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.

• Used Tableau for the data/business predictive analysis, for trending, and for finding the pattern of data over the period.

• Building customized and interactive dashboards using multiple data sources.

• Preparing dashboards using calculated fields, parameters, calculations, groups, sets, and hierarchies in Tableau.

• Gathered user requirements, analyzed, and designed software solutions based on the requirements.

• Building, and publishing customized interactive reports and dashboards, report scheduling using Tableau server.

• Created worksheets and dashboards by using custom queries and multiple tables.

• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

• Effectively used data blending feature in tableau.

• Defined best practices for Tableau report development.

• Administered user, and user groups, and scheduled instances for reports in Tableau.

• Executed and tested required queries and reports before publishing.

• Developing Standards and Creating reports using Tableau Desktop.

• Developing Attributes, Facts, Metrics, Filters, Prompts, and Hierarchies as per Specifications for developing reports.

• Creating DB views for reporting purposes.

• Preparing Report Mapping Documents as per Specifications.

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

• Analyzed requirements for various reports, dashboards, and scorecards and created a proof of concept / prototype the same using Tableau desktop.

• Mentored business power users to create reports/dashboards using tableau desktop.

• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

• Extensively used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts, etc., to assist business users in solving complex problems.

• Utilized advanced features of Tableau software like linking data from different connections together on one dashboard and filtering data in multiple views at once.

• Created Prompts, customized Calculations, Conditions, and filters (Local, Global), Parameters, Groups, and sets for various analytical reports and dashboards. Lamda, INDIA Sept 2014 – Jun

2017

Role: Tableau Developer

Responsibilities:

• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.

• Conducted gap analysis for re-engineering and upgrading the current system wherever necessary.

• Analysis of Business requirements and site specifications to create a Business Requirement Document

(BRD) and Design Document (Functional and Technical).

• Eliciting and translating business and/or technical needs into relevant documentation for assigned initiatives/projects.

• Designed the conceptual and business process models. The physical design of data record data files and databases.

• Involved in writing Test Cases, procedures, reports, and approval of software releases.

• Monitoring the project during the Development phase and being involved in User Acceptance Testing (UAT) once the change requests are released from system testing.

• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, and Informatica mappings to improve the performance of Tableau and Power BI reports/Dashboards.

• Comprehend business needs within the BI framework, develop data models for converting raw data to valuable insights, and build interactive reports and dashboards using Power BI/Tableau for visualization.

• Create, develop, and deploy Power BI scripts, perform a thorough analysis, recognize KPIs with specific goals, and maintain continuous monitoring.

• Execute DAX queries and functions in Power BI for data manipulation and modeling.

• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau and Developed mappings and workflows to extract data files used as sources for various Tableau reports.

• Designed a business intelligence dashboard using Tableau Desktop and published the same on the Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations.

• Designed and developed complex interactive reports and Dashboards using calculated fields, parameters, calculations, groups, sets, and hierarchies in Tableau with different data visualizations using Tableau desktop on customer data.

• Developed Technical requirements, design requirements, and user acceptance documentation by placing Screenshots of actual Reports and tested reports in the documentation.

• Deployment of defect-free code while managing the timeline set for the project. E D U C A T I O N

Master of Science in Health Informatics, University of Findlay – OH, USA

Contact this candidate