Shilpa
Email: ************@*****.***
Contact: 732-***-**** Ext: 780
PROFESSIONAL SUMMARY
Tableau Developer/Analyst with professional experience of nine years in the field of Health Care and Information
Technology.
EDUCATION
Master’s Information Systems, Eller College of Management, University of Arizona
Bachelor of Engineering, Electronics and Communication, Visvesvaraya Technological University
SKILLS
Technologies: Java, JDBC, PHP,SQL
Applications: HP Quality Center, Rational Requisite Pro, BMC Remedy, BMC Patrol, BMC
BCO, MS Office Programs, MS Visio, Eclipse,Google Analytics, AdWords,
Tableau, Cognos
MS Access, MS Visio, MS Office, MS Project
Defect Tracking Tools: Mercury Quality Center
Databases: Oracle 11g, MySQL, Microsoft SQL Server 2008 R2
Platforms: Windows XP/2000/98, Windows Vista, Linux, HP-UX
SoftwareDevelopment Agile – Scrum Testing Methodology, Waterfall
Methodology:
SPECIFIC EXPERTISE
• Sound understanding of Gap Analysis, requirement management, risk analysis and project plans.
• Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
• Design and review of various documents including the Software Requirement Specifications (SRS),
Business requirements document (BRD), Use Case Specifications, Requirement Traceability Matrix (RTM)
and testing documents.
• Requirements management using Rational Requisite Pro
• Experience in designing business models using UML diagrams such as use case diagrams, class diagrams,
activity diagrams, sequence diagrams and collaboration diagrams using MS Visio.
• Experience in conducting Joint Application Development (JAD) sessions and White Board Sessions with
end-users, Subject Matter Expert (SMEs) team,
•Involved in Trouble Shooting, Performance tuning of reports and resolving issues
within Tableau Server and Tableau Dashboards.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including
technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience on building dashboards using Tableau.
• Deploying and scheduling Reports to generate all daily, weekly, monthly and quarterly Reports including
current status. Established Best Practices for Enterprise Tableau Environment and application intake and
development processes.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing data
connections, scheduling tasks
• Expertise in writing SQL Queries
• Proficient in designing Data Mart and Data Warehouse and Snowflake Schemas.
• 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.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to
identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
PROFESSIONAL EMPLOYMENT HISTORY
AstirIT client: BCBS Tableau Developer (June 2013-Present) Chicago, USA
Project: RMAS and Integrated Channels
Environment: CA Wily, BMC Capacity Optimization, Oracle SQL, MS Visio, MS Project,MS Excel, Oracle 9i, MS
SQL, Windows 7,Tableau
As a part of the affordable healthcare act BCBS has acquired hallmark to venture into individual healthcare plans. This
project is about integrating Hallmark with Retail applications and preparing BCBS for open enrollment. The
integration involved the workflows such as shopping for the Medicare and Medicaid insurance plans, enrolling for an
insurance plan and providing payment details. This involved interactions among 34 different applications. The
eligibility and benefit enquiry for post enrollment go through a gateway integrated channels. This interacts with other
applications like provider, member, benefits and claims processes. The project involves providing accesses to
integrated channels to blue accesses members which is portal for enrolled members and generating various reports,
dashboards to analyze the trending for Medicare/Medicaid plans.
Responsibilities:
• Conducting JAD sessions for gathering requirements from various stake holders.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according
to deliverable specifications.
• Good understanding of tool administration for creating user, user groups, and scheduled instances for reports
in Tableau
• Monitored Vizql to track performance and system stability.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau
desktop & publish them to server.
Cerner Corporation Tableau Developer (Oct 2005 Jul2011) Kansas City, MO
Project: Inet, Powerchart, CAM IRC and Rules Wizard
Environment: Quality Centre, Unified Modeling Language, BMC Patrol, MS Visio, MS Project, Oracle 9i, MS
SQL,Tableau Windows XP/2000/98, Windows Vista
Inet and Powerchart a component of the Cerner Millennium platform, is Cerner’s critical care clinical solution. Inet is
used as critical care product, and contains a single flow sheet for recording, viewing, charting and filtering data vital
signs, hemodynamics, IV titrations and fluid balance. The workflows involved calculating workflows, generating
medication summary, charting interactive views and generating graphical reports. Cerner’s infrastructure team uses
Rules wizard to filter the relevant alarms to be routed to the end user and displayed in the Cerner Alarm Manager
Instance Response Center (CAM IRC) console and BMC patrol for monitoring the middleware data.. The project
focused on gathering requirements and generating reports to analyze the infrastructure usage trending for the
applications.
Responsibilities:
•
• Develop various data connections from data source to Tableau Server for report and dashboard
development
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations
and calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and
worksheets using Tableau.
• Effectively used data blending, filters, actions and Hierarchies feature in tableau.
• Calculated fields, Sets, Groups, Parameters in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top
management.
• End to end experience in designing and deploying data visualizations using Tableau and Extensive
experience in Data Analysis and understanding of Data modeling (Dimensional & Relational) on concepts
like Star-schema, Snowflake schema using fact, dimension tables and relational databases
Wellpoint Test Engineer (Mar 2005 – Sep 2005) Bangalore, India
Project: WellPoint
Environment: Test Director, Unified Modeling Language, MS Visio, MS Project, Oracle 9i, MS SQL, Windows
XP/2000/98, Windows Vista
Responsibilities:
• Extensively worked on documentation of requirements, QA practices, preparing test strategies, and
identifying critical application areas.
• Participated in the technical reviews and walkthroughs starting from the initial phases of the Software
Development Life Cycle.
• Developed test plans by understanding the User Requirements and business logic to enable manually testing
of application.
• Created test cases and executed the same manually using Test Director.
• Conducted GUI testing, Functionality testing and Regression testing.
• Provided up-to-date status of defects, viz; open, closed, fixed, reopen, deferred to the developers.