SUMMARY

• Over 8 years of professional IT experience on SQL Server as BI Developer including Tableau with strong background in Databases and Data warehousing concepts.
• Extensive experience in Tableau Desktop,Tableau Server and Tableau Reader in various versions of Tableau7 and Tableau 8.
• Extensive experience on building dashboards using Tableau.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• 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.
• Involved in Software Development Life Cycle (SDLC) Analysis, Design and Quality Assurance ofData Warehousing.
• Developed a number of SSRS and SSIS solutions for enterprise - wide implementations of decision support systems.
• Knowledge of SQL Server Analysis Services.
• Experience with bulk loading options using Bulk logged and Simple mode recovery model.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and charts.
• Proficient in implementing Complex Stored Procedure, Indexes, Views, Table Variables, Triggers, Nested Queries, Joins, Cursors, and user and system defined functions.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Knowledge of project managementprocesses.
• End-userTraining andSupport.

TECHNICAL SKILLS

Platforms: Windows NT/2000/XP/VISTA/7/8, WindowsServer 2000/2003/2008/2008 R2

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

Languages: T-SQL, PL/SQL, Visual Basic, VBA, XML, HTML

Database: MSSQLServer 2000/2005/2008/ R2/2012, MS Access 2003/2007/2010 Oracle 11g, IBM DB2

Reporting Tools: TOAD, BIDS, Tableau 8, Tableau Desktop

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential, Denver, CO

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/ SQL Server for design, development and analysis projects withinTableauDesktop
• Created Tableauscorecards, dashboards, Heat maps using show me functionality.
• 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.
• Worked with various data sources like Excel, CSV files, Flat files, Access Database, MySQL, Oracle tables.
• Created dashboard using parameters, sets, groups and calculations.
• Developeda number ofparameterized dynamicdashboards, scorecards, withdrill down and drill through capabilities.
• 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 closely with the developers’ team and 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.

Tableau Developer

Confidential, Atlanta, GA

Responsibilities:

• Experience in designing and development ofTableauvisualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Created dual-axis bar chart with multiple measures.
• Created stored procedures, views, and custom SQL queries to import data from SQL server totableau.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Provided automation and effectiveBIsolutions for varioustasksvia a solid combination of tools and techniques in theMicrosoftBIsuite.
• Wrote T-SQL, stored procedures, functions, views, triggers, etc.
• Created and enhanceda number ofreportsusing SSRS in visual studio (BIDS).
• Implemented SQL Reporting Services management security. Setup automated report delivery via emails, setup subscriptions, managed report execution schedules and snapshots.
• Created a number of SSIS packages using advanced tools to pull data from various data sources includingflat files,MS-Access, Excel,SQLServer/Oracle databases, etc.
• Created SQL Agent Jobs, Alerts,to schedule DTS/SSISPackages.
• Worked on initiating regular daily compressed backups and log backups to get point in time recovery of the database using Full recovery model.

BI Developer

Confidential, Atlanta, GA

Responsibilities:

• Liaised with business and functional managersto analyze current business processes, assessed opportunitiesfor redesigning these processes, and gathered business requirements that will supportanynewly designed process.
• Generated DDL todefine database schema.
• UsedSQLServer2008Integration Services to perform extraction ofOLTPdata and to extract data from flat files and excel files.
• Used staging tables to transform data using lookup,views,aggregate transformation, and loaded the result setintoOLAP databases.
• Wrotea number ofDTS packages in MS-SQLServer2000.
• Played a key role in migrating from MS-SQLServer2000 to 2008 and rewroteETLpackages in SSISusing BIDS inSQLServer2008.
• Used SQL Agent to set up and schedulejobs.
• Used SQL Server Reporting Services (SSRS) to design and develop reports per business needs.
• Created tabular, matrix, graphical anddashboardSSRSreports from multiple data sources (relational and multidimensional) usingSQLServer2008 Reporting Services.
• Wrote stored procedures and triggers for varioustasks in MS-SQL Server.
• Performed system testing and data validation.
• Developed MS- Access VBA applications with SQL server as the backend databases.

BI Developer

Confidential, Union, NJ

Responsibilities:

• Developed theFunctional specification documentationfor the modules to be developed.
• Worked withSQL to createTables, Views, and Triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcingdata integrityand business rules.
• Responsible for tuning T-SQL procedures, triggers and other database objects.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Extensive useof T-SQL DDLandDMLcommandsfor various applications.
• Involved in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
• Provided technical guidance and support to end-users by developing documentations required.
• Identified and defined the Datasets for report generation.
• Wrote queries for drill down reports.
• Identified and included report parameters.
• Formatted the reports using Global variables and expressions.

Software Engineer

Confidential

Responsibilities:

• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
• Involved in creating tables, views, indexes, cursors and stored procedures.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Participated in upgrade of SQL server 2000 to SQL Server 2005 on standalone and clustered environments and applied service pack.
• Participated with business analysts in order to gather requirements for design and implementation of database. Performed basic DBA activities like Backup and Restore.
• Identified slow running query and optimization of stored procedures and performed testing on applications for performance, data integrity using SQL Profiler.
• Creating, maintaining the users, roles and granting privileges.
• Involved in writing queries and optimizing the performance of the queries.