SUMMARY

• BI / Data visualization professional with 8 years experience in designing, developing and implementing BI and data visualization solutions with a focused data story telling approach to help stakeholders build an insight and understanding for their business problems and help make informed decisions
• Experience working with Data modeling using tools like Alteryx and Informatica.
• Extensive experience using Tableau Desktop, Tableau Server and Tableau online. Implemented Tableau Environments, Security, and Architecture setup.
• Involved in catering Ad - hoc business users requests. Extensive experience in building interactive reports, dashboards, and/or integrating modeling results and has strong Data Visualization design skills and analytic background. Created interactive Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality, Dashboards and stories as needed using Tableau Desktop. Worked on the development of Dashboard reports for the Key Performance Indicators KPI for the top management.
• Involved in integration of Tableau JavaScript API Filters in web application. Used Python (Tabpy), R and Web data connector to perform statistical analysis in Tableau work books.
• Extensive experience working on data models to create complex datasets using various techniques such as cross database joins, unions extracting data views/custom queries. Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows.
• Designed and developed reports and dashboards in Tableau using data in Hive (Hadoop) using Hive ODBC. Connected to Oracle, Microsoft Access, DB2, My-SQL, SQL server and Hadoop Hive, Sybase DB etc as data sources.
• Involved in Identifying and removing bottlenecks to improve the performance of dashboards and reports.
• Performed Tableau admin Tasks such as creating new Schedule's, deployment and checking the task's daily on the server. Experience in Production and Technical Support activities and managing production rollouts
• Worked on multiple projects and has been involved in reviewing business requirements, gathering business requirements, creating BRDs/FRDs and technical requirement specification documents, training end-users etc.
• Involved in writing test plans and test scripts, user manuals, run books and product support documentation.
• Experience troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements
• Excellent written, verbal and communication skills.

TECHNICAL SKILLS:

BI Tools: Tableau 2019,2018/10.x/9.x/8.x, Microsoft Power BI, SAP Business Objects Webi, Crystal, Xcelsius

Languages: SQL, PL SQL, Stored Procedure, Hive QL, Python, R, JSON, UNIX Shell Scripting.

Databases: SQL Server, Oracle, Teradata, AWS, Sybase, MS Access, Apache Hive

SDLC Applications: JIRA, Version One, TFS, Microsoft Office, SharePoint

ETL/Data Modeling: Informatica, Alteryx, Data Stage

PROFESSIONAL EXPERIENCE:

Confidential, Long Island City, NY

Data Visualization Consultant

• Created consumer lending KPI dashboards to display loan conversion rate to measure the efficiency of managing the pipeline.
• Developed Credit risk dashboards to display concentration analysis, % utilizations, risk factors on default loans, Return on assets, return on equity etc.
• Designed wireframes, dashboard templates as per the requirement with tabular reports, bar charts, water fall charts, Gantt charts, Bubble charts, Word maps, Geospatial visualizations etc.
• Created Calculated sets, parameters, action filters and URL actions to provide drill-down /summary to detail analysis. Created complex c calculations such as string manipulation, arithmetic calculations, custom Aggregations and Ratios. Used data blending to bring data from multiple sources.
• Used Tableau Data Extracts for improved performance. Used Performance monitoring tool of tableau desktop to analyze the performance of data heavy dashboards and implemented the best practices to optimize dashboards for a better user experience
• Utilized Tableau server to publish and share the reports with the business users.
• Assisted BI Center of Excellence (COE) team to critique, review and certify tableau dashboards to make go/no go decisions for production deployments.
• Used web data connectors to bring data in Tableau from various websites and performed Predictive analysis by using Tabpy.
• Defined and Designed the Tableau architecture, Security, environment set up and deployment process.
• Defined best practices for Tableau Report development by adhering to style guidelines and making visual pop-out.
• Worked with Business Analysts to streamline any data issues which involve Unit Testing of all the Worksheets.
• Used Alteryx to perform data manipulation/data modeling for Tableau presentation layer.

Environment: Tableau Desktop/Server, Oracle, SQL server, Python, AWS, Alteryx, JIRA, TabJolt, Tabadmin

Confidential, Baskin Ridge, NJ

Sr. Tableau Developer

• Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
• Used Tabpy to perform Statistical/Predictive analysis in Tableau.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Created views using various axes like Individual Axes, Dual Axes, and Blended Axes.
• Used Trend Lines, Reference Lines, and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Built Stories in Tableau with various Data points to narrate the data to the end users.
• Writing SQL queries for data validation by using join conditions.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Power BI, Xcelsius, SQL Server, DB2, TFS, JIRA, Web Data Connector.

Confidential, Houston, TX

Tableau Developer/Data Analyst

• Studied the data requirements and the impact analysis on the existing schema.
• Created visualizations reports on sales quotas, attainments and performance on various categories to ascertain the overall sales effectives of each program.
• Created stacked bars to show the quota and actual performance for each sales rep by region.
• Developed benchmark ticket price for each market to understand the quality of discounts offered.
• Created report using dual axes to show the gap in performance.
• Responsible for analyzing functional Specs and preparing technical specifications per business needs.
• Created Executive Dashboard Scorecard that provides sales reps and sales manager performance KPIs.
• Created story showing the performance of each sales rep since sales territory assignment.
• Developed reports for different sales management hierarchies.
• Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• Implemented Data blending to pull data from disparate sources.
• 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 Data extracts for better performance and accessing data offline.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business
• Change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Actively participated in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Environment: Tableau Desktop/Tableau Server, Teradata, Oracle, UNIX, TOAD, Version

Confidential, Rosenberg, TX

Tableau Data Engineer

• Set up profiles and created publications to distribute reports to users.
• Created graphical representation of reports such as Bar chart, Pie chart etc. as per the end user requirements.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Conversion of BO reports to Tableau
• Wrote complex SQL queries to fetch the data from Oracle, MS SQL Server and Created the Tableau worksheets, dashboards.
• Involved in creating TDE (Tableau Data Extract) using PYTHON script.
• Maintained permissions of Tableau Views and Dashboards.
• Extensively worked on parameters, Pareto charting, mapping, calculations, demographics and geographic fields.
• Worked with string functions, date calculations and swapping dimensions with parameters.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.
• Responsible to work with Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Used in depth features of Tableau like Data Blending from multiple data sources to attain data analysis.
• Involved in generating dual axis bar chart with multiple measures and data blending in case of merging different sources.
• Writing custom SQL quires to limit the data sourced into tableau thus improving Tableau performance.
• Integrating interactive location maps with the data analytics based on various filters and actions.
• Fixing defects logged in JIRA by QA and UAT team.
• Resolved the incidents and requests raised by the end-users.

Environment: Tableau Desktop, Tableau Server, SAP Business Objects, Python, Oracle, Composite, SQL Server.