EXPERIENCE SUMMARY:

• Results driven professional with 11+ years of full - lifecycle software development projects. Able to quickly understand the goals of the business and break complex issues into manageable components. Broad experience in developing IT Solutions for business requirements, functional / technical specifications and Code Components.
• Over 11+ years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server, Data Analyst and efficient in connecting various data sources.
• 6+ years of extensive data analyst, Tableau Experience in Enterprise Environment, in Tableau 10.3/10.2/10.1/ 9. x/8.x/7.x as a Developer and Admin.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 10 desktop/Server.
• Developed Tableau Data Extracts from the above mentioned data sources using Pentaho Data Integration ETL tool.
• Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration. Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.)
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Design.
• Experience in deployment of Business Objects and Web Intelligence from various Sources oracle, Teradata, Ms Sql Server.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and sequel server reporting services(SSRS).
• Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility, SQL, Cloudera Hadoop and Hive, Apache SOLR, Map Reduce, Amazon Redshift.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Hands-on experience in Git and CVS for version controlling and project management.
• Used Chrome Developer tool and other testing tool to do the debug.
• Experience in conducting performance testing on applications using HP Load Runner and automated functional testing using SOAP UI and automated UI Testing using Karma.
• Strong knowledge in using Object Oriented Programming concepts in JavaScript.

SOFT SKILLS:

• Self-Motivated, Ambitious
• Quick Learner
• Team Player
• Critical Observer
• Excellent communication skills

SKILLS INVENTORY:

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2

BI Tools: Tableau Desktop 10.x, Tableau Server, Tableau online, Tableau Public, Tableau Reader, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services(SSIS), Alteryx 11

Python Libraries: Python, Spark, Scala, Panda, Numpy, Scipy, Pydoop, PySpark

Databases: SQL server, Oracle 8i,9i,10g, Teradata, SAP Hana, Redshift, Hadoop

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: Python, PySpark, MS-SQL, MySQL, hive, HTML5, CS3, JavaScript and XML

Web Servers: Apache web server, Microsoft IIS 4.0, Jboss 6.4

OS: Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools: Microsoft Project, Microsoft Office, Microsoft Excel

RELATED EXPERIENCE:

Confidential, Chicago, IL

Sr. Tableau Developer/Admin

Responsibilities:

• Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.
• As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Extensively used Tab admin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Experienced in developing Web Services with Python programming language.
• Solving P1 issues for the users in the production.
• Creating users, groups, projects, Data connections, settings as tableau administrator.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Experience in administration activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Server.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Analytic support for the company’s marketing campaigns; by predicting areas of promotion.
• Identify areas of opportunity to improve ROI of marketing activities by analyzing customer behavior.
• Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Implemented workbooks to display Year to Date, Month to Date, Quarter to Date analysis for Operational expenses for IT leaders based on Accounts, and generated bullet graphs.
• Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed PL/SQL triggers on master tables for automatic creation of primary key values.
• Scheduled 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.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Mapplet, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh.

Environment: Tableau Desktop 10.5/10.3, Tableau Server 9.3, MS Office Suite, SQL Server, PL/SQL, Informatica, Teradata, MS Excel.

Confidential

Tableau Developer

Responsibilities:

• Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.
• Interacted with Business/Application Users(CIO/VP's) and Business Analysts to gather Reporting Requirements, subsequently translate it into Functional specifications for Tableau Dashboards Development.
• Designed and Developed Reports/Dashboards like Service scorecard, Revenue Dashboard, Customer satisfaction, Order Management, Retail scorecard, Traffic Dashboard, Event log Dashboard, Inventory Management, TOP 6 Metrics, CEO Daily, and prepared user stories to create compelling Dashboards(Visualizations)to deliver actionable insights.
• Created customized Dashboards using various chart types like Bar, Pie, Tree maps, Heat maps and line charts in Tableau
• Worked extensively with Tableau Advance analysis of Actions, Calculations, Parameters, Maps, Trend Lines, forecast, sets, groups, Background images, bins and table calculations to develop Dashboards.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Developed Tableau Dashboards/Story's from multiple data sources using Data Blending.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Administrated Tableau Online Activities like Users/Groups/Site Creation and setting up access levels for each Dashboard.
• Published reports to Tableau online and made them available to Appropriate Business Group as per the access levels.
• Scheduled Dashboards using Tableau Bridge and made them available to users like Hourly, Daily, weekly, Monthly.
• Performed GAP Analysis and resolved the functional logic issues in BRD's with the help of Business Users.
• Prepared documents like BRD's and Test cases (Unit/SIT/UAT).
• Interacted with Business users for controlled validation and push the report Production and user .
• Conducted Load and Performance Testing using Tab Jolt and resolved performance related issues on affected Tableau Reports.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Wrote Custom SQL scripts for creating aggregate tables and generating views.
• Worked on understanding of relational database structures, theories, principles and practices.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Involved to create Documentation for debugging report for Tableau.
• Developing various dashboards in that would identify cost savings and highlight the errors in the insurance claim.
• Developed Dashboards using Tableau Desktop and made them available to users on Mobile/I pad.

Environment: Agile, Tableau Desktop/Server 10.3/10.2/9.3/ , 9.2/9.1/,9.0/,8.0, Teradata SQL Assistant, Teradata Administrator/ Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), HTML 5, Angular JS, Angular 2/1.5, ReactJs, Redux, Node JS, JavaScript, Backbone JS, CSS3, ECMAScript, Qlik view, Visual studio, Bootstrap, JSON, Grunt, AJAX, GitHub, firebug, Notepad+.

