SUMMARY:

• 8 + years of experience in design, development, implementation, and maintenance of enterprise level Data Warehouse and Business Intelligence solutions in domains such as Energy, Oil and Gas, Transportation, Pharmaceutical, Banking and Finance, Entertainment, Manufacturing and Supply Chain Management.
• 6+ years of experience in Tableau Desktop & Tableau Server.
• Strong analytical, conceptual design skills and strong problem - solving skills and have best Practices for Real-time Data Warehousing and Business intelligence.
• Proficient in Business Analytics, Data Analysis, Data Analytics, Data Science, Machine Learning, Data Warehousing, Database Programming, Cloud Engineering and Data Modeling.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
• Sound knowledge in Dimensional modeling and designing and implementing Star and Snowflake Schema.
• Excellent SQL, TSQL, PL/SQL coding, Triggers, Stored procedures, Views development skills.
• Highly Proficient in preparing Functional Designs & Technical Specifications as required by SDLC.
• Strong ability to learn and adapt to new trends and technologies quickly and willing to assume responsibilities.
• Good at adopting new technologies and gain proficiency in the new technologies to enable users to find right BI Solution based on the requirement.
• Able to work under pressure with minimal guidance and desire to work on new, innovative, cutting-edge technologies.
• Demonstrated mastery in understanding Business Vision and evaluating requirements to technical solutions in accordance with enterprise and strategic goals of the organization.
• Expertise in Requirements Management; Acted as a liaison between Business Stakeholders and development team to facilitate understanding of business requirements.
• Strong analytical and problem-solving skills; excellent communication & presentation skills, and ability to work in a team environment.
• Executed projects in a Global Delivery Model with Onsite/Offshore teams.

TECHNICAL SKILLS:

Tableau: 2019.x/2018.x/10.5/10.0/9.x/8.x/7.x Tableau Desktop, Tableau Server, Tableau Reader, Tableau Online, Tabjolt, JavaScript API, REST APIs

Amazon Web Services: Amazon S3, EC2, Redshift, Aurora, Amazon Dynamo No SQL Database

Microsoft Cloud: SQL Azure, Azure Analysis Services, VSTS, Azure Database Migration service, Azure Cosmos DB

Microsoft SQL Server: MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS SQL Server Data Tools (SSDT)

Microsoft Power BI: Power BI Online, Power BI Desktop, Power BI Report Server

RDBMS: Oracle 12c/11g/10g/9i, MS SQL Server 2016/2012/2008 , PostgreSQL 9.6/9.1

ETL: Alteryx v 2018/11.7/10 (Alteryx Designer, Alteryx Server, Alteryx Connect), Tableau Prep, Informatica Power Center 10.1/9.x

Server Tools: AppDynamics, Unified Infrastructure Management, WinSCP.

Testing Tools: HP Quality Center, IBM Rational Manual Tester

Programming: SQL, PL/SQL, JavaScript, HTML, XML, R, Python, PowerShell

Tracking Tools: Rational Suite (Jazz, Clear Case, Clear Quest), IBM Smart Cloud Control Desk

Operating Systems: Windows Server 2016/2013/2008 , Red Hat Enterprise Linux 7

HADOOP/Big data: No SQL Database, Cloudera, Apache Spark

SAP Business Objects Business Intelligence: BOBI 4.1/3.1/XIR2 (WebI, BI Launch Pad, IDT, CMC)

Domains: Media, Energy, Technology, Healthcare, Financial Markets, Manufacturing and Logistics, Supply Chain Management.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Senior Tableau Developer

Responsibilities:

• Developed Sales and Margin dashboards and visualizations that empower decision makers.
• Developed waterfall, bubble chart and heat map to gauge sales and margin data.
• Compared two-year data in all sales & margin aspects including in-depth analysis product wise and region wise.
• Performed detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
• Used Tableau API Tabpy to perform statistical analysis using python functions.
• Involved in administrative tasks such as publishing workbooks, setting permissions, managing ownership, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau
• Interacted with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with the important project & business stakeholders throughout the project life cycle.
• Mainly dealt with sales and networking team to analyze the sales which lead to an increase and decrease in the sales region by region.
• Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
• Used Alteryx to clean and model the data as per the need of Tableau Dashboards.
• Used google and Adobe Analytics to provide analytics on the website’s usages.

Technical Environment: Tableau 2019/2018, HANA, SQL Server, JIRA, R, AWS, Google Analytics, SharePoint, Alteryx

Confidential, Jackson MI

Senior Tableau Developer/Analytical Consultant

Responsibilities:

• Played a pivot role in the requirements gathering of the project by interacting with the business.
• Designed, developed and maintained daily and monthly summary, trending and benchmark reports repository in Tableau Desktop.
• Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements.
• Involved in building SQL queries that would be utilized in Tableau dashboards to satisfy the business's needs.
• Used Git and Jira for code submissions and review process.
• Implemented visualizations and views like combo charts, stacked bar charts, pareto charts, donut charts, geographic maps, spark lines, crosstabs etc.
• Published workbooks and extract data sources to Tableau Server, implemented row-level security and scheduled automatic extract refresh.
• Analyzed workbook performance on timeline and execution query, tuned and optimized analysis, calculated fields, layout and data source.
• Used Tabcmd for capturing tableau dashboards images and send business emails for business users.
• Applied tableau security and published report to Tableau Server Based on Sector Level & Market Level.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server to allow end users understand data on the fly by using quick filters for on demand needed information.
• Created groups in the repository and added users to the groups and granted privileges explicitly through group inheritance.

Technical Environment: Tableau 2018.1, HANA, SQL Server, JIRA, Python, BOBJ, Dashboard Designer, AWS, Postgres

Confidential, Houston, TX

Senior Tableau Developer/BI SME

Responsibilities:

• Responsible to Design and Development Advanced Analytics, Data &Visual Analytics efforts to support the data warehouse and reporting requirements for Performance Analysis & Integrity of Confidential .
• Responsible to Design, Develop & Test the Dashboards, Reports.
• Created Tableau Visualizations for statistics Reports using standard deviation & regression Analysis.
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created Tableau Visualizations for YTD - Year to Date, MTD - Month to Date, YoY - Year Over Year, MoM - Month Over Month, WOW - Week Over Week Analysis.
• Worked on Transforming Conceptual ideas to Building, publishing Dashboards, KPIs, and Applied Section 508/ Accessibility Standards compliant software development methodologies where necessary.
• Worked on Tableau Workbooks, Extracts optimization and Tableau Server performance.
• Interacted with End Users, Cross Functional teams for requirements gathering.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Developed set analysis to provide custom functionality in tableau application.
• Expertise in creating Hierarchies for proving drill down option for the end user.
• Defined best practices for Tableau report development and effectively used data blending feature in Tableau.
• Worked on the Postgre SQL for Server issues using Tabjolt.

Technical Environment: Tableau 10.5/10.0 (Server, Desktop, Reader, Online, Postgre SQL, Tabjolt),App Dynamics, Unified Infrastructure Management, Oracle 12c,Microsoft SQL Server 2016(Azure, VSTS, SSDT, SQL Server Management Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)) and Alteryx v 11.7((Alteryx Designer, Alteryx Server, Alteryx Connect)

Confidential, Washington, DC

Sr. Tableau Developer/Admin

Responsibilities:

• Responsible for the Development of Complex Dashboard s and Data Integration for Operations, IT and HR.
• Installed, configured and supported Tableau 10.0 in a Distributed environment and Responsible for Tableau Server performance &Tableau Workbooks optimization.
• Connected to Cloudera Hive schemas using Hive JDBC Drivers to create Tableau Visualizations.
• Developed cutting edge & visually stunning reports adheres to Tableau best practices.
• Java script has been used to integrate the Tableau Dashboards with internal application.
• Developed Tableau Dashboards to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis and used LODs calculations.
• Data Blending has been used to combine multiple Data sources in Tableau.
• Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Developed and created a Sales Growth Dashboard metrics measure the pace at which your organization's sales revenue is increasing or decreasing.
• The Sales Opportunity Dashboard metric organizes prospects based on opportunity value and the probability of closing the sale. Each prospect has an estimated purchase value associated with them to help your team prioritize their efforts.
• Served as a Tableau Administrator by managing user access, performance, troubleshooting, job monitoring, communicating with business users
• Interacted with End Users, Cross Functional teams to Create & Support Visualizations, Reports

Technical Environment: Tableau 10.2 /10.0 /9.3 (Desktop, Server, JavaScript API, Online, Reader),Amazon Web Services (Amazon Redshift, Amazon Dynamo No SQL Database), Oracle 12c,Microsoft SQL Server 2016(SQL Server Management Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)), Team Foundation Server) ,Cloudera Hive, AWS(Aurora, EC2,Redshift, Amazon S3, Dynamo DB)

Confidential, PA

Sr. Tableau Developer

Responsibilities:

• Responsible for Marketing & Sales department’s Data Integration, Data & Visual Analytics, Dashboards, Advanced Analytics.
• Used Microsoft Visio to develop flow charts for process mapping.
• Developed Dashboards to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis and used LODs calculations.
• Co Ordinated with CRM Team for Developing CRM solutions and customization of building web services for the Data & Reports Integration.
• Created Tableau Dashboards for YoY - Year Over Year, MoM - Month Over Month, WOW - Week Over Week Analysis.
• Worked on Transforming Conceptual ideas to Building, publishing Dashboards, and KPIs.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau Desktop using various sources such as Oracle.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Creating interfaces on ODS data using SQL and PL/SQL in procedures and packages in oracle and running using oracle schedules by hourly, daily, weekly or monthly depends upon business requirements.
• Providing training material and hands on training on reports with ODS data to end users.

Technical Environment: Tableau 9.x (Server, Desktop, Tableau Reader, Postgre SQL) Oracle 11g, Microsoft SQL Server 2012(SQL Server Management Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)), Microsoft Power BI 2014(Power BI Online, Power BI Desktop, Server), CRM 2014 and Alteryx v 10.

Confidential, Charlotte, NC

Sr. Tableau /BI Consultant

Responsibilities:

• Responsible for Tableau BI Design and Development activities including developing the Data models, BI solutions, Analytic visualizations, Complex Reports.
• Migrated Xcelcius & SAP Lumira Dashboards to Tableau Dashboards.
• Designed Tableau views with quick/context/global filters, Table Calculations, Parameters and calculated fields. provided Tableau KPI's & ViZs on housing market performance, enable homeowners to see if prices are rising in their area& how quickly homes are selling.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created stories in Tableau desktop using Story functionality.
• Responsible for developing Dashboards and preparing ad-Hoc Reporting.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involved to create Documentation for debugging report for Tableau

