PROFESSIONAL SUMMARY:

Professional MS SQL BI and reporting consultant with 7 plus years of extensive IT experience working in MS 2008/R2/2012, Tableau and Azure cloud environment. Hands - on knowledge and expertise in MS BI suite such as (SSIS, SSAS, SSRS, SharePoint and Power BI) with more focus towards reporting layer within industries such as healthcare, insurance, banking and education.

TECHNICAL SKILLS:

• MS-SQL Server 2008, 2008 R2, 2012
• Data Modeling Tools: ER Win, MS Visio
• Data Integrations Tools: BIDS, SSDT
• Source Control: SharePoint, Team Foundation Server (TFS)
• BI Tools: Power BI, Power Pivot, Power View, Performance Point
• Integration Services 2005/2008/2012
• Analysis Services 2005/2008/2012 (OLAP Cubes),
• Reporting Services 2005/2008/2012
• SDLC: Agile, Scrum, Waterfall, and Spiral

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

MS SQL Tableau Developer

Technical Environment: SQL Server 2012, Erwin, TSQL, SSIS, SSAS, SSRS, SSDT, SQL Azure, Tableau, TFS, MDX, DAX, Power BI, SharePoint, PerformancePoint Services

Responsibilities:

• Collaborated with team members for designing the database workflow and created multitude of business requirement documents.
• Maintained referential, domain, and column level integrities with constraints, triggers and rules as demanded by business process.
• Utilized T-SQL structures in constructing user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Wrote MDX scripts for KPIs to get trends, status and created calculated members based on the business requirements in SSAS.
• Designed and implemented a variety of SSRS reports such as parameterized, drilldown, ad-hoc, and sub-reports.
• Optimized SSRS reports utilizing stored procedures, caches, execution log views, expressions, and snapshots.
• Scheduled and delivered on-demand reports for business analysis utilizing subscriptions in SSRS.
• Utilized Tableau web data connector to create powerful data visualizations by securely accessing to real-time report data directly in Tableau
• Created multiple dashboards with filters and parameters for analyses and better visualization utilizing Tableau.
• Created scorecards, stack bars, bar graphs, scattered plots, geographical maps utilizing Tableau desktop.
• Advised and participated in trouble shooting, performance tuning of reports and resolved issues within Tableau server and reports.
• Utilized quick filters and parameters in Tableau desktop to create rich worksheet reports and dashboards laying out the foundation for user pinned stories.
• Published the reports from Tableau Desktop to Tableau Server to be shared across multiple cross functional user base.
• Utilized advanced Tableau reporting items such as Heat Maps, Tree Maps, Visual Maps, Box and Whisker plots including scatter plots to display business user data into better graphical insights.
• Designed multitude of spreadsheets, bar charts, pie charts and filled/symbol map with Tableau Desktop software.

Confidential, Austin, Texas

SQL Tableau Developer

Technical Environment: SQL Server 2012, T-SQL, SSDT, SSIS, SSAS, SSRS, Tableau, Erwin, MDX, SharePoint, Power BI

Responsibilities:

