Professional Summary:

• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Have 8 years of professional work experience in Data warehousing and informatica ETL data integration process with OLAP Business Intelligence and Database Platforms
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• gathering/ analysis, Design, Development, Testing and Production rollover.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries..
• Have wide knowledge in healthcare domain like provider, claims etc
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
• In-depth knowledge on Tableau Desktop and Tableau Server.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator
• Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Established Best Practices for Enterprise Tableau Environment and application intake and
• development processes.
• Worked exclusively on implementing the types of Slowly changing dimensions SCDs - Type I II and III in different mappings as per the requirements.
• Experience in testing and fixing the bugs.
• Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues
• Worked extensively in Informatica Power Center 8.6 9.1.
• Proficient in Oracle Database and UNIX Shell Scripting.
• Ability to work collaboratively and understanding of business requirements and system architecture.
• Been part in writing technical requirement documents and low level design documents.
• Conversant with Software Development Life cycle and SEI-CMMI level 5 Quality Processes while executing projects
• Received client appreciation award of the year 2013 for passion towards learning and effectively scaling up in Data Feed visualization.

Technical Skills:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr.Tableau Developer

Confidential

RESPONSIBILITIES:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps,Gantt charts using show me functionality during POC .
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium laptop, pc, Ipad
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Understanding existing business model and customer's new requirements.
• Created workbooks and Dashboards using calculated metrics for different visualization requirements
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Created dashboard views from provider information data to members
• Extensively created visualisation dashboards for the claims
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area
• Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance
• Created extensive custom joins for blending data from several different data sources
• Helped customize Tableau Server with Company Logo and Company Pop-Ups
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.Created and assisted users in Tableau dashboard development
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.
• Assist business users in developing/ executing complex queries/ reports using Analysis studio, Query Studio
• Collaborated with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop as per requirement.
• Created a proof of concept for the optimal data integration process.
• Designed high-level view of the current state BCBSA files, leads, and website activity using Tableau
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Created workbooks and Dashboards using calculated metrics for different visualization requirements

Confidential

Role:Sr. Tableau Developer

Role and Responsibilities:

• Experienced in handling large volumes of data.
• Extensively used SQL to analyze the data.
• Developed transformation logic and designed various Complex Mappings using the Designer
• Define / Develop SQL queries, Stored Procedures, and data mining as necessary in collaboration with the Database developer and BI Team as needed
• Optimized SQL scripts to improve the efficiency on the database.
• Developed Custom SQL scripts to view required claim data in developed dashboards
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created series of signboard and dashboard reports, built for a new process being built in Horizon.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer.
• Coordinate with Team Lead and Client to understand and analyze business requirements.
• Member and member reconciliation interface was handled.
• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each member, zone, region and nationally to gauge system performance using the Tableau.
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's

PROJECT 3:

Role: ETL/ BI Developer

Confidential

ROLES AND RESPONSIBILITIES:

• Analyzed Customer requirements and prepared design/mapping documents.
• Designing and Development of Mappings using Informatica Power Center Designer Tool as well as involved in Application End to End ETL Testing phase.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium laptop, pc, Ipad
• Created calculated fields using Tableau for implementation of color coding and proper aggregations for data
• Created extensive joins for data blending from several different data sources
• Helped customize Tableau Server with Company Logo and Company Pop-Ups
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metricsCreated and assisted users in Tableau dashboard dsevelopment
• Developed Complex Dashboards, Reports and Cubes using Report Studio.
• Administered and provided production support for Wellpoint wide Tableau application consisting of multiple key functional business domains.
• Created new ETL Informatica routines as per the business requirements.
• Created different mappings for loading the data into Oracle database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expressions, Aggregator, Sequence Generator and Normalizer.
• Created different mappings for loading the data into Oracle database.
• update on the defects raised to SQA Team in daily vendor calls. Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues
• Prepared unit test cases for the created new ETL routines.
• Developed SQL queries for data reconciliation/Audit.
• Tested ETL code in Dev, SIT UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• activities like preparation of LLD Low Level Design Document, ETL Extract Transform Load build, plans and conducts ETL unit and development, tests, monitors results and takes corrective action, when necessary.
• Taken care of pre-production activities like Clear Quest tickets, Migration checklist, Run plan etc.
• Tracked project status by submitting weekly/Monthly project status report and participated in triage calls.
• Trained new joiners in understanding the business.

Confidential

Responsibilities:

• Analyzed Customer requirements and prepared design/mapping documents.
• Worked on Data profiling to validate data related assumptions.
• Suggested data model changes as required.
• Prepared unit test cases for the modified existing ETL routines.
• Creating the SQL queries based on source to target mappings for Target tables.
• Prepared the alter scripts to alter the length and data type.
• Design, develop, and test reports and Dashboards in Cognos 8.4.1
• Created new jobs and scheduled reports using Cognos Connection.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer
• Worked on various reports like conditional reports, master-detail reports, reports with prompts and other complex reports Developed transformation logic and designed various Complex Mappings using the Designer
• Extensively used SQL to analyze the data.
• Experienced in handling large volumes of data.
• Analyzing the requirement
• Code developed based on the business requirement
• Develop an ETL mapping as per Business requirement, developing SQL queries to perform audit between source, staging and Target data.
• Created database connections to different data sources in Framework Manager.
• Designed the standard template for creating reports in Report Studio.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.,
• Once components get migrated to production, it is necessary to involve in supporting process
• During the support it is necessary to share the daily status of load run and Incident Management tickets opened in SharePoint to business during daily calls.
• Created Unit Test cases and captured Test log

Confidential

Roles and Responsibilities:

• Understanding existing business model and customer's new requirements.
• Prepare ETL Design Documentation Conducted Design walk-through sessions
• ETL performance optimization.
• Code development, UTC, testing different scenarios and documenting the result, working on defect fixes from System Testing User Testing.
• Tested ETL code in Dev, SIT UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions

Confidential

Roles and Responsibilities:

• Prepared UTC UTR after completion of the development and provided results to client.
• Migrated Informatica code from one environment to other environment manually whenever necessary.
• Tested ETL code in Dev, SIT UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions