Apurva Ghogare

BI Developer/Data Analyst

Email ID: adyj5s@r.postjobfree.com 571-***-****

linkedin.com/in/apurva-g-b9aa42255

SUMMARY :

●Around 6 years of experience in IT industry as BI Developer with Tableau and Business Objects with strong background in Databases and Data warehousing concepts.

●Expertise in Tableau Server, Tableau (2022.x,2021.x,2020.X, 2019.X10.X) cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader

●Experienced in Workday Reporting and Data Analyst will be responsible for performing research and analysis on solutions to meet the needs of the business, assess current configuration and identify opportunities to improve data quality and reporting.

●In-depth knowledge in programming languages Python and expertise in SQL.

●Good experience in Python, R, SQL, NoSQL, and Tableau within the IT industries. Hands on experience with building data pipelines in python/PySpark/Hive SQL/Presto.

●Expertise knowledge in Hive SQL, Presto SQL, and Spark SQL for ETL jobs and using the right technology to get the job done. Strong skills in SQL development an in-depth grasp of SQL reporting, analytics & business intelligence

●Extensive experienced in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.

●Great expertise in processing data and flowcharting techniques

●Excellent understanding of database structures, principles, theories and practices.

●Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.

●Worked on creating interactive, real-time dashboards using drilling downs & customizations.

●Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.

●Setup trusted authentication in Tableau server and pass requests from Web server

●Worked heavily using Tabadmin tools and Tableau cmd for setting up security profiles for various User groups and Users.

●Designed & setup user security for entire landscape to facilitate Windows AD login.

●Used Tableau cmd line tool for various Dashboard migrations from one environment to another.

●Setup of Distributed Server environments for optimum load balancing.

●Used efficient load balancing techniques to manage the load on the server for concurrent user logins.

●Created automated DAGs for tableau workbook refresh when not in live-connections

●Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.

●Experienced in managing schedules and scheduling workbooks and activities on Tableau Server

●Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems

●Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications

●Experienced in writing queries, stored procedures and functions using SQL.

●Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.

●Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.

●Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.

●Hands on experience in developing PL/SQL, Stored Procedure and UNIX Scripting.

●Knowledge in creating Crystal Reports using crystal reports formulas, Grouping, Parameters, selection criteria to handle the customer’s requests from Tables, Views and command objects.

●Quick Learner with excellent analytical and problem-solving skills with positive attitude towards new challenges

TECHNICAL SKILLS:

Business Intelligence Tool: Tableau Desktop 10.5/10.4 /10.2/10.1/10.0/9.3/9.2/9.1/8.0, Tableau server, Tableau Online, Cognos, SAP Business Objects, Crystal Reports, Power BI. Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, HIS, Apache).

Operating Systems: Windows 10/8/7/VISTA/NT/XP.

Programming Languages: Python, SQL, T-SQL, PL/SQL, HTML, XML.

Databases: MS SQL Server, Oracle, IBM UD2 DB2, MS Access 2000, SAP BW.

AWS: Cloud Technologies, Connecting Instances, Configuration Management, Linux System Administration, CloudFormation.

EXPERIENCE:

Move Inc., Austin, TX (remote) April 2021 – Present

Sr BI Developer/Data Analyst

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

●Responsible for data aggregation, data pre-processing, missing value imputation and descriptive and inferential analysis with R, Python, Tableau prep, Tableau desktop

●closely worked with client’s HR and Workday Implementation teams on inspecting, mapping, and transforming data, create models to generate insights, improve data integrity and inform a data governance framework.

●Develop client use cases to drive simplified and streamlined Standard Workday reporting catalogue.

●Conduct sessions with customers to analyze business requirements and processes and provide solutions to complex business problems.

●Provide subject matter expertise to create client standard operating procedures (SOPs) for Workday Reporting and Enterprise data stewardship and governance.

●Using best practices and Workday product knowledge, identify strategies, risks, and roadmap to meet current and future reporting and analytics requirements.

●Support change management strategies through client mentorship

●Support business development activities such as identification, proposal development, and other pursuit activities Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.

●Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.

●Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the dashboards.

●Develop and maintain reporting and analytical tools, including Business Objects.

●Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental.

●Got involved in designing the Data model for the Data warehouse and for different Data marts.

●Created dashboards and Business Intelligence (BI) visualizations using Tableau and Matplotlib to communicate the

●business process analysis reports from PL/SQL and Mongo DB databases.

●Experienced Working on Informatica Designer, Workflow Manager and Workflow Monitor for loading BI tables.

●Validation of data transformations & perform end-to-end data cushion for BI layer Tables.

●Developed and executed plan for data profiling, Unit Testing, Performance testing, SIT, UAT for BI Tables and Tableau.

●Performed End to end testing using SQL Queries in Oracle.

●Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-uses.

●Work with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations

USAA, Annapolis, MD Aug 2019–Feb 2021

Tableau Consultant /Data Analyst

●Built interactive dashboards and stories using Tableau Desktop for accuracy in report generation applying advanced tableau functionality: parameters, actions, tooltip modifications & API.

●Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.

●Extensively worked on metadata in Tableau desktop to modify data types, rename fields, joins, assign roles, refresh data and change extract data options to prepare data sources to be used by users.

●Developed effective and interactive Dashboards using Dashboard objects and Dashboard Actions.

●Created advanced analytical dashboards using Trend Lines, Forecasting, Linear Regression Models etc.

●Optimized existing pivot tables’ reports using Tableau and proposed an expanded set of views in the form of interactive dashboards using line graphs, bar charts, heat maps, tree maps, trend analysis, Pareto charts and bubble charts to enhance data analysis.

●Designed Alteryx workflows in Alteryx designer for data manipulation and data preparation.

●Translated business logic and rules from the existing system (SQL) to Alteryx.

●Involved in upgrade of Tableau Server from 10.0 to 10.3 and created Users Groups, Projects, and assigned Access levels in Server.

●Extensive worked on using spatial fields, geo maps and geo-coding.

●Defined best practices for Tableau report development and effectively used data blending feature in tableau.

●Extensively worked on performance tuning of Tableau dashboards using Performance recording feature.

●Created PL/SQL scripts for data extraction and transformation to ensure that the data is properly extracted for building Tableau dashboards.

FM Global, Johnston, Rohde Island Aug 2017 – July 2019 BI Developer/Data Analyst

●Deep experience with the design and development of Tableau visualization solutions.

●Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

●Used various ETL tools to extract data into Tableau Desktop and data wrangling using SSIS in data preparation phase.

●Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

●Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.

●Created External filter, internal filter and Context filter to improve performance.

●Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

●Used data connectors that are already available in Tableau, to read any site that publishes data in JSON, XML, or HTML.

●Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from various locations.

●Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

●Created parameters and quick filters.

●Created sets to display top products based on their sale.

●Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

●Created Dashboards with interactive views, trends and drill downs.

●Published Workbooks and Dashboards to the Tableau server.

●Combined visualizations into Interactive Dashboards and publish them to the web.

●Created groups and users in Tableau server

EDUCATION:

Bachelors Of Engineering - 2012 from Amravati University.

Contact this candidate