SUMMARY

• Over 8 years of specialized experience as SQL Developer, Business Intelligence (BI) Developer, and Database Administrator.
• Extensive work experience using Tableau Desktop (3+ years)andCognosto build reports, interactive dashboards, KPI metrics, data visualization models and POC solutions.
• Extensively worked in OLTP, OLAP, Client - Server & Enterprise Data warehouse Environments.
• Expert in Microsoft Business Intelligence Tools technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Experience in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from OLTP to OLAP with the help of SSIS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Up to date with Tableau features and well experienced in using Tableau Desktop for setting up graphic visualization, story telling (latest feature), embedding tableau in sharepoint and Java API, security setup, using marks, pie/crosstab reports, calculations, 12 commonly used graphs, publishing, scheduling etc.
• Experience in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling, Data Marts and OLAP technologies.
• Created and Configured Data Source &Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s and MDX Queries using SQL Server Analysis Services.
• Expert in developing reports using SQL Server Reporting Services and creating various types of reports like Drill Down, Drill Through, Parameterized and Cascading Reports.
• Strong experience inT-SQL for developing complex stored procedures, triggers, tables, user functions, relational database models, SQL joins and query writing.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Involved in the complete Data Warehouse Development Life Cycle. Actively supported business users for change requests.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2012/2008/2005.
• Experience in designing and developing Tableau Reports, Documents, Dashboards and Scorecards per specified requirements and timelines.
• Working knowledge of installation, configuration of Tableau products like Tableau Desktop and Reader.
• Experience in designing interactive Dashboard using various data visualizations using Tableau Desktop and Tableau Server.
• Work Experience through the Diversified Fields of Software Development Life Cycle (SDLC), familiar with Agile Methodologies (Extreme Programming, Scrum), Waterfall Methodologies, Test-Driven Development (TDD) and Design Patterns.
• Experience in Visual Studio 2010/2008/2005 , .NET Framework 4/3.5/3.0/2.0 , C#,WINFORMS, WCF,XAML, ASP.NET, ADO.NET,VB.NET, AJAX, ADO.NET Windows, MVC, Web Services&IIS.
• A well-organized, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, MySQL, MDX, HTML, CSS, XML, C, C++, C#, Visual Basic, Perl, JavaScript, UNIX

Operating Systems: Microsoft Windows 7/Vista/XP/2000/98/95, Linux, Windows Server 2012/2008

Databases: MS SQL Server 2012/2008 R2/2005, Oracle 11g,10g,9i, DB2, Oracle Hyperion, MS Access 2012/2008

ETL Tools: SQL Server Integration Services (SSIS 2012/2008 R2/2005)

Reporting Tools: SQL Server Reporting Services (SSRS 2012/2008 R2/2005), Crystal Reports, Tableau 8.x

OLAP Tools: SQL Server Analysis Services (SSAS 2012/2008 R2/2005)

Tools: /Utilities SQL Server Management Studio, Microsoft SharePoint, SQL Server DTS, ERWIN, PowerBuilder 12, Microsoft Visio, Profiler, SQL Query Analyzer, Visual Studio .NET, Spotlight

Application Packages: MS Office 2013/2010/2007 , Adobe Photoshop, Adobe Dreamweaver

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr Tableau Developer

Responsibilities:

• Act as a Subject Matter Expert in the areas of Business Intelligence and providing automated reporting solutions for executive level users to take decisions for better quality care.
• Use Tableau Desktop tool tobuildadhoc/custom/requirement driven/data sharing reports and dashboards various business and IT needs.
• Work with tableau features such as drillown using actions, story telling, context filtering, quick filter, report formatting for ease of understanding metrics and one stop shop for decision making, conditional formatting, calculated fields, custom SQL, data blending, charts, diagrams, trends graphs, crosstabs, multi-level aggregated views etc.
• Build tableau datasources to give a logical layer of data elements for end users to build reports on the server without the need to have tableau desktop license.
• Practice and implement tableau best practices for creating organizational metrics and indicators. Support all dashboards and troubleshoot performance ineffective reports over time.
• Document and translate stake holder reporting needs to Tableau POC reports for IT project acceptance and A3 approvals. Implemented various data connections from data source toTableauServer 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 and MS Excel.
• 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.
• Daily Production monitoring & support exiting Tableau report extracts.
• Work on Daily and weekly ad-hoc ETL requests. Stage data for reporting via Tableau.

Environment: Tableau 8.3, 8.2/8.1.3, MS SQL Server, InformaticaAnalyst, PowerCenter 9.6/9.5, IDQ and Developer. MS Office tools, Oracle 10, T-SQL, Windows Batch Scripts, MS Management Studio, MS Enterprise Manager, Windows OS & Servers, Report2Web, Filezilla, ERWin for data modeling.