• Developed functional/technical specifications such as business scope document utilizing agile methodology.
• Wrote scripts to create and optimize database objects such as stored procedures, functions, DDL/DML triggers, and indexes.
• Designed OLAP architecture for changing and maintaining the warehouse, optimizing dimensions, hierarchies and adding the aggregations to the cube with SSAS.
• Applied formatting in SSRS reports with features such as grouping, drill-down, parameters and sub reports.
• Scheduled reports execution in SSRS on daily/weekly basis to support the incremental load in OLAP.
• Deployed reports on SharePoint servers for easy access to the users by setting permissions and roles at report server in SharePoint integrated mode.
• Created dashboards with multiple worksheets, linear graphs, and pie charts utilizing Tableau.
• Built dashboards with techniques for guided analytics, interactive dashboard design, and visual best practices utilizing Tableau.
• Created complex calculations in Tableau reports including string manipulation, basic arithmetic calculations, custom aggregations and ratios, logic statements and quick table calculations.
• Compared the historical reports in BIDS SSRS with the new generated report in Tableau for improved functionality.
• Utilized various reporting items such as pie charts, line and bar charts with different shapes and sizes by placing appropriate dimensions and measures onto marks card.
• Involved in developing donut charts and implementing complex features in charts such as creating bar charts in tooltip.
• Designed histogram on data pattern distribution utilizing bins across measures in Tableau Desktop.
• Performed side-by-side comparison between Tableau Server and hosted Tableau Server (Tableau On-line) for best possible outcome scenario.
• Involved in building groups, hierarchies, sets to create detail level summary reports and dashboard utilizing KPI's in Tableau.
• Extracted data from data source and maintained (.tde) tableau data extract file to be published on Tableau server acting as data source.
• Involved in production support to Tableau users and wrote custom SQL to support business requirements.
• Distributed Tableau reports utilizing techniques such as Packaged Workbooks, PDF to different user community.

Confidential, San Jose, California

BI Reports/Tableau Developer

Technical Environment: SQL Server 2008R2, T-SQL, BIDS, SSIS, SSAS, SSRS, Erwin, TFS, SharePoint, Power BI, Tableau.

Responsibilities:

• Collaborated with scrum master and business analyst for writing functional specifications based on business reporting needs.
• Developed and implemented ETL mapping document, normalization and de-normalization of existing tables for accelerated query retrieval.
• Designed and tuned database objects such as tables, procedures, functions, triggers, indexes, and views utilizing T-SQL.
• Designed mappings between sources and operational staging targets utilizing star schema.
• Created the packages to extract data from flat files, excel and oracle and loaded into SQL Server database.
• Designed various ad-hoc queries for customer reports and executive management reports; developed multiple types of reports such as tables, matrix, drill through reports.
• Created interactive reports with SSRS, utilizing the report parameters, query parameters, expressions and filters.
• Utilized features such as interactive sorting, document map, actions in SSRS reports to make it more interactive.
• Generated on-demand and scheduled reports with SSRS for business analyses and managerial decisions.
• Subscribed SSRS reports to users utilizing standard and data-driven subscriptions as per the format requested and needed by the clients.
• Created interactive dashboards utilizing parameters, actions and various data visualizations utilizing tableau desktop.
• Involved in creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters in Tableau.
• Involved in developing Tableau workbooks from multiple data sources using Data Blending.
• Generated Tableau Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data in Tableau.
• Created custom function's date range, time functions, array functions, and conditional formatting functions in Tableau reports.
• Built Tableau dashboards for measures with forecast, trend line and reference lines.
• Published Tableau reports onto Tableau Server to share it across the business users.

Confidential, Los Angeles, California

Microsoft SQL Developer

Responsibilities:

• Created database documentation for table/column dictionaries and related reference materials.
• Created T-SQL script which generate all tables and relationships based on the finalized ER-Diagram.
• Designed stored procedures, views, and user-defined functions to automate data entry by a front-end application.
• Analyzed dimensions and facts included in the data warehouse’s design utilizing star-schema.
• Developed logical/physical models of the DW in ER-win.
• Created tables, views, stored procedures, and functions with SQL Server 2008 according to the functional specifications.
• Created views to implement a user interface and triggers, ensuring consistent and accurate data entries in the database.
• Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports and report stored procedures.
• Incorporated Dynamic SQL for user-customizable queries which are answered by the SQL Server.
• Optimized existing queries to improve performance utilizing profiler and execution plans.
• Supported business-specific relationships and advanced constraints by embedding triggers on tables.
• Implemented multiple Isolation levels with lock mechanisms to prevent deadlocks.
• Created partition functions, schema, and file groups for fact tables in the ROLAP data warehouse.
• Developed weekly backup databases utilizing SQL Server; restored databases in a standby server.

Environment: SQL Server 2008/05, BIDS, SSMS, SSIS, SSAS, SSRS, Erwin, Windows Server, SQL Profiler, DTA, T-SQL.