SUMMARY

• 8+ years of extensive experience in IT industry which includes extensive Functional and Technical experience in Data Modeling, Data Warehousing, Business Intelligence (BI), Operational Data Store (ODS) and OLAP, ETL tools, product development and Analytics.
• Over 4 years of experience on Tableau 9.x/8.x/7.x product suite ( Desktop, Server, Public, Reader, Mobile ) solving client’s analytical needs.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Expert in documentation of business requirements and system functional specifications, including BRD, FRD, FSD and end to end Traceability Matrix.
• Outstanding experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables in Tableau.
• Proficient in creating Tableau scorecards, Tableau dashboards using advance Tableau functions like Calculated fields, Sets, Groups, Parameters, Actions, LOD, Adhoc Calculations, etc.
• Expertise in Pareto charting, advanced calculations, work with demographic and geographic fields.
• Expertise in designing sophisticated and intelligent dashboards and stories that solve business problems and that include multiple data sources, Tableau best practices in play, complex calculated metrics, user security / data limitation requirements and other complex development needs
• Strong expertise in developing a high performance dashboard with KPI's, Story points and Advanced calculations.
• Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management ( Connections, Data Model, VizQL Model).
• Proficient in developing Entity - Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
• Hands on experience working with modeling tools such as ERwin, Power Designer, ER Studio and Visio.
• Expertise in analysis, design and implementation of data warehousing applications using Tableau, Cognos, Teradata, DataStage, SQL Server, UNIX, DB2, Oracle technologies.
• Outstanding Data analysis skills including Data Profiling, Data Mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Experience in Tableau Administration for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Outstanding knowledge in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILLS

Reporting Tools: Tableau (Desktop/Server/Mobile/Public), SSRS, Power BI, Cognos

ETL tools: DataStage, SSIS

Databases: Teradata, Oracle, MS SQL Server, DB2, MS Access, AWS

Database tools: TOAD, Teradata SQL Assistant, DataStudio

Applications: Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio

Languages: SQL, PL/SQL, T-SQL, HTML, XML, VB, JAVA API

Web Tools: MS-Front Page, Dream Weaver

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

Design/Version Control: UML, Rational Rose, SVN, GitHub

Operating Systems: Windows Server 2003/2008, Linux, Unix (AIX, HP-UX), OS 400

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. Tableau Developer /Sr. Data Analyst

Responsibilities:

• Involved in transferring databases from SQL Server, extensively used joins and sub-queries to simplify complex queries involving multiple tables.
• Created logical and physical database design, data structures, primary key, foreign key and implemented large databases.
• Created new and modified multiple database objects like Tables, Views, Functions, and Triggers to meet the requirements.
• Built high performance data integration solutions, including extraction, transformation, and load (ETL) packages and scheduled packages and jobs.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• While using Tableau I designed and created Report templates, Area charts, Data bars, Column charts, Line charts, Bar graphs, Pie charts, Polar charts, range charts, Scatter charts, Shape charts, and Stock charts based on the financial data.
• Created Various kinds of reports using in Tableau v9.1 based on the client’s needs.
• Experienced with connecting multiple data sources in Tableau to implement working reports.
• Widely took an interest in making an interpretation of business needs into Business Intelligence announcing arrangements by guaranteeing the right determination of toolset accessible over the Tableau BI suite.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Expert on creating complex Common Table Expressions, Sub Queries, Joins for multiple kind of reports.
• Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• Investigates problems through to resolution or root cause/raises by pulling Data from multiple Sources and Develop Report.
• Developed Custom Geo-coding for organizational territory alignment requirements.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau Servers.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of BI tools.
• Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.

Environment: Tableau v9.x, MS SQL Server 2012/2014 R2, SQL Server Integration Services (SSIS 2014), AWS RDS, ERwin, Oracle 11g, Share Point, Windows 2010, MS Excel.

Confidential, Fort Worth, TX

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Responsible for creating, supporting, modifying, and maintaining complex-to-moderately complex data warehousing and Business Intelligence applications in support of Sales & Marketing, Confidential Commercial Execution (ACE reporting) for Pharma, Vision Care and Surgical divisions.
• Enhancements of ACE application to support the representatives, regional heads for planning/forecasting and execution of marketing the products by ranking, positioning, category, brand, weighted & un-weighted.
• Successfully migrated Cognos reports into Tableau with high data visualizations.
• Designed and developed Ad-hoc reports with filters, quick filters, context filters, global filters, parameters and calculated fields using Cognos/Tableau.
• Generated tableau dashboards with combination charts for clear understanding with different Data Visualization Techniques like: -Tree Maps, Geo Maps, Stack Bars and Line -Graphs for Showing Trend with Dual-Axis and Data Blending Techniques.
• Worked with various data sources like MS SQL, Oracle, MS Excel, Flat files and CSV.
• Developed multi format views in workbook to visually analyze the data in different aspects (what if analysis).
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Experience using Quick, Context and Global Filters for Generating Tableau Dashboards.
• Generated Tableau reports by using various types of Parameters and Calculated Fields.
• Compared data and analyzed using Data Blending, Groups, Combine Fields, Calculated Fields, and Aggregated Fields, Spotlighting.
• Worked with Sets/Groups to display top products based on their sale.
• Experienced administrative capabilities with project setup (Installing, configuring, managing and controlling) and Project Lifecycle Management & performed the regular upgrades to adopt new features.
• Created Actions in dashboards for interactivity and to compare data against different views.
• Created worksheets with interactive views, trends and drill downs along with user level security.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Utilizing capabilities of Tableau such as Data Extracts, Data Blending, Forecasting, Dashboard Actions and Table Calculations.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Created of Adhoc data model in Tableau by joining multiple data tables and hierarchies using Level of Detail expressions (LODs) and making the environment available for adhoc reporting. This also involves training the business users to build adhoc reports.
• Creating and managing schedules for users, performing maintenance activity for servers

