SUMMARY

• Over 8+ years of experience in Analysis, Design, Administration, Development, Integration, Implementation and Maintenance of Data warehousing, ETL, Business Intelligence and Database platforms.
• 3.5+ years of extensive experience with design and development of Tableau Reports.
• Extensive knowledge of Business Intelligence platforms and processes across Financial, Banking, HealthCare, Retail and Technology industries.
• Experience in the Development, Implementation of Database/Data Warehousing Environment, BI Analytics and Dashboards applications using Data Profiling, Data Extraction, Data Transformation, Data Loading, Data Visualization using Tableau, Informatica, SSIS technologies.
• Expertise in the design and development ofTableauvisualization and dashboard solutions using Tableau Desktop and publishing the same on Tableau Server/ Public/ Reader and external websites.
• Experience transforming complex business requirements into rich data visualizations using Tableau.
• Worked to a great extent with the design and development of BI reports / dashboards using Tableau visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Pareto Charts, Gantt Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculation, Calculated fields, LOD, Sets, Groups, Parameters, Forecasting, Blending and Trend lines.
• Hands on experience in Automation Tools namely QTP, Test Complete, QC and familiar with tools like Egg Plant and SIKULI
• Extensive experience with SQL Development - Querying data, creating tables, creating views, stored procedures, Triggers etc.
• Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Excellent understanding of ETL process, Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases and client/server applications.
• Worked with different data sources like Teradata, Oracle, SQL Server, PostgreSQL, XML, PeopleSoft, Excel and flat files, Big Data, DB2 etc.
• Familiar in using tools like File Zilla, Winscp, Putty, SVN, SQL Developer, TOAD.
• Played key role in Agile team including participating in job sprints on SCRUM based projects
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production support.
• Good knowledge on JavaScript API integration of Tableau with web portals
• Good working on integration of Tableau reports with web application ( .Net)

TECHNICAL SKILLS

Business Intelligence: Tableau Desktop, Tableau Server, Tableau Reader, SSRS, QlikView Desktop

Database Technology: Teradata, Oracle, DB2, MS Access, MS Excel, MS SQL Server

Programming Language: C, C++, SQL /PLSQL, HTML, JavaScript, C#

Methodologies: Scrum, Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, Waterfall, Agile, RAD

Operating Systems: Windows XP, Windows NT / 2000, Windows 7, MS-DOS, Linux

Version Controls: SVN, Kiln

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Sr. Tableau Developer

Responsibilities:

• Worked closely with product owners and business analyst in estimating tableau development to satisfy business needs.
• Involved in the database design and relational model development for database
• Involved in setting up the cluster environment in Tableau Server to process concurrent users.
• Played Lead developer role for the Agile Scrum Development Life Cycle utilizing Rally software to track the entire development phase of the project.
• Worked extensively in SQL Server and DB2 databases to analyze different trends and patterns over a period of time.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Utilized Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Implemented parameters, quick filters and sets to display performance of different attributes.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Data blending of DB2 and SQL tables in tableau
• Published Workbooks and Dashboards to the Tableau server.
• Integrated Tableau views/workbooks/dashboards on external websites using AngularJS which enable users to change certain fields as required
• Used commands in Tamed and Tabadmin utility tool for Tableau Server
• Integration of tableau reports with asp.net web application
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks.

Environment: Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x, Rally, SQL Server 2012, IBM DB2, Microsoft Office Suite ( Word, Excel, PowerPoint), Asp.Net C# 4.5, Visual Studio 2013

Confidential, Taylor, TX

Sr. Tableau Developer

Responsibilities:

• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Analyze complex data from various data repositories and become familiar with user base locations.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth based on users upgrading to additional features of the mobile app additionally adding filter to choose between business and personal users.
• Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Used parameters and input controls to give users control over certain values.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Created Data extracts for better performance of dashboards and accessing data offline.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsof the user counts.
• Integrated dashboards with live Connection in Microsoft PowerPoint using LiveWeb add on.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Created reports using Custom SQL for complex report views.
• Executed and tested required queries and reports before publishing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop/Server) 9.x/8.x, Oracle 11i, MS SQL Server, SQL BI Suite (SSIS, SSRS), SharePoint, MS Visio, Microsoft Office Suite( Word, Excel, PowerPoint).

Confidential, Cleveland, OH

Tableau Developer

Responsibilities:

• Interacted with business user group for domain requirements gathering.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Involved in defining the whole project life cycle, following agile methodology. Analyze business requirements and segregated them into high level and low level
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• 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.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Environment: Tableau Desktop/Server, SQL Server 2008, Oracle 11g, SQL, PL/SQL, T-SQL, MS Visio, Microsoft office Suite ( Word, Excel, PowerPoint) .

Confidential, Sioux Falls, SD

Business Systems Analyst

Responsibilities:

• Played a key role in gathering and documenting Business requirements.
• Conducted Requirement walk-through meetings with key stakeholders.
• Participated in technical walk-through meetings to develop the functional design for the implementation.
• Performed detailed requirement analysis and created data mapping documents
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Designed the conceptual data and business process models.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modeling techniques in designing the data marts project.
• Extensively involved in Data mapping and Data modeling.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Developed mappings and workflows in Informatica to extract data files for third party vendors.
• Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
• Involved in modifying Teradata stored procedures and performance tuning of various tables.
• Managing metadata by mapping dimensions and fact tables of various schemas/data models
• Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports using ERwin Tool.
• Conducted JAD sessions, design discussions and SOS meetings to come out with the appropriate data mart.
• Experience defining enterprise data location architectures for ODS, Data mart, and Data Warehouse data.
• Created test cases for carrying out unit testing and part of functional testing.

Environment: Erwin, ER/ Studio, SSIS, SSRS, Oracle, Toad, SQL Developer, TOAD, UNIX, MS Visio, MS Office Suite (Word, PowerPoint, Excel).

Confidential

Software Engineer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Conducted Performance review and end to end testing of Loan IQ
• Created test sets using quality center and merged it with QTP
• Analyze, design, implement and test ad-hoc and standard reports.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Designed and developed various complex reports.
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Preparedfunctional specificationsfor user requirements.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Createdentry forms/reportsfor various modules. Createddatabases, loaded initialization data, generated users, and assigned rolesandaccess.
• PreparedUser manual, Technical documentsfor the end user.
• Prepared executables for system deployment and led the release of applications following
• Experience in UNIX Environment in file transfers, job scheduling and error handling
• Maintenance and support for the system. Involved inend user training.

Environment: Oracle 10g/9i, Windows 2000, PL/SQL, TOAD