SUMMARY

• Over 8 years of extensive IT Experience as a Data Analyst, Business Systems Analyst in Data Warehousing and Business Intelligence applications in Retail, Banking, Financial and Healthcare industries.
• Extensive experience in working wif Tableau Desktop, Tableau Server, and Tableau Reader in various. Versions of Tableau 10.x/9.x/8.x
• Experience gathering customer requirements, writing test cases and partnering wif developers to ensure full understanding of internal/external customer needs.
• Experience in facilitating Joint Requirement Planning sessions wif Business User Groups, conducting Joint, Application Development sessions wif IT Groups & Conflict Management wif Project team members.
• Data blending, data preparation using Alteryx and SQL for tableau consumption, publishing data sources to Tableau server
• In depth understanding of the As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Developing Extract-Transform-Load process using Informatica, Data Modelling, Informatica Cloud, Informatica Connector, AWS and Amazon Redshift for Financial Reporting and Risk Analytics and Designing Risk Management plans.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based, Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Expertise in web integration of Tableau Reports wif HTML or Asp.Net.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• Outstanding Data analysis skills including Data mapping from source to Confidential database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Proficient Star Schema dimensional modelling, which includes understanding business processes, modelling, dimensions, hierarchies and facts.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
• Liaison wif IT and Process Subject Matter Experts (SMEs) to resolve technical bugs, system enhancements, upgrades and development for all HR Systems
• Working knowledge of performance improvement measures including aggregate tables, Indexes and Explain plan.
• Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Excellent communication and interpersonal skills. Ability to work TEMPeffectively as a team member and individually.

TECHNICAL SKILLS

BI Tools: Tableau 10.x/9.x/8.x, Power BI, Business Objects XI3.1/XIR2, OBIEE 10g, DataStage 8.5/8.1

Languages: SQL, C, C++, UNIX Shell Scripting, ASP.NET

Databases: Teradata v15/13/12, SQL Server 2000/2005, DB2, MS Access, Oracle 9i/11i

Operating Systems: Linux (Red Hat) AS4, Unix, WINDOWS 95/98/2000/NT/XP

Dimensional Modeling: Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables

Application Software: MS Word, MS Excel, MS Access, MS Power Point

Other Tools/utilities: Alteryx, Oracle TOAD; Teradata Utilities: SQL Assistant, TPT, FastLoad, MultiLoad, Tpump, BTEQ; BOBJ Suite: Web Intelligence, Desktop Intelligence, CMC, Infoview; OBIEE Suite: Administration tool, Presentation tool; DataStage Suite: Designer, Director.

PROFESSIONAL EXPERIENCE

Confidential - Bentonville, AR

Sr. Tableau Developer/Data Analyst

Responsibilities:

• Gathering, reviewing and discussing reporting requirements wif subject matter experts and business users tan prepare consumption documents.
• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Performed data refresh on Tableau Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.
• Mastered the ability to design and deploy rich Graphic visualizations wif Drill Down and Dropdown menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, Symbol Maps, Pareto charting, mapping, calculations, demographics and geographic fields according to deliverable specifications using Tableau.
• Understanding of and experience wif real-time analytics, BI platforms and visualization tools such as Tableau and Power BI.
• Converted Various Excel, Tableau and BO Reports to Power BI.
• Created detailed dashboards utilizing Microsoft Power BI desktop to improve analysis and decision making.
• Worked on PowerBI Desktop for Data model preparation and Visuals and real-time reports Hands on experience on Integration of Power BI dashboards wif data feed integration Implemented Row Level Security in PowerBI.
• Created and administered user, user groups, and scheduled instances for reports in Tableau & Power BI Server.
• Worked extensively wif Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboards
• Strong Dashboard design experience and passionate practitioner of TEMPeffective data visualization. Familiarity wif best practices around visualization and design
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets and created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Scheduled extract refresh for weekly and monthly reports and worked on workbook Permissions, Ownerships and User filters and provided production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports wif the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Responsible to work wif Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant, writing custom SQL queries to limit the data sourced into tableau thus improving Tableau performance
• Created universe, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Created Cardinalities, Contexts, Joins, Aliases for loops and checked the Integrity of the Universes.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Assist in determining the root cause and troubleshoot the report and query issues across Dev, Testing and Production environments.
• Ability to write, validate and optimize SQL code from multi database platforms and fine tune the SQL queries from new and existing reports and improve the report performance.
• Involved in performing system to system migration and biar file migration of reports and content using CMC.
• Involved in sprint planning sessions and sizing the user stories in AGILE environment.
• Performed admin tasks such as security implementation at report level, folder level and user and content management across all platforms.

Environment: Tableau 10.x/9.x Desktop, Tableau server, Alteryx, Python, Microsoft Power B.I., Oracle 11, SQL, SQL*Plus, HRIS, MS Access, Teradata 14.01, DB2, Universe Design Tool, Web Intelligence, Dashboards 4.1, Crystal reports, Qlik view, Windows 7/ XP.

Confidential - Minneapolis, MN

Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated wif all project teams. Interacted wif Subject Matter Experts & End Users and gatheird business requirements. Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Worked wif Global Operations, Technology and Data Metrics and Analysis teams to analyze, define and publish firm-wide performance and risk metrics to enable managers to make informed decision
• Worked extensively in creating dashboards usingTableauthat includes tools likeTableauDesktop TableauServer andTableauReader in various versions ofTableau7 and 8.1. Also involved in the administration ofTableauserver like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely wif all team members in implementingTableauBI tool in all IT projects.
• Generated reports using SQL queries inTableau7.x/8.x and published them to users in online thru Tableauserver.
• Involved in generating Daily/Weekly Sales & Finance trending reports usingTableauby identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.
• Took backup of the Tableau server on regular basis by using Tabcmd, Tabadmin commands also developed restoration procedures to restore the server during system failures.
• Created adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau adhoc reports.
• Generated Tableau dashboards wif combination charts. Used custom SQL connections, filters, quick filters, sets, parameters and calculated fields wifin Tableau reports to facilitate automated data visualizations.
• Developed and reviewed custom SQL queries wif use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
• Involved in requirement gathering, reviewing requirements and data sources for design, development, and testing and production rollover of reporting and data visualization projects using Tableau
• Performed super user trainings in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to promote the usage of Tableau.
• Played an important role in coordination wif the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Environment: Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x, Tableau Reader 7.x/8.x, SQL Server 2005/2008/2012 , Designer, BI, Dashboard/ Crystal Reports 2008/2011, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007.

Confidential - Richmond, VA

Tableau Developer/Administrator

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively wif Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and dashboard using KPI's.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Involved in migrating client's reports from excel (static) based solution to an interactive service.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from Tableau 8.0 to 8.1
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created incremental refreshes for data sources on Tableau server.
• Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Coordinated database middleware issues wif DBA's, system performance wif System Architects.
• Involved in license management SLA's wif Tableau support.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tab commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau Desktop 8.x, Tableau server / Administrator, Tableau drive, SQL developer, SQL 2012, Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential

SQL Server/BI Developer

Responsibilities:

• Interacted wif Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Closely worked wif the ETL teams and responsible for ETL process in development, test and production landscapes.
• Interpreted logical and physical data models for Business users to determine common data definitions and established referential integrity of the system using Erwin.
• Worked as Dashboard / Performance Manager for the Net Investment and Interest to analyze the investment return.
• Involved in creation of Universes, Classes, Objects and Hierarchies for multi-dimensional analysis of database using Business Objects XIR2 for technical and sales departments
• Exported universes between repositories for access to a wider audience.
• Involved in joining the tables by creating aliases to resolve the loop.
• Created master detail reports using drill up and drill down functionalities
• Prepared reports using master detail, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersections.
• Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV's, Combined Queries, Free Hand SQL and Semantically dynamic calculations using context method.
• Worked extensively wif @functions including @aggregate aware, select, prompts to overcome database integration issues.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data wif Alerter
• Used SQL against the database to check retrieved data integrity.
• Exported universes to the repository for making resources available to users.
• Actively involved in planning, documentation and administrative tasks.

Environment: Business Objects XIR2(CMC, CCM, CMS), Linux, MS-Access, Java, JavaScript, Web intelligence, Info view, Oracle 10g, MS SQL Server 2000, PL/SQL, Windows 2000/XP Server.

Confidential

SQL Server Developer

Responsibilities:

• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Develop, Test and Production Environments.
• SQL database design, architecture, data modeling using Erwin; Data Warehousing and
• Analysis skills: ETL tools, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Analysis Services (SSAS) -- Creating data sources and data source views (DSVs), named calculations and named queries. Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs), Perspectives, measure group partitions, partition aggregations, data mining models. Deploying and processing
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• 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.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• OLAP design (SSAS 2008R2) for different cloud services and service items. Implemented OLAP cube and connecting using Excel PowerPivot.
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Created incremental data load task using SQL Server Integration services
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server.
• Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: Tableau Desktop, MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, Power PivotWindows Server 2003/2008, DTSHTML, XML, Visual Studio 2005, MS Access, MS Excel 2007.