SUMMARY

• Over 7+ Years of IT experience which includes Design, Development, Integration, Implementation and Maintenance of Business Intelligence Platforms.
• Experience in Latest BI Tools like Tableau, QlikView, and Microsoft Power BI.
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Professional in writing complex Formulas, Sub Reports, Summary Reports.
• Worked extensively with Advance analysis like Actions, Calculations, Parameters, Background images, Maps, Trend Lines and Statistics.
• Used Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Designed and developed many complex reports based on the requirements using complex calculations like Row - level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines using Tableau 8.2 to 10 .1.
• Performed LOD Calculations on the worksheet for micro granular reporting.
• Working knowledge in gather external data to Tableau from different sources like Oracle, MySQL, AWS Redshift, SQL Server & flat flies etc., for data visualization.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Documented the Technical Requirement of the Instances for installation on Tableau server on cloud.
• Implemented Tableau in cloud using the virtual instances in the AWS EC2 platform.
• Worked with 16 core processor with two 64 Gb RAM server, having monthly refresh in AWS.
• Managed the DNS zone files of respective servers and managed the clusters through VPC using the load balancers in AWS.
• Created Dashboards, Reports, Datasets using Power BI.
• Replicated the Tableau Dashboards to QlikView for the management
• Connected different data sources to QlikView like Oracle, MySQL, AWS Redshift, SQL Server & flat flies etc for Data visualization
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Multiple levels of Hierarchies are implemented such as Sales, Product, Partner, Customers and Service Hierarchy etc.
• Was actively involved in the Server migration and the Fresh Tableau Server Installation process.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Administered user, user groups, and scheduled instances for reports in Tableau by controlling the access of resources to intended user.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Experience in Managing the DNS, SSL and proficient in network security concepts.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling using Erwin data modeler.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experience in Creating Tables, Views, Complex Stored Procedures, Triggers to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.
• Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Experience in Database Normalization, Designing, Creating Indexes, Developed Queries & T-SQL Scripts in MS SQL.
• Experience in developing SSAS Cubes, Dimensions and data source views and Deploying & Processing SSAS objects.
• Expertise in creating complex SSRS reports against OLTP, OLAP databases.
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS).
• Experience in optimizing the query by creating various Clustered, Non-clustered indexes.
• Expertise in Report Caching and Subscriptions including Standard and Data-Driven Subscriptions.

TECHNICAL SKILLS

BI Reporting Tools: Tableau Desktop, Tableau Server, Microsoft Power BI, Excel, QlikView

MSBI Tools: SQL Server Reporting-SSRS, Analysis-SSAS, Integration- SSIS Services

SQL Tools: SQL Server Data Tools and Business Intelligence Development Studio

Databases: MS SQL Server, MS Access, Redshift Oracle, PostgreSQL, Workbench/J

Languages: T-SQL, PL/SQL, DAX, MDX, .Net, Shell Scripting

Environment: Windows 7, 8.1, 10, Windows Server 2003, Server 2008, Server 2012, Linux.

AWS: EC2, Redshift DB, S3 Storage, Route-53 DNS, IAM Management

Other Tools: Microsoft office suite, Photoshop CS5, Google Analytics

Networking: DNS Management, Web Hosting, SSL, SAML, Security Group Management, SSH

PROFESSIONAL EXPERIENCE

Confidential - GA

Tableau Admin/Developer

Responsibilities:

• Partnered with Business stakeholders and executives with the goal of providing them with the ability to make decisions and gain insights through data visualization reports and operational reports.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Interact with Business Users, Business Analyst and source system owners to gather the Requirements and Business logics.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee, project, time and location dimension.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Extensively involved in doing user acceptance testing (UAT).
• Analyzing the transactional and dimensional data present in SQL server and Microsoft CUBE using Tableau to create standard reports for property management and internal strategy group.
• Enhancing the reporting environments performance by reviewing the Microsoft Cube and Tableau server configuration
• Strong Excel skills, including pivots, Vlookup, conditional formatting, large record sets. Including data manipulation and cleaning
• Connected to Tableau through SQL, AWS Redshift databases to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Installed the tableau on the cloud through Amazon Web Services EC2 services.
• Customized the Tableau portal with site listing as icons and descriptions
• Gathered reports requirement; collaborated with the business users using wireframe mockups.

