PROFESSIONAL SUMMARY:

*+ years of experience in Information Technology field with Extensive Business Intelligence, Analysis and Database Skills in Manufacturing, Finance, E-Commerce and Market Research business domains.

Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation and maintenance.

Experience in the Development, Implementation of Database/Data Warehousing, BI Analytics and Dashboards applications using Data Extraction, Data Transformation, Data Loading, data visualization and reporting tools.

Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables in Tableau.

Worked on complex KPI scorecards, heat maps, treemaps, circle views, bar charts, lines, pie charts, area charts, box and whisker, Gantts, bubbles and highlight tables. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.

Worked on data blending and increased the dashboard performance by extracting data.

Worked on different table calculations for different Scorecards.

Expertise in Performance Tuning Tableau reports and published dashboards on Tableau public.

Expertise in Tableau server installation, Configuration and enforcing security in Tableau.

Worked closely with Tableau support team during tableau server upgrades to 8.1.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), OLAP SAP BW, MS Excel, MS Access, Teradata and DB2.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.

Extensive data modelling experience in Alteryx.

Well versed in query optimization for performance tuning and monitoring of processes.

Broad experience in resolving universe issues like Loops and Traps using Alias and context.

Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

Academic knowledge on Power BI and Looker, a stunning data exploration tool that can also utilize D3 JS.

TECHNICAL SKILLS:

Business Intelligence tools

Tableau 9.3,9.2,9.1, 8.x,7.x, SSAS, SSIS, SSRS,

Database

SQL Server2005/2008/2008R2, Oracle 11g/10g/9i, Teradata, MySQL, DB2.

Data Modeling

Erwin, PowerDesigner, Alteryx

Operating Systems

Windows XP, Windows NT / 2000, Windows 7, Unix.

PROFESSIONAL EXPERIENCE:

Client name: Wells Forgo, Charlotte, NC Aug 2014 – Current

Role: Sr. Tableau Developer / Analyst

In the Credit Card division of Wells forgo, a universal bank and is organized within two business clusters: Corporate Investment Banking Management and Retail and Business Banking. The goal of the project is to evaluate credit card usage and trends. My responsibility was to design and develop Tableau Interactive dashboards, configure Server & also Creating Sites, Users, Group and Projects.

Responsibilities:-

Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."

Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine.

Created Users, Groups and projects in Tableau environment.

Created and managed schedules for users.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.

Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.

Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.

Implemented various data connections from data source to Tableau Server for report and dashboard development.

Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.

Created guided navigation links for Interactive dashboards in Tableau.

Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Created Bullet graphs to determine average wages and workers compensation by using measures and dimensions data from Oracle, SQL Server, MS Excel, and other ODBC Databases like SAS.

Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.

Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

Design interactive dashboards in Tableau Desktop and published them to Tableau Server.

Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.

Created and updated stored procedures and functions to meet the requirements and changes specified by the users.

Environments: Tableau Server v9/v8, Tableau Desktop v9/v8, Windows Server Standard R2, Oracle 11i, Excel, JAVA, J2EE, SQL Server management studio, T-SQL,ERWIN 7.2, .NET.

Client name: Blue Cross Blue Shield, FL Mar 2013 – July 2014

Role: Tableau Developer/Analyst

Blue Cross Blue Shield is the leader in personal insurance, providing insurance to each and every one in US. My project revolved around creating dashboards to assist the medical directors to identify the providers that would provide cost effective solutions to a conditions. The analysis of this dashboard is put on the main webpage of the BCBS for a customer of BCBS to access and go to the provider of choice.

Responsibilities:-

Involved in creating dashboards and reports in Tableau 6.1/7.

Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Created drill down and drill up in worksheets.

Created report schedules on Tableau server.

Worked as a Reporting admin, in charge of the report development and maintenance

Worked on the concentration and risk management data and dealt with lot of financial data. Used Tableau to great effect in developing the visualizations in tableau from OBIEE.

Built and maintained many dashboards.

Training classes to the employees on this new version of Tableau.

Creating dataflow diagram and documenting the whole data movement process.

Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.

