PROFESSIONAL EXPERIENCE:

• Over8 yearsof professional IT experience on SQLServeras BI Developer includingTableauwif strong background in Analysis, Design, Development, Testing and Implementation of Business Intelligence Solutions Using Data Warehouse, ETL, SQL Server2012/2008R 2/2008/2005/2002.
• Experience in various industry sectors such asRetail, Health Care domain.
• Extensive experience inTableauDesktop,TableauServerandTableauReader in various versions ofTableau8 and Tableau9.
• Extensive experience onbuilding dashboards using Tableauand inEnterprise Environment.
• Experienced in developing Tableau reports by writing complex SQL queries using views, macros, volatile, global temporary tables.
• Good noledge on SDLC, wif Agile and Scrum Methodology and Version One.
• Mastered teh ability to design and deploy rich Graphic visualizations wif Drill Down and Drop - down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive noledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Experienced in developing visualization reports, dashboards, advanced charts and storyboards using TableauSoftware.
• Demonstrated expertise in designing, developing Business Intelligence solutions using SSIS and SSRS.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like table, matrix, charts, sub reports using cascading parameters, Drill-Through Reports and Parameterized Reports
• Strong Knowledge of Complete SDLC (Software Development Life Cycle), database design, RDBMS, data warehousing, data modeling concepts and software quality management.
• Experience in optimizing teh queries by creating various clustered, Non-Clustered indexes and indexed view.
• Expert in writing Complex SQL Queriesinvolving multiple tables inner and outer joins.
• Brilliant in tuning teh reports that includes modifying, Testing teh required TSQL and MDX queries using DMV's and creating teh necessary environment for Deployment.
• Experienced in T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Views, and Triggers for various applications.
• Brilliant in High Level Design of ETL DTS packages & SSIS packages for integrating data using OLE DB connection from Heterogeneous sources.
• Excellent in developing SSIS packages extracting Data from Oracle Database using OLE DB driver for oracle on windows 64bit and 32bit machines.
• Proficient in performance tuning in SSIS packages by using row transformations.
• Experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Knowledge in query optimization & performance tuning using SQL Server Profiler.
• Good communication and Analytical skills can perform both works independently as a good team player.
• Flexible to adapt new environment wif strong desire and enthusiastic to learn new technologies.

TECHNICAL SKILLS:

Platforms: WindowsServer 2000/2003/2008/2008 R2

Software: MS-Office Access, Excel, PowerPoint, InfoPath; Visual Studio, SSAS, SSRS, DTSSSIS, Power Designer, Business Objects, Adobe Acrobat

Languages: T-SQL, PL/SQL, Visual BasicDatabase: MSSQLServer 2000/2005/2008/ R2/2012, MS Access 2003/2007/2010, Oracle 11g, Teradata

Reporting Tools: Tableau 8, 9.1 & 10.1, Tableau Desktop, SSRS, Power Pivot

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Developer/ Report Lead/Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/ SQL Server for design, development and analysis projects wifinTableauDesktop.
• Involved in entering Low level design using Master Data Server.
• Developed SSRS sub reports, Matrix/ Tabular reports, Drill down reports, Drill thorough reports and Power-Pivot reports.
• Involved in using PL-SQL functions to write complex reporting queries.
• Built all trend chart available in SSRS me.e. Line chart, bar chart, dual axis charts, pie chart, Scatter plot charts, 3D charts.
• Involved in developing T-SQL and store procedures to declare report parameters.
• Created Tableauscorecards, dashboards, Heat maps, Donut charts using show me functionality.
• Created Sankey charts to determine flow of customers in tableau.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using Tableau desktop.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created rich Graphic visualizations wif Drill Down and Drop-down menu option and Parameterized using Tableau.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Developed various dashboards, used context filters, sets while dealing wif huge volume of data.
• Generated dashboard for Finance team, provided security by using user filters.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Building, publishing customized interactive reports and dashboards and report scheduling using Tableau server.
• Building complex dashboards by using data blending, parameters, conditional color formatting, tooltips
• Hands on wif quick/context filters, action filters, parameters and calculated fields.
• Worked wif various data sources like Excel, Flat files, Access Database, MySQL, Oracle tables and Teradata tables.
• Created context filters and used performance actions while handling huge volume of data.
• Developed Tableau dashboards for sales wif forecast and lines.
• Developed Tableau dashboards wif combination charts for clear understanding.
• Created Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Leveraged expertise to deliver reporting solutions across process areas using Tableau.
• Uploaded dashboards from Tableau Desktop to Tableau server for easier maintenance.
• Created dashboard using parameters, sets, groups and calculations.
• Developedmanyparameterized dynamicdashboards, scorecards, wifdrill down and drill through capabilities.
• Handled Tableau admin activities granting access, managing extracts.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report
• Worked in developers’ team and closely wif teh end users while teh system is being under development phase.
• Responsible for developing and maintaining all major datamanagement aspects of teh organization andone of themain points of contact for all data related noledge.
• Worked closely wif all teams wifin teh organization to understand business processes, gather requirements, understand complexities and end goals to come up wif teh best plan of execution.
• Involved in check in and check out of report layouts using TFS.
• Involved in requirements gathering for teh Reports, Troubleshoot Data issues and validate teh data sources.
• Involved in performance tuning of reports.
• Responsible in scheduling Data- refresh for SSRS reports and enabling email configuration for SSRS Reports.
• Deployed report on different environments and on BestBuy Retail and Corporate portals.
• Managed Off shore team for timely delivery of teh Reports.
• Responsible for unit testing & deploying code to production.
• Responsible for maintaining user access to teh Reports & LicensingUsers for access.
• Created a Technical Design Documents for teh projects development.
• Responsible for coordination & communication wif teh offshore team for teh project development effort.
• Actively participated in meetings wif project Manager to meet teh business and system requirements of teh project.

