SUMMARY

• Over all 7+ years of experience in business intelligence technologies such as Tableau BI, Cognos.
• Extensive experience with business intelligence tools like Tableau BIfor creating data visualization, interactive dashboards, reports, data aggregation using Tableau products such as Tableau Desktop, Tableau Server, Tableau Prep, Tableau Public and Tableau Reader.
• Extensive experience in creating interactive dashboards with guided techniques such as drill down capability, slicing and dicing of data and navigating to external webpage with URL’s using tableau desktop.
• Developed advanced data visualizations such as water fall chart, Pareto chart, Line and Area charts, 100% bar charts, Donut chart, and custom Geo coding maps.
• Expertise in creating report objects such as hierarchies, Context filters, Date filters, Global filters, Reference lines, parameters, sets and calculation fields using Tableau Desktop.
• In depth noledge of regression and time series analysis.
• Built aggregated views from various data sources using data blending and data joining techniques in tableau desktop.
• Experience in performing data extracts and incremental refreshes using Tableau Desktop/Tableau Server.
• Hands on experience in using Tableau server Product for publishing dashboards and workbook packages, managing user security, administration and Content Restriction.
• Excellent understanding of concepts like Star - schema, Snowflake schema using fact and dimension tables in relational databases.
• Experience in Insurance, Banking, Retail, Manufacturing, Educational and Financial Service Domains and analyzing big data.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an ability to learn new technologies.

TECHNICAL SKILLS

BI Tools: Tableau 20/19/18/10

Data bases: Oracle 10g/11g, Microsoft SQL Server and DB2, PL/SQL, MS Access

Operating Systems: Windows 95/98/2000/2008/NT/XP, UNIX, LINUX

Languages: C, SQL, PL/SQL, HTML, XML

Domain Insurance: Banking, Manufacturing, Healthcare, Retail Industries.

PROFESSIONAL EXPERIENCE

Confidential, Walnut Creek, CA

Tableau Developer

Responsibilities:

• As a Tableau BI, end to end life cycle implementation resource, involved in data analysis, dashboard development and administration.
• Developed interactive and dynamic dashboards featuring Policy analysis, Claims analysis, Demographic analysis, Performance breakdown by Product and Region, customer analysis, Stress Testing etc.
• Effectively used dual axis technique, trend lines, images and developed advanced visualizations such as donut chart, customized geo spatial maps, line chart and scattered plot.
• Established connections between tableau and SQL server.
• Created dashboards using Data Join techniques
• Developed Dashboards in Tableau Desktop using Functions such as color coding, formatting, sorting, filtering(quick Filters, cascading filters, context Filters),ranking, Top-N Analysis, hierarchies etc.
• Worked on KPI calculations such as Avg Time to settle a Claim, Avg cost per Claim, Return on Surplus, Loss Ratio, Severity, Expense ratio, Customer Retention, Strike rate, Avg. Policy size, Policy sales growthusing LOD(Level Of Detail Expressions)s, Date functions etc.
• Published various dashboards from Tableau Desktop to tableau server.
• Performed tableau extracts, scheduling and refreshes.
• Modified existing reports and dashboards to make it more dynamic and brought teh number for optimal management.
• Worked with users for better understanding of their reporting and dash board needs and presented solutions using Agile project methodology approach.
• Created Cross tab reports to display underlying data based on various graphs and charts for further data analysis.
• Involved with business to sign off teh dashboard prototypes/mock ups and freeze out teh report format to facilitate teh project to move in a right direction.
• Closely worked in teh peer reviews for teh final dashboards for impact analysis and gap analysis as per teh requirements.
• Resolved performance issues and worked for better scalability and availability of Tableau server.
• Performed data analysis on daily, weekly, and monthly scheduled refreshes to ensure developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Assisted Project Manager in documenting teh progress of teh project and any possible road blocks.

Confidential, San Jose, CA

Sr.Tableau Admin/Developer

Responsibilities:

• Established connections and integrated data sources SAP BW & SQL Server with Tableau Desktop.
• Developed and reviewed SQL queries with use of join clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data.
• Effectively used data joining and data blending techniques to extract data from SQL server and SAP BW to create a reporting application in tableau desktop.
• Designed tableau dashboard prototypes, presented to business users and involved with teh business to sign-off and freeze out prototype designs.
• Modified existing dashboards and optimized performance for new user experience.
• Extensively created rolling forward reports for monthly and Quarterly forecasting analysis across all operating companies.
• Published developed dashboards to tableau server, managed autantication, authorization and security.
• Performed tableau extracts, scheduling and refreshes, user management (adding users and groups) and content restriction.
• Performed data analysis on daily, weekly, and monthly scheduled refreshes of data based on business or system change dat have happened to ensure dat teh developed dashboards are displaying accurate and up-to-date live.
• Conducted Training sessions for tableau power users and created documents for end-user support.

Confidential, San Jose, CA

Tableau Developer

Responsibilities:

• Gathering requirements from various stake holders, cross functional departments, business users and documenting them in teh reports specifications document and report inventory.
• Involved in translating teh business questions and business requirements to actual and final dashboard technical requirements.
• Understanding and translation of existing Hyperion reports to convert them as Tableau reports and dashboards.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo coding.
• Created various report\dashboard functions such as grouping, sorting, filtering, ranking and ordering teh data and using Tableau reports for various analyses Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
• Performed data\business predictive findings, for trending, for finding teh pattern of data over teh period of time.
• Involved in creating mapping document, reports specs doc and interacting teh cross functional departments and stakeholders for gathering report\dashboards requirements.
• Involved in creating teh report mock ups, proto types for teh end dashboards and interacting with stakeholders for report change request and sign - off on teh requirements.
• Involved in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.

Confidential,

Intern/Jr.BI Developer

Responsibilities:

• Created and modified universes for different departments using Designer.
• Created classes, aliases, report objects as per functional specifications
• Performed joins between different tables form various data sources.
• Created cross tab reports.
• Applied formatting options such as sections, breaks, data sort options, font, colors etc.
• Developed various tables, graphs and drill down reports in Webi.
• Worked extensively with major functionalities such as breaks, ranks, alerts, filters, sorts, query prompt and hyperlinks in Webi.
• Extensively developed various charts, Graphs and drill down reports.
• Implemented row land object level security in universe designer
• Performed unit testing of reports
• Involved in extensive testing of universes and reports during version migration of business objects.
• Used slice and dice, drill down, prompt filters, cascading list of values.
• Experienced in Creating Charts with Value-based alerts and setting up Drill down in charts using Crystal Xcelsius.