SUMMARY

• 8+ years of experience in BI industry and 7 years with Tableau.
• Expertise in Tableau 2021,2020,2019,2018.3,2018.2, 10.2/10.1/10.0/9.3/9.2/9.1/8.0 , Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Currently working on 2021.x version.
• Extensive experience working with Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader.
• Extensive experience working with Tableau and PowerBI.
• Expertise with performance tuning for the PowerBI server.
• Experienced in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Worked with different Machine Learning Algorithms like Linear Regression, GLM, Logistic Regression, Support Vector Machine (SVM), Decision Tree, K - Nearest Neighbours (KNN) and K- Means Clustering.
• Provided Data warehousing architecture by writing SQL query code based on detail requirements provided by marketing group.
• Expertise with performance tuning for the Tableau Visualizations and Tableau server.
• Used Tableau with AWS cloud connecting to AWS EMR and AWS redshift.
• Identify production faults and critical issues followed and troubleshoot them.
• Provide remedial measures to the production issues or process failure.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.
• Experience in Tableau report developing, testing and deploying reporting solutions using Tableau Server.
• Creating data model for tableau
• Worked on Data Warehouses with expertise in all phases of data warehousing lifecycle along with implementation and testing of software products.
• Strong understanding of project life cycle and SDLCmethodologies including RUP, RAD, Waterfalland Agile
• Expertise in ETL tools like SQL Server Integration Services (SSIS) and Relational Database Management Systems.
• Experience in creating Tableau reports based on the old MicroStrategy reports for external clients.
• Worked on Data analysis by using NumPy and SciPy libraries in python to filter unstructured data to structured format.
• Used Alteryx (version 10.5) as ETL tool to create modules that generated data sources required for the tableau dashboards.
• Proficient in automating data pulling from multiple resources by creating Alteryx ETL workflows
• Experience in Alteryx Designer, Alteryx Server and the tools within Alteryx such as Predictive, Spatial, Data Investigation, Parsing and Transforms.
• Translated business logic from one system (SQL, Excel, etc.) into Alteryx in a quick and accurate manner
• Hands-on-experience with Pandas, SciPy and NumPy packages in Python for data analytics.
• Largedata sets manipulation, datacleaning, quality control, and datamanagement (Python, R, SQL).
• Working knowledge of software development methodologies such as waterfall, agile, lean, XP, etc.
• Experience with Statistical analysis, Stat packages mainly in R/python.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience working on Agile Methodologies. Waterfall SDLC methodologies
• Strong team member with good communication and analytical skills.
• Excellent problem solving, troubleshooting and decision-making skills.

TECHNICAL SKILLS

BI Tools: Tableau Desktop (2020.4, 2020.x, 2019.x/2018.x/10.x/9.x/8.x/7.x), Tableau server, Tableau Online, Microsoft Power BIServers: Application Servers (WAS, Tomcat), Web Servers (IIS, HIS, Apache).

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

Databases: SQL, HANA, Snowflake, Oracle

Machine Learning: Sklearn, Pandas, NumPy, TensorFlow, Matplotlib, Clustering Techniques, XgBoost.

Other Tools: Alteryx, MicroStrategy, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Sr. BI Consultant

Responsibilities:

• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases.
• Involved in reviewing business requirements and analysing data sources form Excel/Teradata SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (2021.x, 2020.x).
• Design, development and deployment ofTableaureports onTableauDesktop 2021.x and 2020.x.
• Gathered user requirements, analysed and designed software solution based on the requirements.
• Experienced in creating Prototypes, Wireframes and Mock-Up Screens to visualize (GUI).
• Used techniques like data blending which brings data from multiple data sources into a single view in Tableau.
• Designing and development of Tableauvisualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved as a technical expert providing input to application design regarding production using and administration requirements.
• Worked on PowerBI for creating dashboards.
• Implemented PowerBI Dashboard reporting solution for different groups in the organization.
• Designed and developed PowerBI Dashboards based on the Client requirement in timely manner.
• Designed, developed and tested various Power BI/Tableau visualization for dashboard and ad-hoc reporting solutions.
• Created Power BI Visualizations and Dashboard as per the requirements.
• Configured Power BI Dashboard and reports.
• Worked with Power BI, Datazen, DAX expressions, Power View and Power Query
• Import data from Tableau into Power BI using different ETL methods, SQL Azure, Direct Query, and Restful API. Generator build relational model within Power BI generate marketing Campaigns metrics related to landing pages, Email Analysis and visitors
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations based on the design specifications
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Designed several business dashboards using Power BI, Tableau Desktop, Tableau server and hosted them across the client servers
• Created and scheduled Alteryx workflows.
• Experience in integrating Alteryx and tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on server though Web data connector into tableau Desktop.
• Data Manipulation and Extraction using Alteryx from various data sources, which in turn is used to feed data in to Tableau.

Confidential, NYC

BI Developer

Responsibilities:

• Worked on designing and development of Tableau visualization solutions and created Business requirement documents and plans for creating dashboards
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Defined best practices for Tableau report development and effectively used data blending and multiple data sources joins in Tableau 10.1
• Provided visibility in real-time using active and passive scanning and third-party connectors.
• Efficiently fed configuration management and asset management databases using Ivanti
• Implemented Tableau mobile dashboards via Tableau financial application
• Predictive analytics using Alteryx and mapping geographical data using Alteryx
• Used workflows in Alteryx and published to Alteryx server for frequent data loads that feed Tableau reports
• Experience in working with unstructured data developing workflows in Alteryx Designer with documentation and implementation of the processed data.
• Worked on ETL tool like Alteryx to transform data sets and transform data types to meet the requirements.
• Troubleshoot and performance tuned complex ETL mappings to reduce the session run time.
• Improve Reports performance in tableau using extracts and context filters.
• Involve in ETL applications, data feeding, cleansing, archiving and re-modeling
• Used Alteryx to provide analysts the unique ability to easily prep, blend, and analyze all of their data using a repeatable workflow.
• Connected to the AWS Redshift and Snowflake directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Established Snowflake Data Architecture for Data backing the KPIs
• Involved in reviewing business requirements and analysing data sources from Snowflake, Excel/Oracle, SQL Server /AWS for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Designed and Developed ETL workflows for datasets in Snowflake.
• Implements data structures using best practices in data modeling, processes, and technologies.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Designed several business dashboards using Power BI, Tableau Desktop, Tableau server and hosted them across the client servers.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Strong knowledge/experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Responsible for creating SQL datasets for Power BI and Ad-hoc reports.
• Utilized machine learning algorithms such as linear regression, multivariate regression, Naive Bayes, Random Forests, K-means, & KNN for data analysis.
• Used Python Matplotlib packages to visualize and graphically analyses the data.
• Data pre-processing, splitting the identified data set into Training set and Test set.
• Performed data wrangling to clean, transform and reshape the data utilizing pandas library.
• Analysed data using SQL, R, Python, Apache Spark and present analytical reports to management and technical teams.
• Worked on change requests, identifying the defects and working on resolution, processing on SSIS Packages.

Confidential, Peoria IL

Sr. BI Data Analyst/Data Engineer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
• 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.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion
• Importing tables using Warehouse catalogue and Creating Logical Tables
• Created Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
• Import data into power BI using different ETL methods, SQL Azure, Direct Query, and Restful API.
• Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.
• Used python to extract financial data from various sources and integrated them into one single data set
• Worked on Data analysis by using NumPy and SciPy libraries in python to filter unstructured data to structured format.
• Architect, design and validate Azure infrastructure-as-a-Service (IaaS) environment
• Worked with Azure transformation project and Azure architecture decision
• Azure Cloud Build and Automation using ARM template
• Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise systems/applications to Azure cloud.
• Experience in implementing python alongside using various libraries such as matplotlib for charts and graphs, MySQL dB for database connectivity, Pandas for data manipulation.
• Built and analysed datasets using Python and R (in decreasing order of usage).
• Used Python NumPy, SciPy, Pandas packages to perform dataset manipulation.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Improved slow performance queries by looking at the execution of complex SQL queries
• Modified & maintained complex SQL Server stored procedures, views, ad-hoc queries Report Designing & Maintenance
• Designed, deployed, and maintained complex canned reports via SQL Server 2008 Reporting Services
• Deployed & executed the packages in both Development & Production environments

Confidential, Santa Clara CA

Data Analyst/Tableau Developer

Responsibilities:

• Conversion of extreme level design specifications to detailed technical, functional specifications and interacted with business users for gathering requirements for Tableau Workbooks and Dashboards.
• Performed current state analysis to assist in the definition of new concepts. Maintain the cash flow model on a daily basis and prepared quarterly cash flow forecast and conduct variance analysis.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Designed and developed Dashboards based on the Client requirement in timely manner.
• Data pre-processing, splitting the identified data set into Training set and Test set.
• Performed data wrangling to clean, transform and reshape the data utilizing pandas library.
• Analysed data using SQL, R, Python, Apache Spark and present analytical reports to management and technical teams.
• Used R to support the SQL analysis by implementing exploratory data analysis.
• Prepared use cases in Tableau and look and feel documents and got reviewed with end client.
• Worked on editing data connections and changing data sources in Tableau
• Handled tableau admin activities like granting access to users, managing extracts and installations.
• Specialized in analysing and editing metadata (dimensions and measures) and saving data sources.
• Created worksheets by creating join/data blending, custom SQL and data source filters.
• Used various join types (left, inner, right, outer joins) based on business requirements.
• Used techniques like data blending which brings data from multiple data sources into a single view in Tableau.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Bubble Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
• Used symbol maps, filled maps and other map options to plot geographical data.
• Created Tableau field maps feature with specific geographical roles.
• Used Show Me for creating visual analytics.
• Created interactive visualizations by adding quick filters.
• Analysed data using Filter Shelf, Conditional filters (by using formula), and Dynamic measure filters.
• Created worksheets using parameters and used features like sorting, grouping, sets.
• Made data analysis easy to client by generating crosstab, aggregating data, using trend line, using page shelf and forecasting data.

Confidential

Data Analyst

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Used SQL extensively in command objects of Crystal reports.
• Tested the reports for accuracy using SQL queries in TOAD and SQL Developer.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Used Crystal Reports 2008 to develop reports with Dynamic parameters according to the requirement
• Converting high-level design specifications to detailed functional and technical specifications.
• Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
• Worked on background images which include plotting data on image.
• Worked on workbook permissions, ownerships and user filters.
• Experience in Multiple polynomial regression, Support Vector Regression, Decision Tree Regression, Random Forest Regression using Python & R.
• Used python to extract financial data from various sources and integrated them into one single data set.
• Experienced in web scraping using Beautiful Soup package in Python.
• Created interactive visualizations by adding quick filters.
• Created worksheets using parameters and used features like sorting, grouping, sets.
• Made data analysis easy to client by generating crosstab, aggregating data, using trend line, using page shelf and forecasting data.
• Scheduled extract refresh for weekly and monthly reports
• Analyzed data using Filter shelf, Conditional filters (by using formula), and Dynamic measure filter.
• Involved in created stored procedures, views, and custom SQL queries to import data from sql server.