Environment: SQL Server 2012/2008 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio(BIDS),SSIS, SSRS, TSQL, Master Data Services 2013, Team Foundation Server 2012, Tableau Desktop, Tableau 9.

Confidential

MS SQL/BI Developer / Tableau Developer

Responsibilities:

• Designed, Developed, coded, tested and debugged teh documentation of applications
• Analyzed business requirements and build logical and physical data models that describe all teh data and relationships between teh data using Erwin r7
• Created Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers
• Created tables, views, users, logins, indexes (indices), check constraints and business rules using T-SQL and maintained databases
• Migrated Databases from SQL Server 2008 R2 to 2012 and determined teh technical approach of migration Used SSIS Packages to extract transform and load data from multiple input sources like Excel files, Production SQL Servers into SQL Server Staging Database
• Created SSIS package to clean and load a data to data warehouse
• Used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers,and Log Providers etc.
• Involved in using SSIS tools like Import and Export Wizard for developing teh packages.
• Performed data mapping and transferred data from staging tables to data warehouse tables using SSIS transformations.
• Designed and developed teh classes usingC#.Net,XMLfor database connectivity
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join, OLEDB Command, and Row Count
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS
• Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS reports.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Involved in using TFS to check in and check out SSRS reports.
• Fine Tuned Data Warehouses including teh creation of materialized views, bitmap indexes and partitions
• Performed Query optimization & Performance Tuning.
• Optimize queries using SQL profiler and Database engine tuning advisor.
• Used MS Excel, Word, Access, and Power Point to process data, create reports for Tableau adhoc requests.
• Generated Tableau combination charts using Tableau visualization software.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Developed various dashboards, used context filters, sets while dealing wif huge volume of data.
• Generated dashboard for Finance team, provided security by using user filters.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Developed Tableau dashboards wif combination charts for clear understanding.
• Resolvedandclosedthe Production tickets generated due to failure of daily incremental production jobs and provided on call support for Production issues.
• Worked wif QA team to determine if applications fit specification and technical requirements. Tests and evaluates systems, subsystems, and components.
• Responsible for Creating Technical Specification document and Process Flow document

Environment: MS SQL Server 2012/2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), C#.NET, T SQL, SQL *Profiler, XML, Erwin r7, Team Foundation Server (TFS), Windows, Tableau 8.1

Confidential, Louisville, KY

SQL BI Developer

Responsibilities:

• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created Databases, Tables, Views, Indexes.
• Wrote complex stored procedures, queries, triggers.
• Managed index, statistics and optimizing queries by using execution plan.
• Responsible for transferring teh data using SSIS packages.
• Studied teh existing OLTP system(s) and Created facts, dimensions and star schema representation for teh data mart.
• Created cubes and defined teh dimensions.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes
• Involved in teh SSAS storage and partitions, and aggregations, calculation of queries wif MDX, Data Mining Models, and developing reports using MDX and SQL.
• Created Dimensions wif teh cube wizard and also individually and Generated Named calculations and named queries.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), Server Analysis Services (SSAS), Server Reporting Services (SSRS).

Confidential, Minneapolis, MN

SQL BI DEVELOPER

Responsibilities:

• Worked as a developer on database like MS SQL Server 2005.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up wif more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve teh customer details, connection details, payment history by giving teh related parameters.
• Tested successfully all store procedures on SQL 2000 server Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler.
• Participated in teh meetings and checked teh progress of teh project.
• Documented all work so that teh user can easily understand teh flow of teh process.

Environment: MS SQL server 2000, MS Excel, DTS, T-SQL

Confidential

MS SQL DEVELOPER

Responsibilities:

• Defining teh Testing Strategy
• Creation of Standard Guidelines for User Interface Testing
• Creation of Test case writing Formats for GUI, Unit Testing, Functionality Testing, Integration Testing and
• Compatibility Testing Creation of checklist for Load Testing
• Creation of Test Data Sheet Format
• Worked wif teh production support team to resolve teh issues and wif teh implementation teams for successful fixes on Test and Production environments

Environment: Visual Source Safe, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft word