SUMMARY

• Overall 7 years of experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.x.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Extensive knowledge and experience in producing tables, Reports, graphs using Tableau.
• Skilled inTableau Desktop for data visualization, Reporting and Analysis; Scatter
• Plots, Pie Charts and Bar Charts, Heat maps, Funnel charts, Bubble charts, Density chart and application of other local and global filters according to the end user requirement.
• Perform User Acceptance Testing (UAT) for the data load process into Data warehouse.
• Familiarity writing complex SQL queries and Stored Procedures, Triggers, functions in Oracle 11g database.
• Extensive experience in ETL of data directly from different Heterogeneous source systems like Flat files, Excel, Oracle, MYSQL and Teradata.
• Outstanding MS Excel skills, including experience using spreadsheets to perform complexdata analysis using Pivot tables, vlookup, excel formulae, conditional formatting, visualizations etc.
• Experience in validating and capturing source to target data mappings.
• Proven ability to support multiple projects, under tight deadlines, often with competing priorities.
• Build various Dashboards using heterogeneous data sources like excel, flat files, oracle and Teradata.
• Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
• Designed and deployed interactive reports with Drill Downs, Drop down, Parameters and Linked reports usingtableau.
• Created External filter, internal filter and Context filter to improve performance.
• Used Tableaus Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyse data in different perspectives.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Familiarity with Big Data technologies and running HIVE Queries.

TECHNICAL SKILLS

Languages: Oracle PL/ SQL, SQL,BTEQ

Technical Tools: MS excel, MS word, WinFTP.

Database: Business Intelligence

MySQL, Oracle 11g, Teradata 12.0: Tableau 9.0,Excel 2000

Operating system: Microsoft Windows

Software Packages: MS-Office

Designing Tools: HTML, ASP.NET, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Tableau Consultant

Environment: Tableau 9.0, Oracle 11g

Responsibilities:

• Created financial scorecards and dashboards to give 360 degree business view to the management.
• Created wait time dashboards to indicate the patient wait time KPI.
• Created reports/dashboards by directly working under business executives.
• Created incremental refreshes for data sources on Tableau server.
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee.
• Modeled all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and employee roles, timestamps and location.
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee, time and location dimension.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Designed 30+ near-real-time monitoring Dashboards for Tableau Server.
• Optimized Data Extracts, Connections, and Data Refreshes for corporate Tableau Server.
• Worked with the IT team to identify and map details of current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Worked with various user groups in sales sector to understand the business user reporting.
• Facilitated and managed meeting sessions with work stream SMEs to elicit business requirements and find solutions to the data gaps.

Confidential, Richmond, VA

Business Intelligence Analyst

Environment: Tableau 8.2, MySql, Oracle 11g, Teradata 12.0

Responsibilities:

• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Expert in info-graphics and Dash boarding for data visualization.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in providing Tableau server and tableau desktop training.
• Installed drivers for the Teradata and upgraded ODBC drivers to 13.00.00.01 for better performance.

Confidential, Plano, TX

Data Analyst

Environment: Teradata 12.0, oracle 10g.

Responsibilities:

• Work with the business team/end users to carry out source system analysis and in turn create SQL Reports to match legacy reports.
• Generate borrower profile reports classifying borrowers on income, race and gender dimensions.
• Generate Loan characteristic report using SQL.
• Generated SQL reports comparing different source systems to explore data gaps and provide feedback in UAT testing to rectify defects.
• Generate periodic SQL reports on foreclosure reporting.
• Createdtables,views,stored procedures and triggers in user spaces for adhoc data analysis usingSQL.
• Created materialized and inline views to give a loan status snapshot to the user.
• Worked with the QA team during the Smoke Testing and Integration Testing phases using HP Quality Center.

Confidential, Plano, TX

Data analyst

Environment: Oracle 10g, Teradata, Excel. MS Word.

Responsibilities:

• Worked with the business users and M&A team to define reporting requirements.
• Identified all the potential sources for the Subject data requests from users.
• Profiled mortgage loans performance for the book of business loans using SQL in oracle and Teradata.
• Produced daily weekly and monthly reports on Loan standings.
• Produce monthly REO reports detailing, appraised value, and disposed value, net proceeds, Monthly expense etc.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application. Documented inconsistencies using MS Excel and worked to resolve them.
• Wrote SQLs to validate each individual data element being loaded to star schema Data mart.
• Assisted testing team in creating test cases and test plans and verify the components integration, data loading, data mining and query execution of the data warehouse.