SUMMARY:

• Over 9 years of professional work experience in Data warehousing and 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.
• Good understanding of views, Synonyms, Indexes, Joins and Sub - Queries..
• Have wide knowledge in Telecommunication, healthcare domain like provider, claims, Medicare, Medicaid etc.
• Have worked in Agile, Waterfall, and Iterative project methodologies.
• Exposure to Star, Snowflake Schema and Multidimensional Data Models.
• 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.
• Provided production support for managed reports and users.
• Widely implemented Performance tuning for reports
• Mastered the ability to design and deploy Rich 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 extensively in Tableau Desktop/Server 8.3, 9.2 &10.x
• Played the role of Tableau mentor for internal team and business users
• Experience in testing and fixing the bugs.
• Worked closely in resolving all Incident and Change Management requests
• 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.

SKILLS & TOOLS:

Operating Systems: Windows 95/98/2000, Windows XP Professional, Windows NT, UNIX

Languages: C, C++, C#, SQL, PL/SQL, HTML

Databases: Oracle 8i/9i/10g/11g, Google BigQuery, SQL Server 2008/2005,DB2, Teradata.

Tools: Tableau Server v7/v8/v9/v10, Tableau Desktop v7/v8/v9/v10, Informatica Power Center 9.1.0/9.0.1 , 8.6.1,8, Cognos 10.x, Cognos 8.x, Cognos Transformer

Related Skills: TOAD, PUTTY, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Sr. Tableau Developer

Responsibilities:

• Motorola customer repair service data was handled which includes Advance Exchange, Return Exchange,AFX models with US BULK and Non BULK data.
• Large datasets were handled in Google BigQuery to manage the data.
• Coordinated Client to understand and analyze business requirements.
• 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 dashboards to enable a fast read on claims and key business drivers and to direct attention to key area
• Mastered the ability to design and deploy rich visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created Complex calculated fields in getting Turn Around Time and Aging of the devices as per business requirement for the given time frame.
• Effectively built performance rich Dashboards and fast rendering of reports
• Created side by side bars, Scatter Plots, Stacked Bars, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensively use tableau Parameters,Data blending, Action filters, joins and Drilldowns
• 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.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Experience on working with LOD and Table calculations.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer.
• Experience in using Tableau Mobile for dashboards
• Developed Custom SQL scripts to view required claim data in developed dashboards
• Optimized SQL scripts to improve the efficiency on the database.
• Involved in performance tuning for tableau Dashboards.
• Developed transformation logic and designed various Mappings using the Designer
• Extensively used SQL to analyze the data.
• Extensively used Bar charts, Pie charts, Line charts, Geographic Maps in dashboard creations.
• Experienced in handling large volumes of data.
• 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

Environment: Tableau Desktop 8.3/9.2,10.3 Tableau server / Administrator, Informatica Powercenter 9.1, SQL, Unix Shell Scripting, Windows/UNIX, Google BigQuery

Confidential, New Jersey

Sr. Tableau Developer /ETL Developer

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
• Extensively created visualization 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
• 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
• Created workbooks and Dashboards using calculated metrics for different visualization requirements

Environment: Tableau Desktop Tableau server / Administrator, Informatica Powercenter 9.1, Windows/UNIX, SQL, Unix Shell Scripting, Oracle

Confidential, Richmond, VA

ETL/ BI Developer

Responsibilities:

• Analyzed Customer requirements and prepared design/mapping documents.
• Designing and Development of Mappings using Informatica Power Centre 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.
• Trained new joiners in understanding the business.

Environment: Informatica 9.1, Tableau, SQL, Oracle 10g, Teradata’s, Windows/UNIX

Confidential

BI/ETL Developer

Responsibilities:

• Involved in Strategic Planning of Cognos Framework Manager Model.
• Created models using Framework Manager in multiple namespaces by creating shortcuts, joins, star schema groupings, Calculations and filters.
• 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.
• Validated the reports using Pl/SQL on Oracle Database and obtain approval.
• Attended Functional Testing and User Acceptance sessions, and worked on the feedback from the business users.
• Developed Executive Dashboard and Sales Dashboard using CRN
• Deployed the packages (exporting and importing the packages) using the Deployment functionality under Cognos Connection Portal.
• Provided production support for managed reports and users.
• Designed packages using Framework Manager from various data sources of Oracle Clinical.
• Involved in Developing Informatica mappings for doing ETL of Facts and Dimensions.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Worked on various reports like conditional reports, master-detail reports, reports with prompts and other complex reports.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables and to debug SQL query issued during report execution.
• Created Dashboards for multiple views of Reports on the same Report page as per the user request.
• Coordinated training sessions and demonstration of Cognos tools to end-users.
• Provided support to projects for new applications / report needs.
• Provided technical support to other team members at various issues.

Environment: Cognos8.x, ReportNet 1.1MR2, FrameWork Manager, Cognos Connection, Report Studio, Query Studio,Impromptu, Informatica Powercenter, Toad, Oracle.