SUMMARY:

• Having 7+ years of IT experience inBusiness Intelligence(Cognos, Tableau), Data warehousing, Data modeling.
• 4 years of experience working with visualization tools like Tableau.
• Have good understanding of Tableau Architecture, design, development and end user experience.
• Extensive experience in Tableau Desktop, Tableau Server8.x.
• Designed various KPI’s for business monitoring of Client.
• Expertise in Designing Aggregations, Hierarchies, Formatting Sorting in Tableau.
• Proficient in creating Groups, sets, Data bins
• Good Expertise on working with Multiple Measures like Individual axis, Axis Blending and Dual axis.
• Implemented Joins, Data Blending, Custom SQL in Tableau.
• Good Knowledge in Users and Group Management, Licensing and Data Connections, Scheduling in Tableau Server.
• End to end experience in designing and data visualizations using Tableau
• Extensive experience working as a Business Intelligence with specialization inCognos 8.3/10.1.2.
• Extensively usedFramework Manager,Query StudioandReport Studioformodel design, ad - hocreporting andadvancedreport authoring.
• Systems analysis and design, converting requirements specifications into functional specifications.
• Having Experience on Framework manager for creating models,folders,filters and publishing packagaes.
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill through, Master-Detail, and Cascading) and Dashboards using Active Reports.
• Worked with Different Databases likeOracle/9i/10g/11g, SQL Server 2000
• Ability to work with different source systems (flat files, xml files, RDBMS, etc.)
• Hands on experience withDimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• ExcellentVerbal & Written Communicationskills and strong inDocumentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Proven background improving process quality and providing system Automation recommendations and Strategies to manage solutions and data efficiently..
• Efficient in working closely with Development, QA, Product and Business owner teams to ensure high quality and timely delivery ofReports across multiple platforms and environments.

TECHNICAL SKILLS:

Reporting Tools: Tableau8.2/8.3(tableau Desktop, Tableau Server), Cognos 8BI, ( Framework Manager, Report Studio, Query Studio, Cognos Connection).

ETL Tools: Data Stage8.5/9.1.

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

Project Methodologies: Waterfall, RUP, Agile

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

Programming Languages: C, C++

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

EMPLOYMENT HISTORY:

Confidential, Aiken, SC

Application: SPC

Responsibilities:

• performed Gap Analysis according to Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Involved in JAD sessions with the whole team of Data Modeler, Analysts, and Developers to create a technical flow until reporting.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Tableau, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Make use of filters and making them local and global accordingly.
• Publish the developed dashboard, reports on the Tableau Server so that the end users who have access to the server can view the data.
• Scheduled Full and Incremental Refresh of the underlying data sources while publishing them to the server.
• Involved in the migration project where the Reports from Micro-strategy are re-created in tableau using more visualization options available as per End user requirement.
• Analyzed the data in the Micro-Strategy reports.
• Created Drill-down and navigation features extensively in Tableau Desktop.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Actively participated in clarification meeting with the Client.
• Created different types of charts.
• Providing the Security while Publishing to the Tableau Server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Developed various types of complex reports like Cross tab reports, Drill Down and Master Detail Relationships.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Applied the actions in the work sheets and dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
• Created Test Cases and documented the Test Results.
• Extensively involved in doing user acceptance testing (UAT)

Environment: Tableau8.3, Datastage9.1, Oracle10g, Toad.

Confidential, Neenah, WI

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.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• 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.
• Created Stories using Tableau as part of report presentations to Business
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
• Responsible for Preparing the Report Design specifications based onthe User’s requirements
• Created different types of charts.
• Providing the Security while Publishing to the Tableau Server.
• Developed various types of complex reports like Cross tab reports, Drill Down and Master Detail Relationships.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Applied the actions in the work sheets and dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.

Environment: Tableau 7.0/8.0, MS Excel, DB2, TOAD, Windows

Confidential, New Orleans, LA

Application: Global Sales Data Mart

Responsibilities:

• Involved in gathering the requirements andanalyzing them
• 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 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.
• Extensively involved in doing user acceptance testing (UAT).

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

Confidential, Bedford, NH

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be a developer.
• Created dashboard using parameters, sets, groups and calculated fields
• Involved in creating a dual-axis bar chart with multiple measures and also created bins for different measures.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Implemented data blending in order to merge data from different sources.
• Used and applied actions like filter, highlight and URL to dashboards.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, SQL Server and Oracle.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Developed local and global filters while preparing worksheets and dashboards in Tableau.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Published Tableau Packaged Workbook (.Twbx) in Server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Experience in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.
• Creating Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau users.
• Build homepage to navigate to all reports.
• 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.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting for future predictions.
• 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.
• 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.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Strong knowledge of Data Warehousing methodologies and concepts including Star Schemas, Snowflake Schema and identifying fact and dimensional tables.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Administered user, user groups, and scheduled instances for reports in Tableau.

Environment: Desktop & Server 8, MS SQL Server 2012, T-SQL, SQL Server Management Studio, SharePoint, MS Office 2010/2013.

Confidential

Application: P3MF

Responsibilities:

• Interacted with cross functional teams to facilitate gathering of business requirements.
• Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.
• Developed various reports using functionalities like Drill through, Master Detail, Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Congo's.
• Recommended and coordinated development efforts and enhancements
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
• Used java scripts to manipulate the prompt pages and their functionalities.
• Involved in writing Complex SQL queries to improve the performance of the report.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved in Deployment to QA, UAT and Production environment
• Understanding the source systems and MD50’s developed by Oracle Financial team.
• Gap Analysis with source systems.
• Preparation of CV-40 documents.
• Design and develop the ODS.
• Developing in Framework Manager Project designing.
• Creating Meta Data Models and Publishing packages to Cognos connection.
• Preparation of Report design documents.
• Responsible for the delivery of solution-oriented complex reports with multiple prompts, conditional formatting and calculated columns using Cognos report studio.
• Developed reports with filters, calculations, prompts and conditions using Cognos report studio.
• Developing the cube using IQD.
• Involved in Scheduling and Cognos Report studio reports using Schedule Management in Cognos Connection.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Oracle 10g, Cognos Access Manger

Confidential

Responsibilities:

• Interacted with cross functional teams to facilitate gathering of business requirements.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Analyzed Business Requirements, performed GAP analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness Diagram using Rational Rose.
• Involved in Change Management Configuration using Rational Clear-Quest.
• Performed UAT testing of the requirements. Testing for checking the data flow of the application using SQL.
• Involved in preparing flow diagrams for the decision logic using Visio tool.
• Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.
• RUP process model was used for the different phases of the application development of the Software Development Life Cycle
• Recommended and coordinated development efforts and enhancements
• Generation of the UML Collaboration and Sequence Diagrams for specifying the call flow.
• Worked on Data Mapping for the models for data transformation.
• Worked with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing and documenting functional and technical requirements to develop packages and reports.
• Developed standard/complex reports and analytics to meet the needs of business analysts and business users.
• Built ad-hoc reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of master-detail reports using repeaters and repeater tables.
• Customized reports by adding Filters, Prompts, Calculations, Summaries and Functions.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Bursting reports to different user groups.
• Involved in full development of life cycle (SDLC) within Cognos reporting Framework from developing business requirements to production environment.
• Provided the prompts, filters, drill up/drill down in Query Studio.
• Created different types of reports like predefined Filters for the Ad hoc users, List, Cross-tab, Chart, Drill-Through and Master-Detail Reports for production using report studio

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis studio), Oracle 10g, Windows, Microsoft Excel, Microsoft Word, Microsoft Visio, Rational Tools, Clear Quest, Clear Case, Microsoft Access