Environment: Tableau Desktop 9.3, 9.0, 8.3, Tableau server 9.0, 8.3 windows server 2008, Oracle 10g, Microsoft Excel, MS Access, MS SQL, Photoshop, Amazon Web Services- Redshift, EC2.

Confidential - IL

Tableau Developer

Responsibilities:

• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Manages platform admin functionalities including installations/ configuration, upgrades, patches, change management, performance tuning, meta data Management and user management scheduling
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images,Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summaryreport and Dashboard using KPI’s
• Experienced in data warehousing using Amazon Redshift when dealing with large sets of data. Developed complex visualizations using Amazon Redshift.
• Experience on scripting using Tabcmd and Tabadmin.
• Developed SQL Queries to retrieve or create test data from different Redshift databases.
• Business Intelligence, Operational Risk Loss Data Management.
• Responsible for maintaining User and Group permissions across servers and dashboards.
• Experience in creating and managing Tableau sites.
• Experience in creating filters, quick filters, data source filters, local & global filters, context filters and user filters.
• Responsible to Identifying and assessing risks, determining the impact to platform.
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations. Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Creating calculated fields, groups, sets and hierarchies etc. Creating data blending in case of merging two different datasets.
• Built complex formulas in Tableau for various business calculations.

Environment: Tableau Desktop 9.0, 8.3, Tableau server 9.0, 8.3 windows server 2008, Oracle 10g, Microsoft Excel, MS Access, Amazon Redshift.

Confidential

Tableau/BI Developer

Responsibilities:

• Collected business requirements from different sources and wrote the technical specifications for building the Data model.
• Strong leadership, problem-solving and multi-tasking abilities.
• Developed workbooks and dashboards using Tableau 8.3 Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
• Involved in creating calculated fields, mapping and hierarchies.
• Worked creating Aggregations, calculated fields, mapping, hierarchies, Table calculations, Totals, percentages using Key Performance Measures ( KPI) and Measure.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Executed and tested required queries and data before publishing Dashboard
• Effectively used data blending feature in tableau.
• Define best practices for Tableau report development.
• Execute and tested required queries and reports before publishing
• Designed the ETL process to load data to the server through SSIS with a variety of data sources including Flat files, Access, Excel.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.
• Developed and deployed packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created Queries in Oracle SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Documented all processes and activities for future development.

Environment: Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2, Excel, MSBI(SSAS, SSRS, SSIS), MS SQL Server 2008R2, UNIX .

Confidential

SQL Developer

Responsibilities:

• Maintaining server activities, user activity, and customized views on Server Analysis.
• Manage the application's users, groups, and integration with Active Directory.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Designed, Coded, Tested, Implemented the Stored Procedures to support the System.
• Fixed bugs in the existing in-house developed Software, which is used to upload the reports for the end users to view the reports.
• Designed, coded and tested several T-SQL Queries to Support the System.
• Fixed bugs in the software that was used to support the healthcare system.
• Designed the reports using Crystal reports And SSRS to create reports for the end users.
• Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
• Used the SQL profiler to trace the data and thus troubleshoot effectively.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

Environment: SQL Server 2008, MS Visio, NET Framework, PowerBuilder, Crystal reports, SSRS

Confidential

SQL Developer

Responsibilities:

• Involve in Planning, Defining and Designing data based on business requirements and provide documentation
• Involved in updating functional requirement document after development and created documentation for deployment team.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Good understanding of SSRS with Report authoring, created daily, weekly and monthly reports as per requirement using SSRS.
• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS.
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Worked on SSRS reports and fine-tuned SSRS MDX queries.Also worked as a part time BA in mappings of the reports.
• Created an SSIS Packages for loading mappings into Tables.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations. Used MDX to create calculation formulae to enhance the cube productivity.

Environment: SQL Server 2008R2 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, PL/ SQL, SSIS, SSRS, SSAS.