PROFESSIONAL SUMMARY:

• 6+years of experience in the field of Information Technology. 4 years of experience in Tableau dashboard development and 2 years as a SQL Developer.
• Experience with BI tools Tibco Spotfire, Ab Initio and Microstrategy.
• Experience transforming complex business requirements into rich data visualizations using Tableau.
• Data extraction, creation of metrics, attributes, filters, sets, ranks, parameters, aging bins, reports and dashboards.
• Created Side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications. .
• Worked on data blending and increased the dashboard performance by extracting data
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on different table calculations for different Scorecards.
• Strong experience working with SQL server databases.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• GeneratedTableauDashboard with quick/context/global filters, parameters and calculated fields onTableaureports.
• Hands on experience using query tools like SQL Developer and Teradata SQL Assistant.
• Strong knowledge of Google Analytics, as well as other analytics apps, like Chartbeat, Mixpanel and Crazy Egg
• Familiar with Adobe Site Catalyst(Omniture) or similar web analytics software.
• SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MSSQL Server 2012, 2008 and 2005.
• Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Assist in handoff to support team upon successful project completion.
• Good knowledge in Object Oriented Programming(OOPS) concepts, PHP,HTML.
• Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Process: Development, Support and Maintenance

Reporting Tools: Tableau 9.0,9.3/8.2,8.1/8.0/7.0

Technology: Tableau.

Technical Languages: C, T-SQL.

Databases: MS SQL Server 2005/2008/2012, Oracle, MS Access.

Domains: Health Care,Telecom, Financial, Banking, Retail.

Others: MS Office, Visual Studio.

WORK EXPERIENCE:

Confidential, St. Louis, Mo

Tableau Developer

Responsibilities:

• Developed customized and ad-hoc reports using Templates, Metrics and Filters, Reports.
• Involve with Business users and their Adhoc- Reporting requirements.
• Working on Drill Map Editors, Hierarchy relations. Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
• Involved in gathering Business user requirements,understanding Business Flow thru Analysis, Design and Development and coordinating with team.
• Developed Medical Director Reports.

Environment: Tableau Desktop 10.1,Tableau Server, Teradata as backend Database with SQL Assistance 14.10 version

Confidential, Minnetonka, MN

Tableau Data Analyst/Developer

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Strong verbal and written communication skills, ability to work effectively with user departments.

Environment: Tableau 9.3, Tableau Server, MapR Hadoop Hive, Hive Database, Microsoft Office, Windows 7.

Confidential, Mounds View, MN

Tableau Data Analyst/Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• 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 action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Involved in creating dashboards and reports. Created report schedules on Tableau server.
• Creating New Schedule's and checking the task's daily on the server.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Created Business requirement documents and plans for creating dashboards.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Created functional & technical documentation related to Business Intelligence (BI) solutions.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Deep experience with the design and development of Tableau visualization solutions
• Provided 24/7 production support for Tableau users.

Environment: Tableau Desktop 9.2/9.1/9.0, Amazon Virtual Private Cloud (VPC) networks, Amazon Elastic Compute Cloud (EC2) Instances

Confidential, Hoboken, NJ

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked closely with 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.
• 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) for various analytical reports and dashboards.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across theTableauBI suite
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: Tableau Desktop 8.2/8.1/ 8.0 SQL Server 2008/2012, Info view, Windows 2008 Server.

Confidential

SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Worked with internal and external clients for import and normalization of third-party data.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Monitored and provided front-line support of daily processes.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Provide technical support and guidance to staff and clients.
• Generate reports and spreadsheets detailing database changes and performance.

Confidential

Jr.SQL Developer

Responsibilities:

• Create Entity Relationship (ER) Diagrams to the proposed database
• Create database objects such as tables, views, stored procedures, Triggers etc.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Expert Experience in Normalization, De-normalization.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.