SUMMARY

• 5+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive experience in Tableau ecosystems. In - depth knowledge on Tableau Desktop, Tableau Reader, Tableau Public and Tableau Server.
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online.
• Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Dual Charts, Action Dashboards and cascading reports using Tableau
• Strong advanced tableau developer skills such as complex calculations, table calculations, parameters, geographic mapping, data blending, and extract optimization.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at the application level, folder level and user level.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T-SQL statements for various applications.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Involved in Tableau Server installation, configuration, creating Users, Groups, Projects and assigning Privileges.
• Expertise in performance tuning and resolving the issues within tableau server.
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Extensive experience with technical problem solving, testing, debugging and troubleshooting.
• Strong knowledge of Software Development Life Cycle (SDLC)
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems
• Extensive experience with technical problem solving, testing, debugging and troubleshooting.
• Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements
• Installed, Configured, Administered Tableau Server environment in distributed systems and balance the load across multiple dispatchers
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in configuring reports from different data sources using data blending

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer/ Data Analyst

Responsibilities:

• Data Support Gathered and analyzed internal/external data with sales managers to identify and optimize market trends (based on region, industry, and other key metrics). Examined new data Sources, negotiated with vendors and made correspond reports/presentation to data Team
• Design Strategy & Territory Effectively supported decision-making by modelling various scenarios/industries; Through read up to 250 financial statements per one territory, designed and implemented profitable 10 territories (in Excel), aligning with corporate sales strategy; Analyzed and visualized outcomes (in Excel Pivotable/Tableau). Identified, evaluated and well communicated various market opportunities to sales managers, through building sales strategy, significantly helped market growth at 45% in 5 years
• Internal Consulting Received and solved worldwide sales team requires; Explained data to different team managers. Built multiple reports weekly and present to co-operate teams (in Tableau/PowerPoint)
• Involved in the requirements gathering process to prepare the business requirement documents.
• Developed Tableau dashboards using internal/external data to identify and optimize market trends (based on region, industry, and other key metrics)
• Examined new data Sources, negotiated with vendors and made correspond reports/presentation to data Team.
• Trained different team managers on Tableau and created best practices document for dashboard development.
• Developed multiple Tableau dashboards weekly and present to co-operate team
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts, etc
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Written Custom SQL to support Business and Compliance requirements and meet expectations from regulators.
• Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Executed and tested required queries and reports before publishing.
• Prepared and polished documentation and procedures that are data-related and are required by compliance team.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores

Environmen t: Tableau Desktop 10.4/10.1/9, Tableau Server Administrator, SQL Developer, MS-SQL Server 2008/12 R2, MS Excel

Confidential,

Tableau Developer/ Data Analyst

Responsibilities:

• Project: Option Price Analysis Conducted data processing/data mining on large datasets; Developed data automation software (applied Granger test in R) to validate integrity of option prices, customizing to clients’ needs, significantly increased scalability and data preprocess efficiency; Visualized data through dashboard (in Tableau/Excel) and conveyed information into project charter for clients.
• Project: Individual Asset Management Helped designed and tested automatic process to scraped data from InteractiveBrokers (in Python) and assigned in database (in MySQL) for manager use. Participated in design portfolios, build quantitative trading and investment strategies, Forecasted future cash flow (in Tableau)
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility; Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets like Yearly, monthly reports (in Tableau); Created Geographic map reports (in Tableau) which explained the company financial keys according to the members.
• Helped build official Website (Diaconiasolutions.com), Collaborated with colleagues resolving cross-functional operational issues
• Designed and tested automatic process to pull data from InteractiveBrokers using Python
• Used MySQL and Tableau as data analytical tools to analyze and understand trading and investment strategies data
• Integrated R in Tableau dashboard to forecast the cash flows
• Conducted data processing/data mining on large datasets; Developed data automation software to validate integrity
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets like Yearly, monthly reports in Tableau
• Used Custom SQL for joining the tables and selecting the required Data.
• Defined best practices for Tableau report development.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Used Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores

Environment: Tableau Desktop 10.3, Tableau server 10.3, MySQL and SQL Server 2012

Confidential

Tableau / SQL Server Developer

Responsibilities:

• Data storage Built various table for data storage usage, separated identification tables into different department dimensions
• Company verification Using internal database (in SQL), research revenue, and industrial information for company business, gathered and built dashboards to director for data analysis
• Financial/report support Formatted weekly/ monthly/ seasonally reports, gathered data from financial department and helped associates fill in the reports (in Excel Pivotable); Provided internal consulting to financial related department, interpreted manipulation progress to managers (in Tableau);
• Visualization training Helped training new associate in data team, created training content, including quick - start guides and workshop materials (Tableau/Excel)
• Gathering user requirements analyzed and designed software solution based on the requirements.
• Creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Used several built-in excel functions and formulas for report development and created different kind of operational reports using Excel.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created different kind of visualizations like Dual axis, forecasting, combined sets and Dual axis Geo maps.
• Imported data into excel from flat files and implemented pivot tables and charts in Excel for summarizing data.
• Created views with business logic to reduce database complexities for ad-hoc reporting
• Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Excel/Access/VBA.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Published Workbooks and Dashboards to the Tableau server.
• Defined reporting requirements and gather data, using Access and create management reports, also export data from MS access to MS Excel to create Pivot table for management do more analysis.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.

Environment: MS Excel, Microsoft SQL Server 2012, Access, Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3

Confidential

Tableau / SQL Server Developer

Responsibilities:

• Project: Brokerage Historical Documents Platform Assisted team building a brokerage historical documents platform, it is a web-based application which provides online support for users to deposit and view local Brokerage Historical Documents which are stored in Database (in SQL Server). This application provides rich User Interface and immediate processing for their search of local Financial Services, Common Proposals and Financial Planning related documents based on role authentication
• Analyzed financial statements for selected equities;
• Collaborated with team to optimize clients’ returns of asset management (based on individual preference on risk aversion & asset liquidity)
• Involved in the requirements gathering process to prepare the business requirement documents.
• Evaluated data by KPI analysis and comparable company analysis (in Excel). Export data from SQL Server and built monthly reports (in Excel/PowerPoint).
• Tracked operation status of online trading applications, ensuring smooth system operation with timely monitoring/backups; Performed timely updates, maintaining error-free data
• Involved in building a brokerage historical documents platform, it is a web-based application which provides online support for users to deposit and view local Brokerage Historical Documents
• Created normalized databases to support web application
• Developed various stored procedures to store the web application data in SQL Server Database
• Involved in the requirements gathering process to prepare the business requirement documents
• Created Tableau dashboard to show financial insights of selected equities and integrated in web application
• Evaluated data in KPI and comparable company dashboards
• Developed stored procedures to build various Monthly dashboards
• Developed complex SQl Queries and stored procedures using Joins, Sub queries and CTE etc., appropriately to clean, transfer and manipulate web application data
• Written required stored procedures for immediate processing for their search of local Financial Services, Common Proposals and Financial Planning related documents based on role authentication
• Tracked operation status of online trading applications, ensuring smooth system operation with timely monitoring/backups; Performed timely updates, maintaining error-free data
• Involved to create Documentation for Tableau training

Environment: Excel, Java, Linux, SQL Server 2012,Tableau 9.0