SUMMARY

• Over 8 years of professional IT experience on SQLServeras BI Developer includingTableauwith 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 as Retail, Health Care domain.
• Extensive experience inTableauDesktop,Tableau Server and Tableau Reader in various versions of Tableau 8 and Tableau 9.
• Extensive experience onbuilding dashboards using Tableauand in Enterprise Environment.
• Experienced in developing Tableau reports by writing complex SQL queries using views, macros, volatile, global temporary tables.
• Good knowledge on SDLC, with Agile and Scrum Methodology and Version One.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop - down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive knowledge 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 the 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 the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the 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 with 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, MN

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 withinTableauDesktop.
• 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 i.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 with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Generated Dashboards with 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 with 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 with quick/context filters, action filters, parameters and calculated fields.
• Worked with 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 with forecast and reference lines.
• Developed Tableau dashboards with combination charts for clear understanding.
• Created Dashboards with 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, withdrill 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 the views and dashboards were displaying the changed data accurately.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report
• Worked in developers’ team and closely with the end users while the system is being under development phase.
• Responsible for developing and maintaining all major datamanagement aspects of the organization andone of themain points of contact for all data related knowledge.
• Worked closely with all teams within the organization to understand business processes, gather requirements, understand complexities and end goals to come up with the best plan of execution.
• Involved in check in and check out of report layouts using TFS.
• Involved in requirements gathering for the Reports, Troubleshoot Data issues and validate the 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 Confidential Retail and Corporate portals.
• Managed Off shore team for timely delivery of the Reports.
• Responsible for unit testing & deploying code to production.
• Responsible for maintaining user access to the Reports & LicensingUsers for access.
• Created a Technical Design Documents for the projects development.
• Responsible for coordination & communication with the offshore team for the project development effort.
• Actively participated in meetings with project Manager to meet the business and system requirements of the 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, KY

MS SQL/BI Developer / Tableau Developer

Responsibilities:

• Designed, Developed, coded, tested and debugged the documentation of applications
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the 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 the 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 the packages.
• Performed data mapping and transferred data from staging tables to data warehouse tables using SSIS transformations.
• Designed and developed the 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 the 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 with 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 with 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 with 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 the data using SSIS packages.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created cubes and defined the dimensions.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes
• Involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL.
• Created Dimensions with the 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 with 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 the customer details, connection details, payment history by giving the 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 the meetings and checked the progress of the project.
• Documented all work so that the user can easily understand the flow of the process.

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

Confidential

MS SQL DEVELOPER

Responsibilities:

• Defining the 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 with the production support team to resolve the issues and with the 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