SUMMARY

• Around 6 years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server and efficiently in connecting various data sources.
• Professional experience on Tableau Desktop, Reader, Server, Mobile, Public. (Tableau versions 7 / 8 / 9/10)
• Analyzing and acquiring experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Involved in creating 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 and Tableau Server.
• Professional expert in Data Visualization development using tableau to create complex, intuitive and dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines. Groups, hierarchies, set to create a detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Used Performance monitoring tool of tableau desktop to analyze the performance of data - heavy dashboards and implemented the best practices to improve the end-user experience.
• Professional expert in roles such as BI End-to-End and solution implantation expert in the data warehouse, BI KPIs modeling.
• Designed and developed crosstab, conditional, drill-down, summary, sub reports, Ad hoc reports, parameterized reports, Complex Reports.
• Expert in RDBMS concepts and constructs along with Database objects creation such as tables, Index’s, stored procedures, Views, User Defined functions, Triggers, and cursors.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end-user requirement.
• Expert in Tableau Administration Tool for configuration, adding users, managing licenses, and data connections, scheduling tasks.
• Good experience in Database skills with testing complex SQL & PL/SQL queries.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Having knowledge ofETLtools likeInformaticaand all Informatica Designer tools including (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer).
• Identifying and removing bottlenecks in order to improve the performance of dashboards and reports.
• Writing and reviewing technical documentation like functional specifications, design specifications, project standards, test plans and test scripts, product documentation.
• Experience troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements.
• Experience with Business Intelligence and data mining tools to perform insights analysis on varied data (E.g. Tableau, Salesforce Einstein Analytics, Microsoft Power BI).
• Strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• In-depth experience in End-to-End Testing Lifecycle Phases including Test Planning, Test Design, Test Execution, and Defect Reporting. Extensive experience in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint) and IAM web-based reports.

TECHNICAL SKILLS:

BI Tools: Tableau (Desktop 7 to 10, Server, and Reader), MicroStrategy, Quick view, Power BI.

Data Warehousing ETL Tools: Informatics Power Center 8, Tableau Prep

Operating Systems: Windows Family, Linux

Languages: HTML, CSS, SQL, PL/SQL, Python, R, SAS, Shell Scripting

Databases: ORACLE 9i, 10g, 11g, 12.c, DB2, MS SQL Server 2012, HP Vertica and MS-Access

Software Packages: MS-Office 2003, Microsoft Word, Excel and PowerPoint

Clinical & Provider Software: EPIC, JIVA

Source Code Repository: Git Hub

Agile: JIRA, Rally

Wiki Tool: Confluence

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

Data Analyst

Responsibilities:

• Proactively provide technical analysis expertise and direction in developing, maintaining, and enhancing health and Wellness data needs, such as key operational and clinical metrics.
• Utilize Tableau and programming skills to support the Health and Wellness division, including the development and automation of key operational workflows and clinical metrics.
• Coordinate and participate in Health and Medical Management’s (HMM) technical initiatives, including the development of operational reports and technical specifications in support of all aspects of our Health Management Program.
• Manage technical projects ensuring that project plan target dates are met and implemented to enhance and maintain reports.
• Proactively review SAS report metadata to understand trends and provide recommendations to business users for continuous improvement and transfer to tableau report visualization.
• Created Inpatient and Outpatient reports to analyze sales and revenue by a provider for management reporting and weekly/monthly Behavioral health team performance report.
• Provided User Acceptance Testing (UAT) documentation for Tableau reports and provided exiting reports solution to improve performance.
• Analyzed existing reports for identifying common KPI metrics to create common metadata and self-service metadata.
• Promoted and supported the infrastructure of reporting and Power BIstrategy, including standards and best practices.
• Created interactive Commercial and Medicare Advantage, FEP Authorization trend reports.
• Lead cross-functional teams/workgroups to bridge gaps between business and technical teams.
• Conducting analyses to assess the budget impact of new drugs, assess adherence to policies and appropriateness of drug utilization, reimbursement by third-party payers, and other analyses to support cost-effective use of drugs.
• Validate the SAS dataset and migrate SAS data sets into the SQL server to use for tableau reports
• 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.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using Power BI.
• Writing SQL queries for data validation by using join conditions. Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created company tableau chart guide template for training purposes.
• Create Groups, Projects and add Users inTableauServer.
• Involved in the deployment of new dashboards to Test and Production environment.

