SUMMARY

• Over 7 years of experience in Business Intelligence applications like Tableau, and over 3 years of experience with Power Bi. Have extensive expertise in designing and developing dashboards using Tableau Desktop, Tableau Server, and Business Intelligence tools (SSRS) as well as publishing visually rich and intuitively interactive Tableau workbooks with large data volumes from various data sources (SQL Server, AWS, Excel, Cognos).
• Involved in Software Development life cycle (SDLC) Phases such as Requirement Analysis, Design, Development, Testing and Deployment of Business Intelligence and Database Platforms, Project management expertise to structure work, timelines, and leading team along with soft skills to appropriately set stakeholder expectations under Agile environment.
• Highly adaptable and highly motivated to know more about the latest technologies, new software, and products. Ability to analyze and solve complex problems and ability to work proactively in a fast - paced environment.
• Worked in several domains as an investment company, healthcare, pharmaceuticals, apparel and footwear, financial, banking, and software services.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop (2020.2.2), Prep (2020.2.3), Server (2020.2.2), Online (2020.2), Public; Power BI Desktop (2.90), OLAP.

Database: Tableau server data sources, Google sheets, MySQL 5.5, Microsoft SQL Server 2014, IBM DB2 9.1, Teradata 15.0, Salesforce, AWS, Azure, Microsoft Excel 2007, Hadoop HDFS 2.9, IBM Cognos 11/10.

Programming: SQL, Python Scripting, Java, HTML.

Environment: s: VMware (ESXi 7.0), Microsoft Azure, Windows (XP, 2000, 2003, Vista), Linux HP-UX, AIX.

Managing Tools: JIRA v.8.5.1, TeamTrac (Intakes), Agile (Scrum, Kanban), MS Project 2016, SDLC.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Tableau Developer

Responsibilities:

• Developed crew velocity dashboards by following general guidelines with Personally Identifiable information for viewing daily, monthly and yearly velocities and included complex queries of SQL to extract data from AWS data sets for 7 different departments.
• Maintained tableau reports data source connections and scheduled refreshes and updates by automating manual Cognos work and generate various reports based on requirements.
• Performed risk-based validation in dashboards for better time management by maintaining data accuracy and integrity.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements..
• Produced interactive dashboard and applied actions (filter, highlight, and URL) for getting respective crew’s PII like name, address, phone number and so on.
• Managed troubleshooting performance issues that were associated with Tableau and Cognos.
• Extensively written Hive queries for data analysis to meet the business requirements.
• Performed development activities from gathering requirements and designing solutions, through developing code or reports, to testing and release or deployment.
• Researched and identified the needs, goals, and business models by collaborating with the end users, stakeholders and support partners.
• Worked with JIRA for maintaining and handling intakes based on the priority.

Environment: Tableau Desktop 2020.3, Tableau Server 2020.3, Tableau Prep 2020.2, Cognos v.10, SQL Server 2014, SQL Server Analysis Services (SSAS), MySQL 5.5, Microsoft SQL Server 2014, Hadoop HDFS v.2.9, Hive, SQL, MS Office Suite, JIRA 8.5, Teamtrac.

Confidential, Oakland, CA

Tableau Developer

Responsibilities:

• Created reports for the crew in Tableau by connecting various data sources (MS SQL, Access, Excel).
• Connected Tableau server with SharePoint portal and set up auto refresh feature for bi-weekly and annual reports directly sent to end-users.
• Compiled data and stories into reports for financing teams and improving performance by reducing analysis time.
• Generated Hive tables and working on them using Hive QL.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Computerized monthly reports into Workbooks and Dashboards which allows analyses and forecast complex data to be presented by using calculated fields, different filters (Extract, data source).
• Created data extraction process to extract data and performed required business transformation using SQL Packages.
• Produced data model by extracting the raw data from the SQL server database.
• Utilized advanced features of Tableau software like linking data from different connections together on one dashboard and filtering data in multiple views at once.

Environment: Tableau Desktop (10.2, 2018.3), Server (10.2, 2018.3), Microsoft SQL Server 2014, AWS, IBM Cognos 10, Hadoop HDFS v.2.9, Hive, SQL, MS Office Suite, JIRA 8.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Designed and optimized connections, data extracts, schedules for background tasks and data refreshes for Corporate Tableau Server.
• Hands on building groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's.
• Improved existing reports by limiting functions in queries include more extract and data source filters by aggregating data to identify trends and implementing data strategies and developing physical data models.
• Maintained comprehensive documentation and files which help in demonstrating the architecture involved and allowing for smooth collaboration between different departments.
• Designed various dashboards with requirements by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Complied interactive dashboards on the desktop which allows storytelling behind the data with filters and actions for on-demand needed information with just a click of a button.
• Studied and analyzed similar applications and brainstormed with the business team to gather effective requirements for the system along with dashboard development.
• Determined the data that was being used in the reports is correct and make sure the report contains sufficient and efficient information for the end users.
• Worked closely with SQL server creating new view to compose the data needed to create Tableau reports.

Environment: Tableau Desktop 10.1/9.2, Tableau Server 10.1/9.2, MS SQL Server 2014, MS SQL Server Integration Services, SQL, MS Office Suite, JIRA 6.

Confidential, Itasca, IL

BI Developer

Responsibilities:

• Developed mid-level Tableau dashboards to identify overall costs, expenses, and KPI's of the industry by using the BI tool.
• Created numerous reports based on the data collected from financial reporting Systems by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Managed all types of transformations that are available in Power bi query editor and created stored procedures and SQL queries to pull data into power pivot model.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
• Developed Tableau workbooks to perform Last Month, Current Year, trailing 6 months and trailing 12 months to show the variance analysis.
• Implemented data strategies and developing physical data models
• Involved in creating API filters for the Tableau Dashboards in the Cloud environment.

Environment: Tableau Desktop 9.0 & 9.3, Tableau Server 9.0, Microsoft Power BI 2.3, SQL server 2012, SQL, MS Project, MS Office Suite, SSRS 2008.

Confidential

BI Developer

Responsibilities:

• Interacted and coordinated with the robotics team, data modelers, DBA and managers to achieve better data and requirements for generating visually appealing and accurate reports.
• Extensively worked with designing visualizations with functionality like drilldown, drill through and parameters using SSRS.
• Involved in building and publishing customized reports using MS Power BI.
• Hands on experience in modifying existing worksheets and analyzing it to develop better visualizations with more detail.
• Tested Dashboards to ensure maximum data accuracy and functionality and provided postproduction support of BI solution by monitoring and troubleshooting issues.

Environment: Microsoft Power BI 2.2, Tableau Desktop 9.1, SQL Server 2008, SSRS v.11SQL Server 2012/200R2/2008, Windows 2003/2007 Server, SQL Server Configuration Manager.

Confidential

BI Developer

Responsibilities:

• Utilized technical skills and business skills to conduct an in-depth analysis of the business requirements
• Anticipated customer needs proactively develop solutions and suggest how BI can support the enterprise strategic project of all functions of the bank including Finance, Retail, Bank Services, and Risk Management.
• Dealt with Stored Procedure, triggers, User Defined Function, Performance Tuning, and Query Optimization.
• Created, Configured and tuned ETL workflows designed using SSIS of MS SQL Server.
• Worked with automation projects where 90% of the task are made automated.
• Customized sub reports and defining query for generating drill down reports using MS SQL Server (SSRS).

Environment: Microsoft Power BI 2.2, SQL Server 2008, Tableau Desktop 9.0, SQL, SSRS v.11, XML 1.0, Microsoft Excel, Business Objects 4.0, Cognos, Hadoop