SUMMARY:

• 10 years of experience in Reporting, Data Analysis/Business Analysis, System Analysis & Design, Development, Testing and Implementation of BI/Data Warehousing projects using Tableau, Congos, Oracle, etc. in Manufacturing, Financial industries, Retail and Transportation.
• Tableau Desktop (10.4) Certified with 4 + years of experience with Tableau 7.x/8.x/9.x /10.x product suite (Desktop, Server, Reader, Mobile).
• Solid track of application of Statistical and Analytical Models in Tableau using advance analytical features including Trending, Cause and effect relationships, data distribution and anomalies and Forecasting models.
• Solid experience in Designing Tableau Reporting solutions working in agile Environments for clients, Creating Interactive Dashboards, Performance optimization, developing user Training Material and creating Best practices for reporting solutions.
• Proficient in using parameters, dynamics groups and sets, data hierarchies, filters, calculated fields and other custom function like string functions, date functions and logical functions.
• Proficient in creating visualization like Stack Bar, Bar Graphs, scattered plots, Bars, Lines and Pie charts, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables, Pareto Charts and Waterfall charts and funnel charts in Tableau.
• Solid track of working with multiple teams, handling multiple projects, conducting meetings and user probing sessions, identifying Key Performance Indicators and metrics and advising best reporting strategies based on client requirements.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, F S D and end - to-end Traceability Matrix.
• Outstanding knowledge in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• 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.
• Strong Analytical and Problem-Solving Skills and communication skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILLS:

Reporting Tools: Tableau 7.x/8.x/9.x/10.x product suite (Desktop, Server, Reader) IBM Congo s, Microsoft Power BI.

ETL tools/Databases: MS SQL Server2008, 2012, Vertica, Teradata, Oracle, MS SQL Server, IBM DB-2, Alteryx and MS Access

Database tools: SQL Enterprise Manager, TOAD, Teradata SQL Assistant

Languages: C++, HTML, SQL, PL/SQL T-SQL, Python, R Scripting

Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio

Operating Systems: Windows Server 2000/2003/2008, Windows 98/2000/XP/VISTA/7, OS 400

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Tableau Developer/Sr. Business Intelligence Specialist

Responsibilities:

• Coordinate and work with different cross functional teams including Venom Team, configuration & Design team and Capacity Team to understand/identify the business needs and come up with reporting solutions
• Prepared over 15 Tableau Reports and supported over 35 Tableau Reports related to various subject areas including Network and SBC’s Configuration, International Carrier Management and Billing, TDM and SIP Utilization, Media Gateway Management and Call Modeling and other KPI’s.
• Used Analytical features in Tableau Reports including Trending Models, Forecasting techniques, Regression testing and Reference band.
• Developed advanced Dashboards by cross joining and data blending data from Microsoft SQL Server, Vertica, MS Excel and MY SQL.
• Wrote SQL Scripts for creating aggregate tables for data set creation and performance optimization
• Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Worked extensively with Advance Analysis Actions filters, Table Calculations, Parameters, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets and Meta data management in Tableau.
• Worked on Tableau Admin for publishing reports in the production environment and trouble shooting and unit testing of reports.
• Maintain Tableau Site publishing meta data, Schedule data refresh manage automatic data driven subscriptions, project security, and managing user access.

Environment: Tableau 9.2/10.1, HP Verica, Microsoft SQL Server, MySQL, MS-Excel, Python and MS Office.

Confidential, Atlanta, GA

Sr. Tableau Developer/Sr. Business Intelligence Specialist

Responsibilities:

• Prepared multiple Tableau reports on various datasets, including Product Assortment data, Product-SKU-store combination and Sales Data.
• Worked with the Assortment Planning team to identify the KPI’s, to develop mockups and POC’s.
• Developed advanced Dashboards by blending data from IBM-DB 2 and Teradata, passing data source parameters for live connection of reports.
• Wrote SQL scripts to join the tables and load data from Teradata and IBM - DB 2
• Wrote SQL Scripts for creating aggregate tables, views adding measures in the underlying tables for performance improvement.
• Worked on Tableau Admin for publishing reports in the production environment and trouble shooting and unit testing
• Scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.

Environment: Tableau 9.0/9.2, Teradata (Teradata 15.00.04.05 ), IBM-DB2, MS-Access and MS Office (Word, excel, PowerPoint).

Confidential, Atlanta GA