Confidential, Worcester, MA

SQL Server / MSBI Developer / Tableau

Responsibilities:

• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS
• Designed and created SQL Databases, tables, indexes, and views based on user requirements
• Involved in query optimization for faster processing of queries.
• Used various Data Flow Transformations, like Lookup, Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Created the Load packages for loading the CSV files and flat files from DB2 into SQL Server using SSIS 2008R2
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS)
• Created new cubes and modified existing cubes using SSAS to make data available for the decision makers
• Generate various ad hoc reports using MS Reporting services and Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis
• Built the SSRS reports from Different Databases like Oracle Hyperion and SQL Server
• Created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created complex formulas and calculations within Tableauto meet the needs of complex business logic
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Implemented data blending to blend related data from two different data sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Generated insights out of voluminous and complex datasets and built story lines.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Configured Cache settings which improved the performance of the reports and Dashboards
• Experience developing various data connections from data source toTableauDesktop for report and dashboard development
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports
• Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data

Environment: MS SQL Server 2012/2008R2, Business Intelligence Development Studio,PL-SQL, Share Point, Oracle 10g, MS Access, Hyperion, Windows Server 2003, Tableau Desktop 8, Tableau Reader, Tableau Public, Tableau Server 8/7/6/5

Confidential, Philadelphia, PA

Tableau/MSBI Developer

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access)
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Experienced in Error handling and debugging coding issues and troubleshoot production problems.
• Experienced in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• Develop SSIS package for implement Slowly Changing Dimension. Fact Load and Dimension Load. Incremental Load.

Environment: Tableau 7, Tableau 8, SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server, SQL Profiler, Index Tuning Wizard.

Confidential, Omaha, NE

SQL Server BI Developer

Responsibilities:

• Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from various RDBMS and Non-RDBMS systems
• Build efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 and type 2 changes
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement
• Created SSAS OLAP Cubes, where the cubes are used to automate the current manual process of Reports
• Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services
• Developed MDX Queries against SSAS cubes to generate reports
• Created Subscription of Reports in different formats like PDF, excel etc to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring

Environment: MS SQL Server 2008, T-SQL, DTS, Data Profiler, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Management studio, Microsoft SharePoint, Microsoft Visio, XML.

Confidential, CA

ASP.NET/SQL Server Developer/SSIS

Responsibilities:

• Analysis of the specifications provided by the client
• Developed user Controls and dynamically loading it at runtime.
• Implemented role-based authentication using ASP.NET Form based authentication.
• Created Stored Procedures required for role-based authentication.
• Developed web forms using C#.NET and user friendly navigation system for the web application
• Created SQL joins, Sub queries, tracing and performance tuning for better running of queries
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDF’s
• Designed, Managed and Published various reports using SQL Server Reporting Services 2005
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports
• Designed Cascading ( Collapsed ), Printable, interacted reports (drill-down and sorting functionality)
• Created and designed reports based on query parameters and Report parameters
• Created nested Grouping, sorting columns and writing expressions according to the business requirements.
• Created sub reports and pass through parameters from main report to the sub reports
• Worked on Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse using SSIS packages.
• Published migrated data using SSIS(SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Worked on Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages
• Created in setting report parameter properties. Determine whether parameters are single or multi valued, visible at runtime and set the default values in the run time
• Deployed reports in the solution explorer and opened through browser
• Unit Testing and Deployment

Environment: MS SQL Server 2005,SSRS 2005,SSIS 2005,SSAS 2005,Microsoft visual studio 2005, ASP.NET,VB.NET, Business Intelligence Development Studio, Microsoft Office Excel, XML, IIS 6.0, Windows 2003.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in logical and physical database development (using Erwin, Normalization and Dimension modeling).
• Maintaining the database consistency with DBCC at regular intervals.
• Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data.
• Responsible for database backups, database replication and database security
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Export/ Import data from other data sources like flat files using Import/Export of Data Transformation Services (DTS)
• Involved in trouble shooting and tuning of databases for its performance and concurrency using Database Tuning Advisor.
• Wrote stored procedures/T-SQL scripts and indexed tables as per business need.
• Worked on developing Tables, Creating complex stored procedures and user defined Functions.
• Involved in index creation, index removal, index modification, file group modifications and adding scheduled jobs to re-index and update in database.
• Reporting project status, issues and resolutions to the team leader or manager.

Environment: SQL Server 2000/7.0, Enterprise Manager, Windows Server 2003, SQL Profiler, DTS, T-SQL, BCP, MS Excel