SUMMARY

• Have 7+ years of professional work experience in Data warehousing and informatica ETL data integration process with OLAP Business Intelligence and Database Platforms
• 3+ years of development experience in Tableau 8.x/9.x
• 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.
• 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.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• 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.
• 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.

TECHNICAL SKILLS

Operating Systems: Windows 8/7Windows XP Professional, Windows NT, UNIX, Linux

Scripting Languages: C, C++, SQL, PL/SQL, HTMLand XML

Databases: Oracle 11g/10g/,SQL Server 2012/2008/2005/2000 DB2, MS Access, Teradata.

Tools: Tableau Server v7/v8, Tableau Desktop v7/v8, Informatica Power Center 9.1, 8.6, 8, Cognos Related Skills TOAD, PUTTY

Documenting and Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, MS Project, MS Office(Word/ Excel/ Access/ Power Point), MS SharePoint.

PROFESSIONAL EXPERIENCE

Sr.Tableau Developer

Confidential, Philadelphia, PA

Responsibilities:

• 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
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad)
• 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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC
• 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

Sr. Tableau Developer

Confidential, Minneapolis, MN

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Experience with the design and development of Tableau visualization solutions.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of Concept/ prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Developed of key indicators and the appropriate tracking reports with graphical and written summations using summary and Annotations to assist in the quality improvement initiatives.
• Created quick Filters, customized Calculations, Conditional formatting for various analytical reports and dashboards.
• Studying the existing system and conducting reviews to provide a unified view of the program.
• Involved in creating Informatica mappings, mapplets, worklets and workflows to populate the data from different sources to warehouse.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

ETL/ BI Developer

Confidential, Melbourne, AUS

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 metrics created and assisted users in Tableau dashboard development
• 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.

ETL Developer

Confidential 

Responsibilities:

• Analyzed Customer requirements and prepared design/mapping documents.
• Worked on Data profiling to validate data related assumptions.
• 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.
• 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