Technical Environment: Tableau Desktop 9.0/8.3, Tableau Server 9.0/8.3, Team Foundation Server 2013, Erwin Data Modeler 9.0, Oracle 12c/11g, Oracle PL/SQL, .NET Framework 4.6 (Asp.Net, C#, VB.Net), Microsoft SQL Server 2012(SQL Server Management Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS SQL Server)

Confidential, N.Y

Sr. BI Consultant

Responsibilities:

• Responsible for Tableau BI Design and Development for OLAP Analysis, Dashboards, Metrics, KPIs, Score cards, Polygon Maps, interactive maps, Geo Map dashboards and integrate with existing internal application using JavaScript API, REST APIs.
• Applied this expertise to the elaboration and design of the data model to capture and correlate relevant delivery quality metrics and to enable analytical/actionable insights.
• Strategically enables data-acquisition and sourcing (identify, extract, transform, load, normalize) of relevant data to enable delivery quality metric reporting.
• Developed analytical queries and reports "which resonate" for Delivery Quality Insights.
• Acted as a steward of the integrity of the Metric model and reports with emphasis on accuracy, clarity, availability, reliability.
• Produced value-add delivery metrics, reports, scorecards, analytical trending charts, etc. to enable transparency in TSG's effort to deliver faster and better value.
• Prepared Backup strategy and performed Full, Differential and Transaction Log Backups and restore them whenever necessary.
• Enforced SQL Server Security by Managing Logins, Server Roles, Database Users, Roles and Permissions
• Performed Troubleshooting of issues related to Database Integrity, Performance, Blocking & Deadlocking and Index Management.
• Writing SQL queries for data validation by using join conditions.
• Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Provided support for Tableau developed objects and understand tool administration. Created and Published Tableau Dashboards into Tableau Server.

Technical Environment: Tableau Desktop 8.0, Oracle 11g, TOAD 4.5, kdiff3 0.9.95, Ultra Compare Professional Version 14.0, IBM Rational Manual Tester 7.0.1, Rational Suite (Rational Rose, Requisite Pro, Clear Case, Clear Quest), SQL Server 2012/2008.

Confidential, N.Y

Sr. BI Consultant /Tableau Consultant

Responsibilities:

• Provided new reporting solutions using Tableau, SAP Business Objects, Microsoft Including new report generation, report optimization, customization of existing reports and standardization of reports for Unemployment Compensation Management System (UCMS).
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Created Complex SQL Queries for SAP BOBI IDT Derived Tables & Calculated measures for BOBJ Universe.
• Writing complex T SQLs for Reporting, data integration using SSIS from different Source Systems, Coding complex stored procedures.
• Developed and to re-designed reports with dynamic grouping fields, dynamic group sorting, on-demand sub-reports, drilldown and summary report/Created Cross Tab reports using Crystal reports to suit the reporting needs.

Technical Environment: Tableau 7.0(Desktop, Server), Business Objects XI 3.1(Web Intelligence Rich Client, QAAWS, Info view, Universe), Xcelsius 2008, Crystal Reports 2008, MS SQL Server 2008, Microsoft BI (Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MS SQL Server Management Studio (SSMS)), Visual SourceSafe Explorer 2005/6.0 and Oracle 11g.

Confidential, Texas

BI Consultant

Responsibilities:

• Interacted Daily basis with Business Analysts, End Users to gather the business needs and requirements to Create and modify existing Universes.
• Performed analysis, design, develop, testing and implementation of universe using Business Objects XI.
• Responsible for unit testing of reports to confirm that they work as expected in Development environment, both in Crystal Reports and when published to Business Objects Enterprise XI R2/3.1 environment
• Developed the web-intelligence reports, provided a supporting role in building the universes & Security Architecture.
• Very good working knowledge of Trading Compliance.
• Involved in testing and debugging of canned complex reports.
• Performed Performance Tuning of Universe and Reports in order to reduce query run time.
• Developed Xcelcius dashboards with SAP BW Queries as sources.
• Prepared user documentation for hands on training of end user community.
• Strong knowledge of securities (mortgage backed securities and derivatives).
• Created mappings using Informatica Power Center.

Technical Environment: Business Objects XI 3.1(Designer, QAAWS, Live Office, Web Intelligence Rich Client, Import Wizard, Business View Manager, Query Builder, Data Source Migration Wizard), Control M Enterprise Manager 6.4.01/6.3.01 , IBM DB2 9/8.2, kdiff3 0.9.95, PostgreSQL 9.1, Xcelsius 2008, Report Conversion Tool 4.0, IBM ODA 2.2.3.0/2.2.2.1 , PostgreSQL 9.1, Informatica Power Center 8.6, Lotus Notes 8.1 &SAP Crystal Reports 2008.