Data Sql Server

Professional Experience

I have* years of experience with core expertise in Tableau development and Administration along Data Analysis, Migration, Quality assessment and Business intelligence. Holds significant experience in Health care, Financial services, Insurance and telecom domains providing advanced analytics development, implementation and support in form of transforming data, segmentation and profiling and solution development /implementation.

Also carries good expertise with Informatica, QlikView and Databases such as Oracle/ Teradata/Netezza.

Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management.

Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons),Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

Experienced in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.

Worked extensively with Tableau Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI'

Adept at requirement Analysis, application Design, creation of technical design and documentation and Expertise with agile and waterfall project management methodologies.

Excellent interpersonal and communications skills allowing positive interaction with both business and technical teams

Techno-Functional and Client focused attitude. Highly collaborative, resilient and have conflict resolution skills in managing remote/ in-house teams

Few of domain areas, been part of implementation and support using Tableau.

Health Care Analytics: To produce data, analytics and a tool to support leading insurance provider in US on pricing and financial forecasting for its individual business.

Customer Analytics: Projects related to customer segmentation, customer profiling to retain the customers. This to identify customers who have higher propensity to churn and to detect frauds which causes considerable damage to network operators.

Claims Analytics: Developed solutions for dental claim analytics with exposure from minimum complexity ones to high severity approach. Data model, migration and analysis been carried out using Erwin, Informatica and Tableau.

Skills Summary

Industry–Life Sciences & Health Care Insurance Retail Cross Sector

Project/Program Management Enterprise Architecture Business Systems Analysis

Project Management Software Architecture Requirements elicitation

Cross-Functional co-ordination Software Development Data Analysis

Team Building & Mentoring Workflow Scheduling Build Analytics framework

Client Relations & Presentations Information Architecture Data Database Modelling

Technology Skill Summary

Data Visualization

Tableau Developer 9.0 / Tableau Administration

Data Migration / ETL Tools

Informatica

OLAP Tools

Business Objects XI, Cognos

Programming Languages

Structured Query Language (SQL).

Database

Oracle, Teradata, DB2, MS SQL Server

Testing tools

HP Quality Center

Apps & Web servers

Apache web server, Tomcat, IIS

Methodologies

Agile and Waterfall

Blue Cross Blue Shield of Louisiana, Baton Rouge, LA Aug 2014 – Present

Tableau Lead -Sr. Business Analyst

Founded in 1934 in New Orleans, Blue Cross and Blue Shield of Louisiana is the state's oldest and largest health insurer. For more than 75 years, we've been committed to improving the lives of Louisiana residents by providing health guidance and affordable access to quality care.

Health Care Reform Project & Claims Application System Upgrade

As per PPACA (Patient protection and Affordable Care Act) in the current healthcare plans as well as upgraded the legacy claims application system to a newer technology by conducting analysis & testing.

Responsibilities:

Responsible for gathering and documenting Legislative, Business, Functional requirements for all the provisions and their impact on the existing products and systems.

Familiarization with Installation, configuration, patching and upgrading of Tableau tool across the environments

Using Tableau and third party tools ensured Platform monitoring, availability and performance management, and service reporting (KPI)

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

Developed workbooks and dashboards using Tableau Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.

Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.

Traced High Level Requirements (HLR) to Detailed Level Requirements (DLR).

Conducted meetings with SME's to understand current business process and performed Gap Analysis to meet future business needs.

Created and managed project templates, use case project templates, requirement types and traceability relationships in MKS Integrity.

Developed Systems Specifications document to define the impact of the new requirements on the existing system.

Environment: Requisite Pro, Rational Rose, XML, Clear Case, MS Office, Netezza, Oracle, MS BI and Tableau

Liberty Mutual,Indianapolis Jun 2013 – Jul 2014

Lead - Tableau

To build and design new database as part of internal audit analytics application model and user interface for Data analytics reports.

Responsibilities:

Involved in requirement gathering with business users, and build conceptual model around requirements.

Conducted data analysis in order to identify specific patterns. Designed and build reports using custom functions, groups, group’s selections and variables. Scheduled reports in accordance to business requirements.

Build dashboards and reports such as master/detail and cross tabs for trend analysis. Developed complex SQL queries and functions to fetch data for reporting and to accomplish several computations

Published Workbooks with row and column level security been implemented with user filters so that only appropriate teams can view it

Utilized context filters and used performance actions while handling huge volume of data.

Generated tableau dashboards for sales with forecast and reference lines

Provide regular (monthly, weekly, bi-weekly) reports for both internal and external stakeholders.

AT&T, LA Nov 2012 – April 2013

Data Analyst and Tableau developer

Project is to analyze of transaction data, billing data, messaging content and traffic pattern for suspected instances of potential fraud compared with transaction data for transactions

Responsibilities:

Identify and describe transaction patterns suggesting “stacked marketing”, “cramming” or similar anomalous transactions and providing AT&T with specific transactions as examples for each Aggregator and Content Provider

Data/ Text mining lead for building variables and establish a model. Built Variables and created text classifications using Python.

Build daily, weekly, monthly and quarterly reports in accordance to the requirements. Developed Set Analysis to provide custom functionality in Tableau.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Performance tuning of workbooks, data sources, and providing best practices for user community

