SUMMARY

• Over 7 years of experience as SQL Server/Business Intelligence Developer in database designing, modeling and reporting using SQL Server 2012/2008/2005 , SSIS and SSRS.
• Around 4 years of experience in developing Tableau Views, Dashboards, Scorecards, created data extracts for optimized loads, Tuned Server and Dashboard Performances
• Worked on each phase of data warehouse development life cycle - technical design and functional requirement documents, development, production deployment and support.
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Expert in creating various SQL server objects like database, schemas, tables, indexes and indexed views, complex stored procedures, effective functions and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Well experienced in data extraction, transformation and loading (ETL) between homogeneous and heterogeneous systems such as Oracle, DB2, Sybase and MS Access using DTS,BCP,SSIS 2005/2008/2012 and creating complex work flows with different tasks, containers (for loop, for each loop, sequence) and different transformations.
• Experience in developing custom reports and various Tabular Reports, Matrix Reports, Ad hoc Reports, Distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using ERWIN and SQL Server Enterprise manager.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Expert in dashboards and visualizations using Xcelsius2008 and Tableau 7.0/8.0/8.1.

TECHNICAL SKILLS

Languages: C,C++,SQL, T-SQL, VB, Java

Databases and Business Intelligence Tools: MS SQL Server 2012/20, SQL Server Management Studio(SSMS), MS SQL Server Integration Services(SSIS) 2012/20, MS Access, Enterprise Manager, Tableau 8 Server/ Desktop

Web Technologies: XML Web Services, Microsoft Office SharePoint Server (MOSS) 2007

Reporting Tools: SQL Server Reporting services 2012/20, Spotfire,Qlikview Logi XML, Crystal Reports

Web Server Technologies: Data Modeling Tool, ETL, Microsoft Visio, ERWIN, SharePoint

Operating System: Windows 2008, Windows 2000/2003 Server, data Center, Windows 2000/XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Tableau Consultant

Responsibilities:

• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• UsingTableauDesktop created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues withinTableau Server and Reports
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Involved in analysis of Key Performance Indicators (KPI's) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted X-Celsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• 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.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience in creating dashboards using calculations, parameters in Tableau.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed effective and interactive Dashboards using Parameters and Actions.

Environment: Tableau 8.X Server and Desktop, SQL Server 2008, SSIS, SSAS, SSRS, Eclipse, Windows Server/professional, Oracle 12g, C#, VISIO, ERWIN.

Confidential, Knoxville, TN

SQL Server/MSBI/Tableau Developer

Responsibilities:

• Involved in installation of SQL Server 2008 with the latest service packs.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Worked on database capacity planning and space forecasting.
• Migrated Database from SQL Server by using side-by-side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Actively worked on SQL XML and X-path queries.
• Wrote scripts to review object permissions in all databases.
• Involved in Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Created SSIS packages using Active X scripts and with Error Handling.
• Worked on enhancing and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Administered the created Reports by assigning permission to the valid user for executing the reports.
• Created and Maintained Database Maintenance Plans.
• Implemented Database Mirroring between Development and Test Server.
• Involved in Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and deadlocks.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Integrated SQL Server 2008 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
• Reviewed Third Party tools so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.

Environment: MS SQL Server 2005/2008, Tableau 8.0/8.1 server and desktop, SharePoint Portal, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, VSS, SQL Diagnostic Manager, Power Designer.

Confidential, College Station, TX.

Tableau Consultant

Responsibilities:

• Involve in Planning, Defining and Designing data based on business requirements and provide documentation.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks for PwC Analytical Projects and Data Visualization teams
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server
• Created Schedules and Extracted the data intoTableauData Engine.
• Prototyped Visualization of Time Series and Data Transparency in tableau for attendance, payroll, and benefits data Integration
• Optimized Tableau Workbooks and Background Tasks for Targeted Interactions Analytics
• Successfully administered user, user groups, and scheduled instances for reports in Tableau.
• Implemented action filters, parameters, calculated fields and sets for preparing dashboards and worksheets inTableau.
• CreatedTableauscorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Executed and tested required queries and reportsbefore publishing.
• 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.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports usingTableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Defined best practices for Tableau report development.
• Developed dashboards inTableauDesktop and published them on toTableauServer that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Design and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Created users, groups, projects, Data connections, and settings as a tableau administrator.

Environment: Tableau Desktop, Tableau Server, Microsoft Visual Studio, MS SQL Server, SQL Server Management Studio 2010, MS Excel, T-SQL.

Confidential, Montvale, NJ

SQL Server/MSBI/Tableau Developer

Responsibilities:

• Dynamically supporting business users & Customers for given requirements and developed reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers database integrity checks and re-indexing.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.
• Generated various reports with drilldowns, drill through, calculated members and dropdowns.
• Created data sources, connection strings and defined the datasets for generating the report.
• Using various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Built and deployed Report Models using Report Builder 2.0 to facilitate ad-hoc reporting for end users. Working with various Delivery mechanisms of Reports like Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2012/2008/2005 , T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau 7.0, Logi XML, Spotfire, Qlikview, Business Intelligence Development Excel, Visual Source Safe (VSS), Windows XP, VB, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Created and reported applications from MS Excel and MS Access using Crystal Data mining and query development using SQL scripting providing Level I & II Support for the project.
• Developed and maintained custom data driven applications using SQL Server, Reporting and Integration (SSRS, SSIS) Services to track Data transactions such Collections and Banking.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Automated tasks using job schedulers, optimized Transact-SQL code, performed SQL query performance analysis and tuning on a regular basis.
• Developed SSRS reports from back end 2005/2008 SQL Server Database using Stored Procedures, Triggers, Transact SQL, Views and Queries
• Maintain, analyze, troubleshoot, and repair computer systems, hardware and computer peripherals (laptop and desktop).
• Data uploading, retrieval from a server, analyzing, testing and Encryption using Eclipse system. Reinstalls software programs or adjust settings on existing software to fix DVD/CD Manufacture machine malfunctions.
• Developed back end 2005 SQL Server Database using Experience in Stored Procedures, Triggers, Transact SQL, Views and Queries.
• System Administration, DNS/ DHCP, TCP/IP connectivity, and Active Directory i.e User log and password reset.
• Technical and Application support such as, diagnose, troubleshooting and resolve software and hardware problems. Desktop and laptop repair, software imaging/reloading on PC and Mac.
• Configure and connect share printers into network, System security such us virus and malware removal system deployment and upgrading.

Environment: SQL Server 2005/2008, MS Excel, SQL BI Suite (SSIS, SSRS), Windows Server 2008, Oracle 12g, C#.

Confidential

SQL Server Developer

Responsibilities:

• Merged existing databases and to design new data models according to the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Created joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configure SQL Servers 2005 and 2008 on development server for designing and testing.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created complex Stored Procedures, Views, Triggers, Tables and other SQL joins.
• Maintained data integrity by performing validation checks.
• Provided research, design, and creation of a robust system ensuring effective processing of financial information from multiple external locations.

Environment: MSSQL Server 2005, Windows Server 2003/2000, Windows NT, Visual SourceSafe, DTS, MS Access, Enterprise Manager, Analysis services 2000,HP Helpdesk, MS office 2003,VB macros.