SUMMARY

• Over 7 years of working experience indatavisualization,report design&dashboard development using BI technology and Decision Support Systems.
• Professional experience on Tableau Desktop and Server. (Tableau versions 7 / 8 / 9/10.x)
• Analyzing and acquire experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Developed 12 Different types of Dashboards usingTableau.
• Installation setup, user management and other administration of Tableau Server.
• Professional expert in Data Visualization development using tableau to creating complex, intuitive and dashboards.
• Implemented Data blending on multiple data sources and generated interactive dashboards.
• 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.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Expert in designing customized interactive dashboards in tableau using marks, Action, filters, parameters, Security Concepts, calculations, and relationships.
• Extensive knowledge in creating Tableau scorecards, bar graphs, dashboards using stack bars, geographical maps, scattered plots, Gantt charts using show me functionality.
• Good experience in Software Development Life Cycle like project documentation design, testing and production development.
• 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.
• Involved in the installation of Tableau Server and gained experience in dealing with multi-tenant and distributed environment architecture.
• Good experience on Databases skills with testing complex SQL & PL/SQL queries.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server.
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact, and Dimensions tables.
• Good communication skills, collaboration and building skills, ready to work with new team employees, flexible to work in different projects.

TECHNICAL SKILLS

• Tableau Desktop/Tableau server 7/8
• SQL developer
• SQL 2008
• Oracle 10g
• Microsoft Excel 2007
• MS Access
• Windows 2007 server
• Microsoft Office.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in sprint planning sessions and sizing the user stories in AGILEenvironment.
• Created visually compelling Dashboards.
• Communicating with the business users to get the requirements.
• Analyze the business data and understanding field level information.
• Built data model for the new data sources.
• Responsible for gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the Reports.
• Conversion of BO reports to Tableau.
• Writing complex SQL queries to fetch the data from Oracle, MS SQL Server
• Extensive use of Rally software tool to manage agile development, creation of user stories, estimates and updates. Viewing the burn down charts and other reports, updating the team in meetings.
• Worked on development of various Tableau reports/ dashboards.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps andSymbol Maps according to deliverable specifications.
• Effectively used data blending feature in Tableau to connect different databaseslike Oracle, MS SQL Server.
• Maintained permissions of Tableau Views and Dashboards.
• Extensively worked on parameters, Pareto charting, mapping, calculations, demographics and geographic fields.
• Worked with string functions, date calculations and swapping dimensions withparameters.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.
• Responsible to work with advanced connections, join new tables, create &manage Extract and Monitor Queries using SQL Assistant.
• Integrating interactive location maps with the data analytics based on variousfilters and actions.
• Fixing defects logged in JIRA by QA and UAT team.
• Resolved the incidents and requests raised by the end-users.

Environment: Tableau (Desktop/Server) 9/10.x, SAP Business objects 4.1, Oracle11g, SQL Server, Toad, SQL Developer, Agile-Scrum.

Confidential

Tableau Developer/ Data Analyst

Responsibilities:

• Identifying and gathering user requirements and business requirements from different groups, end users for developing reports.
• Designed and developed Tableau Dashboards.
• Performed yearly analysis and business risks using different line charts.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Creation of Tableau users and testing with different security levels for web authorization and authentication.
• Exploring tableau 8.0 features for web editing and authoring, filters and server monitoring.
• Created Tableau scorecards, dashboards using various plots (stack bars, bar graphs, scatter plots) demonstrating key information for decision making.
• Created conditional and context filters to filter the data on dashboard. Responsible for Creating Parameters for desired functionality.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, and SQL Server.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, and Background images, Maps, Trend Lines and Statistics.
• Created Groups, hierarchies, and Sets to create detail level summary reports and dashboards using KPI's.
• Generated tableau dashboards for sales with forecast and reference lines.
• Build and publish Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs and Actions.
• Tableau advanced charts using geo maps, Gantt charts, Pareto charts, scattered plots for providing multidimensional views.
• Key integration with web applications and resolving ticketing server issues with IIS.Smoke testing for all the business scenarios in Dev and Pre-Production servers.
• Integration of tableau reports with web application and viewing reports online.

Environment: Tableau Desktop/Server 7/8, OBIEE, Oracle 10g, SQL, Clear Quest (CQ), Informatica(ETL), ER Studio.

Confidential

