SUMMARY:

• Around 12 years of IT experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations, reporting, production support and Documentation of various functionalities.
• Certified Tableau Desktop 10 Qualified Associate with over 7+ years of professional experience working on Tableau Desktop 9.3 and higher and Tableau Server.
• Extensive experience and in - depth knowledge in gathering business requirements and developing complex reports with multiple queries, custom SQL, complex functions, merging dimensions at report level, drill down, complex filters including calculations contexts, variables, filters, breaks, sorting, alerts, drill down, slice and dice, Master/Detail, Cross Tab, Charts.
• Highly skilled in developing multiple dashboards/reports using various charts like Stacked Bar/Pie, Line/Area,
• Donut, Dual-axes charts, Geo-Maps, Bubble, Scatter, Heat Maps, Box & Whiskers Plot, Word Cloud, Funnel chart, Gantt chart, Cross Map and Symbol Maps.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• 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.
• Experience in configuring reports from different data sources using data blending.
• Strong expertise in relational database. Proficient in writing complex SQL queries
• Strong knowledge OLAP and OLTP systems and Experience in using Dimensional Data Modeling and Relational Data Modelling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling for designing Data warehouse / Datamarts.
• Certified Scrum Master (CSM) with expertise on Agile, Waterfall and other development methodologies.
• Expertise in management of the entire Software Development Life Cycle (SDLC) and experience as a point of contact between development and the client team in connection with assigned projects. Managed projects in global (onsite-offshore) delivery model.
• Possess extensive Team player skills with strong interpersonal skills & liaison skills. Possess excellent analytical and problem solving skills with strong academic record.
• Excellent domain knowledge in Banking, Insurance, Telecom and Healthcare sectors and applying best practices.

TECHNICAL SKILLS:

Tool: Tableau 8.0, 8.1, 9.0, 10.0 Excel, Tableau (Desktop/ Sever/ Reader) 9.3/8.3, JIRA, ETL Tools Informatica, HP ALM Quality Centre, QTP, EASYTRIEVE, VSAM, INFOMAN, FILE-AID, QMF, SPUFI, ENDEVOR, ABEND-AID, XPEDITOR, INTERTEST, IOF, SYNCSORT, PANVALET, SAR

Packages: MS-Office products (Visio, Excel, PowerPoint), MS-Project

Methodology: Scrum (Agile), Waterfall, Iterative

Languages: COBOL, Confidential, SQL, JCL, REXX

Database: Teradata, Oracle, SQL Server, DB2, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. Tableau Developer

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs for Loyalty Program.
• Performed data analysis and extracted data from various tables in the Enterprise Data Warehouse to identify the problem with the existing data and prepared documentation on the ongoing fix and data issues.
• Analyzed dimensional and fact tables in data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Worked with technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Worked with technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
• Extensively used advance chart visualizations in Tableau like Dual Axes, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Build custom time frame dashboards to compare any date range of one period with another.
• Created functional Stop/Pause button using JAVA Script.
• Used Java Script API to create functional Stop/Pause button and customize the views, selects, filters, date and time.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures
• Use MS Excel, Word, Access, and Power Point to process data, create reports in Tableau, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau (Desktop/ Sever/ Reader) 9.3/8.3, Oracle 11g, Teradata 14.10, Toad, Teradata SQL Assistant, Alteryx, ERwin, MS Project, JavaScript API, MS Excel, Confluence.

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Developed highly polished executive level dashboard prototype regarding total budget views, churning, new acquisitions and value changes for budgets.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the total value change with respect to several weeks ago data
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created complex Tableau Dashboards by blending the data from SQL Server and flat files
• Co-ordination with IT and testing teams in creating Solution documents, Test Case documents and traceability matrix.
• Responsible for setting up security model which involves creation and deletion of sites/users group, granting permissions for user / user group
• Key member in development of E-R modelling (Logical design) of database incorporating business logic and user requirement.
• Worked on Capital revenue, Sales growth by region, Country wise, state wise metrics, geocoding reports
• Connected Tableau to Hadoop Data lake using Hive and extracted approx. 50M of data and created the Benchmark sales and performance KPI's using Tableau Analytics.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL.

Environment: Tableau 8.X/9.X, Tableau (Desktop/ Sever/ Reader) 9.3/8.3, Oracle 11g, CRM Siebel, DB2, SQL Server, SPUFI, QMF, MS-Office and MS-Visio, Hadoop Hive, Impala

Confidential , Fort Worth, TX

Tableau Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Performed Gap Analysis for designing future state application by analysing current applications and business processes.
• Gathered user requirements, analysed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good hands on experience on terra data DBA and modern data ware housing.
• Vision, Scope, Business Requirement, Business Rules, Business Events, Use Cases, User Interface, Non-Functional Requirement, Implementation Plan, Test Plan, Test Case, User Acceptance Testing scripts and User Guides.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Effectively used data blending feature in tableau.
• Define roadmaps, project plans and steps to implement master data management architectures
• Responsible for design, development, and testing of new and existing software features.
• Participated in design review and code review activities and provided valuable inputs.
• Comply with the standard SDLC process for software development and ensure that all BI deliverables are supplied and approved.
• Worked with the team in improving the BI process while maintaining alignment with Client Technology Solutions objectives.
• Interpreted project activities to ensure prioritization of deliverables and accuracy in estimated milestone parameters.
• Create highly visual analytical dashboards using Tableau.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created Heat Map showing sales data by colour that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Designed customer oriented interactive web reports and dashboards for different user experience KPIs
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.

Environment: Tableau Desktop 8.x, Tableau Server, Tableau (Desktop/ Sever/ Reader) 9.3/8.3, Oracle 11g, MS Office Suite, MS Excel, Visual Studio, SQL Server.

Confidential, Lewisville, TX

Tableau Developer

Responsibilities:

• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Created incremental refreshes for data sources on Tableau server.
• Generated high detail oriented views using multiple measures, Individual Axis, Dual Axis and Custom Geo-coding.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Build complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Group, Sets, Forecasting, and Hierarchies.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Created custom SQL queries for complex Tableau Reporting.
• Performed end-to-end Data Analysis and ensure the data quality gaps are identified

Confidential, Columbus, OH

IT System Analyst

Responsibilities:

• System study and analysis. Requirements gathering, elicitation, analysis and development. Documenting business, functional requirements and translating into system requirements specifications.
• Maintenance and/or development of COBOL and Confidential programs including DB2 stored procedures.
• Onsite/Offshore coordination, act as a point of contact between development and the client team for this project.
• Manage change in requirements, estimate and Unit Test plan preparation. Planning, conducting project review meets, performing unit testing, peer testing, system testing.
• Provide on-call support and assistance to the existing Blue Ribbon applications for various business units.
• Assist in providing management activities and provide all required status reports to the client and Wipro Leadership team.

Confidential, Colorado Springs, CO

Sr. Developer/ Analyst

Responsibilities:

• Requirements analysis and gathering for modification of system. Preparing requirement document; unit test plan, system and integration test plans.
• Conducting design walk through, software coding, conducting review meets, performing unit testing, peer testing and system testing.
• Implementation support, testing and coordinate with development team on bug fixes. Act as a point of contact between development and the client team in connection with assigned projects and coordinate with offshore team. Mentoring offshore team.

Confidential, Los Angeles, CA

Developer/Analyst

Responsibilities:

• Analysis and documentation of requirements for the entire project. Preparing design and analysis document. Conducting design walk-through.
• Software coding COBOL, Assembler and Easytrive programs, conducting review meets, documenting unit test plans and performing unit testing. Production migration and validation. Done research and analysis for client queries.

Confidential, Atlanta, GA

Programmer Analyst

Responsibilities:

• Design, Estimation and Functional specs for proposed Enhancement of the existing applications. Coding, unit testing and code migration. Cycle tuning and Automation.
• Production support for URM applications. Migration of code from test region to acceptance in endeavour.
• To coordinate with other teams during installations across systems and special cycles. Metrics collection, weekly status and monthly status reporting.
• Gathering of requirements from client and documenting it.
• Preparing the design document. Coding, Unit Testing, Bug fixing and migration of code.
• Preparation and testing of reports.
• To coordinate with other teams during major and minor installations, and special cycles.
• Resolution, review of business queries relating to financial reporting processing. 24x7 Production support for the applications.