Confidential

Data Analyst/Tableau

Responsibilities:

• Performed code-decode ( data) analysis for the utilization in other projects. Modified database with new records.
• Created DDL scripts to create database or make modifications to it and reviewed with the Dev team and DBA.
• Implemented and maintaining DR strategy for BCP-DRP (Business Continuity Plan - Disaster Recovery Plan).
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimized and updated logical and physical data models to support new and existing projects.
• Designed XML layouts and data movement strategies in compliant to ACORD standards.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Maintained conceptual, logical, and physical data models along with corresponding metadata.
• Created Mappings for Type2 and slowly changing dimensions for updating and inserting of records and in turn maintaining history.
• Worked with ER/Studio to create business glossaries with consistent terms and to definitions to ensure that data models and databases are aligned to an organizational usage.
• Excellent understanding of an Approach to MDM to creating a data dictionary, Using Informatica or other tools to do mapping from sources to the Target MDM Data Model.
• Worked on Master Data Management (MDM) for maintaining the customer information and for the ETL rules to be applied.
• Maintained high-level data architecture documentation, which illustrates the source and destination of data to and /or from approved data sources.
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Developed Source to Target Data Mapping, Data Profiling, Transformation and Cleansing rules for OLTP and OLAP.
• Recommended opportunities for reuse of data models in new environments.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Evaluated data models and physical databases for variances and discrepancies.
• Involved in logical and physical database designs and data mappings between cross functional application and used SQL queries to filter data.
• Performed Data Analysis for building the reports and building Enterprise Data warehouse(EDW).
• Defined timelines for project delivery and provided the status update to the client team on a regular basis.
• Created entity/process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Responsible in integrated the work tasks with relevant teams for smooth transition from testing to implementation phase.

Environment: Erwin 7.2, ER/Studio, SQL Server 2008, DB2, Microsoft Access, SQL Server 2000, MS PowerPoint, MS Access, Lotus Notes, Microsoft Excel

Confidential

SQL Developer

Responsibilities:

• Designed ETL processes for extracting, transforming and loading of OLTP data into a central data warehouse.
• Integrated new systems with existing data warehouse structure and refined system performance and functionality.
• Performed physical and logical modeling and Created SSIS packages to migrate data from heterogeneous sources such as MS Excel, Flat Files, and CSV files and then transform and load into the data mart.
• Responsible for enhancement of database performance using database performance and tuning optimization tools and techniques
• Responsible for mentoring team members, helping with assignments, providing guidance and technical oversight, and making key decisions on the technical design
• Implemented replication in SQL Server for syncing up data across servers
• Optimized the performance of TSQL queries, established joins and created clustered/non-clustered indexes wherever necessary.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Used BCP utility inside SSIS packages to import and export bulk data across servers
• Utilized change data capture for data integration across various environments
• Created the Shell Scripts to automate the execution of the SQL subprograms and to move the data to store in historical/archive folders.
• Analyzing the gaps between the old source system and new source system and estimate the time frame to complete the gaps.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS). Created calculated measures, dimension members using MDX, named calculations using SSAS for generation of cube
• Created a number of cubes, dimensions using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS and created new and converted several Crystal reports into detailed SSRS reports.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers
• Developed Dashboards using performance point dashboard designer, which is a part of performance point services in Microsoft SharePoint server 2013.

Environment: MS SQL Server Business Intelligence Development Studio 2016/2014/2008/2008 R2, SSIS, SSAS, SSRS, XML, Oracle, MS Visual Studio, SQL Server Management Studio, SharePoint 2013, ASP.NET, T-SQL, IBM DB2, Data Mining, Power Bi

Confidential

SQL Developer

Responsibilities:

• Gathered requirements from the client and identifying key features for designing product site.
• Managing of database objects like Tables, views, indexes.
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005.
• Implementing Load Balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O

Environment: SQL Server 2000, SQL Server 2005. T-SQL, Windows Server, HTML, VBScript, JavaScript, Access

Confidential

SQL Developer

Responsibilities:

• Used Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• Created SQL Server (T- SQL) Objects like Databases, Tables, Stored Procedures, Normalizations, Triggers, Joins, Cursors, Views, Functions, Data Types, Indexes.
• Analyzed and designed software and database solutions. Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS).
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Maintains client confidence and protects operations by keeping information confidential according to HIPAA standards.
• Worked on other packages of the SQL server 2012 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Modified SSAS Tabular models with dimensions and fact tables from data sources.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Developing Warehouse reporting capabilities for ACO, ACQA, PQRS, HEDIS and other industry required reporting.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2012 Server to achieve the efficiency of SQL Server Analysis(SSAS).
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
• Created and managed relationships between tables in Power BI to calculate accurate results.
• Transformed and combined the data using Query Editor in the Power BI.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Worked on Power View and Power Map to visualize reports.
• Created reports with Analysis Services Cube as the data source using SQL Server 2012 Reporting Services.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams.

Environment: MS SQL Server 2012, SQL Server Analytical Services, SQL Server Reporting Services 2012, SQL Server Integration Services, Windows 8/8.1, MS Office 2007/2010, T- SQL.