Environment: Tableau Desktop 10.5, Tableau Server 10.5, SAS 7.1, Microsoft SQL Server, JIVA, Excel, MS Office, CSV, Windows 10.

Confidential

BI Developer

Responsibilities:

• Created and published Tableau data sources and Scheduled extract refresh for Daily, weekly and monthly.
• Created interactive workbooks using Tableau 10 and 9.x with multiple connections to multiple data sources using data integration.
• Involved in reviewing business requirements and analyzing data sources form Excel/ SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Conducted Gap Analysis, created Use Cases, workflows, screen shots and Power Point presentations for the Web Applications.
• Creating Sales Growth Dashboardmetrics measure the pace at which your organization's sales revenue is increasing or decreasing.Current sales revenue: The total dollar value of sales during the current time.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts, etc.
• Power BI developer with skills as well to help deliver a set of dashboards.
• Calculating theAverage Purchase ValueKPI measures the average value of each purchase order in your sales team processes.
• Involved in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.
• Troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements.
• Created Ad-hoc reports by gathering specific requirements from the different users
• Involved extensively in the overall life cycle of the Data Warehouse integration project
• Generated reports using Advanced Metric objects, Filters, Prompts and created customized templates to facilitate the End users to create customized reports by choosing Filters, Metrics and report attributes
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Designed, developed and maintained daily and monthly summary, team rendering benchmark reports.
• Provided support and developed high level render teams work performance with render shot links reports.
• Involved in building SQL queries that were utilized in Tableau dashboards to satisfy the business's needs.
• Developed shell and SQL scripts to apply for splits and coverage on trades that flow to Hp Vertica through different feeds.
• Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
• Involved in creating Documentation for debugging reports for Tableau.
• Developed the table documentation for Tableau Dashboards. Wrote SQL queries for custom reports.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Analyzed poorly performing SQL queries to improve application performance.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Preparing Dashboards using calculations, parameters, filters, calculated fields, groups, sets and hierarchies in Tableau.
• Created project documentation for future knowledge and provided 24/7-production support for Tableau users.
• Working knowledge on Tableau Server / Administration.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Defined best practices for Tableau report development.

Environment: Tableau Desktop 10.5, Tableau Server 10.5, EPIC, Informatica, Microsoft SQL Server, Oracle 12c, Confluence, Excel, MS Office, CSV, Windows 10.

Confidential

Software Developer

Responsibilities:

• Involved in the design and development of two main technological components, a Database to store data of all transactions related to each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Designed and developed calculator tools utilizing JavaScript, CSS, and HTML to create online graphical user interfaces to assist with testing trade applications.
• Involved in database design/preparing SQL scripts to support the larger databases that involve terabytes of data.
• Analyzed software application requirements, performed regression testing, executed test plans on UNIX platform and documented results.
• Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• Writing SQL queries for data validation by using join conditions and involved to create Documentation for debugging report for Tableau
• 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.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau view in other web applications like SharePoint.
• Traced paths to various CSV files to change required property settings before test runs.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Creating interactive dashboards in spreadsheets, power points and submitting to the client.
• Worked with government higher officials to identify state land and created property area maps.
• Created customized reports using various chart types like text tables, bar, Area, Pie, tree maps, heat maps, line charts, pivot tables in excel and tableau.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau view in other web applications like SharePoint.
• Involved in conducting training to a user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Identifying requirements by establishing a personal rapport with potential and actual clients and with other persons in a position to understand service requirements.
• Maintains computer systems and programming guidelines by writing and updating policies and procedures
• Design and conduct tests for software programs.

Environment: MS SQL Server 2012, SQL, Jenkins, HTML, JavaScript, CSS, Oracle, PLSQL, Git, UNIX, Windows XP, User Acceptance Testing (UAT), Rational Clear Quest, MS Access, Jenkins, Git, Rational Test Manager, MS Office.