Environments: Tableau Server 6.1, Tableau Desktop 6.1/7, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 11i, Excel, JAVA, J2EE, TSQL

Client name: Ingram Micro, Carol Stream, IL Jan 2012 – Feb 2013

Role: Tableau Developer

Ingram Micro Inc. is the world’s largest technology distributor and a leading technology sales, marketing and logistics company. As a vital link in the technology value chain, Ingram Micro creates sales and profitability opportunities for vendors and resellers through unique marketing programs, outsourced logistics services, technical support, financial services and product aggregation and distribution.

Responsibilities:-

Understanding the functional and technical specification.

Deep experience with the design and development of Tableau visualization solutions.

Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.

Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

Regular involving in calls with customer and discussing about status and new requirements of the project.

Preparing Dashboards using calculations, parameters in Tableau.

Used TrendLines, Parameters, Aggregate Functions, Filters.

Environments: Tableau Server 6.1, Tableau Desktop 6.1/7, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 10i, Excel, JAVA, J2EE, TSQL

Client name: Fidelity Investments Inc., MA Nov 2010 – Dec 2011 Role: SSRS/SSAS/SSIS BI developer

Fidelity Investments manages a large family of mutual funds, provides fund distribution and investment advice services, as well as providing discount brokerage services, retirement services, wealth management, securities execution and clearance, insurance and a number of other services.

Responsibilities:

Worked on Migrating reports from SSRS 2005 to SSRS 2008.

Worked extensively with the major functionality of SSRS like Matrix reports, Drill down reports, multi-parameterized reports and drill through reports.

Created Data Source, Data Source View to create a logical view of the data using SQL Server Analysis Services (SSAS) projects.

Created SSIS packages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of scheduled jobs.

Design and developed SSIS packages to extract data from different source files like Excel, Access file, CSV, etc., into SQL server 2008 R2 for further data analysis and reporting.

Developed Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Involved in designing star schema and snowflake schema using facts, dimensions and measures.

Involved in writing complex SQL queries using table joins (inner and outer) and temporary tables.

Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.

Worked closely with client team members in developing and delivering.

Environments: MS SQL Server 2005 SSRS/SSAS/SSIS, MS SQL Server 2008R2 SSRS/SSAS/SSIS, TSQL, windows 2008

Client name: Asian Paints Limited, Mumbai, India Sep 2008 – Oct 2010

Role: Data Analyst/SQL Server BI Developer

Asian Paints Limited, Mumbai India is an Indian chemicals company headquartered in Mumbai, India. It manufactures paints for decorative and industrial use. I was responsible in building and maintaining interface packages build on SSIS to transform periodic transactional feed to DSS system.

Responsibilities:-

Gathering, project analysis & review meetings and progress reporting.

Advised Development team on the development of SSIS packages for various inbound/outbound data, OLAP system as well as large volume Data warehouse.

Built packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.

Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping.

Developed complex solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.

Created derived columns on the fact and dimension tables as per the business requirements.

Created SSRS Report Model Projects in BI studio as well as created, modified and managed various report models with multiple model objects, source fields and expressions.

Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.

Wrote complex T-SQL scripts, stored procedures, functions and triggers.

Worked with other developers to ensure the code interdependencies are met and fully tested via a formal system test plan.

Environment: Windows Server, SQL 2008 Enterprise Edition, SSRS, SSIS, Oracle 9g.

Client name: Lotus Research Marketing Company, Mumbai, India July 2007 – Aug 2008

Role: SQL Developer

Lotus Research is an independent market research company which offers quantitative and qualitative, consumer, business-to-business and primary market research field work in Asian market. I was part of the Business Intelligence team working on SQL development.

Responsibilities:-

Developed SQL code for the application.

Modified the existing database by adding the tables and maintained relationships between the tables.

Used Event Handlers for Exception Handling.

Involved in creating, deploying and configuring reports according to the requirements using SQL Server Reporting Services.

Supported various sectors like Development, testing, Production, Maintenance and Application teams.

Environment: SQL Server 2005, MS Office, Autosys.

EDUCATION:-

Bachelors in Information Technology from University of Mumbai 2003 –2007

Contact this candidate