Sr. Tableau Developer/Sr. BI Analyst

Responsibilities:

• Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
• Played critical role in establishing Best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI’s and developing POC Dashboards.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Worked extensively with Advance Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Wrote Custom SQL scripts for creating aggregate tables and generating views.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau.
• Upgraded Tableau server from 8.0 to 9.0 in DEV and QA along with Migration of reports.
• Developed a SSB BI Landing Page for all the reports and authored user guides of Tableau reports for the user community.

Environment: Tableau 8.2/9.0, Alteryx, SQL Server 2008R2/2012, Oracle, TSQL, Control-M, MS Visio, MS Office (Word, excel, PowerPoint).

Confidential, Foster City, CA

Tableau Developer/ BI Data Analyst

Responsibilities:

• Worked closely with the business users to identify various KPI’s and designed reporting solutions to enhance business decision-making.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop and worked on all types of report types like tables, matrix, charts, sub reports etc.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created very complex Dashboards using Tableau 8.0 using the drill down, drill across, actions for business steering committee.
• Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Defined best practices for Tableau report development.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents)
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Environment: Tableau 8.0, Oracle, PL/SQL, Control-M, MS Visio, MS Project, MS Office (Word, excel, PowerPoint).

Confidential, Glenview, IL

Tableau Developer/ BI Consultant

Responsibilities:

• Participate in the Business and Specifications requirements gathering sessions and convert it into Design specifications. The Design specification ranges from High Level Design to Application level designs and (Cross) Application Interface agreements specifications.
• Performed Analysis of Reference Data, Data sets and Asset classes to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements
• Created the AS-IS and TO-BE process flow diagrams
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Developed business, functional and/or technical requirement specifications adhering to standard requirement templates.
• Define, Create, and manage business specifications, technical specifications, and project documentation for applications development.
• Designed and developed various Weekly and Monthly reports showing detailed information that could be used to send information to diverse group of users, clients, and managers.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, and geographical maps.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).

Environment: Tableau (Desktop, Server), Teradata, Oracle, SQL Server, MS Visio, RUP methodology, Microsoft Office Suite (Word, Excel, Power Point)

Confidential, Pittsburgh, PA

Sr. Cognos Consultant /Data Analyst

Responsibilities:

• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Created dashboards, Port lets for various HR and payroll related reports.
• Developed various HR reports - MTD, QTD, YTD, last fiscal year, current fiscal year reports, employee taxable, paid time offs, holidays, sick leaves, workers compensation report (WCR) etc.
• Created complex reports in Cognos mainly dealing with Member Data, Claims data and Provider Data.
• Designed DMR models in Cognos 10 Framework Manager
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Worked on multiple databases, and multiple data sources in Framework Manager to generate reports.
• Created list, crosstab and drill through reports for departments like claims, billing, members/subscribers in Cognos 10 Report Studio
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, and multiple queries for data extraction in reports.
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Used Union, Intersection, and Exception for creating queries.
• Involved performance tuning of reports including database tuning and model tuning.

Environment: Cognos 10/ 8.4, Transformer, Report Studio, Query Studio, Metric Studio, Erwin 4.0, TOAD, Data Stage, SQL Server 2005

Confidential, Southlake, TX

Cognos Developer

Responsibilities:

• Analyzed business requirements and transforms the Functional Design Document into Technical Design Document.
• Involved in Modeling and Reporting against a Warehouse (OLAP) which is in the form of a Star Schema
• Develop dimensionally model relational for Standard Reporting, Ad-hoc reporting and for Multi-Dimensional Analysis using multi-layer Approach and Modeling Best Practices to meet the reporting requirements
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validated the Prompts using Java Script.
• Involve with Scheduling and Distributing reports through Schedule Management in Cognos Connection and Burst reports to different user groups.

Environment: Cognos Report net/ 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Transformer), SQL Server, Quality Center, Rational Clear Quest, UNIX.

Confidential

SQL Developer

Responsibilities:

• Promote emphasis on tools and process to facilitate analytics
• Involved in the development of system test plan which included scope, objectives, resources, timelines etc. of the testing effort.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Analyzed the reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application with SharePoint as backend.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application Database Tables, along with checkpoints for testing / verification.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing. Developed user test cases and validated test results during user acceptance testing.

Environment: MS Outlook, SQL Server 2000, Microsoft Visio, MS Office and Windows 2000.