Environment: Tableau (Desktop/Server) 9.2/8.3, Cognos 10.2, SQL Server, Oracle, DB2, ERwin, Toad, Data Studio, JavaScript and HTML, PVCS, JIRA.

Confidential, Atlanta, GA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Worked with large-scale high-volume application design, development and deployment for supply chain, B2B, and B2C operations.
• Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time.
• Building the customized and interactive dashboards using multiple data sources
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in Tableau to integrate different database tables.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developing Standard and Create reports using Tableau Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axes, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Environment: Tableau (Desktop/Server)8.1/8.2, SQL Server 2012, Oracle 11g/12c, Excel,Service Now T-SQL, ERwin, DataStage, SharePoint.

Confidential, Foster City, CA

Tableau Developer /Sr. Data Analyst.

Responsibilities:

• Worked closely with the business users to identify various KPI’s and designed 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 maintained high level overview of the data flows using MS Visio
• Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop.
• 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.
• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• 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 using the drill down, drill across, actions for business steering committee.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, IPhones, and other smart mobile phones.
• Developed Adhoc Calculations, Statistical functions, Trend lines, Forecasting, Actions, Filters (Quick, Global, Context), Parameters, Groups and sets for various analytical reports and dashboards.
• Built complex calculations using advanced functions (LOD, ATTR, DATEDIFF, STR, Ifs, OR, Nested Ifs, NOT, AND, SUMIFs, COUNTIF, LOOKUPs, RUNNING SUM, RANK DENSE, and QUICK TABLE Calculations).
• Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Defined best practices for Tableau report development. Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Extensively done ETL process and extracted the data from different data bases Oracle, MS Access, Flat files, XML.
• Created ad-hoc SQL queries for user reports, executive management reports.
• Successfully administered user, user groups, and scheduled instances for reports in Tableau.
• Preformed Data mining for the identification of unusual data records or data errors that require further investigation.

Environment: Tableau(Desktop/Server), Oracle, SQL Server, SQL, PL/SQL, Control-M, MS Access, GitHub, MS Project, MS Office (Word, excel, PowerPoint).

Confidential, Pittsburgh, PA

Sr. BI Consultant/ Tableau Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Participate in the Business and Specifications requirements gathering sessions and convert it into Design specifications.
• Worked extensively with MS Visio and Rational tools to document requirements
• Analysed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Define, Create, and manage business specifications, technical specifications, and other project documentation for applications development.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and deployed rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance chart visualizations in Tableau like Dual Axis, Box and Whisker Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Used Tableau URL Actions to navigate from the main dashboard to detail reports.
• Developed and published reports and dashboards using Tableau Desktop/server.
• Created Data Extracts (. TDE), published and scheduled data refreshes (Complete/Incremental) of the same on Tableau Server.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked collaboratively with a team of Teradata developers to build ETL process needed for reporting.
• Executed and tested required queries and reports before publishing.

Environment: Tableau (Desktop/Server) 7.x, Teradata, Oracle, SQL Server, Power Designer, MS Visio, SharePoint, Microsoft Office Suite (Word, Excel, Power Point)

Confidential, Alameda, CA

Data Analyst/BI Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• 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.
• Experienced in eliciting, defining, writing, and managing business specifications, technical specifications, and other project documentation for applications development.
• Assess, research, analyse and document sponsor/stakeholder needs.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Actively involved in the design, development and testing phase and conducted detailed Data Modeling for the database to be developed.
• Create both logical and physical design of a database and ran the reports.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Modified applications according to the user’s requirements.
• Designed procedures, functions and packages to implement the system’s business logic using PL/SQL.
• Created workbooks and Dashboards using calculated metrics for different visualization requirements
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Incorporated a regional and national comparative / benchmark metrics to give context to Horizon
• Performance Created extensive custom joins for blending data from several different data sources
• Developed Tableau scorecards / dashboards/ reports using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.
• Creating and developing test strategies, test cases and test plans
• Interacted extensively with offshore development team to make sure that the developed system matches the requirements

Environment: SSRS, Tableau 6.x, Oracle, MS SQL Server, MS Visio, RUP methodology, Rational Rose, Requisite Pro, ClearQuest, MS Office Suite, MS Project.