SUMMARY

• Over 10 years of BI experience with expertise in Analysis, Design, Development, and Implementation of BI tools - Tableau, Power BI, Sisense.
• 2 years of Python experience using data science libraries like Pandas, NumPy, SciPy for examining and designing data sets.
• Actively involved in full BI life cycle development including design, data modeling, developing visualizations and dashboards along with testing, production migration and maintenance.
• Created database correlations, dashboards, KPIs to drive real-time decision-making, and champion impactful predictive modeling by using business expertise, data understanding, and analytic experience
• Design and deploy rich graphic visualizations and dynamic reports with hierarchies, parameters, sets, groups, maps, images.
• Created dashboards using Table calculations, LOD calculations, calculated fields using Window functions and worked on advanced Analytics like Reference Lines and Bands, Trend Lines, Clusters etc.
• Extensive experience in Tableau Administration - configuration, manage users/groups, data connections, scheduling tasks, embedding dashboards with other platforms
• Proficient with shell scripting and Cron jobs on Unix/Linux
• Highly proficient in SQL, PL/SQL including writing stored procedures, functions and triggers.
• Strong understanding of relational and DMR models and helped in designing BI data warehouse using Star, Snowflake schemas
• Designed datawarehouse schemas for Snowflake data and Marketo data using Star schema methodology.
• Experience in effectively communicating with various business groups to prepare functional and business specific technical documentation.
• Experience working in Waterfall and Agile development environments that included iterative application development, weekly sprints and daily stand up meetings.

TECHNICAL SKILLS

BI Tools: Tableau, Power BI, Sisense

Analytics: Python (Pandas, NumPy, SciPy, Matplotlib libraries), JavaScript

RDBMS: PostgreSQL, Snowflake, Oracle 11g, SQL Server 2016, SAP HANA

ETL/Integration: MS SSIS, Dell Boomi

Environment: Windows Server, UNIX

Others: GitHub, Docker, Postman, JIRA, Active Directory

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

BI Consultant

Responsibilities:

• Created Sales dashboards like Health of Business, Blackbelt training, Focus Technologies using data from SAP HANA and Snowflake.
• Developed multiple Stored Procedures to load required data into HANA tables and the parameters for the procedures are passed from UI frontend.
• Worked extensively with Advance Analysis - Action Links, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Worked across departments to identify and understand key business questions, and standardize key metrics.
• Implemented security in Tableau using parameterhash, username, sessionid functions.
• Updated multiple existing dashboards which are slow by recreating the data sources and updating underlying calculations for better performance.
• Involved in discussions to scale up Tableau servers for handling multiple teams getting on boarded in the future.

Environment: Tableau 2019.3/2020.2 , SAP HANA, Snowflake, Salesforce, JavaScript

Confidential, Pleasanton, California

BI Datawarehouse Consultant

Responsibilities:

• Worked with Sales, Marketing, Commercial Management teams to understand and gather required data to be loaded into Snowflake datawarehouse, dashboards are created and shared in Tableau.
• Lead the project which required data to be loaded from Salesforce and Marketo into Snowflake using Dell Boomi; designed and created Dims, Facts based on requirements.
• Created full Marketing Funnel Cycle dashboards based on Salesforce, Marketo data showing data in different stages from Prospect to Customer as well as ROI Dashboards based on Campaigns, Opportunities and media costs.
• Created 20 dashboards based on Sales(Salesforce) and Finance(Bookings, Invoice) data as part of migration from Qlik to Tableau.
• Adhoc reports are created for quick reference to Finance(Oracle Netsuite, Fusion), Sales, Marketing users and data sources are developed for adhoc reporting.
• Reduced redundant requests and manual efforts in generating “Forecast Bookings” reports for business users by providing self-service portals using Tableau Visualizations to serve 300+ business users.
• Created dashboards to show QOQ, YOY, YTD, QTD, Quota vs Actual sales metrics.
• Used user filters to restrict data by group, region and user level and used Blends to join data between different data sources.
• Used Tableau bridge to schedule extract refreshes and maintained the different schedules based on regions.
• Views, Procedures in snowflake are developed for specific use business use cases.
• Maintained Tableau Server and created security gropes based on user profile.

Environment: Tableau 2020.1, Snowflake, Dell Boomi, Salesforce, Marketo, JSON, JavaScript, Service Now, Netsuite

Confidential

BI Engineer

Responsibilities:

