SUMMARY

• 6+ years of experience in Data Ware Housing and Business Intelligence applications in various domains like banking, health and retail businesses.
• 4+ years of experience in Tableau Desktop, Tableau Server, Tableau Reader, Tableau Public in various versions of Tableau 9.x/8.x/7.x/6.x.
• Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end - user/clients/stake holders, Subject-Matter Experts and the technology group.
• Proficient in documentation of business requirements and system functional specifications
• Proficient in design and development of various dashboards/ reports utilizing Tableau Visualizations like Bar Graphs, Scatter Plots, Pie-Charts, Geographic Maps ( Symbol Maps & Filled Maps), Heat Maps, Bubble-Charts, Funnel Charts, Circle Views, Area Charts, Histogram, Box & Whisker Plot, Line (Dual & Discrete)and Highlight Tables making use of actions, other context, 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.
• Experience in deployment of tableau by laying the architecture by using suitable deployment model, creating security levels for users, looking after the system administration, ensuring the best practices for optimal use of the system.
• Good knowledge on Java Script API and Asp.Net Web application integration with Tableau.
• Experience in configuration of backgrounds jobs, scheduling of the extract refresh activity, trouble shooting failed refresh activity, monitoring dashboards performance on tableau server.
• Extensive knowledge in various reporting objects like facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, Sets, groups, parameters etc., in Tableau.
• Experienced in using Normalization and De-Normalization techniques.
• Experience working with Data Sourcing, Data Mapping, Data Profiling and Data Mining.
• Good experience in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling
• Have been working with various data sources such as Oracle, SQL Server, Hadoop, ODBC and flat file sources.
• Expertise in System Analysis Development and Quality Assurance including Functional, Regression, Integration, System and Performance Testing of Client/Server and Web based Applications.
• Excellent communication, co-ordination and interpersonal skills. Can establish & maintain communications at all levels between technical and non-technical personnel of all ages and backgrounds.

TECHNICAL SKILLS

Databases: Oracle … MS Access, MySQL

Scripting: SQL, PL/SQL, UNIX Shell Scripting, PERL scripting

Languages: C, C++, Java, SQL, HTML

Operating Systems: UNIX, Windows

BI Tools: Tableau desktop / Tableau Server, Qlikview, Business

Objects, SSRS:

Query Tools: TOAD, SQL Developer, and SQL*PLUS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Data Analyst

Responsibilities:

• Implemented 60+ minor enhancements in the period covering customer management, recoveries, fulfillment management, customer acquisitions, rewards, high yield accounts, money market accounts.
• Interacted with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on nontechnical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS.
• Created Data Definitions and help maintain Metadata repository.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Worked on motion chart, bubble chart, drill down analysis using tableau desktop.
• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau / SSRS.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Environment: Tableau (Desktop/ Server), MS SQL Server, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Created dashboards for analyzing POS data using Tableau 8.0 on top of SAP HANA.
• Developed dashboards for POS use cases to understand new product launch, promotion effectiveness, trend detections and cannibalization.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.
• Expert level capability in table calculations and applying complex, compound calculations to large, complex big data sets
• Used trend lines for correlating different KPI’s for new product launches.
• Created required custom functions in the reports (Date range, Time functions, Logical functions).
• Scheduled an extract refresh and also subscriptions for weekly and monthly reports.
• Tableau dashboards were integrated into internal web portal using Java Script API.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Provided user trainings on the key dashboards
• Provided detailed documentation on the Analytical deliverables
• Used Industry standard design templates for POS use case analysis.

Environment: Tableau 8 Desktop, Tableau server, SQL Server 2008R2, Informatica 8, SQL.

Confidential, Hartford, CT

Tableau Developer/System Analyst

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content in each category allowing interaction between the two charts for drill down analysis.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers of viewers watching a particular sports channel.
• Blended data from multiple databases such as MS Excel and SQL database by assigning primary key from each databases.
• Upgraded Workbooks and Dashboards from Tableau 7 to Tableau 8.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.

Environment: Tableau Desktop 8.1, Tableau server / Administrator, SQL server 2008/2012

Confidential

Report Developer - SQL Programmer

Responsibilities:

• Develop and maintain reporting solutions utilizing Microsoft Reporting Tools.
• Plan, execute, and coordinate the tasks required for the development, testing and implement business reporting solutions.
• Develops analytical and reporting tools for the client enterprise reporting organization.
• Wrote codes to extract data from numerous databases for routine and non-routine report purposes.
• Involved in the development related procedures and operating instructions for business users.
• Assist in Investigate, troubleshoot, and resolve problems by coordinating with the teams.
• Provide consulting support to business functional teams as needed.

Environment: MySQL, Microsoft SQL Server 2005 Enterprise Edition, SQL Business Intelligence Development Studio (BIDS), Oracle, Microsoft Visual Studio.

Confidential

SQL Developer

Responsibilities:

• Design, code, test, debug, and document complex database programs to ensure that data processing production systems meet user needs.
• Interact with internal and external clients to understand requirements, explain issues and prioritize work.
• Worked closely with end users in designing and creating the Data warehouse for management group using Erwin.
• Implemented logical and physical database modeling using Erwin tool.
• Enhance existing programs.
• Created Queries in Oracle SQL, Stored Procedures, and views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Performed tuning and optimization of queries for reports that takes longer execution time using MySQL.

Environment: MySQL, Microsoft SQL Server 2005 Enterprise Edition, Windows Server, SQL Business Intelligence Development Studio (BIDS), Oracle, Microsoft Visual Studio, IIS.