SUMMARY:

• Over 14 years of IT experience with prime focus on Analysis, Design, Development, Customization, Data Modeling, Gap Analysis, Testing, Documentation and Maintenance of Data Warehouse / Data Marts and Business Intelligence.
• Extensive usage of Alteryx - 2019,2019.1,2019.3.5 / Trifacta 6.0/6.2,6.9,7.0 more than 3yrs.
• Hands on experience on Tableau 20.3,20.1,19.3,12.1,11.0,11.3, 10.1/10.0/9.3/9.0/8.3/8.0/7.0
• Excellent Knowledge of Tableau Platform, AWS-S3, AWS-Redshift, Hadoop, HANA Oracle E-Business, BIG Data (Hadoop/Hiva/Impala) and their underlying architecture & data model.
• Worked on the Tableau security setting up AD users using windows run as user. Setting up SSL /SMPT mail server configuration for alters on report failures.
• Developed complex workflows using Alteryx/ Trifacta
• Experience with configuring Financial Analytics, Supply chain and Order management (SCOM), Project analytics, Marketing, and HR Analytics including ETL/DAC / components.
• Worked with APPS modules like Finance (AR/AP/GL), P2P, supply chain and Order management (SCOM), Project Analytics, Marketing, HR Analytics and migrated the objects with PPM and scheduled Concurrent Program which intern does the incremental loads every day.
• Worked on the different modules like Financials, P2P, Supply chain and Order management (SCOM), Planning and Human Resource
• Worked on the AWS - S3 for the version control and bit bucket for the .tde file storage.
• Worked with Hadoop Team on building the views for modeling the Tableau extracts.
• Extracted with custom SQL more than 15million of records which intern does the incremental loads every day.
• Connected with multiple sources like SP/Hive/excels/Cubes etc. with Alteryx/Trifacta input data app.
• In-depth knowledge in Tableau analysis features like Actions, calculations, forecasting, parameters and trend lines, donut charts etc.
• Worked closely with DBA/Release Team in scheduling the Concurrent Program and migration Process approvals and attended the CRB meetings for approval.
• Strong understanding of data modeling and dimensional modeling, and designing Kimball’s Star and Snowflake schemas
• Strong skills in Requirement Study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation, Project Tracking, UAT, and Change Control Management.
• Expertise in Security Setup (groups, access / query privileges), LDAP, External Tables, configuring Analytics Metadata objects (Subject Area, Table, Column), and scheduling ibots.
• Expertise in Business Model development with Dimensions, Hierarchies, Aggregation Rules, Time Series, and Caching.
• Enhanced & implemented the Agile methodology with offshore & onsite model.
• Worked on Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
• Investigate issues in Hadoop Hue editor for complete end to end validation of the reports.
• Extensive experience in Repository Manager, Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor to extract, transform and load the data.
• Excellent Data Analysis Skills and ability to translate Business logic into mappings using complex Transformation logics for ETL processes.
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica 9.x/8.x/7.x/ 6.x.

SKILLS OVERVIEW:

Tableau: Tableau 7.0/8.0/8.1/9.0/9.1/9.3/10.1 /11.1/11.3,/20.1,20.3

Operating Systems: MS-DOS, Windows family, UNIX (HP, Sun Solaris), Linux

Programming Languages: C, C++, Core Java, .Net, Python.

Databases, Database Tools: Hadoop, Hue Editor, HANA, Oracle, AWS-Redshift, AWS-S3, SQL Server 2000, HANA Studio, Teradata.

ETL: Informatica 9, OWB, Dell boomi, Alteryx- 2019.3.5.1 , Trifacta

Web Servers: Microsoft IIS, Sun One

Scripting: JavaScript, VB script

Testing Tools: HP Quality Center

Data Migration: Bit Bucket, Git hub, SQL Loader, MS DTS, Service Now, PPM (Project and Portfolio Management Center).

Defect Tracking: HPALM, Bugzilla, POSTMAN

Scrum: JIRA, Kanban.

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, Delaware

Sr. Tableau Developer/Alteryx/Trifacta Developer

Environment: Tableau 20.1,20.3, Hadoop, Hive, Impala, Alteryx, Trifacta Cubes, Views, Oracle, Bitbucket, JIRA/Confluence.

Responsibilities:

• Oversee data elements provided by various lines of businesses (LOBs) within the CCB umbrella in regards to customer correction and remediation activities.
• Provide scheduled analytics to Senior Executive leaders regarding statuses, opportunities, and next steps for our cases.
• Data architect for reporting solution integrating Alteryx and Tableau to be a more self-service platform for stakeholders
• Design, document, and deliver ad hoc reporting once requirements have been delivered from the LOB or other requestor (senior leaders or regulatory bodies).
• Developing and white boarding wire frames, beta dashboards and presenting them to the business teams to see if they meet the requirements.
• Design, build and test several complex Alteryx workflows with multiple applications and customize flow based on the requirements.
• Data preparation, data blending, and the creation of data models/sets using Alteryx.
• Defining new KPIs and implementing highly complex user stories/actionable insights using Tableau reporting environment .
• Worked with Hadoop Team on building the views for modeling the Tableau extracts.
• Run an on-demand jobs using the specified destinations. The job is immediately queued for execution through Trifacta.
• Working on the Agile and give the turnaround time and try to resolve the Tableau issues raised by business/testing team.
• Created Multiple macros using Alteryx and used in other workflow LOBS.
• Publishing destinations specify output format, location, and other publishing actions through Trifacta. A single recipe can have multiple publishing destinations.
• Built Tableau dashboards on top of Hadoop database through live connectivity.
• Develop methodologies that allow for efficient and repetitive data extraction processes. Interact directly with Audit Managers and their staffs, Business process owners, Finance, and IT to design and implement data analysis solutions. Continually re-assess these solutions in efforts to make them more efficient and effective,
• Build complex custom BI r eports for end-user scenarios: Actuals/Budget/Forecast/BD3 .
• Present findings and recommendations to identify gaps or issues, conduct root cause analysis, document the impact and present options for resolution and change.

Confidential, Irving, Texas

Sr. Tableau / Trifacta Developer

Environment: Tableau 11.3, 10.3, Hadoop, Hive/Impala, Views / Materialized Views, Could (AWS), Bit bucket, Rally.

Responsibilities:

• Worked on the AWS - S3 for the version control and bit bucket for the file storage.
• Extracted with custom SQL more than 15million of records which intern does the incremental loads every day.
• Actively participated in Business Analyze sessions conducted by Stake holders to understand the business and answer business questions about capabilities of Tableau.
• Convinced business to use Tableau by exposing the capabilities of Tableau reporting.
• Built Tableau dashboards for showing insights of different portfolios dashboards and customer level detailed reports for relational managers, Directors and VP. Generated various Analytics reports like Formulary Report and Direct Enrollments Report using global and local filters.
• Worked with Hadoop Team on building the views for modeling the Tableau extracts.
• Working on the Agile and give the turnaround time and try to resolve the Tableau issues raised by business/testing team.
• Built Tableau dashboards on top of Hadoop database through live connectivity.
• Investigate issues in Hadoop Hue editor for complete end to end validation of the reports.
• Involved in the setup of Tableau with AWS configuration in cluster environment.
• Experienced in Tableau administration Tool for Configuration adding users /groups/Projects/sites/managing licenses and data connections scheduling tasks embedding views by integrating with other platforms like Service Now.
• Designed and developed many Smart Works Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & drillable charts (bar-charts, pie-charts, radars, and bubble-charts), Capabilities split reports for summary & details information,
• Improved Performance by creating materialized views and Partitions tables for the fact tables.

Confidential, SFO, CA

Sr. Tableau Developer /Lead/Admin

Environment: Tableau 8.0/8.3,9.0,9.3, Dell Boomi, HANA, AWS-Redshift, Pl/SQL

Responsibilities:

• Developed many Dashboards/Reports that are Dynamic & Interactive with intuitive drill downs, drill-across & drill able charts (water fall-charts, trend-charts, radars, and bubble-charts), Capabilities split reports for summary & details information.
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level per-computations and aggregations.
• Improved Performance by creating materialized views and Partitions tables for the fact tables.
• Working on the Agile and give the turnaround time and try to resolve the Tableau issues raised by business/testing team.

Confidential, Redwood city, CA

Sr. Tableau Developer /Lead/Admin

Environment: Tableau 8.0/8.3,9.0,9.3 Informatica 9.0, DAC, HANA, Oracle 10g, PL/SQL

Responsibilities:

• Involved in gathering requirements from business users and stake holders.
• Actively participated in Business Analyze sessions conducted by Stake holders to understand the business and answer business questions about capabilities of Tableau.
• Convinced business to use Tableau by exposing the capabilities of Tableau reporting.
• Built Tableau dashboards for showing insights of different portfolios dashboards and customer level detailed reports for relational managers, Directors and VP. Generated various Analytics reports like Formulary Report and Direct Sales Report using global and local filters.
• Worked with EBS modules like AR/AP/GL/P2P and migrated the objects with PPM and scheduled Concurrent Program which intern does the incremental loads every day.
• Worked closely with DBA/Release Team in scheduling the Concurrent Program and migration Process approvals and attended the CRB meetings for approval.
• Working on the incidents and give the turnaround time and try to resolve the Tableau issues raised by business.
• Built Tableau dashboards on top of HANA database through live connectivity.
• Have knowledge on HANA modeling.
• Investigate issues in HANA Studio and report to HANA developers.
• Involved in Testing the Tableau server/Desktop upgrading process and report the same to Support or Vendor.
• Created KPI’s and Scorecards to show the performance of Sales with prior year sales and forecast sales.
• Implemented Tableau Data/region level security at reports /dashboard. Worked with multiple source systems.

Confidential, San Mateo, CA

Tableau Developer

Environment: Tableau 7.0, 8.0, Oracle 10g, Pl/SQL, Informatica

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Converted existing BO 5x reports into tableau dashboards
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Collaborated with .NET developers to integrate the dashboards with .NET Framework.
• Worked with APPS modules like Finance (AR/AP/GL) and Procure to pay (P2P) and migrated the objects with PPM and scheduled Concurrent Program which intern does the incremental loads every day.
• Monitoring the Tableau Admin views and creating custom views. Generated report schedules on Tableau server/Tableau Desktop

Confidential, Atlanta, GA

Tableau Developer

Environment: Tableau 7.0, 8.0, SQL Server 2008.

Responsibilities:

• Created Tableau dashboards with interactive views, trends and drill downs along with user level security.
• Created and developed Parameterized, drill down reports using SQL Server 2008 Reports Services (SSRS).
• Actively involved in gathering requirements from end users, involved in modifying various technical & Functional specifications.
• Analyzed various reports, dashboards, scorecards in OBIEE and created the same using Tableau Desktop and server.
• Identified the factors involving the Tableau performance of the reports and coordinated in creation of indexes to improve the query turnaround time efficiently.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users

Confidential, Chicago, IL

BI Developer

Environment: OBIEE 10.1.3.4.1/11 g, Tableau, BI-Publisher, Informatica8.6, DAC, SAP BI, Oracle 10g, Pl/SQL

Responsibilities:

• Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.
• Experience using the Tableau tool to handle the various data feeds from different data sources using the Tableau Desktop tool.
• Building the customized and interactive dashboards using multiple data sources.
• Expertise with the extraction of data from different source systems such as Siebel - CRM and flat files
• Implementation of the data level and view level security, involved in developing the Incremental ETL
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.

Confidential

BI/Siebel Analytics Developer

Environment: OBIEE 10.1.3.2 (Siebel Analytics Applications), Informatica, SQL Server 2005

Responsibilities:

• Worked in Configuring the Siebel e-business Applications.
• Involved in creation of Technical design specifications according to client Requirements.
• Configured the User Interface layer like Applets, Views and Screens.
• Configured the Special events like Static and Dynamic Pick lists, Drilldowns, Multi Value Groups (MVGs) and Association Applet.
• Written scripts (e-script) to satisfy Client Requirements.
• Worked on data loads to load the data on to Siebel using EIM.