SUMMARY

• Senior Tableau/BI developer wif 6 years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence Reporting using Tableau v9.x/8.x/7.x and SQL Server.
• 3+ years of experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and dashboards using Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• Strong knowledge in Agile/ Scrum methodologies.
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards and Tableau suite.
• Experience in developing multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, Dual-axes charts, Geo-Maps, Bubble, Histograms and Heat Maps.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management me.e., Connections, Data Model and VizQL Model.
• Highly skilled inTableauDesktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Expertise in designing and creating various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in the organization.
• Expert intableauserver commands like synchronization, Tabcmd andTableauserver backup activity.
• Experience inTABCMD&TABADMIN, Email alerts, scheduling, data backup, SAML and drivers setup activities.
• Hands-on experience in Trouble Shooting, Performance tuning of reports and resolving issueswif in TableauServer and Reports.
• Experience wif Dashboard &Scorecard Reports for Corporate Financial Forecasting as per user requirements usingXML, HTML, andDHTML.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experiencein designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physicalmodeling.
• Extensive experience in working wif Relational databases such as MS SQL Server 2012/2008R2/2008,Oracle 11g/10g, DB2, Teradata and MS Access.

TECHNICAL SKILLS

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling, TOAD, SQL Developer, SQL Plus

Data Warehousing ETL Tools: Informatica Power Center 8 .X,7.X, Talend 4x/5xDatabases: Oracle 11g/10g/9i, My SQL Server, Teradata

Reporting Tools: Tableau 9x/8x/7x, SAS, OBIEE 10.1.3x/11g, ACTIMIZE

Languages: PL/SQL, SQL, Unix shell scripting, Java, C

Web Tools: HTML,CSS, DHTML, XML, JAVA SCRIPT, FileNet

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Tableau Developer/Admin

Responsibilities:

• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting the day to day developments of the work done.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableauserver.
• Effectively used data blending feature intableau.
• Defined best practices forTableaureport development.
• Executed and tested required queries and reports before publishing.
• Extensive experience usingTableauServer,TableauDesktop,CognosBI Suite.
• Developed multiple page reports wif page-breaks based on the first page of the report inCognos.
• Business Intelligence report creation usingBOBJand dashboard development by creating Data visualizations inTableau8.2.
• Experience on migration toTableauVisualization fromSpotfirevisualization
• Interact wif Database, Informatica Administrators on environmental issues and work on fixing the issues.
• IT Project Management (OracleEBS, BI, Help Desk, Data Center, Network Infrastructure Projects)
• Developingmetrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Mastered the ability to design and deploy rich Graphic visualizations wif Drill Down and Drop down menu option and Parameterized usingTableau.
• Build Analytical Dashboards, Worksheets, Sheets, analytics on top of Tableau's Hadoop Cloudera source data and performed lot of data analysis for coming up wif the right visualizations
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Proficient in TuningT-SQLqueries to improve the database performance and availability
• Working closely wif DBA's for performance problems, fix the problem and make recommendations to technical staff to improve performance.
• Utilized the JavaScript API to create a customized portal for the property management group.
• Implemented Data Representation using Visualization Techniques inTableauusingAlteryx(Graphs, Charts etc.).
• Provided support forTableaudeveloped objects and understand tool administration.
• Worked inTableauenvironment to create dashboards like weekly, monthly, daily reports using tableaudesktop & publish them to server.
• Created test plans and performed the Unit testing, Integration testing and System testing for the ETL jobs
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau8.X.
• Customized the system modifying the XML, JS and CSS files to change the User interface, AJAX functionality and fine-tuning the performance of the system. Used SQL connectors to write complex queries to extract data from oracle
• Developed formatted, complex reusable formula reports and reports wif advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Environment: Tableau8.3/9.X,TableauServer, informatica, DB2, OracleEBS, ETL, Alteryx, D3,Microsoft SQL Server, Teradata, SAML,CSS, T-SQL, GoogleBigQuery Cloudera JavaScript, Microsoft Office, Microsoft Visio, Windows 7, Custom SQL,CRM.

Confidential, Dublin, Ohio

Sr. Tableau Developer

Responsibilities:

• Gathering user requirements, analyzing, designing and efforts estimations
• Building executive, adhoc, and custom dashboards and publishing toTableauserver.
• Testing, Monitoring performances, cleaning unused dashboards
• Created few Reports usingCognos tool's according to the user requirement.
• OverseeTableau/Alteryxon-boarding process, deliver training, consultation and support services.
• Used Autosys to schedule the ETL batch jobs on a daily, weekly and monthly basis
• Creating Sites, Groups, Projects using TABCMD & TABADMIN commands
• Installation and ActivatingtableauPorts using TABCMD
• Analyzed and built data visualization models usingAlteryxandTableau.
• Create and ValidateInsightson key Enterprise Accounts around Product Usage trends, AdoptionMetricsand create dashboards for internal teams.
• Defined New Tax categories, Tax drivers in Vertex Central R5 Application and mapped it to new item categories inOracleEBSInventory module (11.5.10, R12)
• Performing Annual IT DR test procedures in Windows andOracleEBS/ Linux Server Environments to comply wif IT SOX audit procedures and policy.
• Used Informatica to populate the data mart from large flat files and relational databases.
• Conducting kick off meetings, status calls, walk thru sessions and trainings to business users
• Created best practices, publishing checklists and repository backups etc.,
• DevelopedT-SQLqueries, triggers, functions, cursors and stored procedures
• Conducting performance tuning, applying user and data source level securities upon need
• Conducting POC fortableauserver setup for non-existingtableauapplications
• Actively participated wif Architect in decision and moving toClouderafrom Tabular models
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableauas needed
• Executed and tested required queries and reports before publishing.
• Extensively developed SQL queries/views forvisualizationsto overcometableaulimitations & for performance tuning
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8.1 desktop/Server.
• AdministeredSpotfireServers and monitored server performance and troubleshoot server issues
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Experience in creating sets, joins, hierarchies, filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.
• Experience in all the Latest BI Tools Tableau, Qlikview Dashboard Design, and Spotfire.
• Experience in creating various views inTableauby different charts such as maps, bars, lines, cross tab, packet bubbles, scatter plot, heat maps and highlight tables.
• Developed a Windows Application to parse the Folder Tree structure and then recursively traverse through the folders to identify the appropriate docClass properties for filing wifinFileNET
• Extensively involved in developing the java code using HTML, JSP for the front end screen development.

Environment: s:TableauDesktop 8x,TableauServer 8x,CRM,ETL, cloudera, cognos, GoogleBig Query, T-SQL,SSIS, Alteryx, Qlikview, OracleEBS, SQL Server 2008R2,Informatica, MS Excel.

Confidential, Jersey City, NJ

Tableau Admin/developer

Responsibilities:

• Going through Report Specification Documents and Understanding the User requirements.
• Created and used Filters, Quick Filters, Table Calculations and Parameters onTableaureports.
• Created of dashboards for business groups like finance and sales.
• Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters
• Designed and publishing visually rich and intuitiveTableaudashboards for executive decision making.
• Created Sets, Groups and Data Bins as per user requirements.
• Created various views inTableaulike Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based on data content.
• Developed various dashboards, used Context filters, Sets while dealing wif huge volume of data.
• Created and updated server architecture for scheduling tasks.
• Communicating results in an audience appropriate manner using applicablemetrics, visuals, actionableinsights, recommendations and decisions.
• Analyzed and resolved performance and server based issues.
• Worked closely wif Business users. Interacted wif ETL developers, Project Managers
• Prepared backups using Tabadmin and Tabcmd commands.
• Formulated procedures for installation and configuration of Tableau desktop.
• Designed and developed SSIS packages for Tableau dashboards.
• Involved in the development of Informatica mappings between Source system and Warehouse.
• Utilized data blending activities for Tableau functionalities.
• Participated in performance tracking activity by evaluating server tasks.
• Modified data visualization dashboards and developed data connections.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending wif multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.

Environment: TableauServer, Oracle 11i, TableauDesktop 7.0, Informatica, Visualization, ETL,SQLdeveloper, Oracle 10g.

Confidential, Hopkins, MN

SQL BI Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated wif DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gatheird data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Experience wif design and development ofTableauvisualizationsolutions.
• Combinedvisualizationsinto Interactive Dashboards and publish them to the web
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings dat the company will use to analyze performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQL Server 2008, BIDS, SSRS, SSIS, SSAS, Crystal Reports, Windows 7, Erwin.

Confidential

SQL Developer

Responsibilities:

• Interacted wif the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases.
• Involved in Partitioning tables dat have bulk inserts, deletes and updates to improve the performance.
• Extracted data from xml and flat files using SSIS.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along wif checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy dat protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2000/2005/2008 , Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.

Confidential

SQL Developer

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Involved in Installation of SQL Server wif Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005.
• Implementing Load balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration wif BCP Utilities.
• Performed Database consistency checks wif DBCC, Index tuning and monitored SQL Server error logs.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk me/O.

Environment: SQL Server 2000, SQL Server 2005. T-SQL, Windows Server, HTML, VBScript, JavaScript, Access