SUMMARY

• Over 71/2 years of experience in Designing, Administration, Analysis and Management in Business Intelligence Data warehousing.
• 5+ years of extensiveTableaudevelopment experience in enterprise environments, inTableau8.0, 8.2,9.0, 9.3,10.2
• Interviewed SMEs and Stakeholders to get a better understanding of Stake holder reports business processes and gather business report requirements.
• Experienced with dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboard color coding, formatting, Tableau designs, proto types and Tableau mock up reports, wireframes, frame works, design documents and reporting.
• Data Warehousing experience using InformaticsPowerCenterClient 10.x/9.x/8.x/7.x.
• Used informaticapowercenter 10.1/9.6/9.0.1 to extract, transform and load data into data warehouse from various sources like Oracle, Ebcidic, xml, csv and flat files.
• Coordinate for planning, testing and Implementation for Informatica 9.1 to 9.6 and 9.6 to 10.1 migrations and Teradata server upgradations
• Hands - on experience in creating 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 inTableauDesktop.
• Experienced in designing customized interactive dashboards inTableauusing Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Administered user, user groups, and scheduled instances for reports inTableauand documented upgrade plan from (Tableau8.0 to 9.0).
• Having experience on various data analyzation techniques, reports efforts estimation, Reports development planning.
• Working with Project Management Team Foundation Server, SharePoint, Microsoft Project, andJIRAand source code version control SVN environment.
• Hands-on experience on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's.
• Proficient in design and development of various dashboards, reports utilizingTableau 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.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008/ R2/2005, Oracle 11g/10g

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Power Pivot, Power BI, TABLEAUDESKTOP 2019, 2018.2 10.0 x, 9.x, 8.x,TABLEAUSERVER, Business Objects 4.0, 4.1 a, ETL/Datastage

ETL Tools: SQL Server Integration Services (SSIS), DTS Import/Export

Data Modeling and Data Design Tools: Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling, JIRA

Other Software: MS Office- 2019, 2013, 2010, 2007, Team Foundation Server (TFS) 2012, 2013

Operating Systems: Windows 10/Windows 7 Enterprise/Vista/XP and Unix

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Sr. BI Developer

Confidential

Responsibilities:

• Took a major responsibility to understand the business process in bcbs and the way Claims process takes place.
• Extensively involved in the data migration team to build the Re-usable Datastage job templates, common parameter sets, common Datastage job containers, SQL extract procedures and common re-usable shell scripts.
• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Designing complex tableau report dashboards, publishing them on the tableau server.
• Designed tableau dashboard to show statistics for turnaround time taken by pathologists.
• Training Internal employees with tableau desktop and tableau server knowledge.
• Enhancement of existing reports to improve performance by modifying the sql code used in extraction of data.
• Involved in design requirement meeting with clients and internal employees.
• UAT testing of the reports developed along with Dev testing.
• Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
• Working with Level of Details expressions and Regular Expressions which are helpful in providing ETL functionality for tableau.
• Utilized Tableau server to publish and share the reports with the business users. Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Scheduled the server jobs using DataStage Director, which are controlled by DataStage engine and for monitoring and performance statistics of each stage.
• Preparing documentation for SQA approvals and resolving issues identified by them before deployment.
• Walking through the reports to users across multiple departments in report share meetings tomake same report useful for cross departments.
• Taking immediate initiative to work on the Service Now incident tickets on the priority submitted.

Environment: Tableau 2019.2, Tableau Server, SQL Server 2012, ServiceNow, SSMS, MS Office Suite, Windows 10

Sr.BI Tableau Developer/Analyst

Confidential, Indianapolis, IN

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableau Desktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules onTableauserver.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Responsible for the MY Confidential business, functional and technical requirements gathering, requirement Use cases, user stories, BRD and FSD, mock up\wireframes of web site pages including the mobile version.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Owned, responsible and accountable for the business, functional, technical, documentation, design (mock up, wireframe and, proto type), pipelining, base lining, Gap analysis, reverse engineering, development, testing and UAT of the whole project in 3 environments RT (Run Time) Dev\Staging and PROD.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: TableauDesktop 2019.4,TableauServer, wireframe, user stories, MS Excel, Windows, SQL Server 2018, SSMS, MS Office Suite, Windows 10, SQL

Sr.Tableau Developer

Confidential, Alpharetta, GA

Responsibilities:

• Conversant in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test, implementation and report.
• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory
• Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding.
• Created work flow diagrams and wireframes required to fulfill the project requirements for the whole project.
• Worked on InformaticaPowerCentertool - Source Analyzer, Data warehousing designer, Mapping &Mapplet Designer and Transformation Designer Involved in high level design.
• Integrated Informatica Data Quality with InformaticaPowerCenter.
• Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
• Developed various types of charts and graphs like donut charts, funnel charts, bar charts, line graphs, pie charts.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Also, created views inTableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Responsible for dashboard design, look and feel and development.
• Creating user groups for reporting and set email bursting with user specific data.
• Extensively involved in training users in Web intelligence,CrystalReports, and Xcelsius Through training led scenarios.
• Interacted with Business Users to know their Business needs to effectively develop and modify Universes andReports.
• Expertise in usingCrystalXcelsius to create user appealing Dashboardreports.
• Experience in building queries using SAP BEX Query Designer.
• Expertise in writing and implementation of the Packages, Triggers, Stored Procedures, Functions, views, Materialized Views, indexes at Database level and Form level using PL/SQL and T-SQL.
• Hands on experience in Data Modeling using Erwin tool and implementing Star Schema and Snowflake Schema for various Dimensional Modeling and Data Marts.

Environment: Tableau(Desktop/ Server) 9.3 & 10.0, Alteryx, Microsoft Power B.I., Teradata V2R5/R6/R12/R13, Hadoop, AWS, SQLdeveloper, PowerCenter9.5 MS SQL Server & TFS, Oracle MySQL, PL/SQL, T-SQL, Teradata SQL Assistant, Business Objects /CrystalReportsXI R2, Toad, MS Access, Windows 2012 R2 server, Informatica/ETL Developer

Sr.Tableau Developer

Confidential, Memphis, TN

Responsibilities:

• Worked with Business Users from different functional Units and understand business challenges in terms of providing reporting solutions across organization.
• Worked directly with BI Architect, Administrator, DW / DBA team and Business Units to deliver solutions.
• Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.
• Acted as both functional and business sides of the web development to interact with the various cross departmental stake holders
• Gathered requirements from business Users in various sessions, formed questions to ask business owners and stakeholders of MY Confidential portal and created Use Cases based on that.
• Updated BI Manager with any Reporting challenges and worked towards creating solutions for the same.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Designed, developed and published customized interactive reports and dashboards usingTableau.
• Used Action filters, Parameters and LOD calculations, Quick Table calculations, Sets, etc. for preparing dashboards and worksheets inTableau.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on thereport.
• Created Web IntelligenceReportswith different functionalities like cascading prompts, drilldown, charts, graphs, ranking, Scope of Analysis and alerts.
• Created Ad-hocreportsusing BO functionalities like Master Detail, Formulas, Breaks, Calculations, Alerts, Slice and Dice, DrillDown and Functions.
• Developedreportsby linking different data providers in a singlereport, and made all possible incompatible objects as compatible by merging the common objects.
• ConfiguredJIRAService Desk with Confluence for customers self-service.
• Used Groovy scripts on Script Runner plugin to write custom scripts forJIRA.
• Create complexJIRAworkflows including project workflows, field configurations, screen schemes, permission schemes and notification schemes.
• Helping Scrum master across the company to customizeJIRAfor their requirements.
• Configured theJIRAService Desks for the following Business Units - Corporate Technology, IT Help Desk, Workplace Services, Sales force Helpdesk, and Vendor Management and Others.
• Created Groups and Custom Hierarchies to meet the Business requirement inTableau.
• Worked with various teams on Setting newJIRA& Confluence instances for new teams
• Generated scripts for effective integration ofJIRAapplications with other tools.
• Effectively used data blending feature intableauand defined best practices forTableau report development.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized usingTableau.

Environment: Tableau10.x/9.x (Desktop/Sever), JIRA, WEBI, Teradata, Oracle, SQL Server, Teradata SQL Assistant, SQL Server Management Studio, Crystal Reports Microsoft Office Suite (Word, Excel, PowerPoint, Visio).

Tableau Developer

Confidential, Wichita, KS

Responsibilities:

• Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
• Responsible for making reports usingTableaudesktop (9.2), Teradata according to the user's requirements.
• Worked closely with Customer service and BO department for prompt and efficient delivery ofTableauReports.
• Developed IDT universes and modified existing Universes for enhancements over Oracle database in BO XI 3.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Developed various data connections from data source toTableauDesktop for report and dashboard development
• Created new Data source and replaced with existed Data source.
• Created Schedules and Extracted the data intoTableauData Engine.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked 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.
• Developed story telling dashboards inTableauDesktop and published them on toTableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver. Creating New Schedule's and checking the task's daily on the server.
• Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created and PublishedTableauDashboards intoTableauServer.
• PublishedTableaudashboard onTableauServer orTableauOnline and embedded them into portal.
• Analyzed and gained understanding of the underlying data and generatedTableau dashboards with forecast and reference lines.
• Created Users and groups onTableauServer and created monthly subscriptions of reports.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Wrote Custom SQL to support business requirements.
• Extracted data from different data sources like SQL Server, MySQL andTableauServer and created queries based on the requirement to provide data visually.

Environment: TableauDesktop 9.x/8.x,TableauServer 9.x, MySQL, ETL, BO XI 3, SSRS, SharePoint, SQL Server and Windows.

Tableau Developer

Confidential, San Jose, CA

Responsibilities:

• Working closing with Customer service and BI department for prompt and efficient delivery ofTableauReports.
• Used complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling ofTableauapplication.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Responsible for maintaining reports inTableauserver, entity relational data modeling, giving appropriate access to users monitoring performances.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Monitored and maintained incremental refreshes for data sources onTableauserver.
• Worked on querying data and creating on-demand reports usingTableauDesktop and publish the same to Server and Used Tab admin and Tabcmd commands in creating backups and restoring backups ofTableaurepository.
• Worked on loading excel files into the SQL server database using the SQL server integration services 2008.
• Developed restricted user access toTableaureports according to the users requirements at worksheet level.
• Developed different visualizations using bars, lines, scatter plots, bubbles and histograms based on the requirements.
• Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed different strategies for improving the performances ofTableaureports.

Environment: TableauDesktop 9.x/8.x,TableauServer 9.x, MySQL, SSIS, SharePoint, SQL Server.