SUMMARY

• 7 years of experience in supporting the development of analytics solutions leveraging tools like Tableau Desktop and Tableau Online and experience working with SQL, developing complex SQL queries, and leveraging SQL in Tableau.
• Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 in Development, Test and Production Environments with various business domains.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience leveraging web traffic and consumer analytics tools such as Adobe Analytics, Google Analytics, Mixpanel, etc
• Experience in Design, Development, Integration, Implementation and Maintenance of Business Intelligence with related Database Platforms.
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Knowledge of best practices and principles for data visualization, dashboard and report design, marketing analytics, and data mining.
• Strong development experience with the Microsoft BI Stack - SQL-Server, SSIS, SSRS, SSAS, Power Pivot, Power BI for Office and SharePoint.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Analysing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple tables’ inner and outer joins, stored procedures.

TECHNICAL SKILLS

• Operating Systems: Windows XP, Windows 7/10
• Specialties: Data Visualization, Business Intelligence (BI), Software Management, Data Blending.
• Languages: SQL, PL/SQL, JSON, HTML,CSS, Bootstrap
• BI Tools: Tableau Desktop/Reader/Public/Server, Qlikview, PowerBI
• Data Bases: Oracle 11g/10g, MS SQL Server 2016/2014/2012/2008 /2005/2000, MS Access, Oracle 9i/8i/11g, Teradata, Snowflake
• Document Management: SharePoint
• Modelling Tools: Dimensional Data Modelling, Multi - dimensional modelling, Snowflake/Star Schema
• Others: MS Word, Excel, Visual Studio, Astah, Rational rose, Notepad++

PROFESSIONAL EXPERIENCE

Senior SQL BI/Tableau Developer

Confidential, Plano, TX

Responsibilities:

• Works closely with BI subject matter experts and developers to implement best practices for designing, developing and deploying applications in a multi-tenancy environment.
• Assists with application installations, upgrades, and migrations within virtualized environments
• Researches and assists with scaling new data analytics products within the department including, but not limited to R Studio Server, Tableau, and Microsoft Power BI.
• Supports the development, maintenance and configuration of reports/dashboards within Oracle Business Intelligence Enterprise Edition (OBIEE).
• Creating SSIS packages using proper control and data flow elements improving the performance of the package run time and unit test the developed packages as an ETL developer.
• Work on ETL process using Microsoft SQL Server Integration Services (SSIS) process to provide the data quality, data cleansing, business rule transformations, and data loading, support the data loads and transformations using SSIS for the iterative conversion project.
• Involved in migration from SQL Server 2008R2 to Oracle databases using SSIS on CSS Conversion Project.
• Develops and maintains basic workflows, mappings, and sessions within Informatica Power Centre
• Create necessary documentation for all charts and dashboards using multiple data sources
• Write, interpret, and optimize complex queries working with large sets of data
• Develop and maintain tableau visualizations and reports
• Develop ad-hoc Business Objects Web Intelligence Reports
• Developed Packages to Load data from MS SQL server to Oracle Destinations and in the flow created new SSIS packages according to the requirement for the fields.
• Troubleshooting the issues on the SSIS packages.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Environment: Tableau Desktop 2018.3, Teradata SQL Assistant, Tableau Server, MS Excel, MS SQL Server 2012, SSRS 2012 -MS SQL Server Reporting Services (SSRS), T-SQL, PL-SQL, Oracle SQL Server, SQL Server Integration Services (SSIS).

MS SQL Server BI Developer

Confidential, Richardson, TX

Responsibilities:

• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012,2014
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining, Data modelling and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad)
• Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database

Environment: Tableau Desktop 10.3, Tableau Server 10.3, Teradata SQL, SQL Server Analysis services (SSAS), MS SQL Server Reporting Services (SSRS) T-SQL, SQL Server Integration Services (SSIS), Power BI, SharePoint, Tabular Models, Data Modelling DTS, SQL Profiler, Erwin VB SCRIPT, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET,VB Script ProClarity Analysis, Power Pivot, Erwin, Python, Snowflake.

MS SQL Server BI/ Data warehouse Developer

Confidential, Summit, MO

Responsibilities:

• Develop dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• 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.
• Schedule data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
• Worked with Business Analysts and Business users to understand the user requirements, layout of developed applications
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization.
• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.

Environment: Tableau Desktop v8/v9, Tableau server v8/v9, SQL Server, SSIS, Tabular Data models, Microsoft Business Intelligence Development Studio (BIDS), T-SQL, DTS, OLAP, MS office 2007.