PROFESSIONAL SUMMARY

• Highly Motivated BI developer using MSBI, Tableau, Power BI and SQL
• Extensive experience in improving the customer experience and reducing the call volume .
• Programming experience in DDL, DML, DCL commands, stored procedure for various business process applications.
• Created Dashboards for Sales, products and customer KPIs using Tableau 9 and 10 versions
• Developed Tableau views and dashboards to show various trends like yearly, quarterly and monthly analysis of the financial performance
• Extensive experience in optimizing stored procedures and queries.
• Implemented Row level, Column level Security and Data masking for Sensitive tables .
• Extensive experience in handling Sales and Product hierarchy management.
• Experience in using Joins and Sub - Queries to simplify complex queries involving multiple tables and established relationships between tables using
• Primary Key & Foreign Key Constraints
• Use of heterogeneous sources to collect data such as SQL Server, MySQL, flat files and excel files
• Created advanced charts, custom visualizations and complex calculated fields for worksheets and dashboards to represent the global and local performance of various products across various regions
• Developed high performance dashboards for what if analysis, score cards and metrics, drill down reports, interconnected charts for better overall view of the status of business
• Setting up user permissions, creating/modifying policies, rules, backups and schedules for data lifecycle and load balancing to ensure optimum performance at all times
• Built Data integration solutions, workflow solutions and ETL (Extract-Transform-Load) solutions for Data warehouse using SSIS
• Responsible for documenting design documents, functional specifications and deployment documents, sharing operational metrics on the project to respective managers
• Working knowledge of Data marts, Operational data source (ODS), OLAP, dimensional data modeling, Star schema modeling, snow flake modeling for Facts and Dimension tables using analysis services

TABLEAU EXPERIENCE:

• Created Dashboards for inventory planning and forecasting, performance measurement
• Use of heterogeneous sources to collect data such as SQL Server, Oracle, Hadoop, Teradata, flat files and excel files
• Creating user filters, for tableau level and row level security to ensure secure access to the dashboard based on the user login using impersonation
• Performing data validation, data blending, use of SQL queries and creating empty extracts to transfer performance load on Tableau servers instead of Tableau desktop
• Use of filters, transformations, calculated fields, LODs, sets, groups and parameters
• Creating performance metrics, score cards, what if analysis, forecasting models based on in built and custom statistical analysis
• Creating custom maps and visualization to give a comprehensive view of the business across various regions and products/services
• Providing drill down functionality to all the maps, charts and other visualizations as well as making them interactive and applying filters across worksheets
• Creating story boards to deliver a complete picture of the status of business and compelling dashboards for actionable insights
• Creating subscriptions and alerts for various levels of user groups for dashboard administration, alerts, and updated views
• Publishing Dashboards on the server, creating packaged workbooks
• Setting up permissions for various levels of user accessing the published Dashboards
• Scheduling updates of the Tableau dashboards on the Tableau server Power BI experience:
• Interactive visual report created for quick digestible report summarizing company performance
• Use of parameters, transformations, custom visual charts
• Scheduling updates of the Power BI dashboards
• Setting up user permissions and data access privilegesn SQL Experience:
• SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, Unique and similar
• T-SQL Queries, sub queries, co-related sub queries, dynamic SQL queries and similar
• SQL Server - Stored procedures, triggers, user defined functions, views and cursors
• Merging data from heterogeneous sources such as SQL server, Oracle, excel, text files and similar

TECHNICAL KNOWLEDGE

RDBMS: Microsoft SQL Server 2012/2008R2/2008/2005, Oracle

Programming: T-SQL, PL/SQL, Dynamic SQL

Databases: MS SQL Server, MS Access, Oracle 10g, Star Schema, Snowflake Schema, OLAP, OLTP

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Data tools

Reporting Tools: SSRS, Tableau, Power BI, Excel

Tools: SQL Server Management Studio, SQL Server Data tools

Operating Systems: Windows 10, Windows 8.1, Windows 7, Windows 2000, Server 2003, Server 2008, Server 2012

Other tools: MS Office, MS Visio, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Tableau- Developer

Responsibilities:

• Build the Tableau dashboards based on the data received from SAS & WMS cubes.
• Gather data from different databases, data warehouses & cubes which we use inside the organization and visualize the data according to the Product Owner’s insights.
• Publish the dashboards and validate the data on weekly bases.
• Receive the updated data from SAS team, WMS and from SAT tool and validate the data and then publish to tableau server.
• Write SQL queries, procedures and triggers to pull the data from the databases and visualize it on tableau.
• Worked of SQL integration tool to pull the information from the database and transform the database according to the PO’s requirements.
• Build the dashboards using SAS tool and compare it with tableau dashboards to check the performance of both tools.
• Used several databases like WMS, SAS, SAT, Q-tools, Cloud9 and many other internal databases and data warehouses for organizations use.
• Used Amazon redshift to connect to tableau and use the data to build the dashboards and perform the analysis and validate the data.
• Also gathered social media data from sources like amazon, best buy, google and few other websites to understand the product quality and estimate the health of the laptops, desktops, Hard Drives, etc.
• Created dashboard on the customer call data and to track the frequency of the calls and do the service count based on the time frames and remove duplications.
• Created a dashboard from WIB to estimate the health of laptops, desktops, hard drives, monitors and all other HP products to give an estimated date on the failure.
• Track the performance life cycle of all HP products and the replacement products and maintain the most updated information of the product.
• Fix data issues and find the root cause by doing reverse engineering.
• Create and modify the database tables and make changes to the procedures and triggers upon requirement.
• Worked on DAAS tool for analysis service and to create dashboards from the results of this tool.

Environment: Tableau Desktop 10.5, Tableau server 10.5, SQL Server 2015, SAS, SAT Visor, DAAS, Amazon Redshift.

Confidential, Jacksonville, FL

BI/Tableau-Developer

Responsibilities:

• Using parameters, filters, actions, sets and grouping, calculated fields to create new metrics for performance analysis
• Generated and shared monthly claim status reports and trend forecasting dashboards on Tableau 10.5
• Creating dashboard for performance review of the sales team and products using multiple data sources
• Created different type of Tableau reports including: histogram, Control charts, bar in bar, Donut charts and Pareto charts
• Creating new tables in SQL Server to accommodate the reporting requirements
• Modifying existing stored procedures in SQL Server to accommodate business changes to take in the new hierarchy and add columns
• Creating ETL packages for the sales team to accommodate new tableau reports
• Setting up row level security through views and using data source filters in tableau when creating compensation estimators for the sales team
• Performing data validation and setting up best practices and procedures for data validation of Tableau reports
• Setting up best practices for data visualization, standardizing format and color schemes, security measures, and data extraction practices
• Standardizing the business process from requirements gathering to report creation in Tableau, which would help establish timelines, and provide effort estimation for each request
• Following agile methodology for the projects, setting up monthly sprints, and daily standups to identify roadblocks and measure progress of the ongoing project
• Published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Always ensured that customers will be completely satisfied with their reporting request.
• Have a good rapport with business users to understand their needs and provide them with solutions
• Published dashboards with appropriate user filters to ensure only authorized users have access to the reports
• Handled the extracts and data transformation at the source level wherever needed
• Creating dashboards using the existing business metrics, charts and visualizations
• Creating drill down reports, interactive graphs and visuals for a comprehensive report
• Maintaining database connections, ensuring smooth transfer of data, troubleshooting data errors such as formatting, data type errors and null values
• Joining tables from different database to create reports to cater to specific departments and their needs
• Responsible for establishing Tableau as major BI tool, replacing the existing BOBJ reports

Environment: Tableau (Desktop, Server), ETL Tools, MS SQL and Oracle

Confidential, CA

BI Developer

Responsibilities:

• Responsible for pushing Tableau as major BI tool, setting up Tableau server in the organization
• Managing user activity permissions when sharing dashboards, limiting visibility to data, assigning roles in Tableau and Power BI dashboards
• Design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Pie-Charts, Heat Maps, Bubble Charts and Geographic Visualization according to the end user requirement.
• Constructed various OLAP cubes and performed data mining on the data with the fact table and the dimension utilizing SSAS.
• Designed and optimized SSAS cubes by creating partitions, aggregations, and defining appropriate storage modes.
• Deployed reports and Power BI dashboards on the reports & scheduled deployments with subscriptions.
• Used Excel sheet, flat files, MS SQL Server 2012, Oracle Server to generate Tableau ad-hoc reports.
• Created different type of Tableau reports including: histogram, Control charts, bar in bar, Donut charts and Pareto charts.
• Created Tableau story boards through Web data connector using XML data, REST APIs and internal web services.
• Shared Power BI dashboards among multiple users in the group.
• Conducted sessions for Tableau & Power users and created the documents for end user support.
• Managed user permissions, subscriptions and alerts on Tableau Server
• Fetched data from Azure SQL environment as source in Power BI environment.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Analyzed frequently executed queries and designed covering indexes to avoid bookmarks, keys, and RID lookups.
• Created Power Map in Power BI and maps in Tableau (heat and polygon report) for reporting purposes
• Maintenance and Scheduling of reports (Tabular reports, matrix reports) in Power BI and Tableau
• Created interactive dashboards in Power BI and Tableau with page level filters, contextual filters, and complex LODs
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Created report snapshots and caches to improve performance, deployment, scheduling of reports.
• Designed system requirement gathering documents based on extensive JRD and JAD sessions as per need.
• Utilized Azure cloud for migrating data from Microsoft Azure cloud platform to on-premises data servers.

Environment: Tableau, Power BI, SQL, ETL Tools (SSIS, SSAS, SSRS), MS SQL 2012, Azure, Rest API’S

Confidential

SQL/ETL Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design documents.
• Extensively utilized T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Implemented views utilizing T-SQL in development and production environment for SQL Server 2008 R2.
• Analyzed existing OLTP to locate and determine dimensions and facts for the OLAP database.
• Incorporated analyzing T/SQL scripts which produce tables and relationships based on defined ER-Diagram.
• Extensive knowledge on SSAS Tabular model.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS
• Adapted to defining referenced relationships and calculated members in SSAS and used MDX/DMX and DAX queries.
• Expertise in designing complex reports like Drill-Down Reports, Confidential Reports and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Involved in analyzing SQL queries to fetch data utilizing stored procedures and CTE to combine datasets for multiple applications in T-SQL.
• Analyzed an ETL architecture for data migration from the OLTP to OLAP utilizing SSIS.
• Analyzed SSIS Packages for ETL process to load and transform data from flat files to the data warehouse.
• Formatted and extended SSRS reports with parameters within reports, multi-value parameters, expressions, and embedded functions.
• Designed and deployed ad-hoc, parameterized, drill down, and drill through reports with standard/data subscriptions.

Environment: SQL Server (2008,2010), ETL Tools (SSIS, SSRS, SSAS), T-SQL, OLTP Databases

Confidential

SQL Developer

Responsibilities:

• Created database objects such as Tables, Procedures, Functions, Indexes and Views utilizing T-SQL.
• Implemented DML scripts to perform modification tasks such as Insert, update and Delete data in database tables.
• Extensively implemented system as well as User-Defined functions to enhance the functionality of T-SQL code.
• Implemented Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created T-SQL scripts for ad hoc requests from Business Analysts and Management.
• Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Actively involved in gathering and analyzing requirements.
• Implemented indexes, constraints and rules on tables for optimization of queries.
• Used SQL Server Agent to create jobs, SQL Mail, Alerts and SSIS Packages schedule.
• Created DTS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat files.

Environment: SQL Server 2008, T-SQL, MS Access, MS Excel, SSIS