Build components to integrate client systems with LDAP and meta-directory products using Python and Java and developed system using Python to test and analyze.

Unit testing and Performance Tuning of all the report in order to reduce the execution time required for generating these reports and thereby improving the overall speed of execution and performance of the reports

Technical Environment: SQL Server, Python, Java and Tableau

AmeriHealth, Mount Laurel NJ Aug 2011 – Oct 2012

Tableau Developer – Sr. Business Analyst

In 1996, AmeriHealth Casualty Insurance Company was established as an extension of our workers’ compensation claims services its mission to provide workers’ compensation insurance combined with high quality claims service and cost containment.

ICD-10 Project is a federal mandate to replace the current ICD-9 Diagnosis codes with the ICD-10 Diagnosis code set. The US Department of Health and Human Services (HHS) is requiring health plans, Physicians, hospitals, and other health care professionals to be ICD-10 compliant by October 1, 2014. The HHS also mandated that the entities migrate from the existing HIPAA 4010 electronic transaction set to the new X12 5010 transaction set by Jan 1, 2012.

Responsibilities:

Worked with internal team to build out of a high level roadmap and time line to achieve compliance. Participated in ICD 9 to ICD 10 codes conversion requirement gathering sessions and created high level business requirement document.

Performed impact analysis on 5010 upgrades and ICD-10 conversions.

Incorporated mathematical and statistics based approach to identifying key Performance indicators (KPIs) and customer behaviors through correlation trending and analysis (insights).

Managed data sets, cubes and views from data warehouse as well as utilizing external data sources by blending, according to internal client specifications to recurrent and ad-hoc prepared analyses.

Develop and engineered solutions for dashboards, scorecards, scheduled reports, ad hoc queries, and decision support, in Tableau.

Designed and deployed Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.

Build Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI) and Measure

Change Control Process – Led the Change Control Process for changes submitted for the BRD once the document was submitted to IT department.

Documented the UAT Plan for the project and worked with the UAT Team to ensure every acceptance criteria for the requirements has been included in the UAT task plan

Maintained the Traceability Matrix table to uniquely trace the identified business requirements to general design to testing as proof that requirements requested have been developed into a solution and that it has been tested and tracked.

Environment: Agile, Sql Server, Netezza, InformaticaPowercenter, Business Objects and Tableau.

Magellan Health Services Inc, Glen Allen, VA Feb 2010- Jun 2011

Tableau Developer – Lead Business System/ Analyst

Magellan of Virginia was selected by the Virginia Department of Medical Assistance Services (DMAS) to serve as the Behavioral Health Services Administrator (BHSA).

Electronic Medical Record & Member Portal Project:

This project aimed at integrating elements of a patient’s health history, medication information, test results and treatment plans in an electronic format by creating electronic medical record (EMR) & worked on membership portal project aimed at providing new features to members.Worked on Market Prominence’s automated solution for payers covers Medicare, Medicaid.

Responsibilities:

Acted as primary liaison between the Business unite and development team department; performed analysis, review, and estimation of client requests; prepared and reviewed system requirements, and client documentation; prepared and executed detailed test plans

Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Conducted data analysis in order to identify specific patterns. Designed and build reports using custom functions, groups, group’s selections and variables. Scheduled reports in accordance to business requirements.

Designed approach for migration from unstructured and semi structured data

Build interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Built dual-axis bar chart with multiple measures and data blending in case of merging different sources.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Transformed TABLEAU into a managed service offering for consumption across multiple functionaries.

Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle and Microsoft SQL Server

Performed Tableau type conversion functions when connected to relational data sources.

Maintained and Installed Tableau Serverfor UAT environment and implemented incremental refreshes for data sources on Tableau server.

Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.

Environment:Informatica, Tableau, Sql Server 2000, Oracle 10 g, Teradata

Centene Celtic, Chicago, IL Aug 2008 – Jan 2010

SQL and BI Developer

Celtic Insurance Company is committed to offering healthcare solutions for the uninsured. Ongoing market research and product development initiatives create healthcare plans designed to increase access to high quality healthcare.As an individual health insurer, combined with Centene’s national expertise in providing government sponsored healthcare solutions, Celtic has a unique perspective into the private and public healthcare sectors within each state.

Responsibilities:

Involved in requirementsgathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

Working on the SQL tuning and optimization of the Business Objects reports.

Exported the ad-hoc ready universes for making semantic layer available to the users.

Created and defined the Hierarchies for various reports based on the Business rule of the Organization.

Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.

Created complex reports by linking data from multiple data providers and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.

Extensive testing and migrating the reports or objects from development to Production system.

Created Views and User Defined Functions to facilitate the automation of data entry by a front end application. Dynamic SQL creation for user customizable queries to be answered by the SQL Server.

Creating Adhoc reporting ready universes using Business Objects Universe Designer.

Scheduled Reports using scheduler InfoView as well as CMC.

Providing support for the users on application usage and conducting training walk through of salient features of the application

Environment:MS Office Tools, Sql Server, Business Objects, XML

References: Will provide the references on request

Contact this candidate