SUMMARY

• Over 8+ years of extensive IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications and Tableau.
• Extensive experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Over 4 years extensive experience in Tableau in Enterprise Environment and Tableau Administrator including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Experience in HealthCare Quality Analytics.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Deployed the reports andScheduled Reportsfor the use of end users and customers
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and SAP BO.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Worked extensively with the major functionality of SAP BO ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinSAP BO.
• Installation, configuration and administration of Crystal reports and SAP BO.
• 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 Rational Unified Process (RUP), 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
• Experienced in tuning Long running SQL queries for better performance.

TECHNICAL SKILLS

Languages: HTML, PL/SQL, SQL, XML, Java/J2EE

Applications: Oracle SQL Developer

Reporting tools: SQL server 2005/2008 R2 SSAS/SSRS/SSIS, Tableau Desktop, Tableau Server, SAP BO, Crystal Reports

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

RDBMS: MS Access, Teradata

Operating Systems: Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Packages / Tools: MS Office, Toad, Putty, FrontPage 2000.

PROFESSIONAL EXPERIENCE

Confidential, Lowell, MA

Tableau Consultant

Responsibilities:

• Developed various data connections from data source to Tableau Server for report and dashboard development.
• Providing of clinical intelligence solutions for hospitals. Providing meaningful use reporting solutions and clinical reporting solutions help hospitals achieve compliance with federal P4P programs and provide them with daily, actionable information to improve care, quality, and outcomes.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Did the initial study of Health Care Management to collect customer s information, data about existing systems at client site, specific customer requirements for the Electronic Health Reports (EHR).
• We work on programs such as Meaningful Use, Inpatient Quality Reporting (IQR), and Value Based Purchasing (VBP).
• Created solution driven dashboards by developing different chart types including Crosstab s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop for Client Specific Hospitals.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Upgraded Tableau Server to latest version 9.2 and created automated Backup using Task Scheduler.
• Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitored and maintained incremental refreshes for data sources on Tableau server.
• Blended data from multiple databases into one report by selecting primary key s from each database for data validation.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders.
• Focus on getting end - users up to speed on Tableau capability.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Worked on multiple Complex tables through custom SQL.
• Generated several drill down and drill up reports.
• Generated Tableau reports with Trend lines, reference lines and bands.

Environment: Tableau Desktop 8.1, 8.2& 8.3,9.2 Tableau Server 8.x,9.x, Tabcmd, Tabadmin, Oracle, PL/SQL, MS SQL Server 2012,Google Analytics,, Oracle Virtual Machine.

Confidential, Dallas, TX

Tableau Admin/Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual - axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, 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 on Tableau Server for weekly and monthly increments based 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 group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel, T-SQL.

Confidential, Schaumburg, IL

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• 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.
• Monitored VizQL server, 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.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, 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, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Confidential, Baltimore, MD

Business Systems Analyst

Responsibilities:

• Liaison between the client and development team to support the client’s data analysis and reporting needs.
• Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective
• Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
• Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds.
• Performed monthly analysis comparing the monthly interest rate calculation to interest income booked to the general ledger.
• Reconcile internal & external financial reports to ensure proper account balance are maintained and accurate data, which are reflected on client accounts.
• Managed the production of cash flow, P&L and balance sheet reports
• Design and develop data conversion programs relating to Oracle Project Contracts and Oracle Work in Process.
• Engaged in analyzing requirements, identifying various individual logical components, expressing the system design through UML diagrams
• Worked on Rational Rose to develop the use cases, class diagrams and sequence diagrams.
• Worked on Requirement Change Management System in Rational Requisite Pro.
• Setting up document hierarchy and standards to define different level of requirement using Rational Requisite Pro.
• Requirements Elicitation, Analysis, Communication, and Validation according to Six Sigma Standards.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Performed Regression testing for User interface
• Conduct data mapping sessions, and write the required business requirements documentation including use cases.
• Interacted and interviewed customers and business sponsors to gather data requirement.
• Developed detailed auditing and reporting of the current status and history of all components related to a product.
• Translated customer/clients’ needs into new features and new services.

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), Windows XP/2000, Linux, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio, MS Word, MS Excel.

Confidential, OK

Data Analyst

Responsibilities:

• Conducted requirement gathering using focus groups, document analysis, interviews, prototyping and blueprints for the project
• Involved in Business Process Reengineering (BPR) - analyzed existing business processes and implemented new improved processes
• Did the initial study of collect customers’ information, data about existing systems at client site, specific customer requirements for the Electronic Data Management System
• Used Crystal Reports for querying underlying database tables
• Involved in designing of the system with the system architecture and the development team, implementing technology based solutions
• Designed user interface for PHTS and process flows to control the patient records and Information Management System to secure PII - Personal identification information similar to LaboratoryManagement System (LIS)
• Written all Business requirements and Functional/Non functional requirement.
• Worked on Workflow of the project, concentrating on Current and Future Workflow Description, Created Use cases diagrams using Visio
• Developed Sequence Diagrams, Activity Diagrams
• Designed and implemented basic SQL queries for QA - Quality Assurance testing and report / data validation
• Conducted JAD sessions between the end users and the development team, Point of sales (POS) team, Business Team
• 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: Use cases, JAD, Interview, KM, SQL, Oracle 10G, Clear Quest, Clear case, MS EXCEL, MS Access, MS power point, DOORS, Microsoft Vision, Mercury Quality center, statistics, BPR, Toad, HIPAA, Functional Analysis,.

Confidential

SQL Server Developer

Responsibilities:

• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Performed Database code Migration from SQL Server in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. .
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.