SUMMARY

• Over 7+ years of professional experience in IT industry working on Business Intelligence and Data Warehousing environments.
• Well - rounded experience in designing, developing, implementing & leading Analytics, Business Intelligence & Enterprise Reporting initiatives/Applications using Tableau 10/9/8/2018, Power BI and SSRS
• Proficient in building user-friendly visualizations, using Tableau Desktop, that identify opportunities for tracking KPIs, process improvement, supply chain management, price negotiation, and inventory planning, budgeting & cost savings.
• Extensively worked on Tableau Hierarchies, Filters, Calculated fields, Sets, Groups, and Parameters & LODs.
• Experienced in using Microsoft Power BI desktop and Power BI service for Enterprise reporting.
• Experienced in using JavaScript API, REST API & Tableau Server Client (Python) Library.
• Worked on extracting, cleaning, and using data from MS SQL, Oracle, Amazon AWS Redshift, and other databases and building tableau data sources through joins, blending, unions & custom SQL query.
• Experienced in developing Performance Analytics dashboards, creating indicators, breakdowns, widgets and managing data collection jobs in ServiceNow.
• Experienced in using ServiceNow Data load/collection jobs, SSIS and Tableau Prep.
• Expert in building TEMPeffective Tableau Visualizations, implementing visual best practices & improving teh existing Tableau dashboards in terms of utility and performance.
• Experienced in implementing data management, data governance, and integrity & data security in context of reporting platforms.
• Regularly built impactful Tableau training materials and conducted multiple Tableau trainings.
• Expert in mentoring team members, managing agile teams & projects using Jira & ServiceNow.
• Extensively worked on brainstorming, identifying requirements for data needs, interacting with both technical and non-technical users, working with executive management for presenting ideas & insights.

TECHNICAL SKILLS

BI Tools: Tableau 8/9/10, QlikView, MS Power BI, Data Stage, Ab Initio, Tableau Prep Builder

ETL Tools: SQL server Integration Services (SSIS) 2008/2012/2016 , Tableau Prep Builder.

Programming Languages: SQL, PL/SQL, TSQL

Databases: Oracle 10g,11g,12c, MS Access, MS SQL Server 2008/2012/2016 , DB2, Teradata 7.0/8.1

Tools: TOAD, SQL*Plus, SQL Developer

Operating System: Windows XP/7/10, Windows Server 2008/2012/2016 , MS-DOS, UNIX / LYNUX

Microsoft tools: MS Word, MS Excel, MS Outlook, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

BI Developer

Responsibilities:

• Data Preparation and Created Tableau dashboards using stacked bars, bar graphs, pie charts, Donut charts and trend lines for Risk analysis by using for Risk analysis by using Tableau 2018.
• Developed stored procedures and Functions and used those to Design and Build SSRS reports.
• Created a daily load process to refresh commonly used data into User defined tables to improve performance of SSRS reports.
• Identified performance bottlenecks on Dashboards using Performance recording and tuned some of teh Dashboards for quicker rendering.
• Performed Regression Testing on SHRP reports and Dashboards to identify issues.
• Worked on Documenting teh Shared Platform frequently used Objects and mapping documents for future use on creating reports.
• Worked in an agile environment to release changes in 2-week sprints.
• Requirements gathering and conducting meeting and discussions with Users / Business to brainstorm on open items.
• Worked on production support resolving and providing solutions to Business-Critical issues.
• Modeled data on Integration layer to get Data from SHRP Archer database and load data into Integration staging.

Environment: and Tools: Visual Studio 2017, SSMS 2014, SQL Server 2016, Jira, Tableau 2018.3

Confidential, Malvern, PA

Tableau Lead/Data Engineer

Responsibilities:

• Responsible to develop Dashboards using Tableau 2019.
• CreatedTableauworkbooks and dashboards using stacked bar graphs, scattered plots, geographical maps, Gantt charts with customized features like dual axis maps, overlaid maps, references, drilling down options.
• Rebuilding existing Reports into Tableau Visualizations with user and action filters.
• Involved in creation of target schema for RDS and development of schema extraction process using Python.
• Worked on Attunity Replace tool to transform and load teh data into AWS.
• Worked with Tableau Prep for data cleansing.
• Developed Dashboards indicating trends of Key Performance Indicators, growth, and revenue forecasting for teh top management using Tableau and Power BI.
• Involved in data architecture and design of teh overall transformation program.
• Performed Legacy Data Analysis.
• Responsible to gather requirements for teh Dashboards from Business Users and document for approval.
• Lead teh team and co-ordinate (Onshore -Offshore) with team during development of Dashboards.

