PROFESSIONAL SUMMARY:

• 7+ years of experience in Data Analysis, Design, Implementation, Administration and support of Business Intelligence using SQL Server SSIS, SSAS and SSRS.
• Extensiveexperiencein Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau Reader in various versions of Tableau (8.x/9.x/10.x) and SQL, PL SQL and UNIX shell scripting
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Having experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools in Nonprofit, Healthcare, Financial, Banking and Services industries.
• 4+ years of extensive experience with design and development of Tableau visualization solutions.
• Proficient in conducting Gap Analysis, Business Process Re - engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design identifying interface and business process specifications.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Expertise in Netezza, Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, Micro Strategy, Unica, Google Analytics, UNIX, Toad, Microsoft Office Suite.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data.
• Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, and Parameters etc.
• Coordinate/assist/develop cognos framework manager model adjustments to accommodate new and existing requirements.
• Experience with Tableau new features like Level of Detail (LOD) expressions EXCLUDE, INCLUDE, and FIXED to present fixed comparisons and data at different grain.
• Hands on experience in embedding Tableau reports and dashboards on external websites using JavaScript API.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Experienced in roles such as End-to-End BI and data-warehouse Solution implementation expert, BI Reports/Dashboards/Scorecards design and development, BI KPIs Modeling.
• Designed the data conversion strategy, development of data mappings, source data profiling and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Flexible, enthusiastic, project oriented team player with excellent communication skills and leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

Analytical Tools: Tableau 10.x, 9.x, 8.x (Desktop/Server/Reader/Public/Online),SSRS,SSAS, Micro Strategy (Desktop/Server), UNICA, Google Analytics (Adobe Site Catalyst).

Data Integration (ETL) Tools: Informatica, SSIS

Data Modelling: Power Designer, Erwin, Visio

RDBMS: Netezza, Teradata, Oracle, MS SQL Server, DB2, Sybase, Access

SQL Tools: Teradata SQL Assistant, PL/SQL Developer, Toad, SQL Server Management Studio

Service Management: CA Service desk, Lotus Notes

Document Management: Share Point

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Defect management tools: Mercury Test Director, HP Quality center

Scripting Languages: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Orange county, CA

Tableau Developer

Responsibilities:

• Retrieve and analyze data using Python, MSSQL, Excel, and other data management systems.
• Created tableau custom geo code map based on three digit US Zip codes for tracking plan providers' participation.
• Designed Tableau dashboards and reporting for critical statistics which impact business decisions.
• Built workflow for design, development and maintenance of ongoing metrics, reports, and dashboards to drive key conclusions on each Blue Distinction Specialty Care.
• Designing and performance tuning of tableau workbooks, data sources, and provide best practices for user community.
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Designed and developed various analytic reports / dashboards using Tableau.
• Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Assisted power users in Tableau dashboard development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Environment: Tableau(Desktop/Server) 10.x/9.0/8.3, Microsoft SQL Server, JIRA, SSIS, SSRS, SSAS, MS Visio, Microsoft Office Suite ( Word, Excel, PowerPoint).

Confidential, Sunnyvale CA

Tableau Developer

Responsibilities:

• Designed, developed and tested various Tableau dashboards such as Scorecard, marketing dashboards, usage reports and various Ad-Hoc reporting solutions using Tableau 10.0.1 and 10.3.0.
• Analyzed data requirements, application and processing architectures, while designing, developing, amending, and optimizing database designs to satisfy client needs.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Daily data pull and testing using SQL queries.
• Developed dashboards using Custom SQL queries, and various data sources using data blending techniques.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Performed End to end testing using SQL Queries in Oracle.
• Provided training sessions to business users on how to use Tableau reports.
• Developed PoCs for business users displaying various functionality and visualization.
• Update and maintain various release documentation, and JIRA tickets.
• Maintained multiple version of Tableau dashboards using SVN.
• Schedule reports, administer users and user groups for workbooks, data sources and views in Tableau.
• Worked with ETL team on designing Oracle tables for multiple projects, data analysis and SQL Query transform.
• Analyzed the data using Statistical features in Tableau to develop trend analysis like context reports based on Daily, MTD, last one month, and YTD date fields.
• Identified opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion

Environment: Tableau(Desktop/Server) 10.x/9.0/8.3, Microsoft SQL Server, JIRA, SSIS, SSRS, SSAS, MS Visio, Microsoft Office Suite ( Word, Excel, PowerPoint).

Confidential, Columbus, GA

Sr. Cognos Consultant

Responsibilities:

• Attend workshops with the business teams to understand requirements
• Defined technical Design Document requirements (TDD) based on the business requirements workshops.
• Created Cognos reports and framework models for creating complex logic driven reports.
• Report and package deployment, folder creation, granting accesses and security to the reports.
• Provided Cognos training to business and technical users.
• Develop filter, calculations and prompts using Cognos Report Studio. Created list, cross-tab and Drill-through reports
• Incorporated Report Studio, Query Studio to develop reports to be used by the end users for viewing the day to day affairs of the business in Cognos 8.4/10.1 suite.
• Worked on performance tuning of the complex reports for better performance after migrating them to 10 series.
• Created User guides on Query studio for users to perform few practice labs and learn the component for their business need
• Worked on a tight deadlines and delivered the reports in expected time frame including the testing and documentation.
• Worked with Database Administrators, Security Teams, and IT Infrastructure teams to resolve technical issues and coordinate changes that impact user communities.
• Cognos Administration activities including Server configuration, Security, Upgrades, Patch Installations, Implementation of Change Requests.
• Coordinate with IBM on Issues, Upgrades and Installations.
• Process Improvements and Research on optimizing the Cognos Functionalities from the Application perspective.

Environment: Cognos 8BI v8.4, v10, Oracle Discoverer 4i, Remedy, Banner, Salesforce CRM, Oracle 10g

Confidential

Business Intelligence Consultant

Responsibilities:

• Worked as Onsite and Offshore coordinator in Agile methodology Environment, delivering reports for every two week sprint cycles.
• Reviewed trends in data sets, used SQL query operations to filter the data to understand the opportunities for brands and clients.
• Worked on resolving the performance issues of the cognos reports and increased the performance of the reports by tuning SQL
• Interacted with the Development and Management teams, provided technical assistance to developers.
• Used Framework Manager to build metadata model, which could be used by the Report Developers in the group.
• Created excellent presentations to expose the development work to the end users and the stake holders.
• Generated various List Reports, Grouped Reports, Crosstab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Generated complex reports in Cognos 8.4 report studio including Drill-Down Reports from DMR modelled Framework Mode
• Created dashboards to present critical company data into a single report.
• Created List Reports and Crosstab reports using cognos 8.4.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Created reports studio reports using functionalities like drill though, master details, condition blocks and conditional formatting; Fixed JavaScript’s in reports on migration Cognos 8.1 reports to 8.4.
• Created reports in Cognos 8.4 using Native SQL.
• Created Framework Manager Models using several different intermediate layer and business/presentation layer/Folder/Functions and published packages to Cognos Connection.
• Deployed the Ad-hoc Model Reports from Dev. to Val. and to Prod. Environments.
• Understanding existing business model and writing requirements (BRDs).
• Created the Entity Relationship Diagram implementing Star schema using VISIO
• Developed various mappings and Stored Procedure transformations using PL/SQL Framework.
• Worked on Cube Designer to build MOLAP cubes
• Created and adopted multi layered approach to avoid data complexity for end users in FM.
• Prepared EOW(End of Week) Status Reports and shared with the Managers.

Environment: Cognos8 BI v8.1 & 8.4, Oracle 9i, SQL Server 2005, Load Runner, Remedy, WMS