SUMMARY:

• Over 7+ Years of IT experience in ETL, Business Intelligence, Business Architecture, Data Warehousing, and Web based, Client/Server applications in Development, testing and implementation in various domain such as Insurance, Banking and Retail industries.
• Extensive experience in Data Modelling, Data Profiling, Data Integration, Data Migration and Data Mining.
• Experience in SQL Queries, E - R and Dimensional Model, Star/Snow Flake Schema design, Modelling dimensions, hierarchies and facts, Database Architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Expert in Tableau 6.x/7.x/8.x/9.x/10.x (Desktop, Server, Mobile, Public), Tableau Desktop, Tableau Reader and Tableau Server and Experience including analysis, modeling, design, and development of Tableau reports and Created dashboards by using Level of Detail concept (LOD’s)
• Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Bar Charts, Line Charts, Histograms, Tree maps, Pie-Charts, Dual Charts, Action Dashboards and cascading reports using Tableau.
• Experience in configuring reports from different data sources using data blending.
• Expertise in Teradata, Oracle, SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), UNIX, Microsoft Office Suite.
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Developed reports using Advance Analytics like Reference Lines, Reference Bands, Trend Lines, Box plots and Custom Geocoding.
• Proficient in developing complex SQL queries for reporting needs.
• Experienced in using Python, Tableau for data integration, data cleaning, data masking, data visualization, risk analysis and predictive analytics.
• Proficient in using SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Experience in performing Data Analysis and Data Validations to ensure the Data is as per Business needs.
• Experience in creating various kinds of reports like Parameterized, Cached, Drill through, Drill down, Sub reports in SSRS.
• Familiar with SSIS Packages - Dataflow, Control flow items and SQL Import/Export wizard operations to move Data between different Sources.
• Involved in SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in data Warehouse using SSIS.
• Experience in Requirement Gathering Methodologies with complete end to end participation in all areas of Software Development Life Cycle (SDLC) which includes traditional Waterfall and Agile (SCRUM) and Expertise in preparing Business Requirements Document (BRD), Software Requirements Specification (SRS), Functional Specifications Document (FSD) and assisting in developing test plans.

TECHNICAL SKILLS:

RDBMS/DBMS: Microsoft -SQL Server 2014/ 2012/2008/2005, Oracle 10 /11g/12c, MS Access, DB2, HANA, Teradata, DB2, Apache Hive/Spark, SalesForce.

BI /Data model Tools: Tableau Desktop 10.x /9.x/8.x, Tableau Server, Business Objects, Dashboard designer, SSRS

2012/2008/2005, Alteryx, Crystal Reports, DTS, SSIS, Visio. Visual Studio 2013/2015.

ETL Tools:: SSIS, Informatica.

Operating Systems: Windows 10/Windows 7 /Windows NT/ Windows Server 2003/Windows XP, IIS 5, 6,Linux,Unix Mac OS

Programming Languages: Python(Pandas,matplotlib,seaborn,scikit-learn,re), SAS, SQL, T-SQL, PL SQL, Hive QL, R, Stored Procedure, ANSI SQL

Application Packages:: MS Office, MS Outlook, Power Query, PowerPivot, Statistical analysis.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS) Proficient, SQL Server Enterprise Manager, Toad, Query Analyzer, Bex, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE:

Confidential, Pasadena CA

Sr. Tableau Developer/SQL Developer

Responsibilities:

• Conversant in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test, implementation and report.
• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding.
• Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
• Developed various types of charts and graphs like donut charts, funnel charts, bar charts, line graphs, pie charts.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Generating Complex Transact SQL (T- SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the Stored Procedures, User-defined Functions and Views.
• Proficient in developing complex SQL queries for reporting needs.
• Also, created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Blended data from multiple databases such as MS Excel and Oracle, SQL database by assigning primary key from each database.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) in SQL Server.
• Handled the tasks of building, deploying and maintaining metadata inventories and data support tools. Experienced working on different ticketing systems such as Agile ticketing.
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Combine data sources by joining multiple tables and using data blending
• Responsible for dashboard design, look and feel and development.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Collaborated with Business Analysts and Data experts to capture analytical requirements
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Experienced MSBI Developer, specializing in designing, development, implementation and maintenance of Database and BI Applications using MS SQL Server 2012/R2/2008/2005 and MS BI Stack (SSIS, SSAS, and SSRS) and Tableau.
• Created Test Cases and documented the Test Results.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Perform installation migration and upgrade of Tableau Servers and Desktops under High Availability scenario,
• Perform performance analysis of existing Tableau Servers and make Best Practice recommendations
• System Administration including the creation of new site, server maintenance/upgrades/patches and schedule control.
• Incident management, showstopper resolution, root cause analysis and backup and recovery.
• Product implementation, system integration or development with strong understanding of TableauArchitecture and Administration .
• Formulated procedures for installation and configuration of Tableau desktop.

Environment: Tableau (Desktop/ Server)9.3 & 10.0, Alteryx, Informatica, Microsoft PowerB.I.,Teradata V2R5/R6/R12/R13, Hadoop, AWS, SQL developer, MS SQL Server & TFS, Oracle MySQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2012 R2 server.

Confidential, Conway, AR