Environment: and Tools: Tableau 2019, Tableau Server 2018, Mainframe DB2Oracle, Attunity Replace, Amazon RDS, Power BI Desktop, Tableau Prep Builder, Jupyter 3.5, SSIS, SSRS, SSAS.

Confidential, MI

Tableau Developer

Responsibilities:

• Designed Interactive worksheets and dashboards integrating various reporting components from multiple sources using live and extract connection.
• Used Alteryx 2018 for data cleansing and Easy analyzing purposes.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Created Users, Groups, and Project and assigned various security as per user roles.
• Worked with EDW Development team to implement data strategies, build data flows, and develop conceptual and logical models for transformation.
• Automated ETL loading process by using SAS from different application to SQL server data base.
• Gathered requirements and developed dashboards by using Tableau 10 and Qlick view as per business requirements.
• Gathered Business requirement and create a reporting solution for users to perform analytics and ad-hoc reporting for business applications.

Environment: Tableau 10, Tableau Server, MS SQL Server 2012, SAS, Qlik View Oracle 11g, SSIS, Tableau Reader, Tableau Prep Builder, MS Excel 2016

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Worked with applications like R and python to develop algorithms for cluster analysis.
• Tested dashboards to ensure data was matching as per teh business requirements and if there were any changes in underlying data.
• Published workbooks and dashboards to teh Tableau Server.
• Assisted users in creating and modifying worksheets and data visualization dashboards.
• Primary activities included requirement gathering, development of insightful dashboards, serving as point of contact for Tableau and delivery of solutions.

Environment: TableauServer 10.3,TableauDesktop, Excel 2010, MS Access 2010, R studio, Eclipse, Teradata, CSV Files, JIRA, SharePoint

Confidential, PA

Tableau Developer

Responsibilities:

• Create reports for users in Tableau by working with DBA's and connecting various data sources (MS SQL Server, Oracle, MS Excel, Flat files, CSV).
• Developed reports, dashboards, and SQL queries using Tableau.
• Generated adhoc Tableau reports as per Business and management needs.
• Implement security in reports according to employee groups and roles according to teh requirement and involved in deployment process.
• Responsible for tracking defects and issue raised by teh business users and communicating teh same to developers.
• Analyzed teh business requirements and worked with SME’s.

Environment: TableauDesktop 9,TableauServer 9, MS Office 2010, SQL Server, Oracle, PL/SQL, MS Excel 2010, Salesforce, MS Outlook 2010

Confidential, OH

SQL/SSIS/SSRS Developer

Responsibilities:

• Worked on database objects such as Stored Procedures, Indexes, UDF and triggers.
• Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.
• Generated reports using SSRS which were send to different business users.
• Performed ETL using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2008R2 instances and to load into staging,
• Perform Data analysis and generate balancing reports between Source and Staging.
• Move data from Stating to DW and perform Data analysis and balancing.

Environment: MS SQL SERVER 2008R2, SSIS (ETL Development), SSRS 2008 (Reporting Development), SQL Server Agent, MS Office 2007, TFS, Agile, Jira

Confidential, Bayonne, NJ

SQL server Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation, and extraction.
• Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.
• Designed and optimized indexes, views, stored procedures, and functions using T-SQL
• Maintained teh table performance by following teh tuning tips like Normalization, Creating Indexes etc.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Used agile methodology to achieve Goal by using regular scrums and Sprints.

Environment: MS SQL SERVER 2008, MS Office, Excel 2007, SQL Server Agent, TFS, Agile, Jira

Confidential

SQL server Developer

Responsibilities:

• Developed various T-SQL stored procedures and user defined functions.
• Designed and optimized queries and stored procs using indexes and temp tables.
• Used agile methodology to achieve Goal by using regular scrums and Sprints.

Environment: MS SQL SERVER 2008, MS Office, Excel 2007, SQL Server Agent, TFS, Agile, Jira