SUMMARY

• Over 6+ years of experience in Designing, Administration, Analysis and Management in Business Intelligence Data warehousing. 5+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 8.0, 8.2, 9.0, 9.3, 10.2 as a developer and Administrator.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Experience in Informatica (ETL) tools which is widely used in building enterprise data ware house.
• Experienced in Tableau working with different Enterprise Data sources likes SAP HANA, SSAS Cubes, Hadoop HDFS, Oracle Enterprise Servers and the Extracts (auto/incremental)
• Administration, Installation and configuration of a Core Licensed Tableau Server.
• Hands - on experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from ( Tableau 8.0 to 9.0)
• Extensively worked on tabcmd, tabadmin, creating users, sites and projects in tableau.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Hands-on experience on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's.
• Proficient in design and development of various dashboards, reports utilizing 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 end user requirement.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Experience in data extraction, data integration, data modelling and data rendering in Tableau.
• Strong knowledge of database management in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica UNIX, DB2, and SQL Server technologies.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008/ R2/2005, Oracle 11g/10g

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Power Pivot, Power BI, TABLEAU DESKTOP 10.0x, 9.x, 8.x, TABLEAU SERVER, Business Objects 4.0, 4.1 a

ETL Tools: SQL Server Integration Services (SSIS), DTS Import/Export

Data Modelling and Data Design Tools: Erwin 4.0, Visio, Star Schema/Snowflake Schema modelling, FACT & Dimensions tables, Physical & logical data modelling

Other Software: MS Office- 2013, 2010, 2007, Team Foundation Server (TFS) 2012, 2013

Operating Systems: Windows 7 Enterprise/Vista/XP and Unix

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential

Sr. Tableau Developer/ Data Analyst

Responsibilities:

• Conversant in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test, implementation and report.
• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding.
• Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
• Developed various types of charts and graphs like donut charts, funnel charts, bar charts, line graphs, pie charts.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Also, created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Blended data from multiple databases such as MS Excel and Oracle, SQL database by assigning primary key from each database.
• Handled the tasks of building, deploying and maintaining metadata inventories and data support tools. Experienced working on different ticketing systems such as Agile ticketing.
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Use parameters to give users control over certain values.
• Combine data sources by joining multiple tables and using data blending
• Responsible for dashboard design, look and feel and development.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Deployed TFS (Team Foundation Server) for cross-functional team collaboration.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPad, iPhones, and other smart mobile phones.
• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Collaborated with Business Analysts and Data experts to capture analytical requirements
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Experienced MS BI Developer, specializing in designing, development, implementation and maintenance of Database and BI Applications using MS SQL Server 2012/R2/2008/2005 and MS BI Stack (SSIS, SSAS, and SSRS) and Tableau.
• Created Test Cases and documented the Test Results.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.

Environment: Tableau (Desktop/ Server) 9.3 & 10.0, Alteryx, Microsoft Power B.I., Teradata V2R5/R6/R12/R13, Hadoop, AWS, SQL developer, MS SQL Server & TFS, Oracle MySQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2012 R2 server.

Confidential - Fort Lauderdale, FL

Data Analyst

Responsibilities:

• Acted as liaison to understand business needs and to accommodate into client deliverables
• Worked with a team to build models and develop the existing business models
• Documentation and validation of business and reporting processes
• Translate and match the business requirements to meet the technical feasibility
• Close the gaps between the technical and the business teams through behaviour driven development (BDD)
• Requirement analysis and developing Use Cases by conducting client meetings and JAD sessions
• Interacts with internal and external stakeholders to develop solutions to technical and business challenge
• Formulated table schema by considering all required fields from Service Now, Jira and Trouble Call data
• Created tables in Postage SQL and loaded the data
• Established connection between database and Power BI while Power BI User Interface was created
• Tested reports and dashboards for accuracy.
• Collected data from various data points.
• Assessed accuracy of deliverables performing internal reviews
• Provided Support to the team and ensured to create a healthy work environment

Environment: Tableau (Desktop/ Server) 9.3 & 10.0, Microsoft Power B.I., Teradata V2R5/R6/R12/R13, AWS, SQL developer, MS SQL Server & TFS, Oracle MySQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad.

Confidential

Data Analyst

Responsibilities:

• Captured necessities from sponsors to complete computerization of reports
• Aligned provisions to accommodate technical feasibilities
• Created Tableau Dashboards / Reports.
• Acted as bridge amid developers and patrons throughout automation and testing phase
• Conducted investor and client meetings to discuss purposed plans
• Coordinated technical and operational requirements to business objectives
• Developed final requirement analysis documentation for further progression

Environment: SQL, Oracle 10g, MS SQL Server 2008, Windows Server 2012, MS Excel/Access 2007

Confidential

SQL Developer

Responsibilities:

• Worked in Global Markets repository team and created BI solutions to business users.
• Crated Dashboards/Reports for different investment portfolios.
• Involved in creating dashboards by extracting data from different sources (Data Blending)
• Created interactive dashboard and applied filter, highlight and URL actions to the dashboard.
• Responsible for creating calculated fields, LOD Calculations, bins, sets, geo coding and hierarchies.
• Performed type conversion functions when connected to relational data sources.
• Ability to authoring on Tableau server by changing mark types and adding filters.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitored and maintained incremental refreshes for data sources on Tableau server.
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Developed interactive dashboards in Tableau Desktop and published them on to Tableau Server which 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 changes to ensure that the views and dashboards displayed the changed data accurately.
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Reviewed basic SQL queries and altered for better performance in Tableau Desktop.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop/Server 7.0/8.1, Oracle 10g, MS SQL Server 2008, Windows Server 2012, MS Excel/Access 2007

Confidential

SQL Developer

Responsibilities:

• Involved in the System study, analysis and Design for creating a robust MIS Reporting System.
• Involved in initial study, design of Data Warehouse for better Reporting for Inventory and Procurement Systems.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Used SQL*Loader to load flat files data to various tables.
• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS)
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services)
• Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.