SUMMARY

• 9 years of experience in Data warehousing and Business Intelligence technologies along with around 3 years of data visualization using BI Tableau.
• Expertise inBI Tableau 7, 8,9,10BusinessObjects 4.0, 4.1,andSAP Business Intelligence 7.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Hands on experience on Tableau Desktop versions 7/8.2/9, Tableau Reader and Tableau Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Worked in all phases of BW/BI full life cycles includinganalysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Expertise in building BI components like Info objects, data sources, Info cube, DSO, Transformations, Data Transfer Process DTP, Multi providers and Master data Info Objects, Transfer Structures, Transfer Rules and Update Rules..
• Widely used BEx for building Queries and workbooks and preparing end user training documents.
• Expertise in front-end Components likeBEx Queries, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Worked on User exits for various variables.
• Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast paced environment.
• Communicate effectively with colleagues and business users.

TECHNICAL SKILLS

BI Tools: Tableau, MicroStrategy, Business Objects, SSRS, Power BI

DBW Tools: Tableau Desktop 7.x, 8.x,9.x,10.x Business Objects 4.0, 4.1 and SAP BI 7

Other Reporting Tools: SAP Business Explorer BEx Analyzer, BEx Query Designer

Environment: Windows 2008, windows 2003, XP.

Database: Oracle 9i/11g, SQL Server 2008, MS Access 2000.

Language: VB 6, VBA, VB.NET, C .NET, HTML, SQL

Defect management tool: HP Quality Center, JIRA

Scripting Languages: javascript, C, C++, HTML, SQL, PL/SQL and XML

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

BI Tableau Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau 9.x, Business Object 5x, Amazon Redshift.

Confidential, Dallas, Texas

BW/BI Tableau Developer/ Data Analyst

Responsibilities:

• Involved in meetings and projects with business users, project managers & developers to automate and upgrade applications that accomplish business operations and goals.
• Responsible for generating, maintaining and automating daily, weekly, monthly and quarterly reports for the Confidential Compliance & Ethics team and FHFA and other Stake holders as required.
• Developed Mortgage Fraud Category, SAR, TIPS, Cases and Resolution Dashboard in Tableau for Anti Mortgage Fraud Team to identify Fraud Patterns.
• Designing and developing, proto typing the various dashboards using tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts, Refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, Context Filters), Ranking, Top-N Analysis, hierarchies).
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.
• Created Complex Tableau reports utilizing the features like Hierarchy, New Calculated Columns, Actions - Drill Down functionality, Graphs. Also Created Parameters to achieve desired functionality.
• Developed Dashboards using quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Developed Tableau data visualizations using Waterfall Chart, Donut Chart, Gantt Charts, Cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.
• Implementing the use of Hyperlinks, Filters for developing Complex dashboards and created Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ).
• Used live and extract data connections for the reports, scheduling the reports and maintaining extract refresh for the reports on the Tableau server
• Hands on building Groups, hierarchies, Sets to create detail level, Summary level reports and Dashboards using KPI's.
• Reviewed custom SQL queries and tuned for better performance in Tableau Desktop.
• Worked on querying data and creating on-demand/adhoc reports using Tableau Desktop and publish the same to Server.
• Worked with various teams across different domains to support their data & analytics needs.
• Involved in direct interaction with Tableau Admin for requesting appropriate permissions for various Groups assigned to Projects where Dashboards and worksheets are saved.
• Created connections, join tables, create & manage Extract and Monitor Queries using Oracle SQL Developer/Teradata SQLAssistant.
• Utilized Tableau server to publish and share the reports with the business users.
• Hands on Tableau dashboard performance tuning based on Tableau Recommendations.
• Sourced data from various data sources like Oracle, SQL Server and Teradata.
• Worked extensively on ETL using SAS. Extracted data from Oracle & Flat files and load data into DB tables.
• Extensive Experience in Base SAS, SAS/MACROS, SAS/SQL, SAS/ACCESS and SAS/ODS etc in Windows & Unix environment.
• Transferred files from Unix to Windows used WinSCP & Humming Bird.
• Extensively worked with the QA Team and the Business users during UAT & Sign-off process. Tracked issues/bugs and resolved it in timely manner to meet SLA.
• Involved in peer review, testing and documenting processes.

Environment: Tableau 10.x/9.x/8.x (Desktop/ Server), Base SAS, SAS Enterprise Guide, Teradata SQL Assistant, Oracle SQL Developer, MS SQL Server, Oracle, WINSCP, Humming Bird, Windows, Unix.

