SUMMARY

• Around 7.5 years of experience in Information Technology industry with a strong background in analysis, design and development in the field of Data Warehouse, Business Intelligence Data Modeling and Implementation of Tableau Desktop 7.X,8.X, Tableau Server, Cognos 8.X/10.X, database.
• Ability to define and develop Report Structure withdata definition, report layout and report definition language.
• Creating Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Created Derived Columns to fulfill the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Designed, developed and supported BI solutions, involved in debugging, monitoring and troubleshooting issues/tickets.
• Experience with the design and development of Tableau visualization solutions.
• Excellent inrendering reports, managing subscriptions,creating reports in Tableau.
• Excellent in scheduling and deployment of reports in Tableau
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Competence in generating analytical reports using Slice and Dice, Drill down, Cross Tab, Graph, Parameterized reports using Tableau.
• Good working knowledge in publishing customized dashboards and automation.
• Experienced in SQL programming and creating Tables, Stored Procedures and Triggers, user - defined Functions, Views, Indexes, user profiles and relational database models.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Hands on experience withDimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Strong knowledge on software development life cycle (SDLC).
• Providing the Security while Publishing to the Tableau Server.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the various applications.
• Proven background improving process quality and providing system automation recommendations and strategies to manage solutions and data efficiently.
• Strong analytical, logical, Communication and problem solving skills. Ability to work independently, excellent communication and strong team-building management skills.

TECHNICAL SKILLS

BI Reporting tools: Tableau 8.3/8.2/7.0/6.0 , Cognos 8x

Databases: Oracle 9x/10x/11x, SQL Server 2000/2005/2008/2012

Operating Systems: Windows 95/98/2000/XP/Vista/7, Linux

ETL tools: Informatica 8.6

Business Modeling tools: IBM Rational Modeler, MS Visio

Project Methodologies: Waterfall, RUP, Agile

Other tools: MS Office Suite, MS Project, Share Point

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Report Developer

Responsibilities:

• Involved in gathering the requirements andanalyzing the requirements,
• Regularly interacting with customer to resolve issues.
• Responsible for Preparing the Report Design specifications based onthe User’s requirement.
• Involved in Data modeling.
• Extracted data from various sources and performed data blending.
• Creating Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, and Geographical Maps.
• Strong knowledge on software development life cycle (SDLC).
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
• Created Derived Columns to fulfil the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Worked with Tableau Server Extract (.TDE).
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand data in an easy and efficient manner.

ENVIRONMENT: Tableau Desktop, Tableau Server, Oracle, Informatica, Windows NT

Confidential, Towson, MD

Report Specialist

Responsibilities:

• Involved in gathering the requirements andanalyzing the requirements and interact with the customer to find the proper information.
• Responsible for Preparing the Report Design specifications based onthe User’s requirement.
• Extracted data from various sources and performed data blending.
• Created different type of charts.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.
• Updating the weekly status and tracking the query sheet.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters and date functions.
• Created Stories using Tableau as part of report presentations to Business.
• Extensively worked on issue tracking tools like Succeed etc to resolve the issues rose by Business promptly.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

ENVIRONMENT: Tableau Desktop and Tableau Server

Confidential, Sparks, MD

Report Developer

Responsibilities:

• Understand the customer requirements and technical specification documents.
• Developed Tableau Dashboards for visualization solutions.
• Responsible for interacting with stake holders, gathering requirements and managing delivery.
• Developing data model to create reports and dashboards.
• Implemented Binning & Blending concepts in my Tableau Reports.
• Worked on Individual Axis, Blended Axis and Dual Axis concept while working with reports.
• Created Work sheet by using calculations and aggregations.
• Created parameters using customized calculations.
• Created reports using conditional formatting.
• Involved in refreshing the Data Extracts and Auto updates in Dashboards.
• Created Filters, Groups, Sets on Tableau Reports.
• Worked with Live and Extract connection.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Created Cascading reports in Dashboard.
• Created Tableau work sheets by connecting TDE.
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
• Experienced with creation of Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau Server logons and security checks.
• Created Parameters to achieve desired functionality.
• Experienced in creating dashboards and various chart views in tableau.
• Experienced in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Created Users, Groups and Set Permissions on Server.
• Formatted the Reports as per the Client requirement.
• Involved in Data modeling and advanced Reporting experience.
• Created Cascading reports in dashboards.

ENVIRONMENT: Tableau Desktop, Tableau Server, Oracle, Informatica, Windows NT

Confidential, Columbus, OH

Tableau Developer/ Admin

Responsibilities:

• Interaction with a diverse group of professionals and gathered user requirements and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping and Design process for various sources and Targets.
• Adhere to good systems agile development methodology.
• Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.
• Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Creation of workbooks and dashboards those are accessible on different environments like any browser or tablet. Developed dashboards for calendar year and fiscal year.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Created Stories using Tableau as part of report presentations to Business.
• Extensively worked on issue tracking tools like Succeed etc to resolve the issues rose by Business promptly.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Developed knowledge on certain BI tools like QlikView helping the End Users to modify the existing QlikView Visualizations.
• Effective story board development conveying the story in transparent manner to the users.
• Responsible for generating dashboards in Tableau Server using different data sources including hadoop, Excel, Oracle and Microsoft SQL Server.
• Distributed Tableau reports using Packaged Workbooks, PDF to authorized user community.
• Responsible for performance optimization by writing SQL overrides.
• Improved performance of tableau dashboards and maintained high level of data integrity.

ENVIRONMENT: Tableau 7.0/8.0, MS Excel, DB2, TOAD, Windows, QlikView

Confidential, Somerset, NJ

Cognos Report Developer

Responsibilities:

• Involved in gathering requirements from Clients.
• Involved in Frame Work Projects & Model to publish the package.
• Involved in Developing Functional Specs & Technical Specs and done reviews.
• Developed Reports using conditional formatting, drill through and master detail relationships.
• Used Cascading Prompts, Filters, and Bookmarks to create efficient reports in Report studio.
• Done Testing after completion of Report development.
• Developed scheduled reports as per client requirements.
• Involved in Deployment of Data sources from one server to another server (Dev Server, Qual Server, and Production Server).
• Reporting regularly & interacting with onsite coordinator to resolve issues.
• Sending Daily Status Reports, Weekly Status Reports to team lead and client.
• Performed End User Training and Support.
• Involved in creation and updates of several SQL Indexes, joins, Views, Stored Procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Involved in performance tuning by creating and updating stored procedures and triggers.

ENVIRONMENT: Cognos Series 8, (Frame Work Manager, Report Studio, Query Studio, Cognos Connection), Access Manager, Configuration Manager, IIS 5.1, Oracle 9i, Toad, PL/SQL, Win XP Professional.