SUMMARY:

• A result - oriented, self-motivated, and dedicated professional offering 7+ years of professional experience who works well independently and as a strong team member
• Responsible for designing, planning, implementing and administering databases, including security, access, and documentation.
• Proficient in Tableau Desktop (9.x, 8.x, 7.x).
• Experience in establishing connections to different Servers (MS SQL Servers, MySQL, Hadoop, Oracle, Tableau Server, Cubes), Files (Excel, Text) and Saved Data Sources and other ODBC connections
• Experience in developing various kinds of Views, Workbooks as per business requirements by utilizing Charts (Bar Graphs, Dual Axis, Pie-Charts, Bubble Charts, Scatter Plots, Heat Maps, Tree Maps, Funnel Charts), Filters, Pages, Calculated Fields, Groups, Parameters, Sets, Dynamic Sorting, Table calculations, Trend lines, Forecast, LOD’s (Level of Detail Expressions), YTD’s, QTD’s, User Filters, Key Performance Indicators, etc.
• Expertise in developing interactive Data Visualization Dashboards by making use of Components (Horizontal, Vertical, Image, Webpage and Text), Actions (Filter, URL, Highlight Actions), Use as Filters, Layouts, Objects, etc.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools like Informatica Server, Repository Server manager.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports
• Develop API services in an Agile environment
• Assist in scope definition, planning, estimation and tracking
• Good Experience with Teradata and Semantic Views
• Published Dashboards, Workbooks, Views and Stories on to the Tableau Server and set refresh schedules for extracts. And provided Permissions, Data Level & Row Level Security to the individual (users, groups)
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Experience in Tableau Server Administration for Installations, Adding Users, Managing Licenses, Security, Configuration, Scheduling Tasks, Assign Privileges, Web Authoring etc.
• Experience in Performance Tuning of Reports, Trouble Shooting and Resolving issues with in Tableau
• Experience in creating Backups, Code Migrations and Version Upgrades across Tableau environments.
• End to end experience in Designing, Deploying and Maintaining data visualizations using Tableau.
• Experience in fetching data from HDFS using Alteryx and Schedule jobs.
• Expertise in using Alteryx Data Blending tool
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS PowerPoint, MS Visio.
• Effective in executing multiple tasks and assignments ahead of schedule
• Flexible and adaptable towards change and ambiguous environment

TECHNICAL SKILLS:

BI/Visualization & ETL Tools: Tableau (Desktop & Server)8.x/9./10x, and MSBI (SSIS, SSAS, SSRS)

Databases: SQL Server 2005/2008/2012 , Oracle 10g

Programming Languages: SQL, PL/SQL, C#, C

Scripting Languages: HTML, JavaScript, XML

Operating Systems: Windows Server 2003/2008/XP, UNIX, Linux and Mac

Microsoft Office Tools: Access, Word, PowerPoint, Excel

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Tableau developer

Responsibilities:

• Actively and consistently supported all efforts to simplify and enhance the customer experience.
• Interpreted data and analyze results using statistical techniques, and provide ongoing reports.
• Acquired data from primary or secondary data sources for use in analysis and trending.
• Identify, analyze and interpret trends or patterns in complex data sets.
• Produced ad hoc reports to answer business questions quickly and thoroughly. Create reports and data driven presentations.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Manage day-to-day system development and maintenance activities for APIM and Datapower deployment in global regions
• Worked closely with management to prioritize business and information needs.
• Involved in business sessions with clients to gather and understand the requirements and to document functional & technical specs.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Help to develop and manage the Tableau semantic layer through reusable data sources
• Involved in up-gradation of Tableau Server from 8.x to 10.x and documented for future use.
• Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.
• Created various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Used data source filters for high volume of data to improve performance of the reports.
• Created views and dashboards to support client business requirements using tableau features like data joining, charts, table calculations, complex calculated fields, cascading filters, sets, parameters, actions, hierarchies feature in Tableau.
• Published dashboards and worksheets on to the tableau server and provided data security so that end users with user access and permissions can view the appropriate dashboards and views...
• Coordinated with development team tasks & deliverables and work on high priority issues.
• Interacted with the end users on a regular basis for resolving issues pertaining to the reports.

Environment: Tableau Desktop 8.x & 10.x, Tableau Server 8.x & 10.x, MS Excel, MS SQL Server 2012 R2, Share point, Win Server 2012 R2, Active Directory,IBM Datapower, Hadoop Hive, Vectorwise,SAS,,Tableau Data Extract (TDE), Google Analytics, API Data, Cloud SQL.

Confidential, Dallas, Texas

Tableau Developer

Responsibilities:

• Collaborated with Business Analysts and Data experts to capture analytical requirements
• Translated requirements into BI solutions that are effective, easy to use and well performing
• Worked closely with ETL developers, DBA’s and other BI developers
• Participated in end user support
• Participated in user training
• Supported user ad-hoc requests
• Integrated SharePoint with external identity providers like Azure AD, Social and AD-FS/SAML federation
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Involved in reviewing business requirements and analyzing data sources form Excel/MS SQL Server for design, development, testing of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Developed Metadata Models in Tableau and dashboards.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Created dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Create workflows to fetch data from different sources to HDFS using Alteryx and Schedule jobs.

Environment: Tableau 8/9, MS SQL Server 2012 Informatica Power Center 9.1/8.6/8.5/8.1/7.1 , Oracle,Alteryx,Teradata, Java, share point,Teradata,MS Excel, Windows Server 2012.

Confidential, Houston, TX

Business Analyst/Tableau Developer

Responsibilities:

• Obtained business requirements from business users and stakeholders using JAD sessions, brain storming sessions, focus groups and personal interviews to get a better understanding of the client's business process.
• Worked with the business to document and develop formulas for the calculation of premiums and losses statistics in the marts (e.g. Written Premium, Earned Premium, Unearned Premium)
• Elicited, documented, modeled, validated and prioritized functional and non-functional requirements using interviews, data analysis, and different modeling tools.
• Actively involved in preparing and writing the business requirement documents, functional requirement documents and data mapping documentation.
• Performed in depth data analysis identifying data issues in legacy system and worked with business to develop resolutions to those issues.
• Used MS Project for status reporting and planning.
• Utilized MS Visio for designing Use Case Diagrams, Activity Diagrams and Sequence Diagrams, after accessing the status and scope of the project and understanding the business processes.
• Analyzed the as-is and to-be state of the project and performed Gap analysis, Impact analysis and SWOT analysis.
• Created data mapping documents for the movement of data from production databases to the warehouse and from the warehouse to the policy and claims marts.
• Used the guidelines and artifacts of the SCRUM methodology for project implementation and development.
• Created views and dashboards to support client business requirements using tableau features like data joining, charts, table calculations, complex calculated fields, cascading filters, sets, parameters, actions, hierarchies feature in Tableau.
• Interpreted data and analyze results using statistical techniques, and provide ongoing reports.
• Acquired data from primary or secondary data sources for use in analysis and trending
• Assisted System Architects and Quality Assurance Analysts in creation of various tests.

Environment: MS Office (Word, Excel, Power Point), RUP, Share Point, MS Visio, Microsoft Outlook, Tableau 8/9.

Confidential

Business Analyst

Responsibilities:

• Responsible for continuous process improvement and for identifying and maintaining a clear and measurable Development Process that is deployable throughout the enterprise using Agile Methodology.
• Used use case diagrams during analysis to capture the requirements.
• Attended daily Scrum meetings, kept up-to-date on best practices for JavaScript frameworks and techniques.
• Worked closely with Business teams on aligning business requirements with technical ones.
• Designed and implement front-end projects of various scope.
• Built and maintain the presentation layer of Hotwires site.
• Strict adherence to W3C standards and cross browser compatibilities.
• Designed and implemented multiple new features in hotwire.com related to Hotel Room search and purchase using AJAX, JQuery, Angular JS, CSS3 and HTML5.
• Worked with JQuery Plugins to improve user experience, using Data Table, Data Charts to show the amount, availability of the hotel room left.
• Developed the flow diagrams for business process of the company using Microsoft Visio and analyzed and documented the requirement in Microsoft Word.
• Helped creating a Common Outlook Module to auto generates the Meeting Invitation in Microsoft Outlook.
• Acted as a liaison between management & development team for requirements & QA.
• Participated in the planning and execution of the User Acceptance Testing effort.
• Ensured application forms and reports (UI) followed client’s development standards and guidelines in terms of usage, naming conventions etc.
• Conducted workshops for internal users to provide training.
• Worked with stakeholders on Joint Application development (JAD) during prototyping phase of SDLC.
• Involved throughout the business System Development Life Cycle (SDLC).
• Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle.
• Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
• Facilitated JAD sessions with model diagrams to elicit future state business requirements and to document Business Use Case To-Be artifacts.
• Created SQL scripts to validate the inputs.
• Worked with QA team to develop performance test cases based on projected user load.
• Involved in all stages of testing process - Development of Test scripts and Test cases based upon requirements for Functional Testing, Integration Testing and support for User Acceptance Testing.
• Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application.
• Worked with management to create and communicate critical information to the user community via email and discussion boards.

Environment: Pencil Project, MS Office (Word, Excel, Power Point),JavaScript RUP, Share Point, MS Visio, Microsoft Outlook