Confidential, CA

SAP BW Tableau Consultant

Responsibilities:

• Created InfoObjects for the reporting areas, which includes building all structures within BI.
• Created users, user groups and maintained user access rights in Tableau.
• Performed reports/dashboards performance optimization
• Involved in User Training documentation of Tableau dashboards.
• Created complex Tableau reports with multiple queries, custom sql, complex functions, merge dimensions
• Created transfer structure, communication structure, transfer rules and update rules.
• Strong knowledge in SAP BW Data model design and Implementation
• Installed Business Content and activated SAP delivered standard InfoCubes and InfoSources.
• Involved in Design, Development and Enhancements of Info Cubes, DSO Objects and Info Sources.
• Designed and developed DSO objects and built Info Set queries.
• Developed process chains to load the data.
• Actively involved in Transports, Troubleshooting and Data Validation.
• Worked with Basis team to resolve the performance related issues such as recreating the indexes on the database tables.
• Involved in deploying role based reports in various environments such as (but not limited to) Portal, BEx Browser.
• Through process chain.

Environment: BW 7.3, ECC 6.0, BEx, MS Excel, MM and SD Tableau 10.1

Confidential, VA

SAP BW/BI Developer

Responsibilities:

• Provided support to business users on how to use the analyzers and interpret the contents of the data
• Enhanced extract structures for data sources pertaining to Sales, Delivery and Billing.
• Enhancements of Info Cubes, DSO, Info Source, Transfer rule and Update rule with necessary update routines
• Created Process Chain to load the data into respective cubes and monitored the scheduled the background jobs.
• Responsible for checking RSMO daily to ensure all jobs were carried out without any failures and fix all failed loads
• Made sure the database has the sufficient space to load data or else report to the database team to add some disk space.
• Involved in escalating high-prioritized tickets regarding extractors, performances issues and also load failures
• Good at troubleshooting and debugging skill set. Ability to analyze and solve complex technical issues such as load failures and systems dumps.
• Understanding of integration to POS DM, MM, FI/CO and Activation & Installation of Business Content Objects for FI, MM,
• IM and Business content Enhancement.
• Resolved Remedy tickets raised by Business Users for issues regarding Reports and BI Object Enhancements
• Created aggregates, Compressed Info Cubes, updating DB statistics regularly and rebuilding missing indexes for increasing the Query Response.
• Generated Reports using BEX with Variables, calculated, restricted key figures, formulas, conditions and
• Exceptions, filters, drilldown methods and RRI interfaces.
• Developed Web Reports & Dashboards using Web Application Developer.

Environment: Netweaver 04s (BI 7.0), MS SQL, BEx Analyzer/ Browser/, SD, MM, FICO modules.

Confidential, MI

SAP BI Consultant

Responsibilities:

• Activation & Installation of Business Content Objects for FI, MM, IM and Business content Enhancement.
• Worked on the standard extractors for FI and CO. Enhanced business content extractors using LBWE & CMOD transactions.
• Deleting & installing data from setup tables for specific application components.
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to BW and to report using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user exits.
• Activated profit center accounting, accounts payable, accounts receivable cubes as a part of crossfunctional SAP BW
• Enhanced the standard extractors, by adding fields and User Exits to handle customer specific business requirements.
• Worked with process-chains to automate the Data Loads, Rollups into Aggregates.
• Worked extensively on Extraction from multiple Source Systems - SAP R/3, Non SAP Systems (DB
• Connect, Flat Files). • Created Info package Routine, used the selection option in Info package. Scheduling the jobs to run using Scheduler and handling Process Chains.
• Gathered Security Requirements, Assisted in Security model design with Security Team. Implemented
• BW Authorization and Security for the BW System.
• Worked on InfoSet queries for reporting on master data and DSO objects.
• Experience in troubleshooting DataLoads.
• Created a Generic extractor with data capability from a database view.
• Analyzed business reporting requirements against standard Business Content and installed the necessary object.
• Designed Queries, Reports, Workbooks and assigning them to Roles. Used calculated key figures and restricted key figures Conditions, Exceptions reporting and Customer Exits for calculating the YTD and JTD Values.
• Created an Aggregate-schema to improve the Query Performance drastically.
• Worked extensively on Query Monitor and tracing the SQL Query.
• Provided Process documentation, which includes data flow and how to guides to end users for post production support.

Environment: SAP BI 7.0, SAP 4.7, ABAP/4 and Windows XP