SUMMARY

• Over 7+ years of extensive IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications and Tableau.
• Extensive experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Technically hands-on commercially experience mainly with full range of BI Skills with Tableau 7x, Tableau Desktop, Tableau Server and Tableau Public.
• Expertise in Tableau BI reporting tools & Tableau Dashboards Developments & Server Administration.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Deployed the reports and Scheduled Reports for the use of end users and customers
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Expertise in Staging Partitions and Usage Based Optimization mechanisms for SSAS 2012 and 2008 OLAP databases.
• Experience in Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments
• Involved in performing Audits and recovery operations of SSAS objects.
• Conducted detailed analysis and understanding of existing business requirements to produce technical designs.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Extensive experience working as a Business Intelligence Consultant with specialization in IBM Cognos BI Suite.
• Hands on Experience with Framework Manager Modeling and Complex Report development with Report Studio.
• Sound Skills in developing Dashboard Reports in Report Studio and Active Reports for Mobile Applications.
• Sound Skills in Developing Multi-Dimensional Models & Developing Power Cubes in Transformer.
• Developed List, Cross-tab and Chart Reports using Drill-Through, Master-Detailed and dynamic Customized Prompt functionalities.
• Expertise in developing Score Card Applications using Metric Manger and Metric Studio.
• Strong Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Experienced in Creating Stored procedures Query Subjects in Framework manager as per the reporting requirements.
• Expertise in developing Database Schemas such as Star Schema and Snowflake Schema, which are used in relational, dimensional and multidimensional modelling.
• Strong Experience on Installation & Configuring the Cognos Tools on different platforms.
• Involved in Performance Analysis and Tuning
• Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE, TERADATA and DB2.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
• Strong problem solving skills, ability to develop strategies for clients, and provide detailed documentation to clients.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 7, 8.1 & 9,Tableau Server 7, 8.1 & 9, Cognos 10.2, 10.1, 8.4.1 Suite Cognos 8.4 Suite,, CRN 1.1 MR3, Cognos EP Series 7.3 (Power play Transformer,Power play Windows/Web, Impromptu, Upfront, Metric Manager,Metric Studio, Event Studio), SDK, SSAS,SSRS.

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX, 7.

Languages: SQL, T-SQL,PL/SQL, MDX, Unix shell scripting, C, C++, HTML, XML. ETL Informatica 9x/8x/, Data Junction, SQL Loader, DataStage.

Databases: SQL Server2005, Oracle 9i/10g, DB2, Teradata V2.

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS) .

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Sr Tableau Consultant

Responsibilities:

• Reported directly to the Senior Manager for EDW and Business Reporting.
• Designed and perfected the reporting requirement documents and the tracker logs to track and assign the work packets until they get completed /resolved.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• 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 Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS 2012 and 2008 OLAP databases.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Converted Metric insight reports to tableau reports.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using 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.
• Extensively worked on Tableau Desktop, by creating Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Up on Special Request from the users new tables are added to the existing schema for the Transformation purpose and created Application objects on top of them for the SSRS Reports.
• In order to support the special reports a new reporting table created in schema.
• Designed and Developed Schema Tables, Attributes, Facts, Hierarchies, Metrics, Filters, Prompts, Custom Groups, Consolidations, and Reports using SSRS.
• Involved in creating a lot of documentations like technical Specs, Report Specs, etc.

Environment: Tableau (Administrator, Desktop, Tableau Desktop 7, 8.1 & 9,Tableau Server, Web), DB2, Informatica, Html, Windows 7, SQL Server, SSRS,SSAS.

Confidential, Roseland, NJ

Sr. Tableau Developer/ Analyst

Responsibilities:

• Defined data source and data source views for each report as per client requirement.
• Involved in creating dashboards and reports in Tableau 7.0.
• Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.1 to Tableau 7.0
• Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal
• MDX query performance of Hierarchies and Fact Dimensions
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS 2012 and 2008 OLAP databases..
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for CHOP Enterprise wide Tableau application consisting of multiple key functional business domains.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: Tableau Server 7.0, Tableau Desktop 7.0, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, MS SQL Server Analysis Services 2005, .NET Framework 3.5, MS SQL Profiler.

Confidential, White Plains, NY

Cognos Consultant

Responsibilities:

• Analyzed Business requirements and existing reporting environment
• Involved in gathering requirement from end users and creating functional specification document
• Customized Cognos Connection with appropriate reports and security measures
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Cognos Connection.
• Involved in Designing models using Framework Manager and deployed packages for reporting
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created database layer and business layer, defining appropriate relationship between tables, query subjects in Framework Manager
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Burst Reports against database.
• Created Transformer models and built power cubes using PowerPlay Transformer and published onto Cognos Server, created reports using cubes in Report Studio and Analysis Studio
• Worked on Analysis Studio to develop multi dimensional reporting
• Used Cascading prompts, Filters, Calculations to create efficient reports in Report Studio and Analysis Studio.
• Extensive training for end-users to generate reports using Analysis Studio and Query Studio. Sessions on best practices involved in modelling and reporting.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Scheduled Reports using Cognos Connection
• Developed Complex Report Studio Reports using Bursting, Tabular Objects.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Prepared User documentation to train users and functionality of each report.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.

Environment: Cognos 8.4 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer), Oracle 10g, TOAD, SQL, PL/SQL, Unix, Tomcat/Apache, windows 2000 )

Confidential

SQL Developer

Responsibilities:

• Understand and evaluate UNIX, SQL and or Data Modeling.
• Design and develop T-SQL procedures, query performance tunings and SSIS packages.
• Develop underlying data models and databases.
• Develop, manage and maintain data dictionary and or metadata.
• Ensure compliance of standards and conventions in developing programs.
• Design, develop and implement complete life cycle of data warehouses.
• Translate business requirements into software applications and models.
• Resolve and troubleshoot complex issues.
• Perform and execute data extraction, transformation and loading using ETL tools.
• Maintain and manage all versions of data models for production, testing and developing databases.

Environment: Oracle 9i, SQL SERVER, Flat Files, SQL, PL/SQL, Windows NT.