SUMMARY:

• Over 7 years of experience in all the phases of SDLC Design, Development, Integration, Implementation and Maintenance of MS Business Intelligence and Tableau Platforms.
• Proficient in Tableau (Desktop, Server), Power BI, OBIEE, Micro Strategy (Desktop, Intelligence Server, Narrowcast Server) and SSRS.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Expertise in Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, SSAS, UNIX, Toad, Microsoft Office Suite.
• Possess strong knowledge of database management in writing complex SQL queries, Netezza, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Worked with a team who deal with Netezza Database for complex queries and then key in the data to connect with Tableau for data blending and data manipulating procedures.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

BI Tools: Tableau, Micro Strategy,SSIS, SSRS,OBIEE, Cognos, Power BI.

ETL Tools: Informatica, Data Stage, Talend, Microsoft SQL Server Integrated Services(SSIS)

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: Google big-query, Teradata, Oracle, SQL Server, Netezza, DB2, Sybase, Access.

Document management: Visual Source Safe, Share point, Ultra Edit, Documentum

Defect management tool: HP Quality center

Programming Languages: C, C++, HTML, SQL, PL/SQL, XML, Python, C#

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

Project management Tools: Taiga, Kanboard, Kanban, Libreboard, Trello, JIRA

PROFESSIONAL EXPERIENCE:

Confidential - Englewood, CO

Tableau Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements and published using Tableau server.
• Interactive data visualizations in Tableau desktop and providing BI Solutions to the management for strategic decision making.
• Experience working on Tableau Desktop - Connecting to multiple data sources, Building quick views, advanced filtering, Sorting, Groups, Hierarchy, Create Sets, Actions, Table
• Calculations and using necessary Parameters, Forecast, Trend lines, Data Blending.
• Analysis of sales for each group/department, over different dimensions like Region, Units, Organizations.
• Team will check the maximum number of sales/visitors are coming on to the website from various locations, the maximum number of the orders have been canceled.
• Created Relationships, actions, data-blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on clients need.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Experienced in Agile Scrum Methodology to implement project life cycles of reports design and development.
• Design/Develop aggregations with dimensional slicing.
• Enable Dimensional Hierarchies & Measures and Name sets.
• Harmonize and simplify the incredible complexity of data
• Enable Visualization like Qlik Sense / Tableau to read from Cubes

Environment: s: MySQL, Tableau (Desktop, Server), Agile-Scrum (JIRA), MS Office, Qlik, ThoughtSpot, Grafana.

Confidential - Omaha, NE

Tableau Developer

Responsibilities:

• Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
• Responsible for making reports using Tableau desktop, Teradata according to the user's requirements.
• Worked closely with Customer service and BO department for prompt and efficient delivery of Tableau Reports.
• Developed IDT universes and modified existing Universes for enhancements over Oracle database in BO XI 3.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development
• Created Schedules and Extracted the data into Tableau Data Engine.
• Created Tableau scorecards, 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 in Tableau Desktop and published them on to Tableau 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 using Tableau server. 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.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Created Users and groups on Tableau Server and created monthly subscriptions of reports.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.

Environment: Tableau Desktop, Tableau Server, MySQL, ETL, SSRS, SharePoint, SQL Server and Windows.

Confidential - Marlborough, MA

Tableau Developer

Responsibilities:

• Working closing with Customer service and BI department for prompt and efficient delivery of Tableau Reports.
• Used complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling of Tableau application.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Responsible for maintaining reports in Tableau server, entity relational data modeling, giving appropriate access to users monitoring performances.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Monitored and maintained incremental refreshes for data sources on Tableau server.
• Worked on loading excel files into the SQL server database using the SQL server integration services 2008.
• Developed restricted user access to Tableau reports according to the users requirements at worksheet level.
• 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 reports for CAHPS, state measures, claim chases and patient level details.
• Worked on geo coding, using the FIP codes to develop reports showing possible EMR and PCPs.
• Worked on grouping to rollup products to their specific lines of business for reporting.
• Worked on making metadata tables to load the excel files into the SQL server database using Stored Procedures.

Environment: Tableau Desktop, Tableau Server, MySQL, SSIS, SharePoint, SQL Server.

Confidential

Tableau/SQL Developer

Responsibilities:

• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up) List, cross tab etc. using Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development.
• Involved in performance tuning of sources, targets and sessions.
• Built Tableau dashboards for showing insights of different portfolios dashboards and customer level detailed.
• Deftly designed dashboard templates as per the requirements and dashboards content which included bar charts, water fall charts, score cards, Gantt charts, Bubble charts, Word maps, Geospatial visualizations, network charts etc.
• Generated reports using SQL queries and published them to users through Tableau server.
• Wrote Custom SQL to support business requirements.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the business analysts.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Assisted users with questions and issues using Tableau Worked with various infrastructure teams and Tableau support team to help improve dashboard response time.

Environment: Tableau Desktop, Tableau Server, MS Office Suite, SQL Server, Power BI, MS Excel, OBIEE, Oracle, Microsoft SQ Server.