SUMMARY

• 8 plus years of strong experience in Data Warehousing and Business Intelligence technologies with strong experience of data visualization using Tableau and experience in delivering key technologies in data design and ETL.
• Dynamic and motivated professional with a master's degree in Information Management
• Extensive experience in Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 6, Tableau 7, Tableau 8, 9.X and Tableau 10
• Performed analysis of reference data, data sets and asset classes to bring the data into the central repository
• Very good experience on using Tableau functionalities for creating different Reports, Interactive Dashboards with page and Dashboard Prompts.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Defined, created and managed the business specifications, technical specifications, and other project documentation for applications development.
• Created & Managed tables in Azure Databricks using SQL.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
• Worked on motion chart, Bubble chart, and Drill Down analysis using Tableau Desktop.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Created SSRS reports such as drilldown, drill through, sub reports, tabular reports, chart reports, matrix report and document map.
• Highly skilled in working on complex projects that follow traditional and/or agile software development life cycle methodology in teams of 10 - 60 people.

TECHNICAL SKILLS

Analytical Tools: Oracle, MySQL, MS Excel, MS Office Suite, Tableau Desktop/ Server 10.310.1/9.3/9.1/9.0/8.0, Tableau reader, Alteryx, PowerBI.

Databases: Microsoft SQL Server 2016/2012/2008, Postgre SQL, DB2, Teradata, Postgres Sql, SAS MS Access 2003, Oracle11g/10g/9i/8i, Netezza, Snow Flake, Google Cloud Platfrom.

Methodologies: Waterfall, SCRUM and Agile, Complete Software Development Life Cycle, Iterative.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

BI Developer (SQL/ Tableau)

Responsibilities:

• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Tableau Desktop, Tableau server / Administrator, Netezza, Microsoft Excel, MS Access,
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Creating dataflow diagram and documenting the whole data movement process.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Custom Hierarchies to meet Business requirement inTableau.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
• Created process documents using Confluance.

Environment: Environment: Tableau Desktop, Tableau server, Netezza, Microsoft Excel,MS SQL SERVER, Windows 2003/ XP, Confluence, Snow Flake.

Confidential, Mulberry, FL

Business Intelligence Developer.

Responsibilities:

• Worked on Sales and Service, Advertising, Social, Website, Leads, Website Metrics to create the visualization dashboards for the Stake holders.
• Created Rich Graphicvisualization/dashboards to enable a fast read on sales and key business drivers and to direct attention to key area.
• Designed high-level view of the current state of dealer operation, leads, and website activity usingTableau.
• Responsible for writing complete requirement document document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Developed SQL Server Impersonation for impersonation Requirements, How Impersontion Works,
• Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
• Drew upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Published Dashboards onto TableauServer and from there consumers would choose viewing medium (laptop, pc, iPad).
• Microsoft office MS SQL SERVER 2008, SSIS, SSAS, SSRS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access.
• Created numerous functional T-SQL triggers on tables for testing.
• Administered and provided production support for Enterprise wideTableauapplication consisting of multiple key functional business domains.
• UsedTableauURL Actions to navigate from the main Dashboard to detail Reports.
• Created Advanced Charts usingTableauDesktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company.
• Converted metric insight reports to tableau reorts.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports
• Fixed the bugs caused after migration in dashboards.
• Used life cycle manager to promote the jobs from DEV to QA.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.

Environment: Tableau Desktop 9.x, 10.x, 11.x, T-SQL, SQL Server,SSIS,SSRS, MS Access, MS Excel, Alteryx.

Confidential, Eden Prairie, MN

SQL MSBI Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports onserver.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created several reports using SSRS and MDS like parameterized report, drill through reports, linked and sub reports
• Actively participated and interacted with project manager and other team members to process the complex business logic and requirements of the project.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by usingSQLProfiler andSQLAnalyzer.

Environment: MS SQL Server 2012/2008R2, Agile, C#.NET, T SQL, SQL Profiler, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS Excel, Windows 8.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation
• Designed the ETL process based on the schemas (star schema) for extraction and transformation of data from the source database and loading on to the target database
• Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting
• Designed ETL strategies using Visio showing Data Flow to peer developers and Lead
• Implemented complex business rules using multiple transformations like Conditional Split, Look up Transform, Derived Column, and Union All. Also, handled errors efficiently
• Scheduled the SSIS packages to run as jobs on periodic basis according to the requirement using SQL Server Agent
• Configured SSIS packages to move the same between different Environments and for optimal performance.
• Designed error tolerant SSIS packages and logged the execution details
• Work directly with users and business partners to gather reporting requirements and provide solutions
• Prepared documents to show the details of packages and Reports created for future reference
• Prepared the reports to show ineligible loans, total loans securitized etc. on day-to-day as well as weekly/monthly purposes using SSRS 2008 and scheduled them
• Implemented the core business process using T-SQL, Stored Procedures and Functions
• Developed code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2005/ 2008

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), T-SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server