PROFESSIONAL SUMMARY:

• 6+ years of IT experience in Business Analysis, System Analysis, Data Analysis, Software design, development, testing and maintenance of Business Intelligence/Data Warehousing environment across Entertainment, Financial, Insurance, Healthcare, Transportation, Technology and Banking industries.
• Tableau Desktop 9 Qualified Associate with 7 years extensive experience in working with Tableau 10.x/9.x/8.x/7.x product suite (Desktop, Server, Public, Reader, Mobile) and other BI technologies like Power BI, QlikView, Microsoft and Informatica etc.,
• Over 6 years of experience as Business Intelligence Analyst/Data Analyst and Tableau consultant
• Experience building Tableau visualizations using Tableau desktop and server accessing data from multiple environments like Microsoft SQL server, Teradata, Oracle database including Big data and cloud environments like Hadoop data sources and Amazon S3
• Explicit experience writing complex queries on T - SQL, PLSQL, Hadoop via spark SQL to build required data sets based on business requirement.
• Experience building complex charts including Tree maps, Heat maps, Gannt Charts, Funnel charts, Dual axis charts and Box plots etc., using Tableau Desktop
• Extensive experience in presenting Tableau visual analytics and best practices like Story Points, Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experience working with User level permissions on Tableau dashboards, worksheets and views
• Strong understanding of Project Life Cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration, Data Modelling, Data Cleansing, Transformation, Data Import, Data Export and Metadata Management Services and Configuration Management.
• Experience working in Hadoop, Spark, Scala, Teradata, Bigdata environments
• Expert in designing, development and maintenance of Data Analytical Applications (metrics, reports, analysis, KPIs & dashboard for data visualization) using report tools like Tableau, SSRS, SSAS, Qlik View and Excel.
• Experience in importing, transforming, wrangling, munging and analyzing data and creating visualizations and reports using R and Python.
• Experience with JavaScript API to customize the views, selects, filters, date and time and embedding Tableau visualizations in web pages
• Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart-Box (Drill Down, Drill up & Cyclic Grouping), Heat Maps, Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations…etc.,
• Strong Knowledge in implementing statistical models using R and Python.
• Experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Embarcadero.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Strong understanding of Data warehouse concepts like Kimball/Inmon methodologies, Star Schema, Snowflake Schema, Dimensional data modeling, Factsand Dimensions tables, physical and logical data modeling.
• Proficient in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Experience in developing and deploying projects with Python, and frameworks such as DJango/Flask using one or more of MySQL, HTML and Linux (UNIX).
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
• Good experience using various Python libraries to speed up development (libraries used: Beautiful Soup, NumPy, SciPy, Matplotlib, python-twitter, Pandas data frame, network, urllib2, MySQL dB for database connectivity, JSON libraries).
• Knowledge in R language, Hadoop, big data analytics, ML packages and datamining.
• Proficient in writing complex SQL queries, stored procedures, normalization, database design, creating indexes, functions, triggers and sub-queries.
• Extensively worked with various database systems like Oracle, Teradata, DB2, MS Access, Flat files, XML and SQL Server.
• Good Data Warehousing concepts including Metadata and Data Marts.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams
• Extensive experience in project management best practices, processes, & methodologies, including Rational Unified Process (RUP) and SDLC.
• Experienced to work as a Data Analyst to perform complex Data Profiling, Data definition, Data Mining, validating and analyzing data and presenting reports.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validations for all the reports and dashboards generated from various database sources.
• Outstanding knowledge in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Flexible, enthusiastic and project-oriented team player with excellent communication skills with leadership abilities to develop creative solutions in challenging environments.

TECHNICAL SKILLS:

Analytical Tools: Tableau10.X/9.X/8.X/7.X (Desktop, Server, Reader, Public), SSRS, Power BI, Qlik View

Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Data Integration Tools: Alteryx, Informatica Power Center, SQL Server DTS, SSIS

SQL Tools: Rapid SQL, Toad, Teradata SQL Assistant, PL/SQL Developer

RDBMS/NOSQL: Teradata, Oracle, SQL Server, DB2, MS Access, PostgreSQL, MongoDB, Cassandra,Hadoop

Documentation: HP Quality Center

Scripting/Languages: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, XML

Reporting Tools: SSRS, Crystal Reports, Tableau, Google Analytics

Operating Systems: UNIX /Linux, Windows 7/XP/2000

Statistical Language/ Predictive Model: R, Python

PROFESSIONAL EXPERIENCE:

Confidential - Austin, TX

Sr.Tableau Developer /Sr. Data Analyst/ Business Intelligence Analyst

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualization approaches using Tableau to the senior management at the client as part of the BRD.
• Analyzed and created stored procedures on SQL Server to extract, transform and load staged tables from raw data.
• Developed relational tables, coded SQL queries, created macros in MS Access to produce financial data sets.
• Designed data mart components like metadata, facts and dimensions using star and snow flake schemas.
• Designed custom SQL queries for various Tableau reports for the business users to enhance the report and show the granularity of the data.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilitiesfor the dashboards, and to provide drill down features for thedetailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Worked on building queries to retrieve data into Tableau from SQL Server, Teradata, Oracle, Presto cluster for loading data into target database.
• Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed
• Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Created calculations including string manipulation, custom aggregations, date math, logic statements, parameters and represented data using different charts.
• Combining data sources by joining multiple tables and using data blending
• Designed and created aggregate tables for large datasets to optimize the data and increase performance of the dashboard.
• Scheduled data refreshes on Tableau Server for daily/weekly/monthly increments depending on the dashboard cadence.
• Worked with Teradata database and Presto cluster to extract data and developed POCs by building reports and dashboards using Tableau 9.2.
• Wrote Python scripts to parse XML documents and load the data in database.
• Used Python to extract weekly information from XML files.
• Worked on integrating Tableau with SPARTA application for the users to interact with the Tableau reports.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualization approaches using Tableau to the senior management at the client as part of the BRD.
• Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.
• Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.
• Creating reports and infrastructure to show migration activities by monthly release, business functions and IT projects.

Environment: Windows, SQL, Python, Tableau Desktop 10.3/9.1/9.2 , Tableau Server 9.1/9.2, OBIEE 11g, SQL Workbench, Teradata, Presto, PostgreSQL, Spark SQL,Alteryx, Toad, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential - Austin, TX

Sr. Data Analyst/Tableau Developer/Business Intelligence Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications.
• Installed,configured and setup Tableau environment in the organization.
• Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.
• Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.
• Creating reports and infrastructure to show migration activities by monthly release, business functions and IT projects.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Worked on converting map shape files to tableau readable CSV format using R software
• Conducted presentations to other lines of business as a Meta role to show value of Tableau as a BI tool.
• Participated and co-ordinate daily stand-ups with clients on daily design and development effort.
• Extensively used LOD expressions for cohort analysis and aggregation.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
• Performed statistical analysis of Data with R and Python using regression modeling, Bayesian forecasting, decision tree modeling, clustering to understand business use-cases and target potential customers.
• Developed a semantic analysis tool in Python to identify outliers and incorrect data during data scrapping in data pipeline that resulted in a cleansed database.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Generated the test plans specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Prepared test scripts and documented user training modules.
• Maintained Test log and created Test Evaluations, Summary Reports.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Provided Ongoing support to BI applications running in production & troubleshoot any issues.

Environment: Windows, Linux, Python, R, Tableau Desktop 9.1/9.2, Tableau Server 9.1/9.2, OBIEE 11g,Axure,Alteryx, Toad, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)

Confidential

Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Worked with the report development Manager and other team members on report requirements, timelines, testing, and technical delivery.
• Designed and developed Tableau reports, dashboard and metrics to support Claims Reporting and Business Intelligence strategy
• Developed Tableau objects like Filters, Parameters, Calculated fields, Hierarchies, Actions, etc.
• Extensively used Tableau Report Services to generate Report Documents.
• Created calculated fields for comparative reports like claims this year to last year (year to date and month to date).
• Designed different BI Dashboards for the Company Executives, through an efficient use of Tableau Report Services.
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Creating and developing test strategies, test cases and test plans.

Environment: Tableau (Desktop, Server)7.x, Teradata, Oracle, SQL Server, Power Designer, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite (Word, Excel, Power Point, Visio).