SUMMARY

• Over 7 years of extensive IT experience in Business Analysis, Data Mining, Data Analysis, Design, Development, Implementation and Database applications and Tableau.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Performed Business Analyst role in analyzing, modeling and implementing various enhancement projects using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Involved in creating Dashboards using Tableau Desktop.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Built complex formulas in Tableau for various business calculations.
• Deployed the reports andScheduled Reportsfor the use of end users and customers.
• Experience in creating reports and dashboards for senior management using large data sources.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Creating Ad-hoc reports on demand, Gathering Business requirements for custom reports.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment
• Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects
• Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2
• Excellent data-analysis skills and ability to translate specifications into a working Universe and Report.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Well experienced in writing complex queries, stored procedures, functions, cursors and packages using PL/SQL programming.
• Experienced in tuning long running SQL queries for better performance.
• A highly motivated self-starter with excellent communication skills.

TECHNICAL SKILLS

Server: Tableau Desktop, Tableau Server, and Tableau Reader.

Languages: SQL, PL/SQLApplications Microsoft SQL Developer

Databases: Oracle 10g/11g, MS Access, My SQL, MS SQL Server 2000/2005/2008 R2

Operating Systems: Windows XP/7/8, Sun Solaris.

Packages / Tools: MS Office, Toad, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created complex dashboards.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Creating reports with user security.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Perform UNIT testing and help the UAT testing team to performing various testing scenarios.
• Fix the JIRA tickets raised during the UAT testing.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in daily scrum calls, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 9.0,TableauServer 9,MS Office Suite,Oracle SQL ServerR2, MS Excel, JIRA, Toad for Oracle.

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Created several types of visualizations using Sets, dynamic sorting etc.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 7& 8.3,TableauServer,MS Office Suite,Oracle SQL ServerR2, SQL server, MS Excel.

Confidential, Warren, NJ

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Monitored Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Ability to communicate data clearly to a range of audiences through compelling data visualizations.
• Built Tableau visualizations by connecting to various Data Sources Relational Databases (Oracle, SQL Server).
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX.

Confidential, San Antonio, TX

Business Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Worked with the business unit to define business requirements and analyze the possible technical solutions.
• Responsibilities included requirement gathering, business process flow, business process modeling and business analysis.
• Designed and developed project document templates based on SDLC methodology.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Conducted workflow, process diagram and gap analyses to drive requirements for the automation process.
• Using detailed knowledge of application features and functions access scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Design and developed extranet for internal reporting functionality for client.
• Design and developed shell scripts to schedule data loading process to staging server.
• Providing Support and Maintenance for all the clients.
• Performed User Acceptance Testing (UAT) and describing the bugs to the development team
• Coordinated between the on-site coordinator and development team at Offshore to derive correct requirements for the product
• Responsible for directing analysis and need assessments to get the present manual medical records and translates them to Electronic Health Records.
• Helped to develop a Knowledge Management (KM) portal subsystem, for doctors to keep abreast of the latest Evolutions.
• Understood the Business Logic, User Requirements and test-objectives to develop Use Case, Test plans, Test
• Cases, Scenarios to reevaluate the Business Process and models.
• Co-authored detailed Business requirement document (BRD) and Functional architecture and solution specification Document.

Environment: Sun Solaris, Windows NT, Oracle 9i, MS Access, My Sql, MS Office Suite.

Confidential

SQL Developer

Responsibilities:

• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Preparedfunctional specificationsfor user requirements.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Createdentry forms/reportsfor various modules. Createddatabases, loaded initialization data, generated users, and assigned rolesandaccess.
• CreatedTables, Indexes, Table Spaces, Views synonyms,andintegrity constraints.
• Involved in creation ofschema objects, rolesandprivileges, users.
• PreparedUser manual, Technical documentsfor the end user.
• Prepared executable for system deployment and led the release of applications following
• Experience in UNIX Environment in file transfers, job scheduling and error handling
• Maintenance and support for the system. Involved inend user

Environment: SQL, PL/SQL, SQL*Loader, Windows XP, UNIX.