Tableau Developer / Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gatheird Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared BI Interactive Dashboards using calculations, parameters inTableau.
• Develop, organize, manage and maintain graph, table, slide and document templates dat will allow for efficient creation of reports.
• Deep experience with the design and development ofTableauvisualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.
• Configured different data sources using Tableau Desktop.
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Expertise in Tableau Actions used to navigate between sheets or URLs, highlight or filter.
• Experience with creation of users, groups, projects, workbooks and the appropriatepermission sets for Tableau server logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Good working knowledge on Tableau administration for creating users, groups, sites and access control.
• Involved in migration activities related to Tableau across the environments.
• Develop, organize, manage and maintain graph, table, slide and document templates dat will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop/Tableau server 7/8, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft Office.

Confidential

PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and development of Business process/ Work flow charts.
• Developed PL/SQL procedures, customizing existing programs according to the needs of the client testing.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Materialized views, Triggers, Sequences, Collections.
• Involved in development and testing of Oracle back-end objects like database triggers, stored procedures, sequences and synonyms.
• Worked with tuning the complex stored procedures for faster execution using bulk collections and Dbms profiler.
• Involved in design, development and Modification of PL/SQL stored procedures, Functions, Packages and triggers to implement business rules into the application.
• Extensively used cursors for fetching the rows.
• Loading data through SQL Loader and UTL FILE.
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
• Designed reports using reports as per user requirements.
• Created reference and master/Detail tables to store information.
• Tested forms and reports using test data.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms.
• Wrote shell scripts to insert data to database tables.
• Wrote PL/SQL code to retrieve data for master and detail blocks.
• Customized forms and reports as per user requirements using Oracle Developer Forms and Reports.
• Interacted with clients in remote locations to verify customer requirements.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows

Confidential

QA Test Engineer

Responsibilities:

• It Includes Information's like patient demographics, progress notes, problems, medications, vital signs, past medical history, immunizations, laboratory data, and radiology reports.
• The EHR automates and streamlines the clinician's workflow.
• Claims Management, Document Management, Insurance information management and Charge Capture. Roles and Responsibilities.
• Participated in Business/Development meetings to Understand Meaningful Use requirements.
• Preparing Test Plan, Test Conditions, Test Data & test cases for the application to ensure 100% requirements and test coverage.
• Performed several tests like acceptance testing & sanity testing for accepting the build.
• Integration testing was done to ensure data processing, interface validity and proper communication among components of each application.
• Testing Mainframe applications and InfoPath forms in share point.
• Involved in testing Member, Provider, Claims Processing, Authorizations, Contracts and Benefits.
• Knowledge in relational database concepts like Tables, Primary and foreign keys, Views and Referential Integrity.
• Proficient in the data manipulation using SQL for the retrieval of data from the relational database (inner joins, outer join, group by, order by etc
• Defect logging, defect tracking, verification & closure activities using Quality Center and following up with the developers and team.
• Estimated test effort for each test execution cycle.
• Attended project meetings, release meetings, and QA status meetings.

Environment: Java, J2EE, SERVLETS, SQL Server, Manual, Automation QTP and QC 10.0.

Confidential

Test Engineer

Responsibilities:

• Apollo health system has developed an Integrated Hospital Management System, which addresses all the major functional areas of modern multi-specialty Hospitals.
• It has the following the modules Registration, Medical which has In-Patient and Out Patient depts., Service, Financial and Pharmacy modules.
• Reviewed System Requirement Documents and functional requirements documents.
• Tested the functionality of each screen to monitor proper navigation.
• Ensured dat defect reports were documented, maintained and monitored.
• Involved in code reviews, Unit Testing and Peer reviews.
• Performed Functional, GUI, Back end, Regression and System Testing.
• Utilized Bugzilla for test management and defect tracking.
• Involved in regression testing between different Builds.
• Updated Requirements Traceability Matrix with Test Case Ids mapping with HLD and DD etc.
• Identifying Test Cases to be run for Regression Testing and conducting Regression testing as and when new builds were made.
• Test cases executed and reported as Pass/ Fail and tracked failed test cases.
• Designed detailed test cases for testing software functionality.
• Prepared Understanding document with the available documentation.
• Worked on traditional Waterfall methodology in terms of SDLC.

Environment: Java, HTML, java script, Win'2000, SQL Server 2000, TOAD, Bugzilla, MS Office