• After data is collected from various channels, it is analyzed, cleansed and interpreted for trends or patterns using python.
• Worked on Python libraries like Pandas, NumPy for cleansing and aggregating the data (source CSV and Excel) and loaded into PostgreSQL and Redshift for data projection.
• Developed POC's on word count and Predictive Analysis using Sci Py Functions in Sisense
• Configured virtual machines or Docker containers to run standalone simulations for running Python scripts.
• BI Project involves implementation of Mapbox API, multiple charts, images with annotations in BI tools like Tableau, Sisense to enhance the midstream services data for more interactive and effective analysis.
• Embed Tableau and Sisense dashboards into micro apps using JavaScript and implement SSO based security using JWT and URL Images in dashboards are hashed using MD5 algorithms from Limelight CDN.
• Create views as required as data sources. Raw data in the form of JSON requires manipulation, so views are created.
• Enhance existing application using Java script API to implement out of the box techniques in Tableau JavaScript API and Sisense. Images should be displayed with annotations; this functionality is implemented using JavaScript API in Tableau.
• Used SQL scripts to import data in Data source tab from multiple data sources and performed data blending.
• Developed reports involving complex calculations, aggregations, drill thru functionality, and conditional formatting
• Extensively used advanced chart visualizations like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, Funnel charts with Trend Lines, Reference lines, Forecast lines and Clusters.
• Created and maintained materialized views for adding external data instead of using tabular SQL in reports for faster performance.
• Performed admin duties like creating and maintaining schedules and jobs, optimizing report performance, maintaining security, creating data sources, deploy reports, dashboards and packages between DEV, STG and PROD

Environment: Python 3, Tableau 2018.3, Sisense 7, Rally, PostgreSQL, Amazon Redshift, JSON, JavaScript, GitHub

Confidential

Technical Lead - Reporting and Analytics

Responsibilities:

• Worked with Sales and Procurement team to load data from source to reporting data warehouse and build, workbooks, dashboards, stories based on user requirements.
• Linked data from different data sources together and implemented data blending in Tableau to create dashboards and workbooks
• Created workbooks with dashboards and stories using calculated fields, table calculations, hierarchies, sets, bins & parameters
• Extensively used advanced chart visualizations like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, Funnel charts with Trend Lines, Reference lines, Forecast lines and Clusters.
• Created Dashboards that provides sales performance by Region and stories showing performance of each sales territory.
• Scheduled data refreshes on Tableau server to ensure data in workbooks and dashboards reflects source systems.
• Used Extracts instead of live connection for performance improvements and offline access to dashboards and created extracts daily for data accuracy.
• Automated server scripts with Cron, on schedules by placing the scripts in crontab files.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and calculation views in HANA Studio.
• Involved in Transport management of HANA models across different systems. Migrated HANA content from Development, UAT environments to Production environment using delivery units.
• Created and maintained materialized views for faster query performance to add data form an external data source instead of using regular views.
• Acted as admin with duties like maintaining schedules and extract refreshes, optimizing performance, maintaining security, creating data sources, deploy workbooks and dashboards between UAT and PROD
• Work with support team to install/upgrade fix packs and discuss potential fixes for the future versions

Environment: Tableau Desktop/Server 10.2, MS SQL Server 2016, Oracle 11g, SAP HANA 1.0, CLM, SQL Developer

Confidential, Houston, Texas

Tableau Developer

Responsibilities:

• Interacted with the Business Users and Analysts for gathering project requirements and prepare detailed design specs.
• Cleansed and pre-filtered data using Data Interpreter and pivot, split functionality. Used joins and blending techniques to compare and merge data for dashboards requiring data from multiple data sources.
• Created Executive Dashboards that provides insight on vendor performance and sales for related Capital project spending and Risk Analysis
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes, Used Trend Lines, Reference Lines, box plots and Annotations to describe the data.
• Created groups, parameters and dynamic sets, hierarchies for preparing worksheets and dashboards in Tableau Desktop.
• Used parameters and input controls to give users control over data they want to see on the dashboards.
• Implemented filters at different levels - Data source filters to limit data available for reporting, context filters for better performance, action and quick filters for user convenience.
• Created Data extracts for non-crucial data for better performance and accessing data offline.
• Developed Custom Geo-coding for organizational territory alignment requirements, since the project involves pipeline maps worked on implementing Google earth maps using Spatial files, kml ( Keyhole Markup Language ) files in Tableau
• Scheduled data refresh on Server with weekly and monthly increments to ensure output in the views and dashboards are reflecting accurate results.
• Assisted and worked with Data Stage ETL developers to make sure that model being developed is according to the business requirements.
• Lead a Team of 4 developers and support along with managing development and release activities through JIRA (agile project tracking tool) and provide weekly Status Reporting for the PMO office.
• Managed dashboard migrations between different environments, and managed Data Sources, run activities, creation and maintenance of user accounts and permissions.

Environment: Tableau Desktop/Server 9/8, Power BI 2.4, MS Active Directory, JIRA 6.3, IBM AIX, MS SSIS 2016, Oracle 11g, DB2 10.5