Sr. Tableau Developer/ SQL Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.0, 8.2and 8.1.
• Also, involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Tableau installations, configuration and administration strong expertise with Tableau platform sizing, troubleshooting, tuning & disaster recovery
• Administer and provide production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, DataMigration, Data Integration using SSIS, SSAS and Python.
• Worked on client/server tools like SQL server Enterprise Manager and Query Analyzer to Administrator SQL Server .
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing reports using SSRS and Universe of Business Objects
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Handle Tableau admin activities such as granting access, managing extracts and Installations.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Involved in code migration to different folder and to different versions of Informatica 9.6.1 to 10.1.
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements. Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 9.0, 8.1, 8.2, Teradata 13, Informatica, Oracle 10g, Crystal Reports 2008, TFS, SSRS, SSIS, SSAS, MS Office Suite.

Confidential, San diego, CA

Tableau developer/ SQL Developer

Responsibilities:

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the report’s specifications document and report inventory.
• Responsible for all tableau admin and developer activities, manage user and groups, create data extraction using schedules. Create sites and project in tableau server and grant permission to related business users. Use tableau admin view page to manage all activities background extract and non-extract tasks.
• Performed data preparation for tableau workbooks using Alteryx and Sandbox tables.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Developed custom reports and dashboards based on the business requirements using Power BI.
• Prepared dashboards using calculation fields, parameters and Action Filters.
• Developed dashboards to show survey, design, construction and information to field contractors
• Developed Construction Detail report, where all the construction information like nodes, footages and passages can be viewed all together.
• Created Hyper build report where we can get all the open tasks, estimated cost and jobs.
• Developed UCD (User-Centered Design) and UDD (User-Driven Development) using a mixture of investigative methods and tools to develop an understanding of user needs.
• Worked with different design teams including software engineers and domain expertsfrom across multiple disciplines to develop UCD and UDD.
• Created Polaris financial reports, forecasting reports, capital tracking reports.
• Responsible for writing queries in T- SQL, implementing views and stored procedures to support the various BI report requirements.
• Setup new projects, security groups, roles and administer users for all supported platforms.
• Scheduled extract refresh for daily, weekly and monthly reports.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs. as part of the Business Intelligence team, was responsible for installation configuration and administration of theTableau server and client applications. established best practice methodologies for the administration of the Tableau platform.
• Tableau data infrastructure data source creation security user access change control of Tableau objects and overall Tableausupport
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created customized and interactive Tableau dashboards using multiple data sources - Oracle, SQL Server, CSV files
• Worked with customers to define reporting needs and implement Tableau reports to satisfy needs
• Created custom database connections, join-tables as needed, create & manage Extract and Monitor Queries using SQuirreL SQL Client.
• Have always completed the committed story for the sprint while following Agile board.

Environment: Tableau Server 10.2, 10.4, 2018.1, Tableau Desktop 10.2, 10.4, 2018.1, MS SQL Server 17.4, Oracle 10g, MS VISIO, Microsoft Office Suite, TFS, Alteryx 11.7.4.

Confidential, San Antonio, Texas

Tableau Developer

Responsibilities:

• Researched existing systems and processes for report generation, developed / documented business requirements and held meetings with Investment teams (Primary, Secondary, Private Credit, etc) to complete the development schedule.
• Designed and developed Summary/ Aggregate tables using procedures and views from SQL Server
• Designed, developed and published customized interactive reports /dashboards and scheduled data refreshes for reports on Tableau Online.
• Created Adhoc reports to users in Tableau by connecting to excel sheet, flat files, and CSV files.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending feature in Tableau.
• Provided guidance and insight on data visualization and dashboard design best practices for Tableau report development
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data.
• Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop to validate static and dynamic data for data validation.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Played key role in Agile team including participating in job sprints on SCRUM based projects with onsite/offshore team members to assist them in the projects
• Technical oversight of the entire Tableau Online infrastructure from user setup to performance tuning.
• Performance tuning of workbooks, data sources, and providing best practices for user community
• Provided production support for Tableau users.

Environment: Tableau (Desktop/Online) 10.x, Microsoft SQL Server, JIRA, Informatica, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Plano TX

Tableau Admin/ Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Involved in gathering client requirement and developed Tableau reports based on user defined ad hoc user Interface for end users.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with an incremental load.
• Experience in generating On-demand and Scheduled Reports for business analysis or Management decision using SQL Server Reporting Services.
• Designed complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tools Tableau and Qlik view.
• Involved in developing Tableau Dashboards using both relational and Multidimensional data.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Administered user, user groups, and scheduled instances for reports in Tableau. Converted metric insight reports to Tableau reports.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.

Environment: SQL Server 2012, 2014, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), visual studio 2013, Tableau Desktop, Tableau server / Administrator, tabcmd.

Confidential

Tableau Developer/Admin

Responsibilities:

• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Designed and deployed rich graphic visualizations with Drill Down and Drop-down menu option and used parameters using Tableau.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Generated Tableau dashboards with combination charts for presenting KPI’s, with different Data Visualization Techniques like Tree Maps, Geo Maps, Stack Bars and Line Graphs for Showing Trend with Dual-Axis and Data Blending Techniques.
• Developed key indicators and appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
• Worked on Custom complex SQL Queries to generate data from various data sources to generate Innovative and Powerful dashboards for easy data visualization and analytics in Tableau.

Environment: Tableau Desktop 8.0, Tableau Reader, Tableau Server 7/8, Tabcmd, MS SQL Server 2012TSQL, MS Excel, SQL Server Management Studio, Share Point, MS Office 2010/2013.